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

560 rows where agency = "Solano" and fips = 95 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

  • 95 · 560 ✖

county 1

agency 1

  • Solano · 560 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
51 51 Solano Solano 95 2021-09-02 41521 273 TRUE
112 112 Solano Solano 95 2021-09-01 41521 273  
173 173 Solano Solano 95 2021-08-31 40477 270 TRUE
234 234 Solano Solano 95 2021-08-30 40477 270  
295 295 Solano Solano 95 2021-08-29 39800 266 TRUE
356 356 Solano Solano 95 2021-08-28 39800 266 TRUE
417 417 Solano Solano 95 2021-08-27 39800 266  
478 478 Solano Solano 95 2021-08-26 39329 266 TRUE
539 539 Solano Solano 95 2021-08-25 39329 266  
600 600 Solano Solano 95 2021-08-24 39002 264 TRUE
661 661 Solano Solano 95 2021-08-23 39002 264  
722 722 Solano Solano 95 2021-08-22 38764 262 TRUE
783 783 Solano Solano 95 2021-08-21 38764 262 TRUE
844 844 Solano Solano 95 2021-08-20 38764 262  
905 905 Solano Solano 95 2021-08-19 38294 259 TRUE
966 966 Solano Solano 95 2021-08-18 38294 259  
1027 1027 Solano Solano 95 2021-08-17 37914 259 TRUE
1088 1088 Solano Solano 95 2021-08-16 37914 259  
1149 1149 Solano Solano 95 2021-08-15 37664 254 TRUE
1210 1210 Solano Solano 95 2021-08-14 37664 254 TRUE
1271 1271 Solano Solano 95 2021-08-13 37664 254  
1332 1332 Solano Solano 95 2021-08-12 37350 254 TRUE
1393 1393 Solano Solano 95 2021-08-11 37350 254  
1454 1454 Solano Solano 95 2021-08-10 37056 254  
1515 1515 Solano Solano 95 2021-08-09 37056 254  
1576 1576 Solano Solano 95 2021-08-08 36848 249 TRUE
1637 1637 Solano Solano 95 2021-08-07 36848 249 TRUE
1698 1698 Solano Solano 95 2021-08-06 36848 249  
1759 1759 Solano Solano 95 2021-08-05 36525 249 TRUE
1820 1820 Solano Solano 95 2021-08-04 36525 249  
1881 1881 Solano Solano 95 2021-08-03 36249 249  
1942 1942 Solano Solano 95 2021-08-02 36249 249  
2003 2003 Solano Solano 95 2021-08-01 36004 249 TRUE
2064 2064 Solano Solano 95 2021-07-31 36004 249 TRUE
2125 2125 Solano Solano 95 2021-07-30 36004 249  
2186 2186 Solano Solano 95 2021-07-29 35703 249 TRUE
2247 2247 Solano Solano 95 2021-07-28 35703 249  
2308 2308 Solano Solano 95 2021-07-27 35482 245 TRUE
2369 2369 Solano Solano 95 2021-07-26 35482 245  
2430 2430 Solano Solano 95 2021-07-25 35193 245 TRUE
2491 2491 Solano Solano 95 2021-07-24 35193 245 TRUE
2552 2552 Solano Solano 95 2021-07-23 35193 245  
2613 2613 Solano Solano 95 2021-07-22 34885 245  
2674 2674 Solano Solano 95 2021-07-21 34885 245  
2735 2735 Solano Solano 95 2021-07-20 34761 245 TRUE
2796 2796 Solano Solano 95 2021-07-19 34761 245  
2857 2857 Solano Solano 95 2021-07-18 34630 245 TRUE
2918 2918 Solano Solano 95 2021-07-17 34630 245 TRUE
2979 2979 Solano Solano 95 2021-07-16 34630 245  
3040 3040 Solano Solano 95 2021-07-15 34461 245  
3101 3101 Solano Solano 95 2021-07-14 34461 245  
3162 3162 Solano Solano 95 2021-07-13 34377 245 TRUE
3223 3223 Solano Solano 95 2021-07-12 34377 245  
3284 3284 Solano Solano 95 2021-07-11 34240 245 TRUE
3345 3345 Solano Solano 95 2021-07-10 34240 245  
3406 3406 Solano Solano 95 2021-07-09 34149 245  
3467 3467 Solano Solano 95 2021-07-08 34149 245  
3528 3528 Solano Solano 95 2021-07-07 34149 245  
3589 3589 Solano Solano 95 2021-07-06 34044 244  
3650 3650 Solano Solano 95 2021-07-05 34044 244 TRUE
3711 3711 Solano Solano 95 2021-07-04 34044 244 TRUE
3772 3772 Solano Solano 95 2021-07-03 34044 244 TRUE
3833 3833 Solano Solano 95 2021-07-02 34044 244  
3894 3894 Solano Solano 95 2021-07-01 33973 244  
3955 3955 Solano Solano 95 2021-06-30 33973 244  
4016 4016 Solano Solano 95 2021-06-29 33898 244 TRUE
4077 4077 Solano Solano 95 2021-06-28 33898 244  
4138 4138 Solano Solano 95 2021-06-27 33846 244 TRUE
4199 4199 Solano Solano 95 2021-06-26 33846 244 TRUE
4260 4260 Solano Solano 95 2021-06-25 33846 244  
4321 4321 Solano Solano 95 2021-06-24 33797 244 TRUE
4382 4382 Solano Solano 95 2021-06-23 33797 244  
4443 4443 Solano Solano 95 2021-06-22 33762 244  
4504 4504 Solano Solano 95 2021-06-21 33762 244  
4565 4565 Solano Solano 95 2021-06-20 33707 244 TRUE
4626 4626 Solano Solano 95 2021-06-19 33707 244 TRUE
4687 4687 Solano Solano 95 2021-06-18 33707 244  
4748 4748 Solano Solano 95 2021-06-17 33673 244  
4809 4809 Solano Solano 95 2021-06-16 33651 244  
4870 4870 Solano Solano 95 2021-06-15 33636 244  
4931 4931 Solano Solano 95 2021-06-14 33625 244  
4992 4992 Solano Solano 95 2021-06-13 33569 244 TRUE
5053 5053 Solano Solano 95 2021-06-12 33569 244 TRUE
5114 5114 Solano Solano 95 2021-06-11 33569 244  
5175 5175 Solano Solano 95 2021-06-10 33559 244  
5236 5236 Solano Solano 95 2021-06-09 33533 244  
5297 5297 Solano Solano 95 2021-06-08 33518 244  
5358 5358 Solano Solano 95 2021-06-07 33511 244  
5419 5419 Solano Solano 95 2021-06-06 33491 244 TRUE
5480 5480 Solano Solano 95 2021-06-05 33491 244 TRUE
5541 5541 Solano Solano 95 2021-06-04 33491 244  
5602 5602 Solano Solano 95 2021-06-03 33469 243  
5663 5663 Solano Solano 95 2021-06-02 33430 243  
5724 5724 Solano Solano 95 2021-06-01 33397 243  
5785 5785 Solano Solano 95 2021-05-31 33293 238 TRUE
5846 5846 Solano Solano 95 2021-05-30 33293 238  
5907 5907 Solano Solano 95 2021-05-29 33293 238 TRUE
5968 5968 Solano Solano 95 2021-05-28 33293 238  
6029 6029 Solano Solano 95 2021-05-27 33261 234  
6090 6090 Solano Solano 95 2021-05-26 33218 234  

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