sources
Data license: CC-BY
1 row where datasetId = 5843 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 |
---|---|---|---|---|---|---|---|---|
27238 | Our World in Data based on BP Statistical Review of World Energy (2022); Our World in Data based on EIA International energy data (2022); Maddison Project Database 2020 (Bolt and van Zanden, 2020) | { "link": "https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html ; https://www.eia.gov/opendata/bulkfiles.php ; https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020", "retrievedDate": "2022-07-08", "additionalInfo": "Primary energy consumption data was compiled by Our World in Data based on two key data sources:\n1. <a href=\"https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html\">BP Statistical Review of World Energy</a>.\n2. <a href=\"https://www.eia.gov/international/data/world/total-energy/more-total-energy-data\">International energy data from the U.S. Energy Information Administration (EIA)</a>.\n\nBP provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where BP provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures.\n\nPer capita figures have been calculated using a population dataset that is built and maintained by Our World in Data, based on <a href=\"https://ourworldindata.org/population-sources\">different sources</a>.\n\nTo calculate energy per unit of GDP, we use total real GDP figures from <a href=\"https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020\">the Maddison Project Database, version 2020</a>.\nThis dataset is based on Bolt, Jutta and Jan Luiten van Zanden (2020), \u201cMaddison style estimates of the evolution of the world economy. A new 2020 update \u201d. GDP is measured in 2011$ which are PPP-adjusted.\n\nBP's region definitions sometimes differ from Our World in Data's definitions. For example, BP's North America includes only Canada, Mexico and United States, whereas Our World in Data's North America includes countries in Central America (see a map with <a href=\"https://ourworldindata.org/world-region-map-definitions\">our region definitions</a>). For this reason, we include in the dataset regions like \"North America (BP)\" to refer to BP's original data using their definition of the region, as well as \"North America\", which is data aggregated by Our World in Data using our definition. These aggregates are constructed by adding up (when possible) the contributions from the countries in the region.\n\n<a href=\"https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy/using-the-review/definitions-and-explanatory-notes.html#accordion_Regional%20definitions\">BP's region definitions</a>, denoted with \"(BP)\", are:\n* \"Asia Pacific (BP)\": Brunei, Cambodia, China (Mainland), China Hong Kong SAR (Special Administrative Region), China Macau SAR (Special Administrative Region), Indonesia, Japan, Laos, Malaysia, Mongolia, North Korea, Philippines, Singapore, South Asia (Afghanistan, Bangladesh, India, Myanmar, Nepal, Pakistan and Sri Lanka), South Korea, Taiwan, Thailand, Vietnam, Australia, New Zealand, Papua New Guinea and Oceania.\n* \"Australasia (BP)\": Australia, New Zealand.\n* \"CIS (BP)\" - Commonwealth of Independent States: Armenia, Azerbaijan, Belarus, Kazakhstan, Kyrgyzstan, Moldova, Russian Federation, Tajikistan, Turkmenistan, Uzbekistan.\n* \"Caribbean (BP)\": Atlantic islands between the US Gulf Coast and South America, including Puerto Rico, US Virgin Islands and Bermuda.\n* \"Central America (BP)\": Belize, Costa Rica, El Salvador, Guatemala, Honduras, Nicaragua, Panama\n* \"Eastern Africa (BP)\": Territories on the east coast of Africa from Sudan to Mozambique. Also Madagascar, Malawi, Uganda, Zambia, Zimbabwe.\n* \"Europe (BP)\": European members of the OECD plus Albania, Bosnia-Herzegovina, Bulgaria, Croatia, Cyprus, Georgia, Gibraltar, Latvia, Lithuania, Malta, Montenegro, North Macedonia, Romania, Serbia and Ukraine.\n* \"Middle Africa (BP)\": Angola, Cameroon, Central African Republic, Chad, Democratic Republic of Congo, Republic of Congo, Equatorial Guinea, Gabon, Sao Tome & Principe.\n* \"Middle East (BP)\": Arabian Peninsula, Iran, Iraq, Israel, Jordan, Lebanon, Syria.\n* \"Non-OECD (BP)\" - Organization for Economic Co-operation and Development: All countries that are not members of the OECD.\n* \"North America (BP)\": US (excluding US territories), Canada, Mexico\n* \"Northern Africa (BP)\": Territories on the north coast of Africa from Egypt to Western Sahara.\n* \"OECD (BP)\" - Organization For Economic Co-operation and Development: Austria, Belgium, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Italy, Latvia, Lithuania, Luxembourg, Netherlands, Norway, Poland, Portugal, Slovakia, Slovenia, Spain, Sweden, Switzerland, Turkey, UK, Australia, Canada, Chile, Colombia, Israel, Japan, Mexico, New Zealand, South Korea, US.\n* \"OPEC (BP)\" - Organization of the Petroleum Exporting Countries: Iran, Iraq, Kuwait, Saudi Arabia, United Arab Emirates, Algeria, Libya, Angola, Equatorial Guinea, Gabon, Nigeria, Republic of Congo, Venezuela.\n* \"South and Central America (BP)\": Caribbean (including Puerto Rico and US Virgin Islands), Bermuda, Central and South America.\n* \"Southern Africa (BP)\": Botswana, Lesotho, Namibia, South Africa, Swaziland.\n* \"Western Africa (BP)\": Territories on the west coast of Africa from Mauritania to Nigeria, including Burkina Faso, Cape Verde, Mali and Niger.\n\nAdditionally, BP includes some regions that are not explicitly defined (e.g. \"Other Europe\", or \"Other CIS\"). We define our regions in the following way:\n* \"Africa\" - All African countries + \"Other Africa\".\n* \"Asia\" - All Asian countries + \"Other Middle East\" + \"Other CIS\" + \"Other Asia Pacific\".\n* \"Europe\" - All European countries + \"Other Europe\".\n* \"North America\" - All North American countries + \"Other Caribbean\" + \"Other North America\".\n* \"Oceania\" - All Oceanian countries.\n* \"South America\" - All South American countries + \"Other South America\".\nWhere the individual countries in each region are defined <a href=\"https://ourworldindata.org/world-region-map-definitions\">in this map</a>. Additional BP regions are ignored, since they belong to other regions already included (e.g. the data for \"Other Western Africa\" is included in \"Other Africa\"). Finally, income groups are constructed following the definitions <a href=\"https://ourworldindata.org/grapher/world-banks-income-groups\">in this map</a>.\n\nTotal energy consumption, extracted from EIA's international energy data from the EIA, downloaded using their <a href=\"https://www.eia.gov/opendata/bulkfiles.php\">Bulk Download Facility</a>.\n\nEIA's region definitions sometimes differ from Our World in Data's definitions. For example, in EIA's data, Russia is not included in Europe, whereas Our World in Data includes Russia in Europe (see a map with <a href=\"https://ourworldindata.org/world-region-map-definitions\">our region definitions</a>). For this reason, we include in the dataset regions like \"Europe (EIA)\" to refer to EIA's original data using their definition of the region, as well as \"Europe\", which is data aggregated by Our World in Data using our definition. These aggregates are constructed by adding up (when possible) the contributions from the countries in the region.\n", "dataPublishedBy": "BP Statistical Review of World Energy; U.S. Energy Information Administration (EIA); Bolt, Jutta and Jan Luiten van Zanden (2020), \u201cMaddison style estimates of the evolution of the world economy. A new 2020 update\u201c.", "dataPublisherSource": null } |
2022-12-30 18:11:51 | 2023-03-02 16:00:33 | Primary energy consumption (BP & EIA, 2022) 5843 | Primary energy consumption data was compiled by Our World in Data based on two key data sources: 1. <a href="https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html">BP Statistical Review of World Energy</a>. 2. <a href="https://www.eia.gov/international/data/world/total-energy/more-total-energy-data">International energy data from the U.S. Energy Information Administration (EIA)</a>. BP provides the longest and most up-to-date time-series of primary energy. However, it does not provide data for all countries. We have therefore supplemented this dataset with energy data from the EIA. Where BP provides data for a given country, this data is adopted; for countries where this data is missing, we rely on EIA energy figures. Per capita figures have been calculated using a population dataset that is built and maintained by Our World in Data, based on <a href="https://ourworldindata.org/population-sources">different sources</a>. To calculate energy per unit of GDP, we use total real GDP figures from <a href="https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020">the Maddison Project Database, version 2020</a>. This dataset is based on Bolt, Jutta and Jan Luiten van Zanden (2020), “Maddison style estimates of the evolution of the world economy. A new 2020 update ”. GDP is measured in 2011$ which are PPP-adjusted. BP's region definitions sometimes differ from Our World in Data's definitions. For example, BP's North America includes only Canada, Mexico and United States, whereas Our World in Data's North America includes countries in Central America (see a map with <a href="https://ourworldindata.org/world-region-map-definitions">our region definitions</a>). For this reason, we include in the dataset regions like "North America (BP)" to refer to BP's original data using their definition of the region, as well as "North America", which is data aggregated by Our World in Data using our definition. These aggregates are constructed by adding u… | https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html ; https://www.eia.gov/opendata/bulkfiles.php ; https://www.rug.nl/ggdc/historicaldevelopment/maddison/releases/maddison-project-database-2020 | BP Statistical Review of World Energy; U.S. Energy Information Administration (EIA); Bolt, Jutta and Jan Luiten van Zanden (2020), “Maddison style estimates of the evolution of the world economy. A new 2020 update“. |
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");