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

5,833 rows where county = "Monroe" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Monroe · 5,833 ✖
Link rowid date ▲ county state fips cases deaths
1095748 1095748 2021-03-07 Monroe Alabama 1099 1667 39
1095856 1095856 2021-03-07 Monroe Arkansas 5095 837 16
1096064 1096064 2021-03-07 Monroe Florida 12087 5986 46
1096190 1096190 2021-03-07 Monroe Georgia 13207 2428 93
1096365 1096365 2021-03-07 Monroe Illinois 17133 4092 87
1096454 1096454 2021-03-07 Monroe Indiana 18105 10443 166
1096561 1096561 2021-03-07 Monroe Iowa 19135 873 28
1096785 1096785 2021-03-07 Monroe Kentucky 21171 1248 38
1096999 1096999 2021-03-07 Monroe Michigan 26115 10008 204
1097161 1097161 2021-03-07 Monroe Mississippi 28095 3998 129
1097266 1097266 2021-03-07 Monroe Missouri 29137 599 10
1097571 1097571 2021-03-07 Monroe New York 36055 53392 998
1097815 1097815 2021-03-07 Monroe Ohio 39111 1176 37
1098007 1098007 2021-03-07 Monroe Pennsylvania 42089 9955 272
1098288 1098288 2021-03-07 Monroe Tennessee 47123 5406 91
1098828 1098828 2021-03-07 Monroe West Virginia 54063 967 14
1098893 1098893 2021-03-07 Monroe Wisconsin 55081 4432 34
1092502 1092502 2021-03-06 Monroe Alabama 1099 1667 39
1092610 1092610 2021-03-06 Monroe Arkansas 5095 836 16
1092818 1092818 2021-03-06 Monroe Florida 12087 5975 46
1092944 1092944 2021-03-06 Monroe Georgia 13207 2427 93
1093119 1093119 2021-03-06 Monroe Illinois 17133 4090 87
1093208 1093208 2021-03-06 Monroe Indiana 18105 10422 166
1093315 1093315 2021-03-06 Monroe Iowa 19135 873 28
1093539 1093539 2021-03-06 Monroe Kentucky 21171 1248 38
1093752 1093752 2021-03-06 Monroe Michigan 26115 10008 204
1093914 1093914 2021-03-06 Monroe Mississippi 28095 3996 129
1094019 1094019 2021-03-06 Monroe Missouri 29137 598 10
1094323 1094323 2021-03-06 Monroe New York 36055 53275 997
1094567 1094567 2021-03-06 Monroe Ohio 39111 1172 37
1094759 1094759 2021-03-06 Monroe Pennsylvania 42089 9932 272
1095040 1095040 2021-03-06 Monroe Tennessee 47123 5395 91
1095580 1095580 2021-03-06 Monroe West Virginia 54063 959 14
1095645 1095645 2021-03-06 Monroe Wisconsin 55081 4430 34
1089256 1089256 2021-03-05 Monroe Alabama 1099 1667 39
1089364 1089364 2021-03-05 Monroe Arkansas 5095 829 16
1089572 1089572 2021-03-05 Monroe Florida 12087 5958 46
1089698 1089698 2021-03-05 Monroe Georgia 13207 2421 93
1089873 1089873 2021-03-05 Monroe Illinois 17133 4084 86
1089962 1089962 2021-03-05 Monroe Indiana 18105 10397 166
1090069 1090069 2021-03-05 Monroe Iowa 19135 873 28
1090293 1090293 2021-03-05 Monroe Kentucky 21171 1248 38
1090506 1090506 2021-03-05 Monroe Michigan 26115 9969 204
1090668 1090668 2021-03-05 Monroe Mississippi 28095 3994 128
1090773 1090773 2021-03-05 Monroe Missouri 29137 598 10
1091077 1091077 2021-03-05 Monroe New York 36055 53168 994
1091321 1091321 2021-03-05 Monroe Ohio 39111 1171 37
1091513 1091513 2021-03-05 Monroe Pennsylvania 42089 9885 272
1091794 1091794 2021-03-05 Monroe Tennessee 47123 5369 90
1092334 1092334 2021-03-05 Monroe West Virginia 54063 956 14
1092399 1092399 2021-03-05 Monroe Wisconsin 55081 4428 34
1086011 1086011 2021-03-04 Monroe Alabama 1099 1667 39
1086119 1086119 2021-03-04 Monroe Arkansas 5095 828 16
1086327 1086327 2021-03-04 Monroe Florida 12087 5937 46
1086453 1086453 2021-03-04 Monroe Georgia 13207 2417 91
1086628 1086628 2021-03-04 Monroe Illinois 17133 4078 84
1086717 1086717 2021-03-04 Monroe Indiana 18105 10382 165
1086824 1086824 2021-03-04 Monroe Iowa 19135 873 28
1087048 1087048 2021-03-04 Monroe Kentucky 21171 1248 38
1087261 1087261 2021-03-04 Monroe Michigan 26115 9928 204
1087423 1087423 2021-03-04 Monroe Mississippi 28095 3993 128
1087528 1087528 2021-03-04 Monroe Missouri 29137 597 10
1087832 1087832 2021-03-04 Monroe New York 36055 52991 993
1088076 1088076 2021-03-04 Monroe Ohio 39111 1169 27
1088267 1088267 2021-03-04 Monroe Pennsylvania 42089 9835 272
1088548 1088548 2021-03-04 Monroe Tennessee 47123 5365 90
1089088 1089088 2021-03-04 Monroe West Virginia 54063 955 12
1089153 1089153 2021-03-04 Monroe Wisconsin 55081 4427 32
1082765 1082765 2021-03-03 Monroe Alabama 1099 1666 39
1082873 1082873 2021-03-03 Monroe Arkansas 5095 828 15
1083081 1083081 2021-03-03 Monroe Florida 12087 5911 46
1083207 1083207 2021-03-03 Monroe Georgia 13207 2415 90
1083382 1083382 2021-03-03 Monroe Illinois 17133 4071 83
1083471 1083471 2021-03-03 Monroe Indiana 18105 10366 165
1083578 1083578 2021-03-03 Monroe Iowa 19135 873 28
1083802 1083802 2021-03-03 Monroe Kentucky 21171 1248 38
1084016 1084016 2021-03-03 Monroe Michigan 26115 9901 203
1084178 1084178 2021-03-03 Monroe Mississippi 28095 3990 127
1084283 1084283 2021-03-03 Monroe Missouri 29137 597 10
1084587 1084587 2021-03-03 Monroe New York 36055 52879 992
1084831 1084831 2021-03-03 Monroe Ohio 39111 1170 27
1085022 1085022 2021-03-03 Monroe Pennsylvania 42089 9783 269
1085303 1085303 2021-03-03 Monroe Tennessee 47123 5346 90
1085843 1085843 2021-03-03 Monroe West Virginia 54063 951 12
1085908 1085908 2021-03-03 Monroe Wisconsin 55081 4418 32
1079519 1079519 2021-03-02 Monroe Alabama 1099 1663 39
1079627 1079627 2021-03-02 Monroe Arkansas 5095 828 15
1079835 1079835 2021-03-02 Monroe Florida 12087 5892 46
1079961 1079961 2021-03-02 Monroe Georgia 13207 2408 89
1080136 1080136 2021-03-02 Monroe Illinois 17133 4071 83
1080225 1080225 2021-03-02 Monroe Indiana 18105 10346 165
1080332 1080332 2021-03-02 Monroe Iowa 19135 873 28
1080556 1080556 2021-03-02 Monroe Kentucky 21171 1248 38
1080770 1080770 2021-03-02 Monroe Michigan 26115 9854 203
1080932 1080932 2021-03-02 Monroe Mississippi 28095 3990 126
1081037 1081037 2021-03-02 Monroe Missouri 29137 597 10
1081341 1081341 2021-03-02 Monroe New York 36055 52760 992
1081585 1081585 2021-03-02 Monroe Ohio 39111 1163 27
1081776 1081776 2021-03-02 Monroe Pennsylvania 42089 9732 266
1082057 1082057 2021-03-02 Monroe Tennessee 47123 5331 90

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