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 = 2823 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
15554 CFC-11 expected and measured concentrations (Montzka et al. 2018) 
{
    "link": "https://www.nature.com/articles/s41586-018-0106-2",
    "retrievedDate": "23rd June 2018",
    "additionalInfo": "Data denotes the measured concentrations of trichlorofluoromethane (CFC-11) gas in the Northern and Southern Hemisphere, collected via air collection and analysis automated onsite instrumentation with gas chromatography coupled with electron capture detection (GC\u2013ECD). This allows for measurement of CFC-11 concentrations in mole fractions (parts per trillion). Data here represents the annual average for data reported in Montzka et al. (2018).\n\nThe WMO (2003; 2010 and 2014) projections are those published by the World Meteorological Organization (WMO) and represent the global average expected change in CFC-11 concentrations based on reported emissions of CFC-11 from all parties to the Montreal Protocol.",
    "dataPublishedBy": "Montzka, S. A., Dutton, G. S., Yu, P., Ray, E., Portmann, R. W., Daniel, J. S., ... & Nance, J. D. (2018). An unexpected and persistent increase in global emissions of ozone-depleting CFC-11. Nature, 557(7705), 413.",
    "dataPublisherSource": null
}
 2018-06-21 10:57:01 2018-06-21 10:57:01 CFC-11 expected and measured concentrations (Montzka et al., 2018) 2823 Data denotes the measured concentrations of trichlorofluoromethane (CFC-11) gas in the Northern and Southern Hemisphere, collected via air collection and analysis automated onsite instrumentation with gas chromatography coupled with electron capture detection (GC–ECD). This allows for measurement of CFC-11 concentrations in mole fractions (parts per trillion). Data here represents the annual average for data reported in Montzka et al. (2018). The WMO (2003; 2010 and 2014) projections are those published by the World Meteorological Organization (WMO) and represent the global average expected change in CFC-11 concentrations based on reported emissions of CFC-11 from all parties to the Montreal Protocol. https://www.nature.com/articles/s41586-018-0106-2 Montzka, S. A., Dutton, G. S., Yu, P., Ray, E., Portmann, R. W., Daniel, J. S., ... & Nance, J. D. (2018). An unexpected and persistent increase in global emissions of ozone-depleting CFC-11. Nature, 557(7705), 413.

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");