Show Table

Column Verbose Name Type Groupable Filterable Is temporal
budget None DOUBLE
investment_priority None VARCHAR(653) COLLATE UTF8MB4_UNI
investment_priority_id None SMALLINT(10)
nuts_0 None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_0_id None SMALLINT(10)
nuts_1 None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_1_id None SMALLINT(10)
nuts_2 None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_2_id None SMALLINT(10)
nuts_3 None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_3_id None SMALLINT(10)
partner_id None INTEGER(11)
period None VARCHAR(255) COLLATE UTF8MB4_UNI
period_id None SMALLINT(10)
program_type None VARCHAR(255) COLLATE UTF8MB4_UNI
program_type_id None SMALLINT(10)
programme_id None INTEGER(11)
programme_name None VARCHAR(255) COLLATE UTF8MB4_UNI
programme_name_id None SMALLINT(10)
project_id None INTEGER(11)
thematic None VARCHAR(255) COLLATE UTF8MB4_UNI
thematic_id None SMALLINT(10)
thematic_objective None VARCHAR(653) COLLATE UTF8MB4_UNI
thematic_objective_id None SMALLINT(10)
Record Count: 24
Metric Verbose Name Type
avg__programme_id None None
sum__project_id None None
avg__project_id None None
sum__partner_id None None
avg__partner_id None None
sum__budget None None
avg__budget None None
sum__programme_id None None
count COUNT(*) None
Number of Projects None None
Number of Thematics None None
Number of Programmes None None
Number of Partners None None
Aggregated Budget None None
sum__thematic_id None None
avg__thematic_id None None
sum__nuts_0_id None None
avg__nuts_0_id None None
sum__nuts_1_id None None
avg__nuts_1_id None None
sum__nuts_2_id None None
avg__nuts_2_id None None
sum__period_id None None
avg__period_id None None
sum__programme_name_id None None
avg__programme_name_id None None
sum__program_type_id None None
avg__program_type_id None None
sum__thematic_objective_id None None
avg__thematic_objective_id None None
sum__investment_priority_id None None
avg__investment_priority_id None None
sum__nuts_3_id None None
avg__nuts_3_id None None
Record Count: 34
Table Name superset_legacy_thematics1420
Sql None
Enable Filter Select False
Fetch Values Predicate None
Database keep_statistics
Schema None
Description None
Owners []
Main Datetime Column None
Default Endpoint None
Offset 0
Cache Timeout None
SQL Lab View False
Template parameters None
Extra None
Perm [keep_drupal_staging].[superset_legacy_thematics1420](id:7)
Associated Charts [Programmes per Thematic Objective per NUTS, Projects per Thematic Objective and Investment Priority, Projects per Thematic Objective and Programme Type, Partnerships per Thematic Objective, Partnerships per Thematic Objective and Programme Type, Budget per Thematic Objective and Programme Type, Budget per Thematic Objective and Investment Priority, Programmes per Programme Type and Thematic Objective, Programmes per Thematic Objectives and Investment Priority, Projects per Thematic Objective and per NUTS, Partnerships per Thematic Objective and NUTS, Budget per Thematic Objective and Programme Type, TEST]