latimes_agency_totals

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals

559 rows where agency = "Long Beach" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: did_not_update, date (date)

fips 1

county 1

agency 1

  • Long Beach · 559 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
20 20 Long Beach Los Angeles 37 2021-09-02 61393 985  
81 81 Long Beach Los Angeles 37 2021-09-01 61265 983  
142 142 Long Beach Los Angeles 37 2021-08-31 61161 979  
203 203 Long Beach Los Angeles 37 2021-08-30 60773 977  
264 264 Long Beach Los Angeles 37 2021-08-29 60683 975 TRUE
325 325 Long Beach Los Angeles 37 2021-08-28 60683 975 TRUE
386 386 Long Beach Los Angeles 37 2021-08-27 60683 975  
447 447 Long Beach Los Angeles 37 2021-08-26 60464 972  
508 508 Long Beach Los Angeles 37 2021-08-25 60343 971  
569 569 Long Beach Los Angeles 37 2021-08-24 60215 969  
630 630 Long Beach Los Angeles 37 2021-08-23 59716 966  
691 691 Long Beach Los Angeles 37 2021-08-22 59520 963 TRUE
752 752 Long Beach Los Angeles 37 2021-08-21 59520 963 TRUE
813 813 Long Beach Los Angeles 37 2021-08-20 59520 963  
874 874 Long Beach Los Angeles 37 2021-08-19 59425 962  
935 935 Long Beach Los Angeles 37 2021-08-18 59289 961  
996 996 Long Beach Los Angeles 37 2021-08-17 59092 961  
1057 1057 Long Beach Los Angeles 37 2021-08-16 58577 961  
1118 1118 Long Beach Los Angeles 37 2021-08-15 58396 960 TRUE
1179 1179 Long Beach Los Angeles 37 2021-08-14 58396 960 TRUE
1240 1240 Long Beach Los Angeles 37 2021-08-13 58396 960 TRUE
1301 1301 Long Beach Los Angeles 37 2021-08-12 58175 960  
1362 1362 Long Beach Los Angeles 37 2021-08-11 58067 958  
1423 1423 Long Beach Los Angeles 37 2021-08-10 57876 957  
1484 1484 Long Beach Los Angeles 37 2021-08-09 57458 956  
1545 1545 Long Beach Los Angeles 37 2021-08-08 57263 956 TRUE
1606 1606 Long Beach Los Angeles 37 2021-08-07 57263 956 TRUE
1667 1667 Long Beach Los Angeles 37 2021-08-06 57263 956  
1728 1728 Long Beach Los Angeles 37 2021-08-05 57016 956  
1789 1789 Long Beach Los Angeles 37 2021-08-04 56696 955  
1850 1850 Long Beach Los Angeles 37 2021-08-03 56191 953  
1911 1911 Long Beach Los Angeles 37 2021-08-02 56191 953  
1972 1972 Long Beach Los Angeles 37 2021-08-01 55885 953 TRUE
2033 2033 Long Beach Los Angeles 37 2021-07-31 55885 953  
2094 2094 Long Beach Los Angeles 37 2021-07-30 55739 953  
2155 2155 Long Beach Los Angeles 37 2021-07-29 55739 953  
2216 2216 Long Beach Los Angeles 37 2021-07-28 55643 951  
2277 2277 Long Beach Los Angeles 37 2021-07-27 55503 951  
2338 2338 Long Beach Los Angeles 37 2021-07-26 55244 951  
2399 2399 Long Beach Los Angeles 37 2021-07-25 55133 951 TRUE
2460 2460 Long Beach Los Angeles 37 2021-07-24 55133 951 TRUE
2521 2521 Long Beach Los Angeles 37 2021-07-23 55133 951  
2582 2582 Long Beach Los Angeles 37 2021-07-22 55028 950  
2643 2643 Long Beach Los Angeles 37 2021-07-21 54890 949  
2704 2704 Long Beach Los Angeles 37 2021-07-20 54750 949  
2765 2765 Long Beach Los Angeles 37 2021-07-19 54471 948  
2826 2826 Long Beach Los Angeles 37 2021-07-18 54395 948 TRUE
2887 2887 Long Beach Los Angeles 37 2021-07-17 54395 948 TRUE
2948 2948 Long Beach Los Angeles 37 2021-07-16 54395 948  
3009 3009 Long Beach Los Angeles 37 2021-07-15 54294 948  
3070 3070 Long Beach Los Angeles 37 2021-07-14 54201 947  
3131 3131 Long Beach Los Angeles 37 2021-07-13 54105 947  
3192 3192 Long Beach Los Angeles 37 2021-07-12 53885 947 TRUE
3253 3253 Long Beach Los Angeles 37 2021-07-11 53885 947  
3314 3314 Long Beach Los Angeles 37 2021-07-10 53843 947 TRUE
3375 3375 Long Beach Los Angeles 37 2021-07-09 53843 947  
3436 3436 Long Beach Los Angeles 37 2021-07-08 53843 947  
3497 3497 Long Beach Los Angeles 37 2021-07-07 53811 945  
3558 3558 Long Beach Los Angeles 37 2021-07-06 53734 945  
3619 3619 Long Beach Los Angeles 37 2021-07-05 53709 945 TRUE
3680 3680 Long Beach Los Angeles 37 2021-07-04 53709 945 TRUE
3741 3741 Long Beach Los Angeles 37 2021-07-03 53709 945 TRUE
3802 3802 Long Beach Los Angeles 37 2021-07-02 53709 945  
3863 3863 Long Beach Los Angeles 37 2021-07-01 53692 945  
3924 3924 Long Beach Los Angeles 37 2021-06-30 53650 945 TRUE
3985 3985 Long Beach Los Angeles 37 2021-06-29 53650 945  
4046 4046 Long Beach Los Angeles 37 2021-06-28 53612 945  
4107 4107 Long Beach Los Angeles 37 2021-06-27 53607 945 TRUE
4168 4168 Long Beach Los Angeles 37 2021-06-26 53607 945 TRUE
4229 4229 Long Beach Los Angeles 37 2021-06-25 53607 945  
4290 4290 Long Beach Los Angeles 37 2021-06-24 53564 947 TRUE
4351 4351 Long Beach Los Angeles 37 2021-06-23 53564 947  
4412 4412 Long Beach Los Angeles 37 2021-06-22 53533 945  
4473 4473 Long Beach Los Angeles 37 2021-06-21 53525 945 TRUE
4534 4534 Long Beach Los Angeles 37 2021-06-20 53525 945 TRUE
4595 4595 Long Beach Los Angeles 37 2021-06-19 53525 945  
4656 4656 Long Beach Los Angeles 37 2021-06-18 53515 945 TRUE
4717 4717 Long Beach Los Angeles 37 2021-06-17 53515 945 TRUE
4778 4778 Long Beach Los Angeles 37 2021-06-16 53515 945  
4839 4839 Long Beach Los Angeles 37 2021-06-15 53505 944  
4900 4900 Long Beach Los Angeles 37 2021-06-14 53476 942  
4961 4961 Long Beach Los Angeles 37 2021-06-13 53476 942 TRUE
5022 5022 Long Beach Los Angeles 37 2021-06-12 53476 942  
5083 5083 Long Beach Los Angeles 37 2021-06-11 53476 942  
5144 5144 Long Beach Los Angeles 37 2021-06-10 53482 942  
5205 5205 Long Beach Los Angeles 37 2021-06-09 53468 942  
5266 5266 Long Beach Los Angeles 37 2021-06-08 53465 941  
5327 5327 Long Beach Los Angeles 37 2021-06-07 53450 941  
5388 5388 Long Beach Los Angeles 37 2021-06-06 53437 941 TRUE
5449 5449 Long Beach Los Angeles 37 2021-06-05 53437 941 TRUE
5510 5510 Long Beach Los Angeles 37 2021-06-04 53437 941  
5571 5571 Long Beach Los Angeles 37 2021-06-03 53416 940  
5632 5632 Long Beach Los Angeles 37 2021-06-02 53403 939  
5693 5693 Long Beach Los Angeles 37 2021-06-01 53383 939  
5754 5754 Long Beach Los Angeles 37 2021-05-31 53378 939 TRUE
5815 5815 Long Beach Los Angeles 37 2021-05-30 53378 939  
5876 5876 Long Beach Los Angeles 37 2021-05-29 53378 939 TRUE
5937 5937 Long Beach Los Angeles 37 2021-05-28 53378 939  
5998 5998 Long Beach Los Angeles 37 2021-05-27 53369 939  
6059 6059 Long Beach Los Angeles 37 2021-05-26 53353 938  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_agency_totals] (
   [agency] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [date] TEXT,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [did_not_update] TEXT
);