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 CO₂ (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:

product_emissions

field	data type
id	VARCHAR
year	INT
product_name	VARCHAR
company	VARCHAR
country	VARCHAR
industry_group	VARCHAR
weight_kg	NUMERIC
carbon_footprint_pcf	NUMERIC
upstream_percent_total_pcf	VARCHAR
operations_percent_total_pcf	VARCHAR
downstream_percent_total_pcf	VARCHAR

You'll use this data to examine the carbon footprint of each industry in the dataset!