variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

72 rows where datasetId = 5112 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
143359 Biofuels per capita (kWh)     2020-08-14 17:10:59 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143358 Biofuels (TWh growth – sub method)     2020-08-14 17:10:59 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143357 Biofuels (% growth)     2020-08-14 17:10:59 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143356 Biofuels (% sub energy)     2020-08-14 17:10:59 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143355 Biofuels (% primary direct energy)     2020-08-14 17:10:59 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143354 Biofuels (TWh)     2020-08-14 17:10:59 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Biofuels",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143237 Primary energy – direct (TWh)     2020-08-04 15:22:16 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143230 Low-carbon energy (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143229 Other renewables (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143228 Wind (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Wind",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143227 Solar (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Solar",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true
}
 0           1                                  
143226 Renewables (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143225 Nuclear (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Nuclear",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143224 Hydro (TWh – sub method)     2020-08-02 06:09:47 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Hydropower",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143221 Other renewables per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143220 Low-carbon energy per capita(kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Low-carbon",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143219 Fossil fuels per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143218 Renewables per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Renewables",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143217 Hydro per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Hydropower",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143216 Wind per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Wind",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143215 Solar per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Solar",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143214 Nuclear per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Nuclear",
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143213 Gas per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143212 Oil per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143211 Coal per capita (kWh)     2020-07-30 12:47:29 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "unit": "kilowatt-hours",
    "shortUnit": "kWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143050 Low-carbon energy (% primary direct energy)     2020-07-12 06:11:52 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Low-carbon energy",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
143049 Fossil Fuels (% primary direct energy)     2020-07-12 06:11:52 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Fossil Fuels",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
143048 Low-carbon energy (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Low-carbon energy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true
}
 0           1                                  
143047 Low-carbon energy (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Low-carbon energy",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143046 Fossil fuels (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Fossil fuels",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143045 Fossil fuels (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143044 Renewables (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Renewables",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true
}
 0           1                                  
143043 Renewables (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  
143042 Other renewables (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Other renewables",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143041 Other renewables (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Other renewables",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143040 Wind (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Wind",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143039 Wind (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Wind",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143038 Solar (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Solar",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143037 Solar (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Solar",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143036 Hydro (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Hydropower",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143035 Hydro (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Hydropower",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143034 Nuclear (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Nuclear",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143033 Nuclear (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Nuclear",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143032 Oil (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Oil",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143031 Oil (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Oil",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143030 Gas (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Gas",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143029 Gas (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Gas",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143028 Coal (TWh growth – sub method)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Coal",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "includeInTable": true
}
 0           1                                  
143027 Coal (% growth)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Coal",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143026 Low-carbon energy (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Low-carbon energy",
    "unit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    }
}
 0           1                                  
143025 Fossil fuels (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Fossil fuels",
    "unit": "%"
}
 0           1                                  
143024 Other renewables (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Other renewables",
    "unit": "%"
}
 0           1                                  
143023 Wind (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Wind",
    "unit": "%"
}
 0           1                                  
143022 Solar (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Solar",
    "unit": "%"
}
 0           1                                  
143021 Renewables (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Renewables",
    "unit": "%"
}
 0           1                                  
143020 Hydro (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Hydropower",
    "unit": "%"
}
 0           1                                  
143019 Nuclear (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Nuclear",
    "unit": "%"
}
 0           1                                  
143018 Oil (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Oil",
    "unit": "%"
}
 0           1                                  
143017 Gas (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Gas",
    "unit": "%"
}
 0           1                                  
143016 Coal (% sub energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Coal",
    "unit": "%"
}
 0           1                                  
143015 Other renewables (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Other renewables",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143014 Wind (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Wind",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143013 Solar (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Solar",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143012 Renewables (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Renewables",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143011 Hydro (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Hydropower",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143010 Nuclear (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Nuclear",
    "unit": "%",
    "includeInTable": true
}
 0           1                                  
143009 Oil (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Oil",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143008 Gas (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Gas",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143007 Coal (% primary direct energy)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Coal",
    "unit": "%",
    "shortUnit": "%",
    "includeInTable": true
}
 0           1                                  
143006 Low-carbon energy (TWh)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Low-carbon energy",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true,
    "numDecimalPlaces": 0
}
 0           1                                  
143005 Fossil Fuels (TWh)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{
    "name": "Fossil Fuels",
    "unit": "terawatt-hours",
    "shortUnit": "TWh",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143004 Primary energy (TWh)     2020-07-12 05:54:51 2023-06-15 05:05:42       Energy mix from BP (2020) 5112 Our World in Data based on BP Statistical Review of World Energy (2020) 17842   
{}
 0           1                                  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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