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 · 43,996 rows across 16 tables
| Table | Rows | Purpose |
|---|---|---|
| cities | 1,268 | City roster with coords & hero text |
| topics | 19 | Topic taxonomy (parking, transport, …) |
| institutions | 23,344 | Offices, operators, POIs (churches, hospitals, …) |
| fees | 74 | Prices — tickets, parking, permits, fines |
| rules | 5,069 | Regulation snippets / notes |
| required_docs | 45 | Documents needed for procedures |
| procedures | 151 | Step-by-step how-tos |
| transport_routes | 262 | Bus / tram / metro / train lines |
| parking_zones | 30 | Paid parking zones by color/code |
| press_releases | 208 | Recent announcements from institutions |
| events | 7,621 | Upcoming public events & festivals |
| sources | 4,027 | URLs the pipeline crawls |
| crawl_runs | 162 | Ingestion run log |
| audit_runs | 7 | Daily CEO audit reports |
| audit_findings | 45 | Per-run quality findings |
| gaps | 1,664 | 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 |