ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Montgomery" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1077088 | 1077088 | 2021-03-01 | Montgomery | Iowa | 19137 | 964 | 36 |
1073842 | 1073842 | 2021-02-28 | Montgomery | Iowa | 19137 | 964 | 36 |
1070596 | 1070596 | 2021-02-27 | Montgomery | Iowa | 19137 | 964 | 36 |
1067351 | 1067351 | 2021-02-26 | Montgomery | Iowa | 19137 | 964 | 36 |
1064106 | 1064106 | 2021-02-25 | Montgomery | Iowa | 19137 | 963 | 36 |
1060861 | 1060861 | 2021-02-24 | Montgomery | Iowa | 19137 | 958 | 36 |
1057615 | 1057615 | 2021-02-23 | Montgomery | Iowa | 19137 | 958 | 36 |
1054369 | 1054369 | 2021-02-22 | Montgomery | Iowa | 19137 | 958 | 36 |
1051122 | 1051122 | 2021-02-21 | Montgomery | Iowa | 19137 | 958 | 36 |
1047875 | 1047875 | 2021-02-20 | Montgomery | Iowa | 19137 | 958 | 36 |
1044630 | 1044630 | 2021-02-19 | Montgomery | Iowa | 19137 | 958 | 36 |
1041385 | 1041385 | 2021-02-18 | Montgomery | Iowa | 19137 | 957 | 36 |
1038140 | 1038140 | 2021-02-17 | Montgomery | Iowa | 19137 | 954 | 36 |
1034895 | 1034895 | 2021-02-16 | Montgomery | Iowa | 19137 | 954 | 36 |
1031649 | 1031649 | 2021-02-15 | Montgomery | Iowa | 19137 | 954 | 36 |
1028402 | 1028402 | 2021-02-14 | Montgomery | Iowa | 19137 | 954 | 36 |
1025157 | 1025157 | 2021-02-13 | Montgomery | Iowa | 19137 | 953 | 36 |
1021912 | 1021912 | 2021-02-12 | Montgomery | Iowa | 19137 | 953 | 36 |
1018667 | 1018667 | 2021-02-11 | Montgomery | Iowa | 19137 | 949 | 35 |
1015422 | 1015422 | 2021-02-10 | Montgomery | Iowa | 19137 | 948 | 35 |
1012177 | 1012177 | 2021-02-09 | Montgomery | Iowa | 19137 | 945 | 34 |
1008931 | 1008931 | 2021-02-08 | Montgomery | Iowa | 19137 | 941 | 34 |
1005685 | 1005685 | 2021-02-07 | Montgomery | Iowa | 19137 | 935 | 34 |
1002439 | 1002439 | 2021-02-06 | Montgomery | Iowa | 19137 | 935 | 34 |
999193 | 999193 | 2021-02-05 | Montgomery | Iowa | 19137 | 932 | 32 |
995947 | 995947 | 2021-02-04 | Montgomery | Iowa | 19137 | 932 | 32 |
992701 | 992701 | 2021-02-03 | Montgomery | Iowa | 19137 | 929 | 32 |
989455 | 989455 | 2021-02-02 | Montgomery | Iowa | 19137 | 927 | 30 |
986208 | 986208 | 2021-02-01 | Montgomery | Iowa | 19137 | 922 | 30 |
982961 | 982961 | 2021-01-31 | Montgomery | Iowa | 19137 | 921 | 30 |
979715 | 979715 | 2021-01-30 | Montgomery | Iowa | 19137 | 920 | 28 |
976469 | 976469 | 2021-01-29 | Montgomery | Iowa | 19137 | 914 | 27 |
973224 | 973224 | 2021-01-28 | Montgomery | Iowa | 19137 | 907 | 25 |
969979 | 969979 | 2021-01-27 | Montgomery | Iowa | 19137 | 901 | 24 |
966735 | 966735 | 2021-01-26 | Montgomery | Iowa | 19137 | 900 | 24 |
963490 | 963490 | 2021-01-25 | Montgomery | Iowa | 19137 | 892 | 24 |
960245 | 960245 | 2021-01-24 | Montgomery | Iowa | 19137 | 891 | 24 |
956999 | 956999 | 2021-01-23 | Montgomery | Iowa | 19137 | 883 | 24 |
953754 | 953754 | 2021-01-22 | Montgomery | Iowa | 19137 | 880 | 24 |
950509 | 950509 | 2021-01-21 | Montgomery | Iowa | 19137 | 872 | 24 |
947263 | 947263 | 2021-01-20 | Montgomery | Iowa | 19137 | 864 | 23 |
944016 | 944016 | 2021-01-19 | Montgomery | Iowa | 19137 | 856 | 22 |
940771 | 940771 | 2021-01-18 | Montgomery | Iowa | 19137 | 848 | 22 |
937526 | 937526 | 2021-01-17 | Montgomery | Iowa | 19137 | 840 | 22 |
934281 | 934281 | 2021-01-16 | Montgomery | Iowa | 19137 | 840 | 22 |
931036 | 931036 | 2021-01-15 | Montgomery | Iowa | 19137 | 840 | 22 |
927791 | 927791 | 2021-01-14 | Montgomery | Iowa | 19137 | 827 | 22 |
924545 | 924545 | 2021-01-13 | Montgomery | Iowa | 19137 | 826 | 22 |
921300 | 921300 | 2021-01-12 | Montgomery | Iowa | 19137 | 817 | 22 |
918055 | 918055 | 2021-01-11 | Montgomery | Iowa | 19137 | 814 | 22 |
914810 | 914810 | 2021-01-10 | Montgomery | Iowa | 19137 | 813 | 22 |
911565 | 911565 | 2021-01-09 | Montgomery | Iowa | 19137 | 811 | 22 |
908320 | 908320 | 2021-01-08 | Montgomery | Iowa | 19137 | 807 | 22 |
905074 | 905074 | 2021-01-07 | Montgomery | Iowa | 19137 | 803 | 17 |
901829 | 901829 | 2021-01-06 | Montgomery | Iowa | 19137 | 790 | 17 |
898584 | 898584 | 2021-01-05 | Montgomery | Iowa | 19137 | 781 | 16 |
895339 | 895339 | 2021-01-04 | Montgomery | Iowa | 19137 | 777 | 16 |
892092 | 892092 | 2021-01-03 | Montgomery | Iowa | 19137 | 770 | 15 |
888846 | 888846 | 2021-01-02 | Montgomery | Iowa | 19137 | 770 | 15 |
885600 | 885600 | 2021-01-01 | Montgomery | Iowa | 19137 | 770 | 15 |
882355 | 882355 | 2020-12-31 | Montgomery | Iowa | 19137 | 763 | 15 |
879110 | 879110 | 2020-12-30 | Montgomery | Iowa | 19137 | 761 | 15 |
875865 | 875865 | 2020-12-29 | Montgomery | Iowa | 19137 | 739 | 15 |
872620 | 872620 | 2020-12-28 | Montgomery | Iowa | 19137 | 730 | 15 |
869375 | 869375 | 2020-12-27 | Montgomery | Iowa | 19137 | 716 | 15 |
866130 | 866130 | 2020-12-26 | Montgomery | Iowa | 19137 | 713 | 15 |
862885 | 862885 | 2020-12-25 | Montgomery | Iowa | 19137 | 713 | 15 |
859640 | 859640 | 2020-12-24 | Montgomery | Iowa | 19137 | 712 | 15 |
856395 | 856395 | 2020-12-23 | Montgomery | Iowa | 19137 | 695 | 14 |
853150 | 853150 | 2020-12-22 | Montgomery | Iowa | 19137 | 689 | 14 |
849905 | 849905 | 2020-12-21 | Montgomery | Iowa | 19137 | 686 | 13 |
846660 | 846660 | 2020-12-20 | Montgomery | Iowa | 19137 | 671 | 13 |
843414 | 843414 | 2020-12-19 | Montgomery | Iowa | 19137 | 671 | 13 |
840169 | 840169 | 2020-12-18 | Montgomery | Iowa | 19137 | 666 | 13 |
836924 | 836924 | 2020-12-17 | Montgomery | Iowa | 19137 | 658 | 13 |
833678 | 833678 | 2020-12-16 | Montgomery | Iowa | 19137 | 647 | 13 |
830431 | 830431 | 2020-12-15 | Montgomery | Iowa | 19137 | 631 | 13 |
827185 | 827185 | 2020-12-14 | Montgomery | Iowa | 19137 | 619 | 13 |
823938 | 823938 | 2020-12-13 | Montgomery | Iowa | 19137 | 611 | 13 |
820692 | 820692 | 2020-12-12 | Montgomery | Iowa | 19137 | 602 | 13 |
817446 | 817446 | 2020-12-11 | Montgomery | Iowa | 19137 | 590 | 13 |
814200 | 814200 | 2020-12-10 | Montgomery | Iowa | 19137 | 575 | 12 |
810955 | 810955 | 2020-12-09 | Montgomery | Iowa | 19137 | 567 | 12 |
807710 | 807710 | 2020-12-08 | Montgomery | Iowa | 19137 | 556 | 12 |
804465 | 804465 | 2020-12-07 | Montgomery | Iowa | 19137 | 551 | 11 |
801220 | 801220 | 2020-12-06 | Montgomery | Iowa | 19137 | 543 | 11 |
797975 | 797975 | 2020-12-05 | Montgomery | Iowa | 19137 | 538 | 11 |
794730 | 794730 | 2020-12-04 | Montgomery | Iowa | 19137 | 531 | 11 |
791485 | 791485 | 2020-12-03 | Montgomery | Iowa | 19137 | 514 | 11 |
788240 | 788240 | 2020-12-02 | Montgomery | Iowa | 19137 | 493 | 11 |
784996 | 784996 | 2020-12-01 | Montgomery | Iowa | 19137 | 486 | 11 |
781751 | 781751 | 2020-11-30 | Montgomery | Iowa | 19137 | 470 | 11 |
778505 | 778505 | 2020-11-29 | Montgomery | Iowa | 19137 | 463 | 11 |
775260 | 775260 | 2020-11-28 | Montgomery | Iowa | 19137 | 461 | 11 |
772015 | 772015 | 2020-11-27 | Montgomery | Iowa | 19137 | 450 | 11 |
768770 | 768770 | 2020-11-26 | Montgomery | Iowa | 19137 | 449 | 11 |
765524 | 765524 | 2020-11-25 | Montgomery | Iowa | 19137 | 446 | 10 |
762279 | 762279 | 2020-11-24 | Montgomery | Iowa | 19137 | 434 | 10 |
759034 | 759034 | 2020-11-23 | Montgomery | Iowa | 19137 | 432 | 10 |
755787 | 755787 | 2020-11-22 | Montgomery | Iowa | 19137 | 426 | 10 |
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);