ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Montgomery" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1076981 | 1076981 | 2021-03-01 | Montgomery | Indiana | 18107 | 3872 | 84 |
1073735 | 1073735 | 2021-02-28 | Montgomery | Indiana | 18107 | 3869 | 84 |
1070489 | 1070489 | 2021-02-27 | Montgomery | Indiana | 18107 | 3864 | 84 |
1067244 | 1067244 | 2021-02-26 | Montgomery | Indiana | 18107 | 3852 | 84 |
1063999 | 1063999 | 2021-02-25 | Montgomery | Indiana | 18107 | 3844 | 84 |
1060754 | 1060754 | 2021-02-24 | Montgomery | Indiana | 18107 | 3830 | 84 |
1057508 | 1057508 | 2021-02-23 | Montgomery | Indiana | 18107 | 3817 | 84 |
1054262 | 1054262 | 2021-02-22 | Montgomery | Indiana | 18107 | 3806 | 84 |
1051015 | 1051015 | 2021-02-21 | Montgomery | Indiana | 18107 | 3801 | 84 |
1047768 | 1047768 | 2021-02-20 | Montgomery | Indiana | 18107 | 3791 | 84 |
1044523 | 1044523 | 2021-02-19 | Montgomery | Indiana | 18107 | 3775 | 83 |
1041278 | 1041278 | 2021-02-18 | Montgomery | Indiana | 18107 | 3772 | 83 |
1038033 | 1038033 | 2021-02-17 | Montgomery | Indiana | 18107 | 3763 | 83 |
1034788 | 1034788 | 2021-02-16 | Montgomery | Indiana | 18107 | 3761 | 83 |
1031542 | 1031542 | 2021-02-15 | Montgomery | Indiana | 18107 | 3756 | 83 |
1028295 | 1028295 | 2021-02-14 | Montgomery | Indiana | 18107 | 3749 | 83 |
1025050 | 1025050 | 2021-02-13 | Montgomery | Indiana | 18107 | 3746 | 83 |
1021805 | 1021805 | 2021-02-12 | Montgomery | Indiana | 18107 | 3738 | 83 |
1018560 | 1018560 | 2021-02-11 | Montgomery | Indiana | 18107 | 3729 | 82 |
1015315 | 1015315 | 2021-02-10 | Montgomery | Indiana | 18107 | 3718 | 82 |
1012070 | 1012070 | 2021-02-09 | Montgomery | Indiana | 18107 | 3701 | 82 |
1008824 | 1008824 | 2021-02-08 | Montgomery | Indiana | 18107 | 3686 | 81 |
1005578 | 1005578 | 2021-02-07 | Montgomery | Indiana | 18107 | 3680 | 81 |
1002332 | 1002332 | 2021-02-06 | Montgomery | Indiana | 18107 | 3667 | 81 |
999086 | 999086 | 2021-02-05 | Montgomery | Indiana | 18107 | 3649 | 80 |
995840 | 995840 | 2021-02-04 | Montgomery | Indiana | 18107 | 3641 | 79 |
992594 | 992594 | 2021-02-03 | Montgomery | Indiana | 18107 | 3628 | 59 |
989348 | 989348 | 2021-02-02 | Montgomery | Indiana | 18107 | 3609 | 58 |
986101 | 986101 | 2021-02-01 | Montgomery | Indiana | 18107 | 3600 | 57 |
982854 | 982854 | 2021-01-31 | Montgomery | Indiana | 18107 | 3582 | 57 |
979608 | 979608 | 2021-01-30 | Montgomery | Indiana | 18107 | 3574 | 57 |
976362 | 976362 | 2021-01-29 | Montgomery | Indiana | 18107 | 3554 | 57 |
973117 | 973117 | 2021-01-28 | Montgomery | Indiana | 18107 | 3538 | 56 |
969872 | 969872 | 2021-01-27 | Montgomery | Indiana | 18107 | 3513 | 55 |
966628 | 966628 | 2021-01-26 | Montgomery | Indiana | 18107 | 3499 | 55 |
963383 | 963383 | 2021-01-25 | Montgomery | Indiana | 18107 | 3478 | 55 |
960138 | 960138 | 2021-01-24 | Montgomery | Indiana | 18107 | 3467 | 55 |
956892 | 956892 | 2021-01-23 | Montgomery | Indiana | 18107 | 3459 | 55 |
953647 | 953647 | 2021-01-22 | Montgomery | Indiana | 18107 | 3435 | 55 |
950402 | 950402 | 2021-01-21 | Montgomery | Indiana | 18107 | 3409 | 55 |
947156 | 947156 | 2021-01-20 | Montgomery | Indiana | 18107 | 3391 | 54 |
943909 | 943909 | 2021-01-19 | Montgomery | Indiana | 18107 | 3383 | 53 |
940664 | 940664 | 2021-01-18 | Montgomery | Indiana | 18107 | 3368 | 52 |
937419 | 937419 | 2021-01-17 | Montgomery | Indiana | 18107 | 3350 | 52 |
934174 | 934174 | 2021-01-16 | Montgomery | Indiana | 18107 | 3340 | 52 |
930929 | 930929 | 2021-01-15 | Montgomery | Indiana | 18107 | 3317 | 52 |
927684 | 927684 | 2021-01-14 | Montgomery | Indiana | 18107 | 3293 | 51 |
924438 | 924438 | 2021-01-13 | Montgomery | Indiana | 18107 | 3251 | 51 |
921193 | 921193 | 2021-01-12 | Montgomery | Indiana | 18107 | 3203 | 51 |
917948 | 917948 | 2021-01-11 | Montgomery | Indiana | 18107 | 3197 | 51 |
914703 | 914703 | 2021-01-10 | Montgomery | Indiana | 18107 | 3175 | 51 |
911458 | 911458 | 2021-01-09 | Montgomery | Indiana | 18107 | 3154 | 51 |
908213 | 908213 | 2021-01-08 | Montgomery | Indiana | 18107 | 3111 | 51 |
904967 | 904967 | 2021-01-07 | Montgomery | Indiana | 18107 | 3051 | 51 |
901722 | 901722 | 2021-01-06 | Montgomery | Indiana | 18107 | 2992 | 51 |
898477 | 898477 | 2021-01-05 | Montgomery | Indiana | 18107 | 2954 | 51 |
895232 | 895232 | 2021-01-04 | Montgomery | Indiana | 18107 | 2948 | 51 |
891985 | 891985 | 2021-01-03 | Montgomery | Indiana | 18107 | 2930 | 50 |
888739 | 888739 | 2021-01-02 | Montgomery | Indiana | 18107 | 2919 | 50 |
885493 | 885493 | 2021-01-01 | Montgomery | Indiana | 18107 | 2891 | 50 |
882248 | 882248 | 2020-12-31 | Montgomery | Indiana | 18107 | 2842 | 50 |
879003 | 879003 | 2020-12-30 | Montgomery | Indiana | 18107 | 2797 | 48 |
875758 | 875758 | 2020-12-29 | Montgomery | Indiana | 18107 | 2752 | 47 |
872513 | 872513 | 2020-12-28 | Montgomery | Indiana | 18107 | 2733 | 44 |
869268 | 869268 | 2020-12-27 | Montgomery | Indiana | 18107 | 2716 | 43 |
866023 | 866023 | 2020-12-26 | Montgomery | Indiana | 18107 | 2707 | 43 |
862778 | 862778 | 2020-12-25 | Montgomery | Indiana | 18107 | 2692 | 43 |
859533 | 859533 | 2020-12-24 | Montgomery | Indiana | 18107 | 2647 | 43 |
856288 | 856288 | 2020-12-23 | Montgomery | Indiana | 18107 | 2616 | 43 |
853043 | 853043 | 2020-12-22 | Montgomery | Indiana | 18107 | 2581 | 43 |
849798 | 849798 | 2020-12-21 | Montgomery | Indiana | 18107 | 2566 | 43 |
846553 | 846553 | 2020-12-20 | Montgomery | Indiana | 18107 | 2546 | 40 |
843307 | 843307 | 2020-12-19 | Montgomery | Indiana | 18107 | 2464 | 39 |
840062 | 840062 | 2020-12-18 | Montgomery | Indiana | 18107 | 2449 | 39 |
836817 | 836817 | 2020-12-17 | Montgomery | Indiana | 18107 | 2424 | 38 |
833571 | 833571 | 2020-12-16 | Montgomery | Indiana | 18107 | 2367 | 38 |
830324 | 830324 | 2020-12-15 | Montgomery | Indiana | 18107 | 2282 | 37 |
827078 | 827078 | 2020-12-14 | Montgomery | Indiana | 18107 | 2247 | 36 |
823831 | 823831 | 2020-12-13 | Montgomery | Indiana | 18107 | 2204 | 35 |
820585 | 820585 | 2020-12-12 | Montgomery | Indiana | 18107 | 2156 | 34 |
817339 | 817339 | 2020-12-11 | Montgomery | Indiana | 18107 | 2113 | 34 |
814093 | 814093 | 2020-12-10 | Montgomery | Indiana | 18107 | 2027 | 34 |
810848 | 810848 | 2020-12-09 | Montgomery | Indiana | 18107 | 1984 | 33 |
807603 | 807603 | 2020-12-08 | Montgomery | Indiana | 18107 | 1975 | 32 |
804358 | 804358 | 2020-12-07 | Montgomery | Indiana | 18107 | 1927 | 31 |
801113 | 801113 | 2020-12-06 | Montgomery | Indiana | 18107 | 1891 | 31 |
797868 | 797868 | 2020-12-05 | Montgomery | Indiana | 18107 | 1847 | 31 |
794623 | 794623 | 2020-12-04 | Montgomery | Indiana | 18107 | 1782 | 30 |
791378 | 791378 | 2020-12-03 | Montgomery | Indiana | 18107 | 1716 | 30 |
788133 | 788133 | 2020-12-02 | Montgomery | Indiana | 18107 | 1672 | 30 |
784889 | 784889 | 2020-12-01 | Montgomery | Indiana | 18107 | 1645 | 30 |
781644 | 781644 | 2020-11-30 | Montgomery | Indiana | 18107 | 1585 | 30 |
778398 | 778398 | 2020-11-29 | Montgomery | Indiana | 18107 | 1548 | 30 |
775153 | 775153 | 2020-11-28 | Montgomery | Indiana | 18107 | 1523 | 30 |
771908 | 771908 | 2020-11-27 | Montgomery | Indiana | 18107 | 1495 | 28 |
768663 | 768663 | 2020-11-26 | Montgomery | Indiana | 18107 | 1468 | 28 |
765417 | 765417 | 2020-11-25 | Montgomery | Indiana | 18107 | 1423 | 28 |
762172 | 762172 | 2020-11-24 | Montgomery | Indiana | 18107 | 1392 | 28 |
758927 | 758927 | 2020-11-23 | Montgomery | Indiana | 18107 | 1314 | 27 |
755680 | 755680 | 2020-11-22 | Montgomery | Indiana | 18107 | 1281 | 27 |
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);