variables
Data license: CC-BY
8 rows where datasetId = 6565 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, updatedAt, timespan, type, sort, createdAt (date), updatedAt (date), sort (array)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
935505 | Population in countries with missing data | people | Population by country and year. | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Population in countries with missing data", "unit": "people", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status_missing_pop | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status_missing_pop | 2 | major | Population in countries with missing data | Population in countries with missing data about their homosexuality status. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | [ { "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing", "name": "Creative Commons BY 4.0" }, { "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt", "name": "CC BY 3.0" }, { "url": "http://creativecommons.org/licenses/by/3.0/igo/", "name": "CC BY 3.0 IGO" } ] |
int | [] |
7803343b584c9266ed9cb07f9e427ff1 | ba1f186dd99187fc6e4576c5492b5a80 | ||||||||||||||
935504 | Population in countries where homosexuality is illegal | people | Population by country and year. | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Population in countries where homosexuality is illegal", "unit": "people", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status_illegal_pop | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status_illegal_pop | 2 | major | Population in countries where homosexuality is illegal | Population in countries where homosexuality is illegal. Homosexuality is defined in this case as consensual homosexual acts among adults in public. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | [ { "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing", "name": "Creative Commons BY 4.0" }, { "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt", "name": "CC BY 3.0" }, { "url": "http://creativecommons.org/licenses/by/3.0/igo/", "name": "CC BY 3.0 IGO" } ] |
int | [] |
f53854587791198f91de685436de8604 | d47fef0494a20c836dc3efc8e71aef2b | ||||||||||||||
935503 | Population in countries where homosexuality is legal | people | Population by country and year. | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Population in countries where homosexuality is legal", "unit": "people", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status_legal_pop | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status_legal_pop | 2 | major | Population in countries where homosexuality is legal | Population in countries where homosexuality is legal. Homosexuality is defined in this case as consensual homosexual acts among adults in public. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | [ { "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing", "name": "Creative Commons BY 4.0" }, { "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt", "name": "CC BY 3.0" }, { "url": "http://creativecommons.org/licenses/by/3.0/igo/", "name": "CC BY 3.0 IGO" } ] |
int | [] |
27331f704332d911d7970c8c9fd43556 | 282554a6109729eaa5082eeb70b66272 | ||||||||||||||
935502 | Legal status of homosexuality | 2024-06-14 15:10:41 | 2024-07-25 23:08:50 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Legal status of homosexuality", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status | 2 | major | Legal status of homosexuality | Legal status of consensual homosexual acts among adults in public. The categories are "Legal" and "Illegal". | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | ordinal | [ "Legal", "Illegal" ] |
c4fb39c91a16f5122fdb3618d840482d | 90f2f3fc827ca134ddc3d26f327ed394 | |||||||||||||||||
935501 | Number of countries with missing data | countries | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Number of countries with missing data", "unit": "countries", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status_missing_count | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status_missing_count | 2 | major | Number of countries with missing data | Number of countries with missing data about their homosexuality status. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | int | [] |
83c4b388b5228c6fd2177d5261c5db8c | e977434826cd460aa008385912424626 | ||||||||||||||||
935500 | Number of countries where homosexuality is illegal | countries | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Number of countries where homosexuality is illegal", "unit": "countries", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status_illegal_count | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status_illegal_count | 2 | major | Number of countries where homosexuality is illegal | Number of countries where homosexuality is illegal. Homosexuality is defined in this case as consensual homosexual acts among adults in public. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | int | [] |
18a341af667871ffa37b38b0c3c20ac8 | bbde2316c254267c4e36809663a88fe9 | ||||||||||||||||
935499 | Number of countries where homosexuality is legal | countries | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 1760-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Number of countries where homosexuality is legal", "unit": "countries", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | status_legal_count | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#status_legal_count | 2 | major | Number of countries where homosexuality is legal | Number of countries where homosexuality is legal. Homosexuality is defined in this case as consensual homosexual acts among adults in public. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | int | [] |
402c50c7e2732a85ed0109f32d4228a1 | ceca63cd162f08bbb7c7a825794cc724 | ||||||||||||||||
935498 | Year of last decriminalization of homosexuality | 2024-06-14 15:10:41 | 2024-07-25 23:08:49 | 2019-2019 | Homosexuality criminalization data from Mignot 6565 | { "name": "Year of last decriminalization of homosexuality", "tolerance": 0, "numDecimalPlaces": 0 } |
0 | last_decriminalization_year | grapher/lgbt_rights/2024-06-11/criminalization_mignot/criminalization_mignot#last_decriminalization_year | 2 | major | Year of last decriminalization of homosexuality | Year of the last decriminalization of homosexuality in each country, for countries where homosexuality is legal. Homosexuality is defined in this case as consensual homosexual acts among adults in public. | [] |
From the original table, we constructed a new dataset with data for all countries between 1760 and 2019. For countries where criminalization was implemented at different points in time across their regions, we considered the earliest year of the change as the year of criminalization. This is the case for the United States (1610-1948). Conversely, for countries where _decriminalization_ was implemented at different points in time across their regions, we considered the latest year of the change as the year of decriminalization. This is the case for Australia (1975-1997), Bosnia and Herzegovina (1998-2001), United Kingdom (1967-1982), and United States (1962-2003). We consider the year of the last decriminalization of homosexuality in Germany to be 1969, the year it was decriminalized in West Germany. East Germany did it in 1968. We modified the homosexuality status for Russia, Armenia, Azerbaijan, Estonia, Georgia, Kazakhstan, Kyrgyzstan, Latvia, Lithuania, Moldova, Tajikistan, Turkmenistan, and Uzbekistan before 1832 to "Legal" to reflect what it is mentioned on page 8 of the original paper (_[the Russian Empire] have not criminalized these practices since at least the 18th century_). | int | [] |
ec05079e7bdc8cb27d441e28161460ab | 9b39b1ecde75d13c54ca04b11fc70ad3 |
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");