ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Jackson" and fips = 20085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194046 | 1194046 | 2021-04-06 | Jackson | Kansas | 20085 | 1389 | 15 |
1190796 | 1190796 | 2021-04-05 | Jackson | Kansas | 20085 | 1389 | 15 |
1187549 | 1187549 | 2021-04-04 | Jackson | Kansas | 20085 | 1382 | 15 |
1184302 | 1184302 | 2021-04-03 | Jackson | Kansas | 20085 | 1382 | 15 |
1181055 | 1181055 | 2021-04-02 | Jackson | Kansas | 20085 | 1382 | 15 |
1177808 | 1177808 | 2021-04-01 | Jackson | Kansas | 20085 | 1381 | 15 |
1174561 | 1174561 | 2021-03-31 | Jackson | Kansas | 20085 | 1381 | 15 |
1171314 | 1171314 | 2021-03-30 | Jackson | Kansas | 20085 | 1378 | 15 |
1168066 | 1168066 | 2021-03-29 | Jackson | Kansas | 20085 | 1378 | 15 |
1164818 | 1164818 | 2021-03-28 | Jackson | Kansas | 20085 | 1375 | 15 |
1161570 | 1161570 | 2021-03-27 | Jackson | Kansas | 20085 | 1375 | 15 |
1158322 | 1158322 | 2021-03-26 | Jackson | Kansas | 20085 | 1375 | 15 |
1155075 | 1155075 | 2021-03-25 | Jackson | Kansas | 20085 | 1373 | 15 |
1151828 | 1151828 | 2021-03-24 | Jackson | Kansas | 20085 | 1373 | 15 |
1148581 | 1148581 | 2021-03-23 | Jackson | Kansas | 20085 | 1363 | 15 |
1145334 | 1145334 | 2021-03-22 | Jackson | Kansas | 20085 | 1363 | 15 |
1142087 | 1142087 | 2021-03-21 | Jackson | Kansas | 20085 | 1360 | 15 |
1138841 | 1138841 | 2021-03-20 | Jackson | Kansas | 20085 | 1360 | 15 |
1135595 | 1135595 | 2021-03-19 | Jackson | Kansas | 20085 | 1360 | 15 |
1132348 | 1132348 | 2021-03-18 | Jackson | Kansas | 20085 | 1353 | 15 |
1129100 | 1129100 | 2021-03-17 | Jackson | Kansas | 20085 | 1353 | 15 |
1125854 | 1125854 | 2021-03-16 | Jackson | Kansas | 20085 | 1349 | 15 |
1122608 | 1122608 | 2021-03-15 | Jackson | Kansas | 20085 | 1349 | 15 |
1119361 | 1119361 | 2021-03-14 | Jackson | Kansas | 20085 | 1347 | 15 |
1116114 | 1116114 | 2021-03-13 | Jackson | Kansas | 20085 | 1347 | 15 |
1112868 | 1112868 | 2021-03-12 | Jackson | Kansas | 20085 | 1347 | 15 |
1109622 | 1109622 | 2021-03-11 | Jackson | Kansas | 20085 | 1343 | 15 |
1106376 | 1106376 | 2021-03-10 | Jackson | Kansas | 20085 | 1343 | 15 |
1103130 | 1103130 | 2021-03-09 | Jackson | Kansas | 20085 | 1338 | 15 |
1099884 | 1099884 | 2021-03-08 | Jackson | Kansas | 20085 | 1338 | 15 |
1096636 | 1096636 | 2021-03-07 | Jackson | Kansas | 20085 | 1339 | 15 |
1093390 | 1093390 | 2021-03-06 | Jackson | Kansas | 20085 | 1339 | 15 |
1090144 | 1090144 | 2021-03-05 | Jackson | Kansas | 20085 | 1339 | 15 |
1086899 | 1086899 | 2021-03-04 | Jackson | Kansas | 20085 | 1336 | 15 |
1083653 | 1083653 | 2021-03-03 | Jackson | Kansas | 20085 | 1336 | 15 |
1080407 | 1080407 | 2021-03-02 | Jackson | Kansas | 20085 | 1330 | 15 |
1077162 | 1077162 | 2021-03-01 | Jackson | Kansas | 20085 | 1330 | 15 |
1073916 | 1073916 | 2021-02-28 | Jackson | Kansas | 20085 | 1330 | 15 |
1070670 | 1070670 | 2021-02-27 | Jackson | Kansas | 20085 | 1330 | 15 |
1067425 | 1067425 | 2021-02-26 | Jackson | Kansas | 20085 | 1330 | 15 |
1064180 | 1064180 | 2021-02-25 | Jackson | Kansas | 20085 | 1329 | 12 |
1060935 | 1060935 | 2021-02-24 | Jackson | Kansas | 20085 | 1329 | 12 |
1057689 | 1057689 | 2021-02-23 | Jackson | Kansas | 20085 | 1328 | 11 |
1054443 | 1054443 | 2021-02-22 | Jackson | Kansas | 20085 | 1328 | 11 |
1051196 | 1051196 | 2021-02-21 | Jackson | Kansas | 20085 | 1327 | 11 |
1047949 | 1047949 | 2021-02-20 | Jackson | Kansas | 20085 | 1327 | 11 |
1044704 | 1044704 | 2021-02-19 | Jackson | Kansas | 20085 | 1327 | 11 |
1041459 | 1041459 | 2021-02-18 | Jackson | Kansas | 20085 | 1324 | 11 |
1038214 | 1038214 | 2021-02-17 | Jackson | Kansas | 20085 | 1324 | 11 |
1034969 | 1034969 | 2021-02-16 | Jackson | Kansas | 20085 | 1316 | 11 |
1031723 | 1031723 | 2021-02-15 | Jackson | Kansas | 20085 | 1316 | 11 |
1028476 | 1028476 | 2021-02-14 | Jackson | Kansas | 20085 | 1312 | 11 |
1025231 | 1025231 | 2021-02-13 | Jackson | Kansas | 20085 | 1312 | 11 |
1021986 | 1021986 | 2021-02-12 | Jackson | Kansas | 20085 | 1312 | 11 |
1018741 | 1018741 | 2021-02-11 | Jackson | Kansas | 20085 | 1303 | 11 |
1015496 | 1015496 | 2021-02-10 | Jackson | Kansas | 20085 | 1303 | 11 |
1012251 | 1012251 | 2021-02-09 | Jackson | Kansas | 20085 | 1290 | 11 |
1009005 | 1009005 | 2021-02-08 | Jackson | Kansas | 20085 | 1290 | 11 |
1005759 | 1005759 | 2021-02-07 | Jackson | Kansas | 20085 | 1284 | 11 |
1002513 | 1002513 | 2021-02-06 | Jackson | Kansas | 20085 | 1284 | 11 |
999267 | 999267 | 2021-02-05 | Jackson | Kansas | 20085 | 1284 | 11 |
996021 | 996021 | 2021-02-04 | Jackson | Kansas | 20085 | 1274 | 11 |
992775 | 992775 | 2021-02-03 | Jackson | Kansas | 20085 | 1274 | 11 |
989529 | 989529 | 2021-02-02 | Jackson | Kansas | 20085 | 1264 | 11 |
986282 | 986282 | 2021-02-01 | Jackson | Kansas | 20085 | 1264 | 11 |
983035 | 983035 | 2021-01-31 | Jackson | Kansas | 20085 | 1259 | 11 |
979789 | 979789 | 2021-01-30 | Jackson | Kansas | 20085 | 1259 | 11 |
976543 | 976543 | 2021-01-29 | Jackson | Kansas | 20085 | 1259 | 11 |
973298 | 973298 | 2021-01-28 | Jackson | Kansas | 20085 | 1248 | 11 |
970053 | 970053 | 2021-01-27 | Jackson | Kansas | 20085 | 1248 | 11 |
966809 | 966809 | 2021-01-26 | Jackson | Kansas | 20085 | 1236 | 11 |
963564 | 963564 | 2021-01-25 | Jackson | Kansas | 20085 | 1236 | 10 |
960319 | 960319 | 2021-01-24 | Jackson | Kansas | 20085 | 1234 | 10 |
957073 | 957073 | 2021-01-23 | Jackson | Kansas | 20085 | 1234 | 10 |
953828 | 953828 | 2021-01-22 | Jackson | Kansas | 20085 | 1234 | 10 |
950583 | 950583 | 2021-01-21 | Jackson | Kansas | 20085 | 1219 | 10 |
947337 | 947337 | 2021-01-20 | Jackson | Kansas | 20085 | 1219 | 10 |
944090 | 944090 | 2021-01-19 | Jackson | Kansas | 20085 | 1204 | 10 |
940845 | 940845 | 2021-01-18 | Jackson | Kansas | 20085 | 1204 | 10 |
937600 | 937600 | 2021-01-17 | Jackson | Kansas | 20085 | 1194 | 10 |
934355 | 934355 | 2021-01-16 | Jackson | Kansas | 20085 | 1194 | 10 |
931110 | 931110 | 2021-01-15 | Jackson | Kansas | 20085 | 1194 | 10 |
927865 | 927865 | 2021-01-14 | Jackson | Kansas | 20085 | 1183 | 10 |
924619 | 924619 | 2021-01-13 | Jackson | Kansas | 20085 | 1183 | 10 |
921374 | 921374 | 2021-01-12 | Jackson | Kansas | 20085 | 1160 | 10 |
918129 | 918129 | 2021-01-11 | Jackson | Kansas | 20085 | 1160 | 10 |
914884 | 914884 | 2021-01-10 | Jackson | Kansas | 20085 | 1126 | 10 |
911639 | 911639 | 2021-01-09 | Jackson | Kansas | 20085 | 1126 | 10 |
908394 | 908394 | 2021-01-08 | Jackson | Kansas | 20085 | 1126 | 10 |
905148 | 905148 | 2021-01-07 | Jackson | Kansas | 20085 | 1094 | 10 |
901903 | 901903 | 2021-01-06 | Jackson | Kansas | 20085 | 1094 | 10 |
898658 | 898658 | 2021-01-05 | Jackson | Kansas | 20085 | 1051 | 10 |
895413 | 895413 | 2021-01-04 | Jackson | Kansas | 20085 | 1051 | 10 |
892166 | 892166 | 2021-01-03 | Jackson | Kansas | 20085 | 1039 | 10 |
888920 | 888920 | 2021-01-02 | Jackson | Kansas | 20085 | 1039 | 10 |
885674 | 885674 | 2021-01-01 | Jackson | Kansas | 20085 | 1039 | 10 |
882429 | 882429 | 2020-12-31 | Jackson | Kansas | 20085 | 1018 | 10 |
879184 | 879184 | 2020-12-30 | Jackson | Kansas | 20085 | 1018 | 10 |
875939 | 875939 | 2020-12-29 | Jackson | Kansas | 20085 | 1001 | 10 |
872694 | 872694 | 2020-12-28 | Jackson | Kansas | 20085 | 1001 | 10 |
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);