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 minimum_patients_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | fips | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases ▼ | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
4 | 4 | 2020-06-05 | El Dorado | 17 | 1 | 0 | 0 | 0 |
16 | 16 | 2020-06-05 | Napa | 55 | 1 | 0 | 0 | 0 |
30 | 30 | 2020-06-05 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
41 | 41 | 2020-06-06 | El Dorado | 17 | 1 | 0 | 0 | 0 |
53 | 53 | 2020-06-06 | Napa | 55 | 1 | 0 | 0 | 0 |
67 | 67 | 2020-06-06 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
78 | 78 | 2020-06-07 | El Dorado | 17 | 1 | 0 | 0 | 0 |
90 | 90 | 2020-06-07 | Napa | 55 | 1 | 0 | 0 | 0 |
104 | 104 | 2020-06-07 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
115 | 115 | 2020-06-08 | El Dorado | 17 | 1 | 0 | 0 | 0 |
127 | 127 | 2020-06-08 | Napa | 55 | 1 | 0 | 0 | 0 |
141 | 141 | 2020-06-08 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
152 | 152 | 2020-06-09 | El Dorado | 17 | 1 | 0 | 0 | 0 |
164 | 164 | 2020-06-09 | Napa | 55 | 1 | 0 | 0 | 0 |
178 | 178 | 2020-06-09 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
189 | 189 | 2020-06-10 | El Dorado | 17 | 1 | 0 | 0 | 0 |
201 | 201 | 2020-06-10 | Napa | 55 | 1 | 0 | 0 | 0 |
215 | 215 | 2020-06-10 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
220 | 220 | 2020-06-10 | Sutter | 101 | 1 | 0 | 0 | 0 |
227 | 227 | 2020-06-11 | El Dorado | 17 | 1 | 0 | 0 | 0 |
239 | 239 | 2020-06-11 | Napa | 55 | 1 | 0 | 0 | 0 |
253 | 253 | 2020-06-11 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
258 | 258 | 2020-06-11 | Sutter | 101 | 1 | 0 | 0 | 0 |
260 | 260 | 2020-06-11 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
266 | 266 | 2020-06-12 | El Dorado | 17 | 1 | 0 | 0 | 0 |
292 | 292 | 2020-06-12 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
297 | 297 | 2020-06-12 | Sutter | 101 | 1 | 0 | 0 | 0 |
299 | 299 | 2020-06-12 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
305 | 305 | 2020-06-13 | El Dorado | 17 | 1 | 0 | 0 | 0 |
331 | 331 | 2020-06-13 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
336 | 336 | 2020-06-13 | Sutter | 101 | 1 | 0 | 0 | 0 |
338 | 338 | 2020-06-13 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
344 | 344 | 2020-06-14 | El Dorado | 17 | 1 | 0 | 0 | 0 |
370 | 370 | 2020-06-14 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
375 | 375 | 2020-06-14 | Sutter | 101 | 1 | 0 | 0 | 0 |
377 | 377 | 2020-06-14 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
383 | 383 | 2020-06-15 | El Dorado | 17 | 1 | 0 | 0 | 0 |
409 | 409 | 2020-06-15 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
414 | 414 | 2020-06-15 | Sutter | 101 | 1 | 0 | 0 | 0 |
416 | 416 | 2020-06-15 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
422 | 422 | 2020-06-16 | El Dorado | 17 | 1 | 0 | 0 | 0 |
448 | 448 | 2020-06-16 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
453 | 453 | 2020-06-16 | Sutter | 101 | 1 | 0 | 0 | 0 |
455 | 455 | 2020-06-16 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
461 | 461 | 2020-06-17 | El Dorado | 17 | 1 | 0 | 0 | 0 |
487 | 487 | 2020-06-17 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
492 | 492 | 2020-06-17 | Sutter | 101 | 1 | 0 | 0 | 0 |
494 | 494 | 2020-06-17 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
500 | 500 | 2020-06-18 | El Dorado | 17 | 1 | 0 | 0 | 0 |
526 | 526 | 2020-06-18 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
531 | 531 | 2020-06-18 | Sutter | 101 | 1 | 0 | 0 | 0 |
533 | 533 | 2020-06-18 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
539 | 539 | 2020-06-19 | El Dorado | 17 | 1 | 0 | 0 | 0 |
565 | 565 | 2020-06-19 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
570 | 570 | 2020-06-19 | Sutter | 101 | 1 | 0 | 0 | 0 |
572 | 572 | 2020-06-19 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
578 | 578 | 2020-06-20 | El Dorado | 17 | 1 | 0 | 0 | 0 |
604 | 604 | 2020-06-20 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
609 | 609 | 2020-06-20 | Sutter | 101 | 1 | 0 | 0 | 0 |
611 | 611 | 2020-06-20 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
617 | 617 | 2020-06-21 | El Dorado | 17 | 1 | 0 | 0 | 0 |
643 | 643 | 2020-06-21 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
648 | 648 | 2020-06-21 | Sutter | 101 | 1 | 0 | 0 | 0 |
650 | 650 | 2020-06-21 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
682 | 682 | 2020-06-22 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
687 | 687 | 2020-06-22 | Sutter | 101 | 1 | 0 | 0 | 0 |
689 | 689 | 2020-06-22 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
708 | 708 | 2020-06-23 | Nevada | 57 | 1 | 0 | 0 | 0 |
722 | 722 | 2020-06-23 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
727 | 727 | 2020-06-23 | Sutter | 101 | 1 | 0 | 0 | 0 |
729 | 729 | 2020-06-23 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
748 | 748 | 2020-06-24 | Nevada | 57 | 1 | 0 | 0 | 0 |
762 | 762 | 2020-06-24 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
767 | 767 | 2020-06-24 | Sutter | 101 | 1 | 0 | 0 | 0 |
769 | 769 | 2020-06-24 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
788 | 788 | 2020-06-25 | Nevada | 57 | 1 | 0 | 0 | 0 |
802 | 802 | 2020-06-25 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
807 | 807 | 2020-06-25 | Sutter | 101 | 1 | 0 | 0 | 0 |
809 | 809 | 2020-06-25 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
828 | 828 | 2020-06-26 | Nevada | 57 | 1 | 0 | 0 | 0 |
842 | 842 | 2020-06-26 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
847 | 847 | 2020-06-26 | Sutter | 101 | 1 | 0 | 0 | 0 |
849 | 849 | 2020-06-26 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
868 | 868 | 2020-06-27 | Nevada | 57 | 1 | 0 | 0 | 0 |
882 | 882 | 2020-06-27 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
887 | 887 | 2020-06-27 | Sutter | 101 | 1 | 0 | 0 | 0 |
889 | 889 | 2020-06-27 | Tuolumne | 109 | 1 | 0 | 0 | 0 |
908 | 908 | 2020-06-28 | Nevada | 57 | 1 | 0 | 0 | 0 |
922 | 922 | 2020-06-28 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
927 | 927 | 2020-06-28 | Sutter | 101 | 1 | 0 | 0 | 0 |
929 | 929 | 2020-06-28 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
948 | 948 | 2020-06-29 | Nevada | 57 | 1 | 0 | 0 | 0 |
962 | 962 | 2020-06-29 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
967 | 967 | 2020-06-29 | Sutter | 101 | 1 | 0 | 0 | 0 |
969 | 969 | 2020-06-29 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
988 | 988 | 2020-06-30 | Nevada | 57 | 1 | 0 | 0 | 0 |
1002 | 1002 | 2020-06-30 | Santa Cruz | 87 | 1 | 0 | 0 | 0 |
1007 | 1007 | 2020-06-30 | Sutter | 101 | 2 | 0 | 0 | 0 |
1009 | 1009 | 2020-06-30 | Tuolumne | 109 | 2 | 0 | 0 | 0 |
1028 | 1028 | 2020-07-01 | Nevada | 57 | 1 | 0 | 0 | 0 |
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 );