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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 25
- Kansas 585
- Ohio 585
- Indiana 582
- Washington 582
- Kentucky 581
- Massachusetts 581
- Mississippi 579
- North Carolina 579
- Pennsylvania 579
- Vermont 578
- Virginia 578
- Tennessee 577
- Alabama 576
- Missouri 575
- New York 574
- Georgia 573
- Illinois 573
- Maine 573
- Louisiana 571
- Texas 570
- Florida 565
- Arkansas 562
- Iowa 562
- Nebraska 558
- Idaho 509
fips 25
county 1
- Franklin · 14,307 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1829639 | 1829639 | 2021-10-19 | Franklin | Alabama | 1059 | 5943 | 105 |
1829744 | 1829744 | 2021-10-19 | Franklin | Arkansas | 5047 | 2714 | 51 |
1829950 | 1829950 | 2021-10-19 | Franklin | Florida | 12037 | 2218 | 45 |
1830059 | 1830059 | 2021-10-19 | Franklin | Georgia | 13119 | 3951 | 79 |
1830188 | 1830188 | 2021-10-19 | Franklin | Idaho | 16041 | 1544 | 22 |
1830239 | 1830239 | 2021-10-19 | Franklin | Illinois | 17055 | 7319 | 127 |
1830338 | 1830338 | 2021-10-19 | Franklin | Indiana | 18047 | 2666 | 45 |
1830441 | 1830441 | 2021-10-19 | Franklin | Iowa | 19069 | 1638 | 28 |
1830536 | 1830536 | 2021-10-19 | Franklin | Kansas | 20059 | 3732 | 55 |
1830648 | 1830648 | 2021-10-19 | Franklin | Kentucky | 21073 | 6852 | 76 |
1830752 | 1830752 | 2021-10-19 | Franklin | Louisiana | 22041 | 4658 | 137 |
1830800 | 1830800 | 2021-10-19 | Franklin | Maine | 23007 | 2135 | 20 |
1830844 | 1830844 | 2021-10-19 | Franklin | Massachusetts | 25011 | 3378 | 122 |
1831044 | 1831044 | 2021-10-19 | Franklin | Mississippi | 28037 | 1193 | 28 |
1831143 | 1831143 | 2021-10-19 | Franklin | Missouri | 29071 | 14291 | 219 |
1831311 | 1831311 | 2021-10-19 | Franklin | Nebraska | 31061 | 314 | 6 |
1831473 | 1831473 | 2021-10-19 | Franklin | New York | 36033 | 4233 | 20 |
1831550 | 1831550 | 2021-10-19 | Franklin | North Carolina | 37069 | 9756 | 61 |
1831696 | 1831696 | 2021-10-19 | Franklin | Ohio | 39049 | 162900 | 1666 |
1831902 | 1831902 | 2021-10-19 | Franklin | Pennsylvania | 42055 | 21284 | 438 |
1832164 | 1832164 | 2021-10-19 | Franklin | Tennessee | 47051 | 7862 | 100 |
1832314 | 1832314 | 2021-10-19 | Franklin | Texas | 48159 | 1316 | 34 |
1832524 | 1832524 | 2021-10-19 | Franklin | Vermont | 50011 | 3015 | 48 |
1832580 | 1832580 | 2021-10-19 | Franklin | Virginia | 51067 | 5894 | 98 |
1832680 | 1832680 | 2021-10-19 | Franklin | Washington | 53021 | 19942 | 180 |
1826390 | 1826390 | 2021-10-18 | Franklin | Alabama | 1059 | 5936 | 105 |
1826495 | 1826495 | 2021-10-18 | Franklin | Arkansas | 5047 | 2706 | 51 |
1826701 | 1826701 | 2021-10-18 | Franklin | Florida | 12037 | 2218 | 45 |
1826810 | 1826810 | 2021-10-18 | Franklin | Georgia | 13119 | 3943 | 78 |
1826939 | 1826939 | 2021-10-18 | Franklin | Idaho | 16041 | 1543 | 22 |
1826990 | 1826990 | 2021-10-18 | Franklin | Illinois | 17055 | 7317 | 127 |
1827089 | 1827089 | 2021-10-18 | Franklin | Indiana | 18047 | 2661 | 45 |
1827192 | 1827192 | 2021-10-18 | Franklin | Iowa | 19069 | 1638 | 28 |
1827287 | 1827287 | 2021-10-18 | Franklin | Kansas | 20059 | 3732 | 55 |
1827399 | 1827399 | 2021-10-18 | Franklin | Kentucky | 21073 | 6833 | 76 |
1827503 | 1827503 | 2021-10-18 | Franklin | Louisiana | 22041 | 4658 | 137 |
1827551 | 1827551 | 2021-10-18 | Franklin | Maine | 23007 | 2114 | 20 |
1827595 | 1827595 | 2021-10-18 | Franklin | Massachusetts | 25011 | 3371 | 122 |
1827795 | 1827795 | 2021-10-18 | Franklin | Mississippi | 28037 | 1191 | 28 |
1827894 | 1827894 | 2021-10-18 | Franklin | Missouri | 29071 | 14262 | 214 |
1828062 | 1828062 | 2021-10-18 | Franklin | Nebraska | 31061 | 313 | 6 |
1828224 | 1828224 | 2021-10-18 | Franklin | New York | 36033 | 4218 | 20 |
1828301 | 1828301 | 2021-10-18 | Franklin | North Carolina | 37069 | 9745 | 60 |
1828447 | 1828447 | 2021-10-18 | Franklin | Ohio | 39049 | 162629 | 1662 |
1828653 | 1828653 | 2021-10-18 | Franklin | Pennsylvania | 42055 | 21165 | 436 |
1828915 | 1828915 | 2021-10-18 | Franklin | Tennessee | 47051 | 7854 | 100 |
1829065 | 1829065 | 2021-10-18 | Franklin | Texas | 48159 | 1306 | 34 |
1829275 | 1829275 | 2021-10-18 | Franklin | Vermont | 50011 | 3004 | 48 |
1829331 | 1829331 | 2021-10-18 | Franklin | Virginia | 51067 | 5882 | 98 |
1829431 | 1829431 | 2021-10-18 | Franklin | Washington | 53021 | 19811 | 178 |
1823141 | 1823141 | 2021-10-17 | Franklin | Alabama | 1059 | 5935 | 105 |
1823246 | 1823246 | 2021-10-17 | Franklin | Arkansas | 5047 | 2705 | 51 |
1823452 | 1823452 | 2021-10-17 | Franklin | Florida | 12037 | 2218 | 45 |
1823561 | 1823561 | 2021-10-17 | Franklin | Georgia | 13119 | 3934 | 77 |
1823690 | 1823690 | 2021-10-17 | Franklin | Idaho | 16041 | 1538 | 22 |
1823741 | 1823741 | 2021-10-17 | Franklin | Illinois | 17055 | 7276 | 126 |
1823840 | 1823840 | 2021-10-17 | Franklin | Indiana | 18047 | 2648 | 45 |
1823943 | 1823943 | 2021-10-17 | Franklin | Iowa | 19069 | 1638 | 28 |
1824038 | 1824038 | 2021-10-17 | Franklin | Kansas | 20059 | 3724 | 55 |
1824150 | 1824150 | 2021-10-17 | Franklin | Kentucky | 21073 | 6786 | 75 |
1824254 | 1824254 | 2021-10-17 | Franklin | Louisiana | 22041 | 4646 | 137 |
1824302 | 1824302 | 2021-10-17 | Franklin | Maine | 23007 | 2114 | 20 |
1824346 | 1824346 | 2021-10-17 | Franklin | Massachusetts | 25011 | 3356 | 122 |
1824546 | 1824546 | 2021-10-17 | Franklin | Mississippi | 28037 | 1191 | 28 |
1824645 | 1824645 | 2021-10-17 | Franklin | Missouri | 29071 | 14257 | 214 |
1824813 | 1824813 | 2021-10-17 | Franklin | Nebraska | 31061 | 310 | 6 |
1824975 | 1824975 | 2021-10-17 | Franklin | New York | 36033 | 4179 | 20 |
1825052 | 1825052 | 2021-10-17 | Franklin | North Carolina | 37069 | 9701 | 60 |
1825198 | 1825198 | 2021-10-17 | Franklin | Ohio | 39049 | 162448 | 1662 |
1825404 | 1825404 | 2021-10-17 | Franklin | Pennsylvania | 42055 | 21138 | 432 |
1825666 | 1825666 | 2021-10-17 | Franklin | Tennessee | 47051 | 7838 | 100 |
1825816 | 1825816 | 2021-10-17 | Franklin | Texas | 48159 | 1306 | 34 |
1826026 | 1826026 | 2021-10-17 | Franklin | Vermont | 50011 | 2987 | 47 |
1826082 | 1826082 | 2021-10-17 | Franklin | Virginia | 51067 | 5840 | 98 |
1826182 | 1826182 | 2021-10-17 | Franklin | Washington | 53021 | 19811 | 178 |
1819892 | 1819892 | 2021-10-16 | Franklin | Alabama | 1059 | 5930 | 105 |
1819997 | 1819997 | 2021-10-16 | Franklin | Arkansas | 5047 | 2704 | 51 |
1820203 | 1820203 | 2021-10-16 | Franklin | Florida | 12037 | 2218 | 45 |
1820312 | 1820312 | 2021-10-16 | Franklin | Georgia | 13119 | 3934 | 77 |
1820441 | 1820441 | 2021-10-16 | Franklin | Idaho | 16041 | 1538 | 22 |
1820492 | 1820492 | 2021-10-16 | Franklin | Illinois | 17055 | 7276 | 126 |
1820591 | 1820591 | 2021-10-16 | Franklin | Indiana | 18047 | 2648 | 45 |
1820694 | 1820694 | 2021-10-16 | Franklin | Iowa | 19069 | 1638 | 28 |
1820789 | 1820789 | 2021-10-16 | Franklin | Kansas | 20059 | 3724 | 55 |
1820901 | 1820901 | 2021-10-16 | Franklin | Kentucky | 21073 | 6786 | 75 |
1821005 | 1821005 | 2021-10-16 | Franklin | Louisiana | 22041 | 4646 | 137 |
1821053 | 1821053 | 2021-10-16 | Franklin | Maine | 23007 | 2114 | 20 |
1821097 | 1821097 | 2021-10-16 | Franklin | Massachusetts | 25011 | 3356 | 122 |
1821297 | 1821297 | 2021-10-16 | Franklin | Mississippi | 28037 | 1191 | 28 |
1821396 | 1821396 | 2021-10-16 | Franklin | Missouri | 29071 | 14230 | 214 |
1821564 | 1821564 | 2021-10-16 | Franklin | Nebraska | 31061 | 310 | 6 |
1821726 | 1821726 | 2021-10-16 | Franklin | New York | 36033 | 4153 | 20 |
1821803 | 1821803 | 2021-10-16 | Franklin | North Carolina | 37069 | 9701 | 60 |
1821949 | 1821949 | 2021-10-16 | Franklin | Ohio | 39049 | 162302 | 1662 |
1822155 | 1822155 | 2021-10-16 | Franklin | Pennsylvania | 42055 | 21081 | 432 |
1822417 | 1822417 | 2021-10-16 | Franklin | Tennessee | 47051 | 7838 | 100 |
1822567 | 1822567 | 2021-10-16 | Franklin | Texas | 48159 | 1306 | 34 |
1822777 | 1822777 | 2021-10-16 | Franklin | Vermont | 50011 | 2967 | 47 |
1822833 | 1822833 | 2021-10-16 | Franklin | Virginia | 51067 | 5840 | 98 |
1822933 | 1822933 | 2021-10-16 | Franklin | Washington | 53021 | 19811 | 178 |
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);