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 = 5201 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
17931 UN Food and Agriculture Organization (FAO). Forest Resources Assessment. 
{
    "link": "https://fra-data.fao.org/",
    "retrievedDate": "20th October 2020",
    "additionalInfo": "Raw data for forest area, deforestation, afforestation and expansion is sourced from the UN FAO Forest Resources Assessment.\n\nOur World in Data have calculated several metrics based on this raw data including:\n\u2013 Net change in forest area (afforestation minus deforestation)\n\u2013 Net conversion rate (net change as a percentage of forest area)\n\u2013 Each country's share of global forest area, deforestation, afforestation, and net change in forests\n\u2013 Each country's share of regional forest area, deforestation, afforestation, and net change in forests\n\nThe UN FAO publish forest area and forest change data as the annual average on 10- or 5-year timescales. Therefore the following year allocation applies:\n\u2013 1990: the annual average over the period from 1990 to 2000.\n\u2013 2000: the annual average over the period from 2000 to 2010.\n\u2013 2010: the annual average over the period from 2010 to 2015.\n\u2013 2015: the annual average over the period from 2015 to 2020.\n\nData on forest cover by country pre-1990 is sourced from a variety sources which are documented here: https://docs.google.com/spreadsheets/d/1nYpao4e8Ai-P86jIUZ3r7X6-5MjZ7ZbG7TJQSO729Bg/edit?usp=sharing",
    "dataPublishedBy": "UN Food and Agriculture Organization (FAO). Forest Resources Assessment 2020."
}
 2020-10-20 09:08:41 2020-10-20 09:08:41 Forest land, deforestation and change (FAO, 2020) 5201 Raw data for forest area, deforestation, afforestation and expansion is sourced from the UN FAO Forest Resources Assessment. Our World in Data have calculated several metrics based on this raw data including: – Net change in forest area (afforestation minus deforestation) – Net conversion rate (net change as a percentage of forest area) – Each country's share of global forest area, deforestation, afforestation, and net change in forests – Each country's share of regional forest area, deforestation, afforestation, and net change in forests The UN FAO publish forest area and forest change data as the annual average on 10- or 5-year timescales. Therefore the following year allocation applies: – 1990: the annual average over the period from 1990 to 2000. – 2000: the annual average over the period from 2000 to 2010. – 2010: the annual average over the period from 2010 to 2015. – 2015: the annual average over the period from 2015 to 2020. Data on forest cover by country pre-1990 is sourced from a variety sources which are documented here: https://docs.google.com/spreadsheets/d/1nYpao4e8Ai-P86jIUZ3r7X6-5MjZ7ZbG7TJQSO729Bg/edit?usp=sharing https://fra-data.fao.org/ UN Food and Agriculture Organization (FAO). Forest Resources Assessment 2020.

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