ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Doniphan" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535337 | 535337 | 2020-09-15 | Doniphan | Kansas | 20043 | 87 | 0 |
532102 | 532102 | 2020-09-14 | Doniphan | Kansas | 20043 | 87 | 0 |
528865 | 528865 | 2020-09-13 | Doniphan | Kansas | 20043 | 84 | 0 |
525629 | 525629 | 2020-09-12 | Doniphan | Kansas | 20043 | 84 | 0 |
522393 | 522393 | 2020-09-11 | Doniphan | Kansas | 20043 | 84 | 0 |
519156 | 519156 | 2020-09-10 | Doniphan | Kansas | 20043 | 80 | 0 |
515921 | 515921 | 2020-09-09 | Doniphan | Kansas | 20043 | 80 | 0 |
512688 | 512688 | 2020-09-08 | Doniphan | Kansas | 20043 | 80 | 0 |
509455 | 509455 | 2020-09-07 | Doniphan | Kansas | 20043 | 80 | 0 |
506223 | 506223 | 2020-09-06 | Doniphan | Kansas | 20043 | 72 | 0 |
502989 | 502989 | 2020-09-05 | Doniphan | Kansas | 20043 | 72 | 0 |
499755 | 499755 | 2020-09-04 | Doniphan | Kansas | 20043 | 72 | 0 |
496522 | 496522 | 2020-09-03 | Doniphan | Kansas | 20043 | 67 | 0 |
493288 | 493288 | 2020-09-02 | Doniphan | Kansas | 20043 | 67 | 0 |
490055 | 490055 | 2020-09-01 | Doniphan | Kansas | 20043 | 65 | 0 |
486822 | 486822 | 2020-08-31 | Doniphan | Kansas | 20043 | 65 | 0 |
483587 | 483587 | 2020-08-30 | Doniphan | Kansas | 20043 | 62 | 0 |
480353 | 480353 | 2020-08-29 | Doniphan | Kansas | 20043 | 62 | 0 |
477120 | 477120 | 2020-08-28 | Doniphan | Kansas | 20043 | 62 | 0 |
473887 | 473887 | 2020-08-27 | Doniphan | Kansas | 20043 | 59 | 0 |
470655 | 470655 | 2020-08-26 | Doniphan | Kansas | 20043 | 59 | 0 |
467426 | 467426 | 2020-08-25 | Doniphan | Kansas | 20043 | 58 | 0 |
464197 | 464197 | 2020-08-24 | Doniphan | Kansas | 20043 | 58 | 0 |
460968 | 460968 | 2020-08-23 | Doniphan | Kansas | 20043 | 52 | 0 |
457741 | 457741 | 2020-08-22 | Doniphan | Kansas | 20043 | 52 | 0 |
454513 | 454513 | 2020-08-21 | Doniphan | Kansas | 20043 | 52 | 0 |
451285 | 451285 | 2020-08-20 | Doniphan | Kansas | 20043 | 52 | 0 |
448057 | 448057 | 2020-08-19 | Doniphan | Kansas | 20043 | 52 | 0 |
444830 | 444830 | 2020-08-18 | Doniphan | Kansas | 20043 | 51 | 0 |
441604 | 441604 | 2020-08-17 | Doniphan | Kansas | 20043 | 51 | 0 |
438377 | 438377 | 2020-08-16 | Doniphan | Kansas | 20043 | 46 | 0 |
435152 | 435152 | 2020-08-15 | Doniphan | Kansas | 20043 | 46 | 0 |
431927 | 431927 | 2020-08-14 | Doniphan | Kansas | 20043 | 46 | 0 |
428699 | 428699 | 2020-08-13 | Doniphan | Kansas | 20043 | 45 | 0 |
425475 | 425475 | 2020-08-12 | Doniphan | Kansas | 20043 | 45 | 0 |
422254 | 422254 | 2020-08-11 | Doniphan | Kansas | 20043 | 45 | 0 |
419031 | 419031 | 2020-08-10 | Doniphan | Kansas | 20043 | 45 | 0 |
415810 | 415810 | 2020-08-09 | Doniphan | Kansas | 20043 | 45 | 0 |
412590 | 412590 | 2020-08-08 | Doniphan | Kansas | 20043 | 45 | 0 |
409370 | 409370 | 2020-08-07 | Doniphan | Kansas | 20043 | 45 | 0 |
406151 | 406151 | 2020-08-06 | Doniphan | Kansas | 20043 | 43 | 0 |
402933 | 402933 | 2020-08-05 | Doniphan | Kansas | 20043 | 43 | 0 |
399716 | 399716 | 2020-08-04 | Doniphan | Kansas | 20043 | 43 | 0 |
396501 | 396501 | 2020-08-03 | Doniphan | Kansas | 20043 | 43 | 0 |
393285 | 393285 | 2020-08-02 | Doniphan | Kansas | 20043 | 42 | 0 |
390068 | 390068 | 2020-08-01 | Doniphan | Kansas | 20043 | 42 | 0 |
386851 | 386851 | 2020-07-31 | Doniphan | Kansas | 20043 | 42 | 0 |
383633 | 383633 | 2020-07-30 | Doniphan | Kansas | 20043 | 41 | 0 |
380416 | 380416 | 2020-07-29 | Doniphan | Kansas | 20043 | 41 | 0 |
377199 | 377199 | 2020-07-28 | Doniphan | Kansas | 20043 | 40 | 0 |
373984 | 373984 | 2020-07-27 | Doniphan | Kansas | 20043 | 40 | 0 |
370772 | 370772 | 2020-07-26 | Doniphan | Kansas | 20043 | 39 | 0 |
367562 | 367562 | 2020-07-25 | Doniphan | Kansas | 20043 | 39 | 0 |
364355 | 364355 | 2020-07-24 | Doniphan | Kansas | 20043 | 39 | 0 |
361148 | 361148 | 2020-07-23 | Doniphan | Kansas | 20043 | 34 | 0 |
357943 | 357943 | 2020-07-22 | Doniphan | Kansas | 20043 | 34 | 0 |
354741 | 354741 | 2020-07-21 | Doniphan | Kansas | 20043 | 32 | 0 |
351539 | 351539 | 2020-07-20 | Doniphan | Kansas | 20043 | 32 | 0 |
348339 | 348339 | 2020-07-19 | Doniphan | Kansas | 20043 | 28 | 0 |
345138 | 345138 | 2020-07-18 | Doniphan | Kansas | 20043 | 28 | 0 |
341938 | 341938 | 2020-07-17 | Doniphan | Kansas | 20043 | 28 | 0 |
338742 | 338742 | 2020-07-16 | Doniphan | Kansas | 20043 | 27 | 0 |
335546 | 335546 | 2020-07-15 | Doniphan | Kansas | 20043 | 27 | 0 |
332353 | 332353 | 2020-07-14 | Doniphan | Kansas | 20043 | 27 | 0 |
329166 | 329166 | 2020-07-13 | Doniphan | Kansas | 20043 | 27 | 0 |
325980 | 325980 | 2020-07-12 | Doniphan | Kansas | 20043 | 27 | 0 |
322798 | 322798 | 2020-07-11 | Doniphan | Kansas | 20043 | 27 | 0 |
319619 | 319619 | 2020-07-10 | Doniphan | Kansas | 20043 | 27 | 0 |
316446 | 316446 | 2020-07-09 | Doniphan | Kansas | 20043 | 27 | 0 |
313272 | 313272 | 2020-07-08 | Doniphan | Kansas | 20043 | 27 | 0 |
310102 | 310102 | 2020-07-07 | Doniphan | Kansas | 20043 | 27 | 0 |
306934 | 306934 | 2020-07-06 | Doniphan | Kansas | 20043 | 27 | 0 |
303769 | 303769 | 2020-07-05 | Doniphan | Kansas | 20043 | 26 | 0 |
300605 | 300605 | 2020-07-04 | Doniphan | Kansas | 20043 | 26 | 0 |
297443 | 297443 | 2020-07-03 | Doniphan | Kansas | 20043 | 26 | 0 |
294285 | 294285 | 2020-07-02 | Doniphan | Kansas | 20043 | 26 | 0 |
291131 | 291131 | 2020-07-01 | Doniphan | Kansas | 20043 | 26 | 0 |
287981 | 287981 | 2020-06-30 | Doniphan | Kansas | 20043 | 26 | 0 |
284832 | 284832 | 2020-06-29 | Doniphan | Kansas | 20043 | 26 | 0 |
281687 | 281687 | 2020-06-28 | Doniphan | Kansas | 20043 | 26 | 0 |
278539 | 278539 | 2020-06-27 | Doniphan | Kansas | 20043 | 26 | 0 |
275391 | 275391 | 2020-06-26 | Doniphan | Kansas | 20043 | 26 | 0 |
272249 | 272249 | 2020-06-25 | Doniphan | Kansas | 20043 | 25 | 0 |
269112 | 269112 | 2020-06-24 | Doniphan | Kansas | 20043 | 25 | 0 |
265982 | 265982 | 2020-06-23 | Doniphan | Kansas | 20043 | 25 | 0 |
262854 | 262854 | 2020-06-22 | Doniphan | Kansas | 20043 | 25 | 0 |
259727 | 259727 | 2020-06-21 | Doniphan | Kansas | 20043 | 23 | 0 |
256601 | 256601 | 2020-06-20 | Doniphan | Kansas | 20043 | 23 | 0 |
253481 | 253481 | 2020-06-19 | Doniphan | Kansas | 20043 | 23 | 0 |
250366 | 250366 | 2020-06-18 | Doniphan | Kansas | 20043 | 24 | 0 |
247254 | 247254 | 2020-06-17 | Doniphan | Kansas | 20043 | 24 | 0 |
244141 | 244141 | 2020-06-16 | Doniphan | Kansas | 20043 | 20 | 0 |
241030 | 241030 | 2020-06-15 | Doniphan | Kansas | 20043 | 20 | 0 |
237921 | 237921 | 2020-06-14 | Doniphan | Kansas | 20043 | 20 | 0 |
234814 | 234814 | 2020-06-13 | Doniphan | Kansas | 20043 | 20 | 0 |
231708 | 231708 | 2020-06-12 | Doniphan | Kansas | 20043 | 20 | 0 |
228605 | 228605 | 2020-06-11 | Doniphan | Kansas | 20043 | 20 | 0 |
225503 | 225503 | 2020-06-10 | Doniphan | Kansas | 20043 | 20 | 0 |
222408 | 222408 | 2020-06-09 | Doniphan | Kansas | 20043 | 20 | 0 |
219313 | 219313 | 2020-06-08 | Doniphan | Kansas | 20043 | 20 | 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);