home

Menu
  • GraphQL API

la-times

Table actions
  • GraphQL API for la-times

Custom SQL query

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

26,904 rows

cdcr-prison-totals

date, code, name, city, county, fips, zipcode, x, y, confirmed_cases, new_confirmed_cases, deaths, new_deaths

28,070 rows

cdcr-state-totals

date, confirmed_cases, new_confirmed_cases

802 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-adult-and-senior-care-totals

date, confirmed_cases, deaths, active_cases, source_url

295 rows

cdph-age

date, age, confirmed_cases_total, confirmed_cases_percent, deaths_total, deaths_percent

1,830 rows

cdph-county-cases-deaths

date, county, fips, population, confirmed_cases, reported_cases, probable_cases, reported_and_probable_cases, reported_deaths

48,662 rows

cdph-hospital-patient-county-totals

date, county, fips, positive_patients, suspected_patients, icu_positive_patients, icu_suspected_patients, icu_available_beds

43,789 rows

cdph-hospital-patient-state-totals

date, positive_patients, suspected_patients, icu_positive_patients, icu_suspected_patients, icu_available_beds

782 rows

cdph-hpi-zipcodes

id, hpi_quartile, county, fips, city

1,678 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

838 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

11,904 rows

cdph-regional-stay-home-metrics

date, region, icu_capacity_percent, stay_home_order

350 rows

cdph-reopening-metrics

date, county, fips, percapita_case_rate, adjusted_case_rate, positivity_rate, equity_index

15,718 rows

cdph-reopening-tiers

date, county, fips, tier

2,494 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

839 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

192,270 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

230,724 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

50,170 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

3,077 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

3,761 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

865 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

60,090 rows

cdph-variants

date, alpha, gamma, epsilon, delta, omicron, other

487 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

28,407 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

32,465 rows

latimes-agency-totals

agency, county, fips, date, confirmed_cases, deaths, did_not_update

33,021 rows

latimes-agency-websites

county, fips, agency, url

61 rows

latimes-beach-closures-area-list

county, fips, area, state_park, restriction

39 rows

latimes-beach-closures-county-list

county, fips, status, restriction

15 rows

latimes-county-recovery-estimates

date, county, fips, recoveries_estimated, active_cases

43,442 rows

latimes-county-totals

date, county, fips, confirmed_cases, deaths, new_confirmed_cases, new_deaths

31,362 rows

latimes-place-totals

id, name, date, county, fips, confirmed_cases, note, population

977,233 rows

latimes-project-roomkey-totals

date, people_housed, leased_rooms, rooms_ready_to_occupy, rooms_occupied, homeless_confirmed_cases

452 rows

latimes-state-recovery-estimates

date, recoveries_estimated, active_cases

749 rows

latimes-state-totals

date, confirmed_cases, deaths, new_confirmed_cases, new_deaths

586 rows

lausd-cases

school, status, staff_student, transmission, staff_student_rate, community_rate, lac_rate, community_schools, community, date, time, Unnamed: 0, color, 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

168,955 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 301.9 MB

Powered by Datasette · Queries took 46.644ms · About: simonw/covid-19-datasette