Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
---|---|---|---|---|---|---|
thematic_priority_id | None | INTEGER | ||||
thematic_priority_content | None | TEXT | ||||
thematic_objective_id | None | INTEGER | ||||
thematic_objective_content | None | TEXT | ||||
project_theme_title | None | VARCHAR(255) | ||||
project_theme_id | None | INTEGER | ||||
project_id | None | INTEGER | ||||
programme_type_title | None | VARCHAR(255) | ||||
programme_type_id | None | INTEGER | ||||
programme_title | None | VARCHAR(255) | ||||
programme_period_title | None | VARCHAR(255) | ||||
programme_period_id | None | INTEGER | ||||
programme_id | None | INTEGER | ||||
partnership_total_budget | None | NUMERIC(11, 2) | ||||
partnership_nuts_3_lng | None | DOUBLE PRECISION | ||||
partnership_nuts_3_lat | None | DOUBLE PRECISION | ||||
partnership_nuts_2_lng | None | DOUBLE PRECISION | ||||
partnership_nuts_2_lat | None | DOUBLE PRECISION | ||||
partnership_nuts_1_lng | None | DOUBLE PRECISION | ||||
partnership_nuts_1_lat | None | DOUBLE PRECISION | ||||
partnership_nuts_0_lng | None | DOUBLE PRECISION | ||||
partnership_nuts_0_lat | None | DOUBLE PRECISION | ||||
partnership_id | None | BIGINT | ||||
nuts_3_title | NUTS3 | VARCHAR(255) | ||||
nuts_3_id | None | INTEGER | ||||
nuts_2_title | NUTS2 | VARCHAR(255) | ||||
nuts_2_id | None | INTEGER | ||||
nuts_1_title | NUTS1 | VARCHAR(255) | ||||
nuts_1_id | None | INTEGER | ||||
nuts_0_title | NUTS0 | VARCHAR(255) | ||||
nuts_0_id | None | INTEGER | ||||
investment_priority_id | None | INTEGER | ||||
investment_priority_content | None | TEXT | ||||
created_at | None | TIMESTAMP WITH TIME ZONE |
Metric | Verbose Name | Type | |
---|---|---|---|
sum_partnership_budgets | Aggregated Partnership Budgets (€) | None | |
count | COUNT(*) | None | |
count_distinct_partnerships | Number of Partnerships | None | |
count_distinct_programmes | Number of Programmes | None | |
count_distinct_projects | Number of Projects | None |
Table Name | superset_partnerships |
---|---|
Sql | |
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_partnerships](id:13) |
Associated Charts | [Budget (€) for 2014 – 2020, Budget (€) for 2014 – 2020, Number of projects, partnerships and relative budget sizes per theme, Budget (€) for 2014 – 2020, Number of projects, partnerships and 2014-2020 budget sizes per theme, Number of projects, partnerships and 2014-2020 budget sizes per theme, Aggregated budgets per country, region and programme type (2014-2020), Partnerships, Programmes, Partnerships, Projects, and Partnership budgets (2014-2020), Partnerships, Budgets (2014-2020) per Theme, Budgets (2014-2020) per Programme Type, Partnerships per NUTS 0, Partnerships per NUTS 1, Partnership budgets (2014-2020 only) per NUTS 0, Partnership budgets (2014-2020 only) per NUTS 1, Partnerships] |