ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 20111 and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635834 | 635834 | 2020-10-16 | Lyon | Kansas | 20111 | 1182 | 37 |
632588 | 632588 | 2020-10-15 | Lyon | Kansas | 20111 | 1171 | 37 |
629344 | 629344 | 2020-10-14 | Lyon | Kansas | 20111 | 1165 | 37 |
626101 | 626101 | 2020-10-13 | Lyon | Kansas | 20111 | 1154 | 37 |
622859 | 622859 | 2020-10-12 | Lyon | Kansas | 20111 | 1151 | 37 |
619615 | 619615 | 2020-10-11 | Lyon | Kansas | 20111 | 1130 | 37 |
616373 | 616373 | 2020-10-10 | Lyon | Kansas | 20111 | 1130 | 37 |
613132 | 613132 | 2020-10-09 | Lyon | Kansas | 20111 | 1130 | 37 |
609890 | 609890 | 2020-10-08 | Lyon | Kansas | 20111 | 1126 | 36 |
606647 | 606647 | 2020-10-07 | Lyon | Kansas | 20111 | 1115 | 36 |
603405 | 603405 | 2020-10-06 | Lyon | Kansas | 20111 | 1107 | 36 |
600162 | 600162 | 2020-10-05 | Lyon | Kansas | 20111 | 1098 | 35 |
596920 | 596920 | 2020-10-04 | Lyon | Kansas | 20111 | 1092 | 35 |
593678 | 593678 | 2020-10-03 | Lyon | Kansas | 20111 | 1092 | 35 |
590437 | 590437 | 2020-10-02 | Lyon | Kansas | 20111 | 1092 | 35 |
587196 | 587196 | 2020-10-01 | Lyon | Kansas | 20111 | 1088 | 35 |
583956 | 583956 | 2020-09-30 | Lyon | Kansas | 20111 | 1080 | 35 |
580717 | 580717 | 2020-09-29 | Lyon | Kansas | 20111 | 1075 | 35 |
577476 | 577476 | 2020-09-28 | Lyon | Kansas | 20111 | 1067 | 35 |
574234 | 574234 | 2020-09-27 | Lyon | Kansas | 20111 | 1051 | 33 |
570991 | 570991 | 2020-09-26 | Lyon | Kansas | 20111 | 1051 | 33 |
567749 | 567749 | 2020-09-25 | Lyon | Kansas | 20111 | 1051 | 33 |
564509 | 564509 | 2020-09-24 | Lyon | Kansas | 20111 | 1044 | 33 |
561269 | 561269 | 2020-09-23 | Lyon | Kansas | 20111 | 1036 | 33 |
558033 | 558033 | 2020-09-22 | Lyon | Kansas | 20111 | 1031 | 33 |
554796 | 554796 | 2020-09-21 | Lyon | Kansas | 20111 | 1027 | 27 |
551557 | 551557 | 2020-09-20 | Lyon | Kansas | 20111 | 1012 | 27 |
548318 | 548318 | 2020-09-19 | Lyon | Kansas | 20111 | 1012 | 27 |
545080 | 545080 | 2020-09-18 | Lyon | Kansas | 20111 | 1012 | 27 |
541844 | 541844 | 2020-09-17 | Lyon | Kansas | 20111 | 1007 | 21 |
538607 | 538607 | 2020-09-16 | Lyon | Kansas | 20111 | 996 | 21 |
535371 | 535371 | 2020-09-15 | Lyon | Kansas | 20111 | 988 | 20 |
532136 | 532136 | 2020-09-14 | Lyon | Kansas | 20111 | 981 | 20 |
528899 | 528899 | 2020-09-13 | Lyon | Kansas | 20111 | 971 | 19 |
525663 | 525663 | 2020-09-12 | Lyon | Kansas | 20111 | 971 | 19 |
522427 | 522427 | 2020-09-11 | Lyon | Kansas | 20111 | 971 | 19 |
519190 | 519190 | 2020-09-10 | Lyon | Kansas | 20111 | 959 | 19 |
515955 | 515955 | 2020-09-09 | Lyon | Kansas | 20111 | 951 | 19 |
512722 | 512722 | 2020-09-08 | Lyon | Kansas | 20111 | 945 | 19 |
509489 | 509489 | 2020-09-07 | Lyon | Kansas | 20111 | 913 | 19 |
506257 | 506257 | 2020-09-06 | Lyon | Kansas | 20111 | 913 | 19 |
503023 | 503023 | 2020-09-05 | Lyon | Kansas | 20111 | 913 | 19 |
499789 | 499789 | 2020-09-04 | Lyon | Kansas | 20111 | 913 | 19 |
496556 | 496556 | 2020-09-03 | Lyon | Kansas | 20111 | 898 | 19 |
493322 | 493322 | 2020-09-02 | Lyon | Kansas | 20111 | 890 | 17 |
490089 | 490089 | 2020-09-01 | Lyon | Kansas | 20111 | 878 | 17 |
486856 | 486856 | 2020-08-31 | Lyon | Kansas | 20111 | 870 | 17 |
483621 | 483621 | 2020-08-30 | Lyon | Kansas | 20111 | 855 | 17 |
480387 | 480387 | 2020-08-29 | Lyon | Kansas | 20111 | 855 | 17 |
477154 | 477154 | 2020-08-28 | Lyon | Kansas | 20111 | 855 | 17 |
473921 | 473921 | 2020-08-27 | Lyon | Kansas | 20111 | 845 | 17 |
470689 | 470689 | 2020-08-26 | Lyon | Kansas | 20111 | 836 | 17 |
467460 | 467460 | 2020-08-25 | Lyon | Kansas | 20111 | 828 | 14 |
464231 | 464231 | 2020-08-24 | Lyon | Kansas | 20111 | 820 | 14 |
461002 | 461002 | 2020-08-23 | Lyon | Kansas | 20111 | 796 | 14 |
457775 | 457775 | 2020-08-22 | Lyon | Kansas | 20111 | 796 | 14 |
454547 | 454547 | 2020-08-21 | Lyon | Kansas | 20111 | 796 | 14 |
451319 | 451319 | 2020-08-20 | Lyon | Kansas | 20111 | 781 | 14 |
448091 | 448091 | 2020-08-19 | Lyon | Kansas | 20111 | 769 | 14 |
444864 | 444864 | 2020-08-18 | Lyon | Kansas | 20111 | 765 | 14 |
441638 | 441638 | 2020-08-17 | Lyon | Kansas | 20111 | 762 | 14 |
438411 | 438411 | 2020-08-16 | Lyon | Kansas | 20111 | 734 | 14 |
435186 | 435186 | 2020-08-15 | Lyon | Kansas | 20111 | 734 | 14 |
431961 | 431961 | 2020-08-14 | Lyon | Kansas | 20111 | 734 | 14 |
428733 | 428733 | 2020-08-13 | Lyon | Kansas | 20111 | 731 | 14 |
425509 | 425509 | 2020-08-12 | Lyon | Kansas | 20111 | 726 | 14 |
422288 | 422288 | 2020-08-11 | Lyon | Kansas | 20111 | 716 | 14 |
419065 | 419065 | 2020-08-10 | Lyon | Kansas | 20111 | 710 | 14 |
415844 | 415844 | 2020-08-09 | Lyon | Kansas | 20111 | 697 | 13 |
412624 | 412624 | 2020-08-08 | Lyon | Kansas | 20111 | 697 | 13 |
409404 | 409404 | 2020-08-07 | Lyon | Kansas | 20111 | 697 | 13 |
406185 | 406185 | 2020-08-06 | Lyon | Kansas | 20111 | 694 | 13 |
402967 | 402967 | 2020-08-05 | Lyon | Kansas | 20111 | 686 | 13 |
399750 | 399750 | 2020-08-04 | Lyon | Kansas | 20111 | 680 | 13 |
396535 | 396535 | 2020-08-03 | Lyon | Kansas | 20111 | 676 | 13 |
393319 | 393319 | 2020-08-02 | Lyon | Kansas | 20111 | 644 | 11 |
390102 | 390102 | 2020-08-01 | Lyon | Kansas | 20111 | 644 | 11 |
386885 | 386885 | 2020-07-31 | Lyon | Kansas | 20111 | 644 | 11 |
383667 | 383667 | 2020-07-30 | Lyon | Kansas | 20111 | 640 | 11 |
380450 | 380450 | 2020-07-29 | Lyon | Kansas | 20111 | 629 | 10 |
377233 | 377233 | 2020-07-28 | Lyon | Kansas | 20111 | 624 | 9 |
374018 | 374018 | 2020-07-27 | Lyon | Kansas | 20111 | 620 | 8 |
370806 | 370806 | 2020-07-26 | Lyon | Kansas | 20111 | 600 | 8 |
367596 | 367596 | 2020-07-25 | Lyon | Kansas | 20111 | 600 | 8 |
364389 | 364389 | 2020-07-24 | Lyon | Kansas | 20111 | 600 | 8 |
361182 | 361182 | 2020-07-23 | Lyon | Kansas | 20111 | 594 | 8 |
357977 | 357977 | 2020-07-22 | Lyon | Kansas | 20111 | 586 | 7 |
354775 | 354775 | 2020-07-21 | Lyon | Kansas | 20111 | 576 | 7 |
351573 | 351573 | 2020-07-20 | Lyon | Kansas | 20111 | 570 | 7 |
348373 | 348373 | 2020-07-19 | Lyon | Kansas | 20111 | 550 | 7 |
345172 | 345172 | 2020-07-18 | Lyon | Kansas | 20111 | 550 | 7 |
341972 | 341972 | 2020-07-17 | Lyon | Kansas | 20111 | 550 | 7 |
338776 | 338776 | 2020-07-16 | Lyon | Kansas | 20111 | 543 | 7 |
335580 | 335580 | 2020-07-15 | Lyon | Kansas | 20111 | 536 | 7 |
332387 | 332387 | 2020-07-14 | Lyon | Kansas | 20111 | 533 | 7 |
329200 | 329200 | 2020-07-13 | Lyon | Kansas | 20111 | 532 | 7 |
326014 | 326014 | 2020-07-12 | Lyon | Kansas | 20111 | 523 | 7 |
322831 | 322831 | 2020-07-11 | Lyon | Kansas | 20111 | 523 | 7 |
319652 | 319652 | 2020-07-10 | Lyon | Kansas | 20111 | 523 | 7 |
316478 | 316478 | 2020-07-09 | Lyon | Kansas | 20111 | 515 | 7 |
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);