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 |
---|---|---|---|---|---|---|---|
319916 | 319916 | 2020-07-10 | Montgomery | Maryland | 24031 | 15606 | 755 |
320160 | 320160 | 2020-07-10 | Montgomery | Mississippi | 28097 | 151 | 3 |
320265 | 320265 | 2020-07-10 | Montgomery | Missouri | 29139 | 23 | 0 |
320537 | 320537 | 2020-07-10 | Montgomery | New York | 36057 | 128 | 5 |
320630 | 320630 | 2020-07-10 | Montgomery | North Carolina | 37123 | 376 | 9 |
320777 | 320777 | 2020-07-10 | Montgomery | Ohio | 39113 | 2378 | 35 |
320966 | 320966 | 2020-07-10 | Montgomery | Pennsylvania | 42091 | 8790 | 826 |
321244 | 321244 | 2020-07-10 | Montgomery | Tennessee | 47125 | 712 | 7 |
321442 | 321442 | 2020-07-10 | Montgomery | Texas | 48339 | 3007 | 41 |
321653 | 321653 | 2020-07-10 | Montgomery | Virginia | 51121 | 177 | 3 |
315591 | 315591 | 2020-07-09 | Montgomery | Alabama | 1101 | 4386 | 111 |
315697 | 315697 | 2020-07-09 | Montgomery | Arkansas | 5097 | 8 | 0 |
316027 | 316027 | 2020-07-09 | Montgomery | Georgia | 13209 | 48 | 0 |
316198 | 316198 | 2020-07-09 | Montgomery | Illinois | 17135 | 64 | 0 |
316287 | 316287 | 2020-07-09 | Montgomery | Indiana | 18107 | 299 | 21 |
316394 | 316394 | 2020-07-09 | Montgomery | Iowa | 19137 | 11 | 2 |
316485 | 316485 | 2020-07-09 | Montgomery | Kansas | 20125 | 53 | 3 |
316610 | 316610 | 2020-07-09 | Montgomery | Kentucky | 21173 | 61 | 0 |
316741 | 316741 | 2020-07-09 | Montgomery | Maryland | 24031 | 15541 | 754 |
316985 | 316985 | 2020-07-09 | Montgomery | Mississippi | 28097 | 149 | 3 |
317090 | 317090 | 2020-07-09 | Montgomery | Missouri | 29139 | 23 | 0 |
317360 | 317360 | 2020-07-09 | Montgomery | New York | 36057 | 125 | 5 |
317453 | 317453 | 2020-07-09 | Montgomery | North Carolina | 37123 | 368 | 9 |
317600 | 317600 | 2020-07-09 | Montgomery | Ohio | 39113 | 2283 | 35 |
317788 | 317788 | 2020-07-09 | Montgomery | Pennsylvania | 42091 | 8749 | 822 |
318066 | 318066 | 2020-07-09 | Montgomery | Tennessee | 47125 | 658 | 7 |
318263 | 318263 | 2020-07-09 | Montgomery | Texas | 48339 | 2876 | 40 |
318474 | 318474 | 2020-07-09 | Montgomery | Virginia | 51121 | 172 | 3 |
312416 | 312416 | 2020-07-08 | Montgomery | Alabama | 1101 | 4321 | 111 |
312522 | 312522 | 2020-07-08 | Montgomery | Arkansas | 5097 | 7 | 0 |
312852 | 312852 | 2020-07-08 | Montgomery | Georgia | 13209 | 45 | 0 |
313024 | 313024 | 2020-07-08 | Montgomery | Illinois | 17135 | 59 | 0 |
313113 | 313113 | 2020-07-08 | Montgomery | Indiana | 18107 | 299 | 21 |
313220 | 313220 | 2020-07-08 | Montgomery | Iowa | 19137 | 10 | 2 |
313311 | 313311 | 2020-07-08 | Montgomery | Kansas | 20125 | 53 | 3 |
313436 | 313436 | 2020-07-08 | Montgomery | Kentucky | 21173 | 61 | 0 |
313567 | 313567 | 2020-07-08 | Montgomery | Maryland | 24031 | 15438 | 752 |
313811 | 313811 | 2020-07-08 | Montgomery | Mississippi | 28097 | 143 | 2 |
313916 | 313916 | 2020-07-08 | Montgomery | Missouri | 29139 | 21 | 0 |
314186 | 314186 | 2020-07-08 | Montgomery | New York | 36057 | 121 | 5 |
314279 | 314279 | 2020-07-08 | Montgomery | North Carolina | 37123 | 362 | 9 |
314427 | 314427 | 2020-07-08 | Montgomery | Ohio | 39113 | 2201 | 31 |
314615 | 314615 | 2020-07-08 | Montgomery | Pennsylvania | 42091 | 8718 | 818 |
314893 | 314893 | 2020-07-08 | Montgomery | Tennessee | 47125 | 620 | 7 |
315090 | 315090 | 2020-07-08 | Montgomery | Texas | 48339 | 2784 | 38 |
315301 | 315301 | 2020-07-08 | Montgomery | Virginia | 51121 | 170 | 3 |
309247 | 309247 | 2020-07-07 | Montgomery | Alabama | 1101 | 4293 | 107 |
309352 | 309352 | 2020-07-07 | Montgomery | Arkansas | 5097 | 7 | 0 |
309682 | 309682 | 2020-07-07 | Montgomery | Georgia | 13209 | 41 | 0 |
309854 | 309854 | 2020-07-07 | Montgomery | Illinois | 17135 | 56 | 0 |
309943 | 309943 | 2020-07-07 | Montgomery | Indiana | 18107 | 299 | 21 |
310050 | 310050 | 2020-07-07 | Montgomery | Iowa | 19137 | 10 | 2 |
310141 | 310141 | 2020-07-07 | Montgomery | Kansas | 20125 | 49 | 3 |
310266 | 310266 | 2020-07-07 | Montgomery | Kentucky | 21173 | 61 | 0 |
310397 | 310397 | 2020-07-07 | Montgomery | Maryland | 24031 | 15370 | 752 |
310641 | 310641 | 2020-07-07 | Montgomery | Mississippi | 28097 | 139 | 2 |
310745 | 310745 | 2020-07-07 | Montgomery | Missouri | 29139 | 21 | 0 |
311015 | 311015 | 2020-07-07 | Montgomery | New York | 36057 | 121 | 5 |
311108 | 311108 | 2020-07-07 | Montgomery | North Carolina | 37123 | 358 | 9 |
311255 | 311255 | 2020-07-07 | Montgomery | Ohio | 39113 | 2134 | 31 |
311443 | 311443 | 2020-07-07 | Montgomery | Pennsylvania | 42091 | 8682 | 815 |
311719 | 311719 | 2020-07-07 | Montgomery | Tennessee | 47125 | 587 | 7 |
311916 | 311916 | 2020-07-07 | Montgomery | Texas | 48339 | 2654 | 38 |
312126 | 312126 | 2020-07-07 | Montgomery | Virginia | 51121 | 167 | 2 |
306078 | 306078 | 2020-07-06 | Montgomery | Alabama | 1101 | 4205 | 105 |
306184 | 306184 | 2020-07-06 | Montgomery | Arkansas | 5097 | 6 | 0 |
306514 | 306514 | 2020-07-06 | Montgomery | Georgia | 13209 | 33 | 0 |
306686 | 306686 | 2020-07-06 | Montgomery | Illinois | 17135 | 49 | 0 |
306775 | 306775 | 2020-07-06 | Montgomery | Indiana | 18107 | 296 | 21 |
306882 | 306882 | 2020-07-06 | Montgomery | Iowa | 19137 | 10 | 2 |
306973 | 306973 | 2020-07-06 | Montgomery | Kansas | 20125 | 49 | 3 |
307098 | 307098 | 2020-07-06 | Montgomery | Kentucky | 21173 | 58 | 0 |
307229 | 307229 | 2020-07-06 | Montgomery | Maryland | 24031 | 15201 | 753 |
307473 | 307473 | 2020-07-06 | Montgomery | Mississippi | 28097 | 135 | 2 |
307577 | 307577 | 2020-07-06 | Montgomery | Missouri | 29139 | 21 | 0 |
307847 | 307847 | 2020-07-06 | Montgomery | New York | 36057 | 120 | 5 |
307940 | 307940 | 2020-07-06 | Montgomery | North Carolina | 37123 | 347 | 7 |
308086 | 308086 | 2020-07-06 | Montgomery | Ohio | 39113 | 2034 | 27 |
308274 | 308274 | 2020-07-06 | Montgomery | Pennsylvania | 42091 | 8634 | 811 |
308550 | 308550 | 2020-07-06 | Montgomery | Tennessee | 47125 | 567 | 7 |
308747 | 308747 | 2020-07-06 | Montgomery | Texas | 48339 | 2550 | 37 |
308957 | 308957 | 2020-07-06 | Montgomery | Virginia | 51121 | 163 | 2 |
302914 | 302914 | 2020-07-05 | Montgomery | Alabama | 1101 | 4174 | 105 |
303020 | 303020 | 2020-07-05 | Montgomery | Arkansas | 5097 | 5 | 0 |
303350 | 303350 | 2020-07-05 | Montgomery | Georgia | 13209 | 33 | 0 |
303521 | 303521 | 2020-07-05 | Montgomery | Illinois | 17135 | 48 | 0 |
303610 | 303610 | 2020-07-05 | Montgomery | Indiana | 18107 | 296 | 21 |
303717 | 303717 | 2020-07-05 | Montgomery | Iowa | 19137 | 10 | 2 |
303806 | 303806 | 2020-07-05 | Montgomery | Kansas | 20125 | 41 | 3 |
303931 | 303931 | 2020-07-05 | Montgomery | Kentucky | 21173 | 58 | 0 |
304062 | 304062 | 2020-07-05 | Montgomery | Maryland | 24031 | 15167 | 749 |
304306 | 304306 | 2020-07-05 | Montgomery | Mississippi | 28097 | 132 | 2 |
304410 | 304410 | 2020-07-05 | Montgomery | Missouri | 29139 | 20 | 0 |
304680 | 304680 | 2020-07-05 | Montgomery | New York | 36057 | 119 | 5 |
304773 | 304773 | 2020-07-05 | Montgomery | North Carolina | 37123 | 343 | 7 |
304919 | 304919 | 2020-07-05 | Montgomery | Ohio | 39113 | 1981 | 26 |
305107 | 305107 | 2020-07-05 | Montgomery | Pennsylvania | 42091 | 8610 | 811 |
305382 | 305382 | 2020-07-05 | Montgomery | Tennessee | 47125 | 554 | 7 |
305579 | 305579 | 2020-07-05 | Montgomery | Texas | 48339 | 2353 | 37 |
305789 | 305789 | 2020-07-05 | Montgomery | Virginia | 51121 | 158 | 2 |
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);