ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

14,081 rows where county = "Montgomery" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 18

fips 18

county 1

  • Montgomery · 14,081 ✖
Link rowid date ▲ county state fips cases deaths
2499625 2499625 2022-05-13 Montgomery Alabama 1101 55316 948
2499734 2499734 2022-05-13 Montgomery Arkansas 5097 1525 57
2500068 2500068 2022-05-13 Montgomery Georgia 13209 2082 53
2500244 2500244 2022-05-13 Montgomery Illinois 17135 9872 111
2500333 2500333 2022-05-13 Montgomery Indiana 18107 10737 164
2500441 2500441 2022-05-13 Montgomery Iowa 19137 2216 55
2500535 2500535 2022-05-13 Montgomery Kansas 20125 9448 154
2500665 2500665 2022-05-13 Montgomery Kentucky 21173 8200 108
2500796 2500796 2022-05-13 Montgomery Maryland 24031 178052 2044
2501041 2501041 2022-05-13 Montgomery Mississippi 28097 2963 77
2501147 2501147 2022-05-13 Montgomery Missouri 29139 2522 57
2501454 2501454 2022-05-13 Montgomery New York 36057 12471 205
2501547 2501547 2022-05-13 Montgomery North Carolina 37123 7308 129
2501700 2501700 2022-05-13 Montgomery Ohio 39113 128090 2019
2501892 2501892 2022-05-13 Montgomery Pennsylvania 42091 158154 2329
2502173 2502173 2022-05-13 Montgomery Tennessee 47125 50488 579
2502376 2502376 2022-05-13 Montgomery Texas 48339 141687 1291
2502591 2502591 2022-05-13 Montgomery Virginia 51121 19403 154
2496367 2496367 2022-05-12 Montgomery Alabama 1101 55297 948
2496476 2496476 2022-05-12 Montgomery Arkansas 5097 1525 57
2496810 2496810 2022-05-12 Montgomery Georgia 13209 2082 53
2496986 2496986 2022-05-12 Montgomery Illinois 17135 9868 111
2497075 2497075 2022-05-12 Montgomery Indiana 18107 10733 164
2497183 2497183 2022-05-12 Montgomery Iowa 19137 2216 55
2497277 2497277 2022-05-12 Montgomery Kansas 20125 9435 154
2497407 2497407 2022-05-12 Montgomery Kentucky 21173 8200 108
2497538 2497538 2022-05-12 Montgomery Maryland 24031 177386 2044
2497783 2497783 2022-05-12 Montgomery Mississippi 28097 2963 77
2497889 2497889 2022-05-12 Montgomery Missouri 29139 2516 57
2498196 2498196 2022-05-12 Montgomery New York 36057 12471 205
2498289 2498289 2022-05-12 Montgomery North Carolina 37123 7308 129
2498442 2498442 2022-05-12 Montgomery Ohio 39113 128090 2019
2498634 2498634 2022-05-12 Montgomery Pennsylvania 42091 158154 2329
2498915 2498915 2022-05-12 Montgomery Tennessee 47125 50488 579
2499118 2499118 2022-05-12 Montgomery Texas 48339 141589 1291
2499333 2499333 2022-05-12 Montgomery Virginia 51121 19362 154
2493109 2493109 2022-05-11 Montgomery Alabama 1101 55266 948
2493218 2493218 2022-05-11 Montgomery Arkansas 5097 1525 57
2493552 2493552 2022-05-11 Montgomery Georgia 13209 2082 53
2493728 2493728 2022-05-11 Montgomery Illinois 17135 9863 111
2493817 2493817 2022-05-11 Montgomery Indiana 18107 10733 164
2493925 2493925 2022-05-11 Montgomery Iowa 19137 2216 55
2494019 2494019 2022-05-11 Montgomery Kansas 20125 9435 154
2494149 2494149 2022-05-11 Montgomery Kentucky 21173 8200 108
2494280 2494280 2022-05-11 Montgomery Maryland 24031 176822 2043
2494525 2494525 2022-05-11 Montgomery Mississippi 28097 2963 77
2494631 2494631 2022-05-11 Montgomery Missouri 29139 2516 57
2494938 2494938 2022-05-11 Montgomery New York 36057 12444 205
2495031 2495031 2022-05-11 Montgomery North Carolina 37123 7308 129
2495184 2495184 2022-05-11 Montgomery Ohio 39113 127624 2018
2495376 2495376 2022-05-11 Montgomery Pennsylvania 42091 158154 2329
2495657 2495657 2022-05-11 Montgomery Tennessee 47125 50488 579
2495860 2495860 2022-05-11 Montgomery Texas 48339 141462 1291
2496075 2496075 2022-05-11 Montgomery Virginia 51121 19304 154
2489851 2489851 2022-05-10 Montgomery Alabama 1101 55239 948
2489960 2489960 2022-05-10 Montgomery Arkansas 5097 1525 57
2490294 2490294 2022-05-10 Montgomery Georgia 13209 2079 53
2490470 2490470 2022-05-10 Montgomery Illinois 17135 9858 111
2490559 2490559 2022-05-10 Montgomery Indiana 18107 10726 164
2490667 2490667 2022-05-10 Montgomery Iowa 19137 2212 55
2490761 2490761 2022-05-10 Montgomery Kansas 20125 9435 154
2490891 2490891 2022-05-10 Montgomery Kentucky 21173 8200 108
2491022 2491022 2022-05-10 Montgomery Maryland 24031 176454 2041
2491267 2491267 2022-05-10 Montgomery Mississippi 28097 2963 77
2491373 2491373 2022-05-10 Montgomery Missouri 29139 2516 57
2491680 2491680 2022-05-10 Montgomery New York 36057 12422 205
2491773 2491773 2022-05-10 Montgomery North Carolina 37123 7294 129
2491926 2491926 2022-05-10 Montgomery Ohio 39113 127624 2018
2492118 2492118 2022-05-10 Montgomery Pennsylvania 42091 156254 2324
2492399 2492399 2022-05-10 Montgomery Tennessee 47125 50400 577
2492602 2492602 2022-05-10 Montgomery Texas 48339 141362 1291
2492817 2492817 2022-05-10 Montgomery Virginia 51121 19256 154
2486594 2486594 2022-05-09 Montgomery Alabama 1101 55203 948
2486703 2486703 2022-05-09 Montgomery Arkansas 5097 1525 57
2487037 2487037 2022-05-09 Montgomery Georgia 13209 2079 53
2487213 2487213 2022-05-09 Montgomery Illinois 17135 9858 111
2487302 2487302 2022-05-09 Montgomery Indiana 18107 10726 164
2487410 2487410 2022-05-09 Montgomery Iowa 19137 2212 55
2487504 2487504 2022-05-09 Montgomery Kansas 20125 9435 154
2487634 2487634 2022-05-09 Montgomery Kentucky 21173 8200 108
2487765 2487765 2022-05-09 Montgomery Maryland 24031 175397 2041
2488010 2488010 2022-05-09 Montgomery Mississippi 28097 2963 77
2488115 2488115 2022-05-09 Montgomery Missouri 29139 2516 57
2488422 2488422 2022-05-09 Montgomery New York 36057 12401 204
2488515 2488515 2022-05-09 Montgomery North Carolina 37123 7294 129
2488668 2488668 2022-05-09 Montgomery Ohio 39113 127624 2018
2488860 2488860 2022-05-09 Montgomery Pennsylvania 42091 156254 2324
2489141 2489141 2022-05-09 Montgomery Tennessee 47125 50400 577
2489344 2489344 2022-05-09 Montgomery Texas 48339 141269 1291
2489559 2489559 2022-05-09 Montgomery Virginia 51121 19220 153
2483336 2483336 2022-05-08 Montgomery Alabama 1101 55168 948
2483445 2483445 2022-05-08 Montgomery Arkansas 5097 1525 57
2483779 2483779 2022-05-08 Montgomery Georgia 13209 2079 53
2483955 2483955 2022-05-08 Montgomery Illinois 17135 9851 111
2484044 2484044 2022-05-08 Montgomery Indiana 18107 10706 164
2484152 2484152 2022-05-08 Montgomery Iowa 19137 2212 55
2484246 2484246 2022-05-08 Montgomery Kansas 20125 9435 154
2484376 2484376 2022-05-08 Montgomery Kentucky 21173 8031 106
2484507 2484507 2022-05-08 Montgomery Maryland 24031 174899 2041
2484752 2484752 2022-05-08 Montgomery Mississippi 28097 2960 77

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);