ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,448 rows where county = "Wichita" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4318 | 4318 | 2020-03-18 | Wichita | Texas | 48485 | 1 | 0 |
5074 | 5074 | 2020-03-19 | Wichita | Texas | 48485 | 1 | 0 |
5968 | 5968 | 2020-03-20 | Wichita | Texas | 48485 | 4 | 0 |
6991 | 6991 | 2020-03-21 | Wichita | Texas | 48485 | 4 | 0 |
8121 | 8121 | 2020-03-22 | Wichita | Texas | 48485 | 5 | 0 |
9340 | 9340 | 2020-03-23 | Wichita | Texas | 48485 | 5 | 0 |
10684 | 10684 | 2020-03-24 | Wichita | Texas | 48485 | 6 | 0 |
12193 | 12193 | 2020-03-25 | Wichita | Texas | 48485 | 6 | 0 |
13828 | 13828 | 2020-03-26 | Wichita | Texas | 48485 | 8 | 0 |
15591 | 15591 | 2020-03-27 | Wichita | Texas | 48485 | 15 | 0 |
17463 | 17463 | 2020-03-28 | Wichita | Texas | 48485 | 15 | 0 |
19422 | 19422 | 2020-03-29 | Wichita | Texas | 48485 | 28 | 0 |
21484 | 21484 | 2020-03-30 | Wichita | Texas | 48485 | 28 | 0 |
23623 | 23623 | 2020-03-31 | Wichita | Texas | 48485 | 30 | 0 |
25837 | 25837 | 2020-04-01 | Wichita | Texas | 48485 | 38 | 0 |
28125 | 28125 | 2020-04-02 | Wichita | Texas | 48485 | 43 | 0 |
30462 | 30462 | 2020-04-03 | Wichita | Texas | 48485 | 44 | 0 |
32860 | 32860 | 2020-04-04 | Wichita | Texas | 48485 | 44 | 0 |
35298 | 35298 | 2020-04-05 | Wichita | Texas | 48485 | 46 | 0 |
37775 | 37775 | 2020-04-06 | Wichita | Texas | 48485 | 48 | 0 |
40304 | 40304 | 2020-04-07 | Wichita | Texas | 48485 | 48 | 0 |
42872 | 42872 | 2020-04-08 | Wichita | Texas | 48485 | 50 | 0 |
45466 | 45466 | 2020-04-09 | Wichita | Texas | 48485 | 50 | 0 |
48089 | 48089 | 2020-04-10 | Wichita | Texas | 48485 | 54 | 0 |
50747 | 50747 | 2020-04-11 | Wichita | Texas | 48485 | 54 | 0 |
53422 | 53422 | 2020-04-12 | Wichita | Texas | 48485 | 56 | 0 |
56111 | 56111 | 2020-04-13 | Wichita | Texas | 48485 | 56 | 0 |
58816 | 58816 | 2020-04-14 | Wichita | Texas | 48485 | 56 | 0 |
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 |
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);