ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where county = "Clay" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194135 | 1194135 | 2021-04-06 | Clay | Kentucky | 21051 | 2592 | 38 |
1190885 | 1190885 | 2021-04-05 | Clay | Kentucky | 21051 | 2589 | 38 |
1187638 | 1187638 | 2021-04-04 | Clay | Kentucky | 21051 | 2591 | 37 |
1184391 | 1184391 | 2021-04-03 | Clay | Kentucky | 21051 | 2591 | 37 |
1181144 | 1181144 | 2021-04-02 | Clay | Kentucky | 21051 | 2587 | 37 |
1177897 | 1177897 | 2021-04-01 | Clay | Kentucky | 21051 | 2581 | 37 |
1174650 | 1174650 | 2021-03-31 | Clay | Kentucky | 21051 | 2581 | 36 |
1171403 | 1171403 | 2021-03-30 | Clay | Kentucky | 21051 | 2577 | 36 |
1168155 | 1168155 | 2021-03-29 | Clay | Kentucky | 21051 | 2574 | 36 |
1164907 | 1164907 | 2021-03-28 | Clay | Kentucky | 21051 | 2572 | 36 |
1161659 | 1161659 | 2021-03-27 | Clay | Kentucky | 21051 | 2568 | 36 |
1158411 | 1158411 | 2021-03-26 | Clay | Kentucky | 21051 | 2570 | 36 |
1155164 | 1155164 | 2021-03-25 | Clay | Kentucky | 21051 | 2563 | 36 |
1151917 | 1151917 | 2021-03-24 | Clay | Kentucky | 21051 | 2558 | 35 |
1148670 | 1148670 | 2021-03-23 | Clay | Kentucky | 21051 | 2557 | 33 |
1145423 | 1145423 | 2021-03-22 | Clay | Kentucky | 21051 | 2551 | 33 |
1142176 | 1142176 | 2021-03-21 | Clay | Kentucky | 21051 | 2547 | 33 |
1138930 | 1138930 | 2021-03-20 | Clay | Kentucky | 21051 | 2547 | 33 |
1135684 | 1135684 | 2021-03-19 | Clay | Kentucky | 21051 | 2539 | 33 |
1132437 | 1132437 | 2021-03-18 | Clay | Kentucky | 21051 | 2537 | 32 |
1129189 | 1129189 | 2021-03-17 | Clay | Kentucky | 21051 | 2528 | 30 |
1125943 | 1125943 | 2021-03-16 | Clay | Kentucky | 21051 | 2523 | 30 |
1122697 | 1122697 | 2021-03-15 | Clay | Kentucky | 21051 | 2514 | 30 |
1119450 | 1119450 | 2021-03-14 | Clay | Kentucky | 21051 | 2505 | 30 |
1116203 | 1116203 | 2021-03-13 | Clay | Kentucky | 21051 | 2501 | 30 |
1112957 | 1112957 | 2021-03-12 | Clay | Kentucky | 21051 | 2492 | 30 |
1109711 | 1109711 | 2021-03-11 | Clay | Kentucky | 21051 | 2486 | 30 |
1106465 | 1106465 | 2021-03-10 | Clay | Kentucky | 21051 | 2480 | 28 |
1103219 | 1103219 | 2021-03-09 | Clay | Kentucky | 21051 | 2471 | 28 |
1099973 | 1099973 | 2021-03-08 | Clay | Kentucky | 21051 | 2464 | 28 |
1096725 | 1096725 | 2021-03-07 | Clay | Kentucky | 21051 | 2463 | 28 |
1093479 | 1093479 | 2021-03-06 | Clay | Kentucky | 21051 | 2456 | 28 |
1090233 | 1090233 | 2021-03-05 | Clay | Kentucky | 21051 | 2455 | 26 |
1086988 | 1086988 | 2021-03-04 | Clay | Kentucky | 21051 | 2448 | 26 |
1083742 | 1083742 | 2021-03-03 | Clay | Kentucky | 21051 | 2439 | 26 |
1080496 | 1080496 | 2021-03-02 | Clay | Kentucky | 21051 | 2431 | 26 |
1077251 | 1077251 | 2021-03-01 | Clay | Kentucky | 21051 | 2415 | 26 |
1074005 | 1074005 | 2021-02-28 | Clay | Kentucky | 21051 | 2414 | 26 |
1070759 | 1070759 | 2021-02-27 | Clay | Kentucky | 21051 | 2406 | 26 |
1067514 | 1067514 | 2021-02-26 | Clay | Kentucky | 21051 | 2382 | 26 |
1064269 | 1064269 | 2021-02-25 | Clay | Kentucky | 21051 | 2378 | 26 |
1061024 | 1061024 | 2021-02-24 | Clay | Kentucky | 21051 | 2372 | 26 |
1057778 | 1057778 | 2021-02-23 | Clay | Kentucky | 21051 | 2365 | 26 |
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 |
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);