latimes_agency_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_agency_totals
559 rows where agency = "Riverside" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | agency | county | fips | date ▲ | confirmed_cases | deaths | did_not_update |
---|---|---|---|---|---|---|---|---|
19007 | 19007 | Riverside | Riverside | 65 | 2020-10-26 | 66732 | 1295 | |
19068 | 19068 | Riverside | Riverside | 65 | 2020-10-25 | 65757 | 1279 | TRUE |
19129 | 19129 | Riverside | Riverside | 65 | 2020-10-24 | 65757 | 1279 | TRUE |
19190 | 19190 | Riverside | Riverside | 65 | 2020-10-23 | 65757 | 1279 | |
19251 | 19251 | Riverside | Riverside | 65 | 2020-10-22 | 65386 | 1279 | |
19312 | 19312 | Riverside | Riverside | 65 | 2020-10-21 | 65056 | 1275 | |
19373 | 19373 | Riverside | Riverside | 65 | 2020-10-20 | 64668 | 1273 | |
19434 | 19434 | Riverside | Riverside | 65 | 2020-10-19 | 64075 | 1272 | |
19495 | 19495 | Riverside | Riverside | 65 | 2020-10-18 | 63284 | 1269 | TRUE |
19556 | 19556 | Riverside | Riverside | 65 | 2020-10-17 | 63284 | 1269 | TRUE |
19617 | 19617 | Riverside | Riverside | 65 | 2020-10-16 | 63284 | 1269 | |
19678 | 19678 | Riverside | Riverside | 65 | 2020-10-15 | 63125 | 1269 | |
19739 | 19739 | Riverside | Riverside | 65 | 2020-10-14 | 62900 | 1264 | |
19800 | 19800 | Riverside | Riverside | 65 | 2020-10-13 | 62553 | 1258 | |
19861 | 19861 | Riverside | Riverside | 65 | 2020-10-12 | 61824 | 1256 | TRUE |
19922 | 19922 | Riverside | Riverside | 65 | 2020-10-11 | 61824 | 1256 | TRUE |
19983 | 19983 | Riverside | Riverside | 65 | 2020-10-10 | 61824 | 1256 | TRUE |
20044 | 20044 | Riverside | Riverside | 65 | 2020-10-09 | 61824 | 1256 | |
20105 | 20105 | Riverside | Riverside | 65 | 2020-10-08 | 61416 | 1248 | |
20166 | 20166 | Riverside | Riverside | 65 | 2020-10-07 | 61133 | 1247 | |
20227 | 20227 | Riverside | Riverside | 65 | 2020-10-06 | 60867 | 1244 | |
20288 | 20288 | Riverside | Riverside | 65 | 2020-10-05 | 60738 | 1238 | |
20349 | 20349 | Riverside | Riverside | 65 | 2020-10-04 | 59934 | 1231 | TRUE |
20410 | 20410 | Riverside | Riverside | 65 | 2020-10-03 | 59934 | 1231 | TRUE |
20471 | 20471 | Riverside | Riverside | 65 | 2020-10-02 | 59934 | 1231 | |
20532 | 20532 | Riverside | Riverside | 65 | 2020-10-01 | 59488 | 1226 | |
20593 | 20593 | Riverside | Riverside | 65 | 2020-09-30 | 59405 | 1226 | |
20654 | 20654 | Riverside | Riverside | 65 | 2020-09-29 | 59173 | 1216 | |
20715 | 20715 | Riverside | Riverside | 65 | 2020-09-28 | 58932 | 1206 | |
20776 | 20776 | Riverside | Riverside | 65 | 2020-09-27 | 58178 | 1189 | TRUE |
20837 | 20837 | Riverside | Riverside | 65 | 2020-09-26 | 58178 | 1189 | TRUE |
20898 | 20898 | Riverside | Riverside | 65 | 2020-09-25 | 58178 | 1189 | |
20959 | 20959 | Riverside | Riverside | 65 | 2020-09-24 | 57883 | 1179 | |
21020 | 21020 | Riverside | Riverside | 65 | 2020-09-23 | 57695 | 1173 | |
21081 | 21081 | Riverside | Riverside | 65 | 2020-09-22 | 57482 | 1172 | |
21142 | 21142 | Riverside | Riverside | 65 | 2020-09-21 | 57419 | 1162 | |
21203 | 21203 | Riverside | Riverside | 65 | 2020-09-20 | 56681 | 1153 | TRUE |
21264 | 21264 | Riverside | Riverside | 65 | 2020-09-19 | 56681 | 1153 | TRUE |
21325 | 21325 | Riverside | Riverside | 65 | 2020-09-18 | 56681 | 1153 | |
21386 | 21386 | Riverside | Riverside | 65 | 2020-09-17 | 56374 | 1143 | |
21447 | 21447 | Riverside | Riverside | 65 | 2020-09-16 | 56201 | 1136 | |
21508 | 21508 | Riverside | Riverside | 65 | 2020-09-15 | 55986 | 1125 | |
21569 | 21569 | Riverside | Riverside | 65 | 2020-09-14 | 55766 | 1118 | |
21630 | 21630 | Riverside | Riverside | 65 | 2020-09-13 | 55073 | 1103 | TRUE |
21691 | 21691 | Riverside | Riverside | 65 | 2020-09-12 | 55073 | 1103 | TRUE |
21752 | 21752 | Riverside | Riverside | 65 | 2020-09-11 | 55073 | 1103 | |
21813 | 21813 | Riverside | Riverside | 65 | 2020-09-10 | 54868 | 1094 | |
21874 | 21874 | Riverside | Riverside | 65 | 2020-09-09 | 54735 | 1085 | |
21935 | 21935 | Riverside | Riverside | 65 | 2020-09-08 | 54572 | 1075 | |
21996 | 21996 | Riverside | Riverside | 65 | 2020-09-07 | 53987 | 1067 | |
22057 | 22057 | Riverside | Riverside | 65 | 2020-09-06 | 53987 | 1067 | TRUE |
22118 | 22118 | Riverside | Riverside | 65 | 2020-09-05 | 53987 | 1067 | TRUE |
22179 | 22179 | Riverside | Riverside | 65 | 2020-09-04 | 53987 | 1067 | |
22240 | 22240 | Riverside | Riverside | 65 | 2020-09-03 | 53703 | 1053 | |
22301 | 22301 | Riverside | Riverside | 65 | 2020-09-02 | 53306 | 1033 | |
22362 | 22362 | Riverside | Riverside | 65 | 2020-09-01 | 53153 | 1026 | |
22423 | 22423 | Riverside | Riverside | 65 | 2020-08-31 | 52909 | 1019 | |
22484 | 22484 | Riverside | Riverside | 65 | 2020-08-30 | 51860 | 1007 | TRUE |
22545 | 22545 | Riverside | Riverside | 65 | 2020-08-29 | 51860 | 1007 | TRUE |
22606 | 22606 | Riverside | Riverside | 65 | 2020-08-28 | 51860 | 1007 | |
22667 | 22667 | Riverside | Riverside | 65 | 2020-08-27 | 51734 | 997 | |
22728 | 22728 | Riverside | Riverside | 65 | 2020-08-26 | 51538 | 984 | |
22789 | 22789 | Riverside | Riverside | 65 | 2020-08-25 | 51200 | 978 | |
22850 | 22850 | Riverside | Riverside | 65 | 2020-08-24 | 50744 | 972 | |
22911 | 22911 | Riverside | Riverside | 65 | 2020-08-23 | 49482 | 927 | TRUE |
22972 | 22972 | Riverside | Riverside | 65 | 2020-08-22 | 49482 | 927 | TRUE |
23033 | 23033 | Riverside | Riverside | 65 | 2020-08-21 | 49482 | 927 | |
23094 | 23094 | Riverside | Riverside | 65 | 2020-08-20 | 48956 | 922 | |
23155 | 23155 | Riverside | Riverside | 65 | 2020-08-19 | 48630 | 917 | |
23216 | 23216 | Riverside | Riverside | 65 | 2020-08-18 | 48200 | 913 | |
23277 | 23277 | Riverside | Riverside | 65 | 2020-08-17 | 47490 | 912 | |
23338 | 23338 | Riverside | Riverside | 65 | 2020-08-16 | 45662 | 881 | TRUE |
23399 | 23399 | Riverside | Riverside | 65 | 2020-08-15 | 45662 | 881 | TRUE |
23460 | 23460 | Riverside | Riverside | 65 | 2020-08-14 | 45662 | 881 | |
23521 | 23521 | Riverside | Riverside | 65 | 2020-08-13 | 44679 | 879 | |
23582 | 23582 | Riverside | Riverside | 65 | 2020-08-12 | 43983 | 853 | |
23643 | 23643 | Riverside | Riverside | 65 | 2020-08-11 | 43376 | 824 | |
23704 | 23704 | Riverside | Riverside | 65 | 2020-08-10 | 41983 | 820 | |
23765 | 23765 | Riverside | Riverside | 65 | 2020-08-09 | 40452 | 799 | TRUE |
23826 | 23826 | Riverside | Riverside | 65 | 2020-08-08 | 40452 | 799 | TRUE |
23887 | 23887 | Riverside | Riverside | 65 | 2020-08-07 | 40452 | 799 | |
23948 | 23948 | Riverside | Riverside | 65 | 2020-08-06 | 39741 | 770 | |
24009 | 24009 | Riverside | Riverside | 65 | 2020-08-05 | 38977 | 752 | |
24070 | 24070 | Riverside | Riverside | 65 | 2020-08-04 | 38487 | 738 | |
24131 | 24131 | Riverside | Riverside | 65 | 2020-08-03 | 38131 | 737 | |
24192 | 24192 | Riverside | Riverside | 65 | 2020-08-02 | 37011 | 695 | TRUE |
24253 | 24253 | Riverside | Riverside | 65 | 2020-08-01 | 37011 | 695 | TRUE |
24314 | 24314 | Riverside | Riverside | 65 | 2020-07-31 | 37011 | 695 | |
24375 | 24375 | Riverside | Riverside | 65 | 2020-07-30 | 36629 | 688 | |
24436 | 24436 | Riverside | Riverside | 65 | 2020-07-29 | 36159 | 682 | |
24497 | 24497 | Riverside | Riverside | 65 | 2020-07-28 | 35910 | 672 | |
24558 | 24558 | Riverside | Riverside | 65 | 2020-07-27 | 35187 | 671 | |
24619 | 24619 | Riverside | Riverside | 65 | 2020-07-26 | 33467 | 637 | TRUE |
24680 | 24680 | Riverside | Riverside | 65 | 2020-07-25 | 33467 | 637 | TRUE |
24741 | 24741 | Riverside | Riverside | 65 | 2020-07-24 | 33467 | 637 | |
24802 | 24802 | Riverside | Riverside | 65 | 2020-07-23 | 32813 | 637 | |
24863 | 24863 | Riverside | Riverside | 65 | 2020-07-22 | 31982 | 617 | |
24924 | 24924 | Riverside | Riverside | 65 | 2020-07-21 | 30890 | 589 | |
24985 | 24985 | Riverside | Riverside | 65 | 2020-07-20 | 29983 | 588 | |
25046 | 25046 | Riverside | Riverside | 65 | 2020-07-19 | 28695 | 587 | TRUE |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_agency_totals] ( [agency] TEXT, [county] TEXT, [fips] INTEGER, [date] TEXT, [confirmed_cases] INTEGER, [deaths] INTEGER, [did_not_update] TEXT );