la-times
Tables
cdc-vaccination-state-totals
date, state, population, doses_distributed, doses_administered, doses_administered_percent, administered_dose1, administered_dose1_percent, administered_dose2, administered_dose2_percent
29,979 rows
cdcr-prison-totals
date, code, name, city, county, fips, zipcode, x, y, confirmed_cases, new_confirmed_cases, deaths, new_deaths
35,910 rows
cdph-adult-and-senior-care-facilities
date, name, county, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, fips, staff_confirmed_cases_note, patients_confirmed_cases_note, staff_deaths_note, patients_deaths_note
116,613 rows
cdph-age
date, age, confirmed_cases_total, confirmed_cases_percent, deaths_total, deaths_percent
1,930 rows
cdph-county-cases-deaths
date, county, fips, population, confirmed_cases, reported_cases, probable_cases, reported_and_probable_cases, reported_deaths
61,538 rows
cdph-hospital-patient-county-totals
date, county, fips, positive_patients, suspected_patients, icu_positive_patients, icu_suspected_patients, icu_available_beds
56,333 rows
cdph-hospital-patient-state-totals
date, positive_patients, suspected_patients, icu_positive_patients, icu_suspected_patients, icu_available_beds
1,006 rows
cdph-nursing-home-county-totals
date, county, fips, minimum_staff_confirmed_cases, minimum_patients_confirmed_cases, minimum_staff_deaths, minimum_patients_deaths
31,733 rows
cdph-population-race-ethnicity
county, fips, aian, asian, black, latino, multirace, nhpi, other, unknown, white
59 rows
cdph-positive-test-rate
date, confirmed_cases, total_tests, new_confirmed_cases, new_positive_tests, new_tests, new_confirmed_cases_seven_day_total, new_tests_seven_day_total, positive_test_rate_seven_day_percent
1,060 rows
cdph-press-releases
date, confirmed_cases, deaths, travel, person_to_person, community_spread, under_investigation, other_causes, self_monitoring, age_0_to_17, age_18_to_49, age_50_to_64, age_65_and_up, age_18_to_64, age_unknown, gender_male, gender_female, gender_unknown, total_tests, received_tests, pending_tests, confirmed_hospitalizations, confirmed_icu, suspected_hospitalizations, suspected_icu, healthcare_worker_infections, healthcare_worker_deaths, vaccine_doses_administered, vaccine_doses_distributed, source_url
559 rows
cdph-race-ethnicity
date, race, age, confirmed_cases_total, confirmed_cases_percent, deaths_total, deaths_percent, population_percent
12,960 rows
cdph-reopening-metrics
date, county, fips, percapita_case_rate, adjusted_case_rate, positivity_rate, equity_index
15,718 rows
cdph-skilled-nursing-facilities
date, id, slug, name, county, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, fips, staff_confirmed_cases_note, patients_confirmed_cases_note, staff_deaths_note, patients_deaths_note
776,631 rows
cdph-skilled-nursing-totals
date, staff_active_cases, patients_active_cases, staff_confirmed_cases, patients_confirmed_cases, staff_deaths, patients_deaths, staff_deaths_note
591 rows
cdph-state-cases-deaths
date, confirmed_cases, reported_cases, probable_cases, reported_and_probable_cases, reported_deaths
1,061 rows
cdph-vaccination-county-by-age
county, fips, date, age_group, partially_vaccinated, at_least_one_dose, fully_vaccinated, population_total, population_12_and_up, partially_vaccinated_percent, partially_vaccinated_percent_12_and_up, at_least_one_dose_percent, at_least_one_dose_percent_12_and_up, fully_vaccinated_percent, fully_vaccinated_percent_12_and_up
348 rows
cdph-vaccination-county-by-race-ethnicity
race_ethnicity, county, fips, date, partially_vaccinated, at_least_one_dose, fully_vaccinated, population_total, population_12_and_up, partially_vaccinated_percent, partially_vaccinated_percent_12_and_up, at_least_one_dose_percent, at_least_one_dose_percent_12_and_up, fully_vaccinated_percent, fully_vaccinated_percent_12_and_up, race_label
348 rows
cdph-vaccination-county-totals
date, county, fips, population, doses_administered, new_doses_administered, pfizer_doses, new_pfizer_doses, moderna_doses, new_moderna_doses, jj_doses, new_jj_doses, partially_vaccinated, new_partially_vaccinated, at_least_one_dose, new_at_least_one_dose, fully_vaccinated, new_fully_vaccinated, partially_vaccinated_percent, at_least_one_dose_percent, fully_vaccinated_percent
63,104 rows
cdph-vaccination-state-by-age
date, age_group, partially_vaccinated, at_least_one_dose, fully_vaccinated, population_total, population_12_and_up, partially_vaccinated_percent, partially_vaccinated_percent_12_and_up, at_least_one_dose_percent, at_least_one_dose_percent_12_and_up, fully_vaccinated_percent, fully_vaccinated_percent_12_and_up
6 rows
cdph-vaccination-state-by-race-ethnicity
race_ethnicity, date, partially_vaccinated, at_least_one_dose, fully_vaccinated, population_total, population_12_and_up, partially_vaccinated_percent, partially_vaccinated_percent_12_and_up, at_least_one_dose_percent, at_least_one_dose_percent_12_and_up, fully_vaccinated_percent, fully_vaccinated_percent_12_and_up, race_label
6 rows
cdph-vaccination-state-totals
date, doses_administered, new_doses_administered, pfizer_doses, new_pfizer_doses, moderna_doses, new_moderna_doses, jj_doses, new_jj_doses, partially_vaccinated, new_partially_vaccinated, at_least_one_dose, new_at_least_one_dose, fully_vaccinated, new_fully_vaccinated, partially_vaccinated_percent, at_least_one_dose_percent, fully_vaccinated_percent
1,088 rows
cdph-vaccination-zipcode-totals
date, id, county, fips, population, partially_vaccinated, at_least_one_dose, fully_vaccinated, partially_vaccinated_percent, at_least_one_dose_percent, fully_vaccinated_percent
109,276 rows
charter-schools-reopening
cdscode, county, district, school, enr_total, elem_enr, middle_enr, high_enr, elem_in_school, middle_in_school, high_in_school, total_in_school, reopening_plan, operational_status_elem, operational_status_middle, operational_status_high, is_reopening, is_reopening_elem, elem_reopening_date, is_reopening_middle, middle_reopening_date, is_reopening_high, high_reopening_date, near_term_opening_date, update_date
1,286 rows
hhs-hospital-icu-totals
hospital, ccn, week, county, fips, region, covid_icu_patients_total, available_adult_icu_beds_total, occupied_adult_icu_beds_total, staffed_adult_icu_beds_total, occupied_adult_icu_beds_percent, icu_patients_with_covid_percent
38,919 rows
hhs-hospital-patient-totals
hospital, ccn, week, county, fips, region, adult_covid_patients_total, pediatric_covid_patients_total, covid_patients_total, occupied_beds_total, occupied_beds_percent, patients_with_covid_percent
48,633 rows
latimes-agency-totals
agency, county, fips, date, confirmed_cases, deaths, did_not_update
33,021 rows
latimes-county-recovery-estimates
date, county, fips, recoveries_estimated, active_cases
56,318 rows
latimes-county-totals
date, county, fips, confirmed_cases, deaths, new_confirmed_cases, new_deaths
31,362 rows
latimes-project-roomkey-totals
date, people_housed, leased_rooms, rooms_ready_to_occupy, rooms_occupied, homeless_confirmed_cases
452 rows
lausd-cases
Unnamed: 0, school, status, color, staff_student, transmission, testing_period, tests, pos, pos_rate, change, cos, cos_tests, cos_pos, cos_pos_rate, cos_change, lausd_tests, lausd_pos, lausd_pos_rate, lausd_change, date, time, staff_student_rate, community_rate, lac_rate, community_schools, community
224,963 rows
school-districts-reopening
county, district, enr_total, elem_enr, middle_enr, high_enr, elem_in_school, middle_in_school, high_in_school, total_in_school, reopening_plan, operational_status_elem, operational_status_middle, operational_status_high, is_reopening, is_reopening_elem, elem_reopening_date, is_reopening_middle, middle_reopening_date, is_reopening_high, high_reopening_date, near_term_opening_date, update_date
969 rows
Download SQLite DB: la-times.db 307.1 MB