Open knowledge
Romania
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
);
Top ↑