ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Riverside" and state = "California" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
668 | 668 | 2020-03-07 | Riverside | California | 6065 | 1 | 0 |
763 | 763 | 2020-03-08 | Riverside | California | 6065 | 1 | 0 |
877 | 877 | 2020-03-09 | Riverside | California | 6065 | 4 | 0 |
1009 | 1009 | 2020-03-10 | Riverside | California | 6065 | 4 | 0 |
1175 | 1175 | 2020-03-11 | Riverside | California | 6065 | 4 | 0 |
1381 | 1381 | 2020-03-12 | Riverside | California | 6065 | 6 | 0 |
1641 | 1641 | 2020-03-13 | Riverside | California | 6065 | 10 | 0 |
1958 | 1958 | 2020-03-14 | Riverside | California | 6065 | 10 | 0 |
2337 | 2337 | 2020-03-15 | Riverside | California | 6065 | 12 | 0 |
2772 | 2772 | 2020-03-16 | Riverside | California | 6065 | 14 | 2 |
3254 | 3254 | 2020-03-17 | Riverside | California | 6065 | 16 | 3 |
3808 | 3808 | 2020-03-18 | Riverside | California | 6065 | 16 | 3 |
4468 | 4468 | 2020-03-19 | Riverside | California | 6065 | 22 | 3 |
5243 | 5243 | 2020-03-20 | Riverside | California | 6065 | 28 | 4 |
6164 | 6164 | 2020-03-21 | Riverside | California | 6065 | 30 | 5 |
7198 | 7198 | 2020-03-22 | Riverside | California | 6065 | 45 | 6 |
8341 | 8341 | 2020-03-23 | Riverside | California | 6065 | 48 | 6 |
9584 | 9584 | 2020-03-24 | Riverside | California | 6065 | 59 | 6 |
10956 | 10956 | 2020-03-25 | Riverside | California | 6065 | 107 | 8 |
12501 | 12501 | 2020-03-26 | Riverside | California | 6065 | 107 | 8 |
14167 | 14167 | 2020-03-27 | Riverside | California | 6065 | 185 | 8 |
15949 | 15949 | 2020-03-28 | Riverside | California | 6065 | 185 | 8 |
17838 | 17838 | 2020-03-29 | Riverside | California | 6065 | 195 | 8 |
19815 | 19815 | 2020-03-30 | Riverside | California | 6065 | 291 | 9 |
21890 | 21890 | 2020-03-31 | Riverside | California | 6065 | 371 | 13 |
24048 | 24048 | 2020-04-01 | Riverside | California | 6065 | 371 | 13 |
26277 | 26277 | 2020-04-02 | Riverside | California | 6065 | 493 | 14 |
28576 | 28576 | 2020-04-03 | Riverside | California | 6065 | 638 | 15 |
30934 | 30934 | 2020-04-04 | Riverside | California | 6065 | 665 | 18 |
33340 | 33340 | 2020-04-05 | Riverside | California | 6065 | 799 | 19 |
35785 | 35785 | 2020-04-06 | Riverside | California | 6065 | 946 | 25 |
38274 | 38274 | 2020-04-07 | Riverside | California | 6065 | 1016 | 28 |
40818 | 40818 | 2020-04-08 | Riverside | California | 6065 | 1179 | 32 |
43390 | 43390 | 2020-04-09 | Riverside | California | 6065 | 1280 | 33 |
45990 | 45990 | 2020-04-10 | Riverside | California | 6065 | 1350 | 39 |
48620 | 48620 | 2020-04-11 | Riverside | California | 6065 | 1431 | 41 |
51282 | 51282 | 2020-04-12 | Riverside | California | 6065 | 1619 | 41 |
53961 | 53961 | 2020-04-13 | Riverside | California | 6065 | 1751 | 50 |
56653 | 56653 | 2020-04-14 | Riverside | California | 6065 | 1961 | 50 |
59361 | 59361 | 2020-04-15 | Riverside | California | 6065 | 2105 | 54 |
62080 | 62080 | 2020-04-16 | Riverside | California | 6065 | 2264 | 59 |
64813 | 64813 | 2020-04-17 | Riverside | California | 6065 | 2457 | 69 |
67561 | 67561 | 2020-04-18 | Riverside | California | 6065 | 2602 | 74 |
70323 | 70323 | 2020-04-19 | Riverside | California | 6065 | 2638 | 75 |
73092 | 73092 | 2020-04-20 | Riverside | California | 6065 | 2847 | 85 |
75868 | 75868 | 2020-04-21 | Riverside | California | 6065 | 2960 | 93 |
78652 | 78652 | 2020-04-22 | Riverside | California | 6065 | 3084 | 99 |
81446 | 81446 | 2020-04-23 | Riverside | California | 6065 | 3218 | 109 |
84246 | 84246 | 2020-04-24 | Riverside | California | 6065 | 3315 | 112 |
87054 | 87054 | 2020-04-25 | Riverside | California | 6065 | 3409 | 117 |
89871 | 89871 | 2020-04-26 | Riverside | California | 6065 | 3563 | 118 |
92689 | 92689 | 2020-04-27 | Riverside | California | 6065 | 3643 | 141 |
95521 | 95521 | 2020-04-28 | Riverside | California | 6065 | 3735 | 141 |
98366 | 98366 | 2020-04-29 | Riverside | California | 6065 | 3942 | 143 |
101216 | 101216 | 2020-04-30 | Riverside | California | 6065 | 4031 | 149 |
104071 | 104071 | 2020-05-01 | Riverside | California | 6065 | 4079 | 156 |
106936 | 106936 | 2020-05-02 | Riverside | California | 6065 | 4164 | 167 |
109805 | 109805 | 2020-05-03 | Riverside | California | 6065 | 4180 | 167 |
112680 | 112680 | 2020-05-04 | Riverside | California | 6065 | 4354 | 181 |
115563 | 115563 | 2020-05-05 | Riverside | California | 6065 | 4454 | 184 |
118522 | 118522 | 2020-05-06 | Riverside | California | 6065 | 4672 | 190 |
121489 | 121489 | 2020-05-07 | Riverside | California | 6065 | 4756 | 194 |
124469 | 124469 | 2020-05-08 | Riverside | California | 6065 | 4817 | 204 |
127454 | 127454 | 2020-05-09 | Riverside | California | 6065 | 4992 | 210 |
130444 | 130444 | 2020-05-10 | Riverside | California | 6065 | 5039 | 212 |
133434 | 133434 | 2020-05-11 | Riverside | California | 6065 | 5189 | 217 |
136424 | 136424 | 2020-05-12 | Riverside | California | 6065 | 5248 | 228 |
139415 | 139415 | 2020-05-13 | Riverside | California | 6065 | 5343 | 238 |
142411 | 142411 | 2020-05-14 | Riverside | California | 6065 | 5440 | 246 |
145410 | 145410 | 2020-05-15 | Riverside | California | 6065 | 5618 | 249 |
148414 | 148414 | 2020-05-16 | Riverside | California | 6065 | 5618 | 255 |
151423 | 151423 | 2020-05-17 | Riverside | California | 6065 | 5633 | 259 |
154435 | 154435 | 2020-05-18 | Riverside | California | 6065 | 5952 | 263 |
157451 | 157451 | 2020-05-19 | Riverside | California | 6065 | 6053 | 270 |
160477 | 160477 | 2020-05-20 | Riverside | California | 6065 | 6184 | 274 |
163505 | 163505 | 2020-05-21 | Riverside | California | 6065 | 6343 | 284 |
166537 | 166537 | 2020-05-22 | Riverside | California | 6065 | 6464 | 290 |
169574 | 169574 | 2020-05-23 | Riverside | California | 6065 | 6464 | 298 |
172615 | 172615 | 2020-05-24 | Riverside | California | 6065 | 6464 | 299 |
175659 | 175659 | 2020-05-25 | Riverside | California | 6065 | 7004 | 304 |
178703 | 178703 | 2020-05-26 | Riverside | California | 6065 | 7139 | 309 |
181747 | 181747 | 2020-05-27 | Riverside | California | 6065 | 7252 | 314 |
184801 | 184801 | 2020-05-28 | Riverside | California | 6065 | 7341 | 320 |
187857 | 187857 | 2020-05-29 | Riverside | California | 6065 | 7486 | 331 |
190922 | 190922 | 2020-05-30 | Riverside | California | 6065 | 7486 | 339 |
193989 | 193989 | 2020-05-31 | Riverside | California | 6065 | 7492 | 339 |
197059 | 197059 | 2020-06-01 | Riverside | California | 6065 | 7982 | 344 |
200132 | 200132 | 2020-06-02 | Riverside | California | 6065 | 8155 | 344 |
203208 | 203208 | 2020-06-03 | Riverside | California | 6065 | 8303 | 345 |
206288 | 206288 | 2020-06-04 | Riverside | California | 6065 | 8303 | 345 |
209369 | 209369 | 2020-06-05 | Riverside | California | 6065 | 8777 | 355 |
212454 | 212454 | 2020-06-06 | Riverside | California | 6065 | 8777 | 355 |
215541 | 215541 | 2020-06-07 | Riverside | California | 6065 | 8935 | 355 |
218632 | 218632 | 2020-06-08 | Riverside | California | 6065 | 9206 | 356 |
221727 | 221727 | 2020-06-09 | Riverside | California | 6065 | 9590 | 365 |
224822 | 224822 | 2020-06-10 | Riverside | California | 6065 | 9911 | 372 |
227924 | 227924 | 2020-06-11 | Riverside | California | 6065 | 10240 | 380 |
231027 | 231027 | 2020-06-12 | Riverside | California | 6065 | 10490 | 383 |
234133 | 234133 | 2020-06-13 | Riverside | California | 6065 | 10616 | 383 |
237240 | 237240 | 2020-06-14 | Riverside | California | 6065 | 10931 | 383 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);