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 |
---|---|---|---|---|---|---|---|
1193159 | 1193159 | 2021-04-06 | Montgomery | Alabama | 1101 | 23856 | 561 |
1193267 | 1193267 | 2021-04-06 | Montgomery | Arkansas | 5097 | 751 | 33 |
1193601 | 1193601 | 2021-04-06 | Montgomery | Georgia | 13209 | 868 | 22 |
1193776 | 1193776 | 2021-04-06 | Montgomery | Illinois | 17135 | 3610 | 77 |
1193865 | 1193865 | 2021-04-06 | Montgomery | Indiana | 18107 | 4109 | 87 |
1193972 | 1193972 | 2021-04-06 | Montgomery | Iowa | 19137 | 987 | 37 |
1194066 | 1194066 | 2021-04-06 | Montgomery | Kansas | 20125 | 3402 | 6 |
1194196 | 1194196 | 2021-04-06 | Montgomery | Kentucky | 21173 | 2456 | 30 |
1194326 | 1194326 | 2021-04-06 | Montgomery | Maryland | 24031 | 67421 | 1484 |
1194571 | 1194571 | 2021-04-06 | Montgomery | Mississippi | 28097 | 1252 | 42 |
1194676 | 1194676 | 2021-04-06 | Montgomery | Missouri | 29139 | 1031 | 10 |
1194981 | 1194981 | 2021-04-06 | Montgomery | New York | 36057 | 3699 | 114 |
1195074 | 1195074 | 2021-04-06 | Montgomery | North Carolina | 37123 | 3212 | 91 |
1195225 | 1195225 | 2021-04-06 | Montgomery | Ohio | 39113 | 49160 | 983 |
1195417 | 1195417 | 2021-04-06 | Montgomery | Pennsylvania | 42091 | 61499 | 1617 |
1195698 | 1195698 | 2021-04-06 | Montgomery | Tennessee | 47125 | 18652 | 223 |
1195901 | 1195901 | 2021-04-06 | Montgomery | Texas | 48339 | 49936 | 526 |
1196116 | 1196116 | 2021-04-06 | Montgomery | Virginia | 51121 | 8896 | 88 |
1189909 | 1189909 | 2021-04-05 | Montgomery | Alabama | 1101 | 23836 | 561 |
1190017 | 1190017 | 2021-04-05 | Montgomery | Arkansas | 5097 | 751 | 33 |
1190351 | 1190351 | 2021-04-05 | Montgomery | Georgia | 13209 | 868 | 22 |
1190526 | 1190526 | 2021-04-05 | Montgomery | Illinois | 17135 | 3608 | 77 |
1190615 | 1190615 | 2021-04-05 | Montgomery | Indiana | 18107 | 4107 | 87 |
1190722 | 1190722 | 2021-04-05 | Montgomery | Iowa | 19137 | 986 | 37 |
1190816 | 1190816 | 2021-04-05 | Montgomery | Kansas | 20125 | 3402 | 6 |
1190946 | 1190946 | 2021-04-05 | Montgomery | Kentucky | 21173 | 2454 | 30 |
1191077 | 1191077 | 2021-04-05 | Montgomery | Maryland | 24031 | 67349 | 1481 |
1191322 | 1191322 | 2021-04-05 | Montgomery | Mississippi | 28097 | 1251 | 41 |
1191427 | 1191427 | 2021-04-05 | Montgomery | Missouri | 29139 | 1031 | 10 |
1191733 | 1191733 | 2021-04-05 | Montgomery | New York | 36057 | 3685 | 114 |
1191826 | 1191826 | 2021-04-05 | Montgomery | North Carolina | 37123 | 3211 | 91 |
1191977 | 1191977 | 2021-04-05 | Montgomery | Ohio | 39113 | 49089 | 980 |
1192169 | 1192169 | 2021-04-05 | Montgomery | Pennsylvania | 42091 | 61280 | 1612 |
1192450 | 1192450 | 2021-04-05 | Montgomery | Tennessee | 47125 | 18617 | 221 |
1192653 | 1192653 | 2021-04-05 | Montgomery | Texas | 48339 | 49839 | 524 |
1192868 | 1192868 | 2021-04-05 | Montgomery | Virginia | 51121 | 8888 | 86 |
1186662 | 1186662 | 2021-04-04 | Montgomery | Alabama | 1101 | 23834 | 561 |
1186770 | 1186770 | 2021-04-04 | Montgomery | Arkansas | 5097 | 751 | 33 |
1187104 | 1187104 | 2021-04-04 | Montgomery | Georgia | 13209 | 868 | 22 |
1187279 | 1187279 | 2021-04-04 | Montgomery | Illinois | 17135 | 3608 | 77 |
1187368 | 1187368 | 2021-04-04 | Montgomery | Indiana | 18107 | 4104 | 87 |
1187475 | 1187475 | 2021-04-04 | Montgomery | Iowa | 19137 | 985 | 37 |
1187569 | 1187569 | 2021-04-04 | Montgomery | Kansas | 20125 | 3399 | 6 |
1187699 | 1187699 | 2021-04-04 | Montgomery | Kentucky | 21173 | 2451 | 30 |
1187829 | 1187829 | 2021-04-04 | Montgomery | Maryland | 24031 | 67258 | 1481 |
1188074 | 1188074 | 2021-04-04 | Montgomery | Mississippi | 28097 | 1250 | 41 |
1188179 | 1188179 | 2021-04-04 | Montgomery | Missouri | 29139 | 1031 | 10 |
1188484 | 1188484 | 2021-04-04 | Montgomery | New York | 36057 | 3672 | 113 |
1188577 | 1188577 | 2021-04-04 | Montgomery | North Carolina | 37123 | 3205 | 91 |
1188728 | 1188728 | 2021-04-04 | Montgomery | Ohio | 39113 | 48985 | 980 |
1188920 | 1188920 | 2021-04-04 | Montgomery | Pennsylvania | 42091 | 61007 | 1612 |
1189201 | 1189201 | 2021-04-04 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1189404 | 1189404 | 2021-04-04 | Montgomery | Texas | 48339 | 49605 | 524 |
1189618 | 1189618 | 2021-04-04 | Montgomery | Virginia | 51121 | 8878 | 86 |
1183415 | 1183415 | 2021-04-03 | Montgomery | Alabama | 1101 | 23823 | 561 |
1183523 | 1183523 | 2021-04-03 | Montgomery | Arkansas | 5097 | 751 | 33 |
1183857 | 1183857 | 2021-04-03 | Montgomery | Georgia | 13209 | 868 | 22 |
1184032 | 1184032 | 2021-04-03 | Montgomery | Illinois | 17135 | 3602 | 77 |
1184121 | 1184121 | 2021-04-03 | Montgomery | Indiana | 18107 | 4104 | 87 |
1184228 | 1184228 | 2021-04-03 | Montgomery | Iowa | 19137 | 985 | 37 |
1184322 | 1184322 | 2021-04-03 | Montgomery | Kansas | 20125 | 3399 | 6 |
1184452 | 1184452 | 2021-04-03 | Montgomery | Kentucky | 21173 | 2451 | 30 |
1184582 | 1184582 | 2021-04-03 | Montgomery | Maryland | 24031 | 67107 | 1480 |
1184827 | 1184827 | 2021-04-03 | Montgomery | Mississippi | 28097 | 1250 | 41 |
1184932 | 1184932 | 2021-04-03 | Montgomery | Missouri | 29139 | 1031 | 10 |
1185237 | 1185237 | 2021-04-03 | Montgomery | New York | 36057 | 3653 | 113 |
1185330 | 1185330 | 2021-04-03 | Montgomery | North Carolina | 37123 | 3205 | 91 |
1185481 | 1185481 | 2021-04-03 | Montgomery | Ohio | 39113 | 48985 | 980 |
1185673 | 1185673 | 2021-04-03 | Montgomery | Pennsylvania | 42091 | 60687 | 1612 |
1185954 | 1185954 | 2021-04-03 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1186157 | 1186157 | 2021-04-03 | Montgomery | Texas | 48339 | 49605 | 523 |
1186371 | 1186371 | 2021-04-03 | Montgomery | Virginia | 51121 | 8853 | 86 |
1180168 | 1180168 | 2021-04-02 | Montgomery | Alabama | 1101 | 23800 | 558 |
1180276 | 1180276 | 2021-04-02 | Montgomery | Arkansas | 5097 | 751 | 33 |
1180610 | 1180610 | 2021-04-02 | Montgomery | Georgia | 13209 | 869 | 22 |
1180785 | 1180785 | 2021-04-02 | Montgomery | Illinois | 17135 | 3601 | 77 |
1180874 | 1180874 | 2021-04-02 | Montgomery | Indiana | 18107 | 4100 | 87 |
1180981 | 1180981 | 2021-04-02 | Montgomery | Iowa | 19137 | 985 | 37 |
1181075 | 1181075 | 2021-04-02 | Montgomery | Kansas | 20125 | 3399 | 6 |
1181205 | 1181205 | 2021-04-02 | Montgomery | Kentucky | 21173 | 2445 | 30 |
1181336 | 1181336 | 2021-04-02 | Montgomery | Maryland | 24031 | 66997 | 1476 |
1181581 | 1181581 | 2021-04-02 | Montgomery | Mississippi | 28097 | 1250 | 41 |
1181686 | 1181686 | 2021-04-02 | Montgomery | Missouri | 29139 | 1030 | 10 |
1181990 | 1181990 | 2021-04-02 | Montgomery | New York | 36057 | 3635 | 112 |
1182083 | 1182083 | 2021-04-02 | Montgomery | North Carolina | 37123 | 3205 | 91 |
1182234 | 1182234 | 2021-04-02 | Montgomery | Ohio | 39113 | 48881 | 980 |
1182426 | 1182426 | 2021-04-02 | Montgomery | Pennsylvania | 42091 | 60315 | 1612 |
1182707 | 1182707 | 2021-04-02 | Montgomery | Tennessee | 47125 | 18441 | 221 |
1182910 | 1182910 | 2021-04-02 | Montgomery | Texas | 48339 | 49605 | 522 |
1183124 | 1183124 | 2021-04-02 | Montgomery | Virginia | 51121 | 8820 | 86 |
1176921 | 1176921 | 2021-04-01 | Montgomery | Alabama | 1101 | 23779 | 552 |
1177029 | 1177029 | 2021-04-01 | Montgomery | Arkansas | 5097 | 751 | 33 |
1177363 | 1177363 | 2021-04-01 | Montgomery | Georgia | 13209 | 868 | 22 |
1177538 | 1177538 | 2021-04-01 | Montgomery | Illinois | 17135 | 3600 | 77 |
1177627 | 1177627 | 2021-04-01 | Montgomery | Indiana | 18107 | 4091 | 87 |
1177734 | 1177734 | 2021-04-01 | Montgomery | Iowa | 19137 | 983 | 37 |
1177828 | 1177828 | 2021-04-01 | Montgomery | Kansas | 20125 | 3395 | 6 |
1177958 | 1177958 | 2021-04-01 | Montgomery | Kentucky | 21173 | 2441 | 30 |
1178089 | 1178089 | 2021-04-01 | Montgomery | Maryland | 24031 | 66877 | 1476 |
1178334 | 1178334 | 2021-04-01 | Montgomery | Mississippi | 28097 | 1250 | 41 |
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);