ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Clay" and fips = 21051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054532 | 1054532 | 2021-02-22 | Clay | Kentucky | 21051 | 2351 | 26 |
1051285 | 1051285 | 2021-02-21 | Clay | Kentucky | 21051 | 2348 | 26 |
1048038 | 1048038 | 2021-02-20 | Clay | Kentucky | 21051 | 2342 | 26 |
1044793 | 1044793 | 2021-02-19 | Clay | Kentucky | 21051 | 2337 | 26 |
1041548 | 1041548 | 2021-02-18 | Clay | Kentucky | 21051 | 2335 | 26 |
1038303 | 1038303 | 2021-02-17 | Clay | Kentucky | 21051 | 2329 | 26 |
1035058 | 1035058 | 2021-02-16 | Clay | Kentucky | 21051 | 2329 | 26 |
1031812 | 1031812 | 2021-02-15 | Clay | Kentucky | 21051 | 2329 | 26 |
1028565 | 1028565 | 2021-02-14 | Clay | Kentucky | 21051 | 2322 | 26 |
1025320 | 1025320 | 2021-02-13 | Clay | Kentucky | 21051 | 2313 | 26 |
1022075 | 1022075 | 2021-02-12 | Clay | Kentucky | 21051 | 2308 | 26 |
1018830 | 1018830 | 2021-02-11 | Clay | Kentucky | 21051 | 2306 | 26 |
1015585 | 1015585 | 2021-02-10 | Clay | Kentucky | 21051 | 2295 | 25 |
1012340 | 1012340 | 2021-02-09 | Clay | Kentucky | 21051 | 2289 | 25 |
1009094 | 1009094 | 2021-02-08 | Clay | Kentucky | 21051 | 2276 | 25 |
1005848 | 1005848 | 2021-02-07 | Clay | Kentucky | 21051 | 2272 | 25 |
1002602 | 1002602 | 2021-02-06 | Clay | Kentucky | 21051 | 2255 | 25 |
999356 | 999356 | 2021-02-05 | Clay | Kentucky | 21051 | 2251 | 25 |
996110 | 996110 | 2021-02-04 | Clay | Kentucky | 21051 | 2239 | 24 |
992864 | 992864 | 2021-02-03 | Clay | Kentucky | 21051 | 2235 | 24 |
989618 | 989618 | 2021-02-02 | Clay | Kentucky | 21051 | 2223 | 24 |
986371 | 986371 | 2021-02-01 | Clay | Kentucky | 21051 | 2205 | 23 |
983124 | 983124 | 2021-01-31 | Clay | Kentucky | 21051 | 2197 | 22 |
979878 | 979878 | 2021-01-30 | Clay | Kentucky | 21051 | 2191 | 22 |
976632 | 976632 | 2021-01-29 | Clay | Kentucky | 21051 | 2179 | 21 |
973387 | 973387 | 2021-01-28 | Clay | Kentucky | 21051 | 2171 | 20 |
970142 | 970142 | 2021-01-27 | Clay | Kentucky | 21051 | 2158 | 20 |
966898 | 966898 | 2021-01-26 | Clay | Kentucky | 21051 | 2146 | 20 |
963653 | 963653 | 2021-01-25 | Clay | Kentucky | 21051 | 2138 | 19 |
960408 | 960408 | 2021-01-24 | Clay | Kentucky | 21051 | 2134 | 17 |
957162 | 957162 | 2021-01-23 | Clay | Kentucky | 21051 | 2122 | 16 |
953917 | 953917 | 2021-01-22 | Clay | Kentucky | 21051 | 2114 | 16 |
950672 | 950672 | 2021-01-21 | Clay | Kentucky | 21051 | 2099 | 16 |
947426 | 947426 | 2021-01-20 | Clay | Kentucky | 21051 | 2076 | 16 |
944179 | 944179 | 2021-01-19 | Clay | Kentucky | 21051 | 2061 | 15 |
940934 | 940934 | 2021-01-18 | Clay | Kentucky | 21051 | 2054 | 14 |
937689 | 937689 | 2021-01-17 | Clay | Kentucky | 21051 | 2039 | 14 |
934444 | 934444 | 2021-01-16 | Clay | Kentucky | 21051 | 2035 | 14 |
931199 | 931199 | 2021-01-15 | Clay | Kentucky | 21051 | 2025 | 12 |
927954 | 927954 | 2021-01-14 | Clay | Kentucky | 21051 | 2009 | 12 |
924708 | 924708 | 2021-01-13 | Clay | Kentucky | 21051 | 1991 | 11 |
921463 | 921463 | 2021-01-12 | Clay | Kentucky | 21051 | 1986 | 10 |
918218 | 918218 | 2021-01-11 | Clay | Kentucky | 21051 | 1964 | 10 |
914973 | 914973 | 2021-01-10 | Clay | Kentucky | 21051 | 1954 | 10 |
911728 | 911728 | 2021-01-09 | Clay | Kentucky | 21051 | 1951 | 9 |
908483 | 908483 | 2021-01-08 | Clay | Kentucky | 21051 | 1808 | 9 |
905237 | 905237 | 2021-01-07 | Clay | Kentucky | 21051 | 1779 | 9 |
901992 | 901992 | 2021-01-06 | Clay | Kentucky | 21051 | 1755 | 9 |
898747 | 898747 | 2021-01-05 | Clay | Kentucky | 21051 | 1723 | 8 |
895502 | 895502 | 2021-01-04 | Clay | Kentucky | 21051 | 1707 | 8 |
892255 | 892255 | 2021-01-03 | Clay | Kentucky | 21051 | 1701 | 8 |
889009 | 889009 | 2021-01-02 | Clay | Kentucky | 21051 | 1692 | 8 |
885763 | 885763 | 2021-01-01 | Clay | Kentucky | 21051 | 1623 | 8 |
882518 | 882518 | 2020-12-31 | Clay | Kentucky | 21051 | 1623 | 8 |
879273 | 879273 | 2020-12-30 | Clay | Kentucky | 21051 | 1623 | 8 |
876028 | 876028 | 2020-12-29 | Clay | Kentucky | 21051 | 1564 | 8 |
872783 | 872783 | 2020-12-28 | Clay | Kentucky | 21051 | 1530 | 8 |
869538 | 869538 | 2020-12-27 | Clay | Kentucky | 21051 | 1528 | 8 |
866293 | 866293 | 2020-12-26 | Clay | Kentucky | 21051 | 1524 | 8 |
863048 | 863048 | 2020-12-25 | Clay | Kentucky | 21051 | 1466 | 8 |
859803 | 859803 | 2020-12-24 | Clay | Kentucky | 21051 | 1466 | 8 |
856558 | 856558 | 2020-12-23 | Clay | Kentucky | 21051 | 1466 | 8 |
853313 | 853313 | 2020-12-22 | Clay | Kentucky | 21051 | 1431 | 8 |
850068 | 850068 | 2020-12-21 | Clay | Kentucky | 21051 | 1378 | 8 |
846823 | 846823 | 2020-12-20 | Clay | Kentucky | 21051 | 1347 | 8 |
843577 | 843577 | 2020-12-19 | Clay | Kentucky | 21051 | 1341 | 8 |
840332 | 840332 | 2020-12-18 | Clay | Kentucky | 21051 | 1325 | 8 |
837087 | 837087 | 2020-12-17 | Clay | Kentucky | 21051 | 1294 | 8 |
833841 | 833841 | 2020-12-16 | Clay | Kentucky | 21051 | 1288 | 8 |
830594 | 830594 | 2020-12-15 | Clay | Kentucky | 21051 | 1262 | 8 |
827348 | 827348 | 2020-12-14 | Clay | Kentucky | 21051 | 1239 | 8 |
824101 | 824101 | 2020-12-13 | Clay | Kentucky | 21051 | 1231 | 8 |
820855 | 820855 | 2020-12-12 | Clay | Kentucky | 21051 | 1229 | 8 |
817609 | 817609 | 2020-12-11 | Clay | Kentucky | 21051 | 1219 | 8 |
814363 | 814363 | 2020-12-10 | Clay | Kentucky | 21051 | 1210 | 8 |
811118 | 811118 | 2020-12-09 | Clay | Kentucky | 21051 | 1194 | 8 |
807873 | 807873 | 2020-12-08 | Clay | Kentucky | 21051 | 1172 | 8 |
804628 | 804628 | 2020-12-07 | Clay | Kentucky | 21051 | 1159 | 8 |
801383 | 801383 | 2020-12-06 | Clay | Kentucky | 21051 | 1155 | 8 |
798138 | 798138 | 2020-12-05 | Clay | Kentucky | 21051 | 1152 | 8 |
794893 | 794893 | 2020-12-04 | Clay | Kentucky | 21051 | 1143 | 8 |
791648 | 791648 | 2020-12-03 | Clay | Kentucky | 21051 | 1122 | 8 |
788403 | 788403 | 2020-12-02 | Clay | Kentucky | 21051 | 1095 | 8 |
785159 | 785159 | 2020-12-01 | Clay | Kentucky | 21051 | 1039 | 8 |
781914 | 781914 | 2020-11-30 | Clay | Kentucky | 21051 | 989 | 8 |
778668 | 778668 | 2020-11-29 | Clay | Kentucky | 21051 | 989 | 8 |
775423 | 775423 | 2020-11-28 | Clay | Kentucky | 21051 | 975 | 8 |
772178 | 772178 | 2020-11-27 | Clay | Kentucky | 21051 | 972 | 8 |
768933 | 768933 | 2020-11-26 | Clay | Kentucky | 21051 | 961 | 8 |
765687 | 765687 | 2020-11-25 | Clay | Kentucky | 21051 | 961 | 8 |
762442 | 762442 | 2020-11-24 | Clay | Kentucky | 21051 | 949 | 8 |
759197 | 759197 | 2020-11-23 | Clay | Kentucky | 21051 | 936 | 8 |
755950 | 755950 | 2020-11-22 | Clay | Kentucky | 21051 | 935 | 8 |
752704 | 752704 | 2020-11-21 | Clay | Kentucky | 21051 | 920 | 8 |
749458 | 749458 | 2020-11-20 | Clay | Kentucky | 21051 | 906 | 8 |
746212 | 746212 | 2020-11-19 | Clay | Kentucky | 21051 | 862 | 8 |
742965 | 742965 | 2020-11-18 | Clay | Kentucky | 21051 | 825 | 8 |
739718 | 739718 | 2020-11-17 | Clay | Kentucky | 21051 | 811 | 7 |
736474 | 736474 | 2020-11-16 | Clay | Kentucky | 21051 | 801 | 7 |
733228 | 733228 | 2020-11-15 | Clay | Kentucky | 21051 | 796 | 7 |
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);