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

9,607 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 · 9,607 ✖
Link rowid date ▲ county state fips cases deaths
1816663 1816663 2021-10-15 Monroe Alabama 1099 3299 62
1816772 1816772 2021-10-15 Monroe Arkansas 5095 1186 24
1816980 1816980 2021-10-15 Monroe Florida 12087 10381 85
1817106 1817106 2021-10-15 Monroe Georgia 13207 4111 141
1817282 1817282 2021-10-15 Monroe Illinois 17133 5236 100
1817371 1817371 2021-10-15 Monroe Indiana 18105 15121 200
1817478 1817478 2021-10-15 Monroe Iowa 19135 1317 34
1817701 1817701 2021-10-15 Monroe Kentucky 21171 2240 59
1817915 1817915 2021-10-15 Monroe Michigan 26115 19666 295
1818077 1818077 2021-10-15 Monroe Mississippi 28095 6727 174
1818182 1818182 2021-10-15 Monroe Missouri 29137 1295 12
1818487 1818487 2021-10-15 Monroe New York 36055 83034 1179
1818731 1818731 2021-10-15 Monroe Ohio 39111 2105 53
1818923 1818923 2021-10-15 Monroe Pennsylvania 42089 19039 353
1819204 1819204 2021-10-15 Monroe Tennessee 47123 9587 121
1819744 1819744 2021-10-15 Monroe West Virginia 54063 2028 25
1819809 1819809 2021-10-15 Monroe Wisconsin 55081 6191 54
1813415 1813415 2021-10-14 Monroe Alabama 1099 3290 62
1813524 1813524 2021-10-14 Monroe Arkansas 5095 1186 24
1813732 1813732 2021-10-14 Monroe Florida 12087 10337 82
1813858 1813858 2021-10-14 Monroe Georgia 13207 4103 141
1814034 1814034 2021-10-14 Monroe Illinois 17133 5229 100
1814123 1814123 2021-10-14 Monroe Indiana 18105 15093 200
1814230 1814230 2021-10-14 Monroe Iowa 19135 1317 34
1814453 1814453 2021-10-14 Monroe Kentucky 21171 2231 59
1814666 1814666 2021-10-14 Monroe Michigan 26115 19394 294
1814828 1814828 2021-10-14 Monroe Mississippi 28095 6713 173
1814933 1814933 2021-10-14 Monroe Missouri 29137 1291 12
1815238 1815238 2021-10-14 Monroe New York 36055 82768 1178
1815482 1815482 2021-10-14 Monroe Ohio 39111 2097 51
1815674 1815674 2021-10-14 Monroe Pennsylvania 42089 18997 353
1815955 1815955 2021-10-14 Monroe Tennessee 47123 9570 118
1816495 1816495 2021-10-14 Monroe West Virginia 54063 2023 25
1816560 1816560 2021-10-14 Monroe Wisconsin 55081 6191 54
1810166 1810166 2021-10-13 Monroe Alabama 1099 3279 61
1810275 1810275 2021-10-13 Monroe Arkansas 5095 1185 24
1810483 1810483 2021-10-13 Monroe Florida 12087 10337 82
1810609 1810609 2021-10-13 Monroe Georgia 13207 4101 140
1810785 1810785 2021-10-13 Monroe Illinois 17133 5226 100
1810874 1810874 2021-10-13 Monroe Indiana 18105 15068 199
1810981 1810981 2021-10-13 Monroe Iowa 19135 1317 34
1811204 1811204 2021-10-13 Monroe Kentucky 21171 2222 59
1811418 1811418 2021-10-13 Monroe Michigan 26115 19394 294
1811580 1811580 2021-10-13 Monroe Mississippi 28095 6702 173
1811685 1811685 2021-10-13 Monroe Missouri 29137 1288 12
1811990 1811990 2021-10-13 Monroe New York 36055 82481 1178
1812234 1812234 2021-10-13 Monroe Ohio 39111 2089 51
1812426 1812426 2021-10-13 Monroe Pennsylvania 42089 18920 353
1812707 1812707 2021-10-13 Monroe Tennessee 47123 9559 118
1813247 1813247 2021-10-13 Monroe West Virginia 54063 2011 25
1813312 1813312 2021-10-13 Monroe Wisconsin 55081 6161 54
1806917 1806917 2021-10-12 Monroe Alabama 1099 3276 60
1807026 1807026 2021-10-12 Monroe Arkansas 5095 1183 24
1807234 1807234 2021-10-12 Monroe Florida 12087 10337 82
1807360 1807360 2021-10-12 Monroe Georgia 13207 4097 140
1807536 1807536 2021-10-12 Monroe Illinois 17133 5220 100
1807625 1807625 2021-10-12 Monroe Indiana 18105 15039 199
1807732 1807732 2021-10-12 Monroe Iowa 19135 1288 34
1807955 1807955 2021-10-12 Monroe Kentucky 21171 2213 57
1808169 1808169 2021-10-12 Monroe Michigan 26115 19117 294
1808331 1808331 2021-10-12 Monroe Mississippi 28095 6690 173
1808436 1808436 2021-10-12 Monroe Missouri 29137 1285 12
1808741 1808741 2021-10-12 Monroe New York 36055 82259 1177
1808985 1808985 2021-10-12 Monroe Ohio 39111 2075 51
1809177 1809177 2021-10-12 Monroe Pennsylvania 42089 18891 352
1809458 1809458 2021-10-12 Monroe Tennessee 47123 9540 117
1809998 1809998 2021-10-12 Monroe West Virginia 54063 2005 25
1810063 1810063 2021-10-12 Monroe Wisconsin 55081 6128 54
1803666 1803666 2021-10-11 Monroe Alabama 1099 3271 60
1803775 1803775 2021-10-11 Monroe Arkansas 5095 1179 24
1803983 1803983 2021-10-11 Monroe Florida 12087 10337 82
1804109 1804109 2021-10-11 Monroe Georgia 13207 4077 140
1804285 1804285 2021-10-11 Monroe Illinois 17133 5197 100
1804374 1804374 2021-10-11 Monroe Indiana 18105 15019 199
1804481 1804481 2021-10-11 Monroe Iowa 19135 1288 34
1804704 1804704 2021-10-11 Monroe Kentucky 21171 2207 57
1804918 1804918 2021-10-11 Monroe Michigan 26115 19117 294
1805080 1805080 2021-10-11 Monroe Mississippi 28095 6674 173
1805185 1805185 2021-10-11 Monroe Missouri 29137 1284 12
1805490 1805490 2021-10-11 Monroe New York 36055 82092 1175
1805735 1805735 2021-10-11 Monroe Ohio 39111 2061 50
1805927 1805927 2021-10-11 Monroe Pennsylvania 42089 18818 352
1806208 1806208 2021-10-11 Monroe Tennessee 47123 9516 117
1806749 1806749 2021-10-11 Monroe West Virginia 54063 1999 25
1806814 1806814 2021-10-11 Monroe Wisconsin 55081 6121 54
1800417 1800417 2021-10-10 Monroe Alabama 1099 3268 60
1800526 1800526 2021-10-10 Monroe Arkansas 5095 1178 24
1800734 1800734 2021-10-10 Monroe Florida 12087 10337 82
1800860 1800860 2021-10-10 Monroe Georgia 13207 4077 140
1801036 1801036 2021-10-10 Monroe Illinois 17133 5197 100
1801125 1801125 2021-10-10 Monroe Indiana 18105 14959 199
1801232 1801232 2021-10-10 Monroe Iowa 19135 1288 34
1801455 1801455 2021-10-10 Monroe Kentucky 21171 2198 57
1801669 1801669 2021-10-10 Monroe Michigan 26115 18938 294
1801831 1801831 2021-10-10 Monroe Mississippi 28095 6661 173
1801936 1801936 2021-10-10 Monroe Missouri 29137 1284 12
1802241 1802241 2021-10-10 Monroe New York 36055 81835 1173
1802485 1802485 2021-10-10 Monroe Ohio 39111 2056 50
1802677 1802677 2021-10-10 Monroe Pennsylvania 42089 18790 352
1802958 1802958 2021-10-10 Monroe Tennessee 47123 9453 117

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