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 |
---|---|---|---|---|---|---|---|
386097 | 386097 | 2020-07-31 | Montgomery | Arkansas | 5097 | 25 | 0 |
386430 | 386430 | 2020-07-31 | Montgomery | Georgia | 13209 | 124 | 0 |
386602 | 386602 | 2020-07-31 | Montgomery | Illinois | 17135 | 138 | 5 |
386691 | 386691 | 2020-07-31 | Montgomery | Indiana | 18107 | 336 | 22 |
386798 | 386798 | 2020-07-31 | Montgomery | Iowa | 19137 | 42 | 3 |
386892 | 386892 | 2020-07-31 | Montgomery | Kansas | 20125 | 152 | 5 |
387019 | 387019 | 2020-07-31 | Montgomery | Kentucky | 21173 | 110 | 0 |
387150 | 387150 | 2020-07-31 | Montgomery | Maryland | 24031 | 17607 | 789 |
387395 | 387395 | 2020-07-31 | Montgomery | Mississippi | 28097 | 276 | 3 |
387500 | 387500 | 2020-07-31 | Montgomery | Missouri | 29139 | 33 | 0 |
387789 | 387789 | 2020-07-31 | Montgomery | New York | 36057 | 154 | 5 |
387882 | 387882 | 2020-07-31 | Montgomery | North Carolina | 37123 | 569 | 13 |
388033 | 388033 | 2020-07-31 | Montgomery | Ohio | 39113 | 3926 | 70 |
388222 | 388222 | 2020-07-31 | Montgomery | Pennsylvania | 42091 | 9761 | 848 |
388502 | 388502 | 2020-07-31 | Montgomery | Tennessee | 47125 | 1646 | 11 |
388702 | 388702 | 2020-07-31 | Montgomery | Texas | 48339 | 6196 | 71 |
388914 | 388914 | 2020-07-31 | Montgomery | Virginia | 51121 | 273 | 3 |
382772 | 382772 | 2020-07-30 | Montgomery | Alabama | 1101 | 6045 | 142 |
382879 | 382879 | 2020-07-30 | Montgomery | Arkansas | 5097 | 24 | 0 |
383212 | 383212 | 2020-07-30 | Montgomery | Georgia | 13209 | 117 | 0 |
383384 | 383384 | 2020-07-30 | Montgomery | Illinois | 17135 | 133 | 5 |
383473 | 383473 | 2020-07-30 | Montgomery | Indiana | 18107 | 328 | 22 |
383580 | 383580 | 2020-07-30 | Montgomery | Iowa | 19137 | 41 | 3 |
383674 | 383674 | 2020-07-30 | Montgomery | Kansas | 20125 | 145 | 4 |
383801 | 383801 | 2020-07-30 | Montgomery | Kentucky | 21173 | 104 | 0 |
383932 | 383932 | 2020-07-30 | Montgomery | Maryland | 24031 | 17436 | 789 |
384177 | 384177 | 2020-07-30 | Montgomery | Mississippi | 28097 | 266 | 3 |
384282 | 384282 | 2020-07-30 | Montgomery | Missouri | 29139 | 33 | 0 |
384572 | 384572 | 2020-07-30 | Montgomery | New York | 36057 | 152 | 5 |
384665 | 384665 | 2020-07-30 | Montgomery | North Carolina | 37123 | 563 | 13 |
384816 | 384816 | 2020-07-30 | Montgomery | Ohio | 39113 | 3845 | 70 |
385005 | 385005 | 2020-07-30 | Montgomery | Pennsylvania | 42091 | 9723 | 847 |
385285 | 385285 | 2020-07-30 | Montgomery | Tennessee | 47125 | 1568 | 11 |
385485 | 385485 | 2020-07-30 | Montgomery | Texas | 48339 | 6077 | 69 |
385697 | 385697 | 2020-07-30 | Montgomery | Virginia | 51121 | 264 | 3 |
379555 | 379555 | 2020-07-29 | Montgomery | Alabama | 1101 | 5971 | 141 |
379662 | 379662 | 2020-07-29 | Montgomery | Arkansas | 5097 | 24 | 0 |
379995 | 379995 | 2020-07-29 | Montgomery | Georgia | 13209 | 115 | 0 |
380167 | 380167 | 2020-07-29 | Montgomery | Illinois | 17135 | 132 | 5 |
380256 | 380256 | 2020-07-29 | Montgomery | Indiana | 18107 | 326 | 22 |
380363 | 380363 | 2020-07-29 | Montgomery | Iowa | 19137 | 40 | 2 |
380457 | 380457 | 2020-07-29 | Montgomery | Kansas | 20125 | 134 | 4 |
380584 | 380584 | 2020-07-29 | Montgomery | Kentucky | 21173 | 103 | 0 |
380715 | 380715 | 2020-07-29 | Montgomery | Maryland | 24031 | 17344 | 787 |
380960 | 380960 | 2020-07-29 | Montgomery | Mississippi | 28097 | 258 | 3 |
381066 | 381066 | 2020-07-29 | Montgomery | Missouri | 29139 | 31 | 0 |
381354 | 381354 | 2020-07-29 | Montgomery | New York | 36057 | 152 | 5 |
381447 | 381447 | 2020-07-29 | Montgomery | North Carolina | 37123 | 561 | 13 |
381598 | 381598 | 2020-07-29 | Montgomery | Ohio | 39113 | 3747 | 65 |
381787 | 381787 | 2020-07-29 | Montgomery | Pennsylvania | 42091 | 9673 | 846 |
382067 | 382067 | 2020-07-29 | Montgomery | Tennessee | 47125 | 1524 | 10 |
382267 | 382267 | 2020-07-29 | Montgomery | Texas | 48339 | 5990 | 65 |
382479 | 382479 | 2020-07-29 | Montgomery | Virginia | 51121 | 260 | 3 |
376339 | 376339 | 2020-07-28 | Montgomery | Alabama | 1101 | 5921 | 141 |
376446 | 376446 | 2020-07-28 | Montgomery | Arkansas | 5097 | 23 | 0 |
376778 | 376778 | 2020-07-28 | Montgomery | Georgia | 13209 | 114 | 0 |
376950 | 376950 | 2020-07-28 | Montgomery | Illinois | 17135 | 128 | 4 |
377039 | 377039 | 2020-07-28 | Montgomery | Indiana | 18107 | 323 | 22 |
377146 | 377146 | 2020-07-28 | Montgomery | Iowa | 19137 | 40 | 2 |
377240 | 377240 | 2020-07-28 | Montgomery | Kansas | 20125 | 134 | 4 |
377367 | 377367 | 2020-07-28 | Montgomery | Kentucky | 21173 | 100 | 0 |
377498 | 377498 | 2020-07-28 | Montgomery | Maryland | 24031 | 17269 | 787 |
377743 | 377743 | 2020-07-28 | Montgomery | Mississippi | 28097 | 252 | 3 |
377849 | 377849 | 2020-07-28 | Montgomery | Missouri | 29139 | 31 | 0 |
378137 | 378137 | 2020-07-28 | Montgomery | New York | 36057 | 152 | 5 |
378230 | 378230 | 2020-07-28 | Montgomery | North Carolina | 37123 | 552 | 13 |
378381 | 378381 | 2020-07-28 | Montgomery | Ohio | 39113 | 3653 | 58 |
378570 | 378570 | 2020-07-28 | Montgomery | Pennsylvania | 42091 | 9621 | 845 |
378850 | 378850 | 2020-07-28 | Montgomery | Tennessee | 47125 | 1482 | 9 |
379050 | 379050 | 2020-07-28 | Montgomery | Texas | 48339 | 5852 | 60 |
379262 | 379262 | 2020-07-28 | Montgomery | Virginia | 51121 | 259 | 3 |
373125 | 373125 | 2020-07-27 | Montgomery | Alabama | 1101 | 5850 | 141 |
373232 | 373232 | 2020-07-27 | Montgomery | Arkansas | 5097 | 22 | 0 |
373564 | 373564 | 2020-07-27 | Montgomery | Georgia | 13209 | 108 | 0 |
373735 | 373735 | 2020-07-27 | Montgomery | Illinois | 17135 | 128 | 2 |
373824 | 373824 | 2020-07-27 | Montgomery | Indiana | 18107 | 321 | 22 |
373931 | 373931 | 2020-07-27 | Montgomery | Iowa | 19137 | 38 | 2 |
374025 | 374025 | 2020-07-27 | Montgomery | Kansas | 20125 | 132 | 4 |
374152 | 374152 | 2020-07-27 | Montgomery | Kentucky | 21173 | 97 | 0 |
374283 | 374283 | 2020-07-27 | Montgomery | Maryland | 24031 | 17203 | 787 |
374528 | 374528 | 2020-07-27 | Montgomery | Mississippi | 28097 | 250 | 3 |
374634 | 374634 | 2020-07-27 | Montgomery | Missouri | 29139 | 29 | 0 |
374921 | 374921 | 2020-07-27 | Montgomery | New York | 36057 | 148 | 5 |
375014 | 375014 | 2020-07-27 | Montgomery | North Carolina | 37123 | 531 | 13 |
375164 | 375164 | 2020-07-27 | Montgomery | Ohio | 39113 | 3567 | 55 |
375354 | 375354 | 2020-07-27 | Montgomery | Pennsylvania | 42091 | 9555 | 844 |
375634 | 375634 | 2020-07-27 | Montgomery | Tennessee | 47125 | 1455 | 9 |
375834 | 375834 | 2020-07-27 | Montgomery | Texas | 48339 | 5780 | 58 |
376046 | 376046 | 2020-07-27 | Montgomery | Virginia | 51121 | 257 | 3 |
369913 | 369913 | 2020-07-26 | Montgomery | Alabama | 1101 | 5724 | 140 |
370020 | 370020 | 2020-07-26 | Montgomery | Arkansas | 5097 | 19 | 0 |
370352 | 370352 | 2020-07-26 | Montgomery | Georgia | 13209 | 105 | 0 |
370523 | 370523 | 2020-07-26 | Montgomery | Illinois | 17135 | 126 | 2 |
370612 | 370612 | 2020-07-26 | Montgomery | Indiana | 18107 | 319 | 22 |
370719 | 370719 | 2020-07-26 | Montgomery | Iowa | 19137 | 38 | 2 |
370813 | 370813 | 2020-07-26 | Montgomery | Kansas | 20125 | 120 | 4 |
370940 | 370940 | 2020-07-26 | Montgomery | Kentucky | 21173 | 97 | 0 |
371071 | 371071 | 2020-07-26 | Montgomery | Maryland | 24031 | 17058 | 783 |
371316 | 371316 | 2020-07-26 | Montgomery | Mississippi | 28097 | 250 | 3 |
371422 | 371422 | 2020-07-26 | Montgomery | Missouri | 29139 | 27 | 0 |
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);