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

7 rows where datasetId = 6614 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, timespan, shortUnit, display, descriptionShort, type, 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
949121 Total AI PhD graduates PhD graduates   2024-07-10 09:35:48 2024-07-10 09:35:48     2010-2022 AI Index Report 6614     
{
    "unit": "PhD graduates",
    "numDecimalPlaces": 0
}
 0     total grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#total   2 minor           There is a subset of new AI PhDs each year who become self-employed, unemployed, or report an “other” employment status in the CRA survey. These students are not included in the chart.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 int 
[]
 dababefc92048b12b05d04ad9c899732 fefd569168e9685b8b28fc0a4299dd63
949120 Share identifying as "other/non-binary" among new computer science PhDs, United States and Canada %   2024-07-10 09:35:48 2024-07-10 09:35:49     2020-2022 AI Index Report 6614   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     nonbinary_other grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#nonbinary_other   2 minor           PhDs who graduated in the given year from academic units of computer science, computer engineering, and information that esponded to the Computing Research Association's Taulbee Survey.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 float 
[]
 6149517d01ee16f95db15fb3598d2f65 db343966ad7c153a20540dcc9c5e43e0
949119 Share of men among new computer science PhDs, United States and Canada %   2024-07-10 09:35:46 2024-07-10 09:35:48     2010-2022 AI Index Report 6614   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     male grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#male   2 minor           PhDs who graduated in the given year from academic units of computer science, computer engineering, and information that esponded to the Computing Research Association's Taulbee Survey.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 float 
[]
 c3c54e5059c57a77bc594301b2c5ab6a 89a618a8042106cc737be211072509a4
949118 AI PhD graduates employed in industry PhD graduates   2024-07-10 09:35:46 2024-07-10 09:35:48     2010-2022 AI Index Report 6614     
{
    "unit": "PhD graduates",
    "numDecimalPlaces": 0
}
 0     industry grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#industry   2 minor           There is a subset of new AI PhDs each year who become self-employed, unemployed, or report an “other” employment status in the CRA survey. These students are not included in the chart.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 int 
[]
 774ca389bf1c99b9626f953ec89d0772 2fc091c99ab64284ccf9a94d0dcade4c
949117 AI PhD graduates employed in government PhD graduates   2024-07-10 09:35:46 2024-07-10 09:35:48     2010-2022 AI Index Report 6614     
{
    "unit": "PhD graduates",
    "numDecimalPlaces": 0
}
 0     government grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#government   2 minor           There is a subset of new AI PhDs each year who become self-employed, unemployed, or report an “other” employment status in the CRA survey. These students are not included in the chart.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 int 
[]
 81de03e121d1cca7b8f48c7036a8e190 2b96160ac0d5e03f77be7648ff0ca0fb
949116 Share of women among new computer science PhDs, United States and Canada %   2024-07-10 09:35:46 2024-07-10 09:35:48     2010-2022 AI Index Report 6614   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 1
}
 0     female grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#female   2 minor           PhDs who graduated in the given year from academic units of computer science, computer engineering, and information that esponded to the Computing Research Association's Taulbee Survey.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 float 
[]
 795b7406f02959548b05c1028b5388df 3dce4ccad18503fbcca4726a1e3dcf25
949115 AI PhD graduates employed in academia PhD graduates   2024-07-10 09:35:46 2024-07-10 09:35:48     2010-2022 AI Index Report 6614     
{
    "unit": "PhD graduates",
    "numDecimalPlaces": 0
}
 0     academia grapher/artificial_intelligence/2024-06-28/ai_phds/ai_phds#academia   2 minor           There is a subset of new AI PhDs each year who become self-employed, unemployed, or report an “other” employment status in the CRA survey. These students are not included in the chart.   
[]
       
{
    "note": "Since 2004, total response rates for the Taulbee Survey have ranged between 61\u201383%. This means that not every graduate is included, and the share who are varies from year to year."
}
 int 
[]
 5fb2c9c14358da3fee9fa8a3cabdadaf f86c7e91104cd888b37fd886a99f32c4

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