rules.city

CEO audit

Automated daily audit at 05:00 UTC. Scores coverage, freshness, pipeline health, and data quality, then drops actionable findings you can work through.

Headline metrics

Coverage
2%
24014 of 1118247 city × topic pairs have data
Cities with data
10353 / 28673
18320 cities still empty
Freshness
0%
pairs crawled in the last 30 days
Pipeline success (7d)
46%
265 runs · 0 dead URLs

Records in the database

EntityCount
Institutions578326
Fees439
Required documents205
Rules & notes762
Transport routes4290
Parking zones278
Procedures816
Press releases3850
Sources seeded33632

Findings (10 this run)

Critical · pipeline

high-error-rate

Pipeline success rate over the last 7 days is 46%. Investigate.

Critical · routing

alias-shadows-city

1 alias(es) match a live city slug — those cities 301 away and cannot be reached. Either the city is a duplicate that should be merged, or the alias must be deleted.

Detail
{"aliases":[{"alias_slug":"mantova","canonical_slug":"mantua"}]}
Needs attention · coverage

cities-empty

18320 of 28673 cities have zero data. Seed sources for them in the `sources` table, or let the CEO pick the next batch.

Detail
{"cities":[{"slug":"el-ayoun","name":"El Ayoun"},{"slug":"umm-salal","name":"Umm Salal"},{"slug":"wafra","name":"Wafra"},{"slug":"pedro-juan-caballero","name":"Pedro Juan Caballero"},{"slug":"majuro","name":"Majuro"},{"slug":"ngerulmud","name":"Ngerulmud"},{"slug":"callao","name":"Callao"},{"slug":"las-palmas-de-gran-canaria","name":"Las Palmas de Gran Canaria"},{"slug":"city-of-melbourne","name":"City of Melbourne"},{"slug":"juanjui","name":"Juanjuí"},{"slug":"new-south-wales","name":"New South Wales"},{"slug":"nicosia-municipality","name":"Nicosia Municipality"},{"slug":"barlad","name":"Bârlad"},{"slug":"miraflores","name":"Miraflores"},{"slug":"tarapoto","name":"Tarapoto"},{"slug":"leon","name":"León"},{"slug":"limassol-municipality","name":"Limassol Municipality"},{"slug":"los-mochis","name":"Los Mochis"},{"slug":"nampo","name":"Nampo"},{"slug":"parnu-city","name":"Pärnu City"}]}
Needs attention · data-quality

implausible-fees

1 fees exceed 10000 RON — likely bad extraction. Review and pin or delete.

Detail
{"fees":[{"city_slug":"budapest","topic_slug":"fire","label_en":"Starting monthly gross salary for firefighters","amount_ron":474700,"source_url":"https://fovaros.katasztrofavedelem.hu/"}]}
Needs attention · data-quality

institutions-bad-website

840 institutions have a non-URL website. Run normalizer.

Needs attention · freshness

stale-data

Only 0% of topic pages are fresher than 30 days.

Informational · coverage

city-topic-pairs-empty

1094364 city/topic pairs are empty. Covered: 24014/1118247 (2%).

Informational · source-health

never-crawled

200 sources have never been successfully crawled.

Detail
{"examples":[{"city_slug":"aalen","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Aalen"},{"city_slug":"aalsmeer","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Aalsmeer"},{"city_slug":"aalten","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Aalten"},{"city_slug":"aanekoski","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Äänekoski"},{"city_slug":"aarau","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Aarau"},{"city_slug":"aarschot","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Aarschot"},{"city_slug":"aartselaar","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Aartselaar"},{"city_slug":"abadan-tm","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Abadan"},{"city_slug":"abadiania","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Abadiânia"},{"city_slug":"abadla","topic_slug":"city-hall","url":"https://en.wikipedia.org/wiki/Abadla"}]}
Informational · data-quality

procedures-no-steps

267 procedures have no step list. Tune the extractor prompt or re-classify.

Informational · routing

alias-coverage

Alias sweep has checked 7747/7747 eligible cities (100%); 16601 aliases live.

Detail
{"eligible":7747,"checked":7747,"aliases":16601}

Run info

Report #129 · generated 18 Aug 2026 · finished at 18 Aug 2026 · duration 12545ms · 2 critical

Trigger manually: curl https://rules-city-audit.ionasrobert.workers.dev/run