sources
Data license: CC-BY
1 row where datasetId = 448 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 |
---|---|---|---|---|---|---|---|---|
570 | Our World In Data based on OECD and Lindert (2004) | { "link": "OECD Social Expenditure Database: http://stats.oecd.org/Index.aspx?datasetcode=SOCX_AGG. OECD (1985): http://www.worldcat.org/title/social-expenditure-1960-1990-problems-of-growth-and-control/oclc/568030375&referer=brief_results. Lindert (2004): http://www.worldcat.org/title/growing-public-social-spending-and-economic-growth-since-the-eighteenth-century/oclc/799512151&referer=brief_results", "retrievedDate": "April 1, 2017", "additionalInfo": "Definitions\n\nSocial spending includes, among others, the following areas: health, old age, incapacity-related benefits, family, active labor market programmes, unemployment, and housing. In some studies and reports, education is included in social spending. This is not the case in this dataset.\n\nHandling of underlying sources\n\nThis dataset was constructed by combining three sources. These are the OECD Social Expenditure Database (OECD SOCX), OECD (1985) and Lindert (2004).\n\nThese three sources were combined as follows. For the period 1980-2016 we report the figures as published in OECD SOCX. For the period 1960-1979, we extended the recent figures (from OECD SOCX) backwards by using the rates of change as reported in OECD (1985). And for the period 1880-1930, we took observations from Lindert (2004).\n\nTo be precise, the data for the period 1960-1979 was obtained by relying on the earliest available observation from OECD SOCX, and then successively extending the series backwards by using the year-by-year rate of change implied by the estimates in OECD (1985). Here is an example:\n\nOECD_SOCX_(Year-1) = [OECD_SOCX_(Year)] x [OECD_1985_(year-1)]/[ OECD_1985_(year)]\n\nBackward extrapolation for the period 1960-1979 was necessary because the levels in the estimates from OECD SOCX and OECD (1985) do not exactly coincide for the overlapping years. The implicit assumption, then, is that the estimates from OECD SOCX and OECD (1985) have different levels, but common trends.\n\nIn this visualization (https://ourworldindata.org/grapher/various-measures-of-social-expenditure-as-share-of-gdp?country=AUS) you can see how the various underlying sources compare to our constructed series.\n\nFurther remarks\n\nAccording to the Manual to the OECD Social Expenditure Database (SOCX), the OECD defines social expenditure as \u201cThe provision by public and private institutions of benefits to, and financial contributions targeted at, households and individuals in order to provide support during circumstances which adversely affect their welfare, provided that the provision of the benefits and financial contributions constitutes neither a direct payment for a particular good or service nor an individual contract or transfer\u201d\n\nThe series on Social expenditure for France and Denmark in OECD(1985) are not complete. However, Lindert (2004) uses the data available to estimate social expenditure in 1960 and 1970. Therefore, we use his estimations to extrapolate backwards for those two points in time.\n\nIn OECD (1985) social expenditure figures include expenditure on education. To ensure consistency with Lindert (2004) and OECD (SOCX), we subtracted education.", "dataPublishedBy": "Our World In Data (dataset constructed by Marco Molteni)", "dataPublisherSource": "Data after 1980 corresponds to OECD Social Expenditure Database (SOCX). Data from 1960 to 1979 corresponds to estimates based on OECD (1985), \"Social Expenditure 1960-1990: problems of growth and control\", OECD social policy studies. (See additional information below for more details.) Data before 1930 corresponds to Lindert (2004), \"Growing Public: Social Spending and Economic Growth since the Eighteenth Century.\" Vol. 1 \u2013 The Story, Cambridge University Press." } |
2017-04-28 04:09:25 | 2017-11-02 13:04:39 | Social Expenditure in the long run - Lindert 2004; OECD 1985; OECD (SOCX). 448 | Definitions Social spending includes, among others, the following areas: health, old age, incapacity-related benefits, family, active labor market programmes, unemployment, and housing. In some studies and reports, education is included in social spending. This is not the case in this dataset. Handling of underlying sources This dataset was constructed by combining three sources. These are the OECD Social Expenditure Database (OECD SOCX), OECD (1985) and Lindert (2004). These three sources were combined as follows. For the period 1980-2016 we report the figures as published in OECD SOCX. For the period 1960-1979, we extended the recent figures (from OECD SOCX) backwards by using the rates of change as reported in OECD (1985). And for the period 1880-1930, we took observations from Lindert (2004). To be precise, the data for the period 1960-1979 was obtained by relying on the earliest available observation from OECD SOCX, and then successively extending the series backwards by using the year-by-year rate of change implied by the estimates in OECD (1985). Here is an example: OECD_SOCX_(Year-1) = [OECD_SOCX_(Year)] x [OECD_1985_(year-1)]/[ OECD_1985_(year)] Backward extrapolation for the period 1960-1979 was necessary because the levels in the estimates from OECD SOCX and OECD (1985) do not exactly coincide for the overlapping years. The implicit assumption, then, is that the estimates from OECD SOCX and OECD (1985) have different levels, but common trends. In this visualization (https://ourworldindata.org/grapher/various-measures-of-social-expenditure-as-share-of-gdp?country=AUS) you can see how the various underlying sources compare to our constructed series. Further remarks According to the Manual to the OECD Social Expenditure Database (SOCX), the OECD defines social expenditure as “The provision by public and private institutions of benefits to, and financial contributions targeted at, households and individuals in order to provide support during circumstances which adversely affect their welfare, pro… | OECD Social Expenditure Database: http://stats.oecd.org/Index.aspx?datasetcode=SOCX_AGG. OECD (1985): http://www.worldcat.org/title/social-expenditure-1960-1990-problems-of-growth-and-control/oclc/568030375&referer=brief_results. Lindert (2004): http://www.worldcat.org/title/growing-public-social-spending-and-economic-growth-since-the-eighteenth-century/oclc/799512151&referer=brief_results | Our World In Data (dataset constructed by Marco Molteni) |
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");