ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Monroe" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536531 | 536531 | 2020-09-15 | Monroe | Ohio | 39111 | 106 | 18 |
533295 | 533295 | 2020-09-14 | Monroe | Ohio | 39111 | 106 | 18 |
530060 | 530060 | 2020-09-13 | Monroe | Ohio | 39111 | 106 | 18 |
526823 | 526823 | 2020-09-12 | Monroe | Ohio | 39111 | 106 | 18 |
523587 | 523587 | 2020-09-11 | Monroe | Ohio | 39111 | 106 | 18 |
520351 | 520351 | 2020-09-10 | Monroe | Ohio | 39111 | 106 | 18 |
517115 | 517115 | 2020-09-09 | Monroe | Ohio | 39111 | 104 | 18 |
513880 | 513880 | 2020-09-08 | Monroe | Ohio | 39111 | 105 | 18 |
510647 | 510647 | 2020-09-07 | Monroe | Ohio | 39111 | 105 | 18 |
507414 | 507414 | 2020-09-06 | Monroe | Ohio | 39111 | 105 | 18 |
504182 | 504182 | 2020-09-05 | Monroe | Ohio | 39111 | 105 | 18 |
500948 | 500948 | 2020-09-04 | Monroe | Ohio | 39111 | 105 | 18 |
497714 | 497714 | 2020-09-03 | Monroe | Ohio | 39111 | 105 | 18 |
494481 | 494481 | 2020-09-02 | Monroe | Ohio | 39111 | 105 | 18 |
491247 | 491247 | 2020-09-01 | Monroe | Ohio | 39111 | 104 | 18 |
488014 | 488014 | 2020-08-31 | Monroe | Ohio | 39111 | 103 | 18 |
484781 | 484781 | 2020-08-30 | Monroe | Ohio | 39111 | 103 | 18 |
481546 | 481546 | 2020-08-29 | Monroe | Ohio | 39111 | 103 | 18 |
478312 | 478312 | 2020-08-28 | Monroe | Ohio | 39111 | 103 | 18 |
475079 | 475079 | 2020-08-27 | Monroe | Ohio | 39111 | 103 | 18 |
471845 | 471845 | 2020-08-26 | Monroe | Ohio | 39111 | 103 | 18 |
468613 | 468613 | 2020-08-25 | Monroe | Ohio | 39111 | 102 | 18 |
465385 | 465385 | 2020-08-24 | Monroe | Ohio | 39111 | 102 | 18 |
462156 | 462156 | 2020-08-23 | Monroe | Ohio | 39111 | 102 | 18 |
458928 | 458928 | 2020-08-22 | Monroe | Ohio | 39111 | 102 | 18 |
455700 | 455700 | 2020-08-21 | Monroe | Ohio | 39111 | 101 | 18 |
452472 | 452472 | 2020-08-20 | Monroe | Ohio | 39111 | 101 | 18 |
449244 | 449244 | 2020-08-19 | Monroe | Ohio | 39111 | 100 | 18 |
446016 | 446016 | 2020-08-18 | Monroe | Ohio | 39111 | 100 | 18 |
442790 | 442790 | 2020-08-17 | Monroe | Ohio | 39111 | 98 | 18 |
439563 | 439563 | 2020-08-16 | Monroe | Ohio | 39111 | 96 | 18 |
436338 | 436338 | 2020-08-15 | Monroe | Ohio | 39111 | 96 | 18 |
433112 | 433112 | 2020-08-14 | Monroe | Ohio | 39111 | 96 | 18 |
429886 | 429886 | 2020-08-13 | Monroe | Ohio | 39111 | 94 | 18 |
426661 | 426661 | 2020-08-12 | Monroe | Ohio | 39111 | 94 | 18 |
423438 | 423438 | 2020-08-11 | Monroe | Ohio | 39111 | 94 | 18 |
420215 | 420215 | 2020-08-10 | Monroe | Ohio | 39111 | 93 | 18 |
416995 | 416995 | 2020-08-09 | Monroe | Ohio | 39111 | 93 | 18 |
413774 | 413774 | 2020-08-08 | Monroe | Ohio | 39111 | 91 | 18 |
410554 | 410554 | 2020-08-07 | Monroe | Ohio | 39111 | 91 | 18 |
407334 | 407334 | 2020-08-06 | Monroe | Ohio | 39111 | 91 | 18 |
404115 | 404115 | 2020-08-05 | Monroe | Ohio | 39111 | 91 | 18 |
400897 | 400897 | 2020-08-04 | Monroe | Ohio | 39111 | 91 | 18 |
397682 | 397682 | 2020-08-03 | Monroe | Ohio | 39111 | 91 | 18 |
394465 | 394465 | 2020-08-02 | Monroe | Ohio | 39111 | 90 | 18 |
391249 | 391249 | 2020-08-01 | Monroe | Ohio | 39111 | 89 | 18 |
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 |
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);