[{"id":1,"schemaname":"public","table":null,"column":null,"type":"schema","datatype":null,"description":{"et":"standard public schema"}}, 
 {"id":2,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":null,"type":"table","datatype":null,"description":{"et": "Maakondlik vanuserühmade hõlmatus.","en": "Coverage of age groups by county."}}, 
 {"id":3,"schemaname":"covid19_old","table":"metadata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":4,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":null,"type":"table","datatype":null,"description":{"et": "Asustusüksuste vanuserühmade hõlmatus.","en": "Coverage of age groups by administrative units."}}, 
 {"id":5,"schemaname":"covid19_old","table":"metadata_odata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":6,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":null,"type":"table","datatype":null,"description":{"et": "Maakondlik kogustatistika.","en": "Test results by county."}}, 
 {"id":7,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_age","column":null,"type":"table","datatype":null,"description":{"et": "Patsientide keskmine vanus.","en": "Average age of patients."}}, 
 {"id":8,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":null,"type":"table","datatype":null,"description":{"et": "Haiglaravi statistika aegrida.","en": "Timeline of hospitalization statistics."}}, 
 {"id":9,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_profile","column":null,"type":"table","datatype":null,"description":{"et": "Patsientide vanuseline ja sooline profiil.","en": "Age and gender profile of patients."}}, 
 {"id":10,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_days","column":null,"type":"table","datatype":null,"description":{"et": "Patsientide haiglas viibimise aeg.","en": "Lenght of hospitalization."}}, 
 {"id":11,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":null,"type":"table","datatype":null,"description":{"et": "Testide tulemused.","en": "Test results."}}, 
 {"id":12,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":null,"type":"table","datatype":null,"description":{"et": "Haldusüksuste vanuserühmade hõlmatus.","en": "Coverage of age groups by municipality."}}, 
 {"id":13,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":null,"type":"table","datatype":null,"description":{"et": "Maakondlik hõlmatus.","en": "Coverage by county."}}, 
 {"id":14,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":null,"type":"table","datatype":null,"description":{"et": "Vanuserühmade hõlmatus.","en": "Coverage by age groups."}}, 
 {"id":15,"schemaname":"covid19_old","table":"opendata_covid19_avg_age_by_result","column":null,"type":"table","datatype":null,"description":{"et": "Nakatunute keskmine vanus.","en": "Average age of those infected."}}, 
 {"id":16,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":null,"type":"table","datatype":null,"description":{"et": "Asukohapõhine statistika.","en": "Test results by location."}}, 
 {"id":17,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":null,"type":"table","datatype":null,"description":{"et": "Üleriigiline nakatumine.","en": "Nationwide positive cases."}}, 
 {"id":18,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":null,"type":"table","datatype":null,"description":{"et": "Vaktsineerijate statistika.","en": "Statistics of institutions carrying out vaccinations."}}, 
 {"id":19,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":null,"type":"table","datatype":null,"description":{"et": "Üleriigiline andmestik.","en": "Nationwide data"}}, 
 {"id":20,"schemaname":"vaccination","table":"metadata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":21,"schemaname":"vaccination","table":"metadata_odata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":22,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":null,"type":"table","datatype":null,"description":{"et": "Vaktsiinvälditavate haiguste (va COVID-19 ja gripp) vastu vaktsineerimise hõlmatuse andmestikus olevate vaktsiini tähiste"}}, 
 {"id":23,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":null,"type":"table","datatype":null,"description":{"et": "Vaktsineerimise andmestik.","en": "Vaccination dataset."}}, 
 {"id":24,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":null,"type":"table","datatype":null,"description":{"et": "Vaktsiinvälditavate haiguste (va COVID-19 ja gripp) vastu vaktsineerimise hõlmatuse andmestik.","en": "Vaccination coverage d"}}, 
 {"id":25,"schemaname":"covid19","table":"metadata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":26,"schemaname":"covid19","table":"metadata_odata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":27,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":null,"type":"table","datatype":null,"description":{"et": "Hooajaline COVID-19 riskigrupi vaktsineerimise hõlmatuse andmestik.","en": "Seasonal COVID-19 Risk Group Vaccination Coverage"}}, 
 {"id":28,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":null,"type":"table","datatype":null,"description":{"et": "Hooajaline COVID-19 haiglaravi andmestik.","en": "Seasonal COVID-19 Hospitalization Dataset."}}, 
 {"id":29,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":null,"type":"table","datatype":null,"description":{"et": "Hooajaline COVID-19 vastu vaktsineerimise andmestik.","en": "Seasonal COVID-19 Vaccination Dataset."}}, 
 {"id":30,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":null,"type":"table","datatype":null,"description":{"et": "Hooajaline COVID-19 nakatumise andmestik.","en": "Seasonal COVID-19 Infection Dataset."}}, 
 {"id":31,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":null,"type":"table","datatype":null,"description":{"et": "Hooajaline COVID-19 vastu vaktsineerimise hõlmatuse andmestik.","en": "Seasonal COVID-19 Vaccination Coverage Dataset."}}, 
 {"id":32,"schemaname":"flu","table":"metadata_odata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":33,"schemaname":"flu","table":"metadata","column":null,"type":"table","datatype":null,"description":{"et": "Metadata andmeteenus.","en": "Metadata data service."}}, 
 {"id":34,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":null,"type":"table","datatype":null,"description":{"et": "Hooajaline gripi vastu vaktsineerimise hõlmatuse andmestik.","en": "Seasonal Influenza Vaccination Coverage Dataset."}}, 
 {"id":35,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":36,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad publitseerimiskeskusest https://pub.e-tervis.ee/classifications/Vaktsiinv%C3%A4lditavad%20haigused%20ja%20haigustekitajad.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the publication center: https://pub.e-tervis.ee/classifications/Vaccine-preventable%20diseases%20and%20pathogens."}}, 
 {"id":37,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":38,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"LocationCountry","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik ehk alati Eesti.","en": "Patient''s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":39,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"LocationCountryEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient''s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country''s code is always 233, which corresponds to Estonia."}}, 
 {"id":40,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"LocationCounty","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "Patient''s county of residence according to the population registry. The value is NULL or unknown if the residence is not available (for foreigners or individuals without registration in the population registry)."}}, 
 {"id":41,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"LocationCountyEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients''s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":42,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"LocationLevel","type":"column","datatype":"character varying(50)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - haldusüksus (vald, linn haldusüksuse tasemel), Village - asustusüksus (küla, vallasisene linn või linnaosa).","en": "The LocationLevel describes the administrative division level to which the data applies: County: The data corresponds to the county level (maakond); Commune: The data corresponds to the administrative unit level, which includes municipalities and cities (vald, linn haldusüksuse tasemel); Village: The data corresponds to the settlement unit level, which includes villages, intra-municipal towns, or city districts (küla, vallasisene linn või linnaosa)."}}, 
 {"id":43,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"AgeGroup","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanuserühm. Vanuserühma jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanuserühmad on kirjeldatud väärtustes 'X-Y', kus vanus on X <= vanus <= Y vahemikus, va viimase vanuserühma juures, kus 'X+' tähendab, et vanus >= X.","en": "The patient''s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format 'X-Y', where the age falls within the range X <= age <= Y, except for the last age group, where 'X+' indicates that the age is greater than or equal to X."}}, 
 {"id":44,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"Gender","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub. M = mees, N = naine.","en": "The patient''s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: M = male, N = female."}}, 
 {"id":45,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"VaccinationSeries","type":"column","datatype":"integer","description":{"et": "Vaktsineerimiskuur, kus 1 = tavapärane esmane vaktsineerimine; >1 lisa- või tõhustusdoosidega vaktsineerimine. VaccinationSeries = 1 väärtuseks loetakse esmane läbiviidud vaktsineerimine. Selle hulka võib kuuluda tavapärase vaktsineerimise käigus 2 doosi 2-doosilisest vaktsiinist või 1 doos 1-doosilisest vaktsiinist või 1 doos 2-doosilisest vaktsiinist kombinatsioonis läbipõdemisega. VaccinationSeries = 2 alla loetakse esimese lisa- ja tõhustusdoosiga vaktsineerimine. VaccinationSeries = n alla loetakse n-1 lisa- ja tõhustusdoosiga vaktsineerimised.","en": "Vaccination course, where 1 denotes the regular primary vaccination, and >1 indicates additional or booster doses. For VaccinationSeries = 1, it is considered as the completion of the primary vaccination. This may include receiving 2 doses in the case of a two-dose vaccine, or 1 dose for a single-dose vaccine, or 1 dose in combination with a previous infection (for a two-dose vaccine). For VaccinationSeries = 2, it represents the first additional or booster dose vaccination. For VaccinationSeries = n, where n > 2, it represents the administration of n-1 additional or booster doses."}}, 
 {"id":46,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"MeasurementType","type":"column","datatype":"character varying(50)","description":{"et": "Mõõdik näitab, mille kohta konkreetse päeva agregeeritud näitajad käivad. Võimalikud väärtused on Vaccinated, FullyVaccinated ja DosesAdministered. Vaccinated alla loetakse kõik inimesed, kes on saanud vähemalt 1 doosi vaktsiini. FullyVaccinated alla loetakse inimesed, kes on vaktsineerimiskuuri nõuetekohaselt lõpetanud (saanud vastavalt kas esimeses kuuris 2 doosi 2-doosilisest vaktsiinist, 1 doosi 1-doosilisest vaktsiinist või 1 doosi ja haiguse läbi põdenud). DosesAdministered alla loetakse mitte inimesi vaid manustatud süste antud vaktsineerimiskuuri lõikes.","en": "This metric indicates the category to which the aggregated statistics of a specific day belong. The possible values are Vaccinated, FullyVaccinated, and DosesAdministered. Vaccinated includes all individuals who have received at least 1 dose of the vaccine. FullyVaccinated includes individuals who have properly completed the vaccination course (received either 2 doses in the course of a 2-dose vaccine, 1 dose of a single-dose vaccine, or 1 dose and have had the disease). DosesAdministered refers to the number of administered doses according to the vaccination course, not the number of individuals."}}, 
 {"id":47,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 01. jaanuar, mis vastab StatisticsDate väärtuses olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The population count by location, age, and/or gender as of January 1st, corresponding to the year specified in the StatisticsDate value. The population count is sourced from the report RV0240 by Statistics Estonia. In case of unknown gender, the value is NULL/missing."}}, 
 {"id":48,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":49,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":50,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"PopulationCoverage","type":"column","datatype":"numeric","description":{"et": "Elanikkonna hõlmatuse protsentnäit reaalarvuna ilma protsendi märgita, ümardatud 2 komakohani. Näiteks 0,05= hõlmatus on 0.05%; 50.00= hõlmatus on 50%. Kui hõlmatust ei saa arvutada, siis on väärtus NULL/ väärtus puudub.","en": "The population coverage percentage as a decimal number without the percent sign, rounded to 2 decimal places. For example, 0.05 = coverage is 0.05%; 50.00 = coverage is 50%. If the coverage cannot be calculated, the value is NULL/missing."}}, 
 {"id":51,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county_agegroup_gender","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":52,"schemaname":"covid19_old","table":"metadata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":53,"schemaname":"covid19_old","table":"metadata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":54,"schemaname":"covid19_old","table":"metadata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":55,"schemaname":"covid19_old","table":"metadata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":56,"schemaname":"covid19_old","table":"metadata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":57,"schemaname":"covid19_old","table":"metadata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":58,"schemaname":"covid19_old","table":"metadata","column":"description","type":"column","datatype":"json","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":59,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":60,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad publitseerimiskeskusest https://pub.e-tervis.ee/classifications/Vaktsiinv%C3%A4lditavad%20haigused%20ja%20haigustekitajad.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the publication center: https://pub.e-tervis.ee/classifications/Vaccine-preventable%20diseases%20and%20pathogens."}}, 
 {"id":61,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":62,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationCountry","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik ehk alati Eesti.","en": "Patient''s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":63,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationCountryEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient''s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country''s code is always 233, which corresponds to Estonia."}}, 
 {"id":64,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationCounty","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "Patient''s county of residence according to the population registry. The value is NULL or unknown if the residence is not available (for foreigners or individuals without registration in the population registry)."}}, 
 {"id":65,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationCountyEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients''s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":66,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationCommune","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha haldusüksus (vald või linn haldusüksuse tasemel). Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "Patient''s administrative unit (municipality or city) of residence according to the population registry. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":67,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationCommuneEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha haldusüksuse (valla, linna haldusüksuse tasemel) Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient''s administrative unit (municipality or city) of residence according to the population registry. The code can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":68,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationVillage","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha asustusüksus (küla, vallasisene linn või linnaosa). Avaldatakse vaid valitud asustusüksuste lõikes (haldusüksuse Tallinna linn kõik linnaosad; haldusüksuse Pärnu linn sisene Pärnu linn; haldusüksuse Tartu linn sisene Tartu linn; Kuressaare linn). Väärtus NULL/ väärtuse puudumise korral on elukoht asustusüksuse tasemel teadmata.","en": "Patient''s settlement unit (village, intra-municipal town, or city district) of residence according to the population registry. It is only disclosed for selected settlement units, such as all city districts within the administrative unit of Tallinn, the intra-municipal town of Pärnu within its administrative unit, the intra-municipal town of Tartu within its administrative unit, and Kuressaare city. If the value is NULL or unavailable, it indicates that the residence at the settlement unit level is unknown."}}, 
 {"id":69,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationVillageEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse asustusüksuse (küla, vallasisese linna või linnaosa) Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Avaldatakse vaid valitud asustusüksuste lõikes (haldusüksuse Tallinna linn kõik linnaosad; haldusüksuse Pärnu linn sisene Pärnu linn; haldusüksuse Tartu linn sisene Tartu linn; Kuressaare linn). Väärtus NULL/ väärtuse puudumise korral on elukoht asustusüksuse tasemel teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient''s settlement unit (village, intra-municipal town, or city district) of residence according to the population registry. The EHAK code for the settlement unit can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. It is only disclosed for selected settlement units, such as all city districts within the administrative unit of Tallinn, the intra-municipal town of Pärnu within its administrative unit, the intra-municipal town of Tartu within its administrative unit, and Kuressaare city. If the value is NULL or unavailable, it indicates that the residence at the settlement unit level is unknown."}}, 
 {"id":70,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationLevel","type":"column","datatype":"character varying(50)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - haldusüksus (vald, linn haldusüksuse tasemel), Village - asustusüksus (küla, vallasisene linn või linnaosa).","en": "The LocationLevel describes the administrative division level to which the data applies: County: The data corresponds to the county level (maakond); Commune: The data corresponds to the administrative unit level, which includes municipalities and cities (vald, linn haldusüksuse tasemel); Village: The data corresponds to the settlement unit level, which includes villages, intra-municipal towns, or city districts (küla, vallasisene linn või linnaosa)."}}, 
 {"id":71,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"AgeGroup","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanuserühm. Vanuserühma jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanuserühmad on kirjeldatud väärtustes 'X-Y', kus vanus on X <= vanus <= Y vahemikus, va viimase vanuserühma juures, kus 'X+' tähendab, et vanus >= X.","en": "The patient''s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format 'X-Y', where the age falls within the range X <= age <= Y, except for the last age group, where 'X+' indicates that the age is greater than or equal to X."}}, 
 {"id":72,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"Gender","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub. M = mees, N = naine.","en": "The patient''s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: M = male, N = female."}}, 
 {"id":73,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"VaccinationSeries","type":"column","datatype":"integer","description":{"et": "Vaktsineerimiskuur, kus 1 = tavapärane esmane vaktsineerimine; >1 lisa- või tõhustusdoosidega vaktsineerimine. VaccinationSeries = 1 väärtuseks loetakse esmane läbiviidud vaktsineerimine. Selle hulka võib kuuluda tavapärase vaktsineerimise käigus 2 doosi 2-doosilisest vaktsiinist või 1 doos 1-doosilisest vaktsiinist või 1 doos 2-doosilisest vaktsiinist kombinatsioonis läbipõdemisega. VaccinationSeries = 2 alla loetakse esimese lisa- ja tõhustusdoosiga vaktsineerimine. VaccinationSeries = n alla loetakse n-1 lisa- ja tõhustusdoosiga vaktsineerimised.","en": "Vaccination course, where 1 denotes the regular primary vaccination, and >1 indicates additional or booster doses. For VaccinationSeries = 1, it is considered as the completion of the primary vaccination. This may include receiving 2 doses in the case of a two-dose vaccine, or 1 dose for a single-dose vaccine, or 1 dose in combination with a previous infection (for a two-dose vaccine). For VaccinationSeries = 2, it represents the first additional or booster dose vaccination. For VaccinationSeries = n, where n > 2, it represents the administration of n-1 additional or booster doses."}}, 
 {"id":74,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"MeasurementType","type":"column","datatype":"character varying(50)","description":{"et": "Mõõdik näitab, mille kohta konkreetse päeva agregeeritud näitajad käivad. Võimalikud väärtused on Vaccinated, FullyVaccinated ja DosesAdministered. Vaccinated alla loetakse kõik inimesed, kes on saanud vähemalt 1 doosi vaktsiini. FullyVaccinated alla loetakse inimesed, kes on vaktsineerimiskuuri nõuetekohaselt lõpetanud (saanud vastavalt kas esimeses kuuris 2 doosi 2-doosilisest vaktsiinist, 1 doosi 1-doosilisest vaktsiinist või 1 doosi ja haiguse läbi põdenud). DosesAdministered alla loetakse mitte inimesi vaid manustatud süste antud vaktsineerimiskuuri lõikes.","en": "This metric indicates the category to which the aggregated statistics of a specific day belong. The possible values are Vaccinated, FullyVaccinated, and DosesAdministered. Vaccinated includes all individuals who have received at least 1 dose of the vaccine. FullyVaccinated includes individuals who have properly completed the vaccination course (received either 2 doses in the course of a 2-dose vaccine, 1 dose of a single-dose vaccine, or 1 dose and have had the disease). DosesAdministered refers to the number of administered doses according to the vaccination course, not the number of individuals."}}, 
 {"id":75,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 01. jaanuar, mis vastab StatisticsDate väärtuses olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The population count by location, age, and/or gender as of January 1st, corresponding to the year specified in the StatisticsDate value. The population count is sourced from the report RV0240 by Statistics Estonia. In case of unknown gender, the value is NULL/missing."}}, 
 {"id":76,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":77,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":78,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"PopulationCoverage","type":"column","datatype":"numeric","description":{"et": "Elanikkonna hõlmatuse protsentnäit reaalarvuna ilma protsendi märgita, ümardatud 2 komakohani. Näiteks 0,05= hõlmatus on 0.05%; 50.00= hõlmatus on 50%. Kui hõlmatust ei saa arvutada, siis on väärtus NULL/ väärtus puudub.","en": "The population coverage percentage as a decimal number without the percent sign, rounded to 2 decimal places. For example, 0.05 = coverage is 0.05%; 50.00 = coverage is 50%. If the coverage cannot be calculated, the value is NULL/missing."}}, 
 {"id":79,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_village_agegroup_gender","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":80,"schemaname":"covid19_old","table":"metadata_odata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":81,"schemaname":"covid19_old","table":"metadata_odata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":82,"schemaname":"covid19_old","table":"metadata_odata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":83,"schemaname":"covid19_old","table":"metadata_odata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":84,"schemaname":"covid19_old","table":"metadata_odata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":85,"schemaname":"covid19_old","table":"metadata_odata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":86,"schemaname":"covid19_old","table":"metadata_odata","column":"description","type":"column","datatype":"character varying(2000)","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":87,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"LastStatisticsDate","type":"column","datatype":"date","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus, kõigil ridadel on sama väärtus.","en": "The last update date of the data in ISO 8601 standard format, with the same value for all rows."}}, 
 {"id":88,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":89,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"Country","type":"column","datatype":"character varying(64)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik. Võimalikud väärtused on Eesti, tundmatu, välismaa.","en": "Patient''s country of residence according to the population registry. Possible values are: Eesti = Estonia; Tundmatu = Unknown; Välismaa = Foreign country."}}, 
 {"id":90,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"CountryEHAK","type":"column","datatype":"character varying(3)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile https://www.iso.org/obp/ui/#iso:code:3166:EE. Andmestikus alati 233.","en": "The numerical code for the patient''s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country''s code is always 233, which corresponds to Estonia."}}, 
 {"id":91,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"County","type":"column","datatype":"character varying(256)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "Patient''s county of residence according to the population registry. Value NULL/missing indicates unknown residence."}}, 
 {"id":92,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"CountyEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients''s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":93,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"ResultValue","type":"column","datatype":"character varying(2)","description":{"et": "SARS-CoV-2 analüüsitulemuse vastus, Võimalikud väärtused on: N - negatiivne, P - positiivne. Väljastatakse esmaseid positiivseid teste ning kõiki negatiivseid teste.","en": "SARS-CoV-2 analysis result response. Possible values are: N - negative, P - positive. Primary positive tests and all negative tests are reported."}}, 
 {"id":94,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"DailyTests","type":"column","datatype":"integer","description":{"et": "Testide (esmakordsete ja kordustestide) arv päevas.","en": "The number of tests (initial and repeated tests) per day."}}, 
 {"id":95,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"TotalTests","type":"column","datatype":"integer","description":{"et": "Testide (esmakordsete ja kordustestide) summa statistika kuupäevaks (StatisticsDate).","en": "Total number of tests (including initial and repeated tests) as of the statistics date (StatisticsDate)."}}, 
 {"id":96,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"DailyCases","type":"column","datatype":"integer","description":{"et": "Esmakordsete positiivsete testide arv päevas. Haigusjuhtumite leidmisel kasutatakse metoodikat, kus leitakse iga patsiendi kohta 60-päevases ajaaknas esimene positiivne test.","en": "Number of first positive tests per day. Finding cases follows a methodology where the first positive test within a 60-day timeframe is identified for each patient."}}, 
 {"id":97,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"TotalCases","type":"column","datatype":"integer","description":{"et": "Esmakordsete positiivsete testide arv kokku statistika kuupäevaks.","en": "Total count of initial positive tests as of the statistics date."}}, 
 {"id":98,"schemaname":"covid19_old","table":"opendata_covid19_test_county_all","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":99,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_age","column":"lastloadstatisticsdate","type":"column","datatype":"date","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus.","en": "The last update date of the data in ISO 8601 format."}}, 
 {"id":100,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_age","column":"gender","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi sugu: M = mees, N = naine, NULL/ väärtus puudub = kõik kokku.","en": "Patient''s gender: M = male, N = female, NULL/missing = men and women combined."}}, 
 {"id":101,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_age","column":"averageage","type":"column","datatype":"integer","description":{"et": "Patsientide keskmine vanus esmase haiglasse sissekirjutamise hetkel.","en": "Average age of patients at the time of their initial hospital admission."}}, 
 {"id":102,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"lastloadstatisticsdate","type":"column","datatype":"date","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus.","en": "The last update date of the data in ISO 8601 format."}}, 
 {"id":103,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"statisticsdate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev, mille kohta andmed kehtivad.","en": "Statistics date to which the data applies."}}, 
 {"id":104,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"hospitalised","type":"column","datatype":"integer","description":{"et": "Unikaalsete patsientide arv, kelle kohta statistika kuupäeval (StatisticsDate) on kirje haiglaga seotuse kohta: st isikud, kes on aktiivselt haiglas sees, samal päeval välja kirjutatud, edasi suunatud teise haiglasse või surnud. Kõik isikud kokku.","en": "The number of unique patients associated with a hospital on a specific statistics date (StatisticsDate) includes individuals who are actively hospitalized, discharged on the same day, transferred to another hospital, or deceased. It represents the total count of all patients."}}, 
 {"id":105,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"activelyhospitalised","type":"column","datatype":"integer","description":{"et": "Koroonaga haiglas viibivate patsientide arv statistika kuupäeval (StatisticsDate), mis arvutatakse järgmiselt: haiglas viibivate patsientide arvust (Hospitalised) on maha arvatud patsiendid, kelle väljakirjutamise põhjus on kas üle viidud mitte-COVID osakonda samas haiglas, üle viidud mitte-COVID osakonda teises haiglas, isolatsioon lõpetatud, valepositiivne või saadetud koju. Siia kuuluvad need, kelle väljakirjutamise põhjus on kas üle viidud COVID-osakonda teises haiglas või surm.","en": "The number of patients hospitalized with COVID-19 on a specific statistics date (StatisticsDate) is calculated as follows: subtract the patients whose discharge reason is either transferred to a non-COVID department in the same hospital, transferred to a non-COVID department in another hospital, isolation ended, false positive, or sent home from the total count of hospitalized patients (Hospitalised). This includes patients whose discharge reason is transferred to a COVID department in another hospital or deceased."}}, 
 {"id":106,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"active","type":"column","datatype":"integer","description":{"et": "Koroonaga haiglas viibivate elus patsientide arv statistika kuupäeval (StatisticsDate), mis arvutatakse järgmiselt: haiglas viibivate patsientide arvust (Hospitalised) on maha arvatud patsiendid, kelle väljakirjutamise põhjus on kas üle viidud mitte-COVID osakonda samas haiglas, üle viidud mitte-COVID osakonda teises haiglas, isolatsioon lõpetatud, valepositiivne, saadetud koju või surm. Siia kuuluvad need, kelle väljakirjutamise põhjus on üle viidud COVID-osakonda teises haiglas.","en": "The number of living patients hospitalized with COVID-19 on a specific statistics date (StatisticsDate) is calculated as follows: subtract the patients whose discharge reason is either transferred to a non-COVID department in the same hospital, transferred to a non-COVID department in another hospital, isolation ended, false positive, sent home, or deceased from the total count of hospitalized patients (Hospitalised). This includes patients whose discharge reason is transferred to a COVID department in another hospital."}}, 
 {"id":107,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"isonventilation","type":"column","datatype":"integer","description":{"et": "Patsientide arv, kes on statistika kuupäeval  (StatisticsDate) ventileeritaval hingamisel.","en": "The number of patients who are on mechanical ventilation on the specific statistics date (StatisticsDate)."}}, 
 {"id":108,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"isinintensive","type":"column","datatype":"integer","description":{"et": "Patsientide arv, kes on statistika kuupäeval  (StatisticsDate) intensiivravi osakonnas.","en": "The number of patients who are in the intensive care unit on the specific statistics date (StatisticsDate)."}}, 
 {"id":109,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"discharged","type":"column","datatype":"integer","description":{"et": "Patsientide arv, kes on statistika kuupäeval  (StatisticsDate) koroonapatsiendina haiglast välja kirjutatud: üle viidud mitte-COVID osakonda samas haiglas, üle viidud mitte-COVID osakonda teises haiglas, isolatsioon lõpetatud, valepositiivne või saadetud koju.","en": "The number of patients who have been discharged from the hospital as COVID-19 patients on the specific statistics date (StatisticsDate), including those transferred to non-COVID departments within the same hospital, transferred to non-COVID departments in other hospitals, completed isolation, had false-positive results, or sent home."}}, 
 {"id":110,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"newcases","type":"column","datatype":"integer","description":{"et": "Uute haiglas avatud COVID-19 haigusjuhtumite arv statistika kuupäeval (StatisticsDate).","en": "The number of new COVID-19 cases admitted to the hospital on the specific statistics date (StatisticsDate)."}}, 
 {"id":111,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"totalcases","type":"column","datatype":"integer","description":{"et": "Statistika kuupäevaks (StatisticsDate) haiglas avatud COVID-19 haigusjuhtumite arv kokku.","en": "The total number of COVID-19 cases opened in the hospital as of the specific statistics date (StatisticsDate)."}}, 
 {"id":112,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"totalcasesdischarged","type":"column","datatype":"integer","description":{"et": "Statistika kuupäevaks (StatisticsDate) lõpetatud COVID-19 haigusjuhtumite arv kokku, va surmajuhtumid.","en": "The total number of COVID-19 cases closed, excluding deaths, as of the specific statistics date (StatisticsDate)."}}, 
 {"id":113,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"newpatients","type":"column","datatype":"integer","description":{"et": "Uute COVID-19 patsientide arv statistika kuupäeval (StatisticsDate).","en": "The number of new COVID-19 patients on the specific statistics date (StatisticsDate)."}}, 
 {"id":114,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"totalpatients","type":"column","datatype":"integer","description":{"et": "Statistika kuupäevaks (StatisticsDate) COVID-19 patsientide arv kokku.","en": "The total number of COVID-19 patients on the specific statistics date (StatisticsDate)."}}, 
 {"id":115,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_timeline","column":"totalpatientsdischarged","type":"column","datatype":"integer","description":{"et": "Statistika kuupäevaks (StatisticsDate) koroonapatsiendina haiglast välja kirjutatud patsientide arv kokku, va surmajuhtumid: üle viidud mitte-COVID osakonda samas haiglas, üle viidud mitte-COVID osakonda teises haiglas, isolatsioon lõpetatud, valepositiivne või saadetud koju.","en": "The total number of COVID-19 patients discharged from the hospital on the specific statistics date (StatisticsDate), excluding deaths: patients transferred to a non-COVID department within the same hospital, transferred to a non-COVID department in another hospital, isolation completed, false positive cases, or sent home."}}, 
 {"id":116,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_profile","column":"lastloadstatisticsdate","type":"column","datatype":"character varying(50)","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus.","en": "The last update date of the data in ISO 8601 format."}}, 
 {"id":117,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_profile","column":"gender","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi sugu: M = mees, N = naine, NULL/ väärtus puudub = kõik kokku.","en": "Patient''s gender: M = male, N = female, NULL/missing = men and women combined."}}, 
 {"id":118,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_profile","column":"agegroup","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanuserühma kuuluvus esmase haiglasse sissekirjutamise hetkel. Võimalikud väärtused on 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, üle 85.","en": "Patients'' age group at the time of their initial hospital admission. Possible values are 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, over 85 (üle 85)."}}, 
 {"id":119,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_profile","column":"patientcount","type":"column","datatype":"integer","description":{"et": "Haiglas viibinud patsientide arv kokku COVID-19 kriisi jooksul.","en": "Total number of patients hospitalized during the COVID-19 crisis."}}, 
 {"id":120,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_days","column":"lastloadstatisticsdate","type":"column","datatype":"date","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus.","en": "The last update date of the data in ISO 8601 format."}}, 
 {"id":121,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_days","column":"statisticsdate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev, mille kohta andmed kehtivad.","en": "Statistics date to which the data applies."}}, 
 {"id":122,"schemaname":"covid19_old","table":"opendata_covid19_hospitalization_avg_days","column":"averagedays","type":"column","datatype":"integer","description":{"et": "Patsientide keskmine haiglas viibimise päevade arv.","en": "Average length of hospital stay for patients in days."}}, 
 {"id":123,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"id","type":"column","datatype":"character varying(64)","description":{"et": "Testi unikaalne anonümiseeritud tunnus.","en": "Unique anonymized identifier for the test."}}, 
 {"id":124,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"Gender","type":"column","datatype":"character varying(2)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub. M = mees, N = naine.","en": "The patient''s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: M = male, N = female."}}, 
 {"id":125,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"AgeGroup","type":"column","datatype":"character varying(16)","description":{"et": "Patsiendi vanuserühma kuuluvus testi tegemise hetke seisuga. Võimalikud väärtused on 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, üle 85.","en": "Patient''s age group at the time of testing. Possible values are: 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, over 85 (üle 85)."}}, 
 {"id":126,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"Country","type":"column","datatype":"character varying(64)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik. Võimalikud väärtused on Eesti, tundmatu, välismaa.","en": "Patient''s country of residence according to the population registry. Possible values are: Eesti = Estonia; Tundmatu = Unknown; Välismaa = Foreign country."}}, 
 {"id":127,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"County","type":"column","datatype":"character varying(256)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "Patient''s county of residence according to the population registry. Value NULL/missing indicates unknown residence."}}, 
 {"id":128,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"ResultValue","type":"column","datatype":"character varying(2)","description":{"et": "SARS-CoV-2 analüüsitulemuse vastus, Võimalikud väärtused on: N - negatiivne, P - positiivne. Väljastatakse esmaseid positiivseid teste ning kõiki negatiivseid teste.","en": "SARS-CoV-2 analysis result response. Possible values are: N - negative, P - positive. Primary positive tests and all negative tests are reported."}}, 
 {"id":129,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":130,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"ResultTime","type":"column","datatype":"timestamp without time zone","description":{"et": "Proovivõtu aeg või selle puudumisel analüüsitulemuse aeg ISO 8601 standardi vormingus koos ajavööndiga.","en": "The sampling time or, in its absence, the analysis result time in ISO 8601 standard format including the time zone."}}, 
 {"id":131,"schemaname":"covid19_old","table":"opendata_covid19_test_results","column":"AnalysisInsertTime","type":"column","datatype":"timestamp without time zone","description":{"et": "Testi tulemuse laekumise aeg tervise infosüsteemi ISO 8601 standardi vormingus koos ajavööndiga.","en": "The result delivery time to the health information system in ISO 8601 standard format including the time zone."}}, 
 {"id":132,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"Id","type":"column","datatype":"integer","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":133,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":134,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad teabekeskusest https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the teabekeskus: https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused"}}, 
 {"id":135,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":136,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationCountry","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik ehk alati Eesti.","en": "Patient''s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":137,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationCountryEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient''s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country''s code is always 233, which corresponds to Estonia."}}, 
 {"id":138,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationCounty","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "Patient''s county of residence according to the population registry. The value is NULL or unknown if the residence is not available (for foreigners or individuals without registration in the population registry)."}}, 
 {"id":139,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationCountyEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients''s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":140,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationCommune","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha haldusüksus (vald või linn haldusüksuse tasemel). Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "Patient''s administrative unit (municipality or city) of residence according to the population registry. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":141,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationCommuneEHAK","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha haldusüksuse (valla, linna haldusüksuse tasemel) Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient''s administrative unit (municipality or city) of residence according to the population registry. The code can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":142,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationLevel","type":"column","datatype":"character varying(50)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - haldusüksus (vald, linn haldusüksuse tasemel), Village - asustusüksus (küla, vallasisene linn või linnaosa).","en": "The LocationLevel describes the administrative division level to which the data applies: County: The data corresponds to the county level (maakond); Commune: The data corresponds to the administrative unit level, which includes municipalities and cities (vald, linn haldusüksuse tasemel); Village: The data corresponds to the settlement unit level, which includes villages, intra-municipal towns, or city districts (küla, vallasisene linn või linnaosa)."}}, 
 {"id":143,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"AgeGroup","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanuserühm. Vanuserühma jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanuserühmad on kirjeldatud väärtustes 'X-Y', kus vanus on X <= vanus <= Y vahemikus, va viimase vanuserühma juures, kus 'X+' tähendab, et vanus >= X.","en": "The patient''s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format 'X-Y', where the age falls within the range X <= age <= Y, except for the last age group, where 'X+' indicates that the age is greater than or equal to X."}}, 
 {"id":144,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"Gender","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub. M = mees, N = naine.","en": "The patient''s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: M = male, N = female."}}, 
 {"id":145,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"VaccinationSeries","type":"column","datatype":"integer","description":{"et": "Vaktsineerimiskuur, kus 1 = tavapärane esmane vaktsineerimine; >1 lisa- või tõhustusdoosidega vaktsineerimine. VaccinationSeries = 1 väärtuseks loetakse esmane läbiviidud vaktsineerimine. Selle hulka võib kuuluda tavapärase vaktsineerimise käigus 2 doosi 2-doosilisest vaktsiinist või 1 doos 1-doosilisest vaktsiinist või 1 doos 2-doosilisest vaktsiinist kombinatsioonis läbipõdemisega. VaccinationSeries = 2 alla loetakse esimese lisa- ja tõhustusdoosiga vaktsineerimine. VaccinationSeries = n alla loetakse n-1 lisa- ja tõhustusdoosiga vaktsineerimised.","en": "Vaccination course, where 1 denotes the regular primary vaccination, and >1 indicates additional or booster doses. For VaccinationSeries = 1, it is considered as the completion of the primary vaccination. This may include receiving 2 doses in the case of a two-dose vaccine, or 1 dose for a single-dose vaccine, or 1 dose in combination with a previous infection (for a two-dose vaccine). For VaccinationSeries = 2, it represents the first additional or booster dose vaccination. For VaccinationSeries = n, where n > 2, it represents the administration of n-1 additional or booster doses."}}, 
 {"id":146,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"MeasurementType","type":"column","datatype":"character varying(50)","description":{"et": "Mõõdik näitab, mille kohta konkreetse päeva agregeeritud näitajad käivad. Võimalikud väärtused on Vaccinated, FullyVaccinated ja DosesAdministered. Vaccinated alla loetakse kõik inimesed, kes on saanud vähemalt 1 doosi vaktsiini. FullyVaccinated alla loetakse inimesed, kes on vaktsineerimiskuuri nõuetekohaselt lõpetanud (saanud vastavalt kas esimeses kuuris 2 doosi 2-doosilisest vaktsiinist, 1 doosi 1-doosilisest vaktsiinist või 1 doosi ja haiguse läbi põdenud). DosesAdministered alla loetakse mitte inimesi vaid manustatud süste antud vaktsineerimiskuuri lõikes.","en": "This metric indicates the category to which the aggregated statistics of a specific day belong. The possible values are Vaccinated, FullyVaccinated, and DosesAdministered. Vaccinated includes all individuals who have received at least 1 dose of the vaccine. FullyVaccinated includes individuals who have properly completed the vaccination course (received either 2 doses in the course of a 2-dose vaccine, 1 dose of a single-dose vaccine, or 1 dose and have had the disease). DosesAdministered refers to the number of administered doses according to the vaccination course, not the number of individuals."}}, 
 {"id":147,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 01. jaanuar, mis vastab StatisticsDate väärtuses olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The population count by location, age, and/or gender as of January 1st, corresponding to the year specified in the StatisticsDate value. The population count is sourced from the report RV0240 by Statistics Estonia. In case of unknown gender, the value is NULL/missing."}}, 
 {"id":148,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":149,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":150,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_commune_agegroup_gender","column":"PopulationCoverage","type":"column","datatype":"numeric","description":{"et": "Elanikkonna hõlmatuse protsentnäit reaalarvuna ilma protsendi märgita, ümardatud 2 komakohani. Näiteks 0,05= hõlmatus on 0.05%; 50.00= hõlmatus on 50%. Kui hõlmatust ei saa arvutada, siis on väärtus NULL/ väärtus puudub.","en": "The population coverage percentage as a decimal number without the percent sign, rounded to 2 decimal places. For example, 0.05 = coverage is 0.05%; 50.00 = coverage is 50%. If the coverage cannot be calculated, the value is NULL/missing."}}, 
 {"id":151,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"StatisticsDate","type":"column","datatype":"character varying(50)","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":152,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad publitseerimiskeskusest https://pub.e-tervis.ee/classifications/Vaktsiinv%C3%A4lditavad%20haigused%20ja%20haigustekitajad.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the publication center: https://pub.e-tervis.ee/classifications/Vaccine-preventable%20diseases%20and%20pathogens."}}, 
 {"id":153,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":154,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"LocationCountry","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik ehk alati Eesti.","en": "Patient''s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":155,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"LocationCountryEHAK","type":"column","datatype":"integer","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient''s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country''s code is always 233, which corresponds to Estonia."}}, 
 {"id":156,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"LocationCounty","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "Patient''s county of residence according to the population registry. The value is NULL or unknown if the residence is not available (for foreigners or individuals without registration in the population registry)."}}, 
 {"id":157,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"LocationCountyEHAK","type":"column","datatype":"integer","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients''s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":158,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"LocationLevel","type":"column","datatype":"character varying(50)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - haldusüksus (vald, linn haldusüksuse tasemel), Village - asustusüksus (küla, vallasisene linn või linnaosa).","en": "The LocationLevel describes the administrative division level to which the data applies: County: The data corresponds to the county level (maakond); Commune: The data corresponds to the administrative unit level, which includes municipalities and cities (vald, linn haldusüksuse tasemel); Village: The data corresponds to the settlement unit level, which includes villages, intra-municipal towns, or city districts (küla, vallasisene linn või linnaosa)."}}, 
 {"id":159,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"VaccinationSeries","type":"column","datatype":"integer","description":{"et": "Vaktsineerimiskuur, kus 1 = tavapärane esmane vaktsineerimine; >1 lisa- või tõhustusdoosidega vaktsineerimine. VaccinationSeries = 1 väärtuseks loetakse esmane läbiviidud vaktsineerimine. Selle hulka võib kuuluda tavapärase vaktsineerimise käigus 2 doosi 2-doosilisest vaktsiinist või 1 doos 1-doosilisest vaktsiinist või 1 doos 2-doosilisest vaktsiinist kombinatsioonis läbipõdemisega. VaccinationSeries = 2 alla loetakse esimese lisa- ja tõhustusdoosiga vaktsineerimine. VaccinationSeries = n alla loetakse n-1 lisa- ja tõhustusdoosiga vaktsineerimised.","en": "Vaccination course, where 1 denotes the regular primary vaccination, and >1 indicates additional or booster doses. For VaccinationSeries = 1, it is considered as the completion of the primary vaccination. This may include receiving 2 doses in the case of a two-dose vaccine, or 1 dose for a single-dose vaccine, or 1 dose in combination with a previous infection (for a two-dose vaccine). For VaccinationSeries = 2, it represents the first additional or booster dose vaccination. For VaccinationSeries = n, where n > 2, it represents the administration of n-1 additional or booster doses."}}, 
 {"id":160,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"MeasurementType","type":"column","datatype":"character varying(50)","description":{"et": "Mõõdik näitab, mille kohta konkreetse päeva agregeeritud näitajad käivad. Võimalikud väärtused on Vaccinated, FullyVaccinated ja DosesAdministered. Vaccinated alla loetakse kõik inimesed, kes on saanud vähemalt 1 doosi vaktsiini. FullyVaccinated alla loetakse inimesed, kes on vaktsineerimiskuuri nõuetekohaselt lõpetanud (saanud vastavalt kas esimeses kuuris 2 doosi 2-doosilisest vaktsiinist, 1 doosi 1-doosilisest vaktsiinist või 1 doosi ja haiguse läbi põdenud). DosesAdministered alla loetakse mitte inimesi vaid manustatud süste antud vaktsineerimiskuuri lõikes.","en": "This metric indicates the category to which the aggregated statistics of a specific day belong. The possible values are Vaccinated, FullyVaccinated, and DosesAdministered. Vaccinated includes all individuals who have received at least 1 dose of the vaccine. FullyVaccinated includes individuals who have properly completed the vaccination course (received either 2 doses in the course of a 2-dose vaccine, 1 dose of a single-dose vaccine, or 1 dose and have had the disease). DosesAdministered refers to the number of administered doses according to the vaccination course, not the number of individuals."}}, 
 {"id":161,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 01. jaanuar, mis vastab StatisticsDate väärtuses olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The population count by location, age, and/or gender as of January 1st, corresponding to the year specified in the StatisticsDate value. The population count is sourced from the report RV0240 by Statistics Estonia. In case of unknown gender, the value is NULL/missing."}}, 
 {"id":162,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":163,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":164,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"PopulationCoverage","type":"column","datatype":"numeric","description":{"et": "Elanikkonna hõlmatuse protsentnäit reaalarvuna ilma protsendi märgita, ümardatud 2 komakohani. Näiteks 0,05= hõlmatus on 0.05%; 50.00= hõlmatus on 50%. Kui hõlmatust ei saa arvutada, siis on väärtus NULL/ väärtus puudub.","en": "The population coverage percentage as a decimal number without the percent sign, rounded to 2 decimal places. For example, 0.05 = coverage is 0.05%; 50.00 = coverage is 50%. If the coverage cannot be calculated, the value is NULL/missing."}}, 
 {"id":165,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_location_county","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":166,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"StatisticsDate","type":"column","datatype":"character varying(50)","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":167,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad publitseerimiskeskusest https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the publication center: https://pub.e-tervis.ee/classifications/Vaccine-preventable%20diseases%20and%20pathogens."}}, 
 {"id":168,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":169,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"AgeGroup","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanuserühm. Vanuserühma jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanuserühmad on kirjeldatud väärtustes 'X-Y', kus vanus on X <= vanus <= Y vahemikus, va viimase vanuserühma juures, kus 'X+' tähendab, et vanus >= X.","en": "The patient''s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format 'X-Y', where the age falls within the range X <= age <= Y, except for the last age group, where 'X+' indicates that the age is greater than or equal to X."}}, 
 {"id":170,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"VaccinationSeries","type":"column","datatype":"integer","description":{"et": "Vaktsineerimiskuur, kus 1 = tavapärane esmane vaktsineerimine; >1 lisa- või tõhustusdoosidega vaktsineerimine. VaccinationSeries = 1 väärtuseks loetakse esmane läbiviidud vaktsineerimine. Selle hulka võib kuuluda tavapärase vaktsineerimise käigus 2 doosi 2-doosilisest vaktsiinist või 1 doos 1-doosilisest vaktsiinist või 1 doos 2-doosilisest vaktsiinist kombinatsioonis läbipõdemisega. VaccinationSeries = 2 alla loetakse esimese lisa- ja tõhustusdoosiga vaktsineerimine. VaccinationSeries = n alla loetakse n-1 lisa- ja tõhustusdoosiga vaktsineerimised.","en": "Vaccination course, where 1 denotes the regular primary vaccination, and >1 indicates additional or booster doses. For VaccinationSeries = 1, it is considered as the completion of the primary vaccination. This may include receiving 2 doses in the case of a two-dose vaccine, or 1 dose for a single-dose vaccine, or 1 dose in combination with a previous infection (for a two-dose vaccine). For VaccinationSeries = 2, it represents the first additional or booster dose vaccination. For VaccinationSeries = n, where n > 2, it represents the administration of n-1 additional or booster doses."}}, 
 {"id":171,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"MeasurementType","type":"column","datatype":"character varying(50)","description":{"et": "Mõõdik näitab, mille kohta konkreetse päeva agregeeritud näitajad käivad. Võimalikud väärtused on Vaccinated, FullyVaccinated ja DosesAdministered. Vaccinated alla loetakse kõik inimesed, kes on saanud vähemalt 1 doosi vaktsiini. FullyVaccinated alla loetakse inimesed, kes on vaktsineerimiskuuri nõuetekohaselt lõpetanud (saanud vastavalt kas esimeses kuuris 2 doosi 2-doosilisest vaktsiinist, 1 doosi 1-doosilisest vaktsiinist või 1 doosi ja haiguse läbi põdenud). DosesAdministered alla loetakse mitte inimesi vaid manustatud süste antud vaktsineerimiskuuri lõikes.","en": "This metric indicates the category to which the aggregated statistics of a specific day belong. The possible values are Vaccinated, FullyVaccinated, and DosesAdministered. Vaccinated includes all individuals who have received at least 1 dose of the vaccine. FullyVaccinated includes individuals who have properly completed the vaccination course (received either 2 doses in the course of a 2-dose vaccine, 1 dose of a single-dose vaccine, or 1 dose and have had the disease). DosesAdministered refers to the number of administered doses according to the vaccination course, not the number of individuals."}}, 
 {"id":172,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 01. jaanuar, mis vastab StatisticsDate väärtuses olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The population count by location, age, and/or gender as of January 1st, corresponding to the year specified in the StatisticsDate value. The population count is sourced from the report RV0240 by Statistics Estonia. In case of unknown gender, the value is NULL/missing."}}, 
 {"id":173,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":174,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":175,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"PopulationCoverage","type":"column","datatype":"numeric","description":{"et": "Elanikkonna hõlmatuse protsentnäit reaalarvuna ilma protsendi märgita, ümardatud 2 komakohani. Näiteks 0,05= hõlmatus on 0.05%; 50.00= hõlmatus on 50%. Kui hõlmatust ei saa arvutada, siis on väärtus NULL/ väärtus puudub.","en": "The population coverage percentage as a decimal number without the percent sign, rounded to 2 decimal places. For example, 0.05 = coverage is 0.05%; 50.00 = coverage is 50%. If the coverage cannot be calculated, the value is NULL/missing."}}, 
 {"id":176,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_agegroup","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":177,"schemaname":"covid19_old","table":"opendata_covid19_avg_age_by_result","column":"ResultDate","type":"column","datatype":"date","description":{"et": "Testide analüüsitulemuse kuupäev ISO 8601 standardi vormingus koos ajavööndiga.","en": "The date of the test result in ISO 8601 standard format including the time zone."}}, 
 {"id":178,"schemaname":"covid19_old","table":"opendata_covid19_avg_age_by_result","column":"Gender","type":"column","datatype":"character varying(2)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub. M = mees, N = naine.","en": "The patient''s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: M = male, N = female."}}, 
 {"id":179,"schemaname":"covid19_old","table":"opendata_covid19_avg_age_by_result","column":"ResultValue","type":"column","datatype":"character varying(2)","description":{"et": "SARS-CoV-2 analüüsitulemuse vastus, Võimalikud väärtused on: N - negatiivne, P - positiivne. Väljastatakse esmaseid positiivseid teste ning kõiki negatiivseid teste.","en": "SARS-CoV-2 analysis result response. Possible values are: N - negative, P - positive. Primary positive tests and all negative tests are reported."}}, 
 {"id":180,"schemaname":"covid19_old","table":"opendata_covid19_avg_age_by_result","column":"AverageAge","type":"column","datatype":"integer","description":{"et": "Testitud patsientide keskmine vanus.","en": "The average age of tested patients."}}, 
 {"id":181,"schemaname":"covid19_old","table":"opendata_covid19_avg_age_by_result","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":182,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"LastStatisticsDate","type":"column","datatype":"date","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus, kõigil ridadel on sama väärtus.","en": "The last update date of the data in ISO 8601 standard format, with the same value for all rows."}}, 
 {"id":183,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":184,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"Country","type":"column","datatype":"character varying(64)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik. Võimalikud väärtused on Eesti, tundmatu, välismaa.","en": "Patient''s country of residence according to the population registry. Possible values are: Eesti = Estonia; Tundmatu = Unknown; Välismaa = Foreign country."}}, 
 {"id":185,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"CountryEHAK","type":"column","datatype":"character(3)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile https://www.iso.org/obp/ui/#iso:code:3166:EE. Andmestikus alati 233.","en": "The numerical code for the patient''s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country''s code is always 233, which corresponds to Estonia."}}, 
 {"id":186,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"County","type":"column","datatype":"character varying(256)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "Patient''s county of residence according to the population registry. Value NULL/missing indicates unknown residence."}}, 
 {"id":187,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"CountyEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients''s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":188,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"Commune","type":"column","datatype":"character varying(256)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha haldusüksus (vald või linn haldusüksuse tasemel). Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "Patient''s administrative unit (municipality or city) of residence according to the population registry. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":189,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"CommuneEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha haldusüksuse (valla, linna haldusüksuse tasemel) Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient''s administrative unit (municipality or city) of residence according to the population registry. The code can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":190,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"Village","type":"column","datatype":"character varying(256)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha asustusüksus (küla, vallasisene linn või linnaosa). Avaldatakse vaid valitud asustusüksuste lõikes (haldusüksuse Tallinna linn kõik linnaosad; haldusüksuse Pärnu linn sisene Pärnu linn; haldusüksuse Tartu linn sisene Tartu linn; Kuressaare linn). Väärtus NULL/ väärtuse puudumise korral on elukoht asustusüksuse tasemel teadmata.","en": "Patient''s settlement unit (village, intra-municipal town, or city district) of residence according to the population registry. It is only disclosed for selected settlement units, such as all city districts within the administrative unit of Tallinn, the intra-municipal town of Pärnu within its administrative unit, the intra-municipal town of Tartu within its administrative unit, and Kuressaare city. If the value is NULL or unavailable, it indicates that the residence at the settlement unit level is unknown."}}, 
 {"id":191,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"VillageEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse asustusüksuse (küla, vallasisese linna või linnaosa) Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Avaldatakse vaid valitud asustusüksuste lõikes (haldusüksuse Tallinna linn kõik linnaosad; haldusüksuse Pärnu linn sisene Pärnu linn; haldusüksuse Tartu linn sisene Tartu linn; Kuressaare linn). Väärtus NULL/ väärtuse puudumise korral on elukoht asustusüksuse tasemel teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient''s settlement unit (village, intra-municipal town, or city district) of residence according to the population registry. The EHAK code for the settlement unit can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. It is only disclosed for selected settlement units, such as all city districts within the administrative unit of Tallinn, the intra-municipal town of Pärnu within its administrative unit, the intra-municipal town of Tartu within its administrative unit, and Kuressaare city. If the value is NULL or unavailable, it indicates that the residence at the settlement unit level is unknown."}}, 
 {"id":192,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"LocationEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Täpseima määratud haldusjaotuse taseme EHAK kood, st VillageEHAK või CommuneEHAK väärtus.","en": "The EHAK code of the most detailed specified administrative division level, i.e., the value of VillageEHAK or CommuneEHAK."}}, 
 {"id":193,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Haldus- või asustusüksuse elanike arv Statistikaameti andmetel seisuga 01.01.2020 (aruanne RV0291U).","en": "The population of the administrative or settlement unit according to Statistics Estonia data as of January 1, 2020 (report RV0291U)."}}, 
 {"id":194,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"LocationArea","type":"column","datatype":"double precision","description":{"et": "Haldus- või asustusüksuse pindala ruutkilomeetrites (km2)  kahe komakoha tüpsusega Statistikaameti andmetel seisuga 01.01.2020 (aruanne RV0291U).","en": "The area of the administrative or settlement unit in square kilometers (km2) with two decimal places precision according to Statistics Estonia data as of January 1, 2020 (report RV0291U)."}}, 
 {"id":195,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"LocationDensity","type":"column","datatype":"double precision","description":{"et": "Haldus- või asustusüksuse asustustihedus (elanikku km² kohta) viie komakoha täpsusega Statistikaameti andmetel seisuga 01.01.2020 (aruanne RV0291U).","en": "The population density of the administrative or settlement unit (number of inhabitants per square kilometer) with five decimal places precision according to Statistics Estonia data as of January 1, 2020 (report RV0291U)."}}, 
 {"id":196,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"ResultValue","type":"column","datatype":"character varying(2)","description":{"et": "SARS-CoV-2 analüüsitulemuse vastus, Võimalikud väärtused on: N - negatiivne, P - positiivne. Väljastatakse esmaseid positiivseid teste ning kõiki negatiivseid teste.","en": "SARS-CoV-2 analysis result response. Possible values are: N - negative, P - positive. Primary positive tests and all negative tests are reported."}}, 
 {"id":197,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"TotalCasesRange","type":"column","datatype":"character varying(30)","description":{"et": "Esmakordsete testide arvu vahemik 10 kaupa. Vahemik näitab testide arvu kokku statistika kuupäevaks (StatisticsDate).","en": "The range of the number of initial tests in increments of 10. The range represents the total number of tests up to the statistics date (StatisticsDate)."}}, 
 {"id":198,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"TotalCasesFrom","type":"column","datatype":"integer","description":{"et": "Esmakordsete testide arvu vahemiku alumine piir.","en": "The lower limit of the range of the number of initial tests."}}, 
 {"id":199,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"TotalCasesTo","type":"column","datatype":"integer","description":{"et": "Esmakordsete testide arvu vahemiku ülemine piir.","en": "The upper limit of the range of the number of initial tests."}}, 
 {"id":200,"schemaname":"covid19_old","table":"opendata_covid19_test_location","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":201,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":"LastStatisticsDate","type":"column","datatype":"date","description":{"et": "Andmete viimase uuendamise kuupäev ISO 8601 standardi vormingus, kõigil ridadel on sama väärtus.","en": "The last update date of the data in ISO 8601 standard format, with the same value for all rows."}}, 
 {"id":202,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":203,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":"DailyCases","type":"column","datatype":"integer","description":{"et": "Esmakordsete positiivsete testide arv päevas. Haigusjuhtumite leidmisel kasutatakse metoodikat, kus leitakse iga patsiendi kohta 60-päevases ajaaknas esimene positiivne test.","en": "Number of first positive tests per day. Finding cases follows a methodology where the first positive test within a 60-day timeframe is identified for each patient."}}, 
 {"id":204,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":"TotalCases","type":"column","datatype":"integer","description":{"et": "Esmakordsete positiivsete testide arv kokku statistika kuupäevaks.","en": "Total count of initial positive tests as of the statistics date."}}, 
 {"id":205,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":"TotalCasesLast14D","type":"column","datatype":"integer","description":{"et": "Esmakordsete positiivsete testide arv kokku viimase 14 päeva jooksul, käesolev päev kaasa arvatud.","en": "Total count of initial positive tests in the last 14 days, including the current day."}}, 
 {"id":206,"schemaname":"covid19_old","table":"opendata_covid19_tests_total","column":"PerPopulation","type":"column","datatype":"double precision","description":{"et": "Viimase 14 päeva positiivsete testide suhtarv 100 000 elaniku kohta, ümardatud 2 komakohani. Arvutatakse järgmise valemi alusel: 14 päeva positiivsete esmakordsete testide arv*100000/ 1328976 (Eesti elanike arv).","en": "Ratio of positive tests in the last 14 days per 100,000 population, rounded to 2 decimal places. It is calculated based on the following formula: number of positive first-time tests in the past 14 days * 100,000 / 1,328,976 (population of Estonia)."}}, 
 {"id":207,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"StatisticsDate","type":"column","datatype":"character varying(50)","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":208,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad publitseerimiskeskusest https://pub.e-tervis.ee/classifications/Vaktsiinv%C3%A4lditavad%20haigused%20ja%20haigustekitajad.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the publication center: https://pub.e-tervis.ee/classifications/Vaccine-preventable%20diseases%20and%20pathogens."}}, 
 {"id":209,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":210,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"ProviderServiceTypeCode","type":"column","datatype":"integer","description":{"et": "Tervishoiuteenuse osutaja tüübi kood: 10= Hospital - Haigla, 20= Family healthcare - Perearstiabi, 25= Specialised healthcare - Eriarstiabi, 30= Dental care - Hambaravi, 40= Ambulance - Kiirabi, 50= Rehabilitation - Taastusravi, 51= Diagnostics - Diagnostika, 53= Nursing care - Õendusabi, 99= General practitioner, except family physician - Üldarst, v.a perearst. NULL/ puudub, kui tüüp ei ole teada.","en": "Healthcare service provider type code: 10 = Hospital, 20 = Family healthcare, 25 = Specialised healthcare, 30 = Dental care, 40 = Ambulance, 50 = Rehabilitation, 51 = Diagnostics, 53 = Nursing care, 99 = General practitioner, except family physician. NULL/missing if the type is unknown."}}, 
 {"id":211,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"ProviderServiceType","type":"column","datatype":"character varying(50)","description":{"et": "Tervishoiuteenuse osutaja tüüp: Hospital - Haigla, Family healthcare - Perearstiabi, Specialised healthcare - Eriarstiabi, Dental care - Hambaravi, Ambulance - Kiirabi, Rehabilitation - Taastusravi, Diagnostics - Diagnostika, Nursing care - Õendusabi, General practitioner, except family physician - Üldarst, v.a perearst. NULL/ puudub, kui tüüp ei ole teada.","en": "Healthcare service provider type: Hospital, Family healthcare, Specialised healthcare, Dental care, Ambulance, Rehabilitation, Diagnostics, Nursing care, General practitioner, except family physician. NULL/missing if the type is unknown."}}, 
 {"id":212,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":213,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":214,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_providertype_doses","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":215,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"StatisticsDate","type":"column","datatype":"character varying(50)","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = ''2021-11-03'' puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = ''2021-11-03'', the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":216,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"TargetDiseaseCode","type":"column","datatype":"integer","description":{"et": "Vaktsiinvälditava haiguse klassifikaatorijärgne kood, mille vastu vaktsineeritakse (219 = COVID-19). Vaktsiinvälditavate haiguste ja haigustekitajate klassifikaatorid on leitavad publitseerimiskeskusest https://pub.e-tervis.ee/classifications/Vaktsiinv%C3%A4lditavad%20haigused%20ja%20haigustekitajad.","en": "Vaccine-preventable disease classifier code for the vaccine administered (219 = COVID-19). Vaccine-preventable diseases and pathogens classifiers can be found at the publication center: https://pub.e-tervis.ee/classifications/Vaccine-preventable%20diseases%20and%20pathogens."}}, 
 {"id":217,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimi, mille vastu vaktsineeritakse (COVID-19).","en": "The name of the vaccine-preventable disease being vaccinated against (COVID-19)."}}, 
 {"id":218,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"VaccinationSeries","type":"column","datatype":"integer","description":{"et": "Vaktsineerimiskuur, kus 1 = tavapärane esmane vaktsineerimine; >1 lisa- või tõhustusdoosidega vaktsineerimine. VaccinationSeries = 1 väärtuseks loetakse esmane läbiviidud vaktsineerimine. Selle hulka võib kuuluda tavapärase vaktsineerimise käigus 2 doosi 2-doosilisest vaktsiinist või 1 doos 1-doosilisest vaktsiinist või 1 doos 2-doosilisest vaktsiinist kombinatsioonis läbipõdemisega. VaccinationSeries = 2 alla loetakse esimese lisa- ja tõhustusdoosiga vaktsineerimine. VaccinationSeries = n alla loetakse n-1 lisa- ja tõhustusdoosiga vaktsineerimised.","en": "Vaccination course, where 1 denotes the regular primary vaccination, and >1 indicates additional or booster doses. For VaccinationSeries = 1, it is considered as the completion of the primary vaccination. This may include receiving 2 doses in the case of a two-dose vaccine, or 1 dose for a single-dose vaccine, or 1 dose in combination with a previous infection (for a two-dose vaccine). For VaccinationSeries = 2, it represents the first additional or booster dose vaccination. For VaccinationSeries = n, where n > 2, it represents the administration of n-1 additional or booster doses."}}, 
 {"id":219,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"MeasurementType","type":"column","datatype":"character varying(50)","description":{"et": "Mõõdik näitab, mille kohta konkreetse päeva agregeeritud näitajad käivad. Võimalikud väärtused on Vaccinated, FullyVaccinated ja DosesAdministered. Vaccinated alla loetakse kõik inimesed, kes on saanud vähemalt 1 doosi vaktsiini. FullyVaccinated alla loetakse inimesed, kes on vaktsineerimiskuuri nõuetekohaselt lõpetanud (saanud vastavalt kas esimeses kuuris 2 doosi 2-doosilisest vaktsiinist, 1 doosi 1-doosilisest vaktsiinist või 1 doosi ja haiguse läbi põdenud). DosesAdministered alla loetakse mitte inimesi vaid manustatud süste antud vaktsineerimiskuuri lõikes.","en": "This metric indicates the category to which the aggregated statistics of a specific day belong. The possible values are Vaccinated, FullyVaccinated, and DosesAdministered. Vaccinated includes all individuals who have received at least 1 dose of the vaccine. FullyVaccinated includes individuals who have properly completed the vaccination course (received either 2 doses in the course of a 2-dose vaccine, 1 dose of a single-dose vaccine, or 1 dose and have had the disease). DosesAdministered refers to the number of administered doses according to the vaccination course, not the number of individuals."}}, 
 {"id":220,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"LocationPopulation","type":"column","datatype":"integer","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 01. jaanuar, mis vastab StatisticsDate väärtuses olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The population count by location, age, and/or gender as of January 1st, corresponding to the year specified in the StatisticsDate value. The population count is sourced from the report RV0240 by Statistics Estonia. In case of unknown gender, the value is NULL/missing."}}, 
 {"id":221,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"DailyCount","type":"column","datatype":"integer","description":{"et": "Statistika kuupäeval lisandunute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":222,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"TotalCount","type":"column","datatype":"integer","description":{"et": "Jooksev kumulatiivne summa (kõigi eelnevate päevade ja sama päeva DailyCount jooksev summa).","en": "The current cumulative sum (the running total of all previous days and the DailyCount of the same day)."}}, 
 {"id":223,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"PopulationCoverage","type":"column","datatype":"integer","description":{"et": "Elanikkonna hõlmatuse protsentnäit reaalarvuna ilma protsendi märgita, ümardatud 2 komakohani. Näiteks 0,05= hõlmatus on 0.05%; 50.00= hõlmatus on 50%. Kui hõlmatust ei saa arvutada, siis on väärtus NULL/ väärtus puudub.","en": "The population coverage percentage as a decimal number without the percent sign, rounded to 2 decimal places. For example, 0.05 = coverage is 0.05%; 50.00 = coverage is 50%. If the coverage cannot be calculated, the value is NULL/missing."}}, 
 {"id":224,"schemaname":"covid19_old","table":"opendata_covid19_vaccination_total","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":225,"schemaname":"vaccination","table":"metadata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":226,"schemaname":"vaccination","table":"metadata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":227,"schemaname":"vaccination","table":"metadata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":228,"schemaname":"vaccination","table":"metadata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":229,"schemaname":"vaccination","table":"metadata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":230,"schemaname":"vaccination","table":"metadata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":231,"schemaname":"vaccination","table":"metadata","column":"description","type":"column","datatype":"json","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":232,"schemaname":"vaccination","table":"metadata_odata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":233,"schemaname":"vaccination","table":"metadata_odata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":234,"schemaname":"vaccination","table":"metadata_odata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":235,"schemaname":"vaccination","table":"metadata_odata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":236,"schemaname":"vaccination","table":"metadata_odata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":237,"schemaname":"vaccination","table":"metadata_odata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":238,"schemaname":"vaccination","table":"metadata_odata","column":"description","type":"column","datatype":"character varying(2000)","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":239,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":240,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"VaccineAbbreviation","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiini tähis Eesti immuniseerimiskavas ja/või avaandmetes.","en": "Vaccine abbreviation in the Estonian Immunization Schedule and/or open data."}}, 
 {"id":241,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"TargetDiseaseCode","type":"column","datatype":"character varying(5)","description":{"et": "Vaktsiinvälditava haiguse kood klassifikaatori järgi (klassifikaator https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused).","en": "Vaccine-preventable disease code according to the classification (https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused)."}}, 
 {"id":242,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"AgeGroup","type":"column","datatype":"character varying(20)","description":{"et": "Patsiendi vanusegrupp. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud aasta 1. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupi võimalikud väärtused on 0,1,2,3,7,8,12,13,14, 16, 18, 18+, 19-26.","en": "The patient`s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the year, representing the age the person had at the beginning of the year. Possible values are 0,1,2,3,7,8,12,13,14, 16, 18, 18+, 19-26."}}, 
 {"id":243,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"Gender","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada) HPV korral. Väärtused on Male - mees, Female - naine, Total - kõik sood kokku, Unknown - sugu teadmata.","en": "The patient`s gender according to the population registry data (if known) in case of HPV. Values ​​are Male - male, Female - female, Total - all genders combined, Unknown - gender unknown."}}, 
 {"id":244,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"OpendataVaccinationVaccineAbbrPopulationLocationCoverage","type":"column","datatype":"character varying(5)","description":{"et": "Tingimus, kas vaktsiini tähis kehtib vaktsineerimise hõlmatuse andmestiku korral. Väärtused kehtib=TRUE, ei kehti=FALSE.","en": "Condition whether the vaccine abbreviation is valid for the vaccination coverage dataset. Values ​​Valid=TRUE, Invalid=FALSE."}}, 
 {"id":245,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"OpendataVaccinationVaccineAbbrEnrollmentCoverage","type":"column","datatype":"character varying(5)","description":{"et": "Tingimus, kas vaktsiini tähis kehtib nimistute vaktsineerimise hõlmatuse andmestiku korral. Väärtused kehtib=TRUE, ei kehti=FALSE.","en": "Condition whether the vaccine abbreviation is valid for the enrollment vaccination coverage dataset. Values ​​Valid=TRUE, Invalid=FALSE."}}, 
 {"id":246,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"VaccineAbbreviationsDescriptionEst","type":"column","datatype":"character varying(500)","description":{"et": "Vaktsiini tähise kirjeldus eesti keeles.","en": "Description of the vaccine abbreviation in Estonian."}}, 
 {"id":247,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"VaccineAbbreviationsDescriptionEng","type":"column","datatype":"character varying(500)","description":{"et": "Vaktsiini tähise kirjeldus inglise keeles.","en": "Description of the vaccine abbreviation in English."}}, 
 {"id":248,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":249,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_description","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":{"et": "Andmete muutmise aeg.","en": "Data modification time."}}, 
 {"id":250,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":251,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"TargetDiseaseCode","type":"column","datatype":"character varying(5)","description":{"et": "Vaktsiinvälditava haiguse kood klassifikaatori järgi (klassifikaator https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused).","en": "Vaccine-preventable disease code according to the classification (https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused)."}}, 
 {"id":252,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimetus klassifikaatori järgi (klassifikaator https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused).","en": "Vaccine-preventable disease name according to the classification (https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused)."}}, 
 {"id":253,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"VaccinationType","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsineerimise tüüp (filter). Võimalikud väärtused on Vaccination või Revaccination ehk vaktsineerimine või revaktsineerimine.","en": "Vaccination type (filter). Possible values ​​are Vaccination or Revaccination."}}, 
 {"id":254,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"VaccinationDate","type":"column","datatype":"date","description":{"et": "Vaktsineerimise kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks VaccinationDate = 2021-11-03 puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Vaccination date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for VaccinationDate = 2021-11-03, the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":255,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"PatientCounty","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus Unknown korral on elukoha maakond teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "The patient`s county of residence according to the population register. If the value is Unknown, the county of residence is unknown (foreigners or persons for whom there is no entry in the population register)."}}, 
 {"id":256,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"PatientCountyEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Unknow ehk väärtuse puudumise korral on maakond teadmata.","en": "County code of the patient`s place of residence according to the population register, or EHAK code https://klassifikatorid.stat.ee/. Unknown is no value, the county is unknown."}}, 
 {"id":257,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"AgeGroupFilter","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanusegrupi filter, mis aitab tekitada eri vanusegruppe. Võimalikud väärtused on AgeGroup1/AgeGroup2. Kasutades patsiendi vanusegrupi filtrit väärtusega AgeGroup1 ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 0-7, 8-19, 20-59, 60+. Kasutades patsiendi vanusegrupi filtrit väärtusega AgeGroup2 ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 0-6, 7-18, 19+. Unknown väärtuse korral on vanusegrupp teadmata.","en": "Patient`s age group filter, which helps to create different age groups. Possible values ​​are AgeGroup1/AgeGroup2. Using patient age group filter AgeGroup1 with value No and patient age group, they can be used to select age groups 5-14, 15-19, 20-49, 50-64, 65-79. Using patient age group AgeGroup2 with value Yes and patient age group, they can be used to select age groups 0-4, 5-11, 12-15, 16-17, 18-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80+. If the value is Unknown, the age group is unknown."}}, 
 {"id":258,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"Agegroup","type":"column","datatype":"character varying(20)","description":{"et": "Patsiendi vanusegrupp. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud aasta 1. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupp on kirjeldatud väärtustes X-Y, kus vanus on X <= vanus <= Y vahemikus, va viimase vanusegrupi juures, kus X+ tähendab, et vanus >= X.","en": "The patient`s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the year, representing the age the person had at the beginning of the year. The age groups are described in the format X-Y, where the age falls within the range X <= age <= Y, except for the last age group, where X+ indicates that the age is greater than or equal to X."}}, 
 {"id":259,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"Gender","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada) HPV korral. Väärtused on Male - mees, Female - naine, Total - kõik sood kokku, Unknown - sugu teadmata.","en": "The patient`s gender according to the population registry data (if known) in case of HPV. Values ​​are Male - male, Female - female, Total - all genders combined, Unknown - gender unknown."}}, 
 {"id":260,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"VaccinatedPersonsCountPerYear","type":"column","datatype":"bigint","description":{"et": "Jooksva aasta kumulatiivne vaktsineeritute summa (kõigi eelnevate päevade ja sama päeva jooksev summa).","en": "Cumulative sum of vaccinated persons for the current year (currant sum of all previous days and the same day)."}}, 
 {"id":261,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"DosesAdministered","type":"column","datatype":"bigint","description":{"et": "Vaktsineerimise kuupäeval lisandunud dooside arv.","en": "The number of doses added on the vaccination date."}}, 
 {"id":262,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":263,"schemaname":"vaccination","table":"opendata_vaccination_county_agegroup_gender","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}, 
 {"id":264,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":265,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"VaccineAbbreviation","type":"column","datatype":"character varying(20)","description":{"et": "Vaktsiini tähis Eesti immuniseerimiskavas ja/või avaandmetes. Kirjeldus asub andmestikus nimega opendata_vaccination_vaccine_abbr_description. Eesti immuniseerimiskava https://vaktsineeri.ee/et/haigused-ja-vaktsiinid/vaktsiinid/riiklik-immuniseerimiskava.","en": "Vaccine abbreviation in the Estonian Immunization Schedule and/or open data. The description is located at opendata_vaccination_vaccine_abbr_description. Estonian Vaccination Schedule https://vaktsineeri.ee/et/haigused-ja-vaktsiinid/vaktsiinid/riiklik-immuniseerimiskava."}}, 
 {"id":266,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"TargetDisease","type":"column","datatype":"character varying(50)","description":{"et": "Vaktsiinvälditava haiguse nimetus klassifikaatori järgi (klassifikaator https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused).","en": "Vaccine-preventable disease name according to the classification (https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused)."}}, 
 {"id":267,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"TargetDiseaseCode","type":"column","datatype":"character varying(10)","description":{"et": "Vaktsiinvälditava haiguse kood klassifikaatori järgi (klassifikaator https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused).","en": "Vaccine-preventable disease code according to the classification (https://teabekeskus.tehik.ee/et/loendid/vaktsiinvalditavad-haigused)."}}, 
 {"id":268,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"AgeGroup","type":"column","datatype":"character varying(20)","description":{"et": "Patsiendi vanusegrupp. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud aasta 1. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupi võimalikud väärtused on 0, 1, 2, 3, 7, 8, 12, 13, 14, 16, 18, 18+, 19-26.","en": "The patient`s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the year, representing the age the person had at the beginning of the year. Possible values are 0, 1, 2, 3, 7, 8, 12, 13, 14, 16, 18, 18+, 19-26."}}, 
 {"id":269,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"Gender","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada) HPV korral. Väärtused on Male - mees, Female - naine, Total - kõik sood kokku, Unknown - sugu teadmata.","en": "The patient`s gender according to the population registry data (if known) in case of HPV. Values ​​are Male - male, Female - female, Total - all genders combined, Unknown - gender unknown."}}, 
 {"id":270,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"InScheduler","type":"column","datatype":"character varying(10)","description":{"et": "Tunnus väärtustega Jah(Yes )/Ei (No). Valides vaktsiini tähise, vanusegrupi ja väärtuse Yes, siis selle valiku korral saadakse Eesti immuniseerimiskavva kuuluvad vaktsineerimised. Valides vaktsiini tähise, vanusegrupi ja tunnuse väärtusega No, siis on tulemuseks Eesti vaktsineerimiskava väline vaktsineerimine.","en": "A feature with values ​​Yes/No. By selecting the vaccine symbol, age group and value Yes, this selection will result in vaccinations included in the Estonian Immunization Schedule. By selecting the vaccine symbol, age group and feature with value No, the result will be vaccinations outside the Estonian Vaccination Schedule."}}, 
 {"id":271,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"PatientCounty","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus Unknown korral on elukoha maakond teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "The patient`s county of residence according to the population register. If the value is Unknown, the county of residence is unknown (foreigners or persons for whom there is no entry in the population register)."}}, 
 {"id":272,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"PatientCountyEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Unknow ehk väärtuse puudumise korral on maakond teadmata.","en": "County code of the patient`s place of residence according to the population register, or EHAK code https://klassifikatorid.stat.ee/. If the value is Unknown, the county of residence is unknown."}}, 
 {"id":273,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"PatientCommune","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha haldusüksus. Võimalikud väärtused on Tallinn, Tartu linn, Narva linn.","en": "Patient`s administrative unit (municipality or city) of residence according to the population registry. Possible values ​​are Tallinn, Tartu city, Narva city."}}, 
 {"id":274,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"PatientCommuneEHAK","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha haldusüksuse Talllinn, Tartu linn, Narva linn Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient`s administrative unit Tallinn, Tartu linn, Narva linn of residence according to the population registry. The code can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/."}}, 
 {"id":275,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"LocationLevel","type":"column","datatype":"character varying(50)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - valikus ainult Tallinn, Tartu linn, Narva linn. Maakond Unknown väärtuste korral on maakond teadmata.","en": "In location data, LocationLevel describes the level of administrative division for which the data is valid: County - county, Commune - only Tallinn, Tartu city, Narva city are in the selection. If the value is Unknow, the county is unknown."}}, 
 {"id":276,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"TotalVaccinationCount","type":"column","datatype":"bigint","description":{"et": "Aasta kumulatiivne vaktsineeritute summa.","en": "Cumulative number of vaccinated people per year."}}, 
 {"id":277,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"LocationPopulation","type":"column","datatype":"bigint","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 1. jaanuar, mis vastab CoverageYear olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240.","en": "The number of inhabitants by location, age and/or gender as of January 1, which corresponds to the year in CoverageYear. The source of the number of inhabitants is Statistics Estonias` report RV0240."}}, 
 {"id":278,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"CoverageYear","type":"column","datatype":"bigint","description":{"et": "Vaktsineerimise ja haldusüksuse rahvarvu aluseks olev aasta.","en": "The year on which vaccination and the population of the administrative unit are based."}}, 
 {"id":279,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":280,"schemaname":"vaccination","table":"opendata_vaccination_vaccine_abbr_population_location_coverage","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":{"et": "Andmete muutmise aeg.","en": "Data modification time."}}, 
 {"id":281,"schemaname":"covid19","table":"metadata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":282,"schemaname":"covid19","table":"metadata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":283,"schemaname":"covid19","table":"metadata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":284,"schemaname":"covid19","table":"metadata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":285,"schemaname":"covid19","table":"metadata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":286,"schemaname":"covid19","table":"metadata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":287,"schemaname":"covid19","table":"metadata","column":"description","type":"column","datatype":"json","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":288,"schemaname":"covid19","table":"metadata_odata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":289,"schemaname":"covid19","table":"metadata_odata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":290,"schemaname":"covid19","table":"metadata_odata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":291,"schemaname":"covid19","table":"metadata_odata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":292,"schemaname":"covid19","table":"metadata_odata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":293,"schemaname":"covid19","table":"metadata_odata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":294,"schemaname":"covid19","table":"metadata_odata","column":"description","type":"column","datatype":"character varying(2000)","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":295,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":296,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = 2021-11-03 puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = 2021-11-03, the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":297,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"VaccinationSeason","type":"column","datatype":"character varying(20)","description":{"et": "Covid-19 hooaeg vastavalt Terviseameti definitsioonile.","en": "Covid-19 season according to the definition of the Health Board."}}, 
 {"id":298,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"PatientCountry","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik, mis on andmestikus alati Eesti.","en": "Patient`s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":299,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"PatientCountryEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient`s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country`s code is always 233, which corresponds to Estonia."}}, 
 {"id":300,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"PatientCounty","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoha maakond teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "The patient`s county of residence according to the population register. The value is NULL/ if there is no value, the county of residence is unknown (foreigners or persons for whom there is no entry in the population register)."}}, 
 {"id":301,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"PatientCountyEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna  kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on maakond teadmata.","en": "County code of the patient`s place of residence according to the population register, or EHAK code https://klassifikatorid.stat.ee/. NULL/ if there is no value, the county is unknown."}}, 
 {"id":302,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"AgeGroup","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi vanusegrupp. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupid on kirjeldatud väärtustes X-Y, kus vanus on X <= vanus <= Y vahemikus, va viimase vanusegrupi juures, kus X+ tähendab, et vanus >= X.","en": "The patient`s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format X-Y, where the age falls within the range X <= age <= Y, except for the last age group, where X+ indicates that the age is greater than or equal to X."}}, 
 {"id":303,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"RiskGroupPopulation","type":"column","datatype":"bigint","description":{"et": "Riskirühma suurus.","en": "The size of the risk group."}}, 
 {"id":304,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"DailyCount","type":"column","datatype":"bigint","description":{"et": "Statistika kuupäeval lisandunud vaktsineeritute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":305,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"TotalCount","type":"column","datatype":"bigint","description":{"et": "Jooksev hooaja kumulatiivne  vaktsineeritute summa (kõigi eelnevate päevade ja sama päeva jooksev summa).","en": "Cumulative amount of vaccinated people of the current season (current sum of all previous days and the same day)."}}, 
 {"id":306,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":307,"schemaname":"covid19","table":"opendata_covid19_riskgroup_vaccination_season_location_agegroup","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}, 
 {"id":308,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":309,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"StatisticsWeek","type":"column","datatype":"date","description":{"et": "Statistika nädal, mille kohta andmed kehtivad.","en": "Statistics week to which the data applies."}}, 
 {"id":310,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"AgeGroup","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi vanusegruppi kuuluvus esmase haiglasse sissekirjutamise hetkel. Võimalikud väärtused on 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+.","en": "Patient`s age group at the time of their initial hospital admission. Possible values are 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+."}}, 
 {"id":311,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"BedProfile","type":"column","datatype":"character varying(10)","description":{"et": "Voodiprofiili tunnus. Võimalikud väärtused IRO/NOT IRO. IRO = intensiivravis, NOT IRO = ei ole intensiivravis. ","en": "Bed profile feature. Value IRO/NOT IRO. IRO = intensive care, NOT IRO = not in intensive case."}}, 
 {"id":312,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"HospitalizationCount","type":"column","datatype":"bigint","description":{"et": "Unikaalsete patsientide arv, kes statistika nädalal haiglas viibisid.","en": "The number of unique patients who stayed in the hospital during the statistics week."}}, 
 {"id":313,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":314,"schemaname":"covid19","table":"opendata_covid19_hospitalization","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}, 
 {"id":315,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":316,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = 2021-11-03 puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = 2021-11-03, the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":317,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"VaccinationSeason","type":"column","datatype":"character varying(20)","description":{"et": "Covid-19 hooaeg vastavalt Terviseameti definitsioonile.","en": "Covid-19 season according to the definition of the Health Board."}}, 
 {"id":318,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"Vaccine","type":"column","datatype":"character varying(255)","description":{"et": "Vaktsiini nimetus.","en": "The name of the vaccine."}}, 
 {"id":319,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"VaccinationGroup","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi vanusegrupp vaktsiinide kasutamise vaatest. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupid on kirjeldatud väärtustes X-Y, kus vanus on X <= vanus <= Y vahemikus, va viimase vanuserühma juures, kus X+ tähendab, et vanus >= X.","en": "Patient age group from the perspective of vaccine use. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format X-Y, where the age falls within the range X <= age <= Y, except for the last age group, where X+ indicates that the age is greater than or equal to X."}}, 
 {"id":320,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"DailyCount","type":"column","datatype":"bigint","description":{"et": "Statistika kuupäeval lisandunud vaktsiini dooside arv.","en": "The number of vaccine doses added on the date of statistics."}}, 
 {"id":321,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":322,"schemaname":"covid19","table":"opendata_covid19_mt_daily_vaccination_vaccine_agegroup","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}, 
 {"id":323,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":324,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = 2021-11-03 puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = 2021-11-03, the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":325,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"StatisticsYear","type":"column","datatype":"bigint","description":{"et": "Statistika aasta.","en": "Statistics Year."}}, 
 {"id":326,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"AgeGroup","type":"column","datatype":"character varying(20)","description":{"et": "Patsiendi vanusegrupi kuuluvus testi tegemise hetke seisuga. Võimalikud väärtused on 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, üle 85.","en": "Patient`s age group at the time of testing. Possible values are: 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, over 85."}}, 
 {"id":327,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"Gender","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub: Male - mees, Female - naine.","en": "The patient`s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: Male: The patient is male; Female: The patient is female."}}, 
 {"id":328,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"Country","type":"column","datatype":"character varying(20)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik. Võimalikud väärtused on Eesti, tundmatu, välismaa.","en": "Patient`s country of residence according to the population registry. Possible values are: Eesti = Estonia; Tundmatu = Unknown; Välismaa = Foreign country."}}, 
 {"id":329,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"CountryEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile https://www.iso.org/obp/ui/#iso:code:3166:EE. Andmestikus alati 233.","en": "The numerical code for the patient`s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country`s code is always 233, which corresponds to Estonia."}}, 
 {"id":330,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"County","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "Patient`s county of residence according to the population registry. Value NULL/missing indicates unknown residence."}}, 
 {"id":331,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"CountyEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna klassifikaatori Eesti haldus- ja asustusjaotus järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on elukoht teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patients`s county of residence according to the population registry. The code can be found at the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence is unknown."}}, 
 {"id":332,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"Population","type":"column","datatype":"bigint","description":{"et": "Haldusüksuse rahvaarv Statistikaameti andmetel (aruanne RV0240).","en": "The population of the administrative  unit according to Statistics Estonia (report RV0240)."}}, 
 {"id":333,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"PopulationYear","type":"column","datatype":"bigint","description":{"et": "Haldusüksuse rahvarvu aluseks olev aasta.","en": "The year on which the population of the administrative unit is based."}}, 
 {"id":334,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"DailyCount","type":"column","datatype":"bigint","description":{"et": "Nakkusjuhtumite arv päevas. Kui nakatumine on diagnoositud laboratoorselt, siis nakkusjuhtumite leidmisel kasutatakse metoodikat, kus leitakse iga patsiendi kohta 60-päevases ajaaknas esimene positiivne test.","en": "Number of infection cases per day. If the infection has been diagnosed in a laboratory, then finding cases follows a methodology where the first positive test within a 60-day timeframe is identified for each patient."}}, 
 {"id":335,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"TotalCountLast7D","type":"column","datatype":"bigint","description":{"et": "Nakkusjuhtude arv kokku viimase 7 päeva jooksul, käesolev päev kaasa arvatud.","en": "Total count of infection cases in the last 7 days, including the current day."}}, 
 {"id":336,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"TotalCountLast14D","type":"column","datatype":"bigint","description":{"et": "Nakkusjuhtude arv kokku viimase 14 päeva jooksul, käesolev päev kaasa arvatud.","en": "Total count of infection cases in the last 14 days, including the current day."}}, 
 {"id":337,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"TotalCount","type":"column","datatype":"bigint","description":{"et": "Nakkusjuhtude arv kokku statistika kuupäevaks.","en": "Total count of infection cases as of the statistics date."}}, 
 {"id":338,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":339,"schemaname":"covid19","table":"opendata_covid19_infections_county_agegroup_gender","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}, 
 {"id":340,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":341,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev. Andmed kehtivad märgitud kuupäeval 07:00:00 kuni järgmisel päeval 06:59:59. Näiteks StatisticsDate = 2021-11-03 puhul kajastatakse andmeid, mis on laekunud vahemikus 2021-11-03 kell 07:00:00 kuni 2021-11-04 kell 06:59:59.","en": "Statistics date. The data is valid for the specified date from 07:00:00 until the next day at 06:59:59. For example, for StatisticsDate = 2021-11-03, the data reflects information received between 07:00:00 on 2021-11-03 and 06:59:59 on 2021-11-04."}}, 
 {"id":342,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"VaccinationSeason","type":"column","datatype":"character varying(20)","description":{"et": "Covid-19 hooaeg vastavalt Terviseameti definitsioonile.","en": "Covid-19 season according to the definition of the Health Board."}}, 
 {"id":343,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationLevel","type":"column","datatype":"character varying(50)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - haldusüksus (vald, linn haldusüksuse tasemel), Village - asustusüksus (küla, vallasisene linn või linnaosa).","en": "The LocationLevel describes the administrative division level to which the data applies: County: The data corresponds to the county level (maakond); Commune: The data corresponds to the administrative unit level, which includes municipalities and cities (vald, linn haldusüksuse tasemel); Village: The data corresponds to the settlement unit level, which includes villages, intra-municipal towns, or city districts (küla, vallasisene linn või linnaosa)."}}, 
 {"id":344,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationCountry","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik ehk alati Eesti.","en": "Patient`s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":345,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationCountryEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient`s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country`s code is always 233, which corresponds to Estonia."}}, 
 {"id":346,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationCounty","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoha maakond teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "The patient`s county of residence according to the population register. The value is NULL/ if there is no value, the county of residence is unknown (foreigners or persons for whom there is no entry in the population register)."}}, 
 {"id":347,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationCountyEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna  kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on maakond teadmata.","en": "County code of the patient`s place of residence according to the population register, or EHAK code https://klassifikatorid.stat.ee/. NULL/ if there is no value, the county is unknown."}}, 
 {"id":348,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationCommune","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha haldusüksus. Võimalikud väärtused on Tallinn, Tartu linn, Narva linn, NULL (elukoht on kõik muud asustusüksused).","en": "Patient`s administrative unit (municipality or city) of residence according to the population registry. Possible values ​​are Tallinn, Tartu city, Narva city, NULL (place of residence is all other administrative units)."}}, 
 {"id":349,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationCommuneEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha haldusüksuse kood ehk EHAK kood (https://klassifikaatorid.stat.ee/). Võimalikud väärtused on 0784 (Tallinn), 0793 (Tartu linn), 0511 (Narva linn), NULL (elukoht on kõik muud asustusüksused).","en": "Code of the administrative unit of the patient`s place of residence according to the population register, or EHAK code (https://klassifikatorid.stat.ee/). Possible values ​​are 0784 (Tallinn), 0793 (Tartu city), 0511 (Narva city), if the value is NULL, the place of residence is all other administrative units."}}, 
 {"id":350,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"AgeGroup","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi vanusegrupp. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud aasta 1. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupp on kirjeldatud väärtustes X-Y, kus vanus on X <= vanus <= Y vahemikus, va viimase vanusegrupi juures, kus X+ tähendab, et vanus >= X.","en": "The patient`s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the year, representing the age the person had at the beginning of the year. The age groups are described in the format X-Y, where the age falls within the range X <= age <= Y, except for the last age group, where X+ indicates that the age is greater than or equal to X."}}, 
 {"id":351,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"AgeGroupFilter1","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi vanusegrupi filter 1, mis aitab tekitada eri vanusegruppe. Võimalikud väärtused on No/Yes. Kasutades patsiendi vanusegrupi filtrit 1 väärtusega No ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 5-14, 15-19, 20-49, 50-64, 65-79. Kasutades patsiendi vanusegrupi filtrit 1 väärtusega Yes ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 0-4, 5-11, 12-15, 16-17, 18-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80+. NULL väärtuse  korral on vanusegrupp teadmata.","en": "Patient`s age group filter 1, which helps to create different age groups. Possible values ​​are No/Yes. Using patient age group filter 1 with value No and patient age group, they can be used to select age groups 5-14, 15-19, 20-49, 50-64, 65-79. Using patient age group filter 1 with value Yes and patient age group, they can be used to select age groups 0-4, 5-11, 12-15, 16-17, 18-29, 30-39, 40-49, 50-59, 60-69, 70-79, 80+. If the value is NULL, the age group is unknown."}}, 
 {"id":352,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"AgeGroupFilter2","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi vanusegrupi filter 2, mis aitab tekitada eri vanusegruppe. Võimalikud väärtused on No/Yes. Kasutades patsiendi vanusegrupi filtrit 2 väärtusega No ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 5-11, 12-15, 16-17, 18-29, 30-39, 40-49, 50-59, 60-69, 70-79. Kasutades patsiendi vanusegrupi filtrit 2 väärtusega Yes ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 0-4, 5-14, 15-19, 20-49, 50-64, 65-79, 80+. NULL väärtuse  korral on vanusegrupp teadmata.","en": "Patient`s age group filter 2, which helps to create different age groups. Possible values ​​are No/Yes. Using patient age group filter 2 with value No and patient age group, they can be used to select age groups 5-11, 12-15, 16-17, 18-29, 30-39, 40-49, 50-59, 60-69, 70-79. Using patient age group filter 2 with value Yes and patient age group, they can be used to select age groups 0-4, 5-14, 15-19, 20-49, 50-64, 65-79, 80+. If the value is NULL, the age group is unknown."}}, 
 {"id":353,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"Gender","type":"column","datatype":"character varying(10)","description":{"et": "Patsiendi sugu rahvastikuregistri andmetel (kui on teada). Teadmata soo korral on väärtus NULL/ väärtus puudub: Male - mees, Female - naine.","en": "The patient`s gender according to the population registry data (if known). If the gender is unknown, the value is NULL or unavailable. The possible values are: Male: The patient is male; Female: The patient is female."}}, 
 {"id":354,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"LocationPopulation","type":"column","datatype":"bigint","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 1. jaanuar, mis vastab PopulationYear olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The number of inhabitants by location, age and/or gender as of January 1, which corresponds to the year in PopulationYear. The source of the number of inhabitants is Statistics Estonia`s report RV0240. For unknown gender, the value is NULL/no value."}}, 
 {"id":355,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"PopulationYear","type":"column","datatype":"bigint","description":{"et": "Haldusüksuse rahvarvu aluseks olev aasta.","en": "The year on which the population of the administrative unit is based."}}, 
 {"id":356,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"DailyCountFullyVaccinated","type":"column","datatype":"bigint","description":{"et": "Statistika kuupäeval lisandunud täielikult vaktsineeritute arv.","en": "The number of fully vaccinated people added on the statistics date."}}, 
 {"id":357,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"TotalCountFullyVaccinated","type":"column","datatype":"bigint","description":{"et": "Jooksev hooaja kumulatiivne täielikult vaktsineeeritute summa (kõigi eelnevate päevade ja sama päeva jooksev summa).","en": "Cumulative amount of fully vaccinated people of the current season (current sum of all previous days and the same day)."}}, 
 {"id":358,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"DailyCountDoses","type":"column","datatype":"bigint","description":{"et": "Statistika kuupäeval lisandunud dooside arv.","en": "The number of doses added on the statistics date."}}, 
 {"id":359,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"TotalCountDoses","type":"column","datatype":"bigint","description":{"et": "Jooksev hooaja kumulatiivne manustatud dooside summa (kõigi eelnevate päevade ja sama päeva jooksev summa).","en": "Cumulative sum of doses administered for the current season (currant sum of all previous days and the same day)."}}, 
 {"id":360,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":361,"schemaname":"covid19","table":"opendata_covid19_vaccination_season_location_agegroup_gender","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}, 
 {"id":362,"schemaname":"flu","table":"metadata_odata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":363,"schemaname":"flu","table":"metadata_odata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":364,"schemaname":"flu","table":"metadata_odata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":365,"schemaname":"flu","table":"metadata_odata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":366,"schemaname":"flu","table":"metadata_odata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":367,"schemaname":"flu","table":"metadata_odata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":368,"schemaname":"flu","table":"metadata_odata","column":"description","type":"column","datatype":"character varying(2000)","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":369,"schemaname":"flu","table":"metadata","column":"id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":370,"schemaname":"flu","table":"metadata","column":"schemaname","type":"column","datatype":"character varying(250)","description":{"et": "Avaandmete valdkond, näiteks COVID-19 või gripp.","en": "Open data domain, for example, COVID-19 or influenza."}}, 
 {"id":371,"schemaname":"flu","table":"metadata","column":"table","type":"column","datatype":"character varying(250)","description":{"et": "Andmestiku inglisekeelne tehniline nimetus ehk API-de kaudu pakutava andmeteenuse nimetus. Identsifitseerib andmestiku andmekoosseisu.","en": "The technical name of the dataset, i.e., the name of the data service provided via APIs. Identifies the structure of the dataset."}}, 
 {"id":372,"schemaname":"flu","table":"metadata","column":"column","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja nimetus, mille kohta kirjeldus antakse.","en": "The name of the data field for which the description is provided."}}, 
 {"id":373,"schemaname":"flu","table":"metadata","column":"type","type":"column","datatype":"character varying(250)","description":{"et": "Viitab, kas kirjeldus antakse andmestiku (table) või andmevälja (column) kohta.","en": "Indicates whether the description is provided for the dataset (table) or the data field (column)."}}, 
 {"id":374,"schemaname":"flu","table":"metadata","column":"datatype","type":"column","datatype":"character varying(250)","description":{"et": "Andmevälja andmetüüp.","en": "Data type of the data field."}}, 
 {"id":375,"schemaname":"flu","table":"metadata","column":"description","type":"column","datatype":"json","description":{"et": "Andmekirjeldus eesti ja inglise keeles JSON vormingus. Eestikeelne kirjeldus on tähistatud lühendiga et ja inglisekeelne kirjeldus lühendiga en.","en": "Data description in Estonian and English in JSON format. The Estonian description is marked with the abbreviation et, and the English description is marked with en."}}, 
 {"id":376,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"Id","type":"column","datatype":"bigint","description":{"et": "Andmerea unikaalne identifikaator.","en": "Unique identifier of the data row."}}, 
 {"id":377,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"StatisticsDate","type":"column","datatype":"date","description":{"et": "Statistika kuupäev, mis leitakse immuniseerimise kuupäeva järgi.","en": "Statistics date found by immunization date."}}, 
 {"id":378,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"StatisticsYear","type":"column","datatype":"bigint","description":{"et": "Statistika aasta.","en": "A year of statistics."}}, 
 {"id":379,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"VaccinationSeason","type":"column","datatype":"character varying(100)","description":{"et": "Gripi hooaeg vastavalt Terviseameti definitsioonile.","en": "Flu season according to the definition of the Health Board."}}, 
 {"id":380,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"AgeGroup","type":"column","datatype":"character varying(100)","description":{"et": "Patsiendi vanusegrupp. Vanusegruppi jagunemine tugineb rahvastikuregistri järgsele sünniajale (kui on teada) ning vanus on arvutatud käesoleva aasta 01. jaanuari seisuga, st kui noor oli inimene aasta alguses. Vanusegrupid on kirjeldatud väärtustes X-Y, kus vanus on X <= vanus <= Y vahemikus, va viimase vanusegrupijuures, kus X+ tähendab, et vanus >= X.","en": "The patient`s age group. The age grouping is based on the date of birth according to the population registry (if known), and the age is calculated as of January 1st of the current year, representing the age the person had at the beginning of the year. The age groups are described in the format X-Y, where the age falls within the range X <= age <= Y, except for the last age group, where X+ indicates that the age is greater than or equal to X."}}, 
 {"id":381,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"AgeGroupFilter","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi vanusegrupi filter, mis aitab tekitada eri vanusegruppe. Võimalikud väärtused on AgeGroup1/AgeGroup2. Kasutades patsiendi vanusegrupi filtrit väärtusega AgeGroup1 ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+. Väärtuse -1 korral on vanus teadmata. Kasutades patsiendi vanusegrupi filtrit väärtusega AgeGroup2 ja patsiendi vanusegruppi, saab nende abil valida vanusegruppe 0-7, 8-19, 20-59, 60-79, 80+. Väärtuse -1 korral on vanus teadmata.","en": "Patient`s age group filter, which helps to create different age groups. Possible values ​​are AgeGroup1/AgeGroup2. Using the patient age group filter with the value AgeGroup1 and the patient age group, they can be used to select the age groups 0-4, 5-9, 10-14, 15-19, 20-24, 25-29, 30-34, 35-39, 40-44, 45-49, 50-54, 55-59, 60-64, 65-69, 70-74, 75-79, 80-84, 85+. If the value is -1, the age is unknown. Using the patient age group filter with the value AgeGroup2 and the patient age group, they can be used to select the age groups 0-7, 8-19, 20-59, 60-79, 80+. If the value is -1, the age is unknown."}}, 
 {"id":382,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PatientCountry","type":"column","datatype":"character varying(50)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha riik, mis on andmestikus alati Eesti.","en": "Patient`s country of residence according to the population registry. In the dataset, the country of residence is always Estonia (Eesti)."}}, 
 {"id":383,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PatientCountryEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha riigi numbriline kood vastavalt ISO 3166 standardile. Andmestikus alati 233.","en": "The numerical code for the patient`s country of residence according to the population registry, based on the ISO 3166 standard. In the dataset, the country`s code is always 233, which corresponds to Estonia."}}, 
 {"id":384,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PatientCounty","type":"column","datatype":"character varying(255)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha maakond. Väärtus NULL/ väärtuse puudumise korral on elukoha maakond teadmata (välismaalased või isikud, kelle kohta rahvastikuregistris sissekirjutus puudub).","en": "The patient`s county of residence according to the population register. The value is NULL/ if there is no value, the county of residence is unknown (foreigners or persons for whom there is no entry in the population register)."}}, 
 {"id":385,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PatientCountyEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha maakonna  kood ehk EHAK kood https://klassifikaatorid.stat.ee/. NULL/ väärtuse puudumise korral on maakond teadmata.","en": "County code of the patient`s place of residence according to the population register, or EHAK code https://klassifikatorid.stat.ee/. NULL/ if there is no value, the county is Unknown."}}, 
 {"id":386,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PatientCommune","type":"column","datatype":"character varying(255)","description":{"et": "Patsiendi rahvastikuregistri järgne elukoha haldusüksus Tallinn, Tartu ja Narva.","en": "Patient`s administrative unit (municipality or city) of residence according to the population registry Tallinn, Tartu, Narva."}}, 
 {"id":387,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PatientCommuneEHAK","type":"column","datatype":"character varying(5)","description":{"et": "Patsiendi rahvastikuregistri järgse elukoha haldusüksuse (valla, linna haldusüksuse tasemel) Eesti haldus- ja asustusjaotuse klassifikaatori järgne kood ehk EHAK kood https://klassifikaatorid.stat.ee/. Väärtus NULL/ väärtuse puudumise korral on elukoht haldusüksuse tasemel teadmata.","en": "The EHAK (Eesti haldus- ja asustusjaotuse klassifikaator) code for the patient`s administrative unit (municipality or city) of residence according to the population registry. The code can be found in the Estonian Classification of Administrative and Settlement Units: https://klassifikaatorid.stat.ee/. If the value is NULL or unavailable, it indicates that the residence at the administrative unit level is unknown."}}, 
 {"id":388,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"LocationLevel","type":"column","datatype":"character varying(100)","description":{"et": "Asukohaandmestikes kirjeldab LocationLevel, millise taseme haldusjaotuse kohta antud andmed kehtivad: County - maakond, Commune - haldusüksus (vald, linn haldusüksuse tasemel), Village - asustusüksus (küla, vallasisene linn või linnaosa).","en": "The LocationLevel describes the administrative division level to which the data applies: County: The data corresponds to the county level (maakond); Commune: The data corresponds to the administrative unit level, which includes municipalities and cities (vald, linn haldusüksuse tasemel); Village: The data corresponds to the settlement unit level, which includes villages, intra-municipal towns, or city districts (küla, vallasisene linn või linnaosa)."}}, 
 {"id":389,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"DailyCount","type":"column","datatype":"bigint","description":{"et": "Statistika kuupäeval lisandunud vaktsineeritute arv.","en": "The number of newly added cases on the statistics date."}}, 
 {"id":390,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"TotalCount","type":"column","datatype":"bigint","description":{"et": "Jooksev hooaja kumulatiivne vakstineeritute summa (kõigi eelnevate päevade ja sama päeva jooksev summa).","en": "Cumulative amount of vaccinated people of the current season (current sum of all previous days and the same day)."}}, 
 {"id":391,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"LocationPopulation","type":"column","datatype":"bigint","description":{"et": "Elanike arv asukoha, vanuse ja/ või soo lõikes seisuga 1. jaanuar, mis vastab PopulationYear olevale aastale. Elanike arvu allikaks on Statistikaameti aruanne RV0240. Teadmata soo korral on väärtus NULL/ väärtus puudub.","en": "The number of inhabitants by location, age and/or gender as of January 1, which corresponds to the year in PopulationYear. The source of the number of inhabitants is Statistics Estonia`s report RV0240. For unknown gender, the value is NULL/no value."}}, 
 {"id":392,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"PopulationYear","type":"column","datatype":"bigint","description":{"et": "Haldusüksuse rahvarvu aluseks olev aasta.","en": "The year on which the population of the administrative unit is based."}}, 
 {"id":393,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"Valid","type":"column","datatype":"boolean","description":{"et": "Andmekirje kehtivus. Kehtiv kirje=TRUE, kehtetu kirje=FALSE.","en": "Data record validity. Valid record=TRUE, invalid record=FALSE."}}, 
 {"id":394,"schemaname":"flu","table":"opendata_flu_vaccination_location_agegroup","column":"ModifiedAt","type":"column","datatype":"timestamp with time zone","description":null}]