variables
Data license: CC-BY
32 rows where datasetId = 6155 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, updatedAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
738646 | Biweekly deaths per million people | 2023-07-24 09:58:55 | 2024-07-31 15:42:43 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | biweekly_deaths_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#biweekly_deaths_per_million_people | 1 | [] |
float | [] |
5744695f05fb0ec0e1a5b278e0a231c4 | df249b3ae1454016ae49fc477289bb2a | |||||||||||||||||||||
738645 | Biweekly cases per million people | 2023-07-24 09:58:53 | 2024-07-31 15:42:44 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | biweekly_cases_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#biweekly_cases_per_million_people | 1 | [] |
float | [] |
dca59a7d74c6469851dea5fc14f02acf | def60634e85c0416f1a7c27ccac351c1 | |||||||||||||||||||||
738644 | Weekly deaths per million people | 2023-07-24 09:58:53 | 2024-07-31 15:42:42 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | weekly_deaths_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#weekly_deaths_per_million_people | 1 | [] |
float | [] |
5238da30b397a2a5f228185c5d201366 | 9f83a0fdcf71c667f7c4110539c79ae8 | |||||||||||||||||||||
738643 | Weekly cases per million people | 2023-07-24 09:58:52 | 2024-07-31 15:42:41 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | weekly_cases_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#weekly_cases_per_million_people | 1 | [] |
float | [] |
32a1fb0e91e4c3385cb33a0d4c098c7a | c9882e6cbdc3ef54267cad178ec2af8f | |||||||||||||||||||||
738642 | Biweekly death growth (%) | % | 2023-07-24 09:58:50 | 2024-07-31 15:42:39 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | % | { "name": "Biweekly death growth", "unit": "%", "zeroDay": "2020-01-21", "shortUnit": "%", "yearIsDay": true } |
0 | biweekly_death_growth__pct | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#biweekly_death_growth__pct | 1 | [] |
float | [] |
19fb42095b1ad3a268e055267c14a577 | 51e391374e2f9b66eaab157f31a37e09 | |||||||||||||||||||
738641 | Biweekly case growth (%) | % | 2023-07-24 09:58:49 | 2024-07-31 15:42:38 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | % | { "name": "Biweekly growth in cases", "unit": "%", "zeroDay": "2020-01-21", "shortUnit": "%", "yearIsDay": true } |
0 | biweekly_case_growth__pct | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#biweekly_case_growth__pct | 1 | [] |
float | [] |
7a2f4b29476e8dda462f122f9c3180de | d876eff5a77d73f0395d910249aac2bf | |||||||||||||||||||
738640 | Biweekly deaths | deaths | 2023-07-24 09:58:48 | 2024-07-31 15:42:38 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "name": "Biweekly deaths", "unit": "deaths", "zeroDay": "2020-01-21", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | biweekly_deaths | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#biweekly_deaths | 1 | [] |
int | [] |
0382c32878824d5e193f369b10264dce | f4aaa09e441ddec6d90db9f1445dee42 | ||||||||||||||||||||
738639 | Biweekly cases | cases | 2023-07-24 09:58:47 | 2024-07-31 15:42:38 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "name": "Biweekly cases", "unit": "cases", "zeroDay": "2020-01-21", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | biweekly_cases | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#biweekly_cases | 1 | [] |
int | [] |
b627399e7f446ea63027937084d62e17 | 7f6fe37dc1e55d3fa6bba8bc7c72025c | ||||||||||||||||||||
738638 | Weekly death growth (%) | % | 2023-07-24 09:58:46 | 2024-07-31 15:42:36 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | % | { "unit": "%", "zeroDay": "2020-01-21", "shortUnit": "%", "yearIsDay": true, "numDecimalPlaces": 1 } |
0 | weekly_death_growth__pct | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#weekly_death_growth__pct | 1 | [] |
float | [] |
75d92e989b6586e648d153a865e1a265 | f20689369e674c7737132e8b2250f05a | |||||||||||||||||||
738637 | Weekly case growth (%) | % | 2023-07-24 09:58:44 | 2024-07-31 15:42:35 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | % | { "unit": "%", "zeroDay": "2020-01-21", "shortUnit": "%", "yearIsDay": true, "numDecimalPlaces": 1 } |
0 | weekly_case_growth__pct | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#weekly_case_growth__pct | 1 | [] |
float | [] |
21c53bc5c550337ab47954c0a1ef3cad | 1cda2a7042fcba8e866b88fce54c939f | |||||||||||||||||||
738636 | Weekly deaths | 2023-07-24 09:58:42 | 2024-07-31 15:42:35 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | weekly_deaths | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#weekly_deaths | 1 | [] |
int | [] |
bad26c254797e548f95cbaecaf8c7c59 | 9fc1b37b10d724b27f20d88cb0bb174e | |||||||||||||||||||||
738635 | Weekly cases | 2023-07-24 09:58:41 | 2024-07-31 15:42:34 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | weekly_cases | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#weekly_cases | 1 | [] |
int | [] |
8649cfd1b19e7f7ad82791455e78903d | 7bc04aca1d353208da95c436af266bc6 | |||||||||||||||||||||
738634 | Has population ≥ 5M AND had ≥100 cases ≥21 days ago AND has testing data | 2023-07-24 09:58:40 | 2024-07-31 15:42:33 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | has_population__gte__5m_and_had__gte_100_cases__gte_21_days_ago_and_has_testing_data | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#has_population__gte__5m_and_had__gte_100_cases__gte_21_days_ago_and_has_testing_data | 1 | [] |
int | [] |
8439f4242f3ffede8ddb027041570f0a | 19abdfaaed2f38c260f22f893ebefa15 | |||||||||||||||||||||
738633 | Days since the total confirmed cases of COVID-19 reached 100 (with population ≥ 5M) | 2023-07-24 09:58:39 | 2024-07-31 15:42:31 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true, "includeInTable": false } |
0 | days_since_the_total_confirmed_cases_of_covid_19_reached_100__with_population__gte__5m | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#days_since_the_total_confirmed_cases_of_covid_19_reached_100__with_population__gte__5m | 1 | [] |
int | [] |
43537d8c0452ebc92cbb0ae01268aeaf | 7f1838b08b4b2fe2c8a5055fdc5f3bd7 | |||||||||||||||||||||
738632 | Case fatality rate of COVID-19 (%) (Only observations with ≥100 cases) | % | 2023-07-24 09:58:38 | 2024-07-31 15:42:31 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | % | { "unit": "%", "zeroDay": "2020-01-21", "shortUnit": "%", "yearIsDay": true, "numDecimalPlaces": 1 } |
0 | case_fatality_rate_of_covid_19__pct__only_observations_with__gte_100_cases | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#case_fatality_rate_of_covid_19__pct__only_observations_with__gte_100_cases | 1 | [] |
float | [] |
294a3e4fb98d23f97e2756f9d5337b0d | 16c3d1c1759ca6441eec39b1e38eda17 | |||||||||||||||||||
738631 | Case fatality rate of COVID-19 (%) | % | 2023-07-24 09:58:37 | 2024-07-31 15:42:30 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "%", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | case_fatality_rate_of_covid_19__pct | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#case_fatality_rate_of_covid_19__pct | 1 | [] |
float | [] |
5af48c2913fd4ce348eb6a714a2322ef | ed232c1a1ac82e15fc7933af3c80c1f9 | ||||||||||||||||||||
738630 | Daily new confirmed deaths due to COVID-19 per million people (rolling 7-day average, right-aligned) | 2023-07-24 09:58:36 | 2024-07-31 15:42:30 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_deaths_due_to_covid_19_per_million_people__rolling_7_day_average__right_aligned | 1 | [] |
float | [] |
1053466936aacf711c83e46a4a9e0ff6 | deaf4eab2d2e3bcb3dd40345ca45f265 | |||||||||||||||||||||
738629 | Daily new confirmed cases of COVID-19 per million people (rolling 7-day average, right-aligned) | 2023-07-24 09:58:34 | 2024-07-31 15:42:27 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_7_day_average__right_aligned | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_cases_of_covid_19_per_million_people__rolling_7_day_average__right_aligned | 1 | [] |
float | [] |
e4a7897f90bd847460eb51679d95e49b | e92fbc0fc342961fbe4f7958cbe25757 | |||||||||||||||||||||
738628 | Daily new confirmed deaths due to COVID-19 (rolling 7-day average, right-aligned) | 2023-07-24 09:58:33 | 2024-07-31 15:42:27 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | daily_new_confirmed_deaths_due_to_covid_19__rolling_7_day_average__right_aligned | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_deaths_due_to_covid_19__rolling_7_day_average__right_aligned | 1 | [] |
float | [] |
5e3ad2b72647cbacf35bd39b726f507d | 6d18b2480bf27ee46071f3e47f0fb097 | |||||||||||||||||||||
738627 | Daily new confirmed cases due to COVID-19 (rolling 7-day average, right-aligned) | 2023-07-24 09:58:31 | 2024-07-31 15:42:26 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | daily_new_confirmed_cases_due_to_covid_19__rolling_7_day_average__right_aligned | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_cases_due_to_covid_19__rolling_7_day_average__right_aligned | 1 | [] |
float | [] |
00343ac5bfae76dedc7cc233ab5c53f3 | 802c1335366d00de4c787e8a3adf4d94 | |||||||||||||||||||||
738626 | Days since the total confirmed deaths of COVID-19 per million people reached 0.1 | 2023-07-24 09:58:28 | 2024-07-31 15:42:25 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true, "includeInTable": false } |
0 | days_since_the_total_confirmed_deaths_of_covid_19_per_million_people_reached_0_1 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#days_since_the_total_confirmed_deaths_of_covid_19_per_million_people_reached_0_1 | 1 | [] |
int | [] |
0e0fb209b6df75b4fde1d1df58f20ff1 | bcdaac7ea5dfacd192598540d6f8240e | |||||||||||||||||||||
738625 | Days since the total confirmed cases of COVID-19 per million people reached 1 | days | 2023-07-24 09:58:27 | 2024-07-31 15:42:24 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "name": "Days since the total confirmed cases per million people reached 1", "unit": "days", "zeroDay": "2020-01-21", "yearIsDay": true, "includeInTable": false } |
0 | days_since_the_total_confirmed_cases_of_covid_19_per_million_people_reached_1 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#days_since_the_total_confirmed_cases_of_covid_19_per_million_people_reached_1 | 1 | [] |
int | [] |
205eb4b39b704e5699ddb10f92fed485 | 9ab808d86a2dd165f838a8708b6db3b0 | ||||||||||||||||||||
738624 | Days since the total confirmed deaths of COVID-19 reached 5 | 2023-07-24 09:58:26 | 2024-07-31 15:42:21 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true, "includeInTable": false } |
0 | days_since_the_total_confirmed_deaths_of_covid_19_reached_5 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#days_since_the_total_confirmed_deaths_of_covid_19_reached_5 | 1 | [] |
int | [] |
1ec55b90c7e2acf8f03be7d5a1a113e4 | a5977c018c7c1f30520bbd9346bcbc8c | |||||||||||||||||||||
738623 | Days since the total confirmed cases of COVID-19 reached 100 | 2023-07-24 09:58:24 | 2024-07-31 15:42:21 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "zeroDay": "2020-01-21", "yearIsDay": true, "includeInTable": false } |
0 | days_since_the_total_confirmed_cases_of_covid_19_reached_100 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#days_since_the_total_confirmed_cases_of_covid_19_reached_100 | 1 | [] |
int | [] |
0b2e6958ac0b1a7e403bffd65c51267b | b3c68258c62f40e67815799ddec8bb21 | |||||||||||||||||||||
738622 | Total confirmed deaths due to COVID-19 per million people | deaths per million | 2023-07-24 09:58:21 | 2024-07-31 15:42:21 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "deaths per million", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | total_confirmed_deaths_due_to_covid_19_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#total_confirmed_deaths_due_to_covid_19_per_million_people | 1 | [] |
float | [] |
6ddebf1bdf6b24b6f7f281c9d5975a83 | e9331bcf9898a198a1b744ffc0592647 | ||||||||||||||||||||
738621 | Total confirmed cases of COVID-19 per million people | cases per million | 2023-07-24 09:58:20 | 2024-07-31 15:42:19 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "cases per million", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | total_confirmed_cases_of_covid_19_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#total_confirmed_cases_of_covid_19_per_million_people | 1 | [] |
float | [] |
6f21a657bbe4008e000fa19ffc673ac0 | daf004ab7684cd449474e3e61c4f796a | ||||||||||||||||||||
738620 | Daily new confirmed deaths due to COVID-19 per million people | deaths per million | 2023-07-24 09:58:19 | 2024-07-31 15:42:19 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "deaths per million", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | daily_new_confirmed_deaths_due_to_covid_19_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_deaths_due_to_covid_19_per_million_people | 1 | [] |
float | [] |
173a2c0fbf33ae58848a10bd2a166673 | baf4ca95ea203fed7accd3e7b9b4c7e1 | ||||||||||||||||||||
738619 | Daily new confirmed cases of COVID-19 per million people | cases | 2023-07-24 09:58:19 | 2024-07-31 15:42:15 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "cases", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | daily_new_confirmed_cases_of_covid_19_per_million_people | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_cases_of_covid_19_per_million_people | 1 | [] |
float | [] |
be0bd9427a83a1d9bd3a474f9330437a | eda09d27f7fa26b5928a2192c381b320 | ||||||||||||||||||||
738618 | Total confirmed deaths due to COVID-19 | deaths | 2023-07-24 09:58:18 | 2024-07-31 15:42:15 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "deaths", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | total_confirmed_deaths_due_to_covid_19 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#total_confirmed_deaths_due_to_covid_19 | 1 | [] |
int | [] |
be3193ccc41cdb14d4d67b8e8794967d | 0941bd29eaf31ea8768e8bd8e78974fa | ||||||||||||||||||||
738617 | Total confirmed cases of COVID-19 | cases | 2023-07-24 09:58:18 | 2024-07-31 15:42:15 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "unit": "cases", "zeroDay": "2020-01-21", "yearIsDay": true } |
0 | total_confirmed_cases_of_covid_19 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#total_confirmed_cases_of_covid_19 | 1 | [] |
int | [] |
a71e977e9b1862d313d84f71e93fa6e6 | e51fa752d4e33d08fdb95be7744b06b7 | ||||||||||||||||||||
738616 | Daily new confirmed deaths due to COVID-19 | deaths | 2023-07-24 09:58:17 | 2024-07-31 15:42:15 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "name": "Daily confirmed deaths", "unit": "deaths", "zeroDay": "2020-01-21", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | daily_new_confirmed_deaths_due_to_covid_19 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_deaths_due_to_covid_19 | 1 | [] |
int | [] |
1c83ae3e30953ce6d28d7388784bd793 | c155f43a5a4d82af5068ddb76b46cb92 | ||||||||||||||||||||
738615 | Daily new confirmed cases of COVID-19 | cases | 2023-07-24 09:58:17 | 2024-07-31 15:42:15 | COVID-19: Confirmed cases and deaths (WHO) 6155 | World Health Organization 29711 | { "name": "Daily confirmed cases", "unit": "cases", "zeroDay": "2020-01-21", "yearIsDay": true, "numDecimalPlaces": 0 } |
0 | daily_new_confirmed_cases_of_covid_19 | grapher/covid/latest/cases_and_deaths_who/cases_and_deaths_who#daily_new_confirmed_cases_of_covid_19 | 1 | [] |
int | [] |
668b63ce2d416161c652fe5580e8a1f2 | ce0079429a8337f66987128f990c97e2 |
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");