ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Monroe" and fips = 39111 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388032 | 388032 | 2020-07-31 | Monroe | Ohio | 39111 | 89 | 18 |
384815 | 384815 | 2020-07-30 | Monroe | Ohio | 39111 | 89 | 17 |
381597 | 381597 | 2020-07-29 | Monroe | Ohio | 39111 | 89 | 17 |
378380 | 378380 | 2020-07-28 | Monroe | Ohio | 39111 | 89 | 17 |
375163 | 375163 | 2020-07-27 | Monroe | Ohio | 39111 | 89 | 17 |
371951 | 371951 | 2020-07-26 | Monroe | Ohio | 39111 | 89 | 17 |
368739 | 368739 | 2020-07-25 | Monroe | Ohio | 39111 | 89 | 17 |
365530 | 365530 | 2020-07-24 | Monroe | Ohio | 39111 | 89 | 17 |
362324 | 362324 | 2020-07-23 | Monroe | Ohio | 39111 | 89 | 17 |
359118 | 359118 | 2020-07-22 | Monroe | Ohio | 39111 | 89 | 17 |
355914 | 355914 | 2020-07-21 | Monroe | Ohio | 39111 | 89 | 17 |
352711 | 352711 | 2020-07-20 | Monroe | Ohio | 39111 | 89 | 17 |
349508 | 349508 | 2020-07-19 | Monroe | Ohio | 39111 | 89 | 17 |
346307 | 346307 | 2020-07-18 | Monroe | Ohio | 39111 | 89 | 17 |
343108 | 343108 | 2020-07-17 | Monroe | Ohio | 39111 | 89 | 17 |
339910 | 339910 | 2020-07-16 | Monroe | Ohio | 39111 | 89 | 17 |
336714 | 336714 | 2020-07-15 | Monroe | Ohio | 39111 | 89 | 17 |
333520 | 333520 | 2020-07-14 | Monroe | Ohio | 39111 | 89 | 17 |
330328 | 330328 | 2020-07-13 | Monroe | Ohio | 39111 | 89 | 17 |
327141 | 327141 | 2020-07-12 | Monroe | Ohio | 39111 | 89 | 17 |
323956 | 323956 | 2020-07-11 | Monroe | Ohio | 39111 | 89 | 17 |
320776 | 320776 | 2020-07-10 | Monroe | Ohio | 39111 | 89 | 17 |
317599 | 317599 | 2020-07-09 | Monroe | Ohio | 39111 | 89 | 17 |
314426 | 314426 | 2020-07-08 | Monroe | Ohio | 39111 | 89 | 17 |
311254 | 311254 | 2020-07-07 | Monroe | Ohio | 39111 | 89 | 17 |
308085 | 308085 | 2020-07-06 | Monroe | Ohio | 39111 | 89 | 17 |
304918 | 304918 | 2020-07-05 | Monroe | Ohio | 39111 | 89 | 17 |
301755 | 301755 | 2020-07-04 | Monroe | Ohio | 39111 | 88 | 17 |
298592 | 298592 | 2020-07-03 | Monroe | Ohio | 39111 | 88 | 17 |
295432 | 295432 | 2020-07-02 | Monroe | Ohio | 39111 | 86 | 17 |
292277 | 292277 | 2020-07-01 | Monroe | Ohio | 39111 | 86 | 17 |
289125 | 289125 | 2020-06-30 | Monroe | Ohio | 39111 | 85 | 17 |
285975 | 285975 | 2020-06-29 | Monroe | Ohio | 39111 | 85 | 17 |
282830 | 282830 | 2020-06-28 | Monroe | Ohio | 39111 | 85 | 17 |
279684 | 279684 | 2020-06-27 | Monroe | Ohio | 39111 | 85 | 17 |
276536 | 276536 | 2020-06-26 | Monroe | Ohio | 39111 | 85 | 17 |
273389 | 273389 | 2020-06-25 | Monroe | Ohio | 39111 | 83 | 16 |
270250 | 270250 | 2020-06-24 | Monroe | Ohio | 39111 | 83 | 16 |
267116 | 267116 | 2020-06-23 | Monroe | Ohio | 39111 | 83 | 16 |
263988 | 263988 | 2020-06-22 | Monroe | Ohio | 39111 | 82 | 15 |
260860 | 260860 | 2020-06-21 | Monroe | Ohio | 39111 | 82 | 15 |
257733 | 257733 | 2020-06-20 | Monroe | Ohio | 39111 | 82 | 15 |
254608 | 254608 | 2020-06-19 | Monroe | Ohio | 39111 | 82 | 15 |
251493 | 251493 | 2020-06-18 | Monroe | Ohio | 39111 | 82 | 15 |
248378 | 248378 | 2020-06-17 | Monroe | Ohio | 39111 | 82 | 15 |
245265 | 245265 | 2020-06-16 | Monroe | Ohio | 39111 | 82 | 15 |
242153 | 242153 | 2020-06-15 | Monroe | Ohio | 39111 | 82 | 15 |
239044 | 239044 | 2020-06-14 | Monroe | Ohio | 39111 | 82 | 15 |
235936 | 235936 | 2020-06-13 | Monroe | Ohio | 39111 | 82 | 15 |
232831 | 232831 | 2020-06-12 | Monroe | Ohio | 39111 | 83 | 15 |
229726 | 229726 | 2020-06-11 | Monroe | Ohio | 39111 | 83 | 15 |
226622 | 226622 | 2020-06-10 | Monroe | Ohio | 39111 | 83 | 15 |
223522 | 223522 | 2020-06-09 | Monroe | Ohio | 39111 | 81 | 15 |
220427 | 220427 | 2020-06-08 | Monroe | Ohio | 39111 | 81 | 15 |
217335 | 217335 | 2020-06-07 | Monroe | Ohio | 39111 | 80 | 15 |
214245 | 214245 | 2020-06-06 | Monroe | Ohio | 39111 | 80 | 15 |
211159 | 211159 | 2020-06-05 | Monroe | Ohio | 39111 | 80 | 15 |
208077 | 208077 | 2020-06-04 | Monroe | Ohio | 39111 | 80 | 15 |
204996 | 204996 | 2020-06-03 | Monroe | Ohio | 39111 | 79 | 14 |
201919 | 201919 | 2020-06-02 | Monroe | Ohio | 39111 | 79 | 14 |
198844 | 198844 | 2020-06-01 | Monroe | Ohio | 39111 | 79 | 14 |
195771 | 195771 | 2020-05-31 | Monroe | Ohio | 39111 | 78 | 12 |
192701 | 192701 | 2020-05-30 | Monroe | Ohio | 39111 | 78 | 12 |
189637 | 189637 | 2020-05-29 | Monroe | Ohio | 39111 | 77 | 12 |
186577 | 186577 | 2020-05-28 | Monroe | Ohio | 39111 | 75 | 12 |
183520 | 183520 | 2020-05-27 | Monroe | Ohio | 39111 | 74 | 12 |
180471 | 180471 | 2020-05-26 | Monroe | Ohio | 39111 | 73 | 11 |
177428 | 177428 | 2020-05-25 | Monroe | Ohio | 39111 | 71 | 11 |
174384 | 174384 | 2020-05-24 | Monroe | Ohio | 39111 | 71 | 11 |
171342 | 171342 | 2020-05-23 | Monroe | Ohio | 39111 | 71 | 9 |
168303 | 168303 | 2020-05-22 | Monroe | Ohio | 39111 | 71 | 7 |
165267 | 165267 | 2020-05-21 | Monroe | Ohio | 39111 | 65 | 4 |
162238 | 162238 | 2020-05-20 | Monroe | Ohio | 39111 | 59 | 4 |
159211 | 159211 | 2020-05-19 | Monroe | Ohio | 39111 | 56 | 4 |
156191 | 156191 | 2020-05-18 | Monroe | Ohio | 39111 | 56 | 2 |
153174 | 153174 | 2020-05-17 | Monroe | Ohio | 39111 | 55 | 2 |
150163 | 150163 | 2020-05-16 | Monroe | Ohio | 39111 | 53 | 1 |
147156 | 147156 | 2020-05-15 | Monroe | Ohio | 39111 | 53 | 1 |
144155 | 144155 | 2020-05-14 | Monroe | Ohio | 39111 | 28 | 0 |
141160 | 141160 | 2020-05-13 | Monroe | Ohio | 39111 | 25 | 0 |
138164 | 138164 | 2020-05-12 | Monroe | Ohio | 39111 | 22 | 0 |
135174 | 135174 | 2020-05-11 | Monroe | Ohio | 39111 | 19 | 0 |
132183 | 132183 | 2020-05-10 | Monroe | Ohio | 39111 | 10 | 0 |
129194 | 129194 | 2020-05-09 | Monroe | Ohio | 39111 | 8 | 0 |
126205 | 126205 | 2020-05-08 | Monroe | Ohio | 39111 | 8 | 0 |
123222 | 123222 | 2020-05-07 | Monroe | Ohio | 39111 | 5 | 0 |
120245 | 120245 | 2020-05-06 | Monroe | Ohio | 39111 | 4 | 0 |
117284 | 117284 | 2020-05-05 | Monroe | Ohio | 39111 | 4 | 0 |
114403 | 114403 | 2020-05-04 | Monroe | Ohio | 39111 | 4 | 0 |
111522 | 111522 | 2020-05-03 | Monroe | Ohio | 39111 | 3 | 0 |
108648 | 108648 | 2020-05-02 | Monroe | Ohio | 39111 | 4 | 0 |
105781 | 105781 | 2020-05-01 | Monroe | Ohio | 39111 | 3 | 0 |
102918 | 102918 | 2020-04-30 | Monroe | Ohio | 39111 | 3 | 0 |
100065 | 100065 | 2020-04-29 | Monroe | Ohio | 39111 | 3 | 0 |
97216 | 97216 | 2020-04-28 | Monroe | Ohio | 39111 | 2 | 0 |
94379 | 94379 | 2020-04-27 | Monroe | Ohio | 39111 | 2 | 0 |
91553 | 91553 | 2020-04-26 | Monroe | Ohio | 39111 | 2 | 0 |
88737 | 88737 | 2020-04-25 | Monroe | Ohio | 39111 | 2 | 0 |
85923 | 85923 | 2020-04-24 | Monroe | Ohio | 39111 | 2 | 0 |
83119 | 83119 | 2020-04-23 | Monroe | Ohio | 39111 | 2 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);