ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Shawnee" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418113 | 1418113 | 2021-06-14 | Shawnee | Kansas | 20177 | 17656 | 365 |
1414867 | 1414867 | 2021-06-13 | Shawnee | Kansas | 20177 | 17650 | 365 |
1411622 | 1411622 | 2021-06-12 | Shawnee | Kansas | 20177 | 17650 | 365 |
1408377 | 1408377 | 2021-06-11 | Shawnee | Kansas | 20177 | 17650 | 365 |
1405131 | 1405131 | 2021-06-10 | Shawnee | Kansas | 20177 | 17647 | 365 |
1401886 | 1401886 | 2021-06-09 | Shawnee | Kansas | 20177 | 17647 | 365 |
1398641 | 1398641 | 2021-06-08 | Shawnee | Kansas | 20177 | 17632 | 365 |
1395394 | 1395394 | 2021-06-07 | Shawnee | Kansas | 20177 | 17632 | 365 |
1392149 | 1392149 | 2021-06-06 | Shawnee | Kansas | 20177 | 17611 | 363 |
1388904 | 1388904 | 2021-06-05 | Shawnee | Kansas | 20177 | 17611 | 363 |
1385659 | 1385659 | 2021-06-04 | Shawnee | Kansas | 20177 | 17611 | 363 |
1382413 | 1382413 | 2021-06-03 | Shawnee | Kansas | 20177 | 17594 | 363 |
1379168 | 1379168 | 2021-06-02 | Shawnee | Kansas | 20177 | 17594 | 363 |
1375922 | 1375922 | 2021-06-01 | Shawnee | Kansas | 20177 | 17569 | 363 |
1372677 | 1372677 | 2021-05-31 | Shawnee | Kansas | 20177 | 17569 | 363 |
1369432 | 1369432 | 2021-05-30 | Shawnee | Kansas | 20177 | 17569 | 363 |
1366186 | 1366186 | 2021-05-29 | Shawnee | Kansas | 20177 | 17569 | 363 |
1362940 | 1362940 | 2021-05-28 | Shawnee | Kansas | 20177 | 17569 | 363 |
1359693 | 1359693 | 2021-05-27 | Shawnee | Kansas | 20177 | 17567 | 363 |
1356447 | 1356447 | 2021-05-26 | Shawnee | Kansas | 20177 | 17567 | 363 |
1353201 | 1353201 | 2021-05-25 | Shawnee | Kansas | 20177 | 17540 | 363 |
1349955 | 1349955 | 2021-05-24 | Shawnee | Kansas | 20177 | 17540 | 363 |
1346708 | 1346708 | 2021-05-23 | Shawnee | Kansas | 20177 | 17538 | 363 |
1343460 | 1343460 | 2021-05-22 | Shawnee | Kansas | 20177 | 17538 | 363 |
1340212 | 1340212 | 2021-05-21 | Shawnee | Kansas | 20177 | 17538 | 363 |
1336965 | 1336965 | 2021-05-20 | Shawnee | Kansas | 20177 | 17530 | 363 |
1333718 | 1333718 | 2021-05-19 | Shawnee | Kansas | 20177 | 17530 | 363 |
1330471 | 1330471 | 2021-05-18 | Shawnee | Kansas | 20177 | 17518 | 363 |
1327224 | 1327224 | 2021-05-17 | Shawnee | Kansas | 20177 | 17518 | 363 |
1323978 | 1323978 | 2021-05-16 | Shawnee | Kansas | 20177 | 17505 | 363 |
1320732 | 1320732 | 2021-05-15 | Shawnee | Kansas | 20177 | 17505 | 363 |
1317485 | 1317485 | 2021-05-14 | Shawnee | Kansas | 20177 | 17505 | 363 |
1314238 | 1314238 | 2021-05-13 | Shawnee | Kansas | 20177 | 17495 | 364 |
1310991 | 1310991 | 2021-05-12 | Shawnee | Kansas | 20177 | 17495 | 364 |
1307745 | 1307745 | 2021-05-11 | Shawnee | Kansas | 20177 | 17472 | 364 |
1304499 | 1304499 | 2021-05-10 | Shawnee | Kansas | 20177 | 17472 | 364 |
1301252 | 1301252 | 2021-05-09 | Shawnee | Kansas | 20177 | 17448 | 364 |
1298005 | 1298005 | 2021-05-08 | Shawnee | Kansas | 20177 | 17448 | 364 |
1294759 | 1294759 | 2021-05-07 | Shawnee | Kansas | 20177 | 17448 | 364 |
1291513 | 1291513 | 2021-05-06 | Shawnee | Kansas | 20177 | 17433 | 362 |
1288267 | 1288267 | 2021-05-05 | Shawnee | Kansas | 20177 | 17433 | 362 |
1285021 | 1285021 | 2021-05-04 | Shawnee | Kansas | 20177 | 17415 | 359 |
1281774 | 1281774 | 2021-05-03 | Shawnee | Kansas | 20177 | 17415 | 359 |
1278527 | 1278527 | 2021-05-02 | Shawnee | Kansas | 20177 | 17380 | 359 |
1275280 | 1275280 | 2021-05-01 | Shawnee | Kansas | 20177 | 17380 | 359 |
1272033 | 1272033 | 2021-04-30 | Shawnee | Kansas | 20177 | 17380 | 359 |
1268786 | 1268786 | 2021-04-29 | Shawnee | Kansas | 20177 | 17337 | 359 |
1265539 | 1265539 | 2021-04-28 | Shawnee | Kansas | 20177 | 17337 | 359 |
1262292 | 1262292 | 2021-04-27 | Shawnee | Kansas | 20177 | 17312 | 358 |
1259045 | 1259045 | 2021-04-26 | Shawnee | Kansas | 20177 | 17312 | 358 |
1255798 | 1255798 | 2021-04-25 | Shawnee | Kansas | 20177 | 17293 | 358 |
1252551 | 1252551 | 2021-04-24 | Shawnee | Kansas | 20177 | 17293 | 358 |
1249304 | 1249304 | 2021-04-23 | Shawnee | Kansas | 20177 | 17293 | 358 |
1246057 | 1246057 | 2021-04-22 | Shawnee | Kansas | 20177 | 17275 | 357 |
1242810 | 1242810 | 2021-04-21 | Shawnee | Kansas | 20177 | 17275 | 357 |
1239563 | 1239563 | 2021-04-20 | Shawnee | Kansas | 20177 | 17243 | 355 |
1236316 | 1236316 | 2021-04-19 | Shawnee | Kansas | 20177 | 17243 | 356 |
1233069 | 1233069 | 2021-04-18 | Shawnee | Kansas | 20177 | 17199 | 355 |
1229820 | 1229820 | 2021-04-17 | Shawnee | Kansas | 20177 | 17199 | 355 |
1226572 | 1226572 | 2021-04-16 | Shawnee | Kansas | 20177 | 17199 | 355 |
1223325 | 1223325 | 2021-04-15 | Shawnee | Kansas | 20177 | 17161 | 354 |
1220077 | 1220077 | 2021-04-14 | Shawnee | Kansas | 20177 | 17161 | 354 |
1216829 | 1216829 | 2021-04-13 | Shawnee | Kansas | 20177 | 17111 | 352 |
1213582 | 1213582 | 2021-04-12 | Shawnee | Kansas | 20177 | 17111 | 352 |
1210334 | 1210334 | 2021-04-11 | Shawnee | Kansas | 20177 | 17066 | 352 |
1207085 | 1207085 | 2021-04-10 | Shawnee | Kansas | 20177 | 17066 | 352 |
1203837 | 1203837 | 2021-04-09 | Shawnee | Kansas | 20177 | 17066 | 352 |
1200589 | 1200589 | 2021-04-08 | Shawnee | Kansas | 20177 | 17029 | 352 |
1197340 | 1197340 | 2021-04-07 | Shawnee | Kansas | 20177 | 17029 | 352 |
1194092 | 1194092 | 2021-04-06 | Shawnee | Kansas | 20177 | 16993 | 352 |
1190842 | 1190842 | 2021-04-05 | Shawnee | Kansas | 20177 | 16993 | 352 |
1187595 | 1187595 | 2021-04-04 | Shawnee | Kansas | 20177 | 16967 | 352 |
1184348 | 1184348 | 2021-04-03 | Shawnee | Kansas | 20177 | 16967 | 352 |
1181101 | 1181101 | 2021-04-02 | Shawnee | Kansas | 20177 | 16967 | 352 |
1177854 | 1177854 | 2021-04-01 | Shawnee | Kansas | 20177 | 16896 | 351 |
1174607 | 1174607 | 2021-03-31 | Shawnee | Kansas | 20177 | 16896 | 351 |
1171360 | 1171360 | 2021-03-30 | Shawnee | Kansas | 20177 | 16875 | 350 |
1168112 | 1168112 | 2021-03-29 | Shawnee | Kansas | 20177 | 16875 | 350 |
1164864 | 1164864 | 2021-03-28 | Shawnee | Kansas | 20177 | 16820 | 350 |
1161616 | 1161616 | 2021-03-27 | Shawnee | Kansas | 20177 | 16820 | 350 |
1158368 | 1158368 | 2021-03-26 | Shawnee | Kansas | 20177 | 16820 | 350 |
1155121 | 1155121 | 2021-03-25 | Shawnee | Kansas | 20177 | 16770 | 350 |
1151874 | 1151874 | 2021-03-24 | Shawnee | Kansas | 20177 | 16770 | 350 |
1148627 | 1148627 | 2021-03-23 | Shawnee | Kansas | 20177 | 16729 | 350 |
1145380 | 1145380 | 2021-03-22 | Shawnee | Kansas | 20177 | 16729 | 350 |
1142133 | 1142133 | 2021-03-21 | Shawnee | Kansas | 20177 | 16683 | 350 |
1138887 | 1138887 | 2021-03-20 | Shawnee | Kansas | 20177 | 16683 | 350 |
1135641 | 1135641 | 2021-03-19 | Shawnee | Kansas | 20177 | 16683 | 350 |
1132394 | 1132394 | 2021-03-18 | Shawnee | Kansas | 20177 | 16618 | 350 |
1129146 | 1129146 | 2021-03-17 | Shawnee | Kansas | 20177 | 16618 | 350 |
1125900 | 1125900 | 2021-03-16 | Shawnee | Kansas | 20177 | 16582 | 350 |
1122654 | 1122654 | 2021-03-15 | Shawnee | Kansas | 20177 | 16582 | 350 |
1119407 | 1119407 | 2021-03-14 | Shawnee | Kansas | 20177 | 16563 | 350 |
1116160 | 1116160 | 2021-03-13 | Shawnee | Kansas | 20177 | 16563 | 350 |
1112914 | 1112914 | 2021-03-12 | Shawnee | Kansas | 20177 | 16563 | 350 |
1109668 | 1109668 | 2021-03-11 | Shawnee | Kansas | 20177 | 16544 | 346 |
1106422 | 1106422 | 2021-03-10 | Shawnee | Kansas | 20177 | 16544 | 346 |
1103176 | 1103176 | 2021-03-09 | Shawnee | Kansas | 20177 | 16514 | 344 |
1099930 | 1099930 | 2021-03-08 | Shawnee | Kansas | 20177 | 16514 | 344 |
1096682 | 1096682 | 2021-03-07 | Shawnee | Kansas | 20177 | 16478 | 344 |
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);