owid: sources: 2 rows where datasetId = 6010 sorted by id descending

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

2 rows where datasetId = 6010 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
29561	World Bank (2021)	{ "link": "https://wbl.worldbank.org/en/wbl-data", "retrievedDate": "2023-05-12", "additionalInfo": "\nBy developing a time series and further researching the interaction between inequality of opportunity for women and labor market dynamics, Women, Business and the Law strengthens insights into how women\u2019s employment and entrepreneurship are affected by legal gender discrimination, and in turn how this affects economic outcomes.\n\nThis specific dataset is an additional file provided by the World Bank, which contains a set of 14 non-scored questions (years 2017, 2019, and 2020), including data on child marriage, customary law, citizenship, sexual harassment, and access to ID cards.\n", "dataPublishedBy": "World Bank. 2023. Women, Business and the Law 2023. Washington, DC: World Bank." }	2023-12-14 12:03:18	2024-07-08 16:40:08	Women, Business and the Law - Additional Data (World Bank, 2021) 6010	By developing a time series and further researching the interaction between inequality of opportunity for women and labor market dynamics, Women, Business and the Law strengthens insights into how women’s employment and entrepreneurship are affected by legal gender discrimination, and in turn how this affects economic outcomes. This specific dataset is an additional file provided by the World Bank, which contains a set of 14 non-scored questions (years 2017, 2019, and 2020), including data on child marriage, customary law, citizenship, sexual harassment, and access to ID cards.	https://wbl.worldbank.org/en/wbl-data	World Bank. 2023. Women, Business and the Law 2023. Washington, DC: World Bank.
27608	World Bank (2021)	{ "link": "https://wbl.worldbank.org/en/wbl-data", "retrievedDate": "2023-05-12", "additionalInfo": "By developing a time series and further researching the interaction between inequality of opportunity for women and labor market dynamics, Women, Business and the Law strengthens insights into how women\u2019s employment and entrepreneurship are affected by legal gender discrimination, and in turn how this affects economic outcomes.\n\nThis specific dataset is an additional file provided by the World Bank, which contains a set of 14 non-scored questions (years 2017, 2019, and 2020), including data on child marriage, customary law, citizenship, sexual harassment, and access to ID cards.\n", "dataPublishedBy": "World Bank. 2023. Women, Business and the Law 2023. Washington, DC: World Bank." }	2023-05-15 16:37:29	2024-07-08 16:40:07	Women, Business and the Law - Additional Data (World Bank, 2021) 6010	By developing a time series and further researching the interaction between inequality of opportunity for women and labor market dynamics, Women, Business and the Law strengthens insights into how women’s employment and entrepreneurship are affected by legal gender discrimination, and in turn how this affects economic outcomes. This specific dataset is an additional file provided by the World Bank, which contains a set of 14 non-scored questions (years 2017, 2019, and 2020), including data on child marriage, customary law, citizenship, sexual harassment, and access to ID cards.	https://wbl.worldbank.org/en/wbl-data	World Bank. 2023. Women, Business and the Law 2023. Washington, DC: World Bank.

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