latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
33,021 rows sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: did_not_update, date (date)
fips >30
county >30
- Los Angeles 1,686
- Alameda 1,118
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Calaveras 559
- Contra Costa 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Tulare 541
- Amador 539
- San Luis Obispo 538
- San Bernardino 537
- …
agency >30
- Los Angeles 586
- Orange 586
- Santa Clara 586
- San Benito 581
- Humboldt 564
- Sacramento 564
- Solano 560
- Alameda 559
- Berkeley 559
- Calaveras 559
- Contra Costa 559
- Long Beach 559
- Marin 559
- Placer 559
- Riverside 559
- San Diego 559
- San Francisco 559
- San Mateo 559
- Santa Cruz 559
- Shasta 559
- Sonoma 559
- Stanislaus 559
- Ventura 559
- Yolo 559
- Fresno 555
- San Joaquin 551
- Madera 545
- Imperial 541
- Pasadena 541
- Tulare 541
- …
Link | rowid | agency | county | fips | date | confirmed_cases | deaths ▲ | did_not_update |
---|---|---|---|---|---|---|---|---|
4930 | 4930 | Siskiyou | Siskiyou | 93 | 2021-06-14 | 2390 | ||
7369 | 7369 | Sierra | Sierra | 91 | 2021-05-05 | 112 | ||
9580 | 9580 | Alpine | Alpine | 3 | 2021-03-29 | 88 | ||
14750 | 14750 | Sierra | Sierra | 91 | 2021-01-04 | 59 | ||
16168 | 16168 | Alpine | Alpine | 3 | 2020-12-11 | TRUE | ||
25730 | 25730 | Sierra | Sierra | 91 | 2020-07-08 | 1 | ||
26233 | 26233 | Alpine | Alpine | 3 | 2020-06-29 | |||
28799 | 28799 | Colusa | Colusa | 11 | 2020-05-18 | 3 | ||
32560 | 32560 | Fresno | Fresno | 19 | 2020-03-06 | 3 | ||
32586 | 32586 | Fresno | Fresno | 19 | 2020-03-05 | 3 | ||
32612 | 32612 | Fresno | Fresno | 19 | 2020-03-04 | 3 | ||
32638 | 32638 | Fresno | Fresno | 19 | 2020-03-03 | 2 | ||
32664 | 32664 | Fresno | Fresno | 19 | 2020-03-02 | 2 | ||
32690 | 32690 | Fresno | Fresno | 19 | 2020-03-01 | 1 | ||
32716 | 32716 | Fresno | Fresno | 19 | 2020-02-29 | 1 | ||
32741 | 32741 | Fresno | Fresno | 19 | 2020-02-28 | 1 | ||
32762 | 32762 | Fresno | Fresno | 19 | 2020-02-27 | 1 | ||
32774 | 32774 | Fresno | Fresno | 19 | 2020-02-26 | 1 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );