variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

8 rows where datasetId = 6146 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, type, createdAt (date), updatedAt (date)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
738277 Weekly new hospital admissions patients   2023-07-24 09:54:40 2024-07-31 15:42:00       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Weekly new hospital admissions for COVID-19",
    "unit": "patients",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     weekly_new_hospital_admissions grapher/covid/latest/hospital_and_icu/hospital_and_icu#weekly_new_hospital_admissions   1                 
[]
         int 
[]
 9cac36916abf9ba07961853f44991e01 d385e7cc9f784285ac24f03fe85dc6ec
738276 Weekly new hospital admissions per million per million   2023-07-24 09:54:40 2024-07-31 15:42:00       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Weekly new hospital admissions for COVID-19 per million",
    "unit": "per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 2
}
 0     weekly_new_hospital_admissions_per_million grapher/covid/latest/hospital_and_icu/hospital_and_icu#weekly_new_hospital_admissions_per_million   1                 
[]
         float 
[]
 04ce7eb130417d75954f00b343959636 6485d632ba9bb757e3c5943448b047f5
738275 Weekly new ICU admissions per million per million   2023-07-24 09:54:40 2024-07-31 15:42:00       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Weekly new ICU admissions for COVID-19 per million",
    "unit": "per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 2
}
 0     weekly_new_icu_admissions_per_million grapher/covid/latest/hospital_and_icu/hospital_and_icu#weekly_new_icu_admissions_per_million   1                 
[]
         float 
[]
 e7065e82eee3ac217be9809d324183c8 dec3b63244417f955d7ac70596829d96
738274 Weekly new ICU admissions ICU patients   2023-07-24 09:54:40 2024-07-31 15:41:59       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Weekly new ICU admissions for COVID-19",
    "unit": "ICU patients",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Hungary: patients on ventilator"
}
 0     weekly_new_icu_admissions grapher/covid/latest/hospital_and_icu/hospital_and_icu#weekly_new_icu_admissions   1                 
[]
         int 
[]
 d0bc10424318e40411e31cfb29385253 fe5c6acbccf38b2ad10e35377e7c2070
738273 Daily hospital occupancy per million per million Daily hospital occupancy is the number of COVID-19 patients in hospital on a given day. 2023-07-24 09:54:40 2024-07-31 15:41:59       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Number of COVID-19 patients in hospital per million",
    "unit": "per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 2
}
 0     daily_hospital_occupancy_per_million grapher/covid/latest/hospital_and_icu/hospital_and_icu#daily_hospital_occupancy_per_million   1                 
[]
         float 
[]
 5034e0e6d4d659bf9723e1c2ec8caf3f 1578191e9c15011a350ceffb7e4518ed
738272 Daily hospital occupancy patients Daily hospital occupancy is the number of COVID-19 patients in hospital on a given day. 2023-07-24 09:54:40 2024-07-31 15:41:59       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Number of COVID-19 patients in hospital",
    "unit": "patients",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     daily_hospital_occupancy grapher/covid/latest/hospital_and_icu/hospital_and_icu#daily_hospital_occupancy   1                 
[]
         int 
[]
 779198b25800f3a2b87f9980b5745ddc 65350d466864c86375b66e261710bf3d
738271 Daily ICU occupancy per million per million   2023-07-24 09:54:40 2024-07-31 15:41:59       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Number of COVID-19 patients in ICU per million",
    "unit": "per million",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 2,
    "entityAnnotationsMap": "Hungary: patients on ventilator"
}
 0     daily_icu_occupancy_per_million grapher/covid/latest/hospital_and_icu/hospital_and_icu#daily_icu_occupancy_per_million   1                 
[]
         float 
[]
 e8cc12767f292eb15445eb1c01696ede 3776a4909edd8451322cd95f86fb7f42
738270 Daily ICU occupancy patients in ICU   2023-07-24 09:54:39 2024-07-31 15:41:59       COVID-2019 - Hospital & ICU 6146 Official data collated by Our World in Data – Last updated 31 July 2024 30955   
{
    "name": "Current number of COVID-19 patients in ICU",
    "unit": "patients in ICU",
    "zeroDay": "2020-01-21",
    "yearIsDay": true,
    "numDecimalPlaces": 0,
    "entityAnnotationsMap": "Hungary: patients on ventilator"
}
 0     daily_icu_occupancy grapher/covid/latest/hospital_and_icu/hospital_and_icu#daily_icu_occupancy   1                 
[]
         int 
[]
 49960c6a1964b7beb79e8edadb9a72c8 1ded08953ed80aec188303f4073fa5c0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");