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 |
---|---|---|---|---|---|---|---|
280838 | 280838 | 2020-06-28 | Montgomery | Alabama | 1101 | 3630 | 95 |
280941 | 280941 | 2020-06-28 | Montgomery | Arkansas | 5097 | 4 | 0 |
281271 | 281271 | 2020-06-28 | Montgomery | Georgia | 13209 | 31 | 0 |
281440 | 281440 | 2020-06-28 | Montgomery | Illinois | 17135 | 41 | 0 |
281528 | 281528 | 2020-06-28 | Montgomery | Indiana | 18107 | 283 | 20 |
281635 | 281635 | 2020-06-28 | Montgomery | Iowa | 19137 | 10 | 2 |
281724 | 281724 | 2020-06-28 | Montgomery | Kansas | 20125 | 29 | 3 |
281848 | 281848 | 2020-06-28 | Montgomery | Kentucky | 21173 | 58 | 0 |
281978 | 281978 | 2020-06-28 | Montgomery | Maryland | 24031 | 14646 | 735 |
282221 | 282221 | 2020-06-28 | Montgomery | Mississippi | 28097 | 111 | 2 |
282325 | 282325 | 2020-06-28 | Montgomery | Missouri | 29139 | 16 | 0 |
282592 | 282592 | 2020-06-28 | Montgomery | New York | 36057 | 118 | 5 |
282685 | 282685 | 2020-06-28 | Montgomery | North Carolina | 37123 | 298 | 7 |
282831 | 282831 | 2020-06-28 | Montgomery | Ohio | 39113 | 1603 | 22 |
283017 | 283017 | 2020-06-28 | Montgomery | Pennsylvania | 42091 | 8377 | 798 |
283291 | 283291 | 2020-06-28 | Montgomery | Tennessee | 47125 | 438 | 7 |
283486 | 283486 | 2020-06-28 | Montgomery | Texas | 48339 | 1952 | 36 |
283695 | 283695 | 2020-06-28 | Montgomery | Virginia | 51121 | 136 | 2 |
277690 | 277690 | 2020-06-27 | Montgomery | Alabama | 1101 | 3624 | 95 |
277794 | 277794 | 2020-06-27 | Montgomery | Arkansas | 5097 | 4 | 0 |
278124 | 278124 | 2020-06-27 | Montgomery | Georgia | 13209 | 31 | 0 |
278292 | 278292 | 2020-06-27 | Montgomery | Illinois | 17135 | 41 | 0 |
278380 | 278380 | 2020-06-27 | Montgomery | Indiana | 18107 | 283 | 20 |
278487 | 278487 | 2020-06-27 | Montgomery | Iowa | 19137 | 10 | 2 |
278576 | 278576 | 2020-06-27 | Montgomery | Kansas | 20125 | 29 | 3 |
278700 | 278700 | 2020-06-27 | Montgomery | Kentucky | 21173 | 47 | 0 |
278830 | 278830 | 2020-06-27 | Montgomery | Maryland | 24031 | 14559 | 734 |
279073 | 279073 | 2020-06-27 | Montgomery | Mississippi | 28097 | 111 | 2 |
279177 | 279177 | 2020-06-27 | Montgomery | Missouri | 29139 | 16 | 0 |
279446 | 279446 | 2020-06-27 | Montgomery | New York | 36057 | 116 | 5 |
279539 | 279539 | 2020-06-27 | Montgomery | North Carolina | 37123 | 284 | 7 |
279685 | 279685 | 2020-06-27 | Montgomery | Ohio | 39113 | 1553 | 22 |
279871 | 279871 | 2020-06-27 | Montgomery | Pennsylvania | 42091 | 8351 | 798 |
280145 | 280145 | 2020-06-27 | Montgomery | Tennessee | 47125 | 438 | 7 |
280340 | 280340 | 2020-06-27 | Montgomery | Texas | 48339 | 1952 | 36 |
280549 | 280549 | 2020-06-27 | Montgomery | Virginia | 51121 | 126 | 2 |
274542 | 274542 | 2020-06-26 | Montgomery | Alabama | 1101 | 3569 | 94 |
274646 | 274646 | 2020-06-26 | Montgomery | Arkansas | 5097 | 4 | 0 |
274976 | 274976 | 2020-06-26 | Montgomery | Georgia | 13209 | 31 | 0 |
275144 | 275144 | 2020-06-26 | Montgomery | Illinois | 17135 | 41 | 0 |
275232 | 275232 | 2020-06-26 | Montgomery | Indiana | 18107 | 285 | 20 |
275339 | 275339 | 2020-06-26 | Montgomery | Iowa | 19137 | 10 | 2 |
275428 | 275428 | 2020-06-26 | Montgomery | Kansas | 20125 | 29 | 3 |
275552 | 275552 | 2020-06-26 | Montgomery | Kentucky | 21173 | 46 | 0 |
275682 | 275682 | 2020-06-26 | Montgomery | Maryland | 24031 | 14510 | 730 |
275925 | 275925 | 2020-06-26 | Montgomery | Mississippi | 28097 | 110 | 2 |
276029 | 276029 | 2020-06-26 | Montgomery | Missouri | 29139 | 16 | 0 |
276298 | 276298 | 2020-06-26 | Montgomery | New York | 36057 | 113 | 5 |
276391 | 276391 | 2020-06-26 | Montgomery | North Carolina | 37123 | 274 | 7 |
276537 | 276537 | 2020-06-26 | Montgomery | Ohio | 39113 | 1527 | 22 |
276723 | 276723 | 2020-06-26 | Montgomery | Pennsylvania | 42091 | 8301 | 794 |
276997 | 276997 | 2020-06-26 | Montgomery | Tennessee | 47125 | 434 | 7 |
277192 | 277192 | 2020-06-26 | Montgomery | Texas | 48339 | 1952 | 36 |
277401 | 277401 | 2020-06-26 | Montgomery | Virginia | 51121 | 122 | 2 |
271402 | 271402 | 2020-06-25 | Montgomery | Alabama | 1101 | 3514 | 91 |
271506 | 271506 | 2020-06-25 | Montgomery | Arkansas | 5097 | 4 | 0 |
271836 | 271836 | 2020-06-25 | Montgomery | Georgia | 13209 | 28 | 0 |
272002 | 272002 | 2020-06-25 | Montgomery | Illinois | 17135 | 41 | 0 |
272090 | 272090 | 2020-06-25 | Montgomery | Indiana | 18107 | 279 | 20 |
272197 | 272197 | 2020-06-25 | Montgomery | Iowa | 19137 | 10 | 2 |
272285 | 272285 | 2020-06-25 | Montgomery | Kansas | 20125 | 25 | 3 |
272409 | 272409 | 2020-06-25 | Montgomery | Kentucky | 21173 | 46 | 0 |
272539 | 272539 | 2020-06-25 | Montgomery | Maryland | 24031 | 14421 | 731 |
272782 | 272782 | 2020-06-25 | Montgomery | Mississippi | 28097 | 110 | 2 |
272886 | 272886 | 2020-06-25 | Montgomery | Missouri | 29139 | 16 | 0 |
273152 | 273152 | 2020-06-25 | Montgomery | New York | 36057 | 111 | 5 |
273245 | 273245 | 2020-06-25 | Montgomery | North Carolina | 37123 | 269 | 7 |
273390 | 273390 | 2020-06-25 | Montgomery | Ohio | 39113 | 1465 | 22 |
273576 | 273576 | 2020-06-25 | Montgomery | Pennsylvania | 42091 | 8244 | 792 |
273850 | 273850 | 2020-06-25 | Montgomery | Tennessee | 47125 | 413 | 7 |
274044 | 274044 | 2020-06-25 | Montgomery | Texas | 48339 | 1889 | 36 |
274253 | 274253 | 2020-06-25 | Montgomery | Virginia | 51121 | 116 | 2 |
268268 | 268268 | 2020-06-24 | Montgomery | Alabama | 1101 | 3441 | 90 |
268371 | 268371 | 2020-06-24 | Montgomery | Arkansas | 5097 | 2 | 0 |
268700 | 268700 | 2020-06-24 | Montgomery | Georgia | 13209 | 28 | 0 |
268865 | 268865 | 2020-06-24 | Montgomery | Illinois | 17135 | 41 | 0 |
268953 | 268953 | 2020-06-24 | Montgomery | Indiana | 18107 | 277 | 20 |
269060 | 269060 | 2020-06-24 | Montgomery | Iowa | 19137 | 10 | 2 |
269148 | 269148 | 2020-06-24 | Montgomery | Kansas | 20125 | 25 | 3 |
269273 | 269273 | 2020-06-24 | Montgomery | Kentucky | 21173 | 46 | 0 |
269402 | 269402 | 2020-06-24 | Montgomery | Maryland | 24031 | 14323 | 728 |
269644 | 269644 | 2020-06-24 | Montgomery | Mississippi | 28097 | 107 | 2 |
269747 | 269747 | 2020-06-24 | Montgomery | Missouri | 29139 | 15 | 0 |
270013 | 270013 | 2020-06-24 | Montgomery | New York | 36057 | 110 | 5 |
270106 | 270106 | 2020-06-24 | Montgomery | North Carolina | 37123 | 260 | 7 |
270251 | 270251 | 2020-06-24 | Montgomery | Ohio | 39113 | 1392 | 21 |
270437 | 270437 | 2020-06-24 | Montgomery | Pennsylvania | 42091 | 8188 | 791 |
270711 | 270711 | 2020-06-24 | Montgomery | Tennessee | 47125 | 407 | 6 |
270904 | 270904 | 2020-06-24 | Montgomery | Texas | 48339 | 1831 | 36 |
271113 | 271113 | 2020-06-24 | Montgomery | Virginia | 51121 | 116 | 2 |
265139 | 265139 | 2020-06-23 | Montgomery | Alabama | 1101 | 3351 | 87 |
265241 | 265241 | 2020-06-23 | Montgomery | Arkansas | 5097 | 2 | 0 |
265570 | 265570 | 2020-06-23 | Montgomery | Georgia | 13209 | 28 | 0 |
265735 | 265735 | 2020-06-23 | Montgomery | Illinois | 17135 | 41 | 0 |
265823 | 265823 | 2020-06-23 | Montgomery | Indiana | 18107 | 276 | 20 |
265930 | 265930 | 2020-06-23 | Montgomery | Iowa | 19137 | 10 | 2 |
266016 | 266016 | 2020-06-23 | Montgomery | Kansas | 20125 | 25 | 3 |
266140 | 266140 | 2020-06-23 | Montgomery | Kentucky | 21173 | 44 | 0 |
266269 | 266269 | 2020-06-23 | Montgomery | Maryland | 24031 | 14244 | 725 |
266511 | 266511 | 2020-06-23 | Montgomery | Mississippi | 28097 | 105 | 1 |
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);