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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | fips ▼ | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
4483 | 4483 | 2020-09-13 | Alameda | 1 | 555 | 941 | 4 | 54 |
4534 | 4534 | 2020-09-14 | Alameda | 1 | 555 | 942 | 4 | 54 |
4585 | 4585 | 2020-09-15 | Alameda | 1 | 555 | 942 | 4 | 64 |
4636 | 4636 | 2020-09-16 | Alameda | 1 | 555 | 945 | 4 | 64 |
4687 | 4687 | 2020-09-17 | Alameda | 1 | 556 | 946 | 4 | 64 |
4738 | 4738 | 2020-09-18 | Alameda | 1 | 556 | 959 | 4 | 64 |
4789 | 4789 | 2020-09-19 | Alameda | 1 | 557 | 961 | 4 | 64 |
4840 | 4840 | 2020-09-20 | Alameda | 1 | 558 | 961 | 4 | 64 |
4891 | 4891 | 2020-09-21 | Alameda | 1 | 558 | 961 | 4 | 65 |
4943 | 4943 | 2020-09-22 | Alameda | 1 | 559 | 961 | 4 | 65 |
4995 | 4995 | 2020-09-23 | Alameda | 1 | 559 | 961 | 4 | 65 |
5047 | 5047 | 2020-09-24 | Alameda | 1 | 560 | 961 | 4 | 65 |
5099 | 5099 | 2020-09-25 | Alameda | 1 | 560 | 961 | 4 | 65 |
5151 | 5151 | 2020-09-26 | Alameda | 1 | 560 | 961 | 4 | 65 |
5203 | 5203 | 2020-09-27 | Alameda | 1 | 561 | 962 | 4 | 75 |
5255 | 5255 | 2020-09-28 | Alameda | 1 | 561 | 962 | 4 | 75 |
5308 | 5308 | 2020-09-29 | Alameda | 1 | 561 | 962 | 4 | 75 |
5361 | 5361 | 2020-09-30 | Alameda | 1 | 561 | 963 | 4 | 75 |
5414 | 5414 | 2020-10-01 | Alameda | 1 | 561 | 965 | 4 | 75 |
5467 | 5467 | 2020-10-02 | Alameda | 1 | 562 | 970 | 4 | 75 |
5520 | 5520 | 2020-10-03 | Alameda | 1 | 563 | 975 | 4 | 75 |
5574 | 5574 | 2020-10-04 | Alameda | 1 | 563 | 975 | 4 | 75 |
5628 | 5628 | 2020-10-05 | Alameda | 1 | 563 | 975 | 4 | 75 |
5682 | 5682 | 2020-10-06 | Alameda | 1 | 564 | 977 | 4 | 75 |
5736 | 5736 | 2020-10-07 | Alameda | 1 | 564 | 977 | 4 | 75 |
5790 | 5790 | 2020-10-08 | Alameda | 1 | 564 | 977 | 4 | 75 |
5844 | 5844 | 2020-10-09 | Alameda | 1 | 564 | 977 | 4 | 75 |
5898 | 5898 | 2020-10-10 | Alameda | 1 | 564 | 977 | 4 | 75 |
5952 | 5952 | 2020-10-11 | Alameda | 1 | 564 | 977 | 4 | 75 |
6006 | 6006 | 2020-10-12 | Alameda | 1 | 564 | 977 | 4 | 75 |
6060 | 6060 | 2020-10-13 | Alameda | 1 | 564 | 977 | 4 | 77 |
6114 | 6114 | 2020-10-14 | Alameda | 1 | 564 | 977 | 4 | 77 |
6168 | 6168 | 2020-10-15 | Alameda | 1 | 571 | 983 | 4 | 77 |
6222 | 6222 | 2020-10-16 | Alameda | 1 | 571 | 983 | 4 | 77 |
6276 | 6276 | 2020-10-17 | Alameda | 1 | 572 | 983 | 4 | 77 |
6330 | 6330 | 2020-10-18 | Alameda | 1 | 573 | 983 | 4 | 77 |
6384 | 6384 | 2020-10-19 | Alameda | 1 | 573 | 983 | 4 | 77 |
6438 | 6438 | 2020-10-20 | Alameda | 1 | 573 | 983 | 4 | 77 |
6492 | 6492 | 2020-10-21 | Alameda | 1 | 573 | 983 | 4 | 77 |
6546 | 6546 | 2020-10-22 | Alameda | 1 | 575 | 983 | 4 | 77 |
6600 | 6600 | 2020-10-23 | Alameda | 1 | 577 | 985 | 4 | 77 |
6654 | 6654 | 2020-10-24 | Alameda | 1 | 578 | 985 | 4 | 77 |
6708 | 6708 | 2020-10-25 | Alameda | 1 | 578 | 985 | 4 | 77 |
6762 | 6762 | 2020-10-26 | Alameda | 1 | 579 | 985 | 4 | 78 |
6816 | 6816 | 2020-10-27 | Alameda | 1 | 580 | 985 | 4 | 78 |
6870 | 6870 | 2020-10-28 | Alameda | 1 | 581 | 985 | 4 | 78 |
6924 | 6924 | 2020-10-29 | Alameda | 1 | 581 | 985 | 4 | 78 |
6978 | 6978 | 2020-10-30 | Alameda | 1 | 581 | 985 | 4 | 78 |
7032 | 7032 | 2020-10-31 | Alameda | 1 | 582 | 985 | 4 | 79 |
7086 | 7086 | 2020-11-01 | Alameda | 1 | 583 | 985 | 4 | 79 |
7140 | 7140 | 2020-11-02 | Alameda | 1 | 584 | 985 | 4 | 79 |
7194 | 7194 | 2020-11-03 | Alameda | 1 | 584 | 985 | 4 | 79 |
7248 | 7248 | 2020-11-04 | Alameda | 1 | 584 | 985 | 4 | 79 |
7302 | 7302 | 2020-11-05 | Alameda | 1 | 585 | 985 | 4 | 79 |
7356 | 7356 | 2020-11-06 | Alameda | 1 | 586 | 985 | 4 | 79 |
7410 | 7410 | 2020-11-07 | Alameda | 1 | 587 | 985 | 4 | 79 |
7464 | 7464 | 2020-11-08 | Alameda | 1 | 588 | 985 | 4 | 79 |
7519 | 7519 | 2020-11-09 | Alameda | 1 | 589 | 985 | 4 | 79 |
7574 | 7574 | 2020-11-10 | Alameda | 1 | 590 | 985 | 4 | 79 |
7629 | 7629 | 2020-11-11 | Alameda | 1 | 591 | 985 | 4 | 79 |
7684 | 7684 | 2020-11-12 | Alameda | 1 | 594 | 985 | 4 | 79 |
7739 | 7739 | 2020-11-13 | Alameda | 1 | 598 | 985 | 4 | 79 |
7794 | 7794 | 2020-11-14 | Alameda | 1 | 598 | 985 | 4 | 79 |
7849 | 7849 | 2020-11-15 | Alameda | 1 | 598 | 987 | 4 | 79 |
7904 | 7904 | 2020-11-16 | Alameda | 1 | 599 | 987 | 4 | 80 |
7959 | 7959 | 2020-11-17 | Alameda | 1 | 599 | 987 | 4 | 80 |
8014 | 8014 | 2020-11-18 | Alameda | 1 | 599 | 987 | 4 | 80 |
8069 | 8069 | 2020-11-19 | Alameda | 1 | 600 | 988 | 4 | 80 |
8124 | 8124 | 2020-11-20 | Alameda | 1 | 612 | 989 | 4 | 80 |
8179 | 8179 | 2020-11-21 | Alameda | 1 | 614 | 989 | 4 | 80 |
8234 | 8234 | 2020-11-22 | Alameda | 1 | 625 | 990 | 4 | 80 |
8289 | 8289 | 2020-11-23 | Alameda | 1 | 627 | 992 | 4 | 80 |
8344 | 8344 | 2020-11-24 | Alameda | 1 | 629 | 992 | 4 | 80 |
8399 | 8399 | 2020-11-25 | Alameda | 1 | 629 | 993 | 4 | 81 |
8454 | 8454 | 2020-11-26 | Alameda | 1 | 632 | 993 | 4 | 81 |
8509 | 8509 | 2020-11-27 | Alameda | 1 | 633 | 1008 | 4 | 81 |
8564 | 8564 | 2020-11-28 | Alameda | 1 | 633 | 1042 | 4 | 81 |
8619 | 8619 | 2020-11-29 | Alameda | 1 | 660 | 1048 | 4 | 81 |
8674 | 8674 | 2020-11-30 | Alameda | 1 | 686 | 1057 | 4 | 81 |
8729 | 8729 | 2020-12-01 | Alameda | 1 | 687 | 1057 | 4 | 81 |
8784 | 8784 | 2020-12-02 | Alameda | 1 | 693 | 1061 | 4 | 82 |
8839 | 8839 | 2020-12-03 | Alameda | 1 | 711 | 1064 | 4 | 82 |
8894 | 8894 | 2020-12-04 | Alameda | 1 | 734 | 1081 | 4 | 82 |
8949 | 8949 | 2020-12-05 | Alameda | 1 | 748 | 1087 | 4 | 82 |
9004 | 9004 | 2020-12-06 | Alameda | 1 | 752 | 1092 | 4 | 82 |
9059 | 9059 | 2020-12-07 | Alameda | 1 | 754 | 1096 | 4 | 82 |
9114 | 9114 | 2020-12-08 | Alameda | 1 | 756 | 1132 | 4 | 82 |
9169 | 9169 | 2020-12-09 | Alameda | 1 | 787 | 1153 | 5 | 83 |
9224 | 9224 | 2020-12-10 | Alameda | 1 | 817 | 1181 | 5 | 83 |
9279 | 9279 | 2020-12-11 | Alameda | 1 | 826 | 1210 | 5 | 83 |
9334 | 9334 | 2020-12-12 | Alameda | 1 | 853 | 1232 | 4 | 83 |
9390 | 9390 | 2020-12-13 | Alameda | 1 | 906 | 1297 | 4 | 83 |
9446 | 9446 | 2020-12-14 | Alameda | 1 | 921 | 1302 | 4 | 85 |
9502 | 9502 | 2020-12-15 | Alameda | 1 | 934 | 1362 | 4 | 85 |
9558 | 9558 | 2020-12-16 | Alameda | 1 | 975 | 1401 | 4 | 85 |
9614 | 9614 | 2020-12-17 | Alameda | 1 | 997 | 1462 | 4 | 88 |
9670 | 9670 | 2020-12-18 | Alameda | 1 | 1030 | 1498 | 4 | 89 |
9726 | 9726 | 2020-12-19 | Alameda | 1 | 1058 | 1516 | 4 | 91 |
9782 | 9782 | 2020-12-20 | Alameda | 1 | 1069 | 1547 | 4 | 92 |
9838 | 9838 | 2020-12-21 | Alameda | 1 | 1078 | 1560 | 4 | 92 |
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 );