ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 20173 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635865 | 635865 | 2020-10-16 | Sedgwick | Kansas | 20173 | 10577 | 120 |
632619 | 632619 | 2020-10-15 | Sedgwick | Kansas | 20173 | 10298 | 114 |
629375 | 629375 | 2020-10-14 | Sedgwick | Kansas | 20173 | 10298 | 107 |
626132 | 626132 | 2020-10-13 | Sedgwick | Kansas | 20173 | 10149 | 107 |
622890 | 622890 | 2020-10-12 | Sedgwick | Kansas | 20173 | 10149 | 106 |
619646 | 619646 | 2020-10-11 | Sedgwick | Kansas | 20173 | 9839 | 106 |
616404 | 616404 | 2020-10-10 | Sedgwick | Kansas | 20173 | 9839 | 106 |
613163 | 613163 | 2020-10-09 | Sedgwick | Kansas | 20173 | 9839 | 104 |
609921 | 609921 | 2020-10-08 | Sedgwick | Kansas | 20173 | 9599 | 94 |
606678 | 606678 | 2020-10-07 | Sedgwick | Kansas | 20173 | 9599 | 94 |
603436 | 603436 | 2020-10-06 | Sedgwick | Kansas | 20173 | 9509 | 94 |
600193 | 600193 | 2020-10-05 | Sedgwick | Kansas | 20173 | 9509 | 93 |
596951 | 596951 | 2020-10-04 | Sedgwick | Kansas | 20173 | 9276 | 93 |
593709 | 593709 | 2020-10-03 | Sedgwick | Kansas | 20173 | 9276 | 93 |
590468 | 590468 | 2020-10-02 | Sedgwick | Kansas | 20173 | 9276 | 93 |
587227 | 587227 | 2020-10-01 | Sedgwick | Kansas | 20173 | 9102 | 93 |
583987 | 583987 | 2020-09-30 | Sedgwick | Kansas | 20173 | 9102 | 93 |
580748 | 580748 | 2020-09-29 | Sedgwick | Kansas | 20173 | 9008 | 86 |
577507 | 577507 | 2020-09-28 | Sedgwick | Kansas | 20173 | 9008 | 86 |
574265 | 574265 | 2020-09-27 | Sedgwick | Kansas | 20173 | 8757 | 86 |
571022 | 571022 | 2020-09-26 | Sedgwick | Kansas | 20173 | 8757 | 86 |
567780 | 567780 | 2020-09-25 | Sedgwick | Kansas | 20173 | 8757 | 86 |
564540 | 564540 | 2020-09-24 | Sedgwick | Kansas | 20173 | 8577 | 85 |
561300 | 561300 | 2020-09-23 | Sedgwick | Kansas | 20173 | 8577 | 85 |
558064 | 558064 | 2020-09-22 | Sedgwick | Kansas | 20173 | 8465 | 85 |
554827 | 554827 | 2020-09-21 | Sedgwick | Kansas | 20173 | 8465 | 82 |
551588 | 551588 | 2020-09-20 | Sedgwick | Kansas | 20173 | 8270 | 81 |
548349 | 548349 | 2020-09-19 | Sedgwick | Kansas | 20173 | 8270 | 81 |
545111 | 545111 | 2020-09-18 | Sedgwick | Kansas | 20173 | 8270 | 81 |
541875 | 541875 | 2020-09-17 | Sedgwick | Kansas | 20173 | 8107 | 81 |
538638 | 538638 | 2020-09-16 | Sedgwick | Kansas | 20173 | 8107 | 81 |
535402 | 535402 | 2020-09-15 | Sedgwick | Kansas | 20173 | 8040 | 69 |
532167 | 532167 | 2020-09-14 | Sedgwick | Kansas | 20173 | 8040 | 68 |
528930 | 528930 | 2020-09-13 | Sedgwick | Kansas | 20173 | 7839 | 68 |
525694 | 525694 | 2020-09-12 | Sedgwick | Kansas | 20173 | 7839 | 68 |
522458 | 522458 | 2020-09-11 | Sedgwick | Kansas | 20173 | 7839 | 63 |
519221 | 519221 | 2020-09-10 | Sedgwick | Kansas | 20173 | 7763 | 56 |
515986 | 515986 | 2020-09-09 | Sedgwick | Kansas | 20173 | 7763 | 56 |
512753 | 512753 | 2020-09-08 | Sedgwick | Kansas | 20173 | 7714 | 56 |
509520 | 509520 | 2020-09-07 | Sedgwick | Kansas | 20173 | 7714 | 56 |
506288 | 506288 | 2020-09-06 | Sedgwick | Kansas | 20173 | 7550 | 56 |
503054 | 503054 | 2020-09-05 | Sedgwick | Kansas | 20173 | 7550 | 55 |
499820 | 499820 | 2020-09-04 | Sedgwick | Kansas | 20173 | 7550 | 55 |
496587 | 496587 | 2020-09-03 | Sedgwick | Kansas | 20173 | 7399 | 55 |
493353 | 493353 | 2020-09-02 | Sedgwick | Kansas | 20173 | 7399 | 50 |
490120 | 490120 | 2020-09-01 | Sedgwick | Kansas | 20173 | 7306 | 50 |
486887 | 486887 | 2020-08-31 | Sedgwick | Kansas | 20173 | 7306 | 50 |
483652 | 483652 | 2020-08-30 | Sedgwick | Kansas | 20173 | 7093 | 50 |
480418 | 480418 | 2020-08-29 | Sedgwick | Kansas | 20173 | 7093 | 50 |
477185 | 477185 | 2020-08-28 | Sedgwick | Kansas | 20173 | 7093 | 50 |
473952 | 473952 | 2020-08-27 | Sedgwick | Kansas | 20173 | 6992 | 50 |
470720 | 470720 | 2020-08-26 | Sedgwick | Kansas | 20173 | 6992 | 50 |
467491 | 467491 | 2020-08-25 | Sedgwick | Kansas | 20173 | 6652 | 48 |
464262 | 464262 | 2020-08-24 | Sedgwick | Kansas | 20173 | 6652 | 48 |
461032 | 461032 | 2020-08-23 | Sedgwick | Kansas | 20173 | 6386 | 48 |
457805 | 457805 | 2020-08-22 | Sedgwick | Kansas | 20173 | 6386 | 48 |
454577 | 454577 | 2020-08-21 | Sedgwick | Kansas | 20173 | 6386 | 48 |
451349 | 451349 | 2020-08-20 | Sedgwick | Kansas | 20173 | 6212 | 47 |
448121 | 448121 | 2020-08-19 | Sedgwick | Kansas | 20173 | 6212 | 47 |
444894 | 444894 | 2020-08-18 | Sedgwick | Kansas | 20173 | 6102 | 47 |
441668 | 441668 | 2020-08-17 | Sedgwick | Kansas | 20173 | 6102 | 47 |
438441 | 438441 | 2020-08-16 | Sedgwick | Kansas | 20173 | 5718 | 47 |
435216 | 435216 | 2020-08-15 | Sedgwick | Kansas | 20173 | 5718 | 47 |
431991 | 431991 | 2020-08-14 | Sedgwick | Kansas | 20173 | 5718 | 47 |
428763 | 428763 | 2020-08-13 | Sedgwick | Kansas | 20173 | 5334 | 46 |
425539 | 425539 | 2020-08-12 | Sedgwick | Kansas | 20173 | 5334 | 46 |
422318 | 422318 | 2020-08-11 | Sedgwick | Kansas | 20173 | 5207 | 46 |
419095 | 419095 | 2020-08-10 | Sedgwick | Kansas | 20173 | 5207 | 44 |
415874 | 415874 | 2020-08-09 | Sedgwick | Kansas | 20173 | 4935 | 44 |
412654 | 412654 | 2020-08-08 | Sedgwick | Kansas | 20173 | 4935 | 44 |
409434 | 409434 | 2020-08-07 | Sedgwick | Kansas | 20173 | 4935 | 44 |
406215 | 406215 | 2020-08-06 | Sedgwick | Kansas | 20173 | 4723 | 44 |
402997 | 402997 | 2020-08-05 | Sedgwick | Kansas | 20173 | 4723 | 43 |
399780 | 399780 | 2020-08-04 | Sedgwick | Kansas | 20173 | 4506 | 43 |
396565 | 396565 | 2020-08-03 | Sedgwick | Kansas | 20173 | 4506 | 43 |
393349 | 393349 | 2020-08-02 | Sedgwick | Kansas | 20173 | 4287 | 42 |
390132 | 390132 | 2020-08-01 | Sedgwick | Kansas | 20173 | 4196 | 39 |
386915 | 386915 | 2020-07-31 | Sedgwick | Kansas | 20173 | 4196 | 39 |
383697 | 383697 | 2020-07-30 | Sedgwick | Kansas | 20173 | 3962 | 39 |
380480 | 380480 | 2020-07-29 | Sedgwick | Kansas | 20173 | 3951 | 38 |
377263 | 377263 | 2020-07-28 | Sedgwick | Kansas | 20173 | 3816 | 38 |
374048 | 374048 | 2020-07-27 | Sedgwick | Kansas | 20173 | 3816 | 36 |
370836 | 370836 | 2020-07-26 | Sedgwick | Kansas | 20173 | 3646 | 36 |
367626 | 367626 | 2020-07-25 | Sedgwick | Kansas | 20173 | 3579 | 36 |
364419 | 364419 | 2020-07-24 | Sedgwick | Kansas | 20173 | 3579 | 35 |
361212 | 361212 | 2020-07-23 | Sedgwick | Kansas | 20173 | 3368 | 33 |
358007 | 358007 | 2020-07-22 | Sedgwick | Kansas | 20173 | 3368 | 33 |
354805 | 354805 | 2020-07-21 | Sedgwick | Kansas | 20173 | 3162 | 33 |
351603 | 351603 | 2020-07-20 | Sedgwick | Kansas | 20173 | 3162 | 32 |
348403 | 348403 | 2020-07-19 | Sedgwick | Kansas | 20173 | 2790 | 32 |
345202 | 345202 | 2020-07-18 | Sedgwick | Kansas | 20173 | 2790 | 32 |
342002 | 342002 | 2020-07-17 | Sedgwick | Kansas | 20173 | 2790 | 32 |
338806 | 338806 | 2020-07-16 | Sedgwick | Kansas | 20173 | 2595 | 32 |
335610 | 335610 | 2020-07-15 | Sedgwick | Kansas | 20173 | 2595 | 32 |
332417 | 332417 | 2020-07-14 | Sedgwick | Kansas | 20173 | 2422 | 28 |
329230 | 329230 | 2020-07-13 | Sedgwick | Kansas | 20173 | 2422 | 28 |
326044 | 326044 | 2020-07-12 | Sedgwick | Kansas | 20173 | 2074 | 28 |
322861 | 322861 | 2020-07-11 | Sedgwick | Kansas | 20173 | 2074 | 28 |
319682 | 319682 | 2020-07-10 | Sedgwick | Kansas | 20173 | 2074 | 28 |
316507 | 316507 | 2020-07-09 | Sedgwick | Kansas | 20173 | 1922 | 28 |
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);