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

7,332 rows where county = "Franklin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state

fips

county

  • Franklin · 7,332 ✖
Link rowid date ▲ county state fips cases deaths
923792 923792 2021-01-13 Franklin Alabama 1059 3597 42
923896 923896 2021-01-13 Franklin Arkansas 5047 1300 26
924102 924102 2021-01-13 Franklin Florida 12037 1058 4
924211 924211 2021-01-13 Franklin Georgia 13119 2086 30
924339 924339 2021-01-13 Franklin Idaho 16041 992 12
924390 924390 2021-01-13 Franklin Illinois 17055 3732 65
924488 924488 2021-01-13 Franklin Indiana 18047 1403 34
924591 924591 2021-01-13 Franklin Iowa 19069 992 18
924686 924686 2021-01-13 Franklin Kansas 20059 2059 19
924799 924799 2021-01-13 Franklin Kentucky 21073 2471 22
924903 924903 2021-01-13 Franklin Louisiana 22041 2200 91
924951 924951 2021-01-13 Franklin Maine 23007 539 7
924995 924995 2021-01-13 Franklin Massachusetts 25011 1510 94
925195 925195 2021-01-13 Franklin Mississippi 28037 643 13
925294 925294 2021-01-13 Franklin Missouri 29071 7381 122
925462 925462 2021-01-13 Franklin Nebraska 31061 214 3
925624 925624 2021-01-13 Franklin New York 36033 984 9
925701 925701 2021-01-13 Franklin North Carolina 37069 3858 39
925847 925847 2021-01-13 Franklin Ohio 39049 94591 702
926052 926052 2021-01-13 Franklin Pennsylvania 42055 10263 265
926314 926314 2021-01-13 Franklin Tennessee 47051 3970 53
926464 926464 2021-01-13 Franklin Texas 48159 535 15
926674 926674 2021-01-13 Franklin Vermont 50011 640 32
926730 926730 2021-01-13 Franklin Virginia 51067 2788 28
926830 926830 2021-01-13 Franklin Washington 53021 9526 87
920547 920547 2021-01-12 Franklin Alabama 1059 3571 42
920651 920651 2021-01-12 Franklin Arkansas 5047 1292 26
920857 920857 2021-01-12 Franklin Florida 12037 1048 4
920966 920966 2021-01-12 Franklin Georgia 13119 2071 30
921094 921094 2021-01-12 Franklin Idaho 16041 991 12
921145 921145 2021-01-12 Franklin Illinois 17055 3693 65
921243 921243 2021-01-12 Franklin Indiana 18047 1391 33
921346 921346 2021-01-12 Franklin Iowa 19069 989 18
921441 921441 2021-01-12 Franklin Kansas 20059 2038 19
921554 921554 2021-01-12 Franklin Kentucky 21073 2435 22
921658 921658 2021-01-12 Franklin Louisiana 22041 2194 87
921706 921706 2021-01-12 Franklin Maine 23007 525 7
921750 921750 2021-01-12 Franklin Massachusetts 25011 1490 94
921950 921950 2021-01-12 Franklin Mississippi 28037 640 13
922049 922049 2021-01-12 Franklin Missouri 29071 7339 122
922217 922217 2021-01-12 Franklin Nebraska 31061 214 3
922378 922378 2021-01-12 Franklin New York 36033 972 9
922455 922455 2021-01-12 Franklin North Carolina 37069 3827 39
922601 922601 2021-01-12 Franklin Ohio 39049 93903 702
922806 922806 2021-01-12 Franklin Pennsylvania 42055 10180 261
923068 923068 2021-01-12 Franklin Tennessee 47051 3941 51
923218 923218 2021-01-12 Franklin Texas 48159 526 15
923428 923428 2021-01-12 Franklin Vermont 50011 640 32
923484 923484 2021-01-12 Franklin Virginia 51067 2746 27
923584 923584 2021-01-12 Franklin Washington 53021 9477 87
917302 917302 2021-01-11 Franklin Alabama 1059 3552 39
917406 917406 2021-01-11 Franklin Arkansas 5047 1259 26
917612 917612 2021-01-11 Franklin Florida 12037 1022 4
917721 917721 2021-01-11 Franklin Georgia 13119 2044 29
917849 917849 2021-01-11 Franklin Idaho 16041 988 11
917900 917900 2021-01-11 Franklin Illinois 17055 3685 64
917998 917998 2021-01-11 Franklin Indiana 18047 1384 31
918101 918101 2021-01-11 Franklin Iowa 19069 981 17
918196 918196 2021-01-11 Franklin Kansas 20059 2038 19
918309 918309 2021-01-11 Franklin Kentucky 21073 2426 22
918413 918413 2021-01-11 Franklin Louisiana 22041 2184 87
918461 918461 2021-01-11 Franklin Maine 23007 514 7
918505 918505 2021-01-11 Franklin Massachusetts 25011 1472 93
918705 918705 2021-01-11 Franklin Mississippi 28037 640 12
918804 918804 2021-01-11 Franklin Missouri 29071 7305 116
918972 918972 2021-01-11 Franklin Nebraska 31061 214 3
919133 919133 2021-01-11 Franklin New York 36033 946 9
919210 919210 2021-01-11 Franklin North Carolina 37069 3743 39
919356 919356 2021-01-11 Franklin Ohio 39049 93057 701
919561 919561 2021-01-11 Franklin Pennsylvania 42055 10035 261
919823 919823 2021-01-11 Franklin Tennessee 47051 3925 51
919973 919973 2021-01-11 Franklin Texas 48159 520 15
920183 920183 2021-01-11 Franklin Vermont 50011 633 32
920239 920239 2021-01-11 Franklin Virginia 51067 2716 25
920339 920339 2021-01-11 Franklin Washington 53021 9432 86
914057 914057 2021-01-10 Franklin Alabama 1059 3530 39
914161 914161 2021-01-10 Franklin Arkansas 5047 1249 26
914367 914367 2021-01-10 Franklin Florida 12037 1017 4
914476 914476 2021-01-10 Franklin Georgia 13119 2023 29
914604 914604 2021-01-10 Franklin Idaho 16041 985 11
914655 914655 2021-01-10 Franklin Illinois 17055 3665 64
914753 914753 2021-01-10 Franklin Indiana 18047 1376 31
914856 914856 2021-01-10 Franklin Iowa 19069 980 17
914951 914951 2021-01-10 Franklin Kansas 20059 2001 19
915064 915064 2021-01-10 Franklin Kentucky 21073 2413 22
915168 915168 2021-01-10 Franklin Louisiana 22041 2178 87
915216 915216 2021-01-10 Franklin Maine 23007 514 7
915260 915260 2021-01-10 Franklin Massachusetts 25011 1458 93
915460 915460 2021-01-10 Franklin Mississippi 28037 639 12
915559 915559 2021-01-10 Franklin Missouri 29071 7267 116
915727 915727 2021-01-10 Franklin Nebraska 31061 214 3
915888 915888 2021-01-10 Franklin New York 36033 924 9
915965 915965 2021-01-10 Franklin North Carolina 37069 3691 39
916111 916111 2021-01-10 Franklin Ohio 39049 92060 700
916316 916316 2021-01-10 Franklin Pennsylvania 42055 9952 261
916578 916578 2021-01-10 Franklin Tennessee 47051 3913 51
916728 916728 2021-01-10 Franklin Texas 48159 507 15
916938 916938 2021-01-10 Franklin Vermont 50011 631 32
916994 916994 2021-01-10 Franklin Virginia 51067 2686 25
917094 917094 2021-01-10 Franklin Washington 53021 9321 86

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