ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

14,407 rows where county = "Franklin" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Franklin · 14,407 ✖
Link rowid date ▲ county state fips cases deaths
1842635 1842635 2021-10-23 Franklin Alabama 1059 5959 105
1842741 1842741 2021-10-23 Franklin Arkansas 5047 2720 52
1842947 1842947 2021-10-23 Franklin Florida 12037 2222 45
1843056 1843056 2021-10-23 Franklin Georgia 13119 3955 80
1843185 1843185 2021-10-23 Franklin Idaho 16041 1568 23
1843236 1843236 2021-10-23 Franklin Illinois 17055 7339 127
1843335 1843335 2021-10-23 Franklin Indiana 18047 2677 46
1843438 1843438 2021-10-23 Franklin Iowa 19069 1647 28
1843533 1843533 2021-10-23 Franklin Kansas 20059 3754 58
1843645 1843645 2021-10-23 Franklin Kentucky 21073 6915 76
1843749 1843749 2021-10-23 Franklin Louisiana 22041 4672 137
1843797 1843797 2021-10-23 Franklin Maine 23007 2241 23
1843841 1843841 2021-10-23 Franklin Massachusetts 25011 3409 122
1844041 1844041 2021-10-23 Franklin Mississippi 28037 1202 28
1844140 1844140 2021-10-23 Franklin Missouri 29071 14385 219
1844308 1844308 2021-10-23 Franklin Nebraska 31061 316 4
1844470 1844470 2021-10-23 Franklin New York 36033 4328 22
1844547 1844547 2021-10-23 Franklin North Carolina 37069 9819 61
1844693 1844693 2021-10-23 Franklin Ohio 39049 164265 1696
1844899 1844899 2021-10-23 Franklin Pennsylvania 42055 21477 450
1845161 1845161 2021-10-23 Franklin Tennessee 47051 7900 102
1845311 1845311 2021-10-23 Franklin Texas 48159 1321 35
1845521 1845521 2021-10-23 Franklin Vermont 50011 3067 48
1845577 1845577 2021-10-23 Franklin Virginia 51067 5971 100
1845677 1845677 2021-10-23 Franklin Washington 53021 20037 177
1839386 1839386 2021-10-22 Franklin Alabama 1059 5959 105
1839491 1839491 2021-10-22 Franklin Arkansas 5047 2718 52
1839697 1839697 2021-10-22 Franklin Florida 12037 2222 45
1839806 1839806 2021-10-22 Franklin Georgia 13119 3955 80
1839935 1839935 2021-10-22 Franklin Idaho 16041 1568 23
1839986 1839986 2021-10-22 Franklin Illinois 17055 7339 127
1840085 1840085 2021-10-22 Franklin Indiana 18047 2677 46
1840188 1840188 2021-10-22 Franklin Iowa 19069 1647 28
1840283 1840283 2021-10-22 Franklin Kansas 20059 3754 58
1840395 1840395 2021-10-22 Franklin Kentucky 21073 6915 76
1840499 1840499 2021-10-22 Franklin Louisiana 22041 4672 137
1840547 1840547 2021-10-22 Franklin Maine 23007 2224 23
1840591 1840591 2021-10-22 Franklin Massachusetts 25011 3409 122
1840791 1840791 2021-10-22 Franklin Mississippi 28037 1202 28
1840890 1840890 2021-10-22 Franklin Missouri 29071 14361 219
1841058 1841058 2021-10-22 Franklin Nebraska 31061 316 4
1841220 1841220 2021-10-22 Franklin New York 36033 4300 21
1841297 1841297 2021-10-22 Franklin North Carolina 37069 9819 61
1841443 1841443 2021-10-22 Franklin Ohio 39049 164013 1696
1841649 1841649 2021-10-22 Franklin Pennsylvania 42055 21442 450
1841911 1841911 2021-10-22 Franklin Tennessee 47051 7900 102
1842061 1842061 2021-10-22 Franklin Texas 48159 1321 35
1842271 1842271 2021-10-22 Franklin Vermont 50011 3053 48
1842327 1842327 2021-10-22 Franklin Virginia 51067 5971 100
1842427 1842427 2021-10-22 Franklin Washington 53021 20037 177
1836137 1836137 2021-10-21 Franklin Alabama 1059 5955 105
1836242 1836242 2021-10-21 Franklin Arkansas 5047 2716 51
1836448 1836448 2021-10-21 Franklin Florida 12037 2218 45
1836557 1836557 2021-10-21 Franklin Georgia 13119 3955 80
1836686 1836686 2021-10-21 Franklin Idaho 16041 1566 23
1836737 1836737 2021-10-21 Franklin Illinois 17055 7335 127
1836836 1836836 2021-10-21 Franklin Indiana 18047 2675 46
1836939 1836939 2021-10-21 Franklin Iowa 19069 1647 28
1837034 1837034 2021-10-21 Franklin Kansas 20059 3745 58
1837146 1837146 2021-10-21 Franklin Kentucky 21073 6903 76
1837250 1837250 2021-10-21 Franklin Louisiana 22041 4669 137
1837298 1837298 2021-10-21 Franklin Maine 23007 2193 23
1837342 1837342 2021-10-21 Franklin Massachusetts 25011 3397 122
1837542 1837542 2021-10-21 Franklin Mississippi 28037 1200 28
1837641 1837641 2021-10-21 Franklin Missouri 29071 14348 219
1837809 1837809 2021-10-21 Franklin Nebraska 31061 316 4
1837971 1837971 2021-10-21 Franklin New York 36033 4280 20
1838048 1838048 2021-10-21 Franklin North Carolina 37069 9807 61
1838194 1838194 2021-10-21 Franklin Ohio 39049 163686 1666
1838400 1838400 2021-10-21 Franklin Pennsylvania 42055 21375 447
1838662 1838662 2021-10-21 Franklin Tennessee 47051 7891 102
1838812 1838812 2021-10-21 Franklin Texas 48159 1318 34
1839022 1839022 2021-10-21 Franklin Vermont 50011 3043 48
1839078 1839078 2021-10-21 Franklin Virginia 51067 5957 99
1839178 1839178 2021-10-21 Franklin Washington 53021 20010 180
1832888 1832888 2021-10-20 Franklin Alabama 1059 5947 105
1832993 1832993 2021-10-20 Franklin Arkansas 5047 2715 51
1833199 1833199 2021-10-20 Franklin Florida 12037 2218 45
1833308 1833308 2021-10-20 Franklin Georgia 13119 3954 80
1833437 1833437 2021-10-20 Franklin Idaho 16041 1549 23
1833488 1833488 2021-10-20 Franklin Illinois 17055 7330 127
1833587 1833587 2021-10-20 Franklin Indiana 18047 2672 46
1833690 1833690 2021-10-20 Franklin Iowa 19069 1647 28
1833785 1833785 2021-10-20 Franklin Kansas 20059 3745 58
1833897 1833897 2021-10-20 Franklin Kentucky 21073 6882 76
1834001 1834001 2021-10-20 Franklin Louisiana 22041 4662 137
1834049 1834049 2021-10-20 Franklin Maine 23007 2159 22
1834093 1834093 2021-10-20 Franklin Massachusetts 25011 3390 122
1834293 1834293 2021-10-20 Franklin Mississippi 28037 1194 28
1834392 1834392 2021-10-20 Franklin Missouri 29071 14324 219
1834560 1834560 2021-10-20 Franklin Nebraska 31061 314 4
1834722 1834722 2021-10-20 Franklin New York 36033 4256 20
1834799 1834799 2021-10-20 Franklin North Carolina 37069 9785 61
1834945 1834945 2021-10-20 Franklin Ohio 39049 163303 1666
1835151 1835151 2021-10-20 Franklin Pennsylvania 42055 21328 444
1835413 1835413 2021-10-20 Franklin Tennessee 47051 7877 100
1835563 1835563 2021-10-20 Franklin Texas 48159 1316 34
1835773 1835773 2021-10-20 Franklin Vermont 50011 3022 48
1835829 1835829 2021-10-20 Franklin Virginia 51067 5926 98
1835929 1835929 2021-10-20 Franklin Washington 53021 19986 180

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);