cdph-nursing-home-county-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- minimum_staff_confirmed_cases
- The minimum number of cumulative confirmed coronavirus case amoung staff at that time.
- minimum_patients_confirmed_cases
- The minimum number of cumulative confirmed coronavirus case amoung patients at that time.
- minimum_staff_deaths
- The minimum number of cumulative deaths amoung staff at that time.
- minimum_patients_deaths
- The minimum number of cumulative deaths amoung patients at that time.
31,733 rows sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-12-12 56
- 2020-12-13 56
- 2020-12-14 56
- 2020-12-15 56
- 2020-12-16 56
- 2020-12-17 56
- 2020-12-18 56
- 2020-12-19 56
- 2020-12-20 56
- 2020-12-21 56
- 2020-12-22 56
- 2020-12-23 56
- 2020-12-24 56
- 2020-12-25 56
- 2020-12-26 56
- 2020-12-27 56
- 2020-12-28 56
- 2020-12-29 56
- 2020-12-30 56
- 2020-12-31 56
- 2021-01-01 56
- 2021-01-02 56
- 2021-01-03 56
- 2021-01-04 56
- 2021-01-05 56
- 2021-01-06 56
- 2021-01-07 56
- 2021-01-08 56
- 2021-01-09 56
- 2021-01-10 56
- …
Link | rowid ▲ | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
31733 | 31733 | 2022-01-15 | Yuba | 115 | 73 | 57 | 0 | 1 |
31732 | 31732 | 2022-01-15 | Yolo | 113 | 306 | 309 | 2 | 39 |
31731 | 31731 | 2022-01-15 | Ventura | 111 | 1141 | 1081 | 1 | 82 |
31730 | 31730 | 2022-01-15 | Tuolumne | 109 | 90 | 94 | 0 | 16 |
31729 | 31729 | 2022-01-15 | Tulare | 107 | 1122 | 1093 | 2 | 148 |
31728 | 31728 | 2022-01-15 | Trinity | 105 | 21 | 1 | 0 | 1 |
31727 | 31727 | 2022-01-15 | Tehama | 103 | 36 | 57 | 0 | 12 |
31726 | 31726 | 2022-01-15 | Sutter | 101 | 294 | 322 | 0 | 15 |
31725 | 31725 | 2022-01-15 | Stanislaus | 99 | 1458 | 1609 | 1 | 144 |
31724 | 31724 | 2022-01-15 | Sonoma | 97 | 762 | 820 | 2 | 38 |
31723 | 31723 | 2022-01-15 | Solano | 95 | 299 | 346 | 0 | 20 |
31722 | 31722 | 2022-01-15 | Siskiyou | 93 | 25 | 1 | 1 | 0 |
31721 | 31721 | 2022-01-15 | Sierra | 91 | 15 | 17 | 0 | 1 |
31720 | 31720 | 2022-01-15 | Shasta | 89 | 783 | 578 | 0 | 66 |
31719 | 31719 | 2022-01-15 | Santa Cruz | 87 | 313 | 501 | 0 | 69 |
31718 | 31718 | 2022-01-15 | Santa Clara | 85 | 2651 | 2951 | 5 | 213 |
31717 | 31717 | 2022-01-15 | Santa Barbara | 83 | 609 | 505 | 2 | 35 |
31716 | 31716 | 2022-01-15 | San Mateo | 81 | 578 | 871 | 3 | 107 |
31715 | 31715 | 2022-01-15 | San Luis Obispo | 79 | 320 | 346 | 0 | 36 |
31714 | 31714 | 2022-01-15 | San Joaquin | 77 | 1802 | 2046 | 3 | 207 |
31713 | 31713 | 2022-01-15 | San Francisco | 75 | 1000 | 814 | 2 | 36 |
31712 | 31712 | 2022-01-15 | San Diego | 73 | 5568 | 5445 | 9 | 342 |
31711 | 31711 | 2022-01-15 | San Bernardino | 71 | 3538 | 3846 | 8 | 319 |
31710 | 31710 | 2022-01-15 | San Benito | 69 | 64 | 21 | 1 | 2 |
31709 | 31709 | 2022-01-15 | Sacramento | 67 | 2453 | 2750 | 4 | 166 |
31708 | 31708 | 2022-01-15 | Riverside | 65 | 3489 | 3853 | 6 | 249 |
31707 | 31707 | 2022-01-15 | Plumas | 63 | 27 | 13 | 1 | 1 |
31706 | 31706 | 2022-01-15 | Placer | 61 | 596 | 711 | 0 | 50 |
31705 | 31705 | 2022-01-15 | Orange | 59 | 5089 | 5207 | 14 | 634 |
31704 | 31704 | 2022-01-15 | Nevada | 57 | 269 | 275 | 0 | 46 |
31703 | 31703 | 2022-01-15 | Napa | 55 | 248 | 229 | 0 | 15 |
31702 | 31702 | 2022-01-15 | Monterey | 53 | 599 | 580 | 0 | 55 |
31701 | 31701 | 2022-01-15 | Modoc | 49 | 71 | 53 | 0 | 2 |
31700 | 31700 | 2022-01-15 | Merced | 47 | 349 | 325 | 1 | 16 |
31699 | 31699 | 2022-01-15 | Mendocino | 45 | 114 | 95 | 1 | 16 |
31698 | 31698 | 2022-01-15 | Mariposa | 43 | 1 | 0 | 0 | 0 |
31697 | 31697 | 2022-01-15 | Marin | 41 | 340 | 367 | 2 | 43 |
31696 | 31696 | 2022-01-15 | Madera | 39 | 295 | 326 | 0 | 28 |
31695 | 31695 | 2022-01-15 | Los Angeles | 37 | 24062 | 24479 | 93 | 3193 |
31694 | 31694 | 2022-01-15 | Lassen | 35 | 23 | 33 | 1 | 1 |
31693 | 31693 | 2022-01-15 | Lake | 33 | 127 | 135 | 1 | 14 |
31692 | 31692 | 2022-01-15 | Kings | 31 | 251 | 210 | 0 | 37 |
31691 | 31691 | 2022-01-15 | Kern | 29 | 1456 | 1341 | 1 | 78 |
31690 | 31690 | 2022-01-15 | Inyo | 27 | 62 | 68 | 0 | 14 |
31689 | 31689 | 2022-01-15 | Imperial | 25 | 167 | 147 | 1 | 22 |
31688 | 31688 | 2022-01-15 | Humboldt | 23 | 76 | 63 | 1 | 3 |
31687 | 31687 | 2022-01-15 | Glenn | 21 | 50 | 44 | 0 | 1 |
31686 | 31686 | 2022-01-15 | Fresno | 19 | 1954 | 1841 | 4 | 196 |
31685 | 31685 | 2022-01-15 | El Dorado | 17 | 271 | 256 | 0 | 33 |
31684 | 31684 | 2022-01-15 | Del Norte | 15 | 40 | 1 | 0 | 0 |
31683 | 31683 | 2022-01-15 | Contra Costa | 13 | 1061 | 1315 | 5 | 105 |
31682 | 31682 | 2022-01-15 | Colusa | 11 | 80 | 58 | 0 | 2 |
31681 | 31681 | 2022-01-15 | Calaveras | 9 | 39 | 71 | 0 | 1 |
31680 | 31680 | 2022-01-15 | Butte | 7 | 469 | 583 | 0 | 50 |
31679 | 31679 | 2022-01-15 | Amador | 5 | 39 | 67 | 0 | 17 |
31678 | 31678 | 2022-01-15 | Alameda | 1 | 2297 | 2670 | 5 | 148 |
31677 | 31677 | 2022-01-14 | Yuba | 115 | 73 | 55 | 0 | 1 |
31676 | 31676 | 2022-01-14 | Yolo | 113 | 306 | 307 | 2 | 39 |
31675 | 31675 | 2022-01-14 | Ventura | 111 | 1133 | 1079 | 1 | 82 |
31674 | 31674 | 2022-01-14 | Tuolumne | 109 | 88 | 94 | 0 | 16 |
31673 | 31673 | 2022-01-14 | Tulare | 107 | 1119 | 1092 | 2 | 148 |
31672 | 31672 | 2022-01-14 | Trinity | 105 | 21 | 1 | 0 | 1 |
31671 | 31671 | 2022-01-14 | Tehama | 103 | 36 | 57 | 0 | 12 |
31670 | 31670 | 2022-01-14 | Sutter | 101 | 294 | 322 | 0 | 15 |
31669 | 31669 | 2022-01-14 | Stanislaus | 99 | 1458 | 1609 | 1 | 144 |
31668 | 31668 | 2022-01-14 | Sonoma | 97 | 762 | 820 | 2 | 38 |
31667 | 31667 | 2022-01-14 | Solano | 95 | 299 | 346 | 0 | 20 |
31666 | 31666 | 2022-01-14 | Siskiyou | 93 | 25 | 1 | 1 | 0 |
31665 | 31665 | 2022-01-14 | Sierra | 91 | 15 | 17 | 0 | 1 |
31664 | 31664 | 2022-01-14 | Shasta | 89 | 782 | 578 | 0 | 66 |
31663 | 31663 | 2022-01-14 | Santa Cruz | 87 | 313 | 501 | 0 | 69 |
31662 | 31662 | 2022-01-14 | Santa Clara | 85 | 2635 | 2928 | 5 | 213 |
31661 | 31661 | 2022-01-14 | Santa Barbara | 83 | 609 | 505 | 2 | 35 |
31660 | 31660 | 2022-01-14 | San Mateo | 81 | 578 | 871 | 3 | 107 |
31659 | 31659 | 2022-01-14 | San Luis Obispo | 79 | 320 | 346 | 0 | 36 |
31658 | 31658 | 2022-01-14 | San Joaquin | 77 | 1802 | 2046 | 3 | 207 |
31657 | 31657 | 2022-01-14 | San Francisco | 75 | 1000 | 814 | 2 | 36 |
31656 | 31656 | 2022-01-14 | San Diego | 73 | 5567 | 5442 | 9 | 342 |
31655 | 31655 | 2022-01-14 | San Bernardino | 71 | 3538 | 3846 | 8 | 319 |
31654 | 31654 | 2022-01-14 | San Benito | 69 | 64 | 21 | 1 | 2 |
31653 | 31653 | 2022-01-14 | Sacramento | 67 | 2447 | 2747 | 4 | 166 |
31652 | 31652 | 2022-01-14 | Riverside | 65 | 3482 | 3849 | 6 | 249 |
31651 | 31651 | 2022-01-14 | Plumas | 63 | 27 | 13 | 1 | 1 |
31650 | 31650 | 2022-01-14 | Placer | 61 | 595 | 711 | 0 | 50 |
31649 | 31649 | 2022-01-14 | Orange | 59 | 5084 | 5207 | 14 | 634 |
31648 | 31648 | 2022-01-14 | Nevada | 57 | 269 | 275 | 0 | 46 |
31647 | 31647 | 2022-01-14 | Napa | 55 | 248 | 229 | 0 | 15 |
31646 | 31646 | 2022-01-14 | Monterey | 53 | 599 | 580 | 0 | 55 |
31645 | 31645 | 2022-01-14 | Modoc | 49 | 71 | 53 | 0 | 2 |
31644 | 31644 | 2022-01-14 | Merced | 47 | 349 | 325 | 1 | 16 |
31643 | 31643 | 2022-01-14 | Mendocino | 45 | 114 | 95 | 1 | 16 |
31642 | 31642 | 2022-01-14 | Mariposa | 43 | 1 | 0 | 0 | 0 |
31641 | 31641 | 2022-01-14 | Marin | 41 | 340 | 367 | 2 | 43 |
31640 | 31640 | 2022-01-14 | Madera | 39 | 295 | 326 | 0 | 28 |
31639 | 31639 | 2022-01-14 | Los Angeles | 37 | 24034 | 24411 | 93 | 3192 |
31638 | 31638 | 2022-01-14 | Lassen | 35 | 23 | 33 | 1 | 1 |
31637 | 31637 | 2022-01-14 | Lake | 33 | 127 | 135 | 1 | 14 |
31636 | 31636 | 2022-01-14 | Kings | 31 | 251 | 210 | 0 | 37 |
31635 | 31635 | 2022-01-14 | Kern | 29 | 1450 | 1338 | 1 | 78 |
31634 | 31634 | 2022-01-14 | Inyo | 27 | 62 | 68 | 0 | 14 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-nursing-home-county-totals" ( [date] TEXT, [county] TEXT, [fips] INTEGER, [minimum_staff_confirmed_cases] INTEGER, [minimum_patients_confirmed_cases] INTEGER, [minimum_staff_deaths] INTEGER, [minimum_patients_deaths] INTEGER );