ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Morgan" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536533 | 536533 | 2020-09-15 | Morgan | Ohio | 39115 | 45 | 0 |
533297 | 533297 | 2020-09-14 | Morgan | Ohio | 39115 | 46 | 0 |
530062 | 530062 | 2020-09-13 | Morgan | Ohio | 39115 | 46 | 0 |
526825 | 526825 | 2020-09-12 | Morgan | Ohio | 39115 | 46 | 0 |
523589 | 523589 | 2020-09-11 | Morgan | Ohio | 39115 | 46 | 0 |
520353 | 520353 | 2020-09-10 | Morgan | Ohio | 39115 | 45 | 0 |
517117 | 517117 | 2020-09-09 | Morgan | Ohio | 39115 | 45 | 0 |
513882 | 513882 | 2020-09-08 | Morgan | Ohio | 39115 | 45 | 0 |
510649 | 510649 | 2020-09-07 | Morgan | Ohio | 39115 | 45 | 0 |
507416 | 507416 | 2020-09-06 | Morgan | Ohio | 39115 | 45 | 0 |
504184 | 504184 | 2020-09-05 | Morgan | Ohio | 39115 | 45 | 0 |
500950 | 500950 | 2020-09-04 | Morgan | Ohio | 39115 | 45 | 0 |
497716 | 497716 | 2020-09-03 | Morgan | Ohio | 39115 | 45 | 0 |
494483 | 494483 | 2020-09-02 | Morgan | Ohio | 39115 | 44 | 0 |
491249 | 491249 | 2020-09-01 | Morgan | Ohio | 39115 | 44 | 0 |
488016 | 488016 | 2020-08-31 | Morgan | Ohio | 39115 | 44 | 0 |
484783 | 484783 | 2020-08-30 | Morgan | Ohio | 39115 | 43 | 0 |
481548 | 481548 | 2020-08-29 | Morgan | Ohio | 39115 | 43 | 0 |
478314 | 478314 | 2020-08-28 | Morgan | Ohio | 39115 | 43 | 0 |
475081 | 475081 | 2020-08-27 | Morgan | Ohio | 39115 | 43 | 0 |
471847 | 471847 | 2020-08-26 | Morgan | Ohio | 39115 | 43 | 0 |
468615 | 468615 | 2020-08-25 | Morgan | Ohio | 39115 | 43 | 0 |
465387 | 465387 | 2020-08-24 | Morgan | Ohio | 39115 | 43 | 0 |
462158 | 462158 | 2020-08-23 | Morgan | Ohio | 39115 | 41 | 0 |
458930 | 458930 | 2020-08-22 | Morgan | Ohio | 39115 | 41 | 0 |
455702 | 455702 | 2020-08-21 | Morgan | Ohio | 39115 | 40 | 0 |
452474 | 452474 | 2020-08-20 | Morgan | Ohio | 39115 | 39 | 0 |
449246 | 449246 | 2020-08-19 | Morgan | Ohio | 39115 | 36 | 0 |
446018 | 446018 | 2020-08-18 | Morgan | Ohio | 39115 | 35 | 0 |
442792 | 442792 | 2020-08-17 | Morgan | Ohio | 39115 | 33 | 0 |
439565 | 439565 | 2020-08-16 | Morgan | Ohio | 39115 | 33 | 0 |
436340 | 436340 | 2020-08-15 | Morgan | Ohio | 39115 | 33 | 0 |
433114 | 433114 | 2020-08-14 | Morgan | Ohio | 39115 | 32 | 0 |
429888 | 429888 | 2020-08-13 | Morgan | Ohio | 39115 | 31 | 0 |
426663 | 426663 | 2020-08-12 | Morgan | Ohio | 39115 | 30 | 0 |
423440 | 423440 | 2020-08-11 | Morgan | Ohio | 39115 | 30 | 0 |
420217 | 420217 | 2020-08-10 | Morgan | Ohio | 39115 | 28 | 0 |
416997 | 416997 | 2020-08-09 | Morgan | Ohio | 39115 | 26 | 0 |
413776 | 413776 | 2020-08-08 | Morgan | Ohio | 39115 | 25 | 0 |
410556 | 410556 | 2020-08-07 | Morgan | Ohio | 39115 | 25 | 0 |
407336 | 407336 | 2020-08-06 | Morgan | Ohio | 39115 | 23 | 0 |
404117 | 404117 | 2020-08-05 | Morgan | Ohio | 39115 | 21 | 0 |
400899 | 400899 | 2020-08-04 | Morgan | Ohio | 39115 | 20 | 0 |
397684 | 397684 | 2020-08-03 | Morgan | Ohio | 39115 | 20 | 0 |
394467 | 394467 | 2020-08-02 | Morgan | Ohio | 39115 | 20 | 0 |
391251 | 391251 | 2020-08-01 | Morgan | Ohio | 39115 | 18 | 0 |
388034 | 388034 | 2020-07-31 | Morgan | Ohio | 39115 | 17 | 0 |
384817 | 384817 | 2020-07-30 | Morgan | Ohio | 39115 | 17 | 0 |
381599 | 381599 | 2020-07-29 | Morgan | Ohio | 39115 | 17 | 0 |
378382 | 378382 | 2020-07-28 | Morgan | Ohio | 39115 | 17 | 0 |
375165 | 375165 | 2020-07-27 | Morgan | Ohio | 39115 | 16 | 0 |
371953 | 371953 | 2020-07-26 | Morgan | Ohio | 39115 | 16 | 0 |
368741 | 368741 | 2020-07-25 | Morgan | Ohio | 39115 | 16 | 0 |
365532 | 365532 | 2020-07-24 | Morgan | Ohio | 39115 | 16 | 0 |
362326 | 362326 | 2020-07-23 | Morgan | Ohio | 39115 | 16 | 0 |
359120 | 359120 | 2020-07-22 | Morgan | Ohio | 39115 | 15 | 0 |
355916 | 355916 | 2020-07-21 | Morgan | Ohio | 39115 | 15 | 0 |
352713 | 352713 | 2020-07-20 | Morgan | Ohio | 39115 | 14 | 0 |
349510 | 349510 | 2020-07-19 | Morgan | Ohio | 39115 | 14 | 0 |
346309 | 346309 | 2020-07-18 | Morgan | Ohio | 39115 | 14 | 0 |
343110 | 343110 | 2020-07-17 | Morgan | Ohio | 39115 | 14 | 0 |
339912 | 339912 | 2020-07-16 | Morgan | Ohio | 39115 | 13 | 0 |
336716 | 336716 | 2020-07-15 | Morgan | Ohio | 39115 | 13 | 0 |
333522 | 333522 | 2020-07-14 | Morgan | Ohio | 39115 | 13 | 0 |
330330 | 330330 | 2020-07-13 | Morgan | Ohio | 39115 | 12 | 0 |
327143 | 327143 | 2020-07-12 | Morgan | Ohio | 39115 | 11 | 0 |
323958 | 323958 | 2020-07-11 | Morgan | Ohio | 39115 | 11 | 0 |
320778 | 320778 | 2020-07-10 | Morgan | Ohio | 39115 | 12 | 0 |
317601 | 317601 | 2020-07-09 | Morgan | Ohio | 39115 | 11 | 0 |
314428 | 314428 | 2020-07-08 | Morgan | Ohio | 39115 | 11 | 0 |
311256 | 311256 | 2020-07-07 | Morgan | Ohio | 39115 | 11 | 0 |
308087 | 308087 | 2020-07-06 | Morgan | Ohio | 39115 | 11 | 0 |
304920 | 304920 | 2020-07-05 | Morgan | Ohio | 39115 | 11 | 0 |
301757 | 301757 | 2020-07-04 | Morgan | Ohio | 39115 | 11 | 0 |
298594 | 298594 | 2020-07-03 | Morgan | Ohio | 39115 | 11 | 0 |
295434 | 295434 | 2020-07-02 | Morgan | Ohio | 39115 | 9 | 0 |
292279 | 292279 | 2020-07-01 | Morgan | Ohio | 39115 | 9 | 0 |
289127 | 289127 | 2020-06-30 | Morgan | Ohio | 39115 | 9 | 0 |
285977 | 285977 | 2020-06-29 | Morgan | Ohio | 39115 | 7 | 0 |
282832 | 282832 | 2020-06-28 | Morgan | Ohio | 39115 | 7 | 0 |
279686 | 279686 | 2020-06-27 | Morgan | Ohio | 39115 | 7 | 0 |
276538 | 276538 | 2020-06-26 | Morgan | Ohio | 39115 | 7 | 0 |
273391 | 273391 | 2020-06-25 | Morgan | Ohio | 39115 | 6 | 0 |
270252 | 270252 | 2020-06-24 | Morgan | Ohio | 39115 | 6 | 0 |
267118 | 267118 | 2020-06-23 | Morgan | Ohio | 39115 | 6 | 0 |
263990 | 263990 | 2020-06-22 | Morgan | Ohio | 39115 | 6 | 0 |
260862 | 260862 | 2020-06-21 | Morgan | Ohio | 39115 | 6 | 0 |
257735 | 257735 | 2020-06-20 | Morgan | Ohio | 39115 | 6 | 0 |
254610 | 254610 | 2020-06-19 | Morgan | Ohio | 39115 | 6 | 0 |
251495 | 251495 | 2020-06-18 | Morgan | Ohio | 39115 | 6 | 0 |
248380 | 248380 | 2020-06-17 | Morgan | Ohio | 39115 | 6 | 0 |
245267 | 245267 | 2020-06-16 | Morgan | Ohio | 39115 | 6 | 0 |
242155 | 242155 | 2020-06-15 | Morgan | Ohio | 39115 | 6 | 0 |
239046 | 239046 | 2020-06-14 | Morgan | Ohio | 39115 | 6 | 0 |
235938 | 235938 | 2020-06-13 | Morgan | Ohio | 39115 | 6 | 0 |
232833 | 232833 | 2020-06-12 | Morgan | Ohio | 39115 | 6 | 0 |
229728 | 229728 | 2020-06-11 | Morgan | Ohio | 39115 | 6 | 0 |
226624 | 226624 | 2020-06-10 | Morgan | Ohio | 39115 | 6 | 0 |
223524 | 223524 | 2020-06-09 | Morgan | Ohio | 39115 | 6 | 0 |
220429 | 220429 | 2020-06-08 | Morgan | Ohio | 39115 | 6 | 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);