owid: sources: 1 row where datasetId = 663 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

1 row where datasetId = 663 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
2822	Long-term energy transitions - Energy History, Harvard (2016)	{ "link": "http://www.fas.harvard.edu/~histecon/energyhistory/energydata_beta.html", "retrievedDate": "08/08/2017", "additionalInfo": "Data published by the Joint Center for History and Economics has been sourced from a range of authors and publications, referenced below.\r\n\r\nThe authors note:\r\n\r\n1. Firewood consumption has been calculated in a variety of ways by the various authors. Sometimes totals are not included for the later part of the series, even if IEA or other organizations report it. The same applies to other forms of energy such as incinerated waste products;\r\n\r\n2. this work considers as primary electricity the following sources: geothermal (only for electricity); hydropower, nuclear power, wind, photo\u00advoltaics, tidals, wave and solar thermal (only for electricity). Generally electricity that has been derived from firewood, wastes, or other biomass is not included in \u2018primary electricity\u2019 as this entails thermal losses;\r\n\r\n3. non-energy uses of oil and natural gas are excluded from the totals.\r\n\r\nOriginal references:\r\n\r\nItaly: Malanima, Paolo, Energy consumption in Italy, 1861-2000, CNR (2006) in Kander et al, Power to the People (Princeton, 2013).\r\n\r\nPortugal: Henriques, S, Energy Transitions, Economic Growth and Structural Change: Portugal in a Long-run Comparative Perspective, Lund Studies in Economic History (2011).\r\n\r\nSpain: Elaborated by Mar Rubio for Kander, Astrid; Gales, Ben; Rubio, Mar; Paolo Malanima, \"North versus South: Energy transition and energy intensity in Europe over 200 years\", European Review of Economic History 11/2, (2007).\r\n\r\nFrance:Elaborated by Ben Gales, Paolo Malanima and Paul Warde for Kander et al, Power to the People (Princeton, 2013).\r\n\r\nGermany: Elaborated by Ben Gales and Paul Warde for Kander et al, Power to the People (Princeton, 2013).\r\n\r\nSweden: Kander, Astrid, Economic growth, energy consumption and CO2 emissions in Sweden, Lund Studies in Economic History, 2002, with further elaborations until 2008 from Swedish National Statistics.\r\n\r\nEngland and Wales:Updated from Warde, Paul, Energy Consumption in England & Wales, 1560-2004 (Naples: CNR, 2007).\r\n\r\nCanada: Richard W. Unger, John Thistle, Energy Consumption in Canada in the 19th and 20th Centuries. A Statistical Outline, (Naples: CNR, 2013)\r\n\r\nUruguay: Adapted from: Bertoni, Reto (2011). Energ\u00eda y desarrollo: la restricci\u00f3n energ\u00e9tica en Uruguay como problema, 1882-2000. Montevideo: Universidad de la Rep\u00fablica.", "dataPublishedBy": "Joint Center for History and Economics, Harvard University and University of Cambridge. Energy History.", "dataPublisherSource": "Literature sources (see references below)" }	2017-08-08 11:02:09	2017-11-20 18:09:08	Long-term energy transitions - Energy History, Harvard (2016) 663	Data published by the Joint Center for History and Economics has been sourced from a range of authors and publications, referenced below. The authors note: 1. Firewood consumption has been calculated in a variety of ways by the various authors. Sometimes totals are not included for the later part of the series, even if IEA or other organizations report it. The same applies to other forms of energy such as incinerated waste products; 2. this work considers as primary electricity the following sources: geothermal (only for electricity); hydropower, nuclear power, wind, photovoltaics, tidals, wave and solar thermal (only for electricity). Generally electricity that has been derived from firewood, wastes, or other biomass is not included in ‘primary electricity’ as this entails thermal losses; 3. non-energy uses of oil and natural gas are excluded from the totals. Original references: Italy: Malanima, Paolo, Energy consumption in Italy, 1861-2000, CNR (2006) in Kander et al, Power to the People (Princeton, 2013). Portugal: Henriques, S, Energy Transitions, Economic Growth and Structural Change: Portugal in a Long-run Comparative Perspective, Lund Studies in Economic History (2011). Spain: Elaborated by Mar Rubio for Kander, Astrid; Gales, Ben; Rubio, Mar; Paolo Malanima, "North versus South: Energy transition and energy intensity in Europe over 200 years", European Review of Economic History 11/2, (2007). France:Elaborated by Ben Gales, Paolo Malanima and Paul Warde for Kander et al, Power to the People (Princeton, 2013). Germany: Elaborated by Ben Gales and Paul Warde for Kander et al, Power to the People (Princeton, 2013). Sweden: Kander, Astrid, Economic growth, energy consumption and CO2 emissions in Sweden, Lund Studies in Economic History, 2002, with further elaborations until 2008 from Swedish National Statistics. England and Wales:Updated from Warde, Paul, Energy Consumption in England & Wales, 1560-2004 (Naples: CNR, 2007). Canada: Richard W. Unger, John Thistle, Energ…	http://www.fas.harvard.edu/~histecon/energyhistory/energydata_beta.html	Joint Center for History and Economics, Harvard University and University of Cambridge. Energy History.

id ▲

name

description

