Photo by Maxim Tolchinskiy on Unsplash
When factoring heat generation required for the manufacturing and transportation of products, Greenhouse gas emissions attributable to products, from food to sneakers to appliances, make up more than 75% of global emissions. -The Carbon Catalogue
Our data, which is publicly available on nature.com, contains product carbon footprints (PCFs) for various companies. PCFs are the greenhouse gas emissions attributable to a given product, measured in CO2 (carbon dioxide equivalent).
This data is stored in a PostgreSQL database containing one table,
prouduct_emissions, which looks at PCFs by product as well as the stage of production that these emissions occurred. Here's a snapshot of what
product_emissions contains in each column:
You'll use this data to examine the carbon footprint of each industry in the dataset!
-- Find the most recent date SELECT MAX(year) AS recent_year FROM product_emissions;
-- Complete the query SELECT industry_group, COUNT(*) AS num_companies, ROUND(SUM(carbon_footprint_pcf),1) AS total_industry_footprint FROM product_emissions WHERE year = 2017 GROUP BY industry_group ORDER BY 3 DESC;