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 301
- Ohio 301
- Indiana 298
- Washington 298
- Kentucky 297
- Massachusetts 297
- Mississippi 295
- North Carolina 295
- Pennsylvania 295
- Vermont 294
- Virginia 294
- Tennessee 293
- Alabama 291
- Missouri 291
- New York 290
- Georgia 289
- Illinois 289
- Maine 289
- Louisiana 287
- Texas 286
- Florida 281
- Iowa 278
- Arkansas 277
- Nebraska 274
- Idaho 225
fips 25
county 1
- Franklin · 7,205 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
897751 | 897751 | 2021-01-05 | Franklin | Alabama | 1059 | 3355 | 38 |
897855 | 897855 | 2021-01-05 | Franklin | Arkansas | 5047 | 1165 | 26 |
898061 | 898061 | 2021-01-05 | Franklin | Florida | 12037 | 964 | 4 |
898170 | 898170 | 2021-01-05 | Franklin | Georgia | 13119 | 1890 | 26 |
898298 | 898298 | 2021-01-05 | Franklin | Idaho | 16041 | 969 | 9 |
898349 | 898349 | 2021-01-05 | Franklin | Illinois | 17055 | 3517 | 60 |
898447 | 898447 | 2021-01-05 | Franklin | Indiana | 18047 | 1296 | 30 |
898550 | 898550 | 2021-01-05 | Franklin | Iowa | 19069 | 929 | 17 |
898645 | 898645 | 2021-01-05 | Franklin | Kansas | 20059 | 1883 | 18 |
898758 | 898758 | 2021-01-05 | Franklin | Kentucky | 21073 | 2226 | 21 |
898862 | 898862 | 2021-01-05 | Franklin | Louisiana | 22041 | 2122 | 85 |
898910 | 898910 | 2021-01-05 | Franklin | Maine | 23007 | 487 | 5 |
898954 | 898954 | 2021-01-05 | Franklin | Massachusetts | 25011 | 1338 | 92 |
899154 | 899154 | 2021-01-05 | Franklin | Mississippi | 28037 | 618 | 9 |
899253 | 899253 | 2021-01-05 | Franklin | Missouri | 29071 | 6859 | 115 |
899421 | 899421 | 2021-01-05 | Franklin | Nebraska | 31061 | 210 | 2 |
899582 | 899582 | 2021-01-05 | Franklin | New York | 36033 | 822 | 9 |
899659 | 899659 | 2021-01-05 | Franklin | North Carolina | 37069 | 3365 | 39 |
899805 | 899805 | 2021-01-05 | Franklin | Ohio | 39049 | 87784 | 700 |
900010 | 900010 | 2021-01-05 | Franklin | Pennsylvania | 42055 | 9189 | 240 |
900272 | 900272 | 2021-01-05 | Franklin | Tennessee | 47051 | 3726 | 48 |
900422 | 900422 | 2021-01-05 | Franklin | Texas | 48159 | 465 | 12 |
900632 | 900632 | 2021-01-05 | Franklin | Vermont | 50011 | 584 | 30 |
900688 | 900688 | 2021-01-05 | Franklin | Virginia | 51067 | 2463 | 24 |
900788 | 900788 | 2021-01-05 | Franklin | Washington | 53021 | 9040 | 84 |
894505 | 894505 | 2021-01-04 | Franklin | Alabama | 1059 | 3340 | 38 |
894610 | 894610 | 2021-01-04 | Franklin | Arkansas | 5047 | 1137 | 25 |
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);