Marius ComperOpen data
RO
Crosswalk + financial dataRelease 2026-09-072016–202550 uses

Better open data starts with a crosswalk that holds.

Open Forexebug now has the layer that makes the rest reusable: a canonical administrative identity with SIRUTA, CUI, QID, territorial codes, and contacts, connected to a queryable financial register. Identities come from the Puntea administrativă. Monetary values in this release are a reproducible modelled demonstrator; official Forexebug observations are the next ingestion target.

Find a UATSee the 50 uses
Administrative identities
3,187
UATs and sectors with SIRUTA, official naming, and reconciliation links.
Entities with a population denominator
3,187
All 3,187 UATs (including the 6 Bucharest sectors) have 2021 Census population for per-resident indicators.
Financial series in this release
31,870
Ten years of rows (3,187 entities × 10), explicitly marked as a modelled demonstrator; official rows imported: 0.
Documented uses
50
Finding, checking, comparing, analysing, reusing, and reproducing the data.
Integrity and provenance

Trust starts with visible limits.

The report separates the identity layer from the financial series. You can cite the administrative key today and replace the financial model with official observations later without rebuilding every join.

Administrative crosswalk—identity records
SIRUTA present—
CUI present / valid—
Wikidata QID present—
Financial series—

Monetary values and rankings help test the interface, formulas, and workflow. They must not be cited as official budget execution.

Read the method →
Safe to cite now: identifiers, names, administrative tier, county, region, population, contacts, and links. Replace before making a financial claim: modelled rows, aggregates, quadrants, and rankings.
Quality report JSONCrosswalk summaryManifest and hashes
Identity explorer

Find the entity before you join the data.

Search by name, county, CUI, SIRUTA, QID, or postal code. Diacritics are folded for search, and the selected UAT gets a stable direct link.

Modelled financial series

A chart for testing questions, not manufacturing certainty.

These aggregates are calculated from modelled rows for 2016–2025. The chart shows how the explorer works and where the official series will enter.

National aggregates (bn RON)
Total revenue
Investment
Personnel
Funds

Units are billions of RON; row status is modelled demonstrator.

Exploratory classification

Four quadrants to inspect autonomy and investment together.

The thresholds are an exploratory convention applied to modelled values. Filter by county and use the result as a verification queue.

modelled demonstrator

1. Economic engines

—
Autonomy ≥ 28% · investment ≥ 900 RON/resident

High autonomy and investment in the model.

Examples: —

2. Grant-supported

—
Autonomy < 28% · investment ≥ 900 RON/resident

High investment with lower own-source autonomy in the model.

Examples: —

3. Passive rentiers

—
Autonomy ≥ 28% · investment < 900 RON/resident

Higher own-source autonomy with lower modelled investment.

Examples: —

4. Survival bureaucracies

—
Autonomy < 28% · investment < 900 RON/resident

Both values are low in the model and need source-level checking.

Examples: —

Working lists

Rankings that start a check.

The order comes from the demonstrator and stays labelled that way. A ranking becomes a finding only after official rows replace the model.

UATCountyTierPopulationAutonomyPersonnel/res.Investment/res.Coverage
Loading…

The values in this table are modelled. Click a row to open its UAT profile.

Territorial context

All 42 counties on one grid.

The table keeps the model's shared definitions visible and shows which aggregates should be rebuilt after official ingestion.

CountyCodeUATsPopulationAutonomyPersonnelInvestmentInvestment/res.Below 100% coverage
Loading…
Utility catalogue

50 things you can do here.

Each entry is a concrete action for a reader, journalist, researcher, or developer. Filter the catalogue and jump straight to the instrument.

Loading…
Data laboratory

Download, join, and run.

Each artefact has a clear role: the crosswalk for identity, Parquet for the modelled financial series, the schema for definitions, and the manifest for release verification.

administrative-crosswalk.json3,187 identities · SIRUTA, CUI, QID, contactsadministrative-crosswalk.csvShared key for spreadsheets and databasesregistru-bugete-locale-2016-2025.parquet31,870 rows · modelled demonstrator · Zstandarduats-index.jsonCompact search and resolver indexschema.jsonColumn dictionary, types, and limitsdata-quality.jsonCoverage, gaps, sources, and checkscrosswalk-summary.jsonIdentity summary for quick citationmanifest.jsonFile sizes and SHA-256 hashes
DuckDB

SQL recipes ready to try

Loading…
Batch resolver

Turn a list of names or codes into canonical keys.

Paste one identifier per line to begin.

Accepts SIRUTA, CUI, QID, postal code, or name.
Small, explicit API

Automate the basic checks.

The public contract is described in OpenAPI. Resolver responses use the same canonical identity as the interface.

GET /api/resolve?siruta=179150Resolve by SIRUTAGET /api/checksum?cui=4204038Check a CUI digitGET /api/healthCheck the published releaseGET /api/quality.jsonRead the quality reportGET /api/use-cases.jsonFetch the 50-use catalogueOpenAPI 3.1Read the complete API contract
Method and sources

The crosswalk is the identity layer. Forexebug is the financial source still to come.

This release uses the local extract of the Puntea administrativă for SIRUTA, names, CUI, QID, territorial codes, population, and contacts. Entities without CUI remain identity profiles, while for the six Bucharest sectors we integrated the official 2021 Census reference population from INS records, preserving other gaps instead of filling them with assumptions.

The financial series is deterministic demonstration data: seed 42, formulas documented in the project dossier, 2016–2025, 31,870 rows. It is not an official extraction. The Ministry of Finance portal remains the target source for the next release, and the quality report states that zero official rows were imported here.

Per-resident indicators use the 2021 Census population available in the crosswalk. Quadrants, county aggregates, and rankings are derived from the model and should be recalculated alongside official ingestion.