ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
763 rows where fips = 17145 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535093 | 535093 | 2020-09-15 | Perry | Illinois | 17145 | 323 | 13 |
531858 | 531858 | 2020-09-14 | Perry | Illinois | 17145 | 323 | 13 |
528621 | 528621 | 2020-09-13 | Perry | Illinois | 17145 | 320 | 13 |
525385 | 525385 | 2020-09-12 | Perry | Illinois | 17145 | 318 | 13 |
522149 | 522149 | 2020-09-11 | Perry | Illinois | 17145 | 314 | 13 |
518912 | 518912 | 2020-09-10 | Perry | Illinois | 17145 | 311 | 13 |
515677 | 515677 | 2020-09-09 | Perry | Illinois | 17145 | 309 | 13 |
512444 | 512444 | 2020-09-08 | Perry | Illinois | 17145 | 309 | 13 |
509211 | 509211 | 2020-09-07 | Perry | Illinois | 17145 | 308 | 13 |
505979 | 505979 | 2020-09-06 | Perry | Illinois | 17145 | 308 | 12 |
502745 | 502745 | 2020-09-05 | Perry | Illinois | 17145 | 308 | 12 |
499511 | 499511 | 2020-09-04 | Perry | Illinois | 17145 | 306 | 11 |
496278 | 496278 | 2020-09-03 | Perry | Illinois | 17145 | 300 | 10 |
493044 | 493044 | 2020-09-02 | Perry | Illinois | 17145 | 298 | 10 |
489811 | 489811 | 2020-09-01 | Perry | Illinois | 17145 | 294 | 9 |
486578 | 486578 | 2020-08-31 | Perry | Illinois | 17145 | 291 | 9 |
483343 | 483343 | 2020-08-30 | Perry | Illinois | 17145 | 287 | 8 |
480109 | 480109 | 2020-08-29 | Perry | Illinois | 17145 | 288 | 8 |
476876 | 476876 | 2020-08-28 | Perry | Illinois | 17145 | 286 | 8 |
473643 | 473643 | 2020-08-27 | Perry | Illinois | 17145 | 283 | 8 |
470411 | 470411 | 2020-08-26 | Perry | Illinois | 17145 | 278 | 8 |
467182 | 467182 | 2020-08-25 | Perry | Illinois | 17145 | 272 | 6 |
463953 | 463953 | 2020-08-24 | Perry | Illinois | 17145 | 271 | 6 |
460724 | 460724 | 2020-08-23 | Perry | Illinois | 17145 | 266 | 6 |
457497 | 457497 | 2020-08-22 | Perry | Illinois | 17145 | 256 | 6 |
454269 | 454269 | 2020-08-21 | Perry | Illinois | 17145 | 246 | 6 |
451041 | 451041 | 2020-08-20 | Perry | Illinois | 17145 | 242 | 5 |
447813 | 447813 | 2020-08-19 | Perry | Illinois | 17145 | 239 | 4 |
444586 | 444586 | 2020-08-18 | Perry | Illinois | 17145 | 228 | 4 |
441360 | 441360 | 2020-08-17 | Perry | Illinois | 17145 | 213 | 3 |
438134 | 438134 | 2020-08-16 | Perry | Illinois | 17145 | 210 | 3 |
434908 | 434908 | 2020-08-15 | Perry | Illinois | 17145 | 198 | 3 |
431683 | 431683 | 2020-08-14 | Perry | Illinois | 17145 | 193 | 3 |
428455 | 428455 | 2020-08-13 | Perry | Illinois | 17145 | 193 | 3 |
425231 | 425231 | 2020-08-12 | Perry | Illinois | 17145 | 185 | 3 |
422010 | 422010 | 2020-08-11 | Perry | Illinois | 17145 | 184 | 2 |
418787 | 418787 | 2020-08-10 | Perry | Illinois | 17145 | 184 | 1 |
415566 | 415566 | 2020-08-09 | Perry | Illinois | 17145 | 184 | 1 |
412346 | 412346 | 2020-08-08 | Perry | Illinois | 17145 | 156 | 1 |
409127 | 409127 | 2020-08-07 | Perry | Illinois | 17145 | 149 | 1 |
405907 | 405907 | 2020-08-06 | Perry | Illinois | 17145 | 142 | 1 |
402689 | 402689 | 2020-08-05 | Perry | Illinois | 17145 | 136 | 1 |
399473 | 399473 | 2020-08-04 | Perry | Illinois | 17145 | 126 | 1 |
396257 | 396257 | 2020-08-03 | Perry | Illinois | 17145 | 126 | 1 |
393041 | 393041 | 2020-08-02 | Perry | Illinois | 17145 | 126 | 1 |
389824 | 389824 | 2020-08-01 | Perry | Illinois | 17145 | 101 | 1 |
386607 | 386607 | 2020-07-31 | Perry | Illinois | 17145 | 101 | 1 |
383389 | 383389 | 2020-07-30 | Perry | Illinois | 17145 | 99 | 1 |
380172 | 380172 | 2020-07-29 | Perry | Illinois | 17145 | 94 | 1 |
376955 | 376955 | 2020-07-28 | Perry | Illinois | 17145 | 92 | 1 |
373740 | 373740 | 2020-07-27 | Perry | Illinois | 17145 | 92 | 1 |
370528 | 370528 | 2020-07-26 | Perry | Illinois | 17145 | 92 | 1 |
367318 | 367318 | 2020-07-25 | Perry | Illinois | 17145 | 87 | 1 |
364111 | 364111 | 2020-07-24 | Perry | Illinois | 17145 | 83 | 1 |
360904 | 360904 | 2020-07-23 | Perry | Illinois | 17145 | 80 | 1 |
357699 | 357699 | 2020-07-22 | Perry | Illinois | 17145 | 73 | 1 |
354497 | 354497 | 2020-07-21 | Perry | Illinois | 17145 | 70 | 1 |
351295 | 351295 | 2020-07-20 | Perry | Illinois | 17145 | 68 | 1 |
348095 | 348095 | 2020-07-19 | Perry | Illinois | 17145 | 67 | 1 |
344894 | 344894 | 2020-07-18 | Perry | Illinois | 17145 | 67 | 1 |
341694 | 341694 | 2020-07-17 | Perry | Illinois | 17145 | 63 | 1 |
338498 | 338498 | 2020-07-16 | Perry | Illinois | 17145 | 63 | 1 |
335302 | 335302 | 2020-07-15 | Perry | Illinois | 17145 | 63 | 1 |
332109 | 332109 | 2020-07-14 | Perry | Illinois | 17145 | 61 | 1 |
328922 | 328922 | 2020-07-13 | Perry | Illinois | 17145 | 61 | 1 |
325736 | 325736 | 2020-07-12 | Perry | Illinois | 17145 | 61 | 1 |
322555 | 322555 | 2020-07-11 | Perry | Illinois | 17145 | 61 | 1 |
319376 | 319376 | 2020-07-10 | Perry | Illinois | 17145 | 61 | 1 |
316203 | 316203 | 2020-07-09 | Perry | Illinois | 17145 | 60 | 1 |
313029 | 313029 | 2020-07-08 | Perry | Illinois | 17145 | 59 | 1 |
309859 | 309859 | 2020-07-07 | Perry | Illinois | 17145 | 58 | 1 |
306691 | 306691 | 2020-07-06 | Perry | Illinois | 17145 | 58 | 1 |
303526 | 303526 | 2020-07-05 | Perry | Illinois | 17145 | 57 | 1 |
300362 | 300362 | 2020-07-04 | Perry | Illinois | 17145 | 56 | 1 |
297200 | 297200 | 2020-07-03 | Perry | Illinois | 17145 | 56 | 1 |
294043 | 294043 | 2020-07-02 | Perry | Illinois | 17145 | 54 | 1 |
290889 | 290889 | 2020-07-01 | Perry | Illinois | 17145 | 54 | 1 |
287739 | 287739 | 2020-06-30 | Perry | Illinois | 17145 | 51 | 1 |
284590 | 284590 | 2020-06-29 | Perry | Illinois | 17145 | 50 | 1 |
281445 | 281445 | 2020-06-28 | Perry | Illinois | 17145 | 49 | 0 |
278297 | 278297 | 2020-06-27 | Perry | Illinois | 17145 | 49 | 0 |
275149 | 275149 | 2020-06-26 | Perry | Illinois | 17145 | 47 | 0 |
272007 | 272007 | 2020-06-25 | Perry | Illinois | 17145 | 46 | 0 |
268870 | 268870 | 2020-06-24 | Perry | Illinois | 17145 | 46 | 0 |
265740 | 265740 | 2020-06-23 | Perry | Illinois | 17145 | 44 | 0 |
262612 | 262612 | 2020-06-22 | Perry | Illinois | 17145 | 44 | 0 |
259485 | 259485 | 2020-06-21 | Perry | Illinois | 17145 | 44 | 0 |
256359 | 256359 | 2020-06-20 | Perry | Illinois | 17145 | 44 | 0 |
253239 | 253239 | 2020-06-19 | Perry | Illinois | 17145 | 44 | 0 |
250124 | 250124 | 2020-06-18 | Perry | Illinois | 17145 | 44 | 0 |
247012 | 247012 | 2020-06-17 | Perry | Illinois | 17145 | 44 | 0 |
243899 | 243899 | 2020-06-16 | Perry | Illinois | 17145 | 44 | 0 |
240788 | 240788 | 2020-06-15 | Perry | Illinois | 17145 | 44 | 0 |
237680 | 237680 | 2020-06-14 | Perry | Illinois | 17145 | 44 | 0 |
234573 | 234573 | 2020-06-13 | Perry | Illinois | 17145 | 43 | 0 |
231467 | 231467 | 2020-06-12 | Perry | Illinois | 17145 | 43 | 0 |
228364 | 228364 | 2020-06-11 | Perry | Illinois | 17145 | 43 | 0 |
225262 | 225262 | 2020-06-10 | Perry | Illinois | 17145 | 43 | 0 |
222167 | 222167 | 2020-06-09 | Perry | Illinois | 17145 | 42 | 0 |
219072 | 219072 | 2020-06-08 | Perry | Illinois | 17145 | 42 | 0 |
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);