ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 21049 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278568 | 1278568 | 2021-05-02 | Clark | Kentucky | 21049 | 2836 | 29 |
1275321 | 1275321 | 2021-05-01 | Clark | Kentucky | 21049 | 2836 | 29 |
1272074 | 1272074 | 2021-04-30 | Clark | Kentucky | 21049 | 2835 | 29 |
1268827 | 1268827 | 2021-04-29 | Clark | Kentucky | 21049 | 2824 | 29 |
1265580 | 1265580 | 2021-04-28 | Clark | Kentucky | 21049 | 2814 | 28 |
1262333 | 1262333 | 2021-04-27 | Clark | Kentucky | 21049 | 2806 | 28 |
1259086 | 1259086 | 2021-04-26 | Clark | Kentucky | 21049 | 2796 | 28 |
1255839 | 1255839 | 2021-04-25 | Clark | Kentucky | 21049 | 2795 | 28 |
1252592 | 1252592 | 2021-04-24 | Clark | Kentucky | 21049 | 2794 | 28 |
1249345 | 1249345 | 2021-04-23 | Clark | Kentucky | 21049 | 2786 | 28 |
1246098 | 1246098 | 2021-04-22 | Clark | Kentucky | 21049 | 2782 | 28 |
1242851 | 1242851 | 2021-04-21 | Clark | Kentucky | 21049 | 2772 | 28 |
1239604 | 1239604 | 2021-04-20 | Clark | Kentucky | 21049 | 2746 | 28 |
1236357 | 1236357 | 2021-04-19 | Clark | Kentucky | 21049 | 2738 | 28 |
1233110 | 1233110 | 2021-04-18 | Clark | Kentucky | 21049 | 2738 | 28 |
1229862 | 1229862 | 2021-04-17 | Clark | Kentucky | 21049 | 2737 | 28 |
1226614 | 1226614 | 2021-04-16 | Clark | Kentucky | 21049 | 2733 | 28 |
1223367 | 1223367 | 2021-04-15 | Clark | Kentucky | 21049 | 2726 | 28 |
1220119 | 1220119 | 2021-04-14 | Clark | Kentucky | 21049 | 2714 | 28 |
1216871 | 1216871 | 2021-04-13 | Clark | Kentucky | 21049 | 2706 | 28 |
1213624 | 1213624 | 2021-04-12 | Clark | Kentucky | 21049 | 2700 | 28 |
1210376 | 1210376 | 2021-04-11 | Clark | Kentucky | 21049 | 2696 | 28 |
1207127 | 1207127 | 2021-04-10 | Clark | Kentucky | 21049 | 2686 | 28 |
1203879 | 1203879 | 2021-04-09 | Clark | Kentucky | 21049 | 2686 | 28 |
1200631 | 1200631 | 2021-04-08 | Clark | Kentucky | 21049 | 2685 | 28 |
1197382 | 1197382 | 2021-04-07 | Clark | Kentucky | 21049 | 2661 | 28 |
1194134 | 1194134 | 2021-04-06 | Clark | Kentucky | 21049 | 2654 | 28 |
1190884 | 1190884 | 2021-04-05 | Clark | Kentucky | 21049 | 2650 | 28 |
1187637 | 1187637 | 2021-04-04 | Clark | Kentucky | 21049 | 2639 | 28 |
1184390 | 1184390 | 2021-04-03 | Clark | Kentucky | 21049 | 2639 | 28 |
1181143 | 1181143 | 2021-04-02 | Clark | Kentucky | 21049 | 2637 | 28 |
1177896 | 1177896 | 2021-04-01 | Clark | Kentucky | 21049 | 2634 | 28 |
1174649 | 1174649 | 2021-03-31 | Clark | Kentucky | 21049 | 2622 | 28 |
1171402 | 1171402 | 2021-03-30 | Clark | Kentucky | 21049 | 2621 | 28 |
1168154 | 1168154 | 2021-03-29 | Clark | Kentucky | 21049 | 2619 | 28 |
1164906 | 1164906 | 2021-03-28 | Clark | Kentucky | 21049 | 2617 | 28 |
1161658 | 1161658 | 2021-03-27 | Clark | Kentucky | 21049 | 2616 | 28 |
1158410 | 1158410 | 2021-03-26 | Clark | Kentucky | 21049 | 2614 | 28 |
1155163 | 1155163 | 2021-03-25 | Clark | Kentucky | 21049 | 2601 | 27 |
1151916 | 1151916 | 2021-03-24 | Clark | Kentucky | 21049 | 2597 | 26 |
1148669 | 1148669 | 2021-03-23 | Clark | Kentucky | 21049 | 2594 | 26 |
1145422 | 1145422 | 2021-03-22 | Clark | Kentucky | 21049 | 2582 | 26 |
1142175 | 1142175 | 2021-03-21 | Clark | Kentucky | 21049 | 2582 | 26 |
1138929 | 1138929 | 2021-03-20 | Clark | Kentucky | 21049 | 2579 | 26 |
1135683 | 1135683 | 2021-03-19 | Clark | Kentucky | 21049 | 2560 | 26 |
1132436 | 1132436 | 2021-03-18 | Clark | Kentucky | 21049 | 2556 | 26 |
1129188 | 1129188 | 2021-03-17 | Clark | Kentucky | 21049 | 2540 | 25 |
1125942 | 1125942 | 2021-03-16 | Clark | Kentucky | 21049 | 2518 | 25 |
1122696 | 1122696 | 2021-03-15 | Clark | Kentucky | 21049 | 2496 | 25 |
1119449 | 1119449 | 2021-03-14 | Clark | Kentucky | 21049 | 2495 | 25 |
1116202 | 1116202 | 2021-03-13 | Clark | Kentucky | 21049 | 2489 | 25 |
1112956 | 1112956 | 2021-03-12 | Clark | Kentucky | 21049 | 2468 | 25 |
1109710 | 1109710 | 2021-03-11 | Clark | Kentucky | 21049 | 2463 | 25 |
1106464 | 1106464 | 2021-03-10 | Clark | Kentucky | 21049 | 2460 | 25 |
1103218 | 1103218 | 2021-03-09 | Clark | Kentucky | 21049 | 2458 | 25 |
1099972 | 1099972 | 2021-03-08 | Clark | Kentucky | 21049 | 2449 | 25 |
1096724 | 1096724 | 2021-03-07 | Clark | Kentucky | 21049 | 2445 | 25 |
1093478 | 1093478 | 2021-03-06 | Clark | Kentucky | 21049 | 2444 | 25 |
1090232 | 1090232 | 2021-03-05 | Clark | Kentucky | 21049 | 2441 | 24 |
1086987 | 1086987 | 2021-03-04 | Clark | Kentucky | 21049 | 2434 | 23 |
1083741 | 1083741 | 2021-03-03 | Clark | Kentucky | 21049 | 2429 | 23 |
1080495 | 1080495 | 2021-03-02 | Clark | Kentucky | 21049 | 2417 | 20 |
1077250 | 1077250 | 2021-03-01 | Clark | Kentucky | 21049 | 2409 | 20 |
1074004 | 1074004 | 2021-02-28 | Clark | Kentucky | 21049 | 2409 | 20 |
1070758 | 1070758 | 2021-02-27 | Clark | Kentucky | 21049 | 2409 | 20 |
1067513 | 1067513 | 2021-02-26 | Clark | Kentucky | 21049 | 2409 | 20 |
1064268 | 1064268 | 2021-02-25 | Clark | Kentucky | 21049 | 2407 | 18 |
1061023 | 1061023 | 2021-02-24 | Clark | Kentucky | 21049 | 2394 | 18 |
1057777 | 1057777 | 2021-02-23 | Clark | Kentucky | 21049 | 2384 | 18 |
1054531 | 1054531 | 2021-02-22 | Clark | Kentucky | 21049 | 2372 | 18 |
1051284 | 1051284 | 2021-02-21 | Clark | Kentucky | 21049 | 2371 | 18 |
1048037 | 1048037 | 2021-02-20 | Clark | Kentucky | 21049 | 2370 | 18 |
1044792 | 1044792 | 2021-02-19 | Clark | Kentucky | 21049 | 2369 | 18 |
1041547 | 1041547 | 2021-02-18 | Clark | Kentucky | 21049 | 2346 | 18 |
1038302 | 1038302 | 2021-02-17 | Clark | Kentucky | 21049 | 2341 | 18 |
1035057 | 1035057 | 2021-02-16 | Clark | Kentucky | 21049 | 2336 | 18 |
1031811 | 1031811 | 2021-02-15 | Clark | Kentucky | 21049 | 2311 | 18 |
1028564 | 1028564 | 2021-02-14 | Clark | Kentucky | 21049 | 2309 | 18 |
1025319 | 1025319 | 2021-02-13 | Clark | Kentucky | 21049 | 2312 | 18 |
1022074 | 1022074 | 2021-02-12 | Clark | Kentucky | 21049 | 2311 | 17 |
1018829 | 1018829 | 2021-02-11 | Clark | Kentucky | 21049 | 2303 | 16 |
1015584 | 1015584 | 2021-02-10 | Clark | Kentucky | 21049 | 2301 | 16 |
1012339 | 1012339 | 2021-02-09 | Clark | Kentucky | 21049 | 2284 | 16 |
1009093 | 1009093 | 2021-02-08 | Clark | Kentucky | 21049 | 2277 | 16 |
1005847 | 1005847 | 2021-02-07 | Clark | Kentucky | 21049 | 2274 | 16 |
1002601 | 1002601 | 2021-02-06 | Clark | Kentucky | 21049 | 2270 | 16 |
999355 | 999355 | 2021-02-05 | Clark | Kentucky | 21049 | 2256 | 16 |
996109 | 996109 | 2021-02-04 | Clark | Kentucky | 21049 | 2239 | 16 |
992863 | 992863 | 2021-02-03 | Clark | Kentucky | 21049 | 2200 | 16 |
989617 | 989617 | 2021-02-02 | Clark | Kentucky | 21049 | 2179 | 16 |
986370 | 986370 | 2021-02-01 | Clark | Kentucky | 21049 | 2160 | 16 |
983123 | 983123 | 2021-01-31 | Clark | Kentucky | 21049 | 2152 | 16 |
979877 | 979877 | 2021-01-30 | Clark | Kentucky | 21049 | 2149 | 16 |
976631 | 976631 | 2021-01-29 | Clark | Kentucky | 21049 | 2134 | 16 |
973386 | 973386 | 2021-01-28 | Clark | Kentucky | 21049 | 2119 | 16 |
970141 | 970141 | 2021-01-27 | Clark | Kentucky | 21049 | 2121 | 16 |
966897 | 966897 | 2021-01-26 | Clark | Kentucky | 21049 | 2098 | 16 |
963652 | 963652 | 2021-01-25 | Clark | Kentucky | 21049 | 2093 | 16 |
960407 | 960407 | 2021-01-24 | Clark | Kentucky | 21049 | 2086 | 16 |
957161 | 957161 | 2021-01-23 | Clark | Kentucky | 21049 | 2076 | 16 |
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);