Dataset relating to the study "Automating the Identification of High-Value Datasets in Open Government Data Portals: A US Municipalities Case Study"

Dataset: U.S. Municipal Open Government Data Portals Overview This dataset describes structural, organizational, and descriptive characteristics of Open Government Data (OGD) portals of major U.S. municipalities. It supports the analysis presented in the paper: Quarati, A., Nikiforova, A.Automating the Identification of High‑Value Datasets in Open Government Data Portals: A U.S. Municipalities Case StudyTelematics and Informatics 107, 102415 https://doi.org/10.1016/j.tele.2026.102415 Files included USCitiesPortals.xlsx Tabular metadata describing U.S. municipal Open Government Data (OGD) portals for incorporated places with an estimated resident population of 50,000 or more as of July 1, 2022. Each row corresponds to one city and includes: population estimates (2020–2022) portal URLs number of available datasets OGD platform (e.g., Socrata, CKAN, ArcGIS) categorization mechanisms qualitative notes on portal structure Key columns Geographic Area – City or municipality Number of datasets (May 2024) – Approximate dataset count Platform / NEW Platform – OGD software platform Categorization / Categories – Portal organization logic Notes – Manual observations and anomalies portals.json Machine‑readable description of portal categorization schemes. Each object represents one city portal with: portal URL geographic coordinates dataset categorization type platform used list of dataset categories or theme Structure { "url": "Portal URL", "city": "City name", "coord": "Geographic coordinates", "categorization": "Categories | Groups | Tags | Themes", "platform": "Socrata | CKAN | ArcGis | Junar | Opendatasoft | -", "categories": ["Category 1", "Category 2", "..."] } Empty category arrays denote portals without explicit or accessible classifications. Relationship between files Both files describe the same set of municipal portals The Excel file provides aggregated and qualitative metadata The JSON file provides structured categorical information City name serves as the conceptual linking key Data collection Data were collected manually and semi‑automatically from official municipal OGD portals on May 2024. The dataset contains no personal or sensitive information. License Creative Commons Attribution 4.0 International (CC BY 4.0) Contact Alfonso Quarati (Genoa, Italy)