ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and fips = 20059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 288 ✖
- 12 17
- 1 13
- 32 10
- 2578 10
- 2589 9
- 6913 9
- 6899 7
- 6915 7
- 6929 7
- 6939 7
- 6954 7
- 6979 7
- 7004 7
- 35 6
- 10 5
- 34 5
- 49 5
- 90 5
- 1594 5
- 2483 5
- 2495 5
- 2507 5
- 2563 5
- 2572 5
- 2582 5
- 2605 5
- 3212 5
- 4032 5
- 4539 5
- 4773 5
- 5832 5
- 6778 5
- 6911 5
- 20 4
- 278 4
- 2646 4
- 6 3
- 9 3
- 57 3
- 67 3
- 78 3
- 115 3
- 135 3
- 150 3
- 183 3
- 245 3
- 258 3
- 271 3
- 280 3
- 306 3
- 349 3
- 411 3
- 444 3
- 486 3
- 524 3
- 594 3
- 679 3
- 824 3
- 949 3
- 1093 3
- 1178 3
- 1363 3
- 1486 3
- 1835 3
- 2001 3
- 2072 3
- 2188 3
- 2264 3
- 2340 3
- 2378 3
- 2415 3
- 2432 3
- 2456 3
- 2472 3
- 2489 3
- 2518 3
- 2536 3
- 2544 3
- 2551 3
- 2588 3
- 2636 3
- 2696 3
- 2738 3
- 2824 3
- 2897 3
- 2960 3
- 3032 3
- 3089 3
- 3324 3
- 3427 3
- 3544 3
- 3634 3
- 3692 3
- 3724 3
- 3754 3
- 3798 3
- 3864 3
- 3923 3
- 3989 3
- 4151 3
- 4291 3
- 4421 3
- 5278 3
- 6308 3
- 6555 3
- 6716 3
- 6836 3
- 6884 3
- 6905 3
- 7 2
- 13 2
- 14 2
- 19 2
- 30 2
- 38 2
- 39 2
- 51 2
- 53 2
- 65 2
- 66 2
- 71 2
- 81 2
- 96 2
- 104 2
- 118 2
- 124 2
- 142 2
- 147 2
- 159 2
- 177 2
- 199 2
- 212 2
- 222 2
- 239 2
- 243 2
- 250 2
- 255 2
- 264 2
- 267 2
- 286 2
- 294 2
- 330 2
- 377 2
- 393 2
- 431 2
- 435 2
- 469 2
- 473 2
- 500 2
- 508 2
- 561 2
- 621 2
- 648 2
- 761 2
- 790 2
- 887 2
- 919 2
- 1022 2
- 1048 2
- 1115 2
- 1146 2
- 1270 2
- 1310 2
- 1412 2
- 1453 2
- 1534 2
- 1703 2
- 1757 2
- 1883 2
- 1942 2
- 2038 2
- 2059 2
- 2102 2
- 2162 2
- 2204 2
- 2244 2
- 2296 2
- 2319 2
- 2347 2
- 2369 2
- 2396 2
- 2409 2
- 2423 2
- 2428 2
- 2438 2
- 2446 2
- 2460 2
- 2470 2
- 2482 2
- 2485 2
- 2488 2
- 2490 2
- 2500 2
- 2503 2
- 2513 2
- 2526 2
- 2528 2
- 2540 2
- 2542 2
- 2547 2
- 2550 2
- 2555 2
- 2556 2
- 2574 2
- 2576 2
- 2579 2
- 2585 2
- 2587 2
- 2601 2
- 2620 2
- 2710 2
- 2724 2
- 2766 2
- 2796 2
- 2842 2
- 2874 2
- 2914 2
- 2931 2
- 2991 2
- 3021 2
- 3069 2
- 3078 2
- 3124 2
- 3176 2
- 3280 2
- 3350 2
- 3405 2
- 3459 2
- 3493 2
- 3568 2
- 3614 2
- 3656 2
- 3674 2
- 3699 2
- 3713 2
- 3732 2
- 3745 2
- 3755 2
- 3773 2
- 3806 2
- 3839 2
- 3885 2
- 3909 2
- 3937 2
- 3967 2
- 4009 2
- 4062 2
- 4112 2
- 4193 2
- 4229 2
- 4325 2
- 4376 2
- 4462 2
- 4663 2
- 5000 2
- 5123 2
- 5399 2
- 5628 2
- 6154 2
- 6401 2
- 6483 2
- 6606 2
- 6681 2
- 6745 2
- 6815 2
- 6826 2
- 6844 2
- 6877 2
- 6890 2
- 6903 2
- 6907 2
- 6909 2
- 2 1
- 8 1
- 16 1
- 17 1
- 23 1
- 26 1
- 29 1
- 33 1
- 72 1
- 77 1
- 226 1
- 321 1
- 322 1
- 526 1
- 533 1
- 7018 1
state 1
- Kansas 791
fips 1
- 20059 · 791 ✖
county 1
- Franklin · 791 ✖
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);