Global City Pollution and Green Energy Transition Set (WW)
ENECGT909· 57K records · 19 tables · v1.0.0 · Updated 2026-08-11
Public Sector & Statistics Climate & Environment Dataset API
Overview
This global urban transition product follows a consistent analytical sample of large cities across a longitudinal annual and monthly spine. Air-quality pollutants and guideline ratios connect to emission-source contributions, electricity mix, renewable projects, transport, buildings, waste, greenhouse-gas indicators, climate risk, health-burden proxies, policy actions, targets and leakage-controlled forecasts. Real city names provide geography while all measurements, projects, costs and effects are modelled. The product supports pollution diagnostics, transition planning, portfolio comparison, policy tracking, emissions analysis, health-context screening and forecast evaluation without claiming to reproduce official city measurements.
Row Counts by Table
Counted from the files that ship, not estimated.
| Table | Rows |
|---|---|
| city_transition_cities | 50 |
| city_transition_years | 12 |
| city_transition_countries | 31 |
| city_transition_pollutants | 6 |
| city_transition_emission_sources | 6 |
| city_transition_annual_air_quality | 3,600 |
| city_transition_monthly_air_quality | 43,200 |
| city_transition_source_contributions | 3,600 |
| city_transition_energy_mix | 600 |
| city_transition_renewable_projects | 600 |
| city_transition_transport_indicators | 600 |
| city_transition_building_indicators | 600 |
| city_transition_waste_indicators | 600 |
| city_transition_climate_indicators | 600 |
| city_transition_health_burden_proxies | 600 |
| city_transition_policies | 600 |
| city_transition_transition_targets | 600 |
| city_transition_forecast_features | 600 |
| city_transition_transition_forecasts | 600 |
Table Relationships
One parent record and seven child tables, each joined back on the same key.
70%
Loading diagram
Schema
Every table ships with typed columns, referential integrity, and documentation.
city_transition_cities· Rows: 50
| Column | Type | Description |
|---|---|---|
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| city_name | varchar(24) | Human-readable city name; names are fictional where the disclosure states so. |
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| latitude | numeric(6,2) | Latitude for the city_transition_cities record. |
| longitude | numeric(7,2) | Longitude for the city_transition_cities record. |
| population_2015_millions | numeric(5,1) | Population 2015 millions for the city_transition_cities record. |
+5 more columns in city_transition_cities. The full schema ships with the download.
city_transition_years· Rows: 12
| Column | Type | Description |
|---|---|---|
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| calendar_year | integer | Calendar year for the city_transition_years record. |
| source_status | varchar(32) | source status in the declared lifecycle, result or source-status vocabulary. |
| vintage_date | date | vintage date as an ISO 8601 calendar date. |
city_transition_countries· Rows: 31
| Column | Type | Description |
|---|---|---|
| country_id | varchar(8) | Stable identifier for country; use it for declared joins. |
| country_code | varchar(8) | Stable code for country. |
| country_name | varchar(40) | Human-readable country name; names are fictional where the disclosure states so. |
| region_name | varchar(16) | Human-readable region name; names are fictional where the disclosure states so. |
| official_geography_flag | boolean | Boolean indicator for official geography. |
city_transition_pollutants· Rows: 6
| Column | Type | Description |
|---|---|---|
| pollutant_id | varchar(8) | Stable identifier for pollutant; use it for declared joins. |
| pollutant_code | varchar(8) | Stable code for pollutant. |
| pollutant_name | varchar(24) | Human-readable pollutant name; names are fictional where the disclosure states so. |
| unit | varchar(16) | Unit for the city_transition_pollutants record. |
| guideline_reference_value | integer | Guideline reference value for the city_transition_pollutants record. |
city_transition_emission_sources· Rows: 6
| Column | Type | Description |
|---|---|---|
| emission_source_id | varchar(8) | Stable identifier for emission source; use it for declared joins. |
| source_code | varchar(8) | Stable code for source. |
| source_name | varchar(32) | Human-readable source name; names are fictional where the disclosure states so. |
| source_group | varchar(32) | Source group for the city_transition_emission_sources record. |
city_transition_annual_air_quality· Rows: 3,600
| Column | Type | Description |
|---|---|---|
| annual_air_quality_id | varchar(16) | Stable identifier for annual air quality; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| pollutant_id | varchar(8) | Stable identifier for pollutant; use it for declared joins. |
| annual_mean_concentration | numeric(7,2) | Annual mean concentration for the city_transition_annual_air_quality record. |
| guideline_reference_value | integer | Guideline reference value for the city_transition_annual_air_quality record. |
| guideline_ratio | numeric(7,3) | Guideline ratio for the city_transition_annual_air_quality record. |
+5 more columns in city_transition_annual_air_quality. The full schema ships with the download.
city_transition_monthly_air_quality· Rows: 43,200
| Column | Type | Description |
|---|---|---|
| monthly_air_quality_id | varchar(24) | Stable identifier for monthly air quality; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| pollutant_id | varchar(8) | Stable identifier for pollutant; use it for declared joins. |
| month_number | varchar(8) | Month number for the city_transition_monthly_air_quality record. |
| mean_concentration | numeric(7,2) | Mean concentration for the city_transition_monthly_air_quality record. |
| maximum_daily_concentration | numeric(7,2) | Maximum daily concentration for the city_transition_monthly_air_quality record. |
+5 more columns in city_transition_monthly_air_quality. The full schema ships with the download.
city_transition_source_contributions· Rows: 3,600
| Column | Type | Description |
|---|---|---|
| source_contribution_id | varchar(16) | Stable identifier for source contribution; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| emission_source_id | varchar(8) | Stable identifier for emission source; use it for declared joins. |
| pm25_contribution_pct | numeric(6,2) | pm25 contribution expressed as a percentage. |
| nox_contribution_pct | numeric(6,2) | nox contribution expressed as a percentage. |
| co2e_emissions_mt | numeric(8,3) | Co2e emissions mt for the city_transition_source_contributions record. |
+3 more columns in city_transition_source_contributions. The full schema ships with the download.
city_transition_energy_mix· Rows: 600
| Column | Type | Description |
|---|---|---|
| energy_mix_id | varchar(16) | Stable identifier for energy mix; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| electricity_demand_twh | numeric(7,2) | Electricity demand twh for the city_transition_energy_mix record. |
| renewable_electricity_share_pct | numeric(6,2) | renewable electricity share expressed as a percentage. |
| coal_share_pct | numeric(6,2) | coal share expressed as a percentage. |
| gas_share_pct | numeric(6,2) | gas share expressed as a percentage. |
+6 more columns in city_transition_energy_mix. The full schema ships with the download.
city_transition_renewable_projects· Rows: 600
| Column | Type | Description |
|---|---|---|
| renewable_project_id | varchar(16) | Stable identifier for renewable project; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| project_type | varchar(24) | Project type for the city_transition_renewable_projects record. |
| project_stage | varchar(16) | Project stage for the city_transition_renewable_projects record. |
| capacity_mw | numeric(6,1) | Capacity mw for the city_transition_renewable_projects record. |
| annual_generation_gwh | numeric(7,1) | Annual generation gwh for the city_transition_renewable_projects record. |
+5 more columns in city_transition_renewable_projects. The full schema ships with the download.
city_transition_transport_indicators· Rows: 600
| Column | Type | Description |
|---|---|---|
| transport_indicator_id | varchar(16) | Stable identifier for transport indicator; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| public_transport_share_pct | numeric(6,2) | public transport share expressed as a percentage. |
| walking_cycling_share_pct | numeric(6,2) | walking cycling share expressed as a percentage. |
| electric_vehicle_share_pct | numeric(6,2) | electric vehicle share expressed as a percentage. |
| zero_emission_bus_share_pct | numeric(6,2) | zero emission bus share expressed as a percentage. |
+4 more columns in city_transition_transport_indicators. The full schema ships with the download.
city_transition_building_indicators· Rows: 600
| Column | Type | Description |
|---|---|---|
| building_indicator_id | varchar(16) | Stable identifier for building indicator; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| building_energy_kwh_sqm | numeric(7,2) | Building energy kwh sqm for the city_transition_building_indicators record. |
| green_building_floor_share_pct | numeric(6,2) | green building floor share expressed as a percentage. |
| heat_pump_share_pct | numeric(6,2) | heat pump share expressed as a percentage. |
| building_retrofit_rate_pct | numeric(5,2) | building retrofit rate expressed as a percentage. |
+3 more columns in city_transition_building_indicators. The full schema ships with the download.
city_transition_waste_indicators· Rows: 600
| Column | Type | Description |
|---|---|---|
| waste_indicator_id | varchar(16) | Stable identifier for waste indicator; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| municipal_waste_kg_per_capita | numeric(6,1) | Municipal waste kg per capita for the city_transition_waste_indicators record. |
| collection_coverage_pct | numeric(5,1) | collection coverage expressed as a percentage. |
| recycling_rate_pct | numeric(5,1) | recycling rate expressed as a percentage. |
| organic_diversion_pct | numeric(5,1) | organic diversion expressed as a percentage. |
+3 more columns in city_transition_waste_indicators. The full schema ships with the download.
city_transition_climate_indicators· Rows: 600
| Column | Type | Description |
|---|---|---|
| climate_indicator_id | varchar(16) | Stable identifier for climate indicator; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| territorial_co2e_mt | numeric(8,3) | Territorial co2e mt for the city_transition_climate_indicators record. |
| per_capita_co2e_tonnes | numeric(6,2) | Per capita co2e tonnes for the city_transition_climate_indicators record. |
| renewable_capacity_mw | numeric(8,1) | Renewable capacity mw for the city_transition_climate_indicators record. |
| energy_intensity_index_2015_100 | numeric(7,2) | energy intensity index 2015 100 as the declared analytical score or index. |
+4 more columns in city_transition_climate_indicators. The full schema ships with the download.
city_transition_health_burden_proxies· Rows: 600
| Column | Type | Description |
|---|---|---|
| health_burden_proxy_id | varchar(16) | Stable identifier for health burden proxy; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| population_exposed_millions | numeric(6,2) | Population exposed millions for the city_transition_health_burden_proxies record. |
| pm25_attributable_risk_index | numeric(7,2) | pm25 attributable risk index as the declared analytical score or index. |
| respiratory_admission_index | numeric(7,2) | respiratory admission index as the declared analytical score or index. |
| cardiovascular_admission_index | numeric(7,2) | cardiovascular admission index as the declared analytical score or index. |
+4 more columns in city_transition_health_burden_proxies. The full schema ships with the download.
city_transition_policies· Rows: 600
| Column | Type | Description |
|---|---|---|
| policy_id | varchar(16) | Stable identifier for policy; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| policy_area | varchar(24) | Policy area for the city_transition_policies record. |
| policy_name | varchar(64) | Human-readable policy name; names are fictional where the disclosure states so. |
| adoption_date | date | adoption date as an ISO 8601 calendar date. |
| policy_status | varchar(32) | policy status in the declared lifecycle, result or source-status vocabulary. |
+5 more columns in city_transition_policies. The full schema ships with the download.
city_transition_transition_targets· Rows: 600
| Column | Type | Description |
|---|---|---|
| transition_target_id | varchar(16) | Stable identifier for transition target; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| target_type | varchar(32) | Target type for the city_transition_transition_targets record. |
| baseline_year | integer | Baseline year for the city_transition_transition_targets record. |
| target_year | integer | Target year for the city_transition_transition_targets record. |
| baseline_value | numeric(7,2) | Baseline value for the city_transition_transition_targets record. |
+5 more columns in city_transition_transition_targets. The full schema ships with the download.
city_transition_forecast_features· Rows: 600
| Column | Type | Description |
|---|---|---|
| forecast_feature_id | varchar(16) | Stable identifier for forecast feature; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| feature_source_cutoff | date | Latest source date available to this feature row; it is strictly earlier than the target event or period when history exists. |
| lag_pm25_1y | numeric(7,2) | Lag pm25 1y for the city_transition_forecast_features record. |
| lag_renewable_share_1y | numeric(6,2) | Lag renewable share 1y for the city_transition_forecast_features record. |
| lag_transport_co2e_1y | numeric(7,3) | Lag transport co2e 1y for the city_transition_forecast_features record. |
+6 more columns in city_transition_forecast_features. The full schema ships with the download.
city_transition_transition_forecasts· Rows: 600
| Column | Type | Description |
|---|---|---|
| transition_forecast_id | varchar(16) | Stable identifier for transition forecast; use it for declared joins. |
| forecast_feature_id | varchar(16) | Stable identifier for forecast feature; use it for declared joins. |
| city_id | varchar(8) | Stable identifier for city; use it for declared joins. |
| year_id | varchar(8) | Stable identifier for year; use it for declared joins. |
| forecast_created_on | date | forecast created on as an ISO 8601 calendar date. |
| model_version | varchar(24) | Model version for the city_transition_transition_forecasts record. |
| predicted_pm25 | numeric(7,2) | Predicted pm25 for the city_transition_transition_forecasts record. |
+7 more columns in city_transition_transition_forecasts. The full schema ships with the download.
Sample Data
A snapshot of real rows from the dataset (values are fully synthetic).
| annual_air_quality_id | city_id | year_id | pollutant_id | annual_mean_concentration | guideline_reference_value | guideline_ratio | days_above_local_threshold | monitoring_coverage_pct | data_quality_band | source_status |
|---|---|---|---|---|---|---|---|---|---|---|
| AAQ00120151 | CTY001 | Y2015 | POL1 | 13.12 | 5 | 2.624 | 215 | 42 | moderate | modelled_observation |
| AAQ00120152 | CTY001 | Y2015 | POL2 | 28.45 | 15 | 1.897 | 136 | 42 | moderate | modelled_observation |
| AAQ00120153 | CTY001 | Y2015 | POL3 | 24.24 | 10 | 2.424 | 197 | 42 | moderate | modelled_observation |
Version History
| v1.0.0 | 2026-08-11 | First release with complete relational coverage, deterministic generation, documentation, SQL, JSON, CSV and API schema. |
Related Datasets
Europe Demography and Financial Indicators Set (EU)
Public Sector & StatisticsA linked European country-year warehouse covering population, age, work, income, growth, industry, education, banking, debt, inclusion and financial risk.
$69one time
View details Latin America Demography and Financial Indicators Set (LATAM)
Public Sector & StatisticsA linked Latin American country-year warehouse covering population, age, work, income, growth, industry, education, banking, debt, inclusion and financial risk.
$69one time
View details North America Demography and Financial Indicators Set (NA)
Public Sector & StatisticsA linked North American country-year warehouse covering population, age, work, income, growth, industry, education, banking, debt, inclusion and financial risk.
$69one time
View details