Code-Smart Manifesto: Auditing Japan’s Public Data and Systems from an Engineering Lens

どうも〜おかむーです! Hi — today I want to take a tech-native look at how Japan’s national and local governments publish and operate public data and systems. エンジニア的に言うと、政策をコードで語るってこういうことなんですよ〜
- Governments publish more data, but formats and APIs are uneven across ministries and local governments
- PDF-first publishing and fragmented APIs limit machine use; standardization efforts exist but need engineering discipline
- Practical fixes: API-first releases, CSV/JSON + OpenAPI, CI for data quality, and local gov system standardization to cut long-term costs
結論
Japan has the right initiatives — e-Gov APIs, Digital Agency case studies, and Soumu’s open data strategy — but the implementation is still half-API, half-PDF. 要するに、政策目標と実績の間に“機械可読性ギャップ”があって、データ利活用が抑制されているということです。技術的にはAPI-first、フォーマット標準化、データ品質パイプラインが最短ルートです!
Report
What I looked at
- e-Gov API portal / API catalog (government API offerings and documentation)
- Digital Agency case studies and local open-data efforts
- Soumu (Ministry of Internal Affairs) open data strategy and local systems standardization materials
These sources show intent: common APIs and standard data models are being promoted. Soumu even lists a three-pillar push (experimental projects, industry–academia–government collaboration, and opening ministry-held data). But intent != interoperability in the wild.
The core technical problems
- PDF-first publishing: many reports still land as PDFs. That’s human-readable but terrible for automation. "This data exists" != "this data is usable".
- Fragmented APIs: some ministries provide tidy JSON/CSV endpoints, others expose narrow APIs or none at all. API specs often missing OpenAPI / machine-readable contracts.
- Inconsistent vocabularies and schemas: without common data models, joining datasets across domains (e.g., population, taxation, infrastructure) requires custom ETL per dataset.
- Local systems diversity: local government back-office systems vary wildly; Digital Agency’s push for standardization and cloud migration addresses this, but migration timelines and cost/ops tradeoffs remain.
Evidence & numbers (what the docs say)
- Soumu’s open data strategy highlights standard API and data model goals — but implementation is phased and depends on local readiness.
- Digital Agency publishes case studies showing private-sector reuses and tools, which proves demand; yet many high-value datasets are still non-API.
Developer-friendly critique
This is an engineering problem with product and process roots:
- Release format: favor CSV/JSON/JSON-LD over PDF. Use CSV for tabular, GeoJSON for geodata, JSON-LD for linked data.
- API-first: every dataset should have a RESTful endpoint with an OpenAPI spec and pagination, filtering, and stable IDs.
- CI & testing: data pipelines need automated validation (schema, value ranges, referential integrity). Treat datasets like code.
- Versioning & provenance: datasets must include version stamps, schema versions, and provenance metadata (DCAT/VoID).
Practical code examples
Curl to discover an e-Gov API (conceptual):
curl -s "https://api-catalog.e-gov.go.jp/info/ja/apicatalog/list" | jq '.items[] | {title, url}'
Python snippet to fetch a CSV then validate with pandas (example):
import requests, pandas as pd
r = requests.get('https://example.gov/dataset.csv')
with open('/tmp/dataset.csv','wb') as f: f.write(r.content)
df = pd.read_csv('/tmp/dataset.csv')
basic checks
assert df['id'].is_unique
assert df['date'].notnull().all()
For PDFs, use Tabula or Camelot to extract, but emphasize: these are stopgaps, not a substitute for native CSV/JSON endpoints.
Policy gap analysis
Governments often set numeric targets (open data counts, API endpoints, cloud migration milestones). The gap is operational: without clear SLAs for data freshness, schema stability, and programmatic access, those numbers overstate real reusability. Example: a published dataset updated annually as a PDF may technically meet an "open data" count but offer negligible value to apps or researchers.
Concrete recommendations
- Mandate OpenAPI + machine-readable metadata (DCAT) for all central and local datasets above a value threshold
- Stop PDF-first for tabular data: require CSV/JSON exports alongside any PDF reports
- Provide a hosted reference implementation (gov-cloud sandbox) and SDKs (JS/Python) to lower integration friction
- Enforce data CI: unit tests for schema, range checks, and sample consumers as smoke tests
- Push common vocabularies and sample ETL recipes so municipalities can join national datasets easily
まとめ
Japan’s gov is building the blocks (APIs, strategies, standardization), but needs engineering rigor: publish data as machine-first formats, provide clear API contracts, and treat datasets as software with CI, versioning, and SDKs. これをやれば、政策の実績検証も民間イノベーションも一気に進みます!
おかむーから一言
Tech + policyは掛け算なんですよ。コードで語るマニフェスト、やるなら徹底的に。僕はフルスタックの視点で、次の一歩を一緒に作りたいと思ってます!
Sources
- https://ja.wikipedia.org/wiki/%E5%85%AC%E5%85%B1
- https://www.intec.co.jp/column/smartcity-08.html
- https://kotobank.jp/word/%E5%85%AC%E5%85%B1-494676
- https://www.digital.go.jp/resources/data_case_study_private
- https://www.takeda.tv/saga/blog/post-230907/
- https://www.e-gov.go.jp/digital-government/api
- https://www.soumu.go.jp/menu_seisaku/ictseisaku/ictriyou/opendata/opendata03.html
- https://japan-opendata.github.io/awesome-japan-opendata/
- https://www.jichi.ac.jp/
- https://api-catalog.e-gov.go.jp/info/ja/apicatalog/list
- https://www.keiba.go.jp/
- https://www.digital.go.jp/policies/local_governments
- https://www.keiba.go.jp/KeibaWeb/TodayRaceInfo/TodayRaceInfoTop
- https://www.soumu.go.jp/menu_seisaku/chiho/jichitaijoho_system/index.html
- https://www.keiba.go.jp/live/
Share
Related Reports

Code-driven Manifesto: Auditing Local Gov Data and Systems (Kagawa case study)
Local gov systems run but hide data behind UIs; expose CSV/JSON, APIs, and common schemas to unlock value.

Code-driven Check: Japan’s Open Data and the Machine-Readable Gap
Digital Japan has dashboards and rules, but PDFs and messy formats still block automated policy verification; mandate CSV/JSON, APIs, and dataset linting.

Code Speaks: Testing Japan's Gov Data and Dashboards
Japan has great dashboards but inconsistent machine-readability. This report inspects e-Stat, Japan Dashboard, Kantei PDFs, and proposes API-first fixes and practical code examples.