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

  • Riverside · 559 ✖

agency 1

Link rowid agency county fips date ▲ confirmed_cases deaths did_not_update
36 36 Riverside Riverside 65 2021-09-02 337921 4749  
97 97 Riverside Riverside 65 2021-09-01 337075 4738  
158 158 Riverside Riverside 65 2021-08-31 336053 4731  
219 219 Riverside Riverside 65 2021-08-30 334846 4727  
280 280 Riverside Riverside 65 2021-08-29 332499 4727 TRUE
341 341 Riverside Riverside 65 2021-08-28 332499 4727 TRUE
402 402 Riverside Riverside 65 2021-08-27 332499 4727  
463 463 Riverside Riverside 65 2021-08-26 331416 4719  
524 524 Riverside Riverside 65 2021-08-25 330327 4713  
585 585 Riverside Riverside 65 2021-08-24 329184 4707  
646 646 Riverside Riverside 65 2021-08-23 327971 4701  
707 707 Riverside Riverside 65 2021-08-22 325944 4697 TRUE
768 768 Riverside Riverside 65 2021-08-21 325944 4697 TRUE
829 829 Riverside Riverside 65 2021-08-20 325944 4697  
890 890 Riverside Riverside 65 2021-08-19 324739 4693  
951 951 Riverside Riverside 65 2021-08-18 323578 4689  
1012 1012 Riverside Riverside 65 2021-08-17 322251 4686  
1073 1073 Riverside Riverside 65 2021-08-16 320777 4686  
1134 1134 Riverside Riverside 65 2021-08-15 319733 4685 TRUE
1195 1195 Riverside Riverside 65 2021-08-14 319733 4685 TRUE
1256 1256 Riverside Riverside 65 2021-08-13 319733 4685  
1317 1317 Riverside Riverside 65 2021-08-12 318681 4679  
1378 1378 Riverside Riverside 65 2021-08-11 317814 4674  
1439 1439 Riverside Riverside 65 2021-08-10 316405 4669  
1500 1500 Riverside Riverside 65 2021-08-09 314862 4667  
1561 1561 Riverside Riverside 65 2021-08-08 313931 4667 TRUE
1622 1622 Riverside Riverside 65 2021-08-07 313931 4667 TRUE
1683 1683 Riverside Riverside 65 2021-08-06 313931 4667  
1744 1744 Riverside Riverside 65 2021-08-05 312705 4667  
1805 1805 Riverside Riverside 65 2021-08-04 311573 4667  
1866 1866 Riverside Riverside 65 2021-08-03 311242 4667  
1927 1927 Riverside Riverside 65 2021-08-02 309217 4667  
1988 1988 Riverside Riverside 65 2021-08-01 308546 4662 TRUE
2049 2049 Riverside Riverside 65 2021-07-31 308546 4662 TRUE
2110 2110 Riverside Riverside 65 2021-07-30 308546 4662 TRUE
2171 2171 Riverside Riverside 65 2021-07-29 307922 4659  
2232 2232 Riverside Riverside 65 2021-07-28 306836 4659 TRUE
2293 2293 Riverside Riverside 65 2021-07-27 306836 4659  
2354 2354 Riverside Riverside 65 2021-07-26 305589 4658  
2415 2415 Riverside Riverside 65 2021-07-25 305195 4658 TRUE
2476 2476 Riverside Riverside 65 2021-07-24 305195 4658  
2537 2537 Riverside Riverside 65 2021-07-23 304512 4657  
2598 2598 Riverside Riverside 65 2021-07-22 304060 4657 TRUE
2659 2659 Riverside Riverside 65 2021-07-21 304060 4657  
2720 2720 Riverside Riverside 65 2021-07-20 302069 4647 TRUE
2781 2781 Riverside Riverside 65 2021-07-19 302069 4647 TRUE
2842 2842 Riverside Riverside 65 2021-07-18 302069 4647 TRUE
2903 2903 Riverside Riverside 65 2021-07-17 302069 4647 TRUE
2964 2964 Riverside Riverside 65 2021-07-16 302069 4647 TRUE
3025 3025 Riverside Riverside 65 2021-07-15 302069 4647  
3086 3086 Riverside Riverside 65 2021-07-14 302069 4647  
3147 3147 Riverside Riverside 65 2021-07-13 302069 4647 TRUE
3208 3208 Riverside Riverside 65 2021-07-12 302069 4647 TRUE
3269 3269 Riverside Riverside 65 2021-07-11 302069 4647 TRUE
3330 3330 Riverside Riverside 65 2021-07-10 302069 4647 TRUE
3391 3391 Riverside Riverside 65 2021-07-09 302069 4647  
3452 3452 Riverside Riverside 65 2021-07-08 302069 4647 TRUE
3513 3513 Riverside Riverside 65 2021-07-07 302069 4647  
3574 3574 Riverside Riverside 65 2021-07-06 301820 4640  
3635 3635 Riverside Riverside 65 2021-07-05 301820 4640 TRUE
3696 3696 Riverside Riverside 65 2021-07-04 301820 4640 TRUE
3757 3757 Riverside Riverside 65 2021-07-03 301820 4640 TRUE
3818 3818 Riverside Riverside 65 2021-07-02 301820 4640  
3879 3879 Riverside Riverside 65 2021-07-01 301774 4637  
3940 3940 Riverside Riverside 65 2021-06-30 301706 4636  
4001 4001 Riverside Riverside 65 2021-06-29 301706 4627  
4062 4062 Riverside Riverside 65 2021-06-28 301706 4627 TRUE
4123 4123 Riverside Riverside 65 2021-06-27 301706 4627 TRUE
4184 4184 Riverside Riverside 65 2021-06-26 301706 4627 TRUE
4245 4245 Riverside Riverside 65 2021-06-25 301706 4627  
4306 4306 Riverside Riverside 65 2021-06-24 301655 4627 TRUE
4367 4367 Riverside Riverside 65 2021-06-23 301655 4627 TRUE
4428 4428 Riverside Riverside 65 2021-06-22 301655 4627  
4489 4489 Riverside Riverside 65 2021-06-21 301655 4627  
4550 4550 Riverside Riverside 65 2021-06-20 301603 4627 TRUE
4611 4611 Riverside Riverside 65 2021-06-19 301603 4627 TRUE
4672 4672 Riverside Riverside 65 2021-06-18 301603 4627  
4733 4733 Riverside Riverside 65 2021-06-17 301543 4625  
4794 4794 Riverside Riverside 65 2021-06-16 301482 4624  
4855 4855 Riverside Riverside 65 2021-06-15 301420 4622  
4916 4916 Riverside Riverside 65 2021-06-14 301329 4620  
4977 4977 Riverside Riverside 65 2021-06-13 301312 4618 TRUE
5038 5038 Riverside Riverside 65 2021-06-12 301312 4618 TRUE
5099 5099 Riverside Riverside 65 2021-06-11 301312 4618  
5160 5160 Riverside Riverside 65 2021-06-10 301284 4617  
5221 5221 Riverside Riverside 65 2021-06-09 301178 4617  
5282 5282 Riverside Riverside 65 2021-06-08 301128 4617  
5343 5343 Riverside Riverside 65 2021-06-07 301013 4618  
5404 5404 Riverside Riverside 65 2021-06-06 300929 4616 TRUE
5465 5465 Riverside Riverside 65 2021-06-05 300929 4616 TRUE
5526 5526 Riverside Riverside 65 2021-06-04 300929 4616  
5587 5587 Riverside Riverside 65 2021-06-03 300879 4614  
5648 5648 Riverside Riverside 65 2021-06-02 300851 4612  
5709 5709 Riverside Riverside 65 2021-06-01 300732 4608  
5770 5770 Riverside Riverside 65 2021-05-31 300701 4608 TRUE
5831 5831 Riverside Riverside 65 2021-05-30 300701 4608  
5892 5892 Riverside Riverside 65 2021-05-29 300701 4608 TRUE
5953 5953 Riverside Riverside 65 2021-05-28 300701 4608  
6014 6014 Riverside Riverside 65 2021-05-27 300631 4608  
6075 6075 Riverside Riverside 65 2021-05-26 300550 4608  

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