home / cth_open

Admitted projects

Projects that have passed Oikos sustainability scoring and are admitted to one or more pathways.

Data license: CC0-1.0 · Data source: CleanTechHUB platform (cth_platform v1)

0 rows sorted by admitted_at descending

✎ View and edit SQL

This data as json

subregion_name 0

pilar_name 0

commodity_slug 0

0 records

CREATE TABLE "projects_admitted" ("id" TEXT, "universe" TEXT, "titulo" TEXT, "descripcion" TEXT, "commodity_id" TEXT, "commodity_slug" TEXT, "is_conservation" TEXT, "subregion_id" TEXT, "subregion_name" TEXT, "municipio_dane" TEXT, "municipio_name" TEXT, "departamento" TEXT, "pilar_id" TEXT, "pilar_name" TEXT, "valor_total_cop" TEXT, "valor_total_usd" TEXT, "estado" TEXT, "fecha_inicio" TEXT, "fecha_fin" TEXT, "admitted_at" TEXT, "bookstack_page_id" TEXT, "source_url" TEXT);
CREATE INDEX "idx_projects_admitted_commodity_slug" ON "projects_admitted" ("commodity_slug");
CREATE INDEX "idx_projects_admitted_subregion_id" ON "projects_admitted" ("subregion_id");
Powered by Datasette · Queries took 1.2ms · Data license: CC0-1.0 · Data source: CleanTechHUB platform (cth_platform v1)