ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
761 rows where county = "Johnson" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635527 | 635527 | 2020-10-16 | Johnson | Illinois | 17087 | 298 | 0 |
632281 | 632281 | 2020-10-15 | Johnson | Illinois | 17087 | 289 | 0 |
629037 | 629037 | 2020-10-14 | Johnson | Illinois | 17087 | 279 | 0 |
625794 | 625794 | 2020-10-13 | Johnson | Illinois | 17087 | 265 | 0 |
622552 | 622552 | 2020-10-12 | Johnson | Illinois | 17087 | 262 | 0 |
619308 | 619308 | 2020-10-11 | Johnson | Illinois | 17087 | 261 | 0 |
616066 | 616066 | 2020-10-10 | Johnson | Illinois | 17087 | 255 | 0 |
612825 | 612825 | 2020-10-09 | Johnson | Illinois | 17087 | 249 | 0 |
609583 | 609583 | 2020-10-08 | Johnson | Illinois | 17087 | 240 | 0 |
606340 | 606340 | 2020-10-07 | Johnson | Illinois | 17087 | 199 | 0 |
603098 | 603098 | 2020-10-06 | Johnson | Illinois | 17087 | 194 | 0 |
599855 | 599855 | 2020-10-05 | Johnson | Illinois | 17087 | 188 | 0 |
596613 | 596613 | 2020-10-04 | Johnson | Illinois | 17087 | 185 | 0 |
593371 | 593371 | 2020-10-03 | Johnson | Illinois | 17087 | 181 | 0 |
590130 | 590130 | 2020-10-02 | Johnson | Illinois | 17087 | 172 | 0 |
586889 | 586889 | 2020-10-01 | Johnson | Illinois | 17087 | 168 | 0 |
583649 | 583649 | 2020-09-30 | Johnson | Illinois | 17087 | 163 | 0 |
580410 | 580410 | 2020-09-29 | Johnson | Illinois | 17087 | 162 | 0 |
577169 | 577169 | 2020-09-28 | Johnson | Illinois | 17087 | 156 | 0 |
573927 | 573927 | 2020-09-27 | Johnson | Illinois | 17087 | 156 | 0 |
570684 | 570684 | 2020-09-26 | Johnson | Illinois | 17087 | 153 | 0 |
567442 | 567442 | 2020-09-25 | Johnson | Illinois | 17087 | 153 | 0 |
564202 | 564202 | 2020-09-24 | Johnson | Illinois | 17087 | 149 | 0 |
560962 | 560962 | 2020-09-23 | Johnson | Illinois | 17087 | 148 | 0 |
557726 | 557726 | 2020-09-22 | Johnson | Illinois | 17087 | 144 | 0 |
554489 | 554489 | 2020-09-21 | Johnson | Illinois | 17087 | 144 | 0 |
551250 | 551250 | 2020-09-20 | Johnson | Illinois | 17087 | 144 | 0 |
548011 | 548011 | 2020-09-19 | Johnson | Illinois | 17087 | 144 | 0 |
544773 | 544773 | 2020-09-18 | Johnson | Illinois | 17087 | 142 | 0 |
541537 | 541537 | 2020-09-17 | Johnson | Illinois | 17087 | 139 | 0 |
538300 | 538300 | 2020-09-16 | Johnson | Illinois | 17087 | 133 | 0 |
535064 | 535064 | 2020-09-15 | Johnson | Illinois | 17087 | 130 | 0 |
531829 | 531829 | 2020-09-14 | Johnson | Illinois | 17087 | 130 | 0 |
528592 | 528592 | 2020-09-13 | Johnson | Illinois | 17087 | 130 | 0 |
525356 | 525356 | 2020-09-12 | Johnson | Illinois | 17087 | 130 | 0 |
522120 | 522120 | 2020-09-11 | Johnson | Illinois | 17087 | 128 | 0 |
518883 | 518883 | 2020-09-10 | Johnson | Illinois | 17087 | 126 | 0 |
515648 | 515648 | 2020-09-09 | Johnson | Illinois | 17087 | 126 | 0 |
512415 | 512415 | 2020-09-08 | Johnson | Illinois | 17087 | 126 | 0 |
509182 | 509182 | 2020-09-07 | Johnson | Illinois | 17087 | 125 | 0 |
505950 | 505950 | 2020-09-06 | Johnson | Illinois | 17087 | 124 | 0 |
502716 | 502716 | 2020-09-05 | Johnson | Illinois | 17087 | 124 | 0 |
499482 | 499482 | 2020-09-04 | Johnson | Illinois | 17087 | 122 | 0 |
496249 | 496249 | 2020-09-03 | Johnson | Illinois | 17087 | 119 | 0 |
493015 | 493015 | 2020-09-02 | Johnson | Illinois | 17087 | 119 | 0 |
489782 | 489782 | 2020-09-01 | Johnson | Illinois | 17087 | 117 | 0 |
486549 | 486549 | 2020-08-31 | Johnson | Illinois | 17087 | 116 | 0 |
483314 | 483314 | 2020-08-30 | Johnson | Illinois | 17087 | 115 | 0 |
480080 | 480080 | 2020-08-29 | Johnson | Illinois | 17087 | 113 | 0 |
476847 | 476847 | 2020-08-28 | Johnson | Illinois | 17087 | 110 | 0 |
473614 | 473614 | 2020-08-27 | Johnson | Illinois | 17087 | 107 | 0 |
470382 | 470382 | 2020-08-26 | Johnson | Illinois | 17087 | 105 | 0 |
467153 | 467153 | 2020-08-25 | Johnson | Illinois | 17087 | 96 | 0 |
463924 | 463924 | 2020-08-24 | Johnson | Illinois | 17087 | 95 | 0 |
460695 | 460695 | 2020-08-23 | Johnson | Illinois | 17087 | 92 | 0 |
457468 | 457468 | 2020-08-22 | Johnson | Illinois | 17087 | 88 | 0 |
454240 | 454240 | 2020-08-21 | Johnson | Illinois | 17087 | 87 | 0 |
451012 | 451012 | 2020-08-20 | Johnson | Illinois | 17087 | 87 | 0 |
447784 | 447784 | 2020-08-19 | Johnson | Illinois | 17087 | 86 | 0 |
444557 | 444557 | 2020-08-18 | Johnson | Illinois | 17087 | 81 | 0 |
441331 | 441331 | 2020-08-17 | Johnson | Illinois | 17087 | 79 | 0 |
438105 | 438105 | 2020-08-16 | Johnson | Illinois | 17087 | 78 | 0 |
434879 | 434879 | 2020-08-15 | Johnson | Illinois | 17087 | 77 | 0 |
431654 | 431654 | 2020-08-14 | Johnson | Illinois | 17087 | 76 | 0 |
428426 | 428426 | 2020-08-13 | Johnson | Illinois | 17087 | 71 | 0 |
425202 | 425202 | 2020-08-12 | Johnson | Illinois | 17087 | 70 | 0 |
421981 | 421981 | 2020-08-11 | Johnson | Illinois | 17087 | 71 | 0 |
418758 | 418758 | 2020-08-10 | Johnson | Illinois | 17087 | 69 | 0 |
415537 | 415537 | 2020-08-09 | Johnson | Illinois | 17087 | 67 | 0 |
412317 | 412317 | 2020-08-08 | Johnson | Illinois | 17087 | 66 | 0 |
409098 | 409098 | 2020-08-07 | Johnson | Illinois | 17087 | 66 | 0 |
405878 | 405878 | 2020-08-06 | Johnson | Illinois | 17087 | 66 | 0 |
402660 | 402660 | 2020-08-05 | Johnson | Illinois | 17087 | 62 | 0 |
399444 | 399444 | 2020-08-04 | Johnson | Illinois | 17087 | 59 | 0 |
396228 | 396228 | 2020-08-03 | Johnson | Illinois | 17087 | 57 | 0 |
393012 | 393012 | 2020-08-02 | Johnson | Illinois | 17087 | 57 | 0 |
389795 | 389795 | 2020-08-01 | Johnson | Illinois | 17087 | 55 | 0 |
386578 | 386578 | 2020-07-31 | Johnson | Illinois | 17087 | 53 | 0 |
383360 | 383360 | 2020-07-30 | Johnson | Illinois | 17087 | 51 | 0 |
380143 | 380143 | 2020-07-29 | Johnson | Illinois | 17087 | 51 | 0 |
376926 | 376926 | 2020-07-28 | Johnson | Illinois | 17087 | 49 | 0 |
373711 | 373711 | 2020-07-27 | Johnson | Illinois | 17087 | 50 | 0 |
370499 | 370499 | 2020-07-26 | Johnson | Illinois | 17087 | 50 | 0 |
367289 | 367289 | 2020-07-25 | Johnson | Illinois | 17087 | 49 | 0 |
364082 | 364082 | 2020-07-24 | Johnson | Illinois | 17087 | 48 | 0 |
360875 | 360875 | 2020-07-23 | Johnson | Illinois | 17087 | 47 | 0 |
357670 | 357670 | 2020-07-22 | Johnson | Illinois | 17087 | 42 | 0 |
354468 | 354468 | 2020-07-21 | Johnson | Illinois | 17087 | 42 | 0 |
351266 | 351266 | 2020-07-20 | Johnson | Illinois | 17087 | 42 | 0 |
348066 | 348066 | 2020-07-19 | Johnson | Illinois | 17087 | 38 | 0 |
344865 | 344865 | 2020-07-18 | Johnson | Illinois | 17087 | 36 | 0 |
341665 | 341665 | 2020-07-17 | Johnson | Illinois | 17087 | 37 | 0 |
338469 | 338469 | 2020-07-16 | Johnson | Illinois | 17087 | 36 | 0 |
335273 | 335273 | 2020-07-15 | Johnson | Illinois | 17087 | 29 | 0 |
332080 | 332080 | 2020-07-14 | Johnson | Illinois | 17087 | 28 | 0 |
328893 | 328893 | 2020-07-13 | Johnson | Illinois | 17087 | 28 | 0 |
325707 | 325707 | 2020-07-12 | Johnson | Illinois | 17087 | 26 | 0 |
322526 | 322526 | 2020-07-11 | Johnson | Illinois | 17087 | 27 | 0 |
319347 | 319347 | 2020-07-10 | Johnson | Illinois | 17087 | 24 | 0 |
316174 | 316174 | 2020-07-09 | Johnson | Illinois | 17087 | 23 | 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);