variables
Data license: CC-BY
6 rows where datasetId = 5977 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: timespan, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 650564 | Same-sex marriage - National context | Describes more details about the legislation status of same-sex marriage in each country and year. | 2023-04-24 14:42:21 | 2023-10-27 12:25:39 | 1793-2023 | Equaldex dataset (Equaldex, 2023) 5977 | Equaldex (2023) 27555 | {
"name": "Same-sex marriage",
"shortUnit": ""
} |
0 | description_marriage | grapher/equaldex/2023-04-13/equaldex/equaldex#description_marriage | 1 | ||||||||||||||||||||||||
| 650563 | Homosexual activity - National context | Describes more details about the legislation status of homosexual activity in each country and year. | 2023-04-24 14:42:21 | 2023-10-27 12:25:39 | 1515-2023 | Equaldex dataset (Equaldex, 2023) 5977 | Equaldex (2023) 27555 | {
"name": "Homosexual activity",
"shortUnit": ""
} |
0 | description_homosexuality | grapher/equaldex/2023-04-13/equaldex/equaldex#description_homosexuality | 1 | ||||||||||||||||||||||||
| 650562 | Right to change legal gender - National context | Describes more details about the legislation status of the right to change legal gender in each country and year. | 2023-04-24 14:42:21 | 2023-10-27 12:25:39 | 1915-2023 | Equaldex dataset (Equaldex, 2023) 5977 | Equaldex (2023) 27555 | {
"name": "Right to change legal gender",
"shortUnit": ""
} |
0 | description_changing_gender | grapher/equaldex/2023-04-13/equaldex/equaldex#description_changing_gender | 1 | ||||||||||||||||||||||||
| 650561 | Same-sex marriage - Legislation status | Describes the legislation status of same-sex marriage in each country and year. Ten different status are possible: 1. Legal 2. Civil unions 3. Other type of partnership 4. Foreign same-sex marriages recognized only 5. Unregistered cohabitation 6. Ambiguous 7. Varies by Region 8. Unrecognized 9. Unrecognized, same-sex marriage and civil unions banned 10. Not legal | 2023-04-24 14:42:21 | 2023-10-27 12:25:39 | 1793-2023 | Equaldex dataset (Equaldex, 2023) 5977 | Equaldex (2023) 27555 | {
"name": "Same-sex marriage",
"shortUnit": ""
} |
0 | marriage | grapher/equaldex/2023-04-13/equaldex/equaldex#marriage | 1 | ||||||||||||||||||||||||
| 650560 | Homosexual activity - Legislation status | Describes the legislation status of homosexual activity in each country and year. Nine different status are possible: 1. Legal 2. Male illegal, female legal 3. Male illegal, female uncertain 4. Illegal (other penalty) 5. Ambiguous" 6. Varies by Region 7. Illegal (imprisonment as punishment) 8. Illegal (up to life in prison as punishment) 9. Illegal (death penalty as punishment) | 2023-04-24 14:42:21 | 2023-10-27 12:25:39 | 1515-2023 | Equaldex dataset (Equaldex, 2023) 5977 | Equaldex (2023) 27555 | {
"name": "Homosexual activity",
"shortUnit": ""
} |
0 | homosexuality | grapher/equaldex/2023-04-13/equaldex/equaldex#homosexuality | 1 | ||||||||||||||||||||||||
| 650559 | Right to change legal gender - Legislation status | Describes the legislation status of the right to change legal gender in each country and year. Five different status are possible: 1. Legal, surgery not required 2. Legal, but requires surgery 3. Ambiguous 4. Varies by Region 5. Illegal | 2023-04-24 14:42:21 | 2023-10-27 12:25:39 | 1932-2023 | Equaldex dataset (Equaldex, 2023) 5977 | Equaldex (2023) 27555 | {
"name": "Right to change legal gender",
"shortUnit": ""
} |
0 | changing_gender | grapher/equaldex/2023-04-13/equaldex/equaldex#changing_gender | 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");