variables
Data license: CC-BY
54 rows where datasetId = 5771 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 525697 | P99 - income threshold of the top 1% | The level of income below which 99% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525696 | P99.9 - income threshold of the top 0.1% | The level of income below which 99.9% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525695 | P99.99 - income threshold of the top 0.01% | The level of income below which 99.99% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525694 | P99.999 - income threshold of the top 0.001% | The level of income below which 99.999% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525693 | P90 - income threshold of the top 10% | The level of income below which 90% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525692 | P80 - income threshold | The level of income below which 80% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525691 | P70 - income threshold | The level of income below which 70% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525690 | P60 - income threshold | The level of income below which 60% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525689 | P50 - income threshold (median) | The level of income below which half of the population live. This is the median of the income distribution. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525688 | P40 - income threshold | The level of income below which 40% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525687 | P30 - income threshold | The level of income below which 30% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525686 | P20 - income threshold | The level of income below which 20% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525685 | P10 - income threshold | The level of income below which 10% of the population live. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525684 | P0 - income threshold of the bottom 10% | The minimum level of income in the distribution. It can be 0 or a negative value. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525683 | P99-P100 - mean income of the top 1% | Mean income of the top 1%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525682 | P99.9-P100 - mean income of the top 0.1% | Mean income of the top 0.1%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525681 | P99.99-P100 - mean income of the top 0.01% | Mean income of the top 0.01%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525680 | P99.999-P100 - mean income of the top 0.001% | Mean income of the top 0.001%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525679 | P90-P100 - mean income of the top 10% | Mean income of the top 10%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525678 | P80-P90 - mean income | Mean income of the population between percentiles 80 and 90. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525677 | P70-P80 - mean income | Mean income of the population between percentiles 70 and 80. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525676 | P60-P70 - mean income | Mean income of the population between percentiles 60 and 70. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525675 | P50-P60 - mean income | Mean income of the population between percentiles 50 and 60. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525674 | P40-P50 - mean income | Mean income of the population between percentiles 40 and 50. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525673 | P30-P40 - mean income | Mean income of the population between percentiles 30 and 40. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525672 | P20-P30 - mean income | Mean income of the population between percentiles 20 and 30. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525671 | P10-P20 - mean income | Mean income of the population between percentiles 10 and 20. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525670 | P0-P10 - mean income of the bottom 10% | Mean income of the bottom 10%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525669 | Mean income | Mean income of the entire income distribution. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "international-$ at 2017 prices",
"shortUnit": "$",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525668 | P99-P100 - share of the top 1% | Share of the national income of the top 1%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the top 1%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525667 | P99.9-P100 - share of the top 0.1% | Share of the national income of the top 0.1%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the top 0.1%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525666 | P99.99-P100 - share of the top 0.01% | Share of the national income of the top 0.01%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the top 0.01%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525665 | P99.999-P100 - share of the top 0.001% | Share of the national income of the top 0.001%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the top 0.001%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525664 | P90-P100 - share of the top 10% | Share of the national income of the top 10%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the top 10%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525663 | P80-P90 - share of national income | Share of the national income of the population between percentiles 80 to 90. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525662 | P70-P80 - share of national income | Share of the national income of the population between percentiles 70 to 80. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525661 | P60-P70 - share of national income | Share of the national income of the population between percentiles 60 to 70. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525660 | P50-P90 - share of the middle 40% | Share of the national income of the middle 40% (the population between percentiles 50 and 90). | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the middle 40%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525659 | P50-P60 - share of national income | Share of the national income of the population between percentiles 50 to 60. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525658 | P40-P50 - share of national income | Share of the national income of the population between percentiles 40 to 50. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525657 | P30-P40 - share of national income | Share of the national income of the population between percentiles 30 to 40. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525656 | P20-P30 - share of national income | Share of the national income of the population between percentiles 20 to 30. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525655 | P10-P20 - share of national income | Share of the national income of the population between percentiles 10 to 20. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525654 | P0-P50 - share of the bottom 50% | Share of the national income of the bottom 50%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the bottom 50%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525653 | P0-P40 - share of the bottom 40% | Share of the national income of the bottom 40%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the bottom 40%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525652 | P0-P10 - share of the bottom 10% | Share of the national income of the bottom 10%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"name": "Share of the bottom 10%",
"unit": "%",
"shortUnit": "%",
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525651 | P50/P10 ratio | The P50/P10 ratio measures inequality by dividing the income thresholds of the 50th (median income) and 10th percentiles. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525650 | P90/P50 ratio | The P90/P50 ratio measures inequality by dividing the income thresholds of the 90th and 50th percentiles (the median income) | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525649 | P90/P10 ratio | The P90/P10 ratio measures inequality by dividing the income thresholds of the 90th and 10th percentiles | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525648 | S90/S50 ratio | The S90/S50 ratio measures inequality by dividing the income share of the top 10% and the income share of the bottom 50%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525647 | S80/S20 ratio | The S80/S20 ratio measures inequality by dividing the income share of the top 20% and the income share of the bottom 20%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525646 | S90/S10 ratio | The S90/S10 ratio measures inequality by dividing the income share of the top 10% and the income share of the bottom 10%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525645 | Palma ratio (S90/S40 ratio) | The Palma ratio measures inequality by dividing the income share of the top 10% by the income share of the bottom 40%. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
0 | 1 | |||||||||||||||||||||||||||
| 525644 | Gini coefficient | The Gini coefficient measures inequality on a scale between 0 and 1, where higher values indicate greater inequality. | 2022-09-19 15:48:24 | 2023-06-15 05:05:42 | World Inequality Database (WID) - Pretax income 5771 | World Inequality Database (WID) 27041 | {
"includeInTable": true
} |
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");