latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "Alameda" sorted by new_deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: new_deaths, date (date)
Link | rowid | date | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths ▼ |
---|---|---|---|---|---|---|---|---|
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 |
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 |
1045 | 1045 | 2021-08-15 | Alameda | 1 | 101473 | 1301 | 0 | 0 |
1161 | 1161 | 2021-08-13 | Alameda | 1 | 101160 | 1299 | 388 | 0 |
1277 | 1277 | 2021-08-11 | Alameda | 1 | 100492 | 1296 | 305 | 0 |
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 |
1741 | 1741 | 2021-08-03 | Alameda | 1 | 97273 | 1286 | 152 | 0 |
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 |
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 |
2611 | 2611 | 2021-07-19 | Alameda | 1 | 92584 | 1271 | 4 | 0 |
2669 | 2669 | 2021-07-18 | Alameda | 1 | 92580 | 1271 | 208 | 0 |
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 |
3133 | 3133 | 2021-07-10 | Alameda | 1 | 91016 | 1268 | 255 | 0 |
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 |
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 |
5801 | 5801 | 2021-05-25 | Alameda | 1 | 88665 | 1263 | 45 | 0 |
5859 | 5859 | 2021-05-24 | Alameda | 1 | 88620 | 1263 | 75 | 0 |
5917 | 5917 | 2021-05-23 | Alameda | 1 | 88545 | 1263 | 43 | 0 |
5975 | 5975 | 2021-05-22 | Alameda | 1 | 88502 | 1263 | 19 | 0 |
6033 | 6033 | 2021-05-21 | Alameda | 1 | 88483 | 1263 | 75 | 0 |
6091 | 6091 | 2021-05-20 | Alameda | 1 | 88408 | 1263 | 49 | 0 |
6149 | 6149 | 2021-05-19 | Alameda | 1 | 88359 | 1263 | 55 | 0 |
6207 | 6207 | 2021-05-18 | Alameda | 1 | 88304 | 1263 | 49 | 0 |
6265 | 6265 | 2021-05-17 | Alameda | 1 | 88255 | 1263 | 25 | 0 |
6323 | 6323 | 2021-05-16 | Alameda | 1 | 88230 | 1263 | 43 | 0 |
6381 | 6381 | 2021-05-15 | Alameda | 1 | 88187 | 1263 | 58 | 0 |
6439 | 6439 | 2021-05-14 | Alameda | 1 | 88129 | 1263 | 68 | 0 |
6497 | 6497 | 2021-05-13 | Alameda | 1 | 88061 | 1263 | 63 | 0 |
6555 | 6555 | 2021-05-12 | Alameda | 1 | 87998 | 1263 | 63 | 0 |
6613 | 6613 | 2021-05-11 | Alameda | 1 | 87935 | 1263 | 59 | 0 |
6671 | 6671 | 2021-05-10 | Alameda | 1 | 87876 | 1263 | 75 | 0 |
6729 | 6729 | 2021-05-09 | Alameda | 1 | 87801 | 1263 | 84 | 0 |
6787 | 6787 | 2021-05-08 | Alameda | 1 | 87717 | 1263 | 87 | 0 |
6845 | 6845 | 2021-05-07 | Alameda | 1 | 87630 | 1263 | 96 | 0 |
6903 | 6903 | 2021-05-06 | Alameda | 1 | 87534 | 1263 | 102 | 0 |
6961 | 6961 | 2021-05-05 | Alameda | 1 | 87432 | 1263 | 54 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );