ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 20087 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278482 | 1278482 | 2021-05-02 | Jefferson | Kansas | 20087 | 1710 | 34 |
1275235 | 1275235 | 2021-05-01 | Jefferson | Kansas | 20087 | 1710 | 34 |
1271988 | 1271988 | 2021-04-30 | Jefferson | Kansas | 20087 | 1710 | 34 |
1268741 | 1268741 | 2021-04-29 | Jefferson | Kansas | 20087 | 1705 | 34 |
1265494 | 1265494 | 2021-04-28 | Jefferson | Kansas | 20087 | 1705 | 34 |
1262247 | 1262247 | 2021-04-27 | Jefferson | Kansas | 20087 | 1701 | 34 |
1259000 | 1259000 | 2021-04-26 | Jefferson | Kansas | 20087 | 1701 | 34 |
1255753 | 1255753 | 2021-04-25 | Jefferson | Kansas | 20087 | 1701 | 34 |
1252506 | 1252506 | 2021-04-24 | Jefferson | Kansas | 20087 | 1701 | 34 |
1249259 | 1249259 | 2021-04-23 | Jefferson | Kansas | 20087 | 1701 | 34 |
1246012 | 1246012 | 2021-04-22 | Jefferson | Kansas | 20087 | 1698 | 34 |
1242765 | 1242765 | 2021-04-21 | Jefferson | Kansas | 20087 | 1698 | 34 |
1239518 | 1239518 | 2021-04-20 | Jefferson | Kansas | 20087 | 1697 | 34 |
1236271 | 1236271 | 2021-04-19 | Jefferson | Kansas | 20087 | 1697 | 35 |
1233024 | 1233024 | 2021-04-18 | Jefferson | Kansas | 20087 | 1692 | 35 |
1229775 | 1229775 | 2021-04-17 | Jefferson | Kansas | 20087 | 1692 | 35 |
1226527 | 1226527 | 2021-04-16 | Jefferson | Kansas | 20087 | 1692 | 35 |
1223280 | 1223280 | 2021-04-15 | Jefferson | Kansas | 20087 | 1690 | 33 |
1220032 | 1220032 | 2021-04-14 | Jefferson | Kansas | 20087 | 1690 | 33 |
1216784 | 1216784 | 2021-04-13 | Jefferson | Kansas | 20087 | 1689 | 33 |
1213537 | 1213537 | 2021-04-12 | Jefferson | Kansas | 20087 | 1689 | 33 |
1210289 | 1210289 | 2021-04-11 | Jefferson | Kansas | 20087 | 1684 | 33 |
1207040 | 1207040 | 2021-04-10 | Jefferson | Kansas | 20087 | 1684 | 33 |
1203792 | 1203792 | 2021-04-09 | Jefferson | Kansas | 20087 | 1684 | 33 |
1200544 | 1200544 | 2021-04-08 | Jefferson | Kansas | 20087 | 1684 | 33 |
1197295 | 1197295 | 2021-04-07 | Jefferson | Kansas | 20087 | 1684 | 33 |
1194047 | 1194047 | 2021-04-06 | Jefferson | Kansas | 20087 | 1683 | 32 |
1190797 | 1190797 | 2021-04-05 | Jefferson | Kansas | 20087 | 1683 | 32 |
1187550 | 1187550 | 2021-04-04 | Jefferson | Kansas | 20087 | 1675 | 32 |
1184303 | 1184303 | 2021-04-03 | Jefferson | Kansas | 20087 | 1675 | 32 |
1181056 | 1181056 | 2021-04-02 | Jefferson | Kansas | 20087 | 1675 | 32 |
1177809 | 1177809 | 2021-04-01 | Jefferson | Kansas | 20087 | 1669 | 32 |
1174562 | 1174562 | 2021-03-31 | Jefferson | Kansas | 20087 | 1669 | 32 |
1171315 | 1171315 | 2021-03-30 | Jefferson | Kansas | 20087 | 1663 | 32 |
1168067 | 1168067 | 2021-03-29 | Jefferson | Kansas | 20087 | 1663 | 32 |
1164819 | 1164819 | 2021-03-28 | Jefferson | Kansas | 20087 | 1658 | 32 |
1161571 | 1161571 | 2021-03-27 | Jefferson | Kansas | 20087 | 1658 | 32 |
1158323 | 1158323 | 2021-03-26 | Jefferson | Kansas | 20087 | 1658 | 32 |
1155076 | 1155076 | 2021-03-25 | Jefferson | Kansas | 20087 | 1653 | 32 |
1151829 | 1151829 | 2021-03-24 | Jefferson | Kansas | 20087 | 1653 | 32 |
1148582 | 1148582 | 2021-03-23 | Jefferson | Kansas | 20087 | 1648 | 32 |
1145335 | 1145335 | 2021-03-22 | Jefferson | Kansas | 20087 | 1648 | 32 |
1142088 | 1142088 | 2021-03-21 | Jefferson | Kansas | 20087 | 1643 | 32 |
1138842 | 1138842 | 2021-03-20 | Jefferson | Kansas | 20087 | 1643 | 32 |
1135596 | 1135596 | 2021-03-19 | Jefferson | Kansas | 20087 | 1643 | 32 |
1132349 | 1132349 | 2021-03-18 | Jefferson | Kansas | 20087 | 1636 | 32 |
1129101 | 1129101 | 2021-03-17 | Jefferson | Kansas | 20087 | 1636 | 32 |
1125855 | 1125855 | 2021-03-16 | Jefferson | Kansas | 20087 | 1632 | 32 |
1122609 | 1122609 | 2021-03-15 | Jefferson | Kansas | 20087 | 1632 | 32 |
1119362 | 1119362 | 2021-03-14 | Jefferson | Kansas | 20087 | 1628 | 32 |
1116115 | 1116115 | 2021-03-13 | Jefferson | Kansas | 20087 | 1628 | 32 |
1112869 | 1112869 | 2021-03-12 | Jefferson | Kansas | 20087 | 1628 | 32 |
1109623 | 1109623 | 2021-03-11 | Jefferson | Kansas | 20087 | 1627 | 32 |
1106377 | 1106377 | 2021-03-10 | Jefferson | Kansas | 20087 | 1627 | 32 |
1103131 | 1103131 | 2021-03-09 | Jefferson | Kansas | 20087 | 1624 | 32 |
1099885 | 1099885 | 2021-03-08 | Jefferson | Kansas | 20087 | 1624 | 32 |
1096637 | 1096637 | 2021-03-07 | Jefferson | Kansas | 20087 | 1623 | 32 |
1093391 | 1093391 | 2021-03-06 | Jefferson | Kansas | 20087 | 1623 | 32 |
1090145 | 1090145 | 2021-03-05 | Jefferson | Kansas | 20087 | 1623 | 32 |
1086900 | 1086900 | 2021-03-04 | Jefferson | Kansas | 20087 | 1620 | 32 |
1083654 | 1083654 | 2021-03-03 | Jefferson | Kansas | 20087 | 1620 | 32 |
1080408 | 1080408 | 2021-03-02 | Jefferson | Kansas | 20087 | 1618 | 32 |
1077163 | 1077163 | 2021-03-01 | Jefferson | Kansas | 20087 | 1618 | 32 |
1073917 | 1073917 | 2021-02-28 | Jefferson | Kansas | 20087 | 1611 | 32 |
1070671 | 1070671 | 2021-02-27 | Jefferson | Kansas | 20087 | 1611 | 32 |
1067426 | 1067426 | 2021-02-26 | Jefferson | Kansas | 20087 | 1611 | 32 |
1064181 | 1064181 | 2021-02-25 | Jefferson | Kansas | 20087 | 1608 | 30 |
1060936 | 1060936 | 2021-02-24 | Jefferson | Kansas | 20087 | 1608 | 30 |
1057690 | 1057690 | 2021-02-23 | Jefferson | Kansas | 20087 | 1605 | 30 |
1054444 | 1054444 | 2021-02-22 | Jefferson | Kansas | 20087 | 1605 | 30 |
1051197 | 1051197 | 2021-02-21 | Jefferson | Kansas | 20087 | 1603 | 30 |
1047950 | 1047950 | 2021-02-20 | Jefferson | Kansas | 20087 | 1603 | 30 |
1044705 | 1044705 | 2021-02-19 | Jefferson | Kansas | 20087 | 1603 | 30 |
1041460 | 1041460 | 2021-02-18 | Jefferson | Kansas | 20087 | 1596 | 28 |
1038215 | 1038215 | 2021-02-17 | Jefferson | Kansas | 20087 | 1596 | 28 |
1034970 | 1034970 | 2021-02-16 | Jefferson | Kansas | 20087 | 1590 | 28 |
1031724 | 1031724 | 2021-02-15 | Jefferson | Kansas | 20087 | 1590 | 28 |
1028477 | 1028477 | 2021-02-14 | Jefferson | Kansas | 20087 | 1576 | 28 |
1025232 | 1025232 | 2021-02-13 | Jefferson | Kansas | 20087 | 1576 | 28 |
1021987 | 1021987 | 2021-02-12 | Jefferson | Kansas | 20087 | 1576 | 28 |
1018742 | 1018742 | 2021-02-11 | Jefferson | Kansas | 20087 | 1568 | 28 |
1015497 | 1015497 | 2021-02-10 | Jefferson | Kansas | 20087 | 1568 | 28 |
1012252 | 1012252 | 2021-02-09 | Jefferson | Kansas | 20087 | 1560 | 28 |
1009006 | 1009006 | 2021-02-08 | Jefferson | Kansas | 20087 | 1560 | 28 |
1005760 | 1005760 | 2021-02-07 | Jefferson | Kansas | 20087 | 1554 | 28 |
1002514 | 1002514 | 2021-02-06 | Jefferson | Kansas | 20087 | 1554 | 28 |
999268 | 999268 | 2021-02-05 | Jefferson | Kansas | 20087 | 1554 | 28 |
996022 | 996022 | 2021-02-04 | Jefferson | Kansas | 20087 | 1542 | 26 |
992776 | 992776 | 2021-02-03 | Jefferson | Kansas | 20087 | 1542 | 24 |
989530 | 989530 | 2021-02-02 | Jefferson | Kansas | 20087 | 1532 | 24 |
986283 | 986283 | 2021-02-01 | Jefferson | Kansas | 20087 | 1532 | 24 |
983036 | 983036 | 2021-01-31 | Jefferson | Kansas | 20087 | 1521 | 24 |
979790 | 979790 | 2021-01-30 | Jefferson | Kansas | 20087 | 1521 | 24 |
976544 | 976544 | 2021-01-29 | Jefferson | Kansas | 20087 | 1521 | 24 |
973299 | 973299 | 2021-01-28 | Jefferson | Kansas | 20087 | 1510 | 24 |
970054 | 970054 | 2021-01-27 | Jefferson | Kansas | 20087 | 1510 | 24 |
966810 | 966810 | 2021-01-26 | Jefferson | Kansas | 20087 | 1495 | 24 |
963565 | 963565 | 2021-01-25 | Jefferson | Kansas | 20087 | 1495 | 24 |
960320 | 960320 | 2021-01-24 | Jefferson | Kansas | 20087 | 1482 | 24 |
957074 | 957074 | 2021-01-23 | Jefferson | Kansas | 20087 | 1482 | 24 |
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);