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)
Suggested facets: date (date)
Link | rowid | date | county | fips ▼ | minimum_staff_confirmed_cases | minimum_patients_confirmed_cases | minimum_staff_deaths | minimum_patients_deaths |
---|---|---|---|---|---|---|---|---|
1 | 1 | 2020-06-05 | Alameda | 1 | 141 | 245 | 0 | 27 |
38 | 38 | 2020-06-06 | Alameda | 1 | 141 | 248 | 0 | 27 |
75 | 75 | 2020-06-07 | Alameda | 1 | 141 | 270 | 0 | 27 |
112 | 112 | 2020-06-08 | Alameda | 1 | 141 | 272 | 0 | 27 |
149 | 149 | 2020-06-09 | Alameda | 1 | 141 | 272 | 0 | 27 |
186 | 186 | 2020-06-10 | Alameda | 1 | 141 | 288 | 0 | 28 |
224 | 224 | 2020-06-11 | Alameda | 1 | 141 | 306 | 0 | 28 |
263 | 263 | 2020-06-12 | Alameda | 1 | 142 | 307 | 0 | 28 |
302 | 302 | 2020-06-13 | Alameda | 1 | 145 | 309 | 0 | 28 |
341 | 341 | 2020-06-14 | Alameda | 1 | 145 | 334 | 0 | 28 |
380 | 380 | 2020-06-15 | Alameda | 1 | 147 | 335 | 0 | 28 |
419 | 419 | 2020-06-16 | Alameda | 1 | 149 | 338 | 1 | 28 |
458 | 458 | 2020-06-17 | Alameda | 1 | 160 | 341 | 1 | 28 |
497 | 497 | 2020-06-18 | Alameda | 1 | 162 | 353 | 1 | 28 |
536 | 536 | 2020-06-19 | Alameda | 1 | 162 | 355 | 1 | 28 |
575 | 575 | 2020-06-20 | Alameda | 1 | 164 | 355 | 1 | 28 |
614 | 614 | 2020-06-21 | Alameda | 1 | 164 | 356 | 1 | 29 |
653 | 653 | 2020-06-22 | Alameda | 1 | 165 | 356 | 1 | 29 |
692 | 692 | 2020-06-23 | Alameda | 1 | 180 | 358 | 1 | 30 |
732 | 732 | 2020-06-24 | Alameda | 1 | 183 | 359 | 1 | 30 |
772 | 772 | 2020-06-25 | Alameda | 1 | 187 | 360 | 1 | 30 |
812 | 812 | 2020-06-26 | Alameda | 1 | 191 | 369 | 1 | 30 |
852 | 852 | 2020-06-27 | Alameda | 1 | 191 | 371 | 1 | 30 |
892 | 892 | 2020-06-28 | Alameda | 1 | 191 | 388 | 1 | 30 |
932 | 932 | 2020-06-29 | Alameda | 1 | 191 | 390 | 1 | 30 |
972 | 972 | 2020-06-30 | Alameda | 1 | 194 | 390 | 1 | 30 |
1012 | 1012 | 2020-07-01 | Alameda | 1 | 197 | 394 | 1 | 31 |
1052 | 1052 | 2020-07-02 | Alameda | 1 | 199 | 397 | 1 | 31 |
1092 | 1092 | 2020-07-03 | Alameda | 1 | 199 | 397 | 1 | 31 |
1133 | 1133 | 2020-07-04 | Alameda | 1 | 200 | 400 | 1 | 31 |
1175 | 1175 | 2020-07-05 | Alameda | 1 | 200 | 400 | 1 | 31 |
1217 | 1217 | 2020-07-06 | Alameda | 1 | 201 | 414 | 1 | 31 |
1259 | 1259 | 2020-07-07 | Alameda | 1 | 201 | 424 | 1 | 31 |
1301 | 1301 | 2020-07-08 | Alameda | 1 | 201 | 424 | 1 | 31 |
1343 | 1343 | 2020-07-09 | Alameda | 1 | 202 | 426 | 1 | 31 |
1386 | 1386 | 2020-07-10 | Alameda | 1 | 207 | 426 | 1 | 31 |
1429 | 1429 | 2020-07-11 | Alameda | 1 | 209 | 443 | 1 | 32 |
1473 | 1473 | 2020-07-12 | Alameda | 1 | 210 | 444 | 1 | 32 |
1517 | 1517 | 2020-07-13 | Alameda | 1 | 211 | 444 | 1 | 32 |
1561 | 1561 | 2020-07-14 | Alameda | 1 | 213 | 445 | 1 | 32 |
1605 | 1605 | 2020-07-15 | Alameda | 1 | 214 | 445 | 1 | 32 |
1649 | 1649 | 2020-07-16 | Alameda | 1 | 217 | 447 | 1 | 32 |
1693 | 1693 | 2020-07-17 | Alameda | 1 | 230 | 449 | 2 | 33 |
1738 | 1738 | 2020-07-18 | Alameda | 1 | 231 | 449 | 2 | 34 |
1783 | 1783 | 2020-07-19 | Alameda | 1 | 231 | 449 | 2 | 35 |
1828 | 1828 | 2020-07-20 | Alameda | 1 | 233 | 468 | 2 | 35 |
1873 | 1873 | 2020-07-21 | Alameda | 1 | 234 | 474 | 2 | 35 |
1918 | 1918 | 2020-07-22 | Alameda | 1 | 234 | 474 | 2 | 35 |
1963 | 1963 | 2020-07-23 | Alameda | 1 | 235 | 484 | 2 | 35 |
2008 | 2008 | 2020-07-24 | Alameda | 1 | 235 | 484 | 2 | 35 |
2053 | 2053 | 2020-07-25 | Alameda | 1 | 237 | 498 | 2 | 35 |
2098 | 2098 | 2020-07-26 | Alameda | 1 | 250 | 515 | 2 | 35 |
2143 | 2143 | 2020-07-27 | Alameda | 1 | 251 | 515 | 2 | 35 |
2188 | 2188 | 2020-07-28 | Alameda | 1 | 251 | 518 | 2 | 35 |
2234 | 2234 | 2020-07-29 | Alameda | 1 | 254 | 518 | 2 | 35 |
2280 | 2280 | 2020-07-30 | Alameda | 1 | 258 | 542 | 2 | 35 |
2326 | 2326 | 2020-07-31 | Alameda | 1 | 262 | 556 | 2 | 35 |
2372 | 2372 | 2020-08-01 | Alameda | 1 | 272 | 563 | 2 | 35 |
2418 | 2418 | 2020-08-02 | Alameda | 1 | 282 | 567 | 2 | 35 |
2464 | 2464 | 2020-08-03 | Alameda | 1 | 282 | 567 | 2 | 36 |
2511 | 2511 | 2020-08-04 | Alameda | 1 | 282 | 569 | 2 | 36 |
2558 | 2558 | 2020-08-05 | Alameda | 1 | 282 | 573 | 2 | 36 |
2605 | 2605 | 2020-08-06 | Alameda | 1 | 282 | 573 | 3 | 37 |
2652 | 2652 | 2020-08-07 | Alameda | 1 | 282 | 573 | 3 | 37 |
2699 | 2699 | 2020-08-08 | Alameda | 1 | 295 | 592 | 3 | 37 |
2746 | 2746 | 2020-08-09 | Alameda | 1 | 307 | 609 | 3 | 37 |
2793 | 2793 | 2020-08-10 | Alameda | 1 | 310 | 613 | 3 | 37 |
2840 | 2840 | 2020-08-11 | Alameda | 1 | 311 | 615 | 3 | 37 |
2887 | 2887 | 2020-08-12 | Alameda | 1 | 335 | 615 | 3 | 37 |
2934 | 2934 | 2020-08-13 | Alameda | 1 | 356 | 624 | 3 | 37 |
2981 | 2981 | 2020-08-14 | Alameda | 1 | 371 | 640 | 3 | 37 |
3029 | 3029 | 2020-08-15 | Alameda | 1 | 402 | 676 | 3 | 38 |
3077 | 3077 | 2020-08-16 | Alameda | 1 | 422 | 700 | 3 | 38 |
3125 | 3125 | 2020-08-17 | Alameda | 1 | 427 | 720 | 3 | 39 |
3173 | 3173 | 2020-08-18 | Alameda | 1 | 443 | 734 | 3 | 39 |
3221 | 3221 | 2020-08-19 | Alameda | 1 | 459 | 738 | 3 | 40 |
3270 | 3270 | 2020-08-20 | Alameda | 1 | 470 | 777 | 3 | 40 |
3320 | 3320 | 2020-08-21 | Alameda | 1 | 477 | 788 | 3 | 40 |
3370 | 3370 | 2020-08-22 | Alameda | 1 | 486 | 791 | 3 | 42 |
3420 | 3420 | 2020-08-23 | Alameda | 1 | 489 | 796 | 3 | 42 |
3470 | 3470 | 2020-08-24 | Alameda | 1 | 490 | 797 | 3 | 42 |
3520 | 3520 | 2020-08-25 | Alameda | 1 | 490 | 798 | 4 | 42 |
3570 | 3570 | 2020-08-26 | Alameda | 1 | 502 | 827 | 4 | 42 |
3620 | 3620 | 2020-08-27 | Alameda | 1 | 518 | 834 | 4 | 43 |
3670 | 3670 | 2020-08-28 | Alameda | 1 | 527 | 849 | 4 | 43 |
3720 | 3720 | 2020-08-29 | Alameda | 1 | 532 | 852 | 4 | 43 |
3770 | 3770 | 2020-08-30 | Alameda | 1 | 533 | 860 | 4 | 43 |
3820 | 3820 | 2020-08-31 | Alameda | 1 | 535 | 860 | 4 | 43 |
3871 | 3871 | 2020-09-01 | Alameda | 1 | 535 | 860 | 4 | 53 |
3922 | 3922 | 2020-09-02 | Alameda | 1 | 537 | 868 | 4 | 53 |
3973 | 3973 | 2020-09-03 | Alameda | 1 | 539 | 871 | 4 | 53 |
4024 | 4024 | 2020-09-04 | Alameda | 1 | 544 | 884 | 4 | 54 |
4075 | 4075 | 2020-09-05 | Alameda | 1 | 547 | 931 | 4 | 54 |
4126 | 4126 | 2020-09-06 | Alameda | 1 | 548 | 932 | 4 | 54 |
4177 | 4177 | 2020-09-07 | Alameda | 1 | 548 | 932 | 4 | 54 |
4228 | 4228 | 2020-09-08 | Alameda | 1 | 548 | 933 | 4 | 54 |
4279 | 4279 | 2020-09-09 | Alameda | 1 | 549 | 936 | 4 | 54 |
4330 | 4330 | 2020-09-10 | Alameda | 1 | 552 | 938 | 4 | 54 |
4381 | 4381 | 2020-09-11 | Alameda | 1 | 554 | 938 | 4 | 54 |
4432 | 4432 | 2020-09-12 | Alameda | 1 | 555 | 940 | 4 | 54 |
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 );