ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71 rows where cases = 566 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428858 | 2428858 | 2022-04-21 | Graham | Kansas | 20065 | 566 | 15 |
2425602 | 2425602 | 2022-04-20 | Graham | Kansas | 20065 | 566 | 15 |
2422346 | 2422346 | 2022-04-19 | Graham | Kansas | 20065 | 566 | 15 |
2419090 | 2419090 | 2022-04-18 | Graham | Kansas | 20065 | 566 | 15 |
2415834 | 2415834 | 2022-04-17 | Graham | Kansas | 20065 | 566 | 15 |
2412578 | 2412578 | 2022-04-16 | Graham | Kansas | 20065 | 566 | 15 |
2409322 | 2409322 | 2022-04-15 | Graham | Kansas | 20065 | 566 | 15 |
2406066 | 2406066 | 2022-04-14 | Graham | Kansas | 20065 | 566 | 15 |
2402810 | 2402810 | 2022-04-13 | Graham | Kansas | 20065 | 566 | 15 |
2399556 | 2399556 | 2022-04-12 | Graham | Kansas | 20065 | 566 | 15 |
2396300 | 2396300 | 2022-04-11 | Graham | Kansas | 20065 | 566 | 15 |
2393045 | 2393045 | 2022-04-10 | Graham | Kansas | 20065 | 566 | 15 |
2389789 | 2389789 | 2022-04-09 | Graham | Kansas | 20065 | 566 | 15 |
2386533 | 2386533 | 2022-04-08 | Graham | Kansas | 20065 | 566 | 15 |
2383279 | 2383279 | 2022-04-07 | Graham | Kansas | 20065 | 566 | 15 |
2380024 | 2380024 | 2022-04-06 | Graham | Kansas | 20065 | 566 | 15 |
2376769 | 2376769 | 2022-04-05 | Graham | Kansas | 20065 | 566 | 15 |
2373517 | 2373517 | 2022-04-04 | Graham | Kansas | 20065 | 566 | 15 |
2370264 | 2370264 | 2022-04-03 | Graham | Kansas | 20065 | 566 | 15 |
2367011 | 2367011 | 2022-04-02 | Graham | Kansas | 20065 | 566 | 15 |
2363758 | 2363758 | 2022-04-01 | Graham | Kansas | 20065 | 566 | 15 |
2360504 | 2360504 | 2022-03-31 | Graham | Kansas | 20065 | 566 | 14 |
2357250 | 2357250 | 2022-03-30 | Graham | Kansas | 20065 | 566 | 14 |
2353997 | 2353997 | 2022-03-29 | Graham | Kansas | 20065 | 566 | 14 |
2350745 | 2350745 | 2022-03-28 | Graham | Kansas | 20065 | 566 | 14 |
2347492 | 2347492 | 2022-03-27 | Graham | Kansas | 20065 | 566 | 14 |
2344239 | 2344239 | 2022-03-26 | Graham | Kansas | 20065 | 566 | 14 |
2340986 | 2340986 | 2022-03-25 | Graham | Kansas | 20065 | 566 | 14 |
2246661 | 2246661 | 2022-02-24 | Elk | Kansas | 20049 | 566 | 8 |
2243410 | 2243410 | 2022-02-23 | Elk | Kansas | 20049 | 566 | 8 |
2149114 | 2149114 | 2022-01-25 | Lincoln | Kansas | 20105 | 566 | 8 |
2145862 | 2145862 | 2022-01-24 | Lincoln | Kansas | 20105 | 566 | 8 |
2126376 | 2126376 | 2022-01-18 | Smith | Kansas | 20183 | 566 | 5 |
2123124 | 2123124 | 2022-01-17 | Smith | Kansas | 20183 | 566 | 5 |
2119872 | 2119872 | 2022-01-16 | Smith | Kansas | 20183 | 566 | 5 |
2116620 | 2116620 | 2022-01-15 | Smith | Kansas | 20183 | 566 | 5 |
2113369 | 2113369 | 2022-01-14 | Smith | Kansas | 20183 | 566 | 5 |
2028826 | 2028826 | 2021-12-19 | Ness | Kansas | 20135 | 566 | 17 |
2025575 | 2025575 | 2021-12-18 | Ness | Kansas | 20135 | 566 | 17 |
2022324 | 2022324 | 2021-12-17 | Ness | Kansas | 20135 | 566 | 17 |
1996327 | 1996327 | 2021-12-09 | Rawlins | Kansas | 20153 | 566 | 7 |
1993076 | 1993076 | 2021-12-08 | Rawlins | Kansas | 20153 | 566 | 7 |
1989831 | 1989831 | 2021-12-07 | Rush | Kansas | 20165 | 566 | 16 |
1986581 | 1986581 | 2021-12-06 | Rush | Kansas | 20165 | 566 | 16 |
1733094 | 1733094 | 2021-09-19 | Meade | Kansas | 20119 | 566 | 14 |
1729844 | 1729844 | 2021-09-18 | Meade | Kansas | 20119 | 566 | 14 |
1726594 | 1726594 | 2021-09-17 | Meade | Kansas | 20119 | 566 | 14 |
1564213 | 1564213 | 2021-07-29 | Washington | Kansas | 20201 | 566 | 14 |
1560965 | 1560965 | 2021-07-28 | Washington | Kansas | 20201 | 566 | 14 |
1541453 | 1541453 | 2021-07-22 | Ottawa | Kansas | 20143 | 566 | 13 |
1538206 | 1538206 | 2021-07-21 | Ottawa | Kansas | 20143 | 566 | 13 |
1414840 | 1414840 | 2021-06-13 | Mitchell | Kansas | 20123 | 566 | 18 |
1411595 | 1411595 | 2021-06-12 | Mitchell | Kansas | 20123 | 566 | 18 |
1408350 | 1408350 | 2021-06-11 | Mitchell | Kansas | 20123 | 566 | 18 |
1405104 | 1405104 | 2021-06-10 | Mitchell | Kansas | 20123 | 566 | 18 |
1401859 | 1401859 | 2021-06-09 | Mitchell | Kansas | 20123 | 566 | 18 |
1398614 | 1398614 | 2021-06-08 | Mitchell | Kansas | 20123 | 566 | 18 |
1395367 | 1395367 | 2021-06-07 | Mitchell | Kansas | 20123 | 566 | 18 |
1268744 | 1268744 | 2021-04-29 | Kearny | Kansas | 20093 | 566 | 10 |
1265497 | 1265497 | 2021-04-28 | Kearny | Kansas | 20093 | 566 | 10 |
1262250 | 1262250 | 2021-04-27 | Kearny | Kansas | 20093 | 566 | 10 |
1259003 | 1259003 | 2021-04-26 | Kearny | Kansas | 20093 | 566 | 10 |
1255756 | 1255756 | 2021-04-25 | Kearny | Kansas | 20093 | 566 | 10 |
1252509 | 1252509 | 2021-04-24 | Kearny | Kansas | 20093 | 566 | 10 |
1249262 | 1249262 | 2021-04-23 | Kearny | Kansas | 20093 | 566 | 10 |
1246015 | 1246015 | 2021-04-22 | Kearny | Kansas | 20093 | 566 | 10 |
1242768 | 1242768 | 2021-04-21 | Kearny | Kansas | 20093 | 566 | 10 |
1239521 | 1239521 | 2021-04-20 | Kearny | Kansas | 20093 | 566 | 10 |
1236274 | 1236274 | 2021-04-19 | Kearny | Kansas | 20093 | 566 | 10 |
1216787 | 1216787 | 2021-04-13 | Kearny | Kansas | 20093 | 566 | 9 |
1213540 | 1213540 | 2021-04-12 | Kearny | Kansas | 20093 | 566 | 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);