Climate Trace Data on Google BigQuery

The document outlines the structure and access requirements for the Climate TRACE public dataset on Google BigQuery, including a detailed data catalog of emissions, metadata, and sector-specific tables. It provides step-by-step instructions for querying the data, managing permissions, and exporting results via CSV, JSON, or Parquet formats, while noting that query costs are borne by the user.

• The Climate TRACE dataset on Google BigQuery is organized into several categories: emissions tables (including source, country, city, and GADM administrative boundary data), metadata tables (covering confidence, uncertainty, and ownership), Emissions Reduction Solutions (ERS) tables, and sector-specific datasets for road transportation, domestic shipping, and international shipping.
• To access and query the public dataset, users must have a Google Cloud account and specific permissions on their own project, such as the bigquery.jobs.create permission, which is included in roles like Project Owner, BigQuery Job User, BigQuery User, or BigQuery Admin.
• Data is updated monthly, and users can identify the specific version of a table by checking the 'Labels' section in the BigQuery Console (e.g., v5_1_0).
• Data export is supported through three methods: downloading query results as csv, json, or parquet for small to medium datasets; exporting large datasets to Google Cloud Storage as Parquet; and using filtered exports via temporary tables.
• While storage costs for the public dataset are covered by Climate TRACE, all query and export costs are billed to the user's own Google Cloud project and billing account based on the amount of data processed.

APA

Climate TRACE (n.d.). Climate Trace Data on Google BigQuery. https://media.climatetrace.org/Climate_TRACE_Big_Query_Data_8713215f81.pdf

Chicago

Climate TRACE. Climate Trace Data on Google BigQuery. n.d. https://media.climatetrace.org/Climate_TRACE_Big_Query_Data_8713215f81.pdf.

Wikipedia

{{cite report |author=Climate TRACE |title=Climate Trace Data on Google BigQuery |url=https://media.climatetrace.org/Climate_TRACE_Big_Query_Data_8713215f81.pdf |access-date=23 October 2026 |via=Climate Insights Directory}}

BibTeX

@techreport{climatetracendclimate, author = {{Climate TRACE}}, title = {{Climate Trace Data on Google BigQuery}}, institution = {Climate TRACE}, url = {https://media.climatetrace.org/Climate_TRACE_Big_Query_Data_8713215f81.pdf}, urldate = {2026-10-23}, note = {Indexed by Climate Insights Directory} }