ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14,081 rows where county = "Montgomery" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
944721 | 944721 | 2021-01-19 | Montgomery | Missouri | 29139 | 545 | 9 |
945026 | 945026 | 2021-01-19 | Montgomery | New York | 36057 | 2230 | 75 |
945119 | 945119 | 2021-01-19 | Montgomery | North Carolina | 37123 | 2472 | 52 |
945271 | 945271 | 2021-01-19 | Montgomery | Ohio | 39113 | 42028 | 399 |
945462 | 945462 | 2021-01-19 | Montgomery | Pennsylvania | 42091 | 44279 | 1299 |
945743 | 945743 | 2021-01-19 | Montgomery | Tennessee | 47125 | 14507 | 149 |
945946 | 945946 | 2021-01-19 | Montgomery | Texas | 48339 | 34423 | 326 |
946160 | 946160 | 2021-01-19 | Montgomery | Virginia | 51121 | 5894 | 54 |
939959 | 939959 | 2021-01-18 | Montgomery | Alabama | 1101 | 19049 | 305 |
940067 | 940067 | 2021-01-18 | Montgomery | Arkansas | 5097 | 621 | 22 |
940401 | 940401 | 2021-01-18 | Montgomery | Georgia | 13209 | 763 | 14 |
940576 | 940576 | 2021-01-18 | Montgomery | Illinois | 17135 | 3038 | 40 |
940664 | 940664 | 2021-01-18 | Montgomery | Indiana | 18107 | 3368 | 52 |
940771 | 940771 | 2021-01-18 | Montgomery | Iowa | 19137 | 848 | 22 |
940865 | 940865 | 2021-01-18 | Montgomery | Kansas | 20125 | 2785 | 6 |
940995 | 940995 | 2021-01-18 | Montgomery | Kentucky | 21173 | 1788 | 16 |
941126 | 941126 | 2021-01-18 | Montgomery | Maryland | 24031 | 54569 | 1234 |
941371 | 941371 | 2021-01-18 | Montgomery | Mississippi | 28097 | 1096 | 34 |
941476 | 941476 | 2021-01-18 | Montgomery | Missouri | 29139 | 545 | 9 |
941780 | 941780 | 2021-01-18 | Montgomery | New York | 36057 | 2197 | 74 |
941873 | 941873 | 2021-01-18 | Montgomery | North Carolina | 37123 | 2446 | 52 |
942024 | 942024 | 2021-01-18 | Montgomery | Ohio | 39113 | 41873 | 399 |
942215 | 942215 | 2021-01-18 | Montgomery | Pennsylvania | 42091 | 43958 | 1298 |
942496 | 942496 | 2021-01-18 | Montgomery | Tennessee | 47125 | 14450 | 149 |
942699 | 942699 | 2021-01-18 | Montgomery | Texas | 48339 | 33006 | 321 |
942913 | 942913 | 2021-01-18 | Montgomery | Virginia | 51121 | 5873 | 49 |
936714 | 936714 | 2021-01-17 | Montgomery | Alabama | 1101 | 18978 | 305 |
936822 | 936822 | 2021-01-17 | Montgomery | Arkansas | 5097 | 619 | 22 |
937156 | 937156 | 2021-01-17 | Montgomery | Georgia | 13209 | 762 | 14 |
937331 | 937331 | 2021-01-17 | Montgomery | Illinois | 17135 | 3031 | 40 |
937419 | 937419 | 2021-01-17 | Montgomery | Indiana | 18107 | 3350 | 52 |
937526 | 937526 | 2021-01-17 | Montgomery | Iowa | 19137 | 840 | 22 |
937620 | 937620 | 2021-01-17 | Montgomery | Kansas | 20125 | 2750 | 6 |
937750 | 937750 | 2021-01-17 | Montgomery | Kentucky | 21173 | 1779 | 15 |
937881 | 937881 | 2021-01-17 | Montgomery | Maryland | 24031 | 54285 | 1226 |
938126 | 938126 | 2021-01-17 | Montgomery | Mississippi | 28097 | 1094 | 34 |
938231 | 938231 | 2021-01-17 | Montgomery | Missouri | 29139 | 545 | 9 |
938535 | 938535 | 2021-01-17 | Montgomery | New York | 36057 | 2167 | 72 |
938628 | 938628 | 2021-01-17 | Montgomery | North Carolina | 37123 | 2446 | 52 |
938779 | 938779 | 2021-01-17 | Montgomery | Ohio | 39113 | 41700 | 399 |
938970 | 938970 | 2021-01-17 | Montgomery | Pennsylvania | 42091 | 43690 | 1296 |
939251 | 939251 | 2021-01-17 | Montgomery | Tennessee | 47125 | 14367 | 149 |
939454 | 939454 | 2021-01-17 | Montgomery | Texas | 48339 | 33006 | 321 |
939668 | 939668 | 2021-01-17 | Montgomery | Virginia | 51121 | 5833 | 49 |
933469 | 933469 | 2021-01-16 | Montgomery | Alabama | 1101 | 18876 | 305 |
933577 | 933577 | 2021-01-16 | Montgomery | Arkansas | 5097 | 619 | 22 |
933911 | 933911 | 2021-01-16 | Montgomery | Georgia | 13209 | 762 | 14 |
934086 | 934086 | 2021-01-16 | Montgomery | Illinois | 17135 | 3006 | 40 |
934174 | 934174 | 2021-01-16 | Montgomery | Indiana | 18107 | 3340 | 52 |
934281 | 934281 | 2021-01-16 | Montgomery | Iowa | 19137 | 840 | 22 |
934375 | 934375 | 2021-01-16 | Montgomery | Kansas | 20125 | 2750 | 6 |
934505 | 934505 | 2021-01-16 | Montgomery | Kentucky | 21173 | 1773 | 15 |
934636 | 934636 | 2021-01-16 | Montgomery | Maryland | 24031 | 53876 | 1221 |
934881 | 934881 | 2021-01-16 | Montgomery | Mississippi | 28097 | 1091 | 34 |
934986 | 934986 | 2021-01-16 | Montgomery | Missouri | 29139 | 544 | 9 |
935290 | 935290 | 2021-01-16 | Montgomery | New York | 36057 | 2123 | 72 |
935383 | 935383 | 2021-01-16 | Montgomery | North Carolina | 37123 | 2427 | 52 |
935534 | 935534 | 2021-01-16 | Montgomery | Ohio | 39113 | 41445 | 399 |
935725 | 935725 | 2021-01-16 | Montgomery | Pennsylvania | 42091 | 43270 | 1292 |
936006 | 936006 | 2021-01-16 | Montgomery | Tennessee | 47125 | 14229 | 148 |
936209 | 936209 | 2021-01-16 | Montgomery | Texas | 48339 | 33006 | 320 |
936423 | 936423 | 2021-01-16 | Montgomery | Virginia | 51121 | 5797 | 49 |
930224 | 930224 | 2021-01-15 | Montgomery | Alabama | 1101 | 18696 | 304 |
930332 | 930332 | 2021-01-15 | Montgomery | Arkansas | 5097 | 615 | 22 |
930666 | 930666 | 2021-01-15 | Montgomery | Georgia | 13209 | 754 | 14 |
930841 | 930841 | 2021-01-15 | Montgomery | Illinois | 17135 | 2970 | 37 |
930929 | 930929 | 2021-01-15 | Montgomery | Indiana | 18107 | 3317 | 52 |
931036 | 931036 | 2021-01-15 | Montgomery | Iowa | 19137 | 840 | 22 |
931130 | 931130 | 2021-01-15 | Montgomery | Kansas | 20125 | 2750 | 6 |
931260 | 931260 | 2021-01-15 | Montgomery | Kentucky | 21173 | 1748 | 15 |
931391 | 931391 | 2021-01-15 | Montgomery | Maryland | 24031 | 53327 | 1217 |
931636 | 931636 | 2021-01-15 | Montgomery | Mississippi | 28097 | 1081 | 34 |
931741 | 931741 | 2021-01-15 | Montgomery | Missouri | 29139 | 543 | 9 |
932045 | 932045 | 2021-01-15 | Montgomery | New York | 36057 | 2069 | 71 |
932138 | 932138 | 2021-01-15 | Montgomery | North Carolina | 37123 | 2398 | 52 |
932289 | 932289 | 2021-01-15 | Montgomery | Ohio | 39113 | 41172 | 398 |
932480 | 932480 | 2021-01-15 | Montgomery | Pennsylvania | 42091 | 42797 | 1279 |
932761 | 932761 | 2021-01-15 | Montgomery | Tennessee | 47125 | 14085 | 148 |
932964 | 932964 | 2021-01-15 | Montgomery | Texas | 48339 | 33006 | 309 |
933178 | 933178 | 2021-01-15 | Montgomery | Virginia | 51121 | 5774 | 49 |
926979 | 926979 | 2021-01-14 | Montgomery | Alabama | 1101 | 18562 | 304 |
927087 | 927087 | 2021-01-14 | Montgomery | Arkansas | 5097 | 611 | 22 |
927421 | 927421 | 2021-01-14 | Montgomery | Georgia | 13209 | 750 | 14 |
927596 | 927596 | 2021-01-14 | Montgomery | Illinois | 17135 | 2943 | 37 |
927684 | 927684 | 2021-01-14 | Montgomery | Indiana | 18107 | 3293 | 51 |
927791 | 927791 | 2021-01-14 | Montgomery | Iowa | 19137 | 827 | 22 |
927885 | 927885 | 2021-01-14 | Montgomery | Kansas | 20125 | 2681 | 6 |
928015 | 928015 | 2021-01-14 | Montgomery | Kentucky | 21173 | 1722 | 15 |
928146 | 928146 | 2021-01-14 | Montgomery | Maryland | 24031 | 52886 | 1211 |
928391 | 928391 | 2021-01-14 | Montgomery | Mississippi | 28097 | 1071 | 34 |
928496 | 928496 | 2021-01-14 | Montgomery | Missouri | 29139 | 540 | 9 |
928800 | 928800 | 2021-01-14 | Montgomery | New York | 36057 | 1986 | 70 |
928893 | 928893 | 2021-01-14 | Montgomery | North Carolina | 37123 | 2357 | 52 |
929044 | 929044 | 2021-01-14 | Montgomery | Ohio | 39113 | 40858 | 396 |
929235 | 929235 | 2021-01-14 | Montgomery | Pennsylvania | 42091 | 42433 | 1266 |
929516 | 929516 | 2021-01-14 | Montgomery | Tennessee | 47125 | 13874 | 145 |
929719 | 929719 | 2021-01-14 | Montgomery | Texas | 48339 | 32575 | 304 |
929933 | 929933 | 2021-01-14 | Montgomery | Virginia | 51121 | 5719 | 49 |
923733 | 923733 | 2021-01-13 | Montgomery | Alabama | 1101 | 18405 | 297 |
923841 | 923841 | 2021-01-13 | Montgomery | Arkansas | 5097 | 601 | 21 |
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);