Japan Osaka Open Data Catalog (CKAN API)

Search the Osaka Prefecture (大阪府) Open Data Catalog by keyword, tag or category — then actually download a dataset's CSV rows as clean, structured JSON (Shift_JIS handled automatically).

This Actor is a thin, polite client for the CKAN API v3 (data.bodik.jp/api/3/action/) that serves the 大阪府オープンデータカタログサイト (Osaka Prefecture Open Data Catalog) on the BODIK ODCS platform. It is not a scraper — it calls the documented CKAN JSON API, needs no API key, and returns each result as a flat record with a legal envelope (source / sourceUrl / license / retrievedAt) on every item.

data.bodik.jp is a shared, multi-tenant catalogue used by many Japanese municipalities, so every request this Actor makes is hard-scoped to the Osaka Prefecture publisher (CKAN organization 270008) — it only ever returns 大阪府 datasets, never another tenant's data.

The catalogue as a whole is a directory, not a product. The value here is get_records: point it at a dataset and it fetches the actual CSV distribution and returns its rows — so you get the data, not just a link to it.

Unofficial tool. Independently built and maintained. Not affiliated with, endorsed by, or connected to the Osaka Prefectural Government or BODIK. Catalogue content is provided under CC BY 4.0 (大阪府オープンデータ利用規約), which permits commercial reuse with attribution; the required 出典 statement 「出典：大阪府オープンデータカタログサイト」 is embedded in the license of every record.

---

Quick start — verified input

Copy, paste, run. This exact input is verified on the platform (SUCCEEDED, items > 0):

{
  "mode": "search_datasets",
  "query": "イベント"
}

Running with no input at all also works (same defaults). To download a dataset's rows, take a datasetId from the search output and run {"mode": "get_records", "datasetId": "270008_event"}.

No API key required

The Osaka Open Data CKAN API is public and unauthenticated. Just pick a mode and run. The Actor keeps a single connection, spaces requests ≥ 1.2 s apart, backs off exponentially on HTTP 429/5xx, and fails visibly on a persistent block — it never attempts rate-limit evasion. (The BODIK host is rate-limit sensitive, so this politeness matters.)

License & source-display obligation (出典表示義務)

The 大阪府オープンデータ利用規約 (原文, https://odcs.bodik.jp/270008/tos/) states that content is licensed under 「クリエイティブ・コモンズ・ライセンス……の表示4.0国際」 — i.e. CC BY 4.0 International. CC BY 4.0 permits copying, adaptation and commercial use with attribution.

• The credit 「出典：大阪府オープンデータカタログサイト」 is embedded verbatim in the license field of every record. If you display or republish the data, keep that credit visible.
• Per-dataset licenses are your responsibility. Each dataset also reports its own license machine-readably in the datasetLicense field (typically cc-by-40-intl). Datasets carrying an individual license/terms are the user's responsibility to confirm. The license and content of any individual dataset — including whether it contains personal data — must be checked by you before use.

Two modes

1. search_datasets — find datasets (CKAN package_search)

Give a query (free text) and/or a tags or group filter, and get back matching 大阪府 datasets: datasetId, title, publisher, update date, the dataset's own license, a catalogue deep link, and the full resources[] list (each resource's CSV/XLSX URL, format and size). At least one filter is required (a targeted search, not a full-catalogue dump); every search is additionally scoped to the Osaka Prefecture publisher.

2. get_records — download a dataset's CSV rows

Give a datasetId (from a search_datasets run) and the Actor resolves that dataset's CSV/TSV resources, downloads them, and returns one record per CSV row — the columns keyed by header, plus provenance (datasetId, resourceName, resourceUrl, rowIndex). Or pass a resourceUrl directly to fetch one specific distribution. Japanese municipal CSVs are frequently Shift_JIS; encoding: "auto" (default) sniffs UTF-8 (incl. BOM) then falls back to Shift_JIS, or force utf-8 / shift_jis.

Sample output

search_datasets (dataset item):

{
  "datasetId": "270008_opendata",
  "title": "オープンデータ一覧（大阪府）",
  "organization": "大阪府",
  "organizationId": "270008",
  "datasetLicense": "cc-by-40-intl",
  "datasetUrl": "https://data.bodik.jp/dataset/270008_opendata",
  "resources": [
    { "name": "オープンデータ一覧（csv）", "format": "CSV", "url": "https://data.bodik.jp/dataset/.../270008_open_data_list.csv" }
  ],
  "tags": ["一覧", "大阪府", "自治体標準オープンデータセット"],
  "source": "大阪府オープンデータカタログサイト / Osaka Prefecture Open Data Catalog (BODIK CKAN)",
  "sourceUrl": "https://odcs.bodik.jp/270008/",
  "license": "出典：大阪府オープンデータカタログサイト（https://odcs.bodik.jp/270008/）。… CC BY 4.0 … Unofficial …",
  "retrievedAt": "2026-08-26T12:00:00.000Z"
}

