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 = 1020 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
6880 Global freshwater use since 1900 - IGB 
{
    "link": "http://www.igbp.net/globalchange/greatacceleration.4.1b8ae20512db692f2a680001630.html",
    "retrievedDate": "2017-11-08",
    "additionalInfo": "Data measures global freshwater use which is the sum of water withdrawals for agriculture, industrial and domestic uses. Data from 1900-2010 is sourced from the IGB Programme (full reference below). Global data has been extended to 2014 by combining with 2014 'World' figures as reported in the World Bank - World Development Indicators, under the variable \"Annual Freshwater Withdrawals, Total (billion cubic meters)\". Available at: http://data.worldbank.org/data-catalog/world-development-indicators [accessed 2017-11-08].\n\nData from 1900-2010 is sourced from the IGB Database. IGB's data is estimated using the WaterGAP model from Fl\u00f6rke et al. 2013 (full reference below). Data is available at aggregates in OECD, BRICS and Rest of the World (ROW). OECD members are defined as countries who were members in 2010 and their membership was carried back in time. BRICS countries are Brazil, Russia, India, China and South Africa.\n\nFull references:\nAlcamo, J., D\u00f6ll, P., Henrichs, T., Kaspar, F., Lehner, B., R\u00f6sch, T., Siebert, S., 2003. Development and testing of the WaterGAP 2 global model of water use and availability. Hydrological Sciences Journal 48:317\u2013337.\naus der Beek, T., Fl\u00f6rke, M., Lapola, D. M., Schaldach, R., Vo\u00df, F., and Teichert, E. 2010. Modelling historical and current irrigation water demand on the continental scale: Europe. Advances in Geoscience 27:79-85  doi:10.5194/adgeo-27-79-2010\nFl\u00f6rke, M., Kynast, E., B\u00e4rlund, I., Eisner, S., Wimmer, F., Alcamo, J. 2013. Domestic and industrial water uses of the past 60 years as a mirror of socio-economic development: A global simulation study. Global Environmental Change 23: 144-156  ",
    "dataPublishedBy": "Global International Geosphere-Biosphere Programme (IGB)",
    "dataPublisherSource": "Fl\u00f6rke et al. 2013; aus der Beek et al. 2010; Alcamo et al. 2003."
}
 2017-11-08 18:41:02 2017-11-08 18:41:02 Global freshwater use since 1900 - IGB 1020 Data measures global freshwater use which is the sum of water withdrawals for agriculture, industrial and domestic uses. Data from 1900-2010 is sourced from the IGB Programme (full reference below). Global data has been extended to 2014 by combining with 2014 'World' figures as reported in the World Bank - World Development Indicators, under the variable "Annual Freshwater Withdrawals, Total (billion cubic meters)". Available at: http://data.worldbank.org/data-catalog/world-development-indicators [accessed 2017-11-08]. Data from 1900-2010 is sourced from the IGB Database. IGB's data is estimated using the WaterGAP model from Flörke et al. 2013 (full reference below). Data is available at aggregates in OECD, BRICS and Rest of the World (ROW). OECD members are defined as countries who were members in 2010 and their membership was carried back in time. BRICS countries are Brazil, Russia, India, China and South Africa. Full references: Alcamo, J., Döll, P., Henrichs, T., Kaspar, F., Lehner, B., Rösch, T., Siebert, S., 2003. Development and testing of the WaterGAP 2 global model of water use and availability. Hydrological Sciences Journal 48:317–337. aus der Beek, T., Flörke, M., Lapola, D. M., Schaldach, R., Voß, F., and Teichert, E. 2010. Modelling historical and current irrigation water demand on the continental scale: Europe. Advances in Geoscience 27:79-85 doi:10.5194/adgeo-27-79-2010 Flörke, M., Kynast, E., Bärlund, I., Eisner, S., Wimmer, F., Alcamo, J. 2013. Domestic and industrial water uses of the past 60 years as a mirror of socio-economic development: A global simulation study. Global Environmental Change 23: 144-156 http://www.igbp.net/globalchange/greatacceleration.4.1b8ae20512db692f2a680001630.html Global International Geosphere-Biosphere Programme (IGB)

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