⚠️ 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

6,305 rows where county = "Montgomery" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Montgomery · 6,305
Link rowid date ▲ county state fips cases deaths
1095749 2021-03-07 Montgomery Alabama 1101 22805 523
1095857 2021-03-07 Montgomery Arkansas 5097 739 30
1096191 2021-03-07 Montgomery Georgia 13209 869 21
1096366 2021-03-07 Montgomery Illinois 17135 3543 76
1096455 2021-03-07 Montgomery Indiana 18107 3921 85
1096562 2021-03-07 Montgomery Iowa 19137 958 36
1096656 2021-03-07 Montgomery Kansas 20125 3310 6
1096786 2021-03-07 Montgomery Kentucky 21173 2328 24
1096917 2021-03-07 Montgomery Maryland 24031 64032 1426
1097162 2021-03-07 Montgomery Mississippi 28097 1235 40
1097267 2021-03-07 Montgomery Missouri 29139 570 10
1097572 2021-03-07 Montgomery New York 36057 3259 107
1097665 2021-03-07 Montgomery North Carolina 37123 3100 88
1097816 2021-03-07 Montgomery Ohio 39113 47536 923
1098008 2021-03-07 Montgomery Pennsylvania 42091 55218 1569
1098289 2021-03-07 Montgomery Tennessee 47125 17563 213
1098492 2021-03-07 Montgomery Texas 48339 46244 471
1098706 2021-03-07 Montgomery Virginia 51121 8075 86
1092503 2021-03-06 Montgomery Alabama 1101 22789 523
1092611 2021-03-06 Montgomery Arkansas 5097 738 30
1092945 2021-03-06 Montgomery Georgia 13209 869 21
1093120 2021-03-06 Montgomery Illinois 17135 3542 76
1093209 2021-03-06 Montgomery Indiana 18107 3918 85
1093316 2021-03-06 Montgomery Iowa 19137 958 36
1093410 2021-03-06 Montgomery Kansas 20125 3310 6
1093540 2021-03-06 Montgomery Kentucky 21173 2325 24
1093670 2021-03-06 Montgomery Maryland 24031 63943 1426
1093915 2021-03-06 Montgomery Mississippi 28097 1235 40
1094020 2021-03-06 Montgomery Missouri 29139 570 10
1094324 2021-03-06 Montgomery New York 36057 3244 107
1094417 2021-03-06 Montgomery North Carolina 37123 3100 88
1094568 2021-03-06 Montgomery Ohio 39113 47506 923
1094760 2021-03-06 Montgomery Pennsylvania 42091 54952 1567
1095041 2021-03-06 Montgomery Tennessee 47125 17539 213
1095244 2021-03-06 Montgomery Texas 48339 46244 471
1095458 2021-03-06 Montgomery Virginia 51121 8046 86
1089257 2021-03-05 Montgomery Alabama 1101 22765 520
1089365 2021-03-05 Montgomery Arkansas 5097 738 30
1089699 2021-03-05 Montgomery Georgia 13209 868 21
1089874 2021-03-05 Montgomery Illinois 17135 3536 76
1089963 2021-03-05 Montgomery Indiana 18107 3907 85
1090070 2021-03-05 Montgomery Iowa 19137 958 36
1090164 2021-03-05 Montgomery Kansas 20125 3310 6
1090294 2021-03-05 Montgomery Kentucky 21173 2320 24
1090424 2021-03-05 Montgomery Maryland 24031 63841 1424
1090669 2021-03-05 Montgomery Mississippi 28097 1231 40
1090774 2021-03-05 Montgomery Missouri 29139 568 10
1091078 2021-03-05 Montgomery New York 36057 3232 107
1091171 2021-03-05 Montgomery North Carolina 37123 3092 88
1091322 2021-03-05 Montgomery Ohio 39113 47453 923
1091514 2021-03-05 Montgomery Pennsylvania 42091 54736 1565
1091795 2021-03-05 Montgomery Tennessee 47125 17505 213
1091998 2021-03-05 Montgomery Texas 48339 46058 469
1092212 2021-03-05 Montgomery Virginia 51121 8003 86
1086012 2021-03-04 Montgomery Alabama 1101 22739 519
1086120 2021-03-04 Montgomery Arkansas 5097 734 30
1086454 2021-03-04 Montgomery Georgia 13209 869 21
1086629 2021-03-04 Montgomery Illinois 17135 3524 75
1086718 2021-03-04 Montgomery Indiana 18107 3898 84
1086825 2021-03-04 Montgomery Iowa 19137 958 36
1086919 2021-03-04 Montgomery Kansas 20125 3302 6
1087049 2021-03-04 Montgomery Kentucky 21173 2317 24
1087179 2021-03-04 Montgomery Maryland 24031 63747 1421
1087424 2021-03-04 Montgomery Mississippi 28097 1229 39
1087529 2021-03-04 Montgomery Missouri 29139 568 10
1087833 2021-03-04 Montgomery New York 36057 3219 107
1087926 2021-03-04 Montgomery North Carolina 37123 3085 88
1088077 2021-03-04 Montgomery Ohio 39113 47424 903
1088268 2021-03-04 Montgomery Pennsylvania 42091 54580 1562
1088549 2021-03-04 Montgomery Tennessee 47125 17484 213
1088752 2021-03-04 Montgomery Texas 48339 46058 464
1088966 2021-03-04 Montgomery Virginia 51121 7916 86
1082766 2021-03-03 Montgomery Alabama 1101 22708 519
1082874 2021-03-03 Montgomery Arkansas 5097 731 30
1083208 2021-03-03 Montgomery Georgia 13209 867 21
1083383 2021-03-03 Montgomery Illinois 17135 3519 75
1083472 2021-03-03 Montgomery Indiana 18107 3886 84
1083579 2021-03-03 Montgomery Iowa 19137 958 36
1083673 2021-03-03 Montgomery Kansas 20125 3302 6
1083803 2021-03-03 Montgomery Kentucky 21173 2311 24
1083934 2021-03-03 Montgomery Maryland 24031 63640 1420
1084179 2021-03-03 Montgomery Mississippi 28097 1226 39
1084284 2021-03-03 Montgomery Missouri 29139 568 10
1084588 2021-03-03 Montgomery New York 36057 3206 107
1084681 2021-03-03 Montgomery North Carolina 37123 3082 87
1084832 2021-03-03 Montgomery Ohio 39113 47359 903
1085023 2021-03-03 Montgomery Pennsylvania 42091 54364 1559
1085304 2021-03-03 Montgomery Tennessee 47125 17440 213
1085507 2021-03-03 Montgomery Texas 48339 45872 459
1085721 2021-03-03 Montgomery Virginia 51121 7806 86
1079520 2021-03-02 Montgomery Alabama 1101 22636 517
1079628 2021-03-02 Montgomery Arkansas 5097 730 29
1079962 2021-03-02 Montgomery Georgia 13209 864 21
1080137 2021-03-02 Montgomery Illinois 17135 3511 74
1080226 2021-03-02 Montgomery Indiana 18107 3874 84
1080333 2021-03-02 Montgomery Iowa 19137 958 36
1080427 2021-03-02 Montgomery Kansas 20125 3285 6
1080557 2021-03-02 Montgomery Kentucky 21173 2307 24
1080688 2021-03-02 Montgomery Maryland 24031 63544 1418
1080933 2021-03-02 Montgomery Mississippi 28097 1226 39

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