AndreaBozzo/ceres-open-data-index huggingface dataset:
CDPH-Wastewater Surveillance Data, California

The California Department of Public Health (CDPH) is coordinating with wastewater utilities, local health departments, academic researchers, and laboratories in California on wastewater surveillance for infectious disease pathogens of interest to public health (such as SARS-CoV-2, the virus causing COVID-19, influenza, respiratory syncytial virus (RSV), mpox, and norovirus). Data collected from this network of participants, called the California Surveillance of Wastewaters (Cal-SuWers) Network, are submitted to the U.S. Centers for Disease Control and Prevention (CDC) National Wastewater Surveillance System (NWSS). 

Collecting and analyzing wastewater samples for the presence of, and amount of (concentration), a specified pathogen target can help inform public health about circulation of that infectious disease within a community. Data from wastewater testing do not replace existing public health surveillance systems but complement them. While wastewater surveillance cannot determine the exact number of infected persons in the area being monitored, it can provide overall trends of pathogen concentration within that community. 

Please note that data included in the Cal-SuWers Network and available here originate from multiple programs and laboratories. Methodologies for producing wastewater data are not currently standardized, and analyses, comparisons, and aggregations should be done with caution. Wastewater is a complex environmental sample and inherent variability in measured concentrations is expected due to environmental variability, day-to-day differences in sewershed and population dynamics, differences in the amount of shedding between people and pathogens, and laboratory and sampling variability. Please see the CDPH Cal-SuWers, CDC NWSS, and CDC Public Health interpretation and Use of Wastewater Surveillance data webpages for more information.

