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 = 1902 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
13911 Global temperature anomaly - Hadley Centre (HadCRUT4) 
{
    "link": "https://www.metoffice.gov.uk/hadobs/hadcrut4/index.html",
    "retrievedDate": "4th June 2020",
    "additionalInfo": "Temperature anomalies are based on the HadCRUT4 land-sea dataset as published by the Met Office Hadley Centre. Temperature anomalies are given in degrees celcius relative to the average temperature over the period 1961-1990. These are available at the global level, for the Northern Hemisphere, South Hemisphere, and Tropics (defined as 30 degree north and south of the equator).\n\nThe median temperature anomaly, as well as the upper and lower bound anomalies (with a 95% confidence interval) are provided.\n\nFull details of the source of this dataset is available in the following paper:\nMorice, C. P., J. J. Kennedy, N. A. Rayner, and P. D. Jones (2012), Quantifying uncertainties in global and regional temperature change using an ensemble of observational estimates: The HadCRUT4 dataset, J. Geophys. Res., 117, D08101, doi:10.1029/2011JD017187.",
    "dataPublishedBy": "Met Office Hadley Centre",
    "dataPublisherSource": null
}
 2018-01-18 18:27:36 2018-01-18 18:34:26 Global temperature anomaly - Met Office (HadCRUT4) 1902 Temperature anomalies are based on the HadCRUT4 land-sea dataset as published by the Met Office Hadley Centre. Temperature anomalies are given in degrees celcius relative to the average temperature over the period 1961-1990. These are available at the global level, for the Northern Hemisphere, South Hemisphere, and Tropics (defined as 30 degree north and south of the equator). The median temperature anomaly, as well as the upper and lower bound anomalies (with a 95% confidence interval) are provided. Full details of the source of this dataset is available in the following paper: Morice, C. P., J. J. Kennedy, N. A. Rayner, and P. D. Jones (2012), Quantifying uncertainties in global and regional temperature change using an ensemble of observational estimates: The HadCRUT4 dataset, J. Geophys. Res., 117, D08101, doi:10.1029/2011JD017187. https://www.metoffice.gov.uk/hadobs/hadcrut4/index.html Met Office Hadley Centre

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