ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Mitchell" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635840 | 635840 | 2020-10-16 | Mitchell | Kansas | 20123 | 56 | 0 |
632594 | 632594 | 2020-10-15 | Mitchell | Kansas | 20123 | 55 | 0 |
629350 | 629350 | 2020-10-14 | Mitchell | Kansas | 20123 | 55 | 0 |
626107 | 626107 | 2020-10-13 | Mitchell | Kansas | 20123 | 55 | 0 |
622865 | 622865 | 2020-10-12 | Mitchell | Kansas | 20123 | 55 | 0 |
619621 | 619621 | 2020-10-11 | Mitchell | Kansas | 20123 | 53 | 0 |
616379 | 616379 | 2020-10-10 | Mitchell | Kansas | 20123 | 53 | 0 |
613138 | 613138 | 2020-10-09 | Mitchell | Kansas | 20123 | 53 | 0 |
609896 | 609896 | 2020-10-08 | Mitchell | Kansas | 20123 | 48 | 0 |
606653 | 606653 | 2020-10-07 | Mitchell | Kansas | 20123 | 48 | 0 |
603411 | 603411 | 2020-10-06 | Mitchell | Kansas | 20123 | 48 | 0 |
600168 | 600168 | 2020-10-05 | Mitchell | Kansas | 20123 | 48 | 0 |
596926 | 596926 | 2020-10-04 | Mitchell | Kansas | 20123 | 46 | 0 |
593684 | 593684 | 2020-10-03 | Mitchell | Kansas | 20123 | 46 | 0 |
590443 | 590443 | 2020-10-02 | Mitchell | Kansas | 20123 | 46 | 0 |
587202 | 587202 | 2020-10-01 | Mitchell | Kansas | 20123 | 46 | 0 |
583962 | 583962 | 2020-09-30 | Mitchell | Kansas | 20123 | 46 | 0 |
580723 | 580723 | 2020-09-29 | Mitchell | Kansas | 20123 | 44 | 0 |
577482 | 577482 | 2020-09-28 | Mitchell | Kansas | 20123 | 44 | 0 |
574240 | 574240 | 2020-09-27 | Mitchell | Kansas | 20123 | 44 | 0 |
570997 | 570997 | 2020-09-26 | Mitchell | Kansas | 20123 | 44 | 0 |
567755 | 567755 | 2020-09-25 | Mitchell | Kansas | 20123 | 44 | 0 |
564515 | 564515 | 2020-09-24 | Mitchell | Kansas | 20123 | 44 | 0 |
561275 | 561275 | 2020-09-23 | Mitchell | Kansas | 20123 | 44 | 0 |
558039 | 558039 | 2020-09-22 | Mitchell | Kansas | 20123 | 44 | 0 |
554802 | 554802 | 2020-09-21 | Mitchell | Kansas | 20123 | 44 | 0 |
551563 | 551563 | 2020-09-20 | Mitchell | Kansas | 20123 | 43 | 0 |
548324 | 548324 | 2020-09-19 | Mitchell | Kansas | 20123 | 43 | 0 |
545086 | 545086 | 2020-09-18 | Mitchell | Kansas | 20123 | 43 | 0 |
541850 | 541850 | 2020-09-17 | Mitchell | Kansas | 20123 | 43 | 0 |
538613 | 538613 | 2020-09-16 | Mitchell | Kansas | 20123 | 43 | 0 |
535377 | 535377 | 2020-09-15 | Mitchell | Kansas | 20123 | 40 | 0 |
532142 | 532142 | 2020-09-14 | Mitchell | Kansas | 20123 | 40 | 0 |
528905 | 528905 | 2020-09-13 | Mitchell | Kansas | 20123 | 40 | 0 |
525669 | 525669 | 2020-09-12 | Mitchell | Kansas | 20123 | 40 | 0 |
522433 | 522433 | 2020-09-11 | Mitchell | Kansas | 20123 | 40 | 0 |
519196 | 519196 | 2020-09-10 | Mitchell | Kansas | 20123 | 38 | 0 |
515961 | 515961 | 2020-09-09 | Mitchell | Kansas | 20123 | 38 | 0 |
512728 | 512728 | 2020-09-08 | Mitchell | Kansas | 20123 | 38 | 0 |
509495 | 509495 | 2020-09-07 | Mitchell | Kansas | 20123 | 38 | 0 |
506263 | 506263 | 2020-09-06 | Mitchell | Kansas | 20123 | 33 | 0 |
503029 | 503029 | 2020-09-05 | Mitchell | Kansas | 20123 | 33 | 0 |
499795 | 499795 | 2020-09-04 | Mitchell | Kansas | 20123 | 33 | 0 |
496562 | 496562 | 2020-09-03 | Mitchell | Kansas | 20123 | 32 | 0 |
493328 | 493328 | 2020-09-02 | Mitchell | Kansas | 20123 | 32 | 0 |
490095 | 490095 | 2020-09-01 | Mitchell | Kansas | 20123 | 32 | 0 |
486862 | 486862 | 2020-08-31 | Mitchell | Kansas | 20123 | 32 | 0 |
483627 | 483627 | 2020-08-30 | Mitchell | Kansas | 20123 | 30 | 0 |
480393 | 480393 | 2020-08-29 | Mitchell | Kansas | 20123 | 30 | 0 |
477160 | 477160 | 2020-08-28 | Mitchell | Kansas | 20123 | 30 | 0 |
473927 | 473927 | 2020-08-27 | Mitchell | Kansas | 20123 | 30 | 0 |
470695 | 470695 | 2020-08-26 | Mitchell | Kansas | 20123 | 30 | 0 |
467466 | 467466 | 2020-08-25 | Mitchell | Kansas | 20123 | 28 | 0 |
464237 | 464237 | 2020-08-24 | Mitchell | Kansas | 20123 | 28 | 0 |
461008 | 461008 | 2020-08-23 | Mitchell | Kansas | 20123 | 27 | 0 |
457781 | 457781 | 2020-08-22 | Mitchell | Kansas | 20123 | 27 | 0 |
454553 | 454553 | 2020-08-21 | Mitchell | Kansas | 20123 | 27 | 0 |
451325 | 451325 | 2020-08-20 | Mitchell | Kansas | 20123 | 27 | 0 |
448097 | 448097 | 2020-08-19 | Mitchell | Kansas | 20123 | 27 | 0 |
444870 | 444870 | 2020-08-18 | Mitchell | Kansas | 20123 | 28 | 0 |
441644 | 441644 | 2020-08-17 | Mitchell | Kansas | 20123 | 28 | 0 |
438417 | 438417 | 2020-08-16 | Mitchell | Kansas | 20123 | 28 | 0 |
435192 | 435192 | 2020-08-15 | Mitchell | Kansas | 20123 | 28 | 0 |
431967 | 431967 | 2020-08-14 | Mitchell | Kansas | 20123 | 28 | 0 |
428739 | 428739 | 2020-08-13 | Mitchell | Kansas | 20123 | 27 | 0 |
425515 | 425515 | 2020-08-12 | Mitchell | Kansas | 20123 | 27 | 0 |
422294 | 422294 | 2020-08-11 | Mitchell | Kansas | 20123 | 27 | 0 |
419071 | 419071 | 2020-08-10 | Mitchell | Kansas | 20123 | 27 | 0 |
415850 | 415850 | 2020-08-09 | Mitchell | Kansas | 20123 | 27 | 0 |
412630 | 412630 | 2020-08-08 | Mitchell | Kansas | 20123 | 27 | 0 |
409410 | 409410 | 2020-08-07 | Mitchell | Kansas | 20123 | 27 | 0 |
406191 | 406191 | 2020-08-06 | Mitchell | Kansas | 20123 | 27 | 0 |
402973 | 402973 | 2020-08-05 | Mitchell | Kansas | 20123 | 27 | 0 |
399756 | 399756 | 2020-08-04 | Mitchell | Kansas | 20123 | 27 | 0 |
396541 | 396541 | 2020-08-03 | Mitchell | Kansas | 20123 | 27 | 0 |
393325 | 393325 | 2020-08-02 | Mitchell | Kansas | 20123 | 27 | 0 |
390108 | 390108 | 2020-08-01 | Mitchell | Kansas | 20123 | 27 | 0 |
386891 | 386891 | 2020-07-31 | Mitchell | Kansas | 20123 | 27 | 0 |
383673 | 383673 | 2020-07-30 | Mitchell | Kansas | 20123 | 27 | 0 |
380456 | 380456 | 2020-07-29 | Mitchell | Kansas | 20123 | 27 | 0 |
377239 | 377239 | 2020-07-28 | Mitchell | Kansas | 20123 | 26 | 0 |
374024 | 374024 | 2020-07-27 | Mitchell | Kansas | 20123 | 26 | 0 |
370812 | 370812 | 2020-07-26 | Mitchell | Kansas | 20123 | 22 | 0 |
367602 | 367602 | 2020-07-25 | Mitchell | Kansas | 20123 | 22 | 0 |
364395 | 364395 | 2020-07-24 | Mitchell | Kansas | 20123 | 22 | 0 |
361188 | 361188 | 2020-07-23 | Mitchell | Kansas | 20123 | 22 | 0 |
357983 | 357983 | 2020-07-22 | Mitchell | Kansas | 20123 | 22 | 0 |
354781 | 354781 | 2020-07-21 | Mitchell | Kansas | 20123 | 22 | 0 |
351579 | 351579 | 2020-07-20 | Mitchell | Kansas | 20123 | 22 | 0 |
348379 | 348379 | 2020-07-19 | Mitchell | Kansas | 20123 | 22 | 0 |
345178 | 345178 | 2020-07-18 | Mitchell | Kansas | 20123 | 22 | 0 |
341978 | 341978 | 2020-07-17 | Mitchell | Kansas | 20123 | 22 | 0 |
338782 | 338782 | 2020-07-16 | Mitchell | Kansas | 20123 | 16 | 0 |
335586 | 335586 | 2020-07-15 | Mitchell | Kansas | 20123 | 16 | 0 |
332393 | 332393 | 2020-07-14 | Mitchell | Kansas | 20123 | 13 | 0 |
329206 | 329206 | 2020-07-13 | Mitchell | Kansas | 20123 | 13 | 0 |
326020 | 326020 | 2020-07-12 | Mitchell | Kansas | 20123 | 13 | 0 |
322837 | 322837 | 2020-07-11 | Mitchell | Kansas | 20123 | 11 | 0 |
319658 | 319658 | 2020-07-10 | Mitchell | Kansas | 20123 | 11 | 0 |
316484 | 316484 | 2020-07-09 | Mitchell | Kansas | 20123 | 5 | 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);