datasets
Data license: CC-BY
5 rows where createdByUserId = 9 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, namespace, isPrivate, metadataEditedByUserId, dataEditedByUserId, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3073 | V-Dem Dataset Version 8 - V-Dem Institute | 2018-10-03 13:26:02 | 2018-10-03 13:26:02 | vdem | 1 | Jaiden Mispy 9 | 2018-10-03 13:26:02 | Jaiden Mispy 9 | 2018-10-03 13:26:02 | Jaiden Mispy 9 | 0 | 1 | |||||
| 2971 | Interpersonal Trust - General Social Survey (GSS) | Extracted from the GSS Data Explorer Variable "trust" (https://gssdataexplorer.norc.org/variables/441/vshow) -> Tabulate Column: Trust (Can people be trusted) Row: Year (GSS year for this respondent) Weight var: WTSSCOMP Sample design: Simple Random Sample Exclude missing: Yes Note: as of 7 Mar 2022 there is a typo in the values on the GSS website - we think that "Can't trust" actually mean "Can trust" and is the positive response, while "Can't be too careful" is the negative response. | 2018-09-21 06:29:14 | 2018-09-21 06:29:14 | owid | 0 | Jaiden Mispy 9 | 2022-03-07 11:57:47 | Edouard Mathieu 46 | 2022-03-07 11:56:51 | Edouard Mathieu 46 | 0 | 0 | ||||
| 2970 | Percentage of persons without health insurance - Council of Economic Advisers and National Center for Health Statistics | Split from https://owid.cloud/admin/datasets/204 - Jaiden | 2018-09-21 06:20:03 | 2018-09-21 06:20:03 | owid | 0 | Jaiden Mispy 9 | 2018-09-21 06:20:03 | Jaiden Mispy 9 | 2018-09-21 06:20:03 | Jaiden Mispy 9 | 0 | 0 | ||||
| 2760 | Terrain Ruggedness Index - Nunn and Puga (2012) | 2018-04-15 14:11:25 | 2018-04-15 14:11:25 | owid | 0 | Jaiden Mispy 9 | 2018-04-15 14:11:25 | Jaiden Mispy 9 | 2018-04-15 14:11:25 | Jaiden Mispy 9 | 0 | 0 | |||||
| 115 | Countries Continents | Continents each country belongs to. Good one. | 2015-08-19 00:09:40 | 2021-10-24 11:53:02 | owid | 0 | Jaiden Mispy 9 | 2021-10-24 11:53:02 | Edouard Mathieu 46 | 2021-10-24 11:53:02 | Jaiden Mispy 9 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");