Data dictionary · v1.7
Global data dictionary
Unified catalogue of all 76 structured fields and columns documented in national resource schemas. Features interactive search, data type filtering, entity join keys, and an automated SQL CREATE TABLE generator.
76 fields
| Column / Field | Source resource | Type | Description & analytical role |
|---|---|---|---|
judet join key |
Statistical bulletin of the trade register — ONRC ↗ | text | County name or municipality of Bucharest |
forma_juridica |
Statistical bulletin of the trade register — ONRC ↗ | text | Legal entity type (SRL, SA, sole proprietorship) |
cod_caen |
Statistical bulletin of the trade register — ONRC ↗ | text | NACE Rev. 2 sector or division code |
inmatriculari |
Statistical bulletin of the trade register — ONRC ↗ | integer | Count of newly incorporated entities |
radieri |
Statistical bulletin of the trade register — ONRC ↗ | integer | Count of dissolved / struck off entities |
suspendari |
Statistical bulletin of the trade register — ONRC ↗ | integer | Count of temporarily suspended entities |
cui join key |
Company fiscal registry — ANAF API ↗ | integer | Unique Tax ID (without RO prefix) |
data |
Company fiscal registry — ANAF API ↗ | date (YYYY-MM-DD) | Query reference date |
denumire |
Company fiscal registry — ANAF API ↗ | text | Registered corporate legal name |
adresa |
Company fiscal registry — ANAF API ↗ | text | Complete registered office address |
scpTVA |
Company fiscal registry — ANAF API ↗ | boolean | Whether entity is registered for VAT |
statusInactivi |
Company fiscal registry — ANAF API ↗ | boolean | Fiscal inactivity flag |
splitTVA |
Company fiscal registry — ANAF API ↗ | boolean | Split VAT payment mechanism registration |
caNoticeId |
National public procurement — SICAP / SEAP ↗ | integer | Unique award notice identifier |
noticeNo |
National public procurement — SICAP / SEAP ↗ | text | Public notice reference string |
contractingAuthorityName |
National public procurement — SICAP / SEAP ↗ | text | Contracting public authority name |
contractingAuthorityCui |
National public procurement — SICAP / SEAP ↗ | integer/text | Contracting authority fiscal ID |
winnerName |
National public procurement — SICAP / SEAP ↗ | text | Winning contractor business name |
winnerCui |
National public procurement — SICAP / SEAP ↗ | integer/text | Winning contractor fiscal ID |
contractValueRon |
National public procurement — SICAP / SEAP ↗ | decimal | Awarded contract value in RON excl. VAT |
cpvCode |
National public procurement — SICAP / SEAP ↗ | text | Common Procurement Vocabulary (CPV) code |
county_code |
Voter turnout and election results — SIMPV ↗ | text | Two-letter county code |
uat |
Voter turnout and election results — SIMPV ↗ | text | Local administrative unit name |
precinct_nr |
Voter turnout and election results — SIMPV ↗ | integer | Precinct / polling station number |
total_enrolled |
Voter turnout and election results — SIMPV ↗ | integer | Enrolled voters on permanent roll |
votes_permanent |
Voter turnout and election results — SIMPV ↗ | integer | Votes cast from permanent roll |
votes_supplementary |
Voter turnout and election results — SIMPV ↗ | integer | Votes cast on supplementary roll |
votes_mobile |
Voter turnout and election results — SIMPV ↗ | integer | Votes cast via mobile ballot box |
cod_siruta |
SIRUTA 2024 — locality identifiers ↗ | integer | Unique 5 or 6 digit locality code |
cod_judet |
SIRUTA 2024 — locality identifiers ↗ | integer | County numeric identifier (1–42) |
denumire_uat |
SIRUTA 2024 — locality identifiers ↗ | text | Official municipality or village name |
tip_unitate |
SIRUTA 2024 — locality identifiers ↗ | integer | Administrative tier (1=capital, 4=commune, 9=village) |
cod_sup |
SIRUTA 2024 — locality identifiers ↗ | integer | Parent commune or city SIRUTA identifier |
cod_candidat |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | text | Anonymised candidate identifier |
unitate_invatamant |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | text | Full school institution name |
judet join key |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | text | Examination centre county |
profil |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | text | Academic curriculum track |
nota_ro |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | decimal | Grade in Romanian language exam |
nota_proba_obligatorie |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | decimal | Grade in Mathematics or History |
nota_proba_alegere |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | decimal | Grade in elective specialised exam |
medie_finala |
National examination results — Baccalaureate & 8th Grade Assessment ↗ | decimal | Overall arithmetic final grade |
cod_statie |
National Air Quality Monitoring Network — RNMCA ↗ | text | Official station monitoring code |
tip_statie |
National Air Quality Monitoring Network — RNMCA ↗ | text | Station type: Urban background, Traffic, Industrial |
poluant |
National Air Quality Monitoring Network — RNMCA ↗ | text | Monitored pollutant indicator |
valoare |
National Air Quality Monitoring Network — RNMCA ↗ | decimal | Measured concentration over averaging interval |
um |
National Air Quality Monitoring Network — RNMCA ↗ | text | Measurement unit (e.g. µg/m³ or mg/m³) |
data_ora |
National Air Quality Monitoring Network — RNMCA ↗ | date ISO 8601 | Timestamp of measurement reading |
indice_calitate |
National Air Quality Monitoring Network — RNMCA ↗ | text | Air quality index grade |
train_number |
Railway timetables and transport data — CFR ↗ | text | Train rank and service number |
operator |
Railway timetables and transport data — CFR ↗ | text | Licensed operating railway carrier |
station_from |
Railway timetables and transport data — CFR ↗ | text | Departure railway station name |
station_to |
Railway timetables and transport data — CFR ↗ | text | Destination railway station name |
departure_time |
Railway timetables and transport data — CFR ↗ | time (HH:MM) | Scheduled departure time |
arrival_time |
Railway timetables and transport data — CFR ↗ | time (HH:MM) | Scheduled arrival time |
delay_minutes |
Railway timetables and transport data — CFR ↗ | integer | Real-time reported delay in minutes |
indicativ_statie |
National meteorological observation network — ANM ↗ | text | WMO synoptic station identifier code |
nume_statie |
National meteorological observation network — ANM ↗ | text | Geographical name of weather observation station |
judet join key |
National meteorological observation network — ANM ↗ | text | County jurisdiction where station is located |
temperatura_c |
National meteorological observation network — ANM ↗ | float | Air temperature at 2-metre elevation in degrees Celsius |
umezeala_relativa_pct |
National meteorological observation network — ANM ↗ | integer | Relative humidity percentage |
presiune_hpa |
National meteorological observation network — ANM ↗ | float | Atmospheric pressure reduced to sea level (hPa) |
viteza_vant_ms |
National meteorological observation network — ANM ↗ | float | Average wind speed in metres per second |
precipitatii_mm |
National meteorological observation network — ANM ↗ | float | Accumulated precipitation amount (mm or l/sqm) |
an |
Consumer price index and inflation rate — INS ↗ | integer | Observation reference year |
luna |
Consumer price index and inflation rate — INS ↗ | integer | Calendar month (1–12) |
grupa_marfuri |
Consumer price index and inflation rate — INS ↗ | text | Major basket category (Food, Non-food, Services, Total) |
indice_baza_fixa |
Consumer price index and inflation rate — INS ↗ | float | Fixed-base price index (reference year 2020 = 100) |
rata_lunara_pct |
Consumer price index and inflation rate — INS ↗ | float | Monthly price variation percentage vs prior month |
rata_anuala_pct |
Consumer price index and inflation rate — INS ↗ | float | Annual inflation rate percentage vs same month prior year |
cod_unitate |
National registry of inpatient hospital facilities — Ministry of Health ↗ | text | Unique healthcare facility identifier code |
denumire_spital |
National registry of inpatient hospital facilities — Ministry of Health ↗ | text | Full institutional hospital name |
judet join key |
National registry of inpatient hospital facilities — Ministry of Health ↗ | text | County of administrative location |
forma_proprietate |
National registry of inpatient hospital facilities — Ministry of Health ↗ | text | Ownership regime (Public, Private, Mixed) |
paturi_aprobate |
National registry of inpatient hospital facilities — Ministry of Health ↗ | integer | Total authorized inpatient continuous beds |
paturi_ati |
National registry of inpatient hospital facilities — Ministry of Health ↗ | integer | Authorized intensive care unit (ICU) beds |
are_upu |
National registry of inpatient hospital facilities — Ministry of Health ↗ | boolean | Presence of certified emergency department (UPU/CPU) |
SQL DDL generator (CREATE TABLE)
Generate SQL statements for PostgreSQL, DuckDB or SQLite matching schema definitions.
-- Schema SQL generată pentru: Data structure — ONRC statistical bulletin
CREATE TABLE onrc_firme (
judet VARCHAR,
forma_juridica VARCHAR,
cod_caen VARCHAR,
inmatriculari VARCHAR,
radieri VARCHAR,
suspendari VARCHAR
);