variables
Data license: CC-BY
23 rows where datasetId = 5237 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt, display, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
210613 | weekly_deaths_rolling_normalized | 2022-01-07 11:40:35 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
210612 | people_ventilated_normalized | 2022-01-07 11:40:35 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
210611 | people_in_hospital_normalized | 2022-01-07 11:40:35 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
210610 | weekly_cases_rolling_normalized | 2022-01-07 11:40:35 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
210609 | people_ventilated | 2022-01-07 11:40:35 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | {} |
0 | 1 | ||||||||||||||||||||||||||||
145601 | weekly_hospital_admissions | 2020-12-23 13:38:40 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | {} |
0 | 1 | ||||||||||||||||||||||||||||
145600 | people_in_hospital | 2020-12-23 13:21:23 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "UK: Number of COVID-19 patients in hospital", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | ||||||||||||||||||||||||||||
145599 | new_hospital_admissions | 2020-12-23 13:21:23 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "UK: Daily new hospital admissions for COVID-19", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | ||||||||||||||||||||||||||||
145598 | test_positivity_rate | 2020-12-23 10:11:15 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Share of COVID-19 tests that are positive", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145597 | daily_deaths_rate_rolling_average | 2020-12-23 06:31:59 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Daily new confirmed COVID-19 cases, 7-day rolling average", "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145596 | daily_cases_rate_rolling_average | 2020-12-23 06:31:59 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Daily new confirmed COVID-19 cases, 7-day rolling average", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145595 | daily_deaths_rolling_average | 2020-12-23 06:24:16 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Daily new confirmed COVID-19 deaths", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145594 | daily_cases_rolling_average | 2020-12-23 06:24:16 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145593 | daily_cases | 2020-12-22 17:35:26 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Daily new confirmed COVID-19 cases", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | ||||||||||||||||||||||||||||
145592 | daily_deaths | 2020-12-22 17:35:26 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Daily new confirmed COVID-19 deaths", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | ||||||||||||||||||||||||||||
145591 | weekly_deaths_rate | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Confirmed COVID-19 deaths per 100k, weekly rolling average", "unit": "per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145590 | weekly_cases_rate | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Confirmed COVID-19 cases per 100k, weekly rolling average", "unit": "per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145589 | cumulative_deaths_rate | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Cumulative confirmed COVID-19 deaths per 100,000", "unit": "deaths per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145588 | cumulative_cases_rate | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Cumulative confirmed COVID-19 deaths per 100,000", "unit": "deaths per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | ||||||||||||||||||||||||||||
145587 | weekly_deaths_rolling | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Confirmed COVID-19 deaths, weekly rolling average", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145586 | weekly_cases_rolling | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Confirmed COVID-19 cases, weekly rolling average", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true } |
0 | 1 | ||||||||||||||||||||||||||||
145585 | cumulative_deaths | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Cumulative confirmed COVID-19 deaths", "unit": "deaths", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | ||||||||||||||||||||||||||||
145584 | cumulative_cases | 2020-12-22 17:08:42 | 2023-06-15 05:05:42 | uk_covid_data 5237 | UK Government COVID-19 Dashboard – Last updated 9 August 2023 17966 | { "name": "Cumulative confirmed COVID-19 cases", "unit": "cases", "zeroDay": "2020-01-01", "yearIsDay": true, "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");