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 = 2796 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
15533 World Bank EdStats and the STEP Skills Measurement Program 
{
    "link": "PIAAC: https://data.worldbank.org/data-catalog/ed-stats and STEP: http://microdata.worldbank.org/index.php/catalog/step",
    "retrievedDate": "25/05/2018",
    "additionalInfo": "To calculate the average score in adult literacy proficiency from the STEP surveys we have: \n<ul>\n<li>Calculated the mean literacy score for each individual in the survey (over 10 plausible value scores)</li>\n<li>Taken the sum of the mean literacy scores over all individuals</li>\n<li>Divided the aggregate literacy score by the number of individuals</li>\n</ul>\nThe STEP data for calculated average adult literacy (8 additional observations) is appended to the PIAAC scores from World Bank EdStats dataset. \n8 STEP observations include: Armenia (2013); Bolivia (2012); Colombia (2012); Georgia (2013); Ghana (2013); Kenya (2013); Ukraine (2012); and Vietnam (2012)\n\nAs the STEP methodology note outlines \"The STEP literacy assessment has been developed specifically for use in the context of developing countries, and it includes sets of questions taken from PIAAC, the International Adult Literacy Survey, and the Adult Literacy and Life Skills Survey. This overlap allows countries participating in the STEP program to compare their literacy results with those of over 30 other countries.\"\nFull citation: \u201cPierre, Gaelle; Sanchez Puerta, Maria Laura; Valerio, Alexandria; Rajadel, Tania. 2014. STEP Skills Measurement Surveys : Innovative Tools for Assessing Skills. Social protection and labor discussion paper;no. 1421. World Bank Group, Washington, DC. \u00a9 World Bank. https://openknowledge.worldbank.org/handle/10986/19985 License: CC BY 3.0 IGO.\u201d",
    "dataPublishedBy": "World Bank EdStats and the World Bank Central Microdata Catalog",
    "dataPublisherSource": "OECD Programme for the International Assessment of Adult Competencies (PIAAC) using survey data"
}
 2018-05-25 15:01:24 2018-05-25 15:01:24 Adult literacy proficiency - World Bank EdStats and STEP Skills Measurement Program 2796 To calculate the average score in adult literacy proficiency from the STEP surveys we have: <ul> <li>Calculated the mean literacy score for each individual in the survey (over 10 plausible value scores)</li> <li>Taken the sum of the mean literacy scores over all individuals</li> <li>Divided the aggregate literacy score by the number of individuals</li> </ul> The STEP data for calculated average adult literacy (8 additional observations) is appended to the PIAAC scores from World Bank EdStats dataset. 8 STEP observations include: Armenia (2013); Bolivia (2012); Colombia (2012); Georgia (2013); Ghana (2013); Kenya (2013); Ukraine (2012); and Vietnam (2012) As the STEP methodology note outlines "The STEP literacy assessment has been developed specifically for use in the context of developing countries, and it includes sets of questions taken from PIAAC, the International Adult Literacy Survey, and the Adult Literacy and Life Skills Survey. This overlap allows countries participating in the STEP program to compare their literacy results with those of over 30 other countries." Full citation: “Pierre, Gaelle; Sanchez Puerta, Maria Laura; Valerio, Alexandria; Rajadel, Tania. 2014. STEP Skills Measurement Surveys : Innovative Tools for Assessing Skills. Social protection and labor discussion paper;no. 1421. World Bank Group, Washington, DC. © World Bank. https://openknowledge.worldbank.org/handle/10986/19985 License: CC BY 3.0 IGO.” PIAAC: https://data.worldbank.org/data-catalog/ed-stats and STEP: http://microdata.worldbank.org/index.php/catalog/step World Bank EdStats and the World Bank Central Microdata Catalog

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