ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,432 rows where county = "Franklin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state
- Kansas 350
- Ohio 350
- Indiana 347
- Washington 347
- Kentucky 346
- Massachusetts 346
- Mississippi 344
- North Carolina 344
- Pennsylvania 344
- Vermont 343
- Virginia 343
- Tennessee 342
- Alabama 341
- Missouri 340
- New York 339
- Georgia 338
- Illinois 338
- Maine 338
- Louisiana 336
- Texas 335
- Florida 330
- Arkansas 327
- Iowa 327
- Nebraska 323
- Idaho 274
fips
county
- Franklin · 8,432 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1066517 | 1066517 | 2021-02-26 | Franklin | Alabama | 1059 | 3988 | 76 |
1066621 | 1066621 | 2021-02-26 | Franklin | Arkansas | 5047 | 1627 | 34 |
1066827 | 1066827 | 2021-02-26 | Franklin | Florida | 12037 | 1278 | 14 |
1066936 | 1066936 | 2021-02-26 | Franklin | Georgia | 13119 | 2560 | 42 |
1067064 | 1067064 | 2021-02-26 | Franklin | Idaho | 16041 | 1085 | 14 |
1067115 | 1067115 | 2021-02-26 | Franklin | Illinois | 17055 | 4142 | 77 |
1067214 | 1067214 | 2021-02-26 | Franklin | Indiana | 18047 | 1609 | 36 |
1067317 | 1067317 | 2021-02-26 | Franklin | Iowa | 19069 | 1082 | 19 |
1067412 | 1067412 | 2021-02-26 | Franklin | Kansas | 20059 | 2432 | 37 |
1067525 | 1067525 | 2021-02-26 | Franklin | Kentucky | 21073 | 3624 | 28 |
1067629 | 1067629 | 2021-02-26 | Franklin | Louisiana | 22041 | 2428 | 101 |
1067677 | 1067677 | 2021-02-26 | Franklin | Maine | 23007 | 893 | 12 |
1067720 | 1067720 | 2021-02-26 | Franklin | Massachusetts | 25011 | 1969 | 101 |
1067920 | 1067920 | 2021-02-26 | Franklin | Mississippi | 28037 | 756 | 19 |
1068019 | 1068019 | 2021-02-26 | Franklin | Missouri | 29071 | 8409 | 154 |
1068187 | 1068187 | 2021-02-26 | Franklin | Nebraska | 31061 | 232 | 3 |
1068348 | 1068348 | 2021-02-26 | Franklin | New York | 36033 | 2027 | 12 |
1068425 | 1068425 | 2021-02-26 | Franklin | North Carolina | 37069 | 5357 | 43 |
1068571 | 1068571 | 2021-02-26 | Franklin | Ohio | 39049 | 111496 | 1198 |
1068776 | 1068776 | 2021-02-26 | Franklin | Pennsylvania | 42055 | 12464 | 323 |
1069038 | 1069038 | 2021-02-26 | Franklin | Tennessee | 47051 | 4714 | 85 |
1069188 | 1069188 | 2021-02-26 | Franklin | Texas | 48159 | 690 | 24 |
1069398 | 1069398 | 2021-02-26 | Franklin | Vermont | 50011 | 1215 | 35 |
1069454 | 1069454 | 2021-02-26 | Franklin | Virginia | 51067 | 3687 | 51 |
1069554 | 1069554 | 2021-02-26 | Franklin | Washington | 53021 | 11100 | 100 |
1063272 | 1063272 | 2021-02-25 | Franklin | Alabama | 1059 | 3978 | 76 |
1063376 | 1063376 | 2021-02-25 | Franklin | Arkansas | 5047 | 1624 | 34 |
1063582 | 1063582 | 2021-02-25 | Franklin | Florida | 12037 | 1278 | 14 |
1063691 | 1063691 | 2021-02-25 | Franklin | Georgia | 13119 | 2556 | 42 |
1063819 | 1063819 | 2021-02-25 | Franklin | Idaho | 16041 | 1084 | 14 |
1063870 | 1063870 | 2021-02-25 | Franklin | Illinois | 17055 | 4139 | 77 |
1063969 | 1063969 | 2021-02-25 | Franklin | Indiana | 18047 | 1606 | 36 |
1064072 | 1064072 | 2021-02-25 | Franklin | Iowa | 19069 | 1082 | 19 |
1064167 | 1064167 | 2021-02-25 | Franklin | Kansas | 20059 | 2428 | 37 |
1064280 | 1064280 | 2021-02-25 | Franklin | Kentucky | 21073 | 3617 | 28 |
1064384 | 1064384 | 2021-02-25 | Franklin | Louisiana | 22041 | 2427 | 100 |
1064432 | 1064432 | 2021-02-25 | Franklin | Maine | 23007 | 892 | 12 |
1064475 | 1064475 | 2021-02-25 | Franklin | Massachusetts | 25011 | 1966 | 100 |
1064675 | 1064675 | 2021-02-25 | Franklin | Mississippi | 28037 | 755 | 19 |
1064774 | 1064774 | 2021-02-25 | Franklin | Missouri | 29071 | 8402 | 154 |
1064942 | 1064942 | 2021-02-25 | Franklin | Nebraska | 31061 | 230 | 3 |
1065103 | 1065103 | 2021-02-25 | Franklin | New York | 36033 | 2008 | 12 |
1065180 | 1065180 | 2021-02-25 | Franklin | North Carolina | 37069 | 5241 | 43 |
1065326 | 1065326 | 2021-02-25 | Franklin | Ohio | 39049 | 111312 | 1196 |
1065531 | 1065531 | 2021-02-25 | Franklin | Pennsylvania | 42055 | 12425 | 321 |
1065793 | 1065793 | 2021-02-25 | Franklin | Tennessee | 47051 | 4708 | 84 |
1065943 | 1065943 | 2021-02-25 | Franklin | Texas | 48159 | 689 | 24 |
1066153 | 1066153 | 2021-02-25 | Franklin | Vermont | 50011 | 1202 | 35 |
1066209 | 1066209 | 2021-02-25 | Franklin | Virginia | 51067 | 3679 | 47 |
1066309 | 1066309 | 2021-02-25 | Franklin | Washington | 53021 | 11083 | 99 |
1060027 | 1060027 | 2021-02-24 | Franklin | Alabama | 1059 | 3976 | 75 |
1060131 | 1060131 | 2021-02-24 | Franklin | Arkansas | 5047 | 1622 | 34 |
1060337 | 1060337 | 2021-02-24 | Franklin | Florida | 12037 | 1277 | 13 |
1060446 | 1060446 | 2021-02-24 | Franklin | Georgia | 13119 | 2553 | 42 |
1060574 | 1060574 | 2021-02-24 | Franklin | Idaho | 16041 | 1081 | 14 |
1060625 | 1060625 | 2021-02-24 | Franklin | Illinois | 17055 | 4134 | 77 |
1060724 | 1060724 | 2021-02-24 | Franklin | Indiana | 18047 | 1602 | 36 |
1060827 | 1060827 | 2021-02-24 | Franklin | Iowa | 19069 | 1082 | 19 |
1060922 | 1060922 | 2021-02-24 | Franklin | Kansas | 20059 | 2428 | 37 |
1061035 | 1061035 | 2021-02-24 | Franklin | Kentucky | 21073 | 3612 | 28 |
1061139 | 1061139 | 2021-02-24 | Franklin | Louisiana | 22041 | 2423 | 100 |
1061187 | 1061187 | 2021-02-24 | Franklin | Maine | 23007 | 887 | 10 |
1061231 | 1061231 | 2021-02-24 | Franklin | Massachusetts | 25011 | 1959 | 100 |
1061431 | 1061431 | 2021-02-24 | Franklin | Mississippi | 28037 | 754 | 19 |
1061530 | 1061530 | 2021-02-24 | Franklin | Missouri | 29071 | 8388 | 154 |
1061698 | 1061698 | 2021-02-24 | Franklin | Nebraska | 31061 | 229 | 3 |
1061859 | 1061859 | 2021-02-24 | Franklin | New York | 36033 | 1996 | 12 |
1061936 | 1061936 | 2021-02-24 | Franklin | North Carolina | 37069 | 5217 | 43 |
1062082 | 1062082 | 2021-02-24 | Franklin | Ohio | 39049 | 111107 | 1193 |
1062286 | 1062286 | 2021-02-24 | Franklin | Pennsylvania | 42055 | 12406 | 320 |
1062548 | 1062548 | 2021-02-24 | Franklin | Tennessee | 47051 | 4706 | 84 |
1062698 | 1062698 | 2021-02-24 | Franklin | Texas | 48159 | 687 | 24 |
1062908 | 1062908 | 2021-02-24 | Franklin | Vermont | 50011 | 1193 | 35 |
1062964 | 1062964 | 2021-02-24 | Franklin | Virginia | 51067 | 3675 | 46 |
1063064 | 1063064 | 2021-02-24 | Franklin | Washington | 53021 | 11061 | 99 |
1056781 | 1056781 | 2021-02-23 | Franklin | Alabama | 1059 | 3965 | 75 |
1056885 | 1056885 | 2021-02-23 | Franklin | Arkansas | 5047 | 1617 | 34 |
1057091 | 1057091 | 2021-02-23 | Franklin | Florida | 12037 | 1273 | 13 |
1057200 | 1057200 | 2021-02-23 | Franklin | Georgia | 13119 | 2540 | 42 |
1057328 | 1057328 | 2021-02-23 | Franklin | Idaho | 16041 | 1080 | 14 |
1057379 | 1057379 | 2021-02-23 | Franklin | Illinois | 17055 | 4126 | 77 |
1057478 | 1057478 | 2021-02-23 | Franklin | Indiana | 18047 | 1601 | 36 |
1057581 | 1057581 | 2021-02-23 | Franklin | Iowa | 19069 | 1082 | 19 |
1057676 | 1057676 | 2021-02-23 | Franklin | Kansas | 20059 | 2423 | 36 |
1057789 | 1057789 | 2021-02-23 | Franklin | Kentucky | 21073 | 3609 | 28 |
1057893 | 1057893 | 2021-02-23 | Franklin | Louisiana | 22041 | 2420 | 100 |
1057941 | 1057941 | 2021-02-23 | Franklin | Maine | 23007 | 880 | 10 |
1057985 | 1057985 | 2021-02-23 | Franklin | Massachusetts | 25011 | 1957 | 100 |
1058185 | 1058185 | 2021-02-23 | Franklin | Mississippi | 28037 | 753 | 19 |
1058284 | 1058284 | 2021-02-23 | Franklin | Missouri | 29071 | 8380 | 154 |
1058452 | 1058452 | 2021-02-23 | Franklin | Nebraska | 31061 | 229 | 3 |
1058613 | 1058613 | 2021-02-23 | Franklin | New York | 36033 | 1986 | 12 |
1058690 | 1058690 | 2021-02-23 | Franklin | North Carolina | 37069 | 5195 | 43 |
1058836 | 1058836 | 2021-02-23 | Franklin | Ohio | 39049 | 110938 | 1191 |
1059041 | 1059041 | 2021-02-23 | Franklin | Pennsylvania | 42055 | 12370 | 318 |
1059303 | 1059303 | 2021-02-23 | Franklin | Tennessee | 47051 | 4699 | 83 |
1059453 | 1059453 | 2021-02-23 | Franklin | Texas | 48159 | 685 | 24 |
1059663 | 1059663 | 2021-02-23 | Franklin | Vermont | 50011 | 1184 | 35 |
1059719 | 1059719 | 2021-02-23 | Franklin | Virginia | 51067 | 3660 | 44 |
1059819 | 1059819 | 2021-02-23 | Franklin | Washington | 53021 | 11031 | 98 |
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]);