ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Carroll", fips = 21041 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
908478 | 908478 | 2021-01-08 | Carroll | Kentucky | 21041 | 645 | 7 |
905232 | 905232 | 2021-01-07 | Carroll | Kentucky | 21041 | 593 | 7 |
901987 | 901987 | 2021-01-06 | Carroll | Kentucky | 21041 | 577 | 7 |
898742 | 898742 | 2021-01-05 | Carroll | Kentucky | 21041 | 562 | 7 |
895497 | 895497 | 2021-01-04 | Carroll | Kentucky | 21041 | 556 | 7 |
892250 | 892250 | 2021-01-03 | Carroll | Kentucky | 21041 | 548 | 7 |
889004 | 889004 | 2021-01-02 | Carroll | Kentucky | 21041 | 542 | 7 |
885758 | 885758 | 2021-01-01 | Carroll | Kentucky | 21041 | 527 | 6 |
882513 | 882513 | 2020-12-31 | Carroll | Kentucky | 21041 | 527 | 6 |
879268 | 879268 | 2020-12-30 | Carroll | Kentucky | 21041 | 527 | 6 |
876023 | 876023 | 2020-12-29 | Carroll | Kentucky | 21041 | 517 | 6 |
872778 | 872778 | 2020-12-28 | Carroll | Kentucky | 21041 | 508 | 6 |
869533 | 869533 | 2020-12-27 | Carroll | Kentucky | 21041 | 507 | 6 |
866288 | 866288 | 2020-12-26 | Carroll | Kentucky | 21041 | 506 | 6 |
863043 | 863043 | 2020-12-25 | Carroll | Kentucky | 21041 | 499 | 6 |
859798 | 859798 | 2020-12-24 | Carroll | Kentucky | 21041 | 499 | 6 |
856553 | 856553 | 2020-12-23 | Carroll | Kentucky | 21041 | 499 | 6 |
853308 | 853308 | 2020-12-22 | Carroll | Kentucky | 21041 | 522 | 7 |
850063 | 850063 | 2020-12-21 | Carroll | Kentucky | 21041 | 517 | 7 |
846818 | 846818 | 2020-12-20 | Carroll | Kentucky | 21041 | 514 | 7 |
843572 | 843572 | 2020-12-19 | Carroll | Kentucky | 21041 | 505 | 7 |
840327 | 840327 | 2020-12-18 | Carroll | Kentucky | 21041 | 493 | 7 |
837082 | 837082 | 2020-12-17 | Carroll | Kentucky | 21041 | 474 | 7 |
833836 | 833836 | 2020-12-16 | Carroll | Kentucky | 21041 | 461 | 6 |
830589 | 830589 | 2020-12-15 | Carroll | Kentucky | 21041 | 457 | 6 |
827343 | 827343 | 2020-12-14 | Carroll | Kentucky | 21041 | 450 | 6 |
824096 | 824096 | 2020-12-13 | Carroll | Kentucky | 21041 | 443 | 6 |
820850 | 820850 | 2020-12-12 | Carroll | Kentucky | 21041 | 441 | 6 |
817604 | 817604 | 2020-12-11 | Carroll | Kentucky | 21041 | 428 | 6 |
814358 | 814358 | 2020-12-10 | Carroll | Kentucky | 21041 | 414 | 6 |
811113 | 811113 | 2020-12-09 | Carroll | Kentucky | 21041 | 403 | 6 |
807868 | 807868 | 2020-12-08 | Carroll | Kentucky | 21041 | 396 | 6 |
804623 | 804623 | 2020-12-07 | Carroll | Kentucky | 21041 | 388 | 6 |
801378 | 801378 | 2020-12-06 | Carroll | Kentucky | 21041 | 386 | 6 |
798133 | 798133 | 2020-12-05 | Carroll | Kentucky | 21041 | 383 | 6 |
794888 | 794888 | 2020-12-04 | Carroll | Kentucky | 21041 | 374 | 6 |
791643 | 791643 | 2020-12-03 | Carroll | Kentucky | 21041 | 367 | 6 |
788398 | 788398 | 2020-12-02 | Carroll | Kentucky | 21041 | 354 | 6 |
785154 | 785154 | 2020-12-01 | Carroll | Kentucky | 21041 | 349 | 6 |
781909 | 781909 | 2020-11-30 | Carroll | Kentucky | 21041 | 346 | 6 |
778663 | 778663 | 2020-11-29 | Carroll | Kentucky | 21041 | 345 | 6 |
775418 | 775418 | 2020-11-28 | Carroll | Kentucky | 21041 | 343 | 6 |
772173 | 772173 | 2020-11-27 | Carroll | Kentucky | 21041 | 338 | 6 |
768928 | 768928 | 2020-11-26 | Carroll | Kentucky | 21041 | 323 | 6 |
765682 | 765682 | 2020-11-25 | Carroll | Kentucky | 21041 | 323 | 6 |
762437 | 762437 | 2020-11-24 | Carroll | Kentucky | 21041 | 322 | 6 |
759192 | 759192 | 2020-11-23 | Carroll | Kentucky | 21041 | 313 | 6 |
755945 | 755945 | 2020-11-22 | Carroll | Kentucky | 21041 | 309 | 6 |
752699 | 752699 | 2020-11-21 | Carroll | Kentucky | 21041 | 298 | 6 |
749453 | 749453 | 2020-11-20 | Carroll | Kentucky | 21041 | 293 | 6 |
746207 | 746207 | 2020-11-19 | Carroll | Kentucky | 21041 | 286 | 6 |
742960 | 742960 | 2020-11-18 | Carroll | Kentucky | 21041 | 280 | 6 |
739713 | 739713 | 2020-11-17 | Carroll | Kentucky | 21041 | 273 | 6 |
736469 | 736469 | 2020-11-16 | Carroll | Kentucky | 21041 | 267 | 6 |
733223 | 733223 | 2020-11-15 | Carroll | Kentucky | 21041 | 267 | 6 |
729978 | 729978 | 2020-11-14 | Carroll | Kentucky | 21041 | 264 | 6 |
726735 | 726735 | 2020-11-13 | Carroll | Kentucky | 21041 | 261 | 6 |
723492 | 723492 | 2020-11-12 | Carroll | Kentucky | 21041 | 258 | 6 |
720249 | 720249 | 2020-11-11 | Carroll | Kentucky | 21041 | 254 | 6 |
717006 | 717006 | 2020-11-10 | Carroll | Kentucky | 21041 | 251 | 6 |
713762 | 713762 | 2020-11-09 | Carroll | Kentucky | 21041 | 251 | 6 |
710518 | 710518 | 2020-11-08 | Carroll | Kentucky | 21041 | 250 | 6 |
707274 | 707274 | 2020-11-07 | Carroll | Kentucky | 21041 | 249 | 6 |
704031 | 704031 | 2020-11-06 | Carroll | Kentucky | 21041 | 242 | 6 |
700789 | 700789 | 2020-11-05 | Carroll | Kentucky | 21041 | 242 | 6 |
697545 | 697545 | 2020-11-04 | Carroll | Kentucky | 21041 | 239 | 5 |
694302 | 694302 | 2020-11-03 | Carroll | Kentucky | 21041 | 236 | 5 |
691060 | 691060 | 2020-11-02 | Carroll | Kentucky | 21041 | 233 | 5 |
687815 | 687815 | 2020-11-01 | Carroll | Kentucky | 21041 | 233 | 5 |
684571 | 684571 | 2020-10-31 | Carroll | Kentucky | 21041 | 232 | 5 |
681328 | 681328 | 2020-10-30 | Carroll | Kentucky | 21041 | 231 | 5 |
678084 | 678084 | 2020-10-29 | Carroll | Kentucky | 21041 | 228 | 5 |
674842 | 674842 | 2020-10-28 | Carroll | Kentucky | 21041 | 226 | 5 |
671599 | 671599 | 2020-10-27 | Carroll | Kentucky | 21041 | 224 | 5 |
668357 | 668357 | 2020-10-26 | Carroll | Kentucky | 21041 | 224 | 5 |
665113 | 665113 | 2020-10-25 | Carroll | Kentucky | 21041 | 220 | 5 |
661868 | 661868 | 2020-10-24 | Carroll | Kentucky | 21041 | 217 | 5 |
658624 | 658624 | 2020-10-23 | Carroll | Kentucky | 21041 | 214 | 5 |
655379 | 655379 | 2020-10-22 | Carroll | Kentucky | 21041 | 214 | 5 |
652134 | 652134 | 2020-10-21 | Carroll | Kentucky | 21041 | 214 | 5 |
648889 | 648889 | 2020-10-20 | Carroll | Kentucky | 21041 | 212 | 5 |
645645 | 645645 | 2020-10-19 | Carroll | Kentucky | 21041 | 211 | 5 |
642398 | 642398 | 2020-10-18 | Carroll | Kentucky | 21041 | 211 | 5 |
639151 | 639151 | 2020-10-17 | Carroll | Kentucky | 21041 | 209 | 5 |
635905 | 635905 | 2020-10-16 | Carroll | Kentucky | 21041 | 208 | 5 |
632659 | 632659 | 2020-10-15 | Carroll | Kentucky | 21041 | 207 | 5 |
629415 | 629415 | 2020-10-14 | Carroll | Kentucky | 21041 | 206 | 5 |
626171 | 626171 | 2020-10-13 | Carroll | Kentucky | 21041 | 207 | 5 |
622929 | 622929 | 2020-10-12 | Carroll | Kentucky | 21041 | 209 | 5 |
619685 | 619685 | 2020-10-11 | Carroll | Kentucky | 21041 | 209 | 5 |
616443 | 616443 | 2020-10-10 | Carroll | Kentucky | 21041 | 207 | 5 |
613202 | 613202 | 2020-10-09 | Carroll | Kentucky | 21041 | 206 | 5 |
609960 | 609960 | 2020-10-08 | Carroll | Kentucky | 21041 | 203 | 5 |
606718 | 606718 | 2020-10-07 | Carroll | Kentucky | 21041 | 203 | 5 |
603476 | 603476 | 2020-10-06 | Carroll | Kentucky | 21041 | 203 | 5 |
600233 | 600233 | 2020-10-05 | Carroll | Kentucky | 21041 | 203 | 5 |
596991 | 596991 | 2020-10-04 | Carroll | Kentucky | 21041 | 203 | 5 |
593749 | 593749 | 2020-10-03 | Carroll | Kentucky | 21041 | 203 | 5 |
590508 | 590508 | 2020-10-02 | Carroll | Kentucky | 21041 | 202 | 5 |
587267 | 587267 | 2020-10-01 | Carroll | Kentucky | 21041 | 202 | 5 |
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);