ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 20177 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1093436 | 1093436 | 2021-03-06 | Shawnee | Kansas | 20177 | 16478 | 344 |
1090190 | 1090190 | 2021-03-05 | Shawnee | Kansas | 20177 | 16478 | 344 |
1086945 | 1086945 | 2021-03-04 | Shawnee | Kansas | 20177 | 16409 | 344 |
1083699 | 1083699 | 2021-03-03 | Shawnee | Kansas | 20177 | 16409 | 340 |
1080453 | 1080453 | 2021-03-02 | Shawnee | Kansas | 20177 | 16362 | 340 |
1077208 | 1077208 | 2021-03-01 | Shawnee | Kansas | 20177 | 16362 | 340 |
1073962 | 1073962 | 2021-02-28 | Shawnee | Kansas | 20177 | 16327 | 340 |
1070716 | 1070716 | 2021-02-27 | Shawnee | Kansas | 20177 | 16327 | 340 |
1067471 | 1067471 | 2021-02-26 | Shawnee | Kansas | 20177 | 16327 | 340 |
1064226 | 1064226 | 2021-02-25 | Shawnee | Kansas | 20177 | 16290 | 339 |
1060981 | 1060981 | 2021-02-24 | Shawnee | Kansas | 20177 | 16290 | 339 |
1057735 | 1057735 | 2021-02-23 | Shawnee | Kansas | 20177 | 16235 | 331 |
1054489 | 1054489 | 2021-02-22 | Shawnee | Kansas | 20177 | 16235 | 331 |
1051242 | 1051242 | 2021-02-21 | Shawnee | Kansas | 20177 | 16181 | 331 |
1047995 | 1047995 | 2021-02-20 | Shawnee | Kansas | 20177 | 16181 | 331 |
1044750 | 1044750 | 2021-02-19 | Shawnee | Kansas | 20177 | 16181 | 331 |
1041505 | 1041505 | 2021-02-18 | Shawnee | Kansas | 20177 | 16066 | 331 |
1038260 | 1038260 | 2021-02-17 | Shawnee | Kansas | 20177 | 16066 | 320 |
1035015 | 1035015 | 2021-02-16 | Shawnee | Kansas | 20177 | 16025 | 320 |
1031769 | 1031769 | 2021-02-15 | Shawnee | Kansas | 20177 | 16025 | 320 |
1028522 | 1028522 | 2021-02-14 | Shawnee | Kansas | 20177 | 15824 | 316 |
1025277 | 1025277 | 2021-02-13 | Shawnee | Kansas | 20177 | 15824 | 316 |
1022032 | 1022032 | 2021-02-12 | Shawnee | Kansas | 20177 | 15824 | 316 |
1018787 | 1018787 | 2021-02-11 | Shawnee | Kansas | 20177 | 15743 | 310 |
1015542 | 1015542 | 2021-02-10 | Shawnee | Kansas | 20177 | 15743 | 310 |
1012297 | 1012297 | 2021-02-09 | Shawnee | Kansas | 20177 | 15621 | 305 |
1009051 | 1009051 | 2021-02-08 | Shawnee | Kansas | 20177 | 15621 | 299 |
1005805 | 1005805 | 2021-02-07 | Shawnee | Kansas | 20177 | 15530 | 299 |
1002559 | 1002559 | 2021-02-06 | Shawnee | Kansas | 20177 | 15530 | 299 |
999313 | 999313 | 2021-02-05 | Shawnee | Kansas | 20177 | 15530 | 299 |
996067 | 996067 | 2021-02-04 | Shawnee | Kansas | 20177 | 15425 | 280 |
992821 | 992821 | 2021-02-03 | Shawnee | Kansas | 20177 | 15425 | 280 |
989575 | 989575 | 2021-02-02 | Shawnee | Kansas | 20177 | 15278 | 280 |
986328 | 986328 | 2021-02-01 | Shawnee | Kansas | 20177 | 15278 | 277 |
983081 | 983081 | 2021-01-31 | Shawnee | Kansas | 20177 | 15147 | 277 |
979835 | 979835 | 2021-01-30 | Shawnee | Kansas | 20177 | 15147 | 277 |
976589 | 976589 | 2021-01-29 | Shawnee | Kansas | 20177 | 15147 | 277 |
973344 | 973344 | 2021-01-28 | Shawnee | Kansas | 20177 | 14976 | 273 |
970099 | 970099 | 2021-01-27 | Shawnee | Kansas | 20177 | 14976 | 270 |
966855 | 966855 | 2021-01-26 | Shawnee | Kansas | 20177 | 14807 | 268 |
963610 | 963610 | 2021-01-25 | Shawnee | Kansas | 20177 | 14807 | 268 |
960365 | 960365 | 2021-01-24 | Shawnee | Kansas | 20177 | 14630 | 267 |
957119 | 957119 | 2021-01-23 | Shawnee | Kansas | 20177 | 14630 | 267 |
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);