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

1,118 rows where county = "Alameda" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

agency 2

fips 1

  • 1 1,118

county 1

  • Alameda · 1,118 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
1 1 Alameda Alameda 1 2021-09-02 104945 1263  
2 2 Berkeley Alameda 1 2021-09-02 4592 53  
62 62 Alameda Alameda 1 2021-09-01 104317 1261  
63 63 Berkeley Alameda 1 2021-09-01 4565 53  
123 123 Alameda Alameda 1 2021-08-31 103165 1259 TRUE
124 124 Berkeley Alameda 1 2021-08-31 4517 53 TRUE
184 184 Alameda Alameda 1 2021-08-30 103165 1259  
185 185 Berkeley Alameda 1 2021-08-30 4517 53  
245 245 Alameda Alameda 1 2021-08-29 102991 1259  
246 246 Berkeley Alameda 1 2021-08-29 4501 53  
306 306 Alameda Alameda 1 2021-08-28 102932 1259  
307 307 Berkeley Alameda 1 2021-08-28 4482 53  
367 367 Alameda Alameda 1 2021-08-27 102353 1259  
368 368 Berkeley Alameda 1 2021-08-27 4450 53  
428 428 Alameda Alameda 1 2021-08-26 102015 1259  
429 429 Berkeley Alameda 1 2021-08-26 4416 53  
489 489 Alameda Alameda 1 2021-08-25 101610 1259  
490 490 Berkeley Alameda 1 2021-08-25 4378 53  
550 550 Alameda Alameda 1 2021-08-24 101111 1258  
551 551 Berkeley Alameda 1 2021-08-24 4360 53  
611 611 Alameda Alameda 1 2021-08-23 100511 1257  
612 612 Berkeley Alameda 1 2021-08-23 4348 52  
672 672 Alameda Alameda 1 2021-08-22 100486 1257  
673 673 Berkeley Alameda 1 2021-08-22 4333 52  
733 733 Alameda Alameda 1 2021-08-21 100343 1257  
734 734 Berkeley Alameda 1 2021-08-21 4318 52  
794 794 Alameda Alameda 1 2021-08-20 99782 1257  
795 795 Berkeley Alameda 1 2021-08-20 4300 52  
855 855 Alameda Alameda 1 2021-08-19 99228 1257  
856 856 Berkeley Alameda 1 2021-08-19 4275 52  
916 916 Alameda Alameda 1 2021-08-18 98823 1257  
917 917 Berkeley Alameda 1 2021-08-18 4252 52  
977 977 Alameda Alameda 1 2021-08-17 98513 1253  
978 978 Berkeley Alameda 1 2021-08-17 4238 52  
1038 1038 Alameda Alameda 1 2021-08-16 97878 1251  
1039 1039 Berkeley Alameda 1 2021-08-16 4223 51  
1099 1099 Alameda Alameda 1 2021-08-15 97271 1250  
1100 1100 Berkeley Alameda 1 2021-08-15 4202 51  
1160 1160 Alameda Alameda 1 2021-08-14 97271 1250  
1161 1161 Berkeley Alameda 1 2021-08-14 4202 51  
1221 1221 Alameda Alameda 1 2021-08-13 96975 1248  
1222 1222 Berkeley Alameda 1 2021-08-13 4185 51  
1282 1282 Alameda Alameda 1 2021-08-12 96604 1248  
1283 1283 Berkeley Alameda 1 2021-08-12 4168 51  
1343 1343 Alameda Alameda 1 2021-08-11 96336 1245  
1344 1344 Berkeley Alameda 1 2021-08-11 4156 51  
1404 1404 Alameda Alameda 1 2021-08-10 96049 1245  
1405 1405 Berkeley Alameda 1 2021-08-10 4138 51  
1465 1465 Alameda Alameda 1 2021-08-09 95558 1241  
1466 1466 Berkeley Alameda 1 2021-08-09 4123 50  
1526 1526 Alameda Alameda 1 2021-08-08 95376 1241  
1527 1527 Berkeley Alameda 1 2021-08-08 4108 50  
1587 1587 Alameda Alameda 1 2021-08-07 95120 1241  
1588 1588 Berkeley Alameda 1 2021-08-07 4098 50  
1648 1648 Alameda Alameda 1 2021-08-06 94823 1241  
1649 1649 Berkeley Alameda 1 2021-08-06 4083 50  
1709 1709 Alameda Alameda 1 2021-08-05 94298 1241  
1710 1710 Berkeley Alameda 1 2021-08-05 4061 50  
1770 1770 Alameda Alameda 1 2021-08-04 93976 1240  
1771 1771 Berkeley Alameda 1 2021-08-04 4037 50  
1831 1831 Alameda Alameda 1 2021-08-03 93264 1236  
1832 1832 Berkeley Alameda 1 2021-08-03 4009 50  
1892 1892 Alameda Alameda 1 2021-08-02 93117 1236  
1893 1893 Berkeley Alameda 1 2021-08-02 4004 50  
1953 1953 Alameda Alameda 1 2021-08-01 91889 1232 TRUE
1954 1954 Berkeley Alameda 1 2021-08-01 3963 50  
2014 2014 Alameda Alameda 1 2021-07-31 91889 1232 TRUE
2015 2015 Berkeley Alameda 1 2021-07-31 3937 50 TRUE
2075 2075 Alameda Alameda 1 2021-07-30 91889 1232  
2076 2076 Berkeley Alameda 1 2021-07-30 3937 50  
2136 2136 Alameda Alameda 1 2021-07-29 91889 1232  
2137 2137 Berkeley Alameda 1 2021-07-29 3937 50  
2197 2197 Alameda Alameda 1 2021-07-28 91616 1230  
2198 2198 Berkeley Alameda 1 2021-07-28 3923 50  
2258 2258 Alameda Alameda 1 2021-07-27 91333 1224  
2259 2259 Berkeley Alameda 1 2021-07-27 3910 50  
2319 2319 Alameda Alameda 1 2021-07-26 90900 1222  
2320 2320 Berkeley Alameda 1 2021-07-26 3896 50  
2380 2380 Alameda Alameda 1 2021-07-25 90847 1222  
2381 2381 Berkeley Alameda 1 2021-07-25 3889 50  
2441 2441 Alameda Alameda 1 2021-07-24 90473 1222  
2442 2442 Berkeley Alameda 1 2021-07-24 3872 50  
2502 2502 Alameda Alameda 1 2021-07-23 90103 1222  
2503 2503 Berkeley Alameda 1 2021-07-23 3850 50  
2563 2563 Alameda Alameda 1 2021-07-22 89811 1222  
2564 2564 Berkeley Alameda 1 2021-07-22 3824 50  
2624 2624 Alameda Alameda 1 2021-07-21 89548 1222  
2625 2625 Berkeley Alameda 1 2021-07-21 3813 50  
2685 2685 Alameda Alameda 1 2021-07-20 89180 1222  
2686 2686 Berkeley Alameda 1 2021-07-20 3793 50  
2746 2746 Alameda Alameda 1 2021-07-19 88806 1221  
2747 2747 Berkeley Alameda 1 2021-07-19 3778 50  
2807 2807 Alameda Alameda 1 2021-07-18 88805 1221  
2808 2808 Berkeley Alameda 1 2021-07-18 3775 50  
2868 2868 Alameda Alameda 1 2021-07-17 88608 1221  
2869 2869 Berkeley Alameda 1 2021-07-17 3764 50  
2929 2929 Alameda Alameda 1 2021-07-16 88339 1220  
2930 2930 Berkeley Alameda 1 2021-07-16 3752 50  
2990 2990 Alameda Alameda 1 2021-07-15 88013 1220  
2991 2991 Berkeley Alameda 1 2021-07-15 3730 50  

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