ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
752 rows where county = "Edwards" 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 |
---|---|---|---|---|---|---|---|
79300 | 79300 | 2020-04-22 | Edwards | Kansas | 20047 | 1 | 0 |
82093 | 82093 | 2020-04-23 | Edwards | Kansas | 20047 | 1 | 0 |
84894 | 84894 | 2020-04-24 | Edwards | Kansas | 20047 | 1 | 0 |
87703 | 87703 | 2020-04-25 | Edwards | Kansas | 20047 | 1 | 0 |
90519 | 90519 | 2020-04-26 | Edwards | Kansas | 20047 | 1 | 0 |
93340 | 93340 | 2020-04-27 | Edwards | Kansas | 20047 | 2 | 0 |
96172 | 96172 | 2020-04-28 | Edwards | Kansas | 20047 | 2 | 0 |
99018 | 99018 | 2020-04-29 | Edwards | Kansas | 20047 | 3 | 0 |
101869 | 101869 | 2020-04-30 | Edwards | Kansas | 20047 | 3 | 0 |
104729 | 104729 | 2020-05-01 | Edwards | Kansas | 20047 | 4 | 0 |
107594 | 107594 | 2020-05-02 | Edwards | Kansas | 20047 | 4 | 0 |
110465 | 110465 | 2020-05-03 | Edwards | Kansas | 20047 | 4 | 0 |
113341 | 113341 | 2020-05-04 | Edwards | Kansas | 20047 | 4 | 0 |
116223 | 116223 | 2020-05-05 | Edwards | Kansas | 20047 | 4 | 0 |
119184 | 119184 | 2020-05-06 | Edwards | Kansas | 20047 | 4 | 0 |
122154 | 122154 | 2020-05-07 | Edwards | Kansas | 20047 | 4 | 0 |
125136 | 125136 | 2020-05-08 | Edwards | Kansas | 20047 | 4 | 0 |
128124 | 128124 | 2020-05-09 | Edwards | Kansas | 20047 | 4 | 0 |
131114 | 131114 | 2020-05-10 | Edwards | Kansas | 20047 | 4 | 0 |
134105 | 134105 | 2020-05-11 | Edwards | Kansas | 20047 | 4 | 0 |
137095 | 137095 | 2020-05-12 | Edwards | Kansas | 20047 | 4 | 0 |
140088 | 140088 | 2020-05-13 | Edwards | Kansas | 20047 | 4 | 0 |
143084 | 143084 | 2020-05-14 | Edwards | Kansas | 20047 | 4 | 0 |
146084 | 146084 | 2020-05-15 | Edwards | Kansas | 20047 | 4 | 0 |
149088 | 149088 | 2020-05-16 | Edwards | Kansas | 20047 | 4 | 0 |
152099 | 152099 | 2020-05-17 | Edwards | Kansas | 20047 | 4 | 0 |
155111 | 155111 | 2020-05-18 | Edwards | Kansas | 20047 | 5 | 0 |
158128 | 158128 | 2020-05-19 | Edwards | Kansas | 20047 | 5 | 0 |
161153 | 161153 | 2020-05-20 | Edwards | Kansas | 20047 | 5 | 0 |
164182 | 164182 | 2020-05-21 | Edwards | Kansas | 20047 | 5 | 0 |
167215 | 167215 | 2020-05-22 | Edwards | Kansas | 20047 | 5 | 0 |
170253 | 170253 | 2020-05-23 | Edwards | Kansas | 20047 | 5 | 0 |
173294 | 173294 | 2020-05-24 | Edwards | Kansas | 20047 | 5 | 0 |
176338 | 176338 | 2020-05-25 | Edwards | Kansas | 20047 | 5 | 0 |
179382 | 179382 | 2020-05-26 | Edwards | Kansas | 20047 | 5 | 0 |
182427 | 182427 | 2020-05-27 | Edwards | Kansas | 20047 | 5 | 0 |
185481 | 185481 | 2020-05-28 | Edwards | Kansas | 20047 | 5 | 0 |
188539 | 188539 | 2020-05-29 | Edwards | Kansas | 20047 | 5 | 0 |
191603 | 191603 | 2020-05-30 | Edwards | Kansas | 20047 | 5 | 0 |
194671 | 194671 | 2020-05-31 | Edwards | Kansas | 20047 | 5 | 0 |
197741 | 197741 | 2020-06-01 | Edwards | Kansas | 20047 | 5 | 0 |
200813 | 200813 | 2020-06-02 | Edwards | Kansas | 20047 | 5 | 0 |
203889 | 203889 | 2020-06-03 | Edwards | Kansas | 20047 | 5 | 0 |
206970 | 206970 | 2020-06-04 | Edwards | Kansas | 20047 | 5 | 0 |
210051 | 210051 | 2020-06-05 | Edwards | Kansas | 20047 | 5 | 0 |
213136 | 213136 | 2020-06-06 | Edwards | Kansas | 20047 | 5 | 0 |
216223 | 216223 | 2020-06-07 | Edwards | Kansas | 20047 | 5 | 0 |
219315 | 219315 | 2020-06-08 | Edwards | Kansas | 20047 | 5 | 0 |
222410 | 222410 | 2020-06-09 | Edwards | Kansas | 20047 | 5 | 0 |
225505 | 225505 | 2020-06-10 | Edwards | Kansas | 20047 | 5 | 0 |
228607 | 228607 | 2020-06-11 | Edwards | Kansas | 20047 | 5 | 0 |
231710 | 231710 | 2020-06-12 | Edwards | Kansas | 20047 | 5 | 0 |
234816 | 234816 | 2020-06-13 | Edwards | Kansas | 20047 | 5 | 0 |
237923 | 237923 | 2020-06-14 | Edwards | Kansas | 20047 | 5 | 0 |
241032 | 241032 | 2020-06-15 | Edwards | Kansas | 20047 | 5 | 0 |
244143 | 244143 | 2020-06-16 | Edwards | Kansas | 20047 | 5 | 0 |
247256 | 247256 | 2020-06-17 | Edwards | Kansas | 20047 | 5 | 0 |
250368 | 250368 | 2020-06-18 | Edwards | Kansas | 20047 | 5 | 0 |
253483 | 253483 | 2020-06-19 | Edwards | Kansas | 20047 | 6 | 0 |
256603 | 256603 | 2020-06-20 | Edwards | Kansas | 20047 | 6 | 0 |
259729 | 259729 | 2020-06-21 | Edwards | Kansas | 20047 | 6 | 0 |
262856 | 262856 | 2020-06-22 | Edwards | Kansas | 20047 | 6 | 0 |
265984 | 265984 | 2020-06-23 | Edwards | Kansas | 20047 | 6 | 0 |
269114 | 269114 | 2020-06-24 | Edwards | Kansas | 20047 | 6 | 0 |
272251 | 272251 | 2020-06-25 | Edwards | Kansas | 20047 | 6 | 0 |
275393 | 275393 | 2020-06-26 | Edwards | Kansas | 20047 | 6 | 0 |
278541 | 278541 | 2020-06-27 | Edwards | Kansas | 20047 | 6 | 0 |
281689 | 281689 | 2020-06-28 | Edwards | Kansas | 20047 | 6 | 0 |
284834 | 284834 | 2020-06-29 | Edwards | Kansas | 20047 | 6 | 0 |
287983 | 287983 | 2020-06-30 | Edwards | Kansas | 20047 | 6 | 0 |
291133 | 291133 | 2020-07-01 | Edwards | Kansas | 20047 | 7 | 0 |
294287 | 294287 | 2020-07-02 | Edwards | Kansas | 20047 | 7 | 0 |
297445 | 297445 | 2020-07-03 | Edwards | Kansas | 20047 | 7 | 0 |
300607 | 300607 | 2020-07-04 | Edwards | Kansas | 20047 | 7 | 0 |
303771 | 303771 | 2020-07-05 | Edwards | Kansas | 20047 | 7 | 0 |
306936 | 306936 | 2020-07-06 | Edwards | Kansas | 20047 | 7 | 0 |
310104 | 310104 | 2020-07-07 | Edwards | Kansas | 20047 | 7 | 0 |
313274 | 313274 | 2020-07-08 | Edwards | Kansas | 20047 | 7 | 0 |
316448 | 316448 | 2020-07-09 | Edwards | Kansas | 20047 | 7 | 0 |
319621 | 319621 | 2020-07-10 | Edwards | Kansas | 20047 | 8 | 0 |
322800 | 322800 | 2020-07-11 | Edwards | Kansas | 20047 | 8 | 0 |
325982 | 325982 | 2020-07-12 | Edwards | Kansas | 20047 | 8 | 0 |
329168 | 329168 | 2020-07-13 | Edwards | Kansas | 20047 | 8 | 0 |
332355 | 332355 | 2020-07-14 | Edwards | Kansas | 20047 | 8 | 0 |
335548 | 335548 | 2020-07-15 | Edwards | Kansas | 20047 | 8 | 0 |
338744 | 338744 | 2020-07-16 | Edwards | Kansas | 20047 | 8 | 0 |
341940 | 341940 | 2020-07-17 | Edwards | Kansas | 20047 | 9 | 0 |
345140 | 345140 | 2020-07-18 | Edwards | Kansas | 20047 | 9 | 0 |
348341 | 348341 | 2020-07-19 | Edwards | Kansas | 20047 | 9 | 0 |
351541 | 351541 | 2020-07-20 | Edwards | Kansas | 20047 | 9 | 0 |
354743 | 354743 | 2020-07-21 | Edwards | Kansas | 20047 | 9 | 0 |
357945 | 357945 | 2020-07-22 | Edwards | Kansas | 20047 | 9 | 0 |
361150 | 361150 | 2020-07-23 | Edwards | Kansas | 20047 | 9 | 0 |
364357 | 364357 | 2020-07-24 | Edwards | Kansas | 20047 | 9 | 0 |
367564 | 367564 | 2020-07-25 | Edwards | Kansas | 20047 | 9 | 0 |
370774 | 370774 | 2020-07-26 | Edwards | Kansas | 20047 | 9 | 0 |
373986 | 373986 | 2020-07-27 | Edwards | Kansas | 20047 | 9 | 0 |
377201 | 377201 | 2020-07-28 | Edwards | Kansas | 20047 | 9 | 0 |
380418 | 380418 | 2020-07-29 | Edwards | Kansas | 20047 | 9 | 0 |
383635 | 383635 | 2020-07-30 | Edwards | Kansas | 20047 | 9 | 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);