latimes_county_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_county_totals

559 rows where fips = 1 sorted by date descending

✎ View and edit SQL

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

Suggested facets: new_deaths, date (date)

fips 1

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
1 1 2021-09-02 Alameda 1 109537 1316 655 2
59 59 2021-09-01 Alameda 1 108882 1314 1200 2
117 117 2021-08-31 Alameda 1 107682 1312 0 0
175 175 2021-08-30 Alameda 1 107682 1312 190 0
233 233 2021-08-29 Alameda 1 107492 1312 78 0
291 291 2021-08-28 Alameda 1 107414 1312 611 0
349 349 2021-08-27 Alameda 1 106803 1312 372 0
407 407 2021-08-26 Alameda 1 106431 1312 443 0
465 465 2021-08-25 Alameda 1 105988 1312 517 1
523 523 2021-08-24 Alameda 1 105471 1311 612 2
581 581 2021-08-23 Alameda 1 104859 1309 40 0
639 639 2021-08-22 Alameda 1 104819 1309 158 0
697 697 2021-08-21 Alameda 1 104661 1309 579 0
755 755 2021-08-20 Alameda 1 104082 1309 579 0
813 813 2021-08-19 Alameda 1 103503 1309 428 0
871 871 2021-08-18 Alameda 1 103075 1309 324 4
929 929 2021-08-17 Alameda 1 102751 1305 650 3
987 987 2021-08-16 Alameda 1 102101 1302 628 1
1045 1045 2021-08-15 Alameda 1 101473 1301 0 0
1103 1103 2021-08-14 Alameda 1 101473 1301 313 2
1161 1161 2021-08-13 Alameda 1 101160 1299 388 0
1219 1219 2021-08-12 Alameda 1 100772 1299 280 3
1277 1277 2021-08-11 Alameda 1 100492 1296 305 0
1335 1335 2021-08-10 Alameda 1 100187 1296 506 5
1393 1393 2021-08-09 Alameda 1 99681 1291 197 0
1451 1451 2021-08-08 Alameda 1 99484 1291 266 0
1509 1509 2021-08-07 Alameda 1 99218 1291 312 0
1567 1567 2021-08-06 Alameda 1 98906 1291 547 0
1625 1625 2021-08-05 Alameda 1 98359 1291 346 1
1683 1683 2021-08-04 Alameda 1 98013 1290 740 4
1741 1741 2021-08-03 Alameda 1 97273 1286 152 0
1799 1799 2021-08-02 Alameda 1 97121 1286 1269 4
1857 1857 2021-08-01 Alameda 1 95852 1282 26 0
1915 1915 2021-07-31 Alameda 1 95826 1282 0 0
1973 1973 2021-07-30 Alameda 1 95826 1282 0 0
2031 2031 2021-07-29 Alameda 1 95826 1282 287 2
2089 2089 2021-07-28 Alameda 1 95539 1280 296 6
2147 2147 2021-07-27 Alameda 1 95243 1274 447 2
2205 2205 2021-07-26 Alameda 1 94796 1272 60 0
2263 2263 2021-07-25 Alameda 1 94736 1272 391 0
2321 2321 2021-07-24 Alameda 1 94345 1272 392 0
2379 2379 2021-07-23 Alameda 1 93953 1272 318 0
2437 2437 2021-07-22 Alameda 1 93635 1272 274 0
2495 2495 2021-07-21 Alameda 1 93361 1272 388 0
2553 2553 2021-07-20 Alameda 1 92973 1272 389 1
2611 2611 2021-07-19 Alameda 1 92584 1271 4 0
2669 2669 2021-07-18 Alameda 1 92580 1271 208 0
2727 2727 2021-07-17 Alameda 1 92372 1271 281 1
2785 2785 2021-07-16 Alameda 1 92091 1270 348 0
2843 2843 2021-07-15 Alameda 1 91743 1270 0 0
2901 2901 2021-07-14 Alameda 1 91743 1270 197 0
2959 2959 2021-07-13 Alameda 1 91546 1270 349 0
3017 3017 2021-07-12 Alameda 1 91197 1270 37 0
3075 3075 2021-07-11 Alameda 1 91160 1270 144 2
3133 3133 2021-07-10 Alameda 1 91016 1268 255 0
3191 3191 2021-07-09 Alameda 1 90761 1268 0 1
3249 3249 2021-07-08 Alameda 1 90761 1267 278 0
3307 3307 2021-07-07 Alameda 1 90483 1267 100 0
3365 3365 2021-07-06 Alameda 1 90383 1267 8 0
3423 3423 2021-07-05 Alameda 1 90375 1267 0 0
3481 3481 2021-07-04 Alameda 1 90375 1267 0 0
3539 3539 2021-07-03 Alameda 1 90375 1267 5 0
3597 3597 2021-07-02 Alameda 1 90370 1267 89 0
3655 3655 2021-07-01 Alameda 1 90281 1267 5 0
3713 3713 2021-06-30 Alameda 1 90276 1267 65 0
3771 3771 2021-06-29 Alameda 1 90211 1267 46 0
3829 3829 2021-06-28 Alameda 1 90165 1267 62 0
3887 3887 2021-06-27 Alameda 1 90103 1267 13 0
3945 3945 2021-06-26 Alameda 1 90090 1267 154 0
4003 4003 2021-06-25 Alameda 1 89936 1267 46 0
4061 4061 2021-06-24 Alameda 1 89890 1267 73 0
4119 4119 2021-06-23 Alameda 1 89817 1267 61 0
4177 4177 2021-06-22 Alameda 1 89756 1267 107 0
4235 4235 2021-06-21 Alameda 1 89649 1267 57 4
4293 4293 2021-06-20 Alameda 1 89592 1263 0 0
4351 4351 2021-06-19 Alameda 1 89592 1263 0 0
4409 4409 2021-06-18 Alameda 1 89592 1263 30 0
4467 4467 2021-06-17 Alameda 1 89562 1263 27 0
4525 4525 2021-06-16 Alameda 1 89535 1263 36 0
4583 4583 2021-06-15 Alameda 1 89499 1263 51 0
4641 4641 2021-06-14 Alameda 1 89448 1263 61 0
4699 4699 2021-06-13 Alameda 1 89387 1263 48 0
4757 4757 2021-06-12 Alameda 1 89339 1263 1 0
4815 4815 2021-06-11 Alameda 1 89338 1263 34 0
4873 4873 2021-06-10 Alameda 1 89304 1263 101 0
4931 4931 2021-06-09 Alameda 1 89203 1263 2 0
4989 4989 2021-06-08 Alameda 1 89201 1263 54 0
5047 5047 2021-06-07 Alameda 1 89147 1263 6 0
5105 5105 2021-06-06 Alameda 1 89141 1263 12 0
5163 5163 2021-06-05 Alameda 1 89129 1263 38 0
5221 5221 2021-06-04 Alameda 1 89091 1263 66 0
5279 5279 2021-06-03 Alameda 1 89025 1263 55 0
5337 5337 2021-06-02 Alameda 1 88970 1263 15 0
5395 5395 2021-06-01 Alameda 1 88955 1263 26 0
5453 5453 2021-05-31 Alameda 1 88929 1263 9 0
5511 5511 2021-05-30 Alameda 1 88920 1263 28 0
5569 5569 2021-05-29 Alameda 1 88892 1263 55 0
5627 5627 2021-05-28 Alameda 1 88837 1263 64 0
5685 5685 2021-05-27 Alameda 1 88773 1263 66 0
5743 5743 2021-05-26 Alameda 1 88707 1263 42 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);