cdph-skilled-nursing-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.
- staff_active_cases
- The number of active coronavirus case among staff at that time.
- patients_active_cases
- The number of active coronavirus case amoung patients at that time.
- staff_confirmed_cases
- The cumulative number of confirmed coronavirus case among staff at that time.
- patients_confirmed_cases
- The cumulative number of confirmed coronavirus case among patients at that time.
- staff_deaths
- The cumulative number of deaths case among staff at that time.
- patients_deaths
- The cumulative number of deaths case among patients at that time.
- staff_deaths_note
- In cases where the staff_deaths are obscured, this explains the range of possible values.
- source_url
- The URL to the state data release.
591 rows sorted by patients_active_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: staff_deaths_note, date (date)
Link | rowid | date | staff_active_cases | patients_active_cases ▼ | staff_confirmed_cases | patients_confirmed_cases | staff_deaths | patients_deaths | staff_deaths_note |
---|---|---|---|---|---|---|---|---|---|
222 | 222 | 2021-06-01 | 83 | 2 | 50935 | 61517 | 229 | 9058 | |
225 | 225 | 2021-05-29 | 81 | 25 | 50927 | 61497 | 229 | 9058 | |
228 | 228 | 2021-05-26 | 91 | 26 | 50904 | 61485 | 229 | 9057 | |
201 | 201 | 2021-06-24 | 54 | 28 | 51047 | 61589 | 231 | 9062 | |
192 | 192 | 2021-07-03 | 93 | 29 | 51120 | 61619 | 231 | 9065 | |
195 | 195 | 2021-06-30 | 63 | 29 | 51080 | 61609 | 231 | 9065 | |
226 | 226 | 2021-05-28 | 83 | 29 | 50923 | 61495 | 229 | 9058 | |
202 | 202 | 2021-06-23 | 57 | 30 | 51044 | 61584 | 229 | 9062 | |
227 | 227 | 2021-05-27 | 87 | 30 | 50912 | 61489 | 229 | 9057 | |
203 | 203 | 2021-06-22 | 56 | 31 | 51038 | 61581 | 229 | 9062 | |
190 | 190 | 2021-07-05 | 97 | 32 | 51130 | 61625 | 231 | 9066 | |
193 | 193 | 2021-07-02 | 86 | 32 | 51111 | 61616 | 231 | 9065 | |
215 | 215 | 2021-06-08 | 78 | 32 | 50982 | 61549 | 229 | 9060 | |
231 | 231 | 2021-05-22 | 82 | 33 | 50881 | 61477 | 229 | 9056 | |
204 | 204 | 2021-06-21 | 55 | 34 | 51033 | 61580 | 229 | 9062 | |
207 | 207 | 2021-06-18 | 63 | 34 | 51025 | 61576 | 229 | 9062 | |
232 | 232 | 2021-05-21 | 81 | 34 | 50874 | 61475 | 229 | 9056 | |
196 | 196 | 2021-06-29 | 59 | 35 | 51073 | 61606 | 231 | 9065 | |
197 | 197 | 2021-06-28 | 57 | 35 | 51066 | 61600 | 231 | 9063 | |
200 | 200 | 2021-06-25 | 52 | 35 | 51052 | 61592 | 231 | 9062 | |
216 | 216 | 2021-06-07 | 84 | 35 | 50974 | 61535 | 229 | 9060 | |
217 | 217 | 2021-06-06 | 84 | 35 | 50974 | 61535 | 229 | 9060 | |
218 | 218 | 2021-06-05 | 90 | 35 | 50971 | 61534 | 229 | 9060 | |
219 | 219 | 2021-06-04 | 88 | 35 | 50962 | 61530 | 229 | 9060 | |
208 | 208 | 2021-06-17 | 73 | 36 | 51019 | 61575 | 229 | 9062 | |
188 | 188 | 2021-07-07 | 112 | 37 | 51156 | 61637 | 231 | 9067 | |
205 | 205 | 2021-06-20 | 56 | 37 | 51030 | 61579 | 229 | 9062 | |
206 | 206 | 2021-06-19 | 56 | 37 | 51027 | 61577 | 229 | 9062 | |
209 | 209 | 2021-06-16 | 78 | 37 | 51017 | 61575 | 229 | 9062 | |
221 | 221 | 2021-06-02 | 79 | 37 | 50939 | 61524 | 229 | 9058 | |
187 | 187 | 2021-07-08 | 125 | 38 | 51172 | 61644 | 231 | 9067 | |
191 | 191 | 2021-07-04 | 95 | 38 | 51125 | 61623 | 231 | 9065 | |
220 | 220 | 2021-06-03 | 81 | 38 | 50946 | 61527 | 229 | 9059 | |
235 | 235 | 2021-05-18 | 94 | 38 | 50852 | 61466 | 229 | 9056 | |
237 | 237 | 2021-05-16 | 94 | 38 | 50831 | 61486 | 229 | 9056 | |
199 | 199 | 2021-06-26 | 55 | 39 | 51060 | 61596 | 231 | 9062 | |
223 | 223 | 2021-05-31 | 81 | 40 | 50929 | 61510 | 229 | 9059 | |
224 | 224 | 2021-05-30 | 81 | 40 | 50929 | 61510 | 229 | 9059 | |
233 | 233 | 2021-05-20 | 91 | 40 | 50838 | 61483 | 229 | 9052 | |
234 | 234 | 2021-05-19 | 91 | 40 | 50860 | 61467 | 229 | 9056 | |
214 | 214 | 2021-06-09 | 79 | 41 | 50987 | 61554 | 229 | 9061 | |
236 | 236 | 2021-05-17 | 102 | 42 | 51750 | 61463 | 229 | 9056 | |
238 | 238 | 2021-05-15 | 102 | 42 | 50829 | 61483 | 229 | 9056 | |
189 | 189 | 2021-07-06 | 101 | 43 | 51139 | 61630 | 231 | 9066 | |
229 | 229 | 2021-05-24 | 85 | 43 | 50888 | 61491 | 229 | 9053 | |
230 | 230 | 2021-05-23 | 87 | 43 | 50890 | 61484 | 229 | 9056 | |
211 | 211 | 2021-06-12 | 78 | 44 | 51005 | 61564 | 229 | 9061 | |
213 | 213 | 2021-06-10 | 81 | 45 | 50993 | 61557 | 229 | 9061 | |
239 | 239 | 2021-05-14 | 104 | 45 | 50637 | 61475 | 229 | 9055 | |
194 | 194 | 2021-07-01 | 76 | 46 | 51095 | 61612 | 231 | 9065 | |
254 | 254 | 2021-04-29 | 149 | 46 | 50678 | 61380 | 229 | 9047 | |
210 | 210 | 2021-06-13 | 78 | 47 | 51007 | 61569 | 229 | 9061 | |
184 | 184 | 2021-07-11 | 152 | 49 | 51216 | 61662 | 231 | 9068 | |
212 | 212 | 2021-06-11 | 77 | 49 | 51000 | 61558 | 229 | 9061 | |
248 | 248 | 2021-05-05 | 130 | 50 | 50732 | 61423 | 229 | 9051 | |
198 | 198 | 2021-06-27 | 35 | 52 | 51052 | 61592 | 231 | 9062 | |
186 | 186 | 2021-07-09 | 138 | 53 | 51190 | 61656 | 231 | 9067 | |
252 | 252 | 2021-05-01 | 120 | 53 | 50692 | 61388 | 229 | 9048 | |
246 | 246 | 2021-05-07 | 135 | 54 | 50756 | 61441 | 229 | 9052 | |
253 | 253 | 2021-04-30 | 132 | 54 | 50687 | 61386 | 229 | 9048 | |
242 | 242 | 2021-05-11 | 122 | 56 | 50782 | 61444 | 229 | 9052 | |
255 | 255 | 2021-04-28 | 150 | 56 | 50664 | 61380 | 229 | 9047 | |
183 | 183 | 2021-07-12 | 167 | 58 | 51233 | 61667 | 231 | 9068 | |
256 | 256 | 2021-04-27 | 149 | 58 | 50660 | 61376 | 229 | 9045 | |
247 | 247 | 2021-05-06 | 131 | 60 | 50743 | 61437 | 229 | 9051 | |
241 | 241 | 2021-05-12 | 124 | 61 | 50788 | 61448 | 229 | 9054 | |
179 | 179 | 2021-07-16 | 221 | 62 | 51333 | 61705 | 232 | 9072 | |
243 | 243 | 2021-05-10 | 128 | 62 | 50779 | 61452 | 229 | 9052 | |
244 | 244 | 2021-05-09 | 126 | 62 | 50803 | 61427 | 229 | 9052 | |
240 | 240 | 2021-05-13 | 115 | 63 | 50793 | 61453 | 229 | 9054 | |
250 | 250 | 2021-05-03 | 125 | 63 | 50715 | 61409 | 229 | 9050 | |
251 | 251 | 2021-05-02 | 124 | 63 | 50742 | 61395 | 229 | 9050 | |
182 | 182 | 2021-07-13 | 178 | 64 | 51251 | 61672 | 232 | 9068 | |
249 | 249 | 2021-05-04 | 128 | 64 | 50722 | 61422 | 229 | 9050 | |
177 | 177 | 2021-07-18 | 254 | 68 | 51380 | 61724 | 232 | 9075 | |
185 | 185 | 2021-07-10 | 145 | 68 | 51205 | 61661 | 231 | 9067 | |
245 | 245 | 2021-05-08 | 136 | 69 | 50768 | 61447 | 229 | 9052 | |
257 | 257 | 2021-04-26 | 146 | 69 | 50651 | 61376 | 229 | 9044 | |
174 | 174 | 2021-07-21 | 298 | 70 | 51467 | 61746 | 231 | 9075 | |
176 | 176 | 2021-07-19 | 264 | 70 | 51395 | 61726 | 232 | 9072 | |
181 | 181 | 2021-07-14 | 193 | 73 | 51274 | 61686 | 232 | 9070 | |
178 | 178 | 2021-07-17 | 234 | 74 | 51355 | 61709 | 232 | 9074 | |
258 | 258 | 2021-04-23 | 140 | 79 | 50622 | 61363 | 226 | 9041 | |
180 | 180 | 2021-07-15 | 209 | 80 | 51305 | 61696 | 232 | 9071 | |
175 | 175 | 2021-07-20 | 271 | 85 | 51423 | 61732 | 231 | 9075 | |
265 | 265 | 2021-04-14 | 142 | 89 | 50529 | 61308 | 226 | 9037 | |
259 | 259 | 2021-04-22 | 148 | 91 | 50613 | 61358 | 226 | 9040 | |
171 | 171 | 2021-07-24 | 351 | 94 | 51559 | 61796 | 241 | 9078 | |
172 | 172 | 2021-07-23 | 335 | 94 | 51528 | 61785 | 241 | 9078 | |
173 | 173 | 2021-07-22 | 317 | 94 | 51496 | 61754 | 241 | 9076 | |
260 | 260 | 2021-04-21 | 150 | 94 | 50603 | 61352 | 226 | 9040 | |
261 | 261 | 2021-04-19 | 153 | 95 | 50591 | 61346 | 226 | 9040 | |
266 | 266 | 2021-04-13 | 154 | 102 | 50526 | 61297 | 226 | 9035 | |
168 | 168 | 2021-07-27 | 381 | 103 | 51635 | 61842 | 241 | 9080 | |
170 | 170 | 2021-07-25 | 369 | 103 | 51588 | 61810 | 241 | 9078 | |
262 | 262 | 2021-04-17 | 155 | 104 | 50573 | 61326 | 226 | 9040 | |
264 | 264 | 2021-04-15 | 138 | 104 | 50544 | 61322 | 226 | 9038 | |
263 | 263 | 2021-04-16 | 154 | 105 | 50556 | 61315 | 226 | 9038 | |
169 | 169 | 2021-07-26 | 371 | 112 | 51607 | 61818 | 241 | 9080 | |
167 | 167 | 2021-07-28 | 397 | 121 | 51673 | 61854 | 241 | 9081 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-skilled-nursing-totals" ( [date] TEXT, [staff_active_cases] INTEGER, [patients_active_cases] INTEGER, [staff_confirmed_cases] INTEGER, [patients_confirmed_cases] INTEGER, [staff_deaths] INTEGER, [patients_deaths] INTEGER, [staff_deaths_note] TEXT );