ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 17167 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
422020 | 422020 | 2020-08-11 | Sangamon | Illinois | 17167 | 1321 | 34 |
418797 | 418797 | 2020-08-10 | Sangamon | Illinois | 17167 | 1274 | 34 |
415576 | 415576 | 2020-08-09 | Sangamon | Illinois | 17167 | 1249 | 34 |
412356 | 412356 | 2020-08-08 | Sangamon | Illinois | 17167 | 1228 | 34 |
409137 | 409137 | 2020-08-07 | Sangamon | Illinois | 17167 | 1194 | 34 |
405917 | 405917 | 2020-08-06 | Sangamon | Illinois | 17167 | 1161 | 34 |
402699 | 402699 | 2020-08-05 | Sangamon | Illinois | 17167 | 1115 | 34 |
399483 | 399483 | 2020-08-04 | Sangamon | Illinois | 17167 | 1081 | 34 |
396267 | 396267 | 2020-08-03 | Sangamon | Illinois | 17167 | 1066 | 34 |
393051 | 393051 | 2020-08-02 | Sangamon | Illinois | 17167 | 1045 | 34 |
389834 | 389834 | 2020-08-01 | Sangamon | Illinois | 17167 | 986 | 34 |
386617 | 386617 | 2020-07-31 | Sangamon | Illinois | 17167 | 969 | 34 |
383399 | 383399 | 2020-07-30 | Sangamon | Illinois | 17167 | 940 | 34 |
380182 | 380182 | 2020-07-29 | Sangamon | Illinois | 17167 | 916 | 34 |
376965 | 376965 | 2020-07-28 | Sangamon | Illinois | 17167 | 868 | 34 |
373750 | 373750 | 2020-07-27 | Sangamon | Illinois | 17167 | 836 | 34 |
370538 | 370538 | 2020-07-26 | Sangamon | Illinois | 17167 | 825 | 34 |
367328 | 367328 | 2020-07-25 | Sangamon | Illinois | 17167 | 783 | 34 |
364121 | 364121 | 2020-07-24 | Sangamon | Illinois | 17167 | 783 | 34 |
360914 | 360914 | 2020-07-23 | Sangamon | Illinois | 17167 | 761 | 34 |
357709 | 357709 | 2020-07-22 | Sangamon | Illinois | 17167 | 740 | 34 |
354507 | 354507 | 2020-07-21 | Sangamon | Illinois | 17167 | 715 | 34 |
351305 | 351305 | 2020-07-20 | Sangamon | Illinois | 17167 | 687 | 34 |
348105 | 348105 | 2020-07-19 | Sangamon | Illinois | 17167 | 665 | 34 |
344904 | 344904 | 2020-07-18 | Sangamon | Illinois | 17167 | 642 | 34 |
341704 | 341704 | 2020-07-17 | Sangamon | Illinois | 17167 | 632 | 34 |
338508 | 338508 | 2020-07-16 | Sangamon | Illinois | 17167 | 613 | 34 |
335312 | 335312 | 2020-07-15 | Sangamon | Illinois | 17167 | 593 | 34 |
332119 | 332119 | 2020-07-14 | Sangamon | Illinois | 17167 | 567 | 34 |
328932 | 328932 | 2020-07-13 | Sangamon | Illinois | 17167 | 555 | 34 |
325746 | 325746 | 2020-07-12 | Sangamon | Illinois | 17167 | 531 | 34 |
322565 | 322565 | 2020-07-11 | Sangamon | Illinois | 17167 | 526 | 34 |
319386 | 319386 | 2020-07-10 | Sangamon | Illinois | 17167 | 518 | 34 |
316213 | 316213 | 2020-07-09 | Sangamon | Illinois | 17167 | 501 | 34 |
313039 | 313039 | 2020-07-08 | Sangamon | Illinois | 17167 | 483 | 34 |
309869 | 309869 | 2020-07-07 | Sangamon | Illinois | 17167 | 470 | 34 |
306701 | 306701 | 2020-07-06 | Sangamon | Illinois | 17167 | 457 | 34 |
303536 | 303536 | 2020-07-05 | Sangamon | Illinois | 17167 | 450 | 34 |
300372 | 300372 | 2020-07-04 | Sangamon | Illinois | 17167 | 446 | 34 |
297210 | 297210 | 2020-07-03 | Sangamon | Illinois | 17167 | 445 | 34 |
294053 | 294053 | 2020-07-02 | Sangamon | Illinois | 17167 | 437 | 34 |
290899 | 290899 | 2020-07-01 | Sangamon | Illinois | 17167 | 435 | 34 |
287749 | 287749 | 2020-06-30 | Sangamon | Illinois | 17167 | 431 | 34 |
284600 | 284600 | 2020-06-29 | Sangamon | Illinois | 17167 | 424 | 33 |
281455 | 281455 | 2020-06-28 | Sangamon | Illinois | 17167 | 411 | 33 |
278307 | 278307 | 2020-06-27 | Sangamon | Illinois | 17167 | 408 | 33 |
275159 | 275159 | 2020-06-26 | Sangamon | Illinois | 17167 | 405 | 33 |
272017 | 272017 | 2020-06-25 | Sangamon | Illinois | 17167 | 402 | 33 |
268880 | 268880 | 2020-06-24 | Sangamon | Illinois | 17167 | 400 | 33 |
265750 | 265750 | 2020-06-23 | Sangamon | Illinois | 17167 | 395 | 33 |
262622 | 262622 | 2020-06-22 | Sangamon | Illinois | 17167 | 391 | 33 |
259495 | 259495 | 2020-06-21 | Sangamon | Illinois | 17167 | 389 | 33 |
256369 | 256369 | 2020-06-20 | Sangamon | Illinois | 17167 | 389 | 33 |
253249 | 253249 | 2020-06-19 | Sangamon | Illinois | 17167 | 389 | 33 |
250134 | 250134 | 2020-06-18 | Sangamon | Illinois | 17167 | 387 | 33 |
247022 | 247022 | 2020-06-17 | Sangamon | Illinois | 17167 | 386 | 33 |
243909 | 243909 | 2020-06-16 | Sangamon | Illinois | 17167 | 384 | 33 |
240798 | 240798 | 2020-06-15 | Sangamon | Illinois | 17167 | 383 | 33 |
237690 | 237690 | 2020-06-14 | Sangamon | Illinois | 17167 | 378 | 33 |
234583 | 234583 | 2020-06-13 | Sangamon | Illinois | 17167 | 377 | 33 |
231477 | 231477 | 2020-06-12 | Sangamon | Illinois | 17167 | 377 | 33 |
228374 | 228374 | 2020-06-11 | Sangamon | Illinois | 17167 | 377 | 33 |
225272 | 225272 | 2020-06-10 | Sangamon | Illinois | 17167 | 371 | 33 |
222177 | 222177 | 2020-06-09 | Sangamon | Illinois | 17167 | 371 | 33 |
219082 | 219082 | 2020-06-08 | Sangamon | Illinois | 17167 | 367 | 32 |
215991 | 215991 | 2020-06-07 | Sangamon | Illinois | 17167 | 365 | 32 |
212904 | 212904 | 2020-06-06 | Sangamon | Illinois | 17167 | 365 | 32 |
209819 | 209819 | 2020-06-05 | Sangamon | Illinois | 17167 | 365 | 31 |
206738 | 206738 | 2020-06-04 | Sangamon | Illinois | 17167 | 363 | 31 |
203658 | 203658 | 2020-06-03 | Sangamon | Illinois | 17167 | 359 | 31 |
200582 | 200582 | 2020-06-02 | Sangamon | Illinois | 17167 | 357 | 31 |
197509 | 197509 | 2020-06-01 | Sangamon | Illinois | 17167 | 356 | 31 |
194439 | 194439 | 2020-05-31 | Sangamon | Illinois | 17167 | 354 | 31 |
191372 | 191372 | 2020-05-30 | Sangamon | Illinois | 17167 | 354 | 31 |
188307 | 188307 | 2020-05-29 | Sangamon | Illinois | 17167 | 353 | 31 |
185249 | 185249 | 2020-05-28 | Sangamon | Illinois | 17167 | 349 | 30 |
182195 | 182195 | 2020-05-27 | Sangamon | Illinois | 17167 | 343 | 30 |
179151 | 179151 | 2020-05-26 | Sangamon | Illinois | 17167 | 338 | 29 |
176107 | 176107 | 2020-05-25 | Sangamon | Illinois | 17167 | 336 | 28 |
173063 | 173063 | 2020-05-24 | Sangamon | Illinois | 17167 | 336 | 28 |
170022 | 170022 | 2020-05-23 | Sangamon | Illinois | 17167 | 335 | 28 |
166985 | 166985 | 2020-05-22 | Sangamon | Illinois | 17167 | 334 | 28 |
163952 | 163952 | 2020-05-21 | Sangamon | Illinois | 17167 | 324 | 28 |
160924 | 160924 | 2020-05-20 | Sangamon | Illinois | 17167 | 323 | 28 |
157898 | 157898 | 2020-05-19 | Sangamon | Illinois | 17167 | 323 | 28 |
154882 | 154882 | 2020-05-18 | Sangamon | Illinois | 17167 | 319 | 27 |
151870 | 151870 | 2020-05-17 | Sangamon | Illinois | 17167 | 318 | 27 |
148861 | 148861 | 2020-05-16 | Sangamon | Illinois | 17167 | 314 | 26 |
145857 | 145857 | 2020-05-15 | Sangamon | Illinois | 17167 | 300 | 25 |
142857 | 142857 | 2020-05-14 | Sangamon | Illinois | 17167 | 292 | 25 |
139861 | 139861 | 2020-05-13 | Sangamon | Illinois | 17167 | 292 | 25 |
136869 | 136869 | 2020-05-12 | Sangamon | Illinois | 17167 | 286 | 25 |
133880 | 133880 | 2020-05-11 | Sangamon | Illinois | 17167 | 275 | 25 |
130889 | 130889 | 2020-05-10 | Sangamon | Illinois | 17167 | 258 | 24 |
127898 | 127898 | 2020-05-09 | Sangamon | Illinois | 17167 | 256 | 19 |
124911 | 124911 | 2020-05-08 | Sangamon | Illinois | 17167 | 253 | 19 |
121931 | 121931 | 2020-05-07 | Sangamon | Illinois | 17167 | 237 | 19 |
118961 | 118961 | 2020-05-06 | Sangamon | Illinois | 17167 | 231 | 14 |
116001 | 116001 | 2020-05-05 | Sangamon | Illinois | 17167 | 216 | 14 |
113118 | 113118 | 2020-05-04 | Sangamon | Illinois | 17167 | 212 | 13 |
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);