ny_times_us_counties

⚠️ 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

2,782 rows where county = "Franklin" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

  • Franklin · 2,782
Link rowid date ▲ county state fips cases deaths
334405 2020-07-15 Franklin Alabama 1059 975 16
334508 2020-07-15 Franklin Arkansas 5047 34 1
334711 2020-07-15 Franklin Florida 12037 47 0
334820 2020-07-15 Franklin Georgia 13119 272 1
334945 2020-07-15 Franklin Idaho 16041 34 0
334995 2020-07-15 Franklin Illinois 17055 54 0
335094 2020-07-15 Franklin Indiana 18047 140 9
335197 2020-07-15 Franklin Iowa 19069 117 0
335292 2020-07-15 Franklin Kansas 20059 104 1
335401 2020-07-15 Franklin Kentucky 21073 169 4
335505 2020-07-15 Franklin Louisiana 22041 580 14
335553 2020-07-15 Franklin Maine 23007 41 1
335597 2020-07-15 Franklin Massachusetts 25011 385 58
335796 2020-07-15 Franklin Mississippi 28037 60 2
335895 2020-07-15 Franklin Missouri 29071 317 18
336047 2020-07-15 Franklin Nebraska 31061 8 0
336199 2020-07-15 Franklin New York 36033 37 0
336276 2020-07-15 Franklin North Carolina 37069 533 22
336421 2020-07-15 Franklin Ohio 39049 12823 449
336623 2020-07-15 Franklin Pennsylvania 42055 1019 46
336883 2020-07-15 Franklin Tennessee 47051 127 3
337032 2020-07-15 Franklin Texas 48159 61 1
337236 2020-07-15 Franklin Vermont 50011 110 6
337290 2020-07-15 Franklin Virginia 51067 115 1
337390 2020-07-15 Franklin Washington 53021 2690 42
331214 2020-07-14 Franklin Alabama 1059 965 16
331317 2020-07-14 Franklin Arkansas 5047 34 1
331520 2020-07-14 Franklin Florida 12037 45 0
331629 2020-07-14 Franklin Georgia 13119 270 1
331754 2020-07-14 Franklin Idaho 16041 34 0
331804 2020-07-14 Franklin Illinois 17055 50 0
331903 2020-07-14 Franklin Indiana 18047 136 9
332006 2020-07-14 Franklin Iowa 19069 117 0
332101 2020-07-14 Franklin Kansas 20059 96 1
332210 2020-07-14 Franklin Kentucky 21073 168 4
332314 2020-07-14 Franklin Louisiana 22041 575 14
332362 2020-07-14 Franklin Maine 23007 41 1
332406 2020-07-14 Franklin Massachusetts 25011 384 57
332605 2020-07-14 Franklin Mississippi 28037 58 2
332704 2020-07-14 Franklin Missouri 29071 305 18
332855 2020-07-14 Franklin Nebraska 31061 8 0
333007 2020-07-14 Franklin New York 36033 36 0
333084 2020-07-14 Franklin North Carolina 37069 518 22
333229 2020-07-14 Franklin Ohio 39049 12574 449
333431 2020-07-14 Franklin Pennsylvania 42055 1016 46
333691 2020-07-14 Franklin Tennessee 47051 124 3
333839 2020-07-14 Franklin Texas 48159 61 1
334043 2020-07-14 Franklin Vermont 50011 110 6
334097 2020-07-14 Franklin Virginia 51067 114 1
334197 2020-07-14 Franklin Washington 53021 2642 39
328030 2020-07-13 Franklin Alabama 1059 955 16
328133 2020-07-13 Franklin Arkansas 5047 33 1
328335 2020-07-13 Franklin Florida 12037 44 0
328444 2020-07-13 Franklin Georgia 13119 266 1
328569 2020-07-13 Franklin Idaho 16041 34 0
328619 2020-07-13 Franklin Illinois 17055 46 0
328718 2020-07-13 Franklin Indiana 18047 136 9
328821 2020-07-13 Franklin Iowa 19069 113 0
328916 2020-07-13 Franklin Kansas 20059 96 1
329025 2020-07-13 Franklin Kentucky 21073 164 4
329129 2020-07-13 Franklin Louisiana 22041 568 14
329177 2020-07-13 Franklin Maine 23007 42 1
329221 2020-07-13 Franklin Massachusetts 25011 384 57
329420 2020-07-13 Franklin Mississippi 28037 57 2
329519 2020-07-13 Franklin Missouri 29071 283 18
329667 2020-07-13 Franklin Nebraska 31061 8 0
329819 2020-07-13 Franklin New York 36033 36 0
329896 2020-07-13 Franklin North Carolina 37069 504 21
330039 2020-07-13 Franklin Ohio 39049 12301 449
330241 2020-07-13 Franklin Pennsylvania 42055 1006 46
330501 2020-07-13 Franklin Tennessee 47051 122 3
330650 2020-07-13 Franklin Texas 48159 58 1
330852 2020-07-13 Franklin Vermont 50011 110 6
330906 2020-07-13 Franklin Virginia 51067 106 1
331006 2020-07-13 Franklin Washington 53021 2600 38
324846 2020-07-12 Franklin Alabama 1059 943 16
324949 2020-07-12 Franklin Arkansas 5047 30 1
325151 2020-07-12 Franklin Florida 12037 33 0
325260 2020-07-12 Franklin Georgia 13119 261 1
325385 2020-07-12 Franklin Idaho 16041 34 0
325435 2020-07-12 Franklin Illinois 17055 46 0
325534 2020-07-12 Franklin Indiana 18047 136 9
325637 2020-07-12 Franklin Iowa 19069 112 0
325732 2020-07-12 Franklin Kansas 20059 90 1
325841 2020-07-12 Franklin Kentucky 21073 163 4
325945 2020-07-12 Franklin Louisiana 22041 558 14
325993 2020-07-12 Franklin Maine 23007 42 1
326037 2020-07-12 Franklin Massachusetts 25011 384 57
326236 2020-07-12 Franklin Mississippi 28037 54 2
326335 2020-07-12 Franklin Missouri 29071 279 18
326482 2020-07-12 Franklin Nebraska 31061 8 0
326634 2020-07-12 Franklin New York 36033 36 0
326711 2020-07-12 Franklin North Carolina 37069 480 21
326854 2020-07-12 Franklin Ohio 39049 12035 447
327057 2020-07-12 Franklin Pennsylvania 42055 1003 46
327317 2020-07-12 Franklin Tennessee 47051 116 3
327466 2020-07-12 Franklin Texas 48159 57 1
327668 2020-07-12 Franklin Vermont 50011 110 6
327722 2020-07-12 Franklin Virginia 51067 106 1
327822 2020-07-12 Franklin Washington 53021 2409 36

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
);
Powered by Datasette · Query took 1127.511ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette