ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
661 rows where county = "Wichita" and state = "Kansas" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
358021 | 358021 | 2020-07-22 | Wichita | Kansas | 20203 | 1 | 0 |
361226 | 361226 | 2020-07-23 | Wichita | Kansas | 20203 | 1 | 0 |
364433 | 364433 | 2020-07-24 | Wichita | Kansas | 20203 | 2 | 0 |
367640 | 367640 | 2020-07-25 | Wichita | Kansas | 20203 | 2 | 0 |
370850 | 370850 | 2020-07-26 | Wichita | Kansas | 20203 | 2 | 0 |
374062 | 374062 | 2020-07-27 | Wichita | Kansas | 20203 | 2 | 0 |
377277 | 377277 | 2020-07-28 | Wichita | Kansas | 20203 | 2 | 0 |
380494 | 380494 | 2020-07-29 | Wichita | Kansas | 20203 | 3 | 0 |
383711 | 383711 | 2020-07-30 | Wichita | Kansas | 20203 | 3 | 0 |
386929 | 386929 | 2020-07-31 | Wichita | Kansas | 20203 | 3 | 0 |
390146 | 390146 | 2020-08-01 | Wichita | Kansas | 20203 | 3 | 0 |
393363 | 393363 | 2020-08-02 | Wichita | Kansas | 20203 | 3 | 0 |
396579 | 396579 | 2020-08-03 | Wichita | Kansas | 20203 | 4 | 0 |
399794 | 399794 | 2020-08-04 | Wichita | Kansas | 20203 | 4 | 0 |
403011 | 403011 | 2020-08-05 | Wichita | Kansas | 20203 | 4 | 0 |
406229 | 406229 | 2020-08-06 | Wichita | Kansas | 20203 | 4 | 0 |
409449 | 409449 | 2020-08-07 | Wichita | Kansas | 20203 | 4 | 0 |
412669 | 412669 | 2020-08-08 | Wichita | Kansas | 20203 | 4 | 0 |
415889 | 415889 | 2020-08-09 | Wichita | Kansas | 20203 | 4 | 0 |
419110 | 419110 | 2020-08-10 | Wichita | Kansas | 20203 | 4 | 0 |
422332 | 422332 | 2020-08-11 | Wichita | Kansas | 20203 | 4 | 0 |
425553 | 425553 | 2020-08-12 | Wichita | Kansas | 20203 | 4 | 0 |
428777 | 428777 | 2020-08-13 | Wichita | Kansas | 20203 | 4 | 0 |
432005 | 432005 | 2020-08-14 | Wichita | Kansas | 20203 | 4 | 0 |
435230 | 435230 | 2020-08-15 | Wichita | Kansas | 20203 | 4 | 0 |
438455 | 438455 | 2020-08-16 | Wichita | Kansas | 20203 | 4 | 0 |
441682 | 441682 | 2020-08-17 | Wichita | Kansas | 20203 | 4 | 0 |
444908 | 444908 | 2020-08-18 | Wichita | Kansas | 20203 | 4 | 0 |
448135 | 448135 | 2020-08-19 | Wichita | Kansas | 20203 | 4 | 0 |
451363 | 451363 | 2020-08-20 | Wichita | Kansas | 20203 | 4 | 0 |
454591 | 454591 | 2020-08-21 | Wichita | Kansas | 20203 | 4 | 0 |
457819 | 457819 | 2020-08-22 | Wichita | Kansas | 20203 | 4 | 0 |
461046 | 461046 | 2020-08-23 | Wichita | Kansas | 20203 | 4 | 0 |
464277 | 464277 | 2020-08-24 | Wichita | Kansas | 20203 | 4 | 0 |
467506 | 467506 | 2020-08-25 | Wichita | Kansas | 20203 | 4 | 0 |
470735 | 470735 | 2020-08-26 | Wichita | Kansas | 20203 | 4 | 0 |
473967 | 473967 | 2020-08-27 | Wichita | Kansas | 20203 | 4 | 0 |
477200 | 477200 | 2020-08-28 | Wichita | Kansas | 20203 | 4 | 0 |
480433 | 480433 | 2020-08-29 | Wichita | Kansas | 20203 | 4 | 0 |
483667 | 483667 | 2020-08-30 | Wichita | Kansas | 20203 | 4 | 0 |
486902 | 486902 | 2020-08-31 | Wichita | Kansas | 20203 | 4 | 0 |
490135 | 490135 | 2020-09-01 | Wichita | Kansas | 20203 | 4 | 0 |
493369 | 493369 | 2020-09-02 | Wichita | Kansas | 20203 | 4 | 0 |
496602 | 496602 | 2020-09-03 | Wichita | Kansas | 20203 | 4 | 0 |
499836 | 499836 | 2020-09-04 | Wichita | Kansas | 20203 | 4 | 0 |
503069 | 503069 | 2020-09-05 | Wichita | Kansas | 20203 | 4 | 0 |
506303 | 506303 | 2020-09-06 | Wichita | Kansas | 20203 | 4 | 0 |
509536 | 509536 | 2020-09-07 | Wichita | Kansas | 20203 | 5 | 0 |
512768 | 512768 | 2020-09-08 | Wichita | Kansas | 20203 | 5 | 0 |
516001 | 516001 | 2020-09-09 | Wichita | Kansas | 20203 | 5 | 0 |
519236 | 519236 | 2020-09-10 | Wichita | Kansas | 20203 | 5 | 0 |
522473 | 522473 | 2020-09-11 | Wichita | Kansas | 20203 | 5 | 0 |
525709 | 525709 | 2020-09-12 | Wichita | Kansas | 20203 | 5 | 0 |
528945 | 528945 | 2020-09-13 | Wichita | Kansas | 20203 | 5 | 0 |
532182 | 532182 | 2020-09-14 | Wichita | Kansas | 20203 | 5 | 0 |
535417 | 535417 | 2020-09-15 | Wichita | Kansas | 20203 | 5 | 0 |
538654 | 538654 | 2020-09-16 | Wichita | Kansas | 20203 | 5 | 0 |
541890 | 541890 | 2020-09-17 | Wichita | Kansas | 20203 | 5 | 0 |
545126 | 545126 | 2020-09-18 | Wichita | Kansas | 20203 | 5 | 0 |
548364 | 548364 | 2020-09-19 | Wichita | Kansas | 20203 | 5 | 0 |
551603 | 551603 | 2020-09-20 | Wichita | Kansas | 20203 | 5 | 0 |
554842 | 554842 | 2020-09-21 | Wichita | Kansas | 20203 | 6 | 0 |
558079 | 558079 | 2020-09-22 | Wichita | Kansas | 20203 | 6 | 0 |
561315 | 561315 | 2020-09-23 | Wichita | Kansas | 20203 | 5 | 0 |
564555 | 564555 | 2020-09-24 | Wichita | Kansas | 20203 | 5 | 0 |
567795 | 567795 | 2020-09-25 | Wichita | Kansas | 20203 | 5 | 0 |
571037 | 571037 | 2020-09-26 | Wichita | Kansas | 20203 | 5 | 0 |
574280 | 574280 | 2020-09-27 | Wichita | Kansas | 20203 | 5 | 0 |
577522 | 577522 | 2020-09-28 | Wichita | Kansas | 20203 | 5 | 0 |
580763 | 580763 | 2020-09-29 | Wichita | Kansas | 20203 | 5 | 0 |
584003 | 584003 | 2020-09-30 | Wichita | Kansas | 20203 | 5 | 0 |
587243 | 587243 | 2020-10-01 | Wichita | Kansas | 20203 | 5 | 0 |
590484 | 590484 | 2020-10-02 | Wichita | Kansas | 20203 | 5 | 0 |
593725 | 593725 | 2020-10-03 | Wichita | Kansas | 20203 | 5 | 0 |
596967 | 596967 | 2020-10-04 | Wichita | Kansas | 20203 | 5 | 0 |
600209 | 600209 | 2020-10-05 | Wichita | Kansas | 20203 | 5 | 0 |
603452 | 603452 | 2020-10-06 | Wichita | Kansas | 20203 | 5 | 0 |
606694 | 606694 | 2020-10-07 | Wichita | Kansas | 20203 | 7 | 0 |
609936 | 609936 | 2020-10-08 | Wichita | Kansas | 20203 | 7 | 0 |
613178 | 613178 | 2020-10-09 | Wichita | Kansas | 20203 | 8 | 0 |
616419 | 616419 | 2020-10-10 | Wichita | Kansas | 20203 | 8 | 0 |
619661 | 619661 | 2020-10-11 | Wichita | Kansas | 20203 | 8 | 0 |
622905 | 622905 | 2020-10-12 | Wichita | Kansas | 20203 | 11 | 0 |
626147 | 626147 | 2020-10-13 | Wichita | Kansas | 20203 | 11 | 0 |
629391 | 629391 | 2020-10-14 | Wichita | Kansas | 20203 | 13 | 0 |
632635 | 632635 | 2020-10-15 | Wichita | Kansas | 20203 | 13 | 0 |
635881 | 635881 | 2020-10-16 | Wichita | Kansas | 20203 | 20 | 0 |
639127 | 639127 | 2020-10-17 | Wichita | Kansas | 20203 | 20 | 0 |
642374 | 642374 | 2020-10-18 | Wichita | Kansas | 20203 | 20 | 0 |
645621 | 645621 | 2020-10-19 | Wichita | Kansas | 20203 | 25 | 0 |
648865 | 648865 | 2020-10-20 | Wichita | Kansas | 20203 | 25 | 0 |
652110 | 652110 | 2020-10-21 | Wichita | Kansas | 20203 | 32 | 0 |
655355 | 655355 | 2020-10-22 | Wichita | Kansas | 20203 | 32 | 0 |
658600 | 658600 | 2020-10-23 | Wichita | Kansas | 20203 | 33 | 0 |
661844 | 661844 | 2020-10-24 | Wichita | Kansas | 20203 | 33 | 0 |
665089 | 665089 | 2020-10-25 | Wichita | Kansas | 20203 | 33 | 0 |
668333 | 668333 | 2020-10-26 | Wichita | Kansas | 20203 | 41 | 0 |
671575 | 671575 | 2020-10-27 | Wichita | Kansas | 20203 | 41 | 0 |
674818 | 674818 | 2020-10-28 | Wichita | Kansas | 20203 | 46 | 0 |
678060 | 678060 | 2020-10-29 | Wichita | Kansas | 20203 | 46 | 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);