Show Table

Column Verbose Name Type Groupable Filterable Is temporal
project_id None INTEGER(11)
thematic Thematic VARCHAR(255) COLLATE UTF8MB4_UNI
country_name Country VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_0 NUTS-0 VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_1 NUTS-1 VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_2 NUTS-2 VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_3 NUTS-3 VARCHAR(255) COLLATE UTF8MB4_UNI
cca2 None VARCHAR(255) COLLATE UTF8MB4_UNI
lat None DOUBLE
lng None DOUBLE
period Programme Period VARCHAR(255) COLLATE UTF8MB4_UNI
programme_id None INTEGER(11)
programme_name Programme Name VARCHAR(255) COLLATE UTF8MB4_UNI
program_type Programme Type VARCHAR(255) COLLATE UTF8MB4_UNI
thematic_objective Thematic Objective (only 2014-2020 projects) VARCHAR(653) COLLATE UTF8MB4_UNI
investment_priority Investment Priority (only 2014-2020 projects) VARCHAR(653) COLLATE UTF8MB4_UNI
project_start None DOUBLE
budget None DOUBLE
partner_id None INTEGER(11)
partner_lgt None DOUBLE
partner_lat None DOUBLE
project_end None DOUBLE
is_leader None TINYINT(4)
is_ext_nuts None TINYINT(4)
geojson GeoGson STRING
geojsonpoint geojsonpoint STRING
nuts0_lat None DOUBLE
nuts0_lng None DOUBLE
nuts1_lat None DOUBLE
nuts1_lng None DOUBLE
nuts2_lat None DOUBLE
nuts2_lng None DOUBLE
nuts3_lat None DOUBLE
nuts3_lng None DOUBLE
thematic_id None SMALLINT(10)
nuts_0_id None SMALLINT(10)
nuts_1_id None SMALLINT(10)
nuts_2_id None SMALLINT(10)
nuts_3_id None SMALLINT(10)
period_id None SMALLINT(10)
program_type_id None SMALLINT(10)
thematic_objective_id None SMALLINT(10)
investment_priority_id None SMALLINT(10)
thematic_elipsed Thematic VARCHAR
thematic_priority Thematic Priority None
nuts_0_code nuts_0_code None
nuts_1_code nuts_1_code None
nuts_2_code nuts_2_code None
nuts_3_code nuts_3_code None
Record Count: 49
Metric Verbose Name Type
Number of Projects None None
Number of Thematics None None
Number of Programmes None None
Number of Partnerships None None
Aggregated Budget Aggregated Budget [€] None
Average Budget per Project None None
count COUNT(*) None
sum__nuts0_lat None None
avg__nuts0_lat None None
sum__nuts0_lng None None
avg__nuts0_lng None None
sum__nuts1_lat None None
avg__nuts1_lat None None
sum__nuts1_lng None None
avg__nuts1_lng None None
sum__nuts2_lat None None
avg__nuts2_lat None None
sum__nuts2_lng None None
avg__nuts2_lng None None
sum__nuts3_lat None None
avg__nuts3_lat None None
sum__nuts3_lng None None
avg__nuts3_lng None None
sum__nuts_0_id None sum
avg__nuts_0_id None avg
sum__nuts_1_id None sum
avg__nuts_1_id None avg
sum__nuts_2_id None sum
avg__nuts_2_id None avg
sum__nuts_3_id None sum
avg__nuts_3_id None avg
sum__period_id None sum
avg__period_id None avg
sum__program_type_id None sum
avg__program_type_id None avg
sum__thematic_objective_id None sum
avg__thematic_objective_id None avg
sum__investment_priority_id None sum
avg__investment_priority_id None avg
Record Count: 39
Table Name superset_legacy_master
Sql None
Enable Filter Select False
Fetch Values Predicate None
Database keep_statistics
Schema None
Description *test*
Owners []
Main Datetime Column None
Default Endpoint None
Offset 0
Cache Timeout 0
SQL Lab View False
Template parameters None
Perm [keep_drupal_staging].[superset_legacy_master](id:1)
Associated Charts [Project Number Trend, Projects per Thematics, Started Projects per Thematics by Year, Budget per Programme Types per Year, Project, Partnerships and Budget - NUTS3 Level, Started Projects per Thematics by Year, Projects and Partnerships per Year, Programmes, Projects, Project, Partnerships and Budget, Number of Starting Projects per Year, Projects, partnerships and budgets per thematic, Projects, partnerships and budgets per programme type, Projects, partnerships and budget per programming period, Projects per Program Type and Period, Number of Partnerships per Year, Budget per starting projects per Year (€), Number of Programmes per Year, Budget (€) per Thematic Objective and per NUTS, Programmes per Thematic Objective and NUTS, Budget per, Budget per main five thematics per projects start Year, Projects per main five thematics per projects start Year, Projects, Budget, Programmes and Partnerships per NUTS, Pivot-Test, Pivot Test, Projects, partnerships and budget per countries and NUTS regions, Budget per starting projects per Year (€), Number of Starting Projects per Year, Countries, Projects per Period, collaboration-frame [hidden], European Countries Projects Map, Projects, Thematics, Top Countries per Number of Projects, Projects per Thematic, Budget per Thematic/Period, Partnerships - Projects and Programme Type, Projects per Period, Average Budget per Project, Partnerships and Projects, Countries Word Cloud, Top Programmes per Number of Projects, Partnerships per Thematics, Projects per Thematics, Partnerships per Program Type, Partnerships per Country, Budget per Programme Type and Period, Country per Thematics, World Map - Partnerships (color) and Projects (bubbles), Thematic Objectives and Investment Priorities Partitions, Projects per Thematic, Europe Projects Map, Budget per Thematic/Period, Thematics, Countries, Programmes, Projects per Program Type, Map of Partnerships, Projects per Programming Period, Top countries per number of projects, Countries Word Cloud, Top programmes per number of projects, Partnerships per Thematics, Projects per Thematic, Partnerships per Program Type, Partnerships per Country, Budget per Programme Types per Year, Budget per Programme Type and Period, Countries per Thematics, World Map - Partnerships (color) and Projects (bubbles), Thematic Objectives and Investment Priorities Partitions, Projects per Programme Type, Projects per Thematic and Programme Type, Projects per Thematic and Programming Period, Projects per Programme Type and Programming Period, Projects and Partnerships per Programme Type, Partnerships per Thematics, Partnerships per Thematic and Programme Type, Partnerships per Thematic and Programming Period, Partnerships per Programme Type and Programming Period, Project budget (€), Budget per Thematic, Budget per Programme Type, Budget per Programming Period, Programmes per Programme Type, Programmes per Programming Period, Budget per Thematic and Programme Type, Budget per Thematic and Programming Period, Budget per Programme Type and Programming Period, Projects per Thematic, Partnerships per Thematic, Programmes per Thematics and Programming Period, Programmes per Thematic and Programme Type, Partnerships per Programme Type and Programming Period, Budget per Thematic and Programming Period, Projects and Partnerships per Thematic - bubble size indicates total budget size, Programmes per Thematic, Programmes and Projects per Programme Type, Programmes and Partnerships per Programme Type, Projects and Budgets per Programme Type, Projects and Budgets per Programming Period, Partnerships and Budgets per Thematic, Partnerships and Budget per Programme Type, Partnerships and Budget per Programming Period, Budgets per Thematic, Budget per Country, Programmes and Budget per Programme Type, Programmes and Projects per Programming Period, Programmes and Partnerships per Programming Period, Programmes and Budgets per Programming Period, Projects per Country, Partnerships per Country, Budget per country, Programmes per country, Projects per country, Budget per Thematic, Partnerships per Country, Thematics per Country, Programmes per Country, Projects per Programme Type, Partnerships per Programming Period, Projects per Programming Period, Programmes per Programme Type and Programming Period, TestHexagon, Number of Projects per Period and Programme Type, Number of Projects per Programme Period and Programme Type, Projects for Programme Period and Programme Type, ChartWithError, CORDIER MAP BUTTAMI, Partnerships, Projects and Partnerships per Programming Period, Partnerships per Programme Type, Partnerships per Programming Period, Projects per country, GeoJson Test, Projects per NUTS1 region, Projects per NUTS2 region, GeoJsonTest, Chart Nuts1M, Chart Nuts0M, Chart Nuts2M, Chart Nuts123, Projects and Partnerships per Thematic, Projects per NUTS3 region, Programmes per country, Programmes per NUTS1 region, Programmes per NUTS2 regions, Programmes per NUTS3 region, #Thematics x Nuts0, #Thematics x Nuts1, #Thematics x Nuts2, #Thematics x Nuts3, Partnerships per NUTS3 region, Budget (€) per NUTS3 region (2014-2020), Budget (€) per NUTS2 region (2014-2020), Budget (€) per NUTS1 region (2014-2020 only), Partnerships per NUTS2 region, Partnerships per NUTS1 region, Partnerships per country, Budget (€) per country (2014-2020 only), Programmes, projects, partners and budget per countries and NUTS regions, Projects and Partnerships per Thematic Perc, Projects per Thematic %, Projects and Partnerships per Thematic %, Partnerships per Thematics %, Partnerships and Budgets per Thematic %, Budget per Thematic %, Programmes per Thematic %, Programmes and Partnerships per Thematic %, Programmes and Projects per Thematic %, Programmes and Budgets per Thematic %, Projects and Partnerships per Thematic, Projects per Thematic, Budget per Thematic Mobile, ButtamiGiancarlo]