ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Johnson" and fips = 21115 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635942 | 635942 | 2020-10-16 | Johnson | Kentucky | 21115 | 216 | 2 |
632696 | 632696 | 2020-10-15 | Johnson | Kentucky | 21115 | 209 | 2 |
629452 | 629452 | 2020-10-14 | Johnson | Kentucky | 21115 | 206 | 2 |
626208 | 626208 | 2020-10-13 | Johnson | Kentucky | 21115 | 201 | 2 |
622966 | 622966 | 2020-10-12 | Johnson | Kentucky | 21115 | 194 | 2 |
619722 | 619722 | 2020-10-11 | Johnson | Kentucky | 21115 | 192 | 2 |
616480 | 616480 | 2020-10-10 | Johnson | Kentucky | 21115 | 191 | 2 |
613239 | 613239 | 2020-10-09 | Johnson | Kentucky | 21115 | 186 | 2 |
609997 | 609997 | 2020-10-08 | Johnson | Kentucky | 21115 | 180 | 2 |
606755 | 606755 | 2020-10-07 | Johnson | Kentucky | 21115 | 178 | 2 |
603513 | 603513 | 2020-10-06 | Johnson | Kentucky | 21115 | 176 | 2 |
600270 | 600270 | 2020-10-05 | Johnson | Kentucky | 21115 | 165 | 2 |
597028 | 597028 | 2020-10-04 | Johnson | Kentucky | 21115 | 163 | 2 |
593786 | 593786 | 2020-10-03 | Johnson | Kentucky | 21115 | 163 | 2 |
590545 | 590545 | 2020-10-02 | Johnson | Kentucky | 21115 | 162 | 2 |
587304 | 587304 | 2020-10-01 | Johnson | Kentucky | 21115 | 162 | 2 |
584064 | 584064 | 2020-09-30 | Johnson | Kentucky | 21115 | 161 | 2 |
580824 | 580824 | 2020-09-29 | Johnson | Kentucky | 21115 | 161 | 2 |
577583 | 577583 | 2020-09-28 | Johnson | Kentucky | 21115 | 158 | 2 |
574341 | 574341 | 2020-09-27 | Johnson | Kentucky | 21115 | 155 | 1 |
571098 | 571098 | 2020-09-26 | Johnson | Kentucky | 21115 | 155 | 1 |
567856 | 567856 | 2020-09-25 | Johnson | Kentucky | 21115 | 150 | 1 |
564616 | 564616 | 2020-09-24 | Johnson | Kentucky | 21115 | 147 | 1 |
561376 | 561376 | 2020-09-23 | Johnson | Kentucky | 21115 | 147 | 1 |
558140 | 558140 | 2020-09-22 | Johnson | Kentucky | 21115 | 145 | 1 |
554903 | 554903 | 2020-09-21 | Johnson | Kentucky | 21115 | 146 | 1 |
551664 | 551664 | 2020-09-20 | Johnson | Kentucky | 21115 | 146 | 1 |
548425 | 548425 | 2020-09-19 | Johnson | Kentucky | 21115 | 145 | 1 |
545187 | 545187 | 2020-09-18 | Johnson | Kentucky | 21115 | 142 | 1 |
541951 | 541951 | 2020-09-17 | Johnson | Kentucky | 21115 | 141 | 1 |
538715 | 538715 | 2020-09-16 | Johnson | Kentucky | 21115 | 137 | 1 |
535478 | 535478 | 2020-09-15 | Johnson | Kentucky | 21115 | 136 | 1 |
532243 | 532243 | 2020-09-14 | Johnson | Kentucky | 21115 | 136 | 1 |
529006 | 529006 | 2020-09-13 | Johnson | Kentucky | 21115 | 136 | 1 |
525770 | 525770 | 2020-09-12 | Johnson | Kentucky | 21115 | 136 | 1 |
522534 | 522534 | 2020-09-11 | Johnson | Kentucky | 21115 | 135 | 1 |
519297 | 519297 | 2020-09-10 | Johnson | Kentucky | 21115 | 130 | 1 |
516062 | 516062 | 2020-09-09 | Johnson | Kentucky | 21115 | 128 | 1 |
512829 | 512829 | 2020-09-08 | Johnson | Kentucky | 21115 | 128 | 1 |
509597 | 509597 | 2020-09-07 | Johnson | Kentucky | 21115 | 128 | 1 |
506364 | 506364 | 2020-09-06 | Johnson | Kentucky | 21115 | 128 | 1 |
503130 | 503130 | 2020-09-05 | Johnson | Kentucky | 21115 | 128 | 1 |
499897 | 499897 | 2020-09-04 | Johnson | Kentucky | 21115 | 128 | 1 |
496663 | 496663 | 2020-09-03 | Johnson | Kentucky | 21115 | 128 | 1 |
493430 | 493430 | 2020-09-02 | Johnson | Kentucky | 21115 | 127 | 1 |
490196 | 490196 | 2020-09-01 | Johnson | Kentucky | 21115 | 124 | 1 |
486963 | 486963 | 2020-08-31 | Johnson | Kentucky | 21115 | 121 | 1 |
483728 | 483728 | 2020-08-30 | Johnson | Kentucky | 21115 | 117 | 1 |
480494 | 480494 | 2020-08-29 | Johnson | Kentucky | 21115 | 117 | 1 |
477261 | 477261 | 2020-08-28 | Johnson | Kentucky | 21115 | 115 | 1 |
474028 | 474028 | 2020-08-27 | Johnson | Kentucky | 21115 | 110 | 1 |
470796 | 470796 | 2020-08-26 | Johnson | Kentucky | 21115 | 105 | 1 |
467567 | 467567 | 2020-08-25 | Johnson | Kentucky | 21115 | 101 | 1 |
464338 | 464338 | 2020-08-24 | Johnson | Kentucky | 21115 | 101 | 1 |
461107 | 461107 | 2020-08-23 | Johnson | Kentucky | 21115 | 101 | 0 |
457880 | 457880 | 2020-08-22 | Johnson | Kentucky | 21115 | 101 | 0 |
454652 | 454652 | 2020-08-21 | Johnson | Kentucky | 21115 | 100 | 0 |
451424 | 451424 | 2020-08-20 | Johnson | Kentucky | 21115 | 98 | 0 |
448196 | 448196 | 2020-08-19 | Johnson | Kentucky | 21115 | 98 | 0 |
444969 | 444969 | 2020-08-18 | Johnson | Kentucky | 21115 | 90 | 0 |
441743 | 441743 | 2020-08-17 | Johnson | Kentucky | 21115 | 84 | 0 |
438516 | 438516 | 2020-08-16 | Johnson | Kentucky | 21115 | 83 | 0 |
435291 | 435291 | 2020-08-15 | Johnson | Kentucky | 21115 | 83 | 0 |
432066 | 432066 | 2020-08-14 | Johnson | Kentucky | 21115 | 80 | 0 |
428838 | 428838 | 2020-08-13 | Johnson | Kentucky | 21115 | 73 | 0 |
425614 | 425614 | 2020-08-12 | Johnson | Kentucky | 21115 | 66 | 0 |
422393 | 422393 | 2020-08-11 | Johnson | Kentucky | 21115 | 64 | 0 |
419171 | 419171 | 2020-08-10 | Johnson | Kentucky | 21115 | 49 | 0 |
415950 | 415950 | 2020-08-09 | Johnson | Kentucky | 21115 | 49 | 0 |
412730 | 412730 | 2020-08-08 | Johnson | Kentucky | 21115 | 50 | 0 |
409510 | 409510 | 2020-08-07 | Johnson | Kentucky | 21115 | 48 | 0 |
406290 | 406290 | 2020-08-06 | Johnson | Kentucky | 21115 | 46 | 0 |
403072 | 403072 | 2020-08-05 | Johnson | Kentucky | 21115 | 43 | 0 |
399855 | 399855 | 2020-08-04 | Johnson | Kentucky | 21115 | 40 | 0 |
396640 | 396640 | 2020-08-03 | Johnson | Kentucky | 21115 | 39 | 0 |
393424 | 393424 | 2020-08-02 | Johnson | Kentucky | 21115 | 39 | 0 |
390207 | 390207 | 2020-08-01 | Johnson | Kentucky | 21115 | 37 | 0 |
386990 | 386990 | 2020-07-31 | Johnson | Kentucky | 21115 | 32 | 0 |
383772 | 383772 | 2020-07-30 | Johnson | Kentucky | 21115 | 29 | 0 |
380555 | 380555 | 2020-07-29 | Johnson | Kentucky | 21115 | 29 | 0 |
377338 | 377338 | 2020-07-28 | Johnson | Kentucky | 21115 | 29 | 0 |
374123 | 374123 | 2020-07-27 | Johnson | Kentucky | 21115 | 26 | 0 |
370911 | 370911 | 2020-07-26 | Johnson | Kentucky | 21115 | 24 | 0 |
367701 | 367701 | 2020-07-25 | Johnson | Kentucky | 21115 | 19 | 0 |
364494 | 364494 | 2020-07-24 | Johnson | Kentucky | 21115 | 18 | 0 |
361287 | 361287 | 2020-07-23 | Johnson | Kentucky | 21115 | 18 | 0 |
358082 | 358082 | 2020-07-22 | Johnson | Kentucky | 21115 | 17 | 0 |
354879 | 354879 | 2020-07-21 | Johnson | Kentucky | 21115 | 17 | 0 |
351677 | 351677 | 2020-07-20 | Johnson | Kentucky | 21115 | 16 | 0 |
348477 | 348477 | 2020-07-19 | Johnson | Kentucky | 21115 | 16 | 0 |
345276 | 345276 | 2020-07-18 | Johnson | Kentucky | 21115 | 13 | 0 |
342076 | 342076 | 2020-07-17 | Johnson | Kentucky | 21115 | 13 | 0 |
338880 | 338880 | 2020-07-16 | Johnson | Kentucky | 21115 | 12 | 0 |
335684 | 335684 | 2020-07-15 | Johnson | Kentucky | 21115 | 12 | 0 |
332491 | 332491 | 2020-07-14 | Johnson | Kentucky | 21115 | 12 | 0 |
329304 | 329304 | 2020-07-13 | Johnson | Kentucky | 21115 | 11 | 0 |
326118 | 326118 | 2020-07-12 | Johnson | Kentucky | 21115 | 11 | 0 |
322935 | 322935 | 2020-07-11 | Johnson | Kentucky | 21115 | 11 | 0 |
319756 | 319756 | 2020-07-10 | Johnson | Kentucky | 21115 | 11 | 0 |
316581 | 316581 | 2020-07-09 | Johnson | Kentucky | 21115 | 10 | 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);