ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 20149 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1278513 | 1278513 | 2021-05-02 | Pottawatomie | Kansas | 20149 | 1886 | 30 |
1275266 | 1275266 | 2021-05-01 | Pottawatomie | Kansas | 20149 | 1886 | 30 |
1272019 | 1272019 | 2021-04-30 | Pottawatomie | Kansas | 20149 | 1886 | 30 |
1268772 | 1268772 | 2021-04-29 | Pottawatomie | Kansas | 20149 | 1882 | 30 |
1265525 | 1265525 | 2021-04-28 | Pottawatomie | Kansas | 20149 | 1882 | 30 |
1262278 | 1262278 | 2021-04-27 | Pottawatomie | Kansas | 20149 | 1879 | 30 |
1259031 | 1259031 | 2021-04-26 | Pottawatomie | Kansas | 20149 | 1879 | 30 |
1255784 | 1255784 | 2021-04-25 | Pottawatomie | Kansas | 20149 | 1878 | 30 |
1252537 | 1252537 | 2021-04-24 | Pottawatomie | Kansas | 20149 | 1878 | 30 |
1249290 | 1249290 | 2021-04-23 | Pottawatomie | Kansas | 20149 | 1878 | 30 |
1246043 | 1246043 | 2021-04-22 | Pottawatomie | Kansas | 20149 | 1875 | 30 |
1242796 | 1242796 | 2021-04-21 | Pottawatomie | Kansas | 20149 | 1875 | 30 |
1239549 | 1239549 | 2021-04-20 | Pottawatomie | Kansas | 20149 | 1873 | 30 |
1236302 | 1236302 | 2021-04-19 | Pottawatomie | Kansas | 20149 | 1873 | 30 |
1233055 | 1233055 | 2021-04-18 | Pottawatomie | Kansas | 20149 | 1871 | 30 |
1229806 | 1229806 | 2021-04-17 | Pottawatomie | Kansas | 20149 | 1871 | 28 |
1226558 | 1226558 | 2021-04-16 | Pottawatomie | Kansas | 20149 | 1871 | 28 |
1223311 | 1223311 | 2021-04-15 | Pottawatomie | Kansas | 20149 | 1868 | 28 |
1220063 | 1220063 | 2021-04-14 | Pottawatomie | Kansas | 20149 | 1868 | 28 |
1216815 | 1216815 | 2021-04-13 | Pottawatomie | Kansas | 20149 | 1866 | 28 |
1213568 | 1213568 | 2021-04-12 | Pottawatomie | Kansas | 20149 | 1866 | 28 |
1210320 | 1210320 | 2021-04-11 | Pottawatomie | Kansas | 20149 | 1864 | 28 |
1207071 | 1207071 | 2021-04-10 | Pottawatomie | Kansas | 20149 | 1864 | 28 |
1203823 | 1203823 | 2021-04-09 | Pottawatomie | Kansas | 20149 | 1864 | 28 |
1200575 | 1200575 | 2021-04-08 | Pottawatomie | Kansas | 20149 | 1859 | 28 |
1197326 | 1197326 | 2021-04-07 | Pottawatomie | Kansas | 20149 | 1859 | 28 |
1194078 | 1194078 | 2021-04-06 | Pottawatomie | Kansas | 20149 | 1855 | 28 |
1190828 | 1190828 | 2021-04-05 | Pottawatomie | Kansas | 20149 | 1855 | 28 |
1187581 | 1187581 | 2021-04-04 | Pottawatomie | Kansas | 20149 | 1854 | 28 |
1184334 | 1184334 | 2021-04-03 | Pottawatomie | Kansas | 20149 | 1854 | 28 |
1181087 | 1181087 | 2021-04-02 | Pottawatomie | Kansas | 20149 | 1854 | 28 |
1177840 | 1177840 | 2021-04-01 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1174593 | 1174593 | 2021-03-31 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1171346 | 1171346 | 2021-03-30 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1168098 | 1168098 | 2021-03-29 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1164850 | 1164850 | 2021-03-28 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1161602 | 1161602 | 2021-03-27 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1158354 | 1158354 | 2021-03-26 | Pottawatomie | Kansas | 20149 | 1852 | 28 |
1155107 | 1155107 | 2021-03-25 | Pottawatomie | Kansas | 20149 | 1832 | 28 |
1151860 | 1151860 | 2021-03-24 | Pottawatomie | Kansas | 20149 | 1832 | 28 |
1148613 | 1148613 | 2021-03-23 | Pottawatomie | Kansas | 20149 | 1814 | 27 |
1145366 | 1145366 | 2021-03-22 | Pottawatomie | Kansas | 20149 | 1814 | 27 |
1142119 | 1142119 | 2021-03-21 | Pottawatomie | Kansas | 20149 | 1802 | 27 |
1138873 | 1138873 | 2021-03-20 | Pottawatomie | Kansas | 20149 | 1802 | 27 |
1135627 | 1135627 | 2021-03-19 | Pottawatomie | Kansas | 20149 | 1802 | 27 |
1132380 | 1132380 | 2021-03-18 | Pottawatomie | Kansas | 20149 | 1802 | 27 |
1129132 | 1129132 | 2021-03-17 | Pottawatomie | Kansas | 20149 | 1802 | 27 |
1125886 | 1125886 | 2021-03-16 | Pottawatomie | Kansas | 20149 | 1799 | 27 |
1122640 | 1122640 | 2021-03-15 | Pottawatomie | Kansas | 20149 | 1799 | 27 |
1119393 | 1119393 | 2021-03-14 | Pottawatomie | Kansas | 20149 | 1790 | 27 |
1116146 | 1116146 | 2021-03-13 | Pottawatomie | Kansas | 20149 | 1790 | 27 |
1112900 | 1112900 | 2021-03-12 | Pottawatomie | Kansas | 20149 | 1790 | 27 |
1109654 | 1109654 | 2021-03-11 | Pottawatomie | Kansas | 20149 | 1790 | 27 |
1106408 | 1106408 | 2021-03-10 | Pottawatomie | Kansas | 20149 | 1784 | 27 |
1103162 | 1103162 | 2021-03-09 | Pottawatomie | Kansas | 20149 | 1784 | 27 |
1099916 | 1099916 | 2021-03-08 | Pottawatomie | Kansas | 20149 | 1792 | 27 |
1096668 | 1096668 | 2021-03-07 | Pottawatomie | Kansas | 20149 | 1772 | 27 |
1093422 | 1093422 | 2021-03-06 | Pottawatomie | Kansas | 20149 | 1772 | 27 |
1090176 | 1090176 | 2021-03-05 | Pottawatomie | Kansas | 20149 | 1772 | 27 |
1086931 | 1086931 | 2021-03-04 | Pottawatomie | Kansas | 20149 | 1772 | 27 |
1083685 | 1083685 | 2021-03-03 | Pottawatomie | Kansas | 20149 | 1772 | 27 |
1080439 | 1080439 | 2021-03-02 | Pottawatomie | Kansas | 20149 | 1784 | 26 |
1077194 | 1077194 | 2021-03-01 | Pottawatomie | Kansas | 20149 | 1770 | 26 |
1073948 | 1073948 | 2021-02-28 | Pottawatomie | Kansas | 20149 | 1761 | 26 |
1070702 | 1070702 | 2021-02-27 | Pottawatomie | Kansas | 20149 | 1761 | 26 |
1067457 | 1067457 | 2021-02-26 | Pottawatomie | Kansas | 20149 | 1761 | 26 |
1064212 | 1064212 | 2021-02-25 | Pottawatomie | Kansas | 20149 | 1761 | 26 |
1060967 | 1060967 | 2021-02-24 | Pottawatomie | Kansas | 20149 | 1743 | 24 |
1057721 | 1057721 | 2021-02-23 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1054475 | 1054475 | 2021-02-22 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1051228 | 1051228 | 2021-02-21 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1047981 | 1047981 | 2021-02-20 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1044736 | 1044736 | 2021-02-19 | Pottawatomie | Kansas | 20149 | 1728 | 24 |
1041491 | 1041491 | 2021-02-18 | Pottawatomie | Kansas | 20149 | 1713 | 23 |
1038246 | 1038246 | 2021-02-17 | Pottawatomie | Kansas | 20149 | 1713 | 23 |
1035001 | 1035001 | 2021-02-16 | Pottawatomie | Kansas | 20149 | 1642 | 21 |
1031755 | 1031755 | 2021-02-15 | Pottawatomie | Kansas | 20149 | 1642 | 21 |
1028508 | 1028508 | 2021-02-14 | Pottawatomie | Kansas | 20149 | 1637 | 21 |
1025263 | 1025263 | 2021-02-13 | Pottawatomie | Kansas | 20149 | 1637 | 21 |
1022018 | 1022018 | 2021-02-12 | Pottawatomie | Kansas | 20149 | 1637 | 21 |
1018773 | 1018773 | 2021-02-11 | Pottawatomie | Kansas | 20149 | 1615 | 21 |
1015528 | 1015528 | 2021-02-10 | Pottawatomie | Kansas | 20149 | 1615 | 19 |
1012283 | 1012283 | 2021-02-09 | Pottawatomie | Kansas | 20149 | 1593 | 19 |
1009037 | 1009037 | 2021-02-08 | Pottawatomie | Kansas | 20149 | 1593 | 18 |
1005791 | 1005791 | 2021-02-07 | Pottawatomie | Kansas | 20149 | 1573 | 11 |
1002545 | 1002545 | 2021-02-06 | Pottawatomie | Kansas | 20149 | 1573 | 11 |
999299 | 999299 | 2021-02-05 | Pottawatomie | Kansas | 20149 | 1573 | 11 |
996053 | 996053 | 2021-02-04 | Pottawatomie | Kansas | 20149 | 1548 | 11 |
992807 | 992807 | 2021-02-03 | Pottawatomie | Kansas | 20149 | 1548 | 11 |
989561 | 989561 | 2021-02-02 | Pottawatomie | Kansas | 20149 | 1527 | 11 |
986314 | 986314 | 2021-02-01 | Pottawatomie | Kansas | 20149 | 1527 | 11 |
983067 | 983067 | 2021-01-31 | Pottawatomie | Kansas | 20149 | 1502 | 11 |
979821 | 979821 | 2021-01-30 | Pottawatomie | Kansas | 20149 | 1502 | 11 |
976575 | 976575 | 2021-01-29 | Pottawatomie | Kansas | 20149 | 1502 | 11 |
973330 | 973330 | 2021-01-28 | Pottawatomie | Kansas | 20149 | 1472 | 10 |
970085 | 970085 | 2021-01-27 | Pottawatomie | Kansas | 20149 | 1472 | 10 |
966841 | 966841 | 2021-01-26 | Pottawatomie | Kansas | 20149 | 1449 | 10 |
963596 | 963596 | 2021-01-25 | Pottawatomie | Kansas | 20149 | 1449 | 9 |
960351 | 960351 | 2021-01-24 | Pottawatomie | Kansas | 20149 | 1418 | 9 |
957105 | 957105 | 2021-01-23 | Pottawatomie | Kansas | 20149 | 1418 | 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);