ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kenton" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278602 | 1278602 | 2021-05-02 | Kenton | Kentucky | 21117 | 16769 | 201 |
1275355 | 1275355 | 2021-05-01 | Kenton | Kentucky | 21117 | 16769 | 201 |
1272108 | 1272108 | 2021-04-30 | Kenton | Kentucky | 21117 | 16769 | 201 |
1268861 | 1268861 | 2021-04-29 | Kenton | Kentucky | 21117 | 16741 | 201 |
1265614 | 1265614 | 2021-04-28 | Kenton | Kentucky | 21117 | 16722 | 201 |
1262367 | 1262367 | 2021-04-27 | Kenton | Kentucky | 21117 | 16700 | 201 |
1259120 | 1259120 | 2021-04-26 | Kenton | Kentucky | 21117 | 16689 | 198 |
1255873 | 1255873 | 2021-04-25 | Kenton | Kentucky | 21117 | 16642 | 196 |
1252626 | 1252626 | 2021-04-24 | Kenton | Kentucky | 21117 | 16642 | 196 |
1249379 | 1249379 | 2021-04-23 | Kenton | Kentucky | 21117 | 16642 | 196 |
1246132 | 1246132 | 2021-04-22 | Kenton | Kentucky | 21117 | 16606 | 196 |
1242885 | 1242885 | 2021-04-21 | Kenton | Kentucky | 21117 | 16594 | 195 |
1239638 | 1239638 | 2021-04-20 | Kenton | Kentucky | 21117 | 16573 | 195 |
1236391 | 1236391 | 2021-04-19 | Kenton | Kentucky | 21117 | 16558 | 195 |
1233144 | 1233144 | 2021-04-18 | Kenton | Kentucky | 21117 | 16507 | 195 |
1229896 | 1229896 | 2021-04-17 | Kenton | Kentucky | 21117 | 16507 | 195 |
1226648 | 1226648 | 2021-04-16 | Kenton | Kentucky | 21117 | 16507 | 195 |
1223401 | 1223401 | 2021-04-15 | Kenton | Kentucky | 21117 | 16482 | 195 |
1220153 | 1220153 | 2021-04-14 | Kenton | Kentucky | 21117 | 16469 | 194 |
1216905 | 1216905 | 2021-04-13 | Kenton | Kentucky | 21117 | 16447 | 194 |
1213658 | 1213658 | 2021-04-12 | Kenton | Kentucky | 21117 | 16421 | 194 |
1210410 | 1210410 | 2021-04-11 | Kenton | Kentucky | 21117 | 16380 | 194 |
1207161 | 1207161 | 2021-04-10 | Kenton | Kentucky | 21117 | 16380 | 194 |
1203913 | 1203913 | 2021-04-09 | Kenton | Kentucky | 21117 | 16380 | 194 |
1200665 | 1200665 | 2021-04-08 | Kenton | Kentucky | 21117 | 16354 | 193 |
1197416 | 1197416 | 2021-04-07 | Kenton | Kentucky | 21117 | 16338 | 193 |
1194168 | 1194168 | 2021-04-06 | Kenton | Kentucky | 21117 | 16318 | 193 |
1190918 | 1190918 | 2021-04-05 | Kenton | Kentucky | 21117 | 16303 | 193 |
1187671 | 1187671 | 2021-04-04 | Kenton | Kentucky | 21117 | 16260 | 180 |
1184424 | 1184424 | 2021-04-03 | Kenton | Kentucky | 21117 | 16260 | 180 |
1181177 | 1181177 | 2021-04-02 | Kenton | Kentucky | 21117 | 16260 | 180 |
1177930 | 1177930 | 2021-04-01 | Kenton | Kentucky | 21117 | 16260 | 180 |
1174683 | 1174683 | 2021-03-31 | Kenton | Kentucky | 21117 | 16214 | 180 |
1171436 | 1171436 | 2021-03-30 | Kenton | Kentucky | 21117 | 16208 | 180 |
1168188 | 1168188 | 2021-03-29 | Kenton | Kentucky | 21117 | 16193 | 180 |
1164940 | 1164940 | 2021-03-28 | Kenton | Kentucky | 21117 | 16150 | 163 |
1161692 | 1161692 | 2021-03-27 | Kenton | Kentucky | 21117 | 16150 | 163 |
1158444 | 1158444 | 2021-03-26 | Kenton | Kentucky | 21117 | 16150 | 163 |
1155197 | 1155197 | 2021-03-25 | Kenton | Kentucky | 21117 | 16141 | 162 |
1151950 | 1151950 | 2021-03-24 | Kenton | Kentucky | 21117 | 16090 | 161 |
1148703 | 1148703 | 2021-03-23 | Kenton | Kentucky | 21117 | 16090 | 161 |
1145456 | 1145456 | 2021-03-22 | Kenton | Kentucky | 21117 | 16083 | 161 |
1142209 | 1142209 | 2021-03-21 | Kenton | Kentucky | 21117 | 16030 | 160 |
1138963 | 1138963 | 2021-03-20 | Kenton | Kentucky | 21117 | 16030 | 160 |
1135717 | 1135717 | 2021-03-19 | Kenton | Kentucky | 21117 | 16030 | 160 |
1132470 | 1132470 | 2021-03-18 | Kenton | Kentucky | 21117 | 15979 | 147 |
1129222 | 1129222 | 2021-03-17 | Kenton | Kentucky | 21117 | 15962 | 145 |
1125976 | 1125976 | 2021-03-16 | Kenton | Kentucky | 21117 | 15937 | 145 |
1122730 | 1122730 | 2021-03-15 | Kenton | Kentucky | 21117 | 15920 | 144 |
1119483 | 1119483 | 2021-03-14 | Kenton | Kentucky | 21117 | 15911 | 144 |
1116236 | 1116236 | 2021-03-13 | Kenton | Kentucky | 21117 | 15898 | 144 |
1112990 | 1112990 | 2021-03-12 | Kenton | Kentucky | 21117 | 15884 | 134 |
1109744 | 1109744 | 2021-03-11 | Kenton | Kentucky | 21117 | 15820 | 134 |
1106498 | 1106498 | 2021-03-10 | Kenton | Kentucky | 21117 | 15724 | 134 |
1103252 | 1103252 | 2021-03-09 | Kenton | Kentucky | 21117 | 15683 | 134 |
1100006 | 1100006 | 2021-03-08 | Kenton | Kentucky | 21117 | 15653 | 133 |
1096758 | 1096758 | 2021-03-07 | Kenton | Kentucky | 21117 | 15652 | 133 |
1093512 | 1093512 | 2021-03-06 | Kenton | Kentucky | 21117 | 15636 | 133 |
1090266 | 1090266 | 2021-03-05 | Kenton | Kentucky | 21117 | 15594 | 133 |
1087021 | 1087021 | 2021-03-04 | Kenton | Kentucky | 21117 | 15555 | 133 |
1083775 | 1083775 | 2021-03-03 | Kenton | Kentucky | 21117 | 15523 | 130 |
1080529 | 1080529 | 2021-03-02 | Kenton | Kentucky | 21117 | 15470 | 130 |
1077284 | 1077284 | 2021-03-01 | Kenton | Kentucky | 21117 | 15447 | 130 |
1074038 | 1074038 | 2021-02-28 | Kenton | Kentucky | 21117 | 15437 | 130 |
1070792 | 1070792 | 2021-02-27 | Kenton | Kentucky | 21117 | 15409 | 130 |
1067547 | 1067547 | 2021-02-26 | Kenton | Kentucky | 21117 | 15353 | 128 |
1064302 | 1064302 | 2021-02-25 | Kenton | Kentucky | 21117 | 15293 | 128 |
1061057 | 1061057 | 2021-02-24 | Kenton | Kentucky | 21117 | 15259 | 126 |
1057811 | 1057811 | 2021-02-23 | Kenton | Kentucky | 21117 | 15201 | 126 |
1054565 | 1054565 | 2021-02-22 | Kenton | Kentucky | 21117 | 15174 | 125 |
1051318 | 1051318 | 2021-02-21 | Kenton | Kentucky | 21117 | 15158 | 125 |
1048071 | 1048071 | 2021-02-20 | Kenton | Kentucky | 21117 | 15106 | 125 |
1044826 | 1044826 | 2021-02-19 | Kenton | Kentucky | 21117 | 15006 | 123 |
1041581 | 1041581 | 2021-02-18 | Kenton | Kentucky | 21117 | 14929 | 122 |
1038336 | 1038336 | 2021-02-17 | Kenton | Kentucky | 21117 | 14885 | 122 |
1035091 | 1035091 | 2021-02-16 | Kenton | Kentucky | 21117 | 14840 | 121 |
1031845 | 1031845 | 2021-02-15 | Kenton | Kentucky | 21117 | 14783 | 118 |
1028598 | 1028598 | 2021-02-14 | Kenton | Kentucky | 21117 | 14757 | 118 |
1025353 | 1025353 | 2021-02-13 | Kenton | Kentucky | 21117 | 14673 | 118 |
1022108 | 1022108 | 2021-02-12 | Kenton | Kentucky | 21117 | 14598 | 118 |
1018863 | 1018863 | 2021-02-11 | Kenton | Kentucky | 21117 | 14456 | 118 |
1015618 | 1015618 | 2021-02-10 | Kenton | Kentucky | 21117 | 14354 | 119 |
1012373 | 1012373 | 2021-02-09 | Kenton | Kentucky | 21117 | 14236 | 118 |
1009127 | 1009127 | 2021-02-08 | Kenton | Kentucky | 21117 | 14169 | 115 |
1005881 | 1005881 | 2021-02-07 | Kenton | Kentucky | 21117 | 14075 | 114 |
1002635 | 1002635 | 2021-02-06 | Kenton | Kentucky | 21117 | 14058 | 114 |
999389 | 999389 | 2021-02-05 | Kenton | Kentucky | 21117 | 13950 | 113 |
996143 | 996143 | 2021-02-04 | Kenton | Kentucky | 21117 | 13837 | 113 |
992897 | 992897 | 2021-02-03 | Kenton | Kentucky | 21117 | 13592 | 112 |
989651 | 989651 | 2021-02-02 | Kenton | Kentucky | 21117 | 13592 | 112 |
986404 | 986404 | 2021-02-01 | Kenton | Kentucky | 21117 | 13526 | 107 |
983157 | 983157 | 2021-01-31 | Kenton | Kentucky | 21117 | 13454 | 107 |
979911 | 979911 | 2021-01-30 | Kenton | Kentucky | 21117 | 13348 | 107 |
976665 | 976665 | 2021-01-29 | Kenton | Kentucky | 21117 | 13164 | 101 |
973420 | 973420 | 2021-01-28 | Kenton | Kentucky | 21117 | 13107 | 99 |
970175 | 970175 | 2021-01-27 | Kenton | Kentucky | 21117 | 12882 | 99 |
966931 | 966931 | 2021-01-26 | Kenton | Kentucky | 21117 | 12764 | 99 |
963686 | 963686 | 2021-01-25 | Kenton | Kentucky | 21117 | 12680 | 99 |
960441 | 960441 | 2021-01-24 | Kenton | Kentucky | 21117 | 12580 | 97 |
957195 | 957195 | 2021-01-23 | Kenton | Kentucky | 21117 | 12517 | 93 |
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);