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 fips = 61 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

  • 61 · 559 ✖

county 1

agency 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
34 34 Placer Placer 61 2021-09-02 31104 331  
95 95 Placer Placer 61 2021-09-01 30796 326 TRUE
156 156 Placer Placer 61 2021-08-31 30796 326  
217 217 Placer Placer 61 2021-08-30 28948 316 TRUE
278 278 Placer Placer 61 2021-08-29 28948 316 TRUE
339 339 Placer Placer 61 2021-08-28 28948 316 TRUE
400 400 Placer Placer 61 2021-08-27 28948 316 TRUE
461 461 Placer Placer 61 2021-08-26 28948 316  
522 522 Placer Placer 61 2021-08-25 28665 316 TRUE
583 583 Placer Placer 61 2021-08-24 28665 316  
644 644 Placer Placer 61 2021-08-23 28008 313 TRUE
705 705 Placer Placer 61 2021-08-22 28008 313 TRUE
766 766 Placer Placer 61 2021-08-21 28008 313 TRUE
827 827 Placer Placer 61 2021-08-20 28008 313 TRUE
888 888 Placer Placer 61 2021-08-19 28008 313  
949 949 Placer Placer 61 2021-08-18 27691 312 TRUE
1010 1010 Placer Placer 61 2021-08-17 27691 312  
1071 1071 Placer Placer 61 2021-08-16 26905 308 TRUE
1132 1132 Placer Placer 61 2021-08-15 26905 308 TRUE
1193 1193 Placer Placer 61 2021-08-14 26905 308 TRUE
1254 1254 Placer Placer 61 2021-08-13 26905 308 TRUE
1315 1315 Placer Placer 61 2021-08-12 26905 308  
1376 1376 Placer Placer 61 2021-08-11 26609 307 TRUE
1437 1437 Placer Placer 61 2021-08-10 26609 307  
1498 1498 Placer Placer 61 2021-08-09 26004 307 TRUE
1559 1559 Placer Placer 61 2021-08-08 26004 307 TRUE
1620 1620 Placer Placer 61 2021-08-07 26004 307 TRUE
1681 1681 Placer Placer 61 2021-08-06 26004 307 TRUE
1742 1742 Placer Placer 61 2021-08-05 26004 307  
1803 1803 Placer Placer 61 2021-08-04 25559 307 TRUE
1864 1864 Placer Placer 61 2021-08-03 25559 307  
1925 1925 Placer Placer 61 2021-08-02 25146 307 TRUE
1986 1986 Placer Placer 61 2021-08-01 25146 307 TRUE
2047 2047 Placer Placer 61 2021-07-31 25146 307 TRUE
2108 2108 Placer Placer 61 2021-07-30 25146 307 TRUE
2169 2169 Placer Placer 61 2021-07-29 25146 307  
2230 2230 Placer Placer 61 2021-07-28 24955 307 TRUE
2291 2291 Placer Placer 61 2021-07-27 24955 307  
2352 2352 Placer Placer 61 2021-07-26 24483 304 TRUE
2413 2413 Placer Placer 61 2021-07-25 24483 304 TRUE
2474 2474 Placer Placer 61 2021-07-24 24483 304 TRUE
2535 2535 Placer Placer 61 2021-07-23 24483 304 TRUE
2596 2596 Placer Placer 61 2021-07-22 24483 304 TRUE
2657 2657 Placer Placer 61 2021-07-21 24483 304  
2718 2718 Placer Placer 61 2021-07-20 24176 304 TRUE
2779 2779 Placer Placer 61 2021-07-19 24176 304 TRUE
2840 2840 Placer Placer 61 2021-07-18 24176 304 TRUE
2901 2901 Placer Placer 61 2021-07-17 24176 304 TRUE
2962 2962 Placer Placer 61 2021-07-16 24176 304 TRUE
3023 3023 Placer Placer 61 2021-07-15 24176 304 TRUE
3084 3084 Placer Placer 61 2021-07-14 24176 304  
3145 3145 Placer Placer 61 2021-07-13 23943 303 TRUE
3206 3206 Placer Placer 61 2021-07-12 23943 303 TRUE
3267 3267 Placer Placer 61 2021-07-11 23943 303 TRUE
3328 3328 Placer Placer 61 2021-07-10 23943 303 TRUE
3389 3389 Placer Placer 61 2021-07-09 23943 303  
3450 3450 Placer Placer 61 2021-07-08 23943 303 TRUE
3511 3511 Placer Placer 61 2021-07-07 23943 303  
3572 3572 Placer Placer 61 2021-07-06 23846 300  
3633 3633 Placer Placer 61 2021-07-05 23846 300 TRUE
3694 3694 Placer Placer 61 2021-07-04 23846 300 TRUE
3755 3755 Placer Placer 61 2021-07-03 23846 300 TRUE
3816 3816 Placer Placer 61 2021-07-02 23846 300  
3877 3877 Placer Placer 61 2021-07-01 23793 300  
3938 3938 Placer Placer 61 2021-06-30 23755 300  
3999 3999 Placer Placer 61 2021-06-29 23726 300  
4060 4060 Placer Placer 61 2021-06-28 23726 300  
4121 4121 Placer Placer 61 2021-06-27 23673 300 TRUE
4182 4182 Placer Placer 61 2021-06-26 23673 300 TRUE
4243 4243 Placer Placer 61 2021-06-25 23673 300  
4304 4304 Placer Placer 61 2021-06-24 23633 300 TRUE
4365 4365 Placer Placer 61 2021-06-23 23633 300  
4426 4426 Placer Placer 61 2021-06-22 23604 300  
4487 4487 Placer Placer 61 2021-06-21 23589 299  
4548 4548 Placer Placer 61 2021-06-20 23518 299 TRUE
4609 4609 Placer Placer 61 2021-06-19 23518 299 TRUE
4670 4670 Placer Placer 61 2021-06-18 23518 299  
4731 4731 Placer Placer 61 2021-06-17 23477 299  
4792 4792 Placer Placer 61 2021-06-16 23438 299  
4853 4853 Placer Placer 61 2021-06-15 23410 299  
4914 4914 Placer Placer 61 2021-06-14 23383 299  
4975 4975 Placer Placer 61 2021-06-13 23338 298 TRUE
5036 5036 Placer Placer 61 2021-06-12 23338 298 TRUE
5097 5097 Placer Placer 61 2021-06-11 23338 298  
5158 5158 Placer Placer 61 2021-06-10 23305 297  
5219 5219 Placer Placer 61 2021-06-09 23257 297  
5280 5280 Placer Placer 61 2021-06-08 23228 297  
5341 5341 Placer Placer 61 2021-06-07 23196 297  
5402 5402 Placer Placer 61 2021-06-06 23127 297 TRUE
5463 5463 Placer Placer 61 2021-06-05 23127 297 TRUE
5524 5524 Placer Placer 61 2021-06-04 23127 297  
5585 5585 Placer Placer 61 2021-06-03 23118 297  
5646 5646 Placer Placer 61 2021-06-02 23075 297  
5707 5707 Placer Placer 61 2021-06-01 23042 297  
5768 5768 Placer Placer 61 2021-05-31 23004 297 TRUE
5829 5829 Placer Placer 61 2021-05-30 23004 297  
5890 5890 Placer Placer 61 2021-05-29 23004 297 TRUE
5951 5951 Placer Placer 61 2021-05-28 23004 297  
6012 6012 Placer Placer 61 2021-05-27 22983 296  
6073 6073 Placer Placer 61 2021-05-26 22956 296  

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