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 |
---|---|---|---|---|---|---|---|
534581 | 534581 | 2020-09-15 | Montgomery | Arkansas | 5097 | 123 | 4 |
534914 | 534914 | 2020-09-15 | Montgomery | Georgia | 13209 | 268 | 5 |
535088 | 535088 | 2020-09-15 | Montgomery | Illinois | 17135 | 287 | 11 |
535177 | 535177 | 2020-09-15 | Montgomery | Indiana | 18107 | 495 | 22 |
535284 | 535284 | 2020-09-15 | Montgomery | Iowa | 19137 | 84 | 5 |
535378 | 535378 | 2020-09-15 | Montgomery | Kansas | 20125 | 333 | 5 |
535507 | 535507 | 2020-09-15 | Montgomery | Kentucky | 21173 | 221 | 1 |
535637 | 535637 | 2020-09-15 | Montgomery | Maryland | 24031 | 21415 | 835 |
535882 | 535882 | 2020-09-15 | Montgomery | Mississippi | 28097 | 438 | 20 |
535987 | 535987 | 2020-09-15 | Montgomery | Missouri | 29139 | 68 | 1 |
536287 | 536287 | 2020-09-15 | Montgomery | New York | 36057 | 218 | 9 |
536380 | 536380 | 2020-09-15 | Montgomery | North Carolina | 37123 | 990 | 23 |
536532 | 536532 | 2020-09-15 | Montgomery | Ohio | 39113 | 7216 | 146 |
536722 | 536722 | 2020-09-15 | Montgomery | Pennsylvania | 42091 | 11710 | 868 |
537003 | 537003 | 2020-09-15 | Montgomery | Tennessee | 47125 | 2833 | 41 |
537203 | 537203 | 2020-09-15 | Montgomery | Texas | 48339 | 10182 | 147 |
537417 | 537417 | 2020-09-15 | Montgomery | Virginia | 51121 | 1515 | 4 |
531239 | 531239 | 2020-09-14 | Montgomery | Alabama | 1101 | 8487 | 170 |
531346 | 531346 | 2020-09-14 | Montgomery | Arkansas | 5097 | 123 | 4 |
531679 | 531679 | 2020-09-14 | Montgomery | Georgia | 13209 | 265 | 5 |
531853 | 531853 | 2020-09-14 | Montgomery | Illinois | 17135 | 288 | 11 |
531942 | 531942 | 2020-09-14 | Montgomery | Indiana | 18107 | 495 | 22 |
532049 | 532049 | 2020-09-14 | Montgomery | Iowa | 19137 | 83 | 5 |
532143 | 532143 | 2020-09-14 | Montgomery | Kansas | 20125 | 333 | 5 |
532272 | 532272 | 2020-09-14 | Montgomery | Kentucky | 21173 | 220 | 1 |
532402 | 532402 | 2020-09-14 | Montgomery | Maryland | 24031 | 21321 | 834 |
532647 | 532647 | 2020-09-14 | Montgomery | Mississippi | 28097 | 438 | 19 |
532752 | 532752 | 2020-09-14 | Montgomery | Missouri | 29139 | 68 | 1 |
533051 | 533051 | 2020-09-14 | Montgomery | New York | 36057 | 218 | 9 |
533144 | 533144 | 2020-09-14 | Montgomery | North Carolina | 37123 | 986 | 23 |
533296 | 533296 | 2020-09-14 | Montgomery | Ohio | 39113 | 7148 | 144 |
533486 | 533486 | 2020-09-14 | Montgomery | Pennsylvania | 42091 | 11657 | 868 |
533767 | 533767 | 2020-09-14 | Montgomery | Tennessee | 47125 | 2826 | 40 |
533967 | 533967 | 2020-09-14 | Montgomery | Texas | 48339 | 10016 | 145 |
534181 | 534181 | 2020-09-14 | Montgomery | Virginia | 51121 | 1487 | 4 |
528002 | 528002 | 2020-09-13 | Montgomery | Alabama | 1101 | 8446 | 170 |
528109 | 528109 | 2020-09-13 | Montgomery | Arkansas | 5097 | 121 | 4 |
528442 | 528442 | 2020-09-13 | Montgomery | Georgia | 13209 | 261 | 5 |
528616 | 528616 | 2020-09-13 | Montgomery | Illinois | 17135 | 287 | 11 |
528705 | 528705 | 2020-09-13 | Montgomery | Indiana | 18107 | 494 | 22 |
528812 | 528812 | 2020-09-13 | Montgomery | Iowa | 19137 | 83 | 5 |
528906 | 528906 | 2020-09-13 | Montgomery | Kansas | 20125 | 321 | 5 |
529035 | 529035 | 2020-09-13 | Montgomery | Kentucky | 21173 | 220 | 1 |
529166 | 529166 | 2020-09-13 | Montgomery | Maryland | 24031 | 21207 | 834 |
529411 | 529411 | 2020-09-13 | Montgomery | Mississippi | 28097 | 437 | 19 |
529516 | 529516 | 2020-09-13 | Montgomery | Missouri | 29139 | 67 | 1 |
529816 | 529816 | 2020-09-13 | Montgomery | New York | 36057 | 218 | 9 |
529909 | 529909 | 2020-09-13 | Montgomery | North Carolina | 37123 | 979 | 23 |
530061 | 530061 | 2020-09-13 | Montgomery | Ohio | 39113 | 7084 | 144 |
530251 | 530251 | 2020-09-13 | Montgomery | Pennsylvania | 42091 | 11578 | 867 |
530532 | 530532 | 2020-09-13 | Montgomery | Tennessee | 47125 | 2790 | 39 |
530732 | 530732 | 2020-09-13 | Montgomery | Texas | 48339 | 9790 | 145 |
530946 | 530946 | 2020-09-13 | Montgomery | Virginia | 51121 | 1395 | 4 |
524766 | 524766 | 2020-09-12 | Montgomery | Alabama | 1101 | 8390 | 170 |
524873 | 524873 | 2020-09-12 | Montgomery | Arkansas | 5097 | 121 | 4 |
525206 | 525206 | 2020-09-12 | Montgomery | Georgia | 13209 | 258 | 5 |
525380 | 525380 | 2020-09-12 | Montgomery | Illinois | 17135 | 288 | 11 |
525469 | 525469 | 2020-09-12 | Montgomery | Indiana | 18107 | 492 | 22 |
525576 | 525576 | 2020-09-12 | Montgomery | Iowa | 19137 | 83 | 5 |
525670 | 525670 | 2020-09-12 | Montgomery | Kansas | 20125 | 321 | 5 |
525799 | 525799 | 2020-09-12 | Montgomery | Kentucky | 21173 | 219 | 1 |
525930 | 525930 | 2020-09-12 | Montgomery | Maryland | 24031 | 21129 | 834 |
526175 | 526175 | 2020-09-12 | Montgomery | Mississippi | 28097 | 437 | 19 |
526280 | 526280 | 2020-09-12 | Montgomery | Missouri | 29139 | 67 | 1 |
526579 | 526579 | 2020-09-12 | Montgomery | New York | 36057 | 218 | 9 |
526672 | 526672 | 2020-09-12 | Montgomery | North Carolina | 37123 | 975 | 23 |
526824 | 526824 | 2020-09-12 | Montgomery | Ohio | 39113 | 7026 | 144 |
527014 | 527014 | 2020-09-12 | Montgomery | Pennsylvania | 42091 | 11578 | 867 |
527295 | 527295 | 2020-09-12 | Montgomery | Tennessee | 47125 | 2761 | 39 |
527495 | 527495 | 2020-09-12 | Montgomery | Texas | 48339 | 9790 | 144 |
527709 | 527709 | 2020-09-12 | Montgomery | Virginia | 51121 | 1341 | 4 |
521530 | 521530 | 2020-09-11 | Montgomery | Alabama | 1101 | 8349 | 170 |
521637 | 521637 | 2020-09-11 | Montgomery | Arkansas | 5097 | 120 | 4 |
521970 | 521970 | 2020-09-11 | Montgomery | Georgia | 13209 | 253 | 5 |
522144 | 522144 | 2020-09-11 | Montgomery | Illinois | 17135 | 279 | 11 |
522233 | 522233 | 2020-09-11 | Montgomery | Indiana | 18107 | 487 | 22 |
522340 | 522340 | 2020-09-11 | Montgomery | Iowa | 19137 | 83 | 5 |
522434 | 522434 | 2020-09-11 | Montgomery | Kansas | 20125 | 321 | 5 |
522563 | 522563 | 2020-09-11 | Montgomery | Kentucky | 21173 | 217 | 1 |
522694 | 522694 | 2020-09-11 | Montgomery | Maryland | 24031 | 21033 | 833 |
522939 | 522939 | 2020-09-11 | Montgomery | Mississippi | 28097 | 435 | 19 |
523044 | 523044 | 2020-09-11 | Montgomery | Missouri | 29139 | 65 | 1 |
523343 | 523343 | 2020-09-11 | Montgomery | New York | 36057 | 217 | 9 |
523436 | 523436 | 2020-09-11 | Montgomery | North Carolina | 37123 | 968 | 22 |
523588 | 523588 | 2020-09-11 | Montgomery | Ohio | 39113 | 6961 | 143 |
523778 | 523778 | 2020-09-11 | Montgomery | Pennsylvania | 42091 | 11537 | 867 |
524059 | 524059 | 2020-09-11 | Montgomery | Tennessee | 47125 | 2749 | 37 |
524259 | 524259 | 2020-09-11 | Montgomery | Texas | 48339 | 9790 | 140 |
524473 | 524473 | 2020-09-11 | Montgomery | Virginia | 51121 | 1211 | 4 |
518293 | 518293 | 2020-09-10 | Montgomery | Alabama | 1101 | 8310 | 169 |
518400 | 518400 | 2020-09-10 | Montgomery | Arkansas | 5097 | 119 | 4 |
518733 | 518733 | 2020-09-10 | Montgomery | Georgia | 13209 | 250 | 4 |
518907 | 518907 | 2020-09-10 | Montgomery | Illinois | 17135 | 273 | 11 |
518996 | 518996 | 2020-09-10 | Montgomery | Indiana | 18107 | 476 | 22 |
519103 | 519103 | 2020-09-10 | Montgomery | Iowa | 19137 | 83 | 5 |
519197 | 519197 | 2020-09-10 | Montgomery | Kansas | 20125 | 286 | 5 |
519326 | 519326 | 2020-09-10 | Montgomery | Kentucky | 21173 | 214 | 1 |
519457 | 519457 | 2020-09-10 | Montgomery | Maryland | 24031 | 20933 | 832 |
519702 | 519702 | 2020-09-10 | Montgomery | Mississippi | 28097 | 429 | 19 |
519807 | 519807 | 2020-09-10 | Montgomery | Missouri | 29139 | 65 | 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);