tags
Data license: CC-BY
10 rows where parentId = 1500 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: updatedAt, createdAt (date), updatedAt (date)
| id ▲ | name | createdAt | updatedAt | parentId | specialType | slug |
|---|---|---|---|---|---|---|
| 233 | Migration | 2016-01-01 00:00:00 | 2023-12-04 19:58:22 | Population and Demographic Change 1500 | migration | |
| 232 | Remittances | 2016-01-01 00:00:00 | 2023-10-12 16:55:46 | Population and Demographic Change 1500 | ||
| 175 | Urbanization | 2016-01-01 00:00:00 | 2023-12-04 19:58:22 | Population and Demographic Change 1500 | urbanization | |
| 8 | Gender Ratio | 2016-01-01 00:00:00 | 2023-12-04 19:58:20 | Population and Demographic Change 1500 | gender-ratio | |
| 7 | Life Expectancy | 2016-01-01 00:00:00 | 2023-12-04 19:58:20 | Population and Demographic Change 1500 | life-expectancy | |
| 5 | Child & Infant Mortality | 2016-01-01 00:00:00 | 2024-06-19 23:47:25 | Population and Demographic Change 1500 | child-mortality | |
| 4 | Age Structure | 2016-01-01 00:00:00 | 2023-12-04 19:58:20 | Population and Demographic Change 1500 | age-structure | |
| 3 | Fertility Rate | 2016-01-01 00:00:00 | 2023-12-04 19:58:20 | Population and Demographic Change 1500 | fertility-rate | |
| 2 | Future Population Growth | 2016-01-01 00:00:00 | 2018-11-14 20:58:18 | Population and Demographic Change 1500 | ||
| 1 | Population Growth | 2016-01-01 00:00:00 | 2023-12-04 19:58:20 | Population and Demographic Change 1500 | population-growth |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "tags" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(255) NOT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"parentId" INTEGER NULL ,
"specialType" VARCHAR(255) NULL ,
"slug" VARCHAR(512) NULL,
FOREIGN KEY("parentId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "dataset_subcategories_name_fk_dst_cat_id_6ce1cc36_uniq" ON "tags" ("name", "parentId");
CREATE INDEX "parentId" ON "tags" ("parentId");