cdph-skilled-nursing-facilities
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.
- id
- The facility's unique identifier with the state.
- name
- The name of the skilled-nursing facility.
- 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.
- staff_confirmed_cases
- The current number of confirmed coronavirus case amoung staff at that time.
- patients_confirmed_cases
- The current number of confirmed coronavirus case amoung patients at that time.
- staff_confirmed_cases_note
- In cases where the staff_confirmed_cases are obscured, this explains the range of possible values.
- patients_confirmed_cases_note
- In cases where the patients_confirmed_cases are obscured, this explains the range of possible values.
- staff_deaths
- The cumulative number of deaths case amoung staff at that time.
- patients_deaths
- The cumulative number of deaths case amoung patients at that time.
- staff_deaths_note
- In cases where the staff_deaths are obscured, this explains the range of possible values.
- patients_deaths_note
- In cases where the patients_deaths are obscured, this explains the range of possible values.
776,631 rows sorted by id
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | id ▼ | slug | name | county | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | fips | staff_confirmed_cases_note | patients_confirmed_cases_note | staff_deaths_note | patients_deaths_note |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1148 | 1148 | 2022-01-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 44 | 64 | 0 | 1 | 97 | <11 | |||
2371 | 2371 | 2022-01-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 44 | 64 | 0 | 1 | 97 | <11 | |||
3594 | 3594 | 2022-01-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 44 | 63 | 0 | 1 | 97 | <11 | |||
4817 | 4817 | 2022-01-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 44 | 63 | 0 | 1 | 97 | <11 | |||
6040 | 6040 | 2022-01-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 44 | 63 | 0 | 1 | 97 | <11 | |||
7263 | 7263 | 2022-01-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 44 | 63 | 0 | 1 | 97 | <11 | |||
8486 | 8486 | 2022-01-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 42 | 63 | 0 | 1 | 97 | <11 | |||
9709 | 9709 | 2022-01-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 42 | 63 | 0 | 1 | 97 | <11 | |||
10932 | 10932 | 2022-01-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 42 | 62 | 0 | 1 | 97 | <11 | |||
12155 | 12155 | 2022-01-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 41 | 62 | 0 | 1 | 97 | <11 | |||
13378 | 13378 | 2022-01-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 40 | 62 | 0 | 1 | 97 | <11 | |||
14601 | 14601 | 2022-01-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 40 | 62 | 0 | 1 | 97 | <11 | |||
15824 | 15824 | 2022-01-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
17047 | 17047 | 2022-01-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
18270 | 18270 | 2022-01-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
19493 | 19493 | 2021-12-31 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
20716 | 20716 | 2021-12-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
21939 | 21939 | 2021-12-29 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
23162 | 23162 | 2021-12-28 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
24385 | 24385 | 2021-12-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
25608 | 25608 | 2021-12-26 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
26831 | 26831 | 2021-12-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
28054 | 28054 | 2021-12-24 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
29277 | 29277 | 2021-12-23 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
30500 | 30500 | 2021-12-22 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
31723 | 31723 | 2021-12-21 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
32946 | 32946 | 2021-12-20 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
34169 | 34169 | 2021-12-19 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
35392 | 35392 | 2021-12-18 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
36615 | 36615 | 2021-12-17 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
37838 | 37838 | 2021-12-16 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
39061 | 39061 | 2021-12-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
40284 | 40284 | 2021-12-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
41507 | 41507 | 2021-12-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
42730 | 42730 | 2021-12-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
43953 | 43953 | 2021-12-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
45176 | 45176 | 2021-12-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
46399 | 46399 | 2021-12-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
47622 | 47622 | 2021-12-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
48845 | 48845 | 2021-12-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
50068 | 50068 | 2021-12-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
51291 | 51291 | 2021-12-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
52514 | 52514 | 2021-12-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
53737 | 53737 | 2021-12-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
54960 | 54960 | 2021-12-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 38 | 62 | 0 | 1 | 97 | <11 | |||
56183 | 56183 | 2021-12-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
57406 | 57406 | 2021-11-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
58629 | 58629 | 2021-11-29 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
59852 | 59852 | 2021-11-28 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
61075 | 61075 | 2021-11-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
62298 | 62298 | 2021-11-26 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
63521 | 63521 | 2021-11-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
64744 | 64744 | 2021-11-24 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
65967 | 65967 | 2021-11-23 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
67190 | 67190 | 2021-11-22 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
68413 | 68413 | 2021-11-21 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
69636 | 69636 | 2021-11-20 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
70859 | 70859 | 2021-11-19 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
72082 | 72082 | 2021-11-18 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
73305 | 73305 | 2021-11-17 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
74528 | 74528 | 2021-11-16 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
75751 | 75751 | 2021-11-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
76974 | 76974 | 2021-11-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
78197 | 78197 | 2021-11-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
79420 | 79420 | 2021-11-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
80643 | 80643 | 2021-11-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
81866 | 81866 | 2021-11-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
83089 | 83089 | 2021-11-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
84312 | 84312 | 2021-11-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
85535 | 85535 | 2021-11-07 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
86758 | 86758 | 2021-11-06 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
87981 | 87981 | 2021-11-05 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
89204 | 89204 | 2021-11-04 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
90427 | 90427 | 2021-11-03 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
91650 | 91650 | 2021-11-02 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
92873 | 92873 | 2021-11-01 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
94096 | 94096 | 2021-10-31 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
95319 | 95319 | 2021-10-30 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
96542 | 96542 | 2021-10-29 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
97765 | 97765 | 2021-10-28 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
98988 | 98988 | 2021-10-27 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
100211 | 100211 | 2021-10-26 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
101434 | 101434 | 2021-10-25 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
102657 | 102657 | 2021-10-24 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
103880 | 103880 | 2021-10-23 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
105103 | 105103 | 2021-10-22 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
106326 | 106326 | 2021-10-21 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
107549 | 107549 | 2021-10-20 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
108772 | 108772 | 2021-10-19 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
109995 | 109995 | 2021-10-18 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
111218 | 111218 | 2021-10-17 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
112441 | 112441 | 2021-10-16 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
113664 | 113664 | 2021-10-15 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
114887 | 114887 | 2021-10-14 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
116110 | 116110 | 2021-10-13 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
117333 | 117333 | 2021-10-12 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
118556 | 118556 | 2021-10-11 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
119779 | 119779 | 2021-10-10 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
121002 | 121002 | 2021-10-09 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 | |||
122225 | 122225 | 2021-10-08 | 10000001 | 010000001-vineyard-post-acute | VINEYARD POST ACUTE | Sonoma | 37 | 62 | 0 | 1 | 97 | <11 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-skilled-nursing-facilities" ( [date] TEXT, [id] INTEGER, [slug] TEXT, [name] TEXT, [county] TEXT, [staff_confirmed_cases] INTEGER, [patients_confirmed_cases] INTEGER, [staff_deaths] INTEGER, [patients_deaths] INTEGER, [fips] INTEGER, [staff_confirmed_cases_note] TEXT, [patients_confirmed_cases_note] TEXT, [staff_deaths_note] TEXT, [patients_deaths_note] TEXT );