chart_dimensions
Data license: CC-BY
7 rows where variableId = 815383
This data as json, CSV (advanced)
Suggested facets: createdAt (date)
| id ▼ | order | property | chartId | variableId | createdAt | updatedAt |
|---|---|---|---|---|---|---|
| 219913 | 0 | y | Life expectancy for people of different ages 7287 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2023-11-21 12:20:59 | |
| 230234 | 0 | y | Life expectancy 64 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2023-12-22 17:00:10 | |
| 236469 | 0 | y | Smallpox death rate versus life expectancy in Sweden 2694 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2024-02-15 12:39:43 | |
| 258394 | 0 | y | Life expectancy in the United States is lower than peer nations 7870 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2024-06-28 09:32:57 | |
| 261144 | 0 | y | Life expectancy vs. GDP per capita 2722 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2024-07-17 09:53:21 | |
| 261282 | 0 | y | Life expectancy vs. liberal democracy index 3480 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2024-07-17 09:54:05 | |
| 261886 | 0 | y | Life expectancy 7216 | Period life expectancy at birth - Sex: all - Age: 0 815383 | 2024-07-17 09:57:11 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "chart_dimensions" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"order" INTEGER NOT NULL ,
"property" VARCHAR(255) NOT NULL ,
"chartId" INTEGER NOT NULL ,
"variableId" INTEGER NOT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL,
FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("variableId") REFERENCES "variables" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "chart_dimensions_chartId_78d6a092_fk_charts_id" ON "chart_dimensions" ("chartId");
CREATE INDEX "chart_dimensions_variableId_9ba778e6_fk_variables_id" ON "chart_dimensions" ("variableId");