Public Sector Tech Watch Latest Dataset Of Selected Cases
Joint Research Centre
@ecjrc.e8e7bddd_8510_4936_9fa6_7e1b399cbd92
Joint Research Centre
@ecjrc.e8e7bddd_8510_4936_9fa6_7e1b399cbd92
CREATE TABLE table_1 (
"id" VARCHAR,
"name" VARCHAR,
"website" VARCHAR,
"description" VARCHAR,
"geographical_extent" VARCHAR,
"geographical_coverage_country" VARCHAR,
"nuts_2021" VARCHAR,
"responsible_organisation" VARCHAR,
"responsible_organisation_category" VARCHAR,
"functions_of_government_cofog_level_i" VARCHAR,
"functions_of_government_cofog_level_ii" VARCHAR,
"status" VARCHAR,
"start_year" BIGINT,
"end_year" VARCHAR,
"process_type" VARCHAR,
"application_type" VARCHAR,
"cross_border" VARCHAR,
"cross_sector" VARCHAR,
"technology" VARCHAR,
"interaction" 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_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_eliminated_the_risk_of_corruption_and_abuse_537095d9" 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,
"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" VARCHAR,
"date_updated" TIMESTAMP
);
CREATE TABLE table_2 (
"data_entry_field" VARCHAR,
"description_variable_typology" VARCHAR
);
CREATE TABLE table_3 (
"geographic_coverage_country" VARCHAR,
"nuts_2021" VARCHAR,
"geographical_extent" VARCHAR,
"functions_of_government_cofog_level_i" VARCHAR,
"functions_of_government_cofog_level_ii" VARCHAR,
"responsible_organization_category" VARCHAR,
"process_type" VARCHAR,
"application_type" VARCHAR,
"dimensions_of_value_twizeyimana_andersson_2019" VARCHAR,
"benefit" VARCHAR,
"status" VARCHAR,
"crossborder" VARCHAR,
"technology" VARCHAR,
"crosssector" VARCHAR,
"interaction" VARCHAR,
"ai_classification_i" VARCHAR,
"ai_classification_subdomain_ii" VARCHAR,
"ai_keywords_iii" VARCHAR,
"ai_keywords_iii_listed" VARCHAR,
"reasons_for_not_publishing" VARCHAR
);
Anyone who has the link will be able to view this.