Recipes 🧑‍🍳

ClimateDB SQL queries to get you started

Sum of CDR tons purchased by method

select cdr_method, sum(tons_purchased) total_purchased
from emissions.cdr_purchases
group by 1, 2
order by 2 desc

Average Atmospheric CO2 Concentration

select date, average
from climate.co2_monthly_concentration
order by 1 asc

EPA CO2 Emissions by Sector

select latest_reported_industry_type_sectors, year, sum(emissions)
from emissions.ghgrp_facilities f
left join emissions.ghgrp_emissions_by_years eby
on f.id = eby.facility_id
where latest_reported_industry_type_sectors in ('Pulp and Paper', 'Waste', 'Power Plants')
group by 1,2
order by 2 desc