ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Montgomery" and fips = 20125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
940865 | 940865 | 2021-01-18 | Montgomery | Kansas | 20125 | 2785 | 6 |
937620 | 937620 | 2021-01-17 | Montgomery | Kansas | 20125 | 2750 | 6 |
934375 | 934375 | 2021-01-16 | Montgomery | Kansas | 20125 | 2750 | 6 |
931130 | 931130 | 2021-01-15 | Montgomery | Kansas | 20125 | 2750 | 6 |
927885 | 927885 | 2021-01-14 | Montgomery | Kansas | 20125 | 2681 | 6 |
924639 | 924639 | 2021-01-13 | Montgomery | Kansas | 20125 | 2681 | 6 |
921394 | 921394 | 2021-01-12 | Montgomery | Kansas | 20125 | 2607 | 6 |
918149 | 918149 | 2021-01-11 | Montgomery | Kansas | 20125 | 2607 | 6 |
914904 | 914904 | 2021-01-10 | Montgomery | Kansas | 20125 | 2530 | 6 |
911659 | 911659 | 2021-01-09 | Montgomery | Kansas | 20125 | 2530 | 6 |
908414 | 908414 | 2021-01-08 | Montgomery | Kansas | 20125 | 2530 | 6 |
905168 | 905168 | 2021-01-07 | Montgomery | Kansas | 20125 | 2451 | 6 |
901923 | 901923 | 2021-01-06 | Montgomery | Kansas | 20125 | 2451 | 6 |
898678 | 898678 | 2021-01-05 | Montgomery | Kansas | 20125 | 2376 | 6 |
895433 | 895433 | 2021-01-04 | Montgomery | Kansas | 20125 | 2376 | 6 |
892186 | 892186 | 2021-01-03 | Montgomery | Kansas | 20125 | 2316 | 6 |
888940 | 888940 | 2021-01-02 | Montgomery | Kansas | 20125 | 2316 | 6 |
885694 | 885694 | 2021-01-01 | Montgomery | Kansas | 20125 | 2316 | 6 |
882449 | 882449 | 2020-12-31 | Montgomery | Kansas | 20125 | 2244 | 6 |
879204 | 879204 | 2020-12-30 | Montgomery | Kansas | 20125 | 2244 | 6 |
875959 | 875959 | 2020-12-29 | Montgomery | Kansas | 20125 | 2088 | 6 |
872714 | 872714 | 2020-12-28 | Montgomery | Kansas | 20125 | 2088 | 6 |
869469 | 869469 | 2020-12-27 | Montgomery | Kansas | 20125 | 1985 | 6 |
866224 | 866224 | 2020-12-26 | Montgomery | Kansas | 20125 | 1985 | 6 |
862979 | 862979 | 2020-12-25 | Montgomery | Kansas | 20125 | 1985 | 6 |
859734 | 859734 | 2020-12-24 | Montgomery | Kansas | 20125 | 1985 | 6 |
856489 | 856489 | 2020-12-23 | Montgomery | Kansas | 20125 | 1985 | 6 |
853244 | 853244 | 2020-12-22 | Montgomery | Kansas | 20125 | 1866 | 6 |
849999 | 849999 | 2020-12-21 | Montgomery | Kansas | 20125 | 1866 | 6 |
846754 | 846754 | 2020-12-20 | Montgomery | Kansas | 20125 | 1782 | 6 |
843508 | 843508 | 2020-12-19 | Montgomery | Kansas | 20125 | 1782 | 6 |
840263 | 840263 | 2020-12-18 | Montgomery | Kansas | 20125 | 1782 | 6 |
837018 | 837018 | 2020-12-17 | Montgomery | Kansas | 20125 | 1671 | 6 |
833772 | 833772 | 2020-12-16 | Montgomery | Kansas | 20125 | 1671 | 6 |
830525 | 830525 | 2020-12-15 | Montgomery | Kansas | 20125 | 1526 | 6 |
827279 | 827279 | 2020-12-14 | Montgomery | Kansas | 20125 | 1526 | 6 |
824032 | 824032 | 2020-12-13 | Montgomery | Kansas | 20125 | 1480 | 6 |
820786 | 820786 | 2020-12-12 | Montgomery | Kansas | 20125 | 1480 | 6 |
817540 | 817540 | 2020-12-11 | Montgomery | Kansas | 20125 | 1480 | 6 |
814294 | 814294 | 2020-12-10 | Montgomery | Kansas | 20125 | 1402 | 6 |
811049 | 811049 | 2020-12-09 | Montgomery | Kansas | 20125 | 1402 | 6 |
807804 | 807804 | 2020-12-08 | Montgomery | Kansas | 20125 | 1316 | 6 |
804559 | 804559 | 2020-12-07 | Montgomery | Kansas | 20125 | 1316 | 6 |
801314 | 801314 | 2020-12-06 | Montgomery | Kansas | 20125 | 1269 | 6 |
798069 | 798069 | 2020-12-05 | Montgomery | Kansas | 20125 | 1269 | 6 |
794824 | 794824 | 2020-12-04 | Montgomery | Kansas | 20125 | 1269 | 6 |
791579 | 791579 | 2020-12-03 | Montgomery | Kansas | 20125 | 1225 | 6 |
788334 | 788334 | 2020-12-02 | Montgomery | Kansas | 20125 | 1225 | 6 |
785090 | 785090 | 2020-12-01 | Montgomery | Kansas | 20125 | 1158 | 6 |
781845 | 781845 | 2020-11-30 | Montgomery | Kansas | 20125 | 1158 | 6 |
778599 | 778599 | 2020-11-29 | Montgomery | Kansas | 20125 | 1128 | 6 |
775354 | 775354 | 2020-11-28 | Montgomery | Kansas | 20125 | 1128 | 6 |
772109 | 772109 | 2020-11-27 | Montgomery | Kansas | 20125 | 1128 | 6 |
768864 | 768864 | 2020-11-26 | Montgomery | Kansas | 20125 | 1092 | 6 |
765618 | 765618 | 2020-11-25 | Montgomery | Kansas | 20125 | 1092 | 6 |
762373 | 762373 | 2020-11-24 | Montgomery | Kansas | 20125 | 1029 | 6 |
759128 | 759128 | 2020-11-23 | Montgomery | Kansas | 20125 | 1029 | 6 |
755881 | 755881 | 2020-11-22 | Montgomery | Kansas | 20125 | 969 | 6 |
752635 | 752635 | 2020-11-21 | Montgomery | Kansas | 20125 | 969 | 6 |
749389 | 749389 | 2020-11-20 | Montgomery | Kansas | 20125 | 969 | 6 |
746143 | 746143 | 2020-11-19 | Montgomery | Kansas | 20125 | 940 | 6 |
742896 | 742896 | 2020-11-18 | Montgomery | Kansas | 20125 | 940 | 6 |
739649 | 739649 | 2020-11-17 | Montgomery | Kansas | 20125 | 879 | 6 |
736405 | 736405 | 2020-11-16 | Montgomery | Kansas | 20125 | 879 | 6 |
733159 | 733159 | 2020-11-15 | Montgomery | Kansas | 20125 | 862 | 6 |
729914 | 729914 | 2020-11-14 | Montgomery | Kansas | 20125 | 862 | 6 |
726671 | 726671 | 2020-11-13 | Montgomery | Kansas | 20125 | 862 | 6 |
723428 | 723428 | 2020-11-12 | Montgomery | Kansas | 20125 | 831 | 6 |
720185 | 720185 | 2020-11-11 | Montgomery | Kansas | 20125 | 831 | 6 |
716942 | 716942 | 2020-11-10 | Montgomery | Kansas | 20125 | 789 | 6 |
713698 | 713698 | 2020-11-09 | Montgomery | Kansas | 20125 | 789 | 6 |
710454 | 710454 | 2020-11-08 | Montgomery | Kansas | 20125 | 767 | 6 |
707210 | 707210 | 2020-11-07 | Montgomery | Kansas | 20125 | 767 | 6 |
703967 | 703967 | 2020-11-06 | Montgomery | Kansas | 20125 | 767 | 6 |
700725 | 700725 | 2020-11-05 | Montgomery | Kansas | 20125 | 751 | 6 |
697481 | 697481 | 2020-11-04 | Montgomery | Kansas | 20125 | 751 | 6 |
694239 | 694239 | 2020-11-03 | Montgomery | Kansas | 20125 | 736 | 6 |
690996 | 690996 | 2020-11-02 | Montgomery | Kansas | 20125 | 736 | 6 |
687751 | 687751 | 2020-11-01 | Montgomery | Kansas | 20125 | 722 | 6 |
684507 | 684507 | 2020-10-31 | Montgomery | Kansas | 20125 | 722 | 6 |
681264 | 681264 | 2020-10-30 | Montgomery | Kansas | 20125 | 722 | 6 |
678021 | 678021 | 2020-10-29 | Montgomery | Kansas | 20125 | 703 | 6 |
674778 | 674778 | 2020-10-28 | Montgomery | Kansas | 20125 | 703 | 6 |
671536 | 671536 | 2020-10-27 | Montgomery | Kansas | 20125 | 689 | 6 |
668293 | 668293 | 2020-10-26 | Montgomery | Kansas | 20125 | 689 | 6 |
665049 | 665049 | 2020-10-25 | Montgomery | Kansas | 20125 | 666 | 6 |
661804 | 661804 | 2020-10-24 | Montgomery | Kansas | 20125 | 666 | 6 |
658560 | 658560 | 2020-10-23 | Montgomery | Kansas | 20125 | 666 | 6 |
655315 | 655315 | 2020-10-22 | Montgomery | Kansas | 20125 | 653 | 6 |
652070 | 652070 | 2020-10-21 | Montgomery | Kansas | 20125 | 653 | 6 |
648826 | 648826 | 2020-10-20 | Montgomery | Kansas | 20125 | 628 | 6 |
645581 | 645581 | 2020-10-19 | Montgomery | Kansas | 20125 | 628 | 6 |
642334 | 642334 | 2020-10-18 | Montgomery | Kansas | 20125 | 609 | 6 |
639087 | 639087 | 2020-10-17 | Montgomery | Kansas | 20125 | 609 | 6 |
635841 | 635841 | 2020-10-16 | Montgomery | Kansas | 20125 | 609 | 6 |
632595 | 632595 | 2020-10-15 | Montgomery | Kansas | 20125 | 582 | 6 |
629351 | 629351 | 2020-10-14 | Montgomery | Kansas | 20125 | 582 | 6 |
626108 | 626108 | 2020-10-13 | Montgomery | Kansas | 20125 | 562 | 6 |
622866 | 622866 | 2020-10-12 | Montgomery | Kansas | 20125 | 562 | 6 |
619622 | 619622 | 2020-10-11 | Montgomery | Kansas | 20125 | 538 | 6 |
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);