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 = 2872 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
15600 ILOSTAT (2017) 
{
    "link": "https://www.ilo.org/ilostat/",
    "retrievedDate": "08/08/2018",
    "additionalInfo": "The unemployment rate is the number of persons who are unemployed as a percent of the total number of employed and unemployed persons (i.e., the labour force). Data by level of education are provided on the highest level of education completed.\n\nAccording to the ISCED-11 classification, a 'less than basic education' may refer to no schooling, or early childhood education.  'Basic education' includes primary or lower secondary education; 'Intermediate education' to upper secondary or post-secondary non-tertiary education; 'Advanced education' can refer to short-cycle tertiary education, Bachelor's or equivalent level, Master's or equivalent level, or Doctoral or equivalent level, while 'level not stated' is an education level not elsewhere classified. \n\nFor more information see the ILOSTAT's <a href=\"https://www.ilo.org/ilostat-files/Documents/description_EDU_EN.pdf\" rel=\"noopener\" target=_blank\">'Employment by education' document</a>. ",
    "dataPublishedBy": "ILOSTAT",
    "dataPublisherSource": "Labor force and household surveys "
}
 2018-08-08 09:36:34 2018-08-08 14:54:31 Unemployment rate, ages 25-54, by education - ILOSTAT (2017) 2872 The unemployment rate is the number of persons who are unemployed as a percent of the total number of employed and unemployed persons (i.e., the labour force). Data by level of education are provided on the highest level of education completed. According to the ISCED-11 classification, a 'less than basic education' may refer to no schooling, or early childhood education. 'Basic education' includes primary or lower secondary education; 'Intermediate education' to upper secondary or post-secondary non-tertiary education; 'Advanced education' can refer to short-cycle tertiary education, Bachelor's or equivalent level, Master's or equivalent level, or Doctoral or equivalent level, while 'level not stated' is an education level not elsewhere classified. For more information see the ILOSTAT's <a href="https://www.ilo.org/ilostat-files/Documents/description_EDU_EN.pdf" rel="noopener" target=_blank">'Employment by education' document</a>. https://www.ilo.org/ilostat/ ILOSTAT

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