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_confirmed_cases
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 |
1045 | 1045 | 2021-08-15 | Alameda | 1 | 101473 | 1301 | 0 | 0 |
1915 | 1915 | 2021-07-31 | Alameda | 1 | 95826 | 1282 | 0 | 0 |
1973 | 1973 | 2021-07-30 | Alameda | 1 | 95826 | 1282 | 0 | 0 |
2843 | 2843 | 2021-07-15 | Alameda | 1 | 91743 | 1270 | 0 | 0 |
3191 | 3191 | 2021-07-09 | Alameda | 1 | 90761 | 1268 | 0 | 1 |
3423 | 3423 | 2021-07-05 | Alameda | 1 | 90375 | 1267 | 0 | 0 |
3481 | 3481 | 2021-07-04 | Alameda | 1 | 90375 | 1267 | 0 | 0 |
4293 | 4293 | 2021-06-20 | Alameda | 1 | 89592 | 1263 | 0 | 0 |
4351 | 4351 | 2021-06-19 | Alameda | 1 | 89592 | 1263 | 0 | 0 |
30651 | 30651 | 2020-03-16 | Alameda | 1 | 34 | 0 | 0 | 0 |
30825 | 30825 | 2020-03-10 | Alameda | 1 | 5 | 0 | 0 | 0 |
30875 | 30875 | 2020-03-08 | Alameda | 1 | 4 | 0 | 0 | 0 |
30925 | 30925 | 2020-03-06 | Alameda | 1 | 3 | 0 | 0 | 0 |
30949 | 30949 | 2020-03-05 | Alameda | 1 | 3 | 0 | 0 | 0 |
30973 | 30973 | 2020-03-04 | Alameda | 1 | 3 | 0 | 0 | 0 |
30997 | 30997 | 2020-03-03 | Alameda | 1 | 3 | 0 | 0 | 0 |
31021 | 31021 | 2020-03-02 | Alameda | 1 | 3 | 0 | 0 | 0 |
31045 | 31045 | 2020-03-01 | Alameda | 1 | 3 | 0 | 0 | 0 |
31069 | 31069 | 2020-02-29 | Alameda | 1 | 3 | 0 | 0 | 0 |
31123 | 31123 | 2020-02-26 | Alameda | 1 | 1 | 0 | 0 | 0 |
31170 | 31170 | 2020-02-21 | Alameda | 1 | 1 | 0 | 0 | 0 |
31192 | 31192 | 2020-02-20 | Alameda | 1 | 1 | 0 | 0 | 0 |
31307 | 31307 | 2020-01-31 | Alameda | 1 | 0 | 0 | 0 | 0 |
4757 | 4757 | 2021-06-12 | Alameda | 1 | 89339 | 1263 | 1 | 0 |
30771 | 30771 | 2020-03-12 | Alameda | 1 | 13 | 0 | 1 | 0 |
30850 | 30850 | 2020-03-09 | Alameda | 1 | 5 | 0 | 1 | 0 |
30900 | 30900 | 2020-03-07 | Alameda | 1 | 4 | 0 | 1 | 0 |
31282 | 31282 | 2020-02-02 | Alameda | 1 | 1 | 0 | 1 | 0 |
4931 | 4931 | 2021-06-09 | Alameda | 1 | 89203 | 1263 | 2 | 0 |
31092 | 31092 | 2020-02-28 | Alameda | 1 | 3 | 0 | 2 | 0 |
30743 | 30743 | 2020-03-13 | Alameda | 1 | 16 | 0 | 3 | 0 |
2611 | 2611 | 2021-07-19 | Alameda | 1 | 92584 | 1271 | 4 | 0 |
3539 | 3539 | 2021-07-03 | Alameda | 1 | 90375 | 1267 | 5 | 0 |
3655 | 3655 | 2021-07-01 | Alameda | 1 | 90281 | 1267 | 5 | 0 |
5047 | 5047 | 2021-06-07 | Alameda | 1 | 89147 | 1263 | 6 | 0 |
30798 | 30798 | 2020-03-11 | Alameda | 1 | 12 | 0 | 7 | 0 |
3365 | 3365 | 2021-07-06 | Alameda | 1 | 90383 | 1267 | 8 | 0 |
30714 | 30714 | 2020-03-14 | Alameda | 1 | 24 | 0 | 8 | 0 |
5453 | 5453 | 2021-05-31 | Alameda | 1 | 88929 | 1263 | 9 | 0 |
30067 | 30067 | 2020-03-30 | Alameda | 1 | 324 | 25 | 9 | 4 |
30511 | 30511 | 2020-03-20 | Alameda | 1 | 76 | 4 | 9 | 1 |
30582 | 30582 | 2020-03-18 | Alameda | 1 | 55 | 0 | 9 | 0 |
30683 | 30683 | 2020-03-15 | Alameda | 1 | 34 | 0 | 10 | 0 |
5105 | 5105 | 2021-06-06 | Alameda | 1 | 89141 | 1263 | 12 | 0 |
30547 | 30547 | 2020-03-19 | Alameda | 1 | 67 | 3 | 12 | 3 |
30617 | 30617 | 2020-03-17 | Alameda | 1 | 46 | 0 | 12 | 0 |
3887 | 3887 | 2021-06-27 | Alameda | 1 | 90103 | 1267 | 13 | 0 |
5337 | 5337 | 2021-06-02 | Alameda | 1 | 88970 | 1263 | 15 | 0 |
30429 | 30429 | 2020-03-22 | Alameda | 1 | 113 | 7 | 16 | 1 |
30116 | 30116 | 2020-03-29 | Alameda | 1 | 315 | 21 | 17 | 2 |
5975 | 5975 | 2021-05-22 | Alameda | 1 | 88502 | 1263 | 19 | 0 |
30471 | 30471 | 2020-03-21 | Alameda | 1 | 97 | 6 | 21 | 2 |
30301 | 30301 | 2020-03-25 | Alameda | 1 | 186 | 15 | 22 | 5 |
28189 | 28189 | 2020-05-04 | Alameda | 1 | 1792 | 101 | 24 | 2 |
30345 | 30345 | 2020-03-24 | Alameda | 1 | 164 | 10 | 24 | 2 |
6265 | 6265 | 2021-05-17 | Alameda | 1 | 88255 | 1263 | 25 | 0 |
28697 | 28697 | 2020-04-25 | Alameda | 1 | 1458 | 91 | 25 | 0 |
1857 | 1857 | 2021-08-01 | Alameda | 1 | 95852 | 1282 | 26 | 0 |
5395 | 5395 | 2021-06-01 | Alameda | 1 | 88955 | 1263 | 26 | 0 |
4467 | 4467 | 2021-06-17 | Alameda | 1 | 89562 | 1263 | 27 | 0 |
7019 | 7019 | 2021-05-04 | Alameda | 1 | 87378 | 1263 | 27 | 0 |
28537 | 28537 | 2020-04-28 | Alameda | 1 | 1552 | 94 | 27 | 0 |
30387 | 30387 | 2020-03-23 | Alameda | 1 | 140 | 8 | 27 | 1 |
5511 | 5511 | 2021-05-30 | Alameda | 1 | 88920 | 1263 | 28 | 0 |
19663 | 19663 | 2020-09-28 | Alameda | 1 | 21227 | 428 | 29 | 2 |
29227 | 29227 | 2020-04-15 | Alameda | 1 | 999 | 74 | 29 | 1 |
29598 | 29598 | 2020-04-08 | Alameda | 1 | 712 | 55 | 29 | 4 |
29704 | 29704 | 2020-04-06 | Alameda | 1 | 640 | 51 | 29 | 1 |
4409 | 4409 | 2021-06-18 | Alameda | 1 | 89592 | 1263 | 30 | 0 |
28479 | 28479 | 2020-04-29 | Alameda | 1 | 1582 | 94 | 30 | 0 |
28644 | 28644 | 2020-04-26 | Alameda | 1 | 1488 | 92 | 30 | 1 |
29439 | 29439 | 2020-04-11 | Alameda | 1 | 840 | 63 | 30 | 3 |
29757 | 29757 | 2020-04-05 | Alameda | 1 | 611 | 50 | 30 | 2 |
29280 | 29280 | 2020-04-14 | Alameda | 1 | 970 | 73 | 31 | 2 |
26101 | 26101 | 2020-06-09 | Alameda | 1 | 3975 | 142 | 32 | 2 |
27725 | 27725 | 2020-05-12 | Alameda | 1 | 2138 | 110 | 32 | 1 |
26565 | 26565 | 2020-06-01 | Alameda | 1 | 3462 | 129 | 33 | 0 |
27841 | 27841 | 2020-05-10 | Alameda | 1 | 2072 | 106 | 33 | 1 |
28962 | 28962 | 2020-04-20 | Alameda | 1 | 1259 | 84 | 33 | 1 |
4815 | 4815 | 2021-06-11 | Alameda | 1 | 89338 | 1263 | 34 | 0 |
27783 | 27783 | 2020-05-11 | Alameda | 1 | 2106 | 109 | 34 | 3 |
28421 | 28421 | 2020-04-30 | Alameda | 1 | 1617 | 96 | 35 | 2 |
4525 | 4525 | 2021-06-16 | Alameda | 1 | 89535 | 1263 | 36 | 0 |
18619 | 18619 | 2020-10-16 | Alameda | 1 | 22414 | 439 | 36 | 1 |
28131 | 28131 | 2020-05-05 | Alameda | 1 | 1828 | 103 | 36 | 2 |
30163 | 30163 | 2020-03-28 | Alameda | 1 | 298 | 19 | 36 | 0 |
3017 | 3017 | 2021-07-12 | Alameda | 1 | 91197 | 1270 | 37 | 0 |
18735 | 18735 | 2020-10-14 | Alameda | 1 | 22335 | 438 | 37 | 0 |
27377 | 27377 | 2020-05-18 | Alameda | 1 | 2453 | 117 | 37 | 3 |
28591 | 28591 | 2020-04-27 | Alameda | 1 | 1525 | 94 | 37 | 2 |
5163 | 5163 | 2021-06-05 | Alameda | 1 | 89129 | 1263 | 38 | 0 |
30210 | 30210 | 2020-03-27 | Alameda | 1 | 262 | 19 | 38 | 3 |
30257 | 30257 | 2020-03-26 | Alameda | 1 | 224 | 16 | 38 | 1 |
28856 | 28856 | 2020-04-22 | Alameda | 1 | 1340 | 84 | 39 | 0 |
29121 | 29121 | 2020-04-17 | Alameda | 1 | 1117 | 79 | 39 | 3 |
581 | 581 | 2021-08-23 | Alameda | 1 | 104859 | 1309 | 40 | 0 |
27667 | 27667 | 2020-05-13 | Alameda | 1 | 2178 | 111 | 40 | 1 |
29545 | 29545 | 2020-04-09 | Alameda | 1 | 752 | 59 | 40 | 4 |
28363 | 28363 | 2020-05-01 | Alameda | 1 | 1658 | 98 | 41 | 2 |
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 );