variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

4 rows where datasetId = 6569 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display, descriptionShort, type, createdAt (date), updatedAt (date), descriptionKey (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
935572 Population in countries where same-sex marriage is not legal   Population by country and year. 2024-06-17 15:46:03 2024-07-25 23:08:49     2000-2023 Same-sex marriage around the world - Pew Research Center 6569     
{
    "name": "Not legal",
    "tolerance": 0,
    "numDecimalPlaces": 0
}
 0     legal_status_not_legal_pop grapher/pew/2024-06-03/same_sex_marriage/same_sex_marriage#legal_status_not_legal_pop   2 major   Population in countries where same-sex marriage is not legal       Same-sex marriage is marriage and marriage recognition between two people of the same biological sex or gender identity.   
[
    "The data is up to date as of May 2023."
]
 We converted the original data with the years of the legalization of same-sex marriage into a expanded dataset with the legal status of same-sex marriage for each country and year. We estimated regional aggregations of these status by using [Our World in Data definitions of regions](https://ourworldindata.org/world-region-map-definitions) and our [consolidated population data](https://ourworldindata.org/population-sources). 
[
    {
        "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 
[]
 a5a9f8c1cac33711450c4384436f1a72 26636c914d7c4ef8f9b8201f200921ed
935571 Population in countries where same-sex marriage is legal   Population by country and year. 2024-06-17 15:46:03 2024-07-25 23:08:49     2000-2023 Same-sex marriage around the world - Pew Research Center 6569     
{
    "name": "Legal",
    "tolerance": 0,
    "numDecimalPlaces": 0
}
 0     legal_status_legal_pop grapher/pew/2024-06-03/same_sex_marriage/same_sex_marriage#legal_status_legal_pop   2 major   Population in countries where same-sex marriage is legal       Same-sex marriage is marriage and marriage recognition between two people of the same biological sex or gender identity.   
[
    "The data is up to date as of May 2023."
]
 We converted the original data with the years of the legalization of same-sex marriage into a expanded dataset with the legal status of same-sex marriage for each country and year. We estimated regional aggregations of these status by using [Our World in Data definitions of regions](https://ourworldindata.org/world-region-map-definitions) and our [consolidated population data](https://ourworldindata.org/population-sources). 
[
    {
        "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 
[]
 fa2e18853a04e2bace5e139b3ffbe8c2 272864f10e94a783ec71e8fc5c04066a
935570 Number of countries where same-sex marriage is legal     2024-06-17 15:46:03 2024-07-25 23:08:49     2000-2023 Same-sex marriage around the world - Pew Research Center 6569     
{
    "name": "Legal",
    "tolerance": 0,
    "numDecimalPlaces": 0
}
 0     legal_status_legal_count grapher/pew/2024-06-03/same_sex_marriage/same_sex_marriage#legal_status_legal_count   2 major   Number of countries where same-sex marriage is legal       Same-sex marriage is marriage and marriage recognition between two people of the same biological sex or gender identity.   
[
    "The data is up to date as of May 2023."
]
 We converted the original data with the years of the legalization of same-sex marriage into a expanded dataset with the legal status of same-sex marriage for each country and year. We estimated regional aggregations of these status by using [Our World in Data definitions of regions](https://ourworldindata.org/world-region-map-definitions) and our [consolidated population data](https://ourworldindata.org/population-sources).       int 
[]
 5abcbfc5bff453a37cce604a1be4c319 941f721c9a5384f90b9c02f24e5cf1b9
935569 Legal status of same-sex marriage     2024-06-17 15:46:03 2024-07-25 23:08:49     2000-2023 Same-sex marriage around the world - Pew Research Center 6569     
{
    "name": "Legal status of same-sex marriage",
    "tolerance": 0,
    "numDecimalPlaces": 0
}
 0     legal_status grapher/pew/2024-06-03/same_sex_marriage/same_sex_marriage#legal_status   2 major   Legal status of same-sex marriage       Describes the legislation status of same-sex marriage. This is marriage and marriage recognition between two people of the same biological sex or gender identity.   
[
    "The data is up to date as of May 2023."
]
 We converted the original data with the years of the legalization of same-sex marriage into a expanded dataset with the legal status of same-sex marriage for each country and year. We estimated regional aggregations of these status by using [Our World in Data definitions of regions](https://ourworldindata.org/world-region-map-definitions) and our [consolidated population data](https://ourworldindata.org/population-sources).       string 
[]
 d06f3f77e85afd435a0dae802d6c7854 a1a89916f90440b63e2eb393634797bb

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");