ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Monroe" and fips = 21171 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194195 | 1194195 | 2021-04-06 | Monroe | Kentucky | 21171 | 1283 | 40 |
1190945 | 1190945 | 2021-04-05 | Monroe | Kentucky | 21171 | 1283 | 40 |
1187698 | 1187698 | 2021-04-04 | Monroe | Kentucky | 21171 | 1283 | 40 |
1184451 | 1184451 | 2021-04-03 | Monroe | Kentucky | 21171 | 1283 | 40 |
1181204 | 1181204 | 2021-04-02 | Monroe | Kentucky | 21171 | 1281 | 40 |
1177957 | 1177957 | 2021-04-01 | Monroe | Kentucky | 21171 | 1281 | 40 |
1174710 | 1174710 | 2021-03-31 | Monroe | Kentucky | 21171 | 1279 | 40 |
1171463 | 1171463 | 2021-03-30 | Monroe | Kentucky | 21171 | 1279 | 40 |
1168215 | 1168215 | 2021-03-29 | Monroe | Kentucky | 21171 | 1272 | 40 |
1164967 | 1164967 | 2021-03-28 | Monroe | Kentucky | 21171 | 1272 | 40 |
1161719 | 1161719 | 2021-03-27 | Monroe | Kentucky | 21171 | 1272 | 40 |
1158471 | 1158471 | 2021-03-26 | Monroe | Kentucky | 21171 | 1272 | 39 |
1155224 | 1155224 | 2021-03-25 | Monroe | Kentucky | 21171 | 1270 | 39 |
1151977 | 1151977 | 2021-03-24 | Monroe | Kentucky | 21171 | 1269 | 39 |
1148730 | 1148730 | 2021-03-23 | Monroe | Kentucky | 21171 | 1264 | 39 |
1145483 | 1145483 | 2021-03-22 | Monroe | Kentucky | 21171 | 1258 | 39 |
1142236 | 1142236 | 2021-03-21 | Monroe | Kentucky | 21171 | 1258 | 39 |
1138990 | 1138990 | 2021-03-20 | Monroe | Kentucky | 21171 | 1258 | 39 |
1135744 | 1135744 | 2021-03-19 | Monroe | Kentucky | 21171 | 1257 | 39 |
1132497 | 1132497 | 2021-03-18 | Monroe | Kentucky | 21171 | 1256 | 39 |
1129249 | 1129249 | 2021-03-17 | Monroe | Kentucky | 21171 | 1256 | 38 |
1126003 | 1126003 | 2021-03-16 | Monroe | Kentucky | 21171 | 1255 | 38 |
1122757 | 1122757 | 2021-03-15 | Monroe | Kentucky | 21171 | 1254 | 38 |
1119510 | 1119510 | 2021-03-14 | Monroe | Kentucky | 21171 | 1252 | 38 |
1116263 | 1116263 | 2021-03-13 | Monroe | Kentucky | 21171 | 1252 | 38 |
1113017 | 1113017 | 2021-03-12 | Monroe | Kentucky | 21171 | 1251 | 38 |
1109771 | 1109771 | 2021-03-11 | Monroe | Kentucky | 21171 | 1250 | 38 |
1106525 | 1106525 | 2021-03-10 | Monroe | Kentucky | 21171 | 1249 | 38 |
1103279 | 1103279 | 2021-03-09 | Monroe | Kentucky | 21171 | 1249 | 38 |
1100033 | 1100033 | 2021-03-08 | Monroe | Kentucky | 21171 | 1248 | 38 |
1096785 | 1096785 | 2021-03-07 | Monroe | Kentucky | 21171 | 1248 | 38 |
1093539 | 1093539 | 2021-03-06 | Monroe | Kentucky | 21171 | 1248 | 38 |
1090293 | 1090293 | 2021-03-05 | Monroe | Kentucky | 21171 | 1248 | 38 |
1087048 | 1087048 | 2021-03-04 | Monroe | Kentucky | 21171 | 1248 | 38 |
1083802 | 1083802 | 2021-03-03 | Monroe | Kentucky | 21171 | 1248 | 38 |
1080556 | 1080556 | 2021-03-02 | Monroe | Kentucky | 21171 | 1248 | 38 |
1077311 | 1077311 | 2021-03-01 | Monroe | Kentucky | 21171 | 1248 | 38 |
1074065 | 1074065 | 2021-02-28 | Monroe | Kentucky | 21171 | 1249 | 38 |
1070819 | 1070819 | 2021-02-27 | Monroe | Kentucky | 21171 | 1249 | 38 |
1067574 | 1067574 | 2021-02-26 | Monroe | Kentucky | 21171 | 1247 | 38 |
1064329 | 1064329 | 2021-02-25 | Monroe | Kentucky | 21171 | 1248 | 38 |
1061084 | 1061084 | 2021-02-24 | Monroe | Kentucky | 21171 | 1247 | 38 |
1057838 | 1057838 | 2021-02-23 | Monroe | Kentucky | 21171 | 1247 | 38 |
1054592 | 1054592 | 2021-02-22 | Monroe | Kentucky | 21171 | 1245 | 38 |
1051345 | 1051345 | 2021-02-21 | Monroe | Kentucky | 21171 | 1245 | 38 |
1048098 | 1048098 | 2021-02-20 | Monroe | Kentucky | 21171 | 1245 | 38 |
1044853 | 1044853 | 2021-02-19 | Monroe | Kentucky | 21171 | 1241 | 38 |
1041608 | 1041608 | 2021-02-18 | Monroe | Kentucky | 21171 | 1235 | 37 |
1038363 | 1038363 | 2021-02-17 | Monroe | Kentucky | 21171 | 1235 | 36 |
1035118 | 1035118 | 2021-02-16 | Monroe | Kentucky | 21171 | 1235 | 36 |
1031872 | 1031872 | 2021-02-15 | Monroe | Kentucky | 21171 | 1235 | 36 |
1028625 | 1028625 | 2021-02-14 | Monroe | Kentucky | 21171 | 1234 | 36 |
1025380 | 1025380 | 2021-02-13 | Monroe | Kentucky | 21171 | 1228 | 36 |
1022135 | 1022135 | 2021-02-12 | Monroe | Kentucky | 21171 | 1229 | 36 |
1018890 | 1018890 | 2021-02-11 | Monroe | Kentucky | 21171 | 1229 | 36 |
1015645 | 1015645 | 2021-02-10 | Monroe | Kentucky | 21171 | 1226 | 36 |
1012400 | 1012400 | 2021-02-09 | Monroe | Kentucky | 21171 | 1216 | 36 |
1009154 | 1009154 | 2021-02-08 | Monroe | Kentucky | 21171 | 1206 | 36 |
1005908 | 1005908 | 2021-02-07 | Monroe | Kentucky | 21171 | 1207 | 36 |
1002662 | 1002662 | 2021-02-06 | Monroe | Kentucky | 21171 | 1203 | 36 |
999416 | 999416 | 2021-02-05 | Monroe | Kentucky | 21171 | 1196 | 36 |
996170 | 996170 | 2021-02-04 | Monroe | Kentucky | 21171 | 1190 | 36 |
992924 | 992924 | 2021-02-03 | Monroe | Kentucky | 21171 | 1182 | 36 |
989678 | 989678 | 2021-02-02 | Monroe | Kentucky | 21171 | 1177 | 36 |
986431 | 986431 | 2021-02-01 | Monroe | Kentucky | 21171 | 1160 | 36 |
983184 | 983184 | 2021-01-31 | Monroe | Kentucky | 21171 | 1160 | 35 |
979938 | 979938 | 2021-01-30 | Monroe | Kentucky | 21171 | 1159 | 35 |
976692 | 976692 | 2021-01-29 | Monroe | Kentucky | 21171 | 1149 | 35 |
973447 | 973447 | 2021-01-28 | Monroe | Kentucky | 21171 | 1145 | 34 |
970202 | 970202 | 2021-01-27 | Monroe | Kentucky | 21171 | 1134 | 34 |
966958 | 966958 | 2021-01-26 | Monroe | Kentucky | 21171 | 1129 | 34 |
963713 | 963713 | 2021-01-25 | Monroe | Kentucky | 21171 | 1120 | 34 |
960468 | 960468 | 2021-01-24 | Monroe | Kentucky | 21171 | 1118 | 33 |
957222 | 957222 | 2021-01-23 | Monroe | Kentucky | 21171 | 1116 | 33 |
953977 | 953977 | 2021-01-22 | Monroe | Kentucky | 21171 | 1111 | 33 |
950732 | 950732 | 2021-01-21 | Monroe | Kentucky | 21171 | 1107 | 33 |
947486 | 947486 | 2021-01-20 | Monroe | Kentucky | 21171 | 1103 | 32 |
944239 | 944239 | 2021-01-19 | Monroe | Kentucky | 21171 | 1096 | 32 |
940994 | 940994 | 2021-01-18 | Monroe | Kentucky | 21171 | 1092 | 28 |
937749 | 937749 | 2021-01-17 | Monroe | Kentucky | 21171 | 1089 | 28 |
934504 | 934504 | 2021-01-16 | Monroe | Kentucky | 21171 | 1089 | 28 |
931259 | 931259 | 2021-01-15 | Monroe | Kentucky | 21171 | 1086 | 28 |
928014 | 928014 | 2021-01-14 | Monroe | Kentucky | 21171 | 1076 | 28 |
924768 | 924768 | 2021-01-13 | Monroe | Kentucky | 21171 | 1067 | 28 |
921523 | 921523 | 2021-01-12 | Monroe | Kentucky | 21171 | 1060 | 28 |
918278 | 918278 | 2021-01-11 | Monroe | Kentucky | 21171 | 1050 | 28 |
915033 | 915033 | 2021-01-10 | Monroe | Kentucky | 21171 | 1047 | 28 |
911788 | 911788 | 2021-01-09 | Monroe | Kentucky | 21171 | 1046 | 28 |
908543 | 908543 | 2021-01-08 | Monroe | Kentucky | 21171 | 1034 | 28 |
905297 | 905297 | 2021-01-07 | Monroe | Kentucky | 21171 | 1022 | 28 |
902052 | 902052 | 2021-01-06 | Monroe | Kentucky | 21171 | 1011 | 28 |
898807 | 898807 | 2021-01-05 | Monroe | Kentucky | 21171 | 991 | 26 |
895562 | 895562 | 2021-01-04 | Monroe | Kentucky | 21171 | 978 | 26 |
892315 | 892315 | 2021-01-03 | Monroe | Kentucky | 21171 | 971 | 26 |
889069 | 889069 | 2021-01-02 | Monroe | Kentucky | 21171 | 969 | 26 |
885823 | 885823 | 2021-01-01 | Monroe | Kentucky | 21171 | 945 | 26 |
882578 | 882578 | 2020-12-31 | Monroe | Kentucky | 21171 | 945 | 26 |
879333 | 879333 | 2020-12-30 | Monroe | Kentucky | 21171 | 945 | 26 |
876088 | 876088 | 2020-12-29 | Monroe | Kentucky | 21171 | 930 | 25 |
872843 | 872843 | 2020-12-28 | Monroe | Kentucky | 21171 | 916 | 25 |
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);