sources
Data license: CC-BY
1 row where datasetId = 279 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 |
---|---|---|---|---|---|---|---|---|
287 | CIA Factbook (2016) | { "link": "https://www.cia.gov/library/publications/the-world-factbook/rankorder/2103rank.html", "retrievedDate": "26/08/2016", "additionalInfo": "The year for estimates corresponds to the estimated dates directly reported by the CIA Factbook. For those countries for which the year was reported by the source as NA, we have assigned 2011 (the most common year in the dataset). The countries where this imputation took place are: Andorra, Vatican, Liechtenstein, Norway, Austria, San Marino, Cook Islands, Niue, Solomon Islands, Gibraltar.\nThe source also notes: \"This entry includes a definition of literacy and Census Bureau percentages for the total population, males, and females. There are no universal definitions and standards of literacy. Unless otherwise specified, all rates are based on the most common definition - the ability to read and write at a specified age. Detailing the standards that individual countries use to assess the ability to read and write is beyond the scope of the Factbook. Information on literacy, while not a perfect measure of educational results, is probably the most easily available and valid for international comparisons. Low levels of literacy, and education in general, can impede the economic development of a country in the current rapidly changing, technology-driven world.\"", "dataPublishedBy": "CIA Factbook (2016)", "dataPublisherSource": "Data from censuses, surveys, and registration systems" } |
2016-08-03 15:42:30 | 2017-11-02 13:04:39 | Literate world population (OurWorldInData based on OECD and UNESCO) 279 | The year for estimates corresponds to the estimated dates directly reported by the CIA Factbook. For those countries for which the year was reported by the source as NA, we have assigned 2011 (the most common year in the dataset). The countries where this imputation took place are: Andorra, Vatican, Liechtenstein, Norway, Austria, San Marino, Cook Islands, Niue, Solomon Islands, Gibraltar. The source also notes: "This entry includes a definition of literacy and Census Bureau percentages for the total population, males, and females. There are no universal definitions and standards of literacy. Unless otherwise specified, all rates are based on the most common definition - the ability to read and write at a specified age. Detailing the standards that individual countries use to assess the ability to read and write is beyond the scope of the Factbook. Information on literacy, while not a perfect measure of educational results, is probably the most easily available and valid for international comparisons. Low levels of literacy, and education in general, can impede the economic development of a country in the current rapidly changing, technology-driven world." | https://www.cia.gov/library/publications/the-world-factbook/rankorder/2103rank.html | CIA Factbook (2016) |
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");