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)
Suggested facets: date (date)
Link | rowid | date | people_housed | leased_rooms | rooms_ready_to_occupy | rooms_occupied | homeless_confirmed_cases ▼ |
---|---|---|---|---|---|---|---|
428 | 428 | 2020-04-26 | 1141 | 2506 | 1547 | 999 | 100 |
429 | 429 | 2020-04-25 | 1141 | 2506 | 1547 | 999 | 100 |
430 | 430 | 2020-04-24 | 1141 | 2506 | 1547 | 999 | 100 |
427 | 427 | 2020-04-27 | 1238 | 2481 | 1547 | 1102 | 118 |
426 | 426 | 2020-04-28 | 1293 | 2206 | 1714 | 1145 | 128 |
425 | 425 | 2020-04-29 | 1351 | 2206 | 1766 | 1204 | 164 |
421 | 421 | 2020-05-03 | 1674 | 2711 | 1801 | 1500 | 184 |
422 | 422 | 2020-05-02 | 1674 | 2711 | 1801 | 1500 | 184 |
423 | 423 | 2020-05-01 | 1619 | 2206 | 1801 | 1445 | 184 |
420 | 420 | 2020-05-04 | 1708 | 2711 | 1801 | 1517 | 196 |
419 | 419 | 2020-05-05 | 1785 | 2709 | 1799 | 1582 | 199 |
418 | 418 | 2020-05-06 | 1846 | 3101 | 1799 | 1630 | 204 |
417 | 417 | 2020-05-07 | 1904 | 3101 | 1799 | 1672 | 215 |
414 | 414 | 2020-05-10 | 1915 | 3103 | 2011 | 1677 | 223 |
415 | 415 | 2020-05-09 | 1915 | 3103 | 2011 | 1677 | 223 |
416 | 416 | 2020-05-08 | 1915 | 3101 | 2009 | 1677 | 223 |
413 | 413 | 2020-05-11 | 1978 | 3103 | 2011 | 1741 | 234 |
412 | 412 | 2020-05-12 | 1990 | 3103 | 2478 | 1753 | 243 |
411 | 411 | 2020-05-13 | 2030 | 3103 | 2478 | 1790 | 257 |
407 | 407 | 2020-05-17 | 2095 | 3245 | 2728 | 1850 | 261 |
408 | 408 | 2020-05-16 | 2095 | 3245 | 2728 | 1850 | 261 |
409 | 409 | 2020-05-15 | 2095 | 3245 | 2728 | 1850 | 261 |
410 | 410 | 2020-05-14 | 2095 | 3142 | 2728 | 1850 | 261 |
406 | 406 | 2020-05-18 | 2371 | 3245 | 2884 | 2102 | 295 |
405 | 405 | 2020-05-19 | 2423 | 3337 | 2884 | 2149 | 300 |
404 | 404 | 2020-05-20 | 2467 | 3514 | 3071 | 2178 | 314 |
403 | 403 | 2020-05-21 | 2604 | 3514 | 3071 | 2301 | 323 |
399 | 399 | 2020-05-25 | 2684 | 3514 | 3368 | 2390 | 326 |
400 | 400 | 2020-05-24 | 2684 | 3514 | 3368 | 2390 | 326 |
401 | 401 | 2020-05-23 | 2684 | 3514 | 3368 | 2390 | 326 |
402 | 402 | 2020-05-22 | 2684 | 3514 | 3248 | 2390 | 326 |
398 | 398 | 2020-05-26 | 2967 | 3514 | 3407 | 2646 | 347 |
397 | 397 | 2020-05-27 | 3064 | 3514 | 3407 | 2714 | 368 |
396 | 396 | 2020-05-28 | 3124 | 3514 | 3510 | 2826 | 376 |
393 | 393 | 2020-05-31 | 3229 | 3510 | 3510 | 2910 | 393 |
394 | 394 | 2020-05-30 | 3229 | 3510 | 3510 | 2910 | 393 |
395 | 395 | 2020-05-29 | 3229 | 3514 | 3510 | 2910 | 393 |
392 | 392 | 2020-06-01 | 3340 | 3510 | 3510 | 3034 | 411 |
391 | 391 | 2020-06-02 | 3512 | 3510 | 3510 | 3119 | 418 |
390 | 390 | 2020-06-03 | 3580 | 3601 | 3601 | 3170 | 426 |
389 | 389 | 2020-06-04 | 3559 | 3601 | 3601 | 3215 | 433 |
386 | 386 | 2020-06-07 | 3609 | 3601 | 3601 | 3230 | 447 |
387 | 387 | 2020-06-06 | 3609 | 3601 | 3601 | 3230 | 447 |
388 | 388 | 2020-06-05 | 3609 | 3601 | 3601 | 3230 | 447 |
385 | 385 | 2020-06-08 | 3693 | 3601 | 3601 | 3288 | 462 |
384 | 384 | 2020-06-09 | 3690 | 3601 | 3601 | 3277 | 470 |
383 | 383 | 2020-06-10 | 3696 | 3601 | 3601 | 3299 | 476 |
382 | 382 | 2020-06-11 | 3739 | 3601 | 3601 | 3320 | 482 |
379 | 379 | 2020-06-14 | 3767 | 3601 | 3601 | 3345 | 488 |
380 | 380 | 2020-06-13 | 3767 | 3601 | 3601 | 3345 | 488 |
381 | 381 | 2020-06-12 | 3767 | 3601 | 3601 | 3345 | 488 |
378 | 378 | 2020-06-15 | 3766 | 3601 | 3601 | 3367 | 506 |
377 | 377 | 2020-06-16 | 3756 | 3601 | 3601 | 3357 | 513 |
376 | 376 | 2020-06-17 | 3740 | 3601 | 3601 | 3369 | 520 |
375 | 375 | 2020-06-18 | 3771 | 3601 | 3601 | 3379 | 535 |
372 | 372 | 2020-06-21 | 3759 | 3601 | 3601 | 3375 | 548 |
373 | 373 | 2020-06-20 | 3759 | 3601 | 3601 | 3375 | 548 |
374 | 374 | 2020-06-19 | 3759 | 3601 | 3601 | 3375 | 548 |
371 | 371 | 2020-06-22 | 3736 | 3601 | 3601 | 3358 | 571 |
370 | 370 | 2020-06-23 | 3734 | 3601 | 3601 | 3352 | 582 |
369 | 369 | 2020-06-24 | 3743 | 3601 | 3601 | 3350 | 595 |
368 | 368 | 2020-06-25 | 3755 | 3601 | 3601 | 3356 | 613 |
365 | 365 | 2020-06-28 | 3755 | 3601 | 3601 | 3356 | 620 |
366 | 366 | 2020-06-27 | 3755 | 3601 | 3601 | 3356 | 620 |
367 | 367 | 2020-06-26 | 3803 | 3601 | 3601 | 3356 | 620 |
364 | 364 | 2020-06-29 | 3781 | 3601 | 3601 | 3342 | 660 |
363 | 363 | 2020-06-30 | 3790 | 3601 | 3601 | 3341 | 672 |
362 | 362 | 2020-07-01 | 3815 | 3601 | 3601 | 3355 | 682 |
358 | 358 | 2020-07-05 | 3779 | 3601 | 3601 | 3328 | 696 |
359 | 359 | 2020-07-04 | 3779 | 3601 | 3601 | 3328 | 696 |
360 | 360 | 2020-07-03 | 3779 | 3601 | 3601 | 3328 | 696 |
361 | 361 | 2020-07-02 | 3779 | 3601 | 3601 | 3328 | 696 |
357 | 357 | 2020-07-06 | 3682 | 3601 | 3601 | 3310 | 732 |
356 | 356 | 2020-07-07 | 3671 | 3601 | 3601 | 3302 | 745 |
355 | 355 | 2020-07-08 | 3687 | 3601 | 3601 | 3303 | 759 |
354 | 354 | 2020-07-09 | 3716 | 3601 | 3601 | 3312 | 762 |
351 | 351 | 2020-07-12 | 3684 | 3626 | 3626 | 3317 | 774 |
352 | 352 | 2020-07-11 | 3684 | 3626 | 3626 | 3317 | 774 |
353 | 353 | 2020-07-10 | 3684 | 3601 | 3601 | 3317 | 774 |
350 | 350 | 2020-07-13 | 3726 | 3626 | 3626 | 3354 | 807 |
349 | 349 | 2020-07-14 | 3728 | 3920 | 3626 | 3347 | 817 |
348 | 348 | 2020-07-15 | 3821 | 3930 | 3930 | 3379 | 833 |
347 | 347 | 2020-07-16 | 3820 | 3930 | 3930 | 3407 | 872 |
344 | 344 | 2020-07-19 | 3853 | 3930 | 3930 | 3424 | 883 |
345 | 345 | 2020-07-18 | 3853 | 3930 | 3930 | 3424 | 883 |
346 | 346 | 2020-07-17 | 3853 | 3930 | 3930 | 3424 | 883 |
343 | 343 | 2020-07-20 | 3918 | 3930 | 3930 | 3468 | 916 |
342 | 342 | 2020-07-21 | 3897 | 3930 | 3930 | 3456 | 932 |
341 | 341 | 2020-07-22 | 3927 | 3930 | 3930 | 3485 | 942 |
337 | 337 | 2020-07-26 | 3969 | 4027 | 4027 | 3518 | 955 |
338 | 338 | 2020-07-25 | 3969 | 4027 | 4027 | 3518 | 955 |
339 | 339 | 2020-07-24 | 3969 | 4027 | 4027 | 3518 | 955 |
340 | 340 | 2020-07-23 | 3975 | 4027 | 4027 | 3498 | 955 |
336 | 336 | 2020-07-27 | 3990 | 4027 | 4027 | 3538 | 989 |
335 | 335 | 2020-07-28 | 4005 | 4027 | 4027 | 3562 | 1016 |
334 | 334 | 2020-07-29 | 4053 | 4027 | 4027 | 3603 | 1029 |
333 | 333 | 2020-07-30 | 4091 | 4027 | 4027 | 3630 | 1050 |
330 | 330 | 2020-08-02 | 4086 | 4027 | 4027 | 3646 | 1079 |
331 | 331 | 2020-08-01 | 4086 | 4027 | 4027 | 3646 | 1079 |
332 | 332 | 2020-07-31 | 4086 | 4027 | 4027 | 3646 | 1079 |
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 );