About this Dataset

Infectious Diseases By Disease, County, Year, And Sex

These data contain case counts and rates for selected communicable diseases—listed in the data dictionary—that met the surveillance case definition for that disease and was reported for California residents, by disease, county, year, and sex. The data represent cases with an estimated illness onset date from 2001 through the last year indicated from California Confidential Morbidity Reports and/or Laboratory Reports. Data captured represent reportable case counts as of the date indicated in the “Temporal Coverage” section below, so the data presented may differ from previous publications due to delays inherent to case reporting, laboratory reporting, and epidemiologic investigation.
Organization: State of California
Last updated: 2025-07-23T16:28:30.416317
Tags: acute-infection, amebiasis, anaplasmosis, anthrax, babesiosis, botulism, brucellosis, california-department-of-public-health, campylobacteriosis, case, chikungunya-virus-infection, cholera, cid, ciguatera-fish-poisoning, cjd, cocci, coccidioidomycosis, creutzfeldt-jakob-disease-and-other-transmissible-spongiform-encephalopathies, cryptosporidiosis, cyclosporiasis, cysticercosis-or-taeniasis, dengue, disease-surveillance, domoic-acid-poisoning, e-coli-o157, e-coli-other-stec-non-o157, ehrlichiosis, flavivirus-infection-of-undetermined-species, foodborne, foodborne-botulism, giardiasis, hansens-disease, hantavirus-infection, hemolytic-uremic-syndrome, hepatitis-e, human, hus, idb, infectious-diseases, legionellosis, leprosy, leptospirosis, listeriosis, lyme-disease, malaria, other, paralytic-shellfish-poisoning, paratyphoid-fever, plague, psittacosis, q-fever, rabies, relapsing-fever, salmonellosis, scombroid-fish-poisoning, shiga-toxin-positive-feces, shiga-toxin-producing-e-coli, shigellosis, spotted-fever-rickettsiosis, sss, stec, streptococcal-infection-cases-in-food-and-dairy-workers, surveillance-and-statistics-section, trichinosis, tularemia, typhoid-fever, typhus-fever, valley-fever, vibrio-infection-non-cholera, viral-hemorrhagic-fevers, wound, wound-botulism, yellow-fever, yersiniosis, zika-virus-infection

Tables

Infectious Diseases By County, Year And Sex

@usgov.ca_gov_infectious_diseases_by_disease_county_year_and_sex_6e856.infectious_diseases_by_county_year_and_sex

1.03 MB
199125 rows
9 columns


CREATE TABLE infectious_diseases_by_county_year_and_sex (
  "disease" VARCHAR,
  "county" VARCHAR,
  "year" BIGINT,
  "sex" VARCHAR,
  "cases" DOUBLE,
  "population" BIGINT,
  "rate" VARCHAR,
  "lower_95_ci" DOUBLE,
  "upper_95_ci" DOUBLE
);