sources
Data license: CC-BY
1 row where datasetId = 5842 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 |
---|---|---|---|---|---|---|---|---|
27237 | Our World in Data based on BP Statistical Review of World Energy (2022); Our World in Data based on The Shift Dataportal (2022) | { "link": "https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html ; https://www.theshiftdataportal.org/energy", "retrievedDate": "2022-07-08", "additionalInfo": "This dataset on fossil fuel production is generated by combining the latest data from <a href=\"https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html\">the BP Statistical Review of World Energy</a> and <a href=\"https://www.theshiftdataportal.org/energy\">The Shift Dataportal</a>.\n\nBP provide fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016.\n\nTo maintain consistency with the energy datasets on Our World in Data, we have taken BP data as preference - meaning if BP provides data for the given country and year, this is used. Where data is not available from BP for a given country, or pre-1965 we rely on data from Shift.\n\nWe have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278.\n\nProduction per capita has 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\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", "dataPublishedBy": "BP Statistical Review of World Energy; The Shift Dataportal", "dataPublisherSource": null } |
2022-12-30 18:08:26 | 2023-03-02 16:00:42 | Fossil fuel production (BP & Shift, 2022b) 5842 | This dataset on fossil fuel production is generated by combining the latest data from <a href="https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html">the BP Statistical Review of World Energy</a> and <a href="https://www.theshiftdataportal.org/energy">The Shift Dataportal</a>. BP provide fossil fuel production data from 1965 onwards (and crude prices from 1861 onwards). The Shift Dataportal provides long-term data from 1900, but only extends to 2016. To maintain consistency with the energy datasets on Our World in Data, we have taken BP data as preference - meaning if BP provides data for the given country and year, this is used. Where data is not available from BP for a given country, or pre-1965 we rely on data from Shift. We have converted primary production in exajoules to terawatt-hours using the conversion factor: 1,000,000 / 3,600 ~ 278. Production per capita has 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>. 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 up (when possible) the contributions from the countries in the region. <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 wi… | https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html ; https://www.theshiftdataportal.org/energy | BP Statistical Review of World Energy; The Shift Dataportal |
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");