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

19,457 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 25

fips 25

county 1

  • Franklin · 19,457 ✖
Link rowid date ▲ county state fips cases deaths
2499604 2499604 2022-05-13 Franklin Alabama 1059 9903 139
2499709 2499709 2022-05-13 Franklin Arkansas 5047 3818 73
2499915 2499915 2022-05-13 Franklin Florida 12037 3087 52
2500024 2500024 2022-05-13 Franklin Georgia 13119 5414 104
2500153 2500153 2022-05-13 Franklin Idaho 16041 2331 29
2500204 2500204 2022-05-13 Franklin Illinois 17055 12272 178
2500303 2500303 2022-05-13 Franklin Indiana 18047 4390 65
2500407 2500407 2022-05-13 Franklin Iowa 19069 2521 42
2500502 2500502 2022-05-13 Franklin Kansas 20059 7018 81
2500615 2500615 2022-05-13 Franklin Kentucky 21073 13911 153
2500719 2500719 2022-05-13 Franklin Louisiana 22041 7352 178
2500767 2500767 2022-05-13 Franklin Maine 23007 6014 60
2500811 2500811 2022-05-13 Franklin Massachusetts 25011 11403 140
2501011 2501011 2022-05-13 Franklin Mississippi 28037 1927 38
2501111 2501111 2022-05-13 Franklin Missouri 29071 25852 373
2501279 2501279 2022-05-13 Franklin Nebraska 31061 413 12
2501443 2501443 2022-05-13 Franklin New York 36033 10059 46
2501520 2501520 2022-05-13 Franklin North Carolina 37069 20719 79
2501668 2501668 2022-05-13 Franklin Ohio 39049 296037 2610
2501874 2501874 2022-05-13 Franklin Pennsylvania 42055 40694 695
2502136 2502136 2022-05-13 Franklin Tennessee 47051 12908 184
2502286 2502286 2022-05-13 Franklin Texas 48159 2228 42
2502497 2502497 2022-05-13 Franklin Vermont 50011 10325 67
2502553 2502553 2022-05-13 Franklin Virginia 51067 10984 198
2502653 2502653 2022-05-13 Franklin Washington 53021 32668 214
2496346 2496346 2022-05-12 Franklin Alabama 1059 9901 139
2496451 2496451 2022-05-12 Franklin Arkansas 5047 3817 73
2496657 2496657 2022-05-12 Franklin Florida 12037 3087 52
2496766 2496766 2022-05-12 Franklin Georgia 13119 5414 104
2496895 2496895 2022-05-12 Franklin Idaho 16041 2330 29
2496946 2496946 2022-05-12 Franklin Illinois 17055 12266 178
2497045 2497045 2022-05-12 Franklin Indiana 18047 4385 65
2497149 2497149 2022-05-12 Franklin Iowa 19069 2521 42
2497244 2497244 2022-05-12 Franklin Kansas 20059 7004 81
2497357 2497357 2022-05-12 Franklin Kentucky 21073 13911 153
2497461 2497461 2022-05-12 Franklin Louisiana 22041 7349 178
2497509 2497509 2022-05-12 Franklin Maine 23007 6007 60
2497553 2497553 2022-05-12 Franklin Massachusetts 25011 11371 140
2497753 2497753 2022-05-12 Franklin Mississippi 28037 1927 38
2497853 2497853 2022-05-12 Franklin Missouri 29071 25741 372
2498021 2498021 2022-05-12 Franklin Nebraska 31061 413 12
2498185 2498185 2022-05-12 Franklin New York 36033 10059 46
2498262 2498262 2022-05-12 Franklin North Carolina 37069 20719 79
2498410 2498410 2022-05-12 Franklin Ohio 39049 296037 2610
2498616 2498616 2022-05-12 Franklin Pennsylvania 42055 40694 695
2498878 2498878 2022-05-12 Franklin Tennessee 47051 12908 184
2499028 2499028 2022-05-12 Franklin Texas 48159 2228 42
2499239 2499239 2022-05-12 Franklin Vermont 50011 10312 67
2499295 2499295 2022-05-12 Franklin Virginia 51067 10945 198
2499395 2499395 2022-05-12 Franklin Washington 53021 32654 214
2493088 2493088 2022-05-11 Franklin Alabama 1059 9900 139
2493193 2493193 2022-05-11 Franklin Arkansas 5047 3817 73
2493399 2493399 2022-05-11 Franklin Florida 12037 3087 52
2493508 2493508 2022-05-11 Franklin Georgia 13119 5414 104
2493637 2493637 2022-05-11 Franklin Idaho 16041 2330 29
2493688 2493688 2022-05-11 Franklin Illinois 17055 12261 178
2493787 2493787 2022-05-11 Franklin Indiana 18047 4385 65
2493891 2493891 2022-05-11 Franklin Iowa 19069 2521 42
2493986 2493986 2022-05-11 Franklin Kansas 20059 7004 81
2494099 2494099 2022-05-11 Franklin Kentucky 21073 13911 153
2494203 2494203 2022-05-11 Franklin Louisiana 22041 7349 178
2494251 2494251 2022-05-11 Franklin Maine 23007 5996 60
2494295 2494295 2022-05-11 Franklin Massachusetts 25011 11343 138
2494495 2494495 2022-05-11 Franklin Mississippi 28037 1927 38
2494595 2494595 2022-05-11 Franklin Missouri 29071 25741 372
2494763 2494763 2022-05-11 Franklin Nebraska 31061 413 12
2494927 2494927 2022-05-11 Franklin New York 36033 10026 46
2495004 2495004 2022-05-11 Franklin North Carolina 37069 20719 79
2495152 2495152 2022-05-11 Franklin Ohio 39049 293524 2607
2495358 2495358 2022-05-11 Franklin Pennsylvania 42055 40694 695
2495620 2495620 2022-05-11 Franklin Tennessee 47051 12908 184
2495770 2495770 2022-05-11 Franklin Texas 48159 2228 42
2495981 2495981 2022-05-11 Franklin Vermont 50011 10288 67
2496037 2496037 2022-05-11 Franklin Virginia 51067 10938 198
2496137 2496137 2022-05-11 Franklin Washington 53021 32654 214
2489830 2489830 2022-05-10 Franklin Alabama 1059 9899 139
2489935 2489935 2022-05-10 Franklin Arkansas 5047 3817 73
2490141 2490141 2022-05-10 Franklin Florida 12037 3087 52
2490250 2490250 2022-05-10 Franklin Georgia 13119 5413 103
2490379 2490379 2022-05-10 Franklin Idaho 16041 2330 29
2490430 2490430 2022-05-10 Franklin Illinois 17055 12256 178
2490529 2490529 2022-05-10 Franklin Indiana 18047 4378 65
2490633 2490633 2022-05-10 Franklin Iowa 19069 2517 42
2490728 2490728 2022-05-10 Franklin Kansas 20059 7004 81
2490841 2490841 2022-05-10 Franklin Kentucky 21073 13911 153
2490945 2490945 2022-05-10 Franklin Louisiana 22041 7349 178
2490993 2490993 2022-05-10 Franklin Maine 23007 5985 59
2491037 2491037 2022-05-10 Franklin Massachusetts 25011 11295 138
2491237 2491237 2022-05-10 Franklin Mississippi 28037 1927 38
2491337 2491337 2022-05-10 Franklin Missouri 29071 25741 372
2491505 2491505 2022-05-10 Franklin Nebraska 31061 421 12
2491669 2491669 2022-05-10 Franklin New York 36033 10015 46
2491746 2491746 2022-05-10 Franklin North Carolina 37069 20584 79
2491894 2491894 2022-05-10 Franklin Ohio 39049 293524 2607
2492100 2492100 2022-05-10 Franklin Pennsylvania 42055 40558 694
2492362 2492362 2022-05-10 Franklin Tennessee 47051 12894 184
2492512 2492512 2022-05-10 Franklin Texas 48159 2228 42
2492723 2492723 2022-05-10 Franklin Vermont 50011 10272 67
2492779 2492779 2022-05-10 Franklin Virginia 51067 10931 198
2492879 2492879 2022-05-10 Franklin Washington 53021 32645 214

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