ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Randolph" and fips = 17157 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20153 | 20153 | 2020-03-30 | Randolph | Illinois | 17157 | 2 | 0 |
22246 | 22246 | 2020-03-31 | Randolph | Illinois | 17157 | 3 | 0 |
24415 | 24415 | 2020-04-01 | Randolph | Illinois | 17157 | 7 | 0 |
26653 | 26653 | 2020-04-02 | Randolph | Illinois | 17157 | 8 | 0 |
28963 | 28963 | 2020-04-03 | Randolph | Illinois | 17157 | 12 | 0 |
31329 | 31329 | 2020-04-04 | Randolph | Illinois | 17157 | 20 | 0 |
33739 | 33739 | 2020-04-05 | Randolph | Illinois | 17157 | 24 | 0 |
36191 | 36191 | 2020-04-06 | Randolph | Illinois | 17157 | 27 | 0 |
38687 | 38687 | 2020-04-07 | Randolph | Illinois | 17157 | 29 | 0 |
41232 | 41232 | 2020-04-08 | Randolph | Illinois | 17157 | 31 | 0 |
43807 | 43807 | 2020-04-09 | Randolph | Illinois | 17157 | 34 | 0 |
46411 | 46411 | 2020-04-10 | Randolph | Illinois | 17157 | 35 | 0 |
49044 | 49044 | 2020-04-11 | Randolph | Illinois | 17157 | 37 | 0 |
51706 | 51706 | 2020-04-12 | Randolph | Illinois | 17157 | 40 | 0 |
54387 | 54387 | 2020-04-13 | Randolph | Illinois | 17157 | 41 | 0 |
57080 | 57080 | 2020-04-14 | Randolph | Illinois | 17157 | 41 | 0 |
59787 | 59787 | 2020-04-15 | Randolph | Illinois | 17157 | 46 | 0 |
62508 | 62508 | 2020-04-16 | Randolph | Illinois | 17157 | 46 | 0 |
65241 | 65241 | 2020-04-17 | Randolph | Illinois | 17157 | 48 | 1 |
67990 | 67990 | 2020-04-18 | Randolph | Illinois | 17157 | 54 | 1 |
70752 | 70752 | 2020-04-19 | Randolph | Illinois | 17157 | 57 | 1 |
73522 | 73522 | 2020-04-20 | Randolph | Illinois | 17157 | 58 | 1 |
76299 | 76299 | 2020-04-21 | Randolph | Illinois | 17157 | 61 | 1 |
79083 | 79083 | 2020-04-22 | Randolph | Illinois | 17157 | 63 | 1 |
81876 | 81876 | 2020-04-23 | Randolph | Illinois | 17157 | 68 | 1 |
84676 | 84676 | 2020-04-24 | Randolph | Illinois | 17157 | 79 | 1 |
87486 | 87486 | 2020-04-25 | Randolph | Illinois | 17157 | 79 | 1 |
90302 | 90302 | 2020-04-26 | Randolph | Illinois | 17157 | 104 | 1 |
93121 | 93121 | 2020-04-27 | Randolph | Illinois | 17157 | 109 | 1 |
95953 | 95953 | 2020-04-28 | Randolph | Illinois | 17157 | 126 | 1 |
98797 | 98797 | 2020-04-29 | Randolph | Illinois | 17157 | 138 | 1 |
101648 | 101648 | 2020-04-30 | Randolph | Illinois | 17157 | 156 | 1 |
104504 | 104504 | 2020-05-01 | Randolph | Illinois | 17157 | 164 | 1 |
107369 | 107369 | 2020-05-02 | Randolph | Illinois | 17157 | 166 | 1 |
110239 | 110239 | 2020-05-03 | Randolph | Illinois | 17157 | 179 | 1 |
113114 | 113114 | 2020-05-04 | Randolph | Illinois | 17157 | 182 | 1 |
115997 | 115997 | 2020-05-05 | Randolph | Illinois | 17157 | 183 | 2 |
118957 | 118957 | 2020-05-06 | Randolph | Illinois | 17157 | 203 | 2 |
121927 | 121927 | 2020-05-07 | Randolph | Illinois | 17157 | 206 | 2 |
124907 | 124907 | 2020-05-08 | Randolph | Illinois | 17157 | 211 | 2 |
127894 | 127894 | 2020-05-09 | Randolph | Illinois | 17157 | 217 | 2 |
130885 | 130885 | 2020-05-10 | Randolph | Illinois | 17157 | 220 | 2 |
133876 | 133876 | 2020-05-11 | Randolph | Illinois | 17157 | 221 | 2 |
136865 | 136865 | 2020-05-12 | Randolph | Illinois | 17157 | 222 | 3 |
139857 | 139857 | 2020-05-13 | Randolph | Illinois | 17157 | 227 | 3 |
142853 | 142853 | 2020-05-14 | Randolph | Illinois | 17157 | 233 | 3 |
145853 | 145853 | 2020-05-15 | Randolph | Illinois | 17157 | 234 | 3 |
148857 | 148857 | 2020-05-16 | Randolph | Illinois | 17157 | 236 | 3 |
151866 | 151866 | 2020-05-17 | Randolph | Illinois | 17157 | 236 | 3 |
154878 | 154878 | 2020-05-18 | Randolph | Illinois | 17157 | 237 | 3 |
157894 | 157894 | 2020-05-19 | Randolph | Illinois | 17157 | 238 | 3 |
160920 | 160920 | 2020-05-20 | Randolph | Illinois | 17157 | 246 | 3 |
163948 | 163948 | 2020-05-21 | Randolph | Illinois | 17157 | 246 | 3 |
166981 | 166981 | 2020-05-22 | Randolph | Illinois | 17157 | 251 | 3 |
170018 | 170018 | 2020-05-23 | Randolph | Illinois | 17157 | 256 | 3 |
173059 | 173059 | 2020-05-24 | Randolph | Illinois | 17157 | 258 | 3 |
176103 | 176103 | 2020-05-25 | Randolph | Illinois | 17157 | 259 | 3 |
179147 | 179147 | 2020-05-26 | Randolph | Illinois | 17157 | 259 | 3 |
182191 | 182191 | 2020-05-27 | Randolph | Illinois | 17157 | 264 | 4 |
185245 | 185245 | 2020-05-28 | Randolph | Illinois | 17157 | 267 | 4 |
188303 | 188303 | 2020-05-29 | Randolph | Illinois | 17157 | 267 | 4 |
191368 | 191368 | 2020-05-30 | Randolph | Illinois | 17157 | 269 | 4 |
194435 | 194435 | 2020-05-31 | Randolph | Illinois | 17157 | 270 | 4 |
197505 | 197505 | 2020-06-01 | Randolph | Illinois | 17157 | 269 | 4 |
200578 | 200578 | 2020-06-02 | Randolph | Illinois | 17157 | 270 | 4 |
203654 | 203654 | 2020-06-03 | Randolph | Illinois | 17157 | 271 | 4 |
206734 | 206734 | 2020-06-04 | Randolph | Illinois | 17157 | 273 | 4 |
209815 | 209815 | 2020-06-05 | Randolph | Illinois | 17157 | 273 | 4 |
212900 | 212900 | 2020-06-06 | Randolph | Illinois | 17157 | 274 | 4 |
215987 | 215987 | 2020-06-07 | Randolph | Illinois | 17157 | 274 | 4 |
219078 | 219078 | 2020-06-08 | Randolph | Illinois | 17157 | 276 | 4 |
222173 | 222173 | 2020-06-09 | Randolph | Illinois | 17157 | 276 | 5 |
225268 | 225268 | 2020-06-10 | Randolph | Illinois | 17157 | 276 | 6 |
228370 | 228370 | 2020-06-11 | Randolph | Illinois | 17157 | 276 | 7 |
231473 | 231473 | 2020-06-12 | Randolph | Illinois | 17157 | 276 | 7 |
234579 | 234579 | 2020-06-13 | Randolph | Illinois | 17157 | 278 | 7 |
237686 | 237686 | 2020-06-14 | Randolph | Illinois | 17157 | 278 | 7 |
240794 | 240794 | 2020-06-15 | Randolph | Illinois | 17157 | 278 | 7 |
243905 | 243905 | 2020-06-16 | Randolph | Illinois | 17157 | 279 | 7 |
247018 | 247018 | 2020-06-17 | Randolph | Illinois | 17157 | 279 | 7 |
250130 | 250130 | 2020-06-18 | Randolph | Illinois | 17157 | 279 | 7 |
253245 | 253245 | 2020-06-19 | Randolph | Illinois | 17157 | 278 | 7 |
256365 | 256365 | 2020-06-20 | Randolph | Illinois | 17157 | 278 | 7 |
259491 | 259491 | 2020-06-21 | Randolph | Illinois | 17157 | 278 | 7 |
262618 | 262618 | 2020-06-22 | Randolph | Illinois | 17157 | 278 | 7 |
265746 | 265746 | 2020-06-23 | Randolph | Illinois | 17157 | 278 | 7 |
268876 | 268876 | 2020-06-24 | Randolph | Illinois | 17157 | 278 | 7 |
272013 | 272013 | 2020-06-25 | Randolph | Illinois | 17157 | 278 | 7 |
275155 | 275155 | 2020-06-26 | Randolph | Illinois | 17157 | 278 | 7 |
278303 | 278303 | 2020-06-27 | Randolph | Illinois | 17157 | 279 | 7 |
281451 | 281451 | 2020-06-28 | Randolph | Illinois | 17157 | 279 | 7 |
284596 | 284596 | 2020-06-29 | Randolph | Illinois | 17157 | 281 | 7 |
287745 | 287745 | 2020-06-30 | Randolph | Illinois | 17157 | 285 | 7 |
290895 | 290895 | 2020-07-01 | Randolph | Illinois | 17157 | 287 | 7 |
294049 | 294049 | 2020-07-02 | Randolph | Illinois | 17157 | 287 | 7 |
297206 | 297206 | 2020-07-03 | Randolph | Illinois | 17157 | 287 | 7 |
300368 | 300368 | 2020-07-04 | Randolph | Illinois | 17157 | 288 | 7 |
303532 | 303532 | 2020-07-05 | Randolph | Illinois | 17157 | 288 | 7 |
306697 | 306697 | 2020-07-06 | Randolph | Illinois | 17157 | 288 | 7 |
309865 | 309865 | 2020-07-07 | Randolph | Illinois | 17157 | 288 | 7 |
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);