sources
Data license: CC-BY
1 row where datasetId = 975 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
6834 | Long-term per capita fossil fuels - OWID based on UN, Gapminder, BP, Etemad & Luciana | { "link": "http://www.tsp-data-portal.org/", "retrievedDate": "18/10/2017", "additionalInfo": "Average per capita fossil fuel production - for coal, oil and gas - was calculated by OWID based on published population and national fossil fuel production data.\r\n\r\nPer capita fossil fuel production was calculated by dividing national production of coal, oil or gas by the total population in any given year.\r\n\r\nPopulation data was sourced from a combination of Gapminder sources (for data pre-1950), and from 1950 onwards was sourced from the UN Population Division's 2017 Revision.\r\n\r\nFossil fuel production data was sourced from a combination of sources.\r\n\r\nGlobal data from 1800-1965 was sourced from Vaclav Smil's Updated and Revised Edition of his book, 'Energy Transitions: Global and National Perspectives' (2017). This book can be found on Smil's website at: http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/.\r\n\r\nGlobal data from 1965 onwards was sourced from BP Statistical Review of Global Energy. Available at: http://www.bp.com/statisticalreview [accessed 18th October 2017].\r\n\r\nData at the national and regional level is sourced from The SHIFT Project Data Portal, who draws upon Etemad & Luciana and US IEA Historical Statistics. Available at: http://www.tsp-data-portal.org/ [accessed 18th October 2017].\r\n\r\nLong-run data on UK coal output was sourced from the UK's Department for Energy and Climate Change (DECC). Historical coal data: coal production, availability and consumption 1853 to 2016. Available at: https://www.gov.uk/government/statistical-data-sets/historical-coal-data-coal-production-availability-and-consumption-1853-to-2011 [accessed 18th October 2017].", "dataPublishedBy": "Long-term per capita fossil fuels - OWID based on UN, Gapminder, BP, Etemad & Luciana", "dataPublisherSource": null } |
2017-10-18 17:17:40 | 2017-12-06 10:07:51 | Long-term per capita fossil fuels - OWID based on UN, Gapminder, BP, Etemad & Luciana 975 | Average per capita fossil fuel production - for coal, oil and gas - was calculated by OWID based on published population and national fossil fuel production data. Per capita fossil fuel production was calculated by dividing national production of coal, oil or gas by the total population in any given year. Population data was sourced from a combination of Gapminder sources (for data pre-1950), and from 1950 onwards was sourced from the UN Population Division's 2017 Revision. Fossil fuel production data was sourced from a combination of sources. Global data from 1800-1965 was sourced from Vaclav Smil's Updated and Revised Edition of his book, 'Energy Transitions: Global and National Perspectives' (2017). This book can be found on Smil's website at: http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/. Global data from 1965 onwards was sourced from BP Statistical Review of Global Energy. Available at: http://www.bp.com/statisticalreview [accessed 18th October 2017]. Data at the national and regional level is sourced from The SHIFT Project Data Portal, who draws upon Etemad & Luciana and US IEA Historical Statistics. Available at: http://www.tsp-data-portal.org/ [accessed 18th October 2017]. Long-run data on UK coal output was sourced from the UK's Department for Energy and Climate Change (DECC). Historical coal data: coal production, availability and consumption 1853 to 2016. Available at: https://www.gov.uk/government/statistical-data-sets/historical-coal-data-coal-production-availability-and-consumption-1853-to-2011 [accessed 18th October 2017]. | http://www.tsp-data-portal.org/ | Long-term per capita fossil fuels - OWID based on UN, Gapminder, BP, Etemad & Luciana |
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");