ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
762 rows where fips = 20093 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418071 | 1418071 | 2021-06-14 | Kearny | Kansas | 20093 | 574 | 10 |
1414825 | 1414825 | 2021-06-13 | Kearny | Kansas | 20093 | 573 | 10 |
1411580 | 1411580 | 2021-06-12 | Kearny | Kansas | 20093 | 573 | 10 |
1408335 | 1408335 | 2021-06-11 | Kearny | Kansas | 20093 | 573 | 10 |
1405089 | 1405089 | 2021-06-10 | Kearny | Kansas | 20093 | 573 | 10 |
1401844 | 1401844 | 2021-06-09 | Kearny | Kansas | 20093 | 573 | 10 |
1398599 | 1398599 | 2021-06-08 | Kearny | Kansas | 20093 | 573 | 10 |
1395352 | 1395352 | 2021-06-07 | Kearny | Kansas | 20093 | 573 | 10 |
1392107 | 1392107 | 2021-06-06 | Kearny | Kansas | 20093 | 573 | 10 |
1388862 | 1388862 | 2021-06-05 | Kearny | Kansas | 20093 | 573 | 10 |
1385617 | 1385617 | 2021-06-04 | Kearny | Kansas | 20093 | 573 | 10 |
1382371 | 1382371 | 2021-06-03 | Kearny | Kansas | 20093 | 573 | 10 |
1379126 | 1379126 | 2021-06-02 | Kearny | Kansas | 20093 | 573 | 10 |
1375880 | 1375880 | 2021-06-01 | Kearny | Kansas | 20093 | 573 | 10 |
1372635 | 1372635 | 2021-05-31 | Kearny | Kansas | 20093 | 573 | 10 |
1369390 | 1369390 | 2021-05-30 | Kearny | Kansas | 20093 | 573 | 10 |
1366144 | 1366144 | 2021-05-29 | Kearny | Kansas | 20093 | 573 | 10 |
1362898 | 1362898 | 2021-05-28 | Kearny | Kansas | 20093 | 573 | 10 |
1359651 | 1359651 | 2021-05-27 | Kearny | Kansas | 20093 | 573 | 10 |
1356405 | 1356405 | 2021-05-26 | Kearny | Kansas | 20093 | 573 | 10 |
1353159 | 1353159 | 2021-05-25 | Kearny | Kansas | 20093 | 573 | 10 |
1349913 | 1349913 | 2021-05-24 | Kearny | Kansas | 20093 | 573 | 10 |
1346666 | 1346666 | 2021-05-23 | Kearny | Kansas | 20093 | 572 | 10 |
1343418 | 1343418 | 2021-05-22 | Kearny | Kansas | 20093 | 572 | 10 |
1340170 | 1340170 | 2021-05-21 | Kearny | Kansas | 20093 | 572 | 10 |
1336923 | 1336923 | 2021-05-20 | Kearny | Kansas | 20093 | 572 | 10 |
1333676 | 1333676 | 2021-05-19 | Kearny | Kansas | 20093 | 572 | 10 |
1330429 | 1330429 | 2021-05-18 | Kearny | Kansas | 20093 | 572 | 10 |
1327182 | 1327182 | 2021-05-17 | Kearny | Kansas | 20093 | 572 | 10 |
1323936 | 1323936 | 2021-05-16 | Kearny | Kansas | 20093 | 570 | 10 |
1320690 | 1320690 | 2021-05-15 | Kearny | Kansas | 20093 | 570 | 10 |
1317443 | 1317443 | 2021-05-14 | Kearny | Kansas | 20093 | 570 | 10 |
1314196 | 1314196 | 2021-05-13 | Kearny | Kansas | 20093 | 570 | 10 |
1310949 | 1310949 | 2021-05-12 | Kearny | Kansas | 20093 | 570 | 10 |
1307703 | 1307703 | 2021-05-11 | Kearny | Kansas | 20093 | 569 | 10 |
1304457 | 1304457 | 2021-05-10 | Kearny | Kansas | 20093 | 569 | 10 |
1301210 | 1301210 | 2021-05-09 | Kearny | Kansas | 20093 | 568 | 10 |
1297963 | 1297963 | 2021-05-08 | Kearny | Kansas | 20093 | 568 | 10 |
1294717 | 1294717 | 2021-05-07 | Kearny | Kansas | 20093 | 568 | 10 |
1291471 | 1291471 | 2021-05-06 | Kearny | Kansas | 20093 | 568 | 10 |
1288225 | 1288225 | 2021-05-05 | Kearny | Kansas | 20093 | 568 | 10 |
1284979 | 1284979 | 2021-05-04 | Kearny | Kansas | 20093 | 568 | 10 |
1281732 | 1281732 | 2021-05-03 | Kearny | Kansas | 20093 | 568 | 10 |
1278485 | 1278485 | 2021-05-02 | Kearny | Kansas | 20093 | 567 | 10 |
1275238 | 1275238 | 2021-05-01 | Kearny | Kansas | 20093 | 567 | 10 |
1271991 | 1271991 | 2021-04-30 | Kearny | Kansas | 20093 | 567 | 10 |
1268744 | 1268744 | 2021-04-29 | Kearny | Kansas | 20093 | 566 | 10 |
1265497 | 1265497 | 2021-04-28 | Kearny | Kansas | 20093 | 566 | 10 |
1262250 | 1262250 | 2021-04-27 | Kearny | Kansas | 20093 | 566 | 10 |
1259003 | 1259003 | 2021-04-26 | Kearny | Kansas | 20093 | 566 | 10 |
1255756 | 1255756 | 2021-04-25 | Kearny | Kansas | 20093 | 566 | 10 |
1252509 | 1252509 | 2021-04-24 | Kearny | Kansas | 20093 | 566 | 10 |
1249262 | 1249262 | 2021-04-23 | Kearny | Kansas | 20093 | 566 | 10 |
1246015 | 1246015 | 2021-04-22 | Kearny | Kansas | 20093 | 566 | 10 |
1242768 | 1242768 | 2021-04-21 | Kearny | Kansas | 20093 | 566 | 10 |
1239521 | 1239521 | 2021-04-20 | Kearny | Kansas | 20093 | 566 | 10 |
1236274 | 1236274 | 2021-04-19 | Kearny | Kansas | 20093 | 566 | 10 |
1233027 | 1233027 | 2021-04-18 | Kearny | Kansas | 20093 | 565 | 10 |
1229778 | 1229778 | 2021-04-17 | Kearny | Kansas | 20093 | 565 | 9 |
1226530 | 1226530 | 2021-04-16 | Kearny | Kansas | 20093 | 565 | 9 |
1223283 | 1223283 | 2021-04-15 | Kearny | Kansas | 20093 | 565 | 9 |
1220035 | 1220035 | 2021-04-14 | Kearny | Kansas | 20093 | 565 | 9 |
1216787 | 1216787 | 2021-04-13 | Kearny | Kansas | 20093 | 566 | 9 |
1213540 | 1213540 | 2021-04-12 | Kearny | Kansas | 20093 | 566 | 9 |
1210292 | 1210292 | 2021-04-11 | Kearny | Kansas | 20093 | 565 | 9 |
1207043 | 1207043 | 2021-04-10 | Kearny | Kansas | 20093 | 565 | 9 |
1203795 | 1203795 | 2021-04-09 | Kearny | Kansas | 20093 | 565 | 9 |
1200547 | 1200547 | 2021-04-08 | Kearny | Kansas | 20093 | 564 | 9 |
1197298 | 1197298 | 2021-04-07 | Kearny | Kansas | 20093 | 564 | 9 |
1194050 | 1194050 | 2021-04-06 | Kearny | Kansas | 20093 | 562 | 9 |
1190800 | 1190800 | 2021-04-05 | Kearny | Kansas | 20093 | 562 | 9 |
1187553 | 1187553 | 2021-04-04 | Kearny | Kansas | 20093 | 562 | 9 |
1184306 | 1184306 | 2021-04-03 | Kearny | Kansas | 20093 | 562 | 9 |
1181059 | 1181059 | 2021-04-02 | Kearny | Kansas | 20093 | 562 | 9 |
1177812 | 1177812 | 2021-04-01 | Kearny | Kansas | 20093 | 561 | 9 |
1174565 | 1174565 | 2021-03-31 | Kearny | Kansas | 20093 | 561 | 9 |
1171318 | 1171318 | 2021-03-30 | Kearny | Kansas | 20093 | 561 | 9 |
1168070 | 1168070 | 2021-03-29 | Kearny | Kansas | 20093 | 561 | 9 |
1164822 | 1164822 | 2021-03-28 | Kearny | Kansas | 20093 | 560 | 9 |
1161574 | 1161574 | 2021-03-27 | Kearny | Kansas | 20093 | 560 | 9 |
1158326 | 1158326 | 2021-03-26 | Kearny | Kansas | 20093 | 560 | 9 |
1155079 | 1155079 | 2021-03-25 | Kearny | Kansas | 20093 | 560 | 9 |
1151832 | 1151832 | 2021-03-24 | Kearny | Kansas | 20093 | 560 | 9 |
1148585 | 1148585 | 2021-03-23 | Kearny | Kansas | 20093 | 560 | 9 |
1145338 | 1145338 | 2021-03-22 | Kearny | Kansas | 20093 | 560 | 9 |
1142091 | 1142091 | 2021-03-21 | Kearny | Kansas | 20093 | 560 | 9 |
1138845 | 1138845 | 2021-03-20 | Kearny | Kansas | 20093 | 560 | 9 |
1135599 | 1135599 | 2021-03-19 | Kearny | Kansas | 20093 | 560 | 9 |
1132352 | 1132352 | 2021-03-18 | Kearny | Kansas | 20093 | 561 | 9 |
1129104 | 1129104 | 2021-03-17 | Kearny | Kansas | 20093 | 561 | 9 |
1125858 | 1125858 | 2021-03-16 | Kearny | Kansas | 20093 | 561 | 9 |
1122612 | 1122612 | 2021-03-15 | Kearny | Kansas | 20093 | 561 | 9 |
1119365 | 1119365 | 2021-03-14 | Kearny | Kansas | 20093 | 561 | 9 |
1116118 | 1116118 | 2021-03-13 | Kearny | Kansas | 20093 | 561 | 9 |
1112872 | 1112872 | 2021-03-12 | Kearny | Kansas | 20093 | 561 | 9 |
1109626 | 1109626 | 2021-03-11 | Kearny | Kansas | 20093 | 561 | 9 |
1106380 | 1106380 | 2021-03-10 | Kearny | Kansas | 20093 | 561 | 9 |
1103134 | 1103134 | 2021-03-09 | Kearny | Kansas | 20093 | 561 | 9 |
1099888 | 1099888 | 2021-03-08 | Kearny | Kansas | 20093 | 561 | 9 |
1096640 | 1096640 | 2021-03-07 | Kearny | Kansas | 20093 | 561 | 9 |
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);