About this Dataset

Public Sector Tech Watch Latest Dataset Of Selected Cases

This open dataset includes the list of cases for the purpose of the Public Sector Tech Watch, concerning the use of Artificial Intelligence, Blockchain and other emerging technologies within the public sector. Complete metadata and taxonomy information about the cases are available in the separate files below. Please consider that this dataset is currently a work in progress and is set to be regularly enriched with additional use cases. If you notice any mistake or you would like to share some suggestions or feedback. more information here: https://joinup.ec.europa.eu/collection/public-sector-tech-watch and here: https://joint-research-centre.ec.europa.eu/scientific-activities-z/innovations-public-governance_en
Publisher name: Joint Research Centre
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/joint-research-centre
Last updated: 2025-02-12T13:06:01Z

Tables

Table 1

@ecjrc.e8e7bddd_8510_4936_9fa6_7e1b399cbd92.table_1

895.79 kB
1,668 rows
46 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "name" VARCHAR,
  "website" VARCHAR,
  "description" VARCHAR,
  "geographical_extent" VARCHAR,
  "geographical_coverage_country" VARCHAR  -- Geographical Coverage (country),
  "nuts_2021" VARCHAR,
  "responsible_organisation" VARCHAR,
  "responsible_organisation_category" VARCHAR,
  "functions_of_government_cofog_level_i" VARCHAR  -- Functions Of Government (COFOG Level I),
  "functions_of_government_cofog_level_ii" VARCHAR  -- Functions Of Government (COFOG Level II),
  "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  -- Public (citizen)-centered Services,
  "increase_quality_of_psi_and_services" VARCHAR,
  "more_responsive_efficient_and_cost_effective_public_services" VARCHAR  -- More Responsive, Efficient, And Cost-effective Public Services,
  "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  -- Reduced Or Eliminated The Risk Of Corruption And Abuse Of The Law By Public Servants,
  "enabled_greater_fairness_honesty_equality" VARCHAR  -- Enabled Greater Fairness, Honesty, Equality,
  "open_government_capabilities" VARCHAR,
  "increased_transparency_of_public_sector_operations" VARCHAR,
  "increased_public_participation_in_government_actions_a_8f28b14f" VARCHAR  -- Increased Public Participation In Government Actions And Policy Making,
  "improved_public_control_and_influence_on_government_ac_12cbd097" VARCHAR  -- Improved Public Control And Influence On Government Actions And Policies,
  "source" VARCHAR,
  "ai_classification_i" VARCHAR  -- AI Classification (I),
  "ai_classification_subdomain_ii_main" VARCHAR  -- AI Classification Subdomain (II) (main),
  "ai_classification_subdomain_ii_other_i" VARCHAR  -- AI Classification Subdomain (II) (Other I),
  "ai_classification_subdomain_ii_other_ii" VARCHAR  -- AI Classification Subdomain (II) (Other II),
  "ai_classification_subdomain_ii_other_iii" VARCHAR  -- AI Classification Subdomain (II) (Other III),
  "ai_keywords" VARCHAR,
  "date_updated" TIMESTAMP
);

Table 2

@ecjrc.e8e7bddd_8510_4936_9fa6_7e1b399cbd92.table_2

4.73 kB
16,368 rows
2 columns

CREATE TABLE table_2 (
  "data_entry_field" VARCHAR,
  "description_variable_typology" VARCHAR  -- Description (variable Typology)
);

Table 3

@ecjrc.e8e7bddd_8510_4936_9fa6_7e1b399cbd92.table_3

25.13 kB
1,581 rows
20 columns

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 I),
  "functions_of_government_cofog_level_ii" VARCHAR  -- Functions Of Government (COFOG Level II),
  "responsible_organization_category" VARCHAR,
  "process_type" VARCHAR,
  "application_type" VARCHAR,
  "dimensions_of_value_twizeyimana_andersson_2019" VARCHAR  -- Dimensions Of Value Twizeyimana & Andersson, 2019,
  "benefit" VARCHAR,
  "status" VARCHAR,
  "crossborder" VARCHAR,
  "technology" VARCHAR,
  "crosssector" VARCHAR,
  "interaction" VARCHAR,
  "ai_classification_i" VARCHAR  -- AI Classification (I),
  "ai_classification_subdomain_ii" VARCHAR  -- AI Classification Subdomain (II),
  "ai_keywords_iii" VARCHAR  -- AI Keywords (III),
  "ai_keywords_iii_listed" VARCHAR  -- AI Keywords (III) Listed,
  "reasons_for_not_publishing" VARCHAR
);