ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marshall" and fips = 21157 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1057828 | 1057828 | 2021-02-23 | Marshall | Kentucky | 21157 | 2491 | 46 |
1054582 | 1054582 | 2021-02-22 | Marshall | Kentucky | 21157 | 2482 | 46 |
1051335 | 1051335 | 2021-02-21 | Marshall | Kentucky | 21157 | 2479 | 46 |
1048088 | 1048088 | 2021-02-20 | Marshall | Kentucky | 21157 | 2476 | 46 |
1044843 | 1044843 | 2021-02-19 | Marshall | Kentucky | 21157 | 2468 | 46 |
1041598 | 1041598 | 2021-02-18 | Marshall | Kentucky | 21157 | 2466 | 46 |
1038353 | 1038353 | 2021-02-17 | Marshall | Kentucky | 21157 | 2457 | 43 |
1035108 | 1035108 | 2021-02-16 | Marshall | Kentucky | 21157 | 2457 | 43 |
1031862 | 1031862 | 2021-02-15 | Marshall | Kentucky | 21157 | 2448 | 43 |
1028615 | 1028615 | 2021-02-14 | Marshall | Kentucky | 21157 | 2440 | 43 |
1025370 | 1025370 | 2021-02-13 | Marshall | Kentucky | 21157 | 2436 | 43 |
1022125 | 1022125 | 2021-02-12 | Marshall | Kentucky | 21157 | 2434 | 43 |
1018880 | 1018880 | 2021-02-11 | Marshall | Kentucky | 21157 | 2430 | 43 |
1015635 | 1015635 | 2021-02-10 | Marshall | Kentucky | 21157 | 2403 | 41 |
1012390 | 1012390 | 2021-02-09 | Marshall | Kentucky | 21157 | 2386 | 41 |
1009144 | 1009144 | 2021-02-08 | Marshall | Kentucky | 21157 | 2365 | 41 |
1005898 | 1005898 | 2021-02-07 | Marshall | Kentucky | 21157 | 2352 | 40 |
1002652 | 1002652 | 2021-02-06 | Marshall | Kentucky | 21157 | 2350 | 40 |
999406 | 999406 | 2021-02-05 | Marshall | Kentucky | 21157 | 2338 | 38 |
996160 | 996160 | 2021-02-04 | Marshall | Kentucky | 21157 | 2323 | 37 |
992914 | 992914 | 2021-02-03 | Marshall | Kentucky | 21157 | 2293 | 37 |
989668 | 989668 | 2021-02-02 | Marshall | Kentucky | 21157 | 2257 | 35 |
986421 | 986421 | 2021-02-01 | Marshall | Kentucky | 21157 | 2251 | 35 |
983174 | 983174 | 2021-01-31 | Marshall | Kentucky | 21157 | 2244 | 35 |
979928 | 979928 | 2021-01-30 | Marshall | Kentucky | 21157 | 2229 | 35 |
976682 | 976682 | 2021-01-29 | Marshall | Kentucky | 21157 | 2211 | 34 |
973437 | 973437 | 2021-01-28 | Marshall | Kentucky | 21157 | 2194 | 33 |
970192 | 970192 | 2021-01-27 | Marshall | Kentucky | 21157 | 2168 | 32 |
966948 | 966948 | 2021-01-26 | Marshall | Kentucky | 21157 | 2155 | 32 |
963703 | 963703 | 2021-01-25 | Marshall | Kentucky | 21157 | 2129 | 32 |
960458 | 960458 | 2021-01-24 | Marshall | Kentucky | 21157 | 2121 | 32 |
957212 | 957212 | 2021-01-23 | Marshall | Kentucky | 21157 | 2104 | 32 |
953967 | 953967 | 2021-01-22 | Marshall | Kentucky | 21157 | 2069 | 32 |
950722 | 950722 | 2021-01-21 | Marshall | Kentucky | 21157 | 2039 | 32 |
947476 | 947476 | 2021-01-20 | Marshall | Kentucky | 21157 | 2006 | 30 |
944229 | 944229 | 2021-01-19 | Marshall | Kentucky | 21157 | 2000 | 27 |
940984 | 940984 | 2021-01-18 | Marshall | Kentucky | 21157 | 1987 | 27 |
937739 | 937739 | 2021-01-17 | Marshall | Kentucky | 21157 | 1958 | 25 |
934494 | 934494 | 2021-01-16 | Marshall | Kentucky | 21157 | 1947 | 25 |
931249 | 931249 | 2021-01-15 | Marshall | Kentucky | 21157 | 1926 | 25 |
928004 | 928004 | 2021-01-14 | Marshall | Kentucky | 21157 | 1904 | 25 |
924758 | 924758 | 2021-01-13 | Marshall | Kentucky | 21157 | 1869 | 25 |
921513 | 921513 | 2021-01-12 | Marshall | Kentucky | 21157 | 1857 | 25 |
918268 | 918268 | 2021-01-11 | Marshall | Kentucky | 21157 | 1845 | 25 |
915023 | 915023 | 2021-01-10 | Marshall | Kentucky | 21157 | 1829 | 25 |
911778 | 911778 | 2021-01-09 | Marshall | Kentucky | 21157 | 1822 | 25 |
908533 | 908533 | 2021-01-08 | Marshall | Kentucky | 21157 | 1809 | 25 |
905287 | 905287 | 2021-01-07 | Marshall | Kentucky | 21157 | 1765 | 22 |
902042 | 902042 | 2021-01-06 | Marshall | Kentucky | 21157 | 1715 | 22 |
898797 | 898797 | 2021-01-05 | Marshall | Kentucky | 21157 | 1664 | 22 |
895552 | 895552 | 2021-01-04 | Marshall | Kentucky | 21157 | 1652 | 22 |
892305 | 892305 | 2021-01-03 | Marshall | Kentucky | 21157 | 1623 | 21 |
889059 | 889059 | 2021-01-02 | Marshall | Kentucky | 21157 | 1619 | 20 |
885813 | 885813 | 2021-01-01 | Marshall | Kentucky | 21157 | 1558 | 20 |
882568 | 882568 | 2020-12-31 | Marshall | Kentucky | 21157 | 1558 | 20 |
879323 | 879323 | 2020-12-30 | Marshall | Kentucky | 21157 | 1558 | 20 |
876078 | 876078 | 2020-12-29 | Marshall | Kentucky | 21157 | 1525 | 20 |
872833 | 872833 | 2020-12-28 | Marshall | Kentucky | 21157 | 1510 | 19 |
869588 | 869588 | 2020-12-27 | Marshall | Kentucky | 21157 | 1470 | 19 |
866343 | 866343 | 2020-12-26 | Marshall | Kentucky | 21157 | 1467 | 19 |
863098 | 863098 | 2020-12-25 | Marshall | Kentucky | 21157 | 1396 | 19 |
859853 | 859853 | 2020-12-24 | Marshall | Kentucky | 21157 | 1396 | 19 |
856608 | 856608 | 2020-12-23 | Marshall | Kentucky | 21157 | 1396 | 19 |
853363 | 853363 | 2020-12-22 | Marshall | Kentucky | 21157 | 1364 | 19 |
850118 | 850118 | 2020-12-21 | Marshall | Kentucky | 21157 | 1352 | 19 |
846873 | 846873 | 2020-12-20 | Marshall | Kentucky | 21157 | 1335 | 19 |
843627 | 843627 | 2020-12-19 | Marshall | Kentucky | 21157 | 1331 | 19 |
840382 | 840382 | 2020-12-18 | Marshall | Kentucky | 21157 | 1303 | 19 |
837137 | 837137 | 2020-12-17 | Marshall | Kentucky | 21157 | 1275 | 18 |
833891 | 833891 | 2020-12-16 | Marshall | Kentucky | 21157 | 1242 | 18 |
830644 | 830644 | 2020-12-15 | Marshall | Kentucky | 21157 | 1222 | 18 |
827398 | 827398 | 2020-12-14 | Marshall | Kentucky | 21157 | 1223 | 18 |
824151 | 824151 | 2020-12-13 | Marshall | Kentucky | 21157 | 1216 | 18 |
820905 | 820905 | 2020-12-12 | Marshall | Kentucky | 21157 | 1208 | 18 |
817659 | 817659 | 2020-12-11 | Marshall | Kentucky | 21157 | 1187 | 18 |
814413 | 814413 | 2020-12-10 | Marshall | Kentucky | 21157 | 1169 | 18 |
811168 | 811168 | 2020-12-09 | Marshall | Kentucky | 21157 | 1134 | 18 |
807923 | 807923 | 2020-12-08 | Marshall | Kentucky | 21157 | 1121 | 17 |
804678 | 804678 | 2020-12-07 | Marshall | Kentucky | 21157 | 1112 | 16 |
801433 | 801433 | 2020-12-06 | Marshall | Kentucky | 21157 | 1102 | 15 |
798188 | 798188 | 2020-12-05 | Marshall | Kentucky | 21157 | 1090 | 15 |
794943 | 794943 | 2020-12-04 | Marshall | Kentucky | 21157 | 1076 | 15 |
791698 | 791698 | 2020-12-03 | Marshall | Kentucky | 21157 | 1049 | 14 |
788453 | 788453 | 2020-12-02 | Marshall | Kentucky | 21157 | 1034 | 14 |
785209 | 785209 | 2020-12-01 | Marshall | Kentucky | 21157 | 1020 | 14 |
781964 | 781964 | 2020-11-30 | Marshall | Kentucky | 21157 | 981 | 13 |
778718 | 778718 | 2020-11-29 | Marshall | Kentucky | 21157 | 949 | 12 |
775473 | 775473 | 2020-11-28 | Marshall | Kentucky | 21157 | 925 | 12 |
772228 | 772228 | 2020-11-27 | Marshall | Kentucky | 21157 | 912 | 11 |
768983 | 768983 | 2020-11-26 | Marshall | Kentucky | 21157 | 886 | 11 |
765737 | 765737 | 2020-11-25 | Marshall | Kentucky | 21157 | 886 | 11 |
762492 | 762492 | 2020-11-24 | Marshall | Kentucky | 21157 | 868 | 11 |
759247 | 759247 | 2020-11-23 | Marshall | Kentucky | 21157 | 853 | 11 |
756000 | 756000 | 2020-11-22 | Marshall | Kentucky | 21157 | 846 | 11 |
752754 | 752754 | 2020-11-21 | Marshall | Kentucky | 21157 | 840 | 11 |
749508 | 749508 | 2020-11-20 | Marshall | Kentucky | 21157 | 811 | 11 |
746262 | 746262 | 2020-11-19 | Marshall | Kentucky | 21157 | 796 | 10 |
743015 | 743015 | 2020-11-18 | Marshall | Kentucky | 21157 | 777 | 10 |
739768 | 739768 | 2020-11-17 | Marshall | Kentucky | 21157 | 755 | 9 |
736524 | 736524 | 2020-11-16 | Marshall | Kentucky | 21157 | 739 | 9 |
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);