ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Dickinson" and state = "Kansas" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
57287 | 57287 | 2020-04-14 | Dickinson | Kansas | 20041 | 1 | 0 |
59995 | 59995 | 2020-04-15 | Dickinson | Kansas | 20041 | 1 | 0 |
62716 | 62716 | 2020-04-16 | Dickinson | Kansas | 20041 | 1 | 0 |
65452 | 65452 | 2020-04-17 | Dickinson | Kansas | 20041 | 1 | 0 |
68201 | 68201 | 2020-04-18 | Dickinson | Kansas | 20041 | 1 | 0 |
70962 | 70962 | 2020-04-19 | Dickinson | Kansas | 20041 | 1 | 0 |
73733 | 73733 | 2020-04-20 | Dickinson | Kansas | 20041 | 1 | 0 |
76513 | 76513 | 2020-04-21 | Dickinson | Kansas | 20041 | 1 | 0 |
79297 | 79297 | 2020-04-22 | Dickinson | Kansas | 20041 | 1 | 0 |
82090 | 82090 | 2020-04-23 | Dickinson | Kansas | 20041 | 1 | 0 |
84891 | 84891 | 2020-04-24 | Dickinson | Kansas | 20041 | 1 | 0 |
87700 | 87700 | 2020-04-25 | Dickinson | Kansas | 20041 | 1 | 0 |
90516 | 90516 | 2020-04-26 | Dickinson | Kansas | 20041 | 2 | 0 |
93337 | 93337 | 2020-04-27 | Dickinson | Kansas | 20041 | 2 | 0 |
96169 | 96169 | 2020-04-28 | Dickinson | Kansas | 20041 | 2 | 0 |
99015 | 99015 | 2020-04-29 | Dickinson | Kansas | 20041 | 2 | 0 |
101866 | 101866 | 2020-04-30 | Dickinson | Kansas | 20041 | 2 | 0 |
104726 | 104726 | 2020-05-01 | Dickinson | Kansas | 20041 | 2 | 0 |
107591 | 107591 | 2020-05-02 | Dickinson | Kansas | 20041 | 2 | 0 |
110462 | 110462 | 2020-05-03 | Dickinson | Kansas | 20041 | 2 | 0 |
113338 | 113338 | 2020-05-04 | Dickinson | Kansas | 20041 | 2 | 0 |
116220 | 116220 | 2020-05-05 | Dickinson | Kansas | 20041 | 2 | 0 |
119181 | 119181 | 2020-05-06 | Dickinson | Kansas | 20041 | 2 | 0 |
122151 | 122151 | 2020-05-07 | Dickinson | Kansas | 20041 | 2 | 0 |
125133 | 125133 | 2020-05-08 | Dickinson | Kansas | 20041 | 2 | 0 |
128121 | 128121 | 2020-05-09 | Dickinson | Kansas | 20041 | 2 | 0 |
131111 | 131111 | 2020-05-10 | Dickinson | Kansas | 20041 | 2 | 0 |
134102 | 134102 | 2020-05-11 | Dickinson | Kansas | 20041 | 2 | 0 |
137092 | 137092 | 2020-05-12 | Dickinson | Kansas | 20041 | 2 | 0 |
140085 | 140085 | 2020-05-13 | Dickinson | Kansas | 20041 | 2 | 0 |
143081 | 143081 | 2020-05-14 | Dickinson | Kansas | 20041 | 2 | 0 |
146081 | 146081 | 2020-05-15 | Dickinson | Kansas | 20041 | 2 | 0 |
149085 | 149085 | 2020-05-16 | Dickinson | Kansas | 20041 | 2 | 0 |
152096 | 152096 | 2020-05-17 | Dickinson | Kansas | 20041 | 2 | 0 |
155108 | 155108 | 2020-05-18 | Dickinson | Kansas | 20041 | 2 | 0 |
158125 | 158125 | 2020-05-19 | Dickinson | Kansas | 20041 | 2 | 0 |
161150 | 161150 | 2020-05-20 | Dickinson | Kansas | 20041 | 2 | 0 |
164179 | 164179 | 2020-05-21 | Dickinson | Kansas | 20041 | 2 | 0 |
176335 | 176335 | 2020-05-25 | Dickinson | Kansas | 20041 | 3 | 0 |
179379 | 179379 | 2020-05-26 | Dickinson | Kansas | 20041 | 3 | 0 |
182424 | 182424 | 2020-05-27 | Dickinson | Kansas | 20041 | 3 | 0 |
185478 | 185478 | 2020-05-28 | Dickinson | Kansas | 20041 | 3 | 0 |
188536 | 188536 | 2020-05-29 | Dickinson | Kansas | 20041 | 3 | 0 |
191600 | 191600 | 2020-05-30 | Dickinson | Kansas | 20041 | 3 | 0 |
194668 | 194668 | 2020-05-31 | Dickinson | Kansas | 20041 | 3 | 0 |
167212 | 167212 | 2020-05-22 | Dickinson | Kansas | 20041 | 4 | 0 |
170250 | 170250 | 2020-05-23 | Dickinson | Kansas | 20041 | 4 | 0 |
173291 | 173291 | 2020-05-24 | Dickinson | Kansas | 20041 | 4 | 0 |
197738 | 197738 | 2020-06-01 | Dickinson | Kansas | 20041 | 4 | 0 |
200810 | 200810 | 2020-06-02 | Dickinson | Kansas | 20041 | 4 | 0 |
203886 | 203886 | 2020-06-03 | Dickinson | Kansas | 20041 | 5 | 0 |
206967 | 206967 | 2020-06-04 | Dickinson | Kansas | 20041 | 5 | 0 |
210048 | 210048 | 2020-06-05 | Dickinson | Kansas | 20041 | 5 | 0 |
213133 | 213133 | 2020-06-06 | Dickinson | Kansas | 20041 | 5 | 0 |
216220 | 216220 | 2020-06-07 | Dickinson | Kansas | 20041 | 5 | 0 |
219312 | 219312 | 2020-06-08 | Dickinson | Kansas | 20041 | 5 | 0 |
222407 | 222407 | 2020-06-09 | Dickinson | Kansas | 20041 | 5 | 0 |
225502 | 225502 | 2020-06-10 | Dickinson | Kansas | 20041 | 6 | 0 |
228604 | 228604 | 2020-06-11 | Dickinson | Kansas | 20041 | 6 | 0 |
231707 | 231707 | 2020-06-12 | Dickinson | Kansas | 20041 | 6 | 0 |
234813 | 234813 | 2020-06-13 | Dickinson | Kansas | 20041 | 6 | 0 |
237920 | 237920 | 2020-06-14 | Dickinson | Kansas | 20041 | 6 | 0 |
241029 | 241029 | 2020-06-15 | Dickinson | Kansas | 20041 | 6 | 0 |
244140 | 244140 | 2020-06-16 | Dickinson | Kansas | 20041 | 6 | 0 |
247253 | 247253 | 2020-06-17 | Dickinson | Kansas | 20041 | 6 | 0 |
250365 | 250365 | 2020-06-18 | Dickinson | Kansas | 20041 | 6 | 0 |
262853 | 262853 | 2020-06-22 | Dickinson | Kansas | 20041 | 6 | 0 |
265981 | 265981 | 2020-06-23 | Dickinson | Kansas | 20041 | 6 | 0 |
253480 | 253480 | 2020-06-19 | Dickinson | Kansas | 20041 | 8 | 0 |
256600 | 256600 | 2020-06-20 | Dickinson | Kansas | 20041 | 8 | 0 |
259726 | 259726 | 2020-06-21 | Dickinson | Kansas | 20041 | 8 | 0 |
269111 | 269111 | 2020-06-24 | Dickinson | Kansas | 20041 | 8 | 0 |
272248 | 272248 | 2020-06-25 | Dickinson | Kansas | 20041 | 8 | 0 |
275390 | 275390 | 2020-06-26 | Dickinson | Kansas | 20041 | 8 | 0 |
278538 | 278538 | 2020-06-27 | Dickinson | Kansas | 20041 | 8 | 0 |
281686 | 281686 | 2020-06-28 | Dickinson | Kansas | 20041 | 8 | 0 |
284831 | 284831 | 2020-06-29 | Dickinson | Kansas | 20041 | 8 | 0 |
287980 | 287980 | 2020-06-30 | Dickinson | Kansas | 20041 | 8 | 0 |
291130 | 291130 | 2020-07-01 | Dickinson | Kansas | 20041 | 8 | 0 |
294284 | 294284 | 2020-07-02 | Dickinson | Kansas | 20041 | 8 | 0 |
297442 | 297442 | 2020-07-03 | Dickinson | Kansas | 20041 | 8 | 0 |
300604 | 300604 | 2020-07-04 | Dickinson | Kansas | 20041 | 8 | 0 |
303768 | 303768 | 2020-07-05 | Dickinson | Kansas | 20041 | 8 | 1 |
306933 | 306933 | 2020-07-06 | Dickinson | Kansas | 20041 | 10 | 1 |
310101 | 310101 | 2020-07-07 | Dickinson | Kansas | 20041 | 10 | 1 |
313271 | 313271 | 2020-07-08 | Dickinson | Kansas | 20041 | 12 | 1 |
316445 | 316445 | 2020-07-09 | Dickinson | Kansas | 20041 | 12 | 1 |
319618 | 319618 | 2020-07-10 | Dickinson | Kansas | 20041 | 15 | 1 |
322797 | 322797 | 2020-07-11 | Dickinson | Kansas | 20041 | 15 | 1 |
325979 | 325979 | 2020-07-12 | Dickinson | Kansas | 20041 | 15 | 1 |
329165 | 329165 | 2020-07-13 | Dickinson | Kansas | 20041 | 20 | 1 |
332352 | 332352 | 2020-07-14 | Dickinson | Kansas | 20041 | 20 | 1 |
335545 | 335545 | 2020-07-15 | Dickinson | Kansas | 20041 | 22 | 1 |
338741 | 338741 | 2020-07-16 | Dickinson | Kansas | 20041 | 22 | 1 |
341937 | 341937 | 2020-07-17 | Dickinson | Kansas | 20041 | 31 | 1 |
345137 | 345137 | 2020-07-18 | Dickinson | Kansas | 20041 | 31 | 1 |
348338 | 348338 | 2020-07-19 | Dickinson | Kansas | 20041 | 31 | 1 |
351538 | 351538 | 2020-07-20 | Dickinson | Kansas | 20041 | 32 | 1 |
354740 | 354740 | 2020-07-21 | Dickinson | Kansas | 20041 | 32 | 1 |
357942 | 357942 | 2020-07-22 | Dickinson | Kansas | 20041 | 32 | 1 |
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);