Status — what's new
Live feed of the most recent 120 records the pipeline pushed to the database. Updated every hour by the cron-triggered Cloudflare Worker.
System status
🗃️ D1
D1 · rules-city-db
⚡ KV
KV · rc_page_cache
📦 R2
R2 · rules-city-docs
D1 tables · 499,856 rows across 16 tables
| Table | Rows | Purpose |
|---|---|---|
| cities | 28,698 | City roster with coords & hero text |
| topics | 32 | Topic taxonomy (parking, transport, …) |
| institutions | 342,008 | Offices, operators, POIs (churches, hospitals, …) |
| fees | 417 | Prices — tickets, parking, permits, fines |
| rules | 6,312 | Regulation snippets / notes |
| required_docs | 194 | Documents needed for procedures |
| procedures | 806 | Step-by-step how-tos |
| transport_routes | 4,114 | Bus / tram / metro / train lines |
| parking_zones | 278 | Paid parking zones by color/code |
| press_releases | 3,849 | Recent announcements from institutions |
| events | 73,340 | Upcoming public events & festivals |
| sources | 32,495 | URLs the pipeline crawls |
| crawl_runs | 3,950 | Ingestion run log |
| audit_runs | 54 | Daily CEO audit reports |
| audit_findings | 379 | Per-run quality findings |
| gaps | 2,930 | Missing (city × topic) source URLs |
Cloudflare resources
| Resource | ID / name | Region |
|---|---|---|
| Account | f8dfb45bee50d2c1dca65f0e5e0819db | — |
| D1 database | e65cf36e-1c3d-4887-8699-e993de45cc38 (rules-city-db) | EEUR · Frankfurt |
| KV namespace | ece5bf98211642a8a03dc58a09fecff4 (rc_page_cache) | global |
| R2 bucket | rules-city-docs | ENAM |
| Pages project | rules-city · rules.city + 3 subdomains | global edge |
| Workers | pipeline, audit, poi-harvest | global edge |