createdAt

updatedAt

datasetId

additionalInfo

link

dataPublishedBy

2822

Long-term energy transitions - Energy History, Harvard (2016)

{
    "link": "http://www.fas.harvard.edu/~histecon/energyhistory/energydata_beta.html",
    "retrievedDate": "08/08/2017",
    "additionalInfo": "Data published by the Joint Center for History and Economics has been sourced from a range of authors and publications, referenced below.\r\n\r\nThe authors note:\r\n\r\n1. Firewood consumption has been calculated in a variety of ways by the various authors. Sometimes totals are not included for the later part of the series, even if IEA or other organizations report it. The same applies to other forms of energy such as incinerated waste products;\r\n\r\n2. this work considers as primary electricity the following sources: geothermal (only for electricity); hydropower, nuclear power, wind, photo\u00advoltaics, tidals, wave and solar thermal (only for electricity). Generally electricity that has been derived from firewood, wastes, or other biomass is not included in \u2018primary electricity\u2019 as this entails thermal losses;\r\n\r\n3. non-energy uses of oil and natural gas are excluded from the totals.\r\n\r\nOriginal references:\r\n\r\nItaly: Malanima, Paolo, Energy consumption in Italy, 1861-2000, CNR (2006) in Kander et al, Power to the People (Princeton, 2013).\r\n\r\nPortugal: Henriques, S, Energy Transitions, Economic Growth and Structural Change: Portugal in a Long-run Comparative Perspective, Lund Studies in Economic History (2011).\r\n\r\nSpain: Elaborated by Mar Rubio for Kander, Astrid; Gales, Ben; Rubio, Mar; Paolo Malanima, \"North versus South: Energy transition and energy intensity in Europe over 200 years\", European Review of Economic History 11/2, (2007).\r\n\r\nFrance:Elaborated by Ben Gales, Paolo Malanima and Paul Warde for Kander et al, Power to the People (Princeton, 2013).\r\n\r\nGermany: Elaborated by Ben Gales and Paul Warde for Kander et al, Power to the People (Princeton, 2013).\r\n\r\nSweden: Kander, Astrid, Economic growth, energy consumption and CO2 emissions in Sweden, Lund Studies in Economic History, 2002, with further elaborations until 2008 from Swedish National Statistics.\r\n\r\nEngland and Wales:Updated from Warde, Paul, Energy Consumption in England & Wales, 1560-2004 (Naples: CNR, 2007).\r\n\r\nCanada: Richard W. Unger, John Thistle, Energy Consumption in Canada in the 19th and 20th Centuries. A Statistical Outline, (Naples: CNR, 2013)\r\n\r\nUruguay: Adapted from: Bertoni, Reto (2011). Energ\u00eda y desarrollo: la restricci\u00f3n energ\u00e9tica en Uruguay como problema, 1882-2000. Montevideo: Universidad de la Rep\u00fablica.",
    "dataPublishedBy": "Joint Center for History and Economics, Harvard University and University of Cambridge. Energy History.",
    "dataPublisherSource": "Literature sources (see references below)"
}

2017-08-08 11:02:09

2017-11-20 18:09:08

Long-term energy transitions - Energy History, Harvard (2016) 663

Data published by the Joint Center for History and Economics has been sourced from a range of authors and publications, referenced below. The authors note: 1. Firewood consumption has been calculated in a variety of ways by the various authors. Sometimes totals are not included for the later part of the series, even if IEA or other organizations report it. The same applies to other forms of energy such as incinerated waste products; 2. this work considers as primary electricity the following sources: geothermal (only for electricity); hydropower, nuclear power, wind, photovoltaics, tidals, wave and solar thermal (only for electricity). Generally electricity that has been derived from firewood, wastes, or other biomass is not included in ‘primary electricity’ as this entails thermal losses; 3. non-energy uses of oil and natural gas are excluded from the totals. Original references: Italy: Malanima, Paolo, Energy consumption in Italy, 1861-2000, CNR (2006) in Kander et al, Power to the People (Princeton, 2013). Portugal: Henriques, S, Energy Transitions, Economic Growth and Structural Change: Portugal in a Long-run Comparative Perspective, Lund Studies in Economic History (2011). Spain: Elaborated by Mar Rubio for Kander, Astrid; Gales, Ben; Rubio, Mar; Paolo Malanima, "North versus South: Energy transition and energy intensity in Europe over 200 years", European Review of Economic History 11/2, (2007). France:Elaborated by Ben Gales, Paolo Malanima and Paul Warde for Kander et al, Power to the People (Princeton, 2013). Germany: Elaborated by Ben Gales and Paul Warde for Kander et al, Power to the People (Princeton, 2013). Sweden: Kander, Astrid, Economic growth, energy consumption and CO2 emissions in Sweden, Lund Studies in Economic History, 2002, with further elaborations until 2008 from Swedish National Statistics. England and Wales:Updated from Warde, Paul, Energy Consumption in England & Wales, 1560-2004 (Naples: CNR, 2007). Canada: Richard W. Unger, John Thistle, Energ…

http://www.fas.harvard.edu/~histecon/energyhistory/energydata_beta.html

Joint Center for History and Economics, Harvard University and University of Cambridge. Energy History.

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