la_times_cdph_hospital_patient_county_totals
Data license: Reusing the data · Data source: California Department of Public Health via The Los Angeles Times · About: Data dictionary for la_times_cdph_hospital_patient_county_totals
56,333 rows sorted by fips descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips ▲ | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
56 | 56 | 2022-12-29 | Yuba | 115 | 15 | 1 | 1 | 0 | 5 |
112 | 112 | 2022-12-28 | Yuba | 115 | 15 | 3 | 1 | 0 | 5 |
168 | 168 | 2022-12-27 | Yuba | 115 | 18 | 2 | 0 | 0 | 7 |
224 | 224 | 2022-12-26 | Yuba | 115 | 14 | 2 | 0 | 0 | 10 |
280 | 280 | 2022-12-25 | Yuba | 115 | 15 | 2 | 0 | 0 | 11 |
336 | 336 | 2022-12-24 | Yuba | 115 | 12 | 0 | 0 | 0 | 6 |
392 | 392 | 2022-12-23 | Yuba | 115 | 8 | 0 | 0 | 0 | 6 |
448 | 448 | 2022-12-22 | Yuba | 115 | 9 | 0 | 0 | 0 | 11 |
504 | 504 | 2022-12-21 | Yuba | 115 | 11 | 0 | 0 | 0 | 10 |
560 | 560 | 2022-12-20 | Yuba | 115 | 8 | 0 | 0 | 0 | 7 |
616 | 616 | 2022-12-19 | Yuba | 115 | 7 | 0 | 0 | 0 | 8 |
672 | 672 | 2022-12-18 | Yuba | 115 | 8 | 0 | 0 | 0 | 8 |
728 | 728 | 2022-12-17 | Yuba | 115 | 9 | 0 | 0 | 0 | 1 |
784 | 784 | 2022-12-16 | Yuba | 115 | 8 | 0 | 0 | 0 | 0 |
840 | 840 | 2022-12-15 | Yuba | 115 | 7 | 0 | 0 | 0 | 8 |
896 | 896 | 2022-12-14 | Yuba | 115 | 9 | 0 | 0 | 0 | 7 |
952 | 952 | 2022-12-13 | Yuba | 115 | 7 | 0 | 0 | 0 | 9 |
1008 | 1008 | 2022-12-12 | Yuba | 115 | 13 | 0 | 0 | 0 | 5 |
1064 | 1064 | 2022-12-11 | Yuba | 115 | 12 | 0 | 0 | 0 | 7 |
1120 | 1120 | 2022-12-10 | Yuba | 115 | 12 | 0 | 1 | 0 | 9 |
1176 | 1176 | 2022-12-09 | Yuba | 115 | 10 | 0 | 1 | 0 | 6 |
1232 | 1232 | 2022-12-08 | Yuba | 115 | 10 | 1 | 0 | 0 | 5 |
1288 | 1288 | 2022-12-07 | Yuba | 115 | 12 | 0 | 0 | 0 | 9 |
1344 | 1344 | 2022-12-06 | Yuba | 115 | 13 | 1 | 0 | 0 | 9 |
1400 | 1400 | 2022-12-05 | Yuba | 115 | 12 | 1 | 1 | 0 | 8 |
1456 | 1456 | 2022-12-04 | Yuba | 115 | 13 | 1 | 0 | 0 | 9 |
1512 | 1512 | 2022-12-03 | Yuba | 115 | 14 | 1 | 0 | 0 | 6 |
1568 | 1568 | 2022-12-02 | Yuba | 115 | 12 | 0 | 0 | 0 | 6 |
1624 | 1624 | 2022-12-01 | Yuba | 115 | 11 | 0 | 1 | 0 | 2 |
1680 | 1680 | 2022-11-30 | Yuba | 115 | 10 | 0 | 1 | 0 | 4 |
1736 | 1736 | 2022-11-29 | Yuba | 115 | 9 | 0 | 0 | 0 | 5 |
1792 | 1792 | 2022-11-28 | Yuba | 115 | 12 | 0 | 0 | 0 | 4 |
1848 | 1848 | 2022-11-27 | Yuba | 115 | 9 | 0 | 0 | 0 | 6 |
1904 | 1904 | 2022-11-26 | Yuba | 115 | 8 | 0 | 0 | 0 | 6 |
1960 | 1960 | 2022-11-25 | Yuba | 115 | 6 | 0 | 0 | 0 | 5 |
2016 | 2016 | 2022-11-24 | Yuba | 115 | 6 | 0 | 0 | 0 | 6 |
2072 | 2072 | 2022-11-23 | Yuba | 115 | 4 | 0 | 0 | 0 | 7 |
2128 | 2128 | 2022-11-22 | Yuba | 115 | 4 | 0 | 1 | 0 | 6 |
2184 | 2184 | 2022-11-21 | Yuba | 115 | 11 | 0 | 1 | 0 | 9 |
2240 | 2240 | 2022-11-20 | Yuba | 115 | 8 | 0 | 1 | 0 | 9 |
2296 | 2296 | 2022-11-19 | Yuba | 115 | 6 | 0 | 0 | 0 | 8 |
2352 | 2352 | 2022-11-18 | Yuba | 115 | 5 | 0 | 1 | 0 | 13 |
2408 | 2408 | 2022-11-17 | Yuba | 115 | 3 | 0 | 1 | 0 | 9 |
2464 | 2464 | 2022-11-16 | Yuba | 115 | 6 | 0 | 1 | 0 | 9 |
2520 | 2520 | 2022-11-15 | Yuba | 115 | 5 | 0 | 1 | 0 | 9 |
2576 | 2576 | 2022-11-14 | Yuba | 115 | 7 | 0 | 1 | 0 | 9 |
2632 | 2632 | 2022-11-13 | Yuba | 115 | 6 | 0 | 1 | 0 | 9 |
2688 | 2688 | 2022-11-12 | Yuba | 115 | 5 | 0 | 1 | 0 | 7 |
2744 | 2744 | 2022-11-11 | Yuba | 115 | 5 | 0 | 1 | 0 | 8 |
2800 | 2800 | 2022-11-10 | Yuba | 115 | 5 | 0 | 1 | 0 | 9 |
2856 | 2856 | 2022-11-09 | Yuba | 115 | 5 | 0 | 1 | 0 | 10 |
2912 | 2912 | 2022-11-08 | Yuba | 115 | 6 | 0 | 2 | 0 | 10 |
2968 | 2968 | 2022-11-07 | Yuba | 115 | 5 | 0 | 2 | 0 | 7 |
3024 | 3024 | 2022-11-06 | Yuba | 115 | 4 | 0 | 0 | 0 | 8 |
3080 | 3080 | 2022-11-05 | Yuba | 115 | 5 | 0 | 1 | 0 | 7 |
3136 | 3136 | 2022-11-04 | Yuba | 115 | 5 | 0 | 1 | 0 | 6 |
3192 | 3192 | 2022-11-03 | Yuba | 115 | 5 | 0 | 0 | 0 | 6 |
3248 | 3248 | 2022-11-02 | Yuba | 115 | 0 | 0 | 0 | 0 | 5 |
3304 | 3304 | 2022-11-01 | Yuba | 115 | 1 | 0 | 0 | 0 | 5 |
3360 | 3360 | 2022-10-31 | Yuba | 115 | 3 | 0 | 0 | 0 | 7 |
3416 | 3416 | 2022-10-30 | Yuba | 115 | 2 | 0 | 0 | 0 | 9 |
3472 | 3472 | 2022-10-29 | Yuba | 115 | 3 | 0 | 0 | 0 | 7 |
3528 | 3528 | 2022-10-28 | Yuba | 115 | 5 | 0 | 1 | 0 | 7 |
3584 | 3584 | 2022-10-27 | Yuba | 115 | 6 | 0 | 1 | 0 | 6 |
3640 | 3640 | 2022-10-26 | Yuba | 115 | 8 | 0 | 1 | 0 | 7 |
3696 | 3696 | 2022-10-25 | Yuba | 115 | 6 | 0 | 1 | 0 | 7 |
3752 | 3752 | 2022-10-24 | Yuba | 115 | 6 | 0 | 1 | 0 | 8 |
3808 | 3808 | 2022-10-23 | Yuba | 115 | 7 | 0 | 1 | 0 | 8 |
3864 | 3864 | 2022-10-22 | Yuba | 115 | 4 | 0 | 1 | 0 | 8 |
3920 | 3920 | 2022-10-21 | Yuba | 115 | 3 | 0 | 1 | 0 | 4 |
3976 | 3976 | 2022-10-20 | Yuba | 115 | 4 | 0 | 0 | 0 | 8 |
4032 | 4032 | 2022-10-19 | Yuba | 115 | 2 | 0 | 0 | 0 | 8 |
4088 | 4088 | 2022-10-18 | Yuba | 115 | 1 | 0 | 0 | 0 | 11 |
4144 | 4144 | 2022-10-17 | Yuba | 115 | 1 | 1 | 0 | 0 | 15 |
4200 | 4200 | 2022-10-16 | Yuba | 115 | 1 | 1 | 0 | 0 | 14 |
4256 | 4256 | 2022-10-15 | Yuba | 115 | 1 | 1 | 0 | 0 | 13 |
4312 | 4312 | 2022-10-14 | Yuba | 115 | 2 | 1 | 0 | 0 | 14 |
4368 | 4368 | 2022-10-13 | Yuba | 115 | 1 | 1 | 0 | 1 | 10 |
4424 | 4424 | 2022-10-12 | Yuba | 115 | 2 | 1 | 0 | 0 | 8 |
4480 | 4480 | 2022-10-11 | Yuba | 115 | 2 | 0 | 0 | 0 | 8 |
4536 | 4536 | 2022-10-10 | Yuba | 115 | 0 | 0 | 0 | 0 | 7 |
4592 | 4592 | 2022-10-09 | Yuba | 115 | 1 | 0 | 1 | 0 | 7 |
4648 | 4648 | 2022-10-08 | Yuba | 115 | 2 | 0 | 1 | 0 | 7 |
4704 | 4704 | 2022-10-07 | Yuba | 115 | 5 | 0 | 2 | 0 | 10 |
4760 | 4760 | 2022-10-06 | Yuba | 115 | 4 | 0 | 2 | 0 | 15 |
4816 | 4816 | 2022-10-05 | Yuba | 115 | 5 | 0 | 2 | 0 | 11 |
4872 | 4872 | 2022-10-04 | Yuba | 115 | 4 | 0 | 2 | 0 | 11 |
4928 | 4928 | 2022-10-03 | Yuba | 115 | 5 | 0 | 1 | 0 | 9 |
4984 | 4984 | 2022-10-02 | Yuba | 115 | 6 | 0 | 0 | 0 | 11 |
5040 | 5040 | 2022-10-01 | Yuba | 115 | 5 | 0 | 0 | 0 | 12 |
5096 | 5096 | 2022-09-30 | Yuba | 115 | 6 | 0 | 0 | 0 | 4 |
5152 | 5152 | 2022-09-29 | Yuba | 115 | 7 | 0 | 0 | 0 | 5 |
5208 | 5208 | 2022-09-28 | Yuba | 115 | 9 | 0 | 0 | 0 | 5 |
5264 | 5264 | 2022-09-27 | Yuba | 115 | 7 | 0 | 1 | 0 | 8 |
5320 | 5320 | 2022-09-26 | Yuba | 115 | 7 | 0 | 1 | 0 | 12 |
5376 | 5376 | 2022-09-25 | Yuba | 115 | 6 | 0 | 0 | 0 | 11 |
5432 | 5432 | 2022-09-24 | Yuba | 115 | 5 | 0 | 0 | 0 | 12 |
5488 | 5488 | 2022-09-23 | Yuba | 115 | 3 | 0 | 0 | 0 | 9 |
5544 | 5544 | 2022-09-22 | Yuba | 115 | 5 | 0 | 0 | 0 | 12 |
5600 | 5600 | 2022-09-21 | Yuba | 115 | 4 | 0 | 0 | 0 | 13 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [la_times_cdph_hospital_patient_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [positive_patients] INTEGER, [suspected_patients] INTEGER, [icu_positive_patients] INTEGER, [icu_suspected_patients] INTEGER, [icu_available_beds] INTEGER );