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

1,686 rows where fips = 37 sorted by date descending

✎ View and edit SQL

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

Suggested facets: did_not_update, date (date)

agency 3

fips 1

  • 37 · 1,686 ✖

county 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
20 20 Long Beach Los Angeles 37 2021-09-02 61393 985  
21 21 Los Angeles Los Angeles 37 2021-09-02 1338203 24027  
22 22 Pasadena Los Angeles 37 2021-09-02 12783 354  
81 81 Long Beach Los Angeles 37 2021-09-01 61265 983  
82 82 Los Angeles Los Angeles 37 2021-09-01 1335647 23989  
83 83 Pasadena Los Angeles 37 2021-09-01 12772 354  
142 142 Long Beach Los Angeles 37 2021-08-31 61161 979  
143 143 Los Angeles Los Angeles 37 2021-08-31 1331891 23920  
144 144 Pasadena Los Angeles 37 2021-08-31 12737 354  
203 203 Long Beach Los Angeles 37 2021-08-30 60773 977  
204 204 Los Angeles Los Angeles 37 2021-08-30 1329699 23916 TRUE
205 205 Pasadena Los Angeles 37 2021-08-30 12723 354  
264 264 Long Beach Los Angeles 37 2021-08-29 60683 975 TRUE
265 265 Los Angeles Los Angeles 37 2021-08-29 1329699 23916  
266 266 Pasadena Los Angeles 37 2021-08-29 12671 354 TRUE
325 325 Long Beach Los Angeles 37 2021-08-28 60683 975 TRUE
326 326 Los Angeles Los Angeles 37 2021-08-28 1327483 23911  
327 327 Pasadena Los Angeles 37 2021-08-28 12671 354 TRUE
386 386 Long Beach Los Angeles 37 2021-08-27 60683 975  
387 387 Los Angeles Los Angeles 37 2021-08-27 1324126 23885  
388 388 Pasadena Los Angeles 37 2021-08-27 12671 354  
447 447 Long Beach Los Angeles 37 2021-08-26 60464 972  
448 448 Los Angeles Los Angeles 37 2021-08-26 1321522 23856  
449 449 Pasadena Los Angeles 37 2021-08-26 12646 354  
508 508 Long Beach Los Angeles 37 2021-08-25 60343 971  
509 509 Los Angeles Los Angeles 37 2021-08-25 1318547 23827  
510 510 Pasadena Los Angeles 37 2021-08-25 12623 354  
569 569 Long Beach Los Angeles 37 2021-08-24 60215 969  
570 570 Los Angeles Los Angeles 37 2021-08-24 1315856 23794  
571 571 Pasadena Los Angeles 37 2021-08-24 12601 354  
630 630 Long Beach Los Angeles 37 2021-08-23 59716 966  
631 631 Los Angeles Los Angeles 37 2021-08-23 1313497 23761  
632 632 Pasadena Los Angeles 37 2021-08-23 12571 354  
691 691 Long Beach Los Angeles 37 2021-08-22 59520 963 TRUE
692 692 Los Angeles Los Angeles 37 2021-08-22 1311178 23754  
693 693 Pasadena Los Angeles 37 2021-08-22 12488 354 TRUE
752 752 Long Beach Los Angeles 37 2021-08-21 59520 963 TRUE
753 753 Los Angeles Los Angeles 37 2021-08-21 1308407 23744  
754 754 Pasadena Los Angeles 37 2021-08-21 12488 354 TRUE
813 813 Long Beach Los Angeles 37 2021-08-20 59520 963  
814 814 Los Angeles Los Angeles 37 2021-08-20 1304670 23716  
815 815 Pasadena Los Angeles 37 2021-08-20 12488 354  
874 874 Long Beach Los Angeles 37 2021-08-19 59425 962  
875 875 Los Angeles Los Angeles 37 2021-08-19 1291124 23687  
876 876 Pasadena Los Angeles 37 2021-08-19 12456 354  
935 935 Long Beach Los Angeles 37 2021-08-18 59289 961  
936 936 Los Angeles Los Angeles 37 2021-08-18 1288173 23652  
937 937 Pasadena Los Angeles 37 2021-08-18 12435 354  
996 996 Long Beach Los Angeles 37 2021-08-17 59092 961  
997 997 Los Angeles Los Angeles 37 2021-08-17 1284750 23620  
998 998 Pasadena Los Angeles 37 2021-08-17 12407 354  
1057 1057 Long Beach Los Angeles 37 2021-08-16 58577 961  
1058 1058 Los Angeles Los Angeles 37 2021-08-16 1282123 23591  
1059 1059 Pasadena Los Angeles 37 2021-08-16 12371 354  
1118 1118 Long Beach Los Angeles 37 2021-08-15 58396 960 TRUE
1119 1119 Los Angeles Los Angeles 37 2021-08-15 1279702 23586  
1120 1120 Pasadena Los Angeles 37 2021-08-15 12272 354 TRUE
1179 1179 Long Beach Los Angeles 37 2021-08-14 58396 960 TRUE
1180 1180 Los Angeles Los Angeles 37 2021-08-14 1276355 23578  
1181 1181 Pasadena Los Angeles 37 2021-08-14 12272 354 TRUE
1240 1240 Long Beach Los Angeles 37 2021-08-13 58396 960 TRUE
1241 1241 Los Angeles Los Angeles 37 2021-08-13 1272418 23559  
1242 1242 Pasadena Los Angeles 37 2021-08-13 12272 354  
1301 1301 Long Beach Los Angeles 37 2021-08-12 58175 960  
1302 1302 Los Angeles Los Angeles 37 2021-08-12 1268875 23543  
1303 1303 Pasadena Los Angeles 37 2021-08-12 12246 353  
1362 1362 Long Beach Los Angeles 37 2021-08-11 58067 958  
1363 1363 Los Angeles Los Angeles 37 2021-08-11 1265287 23523  
1364 1364 Pasadena Los Angeles 37 2021-08-11 12196 353  
1423 1423 Long Beach Los Angeles 37 2021-08-10 57876 957  
1424 1424 Los Angeles Los Angeles 37 2021-08-10 1262244 23496  
1425 1425 Pasadena Los Angeles 37 2021-08-10 12169 353  
1484 1484 Long Beach Los Angeles 37 2021-08-09 57458 956  
1485 1485 Los Angeles Los Angeles 37 2021-08-09 1259922 23474  
1486 1486 Pasadena Los Angeles 37 2021-08-09 12157 353  
1545 1545 Long Beach Los Angeles 37 2021-08-08 57263 956 TRUE
1546 1546 Los Angeles Los Angeles 37 2021-08-08 1257021 23468  
1547 1547 Pasadena Los Angeles 37 2021-08-08 12077 353 TRUE
1606 1606 Long Beach Los Angeles 37 2021-08-07 57263 956 TRUE
1607 1607 Los Angeles Los Angeles 37 2021-08-07 1254005 23460  
1608 1608 Pasadena Los Angeles 37 2021-08-07 12077 353 TRUE
1667 1667 Long Beach Los Angeles 37 2021-08-06 57263 956  
1668 1668 Los Angeles Los Angeles 37 2021-08-06 1250152 23447  
1669 1669 Pasadena Los Angeles 37 2021-08-06 12077 353  
1728 1728 Long Beach Los Angeles 37 2021-08-05 57016 956  
1729 1729 Los Angeles Los Angeles 37 2021-08-05 1246613 23431  
1730 1730 Pasadena Los Angeles 37 2021-08-05 12048 353  
1789 1789 Long Beach Los Angeles 37 2021-08-04 56696 955  
1790 1790 Los Angeles Los Angeles 37 2021-08-04 1243063 23415  
1791 1791 Pasadena Los Angeles 37 2021-08-04 12004 353  
1850 1850 Long Beach Los Angeles 37 2021-08-03 56191 953  
1851 1851 Los Angeles Los Angeles 37 2021-08-03 1239833 23399  
1852 1852 Pasadena Los Angeles 37 2021-08-03 11946 352  
1911 1911 Long Beach Los Angeles 37 2021-08-02 56191 953  
1912 1912 Los Angeles Los Angeles 37 2021-08-02 1237942 23385  
1913 1913 Pasadena Los Angeles 37 2021-08-02 11946 352  
1972 1972 Long Beach Los Angeles 37 2021-08-01 55885 953 TRUE
1973 1973 Los Angeles Los Angeles 37 2021-08-01 1235581 23380  
1974 1974 Pasadena Los Angeles 37 2021-08-01 11877 352 TRUE
2033 2033 Long Beach Los Angeles 37 2021-07-31 55885 953  

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
);