ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Grant" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635925 | 635925 | 2020-10-16 | Grant | Kentucky | 21081 | 214 | 6 |
632679 | 632679 | 2020-10-15 | Grant | Kentucky | 21081 | 213 | 6 |
629435 | 629435 | 2020-10-14 | Grant | Kentucky | 21081 | 209 | 6 |
626191 | 626191 | 2020-10-13 | Grant | Kentucky | 21081 | 205 | 6 |
622949 | 622949 | 2020-10-12 | Grant | Kentucky | 21081 | 204 | 6 |
619705 | 619705 | 2020-10-11 | Grant | Kentucky | 21081 | 204 | 6 |
616463 | 616463 | 2020-10-10 | Grant | Kentucky | 21081 | 200 | 6 |
613222 | 613222 | 2020-10-09 | Grant | Kentucky | 21081 | 198 | 6 |
609980 | 609980 | 2020-10-08 | Grant | Kentucky | 21081 | 195 | 6 |
606738 | 606738 | 2020-10-07 | Grant | Kentucky | 21081 | 194 | 6 |
603496 | 603496 | 2020-10-06 | Grant | Kentucky | 21081 | 192 | 6 |
600253 | 600253 | 2020-10-05 | Grant | Kentucky | 21081 | 189 | 6 |
597011 | 597011 | 2020-10-04 | Grant | Kentucky | 21081 | 185 | 6 |
593769 | 593769 | 2020-10-03 | Grant | Kentucky | 21081 | 184 | 6 |
590528 | 590528 | 2020-10-02 | Grant | Kentucky | 21081 | 179 | 6 |
587287 | 587287 | 2020-10-01 | Grant | Kentucky | 21081 | 174 | 6 |
584047 | 584047 | 2020-09-30 | Grant | Kentucky | 21081 | 173 | 6 |
580807 | 580807 | 2020-09-29 | Grant | Kentucky | 21081 | 171 | 6 |
577566 | 577566 | 2020-09-28 | Grant | Kentucky | 21081 | 170 | 6 |
574324 | 574324 | 2020-09-27 | Grant | Kentucky | 21081 | 164 | 6 |
571081 | 571081 | 2020-09-26 | Grant | Kentucky | 21081 | 163 | 6 |
567839 | 567839 | 2020-09-25 | Grant | Kentucky | 21081 | 162 | 6 |
564599 | 564599 | 2020-09-24 | Grant | Kentucky | 21081 | 159 | 6 |
561359 | 561359 | 2020-09-23 | Grant | Kentucky | 21081 | 158 | 6 |
558123 | 558123 | 2020-09-22 | Grant | Kentucky | 21081 | 158 | 6 |
554886 | 554886 | 2020-09-21 | Grant | Kentucky | 21081 | 156 | 6 |
551647 | 551647 | 2020-09-20 | Grant | Kentucky | 21081 | 154 | 6 |
548408 | 548408 | 2020-09-19 | Grant | Kentucky | 21081 | 154 | 6 |
545170 | 545170 | 2020-09-18 | Grant | Kentucky | 21081 | 154 | 6 |
541934 | 541934 | 2020-09-17 | Grant | Kentucky | 21081 | 153 | 6 |
538698 | 538698 | 2020-09-16 | Grant | Kentucky | 21081 | 151 | 6 |
535461 | 535461 | 2020-09-15 | Grant | Kentucky | 21081 | 150 | 6 |
532226 | 532226 | 2020-09-14 | Grant | Kentucky | 21081 | 150 | 6 |
528989 | 528989 | 2020-09-13 | Grant | Kentucky | 21081 | 149 | 6 |
525753 | 525753 | 2020-09-12 | Grant | Kentucky | 21081 | 149 | 6 |
522517 | 522517 | 2020-09-11 | Grant | Kentucky | 21081 | 148 | 6 |
519280 | 519280 | 2020-09-10 | Grant | Kentucky | 21081 | 148 | 6 |
516045 | 516045 | 2020-09-09 | Grant | Kentucky | 21081 | 147 | 6 |
512812 | 512812 | 2020-09-08 | Grant | Kentucky | 21081 | 148 | 6 |
509580 | 509580 | 2020-09-07 | Grant | Kentucky | 21081 | 143 | 6 |
506347 | 506347 | 2020-09-06 | Grant | Kentucky | 21081 | 143 | 6 |
503113 | 503113 | 2020-09-05 | Grant | Kentucky | 21081 | 143 | 6 |
499880 | 499880 | 2020-09-04 | Grant | Kentucky | 21081 | 143 | 6 |
496646 | 496646 | 2020-09-03 | Grant | Kentucky | 21081 | 142 | 6 |
493413 | 493413 | 2020-09-02 | Grant | Kentucky | 21081 | 140 | 6 |
490179 | 490179 | 2020-09-01 | Grant | Kentucky | 21081 | 139 | 6 |
486946 | 486946 | 2020-08-31 | Grant | Kentucky | 21081 | 138 | 6 |
483711 | 483711 | 2020-08-30 | Grant | Kentucky | 21081 | 138 | 6 |
480477 | 480477 | 2020-08-29 | Grant | Kentucky | 21081 | 137 | 6 |
477244 | 477244 | 2020-08-28 | Grant | Kentucky | 21081 | 136 | 6 |
474011 | 474011 | 2020-08-27 | Grant | Kentucky | 21081 | 135 | 6 |
470779 | 470779 | 2020-08-26 | Grant | Kentucky | 21081 | 133 | 6 |
467550 | 467550 | 2020-08-25 | Grant | Kentucky | 21081 | 133 | 6 |
464321 | 464321 | 2020-08-24 | Grant | Kentucky | 21081 | 133 | 6 |
461090 | 461090 | 2020-08-23 | Grant | Kentucky | 21081 | 133 | 6 |
457863 | 457863 | 2020-08-22 | Grant | Kentucky | 21081 | 133 | 6 |
454635 | 454635 | 2020-08-21 | Grant | Kentucky | 21081 | 133 | 6 |
451407 | 451407 | 2020-08-20 | Grant | Kentucky | 21081 | 131 | 6 |
448179 | 448179 | 2020-08-19 | Grant | Kentucky | 21081 | 131 | 6 |
444952 | 444952 | 2020-08-18 | Grant | Kentucky | 21081 | 130 | 6 |
441726 | 441726 | 2020-08-17 | Grant | Kentucky | 21081 | 129 | 6 |
438499 | 438499 | 2020-08-16 | Grant | Kentucky | 21081 | 130 | 6 |
435274 | 435274 | 2020-08-15 | Grant | Kentucky | 21081 | 130 | 6 |
432049 | 432049 | 2020-08-14 | Grant | Kentucky | 21081 | 129 | 6 |
428821 | 428821 | 2020-08-13 | Grant | Kentucky | 21081 | 127 | 6 |
425597 | 425597 | 2020-08-12 | Grant | Kentucky | 21081 | 126 | 6 |
422376 | 422376 | 2020-08-11 | Grant | Kentucky | 21081 | 124 | 6 |
419154 | 419154 | 2020-08-10 | Grant | Kentucky | 21081 | 124 | 6 |
415933 | 415933 | 2020-08-09 | Grant | Kentucky | 21081 | 120 | 5 |
412713 | 412713 | 2020-08-08 | Grant | Kentucky | 21081 | 117 | 5 |
409493 | 409493 | 2020-08-07 | Grant | Kentucky | 21081 | 112 | 5 |
406273 | 406273 | 2020-08-06 | Grant | Kentucky | 21081 | 108 | 5 |
403055 | 403055 | 2020-08-05 | Grant | Kentucky | 21081 | 107 | 5 |
399838 | 399838 | 2020-08-04 | Grant | Kentucky | 21081 | 106 | 5 |
396623 | 396623 | 2020-08-03 | Grant | Kentucky | 21081 | 105 | 5 |
393407 | 393407 | 2020-08-02 | Grant | Kentucky | 21081 | 100 | 5 |
390190 | 390190 | 2020-08-01 | Grant | Kentucky | 21081 | 99 | 5 |
386973 | 386973 | 2020-07-31 | Grant | Kentucky | 21081 | 96 | 5 |
383755 | 383755 | 2020-07-30 | Grant | Kentucky | 21081 | 91 | 5 |
380538 | 380538 | 2020-07-29 | Grant | Kentucky | 21081 | 89 | 5 |
377321 | 377321 | 2020-07-28 | Grant | Kentucky | 21081 | 87 | 5 |
374106 | 374106 | 2020-07-27 | Grant | Kentucky | 21081 | 86 | 5 |
370894 | 370894 | 2020-07-26 | Grant | Kentucky | 21081 | 84 | 5 |
367684 | 367684 | 2020-07-25 | Grant | Kentucky | 21081 | 84 | 5 |
364477 | 364477 | 2020-07-24 | Grant | Kentucky | 21081 | 83 | 5 |
361270 | 361270 | 2020-07-23 | Grant | Kentucky | 21081 | 81 | 5 |
358065 | 358065 | 2020-07-22 | Grant | Kentucky | 21081 | 80 | 5 |
354862 | 354862 | 2020-07-21 | Grant | Kentucky | 21081 | 79 | 5 |
351660 | 351660 | 2020-07-20 | Grant | Kentucky | 21081 | 79 | 5 |
348460 | 348460 | 2020-07-19 | Grant | Kentucky | 21081 | 78 | 5 |
345259 | 345259 | 2020-07-18 | Grant | Kentucky | 21081 | 77 | 5 |
342059 | 342059 | 2020-07-17 | Grant | Kentucky | 21081 | 76 | 5 |
338863 | 338863 | 2020-07-16 | Grant | Kentucky | 21081 | 74 | 5 |
335667 | 335667 | 2020-07-15 | Grant | Kentucky | 21081 | 71 | 5 |
332474 | 332474 | 2020-07-14 | Grant | Kentucky | 21081 | 70 | 5 |
329287 | 329287 | 2020-07-13 | Grant | Kentucky | 21081 | 70 | 5 |
326101 | 326101 | 2020-07-12 | Grant | Kentucky | 21081 | 67 | 5 |
322918 | 322918 | 2020-07-11 | Grant | Kentucky | 21081 | 66 | 5 |
319739 | 319739 | 2020-07-10 | Grant | Kentucky | 21081 | 64 | 5 |
316564 | 316564 | 2020-07-09 | Grant | Kentucky | 21081 | 62 | 4 |
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);