owid: sources: 2 rows where datasetId = 6018 sorted by id descending

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

2 rows where datasetId = 6018 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
28608	Clarke et al. (2022) via OECD (2023)	{ "link": "https://stats.oecd.org/Index.aspx?DataSetCode=AIRTRANS_CO2#", "retrievedDate": "2023-05-18", "additionalInfo": "\nThe OECD Air Transport CO\u2082 Emissions database includes annual, quarterly, and monthly information on CO\u2082 emissions related to commercial passenger, freight, and general aviation flights, on both a territory and a residence basis, for 186 countries. These CO\u2082 emissions are estimated by the OECD, based on a consistent methodology across countries.\n\nOECD database is updated by the end of the first month of each quarter with new data from the previous quarter.", "dataPublishedBy": "Clarke, D., et al. (2022), CO\u2082 Emissions from air transport: A near-real-time global database for policy analysis, OECD Statistics Working Papers, No. 2022/04, OECD Publishing, Paris, https://doi.org/10.1787/ecc9f16b-en." }	2023-08-25 14:26:27	2024-07-30 06:11:40	Air Transport CO2 Emissions 6018	The OECD Air Transport CO₂ Emissions database includes annual, quarterly, and monthly information on CO₂ emissions related to commercial passenger, freight, and general aviation flights, on both a territory and a residence basis, for 186 countries. These CO₂ emissions are estimated by the OECD, based on a consistent methodology across countries. OECD database is updated by the end of the first month of each quarter with new data from the previous quarter.	https://stats.oecd.org/Index.aspx?DataSetCode=AIRTRANS_CO2#	Clarke, D., et al. (2022), CO₂ Emissions from air transport: A near-real-time global database for policy analysis, OECD Statistics Working Papers, No. 2022/04, OECD Publishing, Paris, https://doi.org/10.1787/ecc9f16b-en.
27916	Clarke et al. (2022) via OECD (2023)	{ "link": "https://stats.oecd.org/Index.aspx?DataSetCode=AIRTRANS_CO2#", "retrievedDate": "2023-05-18", "additionalInfo": "The OECD Air Transport CO\u2082 Emissions database includes annual, quarterly, and monthly information on CO\u2082 emissions related to commercial passenger, freight, and general aviation flights, on both a territory and a residence basis, for 186 countries. These CO\u2082 emissions are estimated by the OECD, based on a consistent methodology across countries.\n\nOECD database is updated by the end of the first month of each quarter with new data from the previous quarter.", "dataPublishedBy": "Clarke, D., et al. (2022), CO\u2082 Emissions from air transport: A near-real-time global database for policy analysis, OECD Statistics Working Papers, No. 2022/04, OECD Publishing, Paris, https://doi.org/10.1787/ecc9f16b-en." }	2023-07-07 15:03:00	2024-07-30 06:11:40	Air Transport CO2 Emissions 6018	The OECD Air Transport CO₂ Emissions database includes annual, quarterly, and monthly information on CO₂ emissions related to commercial passenger, freight, and general aviation flights, on both a territory and a residence basis, for 186 countries. These CO₂ emissions are estimated by the OECD, based on a consistent methodology across countries. OECD database is updated by the end of the first month of each quarter with new data from the previous quarter.	https://stats.oecd.org/Index.aspx?DataSetCode=AIRTRANS_CO2#	Clarke, D., et al. (2022), CO₂ Emissions from air transport: A near-real-time global database for policy analysis, OECD Statistics Working Papers, No. 2022/04, OECD Publishing, Paris, https://doi.org/10.1787/ecc9f16b-en.

Advanced export

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

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");