variables
Data license: CC-BY
23 rows where sourceId = 14868 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 93459 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Not allocated - Age Group:Total - Gender:Total - EBDAG | % current expenditure on health | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93458 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:External causes of morbidity and mortality - Age Group:Total - Gender:Total - EBDAG | % current expenditure on health | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93457 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:All causes - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93456 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Factors influencing health status and contact with health services - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93455 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Injury, poisoning and other consequences of external causes - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93454 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Symptoms, signs and abnormal clinical and laboratory findings, n.e.c. - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93453 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Congenital malformations, deformations and chromosomal abnormalities - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93452 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Certain conditions originating in the perinatal period - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93451 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Pregnancy, childbirth and the puerperium - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93450 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the genitourinary system - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93449 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of musculoskeletal system and connective tissue - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93448 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the skin and subcutaneous tissue - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93447 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the digestive system - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93446 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the respiratory system - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93445 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the circulatory system - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93444 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the ear and mastoid process - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93443 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the eye and adnexa - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93442 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the nervous system - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93441 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Mental and behavioural disorders - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93440 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Endocrine, nutritional and metabolic diseases - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93439 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Diseases of the blood and bloodforming organs - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93438 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Neoplasms - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
0 | 1 | |||||||||||||||||||||||||||
| 93437 | Provider:Total expenditure HP.1-HP.9 - Financing Agent:Total expenditure HF.1-HF.3 - Function:Total current expenditure HC.1-HC.9 (Individual and collective health care) - Diagnostic Category:Infectious and parasitic diseases - Age Group:Total - Gender:Total - EBDAG | Million of national currency units | 2018-03-16 17:19:26 | 2023-06-15 05:05:42 | Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 2647 | OECD - Health - Expenditure by disease, age and gender under the System of Health Accounts (SHA) Framework 14868 | {} |
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");