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

8,432 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 · 8,432 ✖
Link rowid date ▲ county state fips cases deaths
1066517 1066517 2021-02-26 Franklin Alabama 1059 3988 76
1066621 1066621 2021-02-26 Franklin Arkansas 5047 1627 34
1066827 1066827 2021-02-26 Franklin Florida 12037 1278 14
1066936 1066936 2021-02-26 Franklin Georgia 13119 2560 42
1067064 1067064 2021-02-26 Franklin Idaho 16041 1085 14
1067115 1067115 2021-02-26 Franklin Illinois 17055 4142 77
1067214 1067214 2021-02-26 Franklin Indiana 18047 1609 36
1067317 1067317 2021-02-26 Franklin Iowa 19069 1082 19
1067412 1067412 2021-02-26 Franklin Kansas 20059 2432 37
1067525 1067525 2021-02-26 Franklin Kentucky 21073 3624 28
1067629 1067629 2021-02-26 Franklin Louisiana 22041 2428 101
1067677 1067677 2021-02-26 Franklin Maine 23007 893 12
1067720 1067720 2021-02-26 Franklin Massachusetts 25011 1969 101
1067920 1067920 2021-02-26 Franklin Mississippi 28037 756 19
1068019 1068019 2021-02-26 Franklin Missouri 29071 8409 154
1068187 1068187 2021-02-26 Franklin Nebraska 31061 232 3
1068348 1068348 2021-02-26 Franklin New York 36033 2027 12
1068425 1068425 2021-02-26 Franklin North Carolina 37069 5357 43
1068571 1068571 2021-02-26 Franklin Ohio 39049 111496 1198
1068776 1068776 2021-02-26 Franklin Pennsylvania 42055 12464 323
1069038 1069038 2021-02-26 Franklin Tennessee 47051 4714 85
1069188 1069188 2021-02-26 Franklin Texas 48159 690 24
1069398 1069398 2021-02-26 Franklin Vermont 50011 1215 35
1069454 1069454 2021-02-26 Franklin Virginia 51067 3687 51
1069554 1069554 2021-02-26 Franklin Washington 53021 11100 100
1063272 1063272 2021-02-25 Franklin Alabama 1059 3978 76
1063376 1063376 2021-02-25 Franklin Arkansas 5047 1624 34
1063582 1063582 2021-02-25 Franklin Florida 12037 1278 14
1063691 1063691 2021-02-25 Franklin Georgia 13119 2556 42
1063819 1063819 2021-02-25 Franklin Idaho 16041 1084 14
1063870 1063870 2021-02-25 Franklin Illinois 17055 4139 77
1063969 1063969 2021-02-25 Franklin Indiana 18047 1606 36
1064072 1064072 2021-02-25 Franklin Iowa 19069 1082 19
1064167 1064167 2021-02-25 Franklin Kansas 20059 2428 37
1064280 1064280 2021-02-25 Franklin Kentucky 21073 3617 28
1064384 1064384 2021-02-25 Franklin Louisiana 22041 2427 100
1064432 1064432 2021-02-25 Franklin Maine 23007 892 12
1064475 1064475 2021-02-25 Franklin Massachusetts 25011 1966 100
1064675 1064675 2021-02-25 Franklin Mississippi 28037 755 19
1064774 1064774 2021-02-25 Franklin Missouri 29071 8402 154
1064942 1064942 2021-02-25 Franklin Nebraska 31061 230 3
1065103 1065103 2021-02-25 Franklin New York 36033 2008 12
1065180 1065180 2021-02-25 Franklin North Carolina 37069 5241 43
1065326 1065326 2021-02-25 Franklin Ohio 39049 111312 1196
1065531 1065531 2021-02-25 Franklin Pennsylvania 42055 12425 321
1065793 1065793 2021-02-25 Franklin Tennessee 47051 4708 84
1065943 1065943 2021-02-25 Franklin Texas 48159 689 24
1066153 1066153 2021-02-25 Franklin Vermont 50011 1202 35
1066209 1066209 2021-02-25 Franklin Virginia 51067 3679 47
1066309 1066309 2021-02-25 Franklin Washington 53021 11083 99
1060027 1060027 2021-02-24 Franklin Alabama 1059 3976 75
1060131 1060131 2021-02-24 Franklin Arkansas 5047 1622 34
1060337 1060337 2021-02-24 Franklin Florida 12037 1277 13
1060446 1060446 2021-02-24 Franklin Georgia 13119 2553 42
1060574 1060574 2021-02-24 Franklin Idaho 16041 1081 14
1060625 1060625 2021-02-24 Franklin Illinois 17055 4134 77
1060724 1060724 2021-02-24 Franklin Indiana 18047 1602 36
1060827 1060827 2021-02-24 Franklin Iowa 19069 1082 19
1060922 1060922 2021-02-24 Franklin Kansas 20059 2428 37
1061035 1061035 2021-02-24 Franklin Kentucky 21073 3612 28
1061139 1061139 2021-02-24 Franklin Louisiana 22041 2423 100
1061187 1061187 2021-02-24 Franklin Maine 23007 887 10
1061231 1061231 2021-02-24 Franklin Massachusetts 25011 1959 100
1061431 1061431 2021-02-24 Franklin Mississippi 28037 754 19
1061530 1061530 2021-02-24 Franklin Missouri 29071 8388 154
1061698 1061698 2021-02-24 Franklin Nebraska 31061 229 3
1061859 1061859 2021-02-24 Franklin New York 36033 1996 12
1061936 1061936 2021-02-24 Franklin North Carolina 37069 5217 43
1062082 1062082 2021-02-24 Franklin Ohio 39049 111107 1193
1062286 1062286 2021-02-24 Franklin Pennsylvania 42055 12406 320
1062548 1062548 2021-02-24 Franklin Tennessee 47051 4706 84
1062698 1062698 2021-02-24 Franklin Texas 48159 687 24
1062908 1062908 2021-02-24 Franklin Vermont 50011 1193 35
1062964 1062964 2021-02-24 Franklin Virginia 51067 3675 46
1063064 1063064 2021-02-24 Franklin Washington 53021 11061 99
1056781 1056781 2021-02-23 Franklin Alabama 1059 3965 75
1056885 1056885 2021-02-23 Franklin Arkansas 5047 1617 34
1057091 1057091 2021-02-23 Franklin Florida 12037 1273 13
1057200 1057200 2021-02-23 Franklin Georgia 13119 2540 42
1057328 1057328 2021-02-23 Franklin Idaho 16041 1080 14
1057379 1057379 2021-02-23 Franklin Illinois 17055 4126 77
1057478 1057478 2021-02-23 Franklin Indiana 18047 1601 36
1057581 1057581 2021-02-23 Franklin Iowa 19069 1082 19
1057676 1057676 2021-02-23 Franklin Kansas 20059 2423 36
1057789 1057789 2021-02-23 Franklin Kentucky 21073 3609 28
1057893 1057893 2021-02-23 Franklin Louisiana 22041 2420 100
1057941 1057941 2021-02-23 Franklin Maine 23007 880 10
1057985 1057985 2021-02-23 Franklin Massachusetts 25011 1957 100
1058185 1058185 2021-02-23 Franklin Mississippi 28037 753 19
1058284 1058284 2021-02-23 Franklin Missouri 29071 8380 154
1058452 1058452 2021-02-23 Franklin Nebraska 31061 229 3
1058613 1058613 2021-02-23 Franklin New York 36033 1986 12
1058690 1058690 2021-02-23 Franklin North Carolina 37069 5195 43
1058836 1058836 2021-02-23 Franklin Ohio 39049 110938 1191
1059041 1059041 2021-02-23 Franklin Pennsylvania 42055 12370 318
1059303 1059303 2021-02-23 Franklin Tennessee 47051 4699 83
1059453 1059453 2021-02-23 Franklin Texas 48159 685 24
1059663 1059663 2021-02-23 Franklin Vermont 50011 1184 35
1059719 1059719 2021-02-23 Franklin Virginia 51067 3660 44
1059819 1059819 2021-02-23 Franklin Washington 53021 11031 98

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