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 county = "Shasta" 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

  • Shasta · 559 ✖

agency 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
48 48 Shasta Shasta 89 2021-09-02 15889 255  
109 109 Shasta Shasta 89 2021-09-01 15730 254  
170 170 Shasta Shasta 89 2021-08-31 15514 254  
231 231 Shasta Shasta 89 2021-08-30 15353 254  
292 292 Shasta Shasta 89 2021-08-29 15201 252 TRUE
353 353 Shasta Shasta 89 2021-08-28 15201 252 TRUE
414 414 Shasta Shasta 89 2021-08-27 15201 252  
475 475 Shasta Shasta 89 2021-08-26 15060 252  
536 536 Shasta Shasta 89 2021-08-25 14881 252  
597 597 Shasta Shasta 89 2021-08-24 14766 252  
658 658 Shasta Shasta 89 2021-08-23 14591 251  
719 719 Shasta Shasta 89 2021-08-22 14322 251 TRUE
780 780 Shasta Shasta 89 2021-08-21 14322 251 TRUE
841 841 Shasta Shasta 89 2021-08-20 14322 251  
902 902 Shasta Shasta 89 2021-08-19 14224 251  
963 963 Shasta Shasta 89 2021-08-18 14100 250  
1024 1024 Shasta Shasta 89 2021-08-17 14001 247  
1085 1085 Shasta Shasta 89 2021-08-16 13917 244  
1146 1146 Shasta Shasta 89 2021-08-15 13791 244 TRUE
1207 1207 Shasta Shasta 89 2021-08-14 13791 244 TRUE
1268 1268 Shasta Shasta 89 2021-08-13 13791 244  
1329 1329 Shasta Shasta 89 2021-08-12 13685 244  
1390 1390 Shasta Shasta 89 2021-08-11 13604 244  
1451 1451 Shasta Shasta 89 2021-08-10 13485 244  
1512 1512 Shasta Shasta 89 2021-08-09 13412 243  
1573 1573 Shasta Shasta 89 2021-08-08 13382 243 TRUE
1634 1634 Shasta Shasta 89 2021-08-07 13382 243 TRUE
1695 1695 Shasta Shasta 89 2021-08-06 13382 243  
1756 1756 Shasta Shasta 89 2021-08-05 13310 243  
1817 1817 Shasta Shasta 89 2021-08-04 13179 242  
1878 1878 Shasta Shasta 89 2021-08-03 13119 242  
1939 1939 Shasta Shasta 89 2021-08-02 13068 242  
2000 2000 Shasta Shasta 89 2021-08-01 13043 242 TRUE
2061 2061 Shasta Shasta 89 2021-07-31 13043 242 TRUE
2122 2122 Shasta Shasta 89 2021-07-30 13043 242  
2183 2183 Shasta Shasta 89 2021-07-29 12963 242  
2244 2244 Shasta Shasta 89 2021-07-28 12925 242  
2305 2305 Shasta Shasta 89 2021-07-27 12876 242  
2366 2366 Shasta Shasta 89 2021-07-26 12845 242  
2427 2427 Shasta Shasta 89 2021-07-25 12804 242 TRUE
2488 2488 Shasta Shasta 89 2021-07-24 12804 242 TRUE
2549 2549 Shasta Shasta 89 2021-07-23 12804 242  
2610 2610 Shasta Shasta 89 2021-07-22 12786 242  
2671 2671 Shasta Shasta 89 2021-07-21 12766 242  
2732 2732 Shasta Shasta 89 2021-07-20 12749 242  
2793 2793 Shasta Shasta 89 2021-07-19 12728 242  
2854 2854 Shasta Shasta 89 2021-07-18 12693 242 TRUE
2915 2915 Shasta Shasta 89 2021-07-17 12693 242  
2976 2976 Shasta Shasta 89 2021-07-16 12693 242  
3037 3037 Shasta Shasta 89 2021-07-15 12614 238 TRUE
3098 3098 Shasta Shasta 89 2021-07-14 12614 238 TRUE
3159 3159 Shasta Shasta 89 2021-07-13 12614 238 TRUE
3220 3220 Shasta Shasta 89 2021-07-12 12614 238 TRUE
3281 3281 Shasta Shasta 89 2021-07-11 12614 238 TRUE
3342 3342 Shasta Shasta 89 2021-07-10 12614 238 TRUE
3403 3403 Shasta Shasta 89 2021-07-09 12614 238  
3464 3464 Shasta Shasta 89 2021-07-08 12605 238  
3525 3525 Shasta Shasta 89 2021-07-07 12605 235 TRUE
3586 3586 Shasta Shasta 89 2021-07-06 12605 235 TRUE
3647 3647 Shasta Shasta 89 2021-07-05 12605 235 TRUE
3708 3708 Shasta Shasta 89 2021-07-04 12605 235 TRUE
3769 3769 Shasta Shasta 89 2021-07-03 12605 235 TRUE
3830 3830 Shasta Shasta 89 2021-07-02 12605 235 TRUE
3891 3891 Shasta Shasta 89 2021-07-01 12605 235 TRUE
3952 3952 Shasta Shasta 89 2021-06-30 12605 235 TRUE
4013 4013 Shasta Shasta 89 2021-06-29 12605 235  
4074 4074 Shasta Shasta 89 2021-06-28 12605 235 TRUE
4135 4135 Shasta Shasta 89 2021-06-27 12605 235 TRUE
4196 4196 Shasta Shasta 89 2021-06-26 12605 235 TRUE
4257 4257 Shasta Shasta 89 2021-06-25 12605 235  
4318 4318 Shasta Shasta 89 2021-06-24 12605 235  
4379 4379 Shasta Shasta 89 2021-06-23 12605 235  
4440 4440 Shasta Shasta 89 2021-06-22 12605 235 TRUE
4501 4501 Shasta Shasta 89 2021-06-21 12605 233 TRUE
4562 4562 Shasta Shasta 89 2021-06-20 12605 233 TRUE
4623 4623 Shasta Shasta 89 2021-06-19 12605 233 TRUE
4684 4684 Shasta Shasta 89 2021-06-18 12605 233 TRUE
4745 4745 Shasta Shasta 89 2021-06-17 12605 233 TRUE
4806 4806 Shasta Shasta 89 2021-06-16 12605 233 TRUE
4867 4867 Shasta Shasta 89 2021-06-15 12605 233  
4928 4928 Shasta Shasta 89 2021-06-14 12599 232  
4989 4989 Shasta Shasta 89 2021-06-13 12580 232 TRUE
5050 5050 Shasta Shasta 89 2021-06-12 12580 232 TRUE
5111 5111 Shasta Shasta 89 2021-06-11 12580 232  
5172 5172 Shasta Shasta 89 2021-06-10 12559 232  
5233 5233 Shasta Shasta 89 2021-06-09 12539 230  
5294 5294 Shasta Shasta 89 2021-06-08 12526 230  
5355 5355 Shasta Shasta 89 2021-06-07 12494 230  
5416 5416 Shasta Shasta 89 2021-06-06 12467 230 TRUE
5477 5477 Shasta Shasta 89 2021-06-05 12467 230 TRUE
5538 5538 Shasta Shasta 89 2021-06-04 12467 230  
5599 5599 Shasta Shasta 89 2021-06-03 12446 230  
5660 5660 Shasta Shasta 89 2021-06-02 12420 230  
5721 5721 Shasta Shasta 89 2021-06-01 12420 230  
5782 5782 Shasta Shasta 89 2021-05-31 12413 230 TRUE
5843 5843 Shasta Shasta 89 2021-05-30 12413 230  
5904 5904 Shasta Shasta 89 2021-05-29 12413 230 TRUE
5965 5965 Shasta Shasta 89 2021-05-28 12413 230  
6026 6026 Shasta Shasta 89 2021-05-27 12409 229  
6087 6087 Shasta Shasta 89 2021-05-26 12382 229  

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