| Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
|---|---|---|---|---|---|---|
| programme_id | None | INTEGER | ||||
| programme_title | None | VARCHAR(255) | ||||
| programme_type_id | None | INTEGER | ||||
| programme_type_title | None | VARCHAR(255) | ||||
| project_theme_id | None | INTEGER | ||||
| project_theme_title | None | VARCHAR(255) | ||||
| programme_period_id | None | INTEGER | ||||
| nuts_0_id | None | INTEGER | ||||
| nuts_0_title | None | VARCHAR(255) | ||||
| nuts_1_id | None | INTEGER | ||||
| nuts_1_title | None | VARCHAR(255) | ||||
| nuts_2_id | None | INTEGER | ||||
| nuts_2_title | None | VARCHAR(255) | ||||
| nuts_3_id | None | INTEGER | ||||
| nuts_3_title | None | VARCHAR(255) | ||||
| thematic_objective_id | None | INTEGER | ||||
| thematic_objective_content | None | TEXT | ||||
| investment_priority_id | None | INTEGER | ||||
| investment_priority_content | None | TEXT | ||||
| thematic_priority_id | None | INTEGER | ||||
| thematic_priority_content | None | TEXT | ||||
| programme_period_title | None | VARCHAR(255) | ||||
| created_at | None | TIMESTAMP WITH TIME ZONE |
| Metric | Verbose Name | Type | |
|---|---|---|---|
| count_distinct_programmes | Number of Programmes | None | |
| count | COUNT(*) | count |
| Table Name | superset_programmes |
|---|---|
| Sql | None |
| Enable Filter Select | False |
| Fetch Values Predicate | None |
| Database | keep_statistics |
| Schema | None |
| Description | None |
| Owners | [] |
| Main Datetime Column | created_at |
| Default Endpoint | None |
| Offset | 0 |
| Cache Timeout | None |
| SQL Lab View | False |
| Template parameters | None |
| Extra | None |
| Perm | [keep_statistics].[superset_programmes](id:12) |
| Associated Charts | [Programmes with projects in keep.eu, Programmes, Programmes, Programmes 2, Programmes, Programmes, Programmes per Theme, Programmes per Programming Period, Programmes per Programme Type] |