ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21215 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
769015 | 769015 | 2020-11-26 | Spencer | Kentucky | 21215 | 591 | 2 |
765769 | 765769 | 2020-11-25 | Spencer | Kentucky | 21215 | 591 | 2 |
762524 | 762524 | 2020-11-24 | Spencer | Kentucky | 21215 | 570 | 1 |
759279 | 759279 | 2020-11-23 | Spencer | Kentucky | 21215 | 563 | 1 |
756032 | 756032 | 2020-11-22 | Spencer | Kentucky | 21215 | 554 | 1 |
752786 | 752786 | 2020-11-21 | Spencer | Kentucky | 21215 | 549 | 1 |
749540 | 749540 | 2020-11-20 | Spencer | Kentucky | 21215 | 538 | 1 |
746294 | 746294 | 2020-11-19 | Spencer | Kentucky | 21215 | 521 | 1 |
743047 | 743047 | 2020-11-18 | Spencer | Kentucky | 21215 | 508 | 1 |
739800 | 739800 | 2020-11-17 | Spencer | Kentucky | 21215 | 504 | 1 |
736556 | 736556 | 2020-11-16 | Spencer | Kentucky | 21215 | 496 | 1 |
733310 | 733310 | 2020-11-15 | Spencer | Kentucky | 21215 | 488 | 1 |
730065 | 730065 | 2020-11-14 | Spencer | Kentucky | 21215 | 485 | 1 |
726822 | 726822 | 2020-11-13 | Spencer | Kentucky | 21215 | 444 | 1 |
723579 | 723579 | 2020-11-12 | Spencer | Kentucky | 21215 | 427 | 1 |
720336 | 720336 | 2020-11-11 | Spencer | Kentucky | 21215 | 418 | 1 |
717093 | 717093 | 2020-11-10 | Spencer | Kentucky | 21215 | 408 | 1 |
713849 | 713849 | 2020-11-09 | Spencer | Kentucky | 21215 | 406 | 1 |
710605 | 710605 | 2020-11-08 | Spencer | Kentucky | 21215 | 387 | 1 |
707361 | 707361 | 2020-11-07 | Spencer | Kentucky | 21215 | 389 | 1 |
704118 | 704118 | 2020-11-06 | Spencer | Kentucky | 21215 | 382 | 1 |
700876 | 700876 | 2020-11-05 | Spencer | Kentucky | 21215 | 372 | 1 |
697632 | 697632 | 2020-11-04 | Spencer | Kentucky | 21215 | 359 | 1 |
694389 | 694389 | 2020-11-03 | Spencer | Kentucky | 21215 | 347 | 1 |
691147 | 691147 | 2020-11-02 | Spencer | Kentucky | 21215 | 341 | 1 |
687902 | 687902 | 2020-11-01 | Spencer | Kentucky | 21215 | 339 | 1 |
684658 | 684658 | 2020-10-31 | Spencer | Kentucky | 21215 | 337 | 1 |
681415 | 681415 | 2020-10-30 | Spencer | Kentucky | 21215 | 326 | 1 |
678171 | 678171 | 2020-10-29 | Spencer | Kentucky | 21215 | 319 | 1 |
674929 | 674929 | 2020-10-28 | Spencer | Kentucky | 21215 | 315 | 1 |
671686 | 671686 | 2020-10-27 | Spencer | Kentucky | 21215 | 308 | 1 |
668444 | 668444 | 2020-10-26 | Spencer | Kentucky | 21215 | 301 | 1 |
665200 | 665200 | 2020-10-25 | Spencer | Kentucky | 21215 | 293 | 1 |
661955 | 661955 | 2020-10-24 | Spencer | Kentucky | 21215 | 285 | 0 |
658711 | 658711 | 2020-10-23 | Spencer | Kentucky | 21215 | 284 | 0 |
655466 | 655466 | 2020-10-22 | Spencer | Kentucky | 21215 | 280 | 0 |
652221 | 652221 | 2020-10-21 | Spencer | Kentucky | 21215 | 269 | 0 |
648976 | 648976 | 2020-10-20 | Spencer | Kentucky | 21215 | 265 | 0 |
645732 | 645732 | 2020-10-19 | Spencer | Kentucky | 21215 | 263 | 0 |
642485 | 642485 | 2020-10-18 | Spencer | Kentucky | 21215 | 259 | 0 |
639238 | 639238 | 2020-10-17 | Spencer | Kentucky | 21215 | 257 | 0 |
635992 | 635992 | 2020-10-16 | Spencer | Kentucky | 21215 | 254 | 0 |
632746 | 632746 | 2020-10-15 | Spencer | Kentucky | 21215 | 250 | 0 |
629502 | 629502 | 2020-10-14 | Spencer | Kentucky | 21215 | 248 | 0 |
626258 | 626258 | 2020-10-13 | Spencer | Kentucky | 21215 | 244 | 0 |
623016 | 623016 | 2020-10-12 | Spencer | Kentucky | 21215 | 244 | 0 |
619772 | 619772 | 2020-10-11 | Spencer | Kentucky | 21215 | 242 | 0 |
616530 | 616530 | 2020-10-10 | Spencer | Kentucky | 21215 | 237 | 0 |
613289 | 613289 | 2020-10-09 | Spencer | Kentucky | 21215 | 235 | 0 |
610047 | 610047 | 2020-10-08 | Spencer | Kentucky | 21215 | 233 | 0 |
606805 | 606805 | 2020-10-07 | Spencer | Kentucky | 21215 | 232 | 0 |
603563 | 603563 | 2020-10-06 | Spencer | Kentucky | 21215 | 226 | 0 |
600320 | 600320 | 2020-10-05 | Spencer | Kentucky | 21215 | 225 | 0 |
597078 | 597078 | 2020-10-04 | Spencer | Kentucky | 21215 | 225 | 0 |
593836 | 593836 | 2020-10-03 | Spencer | Kentucky | 21215 | 222 | 0 |
590595 | 590595 | 2020-10-02 | Spencer | Kentucky | 21215 | 221 | 0 |
587354 | 587354 | 2020-10-01 | Spencer | Kentucky | 21215 | 218 | 0 |
584114 | 584114 | 2020-09-30 | Spencer | Kentucky | 21215 | 216 | 0 |
580874 | 580874 | 2020-09-29 | Spencer | Kentucky | 21215 | 215 | 0 |
577633 | 577633 | 2020-09-28 | Spencer | Kentucky | 21215 | 214 | 0 |
574391 | 574391 | 2020-09-27 | Spencer | Kentucky | 21215 | 213 | 0 |
571148 | 571148 | 2020-09-26 | Spencer | Kentucky | 21215 | 211 | 0 |
567906 | 567906 | 2020-09-25 | Spencer | Kentucky | 21215 | 208 | 0 |
564666 | 564666 | 2020-09-24 | Spencer | Kentucky | 21215 | 205 | 0 |
561426 | 561426 | 2020-09-23 | Spencer | Kentucky | 21215 | 198 | 0 |
558190 | 558190 | 2020-09-22 | Spencer | Kentucky | 21215 | 197 | 0 |
554953 | 554953 | 2020-09-21 | Spencer | Kentucky | 21215 | 197 | 0 |
551714 | 551714 | 2020-09-20 | Spencer | Kentucky | 21215 | 197 | 0 |
548475 | 548475 | 2020-09-19 | Spencer | Kentucky | 21215 | 197 | 0 |
545237 | 545237 | 2020-09-18 | Spencer | Kentucky | 21215 | 192 | 0 |
542001 | 542001 | 2020-09-17 | Spencer | Kentucky | 21215 | 191 | 0 |
538765 | 538765 | 2020-09-16 | Spencer | Kentucky | 21215 | 190 | 0 |
535528 | 535528 | 2020-09-15 | Spencer | Kentucky | 21215 | 189 | 0 |
532293 | 532293 | 2020-09-14 | Spencer | Kentucky | 21215 | 188 | 0 |
529056 | 529056 | 2020-09-13 | Spencer | Kentucky | 21215 | 188 | 0 |
525820 | 525820 | 2020-09-12 | Spencer | Kentucky | 21215 | 188 | 0 |
522584 | 522584 | 2020-09-11 | Spencer | Kentucky | 21215 | 184 | 0 |
519347 | 519347 | 2020-09-10 | Spencer | Kentucky | 21215 | 183 | 0 |
516112 | 516112 | 2020-09-09 | Spencer | Kentucky | 21215 | 177 | 0 |
512879 | 512879 | 2020-09-08 | Spencer | Kentucky | 21215 | 174 | 0 |
509647 | 509647 | 2020-09-07 | Spencer | Kentucky | 21215 | 174 | 0 |
506414 | 506414 | 2020-09-06 | Spencer | Kentucky | 21215 | 174 | 0 |
503180 | 503180 | 2020-09-05 | Spencer | Kentucky | 21215 | 173 | 0 |
499947 | 499947 | 2020-09-04 | Spencer | Kentucky | 21215 | 173 | 0 |
496713 | 496713 | 2020-09-03 | Spencer | Kentucky | 21215 | 168 | 0 |
493480 | 493480 | 2020-09-02 | Spencer | Kentucky | 21215 | 171 | 0 |
490246 | 490246 | 2020-09-01 | Spencer | Kentucky | 21215 | 169 | 0 |
487013 | 487013 | 2020-08-31 | Spencer | Kentucky | 21215 | 169 | 0 |
483778 | 483778 | 2020-08-30 | Spencer | Kentucky | 21215 | 169 | 0 |
480544 | 480544 | 2020-08-29 | Spencer | Kentucky | 21215 | 166 | 0 |
477311 | 477311 | 2020-08-28 | Spencer | Kentucky | 21215 | 163 | 0 |
474078 | 474078 | 2020-08-27 | Spencer | Kentucky | 21215 | 163 | 0 |
470846 | 470846 | 2020-08-26 | Spencer | Kentucky | 21215 | 162 | 0 |
467617 | 467617 | 2020-08-25 | Spencer | Kentucky | 21215 | 161 | 0 |
464388 | 464388 | 2020-08-24 | Spencer | Kentucky | 21215 | 160 | 0 |
461157 | 461157 | 2020-08-23 | Spencer | Kentucky | 21215 | 152 | 0 |
457930 | 457930 | 2020-08-22 | Spencer | Kentucky | 21215 | 152 | 0 |
454702 | 454702 | 2020-08-21 | Spencer | Kentucky | 21215 | 149 | 0 |
451474 | 451474 | 2020-08-20 | Spencer | Kentucky | 21215 | 146 | 0 |
448246 | 448246 | 2020-08-19 | Spencer | Kentucky | 21215 | 145 | 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);