Column | Verbose Name | Type | Groupable | Filterable | Is temporal | |
---|---|---|---|---|---|---|
num_collaborations | None | INTEGER(11) | ||||
nuts_0 | Country | TEXT | ||||
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_name | None | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
programme_name_id | None | SMALLINT(10) | ||||
source | Country | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
source_id | None | SMALLINT(10) | ||||
target | Partner Country | VARCHAR(255) COLLATE UTF8MB4_UNI | ||||
target_id | None | SMALLINT(10) |
Metric | Verbose Name | Type | |
---|---|---|---|
avg__period_id | None | avg | |
avg__num_collaborations | None | None | |
sum__num_collaborations | None | None | |
Number of Collaborations | None | None | |
sum__source_id | None | sum | |
avg__source_id | None | avg | |
sum__target_id | None | sum | |
avg__target_id | None | avg | |
sum__program_type_id | None | sum | |
avg__program_type_id | None | avg | |
sum__programme_name_id | None | sum | |
avg__programme_name_id | None | avg | |
sum__period_id | None | sum | |
count | COUNT(*) | None |
Table Name | superset_legacy_collaborations |
---|---|
Sql | None |
Enable Filter Select | True |
Fetch Values Predicate | None |
Database | keep_statistics |
Schema | None |
Description | shared projects |
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_collaborations](id:5) |
Associated Charts | [One or more target countries, Select country:, Cooperation among countries (# of projects in common), Cooperation among countries (# of projects in common)] |