variables
Data license: CC-BY
42 rows where datasetId = 5762 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, shortUnit, display, createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 525441 | Wind (%, substituted energy) | % | 2022-09-12 14:32:54 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Wind",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | wind__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#wind__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525440 | Wind (%, direct energy) | % | 2022-09-12 14:32:53 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Wind",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | wind__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#wind__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525439 | Traditional biomass (%, substituted energy) | % | 2022-09-12 14:32:52 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Traditional biomass",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | traditional_biomass__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#traditional_biomass__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525438 | Traditional biomass (%, direct energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Traditional biomass",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | traditional_biomass__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#traditional_biomass__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525437 | Solar (%, substituted energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Solar",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | solar__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#solar__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525436 | Other renewables (%, substituted energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Other renewables",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | other_renewables__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#other_renewables__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525435 | Other renewables (%, direct energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Other renewables",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | other_renewables__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#other_renewables__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525434 | Solar (%, direct energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Solar",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | solar__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#solar__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525433 | Oil (%, substituted energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Oil",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | oil__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#oil__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525432 | Nuclear (%, substituted energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Nuclear",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | nuclear__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#nuclear__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525431 | Oil (%, direct energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Oil",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | oil__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#oil__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525430 | Nuclear (%, direct energy) | % | 2022-09-12 14:32:51 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Nuclear",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | nuclear__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#nuclear__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525429 | Hydropower (%, substituted energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Hydropower",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | hydropower__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#hydropower__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525428 | Gas (%, substituted energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Natural gas",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | gas__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#gas__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525427 | Hydropower (%, direct energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Hydropower",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | hydropower__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#hydropower__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525426 | Gas (%, direct energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Natural gas",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | gas__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#gas__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525425 | Coal (%, substituted energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Coal",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | coal__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#coal__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525424 | Coal (%, direct energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Coal",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | coal__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#coal__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525423 | Biofuels (%, direct energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Modern biofuels",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | biofuels__pct_of_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#biofuels__pct_of_direct_energy | 1 | |||||||||||||||||||||
| 525422 | Biofuels (%, substituted energy) | % | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | % | {
"name": "Modern biofuels",
"unit": "%",
"shortUnit": "%"
} |
0 | null | null | biofuels__pct_of_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#biofuels__pct_of_substituted_energy | 1 | |||||||||||||||||||||
| 525421 | Total consumption (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Total consumption",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | total_consumption__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#total_consumption__twh_direct_energy | 1 | |||||||||||||||||||||
| 525420 | Total consumption (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:49 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Total consumption",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | total_consumption__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#total_consumption__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525419 | Wind (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Wind",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | wind__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#wind__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525418 | Wind (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Wind",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | wind__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#wind__twh_direct_energy | 1 | |||||||||||||||||||||
| 525417 | Traditional biomass (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Traditional biomass",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | traditional_biomass__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#traditional_biomass__twh_direct_energy | 1 | |||||||||||||||||||||
| 525416 | Solar (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Solar",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | solar__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#solar__twh_direct_energy | 1 | |||||||||||||||||||||
| 525415 | Traditional biomass (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Traditional biomass",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | traditional_biomass__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#traditional_biomass__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525414 | Solar (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Solar",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | solar__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#solar__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525413 | Oil (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Oil",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | oil__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#oil__twh_direct_energy | 1 | |||||||||||||||||||||
| 525412 | Other renewables (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Other renewables",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | other_renewables__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#other_renewables__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525411 | Other renewables (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Other renewables",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | other_renewables__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#other_renewables__twh_direct_energy | 1 | |||||||||||||||||||||
| 525410 | Oil (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:46 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Oil",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | oil__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#oil__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525409 | Nuclear (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Nuclear",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | nuclear__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#nuclear__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525408 | Gas (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Natural gas",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | gas__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#gas__twh_direct_energy | 1 | |||||||||||||||||||||
| 525407 | Hydropower (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Hydropower",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | hydropower__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#hydropower__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525406 | Nuclear (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Nuclear",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | nuclear__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#nuclear__twh_direct_energy | 1 | |||||||||||||||||||||
| 525405 | Coal (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Coal",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | coal__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#coal__twh_direct_energy | 1 | |||||||||||||||||||||
| 525404 | Hydropower (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Hydropower",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | hydropower__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#hydropower__twh_direct_energy | 1 | |||||||||||||||||||||
| 525403 | Gas (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Natural gas",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | gas__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#gas__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525402 | Biofuels (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Modern biofuels",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | biofuels__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#biofuels__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525401 | Coal (TWh, substituted energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Coal",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | coal__twh_substituted_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#coal__twh_substituted_energy | 1 | |||||||||||||||||||||
| 525400 | Biofuels (TWh, direct energy) | terawatt-hours | 2022-09-12 14:32:44 | 2023-10-27 12:25:39 | 1800-2021 | Global Primary Energy (Smil & BP, 2022) 5762 | Our World in Data based on BP Statistical Review of World Energy (2022); Energy Transitions: Global and National Perspectives, 2nd edition, Appendix A (Vaclav Smil, 2017) 27333 | TWh | {
"name": "Modern biofuels",
"unit": "terawatt-hours",
"shortUnit": "TWh"
} |
0 | null | null | biofuels__twh_direct_energy | grapher/energy/2022-09-09/global_primary_energy/global_primary_energy#biofuels__twh_direct_energy | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");