Exerica ESG datasets APIs
This suite of APIs provide environmental ESG data on global companies covering up to 10 years of historical data. The data is collected from corporate publications and select independent sources (like cdp.net) and utilizes Exerica’s state-of-the-art data collection AI. This technology makes every single data point traceable to its source, right down to a specific line in the original publication, introducing unrivalled data integrity! Examples in this documentation are for demo purposes and use "demo" API key. Please claim your API key by registering here.
EU Taxonomy API
This API returns datasets for Revenue, Capital Expenditures and Operating Expenses and their breakdowns into aligned and eligible activities according to the EU taxonomy disclosure for the company specified. Historical data starts with 2021 when European companies started to make such disclosures.
https://api.exerica.com/api/v2/datasets/esg/eutaxonomy
curl "https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=E.ON&apikey=demo"
import requests
requests.get("https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=E.ON&apikey=demo")
fetch('https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=E.ON&apikey=demo',
{
method: 'GET'
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});
HttpClient client = new HttpClient();
var url = "https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=E.ON&apikey=demo";
HttpResponseMessage response = await client.GetAsync(url);
var responseBody = await response.Content.ReadAsStringAsync();
var result = JsonConvert.DeserializeObject(responseBody);
API query parameters
Parameter | Description | |
---|---|---|
company | Required | The name of the company of your choice or its stock exchange ticker |
datatype | Optional | By default, datatype=json. Strings json and xlsx are accepted with the following specifications: json returns the results in JSON format; xlsx returns the search results as a XLSX file. |
apikey | Required | Your API key. Claim your API key here |
Response examples
click for JSON output
https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=E.ON&apikey=demo https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=SHEL&apikey=demo
click to download XLSX file
https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=E.ON&apikey=demo&datatype=xlsx https://api.exerica.com/api/v2/datasets/esg/eutaxonomy?company=SHEL&apikey=demo&datatype=xlsx
Carbon footprint API
This API returns datasets covering Scope 1, Scope 2 and Scope 3 emissions for a requested company. All the data is sourced from company publications and cdp.net. Historical data spans up to 10 years (which varies with company).
https://api.exerica.com/api/v2/datasets/esg/carbonfootprint
curl "https://api.exerica.com/api/v2/datasets/esg/carbonfootprint?company=E.ON&apikey=demo"
import requests
requests.get("https://api.exerica.com/api/v2/datasets/esg/carbonfootprint?company=E.ON&apikey=demo")
fetch('https://api.exerica.com/api/v2/datasets/esg/carbonfootprint?company=E.ON&apikey=demo',
{
method: 'GET'
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});
HttpClient client = new HttpClient();
var url = "https://api.exerica.com/api/v2/datasets/esg/carbonfootprint?company=E.ON&apikey=demo";
HttpResponseMessage response = await client.GetAsync(url);
var responseBody = await response.Content.ReadAsStringAsync();
var result = JsonConvert.DeserializeObject(responseBody);
API query parameters
Parameter | Description | |
---|---|---|
company | Required | The name of the company of your choice or its stock exchange ticker |
datatype | Optional | By default, datatype=json. Strings json and xlsx are accepted with the following specifications: json returns the results in JSON format; xlsx returns the search results as a XLSX file. |
apikey | Required | Your API key. Claim your API key here |
Response examples
click for JSON output
https://api.exerica.com/api/v2/datasets/esg/carbonfootprint/company=E.ON&apikey=demo
click to download XLSX file
https://api.exerica.com/api/v2/datasets/esg/carbonfootprint/company=E.ON&apikey=demo&datatype=xlsx
Exerica API's response
APIs return an object with the array of datasets and som additional properties in the unified JSON format. XLSX files are also available for download by specifying datatype=xlsx
in the API request.
JSON response
The response object containt the following properties:
Property | Type | Description |
---|---|---|
company | string | Company name |
measurementUnits | string | Name of units in wich datapoints are measured |
scale | double | Value in wich datapoints values are scaled |
dataSets | array of objects | Array of datasets (see the description below) |
For example, a dataset has measurementUnits: ton
, scale: 1000.0
and a datapoint has the value of 20. This simply means 20 000 tons
.
Each dataset includes the following properties:
Property | Type | Description |
---|---|---|
name | string | Dataset name |
tags | array of strings | EU taxonomy activities associated with the given dataset. Each activity starts with its number, e.g. "4.1 = Electricity generation using solar photovoltaic technology" |
dataPoints | array of objects | Array of datapoints (see the description below) |
breakdown | array of objects | Array of datasets representing a more detailed breakdown of the given dataset |
Each datapoint in a dataset has the following properties:
Property | Type | Description |
---|---|---|
value | double | Value of the dataPoint |
date | object | Date of the datapoint. Contains string endDate (in the "YYYY-MM" format) and integer duration measured in months (duration would be equal to 12 in most cases) |
reportDate | string | Date of the company report which the given datapoint was collected from (in the "YYYY-MM" format). |
source | string | URL referencing the dataPoint's source, right down to a specific line in the original publication |
Company search API
The Company search Endpoint returns the best-matching companies symbols basedon keywords of your choice. The search results also contain match scores that provide you with the full flexibility to develop your own search and filtering logic.
https://api.exerica.com/api/v2/companyInfo/esg/search
curl "https://api.exerica.com/api/v2/companyInfo/esg/search?name=deutsche&apikey=demo"
import requests
requests.get("https://api.exerica.com/api/v2/companyInfo/esg/search?name=deutsche&apikey=demo")
fetch('https://api.exerica.com/api/v2/companyInfo/esg/search?name=deutsche&apikey=demo',
{
method: 'GET'
})
.then(function(res) {
return res.json();
}).then(function(body) {
console.log(body);
});
HttpClient client = new HttpClient();
var url = "https://api.exerica.com/api/v2/companyInfo/esg/search?name=deutsche&apikey=demo";
HttpResponseMessage response = await client.GetAsync(url);
var responseBody = await response.Content.ReadAsStringAsync();
var result = JsonConvert.DeserializeObject(responseBody);
API query parameters
Parameter | Description | |
---|---|---|
name | Required | The name of the company of your choice or its stock exchange ticker |
apikey | Required | Your API key. Claim your API key here |
Response example (click for JSON output)
https://api.exerica.com/api/v2/companyInfo/esg/search?name=deutsche&apikey=demo
JSON response
Property | Type | Description |
---|---|---|
name | string | Offical company name or ticker (can be used in queries in all Exerica APIs) |
matchScore | double | Match score |
Tickers | array of strings | Tickers under which the specified company is trading on various stock exchnages |
Industires | array of strings | Array of subsectors in accordance with Global Industry Classification Standard (GICS) |