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 |
---|---|---|---|---|---|---|---|
920930 | 920930 | 2021-01-12 | Montgomery | Georgia | 13209 | 730 | 11 |
921105 | 921105 | 2021-01-12 | Montgomery | Illinois | 17135 | 2846 | 35 |
921193 | 921193 | 2021-01-12 | Montgomery | Indiana | 18107 | 3203 | 51 |
921300 | 921300 | 2021-01-12 | Montgomery | Iowa | 19137 | 817 | 22 |
921394 | 921394 | 2021-01-12 | Montgomery | Kansas | 20125 | 2607 | 6 |
921524 | 921524 | 2021-01-12 | Montgomery | Kentucky | 21173 | 1661 | 12 |
921655 | 921655 | 2021-01-12 | Montgomery | Maryland | 24031 | 52058 | 1189 |
921900 | 921900 | 2021-01-12 | Montgomery | Mississippi | 28097 | 1066 | 34 |
922005 | 922005 | 2021-01-12 | Montgomery | Missouri | 29139 | 535 | 9 |
922309 | 922309 | 2021-01-12 | Montgomery | New York | 36057 | 1952 | 66 |
922402 | 922402 | 2021-01-12 | Montgomery | North Carolina | 37123 | 2302 | 50 |
922553 | 922553 | 2021-01-12 | Montgomery | Ohio | 39113 | 40238 | 384 |
922744 | 922744 | 2021-01-12 | Montgomery | Pennsylvania | 42091 | 41651 | 1239 |
923025 | 923025 | 2021-01-12 | Montgomery | Tennessee | 47125 | 13540 | 142 |
923228 | 923228 | 2021-01-12 | Montgomery | Texas | 48339 | 31822 | 296 |
923442 | 923442 | 2021-01-12 | Montgomery | Virginia | 51121 | 5658 | 48 |
917243 | 917243 | 2021-01-11 | Montgomery | Alabama | 1101 | 18176 | 286 |
917351 | 917351 | 2021-01-11 | Montgomery | Arkansas | 5097 | 591 | 21 |
917685 | 917685 | 2021-01-11 | Montgomery | Georgia | 13209 | 721 | 11 |
917860 | 917860 | 2021-01-11 | Montgomery | Illinois | 17135 | 2754 | 33 |
917948 | 917948 | 2021-01-11 | Montgomery | Indiana | 18107 | 3197 | 51 |
918055 | 918055 | 2021-01-11 | Montgomery | Iowa | 19137 | 814 | 22 |
918149 | 918149 | 2021-01-11 | Montgomery | Kansas | 20125 | 2607 | 6 |
918279 | 918279 | 2021-01-11 | Montgomery | Kentucky | 21173 | 1626 | 12 |
918410 | 918410 | 2021-01-11 | Montgomery | Maryland | 24031 | 51570 | 1183 |
918655 | 918655 | 2021-01-11 | Montgomery | Mississippi | 28097 | 1061 | 32 |
918760 | 918760 | 2021-01-11 | Montgomery | Missouri | 29139 | 536 | 9 |
919064 | 919064 | 2021-01-11 | Montgomery | New York | 36057 | 1923 | 65 |
919157 | 919157 | 2021-01-11 | Montgomery | North Carolina | 37123 | 2287 | 48 |
919308 | 919308 | 2021-01-11 | Montgomery | Ohio | 39113 | 39691 | 382 |
919499 | 919499 | 2021-01-11 | Montgomery | Pennsylvania | 42091 | 41270 | 1228 |
919780 | 919780 | 2021-01-11 | Montgomery | Tennessee | 47125 | 13456 | 140 |
919983 | 919983 | 2021-01-11 | Montgomery | Texas | 48339 | 31099 | 287 |
920197 | 920197 | 2021-01-11 | Montgomery | Virginia | 51121 | 5633 | 48 |
913998 | 913998 | 2021-01-10 | Montgomery | Alabama | 1101 | 18064 | 285 |
914106 | 914106 | 2021-01-10 | Montgomery | Arkansas | 5097 | 580 | 21 |
914440 | 914440 | 2021-01-10 | Montgomery | Georgia | 13209 | 712 | 11 |
914615 | 914615 | 2021-01-10 | Montgomery | Illinois | 17135 | 2634 | 33 |
914703 | 914703 | 2021-01-10 | Montgomery | Indiana | 18107 | 3175 | 51 |
914810 | 914810 | 2021-01-10 | Montgomery | Iowa | 19137 | 813 | 22 |
914904 | 914904 | 2021-01-10 | Montgomery | Kansas | 20125 | 2530 | 6 |
915034 | 915034 | 2021-01-10 | Montgomery | Kentucky | 21173 | 1614 | 12 |
915165 | 915165 | 2021-01-10 | Montgomery | Maryland | 24031 | 51110 | 1180 |
915410 | 915410 | 2021-01-10 | Montgomery | Mississippi | 28097 | 1058 | 32 |
915515 | 915515 | 2021-01-10 | Montgomery | Missouri | 29139 | 532 | 9 |
915819 | 915819 | 2021-01-10 | Montgomery | New York | 36057 | 1883 | 63 |
915912 | 915912 | 2021-01-10 | Montgomery | North Carolina | 37123 | 2260 | 48 |
916063 | 916063 | 2021-01-10 | Montgomery | Ohio | 39113 | 39479 | 382 |
916254 | 916254 | 2021-01-10 | Montgomery | Pennsylvania | 42091 | 40964 | 1226 |
916535 | 916535 | 2021-01-10 | Montgomery | Tennessee | 47125 | 13352 | 138 |
916738 | 916738 | 2021-01-10 | Montgomery | Texas | 48339 | 29994 | 285 |
916952 | 916952 | 2021-01-10 | Montgomery | Virginia | 51121 | 5606 | 48 |
910753 | 910753 | 2021-01-09 | Montgomery | Alabama | 1101 | 17916 | 282 |
910861 | 910861 | 2021-01-09 | Montgomery | Arkansas | 5097 | 569 | 21 |
911195 | 911195 | 2021-01-09 | Montgomery | Georgia | 13209 | 704 | 11 |
911370 | 911370 | 2021-01-09 | Montgomery | Illinois | 17135 | 2597 | 31 |
911458 | 911458 | 2021-01-09 | Montgomery | Indiana | 18107 | 3154 | 51 |
911565 | 911565 | 2021-01-09 | Montgomery | Iowa | 19137 | 811 | 22 |
911659 | 911659 | 2021-01-09 | Montgomery | Kansas | 20125 | 2530 | 6 |
911789 | 911789 | 2021-01-09 | Montgomery | Kentucky | 21173 | 1601 | 12 |
911920 | 911920 | 2021-01-09 | Montgomery | Maryland | 24031 | 50471 | 1174 |
912165 | 912165 | 2021-01-09 | Montgomery | Mississippi | 28097 | 1050 | 32 |
912270 | 912270 | 2021-01-09 | Montgomery | Missouri | 29139 | 529 | 9 |
912574 | 912574 | 2021-01-09 | Montgomery | New York | 36057 | 1821 | 62 |
912667 | 912667 | 2021-01-09 | Montgomery | North Carolina | 37123 | 2230 | 48 |
912818 | 912818 | 2021-01-09 | Montgomery | Ohio | 39113 | 39206 | 382 |
913009 | 913009 | 2021-01-09 | Montgomery | Pennsylvania | 42091 | 40432 | 1221 |
913290 | 913290 | 2021-01-09 | Montgomery | Tennessee | 47125 | 13123 | 136 |
913493 | 913493 | 2021-01-09 | Montgomery | Texas | 48339 | 29994 | 284 |
913707 | 913707 | 2021-01-09 | Montgomery | Virginia | 51121 | 5572 | 48 |
907508 | 907508 | 2021-01-08 | Montgomery | Alabama | 1101 | 17723 | 282 |
907616 | 907616 | 2021-01-08 | Montgomery | Arkansas | 5097 | 560 | 21 |
907950 | 907950 | 2021-01-08 | Montgomery | Georgia | 13209 | 692 | 11 |
908125 | 908125 | 2021-01-08 | Montgomery | Illinois | 17135 | 2541 | 29 |
908213 | 908213 | 2021-01-08 | Montgomery | Indiana | 18107 | 3111 | 51 |
908320 | 908320 | 2021-01-08 | Montgomery | Iowa | 19137 | 807 | 22 |
908414 | 908414 | 2021-01-08 | Montgomery | Kansas | 20125 | 2530 | 6 |
908544 | 908544 | 2021-01-08 | Montgomery | Kentucky | 21173 | 1569 | 12 |
908675 | 908675 | 2021-01-08 | Montgomery | Maryland | 24031 | 49849 | 1169 |
908920 | 908920 | 2021-01-08 | Montgomery | Mississippi | 28097 | 1040 | 32 |
909025 | 909025 | 2021-01-08 | Montgomery | Missouri | 29139 | 527 | 9 |
909329 | 909329 | 2021-01-08 | Montgomery | New York | 36057 | 1742 | 59 |
909422 | 909422 | 2021-01-08 | Montgomery | North Carolina | 37123 | 2183 | 48 |
909573 | 909573 | 2021-01-08 | Montgomery | Ohio | 39113 | 38845 | 380 |
909764 | 909764 | 2021-01-08 | Montgomery | Pennsylvania | 42091 | 39939 | 1211 |
910045 | 910045 | 2021-01-08 | Montgomery | Tennessee | 47125 | 12922 | 133 |
910248 | 910248 | 2021-01-08 | Montgomery | Texas | 48339 | 29994 | 282 |
910462 | 910462 | 2021-01-08 | Montgomery | Virginia | 51121 | 5505 | 47 |
904262 | 904262 | 2021-01-07 | Montgomery | Alabama | 1101 | 17475 | 282 |
904370 | 904370 | 2021-01-07 | Montgomery | Arkansas | 5097 | 550 | 21 |
904704 | 904704 | 2021-01-07 | Montgomery | Georgia | 13209 | 685 | 11 |
904879 | 904879 | 2021-01-07 | Montgomery | Illinois | 17135 | 2477 | 27 |
904967 | 904967 | 2021-01-07 | Montgomery | Indiana | 18107 | 3051 | 51 |
905074 | 905074 | 2021-01-07 | Montgomery | Iowa | 19137 | 803 | 17 |
905168 | 905168 | 2021-01-07 | Montgomery | Kansas | 20125 | 2451 | 6 |
905298 | 905298 | 2021-01-07 | Montgomery | Kentucky | 21173 | 1525 | 12 |
905429 | 905429 | 2021-01-07 | Montgomery | Maryland | 24031 | 49300 | 1162 |
905674 | 905674 | 2021-01-07 | Montgomery | Mississippi | 28097 | 1034 | 31 |
905779 | 905779 | 2021-01-07 | Montgomery | Missouri | 29139 | 524 | 9 |
906084 | 906084 | 2021-01-07 | Montgomery | New York | 36057 | 1633 | 59 |
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);