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

13,177 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 17

fips 17

county 1

  • Monroe · 13,177 ✖
Link rowid date ▲ county state fips cases deaths
2499624 2499624 2022-05-13 Monroe Alabama 1099 5276 80
2499733 2499733 2022-05-13 Monroe Arkansas 5095 1936 35
2499941 2499941 2022-05-13 Monroe Florida 12087 18412 119
2500067 2500067 2022-05-13 Monroe Georgia 13207 5927 174
2500243 2500243 2022-05-13 Monroe Illinois 17133 9633 128
2500332 2500332 2022-05-13 Monroe Indiana 18105 28850 281
2500440 2500440 2022-05-13 Monroe Iowa 19135 1882 49
2500664 2500664 2022-05-13 Monroe Kentucky 21171 3624 77
2500878 2500878 2022-05-13 Monroe Michigan 26115 39169 475
2501040 2501040 2022-05-13 Monroe Mississippi 28095 10997 220
2501146 2501146 2022-05-13 Monroe Missouri 29137 2180 43
2501453 2501453 2022-05-13 Monroe New York 36055 163464 1587
2501699 2501699 2022-05-13 Monroe Ohio 39111 3499 82
2501891 2501891 2022-05-13 Monroe Pennsylvania 42089 37881 524
2502172 2502172 2022-05-13 Monroe Tennessee 47123 14681 244
2502714 2502714 2022-05-13 Monroe West Virginia 54063 4260 46
2502779 2502779 2022-05-13 Monroe Wisconsin 55081 12305 91
2496366 2496366 2022-05-12 Monroe Alabama 1099 5276 80
2496475 2496475 2022-05-12 Monroe Arkansas 5095 1936 35
2496683 2496683 2022-05-12 Monroe Florida 12087 18412 119
2496809 2496809 2022-05-12 Monroe Georgia 13207 5927 174
2496985 2496985 2022-05-12 Monroe Illinois 17133 9621 128
2497074 2497074 2022-05-12 Monroe Indiana 18105 28724 280
2497182 2497182 2022-05-12 Monroe Iowa 19135 1882 49
2497406 2497406 2022-05-12 Monroe Kentucky 21171 3624 77
2497620 2497620 2022-05-12 Monroe Michigan 26115 39169 475
2497782 2497782 2022-05-12 Monroe Mississippi 28095 10997 220
2497888 2497888 2022-05-12 Monroe Missouri 29137 2179 43
2498195 2498195 2022-05-12 Monroe New York 36055 163464 1586
2498441 2498441 2022-05-12 Monroe Ohio 39111 3499 82
2498633 2498633 2022-05-12 Monroe Pennsylvania 42089 37881 524
2498914 2498914 2022-05-12 Monroe Tennessee 47123 14681 244
2499456 2499456 2022-05-12 Monroe West Virginia 54063 4247 46
2499521 2499521 2022-05-12 Monroe Wisconsin 55081 12289 91
2493108 2493108 2022-05-11 Monroe Alabama 1099 5276 80
2493217 2493217 2022-05-11 Monroe Arkansas 5095 1936 35
2493425 2493425 2022-05-11 Monroe Florida 12087 18412 119
2493551 2493551 2022-05-11 Monroe Georgia 13207 5927 174
2493727 2493727 2022-05-11 Monroe Illinois 17133 9612 128
2493816 2493816 2022-05-11 Monroe Indiana 18105 28724 280
2493924 2493924 2022-05-11 Monroe Iowa 19135 1882 49
2494148 2494148 2022-05-11 Monroe Kentucky 21171 3624 77
2494362 2494362 2022-05-11 Monroe Michigan 26115 39169 475
2494524 2494524 2022-05-11 Monroe Mississippi 28095 10997 220
2494630 2494630 2022-05-11 Monroe Missouri 29137 2179 43
2494937 2494937 2022-05-11 Monroe New York 36055 163022 1583
2495183 2495183 2022-05-11 Monroe Ohio 39111 3488 82
2495375 2495375 2022-05-11 Monroe Pennsylvania 42089 37881 524
2495656 2495656 2022-05-11 Monroe Tennessee 47123 14681 244
2496198 2496198 2022-05-11 Monroe West Virginia 54063 4236 46
2496263 2496263 2022-05-11 Monroe Wisconsin 55081 12271 91
2489850 2489850 2022-05-10 Monroe Alabama 1099 5276 80
2489959 2489959 2022-05-10 Monroe Arkansas 5095 1935 35
2490167 2490167 2022-05-10 Monroe Florida 12087 18412 119
2490293 2490293 2022-05-10 Monroe Georgia 13207 5907 172
2490469 2490469 2022-05-10 Monroe Illinois 17133 9607 128
2490558 2490558 2022-05-10 Monroe Indiana 18105 28636 280
2490666 2490666 2022-05-10 Monroe Iowa 19135 1882 49
2490890 2490890 2022-05-10 Monroe Kentucky 21171 3624 77
2491104 2491104 2022-05-10 Monroe Michigan 26115 38646 475
2491266 2491266 2022-05-10 Monroe Mississippi 28095 10997 220
2491372 2491372 2022-05-10 Monroe Missouri 29137 2179 43
2491679 2491679 2022-05-10 Monroe New York 36055 162669 1582
2491925 2491925 2022-05-10 Monroe Ohio 39111 3488 82
2492117 2492117 2022-05-10 Monroe Pennsylvania 42089 37581 524
2492398 2492398 2022-05-10 Monroe Tennessee 47123 14676 244
2492940 2492940 2022-05-10 Monroe West Virginia 54063 4222 46
2493005 2493005 2022-05-10 Monroe Wisconsin 55081 12244 91
2486593 2486593 2022-05-09 Monroe Alabama 1099 5276 80
2486702 2486702 2022-05-09 Monroe Arkansas 5095 1933 35
2486910 2486910 2022-05-09 Monroe Florida 12087 18412 119
2487036 2487036 2022-05-09 Monroe Georgia 13207 5907 172
2487212 2487212 2022-05-09 Monroe Illinois 17133 9599 128
2487301 2487301 2022-05-09 Monroe Indiana 18105 28636 280
2487409 2487409 2022-05-09 Monroe Iowa 19135 1882 49
2487633 2487633 2022-05-09 Monroe Kentucky 21171 3624 77
2487847 2487847 2022-05-09 Monroe Michigan 26115 38646 475
2488009 2488009 2022-05-09 Monroe Mississippi 28095 10997 220
2488114 2488114 2022-05-09 Monroe Missouri 29137 2179 43
2488421 2488421 2022-05-09 Monroe New York 36055 162439 1581
2488667 2488667 2022-05-09 Monroe Ohio 39111 3488 82
2488859 2488859 2022-05-09 Monroe Pennsylvania 42089 37581 524
2489140 2489140 2022-05-09 Monroe Tennessee 47123 14676 244
2489682 2489682 2022-05-09 Monroe West Virginia 54063 4222 46
2489747 2489747 2022-05-09 Monroe Wisconsin 55081 12227 90
2483335 2483335 2022-05-08 Monroe Alabama 1099 5275 80
2483444 2483444 2022-05-08 Monroe Arkansas 5095 1933 35
2483652 2483652 2022-05-08 Monroe Florida 12087 18412 119
2483778 2483778 2022-05-08 Monroe Georgia 13207 5907 172
2483954 2483954 2022-05-08 Monroe Illinois 17133 9575 128
2484043 2484043 2022-05-08 Monroe Indiana 18105 28457 280
2484151 2484151 2022-05-08 Monroe Iowa 19135 1882 49
2484375 2484375 2022-05-08 Monroe Kentucky 21171 3622 77
2484589 2484589 2022-05-08 Monroe Michigan 26115 38646 475
2484751 2484751 2022-05-08 Monroe Mississippi 28095 10985 220
2484857 2484857 2022-05-08 Monroe Missouri 29137 2179 43
2485164 2485164 2022-05-08 Monroe New York 36055 162211 1578
2485410 2485410 2022-05-08 Monroe Ohio 39111 3488 82
2485602 2485602 2022-05-08 Monroe Pennsylvania 42089 37581 524
2485883 2485883 2022-05-08 Monroe Tennessee 47123 14676 244

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