datasets

This table contains information on all the datasets we publish. Variables are linked to a dataset in a n:1 relationship

Data license: CC-BY

11 rows where metadataEditedByUserId = 11 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, createdAt, updatedAt, isPrivate, metadataEditedAt, dataEditedAt, isArchived, createdAt (date), updatedAt (date), metadataEditedAt (date), dataEditedAt (date)

id ▲ name description createdAt updatedAt namespace isPrivate createdByUserId metadataEditedAt metadataEditedByUserId dataEditedAt dataEditedByUserId nonRedistributable isArchived sourceChecksum shortName version updatePeriodDays
3008 Social Expenditure %GDP - Lindert_OECD_New (2004) (split) Data-set put together by Marco Molteni under the guidance of Esteban. OECD (SOCX) on social spending are used as reference series and data are extrapolated backwards using OECD 1985. 2017-04-28 04:09:25 2017-05-18 20:22:25 owid 1 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 0 0        
3007 Social Expenditure %GDP - Lindert_OECD_Old (2004) (split) Data-set put together by Marco Molteni under the guidance of Esteban. OECD (SOCX) on social spending are used as reference series and data are extrapolated backwards using OECD 1985. 2017-04-28 04:09:25 2017-05-18 20:22:25 owid 1 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 0 0        
3006 Social Expenditure %GDP - Lindert_Historical (2004) (split) Data-set put together by Marco Molteni under the guidance of Esteban. OECD (SOCX) on social spending are used as reference series and data are extrapolated backwards using OECD 1985. 2017-04-28 04:09:25 2017-05-18 20:22:25 owid 1 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 0 0        
3005 Social Expenditure %GDP - OECD (1985) (split) Data-set put together by Marco Molteni under the guidance of Esteban. OECD (SOCX) on social spending are used as reference series and data are extrapolated backwards using OECD 1985. 2017-04-28 04:09:25 2017-05-18 20:22:25 owid 1 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 0 0        
3004 Social Expenditure %GDP - OECD (SOCX) (split) Data-set put together by Marco Molteni under the guidance of Esteban. OECD (SOCX) on social spending are used as reference series and data are extrapolated backwards using OECD 1985. 2017-04-28 04:09:25 2017-05-18 20:22:25 owid 1 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 2017-05-18 20:22:25 Marco Molteni 11 0 0        
2999 Home production working hours per week in the US, by demographic group (Ramey (2009)) (split)   2017-04-14 21:02:34 2017-09-27 16:03:26 owid 1 Marco Molteni 11 2017-09-27 16:03:26 Marco Molteni 11 2017-09-27 16:03:26 Marco Molteni 11 0 0        
2997 General Government Health Expenditure (%GDP) (WHO (2014)) (split)   2017-04-10 23:15:11 2017-04-28 01:16:42 owid 1 Marco Molteni 11 2017-04-28 01:16:42 Marco Molteni 11 2017-04-28 01:16:42 Marco Molteni 11 0 1        
2991 Share of population living in extreme poverty by region (PovcalNet (World Bank) (2017)) (split) Includes previous dataset: - Cost of filling the poverty gap in int-$ 2011 - Povcal created on the 8th March 2017 - New Poverty headcount absolute number, by regions - Povcal - Share of World Population living in Absolute Poverty 1981-2030 - PovcalNe 2017-02-28 19:48:57 2017-11-14 14:54:29 owid 1 Marco Molteni 11 2017-11-14 14:54:29 Marco Molteni 11 2017-11-14 14:54:29 Marco Molteni 11 0 1        
390 Weekly home production hours in the USA - Ramey (2009) & Ramey Francis (2009)   2017-04-14 21:02:34 2017-09-27 16:03:26 owid 0 Marco Molteni 11 2017-09-27 16:03:26 Marco Molteni 11 2017-09-27 16:03:26 Marco Molteni 11 0 0        
365 Measures and indicators for Poverty - PovcalNet (World Bank) (2017) Includes previous dataset: - Cost of filling the poverty gap in int-$ 2011 - Povcal created on the 8th March 2017 - New Poverty headcount absolute number, by regions - Povcal - Share of World Population living in Absolute Poverty 1981-2030 - PovcalNe 2017-02-28 19:48:57 2017-11-14 14:54:29 owid 0 Marco Molteni 11 2017-11-14 14:54:29 Marco Molteni 11 2017-11-14 14:54:29 Marco Molteni 11 0 1        
293 Number of observations in Povcal per decade - OWID (2017)   2016-09-12 19:47:48 2017-11-14 14:58:38 owid 0 Marco Molteni 11 2017-11-14 14:58:38 Marco Molteni 11 2017-11-14 14:58:38 Marco Molteni 11 0 1        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "datasets" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NOT NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"namespace" VARCHAR(255) NOT NULL  ,
	"isPrivate" TINYINT NOT NULL DEFAULT '0' ,
	"createdByUserId" INTEGER NOT NULL  ,
	"metadataEditedAt" DATETIME NOT NULL  ,
	"metadataEditedByUserId" INTEGER NOT NULL  ,
	"dataEditedAt" DATETIME NOT NULL  ,
	"dataEditedByUserId" INTEGER NOT NULL  ,
	"nonRedistributable" TINYINT NOT NULL DEFAULT '0' ,
	"isArchived" TINYINT NOT NULL DEFAULT '0' ,
	"sourceChecksum" VARCHAR(64) NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"version" VARCHAR(255) NULL  ,
	"updatePeriodDays" INTEGER NULL,
	FOREIGN KEY("createdByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("dataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("metadataEditedByUserId") REFERENCES "users" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "datasets_createdByUserId" ON "datasets" ("createdByUserId");
CREATE INDEX "datasets_dataEditedByUserId" ON "datasets" ("dataEditedByUserId");
CREATE INDEX "datasets_metadataEditedByUserId" ON "datasets" ("metadataEditedByUserId");
CREATE UNIQUE INDEX "unique_short_name_version_namespace" ON "datasets" ("shortName", "version", "namespace");