Working with factors
These pages show you how to use factor search and the factor pages to get a value you can defend: find it, read it, choose it, cite it, and take it away in a spreadsheet. None of them needs code.
Pick the page that matches the task in front of you:
- An activity and no factor yet: Find a factor.
- A page open and a value to understand: Read a factor page.
- Two candidates that both look right: Choosing between similar factors, which also covers spend factors and the price level.
- No idea which publisher to use: Choosing a library.
- The value chosen and the report to write: Cite a factor.
- Work to do in a spreadsheet: Export to a spreadsheet for the rows you filtered, or Download the open data for a whole library.
- A question about the data itself, rather than a task: see below.
Why not just use the publisher's own file#
A library published as a spreadsheet is usable on its own terms and hard to compare with the next one: its own category tree, its own region names, its own units, its own IPCC report, and a system boundary that is often implied rather than stated. Putting several libraries beside each other is most of the work of choosing a factor, and it is the work that was done here once so you do not repeat it per project.
- What was made comparable, theme by theme, with what it covers in each library: What open-climate.ai standardised.
- What exactly was changed on the way in, and how to read the publisher's own number back off the row: How factors are cleaned.
- The rules behind those changes, one page per convention: Methodology.
Nothing is guessed. A unit is rescaled only by a fixed ratio, a label is mapped to a controlled value only when the mapping is certain, and every change is recorded on the row it touched, so a reviewer can trace any served number back to the line the publisher printed.
In this section
- Find a factorSearch for a factor, narrow the results with the Filters rail, sort and choose columns, then open the factor page you need.
- Read a factor pageWhat each part of a factor page tells you, from the value and its provenance line to the year table, the gases, the parts and the citation.
- Choosing between similar factorsWhen several factors or values look right, check unit, region, year and boundary, then pick one value per methodology choice and never add them.
- Choosing a libraryPick a library by the country of the activity, its sector, the kind of data you hold and its licence, using the filters on the Libraries page.
- Cite a factorCopy the citation from a factor page, print the credit line that names the publisher and open-climate.ai, and read what its Dataset date means.
- Export to a spreadsheetExport the factors you filtered in factor search as a CSV or XLSX file, with the columns you chose and a licence column on every row. Needs a free account.
- Download the open dataGet a whole library as one standardised file, from the Open data page or a library page, and read what you are allowed to do with it.
- Save factors to come back toKeep a shortlist with the bookmark mark on a row, find it again with the Saved filter, and export only the factors you saved.
- Editions and updatesHow to read a library's Versions section, what Served, Superseded and Announced mean, and what changes for you when a new edition lands.
- Report a wrong value or a newer editionA value that looks wrong, or an edition newer than the one served: where the report form is, what to put in it, and what happens after you send it.
Query with SQL
- SQL guides
- Connect to factor search over SQL
- Quickstart: SQL
- Calculate emissions for a quantity
- Check that a decomposition sums to its parent
- Get the value for a past year
- Match a spend factor to your spend year
- Find a supplier-specific electricity factor
- Trace a served value back to its source line
- Add up factors across libraries
- See what was not imported, and why
- Keep only rows you may redistribute
- Pin a factor value to a release
- Which waste row to use when the route is unknown