get_records (dataset item — one CSV row):

{
  "datasetId": "270008_event",
  "datasetTitle": "イベント一覧",
  "resourceName": "イベント一覧",
  "resourceUrl": "https://data.bodik.jp/dataset/.../270008_event.csv",
  "rowIndex": 1,
  "fields": {
    "地方公共団体名": "大阪府", "イベント名": "…", "開始日": "…", "場所名称": "…"
  },
  "source": "大阪府オープンデータカタログサイト / Osaka Prefecture Open Data Catalog (BODIK CKAN)",
  "sourceUrl": "https://odcs.bodik.jp/270008/",
  "license": "出典：大阪府オープンデータカタログサイト … CC BY 4.0 … Unofficial …",
  "retrievedAt": "2026-08-26T12:00:00.000Z"
}

Input reference

Field	Mode	Description
mode	both	search_datasets (default) or get_records. Case-insensitive; if you pass only a datasetId/resourceUrl the Actor switches to get_records for you.
query	search	Free-text query (CKAN q), Japanese works best, e.g. イベント, 人口. Always scoped to the 大阪府 publisher.
tags	search	Restrict to a CKAN tag, e.g. 自治体標準オープンデータセット.
group	search	Category/group name (see the groups field of search results).
datasetId	get_records	Dataset name/slug to read, e.g. 270008_event (from the search output).
resourceUrl	get_records	Fetch a specific CSV resource URL directly.
encoding	get_records	auto (default), utf-8, or shift_jis (sjis, cp932 … accepted).
maxItems	both	Max records to output, 1–100000 (default 1000).
maxApiRequests	both	Hard per-run upstream request cap, 1–25 (default 10).
proxyConfiguration	both	Optional Apify proxy; default is a direct connection.

At least one of query / tags / group is required in search_datasets mode; datasetId or resourceUrl is required in get_records mode. Values are validated before the first request; an invalid value fails the run immediately with a message that lists the valid values.

Common input mistakes

Mistake	Correct
{"mode": "search_datasets"} with no filter	add "query": "イベント" (or tags / group)
{"mode": "search_datasets", "datasetId": "270008_event"}	"mode": "get_records" — datasetId is a get_records field
{"mode": "get_records", "query": "イベント"}	get_records needs datasetId or resourceUrl, not a query
"datasetId": "https://data.pref.osaka.lg.jp/dataset/270008_event"	just the slug: "270008_event"
"encoding": "euc-jp"	"auto", "utf-8" or "shift_jis"
"maxItems": "all"	a number, e.g. 1000

Empty results?

A run that finds nothing completes with 0 items and a warning in the log (not a failure). Typical causes: an English query (the catalogue is Japanese — try イベント instead of events), a tags/group value that is not an exact CKAN name, or a get_records dataset whose resources are all XLSX/PDF (only CSV/TSV are read — pass a resourceUrl to a CSV). Broaden the query or drop a filter and retry.

Notes & limits

• get_records reads CSV/TSV resources. Non-CSV distributions (XLSX, PDF, etc.) are skipped — pass a resourceUrl to a CSV, or read the XLSX yourself.
• Resource files are hosted on data.bodik.jp (and occasionally on a publisher's own server). A resource that responds with a redirect surfaces as an error (the Actor does not follow redirects to keep the request budget honest) — re-run with the final URL.
• search_datasets pages at up to 1000 datasets per request under maxItems.

Disclaimer

1. Unofficial — not affiliated with, endorsed by, or connected to the Osaka Prefectural Government or the BODIK open-data platform.
2. Public data, your responsibility — data is provided under CC BY 4.0 (大阪府オープンデータ利用規約). Keep the 出典 credit visible. Each dataset's own license (datasetLicense) and content — including any personal data it may contain — are the user's responsibility to verify before use.
3. Polite by design — one connection, ≥ 1.2 s spacing, exponential backoff, a hard request budget, and a visible failure on a persistent block. No rate-limit evasion.
4. No warranty — provided "as is"; verify anything important against the source catalogue.

Search terms

osaka open data api, japan municipal data osaka, osaka prefecture datasets, CKAN japan, BODIK open data, japan open data csv, 大阪府 オープンデータ, japan city data api, osaka government open data, japanese government open data