i_tnp_z
5 rows where region = 6
This data as json, CSV (advanced)
| id ▼ | region | canton | distrito | valor | ano | ente |
|---|---|---|---|---|---|---|
| 26 | Pacífico Central 6 | 1,15199923017139 | 2021 | |||
| 27 | Pacífico Central 6 | 0,846122423065278 | 2022 | |||
| 28 | Pacífico Central 6 | 0,0138529711719012 | 2023 | |||
| 29 | Pacífico Central 6 | -1,01047866192764 | 2024 | |||
| 30 | Pacífico Central 6 | 0,156121253546837 | 2025 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "i_tnp_z" (
"id" INTEGER NOT NULL UNIQUE,
"region" INTEGER NOT NULL,
"canton" INTEGER,
"distrito" INTEGER,
"valor" REAL,
"ano" INTEGER NOT NULL,
"ente" INTEGER,
PRIMARY KEY("id" AUTOINCREMENT),
FOREIGN KEY("ente") REFERENCES "d_entes"("id"),
FOREIGN KEY("region") REFERENCES "d_regiones"("id")
);