ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 561 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337724 | 2337724 | 2022-03-24 | Edwards | Kansas | 20047 | 561 | 13 |
2334470 | 2334470 | 2022-03-23 | Edwards | Kansas | 20047 | 561 | 13 |
2246669 | 2246669 | 2022-02-24 | Graham | Kansas | 20065 | 561 | 13 |
2243418 | 2243418 | 2022-02-23 | Graham | Kansas | 20065 | 561 | 13 |
1989825 | 1989825 | 2021-12-07 | Rawlins | Kansas | 20153 | 561 | 7 |
1986575 | 1986575 | 2021-12-06 | Rawlins | Kansas | 20153 | 561 | 7 |
1694113 | 1694113 | 2021-09-07 | Meade | Kansas | 20119 | 561 | 13 |
1690864 | 1690864 | 2021-09-06 | Meade | Kansas | 20119 | 561 | 13 |
1687614 | 1687614 | 2021-09-05 | Meade | Kansas | 20119 | 561 | 13 |
1684364 | 1684364 | 2021-09-04 | Meade | Kansas | 20119 | 561 | 13 |
1681113 | 1681113 | 2021-09-03 | Meade | Kansas | 20119 | 561 | 13 |
1518721 | 1518721 | 2021-07-15 | Ottawa | Kansas | 20143 | 561 | 13 |
1515474 | 1515474 | 2021-07-14 | Ottawa | Kansas | 20143 | 561 | 13 |
1512228 | 1512228 | 2021-07-13 | Ottawa | Kansas | 20143 | 561 | 13 |
1508981 | 1508981 | 2021-07-12 | Ottawa | Kansas | 20143 | 561 | 13 |
1314211 | 1314211 | 2021-05-13 | Mitchell | Kansas | 20123 | 561 | 18 |
1310964 | 1310964 | 2021-05-12 | Mitchell | Kansas | 20123 | 561 | 18 |
1307718 | 1307718 | 2021-05-11 | Mitchell | Kansas | 20123 | 561 | 18 |
1304472 | 1304472 | 2021-05-10 | Mitchell | Kansas | 20123 | 561 | 18 |
1301225 | 1301225 | 2021-05-09 | Mitchell | Kansas | 20123 | 561 | 18 |
1297978 | 1297978 | 2021-05-08 | Mitchell | Kansas | 20123 | 561 | 18 |
1294732 | 1294732 | 2021-05-07 | Mitchell | Kansas | 20123 | 561 | 18 |
1291486 | 1291486 | 2021-05-06 | Mitchell | Kansas | 20123 | 561 | 18 |
1288240 | 1288240 | 2021-05-05 | Mitchell | Kansas | 20123 | 561 | 18 |
1284994 | 1284994 | 2021-05-04 | Mitchell | Kansas | 20123 | 561 | 18 |
1281747 | 1281747 | 2021-05-03 | Mitchell | Kansas | 20123 | 561 | 18 |
1278500 | 1278500 | 2021-05-02 | Mitchell | Kansas | 20123 | 561 | 18 |
1275253 | 1275253 | 2021-05-01 | Mitchell | Kansas | 20123 | 561 | 18 |
1272006 | 1272006 | 2021-04-30 | Mitchell | Kansas | 20123 | 561 | 18 |
1268759 | 1268759 | 2021-04-29 | Mitchell | Kansas | 20123 | 561 | 18 |
1265512 | 1265512 | 2021-04-28 | Mitchell | Kansas | 20123 | 561 | 18 |
1262265 | 1262265 | 2021-04-27 | Mitchell | Kansas | 20123 | 561 | 18 |
1259018 | 1259018 | 2021-04-26 | Mitchell | Kansas | 20123 | 561 | 18 |
1255771 | 1255771 | 2021-04-25 | Mitchell | Kansas | 20123 | 561 | 18 |
1252524 | 1252524 | 2021-04-24 | Mitchell | Kansas | 20123 | 561 | 18 |
1249277 | 1249277 | 2021-04-23 | Mitchell | Kansas | 20123 | 561 | 18 |
1246030 | 1246030 | 2021-04-22 | Mitchell | Kansas | 20123 | 561 | 18 |
1242783 | 1242783 | 2021-04-21 | Mitchell | Kansas | 20123 | 561 | 18 |
1239536 | 1239536 | 2021-04-20 | Mitchell | Kansas | 20123 | 561 | 18 |
1236289 | 1236289 | 2021-04-19 | Mitchell | Kansas | 20123 | 561 | 18 |
1233042 | 1233042 | 2021-04-18 | Mitchell | Kansas | 20123 | 561 | 18 |
1229793 | 1229793 | 2021-04-17 | Mitchell | Kansas | 20123 | 561 | 0 |
1226545 | 1226545 | 2021-04-16 | Mitchell | Kansas | 20123 | 561 | 0 |
1223298 | 1223298 | 2021-04-15 | Mitchell | Kansas | 20123 | 561 | 0 |
1220050 | 1220050 | 2021-04-14 | Mitchell | Kansas | 20123 | 561 | 0 |
1216802 | 1216802 | 2021-04-13 | Mitchell | Kansas | 20123 | 561 | 0 |
1213555 | 1213555 | 2021-04-12 | Mitchell | Kansas | 20123 | 561 | 0 |
1210307 | 1210307 | 2021-04-11 | Mitchell | Kansas | 20123 | 561 | 0 |
1207058 | 1207058 | 2021-04-10 | Mitchell | Kansas | 20123 | 561 | 0 |
1203810 | 1203810 | 2021-04-09 | Mitchell | Kansas | 20123 | 561 | 0 |
1200562 | 1200562 | 2021-04-08 | Mitchell | Kansas | 20123 | 561 | 0 |
1197313 | 1197313 | 2021-04-07 | Mitchell | Kansas | 20123 | 561 | 0 |
1194065 | 1194065 | 2021-04-06 | Mitchell | Kansas | 20123 | 561 | 0 |
1190815 | 1190815 | 2021-04-05 | Mitchell | Kansas | 20123 | 561 | 0 |
1187568 | 1187568 | 2021-04-04 | Mitchell | Kansas | 20123 | 561 | 0 |
1184321 | 1184321 | 2021-04-03 | Mitchell | Kansas | 20123 | 561 | 0 |
1181074 | 1181074 | 2021-04-02 | Mitchell | Kansas | 20123 | 561 | 0 |
1177812 | 1177812 | 2021-04-01 | Kearny | Kansas | 20093 | 561 | 9 |
1177827 | 1177827 | 2021-04-01 | Mitchell | Kansas | 20123 | 561 | 0 |
1174565 | 1174565 | 2021-03-31 | Kearny | Kansas | 20093 | 561 | 9 |
1174580 | 1174580 | 2021-03-31 | Mitchell | Kansas | 20123 | 561 | 0 |
1171318 | 1171318 | 2021-03-30 | Kearny | Kansas | 20093 | 561 | 9 |
1171333 | 1171333 | 2021-03-30 | Mitchell | Kansas | 20123 | 561 | 0 |
1168070 | 1168070 | 2021-03-29 | Kearny | Kansas | 20093 | 561 | 9 |
1168085 | 1168085 | 2021-03-29 | Mitchell | Kansas | 20123 | 561 | 0 |
1164837 | 1164837 | 2021-03-28 | Mitchell | Kansas | 20123 | 561 | 0 |
1161589 | 1161589 | 2021-03-27 | Mitchell | Kansas | 20123 | 561 | 0 |
1158341 | 1158341 | 2021-03-26 | Mitchell | Kansas | 20123 | 561 | 0 |
1155094 | 1155094 | 2021-03-25 | Mitchell | Kansas | 20123 | 561 | 0 |
1151847 | 1151847 | 2021-03-24 | Mitchell | Kansas | 20123 | 561 | 0 |
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 |
1093394 | 1093394 | 2021-03-06 | Kearny | Kansas | 20093 | 561 | 9 |
1090148 | 1090148 | 2021-03-05 | Kearny | Kansas | 20093 | 561 | 9 |
1086903 | 1086903 | 2021-03-04 | Kearny | Kansas | 20093 | 561 | 9 |
1083657 | 1083657 | 2021-03-03 | Kearny | Kansas | 20093 | 561 | 9 |
918172 | 918172 | 2021-01-11 | Scott | Kansas | 20171 | 561 | 16 |
914927 | 914927 | 2021-01-10 | Scott | Kansas | 20171 | 561 | 16 |
911682 | 911682 | 2021-01-09 | Scott | Kansas | 20171 | 561 | 16 |
869480 | 869480 | 2020-12-27 | Phillips | Kansas | 20147 | 561 | 12 |
866235 | 866235 | 2020-12-26 | Phillips | Kansas | 20147 | 561 | 12 |
862990 | 862990 | 2020-12-25 | Phillips | Kansas | 20147 | 561 | 12 |
859745 | 859745 | 2020-12-24 | Phillips | Kansas | 20147 | 561 | 12 |
856500 | 856500 | 2020-12-23 | Phillips | Kansas | 20147 | 561 | 12 |
778594 | 778594 | 2020-11-29 | Marshall | Kansas | 20117 | 561 | 5 |
775349 | 775349 | 2020-11-28 | Marshall | Kansas | 20117 | 561 | 5 |
772104 | 772104 | 2020-11-27 | Marshall | Kansas | 20117 | 561 | 5 |
677988 | 677988 | 2020-10-29 | Franklin | Kansas | 20059 | 561 | 5 |
674745 | 674745 | 2020-10-28 | Franklin | Kansas | 20059 | 561 | 5 |
361149 | 361149 | 2020-07-23 | Douglas | Kansas | 20045 | 561 | 2 |
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);