sources
Data license: CC-BY
1 row where datasetId = 5229 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
|---|---|---|---|---|---|---|---|---|
| 17958 | Average effective age of retirement, by gender (OECD, 2018) | {
"link": "http://www.oecd.org/els/emp/average-effective-age-of-retirement.htm",
"retrievedDate": "28/11/2020",
"additionalInfo": "The average effective age of retirement is calculated as a weighted average of (net) labour market withdrawals at different ages over a 5-year period for workers initially aged 40 and over.\n\nThe estimate for each year corresponds to the 5 year interval leading up to that year. For example, the observation for 1970 corresponds to (1965-70), 1971 to (1966-71) etc. \n\nLabour force withdrawals are estimated based on changes in labour force participation rates rather than labour force levels to abstract from compositional effects. Estimates include both interpolations of census data as well as labour force surveys. For a breakdown by observation, see the <a href=\"http://www.oecd.org/els/emp/Summary_1970%20values.xlsx\">following spreadsheet</a>.\n\nNote: The estimates for women in Turkey are based on 3-yearly moving averages of participation rates for each 5-year age group.\n\nThe 'Europe average' series includes: Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, United Kingdom.",
"dataPublishedBy": "OECD Database on Average Effective Retirement Age",
"dataPublisherSource": "National labour force surveys, EU Labour Force Survey, and national censuses"
} |
2020-11-29 22:42:36 | 2020-11-29 22:42:36 | Average effective age of retirement, by gender (OECD, 2018) 5229 | The average effective age of retirement is calculated as a weighted average of (net) labour market withdrawals at different ages over a 5-year period for workers initially aged 40 and over. The estimate for each year corresponds to the 5 year interval leading up to that year. For example, the observation for 1970 corresponds to (1965-70), 1971 to (1966-71) etc. Labour force withdrawals are estimated based on changes in labour force participation rates rather than labour force levels to abstract from compositional effects. Estimates include both interpolations of census data as well as labour force surveys. For a breakdown by observation, see the <a href="http://www.oecd.org/els/emp/Summary_1970%20values.xlsx">following spreadsheet</a>. Note: The estimates for women in Turkey are based on 3-yearly moving averages of participation rates for each 5-year age group. The 'Europe average' series includes: Austria, Belgium, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia, Slovenia, Spain, Sweden, United Kingdom. | http://www.oecd.org/els/emp/average-effective-age-of-retirement.htm | OECD Database on Average Effective Retirement Age |
Advanced export
JSON shape: default, array, newline-delimited, object
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");