chart_tags
Data license: CC-BY
6 rows where tagId = 214
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
---|---|---|---|---|---|---|
1570,214 | Time required to start a business 1570 | Business Environment 214 | 2 | 2023-12-24 10:02:56 | 1 | |
1589,214 | Share of firms with a female top manager 1589 | Business Environment 214 | 2 | 2023-02-09 11:26:13 | 2023-09-15 15:36:12 | 1 |
1918,214 | Power outages in firms in a typical month 1918 | Business Environment 214 | 2 | 2023-12-15 11:36:24 | 1 | |
2418,214 | Share of people who prefer a male vs. a female boss 2418 | Business Environment 214 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
2420,214 | Share of women who prefer a male boss vs. share of men who prefer a male boss 2420 | Business Environment 214 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
2689,214 | Share of people who report having intentions to start business 2689 | Business Environment 214 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "chart_tags" ( "chartId" INTEGER NOT NULL , "tagId" INTEGER NOT NULL , "keyChartLevel" TINYINT NOT NULL DEFAULT '0' , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "isApproved" TINYINT NOT NULL DEFAULT '0' , PRIMARY KEY ("chartId", "tagId"), FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE RESTRICT ON DELETE CASCADE, FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "FK_chart_tags_tagId" ON "chart_tags" ("tagId");