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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
294285 | 294285 | 2020-07-02 | Doniphan | Kansas | 20043 | 26 | 0 |
297443 | 297443 | 2020-07-03 | Doniphan | Kansas | 20043 | 26 | 0 |
300605 | 300605 | 2020-07-04 | Doniphan | Kansas | 20043 | 26 | 0 |
303769 | 303769 | 2020-07-05 | Doniphan | Kansas | 20043 | 26 | 0 |
306934 | 306934 | 2020-07-06 | Doniphan | Kansas | 20043 | 27 | 0 |
310102 | 310102 | 2020-07-07 | Doniphan | Kansas | 20043 | 27 | 0 |
313272 | 313272 | 2020-07-08 | Doniphan | Kansas | 20043 | 27 | 0 |
316446 | 316446 | 2020-07-09 | Doniphan | Kansas | 20043 | 27 | 0 |
319619 | 319619 | 2020-07-10 | Doniphan | Kansas | 20043 | 27 | 0 |
322798 | 322798 | 2020-07-11 | Doniphan | Kansas | 20043 | 27 | 0 |
325980 | 325980 | 2020-07-12 | Doniphan | Kansas | 20043 | 27 | 0 |
329166 | 329166 | 2020-07-13 | Doniphan | Kansas | 20043 | 27 | 0 |
332353 | 332353 | 2020-07-14 | Doniphan | Kansas | 20043 | 27 | 0 |
335546 | 335546 | 2020-07-15 | Doniphan | Kansas | 20043 | 27 | 0 |
338742 | 338742 | 2020-07-16 | Doniphan | Kansas | 20043 | 27 | 0 |
341938 | 341938 | 2020-07-17 | Doniphan | Kansas | 20043 | 28 | 0 |
345138 | 345138 | 2020-07-18 | Doniphan | Kansas | 20043 | 28 | 0 |
348339 | 348339 | 2020-07-19 | Doniphan | Kansas | 20043 | 28 | 0 |
351539 | 351539 | 2020-07-20 | Doniphan | Kansas | 20043 | 32 | 0 |
354741 | 354741 | 2020-07-21 | Doniphan | Kansas | 20043 | 32 | 0 |
357943 | 357943 | 2020-07-22 | Doniphan | Kansas | 20043 | 34 | 0 |
361148 | 361148 | 2020-07-23 | Doniphan | Kansas | 20043 | 34 | 0 |
364355 | 364355 | 2020-07-24 | Doniphan | Kansas | 20043 | 39 | 0 |
367562 | 367562 | 2020-07-25 | Doniphan | Kansas | 20043 | 39 | 0 |
370772 | 370772 | 2020-07-26 | Doniphan | Kansas | 20043 | 39 | 0 |
373984 | 373984 | 2020-07-27 | Doniphan | Kansas | 20043 | 40 | 0 |
377199 | 377199 | 2020-07-28 | Doniphan | Kansas | 20043 | 40 | 0 |
380416 | 380416 | 2020-07-29 | Doniphan | Kansas | 20043 | 41 | 0 |
383633 | 383633 | 2020-07-30 | Doniphan | Kansas | 20043 | 41 | 0 |
386851 | 386851 | 2020-07-31 | Doniphan | Kansas | 20043 | 42 | 0 |
390068 | 390068 | 2020-08-01 | Doniphan | Kansas | 20043 | 42 | 0 |
393285 | 393285 | 2020-08-02 | Doniphan | Kansas | 20043 | 42 | 0 |
396501 | 396501 | 2020-08-03 | Doniphan | Kansas | 20043 | 43 | 0 |
399716 | 399716 | 2020-08-04 | Doniphan | Kansas | 20043 | 43 | 0 |
402933 | 402933 | 2020-08-05 | Doniphan | Kansas | 20043 | 43 | 0 |
406151 | 406151 | 2020-08-06 | Doniphan | Kansas | 20043 | 43 | 0 |
409370 | 409370 | 2020-08-07 | Doniphan | Kansas | 20043 | 45 | 0 |
412590 | 412590 | 2020-08-08 | Doniphan | Kansas | 20043 | 45 | 0 |
415810 | 415810 | 2020-08-09 | Doniphan | Kansas | 20043 | 45 | 0 |
419031 | 419031 | 2020-08-10 | Doniphan | Kansas | 20043 | 45 | 0 |
422254 | 422254 | 2020-08-11 | Doniphan | Kansas | 20043 | 45 | 0 |
425475 | 425475 | 2020-08-12 | Doniphan | Kansas | 20043 | 45 | 0 |
428699 | 428699 | 2020-08-13 | Doniphan | Kansas | 20043 | 45 | 0 |
431927 | 431927 | 2020-08-14 | Doniphan | Kansas | 20043 | 46 | 0 |
435152 | 435152 | 2020-08-15 | Doniphan | Kansas | 20043 | 46 | 0 |
438377 | 438377 | 2020-08-16 | Doniphan | Kansas | 20043 | 46 | 0 |
441604 | 441604 | 2020-08-17 | Doniphan | Kansas | 20043 | 51 | 0 |
444830 | 444830 | 2020-08-18 | Doniphan | Kansas | 20043 | 51 | 0 |
448057 | 448057 | 2020-08-19 | Doniphan | Kansas | 20043 | 52 | 0 |
451285 | 451285 | 2020-08-20 | Doniphan | Kansas | 20043 | 52 | 0 |
454513 | 454513 | 2020-08-21 | Doniphan | Kansas | 20043 | 52 | 0 |
457741 | 457741 | 2020-08-22 | Doniphan | Kansas | 20043 | 52 | 0 |
460968 | 460968 | 2020-08-23 | Doniphan | Kansas | 20043 | 52 | 0 |
464197 | 464197 | 2020-08-24 | Doniphan | Kansas | 20043 | 58 | 0 |
467426 | 467426 | 2020-08-25 | Doniphan | Kansas | 20043 | 58 | 0 |
470655 | 470655 | 2020-08-26 | Doniphan | Kansas | 20043 | 59 | 0 |
473887 | 473887 | 2020-08-27 | Doniphan | Kansas | 20043 | 59 | 0 |
477120 | 477120 | 2020-08-28 | Doniphan | Kansas | 20043 | 62 | 0 |
480353 | 480353 | 2020-08-29 | Doniphan | Kansas | 20043 | 62 | 0 |
483587 | 483587 | 2020-08-30 | Doniphan | Kansas | 20043 | 62 | 0 |
486822 | 486822 | 2020-08-31 | Doniphan | Kansas | 20043 | 65 | 0 |
490055 | 490055 | 2020-09-01 | Doniphan | Kansas | 20043 | 65 | 0 |
493288 | 493288 | 2020-09-02 | Doniphan | Kansas | 20043 | 67 | 0 |
496522 | 496522 | 2020-09-03 | Doniphan | Kansas | 20043 | 67 | 0 |
499755 | 499755 | 2020-09-04 | Doniphan | Kansas | 20043 | 72 | 0 |
502989 | 502989 | 2020-09-05 | Doniphan | Kansas | 20043 | 72 | 0 |
506223 | 506223 | 2020-09-06 | Doniphan | Kansas | 20043 | 72 | 0 |
509455 | 509455 | 2020-09-07 | Doniphan | Kansas | 20043 | 80 | 0 |
512688 | 512688 | 2020-09-08 | Doniphan | Kansas | 20043 | 80 | 0 |
515921 | 515921 | 2020-09-09 | Doniphan | Kansas | 20043 | 80 | 0 |
519156 | 519156 | 2020-09-10 | Doniphan | Kansas | 20043 | 80 | 0 |
522393 | 522393 | 2020-09-11 | Doniphan | Kansas | 20043 | 84 | 0 |
525629 | 525629 | 2020-09-12 | Doniphan | Kansas | 20043 | 84 | 0 |
528865 | 528865 | 2020-09-13 | Doniphan | Kansas | 20043 | 84 | 0 |
532102 | 532102 | 2020-09-14 | Doniphan | Kansas | 20043 | 87 | 0 |
535337 | 535337 | 2020-09-15 | Doniphan | Kansas | 20043 | 87 | 0 |
538573 | 538573 | 2020-09-16 | Doniphan | Kansas | 20043 | 87 | 0 |
541810 | 541810 | 2020-09-17 | Doniphan | Kansas | 20043 | 87 | 0 |
545046 | 545046 | 2020-09-18 | Doniphan | Kansas | 20043 | 91 | 0 |
548284 | 548284 | 2020-09-19 | Doniphan | Kansas | 20043 | 91 | 0 |
551523 | 551523 | 2020-09-20 | Doniphan | Kansas | 20043 | 91 | 0 |
554762 | 554762 | 2020-09-21 | Doniphan | Kansas | 20043 | 95 | 0 |
557999 | 557999 | 2020-09-22 | Doniphan | Kansas | 20043 | 95 | 0 |
561235 | 561235 | 2020-09-23 | Doniphan | Kansas | 20043 | 96 | 0 |
564475 | 564475 | 2020-09-24 | Doniphan | Kansas | 20043 | 96 | 0 |
567715 | 567715 | 2020-09-25 | Doniphan | Kansas | 20043 | 100 | 0 |
570957 | 570957 | 2020-09-26 | Doniphan | Kansas | 20043 | 100 | 0 |
574200 | 574200 | 2020-09-27 | Doniphan | Kansas | 20043 | 100 | 0 |
577442 | 577442 | 2020-09-28 | Doniphan | Kansas | 20043 | 106 | 0 |
580683 | 580683 | 2020-09-29 | Doniphan | Kansas | 20043 | 106 | 0 |
583922 | 583922 | 2020-09-30 | Doniphan | Kansas | 20043 | 114 | 0 |
587162 | 587162 | 2020-10-01 | Doniphan | Kansas | 20043 | 114 | 0 |
590403 | 590403 | 2020-10-02 | Doniphan | Kansas | 20043 | 118 | 0 |
593644 | 593644 | 2020-10-03 | Doniphan | Kansas | 20043 | 118 | 0 |
596886 | 596886 | 2020-10-04 | Doniphan | Kansas | 20043 | 118 | 0 |
600128 | 600128 | 2020-10-05 | Doniphan | Kansas | 20043 | 120 | 0 |
603371 | 603371 | 2020-10-06 | Doniphan | Kansas | 20043 | 120 | 0 |
606613 | 606613 | 2020-10-07 | Doniphan | Kansas | 20043 | 123 | 0 |
609856 | 609856 | 2020-10-08 | Doniphan | Kansas | 20043 | 123 | 0 |
613098 | 613098 | 2020-10-09 | Doniphan | Kansas | 20043 | 140 | 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);