cth_open
Data license: CC0-1.0 · Data source: CleanTechHUB platform (cth_platform v1)
Tables
commodities
id, slug, display_name_en, display_name_es, fao_code, hs_code, category, eudr_relevant, active
32 rows
dataset_records_summary
dataset_id, dataset_slug, dataset_kind, site_id, day, n_records, avg_v1, min_v1, max_v1, avg_v2, min_v2, max_v2
0 rows
organizations_admitted
id, kind, legal_name, display_name, country_iso2, hq_city, primary_sector, iati_org_id, website, admitted_at, bookstack_page_id
0 rows
pathway_steps
id, pathway_id, step_order, step_code, title_en, title_es, description_en, description_es, required
21 rows
pathways
id, slug, url_slug, display_name_en, display_name_es, short_desc_en, short_desc_es, category, jurisdiction, icon, hero_color, applies_to, scoring_tools, output_kind, active
4 rows
projects_admitted
id, universe, titulo, descripcion, commodity_id, commodity_slug, is_conservation, subregion_id, subregion_name, municipio_dane, municipio_name, departamento, pilar_id, pilar_name, valor_total_cop, valor_total_usd, estado, fecha_inicio, fecha_fin, admitted_at, bookstack_page_id, source_url
0 rows
sites
id, name, owner_org_id, commodity_id, commodity_slug, is_conservation, centroid_lat, centroid_lng, area_hectares, municipio_dane, subregion_id, country_iso2
0 rows