ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Rockcastle" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093555 | 1093555 | 2021-03-06 | Rockcastle | Kentucky | 21203 | 1366 | 15 |
1090309 | 1090309 | 2021-03-05 | Rockcastle | Kentucky | 21203 | 1362 | 15 |
1087064 | 1087064 | 2021-03-04 | Rockcastle | Kentucky | 21203 | 1359 | 15 |
1083818 | 1083818 | 2021-03-03 | Rockcastle | Kentucky | 21203 | 1358 | 15 |
1080572 | 1080572 | 2021-03-02 | Rockcastle | Kentucky | 21203 | 1355 | 15 |
1077327 | 1077327 | 2021-03-01 | Rockcastle | Kentucky | 21203 | 1350 | 14 |
1074081 | 1074081 | 2021-02-28 | Rockcastle | Kentucky | 21203 | 1347 | 14 |
1070835 | 1070835 | 2021-02-27 | Rockcastle | Kentucky | 21203 | 1343 | 14 |
1067590 | 1067590 | 2021-02-26 | Rockcastle | Kentucky | 21203 | 1340 | 14 |
1064345 | 1064345 | 2021-02-25 | Rockcastle | Kentucky | 21203 | 1336 | 13 |
1061100 | 1061100 | 2021-02-24 | Rockcastle | Kentucky | 21203 | 1330 | 13 |
1057854 | 1057854 | 2021-02-23 | Rockcastle | Kentucky | 21203 | 1329 | 13 |
1054608 | 1054608 | 2021-02-22 | Rockcastle | Kentucky | 21203 | 1319 | 13 |
1051361 | 1051361 | 2021-02-21 | Rockcastle | Kentucky | 21203 | 1315 | 13 |
1048114 | 1048114 | 2021-02-20 | Rockcastle | Kentucky | 21203 | 1309 | 13 |
1044869 | 1044869 | 2021-02-19 | Rockcastle | Kentucky | 21203 | 1306 | 13 |
1041624 | 1041624 | 2021-02-18 | Rockcastle | Kentucky | 21203 | 1302 | 13 |
1038379 | 1038379 | 2021-02-17 | Rockcastle | Kentucky | 21203 | 1298 | 13 |
1035134 | 1035134 | 2021-02-16 | Rockcastle | Kentucky | 21203 | 1295 | 13 |
1031888 | 1031888 | 2021-02-15 | Rockcastle | Kentucky | 21203 | 1292 | 13 |
1028641 | 1028641 | 2021-02-14 | Rockcastle | Kentucky | 21203 | 1292 | 13 |
1025396 | 1025396 | 2021-02-13 | Rockcastle | Kentucky | 21203 | 1284 | 13 |
1022151 | 1022151 | 2021-02-12 | Rockcastle | Kentucky | 21203 | 1281 | 13 |
1018906 | 1018906 | 2021-02-11 | Rockcastle | Kentucky | 21203 | 1278 | 13 |
1015661 | 1015661 | 2021-02-10 | Rockcastle | Kentucky | 21203 | 1273 | 13 |
1012416 | 1012416 | 2021-02-09 | Rockcastle | Kentucky | 21203 | 1267 | 13 |
1009170 | 1009170 | 2021-02-08 | Rockcastle | Kentucky | 21203 | 1261 | 13 |
1005924 | 1005924 | 2021-02-07 | Rockcastle | Kentucky | 21203 | 1259 | 13 |
1002678 | 1002678 | 2021-02-06 | Rockcastle | Kentucky | 21203 | 1255 | 13 |
999432 | 999432 | 2021-02-05 | Rockcastle | Kentucky | 21203 | 1251 | 13 |
996186 | 996186 | 2021-02-04 | Rockcastle | Kentucky | 21203 | 1244 | 13 |
992940 | 992940 | 2021-02-03 | Rockcastle | Kentucky | 21203 | 1227 | 12 |
989694 | 989694 | 2021-02-02 | Rockcastle | Kentucky | 21203 | 1215 | 12 |
986447 | 986447 | 2021-02-01 | Rockcastle | Kentucky | 21203 | 1209 | 12 |
983200 | 983200 | 2021-01-31 | Rockcastle | Kentucky | 21203 | 1209 | 12 |
979954 | 979954 | 2021-01-30 | Rockcastle | Kentucky | 21203 | 1208 | 12 |
976708 | 976708 | 2021-01-29 | Rockcastle | Kentucky | 21203 | 1205 | 12 |
973463 | 973463 | 2021-01-28 | Rockcastle | Kentucky | 21203 | 1193 | 12 |
970218 | 970218 | 2021-01-27 | Rockcastle | Kentucky | 21203 | 1178 | 12 |
966974 | 966974 | 2021-01-26 | Rockcastle | Kentucky | 21203 | 1171 | 12 |
963729 | 963729 | 2021-01-25 | Rockcastle | Kentucky | 21203 | 1160 | 12 |
960484 | 960484 | 2021-01-24 | Rockcastle | Kentucky | 21203 | 1157 | 12 |
957238 | 957238 | 2021-01-23 | Rockcastle | Kentucky | 21203 | 1149 | 12 |
953993 | 953993 | 2021-01-22 | Rockcastle | Kentucky | 21203 | 1140 | 12 |
950748 | 950748 | 2021-01-21 | Rockcastle | Kentucky | 21203 | 1128 | 12 |
947502 | 947502 | 2021-01-20 | Rockcastle | Kentucky | 21203 | 1123 | 12 |
944255 | 944255 | 2021-01-19 | Rockcastle | Kentucky | 21203 | 1109 | 12 |
941010 | 941010 | 2021-01-18 | Rockcastle | Kentucky | 21203 | 1099 | 12 |
937765 | 937765 | 2021-01-17 | Rockcastle | Kentucky | 21203 | 1094 | 12 |
934520 | 934520 | 2021-01-16 | Rockcastle | Kentucky | 21203 | 1083 | 12 |
931275 | 931275 | 2021-01-15 | Rockcastle | Kentucky | 21203 | 1077 | 12 |
928030 | 928030 | 2021-01-14 | Rockcastle | Kentucky | 21203 | 1063 | 12 |
924784 | 924784 | 2021-01-13 | Rockcastle | Kentucky | 21203 | 1039 | 11 |
921539 | 921539 | 2021-01-12 | Rockcastle | Kentucky | 21203 | 1025 | 9 |
918294 | 918294 | 2021-01-11 | Rockcastle | Kentucky | 21203 | 1009 | 9 |
915049 | 915049 | 2021-01-10 | Rockcastle | Kentucky | 21203 | 1004 | 9 |
911804 | 911804 | 2021-01-09 | Rockcastle | Kentucky | 21203 | 999 | 9 |
908559 | 908559 | 2021-01-08 | Rockcastle | Kentucky | 21203 | 985 | 9 |
905313 | 905313 | 2021-01-07 | Rockcastle | Kentucky | 21203 | 964 | 9 |
902068 | 902068 | 2021-01-06 | Rockcastle | Kentucky | 21203 | 949 | 8 |
898823 | 898823 | 2021-01-05 | Rockcastle | Kentucky | 21203 | 920 | 8 |
895578 | 895578 | 2021-01-04 | Rockcastle | Kentucky | 21203 | 913 | 8 |
892331 | 892331 | 2021-01-03 | Rockcastle | Kentucky | 21203 | 902 | 8 |
889085 | 889085 | 2021-01-02 | Rockcastle | Kentucky | 21203 | 885 | 8 |
885839 | 885839 | 2021-01-01 | Rockcastle | Kentucky | 21203 | 842 | 8 |
882594 | 882594 | 2020-12-31 | Rockcastle | Kentucky | 21203 | 842 | 8 |
879349 | 879349 | 2020-12-30 | Rockcastle | Kentucky | 21203 | 842 | 8 |
876104 | 876104 | 2020-12-29 | Rockcastle | Kentucky | 21203 | 825 | 8 |
872859 | 872859 | 2020-12-28 | Rockcastle | Kentucky | 21203 | 812 | 8 |
869614 | 869614 | 2020-12-27 | Rockcastle | Kentucky | 21203 | 795 | 8 |
866369 | 866369 | 2020-12-26 | Rockcastle | Kentucky | 21203 | 795 | 8 |
863124 | 863124 | 2020-12-25 | Rockcastle | Kentucky | 21203 | 782 | 7 |
859879 | 859879 | 2020-12-24 | Rockcastle | Kentucky | 21203 | 782 | 7 |
856634 | 856634 | 2020-12-23 | Rockcastle | Kentucky | 21203 | 782 | 7 |
853389 | 853389 | 2020-12-22 | Rockcastle | Kentucky | 21203 | 769 | 7 |
850144 | 850144 | 2020-12-21 | Rockcastle | Kentucky | 21203 | 761 | 7 |
846899 | 846899 | 2020-12-20 | Rockcastle | Kentucky | 21203 | 758 | 7 |
843653 | 843653 | 2020-12-19 | Rockcastle | Kentucky | 21203 | 750 | 7 |
840408 | 840408 | 2020-12-18 | Rockcastle | Kentucky | 21203 | 745 | 7 |
837163 | 837163 | 2020-12-17 | Rockcastle | Kentucky | 21203 | 736 | 7 |
833917 | 833917 | 2020-12-16 | Rockcastle | Kentucky | 21203 | 731 | 7 |
830670 | 830670 | 2020-12-15 | Rockcastle | Kentucky | 21203 | 717 | 7 |
827424 | 827424 | 2020-12-14 | Rockcastle | Kentucky | 21203 | 707 | 7 |
824177 | 824177 | 2020-12-13 | Rockcastle | Kentucky | 21203 | 701 | 7 |
820931 | 820931 | 2020-12-12 | Rockcastle | Kentucky | 21203 | 694 | 7 |
817685 | 817685 | 2020-12-11 | Rockcastle | Kentucky | 21203 | 689 | 7 |
814439 | 814439 | 2020-12-10 | Rockcastle | Kentucky | 21203 | 669 | 7 |
811194 | 811194 | 2020-12-09 | Rockcastle | Kentucky | 21203 | 642 | 7 |
807949 | 807949 | 2020-12-08 | Rockcastle | Kentucky | 21203 | 632 | 7 |
804704 | 804704 | 2020-12-07 | Rockcastle | Kentucky | 21203 | 615 | 7 |
801459 | 801459 | 2020-12-06 | Rockcastle | Kentucky | 21203 | 613 | 7 |
798214 | 798214 | 2020-12-05 | Rockcastle | Kentucky | 21203 | 598 | 7 |
794969 | 794969 | 2020-12-04 | Rockcastle | Kentucky | 21203 | 583 | 7 |
791724 | 791724 | 2020-12-03 | Rockcastle | Kentucky | 21203 | 570 | 7 |
788479 | 788479 | 2020-12-02 | Rockcastle | Kentucky | 21203 | 550 | 7 |
785235 | 785235 | 2020-12-01 | Rockcastle | Kentucky | 21203 | 534 | 7 |
781990 | 781990 | 2020-11-30 | Rockcastle | Kentucky | 21203 | 514 | 7 |
778744 | 778744 | 2020-11-29 | Rockcastle | Kentucky | 21203 | 506 | 7 |
775499 | 775499 | 2020-11-28 | Rockcastle | Kentucky | 21203 | 502 | 7 |
772254 | 772254 | 2020-11-27 | Rockcastle | Kentucky | 21203 | 499 | 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);