ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Franklin" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536500 | 536500 | 2020-09-15 | Franklin | Ohio | 39049 | 25067 | 593 |
533264 | 533264 | 2020-09-14 | Franklin | Ohio | 39049 | 24832 | 579 |
530029 | 530029 | 2020-09-13 | Franklin | Ohio | 39049 | 24590 | 579 |
526792 | 526792 | 2020-09-12 | Franklin | Ohio | 39049 | 24419 | 579 |
523556 | 523556 | 2020-09-11 | Franklin | Ohio | 39049 | 24144 | 577 |
520320 | 520320 | 2020-09-10 | Franklin | Ohio | 39049 | 23994 | 573 |
517084 | 517084 | 2020-09-09 | Franklin | Ohio | 39049 | 23763 | 572 |
513849 | 513849 | 2020-09-08 | Franklin | Ohio | 39049 | 23477 | 570 |
510616 | 510616 | 2020-09-07 | Franklin | Ohio | 39049 | 23295 | 567 |
507383 | 507383 | 2020-09-06 | Franklin | Ohio | 39049 | 23099 | 565 |
504151 | 504151 | 2020-09-05 | Franklin | Ohio | 39049 | 22935 | 565 |
500917 | 500917 | 2020-09-04 | Franklin | Ohio | 39049 | 22629 | 565 |
497683 | 497683 | 2020-09-03 | Franklin | Ohio | 39049 | 22392 | 565 |
494450 | 494450 | 2020-09-02 | Franklin | Ohio | 39049 | 22161 | 563 |
491216 | 491216 | 2020-09-01 | Franklin | Ohio | 39049 | 22005 | 563 |
487983 | 487983 | 2020-08-31 | Franklin | Ohio | 39049 | 21785 | 562 |
484750 | 484750 | 2020-08-30 | Franklin | Ohio | 39049 | 21619 | 562 |
481515 | 481515 | 2020-08-29 | Franklin | Ohio | 39049 | 21497 | 562 |
478281 | 478281 | 2020-08-28 | Franklin | Ohio | 39049 | 21320 | 559 |
475048 | 475048 | 2020-08-27 | Franklin | Ohio | 39049 | 21133 | 556 |
471814 | 471814 | 2020-08-26 | Franklin | Ohio | 39049 | 20954 | 556 |
468582 | 468582 | 2020-08-25 | Franklin | Ohio | 39049 | 20794 | 554 |
465354 | 465354 | 2020-08-24 | Franklin | Ohio | 39049 | 20659 | 554 |
462125 | 462125 | 2020-08-23 | Franklin | Ohio | 39049 | 20534 | 553 |
458897 | 458897 | 2020-08-22 | Franklin | Ohio | 39049 | 20443 | 553 |
455669 | 455669 | 2020-08-21 | Franklin | Ohio | 39049 | 20316 | 551 |
452441 | 452441 | 2020-08-20 | Franklin | Ohio | 39049 | 20150 | 547 |
449213 | 449213 | 2020-08-19 | Franklin | Ohio | 39049 | 19980 | 545 |
445985 | 445985 | 2020-08-18 | Franklin | Ohio | 39049 | 19818 | 542 |
442759 | 442759 | 2020-08-17 | Franklin | Ohio | 39049 | 19683 | 537 |
439532 | 439532 | 2020-08-16 | Franklin | Ohio | 39049 | 19553 | 537 |
436307 | 436307 | 2020-08-15 | Franklin | Ohio | 39049 | 19437 | 537 |
433081 | 433081 | 2020-08-14 | Franklin | Ohio | 39049 | 19287 | 533 |
429855 | 429855 | 2020-08-13 | Franklin | Ohio | 39049 | 19124 | 533 |
426630 | 426630 | 2020-08-12 | Franklin | Ohio | 39049 | 18965 | 531 |
423407 | 423407 | 2020-08-11 | Franklin | Ohio | 39049 | 18697 | 529 |
420184 | 420184 | 2020-08-10 | Franklin | Ohio | 39049 | 18483 | 525 |
416964 | 416964 | 2020-08-09 | Franklin | Ohio | 39049 | 18317 | 524 |
413743 | 413743 | 2020-08-08 | Franklin | Ohio | 39049 | 18182 | 523 |
410523 | 410523 | 2020-08-07 | Franklin | Ohio | 39049 | 18006 | 522 |
407303 | 407303 | 2020-08-06 | Franklin | Ohio | 39049 | 17834 | 521 |
404084 | 404084 | 2020-08-05 | Franklin | Ohio | 39049 | 17619 | 517 |
400866 | 400866 | 2020-08-04 | Franklin | Ohio | 39049 | 17404 | 515 |
397651 | 397651 | 2020-08-03 | Franklin | Ohio | 39049 | 17254 | 514 |
394434 | 394434 | 2020-08-02 | Franklin | Ohio | 39049 | 17107 | 514 |
391218 | 391218 | 2020-08-01 | Franklin | Ohio | 39049 | 16952 | 513 |
388001 | 388001 | 2020-07-31 | Franklin | Ohio | 39049 | 16842 | 511 |
384784 | 384784 | 2020-07-30 | Franklin | Ohio | 39049 | 16630 | 507 |
381566 | 381566 | 2020-07-29 | Franklin | Ohio | 39049 | 16311 | 502 |
378349 | 378349 | 2020-07-28 | Franklin | Ohio | 39049 | 16042 | 496 |
375132 | 375132 | 2020-07-27 | Franklin | Ohio | 39049 | 15862 | 494 |
371920 | 371920 | 2020-07-26 | Franklin | Ohio | 39049 | 15682 | 489 |
368708 | 368708 | 2020-07-25 | Franklin | Ohio | 39049 | 15548 | 487 |
365499 | 365499 | 2020-07-24 | Franklin | Ohio | 39049 | 15301 | 487 |
362293 | 362293 | 2020-07-23 | Franklin | Ohio | 39049 | 14993 | 484 |
359087 | 359087 | 2020-07-22 | Franklin | Ohio | 39049 | 14736 | 478 |
355883 | 355883 | 2020-07-21 | Franklin | Ohio | 39049 | 14432 | 475 |
352680 | 352680 | 2020-07-20 | Franklin | Ohio | 39049 | 14246 | 468 |
349477 | 349477 | 2020-07-19 | Franklin | Ohio | 39049 | 14001 | 467 |
346276 | 346276 | 2020-07-18 | Franklin | Ohio | 39049 | 13778 | 461 |
343077 | 343077 | 2020-07-17 | Franklin | Ohio | 39049 | 13412 | 457 |
339879 | 339879 | 2020-07-16 | Franklin | Ohio | 39049 | 13099 | 456 |
336683 | 336683 | 2020-07-15 | Franklin | Ohio | 39049 | 12823 | 449 |
333489 | 333489 | 2020-07-14 | Franklin | Ohio | 39049 | 12574 | 449 |
330297 | 330297 | 2020-07-13 | Franklin | Ohio | 39049 | 12301 | 449 |
327110 | 327110 | 2020-07-12 | Franklin | Ohio | 39049 | 12035 | 447 |
323925 | 323925 | 2020-07-11 | Franklin | Ohio | 39049 | 11724 | 445 |
320745 | 320745 | 2020-07-10 | Franklin | Ohio | 39049 | 11433 | 443 |
317568 | 317568 | 2020-07-09 | Franklin | Ohio | 39049 | 11122 | 439 |
314395 | 314395 | 2020-07-08 | Franklin | Ohio | 39049 | 10879 | 439 |
311223 | 311223 | 2020-07-07 | Franklin | Ohio | 39049 | 10587 | 431 |
308054 | 308054 | 2020-07-06 | Franklin | Ohio | 39049 | 10410 | 429 |
304887 | 304887 | 2020-07-05 | Franklin | Ohio | 39049 | 10271 | 422 |
301724 | 301724 | 2020-07-04 | Franklin | Ohio | 39049 | 10023 | 420 |
298561 | 298561 | 2020-07-03 | Franklin | Ohio | 39049 | 9825 | 417 |
295401 | 295401 | 2020-07-02 | Franklin | Ohio | 39049 | 9338 | 407 |
292246 | 292246 | 2020-07-01 | Franklin | Ohio | 39049 | 9338 | 407 |
289094 | 289094 | 2020-06-30 | Franklin | Ohio | 39049 | 9148 | 404 |
285944 | 285944 | 2020-06-29 | Franklin | Ohio | 39049 | 8982 | 395 |
282799 | 282799 | 2020-06-28 | Franklin | Ohio | 39049 | 8840 | 393 |
279653 | 279653 | 2020-06-27 | Franklin | Ohio | 39049 | 8694 | 392 |
276505 | 276505 | 2020-06-26 | Franklin | Ohio | 39049 | 8511 | 383 |
273358 | 273358 | 2020-06-25 | Franklin | Ohio | 39049 | 8310 | 378 |
270219 | 270219 | 2020-06-24 | Franklin | Ohio | 39049 | 8144 | 376 |
267085 | 267085 | 2020-06-23 | Franklin | Ohio | 39049 | 8029 | 370 |
263957 | 263957 | 2020-06-22 | Franklin | Ohio | 39049 | 7915 | 358 |
260829 | 260829 | 2020-06-21 | Franklin | Ohio | 39049 | 7794 | 358 |
257702 | 257702 | 2020-06-20 | Franklin | Ohio | 39049 | 7694 | 357 |
254577 | 254577 | 2020-06-19 | Franklin | Ohio | 39049 | 7590 | 348 |
251462 | 251462 | 2020-06-18 | Franklin | Ohio | 39049 | 7487 | 342 |
248347 | 248347 | 2020-06-17 | Franklin | Ohio | 39049 | 7365 | 337 |
245234 | 245234 | 2020-06-16 | Franklin | Ohio | 39049 | 7289 | 334 |
242122 | 242122 | 2020-06-15 | Franklin | Ohio | 39049 | 7202 | 332 |
239013 | 239013 | 2020-06-14 | Franklin | Ohio | 39049 | 7076 | 329 |
235905 | 235905 | 2020-06-13 | Franklin | Ohio | 39049 | 7030 | 329 |
232800 | 232800 | 2020-06-12 | Franklin | Ohio | 39049 | 6918 | 325 |
229695 | 229695 | 2020-06-11 | Franklin | Ohio | 39049 | 6844 | 320 |
226591 | 226591 | 2020-06-10 | Franklin | Ohio | 39049 | 6741 | 313 |
223491 | 223491 | 2020-06-09 | Franklin | Ohio | 39049 | 6667 | 303 |
220396 | 220396 | 2020-06-08 | Franklin | Ohio | 39049 | 6586 | 300 |
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);