ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 20045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 366 ✖
- 9373 10
- 9342 7
- 14289 7
- 26281 7
- 63 6
- 25412 6
- 43 5
- 51 5
- 56 5
- 4644 5
- 8812 5
- 11002 5
- 12335 5
- 12908 5
- 13074 5
- 14853 5
- 19418 5
- 26689 5
- 27058 5
- 1 4
- 58 4
- 2411 4
- 6146 4
- 6482 4
- 7470 4
- 8005 4
- 8606 4
- 8679 4
- 8761 4
- 8870 4
- 8944 4
- 8999 4
- 9408 4
- 10411 4
- 10641 4
- 25174 4
- 25311 4
- 25616 4
- 25925 4
- 23 3
- 38 3
- 39 3
- 49 3
- 62 3
- 66 3
- 67 3
- 70 3
- 82 3
- 93 3
- 124 3
- 251 3
- 415 3
- 504 3
- 597 3
- 663 3
- 717 3
- 812 3
- 889 3
- 1303 3
- 1566 3
- 1823 3
- 1996 3
- 2174 3
- 2573 3
- 2689 3
- 2796 3
- 2961 3
- 3275 3
- 3724 3
- 4226 3
- 5113 3
- 5512 3
- 5859 3
- 7046 3
- 7818 3
- 8298 3
- 8346 3
- 8424 3
- 8548 3
- 9067 3
- 9152 3
- 9205 3
- 9236 3
- 9279 3
- 9313 3
- 9360 3
- 9382 3
- 9448 3
- 9511 3
- 9642 3
- 9745 3
- 9994 3
- 10267 3
- 11301 3
- 11543 3
- 11716 3
- 11904 3
- 12102 3
- 12244 3
- 12532 3
- 12654 3
- 12800 3
- 13160 3
- 13263 3
- 13647 3
- 14016 3
- 16906 3
- 21646 3
- 23109 3
- 23995 3
- 24630 3
- 24927 3
- 25102 3
- 25247 3
- 25284 3
- 25399 3
- 6 2
- 31 2
- 40 2
- 42 2
- 48 2
- 60 2
- 74 2
- 78 2
- 85 2
- 88 2
- 103 2
- 106 2
- 159 2
- 354 2
- 377 2
- 456 2
- 490 2
- 537 2
- 616 2
- 685 2
- 700 2
- 7617 2
- 7944 2
- 8238 2
- 8505 2
- 8581 2
- 8653 2
- 8735 2
- 8799 2
- 8841 2
- 8922 2
- 8979 2
- 9029 2
- 9042 2
- 9104 2
- 9131 2
- 9181 2
- 9194 2
- 9216 2
- 9226 2
- 9254 2
- 9264 2
- 9287 2
- 9300 2
- 9329 2
- 9334 2
- 9364 2
- 9370 2
- 9376 2
- 9379 2
- 9389 2
- 9391 2
- 9430 2
- 9458 2
- 9489 2
- 9549 2
- 9581 2
- 9685 2
- 9766 2
- 9842 2
- 9937 2
- 10070 2
- 10165 2
- 10345 2
- 10544 2
- 10781 2
- 10918 2
- 11177 2
- 11371 2
- 11485 2
- 11608 2
- 11650 2
- 11774 2
- 11841 2
- 11959 2
- 12037 2
- 12145 2
- 12162 2
- 12281 2
- 12437 2
- 12488 2
- 12564 2
- 12605 2
- 12703 2
- 12750 2
- 12839 2
- 13023 2
- 13488 2
- 13565 2
- 13757 2
- 13885 2
- 14081 2
- 15394 2
- 16120 2
- 17690 2
- 18582 2
- 20824 2
- 22048 2
- 22638 2
- 23339 2
- 23767 2
- 24211 2
- 24459 2
- 24755 2
- 24878 2
- 24978 2
- 25051 2
- 25132 2
- 25158 2
- 25233 2
- 25257 2
- 25266 2
- 25293 2
- 25349 2
- 25377 2
- 26093 2
- 26942 2
- 27259 2
- 27394 2
- 3 1
- 4 1
- 10 1
- 13 1
- 18 1
- 24 1
- 30 1
- 32 1
- 33 1
- 36 1
- 41 1
- 44 1
- 46 1
- 50 1
- 57 1
- 61 1
- 65 1
- 69 1
- 188 1
- 190 1
- 552 1
- 561 1
- 632 1
- 635 1
- 746 1
- 750 1
- 765 1
- 783 1
- 836 1
- 844 1
- 858 1
- 870 1
- 1017 1
- 1037 1
- 1196 1
- 1261 1
- 1375 1
- 1420 1
- 1473 1
- 1508 1
- 1600 1
- 1739 1
- 1772 1
- 1792 1
- 1895 1
- 1935 1
- 1952 1
- 1968 1
- 2084 1
- 2118 1
- 2135 1
- 2149 1
- 2283 1
- 2309 1
- 2340 1
- 2391 1
- 2476 1
- 2495 1
- 2524 1
- 2625 1
- 2642 1
- 2660 1
- 2681 1
- 2740 1
- 2753 1
- 2766 1
- 2784 1
- 2839 1
- 2877 1
- 2898 1
- 2927 1
- 3027 1
- 3051 1
- 3116 1
- 3196 1
- 3397 1
- 3461 1
- 3524 1
- 3636 1
- 3909 1
- 3979 1
- 4035 1
- 4104 1
- 4448 1
- 4551 1
- 4880 1
- 4928 1
- 4968 1
- 5033 1
- 5283 1
- 5326 1
- 5392 1
- 5462 1
- 5562 1
- 5632 1
- 5740 1
- 5797 1
- 5974 1
- 6018 1
- 6079 1
- 6292 1
- 6371 1
- 6428 1
- 6713 1
- 6787 1
- 6887 1
- 6974 1
- 7233 1
- 7287 1
- 7373 1
- 7440 1
- 7791 1
- 7892 1
- 8096 1
- 8276 1
- 8409 1
- 8490 1
- 8533 1
- 8570 1
- 8644 1
- 8733 1
- 8792 1
- 8902 1
- 8971 1
- 9419 1
- 10463 1
- 10719 1
- 13361 1
- 25201 1
- 25330 1
- 25482 1
state 1
- Kansas 788
fips 1
- 20045 · 788 ✖
county 1
- Douglas 788
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500495 | 2500495 | 2022-05-13 | Douglas | Kansas | 20045 | 27394 | 139 |
2497237 | 2497237 | 2022-05-12 | Douglas | Kansas | 20045 | 27394 | 139 |
2493979 | 2493979 | 2022-05-11 | Douglas | Kansas | 20045 | 27259 | 139 |
2490721 | 2490721 | 2022-05-10 | Douglas | Kansas | 20045 | 27259 | 139 |
2487464 | 2487464 | 2022-05-09 | Douglas | Kansas | 20045 | 27058 | 138 |
2484206 | 2484206 | 2022-05-08 | Douglas | Kansas | 20045 | 27058 | 138 |
2480948 | 2480948 | 2022-05-07 | Douglas | Kansas | 20045 | 27058 | 138 |
2477690 | 2477690 | 2022-05-06 | Douglas | Kansas | 20045 | 27058 | 138 |
2474432 | 2474432 | 2022-05-05 | Douglas | Kansas | 20045 | 27058 | 138 |
2471175 | 2471175 | 2022-05-04 | Douglas | Kansas | 20045 | 26942 | 138 |
2467919 | 2467919 | 2022-05-03 | Douglas | Kansas | 20045 | 26942 | 138 |
2464664 | 2464664 | 2022-05-02 | Douglas | Kansas | 20045 | 26689 | 137 |
2461408 | 2461408 | 2022-05-01 | Douglas | Kansas | 20045 | 26689 | 137 |
2458152 | 2458152 | 2022-04-30 | Douglas | Kansas | 20045 | 26689 | 137 |
2454896 | 2454896 | 2022-04-29 | Douglas | Kansas | 20045 | 26689 | 137 |
2451640 | 2451640 | 2022-04-28 | Douglas | Kansas | 20045 | 26689 | 137 |
2448384 | 2448384 | 2022-04-27 | Douglas | Kansas | 20045 | 26281 | 138 |
2445128 | 2445128 | 2022-04-26 | Douglas | Kansas | 20045 | 26281 | 138 |
2441872 | 2441872 | 2022-04-25 | Douglas | Kansas | 20045 | 26281 | 138 |
2438616 | 2438616 | 2022-04-24 | Douglas | Kansas | 20045 | 26281 | 138 |
2435360 | 2435360 | 2022-04-23 | Douglas | Kansas | 20045 | 26281 | 138 |
2432104 | 2432104 | 2022-04-22 | Douglas | Kansas | 20045 | 26281 | 138 |
2428848 | 2428848 | 2022-04-21 | Douglas | Kansas | 20045 | 26281 | 138 |
2425592 | 2425592 | 2022-04-20 | Douglas | Kansas | 20045 | 26093 | 138 |
2422336 | 2422336 | 2022-04-19 | Douglas | Kansas | 20045 | 26093 | 136 |
2419080 | 2419080 | 2022-04-18 | Douglas | Kansas | 20045 | 25925 | 136 |
2415824 | 2415824 | 2022-04-17 | Douglas | Kansas | 20045 | 25925 | 136 |
2412568 | 2412568 | 2022-04-16 | Douglas | Kansas | 20045 | 25925 | 136 |
2409312 | 2409312 | 2022-04-15 | Douglas | Kansas | 20045 | 25925 | 136 |
2406056 | 2406056 | 2022-04-14 | Douglas | Kansas | 20045 | 25616 | 136 |
2402800 | 2402800 | 2022-04-13 | Douglas | Kansas | 20045 | 25616 | 136 |
2399546 | 2399546 | 2022-04-12 | Douglas | Kansas | 20045 | 25616 | 136 |
2396290 | 2396290 | 2022-04-11 | Douglas | Kansas | 20045 | 25616 | 136 |
2393035 | 2393035 | 2022-04-10 | Douglas | Kansas | 20045 | 25482 | 136 |
2389779 | 2389779 | 2022-04-09 | Douglas | Kansas | 20045 | 25412 | 136 |
2386523 | 2386523 | 2022-04-08 | Douglas | Kansas | 20045 | 25412 | 136 |
2383269 | 2383269 | 2022-04-07 | Douglas | Kansas | 20045 | 25412 | 136 |
2380014 | 2380014 | 2022-04-06 | Douglas | Kansas | 20045 | 25412 | 136 |
2376759 | 2376759 | 2022-04-05 | Douglas | Kansas | 20045 | 25412 | 136 |
2373507 | 2373507 | 2022-04-04 | Douglas | Kansas | 20045 | 25412 | 136 |
2370254 | 2370254 | 2022-04-03 | Douglas | Kansas | 20045 | 25399 | 136 |
2367001 | 2367001 | 2022-04-02 | Douglas | Kansas | 20045 | 25399 | 136 |
2363748 | 2363748 | 2022-04-01 | Douglas | Kansas | 20045 | 25399 | 136 |
2360494 | 2360494 | 2022-03-31 | Douglas | Kansas | 20045 | 25377 | 135 |
2357240 | 2357240 | 2022-03-30 | Douglas | Kansas | 20045 | 25377 | 135 |
2353987 | 2353987 | 2022-03-29 | Douglas | Kansas | 20045 | 25349 | 134 |
2350735 | 2350735 | 2022-03-28 | Douglas | Kansas | 20045 | 25349 | 134 |
2347482 | 2347482 | 2022-03-27 | Douglas | Kansas | 20045 | 25330 | 134 |
2344229 | 2344229 | 2022-03-26 | Douglas | Kansas | 20045 | 25311 | 134 |
2340976 | 2340976 | 2022-03-25 | Douglas | Kansas | 20045 | 25311 | 134 |
2337723 | 2337723 | 2022-03-24 | Douglas | Kansas | 20045 | 25311 | 134 |
2334469 | 2334469 | 2022-03-23 | Douglas | Kansas | 20045 | 25311 | 134 |
2331215 | 2331215 | 2022-03-22 | Douglas | Kansas | 20045 | 25293 | 134 |
2327963 | 2327963 | 2022-03-21 | Douglas | Kansas | 20045 | 25293 | 134 |
2324710 | 2324710 | 2022-03-20 | Douglas | Kansas | 20045 | 25284 | 134 |
2321456 | 2321456 | 2022-03-19 | Douglas | Kansas | 20045 | 25284 | 134 |
2318202 | 2318202 | 2022-03-18 | Douglas | Kansas | 20045 | 25284 | 134 |
2314949 | 2314949 | 2022-03-17 | Douglas | Kansas | 20045 | 25266 | 133 |
2311696 | 2311696 | 2022-03-16 | Douglas | Kansas | 20045 | 25266 | 133 |
2308443 | 2308443 | 2022-03-15 | Douglas | Kansas | 20045 | 25257 | 131 |
2305192 | 2305192 | 2022-03-14 | Douglas | Kansas | 20045 | 25257 | 131 |
2301940 | 2301940 | 2022-03-13 | Douglas | Kansas | 20045 | 25247 | 131 |
2298688 | 2298688 | 2022-03-12 | Douglas | Kansas | 20045 | 25247 | 131 |
2295436 | 2295436 | 2022-03-11 | Douglas | Kansas | 20045 | 25247 | 131 |
2292184 | 2292184 | 2022-03-10 | Douglas | Kansas | 20045 | 25233 | 131 |
2288932 | 2288932 | 2022-03-09 | Douglas | Kansas | 20045 | 25233 | 131 |
2285681 | 2285681 | 2022-03-08 | Douglas | Kansas | 20045 | 25201 | 131 |
2282429 | 2282429 | 2022-03-07 | Douglas | Kansas | 20045 | 25174 | 131 |
2279176 | 2279176 | 2022-03-06 | Douglas | Kansas | 20045 | 25174 | 131 |
2275923 | 2275923 | 2022-03-05 | Douglas | Kansas | 20045 | 25174 | 131 |
2272670 | 2272670 | 2022-03-04 | Douglas | Kansas | 20045 | 25174 | 131 |
2269418 | 2269418 | 2022-03-03 | Douglas | Kansas | 20045 | 25158 | 131 |
2266165 | 2266165 | 2022-03-02 | Douglas | Kansas | 20045 | 25158 | 131 |
2262914 | 2262914 | 2022-03-01 | Douglas | Kansas | 20045 | 25132 | 130 |
2259663 | 2259663 | 2022-02-28 | Douglas | Kansas | 20045 | 25132 | 130 |
2256412 | 2256412 | 2022-02-27 | Douglas | Kansas | 20045 | 25102 | 130 |
2253161 | 2253161 | 2022-02-26 | Douglas | Kansas | 20045 | 25102 | 130 |
2249910 | 2249910 | 2022-02-25 | Douglas | Kansas | 20045 | 25102 | 130 |
2246659 | 2246659 | 2022-02-24 | Douglas | Kansas | 20045 | 25051 | 130 |
2243408 | 2243408 | 2022-02-23 | Douglas | Kansas | 20045 | 25051 | 130 |
2240157 | 2240157 | 2022-02-22 | Douglas | Kansas | 20045 | 24978 | 130 |
2236906 | 2236906 | 2022-02-21 | Douglas | Kansas | 20045 | 24978 | 130 |
2233655 | 2233655 | 2022-02-20 | Douglas | Kansas | 20045 | 24927 | 130 |
2230404 | 2230404 | 2022-02-19 | Douglas | Kansas | 20045 | 24927 | 130 |
2227153 | 2227153 | 2022-02-18 | Douglas | Kansas | 20045 | 24927 | 130 |
2223902 | 2223902 | 2022-02-17 | Douglas | Kansas | 20045 | 24878 | 131 |
2220651 | 2220651 | 2022-02-16 | Douglas | Kansas | 20045 | 24878 | 131 |
2217400 | 2217400 | 2022-02-15 | Douglas | Kansas | 20045 | 24755 | 129 |
2214149 | 2214149 | 2022-02-14 | Douglas | Kansas | 20045 | 24755 | 129 |
2210897 | 2210897 | 2022-02-13 | Douglas | Kansas | 20045 | 24630 | 129 |
2207644 | 2207644 | 2022-02-12 | Douglas | Kansas | 20045 | 24630 | 129 |
2204391 | 2204391 | 2022-02-11 | Douglas | Kansas | 20045 | 24630 | 129 |
2201138 | 2201138 | 2022-02-10 | Douglas | Kansas | 20045 | 24459 | 129 |
2197884 | 2197884 | 2022-02-09 | Douglas | Kansas | 20045 | 24459 | 129 |
2194630 | 2194630 | 2022-02-08 | Douglas | Kansas | 20045 | 24211 | 129 |
2191376 | 2191376 | 2022-02-07 | Douglas | Kansas | 20045 | 24211 | 129 |
2188123 | 2188123 | 2022-02-06 | Douglas | Kansas | 20045 | 23995 | 129 |
2184870 | 2184870 | 2022-02-05 | Douglas | Kansas | 20045 | 23995 | 129 |
2181618 | 2181618 | 2022-02-04 | Douglas | Kansas | 20045 | 23995 | 129 |
2178367 | 2178367 | 2022-02-03 | Douglas | Kansas | 20045 | 23767 | 128 |
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);