Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
---|---|---|---|---|---|---|
programme_id | None | INTEGER | ||||
programme_type_id | None | INTEGER | ||||
project_theme_id | None | INTEGER | ||||
programme_period_id | None | INTEGER | ||||
nuts_0_id | None | INTEGER | ||||
nuts_1_id | None | INTEGER | ||||
nuts_2_id | None | INTEGER | ||||
nuts_3_id | None | INTEGER | ||||
thematic_objective_id | None | INTEGER | ||||
investment_priority_id | None | INTEGER | ||||
thematic_priority_id | None | INTEGER | ||||
thematic_objective_content | None | TEXT | ||||
thematic_priority_content | None | TEXT | ||||
investment_priority_content | None | TEXT | ||||
created_at | None | TIMESTAMP WITH TIME ZONE | ||||
nuts_3_title | None | VARCHAR(255) | ||||
project_theme_title | None | VARCHAR(255) | ||||
nuts_0_title | None | VARCHAR(255) | ||||
programme_period_title | None | VARCHAR(255) | ||||
nuts_1_title | None | VARCHAR(255) | ||||
nuts_2_title | None | VARCHAR(255) | ||||
programme_title | None | VARCHAR(255) | ||||
programme_type_title | None | VARCHAR(255) |
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, Programmes, Programmes, Programmes per Theme, Programmes per Programming Period, Programmes per Programme Type] |