ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536499 | 536499 | 2020-09-15 | Fayette | Ohio | 39047 | 221 | 5 |
533263 | 533263 | 2020-09-14 | Fayette | Ohio | 39047 | 219 | 5 |
530028 | 530028 | 2020-09-13 | Fayette | Ohio | 39047 | 217 | 5 |
526791 | 526791 | 2020-09-12 | Fayette | Ohio | 39047 | 215 | 5 |
523555 | 523555 | 2020-09-11 | Fayette | Ohio | 39047 | 213 | 5 |
520319 | 520319 | 2020-09-10 | Fayette | Ohio | 39047 | 210 | 5 |
517083 | 517083 | 2020-09-09 | Fayette | Ohio | 39047 | 209 | 5 |
513848 | 513848 | 2020-09-08 | Fayette | Ohio | 39047 | 208 | 5 |
510615 | 510615 | 2020-09-07 | Fayette | Ohio | 39047 | 207 | 5 |
507382 | 507382 | 2020-09-06 | Fayette | Ohio | 39047 | 206 | 5 |
504150 | 504150 | 2020-09-05 | Fayette | Ohio | 39047 | 202 | 5 |
500916 | 500916 | 2020-09-04 | Fayette | Ohio | 39047 | 201 | 5 |
497682 | 497682 | 2020-09-03 | Fayette | Ohio | 39047 | 198 | 5 |
494449 | 494449 | 2020-09-02 | Fayette | Ohio | 39047 | 193 | 5 |
491215 | 491215 | 2020-09-01 | Fayette | Ohio | 39047 | 192 | 5 |
487982 | 487982 | 2020-08-31 | Fayette | Ohio | 39047 | 189 | 5 |
484749 | 484749 | 2020-08-30 | Fayette | Ohio | 39047 | 189 | 5 |
481514 | 481514 | 2020-08-29 | Fayette | Ohio | 39047 | 189 | 5 |
478280 | 478280 | 2020-08-28 | Fayette | Ohio | 39047 | 189 | 4 |
475047 | 475047 | 2020-08-27 | Fayette | Ohio | 39047 | 182 | 3 |
471813 | 471813 | 2020-08-26 | Fayette | Ohio | 39047 | 181 | 3 |
468581 | 468581 | 2020-08-25 | Fayette | Ohio | 39047 | 175 | 1 |
465353 | 465353 | 2020-08-24 | Fayette | Ohio | 39047 | 172 | 1 |
462124 | 462124 | 2020-08-23 | Fayette | Ohio | 39047 | 169 | 1 |
458896 | 458896 | 2020-08-22 | Fayette | Ohio | 39047 | 168 | 1 |
455668 | 455668 | 2020-08-21 | Fayette | Ohio | 39047 | 166 | 0 |
452440 | 452440 | 2020-08-20 | Fayette | Ohio | 39047 | 147 | 0 |
449212 | 449212 | 2020-08-19 | Fayette | Ohio | 39047 | 142 | 0 |
445984 | 445984 | 2020-08-18 | Fayette | Ohio | 39047 | 135 | 0 |
442758 | 442758 | 2020-08-17 | Fayette | Ohio | 39047 | 134 | 0 |
439531 | 439531 | 2020-08-16 | Fayette | Ohio | 39047 | 130 | 0 |
436306 | 436306 | 2020-08-15 | Fayette | Ohio | 39047 | 129 | 0 |
433080 | 433080 | 2020-08-14 | Fayette | Ohio | 39047 | 127 | 0 |
429854 | 429854 | 2020-08-13 | Fayette | Ohio | 39047 | 126 | 0 |
426629 | 426629 | 2020-08-12 | Fayette | Ohio | 39047 | 124 | 0 |
423406 | 423406 | 2020-08-11 | Fayette | Ohio | 39047 | 121 | 0 |
420183 | 420183 | 2020-08-10 | Fayette | Ohio | 39047 | 115 | 0 |
416963 | 416963 | 2020-08-09 | Fayette | Ohio | 39047 | 113 | 0 |
413742 | 413742 | 2020-08-08 | Fayette | Ohio | 39047 | 112 | 0 |
410522 | 410522 | 2020-08-07 | Fayette | Ohio | 39047 | 110 | 0 |
407302 | 407302 | 2020-08-06 | Fayette | Ohio | 39047 | 109 | 0 |
404083 | 404083 | 2020-08-05 | Fayette | Ohio | 39047 | 104 | 0 |
400865 | 400865 | 2020-08-04 | Fayette | Ohio | 39047 | 102 | 0 |
397650 | 397650 | 2020-08-03 | Fayette | Ohio | 39047 | 97 | 0 |
394433 | 394433 | 2020-08-02 | Fayette | Ohio | 39047 | 94 | 0 |
391217 | 391217 | 2020-08-01 | Fayette | Ohio | 39047 | 91 | 0 |
388000 | 388000 | 2020-07-31 | Fayette | Ohio | 39047 | 88 | 0 |
384783 | 384783 | 2020-07-30 | Fayette | Ohio | 39047 | 80 | 0 |
381565 | 381565 | 2020-07-29 | Fayette | Ohio | 39047 | 76 | 0 |
378348 | 378348 | 2020-07-28 | Fayette | Ohio | 39047 | 73 | 0 |
375131 | 375131 | 2020-07-27 | Fayette | Ohio | 39047 | 71 | 0 |
371919 | 371919 | 2020-07-26 | Fayette | Ohio | 39047 | 68 | 0 |
368707 | 368707 | 2020-07-25 | Fayette | Ohio | 39047 | 66 | 0 |
365498 | 365498 | 2020-07-24 | Fayette | Ohio | 39047 | 65 | 0 |
362292 | 362292 | 2020-07-23 | Fayette | Ohio | 39047 | 64 | 0 |
359086 | 359086 | 2020-07-22 | Fayette | Ohio | 39047 | 64 | 0 |
355882 | 355882 | 2020-07-21 | Fayette | Ohio | 39047 | 64 | 0 |
352679 | 352679 | 2020-07-20 | Fayette | Ohio | 39047 | 61 | 0 |
349476 | 349476 | 2020-07-19 | Fayette | Ohio | 39047 | 59 | 0 |
346275 | 346275 | 2020-07-18 | Fayette | Ohio | 39047 | 59 | 0 |
343076 | 343076 | 2020-07-17 | Fayette | Ohio | 39047 | 59 | 0 |
339878 | 339878 | 2020-07-16 | Fayette | Ohio | 39047 | 58 | 0 |
336682 | 336682 | 2020-07-15 | Fayette | Ohio | 39047 | 58 | 0 |
333488 | 333488 | 2020-07-14 | Fayette | Ohio | 39047 | 58 | 0 |
330296 | 330296 | 2020-07-13 | Fayette | Ohio | 39047 | 58 | 0 |
327109 | 327109 | 2020-07-12 | Fayette | Ohio | 39047 | 55 | 0 |
323924 | 323924 | 2020-07-11 | Fayette | Ohio | 39047 | 55 | 0 |
320744 | 320744 | 2020-07-10 | Fayette | Ohio | 39047 | 55 | 0 |
317567 | 317567 | 2020-07-09 | Fayette | Ohio | 39047 | 51 | 0 |
314394 | 314394 | 2020-07-08 | Fayette | Ohio | 39047 | 48 | 0 |
311222 | 311222 | 2020-07-07 | Fayette | Ohio | 39047 | 46 | 0 |
308053 | 308053 | 2020-07-06 | Fayette | Ohio | 39047 | 46 | 0 |
304886 | 304886 | 2020-07-05 | Fayette | Ohio | 39047 | 46 | 0 |
301723 | 301723 | 2020-07-04 | Fayette | Ohio | 39047 | 46 | 0 |
298560 | 298560 | 2020-07-03 | Fayette | Ohio | 39047 | 46 | 0 |
295400 | 295400 | 2020-07-02 | Fayette | Ohio | 39047 | 46 | 0 |
292245 | 292245 | 2020-07-01 | Fayette | Ohio | 39047 | 46 | 0 |
289093 | 289093 | 2020-06-30 | Fayette | Ohio | 39047 | 46 | 0 |
285943 | 285943 | 2020-06-29 | Fayette | Ohio | 39047 | 46 | 0 |
282798 | 282798 | 2020-06-28 | Fayette | Ohio | 39047 | 45 | 0 |
279652 | 279652 | 2020-06-27 | Fayette | Ohio | 39047 | 45 | 0 |
276504 | 276504 | 2020-06-26 | Fayette | Ohio | 39047 | 45 | 0 |
273357 | 273357 | 2020-06-25 | Fayette | Ohio | 39047 | 45 | 0 |
270218 | 270218 | 2020-06-24 | Fayette | Ohio | 39047 | 45 | 0 |
267084 | 267084 | 2020-06-23 | Fayette | Ohio | 39047 | 45 | 0 |
263956 | 263956 | 2020-06-22 | Fayette | Ohio | 39047 | 45 | 0 |
260828 | 260828 | 2020-06-21 | Fayette | Ohio | 39047 | 45 | 0 |
257701 | 257701 | 2020-06-20 | Fayette | Ohio | 39047 | 45 | 0 |
254576 | 254576 | 2020-06-19 | Fayette | Ohio | 39047 | 45 | 0 |
251461 | 251461 | 2020-06-18 | Fayette | Ohio | 39047 | 45 | 0 |
248346 | 248346 | 2020-06-17 | Fayette | Ohio | 39047 | 45 | 0 |
245233 | 245233 | 2020-06-16 | Fayette | Ohio | 39047 | 45 | 0 |
242121 | 242121 | 2020-06-15 | Fayette | Ohio | 39047 | 45 | 0 |
239012 | 239012 | 2020-06-14 | Fayette | Ohio | 39047 | 45 | 0 |
235904 | 235904 | 2020-06-13 | Fayette | Ohio | 39047 | 44 | 0 |
232799 | 232799 | 2020-06-12 | Fayette | Ohio | 39047 | 44 | 0 |
229694 | 229694 | 2020-06-11 | Fayette | Ohio | 39047 | 44 | 0 |
226590 | 226590 | 2020-06-10 | Fayette | Ohio | 39047 | 43 | 0 |
223490 | 223490 | 2020-06-09 | Fayette | Ohio | 39047 | 43 | 0 |
220395 | 220395 | 2020-06-08 | Fayette | Ohio | 39047 | 43 | 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);