latimes_county_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_county_totals
559 rows where county = "Riverside" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | fips | confirmed_cases | deaths | new_confirmed_cases | new_deaths |
---|---|---|---|---|---|---|---|---|
5833 | 5833 | 2021-05-25 | Riverside | 65 | 300476 | 4608 | 155 | 4 |
5891 | 5891 | 2021-05-24 | Riverside | 65 | 300321 | 4604 | 75 | 2 |
5949 | 5949 | 2021-05-23 | Riverside | 65 | 300246 | 4602 | 0 | 0 |
6007 | 6007 | 2021-05-22 | Riverside | 65 | 300246 | 4602 | 0 | 0 |
6065 | 6065 | 2021-05-21 | Riverside | 65 | 300246 | 4602 | 57 | 0 |
6123 | 6123 | 2021-05-20 | Riverside | 65 | 300189 | 4602 | 63 | 0 |
6181 | 6181 | 2021-05-19 | Riverside | 65 | 300126 | 4602 | 87 | 4 |
6239 | 6239 | 2021-05-18 | Riverside | 65 | 300039 | 4598 | 186 | 5 |
6297 | 6297 | 2021-05-17 | Riverside | 65 | 299853 | 4593 | 60 | 0 |
6355 | 6355 | 2021-05-16 | Riverside | 65 | 299793 | 4593 | 0 | 0 |
6413 | 6413 | 2021-05-15 | Riverside | 65 | 299793 | 4593 | 0 | 0 |
6471 | 6471 | 2021-05-14 | Riverside | 65 | 299793 | 4593 | 228 | 0 |
6529 | 6529 | 2021-05-13 | Riverside | 65 | 299565 | 4593 | 110 | 0 |
6587 | 6587 | 2021-05-12 | Riverside | 65 | 299455 | 4593 | 79 | 3 |
6645 | 6645 | 2021-05-11 | Riverside | 65 | 299376 | 4590 | 203 | 2 |
6703 | 6703 | 2021-05-10 | Riverside | 65 | 299173 | 4588 | 109 | 1 |
6761 | 6761 | 2021-05-09 | Riverside | 65 | 299064 | 4587 | 0 | 0 |
6819 | 6819 | 2021-05-08 | Riverside | 65 | 299064 | 4587 | 0 | 0 |
6877 | 6877 | 2021-05-07 | Riverside | 65 | 299064 | 4587 | 125 | 2 |
6935 | 6935 | 2021-05-06 | Riverside | 65 | 298939 | 4585 | 67 | 9 |
6993 | 6993 | 2021-05-05 | Riverside | 65 | 298872 | 4576 | 95 | 2 |
7051 | 7051 | 2021-05-04 | Riverside | 65 | 298777 | 4574 | 205 | 0 |
7109 | 7109 | 2021-05-03 | Riverside | 65 | 298572 | 4574 | 122 | 0 |
7167 | 7167 | 2021-05-02 | Riverside | 65 | 298450 | 4574 | 0 | 0 |
7225 | 7225 | 2021-05-01 | Riverside | 65 | 298450 | 4574 | 0 | 0 |
7283 | 7283 | 2021-04-30 | Riverside | 65 | 298450 | 4574 | 84 | 6 |
7341 | 7341 | 2021-04-29 | Riverside | 65 | 298366 | 4568 | 104 | 4 |
7399 | 7399 | 2021-04-28 | Riverside | 65 | 298262 | 4564 | 3 | 1 |
7457 | 7457 | 2021-04-27 | Riverside | 65 | 298259 | 4563 | 258 | 4 |
7515 | 7515 | 2021-04-26 | Riverside | 65 | 298001 | 4559 | 120 | 0 |
7573 | 7573 | 2021-04-25 | Riverside | 65 | 297881 | 4559 | 0 | 0 |
7631 | 7631 | 2021-04-24 | Riverside | 65 | 297881 | 4559 | 0 | 0 |
7689 | 7689 | 2021-04-23 | Riverside | 65 | 297881 | 4559 | 111 | 4 |
7747 | 7747 | 2021-04-22 | Riverside | 65 | 297770 | 4555 | 139 | 8 |
7805 | 7805 | 2021-04-21 | Riverside | 65 | 297631 | 4547 | 11 | 0 |
7863 | 7863 | 2021-04-20 | Riverside | 65 | 297620 | 4547 | 301 | 19 |
7921 | 7921 | 2021-04-19 | Riverside | 65 | 297319 | 4528 | 104 | 3 |
7979 | 7979 | 2021-04-18 | Riverside | 65 | 297215 | 4525 | 0 | 0 |
8037 | 8037 | 2021-04-17 | Riverside | 65 | 297215 | 4525 | 0 | 0 |
8095 | 8095 | 2021-04-16 | Riverside | 65 | 297215 | 4525 | 137 | 6 |
8153 | 8153 | 2021-04-15 | Riverside | 65 | 297078 | 4519 | 170 | 5 |
8211 | 8211 | 2021-04-14 | Riverside | 65 | 296908 | 4514 | 107 | 10 |
8269 | 8269 | 2021-04-13 | Riverside | 65 | 296801 | 4504 | 166 | 12 |
8327 | 8327 | 2021-04-12 | Riverside | 65 | 296635 | 4492 | 545 | 11 |
8385 | 8385 | 2021-04-11 | Riverside | 65 | 296090 | 4481 | 0 | 0 |
8443 | 8443 | 2021-04-10 | Riverside | 65 | 296090 | 4481 | 0 | 0 |
8501 | 8501 | 2021-04-09 | Riverside | 65 | 296090 | 4481 | 194 | 27 |
8559 | 8559 | 2021-04-08 | Riverside | 65 | 295896 | 4454 | 126 | 12 |
8617 | 8617 | 2021-04-07 | Riverside | 65 | 295770 | 4442 | 139 | 25 |
8675 | 8675 | 2021-04-06 | Riverside | 65 | 295631 | 4417 | 205 | 28 |
8733 | 8733 | 2021-04-05 | Riverside | 65 | 295426 | 4389 | 690 | 27 |
8791 | 8791 | 2021-04-04 | Riverside | 65 | 294736 | 4362 | 0 | 0 |
8849 | 8849 | 2021-04-03 | Riverside | 65 | 294736 | 4362 | 0 | 0 |
8907 | 8907 | 2021-04-02 | Riverside | 65 | 294736 | 4362 | 119 | 23 |
8965 | 8965 | 2021-04-01 | Riverside | 65 | 294617 | 4339 | 156 | 24 |
9023 | 9023 | 2021-03-31 | Riverside | 65 | 294461 | 4315 | 269 | 18 |
9081 | 9081 | 2021-03-30 | Riverside | 65 | 294192 | 4297 | 129 | 24 |
9139 | 9139 | 2021-03-29 | Riverside | 65 | 294063 | 4273 | 232 | 25 |
9197 | 9197 | 2021-03-28 | Riverside | 65 | 293831 | 4248 | 0 | 0 |
9255 | 9255 | 2021-03-27 | Riverside | 65 | 293831 | 4248 | 0 | 0 |
9313 | 9313 | 2021-03-26 | Riverside | 65 | 293831 | 4248 | 124 | 34 |
9371 | 9371 | 2021-03-25 | Riverside | 65 | 293707 | 4214 | 107 | 24 |
9429 | 9429 | 2021-03-24 | Riverside | 65 | 293600 | 4190 | 164 | 26 |
9487 | 9487 | 2021-03-23 | Riverside | 65 | 293436 | 4164 | 287 | 23 |
9545 | 9545 | 2021-03-22 | Riverside | 65 | 293149 | 4141 | 182 | 24 |
9603 | 9603 | 2021-03-21 | Riverside | 65 | 292967 | 4117 | 0 | 0 |
9661 | 9661 | 2021-03-20 | Riverside | 65 | 292967 | 4117 | 0 | 0 |
9719 | 9719 | 2021-03-19 | Riverside | 65 | 292967 | 4117 | 150 | 20 |
9777 | 9777 | 2021-03-18 | Riverside | 65 | 292817 | 4097 | 211 | 45 |
9835 | 9835 | 2021-03-17 | Riverside | 65 | 292606 | 4052 | 203 | 41 |
9893 | 9893 | 2021-03-16 | Riverside | 65 | 292403 | 4011 | 110 | 27 |
9951 | 9951 | 2021-03-15 | Riverside | 65 | 292293 | 3984 | 427 | 13 |
10009 | 10009 | 2021-03-14 | Riverside | 65 | 291866 | 3971 | 0 | 0 |
10067 | 10067 | 2021-03-13 | Riverside | 65 | 291866 | 3971 | 0 | 0 |
10125 | 10125 | 2021-03-12 | Riverside | 65 | 291866 | 3971 | 191 | 30 |
10183 | 10183 | 2021-03-11 | Riverside | 65 | 291675 | 3941 | 0 | 0 |
10241 | 10241 | 2021-03-10 | Riverside | 65 | 291675 | 3941 | 183 | 1 |
10299 | 10299 | 2021-03-09 | Riverside | 65 | 291492 | 3940 | 452 | 28 |
10357 | 10357 | 2021-03-08 | Riverside | 65 | 291040 | 3912 | 136 | 20 |
10415 | 10415 | 2021-03-07 | Riverside | 65 | 290904 | 3892 | 0 | 0 |
10473 | 10473 | 2021-03-06 | Riverside | 65 | 290904 | 3892 | 0 | 0 |
10531 | 10531 | 2021-03-05 | Riverside | 65 | 290904 | 3892 | 160 | 8 |
10589 | 10589 | 2021-03-04 | Riverside | 65 | 290744 | 3884 | 246 | 35 |
10647 | 10647 | 2021-03-03 | Riverside | 65 | 290498 | 3849 | 173 | 20 |
10705 | 10705 | 2021-03-02 | Riverside | 65 | 290325 | 3829 | 552 | 37 |
10763 | 10763 | 2021-03-01 | Riverside | 65 | 289773 | 3792 | 323 | 25 |
10821 | 10821 | 2021-02-28 | Riverside | 65 | 289450 | 3767 | 0 | 0 |
10879 | 10879 | 2021-02-27 | Riverside | 65 | 289450 | 3767 | 0 | 0 |
10937 | 10937 | 2021-02-26 | Riverside | 65 | 289450 | 3767 | 265 | 18 |
10995 | 10995 | 2021-02-25 | Riverside | 65 | 289185 | 3749 | 225 | 42 |
11053 | 11053 | 2021-02-24 | Riverside | 65 | 288960 | 3707 | 419 | 12 |
11111 | 11111 | 2021-02-23 | Riverside | 65 | 288541 | 3695 | 719 | 31 |
11169 | 11169 | 2021-02-22 | Riverside | 65 | 287822 | 3664 | 288 | 31 |
11227 | 11227 | 2021-02-21 | Riverside | 65 | 287534 | 3633 | 0 | 0 |
11285 | 11285 | 2021-02-20 | Riverside | 65 | 287534 | 3633 | 0 | 0 |
11343 | 11343 | 2021-02-19 | Riverside | 65 | 287534 | 3633 | 334 | 34 |
11401 | 11401 | 2021-02-18 | Riverside | 65 | 287200 | 3599 | 137 | 22 |
11459 | 11459 | 2021-02-17 | Riverside | 65 | 287063 | 3577 | 473 | 19 |
11517 | 11517 | 2021-02-16 | Riverside | 65 | 286590 | 3558 | 1176 | 34 |
11575 | 11575 | 2021-02-15 | Riverside | 65 | 285414 | 3524 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_county_totals] ( [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [deaths] INTEGER, [new_confirmed_cases] INTEGER, [new_deaths] INTEGER );