マチカルテ編集部は関連するテーマ別サイトも公開しています。あわせてご覧ください。
Machikarte publishes approximately 128 million speech rows from 1,794 Japanese basic municipalities. We continuously verify "where the data comes from", "when it was retrieved", and "whether the content is authentic", and disclose every correction as a full historical record.
Each municipality's source URL and minutes system type (sophia / ssp / voices / dbsearch / kensakusystem / universal / family / voicetechno — 8 system families) is recorded in municipality_registry.jsonand publicly disclosed.
Every source PDF / HTML is stored in Google Drive and Google Cloud Storage with a SHA-256 hash. Each speech row can be traced back to its original file via source_doc_id.
council_id is generated as a SHA-256 derivative to prevent collisions. To avoid mistaking same-named municipalities (e.g. Shimizu-cho in Hokkaido vs Shizuoka), source URLs are managed independently per municipality and a dictionary of 18 known traps is continuously maintained.
Immediately before each BigQuery write, the data is scored against whether it contains the canonical municipality name and prefecture name. Writes are aborted when the threshold is not met.
| Pattern | Score |
|---|---|
| Both municipality name + prefecture name | STRONG (1.0) |
| Prefecture name only | MEDIUM (0.5) |
| Municipality name only | WEAK (0.5) |
| Neither | NONE (0.0) |
Threshold: sample size × 0.3. Below this the write is aborted. Implementation: verify_council_name_match() inscripts/framework/council_name_verify.py.
At 04:00 JST on the first day of every month all 1,794 municipalities are mechanically audited (scripts/audit_bq_council_name_match.py). Any flagged inconsistency is investigated and corrected within 24 hours.
continuous_quality_views.sql)dedupe_speeches.py)Correction logs reflect self-reported errors and corrective effort by Machikarte; they do not indicate the quality or merit of any local council.
| Date | Tenant | Issue | Status |
|---|---|---|---|
| 2026-06-03 | universal-shimizu-016365 | URL 設定誤りで別都道府県の同名異自治体データを取得 (48,818 行汚染) | URL を北海道清水町の正規 source に訂正、誤データを DELETE、正規 URL で再 scrape 済 |
| 2026-06-03 | universal-takahama-184811 | URL 設定誤りで別都道府県の同名異自治体データを取得 (608 行汚染) | URL を福井高浜町の正規 source に訂正、誤データを DELETE、正規 URL で再 scrape 済 |
Total 49,426 rows (0.039% of all data) corrected and removed. The full history is published daily via the isvd_machikarte.corrections table.
source_url points directly to its public sourcesource_doc_id resolves to its archived original PDF (via the source_documents table)correlate-workspace.isvd_machikarte.speeches is read-accessible to approved AI agents and researchers| Indicator | Value |
|---|---|
| Covered municipalities | 1,769 / 1,794 (98.6%) |
| Speech rows | ~128 million |
| Coverage period | 2010–2026 |
| Source systems | 8 families |
| Audit-passing (high-confidence) | 179 municipalities |
| Corrections (cumulative) | 2 cases / 49,426 rows (0.039%) |
| Monthly automated audit | Active since 2026-06-02 |
known_same_name_traps.json) continuously updated (currently 18 entries)The automated audit's scoring method has known room for improvement, and certain municipalities are difficult to evaluate purely mechanically due to the nature of their minutes. These are addressed through manual spot checks and algorithm refinement. Improvement status is updated continuously on this page.
Found an error? Please contact us via the corrections form. We respond within 24 hours.
Last updated: 2026-06-02