Selected AI4IOP Cases For (JRC134713)
Joint Research Centre
@ecjrc.cdfdf221_0236_4ebd_8ae9_da5dac094a42
Joint Research Centre
@ecjrc.cdfdf221_0236_4ebd_8ae9_da5dac094a42
CREATE TABLE selected_ai4iop_cases (
"id" BIGINT,
"ucid" VARCHAR,
"name" VARCHAR,
"website" VARCHAR,
"description" VARCHAR,
"geographical_extent" VARCHAR,
"geographic_coverage_country" VARCHAR,
"geographic_coverage_nuts_2021" VARCHAR,
"responsible_organization" VARCHAR,
"responsible_organization_category" VARCHAR,
"functions_of_government_cofog_level_i" VARCHAR,
"functions_of_government_cofog_level_ii" VARCHAR,
"status" VARCHAR,
"start_year" BIGINT,
"end_year" DOUBLE,
"ai_classification_i" VARCHAR,
"ai_classification_subdomain_ii_main" VARCHAR,
"ai_classification_subdomain_ii_other_i" VARCHAR,
"ai_classification_subdomain_ii_other_ii" VARCHAR,
"ai_classification_subdomain_ii_other_iii" VARCHAR,
"ai_keywords_iii" VARCHAR,
"critical" VARCHAR,
"process_type" VARCHAR,
"application_type" VARCHAR,
"technology" VARCHAR,
"crosssector" VARCHAR,
"crossborder" VARCHAR,
"uptake" VARCHAR,
"interaction" VARCHAR,
"data_scope_1" VARCHAR,
"data_scope_2" VARCHAR,
"oss" VARCHAR,
"interop_i" VARCHAR,
"iop_level_1_technical" VARCHAR,
"iop_level_2_semantical" VARCHAR,
"iop_level_3_legal" VARCHAR,
"iop_level_4_organisational" VARCHAR,
"eif_principle_1" VARCHAR,
"eif_principle_2" VARCHAR,
"ai_action_1" VARCHAR,
"ai_action_2" VARCHAR,
"improved_public_service" VARCHAR,
"personalized_services" VARCHAR,
"public_citizen_centered_services" VARCHAR,
"increase_quality_of_psi_and_services" VARCHAR,
"more_responsive_efficient_and_cost_effective_public_services" VARCHAR,
"new_services_or_channels" VARCHAR,
"improved_administration" VARCHAR,
"improved_administrative_efficiency" VARCHAR,
"cost_reduction" VARCHAR,
"responsiveness_of_government_operation" VARCHAR,
"improved_management_of_public_resources" VARCHAR,
"increased_quality_of_processes_and_systems" VARCHAR,
"better_collaboration_and_better_communication" VARCHAR,
"reduced_or_eliminate_the_risk_of_corruption_and_abuse__6c804835" VARCHAR,
"enabled_greater_fairness_honesty_equality" VARCHAR,
"open_government_capabilities" VARCHAR,
"increased_transparency_of_public_sector_operations" VARCHAR,
"increased_public_participation_in_government_actions_a_8f28b14f" VARCHAR,
"improved_public_control_and_influence_on_government_ac_12cbd097" VARCHAR,
"source" VARCHAR,
"date_added" TIMESTAMP,
"date_updated" TIMESTAMP
);
Anyone who has the link will be able to view this.