sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 387 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
508 Ozone concentration-StateofGlobalAir 
{
    "link": "www.stateofglobalair.org",
    "retrievedDate": "12/04/2017",
    "additionalInfo": "Data is gathered based on a combination of air quality observations from satellites combined with information from global chemical transport models, and available ground measurements. A global chemical transport model was used to calculate a seasonal (summer, when temperatures are highest) average concentration. Variation in the timing of the ozone (summer) season in different parts of the world is accounted for in these datasets. Global exposure to PM2.5 is then systematically estimated based on blocks or grid cells covering 0.1\u00b0 x 0.1\u00b0 of longitude and latitude (approximately 11 km x 11 km at the equator).\n\nTaking into account the population in each block within a country, this data is then aggregated as estimated exposure concentrations to national-level population-weighted averages for a given year.",
    "dataPublishedBy": "State of Global Air 2017. HEI, 2017",
    "dataPublisherSource": "Global Burden of Disease Study 2015. IHME, 2016"
}
 2017-04-12 14:38:18 2017-11-02 13:04:39 Ozone concentration-StateofGlobalAir 387 Data is gathered based on a combination of air quality observations from satellites combined with information from global chemical transport models, and available ground measurements. A global chemical transport model was used to calculate a seasonal (summer, when temperatures are highest) average concentration. Variation in the timing of the ozone (summer) season in different parts of the world is accounted for in these datasets. Global exposure to PM2.5 is then systematically estimated based on blocks or grid cells covering 0.1° x 0.1° of longitude and latitude (approximately 11 km x 11 km at the equator). Taking into account the population in each block within a country, this data is then aggregated as estimated exposure concentrations to national-level population-weighted averages for a given year. www.stateofglobalair.org State of Global Air 2017. HEI, 2017

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");