latimes-project-roomkey-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- date
- The date on which data were reported in ISO 8601 format.
- people_housed
- The current number of homeless people in Los Angeles County housed on this date.
- leased_rooms
- The current number hotel rooms leased on this date.
- rooms_ready_to_occupy
- The subset of leased rooms that were ready to occupy on this date.
- rooms_occupied
- The subset of ready rooms that were occupied on this date.
- homeless_confirmed_cases
- The cumulative number of homeless people in Los Angeles County that had tested positive by this date.
452 rows sorted by homeless_confirmed_cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | people_housed | leased_rooms | rooms_ready_to_occupy | rooms_occupied | homeless_confirmed_cases ▼ |
---|---|---|---|---|---|---|---|
329 | 329 | 2020-08-03 | 4073 | 4027 | 4027 | 3638 | 1127 |
328 | 328 | 2020-08-04 | 4027 | 4177 | 4027 | 3638 | 1151 |
327 | 327 | 2020-08-05 | 4053 | 4177 | 4027 | 3650 | 1156 |
326 | 326 | 2020-08-06 | 4134 | 4177 | 4027 | 3649 | 1170 |
325 | 325 | 2020-08-07 | 4141 | 4177 | 4027 | 3650 | 1203 |
323 | 323 | 2020-08-09 | 4141 | 4177 | 4027 | 3650 | 1216 |
324 | 324 | 2020-08-08 | 4141 | 4177 | 4027 | 3650 | 1216 |
322 | 322 | 2020-08-10 | 4128 | 4177 | 4027 | 3622 | 1246 |
321 | 321 | 2020-08-11 | 4122 | 4177 | 4027 | 3611 | 1260 |
320 | 320 | 2020-08-12 | 4153 | 4177 | 4027 | 3643 | 1278 |
319 | 319 | 2020-08-13 | 4131 | 4177 | 4177 | 3699 | 1282 |
316 | 316 | 2020-08-16 | 4254 | 4177 | 4177 | 3725 | 1283 |
317 | 317 | 2020-08-15 | 4254 | 4177 | 4177 | 3725 | 1283 |
318 | 318 | 2020-08-14 | 4254 | 4177 | 4177 | 3725 | 1283 |
315 | 315 | 2020-08-17 | 4275 | 4177 | 4177 | 3737 | 1348 |
314 | 314 | 2020-08-18 | 4304 | 4177 | 4177 | 3765 | 1360 |
313 | 313 | 2020-08-19 | 4266 | 4177 | 4177 | 3764 | 1380 |
312 | 312 | 2020-08-20 | 4329 | 4177 | 4177 | 3774 | 1388 |
309 | 309 | 2020-08-23 | 4320 | 4177 | 4177 | 3779 | 1402 |
310 | 310 | 2020-08-22 | 4320 | 4177 | 4177 | 3779 | 1402 |
311 | 311 | 2020-08-21 | 4320 | 4177 | 4177 | 3779 | 1402 |
308 | 308 | 2020-08-24 | 4301 | 4177 | 4177 | 3763 | 1498 |
307 | 307 | 2020-08-25 | 4305 | 4177 | 4177 | 3755 | 1528 |
306 | 306 | 2020-08-26 | 4319 | 4177 | 4177 | 3753 | 1546 |
305 | 305 | 2020-08-27 | 4328 | 4177 | 4177 | 3750 | 1553 |
302 | 302 | 2020-08-30 | 4282 | 4117 | 4117 | 3723 | 1564 |
303 | 303 | 2020-08-29 | 4282 | 4117 | 4117 | 3723 | 1564 |
304 | 304 | 2020-08-28 | 4282 | 4117 | 4117 | 3723 | 1564 |
301 | 301 | 2020-08-31 | 4309 | 4117 | 4117 | 3732 | 1583 |
294 | 294 | 2020-09-07 | 4308 | 4117 | 4117 | 3724 | 1589 |
295 | 295 | 2020-09-06 | 4308 | 4117 | 4117 | 3724 | 1589 |
296 | 296 | 2020-09-05 | 4308 | 4117 | 4117 | 3724 | 1589 |
297 | 297 | 2020-09-04 | 4308 | 4117 | 4117 | 3724 | 1589 |
298 | 298 | 2020-09-03 | 4321 | 4117 | 4117 | 3733 | 1589 |
299 | 299 | 2020-09-02 | 4286 | 4117 | 4117 | 3738 | 1589 |
300 | 300 | 2020-09-01 | 4318 | 4117 | 4117 | 3728 | 1589 |
287 | 287 | 2020-09-14 | 4206 | 4117 | 4117 | 3623 | 1656 |
288 | 288 | 2020-09-13 | 4177 | 4117 | 4117 | 3630 | 1656 |
289 | 289 | 2020-09-12 | 4177 | 4117 | 4117 | 3630 | 1656 |
290 | 290 | 2020-09-11 | 4177 | 4117 | 4117 | 3630 | 1656 |
291 | 291 | 2020-09-10 | 4240 | 4117 | 4117 | 3673 | 1656 |
292 | 292 | 2020-09-09 | 4232 | 4117 | 4117 | 3647 | 1656 |
293 | 293 | 2020-09-08 | 4221 | 4117 | 4117 | 3654 | 1656 |
280 | 280 | 2020-09-21 | 4027 | 4030 | 4030 | 3527 | 1698 |
281 | 281 | 2020-09-20 | 4059 | 4030 | 4030 | 3551 | 1698 |
282 | 282 | 2020-09-19 | 4059 | 4030 | 4030 | 3551 | 1698 |
283 | 283 | 2020-09-18 | 4059 | 4030 | 4030 | 3551 | 1698 |
284 | 284 | 2020-09-17 | 4072 | 4030 | 4030 | 3563 | 1698 |
285 | 285 | 2020-09-16 | 4066 | 4030 | 4030 | 3566 | 1698 |
286 | 286 | 2020-09-15 | 4045 | 4117 | 4117 | 3575 | 1698 |
273 | 273 | 2020-09-28 | 4060 | 3852 | 3852 | 3480 | 1742 |
274 | 274 | 2020-09-27 | 4003 | 3901 | 3901 | 3519 | 1742 |
275 | 275 | 2020-09-26 | 4003 | 3901 | 3901 | 3519 | 1742 |
276 | 276 | 2020-09-25 | 4003 | 3901 | 3901 | 3519 | 1742 |
277 | 277 | 2020-09-24 | 4032 | 3901 | 3901 | 3530 | 1742 |
278 | 278 | 2020-09-23 | 4015 | 3901 | 3901 | 3517 | 1742 |
279 | 279 | 2020-09-22 | 4027 | 4030 | 4030 | 3541 | 1742 |
266 | 266 | 2020-10-05 | 3828 | 3852 | 3852 | 3377 | 1802 |
267 | 267 | 2020-10-04 | 3875 | 3852 | 3852 | 3373 | 1802 |
268 | 268 | 2020-10-03 | 3875 | 3852 | 3852 | 3373 | 1802 |
269 | 269 | 2020-10-02 | 3875 | 3852 | 3852 | 3373 | 1802 |
270 | 270 | 2020-10-01 | 3889 | 3852 | 3852 | 3390 | 1802 |
271 | 271 | 2020-09-30 | 3973 | 3852 | 3852 | 3468 | 1802 |
272 | 272 | 2020-09-29 | 3975 | 3852 | 3852 | 3484 | 1802 |
259 | 259 | 2020-10-12 | 3818 | 3572 | 3572 | 3312 | 1846 |
260 | 260 | 2020-10-11 | 3818 | 3572 | 3572 | 3312 | 1846 |
261 | 261 | 2020-10-10 | 3818 | 3572 | 3572 | 3312 | 1846 |
262 | 262 | 2020-10-09 | 3818 | 3572 | 3572 | 3312 | 1846 |
263 | 263 | 2020-10-08 | 3818 | 3572 | 3572 | 3310 | 1846 |
264 | 264 | 2020-10-07 | 3814 | 3572 | 3572 | 3317 | 1846 |
265 | 265 | 2020-10-06 | 3839 | 3669 | 3669 | 3340 | 1846 |
252 | 252 | 2020-10-19 | 3856 | 3572 | 3572 | 3251 | 1889 |
253 | 253 | 2020-10-18 | 3789 | 3572 | 3572 | 3283 | 1889 |
254 | 254 | 2020-10-17 | 3789 | 3572 | 3572 | 3283 | 1889 |
255 | 255 | 2020-10-16 | 3789 | 3572 | 3572 | 3283 | 1889 |
256 | 256 | 2020-10-15 | 3804 | 3572 | 3572 | 3285 | 1889 |
257 | 257 | 2020-10-14 | 3819 | 3572 | 3572 | 3296 | 1889 |
258 | 258 | 2020-10-13 | 3812 | 3572 | 3572 | 3292 | 1889 |
245 | 245 | 2020-10-26 | 3808 | 3485 | 3485 | 3180 | 1979 |
246 | 246 | 2020-10-25 | 3681 | 3572 | 3572 | 3222 | 1979 |
247 | 247 | 2020-10-24 | 3681 | 3572 | 3572 | 3222 | 1979 |
248 | 248 | 2020-10-23 | 3681 | 3572 | 3572 | 3222 | 1979 |
249 | 249 | 2020-10-22 | 3734 | 3572 | 3572 | 3240 | 1979 |
250 | 250 | 2020-10-21 | 3733 | 3572 | 3572 | 3246 | 1979 |
251 | 251 | 2020-10-20 | 3767 | 3572 | 3572 | 3247 | 1979 |
238 | 238 | 2020-11-02 | 3631 | 3485 | 3485 | 3178 | 2048 |
239 | 239 | 2020-11-01 | 3639 | 3485 | 3485 | 3192 | 2048 |
240 | 240 | 2020-10-31 | 3639 | 3485 | 3485 | 3192 | 2048 |
241 | 241 | 2020-10-30 | 3639 | 3485 | 3485 | 3192 | 2048 |
242 | 242 | 2020-10-29 | 3645 | 3485 | 3485 | 3192 | 2048 |
243 | 243 | 2020-10-28 | 3637 | 3485 | 3485 | 3187 | 2048 |
244 | 244 | 2020-10-27 | 3615 | 3485 | 3485 | 3185 | 2048 |
231 | 231 | 2020-11-09 | 3570 | 3485 | 3485 | 3113 | 2086 |
232 | 232 | 2020-11-08 | 3592 | 3485 | 3485 | 3147 | 2086 |
233 | 233 | 2020-11-07 | 3592 | 3485 | 3485 | 3147 | 2086 |
234 | 234 | 2020-11-06 | 3592 | 3485 | 3485 | 3147 | 2086 |
235 | 235 | 2020-11-05 | 3620 | 3485 | 3485 | 3172 | 2086 |
236 | 236 | 2020-11-04 | 3611 | 3485 | 3485 | 3168 | 2086 |
237 | 237 | 2020-11-03 | 3621 | 3485 | 3485 | 3177 | 2086 |
226 | 226 | 2020-11-16 | 3462 | 3295 | 3295 | 3017 | 2146 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "latimes-project-roomkey-totals" ( [date] TEXT, [people_housed] INTEGER, [leased_rooms] INTEGER, [rooms_ready_to_occupy] INTEGER, [rooms_occupied] INTEGER, [homeless_confirmed_cases] INTEGER );