ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19,457 rows where county = "Franklin" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 25
- Kansas 791
- Ohio 791
- Indiana 788
- Washington 788
- Kentucky 787
- Massachusetts 787
- Mississippi 785
- North Carolina 785
- Pennsylvania 785
- Vermont 784
- Virginia 784
- Tennessee 783
- Missouri 781
- New York 780
- Georgia 779
- Illinois 779
- Maine 779
- Louisiana 777
- Texas 776
- Florida 771
- Arkansas 768
- Iowa 768
- Nebraska 764
- Idaho 715
- Alabama 682
fips 25
county 1
- Franklin · 19,357 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
290259 | 290259 | 2020-07-01 | Franklin | Alabama | 1059 | 856 | 13 |
293412 | 293412 | 2020-07-02 | Franklin | Alabama | 1059 | 867 | 14 |
296567 | 296567 | 2020-07-03 | Franklin | Alabama | 1059 | 883 | 14 |
299729 | 299729 | 2020-07-04 | Franklin | Alabama | 1059 | 894 | 14 |
302893 | 302893 | 2020-07-05 | Franklin | Alabama | 1059 | 900 | 14 |
306057 | 306057 | 2020-07-06 | Franklin | Alabama | 1059 | 903 | 14 |
309226 | 309226 | 2020-07-07 | Franklin | Alabama | 1059 | 907 | 16 |
312395 | 312395 | 2020-07-08 | Franklin | Alabama | 1059 | 911 | 16 |
315570 | 315570 | 2020-07-09 | Franklin | Alabama | 1059 | 927 | 16 |
318743 | 318743 | 2020-07-10 | Franklin | Alabama | 1059 | 933 | 16 |
321922 | 321922 | 2020-07-11 | Franklin | Alabama | 1059 | 937 | 16 |
325103 | 325103 | 2020-07-12 | Franklin | Alabama | 1059 | 943 | 16 |
328289 | 328289 | 2020-07-13 | Franklin | Alabama | 1059 | 955 | 16 |
331475 | 331475 | 2020-07-14 | Franklin | Alabama | 1059 | 965 | 16 |
334668 | 334668 | 2020-07-15 | Franklin | Alabama | 1059 | 975 | 16 |
337863 | 337863 | 2020-07-16 | Franklin | Alabama | 1059 | 984 | 16 |
341059 | 341059 | 2020-07-17 | Franklin | Alabama | 1059 | 1001 | 16 |
344258 | 344258 | 2020-07-18 | Franklin | Alabama | 1059 | 1016 | 16 |
347458 | 347458 | 2020-07-19 | Franklin | Alabama | 1059 | 1025 | 16 |
350659 | 350659 | 2020-07-20 | Franklin | Alabama | 1059 | 1032 | 16 |
353861 | 353861 | 2020-07-21 | Franklin | Alabama | 1059 | 1043 | 16 |
357064 | 357064 | 2020-07-22 | Franklin | Alabama | 1059 | 1050 | 17 |
360269 | 360269 | 2020-07-23 | Franklin | Alabama | 1059 | 1057 | 17 |
363475 | 363475 | 2020-07-24 | Franklin | Alabama | 1059 | 1072 | 17 |
366682 | 366682 | 2020-07-25 | Franklin | Alabama | 1059 | 1083 | 17 |
369892 | 369892 | 2020-07-26 | Franklin | Alabama | 1059 | 1088 | 19 |
373104 | 373104 | 2020-07-27 | Franklin | Alabama | 1059 | 1110 | 20 |
376318 | 376318 | 2020-07-28 | Franklin | Alabama | 1059 | 1117 | 20 |
379534 | 379534 | 2020-07-29 | Franklin | Alabama | 1059 | 1129 | 20 |
382751 | 382751 | 2020-07-30 | Franklin | Alabama | 1059 | 1156 | 20 |
385969 | 385969 | 2020-07-31 | Franklin | Alabama | 1059 | 1174 | 20 |
389186 | 389186 | 2020-08-01 | Franklin | Alabama | 1059 | 1177 | 20 |
392403 | 392403 | 2020-08-02 | Franklin | Alabama | 1059 | 1198 | 20 |
395619 | 395619 | 2020-08-03 | Franklin | Alabama | 1059 | 1213 | 20 |
398835 | 398835 | 2020-08-04 | Franklin | Alabama | 1059 | 1223 | 20 |
402051 | 402051 | 2020-08-05 | Franklin | Alabama | 1059 | 1232 | 20 |
405269 | 405269 | 2020-08-06 | Franklin | Alabama | 1059 | 1255 | 20 |
408489 | 408489 | 2020-08-07 | Franklin | Alabama | 1059 | 1275 | 20 |
411708 | 411708 | 2020-08-08 | Franklin | Alabama | 1059 | 1288 | 20 |
414928 | 414928 | 2020-08-09 | Franklin | Alabama | 1059 | 1292 | 20 |
418149 | 418149 | 2020-08-10 | Franklin | Alabama | 1059 | 1306 | 20 |
421370 | 421370 | 2020-08-11 | Franklin | Alabama | 1059 | 1314 | 22 |
424591 | 424591 | 2020-08-12 | Franklin | Alabama | 1059 | 1325 | 22 |
427815 | 427815 | 2020-08-13 | Franklin | Alabama | 1059 | 1327 | 22 |
431043 | 431043 | 2020-08-14 | Franklin | Alabama | 1059 | 1332 | 22 |
434268 | 434268 | 2020-08-15 | Franklin | Alabama | 1059 | 1341 | 22 |
437494 | 437494 | 2020-08-16 | Franklin | Alabama | 1059 | 1367 | 22 |
440720 | 440720 | 2020-08-17 | Franklin | Alabama | 1059 | 1377 | 22 |
443946 | 443946 | 2020-08-18 | Franklin | Alabama | 1059 | 1391 | 22 |
447173 | 447173 | 2020-08-19 | Franklin | Alabama | 1059 | 1402 | 22 |
450401 | 450401 | 2020-08-20 | Franklin | Alabama | 1059 | 1428 | 22 |
453629 | 453629 | 2020-08-21 | Franklin | Alabama | 1059 | 1440 | 22 |
456857 | 456857 | 2020-08-22 | Franklin | Alabama | 1059 | 1445 | 22 |
460084 | 460084 | 2020-08-23 | Franklin | Alabama | 1059 | 1454 | 22 |
463313 | 463313 | 2020-08-24 | Franklin | Alabama | 1059 | 1476 | 22 |
466542 | 466542 | 2020-08-25 | Franklin | Alabama | 1059 | 1480 | 24 |
469771 | 469771 | 2020-08-26 | Franklin | Alabama | 1059 | 1490 | 24 |
473003 | 473003 | 2020-08-27 | Franklin | Alabama | 1059 | 1500 | 25 |
476236 | 476236 | 2020-08-28 | Franklin | Alabama | 1059 | 1531 | 26 |
479469 | 479469 | 2020-08-29 | Franklin | Alabama | 1059 | 1554 | 27 |
482703 | 482703 | 2020-08-30 | Franklin | Alabama | 1059 | 1562 | 27 |
485938 | 485938 | 2020-08-31 | Franklin | Alabama | 1059 | 1565 | 27 |
489171 | 489171 | 2020-09-01 | Franklin | Alabama | 1059 | 1567 | 27 |
492404 | 492404 | 2020-09-02 | Franklin | Alabama | 1059 | 1580 | 27 |
495638 | 495638 | 2020-09-03 | Franklin | Alabama | 1059 | 1597 | 27 |
498871 | 498871 | 2020-09-04 | Franklin | Alabama | 1059 | 1608 | 27 |
502105 | 502105 | 2020-09-05 | Franklin | Alabama | 1059 | 1620 | 27 |
505339 | 505339 | 2020-09-06 | Franklin | Alabama | 1059 | 1621 | 27 |
508571 | 508571 | 2020-09-07 | Franklin | Alabama | 1059 | 1628 | 27 |
511804 | 511804 | 2020-09-08 | Franklin | Alabama | 1059 | 1629 | 27 |
515037 | 515037 | 2020-09-09 | Franklin | Alabama | 1059 | 1650 | 27 |
518272 | 518272 | 2020-09-10 | Franklin | Alabama | 1059 | 1653 | 28 |
521509 | 521509 | 2020-09-11 | Franklin | Alabama | 1059 | 1662 | 28 |
524745 | 524745 | 2020-09-12 | Franklin | Alabama | 1059 | 1672 | 28 |
527981 | 527981 | 2020-09-13 | Franklin | Alabama | 1059 | 1693 | 28 |
531218 | 531218 | 2020-09-14 | Franklin | Alabama | 1059 | 1693 | 28 |
534453 | 534453 | 2020-09-15 | Franklin | Alabama | 1059 | 1694 | 28 |
537689 | 537689 | 2020-09-16 | Franklin | Alabama | 1059 | 1703 | 28 |
540926 | 540926 | 2020-09-17 | Franklin | Alabama | 1059 | 1727 | 28 |
544162 | 544162 | 2020-09-18 | Franklin | Alabama | 1059 | 1734 | 28 |
547399 | 547399 | 2020-09-19 | Franklin | Alabama | 1059 | 1741 | 28 |
550638 | 550638 | 2020-09-20 | Franklin | Alabama | 1059 | 1743 | 28 |
553877 | 553877 | 2020-09-21 | Franklin | Alabama | 1059 | 1745 | 28 |
557114 | 557114 | 2020-09-22 | Franklin | Alabama | 1059 | 1748 | 28 |
560350 | 560350 | 2020-09-23 | Franklin | Alabama | 1059 | 1752 | 29 |
563589 | 563589 | 2020-09-24 | Franklin | Alabama | 1059 | 1755 | 29 |
566830 | 566830 | 2020-09-25 | Franklin | Alabama | 1059 | 1767 | 29 |
570071 | 570071 | 2020-09-26 | Franklin | Alabama | 1059 | 1771 | 29 |
573313 | 573313 | 2020-09-27 | Franklin | Alabama | 1059 | 1781 | 29 |
576557 | 576557 | 2020-09-28 | Franklin | Alabama | 1059 | 1790 | 29 |
579798 | 579798 | 2020-09-29 | Franklin | Alabama | 1059 | 1791 | 30 |
583037 | 583037 | 2020-09-30 | Franklin | Alabama | 1059 | 1794 | 30 |
586277 | 586277 | 2020-10-01 | Franklin | Alabama | 1059 | 1808 | 30 |
589518 | 589518 | 2020-10-02 | Franklin | Alabama | 1059 | 1819 | 30 |
592758 | 592758 | 2020-10-03 | Franklin | Alabama | 1059 | 1836 | 30 |
596000 | 596000 | 2020-10-04 | Franklin | Alabama | 1059 | 1842 | 30 |
599243 | 599243 | 2020-10-05 | Franklin | Alabama | 1059 | 1850 | 30 |
602486 | 602486 | 2020-10-06 | Franklin | Alabama | 1059 | 1856 | 30 |
605728 | 605728 | 2020-10-07 | Franklin | Alabama | 1059 | 1868 | 30 |
608971 | 608971 | 2020-10-08 | Franklin | Alabama | 1059 | 1871 | 30 |
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);