ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19,457 rows where county = "Franklin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 25
- Kansas 302
- Ohio 302
- Indiana 299
- Washington 299
- Kentucky 298
- Massachusetts 298
- Mississippi 296
- North Carolina 296
- Pennsylvania 296
- Vermont 295
- Virginia 295
- Tennessee 294
- Alabama 293
- Missouri 292
- New York 291
- Georgia 290
- Illinois 290
- Maine 290
- Louisiana 288
- Texas 287
- Florida 282
- Arkansas 279
- Iowa 279
- Nebraska 275
- Idaho 226
fips 25
county 1
- Franklin · 7,232 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
910732 | 910732 | 2021-01-09 | Franklin | Alabama | 1059 | 3514 | 39 |
910836 | 910836 | 2021-01-09 | Franklin | Arkansas | 5047 | 1220 | 26 |
911042 | 911042 | 2021-01-09 | Franklin | Florida | 12037 | 1008 | 4 |
911151 | 911151 | 2021-01-09 | Franklin | Georgia | 13119 | 2008 | 29 |
911279 | 911279 | 2021-01-09 | Franklin | Idaho | 16041 | 985 | 11 |
911330 | 911330 | 2021-01-09 | Franklin | Illinois | 17055 | 3645 | 63 |
911428 | 911428 | 2021-01-09 | Franklin | Indiana | 18047 | 1363 | 31 |
911531 | 911531 | 2021-01-09 | Franklin | Iowa | 19069 | 973 | 17 |
911626 | 911626 | 2021-01-09 | Franklin | Kansas | 20059 | 2001 | 19 |
911739 | 911739 | 2021-01-09 | Franklin | Kentucky | 21073 | 2377 | 21 |
911843 | 911843 | 2021-01-09 | Franklin | Louisiana | 22041 | 2161 | 86 |
911891 | 911891 | 2021-01-09 | Franklin | Maine | 23007 | 514 | 7 |
911935 | 911935 | 2021-01-09 | Franklin | Massachusetts | 25011 | 1438 | 93 |
912135 | 912135 | 2021-01-09 | Franklin | Mississippi | 28037 | 638 | 12 |
912234 | 912234 | 2021-01-09 | Franklin | Missouri | 29071 | 7195 | 116 |
912402 | 912402 | 2021-01-09 | Franklin | Nebraska | 31061 | 213 | 3 |
912563 | 912563 | 2021-01-09 | Franklin | New York | 36033 | 905 | 9 |
912640 | 912640 | 2021-01-09 | Franklin | North Carolina | 37069 | 3668 | 39 |
912786 | 912786 | 2021-01-09 | Franklin | Ohio | 39049 | 91391 | 700 |
912991 | 912991 | 2021-01-09 | Franklin | Pennsylvania | 42055 | 9855 | 259 |
913253 | 913253 | 2021-01-09 | Franklin | Tennessee | 47051 | 3874 | 50 |
913403 | 913403 | 2021-01-09 | Franklin | Texas | 48159 | 497 | 13 |
913613 | 913613 | 2021-01-09 | Franklin | Vermont | 50011 | 625 | 32 |
913669 | 913669 | 2021-01-09 | Franklin | Virginia | 51067 | 2648 | 25 |
913769 | 913769 | 2021-01-09 | Franklin | Washington | 53021 | 9321 | 86 |
907487 | 907487 | 2021-01-08 | Franklin | Alabama | 1059 | 3462 | 39 |
907591 | 907591 | 2021-01-08 | Franklin | Arkansas | 5047 | 1207 | 26 |
907797 | 907797 | 2021-01-08 | Franklin | Florida | 12037 | 1004 | 4 |
907906 | 907906 | 2021-01-08 | Franklin | Georgia | 13119 | 1984 | 28 |
908034 | 908034 | 2021-01-08 | Franklin | Idaho | 16041 | 979 | 11 |
908085 | 908085 | 2021-01-08 | Franklin | Illinois | 17055 | 3609 | 64 |
908183 | 908183 | 2021-01-08 | Franklin | Indiana | 18047 | 1356 | 31 |
908286 | 908286 | 2021-01-08 | Franklin | Iowa | 19069 | 972 | 17 |
908381 | 908381 | 2021-01-08 | Franklin | Kansas | 20059 | 2001 | 19 |
908494 | 908494 | 2021-01-08 | Franklin | Kentucky | 21073 | 2334 | 21 |
908598 | 908598 | 2021-01-08 | Franklin | Louisiana | 22041 | 2161 | 86 |
908646 | 908646 | 2021-01-08 | Franklin | Maine | 23007 | 508 | 7 |
908690 | 908690 | 2021-01-08 | Franklin | Massachusetts | 25011 | 1418 | 93 |
908890 | 908890 | 2021-01-08 | Franklin | Mississippi | 28037 | 629 | 12 |
908989 | 908989 | 2021-01-08 | Franklin | Missouri | 29071 | 7104 | 116 |
909157 | 909157 | 2021-01-08 | Franklin | Nebraska | 31061 | 213 | 3 |
909318 | 909318 | 2021-01-08 | Franklin | New York | 36033 | 886 | 9 |
909395 | 909395 | 2021-01-08 | Franklin | North Carolina | 37069 | 3558 | 39 |
909541 | 909541 | 2021-01-08 | Franklin | Ohio | 39049 | 90416 | 700 |
909746 | 909746 | 2021-01-08 | Franklin | Pennsylvania | 42055 | 9723 | 254 |
910008 | 910008 | 2021-01-08 | Franklin | Tennessee | 47051 | 3847 | 50 |
910158 | 910158 | 2021-01-08 | Franklin | Texas | 48159 | 485 | 13 |
910368 | 910368 | 2021-01-08 | Franklin | Vermont | 50011 | 619 | 32 |
910424 | 910424 | 2021-01-08 | Franklin | Virginia | 51067 | 2594 | 25 |
910524 | 910524 | 2021-01-08 | Franklin | Washington | 53021 | 9267 | 86 |
904241 | 904241 | 2021-01-07 | Franklin | Alabama | 1059 | 3418 | 39 |
904345 | 904345 | 2021-01-07 | Franklin | Arkansas | 5047 | 1192 | 26 |
904551 | 904551 | 2021-01-07 | Franklin | Florida | 12037 | 992 | 4 |
904660 | 904660 | 2021-01-07 | Franklin | Georgia | 13119 | 1944 | 27 |
904788 | 904788 | 2021-01-07 | Franklin | Idaho | 16041 | 978 | 11 |
904839 | 904839 | 2021-01-07 | Franklin | Illinois | 17055 | 3589 | 63 |
904937 | 904937 | 2021-01-07 | Franklin | Indiana | 18047 | 1334 | 31 |
905040 | 905040 | 2021-01-07 | Franklin | Iowa | 19069 | 962 | 17 |
905135 | 905135 | 2021-01-07 | Franklin | Kansas | 20059 | 1942 | 18 |
905248 | 905248 | 2021-01-07 | Franklin | Kentucky | 21073 | 2292 | 21 |
905352 | 905352 | 2021-01-07 | Franklin | Louisiana | 22041 | 2152 | 85 |
905400 | 905400 | 2021-01-07 | Franklin | Maine | 23007 | 503 | 5 |
905444 | 905444 | 2021-01-07 | Franklin | Massachusetts | 25011 | 1382 | 93 |
905644 | 905644 | 2021-01-07 | Franklin | Mississippi | 28037 | 624 | 11 |
905743 | 905743 | 2021-01-07 | Franklin | Missouri | 29071 | 7001 | 116 |
905911 | 905911 | 2021-01-07 | Franklin | Nebraska | 31061 | 213 | 3 |
906073 | 906073 | 2021-01-07 | Franklin | New York | 36033 | 852 | 9 |
906150 | 906150 | 2021-01-07 | Franklin | North Carolina | 37069 | 3522 | 39 |
906296 | 906296 | 2021-01-07 | Franklin | Ohio | 39049 | 89439 | 700 |
906501 | 906501 | 2021-01-07 | Franklin | Pennsylvania | 42055 | 9515 | 253 |
906763 | 906763 | 2021-01-07 | Franklin | Tennessee | 47051 | 3806 | 49 |
906913 | 906913 | 2021-01-07 | Franklin | Texas | 48159 | 476 | 13 |
907123 | 907123 | 2021-01-07 | Franklin | Vermont | 50011 | 601 | 31 |
907179 | 907179 | 2021-01-07 | Franklin | Virginia | 51067 | 2528 | 25 |
907279 | 907279 | 2021-01-07 | Franklin | Washington | 53021 | 9156 | 86 |
900996 | 900996 | 2021-01-06 | Franklin | Alabama | 1059 | 3383 | 39 |
901100 | 901100 | 2021-01-06 | Franklin | Arkansas | 5047 | 1180 | 26 |
901306 | 901306 | 2021-01-06 | Franklin | Florida | 12037 | 977 | 4 |
901415 | 901415 | 2021-01-06 | Franklin | Georgia | 13119 | 1904 | 27 |
901543 | 901543 | 2021-01-06 | Franklin | Idaho | 16041 | 968 | 10 |
901594 | 901594 | 2021-01-06 | Franklin | Illinois | 17055 | 3559 | 62 |
901692 | 901692 | 2021-01-06 | Franklin | Indiana | 18047 | 1316 | 31 |
901795 | 901795 | 2021-01-06 | Franklin | Iowa | 19069 | 947 | 17 |
901890 | 901890 | 2021-01-06 | Franklin | Kansas | 20059 | 1942 | 18 |
902003 | 902003 | 2021-01-06 | Franklin | Kentucky | 21073 | 2248 | 21 |
902107 | 902107 | 2021-01-06 | Franklin | Louisiana | 22041 | 2129 | 85 |
902155 | 902155 | 2021-01-06 | Franklin | Maine | 23007 | 496 | 5 |
902199 | 902199 | 2021-01-06 | Franklin | Massachusetts | 25011 | 1356 | 92 |
902399 | 902399 | 2021-01-06 | Franklin | Mississippi | 28037 | 620 | 11 |
902498 | 902498 | 2021-01-06 | Franklin | Missouri | 29071 | 6930 | 115 |
902666 | 902666 | 2021-01-06 | Franklin | Nebraska | 31061 | 211 | 2 |
902827 | 902827 | 2021-01-06 | Franklin | New York | 36033 | 832 | 9 |
902904 | 902904 | 2021-01-06 | Franklin | North Carolina | 37069 | 3436 | 39 |
903050 | 903050 | 2021-01-06 | Franklin | Ohio | 39049 | 88447 | 700 |
903255 | 903255 | 2021-01-06 | Franklin | Pennsylvania | 42055 | 9404 | 250 |
903517 | 903517 | 2021-01-06 | Franklin | Tennessee | 47051 | 3751 | 49 |
903667 | 903667 | 2021-01-06 | Franklin | Texas | 48159 | 476 | 12 |
903877 | 903877 | 2021-01-06 | Franklin | Vermont | 50011 | 593 | 31 |
903933 | 903933 | 2021-01-06 | Franklin | Virginia | 51067 | 2494 | 24 |
904033 | 904033 | 2021-01-06 | Franklin | Washington | 53021 | 9082 | 86 |
Advanced export
JSON shape: default, array, newline-delimited
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);