cdph-hospital-patient-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date for which hospital data were reported in ISO 8601 format.
- county
- The name of the county.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- positive_patients
- The current number confirmed coronavirus cases in hospitals on this date.
- suspected_patients
- The current number suspected coronavirus cases in hospitals on this date.
- icu_positive_patients
- The current number confirmed coronavirus cases in intensive-care units on this date.
- icu_suspected_patients
- The current number suspected coronavirus cases in intensive-care units on this date.
- icu_available_beds
- The current number open and avilable intensive-care beds on this date.
56 rows where "date" is on date 2020-04-29
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: suspected_patients, icu_positive_patients, icu_available_beds
Link | rowid ▼ | date | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
54545 | 54545 | 2020-04-29 | Alameda | 1 | 76 | 63 | 33 | 13 | 168 |
54546 | 54546 | 2020-04-29 | Amador | 5 | 0 | 0 | 0 | 0 | 4 |
54547 | 54547 | 2020-04-29 | Butte | 7 | 0 | 2 | 0 | 1 | 20 |
54548 | 54548 | 2020-04-29 | Calaveras | 9 | 0 | 0 | 0 | 0 | 12 |
54549 | 54549 | 2020-04-29 | Colusa | 11 | 1 | 0 | 1 | 0 | 5 |
54550 | 54550 | 2020-04-29 | Contra Costa | 13 | 24 | 50 | 9 | 14 | 131 |
54551 | 54551 | 2020-04-29 | Del Norte | 15 | 0 | 3 | 0 | 1 | 2 |
54552 | 54552 | 2020-04-29 | El Dorado | 17 | 0 | 4 | 0 | 2 | 6 |
54553 | 54553 | 2020-04-29 | Fresno | 19 | 38 | 48 | 16 | 8 | 91 |
54554 | 54554 | 2020-04-29 | Glenn | 21 | 0 | 0 | 0 | 0 | |
54555 | 54555 | 2020-04-29 | Humboldt | 23 | 1 | 5 | 0 | 3 | 7 |
54556 | 54556 | 2020-04-29 | Imperial | 25 | 29 | 5 | 13 | 0 | 4 |
54557 | 54557 | 2020-04-29 | Inyo | 27 | 0 | 0 | 0 | 0 | 6 |
54558 | 54558 | 2020-04-29 | Kern | 29 | 36 | 13 | 23 | 3 | 59 |
54559 | 54559 | 2020-04-29 | Kings | 31 | 9 | 2 | 2 | 0 | 8 |
54560 | 54560 | 2020-04-29 | Lake | 33 | 0 | 2 | 0 | 1 | 1 |
54561 | 54561 | 2020-04-29 | Lassen | 35 | 0 | 0 | 0 | 0 | |
54562 | 54562 | 2020-04-29 | Los Angeles | 37 | 1959 | 591 | 602 | 97 | 1167 |
54563 | 54563 | 2020-04-29 | Madera | 39 | 0 | 1 | 0 | 0 | 22 |
54564 | 54564 | 2020-04-29 | Marin | 41 | 0 | 6 | 0 | 1 | 22 |
54565 | 54565 | 2020-04-29 | Mariposa | 43 | 0 | 1 | 0 | 0 | |
54566 | 54566 | 2020-04-29 | Mendocino | 45 | 0 | 0 | 0 | 0 | 6 |
54567 | 54567 | 2020-04-29 | Merced | 47 | 2 | 7 | 1 | 1 | 5 |
54568 | 54568 | 2020-04-29 | Modoc | 49 | 0 | 0 | 0 | 0 | |
54569 | 54569 | 2020-04-29 | Mono | 51 | 0 | 0 | 0 | 0 | 1 |
54570 | 54570 | 2020-04-29 | Monterey | 53 | 4 | 3 | 3 | 0 | 106 |
54571 | 54571 | 2020-04-29 | Napa | 55 | 1 | 0 | 0 | 0 | 6 |
54572 | 54572 | 2020-04-29 | Nevada | 57 | 1 | 2 | 1 | 1 | 4 |
54573 | 54573 | 2020-04-29 | Orange | 59 | 211 | 91 | 76 | 16 | 373 |
54574 | 54574 | 2020-04-29 | Placer | 61 | 5 | 28 | 1 | 3 | 80 |
54575 | 54575 | 2020-04-29 | Plumas | 63 | 0 | 0 | 0 | 0 | |
54576 | 54576 | 2020-04-29 | Riverside | 65 | 212 | 124 | 78 | 32 | 201 |
54577 | 54577 | 2020-04-29 | Sacramento | 67 | 42 | 36 | 17 | 5 | 137 |
54578 | 54578 | 2020-04-29 | San Benito | 69 | 0 | 0 | 0 | 0 | 1 |
54579 | 54579 | 2020-04-29 | San Bernardino | 71 | 156 | 124 | 56 | 23 | 162 |
54580 | 54580 | 2020-04-29 | San Diego | 73 | 282 | 73 | 119 | 17 | 363 |
54581 | 54581 | 2020-04-29 | San Francisco | 75 | 80 | 24 | 26 | 6 | 107 |
54582 | 54582 | 2020-04-29 | San Joaquin | 77 | 21 | 20 | 9 | 7 | 30 |
54583 | 54583 | 2020-04-29 | San Luis Obispo | 79 | 3 | 2 | 3 | 0 | 34 |
54584 | 54584 | 2020-04-29 | San Mateo | 81 | 51 | 19 | 16 | 1 | 52 |
54585 | 54585 | 2020-04-29 | Santa Barbara | 83 | 28 | 14 | 12 | 2 | 85 |
54586 | 54586 | 2020-04-29 | Santa Clara | 85 | 110 | 34 | 46 | 2 | 198 |
54587 | 54587 | 2020-04-29 | Santa Cruz | 87 | 2 | 0 | 1 | 0 | 8 |
54588 | 54588 | 2020-04-29 | Shasta | 89 | 2 | 0 | 2 | 0 | 5 |
54589 | 54589 | 2020-04-29 | Siskiyou | 93 | 0 | 3 | 0 | 1 | 2 |
54590 | 54590 | 2020-04-29 | Solano | 95 | 10 | 18 | 5 | 5 | 56 |
54591 | 54591 | 2020-04-29 | Sonoma | 97 | 5 | 14 | 2 | 2 | 51 |
54592 | 54592 | 2020-04-29 | Stanislaus | 99 | 35 | 26 | 4 | 5 | 97 |
54593 | 54593 | 2020-04-29 | Sutter | 101 | 0 | 0 | 0 | 0 | |
54594 | 54594 | 2020-04-29 | Tehama | 103 | 0 | 0 | 0 | 0 | 5 |
54595 | 54595 | 2020-04-29 | Trinity | 105 | 0 | 0 | 0 | 0 | |
54596 | 54596 | 2020-04-29 | Tulare | 107 | 30 | 0 | 5 | 0 | 30 |
54597 | 54597 | 2020-04-29 | Tuolumne | 109 | 0 | 0 | 0 | 0 | 0 |
54598 | 54598 | 2020-04-29 | Ventura | 111 | 31 | 26 | 10 | 7 | 50 |
54599 | 54599 | 2020-04-29 | Yolo | 113 | 0 | 0 | 0 | 1 | 10 |
54600 | 54600 | 2020-04-29 | Yuba | 115 | 0 | 0 | 0 | 0 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "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 );