Show Table

Column Verbose Name Type Groupable Filterable Is temporal
thematic None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_0 None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_1 None VARCHAR(255) COLLATE UTF8MB4_UNI
nuts_2 None VARCHAR(255) COLLATE UTF8MB4_UNI
period None VARCHAR(255) COLLATE UTF8MB4_UNI
programme_name None VARCHAR(255) COLLATE UTF8MB4_UNI
program_type None VARCHAR(255) COLLATE UTF8MB4_UNI
project_id None INTEGER(11)
partner_id None INTEGER(11)
budget None DOUBLE
programme_id None INTEGER(11)
thematic_objective None VARCHAR(653) COLLATE UTF8MB4_UNI
investment_priority None VARCHAR(653) COLLATE UTF8MB4_UNI
nuts_3 None VARCHAR(255) COLLATE UTF8MB4_UNI
thematic_id None SMALLINT(10)
nuts_0_id None SMALLINT(10)
nuts_1_id None SMALLINT(10)
nuts_2_id None SMALLINT(10)
period_id None SMALLINT(10)
programme_name_id None SMALLINT(10)
program_type_id None SMALLINT(10)
thematic_objective_id None SMALLINT(10)
investment_priority_id None SMALLINT(10)
nuts_3_id None SMALLINT(10)
Record Count: 24
Metric Verbose Name Type
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
avg__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
Perm [keep_drupal_staging].[superset_legacy_thematics1420](id:7)
Associated Charts [Projects per Thematic Objective and per NUTS, Partnerships per Thematic Objective and NUTS, 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, Budget per Thematic Objective and Programme Type, TEST]