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 = 5240 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
17969 European Commission and IIASA, 2020 
{
    "link": "https://www.pnas.org/content/117/14/7690.abstract",
    "additionalInfo": "These population projections come from a joint project between the European Commission and the International Institute for Applied Systems Analysis (IIASA). The results, first published as the \"<a href=\"https://ec.europa.eu/jrc/en/facts4eufuture/eu-demographic-scenarios\">Demographic Scenarios for the EU</a>\" flagship report, were since updated and published by the Proceedings of the National Academy of Sciences of the United States of America (PNAS). Information on the detailed methodology and updated microsimulation results can be found <a href=\"https://www.pnas.org/content/117/14/7690.abstract\">here</a>.\n\nFull reference:\nMarois, G., B\u00e9langer, A., & Lutz, W. (2020). Population aging, migration, and productivity in Europe. Proceedings of the National Academy of Sciences, 117(14), 7690-7695.\n\n-------\nBackground on the labour force assumptions for the 'LFDR - Constant Participation' and 'LFDR - High Participation' scenarios:\nFuture labour force participation rates are calculated from statistical modelling based on the 2014 and 2015 Labour Force Survey, assuming constant entry and exit rates in the labour force by age, sex, education, and country. The 'high participation (Swedish) scenario' assumes a convergence in labour participation rates by 2050 to what was observed in Sweden during 2014-2015.",
    "dataPublishedBy": "Marois, G., B\u00e9langer, A., & Lutz, W. (2020). Population aging, migration, and productivity in Europe. Proceedings of the National Academy of Sciences, 117(14), 7690-7695."
}
 2021-01-13 21:44:01 2021-01-13 21:44:01 Labour Force Dependency Ratio (IIASC) 5240 These population projections come from a joint project between the European Commission and the International Institute for Applied Systems Analysis (IIASA). The results, first published as the "<a href="https://ec.europa.eu/jrc/en/facts4eufuture/eu-demographic-scenarios">Demographic Scenarios for the EU</a>" flagship report, were since updated and published by the Proceedings of the National Academy of Sciences of the United States of America (PNAS). Information on the detailed methodology and updated microsimulation results can be found <a href="https://www.pnas.org/content/117/14/7690.abstract">here</a>. Full reference: Marois, G., Bélanger, A., & Lutz, W. (2020). Population aging, migration, and productivity in Europe. Proceedings of the National Academy of Sciences, 117(14), 7690-7695. ------- Background on the labour force assumptions for the 'LFDR - Constant Participation' and 'LFDR - High Participation' scenarios: Future labour force participation rates are calculated from statistical modelling based on the 2014 and 2015 Labour Force Survey, assuming constant entry and exit rates in the labour force by age, sex, education, and country. The 'high participation (Swedish) scenario' assumes a convergence in labour participation rates by 2050 to what was observed in Sweden during 2014-2015. https://www.pnas.org/content/117/14/7690.abstract Marois, G., Bélanger, A., & Lutz, W. (2020). Population aging, migration, and productivity in Europe. Proceedings of the National Academy of Sciences, 117(14), 7690-7695.

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