Already logged in
Home Account Logout
Already logged in
Home Account Logout

Please use your company or university domain email address for registration. We do not accept registrations from other email addresses, such as @gmail.com and @126.com

Enter your client ID here:

No password needed - you will receive a login link via email.

Privacy policy We do not share your email address. We will only contact you as needed about important updates. You can close your account at the Account page at any time. This site does not use any tracking cookies.

Search and Data API

Our semantic search service allows you to search for any product, purchase, expenditure, or sector and get the Scope 3 emissions intensity. The search uses AI to find the best-matching sector in the Eora model. If you are already using Eora classification labels you can use the Eora sector labels as a search query and the system will return data for that sector.

This can be used with the REST Data API. It can be used easily in Google Sheets, Python, R, or almost any other language.

To get the correct Scope 3 intensity you must specify the country where the good or service was sourced from.

We've integrated a translation feature so you can search in English or any of 100 other langauges.

Try it out
Try it out:
Loading...
Google Sheets
Example of how to use this service in Google Sheets: =IMPORTHTML("https://new.worldmrio.com/api/search/v1/?q=red+peppers&clientid=1234","table",1)

The IMPORTHTML function in Google Sheets can call this API:

IMPORTHTML(url, query, index) - docs
  • url - See below for REST endpoint.
  • query - For this endpoint this parameter should always be "table".
  • index - The index, starting at 1, which identifies which table should be read. See the REST endpoint description below for documentation on the tables available.
REST endpoint
Most languages support RESTful APIs, e.g. Javascript, Python, and R.

Examples: https://new.worldmrio.com/api/search/v1/?q=bananas&clientid=1234 https://new.worldmrio.com/api/search/v1/?q=bananas&clientid=1234&output=json https://new.worldmrio.com/api/search/v1/?q=ホテル&clientid=1234&query_lang=ja

Base GET URL: https://new.worldmrio.com/api/search/v1/.

HTTP headers:

None required.

Query parameters:
  • q - a URL-encoded string containing the the product or sector, with optional country, to search for. Examples: bananas or bananas%20from%20ecuador. Tip: In Google Sheets the ENCODEURL() can be used to URL-encode text.
  • output - Either json or html (default). See below for details.
  • clientid - Your clientid, or 1234 for demo mode.
Results when output=html
The Google Sheets IMPORTHTML function extracts tables from an HTML document. This web service provides the following tables which can be extracted. The third parameter to IMPORTHTML, the index parameter, specifies which of these tables will be read:
  1. A single row, 5-column table containing the scope 3 emissions intensity value, the unit (Gg CO2eq/$), the year, the sector name, and the country name. Note: Make sure to have 4 additional cells available to the right of the formula cell where the results will be written.
  2. A single cell with the Scope 3 intensity coefficient
  3. A single cell with the country name
  4. A single cell with the sector name
  5. A 5×5 table with other potential search results. Columns are the same as the first table.
  6. A single cell with the search query word, as translated into English
Results when output=json
The endpoint will return a result with this signature:

interface Scope3Result {
    scope3:  number, /* The scope 3 intensity, in Gg CO2eq/$. */
    unit: string, /* The unit of the scope 3 intensity. */
    id: number, /* The sector ID, as an index into the MRIO */
    country: string, /* The country name for this intensity coefficient. */
    sector: string /* The sector name for this intensity coefficient. */
}
            
Client ID

To use this service you must provide a Client ID with an active license with the "multipliers" feature.

For testing you may use clientid=1234. In this case all numeric values will be 3.14.

If you do not provide a valid client ID the service will return a 403 error.