Show Table

Column Verbose Name Type Groupable Filterable Is temporal
created_at None TIMESTAMP WITH TIME ZONE
investment_priority_content None TEXT
investment_priority_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)
partnership_id None BIGINT
partnership_nuts_0_lat None DOUBLE PRECISION
partnership_nuts_0_lng None DOUBLE PRECISION
partnership_nuts_1_lat None DOUBLE PRECISION
partnership_nuts_1_lng None DOUBLE PRECISION
partnership_nuts_2_lat None DOUBLE PRECISION
partnership_nuts_2_lng None DOUBLE PRECISION
partnership_nuts_3_lat None DOUBLE PRECISION
partnership_nuts_3_lng None DOUBLE PRECISION
partnership_total_budget None NUMERIC(11, 2)
programme_id None INTEGER
programme_period_id None INTEGER
programme_period_title None VARCHAR(255)
programme_title None VARCHAR(255)
programme_type_id None INTEGER
programme_type_title None VARCHAR(255)
project_end_date None DATE
project_id None BIGINT
project_start_date None DATE
project_theme_id None INTEGER
project_theme_title Theme VARCHAR(255)
project_total_budget None NUMERIC(11, 2)
thematic_objective_content None TEXT
thematic_objective_id None INTEGER
thematic_priority_content None TEXT
thematic_priority_id None INTEGER
Record Count: 37
Metric Verbose Name Type
sum_partnership_budgets Aggregated Partnership Budgets (€) None
count_distinct_projects Number of Projects None
count_distinct_themes Number of Themes None
count COUNT(*) count
Record Count: 4
Table Name superset_projects
Sql None
Enable Filter Select False
Fetch Values Predicate None
Database keep_statistics
Schema None
Description None
Owners []
Main Datetime Column project_start_date
Default Endpoint None
Offset 0
Cache Timeout None
SQL Lab View False
Template parameters None
Extra None
Perm [keep_statistics].[superset_projects](id:14)
Associated Charts [Number of starting projects per year, Projects per NUTS0, Projects, Programmes, projects, partnerships and budgets per country (2014-2020), Budget (2014-2020 only) per five main themes per project start year, Number of starting projects per year, Programmes, projects, partnerships and budgets per NUTS2, Themes, Projects per theme, Projects per programming period, Budget (2014-2020 only) per starting projects per year, Budget (2014-2020 only) per five main themes per project start year, Avarage project budget by theme, TEST AVG BY THEME, Budget (2014-2020 only) per starting projects per year, Projects per type of programme, Projects per NUTS1, Projects per NUTS0, Projects per Thematic Objective (2014-2020), Projects per Investment Priority (2014-2020), Projects per Thematic Priority (2014-2020), Average project budget by theme., Projects, Themes, Projects per NUTS1, Projects per theme]