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 state
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 |
---|---|---|---|---|---|---|---|
3399 | 3399 | 2020-03-17 | Douglas | Kansas | 20045 | 1 | 0 |
3975 | 3975 | 2020-03-18 | Douglas | Kansas | 20045 | 1 | 0 |
4657 | 4657 | 2020-03-19 | Douglas | Kansas | 20045 | 1 | 0 |
5468 | 5468 | 2020-03-20 | Douglas | Kansas | 20045 | 1 | 0 |
6413 | 6413 | 2020-03-21 | Douglas | Kansas | 20045 | 3 | 0 |
7480 | 7480 | 2020-03-22 | Douglas | Kansas | 20045 | 4 | 0 |
8641 | 8641 | 2020-03-23 | Douglas | Kansas | 20045 | 6 | 0 |
9922 | 9922 | 2020-03-24 | Douglas | Kansas | 20045 | 6 | 0 |
11320 | 11320 | 2020-03-25 | Douglas | Kansas | 20045 | 10 | 0 |
12887 | 12887 | 2020-03-26 | Douglas | Kansas | 20045 | 13 | 0 |
14585 | 14585 | 2020-03-27 | Douglas | Kansas | 20045 | 18 | 0 |
16392 | 16392 | 2020-03-28 | Douglas | Kansas | 20045 | 23 | 0 |
18297 | 18297 | 2020-03-29 | Douglas | Kansas | 20045 | 23 | 0 |
20310 | 20310 | 2020-03-30 | Douglas | Kansas | 20045 | 23 | 0 |
22408 | 22408 | 2020-03-31 | Douglas | Kansas | 20045 | 24 | 0 |
24583 | 24583 | 2020-04-01 | Douglas | Kansas | 20045 | 30 | 0 |
26827 | 26827 | 2020-04-02 | Douglas | Kansas | 20045 | 31 | 0 |
29141 | 29141 | 2020-04-03 | Douglas | Kansas | 20045 | 31 | 0 |
31513 | 31513 | 2020-04-04 | Douglas | Kansas | 20045 | 32 | 0 |
33926 | 33926 | 2020-04-05 | Douglas | Kansas | 20045 | 33 | 0 |
36383 | 36383 | 2020-04-06 | Douglas | Kansas | 20045 | 36 | 0 |
38885 | 38885 | 2020-04-07 | Douglas | Kansas | 20045 | 38 | 0 |
41432 | 41432 | 2020-04-08 | Douglas | Kansas | 20045 | 38 | 0 |
44008 | 44008 | 2020-04-09 | Douglas | Kansas | 20045 | 38 | 0 |
46615 | 46615 | 2020-04-10 | Douglas | Kansas | 20045 | 39 | 0 |
49249 | 49249 | 2020-04-11 | Douglas | Kansas | 20045 | 39 | 0 |
51913 | 51913 | 2020-04-12 | Douglas | Kansas | 20045 | 39 | 0 |
54595 | 54595 | 2020-04-13 | Douglas | Kansas | 20045 | 40 | 0 |
57289 | 57289 | 2020-04-14 | Douglas | Kansas | 20045 | 40 | 0 |
59997 | 59997 | 2020-04-15 | Douglas | Kansas | 20045 | 41 | 0 |
62718 | 62718 | 2020-04-16 | Douglas | Kansas | 20045 | 42 | 0 |
65454 | 65454 | 2020-04-17 | Douglas | Kansas | 20045 | 42 | 0 |
68203 | 68203 | 2020-04-18 | Douglas | Kansas | 20045 | 43 | 0 |
70964 | 70964 | 2020-04-19 | Douglas | Kansas | 20045 | 43 | 0 |
73735 | 73735 | 2020-04-20 | Douglas | Kansas | 20045 | 43 | 0 |
76515 | 76515 | 2020-04-21 | Douglas | Kansas | 20045 | 43 | 0 |
79299 | 79299 | 2020-04-22 | Douglas | Kansas | 20045 | 43 | 0 |
82092 | 82092 | 2020-04-23 | Douglas | Kansas | 20045 | 44 | 0 |
84893 | 84893 | 2020-04-24 | Douglas | Kansas | 20045 | 46 | 0 |
87702 | 87702 | 2020-04-25 | Douglas | Kansas | 20045 | 48 | 0 |
90518 | 90518 | 2020-04-26 | Douglas | Kansas | 20045 | 48 | 0 |
93339 | 93339 | 2020-04-27 | Douglas | Kansas | 20045 | 49 | 0 |
96171 | 96171 | 2020-04-28 | Douglas | Kansas | 20045 | 49 | 0 |
99017 | 99017 | 2020-04-29 | Douglas | Kansas | 20045 | 49 | 0 |
101868 | 101868 | 2020-04-30 | Douglas | Kansas | 20045 | 50 | 0 |
104728 | 104728 | 2020-05-01 | Douglas | Kansas | 20045 | 51 | 0 |
107593 | 107593 | 2020-05-02 | Douglas | Kansas | 20045 | 51 | 0 |
110464 | 110464 | 2020-05-03 | Douglas | Kansas | 20045 | 51 | 0 |
113340 | 113340 | 2020-05-04 | Douglas | Kansas | 20045 | 51 | 0 |
116222 | 116222 | 2020-05-05 | Douglas | Kansas | 20045 | 51 | 0 |
119183 | 119183 | 2020-05-06 | Douglas | Kansas | 20045 | 56 | 0 |
122153 | 122153 | 2020-05-07 | Douglas | Kansas | 20045 | 56 | 0 |
125135 | 125135 | 2020-05-08 | Douglas | Kansas | 20045 | 56 | 0 |
128123 | 128123 | 2020-05-09 | Douglas | Kansas | 20045 | 56 | 0 |
131113 | 131113 | 2020-05-10 | Douglas | Kansas | 20045 | 56 | 0 |
134104 | 134104 | 2020-05-11 | Douglas | Kansas | 20045 | 57 | 0 |
137094 | 137094 | 2020-05-12 | Douglas | Kansas | 20045 | 58 | 0 |
140087 | 140087 | 2020-05-13 | Douglas | Kansas | 20045 | 58 | 0 |
143083 | 143083 | 2020-05-14 | Douglas | Kansas | 20045 | 58 | 0 |
146083 | 146083 | 2020-05-15 | Douglas | Kansas | 20045 | 58 | 0 |
149087 | 149087 | 2020-05-16 | Douglas | Kansas | 20045 | 60 | 0 |
152098 | 152098 | 2020-05-17 | Douglas | Kansas | 20045 | 60 | 0 |
155110 | 155110 | 2020-05-18 | Douglas | Kansas | 20045 | 61 | 0 |
158127 | 158127 | 2020-05-19 | Douglas | Kansas | 20045 | 62 | 0 |
161152 | 161152 | 2020-05-20 | Douglas | Kansas | 20045 | 62 | 0 |
164181 | 164181 | 2020-05-21 | Douglas | Kansas | 20045 | 62 | 0 |
167214 | 167214 | 2020-05-22 | Douglas | Kansas | 20045 | 63 | 0 |
170252 | 170252 | 2020-05-23 | Douglas | Kansas | 20045 | 63 | 0 |
173293 | 173293 | 2020-05-24 | Douglas | Kansas | 20045 | 63 | 0 |
176337 | 176337 | 2020-05-25 | Douglas | Kansas | 20045 | 63 | 0 |
179381 | 179381 | 2020-05-26 | Douglas | Kansas | 20045 | 63 | 0 |
182426 | 182426 | 2020-05-27 | Douglas | Kansas | 20045 | 63 | 0 |
185480 | 185480 | 2020-05-28 | Douglas | Kansas | 20045 | 65 | 0 |
188538 | 188538 | 2020-05-29 | Douglas | Kansas | 20045 | 66 | 0 |
191602 | 191602 | 2020-05-30 | Douglas | Kansas | 20045 | 66 | 0 |
194670 | 194670 | 2020-05-31 | Douglas | Kansas | 20045 | 66 | 0 |
197740 | 197740 | 2020-06-01 | Douglas | Kansas | 20045 | 67 | 0 |
200812 | 200812 | 2020-06-02 | Douglas | Kansas | 20045 | 67 | 0 |
203888 | 203888 | 2020-06-03 | Douglas | Kansas | 20045 | 67 | 0 |
206969 | 206969 | 2020-06-04 | Douglas | Kansas | 20045 | 69 | 0 |
210050 | 210050 | 2020-06-05 | Douglas | Kansas | 20045 | 70 | 0 |
213135 | 213135 | 2020-06-06 | Douglas | Kansas | 20045 | 70 | 0 |
216222 | 216222 | 2020-06-07 | Douglas | Kansas | 20045 | 70 | 0 |
219314 | 219314 | 2020-06-08 | Douglas | Kansas | 20045 | 74 | 0 |
222409 | 222409 | 2020-06-09 | Douglas | Kansas | 20045 | 74 | 0 |
225504 | 225504 | 2020-06-10 | Douglas | Kansas | 20045 | 78 | 0 |
228606 | 228606 | 2020-06-11 | Douglas | Kansas | 20045 | 78 | 0 |
231709 | 231709 | 2020-06-12 | Douglas | Kansas | 20045 | 82 | 0 |
234815 | 234815 | 2020-06-13 | Douglas | Kansas | 20045 | 82 | 0 |
237922 | 237922 | 2020-06-14 | Douglas | Kansas | 20045 | 82 | 0 |
241031 | 241031 | 2020-06-15 | Douglas | Kansas | 20045 | 85 | 0 |
244142 | 244142 | 2020-06-16 | Douglas | Kansas | 20045 | 85 | 0 |
247255 | 247255 | 2020-06-17 | Douglas | Kansas | 20045 | 88 | 0 |
250367 | 250367 | 2020-06-18 | Douglas | Kansas | 20045 | 88 | 0 |
253482 | 253482 | 2020-06-19 | Douglas | Kansas | 20045 | 93 | 0 |
256602 | 256602 | 2020-06-20 | Douglas | Kansas | 20045 | 93 | 0 |
259728 | 259728 | 2020-06-21 | Douglas | Kansas | 20045 | 93 | 0 |
262855 | 262855 | 2020-06-22 | Douglas | Kansas | 20045 | 103 | 0 |
265983 | 265983 | 2020-06-23 | Douglas | Kansas | 20045 | 103 | 0 |
269113 | 269113 | 2020-06-24 | Douglas | Kansas | 20045 | 106 | 0 |
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);