ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where fips = 20041 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500493 | 2500493 | 2022-05-13 | Dickinson | Kansas | 20041 | 4815 | 78 |
2497235 | 2497235 | 2022-05-12 | Dickinson | Kansas | 20041 | 4807 | 78 |
2493977 | 2493977 | 2022-05-11 | Dickinson | Kansas | 20041 | 4807 | 78 |
2490719 | 2490719 | 2022-05-10 | Dickinson | Kansas | 20041 | 4807 | 78 |
2487462 | 2487462 | 2022-05-09 | Dickinson | Kansas | 20041 | 4807 | 78 |
2484204 | 2484204 | 2022-05-08 | Dickinson | Kansas | 20041 | 4807 | 78 |
2480946 | 2480946 | 2022-05-07 | Dickinson | Kansas | 20041 | 4807 | 78 |
2477688 | 2477688 | 2022-05-06 | Dickinson | Kansas | 20041 | 4807 | 78 |
2474430 | 2474430 | 2022-05-05 | Dickinson | Kansas | 20041 | 4805 | 78 |
2471173 | 2471173 | 2022-05-04 | Dickinson | Kansas | 20041 | 4805 | 78 |
2467917 | 2467917 | 2022-05-03 | Dickinson | Kansas | 20041 | 4805 | 78 |
2464662 | 2464662 | 2022-05-02 | Dickinson | Kansas | 20041 | 4805 | 78 |
2461406 | 2461406 | 2022-05-01 | Dickinson | Kansas | 20041 | 4805 | 78 |
2458150 | 2458150 | 2022-04-30 | Dickinson | Kansas | 20041 | 4805 | 78 |
2454894 | 2454894 | 2022-04-29 | Dickinson | Kansas | 20041 | 4805 | 78 |
2451638 | 2451638 | 2022-04-28 | Dickinson | Kansas | 20041 | 4803 | 78 |
2448382 | 2448382 | 2022-04-27 | Dickinson | Kansas | 20041 | 4803 | 78 |
2445126 | 2445126 | 2022-04-26 | Dickinson | Kansas | 20041 | 4803 | 78 |
2441870 | 2441870 | 2022-04-25 | Dickinson | Kansas | 20041 | 4803 | 78 |
2438614 | 2438614 | 2022-04-24 | Dickinson | Kansas | 20041 | 4803 | 78 |
2435358 | 2435358 | 2022-04-23 | Dickinson | Kansas | 20041 | 4803 | 78 |
2432102 | 2432102 | 2022-04-22 | Dickinson | Kansas | 20041 | 4803 | 78 |
2428846 | 2428846 | 2022-04-21 | Dickinson | Kansas | 20041 | 4802 | 78 |
2425590 | 2425590 | 2022-04-20 | Dickinson | Kansas | 20041 | 4802 | 78 |
2422334 | 2422334 | 2022-04-19 | Dickinson | Kansas | 20041 | 4802 | 78 |
2419078 | 2419078 | 2022-04-18 | Dickinson | Kansas | 20041 | 4802 | 78 |
2415822 | 2415822 | 2022-04-17 | Dickinson | Kansas | 20041 | 4802 | 78 |
2412566 | 2412566 | 2022-04-16 | Dickinson | Kansas | 20041 | 4802 | 78 |
2409310 | 2409310 | 2022-04-15 | Dickinson | Kansas | 20041 | 4802 | 78 |
2406054 | 2406054 | 2022-04-14 | Dickinson | Kansas | 20041 | 4799 | 78 |
2402798 | 2402798 | 2022-04-13 | Dickinson | Kansas | 20041 | 4799 | 78 |
2399544 | 2399544 | 2022-04-12 | Dickinson | Kansas | 20041 | 4799 | 78 |
2396288 | 2396288 | 2022-04-11 | Dickinson | Kansas | 20041 | 4799 | 78 |
2393033 | 2393033 | 2022-04-10 | Dickinson | Kansas | 20041 | 4799 | 78 |
2389777 | 2389777 | 2022-04-09 | Dickinson | Kansas | 20041 | 4799 | 78 |
2386521 | 2386521 | 2022-04-08 | Dickinson | Kansas | 20041 | 4799 | 78 |
2383267 | 2383267 | 2022-04-07 | Dickinson | Kansas | 20041 | 4799 | 78 |
2380012 | 2380012 | 2022-04-06 | Dickinson | Kansas | 20041 | 4799 | 78 |
2376757 | 2376757 | 2022-04-05 | Dickinson | Kansas | 20041 | 4799 | 78 |
2373505 | 2373505 | 2022-04-04 | Dickinson | Kansas | 20041 | 4799 | 78 |
2370252 | 2370252 | 2022-04-03 | Dickinson | Kansas | 20041 | 4799 | 78 |
2366999 | 2366999 | 2022-04-02 | Dickinson | Kansas | 20041 | 4799 | 78 |
2363746 | 2363746 | 2022-04-01 | Dickinson | Kansas | 20041 | 4799 | 78 |
2360492 | 2360492 | 2022-03-31 | Dickinson | Kansas | 20041 | 4797 | 77 |
2357238 | 2357238 | 2022-03-30 | Dickinson | Kansas | 20041 | 4797 | 77 |
2353985 | 2353985 | 2022-03-29 | Dickinson | Kansas | 20041 | 4796 | 75 |
2350733 | 2350733 | 2022-03-28 | Dickinson | Kansas | 20041 | 4796 | 75 |
2347480 | 2347480 | 2022-03-27 | Dickinson | Kansas | 20041 | 4796 | 75 |
2344227 | 2344227 | 2022-03-26 | Dickinson | Kansas | 20041 | 4796 | 75 |
2340974 | 2340974 | 2022-03-25 | Dickinson | Kansas | 20041 | 4796 | 75 |
2337721 | 2337721 | 2022-03-24 | Dickinson | Kansas | 20041 | 4794 | 75 |
2334467 | 2334467 | 2022-03-23 | Dickinson | Kansas | 20041 | 4794 | 75 |
2331213 | 2331213 | 2022-03-22 | Dickinson | Kansas | 20041 | 4793 | 75 |
2327961 | 2327961 | 2022-03-21 | Dickinson | Kansas | 20041 | 4793 | 75 |
2324708 | 2324708 | 2022-03-20 | Dickinson | Kansas | 20041 | 4792 | 75 |
2321454 | 2321454 | 2022-03-19 | Dickinson | Kansas | 20041 | 4792 | 75 |
2318200 | 2318200 | 2022-03-18 | Dickinson | Kansas | 20041 | 4792 | 75 |
2314947 | 2314947 | 2022-03-17 | Dickinson | Kansas | 20041 | 4790 | 74 |
2311694 | 2311694 | 2022-03-16 | Dickinson | Kansas | 20041 | 4790 | 74 |
2308441 | 2308441 | 2022-03-15 | Dickinson | Kansas | 20041 | 4790 | 73 |
2305190 | 2305190 | 2022-03-14 | Dickinson | Kansas | 20041 | 4790 | 73 |
2301938 | 2301938 | 2022-03-13 | Dickinson | Kansas | 20041 | 4789 | 73 |
2298686 | 2298686 | 2022-03-12 | Dickinson | Kansas | 20041 | 4789 | 73 |
2295434 | 2295434 | 2022-03-11 | Dickinson | Kansas | 20041 | 4789 | 73 |
2292182 | 2292182 | 2022-03-10 | Dickinson | Kansas | 20041 | 4787 | 73 |
2288930 | 2288930 | 2022-03-09 | Dickinson | Kansas | 20041 | 4787 | 73 |
2285679 | 2285679 | 2022-03-08 | Dickinson | Kansas | 20041 | 4784 | 73 |
2282427 | 2282427 | 2022-03-07 | Dickinson | Kansas | 20041 | 4784 | 73 |
2279174 | 2279174 | 2022-03-06 | Dickinson | Kansas | 20041 | 4784 | 73 |
2275921 | 2275921 | 2022-03-05 | Dickinson | Kansas | 20041 | 4784 | 73 |
2272668 | 2272668 | 2022-03-04 | Dickinson | Kansas | 20041 | 4784 | 73 |
2269416 | 2269416 | 2022-03-03 | Dickinson | Kansas | 20041 | 4781 | 73 |
2266163 | 2266163 | 2022-03-02 | Dickinson | Kansas | 20041 | 4781 | 73 |
2262912 | 2262912 | 2022-03-01 | Dickinson | Kansas | 20041 | 4780 | 73 |
2259661 | 2259661 | 2022-02-28 | Dickinson | Kansas | 20041 | 4780 | 73 |
2256410 | 2256410 | 2022-02-27 | Dickinson | Kansas | 20041 | 4775 | 73 |
2253159 | 2253159 | 2022-02-26 | Dickinson | Kansas | 20041 | 4775 | 73 |
2249908 | 2249908 | 2022-02-25 | Dickinson | Kansas | 20041 | 4775 | 73 |
2246657 | 2246657 | 2022-02-24 | Dickinson | Kansas | 20041 | 4766 | 73 |
2243406 | 2243406 | 2022-02-23 | Dickinson | Kansas | 20041 | 4766 | 73 |
2240155 | 2240155 | 2022-02-22 | Dickinson | Kansas | 20041 | 4758 | 72 |
2236904 | 2236904 | 2022-02-21 | Dickinson | Kansas | 20041 | 4758 | 72 |
2233653 | 2233653 | 2022-02-20 | Dickinson | Kansas | 20041 | 4749 | 71 |
2230402 | 2230402 | 2022-02-19 | Dickinson | Kansas | 20041 | 4749 | 71 |
2227151 | 2227151 | 2022-02-18 | Dickinson | Kansas | 20041 | 4749 | 71 |
2223900 | 2223900 | 2022-02-17 | Dickinson | Kansas | 20041 | 4743 | 71 |
2220649 | 2220649 | 2022-02-16 | Dickinson | Kansas | 20041 | 4743 | 71 |
2217398 | 2217398 | 2022-02-15 | Dickinson | Kansas | 20041 | 4723 | 70 |
2214147 | 2214147 | 2022-02-14 | Dickinson | Kansas | 20041 | 4723 | 70 |
2210895 | 2210895 | 2022-02-13 | Dickinson | Kansas | 20041 | 4696 | 70 |
2207642 | 2207642 | 2022-02-12 | Dickinson | Kansas | 20041 | 4696 | 70 |
2204389 | 2204389 | 2022-02-11 | Dickinson | Kansas | 20041 | 4696 | 70 |
2201136 | 2201136 | 2022-02-10 | Dickinson | Kansas | 20041 | 4696 | 70 |
2197882 | 2197882 | 2022-02-09 | Dickinson | Kansas | 20041 | 4696 | 70 |
2194628 | 2194628 | 2022-02-08 | Dickinson | Kansas | 20041 | 4637 | 69 |
2191374 | 2191374 | 2022-02-07 | Dickinson | Kansas | 20041 | 4637 | 69 |
2188121 | 2188121 | 2022-02-06 | Dickinson | Kansas | 20041 | 4619 | 69 |
2184868 | 2184868 | 2022-02-05 | Dickinson | Kansas | 20041 | 4619 | 69 |
2181616 | 2181616 | 2022-02-04 | Dickinson | Kansas | 20041 | 4619 | 69 |
2178365 | 2178365 | 2022-02-03 | Dickinson | Kansas | 20041 | 4592 | 67 |
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);