latimes_county_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_county_totals

559 rows where fips = 65 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 1

  • 65 · 559 ✖

county 1

Link rowid date ▲ county fips confirmed_cases deaths new_confirmed_cases new_deaths
33 33 2021-09-02 Riverside 65 337921 4749 846 11
91 91 2021-09-01 Riverside 65 337075 4738 1022 7
149 149 2021-08-31 Riverside 65 336053 4731 1207 4
207 207 2021-08-30 Riverside 65 334846 4727 2347 0
265 265 2021-08-29 Riverside 65 332499 4727 0 0
323 323 2021-08-28 Riverside 65 332499 4727 0 0
381 381 2021-08-27 Riverside 65 332499 4727 1083 8
439 439 2021-08-26 Riverside 65 331416 4719 1089 6
497 497 2021-08-25 Riverside 65 330327 4713 1143 6
555 555 2021-08-24 Riverside 65 329184 4707 1213 6
613 613 2021-08-23 Riverside 65 327971 4701 2027 4
671 671 2021-08-22 Riverside 65 325944 4697 0 0
729 729 2021-08-21 Riverside 65 325944 4697 0 0
787 787 2021-08-20 Riverside 65 325944 4697 1205 4
845 845 2021-08-19 Riverside 65 324739 4693 1161 4
903 903 2021-08-18 Riverside 65 323578 4689 1327 3
961 961 2021-08-17 Riverside 65 322251 4686 1474 0
1019 1019 2021-08-16 Riverside 65 320777 4686 1044 1
1077 1077 2021-08-15 Riverside 65 319733 4685 0 0
1135 1135 2021-08-14 Riverside 65 319733 4685 0 0
1193 1193 2021-08-13 Riverside 65 319733 4685 1052 6
1251 1251 2021-08-12 Riverside 65 318681 4679 867 5
1309 1309 2021-08-11 Riverside 65 317814 4674 1409 5
1367 1367 2021-08-10 Riverside 65 316405 4669 1543 2
1425 1425 2021-08-09 Riverside 65 314862 4667 931 0
1483 1483 2021-08-08 Riverside 65 313931 4667 0 0
1541 1541 2021-08-07 Riverside 65 313931 4667 0 0
1599 1599 2021-08-06 Riverside 65 313931 4667 1226 0
1657 1657 2021-08-05 Riverside 65 312705 4667 1132 0
1715 1715 2021-08-04 Riverside 65 311573 4667 331 0
1773 1773 2021-08-03 Riverside 65 311242 4667 2025 0
1831 1831 2021-08-02 Riverside 65 309217 4667 671 5
1889 1889 2021-08-01 Riverside 65 308546 4662 0 0
1947 1947 2021-07-31 Riverside 65 308546 4662 0 0
2005 2005 2021-07-30 Riverside 65 308546 4662 624 3
2063 2063 2021-07-29 Riverside 65 307922 4659 1086 0
2121 2121 2021-07-28 Riverside 65 306836 4659 0 0
2179 2179 2021-07-27 Riverside 65 306836 4659 1247 1
2237 2237 2021-07-26 Riverside 65 305589 4658 394 0
2295 2295 2021-07-25 Riverside 65 305195 4658 0 0
2353 2353 2021-07-24 Riverside 65 305195 4658 683 1
2411 2411 2021-07-23 Riverside 65 304512 4657 452 0
2469 2469 2021-07-22 Riverside 65 304060 4657 0 0
2527 2527 2021-07-21 Riverside 65 304060 4657 1991 10
2585 2585 2021-07-20 Riverside 65 302069 4647 0 0
2643 2643 2021-07-19 Riverside 65 302069 4647 0 0
2701 2701 2021-07-18 Riverside 65 302069 4647 0 0
2759 2759 2021-07-17 Riverside 65 302069 4647 0 0
2817 2817 2021-07-16 Riverside 65 302069 4647 0 0
2875 2875 2021-07-15 Riverside 65 302069 4647 0 0
2933 2933 2021-07-14 Riverside 65 302069 4647 0 0
2991 2991 2021-07-13 Riverside 65 302069 4647 0 0
3049 3049 2021-07-12 Riverside 65 302069 4647 0 0
3107 3107 2021-07-11 Riverside 65 302069 4647 0 0
3165 3165 2021-07-10 Riverside 65 302069 4647 0 0
3223 3223 2021-07-09 Riverside 65 302069 4647 0 0
3281 3281 2021-07-08 Riverside 65 302069 4647 0 0
3339 3339 2021-07-07 Riverside 65 302069 4647 249 7
3397 3397 2021-07-06 Riverside 65 301820 4640 0 0
3455 3455 2021-07-05 Riverside 65 301820 4640 0 0
3513 3513 2021-07-04 Riverside 65 301820 4640 0 0
3571 3571 2021-07-03 Riverside 65 301820 4640 0 0
3629 3629 2021-07-02 Riverside 65 301820 4640 46 3
3687 3687 2021-07-01 Riverside 65 301774 4637 68 1
3745 3745 2021-06-30 Riverside 65 301706 4636 0 9
3803 3803 2021-06-29 Riverside 65 301706 4627 0 0
3861 3861 2021-06-28 Riverside 65 301706 4627 0 0
3919 3919 2021-06-27 Riverside 65 301706 4627 0 0
3977 3977 2021-06-26 Riverside 65 301706 4627 0 0
4035 4035 2021-06-25 Riverside 65 301706 4627 51 0
4093 4093 2021-06-24 Riverside 65 301655 4627 0 0
4151 4151 2021-06-23 Riverside 65 301655 4627 0 0
4209 4209 2021-06-22 Riverside 65 301655 4627 0 0
4267 4267 2021-06-21 Riverside 65 301655 4627 52 0
4325 4325 2021-06-20 Riverside 65 301603 4627 0 0
4383 4383 2021-06-19 Riverside 65 301603 4627 0 0
4441 4441 2021-06-18 Riverside 65 301603 4627 60 2
4499 4499 2021-06-17 Riverside 65 301543 4625 61 1
4557 4557 2021-06-16 Riverside 65 301482 4624 62 2
4615 4615 2021-06-15 Riverside 65 301420 4622 91 2
4673 4673 2021-06-14 Riverside 65 301329 4620 17 2
4731 4731 2021-06-13 Riverside 65 301312 4618 0 0
4789 4789 2021-06-12 Riverside 65 301312 4618 0 0
4847 4847 2021-06-11 Riverside 65 301312 4618 28 1
4905 4905 2021-06-10 Riverside 65 301284 4617 106 0
4963 4963 2021-06-09 Riverside 65 301178 4617 50 0
5021 5021 2021-06-08 Riverside 65 301128 4617 115 -1
5079 5079 2021-06-07 Riverside 65 301013 4618 84 2
5137 5137 2021-06-06 Riverside 65 300929 4616 0 0
5195 5195 2021-06-05 Riverside 65 300929 4616 0 0
5253 5253 2021-06-04 Riverside 65 300929 4616 50 2
5311 5311 2021-06-03 Riverside 65 300879 4614 28 2
5369 5369 2021-06-02 Riverside 65 300851 4612 119 4
5427 5427 2021-06-01 Riverside 65 300732 4608 31 0
5485 5485 2021-05-31 Riverside 65 300701 4608 0 0
5543 5543 2021-05-30 Riverside 65 300701 4608 0 0
5601 5601 2021-05-29 Riverside 65 300701 4608 0 0
5659 5659 2021-05-28 Riverside 65 300701 4608 70 0
5717 5717 2021-05-27 Riverside 65 300631 4608 81 0
5775 5775 2021-05-26 Riverside 65 300550 4608 74 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_county_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [deaths] INTEGER,
   [new_confirmed_cases] INTEGER,
   [new_deaths] INTEGER
);