ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Montgomery" and state = "Kansas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1077182 | 1077182 | 2021-03-01 | Montgomery | Kansas | 20125 | 3285 | 6 |
1073936 | 1073936 | 2021-02-28 | Montgomery | Kansas | 20125 | 3265 | 6 |
1070690 | 1070690 | 2021-02-27 | Montgomery | Kansas | 20125 | 3265 | 6 |
1067445 | 1067445 | 2021-02-26 | Montgomery | Kansas | 20125 | 3265 | 6 |
1064200 | 1064200 | 2021-02-25 | Montgomery | Kansas | 20125 | 3237 | 6 |
1060955 | 1060955 | 2021-02-24 | Montgomery | Kansas | 20125 | 3237 | 6 |
1057709 | 1057709 | 2021-02-23 | Montgomery | Kansas | 20125 | 3225 | 6 |
1054463 | 1054463 | 2021-02-22 | Montgomery | Kansas | 20125 | 3225 | 6 |
1051216 | 1051216 | 2021-02-21 | Montgomery | Kansas | 20125 | 3218 | 6 |
1047969 | 1047969 | 2021-02-20 | Montgomery | Kansas | 20125 | 3218 | 6 |
1044724 | 1044724 | 2021-02-19 | Montgomery | Kansas | 20125 | 3218 | 6 |
1041479 | 1041479 | 2021-02-18 | Montgomery | Kansas | 20125 | 3197 | 6 |
1038234 | 1038234 | 2021-02-17 | Montgomery | Kansas | 20125 | 3197 | 6 |
1034989 | 1034989 | 2021-02-16 | Montgomery | Kansas | 20125 | 3193 | 6 |
1031743 | 1031743 | 2021-02-15 | Montgomery | Kansas | 20125 | 3193 | 6 |
1028496 | 1028496 | 2021-02-14 | Montgomery | Kansas | 20125 | 3176 | 6 |
1025251 | 1025251 | 2021-02-13 | Montgomery | Kansas | 20125 | 3176 | 6 |
1022006 | 1022006 | 2021-02-12 | Montgomery | Kansas | 20125 | 3176 | 6 |
1018761 | 1018761 | 2021-02-11 | Montgomery | Kansas | 20125 | 3142 | 6 |
1015516 | 1015516 | 2021-02-10 | Montgomery | Kansas | 20125 | 3142 | 6 |
1012271 | 1012271 | 2021-02-09 | Montgomery | Kansas | 20125 | 3111 | 6 |
1009025 | 1009025 | 2021-02-08 | Montgomery | Kansas | 20125 | 3111 | 6 |
1005779 | 1005779 | 2021-02-07 | Montgomery | Kansas | 20125 | 3089 | 6 |
1002533 | 1002533 | 2021-02-06 | Montgomery | Kansas | 20125 | 3089 | 6 |
999287 | 999287 | 2021-02-05 | Montgomery | Kansas | 20125 | 3089 | 6 |
996041 | 996041 | 2021-02-04 | Montgomery | Kansas | 20125 | 3043 | 6 |
992795 | 992795 | 2021-02-03 | Montgomery | Kansas | 20125 | 3043 | 6 |
989549 | 989549 | 2021-02-02 | Montgomery | Kansas | 20125 | 3017 | 6 |
986302 | 986302 | 2021-02-01 | Montgomery | Kansas | 20125 | 3017 | 6 |
983055 | 983055 | 2021-01-31 | Montgomery | Kansas | 20125 | 2995 | 6 |
979809 | 979809 | 2021-01-30 | Montgomery | Kansas | 20125 | 2995 | 6 |
976563 | 976563 | 2021-01-29 | Montgomery | Kansas | 20125 | 2995 | 6 |
973318 | 973318 | 2021-01-28 | Montgomery | Kansas | 20125 | 2966 | 6 |
970073 | 970073 | 2021-01-27 | Montgomery | Kansas | 20125 | 2966 | 6 |
966829 | 966829 | 2021-01-26 | Montgomery | Kansas | 20125 | 2933 | 6 |
963584 | 963584 | 2021-01-25 | Montgomery | Kansas | 20125 | 2933 | 6 |
960339 | 960339 | 2021-01-24 | Montgomery | Kansas | 20125 | 2895 | 6 |
957093 | 957093 | 2021-01-23 | Montgomery | Kansas | 20125 | 2895 | 6 |
953848 | 953848 | 2021-01-22 | Montgomery | Kansas | 20125 | 2895 | 6 |
950603 | 950603 | 2021-01-21 | Montgomery | Kansas | 20125 | 2855 | 6 |
947357 | 947357 | 2021-01-20 | Montgomery | Kansas | 20125 | 2855 | 6 |
944110 | 944110 | 2021-01-19 | Montgomery | Kansas | 20125 | 2785 | 6 |
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 |
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);