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

586 rows where agency = "Los Angeles", county = "Los Angeles" and 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)

fips 1

  • 37 · 586 ✖

county 1

  • Los Angeles · 586 ✖

agency 1

  • Los Angeles · 586 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
21 21 Los Angeles Los Angeles 37 2021-09-02 1338203 24027  
82 82 Los Angeles Los Angeles 37 2021-09-01 1335647 23989  
143 143 Los Angeles Los Angeles 37 2021-08-31 1331891 23920  
204 204 Los Angeles Los Angeles 37 2021-08-30 1329699 23916 TRUE
265 265 Los Angeles Los Angeles 37 2021-08-29 1329699 23916  
326 326 Los Angeles Los Angeles 37 2021-08-28 1327483 23911  
387 387 Los Angeles Los Angeles 37 2021-08-27 1324126 23885  
448 448 Los Angeles Los Angeles 37 2021-08-26 1321522 23856  
509 509 Los Angeles Los Angeles 37 2021-08-25 1318547 23827  
570 570 Los Angeles Los Angeles 37 2021-08-24 1315856 23794  
631 631 Los Angeles Los Angeles 37 2021-08-23 1313497 23761  
692 692 Los Angeles Los Angeles 37 2021-08-22 1311178 23754  
753 753 Los Angeles Los Angeles 37 2021-08-21 1308407 23744  
814 814 Los Angeles Los Angeles 37 2021-08-20 1304670 23716  
875 875 Los Angeles Los Angeles 37 2021-08-19 1291124 23687  
936 936 Los Angeles Los Angeles 37 2021-08-18 1288173 23652  
997 997 Los Angeles Los Angeles 37 2021-08-17 1284750 23620  
1058 1058 Los Angeles Los Angeles 37 2021-08-16 1282123 23591  
1119 1119 Los Angeles Los Angeles 37 2021-08-15 1279702 23586  
1180 1180 Los Angeles Los Angeles 37 2021-08-14 1276355 23578  
1241 1241 Los Angeles Los Angeles 37 2021-08-13 1272418 23559  
1302 1302 Los Angeles Los Angeles 37 2021-08-12 1268875 23543  
1363 1363 Los Angeles Los Angeles 37 2021-08-11 1265287 23523  
1424 1424 Los Angeles Los Angeles 37 2021-08-10 1262244 23496  
1485 1485 Los Angeles Los Angeles 37 2021-08-09 1259922 23474  
1546 1546 Los Angeles Los Angeles 37 2021-08-08 1257021 23468  
1607 1607 Los Angeles Los Angeles 37 2021-08-07 1254005 23460  
1668 1668 Los Angeles Los Angeles 37 2021-08-06 1250152 23447  
1729 1729 Los Angeles Los Angeles 37 2021-08-05 1246613 23431  
1790 1790 Los Angeles Los Angeles 37 2021-08-04 1243063 23415  
1851 1851 Los Angeles Los Angeles 37 2021-08-03 1239833 23399  
1912 1912 Los Angeles Los Angeles 37 2021-08-02 1237942 23385  
1973 1973 Los Angeles Los Angeles 37 2021-08-01 1235581 23380  
2034 2034 Los Angeles Los Angeles 37 2021-07-31 1232551 23377  
2095 2095 Los Angeles Los Angeles 37 2021-07-30 1229471 23371  
2156 2156 Los Angeles Los Angeles 37 2021-07-29 1226022 23371  
2217 2217 Los Angeles Los Angeles 37 2021-07-28 1222967 23355  
2278 2278 Los Angeles Los Angeles 37 2021-07-27 1220856 23340  
2339 2339 Los Angeles Los Angeles 37 2021-07-26 1218988 23329  
2400 2400 Los Angeles Los Angeles 37 2021-07-25 1217061 23326  
2461 2461 Los Angeles Los Angeles 37 2021-07-24 1214977 23322  
2522 2522 Los Angeles Los Angeles 37 2021-07-23 1212516 23313  
2583 2583 Los Angeles Los Angeles 37 2021-07-22 1209654 23307  
2644 2644 Los Angeles Los Angeles 37 2021-07-21 1207068 23294  
2705 2705 Los Angeles Los Angeles 37 2021-07-20 1204857 23288  
2766 2766 Los Angeles Los Angeles 37 2021-07-19 1203188 23286  
2827 2827 Los Angeles Los Angeles 37 2021-07-18 1201958 23284  
2888 2888 Los Angeles Los Angeles 37 2021-07-17 1200325 23280  
2949 2949 Los Angeles Los Angeles 37 2021-07-16 1198656 23269  
3010 3010 Los Angeles Los Angeles 37 2021-07-15 1196893 23268  
3071 3071 Los Angeles Los Angeles 37 2021-07-14 1195492 23265  
3132 3132 Los Angeles Los Angeles 37 2021-07-13 1194430 23256  
3193 3193 Los Angeles Los Angeles 37 2021-07-12 1193375 23246  
3254 3254 Los Angeles Los Angeles 37 2021-07-11 1192318 23245  
3315 3315 Los Angeles Los Angeles 37 2021-07-10 1191247 23241  
3376 3376 Los Angeles Los Angeles 37 2021-07-09 1190178 23233  
3437 3437 Los Angeles Los Angeles 37 2021-07-08 1189146 23230  
3498 3498 Los Angeles Los Angeles 37 2021-07-07 1188414 23219  
3559 3559 Los Angeles Los Angeles 37 2021-07-06 1187984 23213  
3620 3620 Los Angeles Los Angeles 37 2021-07-05 1187222 23208  
3681 3681 Los Angeles Los Angeles 37 2021-07-04 1186767 23204  
3742 3742 Los Angeles Los Angeles 37 2021-07-03 1186178 23198  
3803 3803 Los Angeles Los Angeles 37 2021-07-02 1186178 23198  
3864 3864 Los Angeles Los Angeles 37 2021-07-01 1185701 23195  
3925 3925 Los Angeles Los Angeles 37 2021-06-30 1185253 23189  
3986 3986 Los Angeles Los Angeles 37 2021-06-29 1184888 23188  
4047 4047 Los Angeles Los Angeles 37 2021-06-28 1184625 23186  
4108 4108 Los Angeles Los Angeles 37 2021-06-27 1184369 23183  
4169 4169 Los Angeles Los Angeles 37 2021-06-26 1184130 23180  
4230 4230 Los Angeles Los Angeles 37 2021-06-25 1183829 23174  
4291 4291 Los Angeles Los Angeles 37 2021-06-24 1183273 23161  
4352 4352 Los Angeles Los Angeles 37 2021-06-23 1183273 23161  
4413 4413 Los Angeles Los Angeles 37 2021-06-22 1183054 23151  
4474 4474 Los Angeles Los Angeles 37 2021-06-21 1182899 23150  
4535 4535 Los Angeles Los Angeles 37 2021-06-20 1182775 23147  
4596 4596 Los Angeles Los Angeles 37 2021-06-19 1182518 23145  
4657 4657 Los Angeles Los Angeles 37 2021-06-18 1182384 23141  
4718 4718 Los Angeles Los Angeles 37 2021-06-17 1182201 23134  
4779 4779 Los Angeles Los Angeles 37 2021-06-16 1182001 23128  
4840 4840 Los Angeles Los Angeles 37 2021-06-15 1181820 23124  
4901 4901 Los Angeles Los Angeles 37 2021-06-14 1181653 23124  
4962 4962 Los Angeles Los Angeles 37 2021-06-13 1181524 23123  
5023 5023 Los Angeles Los Angeles 37 2021-06-12 1181340 23123  
5084 5084 Los Angeles Los Angeles 37 2021-06-11 1181163 23123  
5145 5145 Los Angeles Los Angeles 37 2021-06-10 1181000 23123  
5206 5206 Los Angeles Los Angeles 37 2021-06-09 1180832 23118  
5267 5267 Los Angeles Los Angeles 37 2021-06-08 1180664 23114  
5328 5328 Los Angeles Los Angeles 37 2021-06-07 1180519 23102  
5389 5389 Los Angeles Los Angeles 37 2021-06-06 1180386 23099  
5450 5450 Los Angeles Los Angeles 37 2021-06-05 1180183 23099  
5511 5511 Los Angeles Los Angeles 37 2021-06-04 1179950 23089  
5572 5572 Los Angeles Los Angeles 37 2021-06-03 1179761 23078  
5633 5633 Los Angeles Los Angeles 37 2021-06-02 1179577 23068  
5694 5694 Los Angeles Los Angeles 37 2021-06-01 1179493 23060  
5755 5755 Los Angeles Los Angeles 37 2021-05-31 1179386 23057  
5816 5816 Los Angeles Los Angeles 37 2021-05-30 1179214 23053  
5877 5877 Los Angeles Los Angeles 37 2021-05-29 1179044 23052 TRUE
5938 5938 Los Angeles Los Angeles 37 2021-05-28 1178863 23047  
5999 5999 Los Angeles Los Angeles 37 2021-05-27 1178679 23037  
6060 6060 Los Angeles Los Angeles 37 2021-05-26 1174666 22911  

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