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 = 958 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
6817 Country-level surface temperature anomaly - HadCRUT4 
{
    "link": "https://crudata.uea.ac.uk/cru/data/temperature/",
    "retrievedDate": "25/09/2017",
    "additionalInfo": "For land regions of the world over 4800 monthly station temperature time series are used and CRUTEM4 (land) is created. For marine regions, sea surface temperature (SST) measurements taken on board merchant and some naval vessels are used and HadSST3 (ocean) is created. HadCRUT4 combines both datasets.\n\nThe temperature anomaly is measured relative to the 1961-1990 global average temperature. Country-level values were created by averaging all grid cells whose centroids were within the border of a country. Area weighted measures were weighted by the area of the grid cell when averaging the gridd cells and population weighted averages used gridded population data from 2015 created by the Center for International Earth Science Information Network - CIESIN (http://dx.doi.org/10.7927/H4X63JVC).",
    "dataPublishedBy": "Climatic Research Unit (University of East Anglia) in conjunction with the Hadley Centre (UK Met Office)",
    "dataPublisherSource": null
}
 2017-10-08 15:43:22 2017-11-02 13:04:39 HadCRUT Temperature Anomaly 958 For land regions of the world over 4800 monthly station temperature time series are used and CRUTEM4 (land) is created. For marine regions, sea surface temperature (SST) measurements taken on board merchant and some naval vessels are used and HadSST3 (ocean) is created. HadCRUT4 combines both datasets. The temperature anomaly is measured relative to the 1961-1990 global average temperature. Country-level values were created by averaging all grid cells whose centroids were within the border of a country. Area weighted measures were weighted by the area of the grid cell when averaging the gridd cells and population weighted averages used gridded population data from 2015 created by the Center for International Earth Science Information Network - CIESIN (http://dx.doi.org/10.7927/H4X63JVC). https://crudata.uea.ac.uk/cru/data/temperature/ Climatic Research Unit (University of East Anglia) in conjunction with the Hadley Centre (UK Met Office)

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