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

559 rows where agency = "Alameda" sorted by date descending

✎ View and edit SQL

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

Suggested facets: did_not_update, date (date)

fips 1

  • 1 559

county 1

agency 1

  • Alameda · 559 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
1 1 Alameda Alameda 1 2021-09-02 104945 1263  
62 62 Alameda Alameda 1 2021-09-01 104317 1261  
123 123 Alameda Alameda 1 2021-08-31 103165 1259 TRUE
184 184 Alameda Alameda 1 2021-08-30 103165 1259  
245 245 Alameda Alameda 1 2021-08-29 102991 1259  
306 306 Alameda Alameda 1 2021-08-28 102932 1259  
367 367 Alameda Alameda 1 2021-08-27 102353 1259  
428 428 Alameda Alameda 1 2021-08-26 102015 1259  
489 489 Alameda Alameda 1 2021-08-25 101610 1259  
550 550 Alameda Alameda 1 2021-08-24 101111 1258  
611 611 Alameda Alameda 1 2021-08-23 100511 1257  
672 672 Alameda Alameda 1 2021-08-22 100486 1257  
733 733 Alameda Alameda 1 2021-08-21 100343 1257  
794 794 Alameda Alameda 1 2021-08-20 99782 1257  
855 855 Alameda Alameda 1 2021-08-19 99228 1257  
916 916 Alameda Alameda 1 2021-08-18 98823 1257  
977 977 Alameda Alameda 1 2021-08-17 98513 1253  
1038 1038 Alameda Alameda 1 2021-08-16 97878 1251  
1099 1099 Alameda Alameda 1 2021-08-15 97271 1250  
1160 1160 Alameda Alameda 1 2021-08-14 97271 1250  
1221 1221 Alameda Alameda 1 2021-08-13 96975 1248  
1282 1282 Alameda Alameda 1 2021-08-12 96604 1248  
1343 1343 Alameda Alameda 1 2021-08-11 96336 1245  
1404 1404 Alameda Alameda 1 2021-08-10 96049 1245  
1465 1465 Alameda Alameda 1 2021-08-09 95558 1241  
1526 1526 Alameda Alameda 1 2021-08-08 95376 1241  
1587 1587 Alameda Alameda 1 2021-08-07 95120 1241  
1648 1648 Alameda Alameda 1 2021-08-06 94823 1241  
1709 1709 Alameda Alameda 1 2021-08-05 94298 1241  
1770 1770 Alameda Alameda 1 2021-08-04 93976 1240  
1831 1831 Alameda Alameda 1 2021-08-03 93264 1236  
1892 1892 Alameda Alameda 1 2021-08-02 93117 1236  
1953 1953 Alameda Alameda 1 2021-08-01 91889 1232 TRUE
2014 2014 Alameda Alameda 1 2021-07-31 91889 1232 TRUE
2075 2075 Alameda Alameda 1 2021-07-30 91889 1232  
2136 2136 Alameda Alameda 1 2021-07-29 91889 1232  
2197 2197 Alameda Alameda 1 2021-07-28 91616 1230  
2258 2258 Alameda Alameda 1 2021-07-27 91333 1224  
2319 2319 Alameda Alameda 1 2021-07-26 90900 1222  
2380 2380 Alameda Alameda 1 2021-07-25 90847 1222  
2441 2441 Alameda Alameda 1 2021-07-24 90473 1222  
2502 2502 Alameda Alameda 1 2021-07-23 90103 1222  
2563 2563 Alameda Alameda 1 2021-07-22 89811 1222  
2624 2624 Alameda Alameda 1 2021-07-21 89548 1222  
2685 2685 Alameda Alameda 1 2021-07-20 89180 1222  
2746 2746 Alameda Alameda 1 2021-07-19 88806 1221  
2807 2807 Alameda Alameda 1 2021-07-18 88805 1221  
2868 2868 Alameda Alameda 1 2021-07-17 88608 1221  
2929 2929 Alameda Alameda 1 2021-07-16 88339 1220  
2990 2990 Alameda Alameda 1 2021-07-15 88013 1220  
3051 3051 Alameda Alameda 1 2021-07-14 88013 1220  
3112 3112 Alameda Alameda 1 2021-07-13 87824 1220  
3173 3173 Alameda Alameda 1 2021-07-12 87481 1220  
3234 3234 Alameda Alameda 1 2021-07-11 87452 1220  
3295 3295 Alameda Alameda 1 2021-07-10 87325 1218  
3356 3356 Alameda Alameda 1 2021-07-09 87072 1218  
3417 3417 Alameda Alameda 1 2021-07-08 87072 1217  
3478 3478 Alameda Alameda 1 2021-07-07 86800 1217  
3539 3539 Alameda Alameda 1 2021-07-06 86700 1217  
3600 3600 Alameda Alameda 1 2021-07-05 86694 1217 TRUE
3661 3661 Alameda Alameda 1 2021-07-04 86694 1217 TRUE
3722 3722 Alameda Alameda 1 2021-07-03 86694 1217  
3783 3783 Alameda Alameda 1 2021-07-02 86694 1217  
3844 3844 Alameda Alameda 1 2021-07-01 86608 1217 TRUE
3905 3905 Alameda Alameda 1 2021-06-30 86608 1217  
3966 3966 Alameda Alameda 1 2021-06-29 86543 1217  
4027 4027 Alameda Alameda 1 2021-06-28 86494 1217  
4088 4088 Alameda Alameda 1 2021-06-27 86432 1217  
4149 4149 Alameda Alameda 1 2021-06-26 86426 1217  
4210 4210 Alameda Alameda 1 2021-06-25 86272 1217  
4271 4271 Alameda Alameda 1 2021-06-24 86226 1217  
4332 4332 Alameda Alameda 1 2021-06-23 86153 1217  
4393 4393 Alameda Alameda 1 2021-06-22 86093 1217  
4454 4454 Alameda Alameda 1 2021-06-21 85991 1217  
4515 4515 Alameda Alameda 1 2021-06-20 85946 1217 TRUE
4576 4576 Alameda Alameda 1 2021-06-19 85946 1217 TRUE
4637 4637 Alameda Alameda 1 2021-06-18 85946 1217  
4698 4698 Alameda Alameda 1 2021-06-17 85920 1217  
4759 4759 Alameda Alameda 1 2021-06-16 85899 1217  
4820 4820 Alameda Alameda 1 2021-06-15 85865 1217  
4881 4881 Alameda Alameda 1 2021-06-14 85814 1217  
4942 4942 Alameda Alameda 1 2021-06-13 85754 1217  
5003 5003 Alameda Alameda 1 2021-06-12 85707 1217 TRUE
5064 5064 Alameda Alameda 1 2021-06-11 85707 1217  
5125 5125 Alameda Alameda 1 2021-06-10 85673 1217  
5186 5186 Alameda Alameda 1 2021-06-09 85575 1217 TRUE
5247 5247 Alameda Alameda 1 2021-06-08 85575 1217  
5308 5308 Alameda Alameda 1 2021-06-07 85522 1217  
5369 5369 Alameda Alameda 1 2021-06-06 85518 1217  
5430 5430 Alameda Alameda 1 2021-06-05 85506 1217  
5491 5491 Alameda Alameda 1 2021-06-04 85469 1217  
5552 5552 Alameda Alameda 1 2021-06-03 85402 1217  
5613 5613 Alameda Alameda 1 2021-06-02 85350 1217  
5674 5674 Alameda Alameda 1 2021-06-01 85335 1217  
5735 5735 Alameda Alameda 1 2021-05-31 85309 1217  
5796 5796 Alameda Alameda 1 2021-05-30 85300 1217  
5857 5857 Alameda Alameda 1 2021-05-29 85272 1217 TRUE
5918 5918 Alameda Alameda 1 2021-05-28 85217 1217  
5979 5979 Alameda Alameda 1 2021-05-27 85155 1217  
6040 6040 Alameda Alameda 1 2021-05-26 85089 1217  

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