Carbon Footprint export data schema

After configuring an export, a BigQuery table with the following schema is created:

Field Type Description Example
usage_month Date Month during which this usage occurred. 2021-10-01
billing_account_id String Cloud Billing account ID used for the carbon footprint export. 007GD7-15C0E6-BDE6B3
project.id String Google Cloud project identifier associated with the carbon footprint data. If data isn't associated with a project or project was deleted, then the project.id field is NULL. my-project
project.number String Google Cloud project number associated with the carbon footprint data. If data isn't associated with a project, then the project.number field is an empty string. 802583874831
service.description String Readable name for the Google Cloud service associated with the carbon footprint data. Cloud Run
service.id String Identifier of the Google Cloud service associated with the carbon footprint data. F17B-412E-CB64
location.location String Location of the carbon footprint at the level of a country, region, or zone. us-central1-a
location.region String Cloud region for the carbon footprint. us-central1
carbon_model_version Integer Version of carbon model that produced this output. This value is updated whenever the model is changed. 1
carbon_footprint_total_kgCO2e.after_offsets Float Total carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. Equivalent to scope 1 + scope 2 market-based + scope 3 + carbon offsets. Currently set to NULL. NULL
carbon_footprint_total_kgCO2e.market_based Float Total carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. Equivalent to scope 1 + scope 2 market-based + scope 3. 588.8
carbon_footprint_total_kgCO2e.location_based Float Total carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. Equivalent to scope 1 + scope 2 location-based + scope 3. 1587.3
carbon_footprint_kgCO2e.scope1 Float Total scope 1 carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. 10
carbon_footprint_kgCO2e.scope2.location_based Float Total scope 2 location-based carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. 400
carbon_footprint_kgCO2e.scope2.market_based Float Total scope 2 market-based carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. 105.8
carbon_footprint_kgCO2e.scope3 Float Total scope 3 carbon footprint for the account, project, service, location, and month in kg of CO2 equivalent. 986.8
carbon_offsets_kgCO2e Float Total carbon offsets for the account, project, service, location, and month in kg of CO2 equivalent. Currently set to NULL. NULL