owid: variables: 4 rows where datasetId = 6605 sorted by id descending

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 = 6605 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	unit	createdAt	updatedAt	timespan	datasetId	shortUnit	display	shortName	catalogPath	schemaVersion	processingLevel	descriptionShort	descriptionKey	descriptionProcessing	grapherConfigETL	type	sort	dataChecksum	metadataChecksum
946943	Global private investment in AI	constant 2021 US$	2024-07-02 19:13:37	2024-07-22 08:46:10	2013-2023	AI Index Report 6605	$	{ "unit": "constant 2021 US$", "shortUnit": "$", "numDecimalPlaces": 0 }	world	grapher/artificial_intelligence/2024-06-28/ai_private_investment/ai_private_investment#world	2	major	Includes companies that received more than $1.5 million in investment (not adjusted for inflation). This data is expressed in US dollars, adjusted for inflation.	[ "The source is not clear about the extent to which investment figures cover infrastructure, computational power, and support services required to develop, deploy, and operationalize AI applications", "For more information on how the costs to train frontier AI models are distributed refer to the article [How Much Does It Cost to Train Frontier AI Models?](https://epochai.org/blog/how-much-does-it-cost-to-train-frontier-ai-models) by EPOCH." ]	- Reporting a time series of AI investments in nominal prices (i.e., without adjusting for inflation) means it makes little sense to compare observations across time; it is therefore not very useful. To make comparisons across time possible, one has to take into account that prices change (e.g., there is inflation). - It is not obvious how to adjust this time series for inflation, and we debated it at some length within our team. - It would be straightforward to adjust the time series for price changes if we knew the prices of the specific goods and services that these investments purchased. This would make it possible to calculate a volume measure of AI investments, and it would tell us how much these investments bought. But such a metric is not available. While a comprehensive price index is not available, we know that the cost for some crucial AI technology has fallen rapidly in price. - In the absence of a comprehensive price index that captures the price of AI-specific goods and services, one has to rely on one of the available metrics for the price of a bundle of goods and services. In the end we decided to use the US Consumer Price Index (CPI). - The US CPI does not provide us with a volume measure of AI goods and services, but it does capture the opportunity costs of these investments. The inflation adjustment of this time series of AI investments therefore lets us understand the size of these investments relative to whatever else these sums of money could have purchased.	{ "note": "This data is expressed in constant 2021 US$. Inflation adjustment is based on the US Consumer Price Index (CPI)." }	int	[]	28305173131de20638d8547d013d7f84	d8c732db75b18823fbc73cb87d4cf0d5
946942	Private investment in AI in the European Union and United Kingdom	constant 2021 US$	2024-07-02 19:13:37	2024-07-22 08:46:10	2013-2023	AI Index Report 6605	$	{ "unit": "constant 2021 US$", "shortUnit": "$", "numDecimalPlaces": 0 }	european_union_and_united_kingdom	grapher/artificial_intelligence/2024-06-28/ai_private_investment/ai_private_investment#european_union_and_united_kingdom	2	major	Includes companies that received more than $1.5 million in investment (not adjusted for inflation). This data is expressed in US dollars, adjusted for inflation.	[ "The source is not clear about the extent to which investment figures cover infrastructure, computational power, and support services required to develop, deploy, and operationalize AI applications", "For more information on how the costs to train frontier AI models are distributed refer to the article [How Much Does It Cost to Train Frontier AI Models?](https://epochai.org/blog/how-much-does-it-cost-to-train-frontier-ai-models) by EPOCH." ]	- Reporting a time series of AI investments in nominal prices (i.e., without adjusting for inflation) means it makes little sense to compare observations across time; it is therefore not very useful. To make comparisons across time possible, one has to take into account that prices change (e.g., there is inflation). - It is not obvious how to adjust this time series for inflation, and we debated it at some length within our team. - It would be straightforward to adjust the time series for price changes if we knew the prices of the specific goods and services that these investments purchased. This would make it possible to calculate a volume measure of AI investments, and it would tell us how much these investments bought. But such a metric is not available. While a comprehensive price index is not available, we know that the cost for some crucial AI technology has fallen rapidly in price. - In the absence of a comprehensive price index that captures the price of AI-specific goods and services, one has to rely on one of the available metrics for the price of a bundle of goods and services. In the end we decided to use the US Consumer Price Index (CPI). - The US CPI does not provide us with a volume measure of AI goods and services, but it does capture the opportunity costs of these investments. The inflation adjustment of this time series of AI investments therefore lets us understand the size of these investments relative to whatever else these sums of money could have purchased.	{ "note": "This data is expressed in constant 2021 US$. Inflation adjustment is based on the US Consumer Price Index (CPI)." }	int	[]	e097cda64a07628ed1435c88ee0eba36	9f5cbddd343b7ae01d14345a10724891
946941	Private investment in AI in the United States	constant 2021 US$	2024-07-02 19:13:37	2024-07-22 08:46:10	2013-2023	AI Index Report 6605	$	{ "unit": "constant 2021 US$", "shortUnit": "$", "numDecimalPlaces": 0 }	united_states	grapher/artificial_intelligence/2024-06-28/ai_private_investment/ai_private_investment#united_states	2	major	Includes companies that received more than $1.5 million in investment (not adjusted for inflation). This data is expressed in US dollars, adjusted for inflation.	[ "The source is not clear about the extent to which investment figures cover infrastructure, computational power, and support services required to develop, deploy, and operationalize AI applications", "For more information on how the costs to train frontier AI models are distributed refer to the article [How Much Does It Cost to Train Frontier AI Models?](https://epochai.org/blog/how-much-does-it-cost-to-train-frontier-ai-models) by EPOCH." ]	- Reporting a time series of AI investments in nominal prices (i.e., without adjusting for inflation) means it makes little sense to compare observations across time; it is therefore not very useful. To make comparisons across time possible, one has to take into account that prices change (e.g., there is inflation). - It is not obvious how to adjust this time series for inflation, and we debated it at some length within our team. - It would be straightforward to adjust the time series for price changes if we knew the prices of the specific goods and services that these investments purchased. This would make it possible to calculate a volume measure of AI investments, and it would tell us how much these investments bought. But such a metric is not available. While a comprehensive price index is not available, we know that the cost for some crucial AI technology has fallen rapidly in price. - In the absence of a comprehensive price index that captures the price of AI-specific goods and services, one has to rely on one of the available metrics for the price of a bundle of goods and services. In the end we decided to use the US Consumer Price Index (CPI). - The US CPI does not provide us with a volume measure of AI goods and services, but it does capture the opportunity costs of these investments. The inflation adjustment of this time series of AI investments therefore lets us understand the size of these investments relative to whatever else these sums of money could have purchased.	{ "note": "This data is expressed in constant 2021 US$. Inflation adjustment is based on the US Consumer Price Index (CPI)." }	int	[]	04afbd3f7585edd07b48de38a93f5dad	dfcdac5ddbd83c3157e235cdfd9a1432
946940	Private investment in AI in China	constant 2021 US$	2024-07-02 19:13:37	2024-07-22 08:46:10	2013-2023	AI Index Report 6605	$	{ "unit": "constant 2021 US$", "shortUnit": "$", "numDecimalPlaces": 0 }	china	grapher/artificial_intelligence/2024-06-28/ai_private_investment/ai_private_investment#china	2	major	Includes companies that received more than $1.5 million in investment (not adjusted for inflation). This data is expressed in US dollars, adjusted for inflation.	[ "The source is not clear about the extent to which investment figures cover infrastructure, computational power, and support services required to develop, deploy, and operationalize AI applications", "For more information on how the costs to train frontier AI models are distributed refer to the article [How Much Does It Cost to Train Frontier AI Models?](https://epochai.org/blog/how-much-does-it-cost-to-train-frontier-ai-models) by EPOCH." ]	- Reporting a time series of AI investments in nominal prices (i.e., without adjusting for inflation) means it makes little sense to compare observations across time; it is therefore not very useful. To make comparisons across time possible, one has to take into account that prices change (e.g., there is inflation). - It is not obvious how to adjust this time series for inflation, and we debated it at some length within our team. - It would be straightforward to adjust the time series for price changes if we knew the prices of the specific goods and services that these investments purchased. This would make it possible to calculate a volume measure of AI investments, and it would tell us how much these investments bought. But such a metric is not available. While a comprehensive price index is not available, we know that the cost for some crucial AI technology has fallen rapidly in price. - In the absence of a comprehensive price index that captures the price of AI-specific goods and services, one has to rely on one of the available metrics for the price of a bundle of goods and services. In the end we decided to use the US Consumer Price Index (CPI). - The US CPI does not provide us with a volume measure of AI goods and services, but it does capture the opportunity costs of these investments. The inflation adjustment of this time series of AI investments therefore lets us understand the size of these investments relative to whatever else these sums of money could have purchased.	{ "note": "This data is expressed in constant 2021 US$. Inflation adjustment is based on the US Consumer Price Index (CPI)." }	int	[]	0f423a895b3247ae4e14cc69121b0de1	52a89099d3ecff6d83039457abeb9e20

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