ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Douglas" and fips = 20045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386852 | 386852 | 2020-07-31 | Douglas | Kansas | 20045 | 663 | 3 |
383634 | 383634 | 2020-07-30 | Douglas | Kansas | 20045 | 635 | 3 |
380417 | 380417 | 2020-07-29 | Douglas | Kansas | 20045 | 632 | 3 |
377200 | 377200 | 2020-07-28 | Douglas | Kansas | 20045 | 616 | 2 |
373985 | 373985 | 2020-07-27 | Douglas | Kansas | 20045 | 616 | 2 |
370773 | 370773 | 2020-07-26 | Douglas | Kansas | 20045 | 597 | 2 |
367563 | 367563 | 2020-07-25 | Douglas | Kansas | 20045 | 597 | 2 |
364356 | 364356 | 2020-07-24 | Douglas | Kansas | 20045 | 597 | 2 |
361149 | 361149 | 2020-07-23 | Douglas | Kansas | 20045 | 561 | 2 |
357944 | 357944 | 2020-07-22 | Douglas | Kansas | 20045 | 552 | 2 |
354742 | 354742 | 2020-07-21 | Douglas | Kansas | 20045 | 537 | 0 |
351540 | 351540 | 2020-07-20 | Douglas | Kansas | 20045 | 537 | 0 |
348340 | 348340 | 2020-07-19 | Douglas | Kansas | 20045 | 504 | 0 |
345139 | 345139 | 2020-07-18 | Douglas | Kansas | 20045 | 504 | 0 |
341939 | 341939 | 2020-07-17 | Douglas | Kansas | 20045 | 504 | 0 |
338743 | 338743 | 2020-07-16 | Douglas | Kansas | 20045 | 490 | 0 |
335547 | 335547 | 2020-07-15 | Douglas | Kansas | 20045 | 490 | 0 |
332354 | 332354 | 2020-07-14 | Douglas | Kansas | 20045 | 456 | 0 |
329167 | 329167 | 2020-07-13 | Douglas | Kansas | 20045 | 456 | 0 |
325981 | 325981 | 2020-07-12 | Douglas | Kansas | 20045 | 415 | 0 |
322799 | 322799 | 2020-07-11 | Douglas | Kansas | 20045 | 415 | 0 |
319620 | 319620 | 2020-07-10 | Douglas | Kansas | 20045 | 415 | 0 |
316447 | 316447 | 2020-07-09 | Douglas | Kansas | 20045 | 377 | 0 |
313273 | 313273 | 2020-07-08 | Douglas | Kansas | 20045 | 377 | 0 |
310103 | 310103 | 2020-07-07 | Douglas | Kansas | 20045 | 354 | 0 |
306935 | 306935 | 2020-07-06 | Douglas | Kansas | 20045 | 354 | 0 |
303770 | 303770 | 2020-07-05 | Douglas | Kansas | 20045 | 251 | 0 |
300606 | 300606 | 2020-07-04 | Douglas | Kansas | 20045 | 251 | 0 |
297444 | 297444 | 2020-07-03 | Douglas | Kansas | 20045 | 251 | 0 |
294286 | 294286 | 2020-07-02 | Douglas | Kansas | 20045 | 190 | 0 |
291132 | 291132 | 2020-07-01 | Douglas | Kansas | 20045 | 188 | 0 |
287982 | 287982 | 2020-06-30 | Douglas | Kansas | 20045 | 159 | 0 |
284833 | 284833 | 2020-06-29 | Douglas | Kansas | 20045 | 159 | 0 |
281688 | 281688 | 2020-06-28 | Douglas | Kansas | 20045 | 124 | 0 |
278540 | 278540 | 2020-06-27 | Douglas | Kansas | 20045 | 124 | 0 |
275392 | 275392 | 2020-06-26 | Douglas | Kansas | 20045 | 124 | 0 |
272250 | 272250 | 2020-06-25 | Douglas | Kansas | 20045 | 106 | 0 |
269113 | 269113 | 2020-06-24 | Douglas | Kansas | 20045 | 106 | 0 |
265983 | 265983 | 2020-06-23 | Douglas | Kansas | 20045 | 103 | 0 |
262855 | 262855 | 2020-06-22 | Douglas | Kansas | 20045 | 103 | 0 |
259728 | 259728 | 2020-06-21 | Douglas | Kansas | 20045 | 93 | 0 |
256602 | 256602 | 2020-06-20 | Douglas | Kansas | 20045 | 93 | 0 |
253482 | 253482 | 2020-06-19 | Douglas | Kansas | 20045 | 93 | 0 |
250367 | 250367 | 2020-06-18 | Douglas | Kansas | 20045 | 88 | 0 |
247255 | 247255 | 2020-06-17 | Douglas | Kansas | 20045 | 88 | 0 |
244142 | 244142 | 2020-06-16 | Douglas | Kansas | 20045 | 85 | 0 |
241031 | 241031 | 2020-06-15 | Douglas | Kansas | 20045 | 85 | 0 |
237922 | 237922 | 2020-06-14 | Douglas | Kansas | 20045 | 82 | 0 |
234815 | 234815 | 2020-06-13 | Douglas | Kansas | 20045 | 82 | 0 |
231709 | 231709 | 2020-06-12 | Douglas | Kansas | 20045 | 82 | 0 |
228606 | 228606 | 2020-06-11 | Douglas | Kansas | 20045 | 78 | 0 |
225504 | 225504 | 2020-06-10 | Douglas | Kansas | 20045 | 78 | 0 |
222409 | 222409 | 2020-06-09 | Douglas | Kansas | 20045 | 74 | 0 |
219314 | 219314 | 2020-06-08 | Douglas | Kansas | 20045 | 74 | 0 |
216222 | 216222 | 2020-06-07 | Douglas | Kansas | 20045 | 70 | 0 |
213135 | 213135 | 2020-06-06 | Douglas | Kansas | 20045 | 70 | 0 |
210050 | 210050 | 2020-06-05 | Douglas | Kansas | 20045 | 70 | 0 |
206969 | 206969 | 2020-06-04 | Douglas | Kansas | 20045 | 69 | 0 |
203888 | 203888 | 2020-06-03 | Douglas | Kansas | 20045 | 67 | 0 |
200812 | 200812 | 2020-06-02 | Douglas | Kansas | 20045 | 67 | 0 |
197740 | 197740 | 2020-06-01 | Douglas | Kansas | 20045 | 67 | 0 |
194670 | 194670 | 2020-05-31 | Douglas | Kansas | 20045 | 66 | 0 |
191602 | 191602 | 2020-05-30 | Douglas | Kansas | 20045 | 66 | 0 |
188538 | 188538 | 2020-05-29 | Douglas | Kansas | 20045 | 66 | 0 |
185480 | 185480 | 2020-05-28 | Douglas | Kansas | 20045 | 65 | 0 |
182426 | 182426 | 2020-05-27 | Douglas | Kansas | 20045 | 63 | 0 |
179381 | 179381 | 2020-05-26 | Douglas | Kansas | 20045 | 63 | 0 |
176337 | 176337 | 2020-05-25 | Douglas | Kansas | 20045 | 63 | 0 |
173293 | 173293 | 2020-05-24 | Douglas | Kansas | 20045 | 63 | 0 |
170252 | 170252 | 2020-05-23 | Douglas | Kansas | 20045 | 63 | 0 |
167214 | 167214 | 2020-05-22 | Douglas | Kansas | 20045 | 63 | 0 |
164181 | 164181 | 2020-05-21 | Douglas | Kansas | 20045 | 62 | 0 |
161152 | 161152 | 2020-05-20 | Douglas | Kansas | 20045 | 62 | 0 |
158127 | 158127 | 2020-05-19 | Douglas | Kansas | 20045 | 62 | 0 |
155110 | 155110 | 2020-05-18 | Douglas | Kansas | 20045 | 61 | 0 |
152098 | 152098 | 2020-05-17 | Douglas | Kansas | 20045 | 60 | 0 |
149087 | 149087 | 2020-05-16 | Douglas | Kansas | 20045 | 60 | 0 |
146083 | 146083 | 2020-05-15 | Douglas | Kansas | 20045 | 58 | 0 |
143083 | 143083 | 2020-05-14 | Douglas | Kansas | 20045 | 58 | 0 |
140087 | 140087 | 2020-05-13 | Douglas | Kansas | 20045 | 58 | 0 |
137094 | 137094 | 2020-05-12 | Douglas | Kansas | 20045 | 58 | 0 |
134104 | 134104 | 2020-05-11 | Douglas | Kansas | 20045 | 57 | 0 |
131113 | 131113 | 2020-05-10 | Douglas | Kansas | 20045 | 56 | 0 |
128123 | 128123 | 2020-05-09 | Douglas | Kansas | 20045 | 56 | 0 |
125135 | 125135 | 2020-05-08 | Douglas | Kansas | 20045 | 56 | 0 |
122153 | 122153 | 2020-05-07 | Douglas | Kansas | 20045 | 56 | 0 |
119183 | 119183 | 2020-05-06 | Douglas | Kansas | 20045 | 56 | 0 |
116222 | 116222 | 2020-05-05 | Douglas | Kansas | 20045 | 51 | 0 |
113340 | 113340 | 2020-05-04 | Douglas | Kansas | 20045 | 51 | 0 |
110464 | 110464 | 2020-05-03 | Douglas | Kansas | 20045 | 51 | 0 |
107593 | 107593 | 2020-05-02 | Douglas | Kansas | 20045 | 51 | 0 |
104728 | 104728 | 2020-05-01 | Douglas | Kansas | 20045 | 51 | 0 |
101868 | 101868 | 2020-04-30 | Douglas | Kansas | 20045 | 50 | 0 |
99017 | 99017 | 2020-04-29 | Douglas | Kansas | 20045 | 49 | 0 |
96171 | 96171 | 2020-04-28 | Douglas | Kansas | 20045 | 49 | 0 |
93339 | 93339 | 2020-04-27 | Douglas | Kansas | 20045 | 49 | 0 |
90518 | 90518 | 2020-04-26 | Douglas | Kansas | 20045 | 48 | 0 |
87702 | 87702 | 2020-04-25 | Douglas | Kansas | 20045 | 48 | 0 |
84893 | 84893 | 2020-04-24 | Douglas | Kansas | 20045 | 46 | 0 |
82092 | 82092 | 2020-04-23 | Douglas | Kansas | 20045 | 44 | 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);