ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" 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 |
---|---|---|---|---|---|---|---|
2500502 | 2500502 | 2022-05-13 | Franklin | Kansas | 20059 | 7018 | 81 |
2497244 | 2497244 | 2022-05-12 | Franklin | Kansas | 20059 | 7004 | 81 |
2493986 | 2493986 | 2022-05-11 | Franklin | Kansas | 20059 | 7004 | 81 |
2490728 | 2490728 | 2022-05-10 | Franklin | Kansas | 20059 | 7004 | 81 |
2487471 | 2487471 | 2022-05-09 | Franklin | Kansas | 20059 | 7004 | 81 |
2484213 | 2484213 | 2022-05-08 | Franklin | Kansas | 20059 | 7004 | 81 |
2480955 | 2480955 | 2022-05-07 | Franklin | Kansas | 20059 | 7004 | 81 |
2477697 | 2477697 | 2022-05-06 | Franklin | Kansas | 20059 | 7004 | 81 |
2474439 | 2474439 | 2022-05-05 | Franklin | Kansas | 20059 | 6979 | 81 |
2471182 | 2471182 | 2022-05-04 | Franklin | Kansas | 20059 | 6979 | 81 |
2467926 | 2467926 | 2022-05-03 | Franklin | Kansas | 20059 | 6979 | 81 |
2464671 | 2464671 | 2022-05-02 | Franklin | Kansas | 20059 | 6979 | 81 |
2461415 | 2461415 | 2022-05-01 | Franklin | Kansas | 20059 | 6979 | 81 |
2458159 | 2458159 | 2022-04-30 | Franklin | Kansas | 20059 | 6979 | 81 |
2454903 | 2454903 | 2022-04-29 | Franklin | Kansas | 20059 | 6979 | 81 |
2451647 | 2451647 | 2022-04-28 | Franklin | Kansas | 20059 | 6954 | 81 |
2448391 | 2448391 | 2022-04-27 | Franklin | Kansas | 20059 | 6954 | 81 |
2445135 | 2445135 | 2022-04-26 | Franklin | Kansas | 20059 | 6954 | 81 |
2441879 | 2441879 | 2022-04-25 | Franklin | Kansas | 20059 | 6954 | 81 |
2438623 | 2438623 | 2022-04-24 | Franklin | Kansas | 20059 | 6954 | 81 |
2435367 | 2435367 | 2022-04-23 | Franklin | Kansas | 20059 | 6954 | 81 |
2432111 | 2432111 | 2022-04-22 | Franklin | Kansas | 20059 | 6954 | 81 |
2428855 | 2428855 | 2022-04-21 | Franklin | Kansas | 20059 | 6939 | 81 |
2425599 | 2425599 | 2022-04-20 | Franklin | Kansas | 20059 | 6939 | 81 |
2422343 | 2422343 | 2022-04-19 | Franklin | Kansas | 20059 | 6939 | 81 |
2419087 | 2419087 | 2022-04-18 | Franklin | Kansas | 20059 | 6939 | 81 |
2415831 | 2415831 | 2022-04-17 | Franklin | Kansas | 20059 | 6939 | 81 |
2412575 | 2412575 | 2022-04-16 | Franklin | Kansas | 20059 | 6939 | 81 |
2409319 | 2409319 | 2022-04-15 | Franklin | Kansas | 20059 | 6939 | 81 |
2406063 | 2406063 | 2022-04-14 | Franklin | Kansas | 20059 | 6929 | 81 |
2402807 | 2402807 | 2022-04-13 | Franklin | Kansas | 20059 | 6929 | 81 |
2399553 | 2399553 | 2022-04-12 | Franklin | Kansas | 20059 | 6929 | 81 |
2396297 | 2396297 | 2022-04-11 | Franklin | Kansas | 20059 | 6929 | 81 |
2393042 | 2393042 | 2022-04-10 | Franklin | Kansas | 20059 | 6929 | 81 |
2389786 | 2389786 | 2022-04-09 | Franklin | Kansas | 20059 | 6929 | 81 |
2386530 | 2386530 | 2022-04-08 | Franklin | Kansas | 20059 | 6929 | 81 |
2383276 | 2383276 | 2022-04-07 | Franklin | Kansas | 20059 | 6915 | 81 |
2380021 | 2380021 | 2022-04-06 | Franklin | Kansas | 20059 | 6915 | 81 |
2376766 | 2376766 | 2022-04-05 | Franklin | Kansas | 20059 | 6915 | 81 |
2373514 | 2373514 | 2022-04-04 | Franklin | Kansas | 20059 | 6915 | 81 |
2370261 | 2370261 | 2022-04-03 | Franklin | Kansas | 20059 | 6915 | 81 |
2367008 | 2367008 | 2022-04-02 | Franklin | Kansas | 20059 | 6915 | 81 |
2363755 | 2363755 | 2022-04-01 | Franklin | Kansas | 20059 | 6915 | 81 |
2360501 | 2360501 | 2022-03-31 | Franklin | Kansas | 20059 | 6913 | 79 |
2357247 | 2357247 | 2022-03-30 | Franklin | Kansas | 20059 | 6913 | 79 |
2353994 | 2353994 | 2022-03-29 | Franklin | Kansas | 20059 | 6913 | 77 |
2350742 | 2350742 | 2022-03-28 | Franklin | Kansas | 20059 | 6913 | 77 |
2347489 | 2347489 | 2022-03-27 | Franklin | Kansas | 20059 | 6913 | 77 |
2344236 | 2344236 | 2022-03-26 | Franklin | Kansas | 20059 | 6913 | 77 |
2340983 | 2340983 | 2022-03-25 | Franklin | Kansas | 20059 | 6913 | 77 |
2337730 | 2337730 | 2022-03-24 | Franklin | Kansas | 20059 | 6913 | 77 |
2334476 | 2334476 | 2022-03-23 | Franklin | Kansas | 20059 | 6913 | 77 |
2331222 | 2331222 | 2022-03-22 | Franklin | Kansas | 20059 | 6911 | 77 |
2327970 | 2327970 | 2022-03-21 | Franklin | Kansas | 20059 | 6911 | 77 |
2324717 | 2324717 | 2022-03-20 | Franklin | Kansas | 20059 | 6911 | 77 |
2321463 | 2321463 | 2022-03-19 | Franklin | Kansas | 20059 | 6911 | 77 |
2318209 | 2318209 | 2022-03-18 | Franklin | Kansas | 20059 | 6911 | 77 |
2314956 | 2314956 | 2022-03-17 | Franklin | Kansas | 20059 | 6909 | 77 |
2311703 | 2311703 | 2022-03-16 | Franklin | Kansas | 20059 | 6909 | 77 |
2308450 | 2308450 | 2022-03-15 | Franklin | Kansas | 20059 | 6907 | 76 |
2305199 | 2305199 | 2022-03-14 | Franklin | Kansas | 20059 | 6907 | 76 |
2301947 | 2301947 | 2022-03-13 | Franklin | Kansas | 20059 | 6905 | 76 |
2298695 | 2298695 | 2022-03-12 | Franklin | Kansas | 20059 | 6905 | 76 |
2295443 | 2295443 | 2022-03-11 | Franklin | Kansas | 20059 | 6905 | 76 |
2292191 | 2292191 | 2022-03-10 | Franklin | Kansas | 20059 | 6903 | 77 |
2288939 | 2288939 | 2022-03-09 | Franklin | Kansas | 20059 | 6903 | 77 |
2285688 | 2285688 | 2022-03-08 | Franklin | Kansas | 20059 | 6899 | 77 |
2282436 | 2282436 | 2022-03-07 | Franklin | Kansas | 20059 | 6899 | 77 |
2279183 | 2279183 | 2022-03-06 | Franklin | Kansas | 20059 | 6899 | 77 |
2275930 | 2275930 | 2022-03-05 | Franklin | Kansas | 20059 | 6899 | 77 |
2272677 | 2272677 | 2022-03-04 | Franklin | Kansas | 20059 | 6899 | 77 |
2269425 | 2269425 | 2022-03-03 | Franklin | Kansas | 20059 | 6899 | 77 |
2266172 | 2266172 | 2022-03-02 | Franklin | Kansas | 20059 | 6899 | 77 |
2262921 | 2262921 | 2022-03-01 | Franklin | Kansas | 20059 | 6890 | 77 |
2259670 | 2259670 | 2022-02-28 | Franklin | Kansas | 20059 | 6890 | 77 |
2256419 | 2256419 | 2022-02-27 | Franklin | Kansas | 20059 | 6884 | 77 |
2253168 | 2253168 | 2022-02-26 | Franklin | Kansas | 20059 | 6884 | 77 |
2249917 | 2249917 | 2022-02-25 | Franklin | Kansas | 20059 | 6884 | 77 |
2246666 | 2246666 | 2022-02-24 | Franklin | Kansas | 20059 | 6877 | 77 |
2243415 | 2243415 | 2022-02-23 | Franklin | Kansas | 20059 | 6877 | 77 |
2240164 | 2240164 | 2022-02-22 | Franklin | Kansas | 20059 | 6844 | 75 |
2236913 | 2236913 | 2022-02-21 | Franklin | Kansas | 20059 | 6844 | 75 |
2233662 | 2233662 | 2022-02-20 | Franklin | Kansas | 20059 | 6836 | 75 |
2230411 | 2230411 | 2022-02-19 | Franklin | Kansas | 20059 | 6836 | 75 |
2227160 | 2227160 | 2022-02-18 | Franklin | Kansas | 20059 | 6836 | 75 |
2223909 | 2223909 | 2022-02-17 | Franklin | Kansas | 20059 | 6826 | 75 |
2220658 | 2220658 | 2022-02-16 | Franklin | Kansas | 20059 | 6826 | 76 |
2217407 | 2217407 | 2022-02-15 | Franklin | Kansas | 20059 | 6815 | 76 |
2214156 | 2214156 | 2022-02-14 | Franklin | Kansas | 20059 | 6815 | 76 |
2210904 | 2210904 | 2022-02-13 | Franklin | Kansas | 20059 | 6778 | 76 |
2207651 | 2207651 | 2022-02-12 | Franklin | Kansas | 20059 | 6778 | 76 |
2204398 | 2204398 | 2022-02-11 | Franklin | Kansas | 20059 | 6778 | 76 |
2201145 | 2201145 | 2022-02-10 | Franklin | Kansas | 20059 | 6778 | 76 |
2197891 | 2197891 | 2022-02-09 | Franklin | Kansas | 20059 | 6778 | 76 |
2194637 | 2194637 | 2022-02-08 | Franklin | Kansas | 20059 | 6745 | 76 |
2191383 | 2191383 | 2022-02-07 | Franklin | Kansas | 20059 | 6745 | 76 |
2188130 | 2188130 | 2022-02-06 | Franklin | Kansas | 20059 | 6716 | 76 |
2184877 | 2184877 | 2022-02-05 | Franklin | Kansas | 20059 | 6716 | 76 |
2181625 | 2181625 | 2022-02-04 | Franklin | Kansas | 20059 | 6716 | 76 |
2178374 | 2178374 | 2022-02-03 | Franklin | Kansas | 20059 | 6681 | 76 |
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);