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 = "Yolo" 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

county 1

agency 1

  • Yolo · 559 ✖
Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
60 60 Yolo Yolo 113 2021-09-02 17244 231  
121 121 Yolo Yolo 113 2021-09-01 17176 231  
182 182 Yolo Yolo 113 2021-08-31 17050 231  
243 243 Yolo Yolo 113 2021-08-30 16925 229  
304 304 Yolo Yolo 113 2021-08-29 16760 229 TRUE
365 365 Yolo Yolo 113 2021-08-28 16760 229 TRUE
426 426 Yolo Yolo 113 2021-08-27 16760 229  
487 487 Yolo Yolo 113 2021-08-26 16642 229  
548 548 Yolo Yolo 113 2021-08-25 16534 229  
609 609 Yolo Yolo 113 2021-08-24 16458 229  
670 670 Yolo Yolo 113 2021-08-23 16368 224  
731 731 Yolo Yolo 113 2021-08-22 16165 223 TRUE
792 792 Yolo Yolo 113 2021-08-21 16165 223 TRUE
853 853 Yolo Yolo 113 2021-08-20 16165 223  
914 914 Yolo Yolo 113 2021-08-19 16047 223  
975 975 Yolo Yolo 113 2021-08-18 15986 223  
1036 1036 Yolo Yolo 113 2021-08-17 15933 223  
1097 1097 Yolo Yolo 113 2021-08-16 15877 223  
1158 1158 Yolo Yolo 113 2021-08-15 15716 223 TRUE
1219 1219 Yolo Yolo 113 2021-08-14 15716 223 TRUE
1280 1280 Yolo Yolo 113 2021-08-13 15716 223  
1341 1341 Yolo Yolo 113 2021-08-12 15635 222  
1402 1402 Yolo Yolo 113 2021-08-11 15560 216  
1463 1463 Yolo Yolo 113 2021-08-10 15533 216  
1524 1524 Yolo Yolo 113 2021-08-09 15431 216  
1585 1585 Yolo Yolo 113 2021-08-08 15252 216 TRUE
1646 1646 Yolo Yolo 113 2021-08-07 15252 216 TRUE
1707 1707 Yolo Yolo 113 2021-08-06 15252 216  
1768 1768 Yolo Yolo 113 2021-08-05 15208 216  
1829 1829 Yolo Yolo 113 2021-08-04 15132 213  
1890 1890 Yolo Yolo 113 2021-08-03 15039 213  
1951 1951 Yolo Yolo 113 2021-08-02 15039 213  
2012 2012 Yolo Yolo 113 2021-08-01 14863 213 TRUE
2073 2073 Yolo Yolo 113 2021-07-31 14863 213 TRUE
2134 2134 Yolo Yolo 113 2021-07-30 14863 213  
2195 2195 Yolo Yolo 113 2021-07-29 14799 213  
2256 2256 Yolo Yolo 113 2021-07-28 14755 213  
2317 2317 Yolo Yolo 113 2021-07-27 14740 213  
2378 2378 Yolo Yolo 113 2021-07-26 14699 213  
2439 2439 Yolo Yolo 113 2021-07-25 14574 213 TRUE
2500 2500 Yolo Yolo 113 2021-07-24 14574 213 TRUE
2561 2561 Yolo Yolo 113 2021-07-23 14574 213  
2622 2622 Yolo Yolo 113 2021-07-22 14523 212  
2683 2683 Yolo Yolo 113 2021-07-21 14498 211  
2744 2744 Yolo Yolo 113 2021-07-20 14450 211  
2805 2805 Yolo Yolo 113 2021-07-19 14426 211  
2866 2866 Yolo Yolo 113 2021-07-18 14358 211 TRUE
2927 2927 Yolo Yolo 113 2021-07-17 14358 211 TRUE
2988 2988 Yolo Yolo 113 2021-07-16 14358 211  
3049 3049 Yolo Yolo 113 2021-07-15 14315 211  
3110 3110 Yolo Yolo 113 2021-07-14 14291 211  
3171 3171 Yolo Yolo 113 2021-07-13 14272 210  
3232 3232 Yolo Yolo 113 2021-07-12 14254 210  
3293 3293 Yolo Yolo 113 2021-07-11 14219 210 TRUE
3354 3354 Yolo Yolo 113 2021-07-10 14219 210 TRUE
3415 3415 Yolo Yolo 113 2021-07-09 14219 210  
3476 3476 Yolo Yolo 113 2021-07-08 14194 210  
3537 3537 Yolo Yolo 113 2021-07-07 14180 210  
3598 3598 Yolo Yolo 113 2021-07-06 14170 210  
3659 3659 Yolo Yolo 113 2021-07-05 14147 210 TRUE
3720 3720 Yolo Yolo 113 2021-07-04 14147 210 TRUE
3781 3781 Yolo Yolo 113 2021-07-03 14147 210 TRUE
3842 3842 Yolo Yolo 113 2021-07-02 14147 210  
3903 3903 Yolo Yolo 113 2021-07-01 14135 210  
3964 3964 Yolo Yolo 113 2021-06-30 14130 210  
4025 4025 Yolo Yolo 113 2021-06-29 14124 210  
4086 4086 Yolo Yolo 113 2021-06-28 14124 210  
4147 4147 Yolo Yolo 113 2021-06-27 14122 210 TRUE
4208 4208 Yolo Yolo 113 2021-06-26 14122 210 TRUE
4269 4269 Yolo Yolo 113 2021-06-25 14122 210  
4330 4330 Yolo Yolo 113 2021-06-24 14116 210  
4391 4391 Yolo Yolo 113 2021-06-23 14109 209  
4452 4452 Yolo Yolo 113 2021-06-22 14109 209  
4513 4513 Yolo Yolo 113 2021-06-21 14099 209  
4574 4574 Yolo Yolo 113 2021-06-20 14082 209 TRUE
4635 4635 Yolo Yolo 113 2021-06-19 14082 209 TRUE
4696 4696 Yolo Yolo 113 2021-06-18 14082 209  
4757 4757 Yolo Yolo 113 2021-06-17 14079 209  
4818 4818 Yolo Yolo 113 2021-06-16 14070 209  
4879 4879 Yolo Yolo 113 2021-06-15 14064 209  
4940 4940 Yolo Yolo 113 2021-06-14 14062 209  
5001 5001 Yolo Yolo 113 2021-06-13 14049 209 TRUE
5062 5062 Yolo Yolo 113 2021-06-12 14049 209 TRUE
5123 5123 Yolo Yolo 113 2021-06-11 14049 209  
5184 5184 Yolo Yolo 113 2021-06-10 14041 209  
5245 5245 Yolo Yolo 113 2021-06-09 14037 209  
5306 5306 Yolo Yolo 113 2021-06-08 14034 209  
5367 5367 Yolo Yolo 113 2021-06-07 14025 208  
5428 5428 Yolo Yolo 113 2021-06-06 14017 208 TRUE
5489 5489 Yolo Yolo 113 2021-06-05 14017 208 TRUE
5550 5550 Yolo Yolo 113 2021-06-04 14017 208  
5611 5611 Yolo Yolo 113 2021-06-03 14012 208  
5672 5672 Yolo Yolo 113 2021-06-02 14000 208  
5733 5733 Yolo Yolo 113 2021-06-01 13995 208  
5794 5794 Yolo Yolo 113 2021-05-31 13982 208 TRUE
5855 5855 Yolo Yolo 113 2021-05-30 13982 208  
5916 5916 Yolo Yolo 113 2021-05-29 13982 208 TRUE
5977 5977 Yolo Yolo 113 2021-05-28 13982 208  
6038 6038 Yolo Yolo 113 2021-05-27 13968 208  
6099 6099 Yolo Yolo 113 2021-05-26 13957 208  

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