ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Franklin" and state = "New York" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
298343 | 298343 | 2020-07-03 | Franklin | New York | 36033 | 33 | 0 |
301506 | 301506 | 2020-07-04 | Franklin | New York | 36033 | 33 | 0 |
304669 | 304669 | 2020-07-05 | Franklin | New York | 36033 | 33 | 0 |
307836 | 307836 | 2020-07-06 | Franklin | New York | 36033 | 33 | 0 |
311004 | 311004 | 2020-07-07 | Franklin | New York | 36033 | 33 | 0 |
314175 | 314175 | 2020-07-08 | Franklin | New York | 36033 | 33 | 0 |
317349 | 317349 | 2020-07-09 | Franklin | New York | 36033 | 34 | 0 |
320526 | 320526 | 2020-07-10 | Franklin | New York | 36033 | 35 | 0 |
323706 | 323706 | 2020-07-11 | Franklin | New York | 36033 | 35 | 0 |
326890 | 326890 | 2020-07-12 | Franklin | New York | 36033 | 36 | 0 |
330077 | 330077 | 2020-07-13 | Franklin | New York | 36033 | 36 | 0 |
333267 | 333267 | 2020-07-14 | Franklin | New York | 36033 | 36 | 0 |
336461 | 336461 | 2020-07-15 | Franklin | New York | 36033 | 37 | 0 |
339657 | 339657 | 2020-07-16 | Franklin | New York | 36033 | 38 | 0 |
342855 | 342855 | 2020-07-17 | Franklin | New York | 36033 | 39 | 1 |
346054 | 346054 | 2020-07-18 | Franklin | New York | 36033 | 40 | 1 |
349255 | 349255 | 2020-07-19 | Franklin | New York | 36033 | 40 | 1 |
352458 | 352458 | 2020-07-20 | Franklin | New York | 36033 | 40 | 1 |
355661 | 355661 | 2020-07-21 | Franklin | New York | 36033 | 42 | 1 |
358865 | 358865 | 2020-07-22 | Franklin | New York | 36033 | 42 | 1 |
362071 | 362071 | 2020-07-23 | Franklin | New York | 36033 | 42 | 1 |
365277 | 365277 | 2020-07-24 | Franklin | New York | 36033 | 42 | 1 |
368486 | 368486 | 2020-07-25 | Franklin | New York | 36033 | 42 | 1 |
371698 | 371698 | 2020-07-26 | Franklin | New York | 36033 | 44 | 1 |
374910 | 374910 | 2020-07-27 | Franklin | New York | 36033 | 44 | 1 |
378126 | 378126 | 2020-07-28 | Franklin | New York | 36033 | 47 | 1 |
381343 | 381343 | 2020-07-29 | Franklin | New York | 36033 | 48 | 1 |
384561 | 384561 | 2020-07-30 | Franklin | New York | 36033 | 48 | 1 |
387778 | 387778 | 2020-07-31 | Franklin | New York | 36033 | 50 | 1 |
390995 | 390995 | 2020-08-01 | Franklin | New York | 36033 | 50 | 1 |
394211 | 394211 | 2020-08-02 | Franklin | New York | 36033 | 50 | 1 |
397428 | 397428 | 2020-08-03 | Franklin | New York | 36033 | 50 | 1 |
400643 | 400643 | 2020-08-04 | Franklin | New York | 36033 | 50 | 1 |
403861 | 403861 | 2020-08-05 | Franklin | New York | 36033 | 52 | 1 |
407080 | 407080 | 2020-08-06 | Franklin | New York | 36033 | 52 | 1 |
410300 | 410300 | 2020-08-07 | Franklin | New York | 36033 | 54 | 1 |
413520 | 413520 | 2020-08-08 | Franklin | New York | 36033 | 54 | 1 |
416741 | 416741 | 2020-08-09 | Franklin | New York | 36033 | 54 | 1 |
419961 | 419961 | 2020-08-10 | Franklin | New York | 36033 | 54 | 1 |
423184 | 423184 | 2020-08-11 | Franklin | New York | 36033 | 54 | 1 |
426407 | 426407 | 2020-08-12 | Franklin | New York | 36033 | 54 | 1 |
429632 | 429632 | 2020-08-13 | Franklin | New York | 36033 | 54 | 1 |
432858 | 432858 | 2020-08-14 | Franklin | New York | 36033 | 54 | 1 |
436084 | 436084 | 2020-08-15 | Franklin | New York | 36033 | 54 | 1 |
439309 | 439309 | 2020-08-16 | Franklin | New York | 36033 | 54 | 1 |
442536 | 442536 | 2020-08-17 | Franklin | New York | 36033 | 54 | 1 |
445762 | 445762 | 2020-08-18 | Franklin | New York | 36033 | 55 | 1 |
448990 | 448990 | 2020-08-19 | Franklin | New York | 36033 | 56 | 1 |
452218 | 452218 | 2020-08-20 | Franklin | New York | 36033 | 56 | 1 |
455446 | 455446 | 2020-08-21 | Franklin | New York | 36033 | 56 | 1 |
458674 | 458674 | 2020-08-22 | Franklin | New York | 36033 | 56 | 1 |
461902 | 461902 | 2020-08-23 | Franklin | New York | 36033 | 56 | 1 |
465131 | 465131 | 2020-08-24 | Franklin | New York | 36033 | 56 | 1 |
468359 | 468359 | 2020-08-25 | Franklin | New York | 36033 | 56 | 1 |
471591 | 471591 | 2020-08-26 | Franklin | New York | 36033 | 57 | 1 |
474825 | 474825 | 2020-08-27 | Franklin | New York | 36033 | 58 | 1 |
478058 | 478058 | 2020-08-28 | Franklin | New York | 36033 | 58 | 1 |
481291 | 481291 | 2020-08-29 | Franklin | New York | 36033 | 58 | 1 |
484526 | 484526 | 2020-08-30 | Franklin | New York | 36033 | 58 | 1 |
487759 | 487759 | 2020-08-31 | Franklin | New York | 36033 | 58 | 1 |
490992 | 490992 | 2020-09-01 | Franklin | New York | 36033 | 58 | 1 |
494226 | 494226 | 2020-09-02 | Franklin | New York | 36033 | 58 | 1 |
497459 | 497459 | 2020-09-03 | Franklin | New York | 36033 | 59 | 1 |
500693 | 500693 | 2020-09-04 | Franklin | New York | 36033 | 59 | 1 |
503927 | 503927 | 2020-09-05 | Franklin | New York | 36033 | 59 | 1 |
507159 | 507159 | 2020-09-06 | Franklin | New York | 36033 | 59 | 1 |
510392 | 510392 | 2020-09-07 | Franklin | New York | 36033 | 59 | 1 |
513625 | 513625 | 2020-09-08 | Franklin | New York | 36033 | 59 | 1 |
516860 | 516860 | 2020-09-09 | Franklin | New York | 36033 | 59 | 1 |
520096 | 520096 | 2020-09-10 | Franklin | New York | 36033 | 59 | 1 |
523332 | 523332 | 2020-09-11 | Franklin | New York | 36033 | 60 | 1 |
526568 | 526568 | 2020-09-12 | Franklin | New York | 36033 | 61 | 1 |
529805 | 529805 | 2020-09-13 | Franklin | New York | 36033 | 63 | 1 |
533040 | 533040 | 2020-09-14 | Franklin | New York | 36033 | 63 | 1 |
536276 | 536276 | 2020-09-15 | Franklin | New York | 36033 | 63 | 1 |
539513 | 539513 | 2020-09-16 | Franklin | New York | 36033 | 63 | 1 |
542749 | 542749 | 2020-09-17 | Franklin | New York | 36033 | 63 | 1 |
545986 | 545986 | 2020-09-18 | Franklin | New York | 36033 | 64 | 1 |
549225 | 549225 | 2020-09-19 | Franklin | New York | 36033 | 64 | 1 |
552464 | 552464 | 2020-09-20 | Franklin | New York | 36033 | 65 | 1 |
555701 | 555701 | 2020-09-21 | Franklin | New York | 36033 | 65 | 1 |
558938 | 558938 | 2020-09-22 | Franklin | New York | 36033 | 65 | 1 |
562175 | 562175 | 2020-09-23 | Franklin | New York | 36033 | 65 | 1 |
565416 | 565416 | 2020-09-24 | Franklin | New York | 36033 | 66 | 1 |
568657 | 568657 | 2020-09-25 | Franklin | New York | 36033 | 66 | 1 |
571899 | 571899 | 2020-09-26 | Franklin | New York | 36033 | 66 | 1 |
575143 | 575143 | 2020-09-27 | Franklin | New York | 36033 | 66 | 1 |
578384 | 578384 | 2020-09-28 | Franklin | New York | 36033 | 66 | 1 |
581624 | 581624 | 2020-09-29 | Franklin | New York | 36033 | 66 | 1 |
584865 | 584865 | 2020-09-30 | Franklin | New York | 36033 | 66 | 1 |
588105 | 588105 | 2020-10-01 | Franklin | New York | 36033 | 66 | 1 |
591346 | 591346 | 2020-10-02 | Franklin | New York | 36033 | 66 | 1 |
594587 | 594587 | 2020-10-03 | Franklin | New York | 36033 | 68 | 1 |
597830 | 597830 | 2020-10-04 | Franklin | New York | 36033 | 70 | 1 |
601073 | 601073 | 2020-10-05 | Franklin | New York | 36033 | 70 | 1 |
604315 | 604315 | 2020-10-06 | Franklin | New York | 36033 | 70 | 1 |
607558 | 607558 | 2020-10-07 | Franklin | New York | 36033 | 70 | 1 |
610800 | 610800 | 2020-10-08 | Franklin | New York | 36033 | 71 | 1 |
614041 | 614041 | 2020-10-09 | Franklin | New York | 36033 | 71 | 1 |
617283 | 617283 | 2020-10-10 | Franklin | New York | 36033 | 71 | 1 |
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);