Historical wastewater data can be found [here](https://data.ca.gov/dataset/covid-19-wastewater-surveillance-data-california).
​Profile of Enrolled Medi-Cal Fee-for-Service (FFS) Providers

The dataset provides basic information of the FFS providers enrolled in the Medi-Cal program as of June 29, 2026.  The data was retrieved from the Provider Master File (PMF), which has been used in the claims payment process and maintained by the Provider Enrollment Division (PED).  The Variables in the dataset include provider number, name, type, specialty, geographic information, etc.  This dataset does not include the Managed Care providers.
CA Urban Retail Water System Water Loss Annual Loss Audit Data

This dataset contains annual validated water loss audit reports submitted to the Department of Water Resources by California urban retail water suppliers, as required under Title 23, California Code of Regulations Section 638.5(c) (Regulation).  California Water Code Section 10608.12(af) specifies that urban retail water suppliers are those water suppliers directly providing potable municipal water to more than 3,000 service connections or that supply more than 3,000 acre-feet per year at retail for municipal purposes. The Regulation mandates that urban retail water suppliers with multiple separate potable water systems submit a separate audit for each system, regardless of system size. The dataset includes individual water loss audits for all potable water systems owned by urban retail water suppliers, including reports from water suppliers newly classified as urban retail water suppliers. While all submissions are available at the WUEdata.ca.gov portal, this dataset provides a cleaned version with only the latest submissions (older submissions that were corrected are not included).

Water system boundaries for the water system water loss data  in this dataset may be available in the Water Board's DDW California Drinking Water System Area Boundaries (SABL)  tool. The link to this tool can be found in Additional Resources as part of this dataset.

Water loss audits evaluate real water losses (leaks) and apparent water losses (e.g. data errors, water theft) occurring in a potable water distribution system. Estimating the scale and cost of these losses allows utilities to identify opportunities for saving water and recovering revenue. California water loss audit submissions were reviewed by validators and submitted to DWR starting in 2016. The reviews followed the validation methodology detailed in Water Research Foundation Project 4639: Level 1 Water Audit Validation. Level 1 water audit validation aims to:

* Identify and, where possible, correct inaccuracies in water audit data and application of methodology.
* Evaluate and communicate the uncertainty inherent in water audit data.
The data is provided "as is" (as submitted by the water systems).
More information on this dataset can be found in the file "Data Source and Notes" available at the on the home page of this dataset.
Dry Well Reporting System Data

In California, water systems serving one (1) to 15 households are regulated at the county level. Counties vary in their practices, but rarely do counties collect data regularly from these systems. Even where data is collected, it is entirely voluntary. A review of well permit information suggests there are over 1 million such water systems in California.

In early 2014, a cross-agency Work Group created an easily accessible reporting system to get more systematic data on which parts of the state had households at risk of water supply shortages. The initial motivation for local water supply systems to report shortage information was to obtain statewide drought assistance. The reporting system receives ongoing reports of shortages from local, state, federal and non-governmental organizations, and tracks their status to resolution. While several counties have developed their own tracking mechanisms, this data is manually entered into the reporting system.  

The cross-agency team, led by DWR, seeks to verify and update the data submitted. However, due to the volunteer nature of the reporting and limitations on reporting agencies, collected data are undoubtedly under-representative of all shortages to have occurred. In addition, reports are received from multiple sources and there are occasionally errors and omissions that can create duplicate entries, non-household water supply reporting, and under-reporting. For example, missing information or no data for a given county does not necessarily mean that there are no household water shortages in the county, rather only that none have been reported to the State.
Periodic Groundwater Level Measurements

The DWR Periodic Groundwater Levels dataset contains seasonal and long-term groundwater level measurements collected by the Department of Water Resources and cooperating agencies in groundwater basins statewide. It also includes data collected through the Sustainable Groundwater Management Act (SGMA) Portal’s Monitoring Network Module (MNM), and the CASGEM (California Statewide Groundwater Elevation Monitoring) Program. Most measurements are taken manually twice per year to capture the peak high and low values in groundwater elevations. However, the dataset also includes measurements recorded more frequently, monthly, weekly, or daily. This resource also included daily measurements from DWR's automated monitoring network of groundwater sites.  For DWRs holdings of groundwater level measurements recorded at more frequent intervals (e.g., hourly), please refer to DWR's “Continuous Groundwater Level Measurements” dataset.

For additional information regarding DWR groundwater levels data collection please visit DWR's Groundwater Management website (https://www.water.ca.gov/Programs/Groundwater-Management). The source data can also be accessed directly from two websites. The Water Data Library (http://wdl.water.ca.gov) provides anonymous access to this and other data sets. The CASGEM online system (https://www.casgem.water.ca.gov/OSS) provides authenticated access to only the the periodic groundwater measurements.

This dataset is maintained primarily in the DWR Enterprise Water Management database and contains information specific to the location of groundwater level monitoring wells and groundwater level measurements collected at these wells. The Stations resource identifies well location coordinates and other supplementary items about the well type. Measurements resources includes information about the time/date a measurement was collected, the entity collecting the measurement, a measurement indicating the depth to groundwater, and quality information about the measurement. The Well Perforations resources contains well construction information identifying the well's screened intervals (not available for all wells).
Drinking Water - SAFER Dashboard Failing and At-Risk Drinking Water Systems

The Division of Drinking Water (DDW) identifies Failing and At-Risk community water systems and K-12 non-transient, non-community schools. This information is displayed online in the Safe and Affordable Funding for Equity and Resilience (SAFER) Dashboard. The data utilized for this assessment is derived from multiple sources: self-reported from water systems, data generated by DDW staff, other California state agencies, and U.S. Census. The data sources, calculation methods, Failing and At-Risk criteria, etc. are fully documented in the annual Drinking Water Needs Assessment report which is published annually on the State Water Board’s website.
Groundwater Sustainability Plan Annual Report Data

The Groundwater Sustainability Plan (GSP) Annual Report (AR) datasets contain the following data submitted by Groundwater Sustainability Agencies (GSA) and Alternative Agencies as part of their GSP AR or Alternative to GSP AR: groundwater extraction, surface water supply, total water use, and change in storage volumes for a given water year. All data was originally submitted to the Department of Water Resources (DWR) through the Sustainable Groundwater Management Act (SGMA) Portal’s AR Modules (https://sgma.water.ca.gov/portal/gspar/submitted and https://sgma.water.ca.gov/portal/alternative/annualreport/submitted). Data records within each dataset correspond to either an entire basin or one of multiple GSP areas which collectively correspond to an entire basin.  
  
The GSP Regulations established the AR data requirements (23 CCR § 356.2) and tasked DWR with developing an online reporting system for GSAs and Alternative Agencies to electronically submit these data (23 CCR § 353.2). The data fields associated with these datasets were created by DWR to ensure GSAs and Alternative Agencies electronically submitted the required AR data to DWR’s online reporting system, the SGMA Portal (https://sgma.water.ca.gov/portal/). For additional information regarding the AR Modules and the AR submittal process, please view the DWR’s AR resources (https://sgma.water.ca.gov/portal/resources).
California Hospital Inpatient Mortality Rates and Quality Ratings

The dataset contains risk-adjusted mortality rates, quality ratings, and number of deaths and cases for 6 medical conditions treated (Acute Stroke, Acute Myocardial Infarction, Heart Failure, Gastrointestinal Hemorrhage, Hip Fracture and Pneumonia) and 3 procedures performed (Carotid Endarterectomy, Pancreatic Resection, and Percutaneous Coronary Intervention) in California hospitals. The 2024 IMIs were generated using AHRQ Version 2025, while previous years' IMIs were generated with older versions of AHRQ software. The differences in the statistical method employed and inclusion and exclusion criteria using different versions can lead to different results. Users should not compare trends of mortality rates over time. However, many hospitals showed consistent performance over years; “better” performing hospitals may perform better and “worse” performing hospitals may perform worse consistently across years. This dataset does not include conditions treated or procedures performed in outpatient settings. Please refer to statewide table for California overall rates: https://data.chhs.ca.gov/dataset/california-hospital-inpatient-mortality-rates-and-quality-ratings/resource/af88090e-b6f5-4f65-a7ea-d613e6569d96
Surface Water - Fecal Indicator Bacteria Monitoring Results

This dataset contains fecal indicator bacteria (FIB) monitoring results collected from surface waters across California. It includes results for _Escherichia coli_ (E. coli), enterococci, fecal coliforms, and total coliforms - key indicators used to assess microbial water quality and potential health risks associated with recreational water use.

The data has been cleaned and standardized to ensure consistency and usability. For each valid data point, the dataset also includes calculated 6-week and 30-day geometric means, which are commonly used to evaluate long-term water quality trends and compliance with bacteria water quality objectives. Some records are excluded from the final dataset during processing. These typically include duplicate or replicate results, records with missing or invalid result values, or any data that cannot be used to calculate a geometric mean. These records are saved to the "Excluded Records" data resource.

This dataset serves as the primary data source for the Water Boards My Water Quality Portal [Safe to Swim Map](https://mywaterquality.ca.gov/safe-to-swim/content/interactive_map/index.html), which provides the public with timely information about potential health risks associated with water contact recreation at monitored sites.

Data is sourced from the [California Environmental Data Exchange Network](https://ceden.waterboards.ca.gov) (CEDEN) database, BeachWatch database, and the Central Valley Water Board [Lower American River Recreational Water Quality Map](https://experience.arcgis.com/experience/47e27f245e044ac2a8e15083307e75f6/?draft=true&org=waterboards). There is some overlap with the [CEDEN Water Chemistry dataset](https://data.ca.gov/dataset/surface-water-chemistry-results). Both portal datasets draw from the same source, but the resources here are updated more frequently to support the Safe to Swim map.
California Public Schools 2025-26

<div style='text-align:Left;'><div><div><p style='margin:0 0 8 4;'><span>This layer serves as the authoritative geographic data source for California's TK/K-12 public school locations for the 2025-26 academic year. Schools are mapped as point locations and assigned coordinates based on the physical address of the school facility. The school records are enriched with additional demographic and performance variables from the California Department of Education's data collections. These data elements can be visualized and examined geographically to uncover patterns, solve problems and inform education policy decisions.</span></p><p style='margin:0 0 8 4;'><span>The schools in this file represent a subset of all records contained in the CDE's public school directory database. This subset is restricted to TK-12 public schools that were open in October 2025 to coincide with the official 2025-26 student enrollment counts collected on Fall Census Day in 2025 (first Wednesday in October). This layer excludes nonpublic schools and district office schools, so the total public school enrollment in this file will differ from the CDE's official statewide Fall 1 Census Day total enrollment.</span></p><p style='margin:0 0 8 4;'><span>CDE's official Fall 1 2025-26 public school enrollment (5,731,260) - nonpublic school enrollment (8,645) - district office school enrollment ( 5,917) = 5,716,698.</span></p><p style='margin:0 0 8 4;'><span>The CDE's </span><a target='_blank' href='https://www.cde.ca.gov/ds/dd/' rel='nofollow ugc noopener noreferrer'><span><u>California School Director</u></span></a><span>y provides school location other basic school characteristics found in the layer's attribute table. The school enrollment, demographic and program data are collected by the CDE through the California Longitudinal Achievement System (CALPADS) and can be accessed as publicly downloadable files from the </span><a target='_blank' href='https://www.cde.ca.gov/ds/' rel='nofollow ugc noopener noreferrer'><span><u>Data &amp; Statistics</u></span></a><span> web page on the CDE website.</span></p><p style='margin:0 0 8 4;'><span>Schools are assigned X, Y coordinates using a quality controlled geocoding and validation process to optimize positional accuracy. Most schools are mapped to the school structure or centroid of the school property parcel and are individually verified using aerial imagery or assessor's parcels databases. Schools are assigned various geographic area values based on their mapped locations including California County Superintendents Educational Services (CCSESA) district numbers, state and federal legislative district identifiers and National Center for Education Statistics (NCES) locale codes.</span></p></div></div></div>
Central Valley Water Board E. coli Monitoring Results

__Draft__ - E. coli monitoring results from the Central Valley Regional Water Quality Control Board. _E. coli_ is a type of bacteria used to indicate fecal pollution and the possible presence of pathogens in the water. The data is sourced from the Central Valley Regional Water Board - Lower American River Recreational Water Quality map (https://arcg.is/0ea0zq). All data are draft unless otherwise noted.
Suisun Marsh Salinity Control Gates Log

This log of operations includes: flashboard installation and removal dates, when tidal operations were started and stopped, and notes any technical issues.

This current document is an Excel file that contains the data as a Table. The Table can be sorted or filtered, and can be read by scripting languages such as Python or R. The date and time are stored together in the DATETIME field. The GATE 1, GATE 2, and GATE 3 fields state whether each gate is operating in Tidal Mode, set to Open, or set to Closed. The ACTION field states what operational change has occurred.

The timestamped records go back to May 5, 2018. If prior dates are needed, refer to the Historical (Archived) Suisun Marsh Salinity Control Gates Log PDF, which contains records going back to November 1, 1998. This document replaces the Archived version because the Archived version did not contain a timestamp for every record. For the records that did have a timestamp, the timestamps were placed in the REMARKS field. This issue, along with the document being a PDF file, created a problem for reading the data into time-series analysis software.
DSM2 Input 2026-07-09 historical update

Version "DSM2 Input 2026-07-09 historical update" is based on version "DSM2 Input 2026-04-16 historical update", and includes the following changes:

Added a channel to the upstream end of Whiskey Slough

Added an output location file output_new_location.inp, containing some really important output locations for Whiskey Slough.

Removed all data from hist.dss file.
CalEnviroScreen 5.0 Results

<p>The Office of Environmental Health Hazard Assessment (OEHHA) has developed CalEnviroScreen (CES) 5.0, the latest iteration of the California Communities Environmental Health Screening Tool. This version of CES incorporates the most recent publicly available data for all indicators and improves the way some indicators are calculated to better reflect environmental conditions or a population’s vulnerability to environmental pollutants. Two new indicators—Small Air Toxic Sites and Diabetes Prevalence—were added to help capture additional environmental burdens and disease that contribute to pollution burden and population sensitivity to pollution. The indicator of Small Air Toxic Sites accounts for the presence of oil and gas wells and other sites reporting air toxic releases that are not already captured in the existing indicator of toxic releases. A Diabetes Prevalence indicator reflects sensitivity to pollution as exposure to pollution leads to worsening health outcomes for individuals with diabetes.&nbsp;</p><p>This version of CES has been updated with additional information to incorporate pollution concerns in the California-Mexico border region, continuing the efforts to address Assembly Bill 1059 (Garcia, Statutes of 2015). For the latest iteration of CES, OEHHA partnered with community-based organizations (CBOs) to co-design key updates to the tool and to continue its commitment to meaningful community engagement. A <a href='https://oehha.ca.gov/sites/default/files/media/2026-01/calenviroscreen50codesignreportd12226.pdf' rel='nofollow ugc'>full report on the co-design process</a> and a <a href='https://oehha.ca.gov/sites/default/files/media/2026-06/calenviroscreen50factsheetf2026.pdf' rel='nofollow ugc'>short overview report</a> summarizing changes and updates for CES 5.0 are available on the <a href='https://oehha.ca.gov/calenviroscreen/report/calenviroscreen-50' rel='nofollow ugc'>CES 5.0 webpage</a> along with a <a href='https://oehha.ca.gov/sites/default/files/media/2026-06/calenviroscreen50reportf2026.pdf' rel='nofollow ugc'>technical report</a> describing the changes and updates in more detail.&nbsp;</p><p>To download data in different formats, visit the <a href='https://data.ca.gov/dataset/calenviroscreen-5-0' rel='nofollow ugc'>CA Open Data Portal</a>.</p>
Surface Water - Freshwater Harmful Algal Blooms

Freshwater harmful algal bloom (HAB) data from the Freshwater Harmful Algal Bloom (FHAB) data system. The FHAB data system is the California State Water Resources Control Board's data system for data and information voluntarily reported to the agency. Bloom reports are voluntary reports submitted by the public or organization to identify a POTENTIAL HAB for evaluation. Bloom Reports may or may not include a report that is confirmed to be a HAB, regardless, all bloom reports are published. Due to the voluntary basis of information and data included in the database, data and information may include: waterbody name and location, potential algal bloom location and observed characteristics, observed field observations and/or analytical sampling results, waterbody and/or land management, general information, recommended advisory status (if any), and updates regarding bloom status. Refer to Data Dictionary and Data Disclaimer for additional information about this dataset. Please visit the Water Boards FHABS web site for more information and data visualizations https://mywaterquality.ca.gov/habs/index.html.
DSM2 Input 2026-04-16 historical update

Version "DSM2 Input 2026-04-16 historical update" is based on version "DSM2 Input 2025-09-18 historical update" (which incorporates the
changes from the Monitoring Special Study version of DSM2), and includes the following changes:

The CHANNEL input section in the file channel_std_delta_grid.inp has been modified to work with DSM2 v8.5.0, by including the "dx" field, which specifies a
value of the parameter "delta x" separately for each channel. Previously, delta x values have been specified in a file called variable_dx.csv.
This file has been removed.

The location of the Middle River Barrier has been corrected by adding channel 901 to replace a portion of channel 134. The Middle River barrier
has been placed on the upstream side of the node for consistency with the configurations of other barriers.

Dispersion factors have been adjusted to improve EC results.