ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where fips = 21075 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1090245 | 1090245 | 2021-03-05 | Fulton | Kentucky | 21075 | 485 | 7 |
1087000 | 1087000 | 2021-03-04 | Fulton | Kentucky | 21075 | 482 | 7 |
1083754 | 1083754 | 2021-03-03 | Fulton | Kentucky | 21075 | 482 | 6 |
1080508 | 1080508 | 2021-03-02 | Fulton | Kentucky | 21075 | 482 | 6 |
1077263 | 1077263 | 2021-03-01 | Fulton | Kentucky | 21075 | 481 | 6 |
1074017 | 1074017 | 2021-02-28 | Fulton | Kentucky | 21075 | 480 | 6 |
1070771 | 1070771 | 2021-02-27 | Fulton | Kentucky | 21075 | 477 | 6 |
1067526 | 1067526 | 2021-02-26 | Fulton | Kentucky | 21075 | 476 | 6 |
1064281 | 1064281 | 2021-02-25 | Fulton | Kentucky | 21075 | 474 | 6 |
1061036 | 1061036 | 2021-02-24 | Fulton | Kentucky | 21075 | 472 | 6 |
1057790 | 1057790 | 2021-02-23 | Fulton | Kentucky | 21075 | 469 | 6 |
1054544 | 1054544 | 2021-02-22 | Fulton | Kentucky | 21075 | 469 | 6 |
1051297 | 1051297 | 2021-02-21 | Fulton | Kentucky | 21075 | 467 | 6 |
1048050 | 1048050 | 2021-02-20 | Fulton | Kentucky | 21075 | 465 | 6 |
1044805 | 1044805 | 2021-02-19 | Fulton | Kentucky | 21075 | 465 | 6 |
1041560 | 1041560 | 2021-02-18 | Fulton | Kentucky | 21075 | 465 | 6 |
1038315 | 1038315 | 2021-02-17 | Fulton | Kentucky | 21075 | 463 | 6 |
1035070 | 1035070 | 2021-02-16 | Fulton | Kentucky | 21075 | 463 | 6 |
1031824 | 1031824 | 2021-02-15 | Fulton | Kentucky | 21075 | 462 | 6 |
1028577 | 1028577 | 2021-02-14 | Fulton | Kentucky | 21075 | 462 | 6 |
1025332 | 1025332 | 2021-02-13 | Fulton | Kentucky | 21075 | 461 | 5 |
1022087 | 1022087 | 2021-02-12 | Fulton | Kentucky | 21075 | 461 | 5 |
1018842 | 1018842 | 2021-02-11 | Fulton | Kentucky | 21075 | 459 | 5 |
1015597 | 1015597 | 2021-02-10 | Fulton | Kentucky | 21075 | 457 | 5 |
1012352 | 1012352 | 2021-02-09 | Fulton | Kentucky | 21075 | 457 | 5 |
1009106 | 1009106 | 2021-02-08 | Fulton | Kentucky | 21075 | 456 | 5 |
1005860 | 1005860 | 2021-02-07 | Fulton | Kentucky | 21075 | 456 | 4 |
1002614 | 1002614 | 2021-02-06 | Fulton | Kentucky | 21075 | 455 | 4 |
999368 | 999368 | 2021-02-05 | Fulton | Kentucky | 21075 | 452 | 4 |
996122 | 996122 | 2021-02-04 | Fulton | Kentucky | 21075 | 450 | 4 |
992876 | 992876 | 2021-02-03 | Fulton | Kentucky | 21075 | 447 | 4 |
989630 | 989630 | 2021-02-02 | Fulton | Kentucky | 21075 | 444 | 4 |
986383 | 986383 | 2021-02-01 | Fulton | Kentucky | 21075 | 444 | 4 |
983136 | 983136 | 2021-01-31 | Fulton | Kentucky | 21075 | 438 | 4 |
979890 | 979890 | 2021-01-30 | Fulton | Kentucky | 21075 | 438 | 4 |
976644 | 976644 | 2021-01-29 | Fulton | Kentucky | 21075 | 438 | 4 |
973399 | 973399 | 2021-01-28 | Fulton | Kentucky | 21075 | 433 | 4 |
970154 | 970154 | 2021-01-27 | Fulton | Kentucky | 21075 | 432 | 4 |
966910 | 966910 | 2021-01-26 | Fulton | Kentucky | 21075 | 429 | 4 |
963665 | 963665 | 2021-01-25 | Fulton | Kentucky | 21075 | 428 | 4 |
960420 | 960420 | 2021-01-24 | Fulton | Kentucky | 21075 | 425 | 4 |
957174 | 957174 | 2021-01-23 | Fulton | Kentucky | 21075 | 423 | 4 |
953929 | 953929 | 2021-01-22 | Fulton | Kentucky | 21075 | 421 | 4 |
950684 | 950684 | 2021-01-21 | Fulton | Kentucky | 21075 | 419 | 4 |
947438 | 947438 | 2021-01-20 | Fulton | Kentucky | 21075 | 416 | 4 |
944191 | 944191 | 2021-01-19 | Fulton | Kentucky | 21075 | 411 | 4 |
940946 | 940946 | 2021-01-18 | Fulton | Kentucky | 21075 | 410 | 4 |
937701 | 937701 | 2021-01-17 | Fulton | Kentucky | 21075 | 408 | 4 |
934456 | 934456 | 2021-01-16 | Fulton | Kentucky | 21075 | 404 | 4 |
931211 | 931211 | 2021-01-15 | Fulton | Kentucky | 21075 | 394 | 4 |
927966 | 927966 | 2021-01-14 | Fulton | Kentucky | 21075 | 390 | 4 |
924720 | 924720 | 2021-01-13 | Fulton | Kentucky | 21075 | 387 | 4 |
921475 | 921475 | 2021-01-12 | Fulton | Kentucky | 21075 | 390 | 4 |
918230 | 918230 | 2021-01-11 | Fulton | Kentucky | 21075 | 389 | 4 |
914985 | 914985 | 2021-01-10 | Fulton | Kentucky | 21075 | 389 | 4 |
911740 | 911740 | 2021-01-09 | Fulton | Kentucky | 21075 | 388 | 4 |
908495 | 908495 | 2021-01-08 | Fulton | Kentucky | 21075 | 388 | 4 |
905249 | 905249 | 2021-01-07 | Fulton | Kentucky | 21075 | 386 | 4 |
902004 | 902004 | 2021-01-06 | Fulton | Kentucky | 21075 | 382 | 4 |
898759 | 898759 | 2021-01-05 | Fulton | Kentucky | 21075 | 376 | 4 |
895514 | 895514 | 2021-01-04 | Fulton | Kentucky | 21075 | 373 | 4 |
892267 | 892267 | 2021-01-03 | Fulton | Kentucky | 21075 | 373 | 4 |
889021 | 889021 | 2021-01-02 | Fulton | Kentucky | 21075 | 370 | 4 |
885775 | 885775 | 2021-01-01 | Fulton | Kentucky | 21075 | 363 | 4 |
882530 | 882530 | 2020-12-31 | Fulton | Kentucky | 21075 | 363 | 4 |
879285 | 879285 | 2020-12-30 | Fulton | Kentucky | 21075 | 363 | 4 |
876040 | 876040 | 2020-12-29 | Fulton | Kentucky | 21075 | 359 | 4 |
872795 | 872795 | 2020-12-28 | Fulton | Kentucky | 21075 | 355 | 4 |
869550 | 869550 | 2020-12-27 | Fulton | Kentucky | 21075 | 353 | 4 |
866305 | 866305 | 2020-12-26 | Fulton | Kentucky | 21075 | 353 | 4 |
863060 | 863060 | 2020-12-25 | Fulton | Kentucky | 21075 | 346 | 4 |
859815 | 859815 | 2020-12-24 | Fulton | Kentucky | 21075 | 346 | 4 |
856570 | 856570 | 2020-12-23 | Fulton | Kentucky | 21075 | 346 | 4 |
853325 | 853325 | 2020-12-22 | Fulton | Kentucky | 21075 | 346 | 4 |
850080 | 850080 | 2020-12-21 | Fulton | Kentucky | 21075 | 346 | 4 |
846835 | 846835 | 2020-12-20 | Fulton | Kentucky | 21075 | 341 | 4 |
843589 | 843589 | 2020-12-19 | Fulton | Kentucky | 21075 | 340 | 4 |
840344 | 840344 | 2020-12-18 | Fulton | Kentucky | 21075 | 338 | 4 |
837099 | 837099 | 2020-12-17 | Fulton | Kentucky | 21075 | 336 | 4 |
833853 | 833853 | 2020-12-16 | Fulton | Kentucky | 21075 | 332 | 4 |
830606 | 830606 | 2020-12-15 | Fulton | Kentucky | 21075 | 331 | 4 |
827360 | 827360 | 2020-12-14 | Fulton | Kentucky | 21075 | 331 | 4 |
824113 | 824113 | 2020-12-13 | Fulton | Kentucky | 21075 | 327 | 4 |
820867 | 820867 | 2020-12-12 | Fulton | Kentucky | 21075 | 326 | 4 |
817621 | 817621 | 2020-12-11 | Fulton | Kentucky | 21075 | 326 | 4 |
814375 | 814375 | 2020-12-10 | Fulton | Kentucky | 21075 | 323 | 4 |
811130 | 811130 | 2020-12-09 | Fulton | Kentucky | 21075 | 322 | 4 |
807885 | 807885 | 2020-12-08 | Fulton | Kentucky | 21075 | 321 | 4 |
804640 | 804640 | 2020-12-07 | Fulton | Kentucky | 21075 | 320 | 4 |
801395 | 801395 | 2020-12-06 | Fulton | Kentucky | 21075 | 314 | 4 |
798150 | 798150 | 2020-12-05 | Fulton | Kentucky | 21075 | 314 | 4 |
794905 | 794905 | 2020-12-04 | Fulton | Kentucky | 21075 | 312 | 4 |
791660 | 791660 | 2020-12-03 | Fulton | Kentucky | 21075 | 308 | 4 |
788415 | 788415 | 2020-12-02 | Fulton | Kentucky | 21075 | 303 | 4 |
785171 | 785171 | 2020-12-01 | Fulton | Kentucky | 21075 | 300 | 4 |
781926 | 781926 | 2020-11-30 | Fulton | Kentucky | 21075 | 298 | 4 |
778680 | 778680 | 2020-11-29 | Fulton | Kentucky | 21075 | 297 | 4 |
775435 | 775435 | 2020-11-28 | Fulton | Kentucky | 21075 | 294 | 3 |
772190 | 772190 | 2020-11-27 | Fulton | Kentucky | 21075 | 291 | 3 |
768945 | 768945 | 2020-11-26 | Fulton | Kentucky | 21075 | 285 | 3 |
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);