variables
Data license: CC-BY
23 rows where sourceId = 30953 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, updatedAt, timespan, display, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
738542 | daily_deaths_rate_rolling_average | 2023-07-24 09:57:29 | 2024-07-31 15:42:17 | 71-1437 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Daily new confirmed COVID-19 cases, 7-day rolling average" } |
0 | daily_deaths_rate_rolling_average | grapher/covid/latest/uk_covid_data/uk_covid_data#daily_deaths_rate_rolling_average | 1 | [] |
float | [] |
3cd379ad61dcd5e704195d5e5ba0b3dd | 34b2ea549e68ce1b113af2da8a443156 | ||||||||||||||||||||
738541 | new_hospital_admissions | 2023-07-24 09:57:28 | 2024-07-31 15:42:18 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "UK: Daily new hospital admissions for COVID-19", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | new_hospital_admissions | grapher/covid/latest/uk_covid_data/uk_covid_data#new_hospital_admissions | 1 | [] |
float | [] |
8286be304af9a7b33de3403b0628c7f5 | ea25fa68a1696e3d73e92732cbff4976 | |||||||||||||||||||||
738540 | daily_cases_rate_rolling_average | 2023-07-24 09:57:28 | 2024-07-31 15:42:17 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Daily new confirmed COVID-19 cases, 7-day rolling average", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | daily_cases_rate_rolling_average | grapher/covid/latest/uk_covid_data/uk_covid_data#daily_cases_rate_rolling_average | 1 | [] |
float | [] |
78b7b5196f8d48fe17c2d205ca2f16d0 | 634f2992744b9dfd664dac2fc0f10e92 | |||||||||||||||||||||
738539 | daily_deaths_rolling_average | 2023-07-24 09:57:27 | 2024-07-31 15:42:16 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Daily new confirmed COVID-19 deaths", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | daily_deaths_rolling_average | grapher/covid/latest/uk_covid_data/uk_covid_data#daily_deaths_rolling_average | 1 | [] |
float | [] |
17928aa16eb88e9a18a15c1bd124b8f9 | ffc5dff1f90b83b105b334fec427cc80 | |||||||||||||||||||||
738538 | daily_cases_rolling_average | 2023-07-24 09:57:27 | 2024-07-31 15:42:15 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | daily_cases_rolling_average | grapher/covid/latest/uk_covid_data/uk_covid_data#daily_cases_rolling_average | 1 | [] |
float | [] |
7fb43170d0b76f8e41b34f6e8ffbe7aa | 9f3c498097743ef1bb83d6f483e64795 | |||||||||||||||||||||
738537 | weekly_deaths_rolling_normalized | % | 2023-07-24 09:57:26 | 2024-07-31 15:42:15 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | % | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true } |
0 | weekly_deaths_rolling_normalized | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_deaths_rolling_normalized | 1 | [] |
float | [] |
e3058d9e16153002db7393cc4ce279f5 | de3d172a33778ebc1675b21a923ef199 | |||||||||||||||||||
738536 | people_ventilated_normalized | % | 2023-07-24 09:57:26 | 2024-07-31 15:42:15 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | % | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true } |
0 | people_ventilated_normalized | grapher/covid/latest/uk_covid_data/uk_covid_data#people_ventilated_normalized | 1 | [] |
float | [] |
84f63003697381ceea56040d99689689 | 78d94e94cc72436a18bd2b9eb72c4a71 | |||||||||||||||||||
738535 | people_in_hospital_normalized | % | 2023-07-24 09:57:25 | 2024-07-31 15:42:15 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | % | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true } |
0 | people_in_hospital_normalized | grapher/covid/latest/uk_covid_data/uk_covid_data#people_in_hospital_normalized | 1 | [] |
float | [] |
8629ed39f91ac8a2c836962bac594cca | 04aa3b6af5805fc190baa749f33d7fd0 | |||||||||||||||||||
738534 | weekly_cases_rolling_normalized | % | 2023-07-24 09:57:25 | 2024-07-31 15:42:13 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | % | { "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true } |
0 | weekly_cases_rolling_normalized | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_cases_rolling_normalized | 1 | [] |
float | [] |
e3274405caf70998853d5f4997e4ffff | e469417f2783a630bb355a19bdc85a65 | |||||||||||||||||||
738533 | weekly_deaths_rate | per 100,000 | 2023-07-24 09:57:25 | 2024-07-31 15:42:15 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Confirmed COVID-19 deaths per 100k, weekly rolling average", "unit": "per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | weekly_deaths_rate | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_deaths_rate | 1 | [] |
float | [] |
bf40671a41d10c39b21fd1c84333cdfc | d0a522ebdd2dee11f8614801eaaf26fb | ||||||||||||||||||||
738532 | weekly_cases_rate | per 100,000 | 2023-07-24 09:57:24 | 2024-07-31 15:42:13 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Confirmed COVID-19 cases per 100k, weekly rolling average", "unit": "per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | weekly_cases_rate | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_cases_rate | 1 | [] |
float | [] |
c60890090f0b3c46dbc9d8f936ce865a | eba2d14400db02e127e9132e87ae1656 | ||||||||||||||||||||
738531 | cumulative_deaths_rate | deaths per 100,000 | 2023-07-24 09:57:22 | 2024-07-31 15:42:13 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Cumulative confirmed COVID-19 deaths per 100,000", "unit": "deaths per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | cumulative_deaths_rate | grapher/covid/latest/uk_covid_data/uk_covid_data#cumulative_deaths_rate | 1 | [] |
float | [] |
14f3986e8a783386377c1fc31ee4eced | e5f093ec864730bf3fb4c4cfb3c9d638 | ||||||||||||||||||||
738530 | cumulative_cases_rate | deaths per 100,000 | 2023-07-24 09:57:22 | 2024-07-31 15:42:13 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Cumulative confirmed COVID-19 deaths per 100,000", "unit": "deaths per 100,000", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | cumulative_cases_rate | grapher/covid/latest/uk_covid_data/uk_covid_data#cumulative_cases_rate | 1 | [] |
float | [] |
3ff4b97b7c2fc58bdc64e261f9ddeb3f | 905fa41f6006989f976fae3b51b0eeec | ||||||||||||||||||||
738529 | test_positivity_rate | % | 2023-07-24 09:57:19 | 2024-07-31 15:42:11 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | % | { "name": "Share of COVID-19 tests that are positive", "unit": "%", "zeroDay": "2020-01-01", "shortUnit": "%", "yearIsDay": true } |
0 | test_positivity_rate | grapher/covid/latest/uk_covid_data/uk_covid_data#test_positivity_rate | 1 | [] |
float | [] |
469861168cc16bbe36a3b2c0ef27c1a2 | 9f58cf2fe1fc30ab2b46e912bb05d634 | |||||||||||||||||||
738528 | people_in_hospital | 2023-07-24 09:57:19 | 2024-07-31 15:42:10 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "UK: Number of COVID-19 patients in hospital", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | people_in_hospital | grapher/covid/latest/uk_covid_data/uk_covid_data#people_in_hospital | 1 | [] |
int | [] |
cddeb7482e7369251794da7532492183 | 766cbb413d2088d66387aa9fad3abfb2 | |||||||||||||||||||||
738527 | people_ventilated | 2023-07-24 09:57:19 | 2024-07-31 15:42:10 | 77-1288 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | {} |
0 | people_ventilated | grapher/covid/latest/uk_covid_data/uk_covid_data#people_ventilated | 1 | [] |
int | [] |
d9c7a4eb35de6c4c416f6d4286d070a9 | b47db8c597c3fb088f15e50b64076eed | ||||||||||||||||||||
738526 | weekly_hospital_admissions | 2023-07-24 09:57:19 | 2024-07-31 15:42:10 | 67-1437 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | {} |
0 | weekly_hospital_admissions | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_hospital_admissions | 1 | [] |
int | [] |
0aa7ccc0706a1366a143961937f6eef9 | 895e12208ab8d5bb681a7eb2d93018a4 | ||||||||||||||||||||
738525 | daily_cases | 2023-07-24 09:57:19 | 2024-07-31 15:42:11 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Daily new confirmed COVID-19 cases", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | daily_cases | grapher/covid/latest/uk_covid_data/uk_covid_data#daily_cases | 1 | [] |
int | [] |
0eac3df011c2d62c75dbba5dbeb7d617 | 8e74aef2d964d575c8084be726eda49e | |||||||||||||||||||||
738524 | daily_deaths | 2023-07-24 09:57:18 | 2024-07-31 15:42:09 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Daily new confirmed COVID-19 deaths", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | daily_deaths | grapher/covid/latest/uk_covid_data/uk_covid_data#daily_deaths | 1 | [] |
int | [] |
6341a2c15e9ab0154eb7ad78d585da8f | b21ba478d2e6534ffd8c96907d1d7164 | |||||||||||||||||||||
738523 | cumulative_deaths | deaths | 2023-07-24 09:57:18 | 2024-07-31 15:42:08 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Cumulative confirmed COVID-19 deaths", "unit": "deaths", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | cumulative_deaths | grapher/covid/latest/uk_covid_data/uk_covid_data#cumulative_deaths | 1 | [] |
int | [] |
8e336bb675e42c799a9e1b4e817c97d9 | af1e822c5d9fc9e4b99d23a1fac16930 | ||||||||||||||||||||
738522 | weekly_deaths_rolling | 2023-07-24 09:57:18 | 2024-07-31 15:42:07 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Confirmed COVID-19 deaths, weekly rolling average", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | weekly_deaths_rolling | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_deaths_rolling | 1 | [] |
int | [] |
ec609d0ebfc4fe5c700efb8018af1620 | 80af842080284cf43e2e9c9607c11e8a | |||||||||||||||||||||
738521 | cumulative_cases | cases | 2023-07-24 09:57:17 | 2024-07-31 15:42:08 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Cumulative confirmed COVID-19 cases", "unit": "cases", "zeroDay": "2020-01-01", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | cumulative_cases | grapher/covid/latest/uk_covid_data/uk_covid_data#cumulative_cases | 1 | [] |
int | [] |
2fba86cb0dc035cb3dc8927686952973 | fb15decdc95e1bf7a384978965d9ae63 | ||||||||||||||||||||
738520 | weekly_cases_rolling | 2023-07-24 09:57:17 | 2024-07-31 15:42:08 | uk_covid_data 6151 | UK Government COVID-19 Dashboard – Last updated 30 July 2024 30953 | { "name": "Confirmed COVID-19 cases, weekly rolling average", "zeroDay": "2020-01-01", "yearIsDay": true } |
0 | weekly_cases_rolling | grapher/covid/latest/uk_covid_data/uk_covid_data#weekly_cases_rolling | 1 | [] |
int | [] |
1753c00f8b9b42d7ed68f41a05403567 | 8315915f563bd8b2d0cc73e41454dd67 |
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");