ny_times_us_counties

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

1,838 rows where county = "Monroe" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Monroe · 1,838
Link rowid date ▲ county state fips cases deaths
334425 2020-07-15 Monroe Alabama 1099 292 4
334532 2020-07-15 Monroe Arkansas 5095 26 0
334737 2020-07-15 Monroe Florida 12087 670 6
334863 2020-07-15 Monroe Georgia 13207 261 20
335034 2020-07-15 Monroe Illinois 17133 171 13
335123 2020-07-15 Monroe Indiana 18105 387 30
335230 2020-07-15 Monroe Iowa 19135 54 7
335450 2020-07-15 Monroe Kentucky 21171 53 2
335664 2020-07-15 Monroe Michigan 26115 693 23
335825 2020-07-15 Monroe Mississippi 28095 491 39
335930 2020-07-15 Monroe Missouri 29137 7 0
336209 2020-07-15 Monroe New York 36055 4282 264
336452 2020-07-15 Monroe Ohio 39111 89 17
336640 2020-07-15 Monroe Pennsylvania 42089 1482 113
336919 2020-07-15 Monroe Tennessee 47123 162 6
337449 2020-07-15 Monroe West Virginia 54063 15 0
337514 2020-07-15 Monroe Wisconsin 55081 145 1
331234 2020-07-14 Monroe Alabama 1099 286 4
331341 2020-07-14 Monroe Arkansas 5095 27 0
331546 2020-07-14 Monroe Florida 12087 641 6
331672 2020-07-14 Monroe Georgia 13207 240 20
331843 2020-07-14 Monroe Illinois 17133 170 13
331932 2020-07-14 Monroe Indiana 18105 377 30
332039 2020-07-14 Monroe Iowa 19135 54 7
332259 2020-07-14 Monroe Kentucky 21171 53 2
332473 2020-07-14 Monroe Michigan 26115 673 23
332634 2020-07-14 Monroe Mississippi 28095 472 39
332739 2020-07-14 Monroe Missouri 29137 6 0
333017 2020-07-14 Monroe New York 36055 4248 264
333260 2020-07-14 Monroe Ohio 39111 89 17
333448 2020-07-14 Monroe Pennsylvania 42089 1474 111
333727 2020-07-14 Monroe Tennessee 47123 156 6
334256 2020-07-14 Monroe West Virginia 54063 15 0
334321 2020-07-14 Monroe Wisconsin 55081 139 1
328050 2020-07-13 Monroe Alabama 1099 275 4
328157 2020-07-13 Monroe Arkansas 5095 22 0
328361 2020-07-13 Monroe Florida 12087 611 6
328487 2020-07-13 Monroe Georgia 13207 232 19
328658 2020-07-13 Monroe Illinois 17133 165 13
328747 2020-07-13 Monroe Indiana 18105 363 30
328854 2020-07-13 Monroe Iowa 19135 52 7
329074 2020-07-13 Monroe Kentucky 21171 50 2
329288 2020-07-13 Monroe Michigan 26115 671 21
329449 2020-07-13 Monroe Mississippi 28095 460 36
329554 2020-07-13 Monroe Missouri 29137 5 0
329829 2020-07-13 Monroe New York 36055 4201 264
330070 2020-07-13 Monroe Ohio 39111 89 17
330258 2020-07-13 Monroe Pennsylvania 42089 1473 111
330537 2020-07-13 Monroe Tennessee 47123 156 6
331065 2020-07-13 Monroe West Virginia 54063 15 0
331130 2020-07-13 Monroe Wisconsin 55081 137 1
324866 2020-07-12 Monroe Alabama 1099 264 4
324973 2020-07-12 Monroe Arkansas 5095 21 0
325177 2020-07-12 Monroe Florida 12087 572 6
325303 2020-07-12 Monroe Georgia 13207 225 19
325474 2020-07-12 Monroe Illinois 17133 159 13
325563 2020-07-12 Monroe Indiana 18105 350 30
325670 2020-07-12 Monroe Iowa 19135 52 7
325890 2020-07-12 Monroe Kentucky 21171 50 2
326104 2020-07-12 Monroe Michigan 26115 661 21
326265 2020-07-12 Monroe Mississippi 28095 461 35
326370 2020-07-12 Monroe Missouri 29137 5 0
326644 2020-07-12 Monroe New York 36055 4178 264
326885 2020-07-12 Monroe Ohio 39111 89 17
327074 2020-07-12 Monroe Pennsylvania 42089 1471 111
327353 2020-07-12 Monroe Tennessee 47123 155 6
327881 2020-07-12 Monroe West Virginia 54063 15 0
327946 2020-07-12 Monroe Wisconsin 55081 134 1
321687 2020-07-11 Monroe Alabama 1099 258 4
321794 2020-07-11 Monroe Arkansas 5095 20 0
321998 2020-07-11 Monroe Florida 12087 544 6
322124 2020-07-11 Monroe Georgia 13207 229 19
322295 2020-07-11 Monroe Illinois 17133 155 13
322384 2020-07-11 Monroe Indiana 18105 342 30
322491 2020-07-11 Monroe Iowa 19135 52 7
322709 2020-07-11 Monroe Kentucky 21171 48 2
322923 2020-07-11 Monroe Michigan 26115 659 21
323084 2020-07-11 Monroe Mississippi 28095 456 35
323189 2020-07-11 Monroe Missouri 29137 5 0
323462 2020-07-11 Monroe New York 36055 4154 263
323702 2020-07-11 Monroe Ohio 39111 89 17
323891 2020-07-11 Monroe Pennsylvania 42089 1470 111
324170 2020-07-11 Monroe Tennessee 47123 155 6
324697 2020-07-11 Monroe West Virginia 54063 15 0
324762 2020-07-11 Monroe Wisconsin 55081 130 1
318510 2020-07-10 Monroe Alabama 1099 257 4
318617 2020-07-10 Monroe Arkansas 5095 19 0
318821 2020-07-10 Monroe Florida 12087 470 6
318947 2020-07-10 Monroe Georgia 13207 229 19
319118 2020-07-10 Monroe Illinois 17133 150 13
319207 2020-07-10 Monroe Indiana 18105 331 30
319314 2020-07-10 Monroe Iowa 19135 51 7
319532 2020-07-10 Monroe Kentucky 21171 44 2
319746 2020-07-10 Monroe Michigan 26115 655 21
319907 2020-07-10 Monroe Mississippi 28095 439 35
320012 2020-07-10 Monroe Missouri 29137 5 0
320284 2020-07-10 Monroe New York 36055 4121 263
320524 2020-07-10 Monroe Ohio 39111 89 17
320713 2020-07-10 Monroe Pennsylvania 42089 1462 111
320991 2020-07-10 Monroe Tennessee 47123 152 6

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
);
Powered by Datasette · Query took 1061.163ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette