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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | positive_patients | suspected_patients | icu_positive_patients | icu_suspected_patients | icu_available_beds |
---|---|---|---|---|---|---|---|---|---|
42393 | 42393 | 2020-12-02 | Alameda | 1 | 195 | 43 | 58 | 5 | 85 |
42394 | 42394 | 2020-12-02 | Amador | 5 | 4 | 0 | 2 | 0 | 3 |
42395 | 42395 | 2020-12-02 | Butte | 7 | 44 | 1 | 6 | 1 | 12 |
42396 | 42396 | 2020-12-02 | Calaveras | 9 | 5 | 0 | 3 | 0 | 5 |
42397 | 42397 | 2020-12-02 | Colusa | 11 | 11 | 0 | 0 | 0 | 0 |
42398 | 42398 | 2020-12-02 | Contra Costa | 13 | 116 | 15 | 27 | 1 | 55 |
42399 | 42399 | 2020-12-02 | Del Norte | 15 | 0 | 0 | 0 | 0 | 3 |
42400 | 42400 | 2020-12-02 | El Dorado | 17 | 13 | 0 | 1 | 0 | 8 |
42401 | 42401 | 2020-12-02 | Fresno | 19 | 338 | 29 | 62 | 2 | 10 |
42402 | 42402 | 2020-12-02 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
42403 | 42403 | 2020-12-02 | Humboldt | 23 | 5 | 6 | 2 | 1 | 2 |
42404 | 42404 | 2020-12-02 | Imperial | 25 | 82 | 1 | 18 | 0 | 2 |
42405 | 42405 | 2020-12-02 | Inyo | 27 | 2 | 0 | 0 | 0 | 4 |
42406 | 42406 | 2020-12-02 | Kern | 29 | 179 | 5 | 42 | 0 | 31 |
42407 | 42407 | 2020-12-02 | Kings | 31 | 58 | 1 | 11 | 0 | 7 |
42408 | 42408 | 2020-12-02 | Lake | 33 | 0 | 0 | 0 | 0 | 2 |
42409 | 42409 | 2020-12-02 | Lassen | 35 | 7 | 0 | 0 | 0 | 0 |
42410 | 42410 | 2020-12-02 | Los Angeles | 37 | 2668 | 336 | 632 | 25 | 528 |
42411 | 42411 | 2020-12-02 | Madera | 39 | 28 | 10 | 8 | 0 | 10 |
42412 | 42412 | 2020-12-02 | Marin | 41 | 16 | 4 | 6 | 0 | 12 |
42413 | 42413 | 2020-12-02 | Mariposa | 43 | 1 | 0 | 0 | 0 | 0 |
42414 | 42414 | 2020-12-02 | Mendocino | 45 | 11 | 0 | 4 | 0 | 1 |
42415 | 42415 | 2020-12-02 | Merced | 47 | 32 | 0 | 7 | 0 | 4 |
42416 | 42416 | 2020-12-02 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
42417 | 42417 | 2020-12-02 | Mono | 51 | 2 | 0 | 0 | 0 | 2 |
42418 | 42418 | 2020-12-02 | Monterey | 53 | 82 | 1 | 17 | 0 | 20 |
42419 | 42419 | 2020-12-02 | Napa | 55 | 12 | 0 | 6 | 0 | 22 |
42420 | 42420 | 2020-12-02 | Nevada | 57 | 17 | 0 | 3 | 0 | 6 |
42421 | 42421 | 2020-12-02 | Orange | 59 | 735 | 49 | 179 | 6 | 114 |
42422 | 42422 | 2020-12-02 | Placer | 61 | 131 | 14 | 19 | 2 | 25 |
42423 | 42423 | 2020-12-02 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
42424 | 42424 | 2020-12-02 | Riverside | 65 | 649 | 72 | 124 | 5 | 44 |
42425 | 42425 | 2020-12-02 | Sacramento | 67 | 359 | 29 | 76 | 4 | 71 |
42426 | 42426 | 2020-12-02 | San Benito | 69 | 9 | 0 | 3 | 0 | 0 |
42427 | 42427 | 2020-12-02 | San Bernardino | 71 | 904 | 98 | 192 | 12 | 57 |
42428 | 42428 | 2020-12-02 | San Diego | 73 | 705 | 56 | 204 | 4 | 219 |
42429 | 42429 | 2020-12-02 | San Francisco | 75 | 93 | 5 | 28 | 0 | 62 |
42430 | 42430 | 2020-12-02 | San Joaquin | 77 | 162 | 7 | 41 | 1 | 27 |
42431 | 42431 | 2020-12-02 | San Luis Obispo | 79 | 8 | 1 | 1 | 0 | 26 |
42432 | 42432 | 2020-12-02 | San Mateo | 81 | 70 | 6 | 21 | 1 | 43 |
42433 | 42433 | 2020-12-02 | Santa Barbara | 83 | 57 | 3 | 16 | 0 | 46 |
42434 | 42434 | 2020-12-02 | Santa Clara | 85 | 304 | 23 | 83 | 2 | 56 |
42435 | 42435 | 2020-12-02 | Santa Cruz | 87 | 47 | 0 | 9 | 0 | 5 |
42436 | 42436 | 2020-12-02 | Shasta | 89 | 53 | 0 | 8 | 0 | 4 |
42437 | 42437 | 2020-12-02 | Siskiyou | 93 | 15 | 0 | 3 | 0 | 8 |
42438 | 42438 | 2020-12-02 | Solano | 95 | 67 | 11 | 21 | 2 | 12 |
42439 | 42439 | 2020-12-02 | Sonoma | 97 | 38 | 4 | 5 | 0 | 4 |
42440 | 42440 | 2020-12-02 | Stanislaus | 99 | 219 | 18 | 41 | 2 | 24 |
42441 | 42441 | 2020-12-02 | Sutter | 101 | 0 | 0 | 0 | 0 | 0 |
42442 | 42442 | 2020-12-02 | Tehama | 103 | 11 | 0 | 3 | 0 | 2 |
42443 | 42443 | 2020-12-02 | Trinity | 105 | 0 | 0 | 0 | 0 | 0 |
42444 | 42444 | 2020-12-02 | Tulare | 107 | 100 | 10 | 12 | 1 | 22 |
42445 | 42445 | 2020-12-02 | Tuolumne | 109 | 11 | 0 | 2 | 0 | 1 |
42446 | 42446 | 2020-12-02 | Ventura | 111 | 98 | 13 | 39 | 4 | 18 |
42447 | 42447 | 2020-12-02 | Yolo | 113 | 20 | 0 | 11 | 0 | 6 |
42448 | 42448 | 2020-12-02 | Yuba | 115 | 37 | 0 | 10 | 0 | 1 |
42449 | 42449 | 2020-12-01 | Alameda | 1 | 187 | 47 | 57 | 3 | 75 |
42450 | 42450 | 2020-12-01 | Amador | 5 | 2 | 1 | 1 | 0 | 2 |
42451 | 42451 | 2020-12-01 | Butte | 7 | 45 | 1 | 6 | 0 | 16 |
42452 | 42452 | 2020-12-01 | Calaveras | 9 | 6 | 0 | 2 | 0 | 5 |
42453 | 42453 | 2020-12-01 | Colusa | 11 | 10 | 0 | 0 | 0 | 0 |
42454 | 42454 | 2020-12-01 | Contra Costa | 13 | 112 | 21 | 27 | 7 | 41 |
42455 | 42455 | 2020-12-01 | Del Norte | 15 | 0 | 0 | 0 | 0 | 2 |
42456 | 42456 | 2020-12-01 | El Dorado | 17 | 14 | 1 | 1 | 1 | 80 |
42457 | 42457 | 2020-12-01 | Fresno | 19 | 291 | 27 | 61 | 3 | 9 |
42458 | 42458 | 2020-12-01 | Glenn | 21 | 0 | 0 | 0 | 0 | 0 |
42459 | 42459 | 2020-12-01 | Humboldt | 23 | 5 | 5 | 1 | 2 | 3 |
42460 | 42460 | 2020-12-01 | Imperial | 25 | 73 | 0 | 16 | 0 | 0 |
42461 | 42461 | 2020-12-01 | Inyo | 27 | 1 | 0 | 1 | 0 | 2 |
42462 | 42462 | 2020-12-01 | Kern | 29 | 189 | 1 | 41 | 0 | 35 |
42463 | 42463 | 2020-12-01 | Kings | 31 | 56 | 0 | 6 | 0 | 10 |
42464 | 42464 | 2020-12-01 | Lake | 33 | 2 | 0 | 0 | 0 | 2 |
42465 | 42465 | 2020-12-01 | Lassen | 35 | 5 | 0 | 0 | 0 | 0 |
42466 | 42466 | 2020-12-01 | Los Angeles | 37 | 2572 | 310 | 601 | 41 | 574 |
42467 | 42467 | 2020-12-01 | Madera | 39 | 25 | 13 | 7 | 0 | 15 |
42468 | 42468 | 2020-12-01 | Marin | 41 | 15 | 2 | 4 | 0 | 12 |
42469 | 42469 | 2020-12-01 | Mariposa | 43 | 2 | 0 | 0 | 0 | 0 |
42470 | 42470 | 2020-12-01 | Mendocino | 45 | 12 | 0 | 4 | 0 | 1 |
42471 | 42471 | 2020-12-01 | Merced | 47 | 29 | 0 | 12 | 0 | 1 |
42472 | 42472 | 2020-12-01 | Modoc | 49 | 1 | 0 | 0 | 0 | 0 |
42473 | 42473 | 2020-12-01 | Mono | 51 | 2 | 0 | 0 | 0 | 2 |
42474 | 42474 | 2020-12-01 | Monterey | 53 | 85 | 1 | 17 | 0 | 25 |
42475 | 42475 | 2020-12-01 | Napa | 55 | 11 | 0 | 7 | 0 | 22 |
42476 | 42476 | 2020-12-01 | Nevada | 57 | 16 | 1 | 4 | 1 | 4 |
42477 | 42477 | 2020-12-01 | Orange | 59 | 689 | 67 | 171 | 8 | 123 |
42478 | 42478 | 2020-12-01 | Placer | 61 | 130 | 20 | 17 | 3 | 24 |
42479 | 42479 | 2020-12-01 | Plumas | 63 | 0 | 0 | 0 | 0 | 0 |
42480 | 42480 | 2020-12-01 | Riverside | 65 | 628 | 76 | 126 | 8 | 44 |
42481 | 42481 | 2020-12-01 | Sacramento | 67 | 363 | 22 | 77 | 5 | 64 |
42482 | 42482 | 2020-12-01 | San Benito | 69 | 8 | 0 | 3 | 0 | 0 |
42483 | 42483 | 2020-12-01 | San Bernardino | 71 | 883 | 82 | 192 | 10 | 54 |
42484 | 42484 | 2020-12-01 | San Diego | 73 | 685 | 48 | 197 | 7 | 210 |
42485 | 42485 | 2020-12-01 | San Francisco | 75 | 88 | 3 | 27 | 0 | 63 |
42486 | 42486 | 2020-12-01 | San Joaquin | 77 | 150 | 12 | 39 | 1 | 28 |
42487 | 42487 | 2020-12-01 | San Luis Obispo | 79 | 9 | 1 | 1 | 0 | 20 |
42488 | 42488 | 2020-12-01 | San Mateo | 81 | 72 | 6 | 17 | 1 | 40 |
42489 | 42489 | 2020-12-01 | Santa Barbara | 83 | 47 | 1 | 14 | 0 | 47 |
42490 | 42490 | 2020-12-01 | Santa Clara | 85 | 293 | 19 | 87 | 2 | 43 |
42491 | 42491 | 2020-12-01 | Santa Cruz | 87 | 42 | 0 | 9 | 0 | 7 |
42492 | 42492 | 2020-12-01 | Shasta | 89 | 53 | 0 | 9 | 0 | 2 |
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 );