ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where county = "Franklin" and deaths = 52 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 13
- Florida 51
- Arkansas 28
- Georgia 25
- Kansas 16
- Vermont 14
- Maine 5
- Pennsylvania 5
- Louisiana 3
- Massachusetts 3
- North Carolina 3
- Washington 3
- Illinois 1
- Virginia 1
fips 13
county 1
- Franklin · 158 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499915 | 2499915 | 2022-05-13 | Franklin | Florida | 12037 | 3087 | 52 |
2496657 | 2496657 | 2022-05-12 | Franklin | Florida | 12037 | 3087 | 52 |
2493399 | 2493399 | 2022-05-11 | Franklin | Florida | 12037 | 3087 | 52 |
2490141 | 2490141 | 2022-05-10 | Franklin | Florida | 12037 | 3087 | 52 |
2486884 | 2486884 | 2022-05-09 | Franklin | Florida | 12037 | 3087 | 52 |
2483626 | 2483626 | 2022-05-08 | Franklin | Florida | 12037 | 3087 | 52 |
2480368 | 2480368 | 2022-05-07 | Franklin | Florida | 12037 | 3087 | 52 |
2477110 | 2477110 | 2022-05-06 | Franklin | Florida | 12037 | 3087 | 52 |
2473852 | 2473852 | 2022-05-05 | Franklin | Florida | 12037 | 3079 | 52 |
2470595 | 2470595 | 2022-05-04 | Franklin | Florida | 12037 | 3079 | 52 |
2467339 | 2467339 | 2022-05-03 | Franklin | Florida | 12037 | 3079 | 52 |
2464084 | 2464084 | 2022-05-02 | Franklin | Florida | 12037 | 3079 | 52 |
2460828 | 2460828 | 2022-05-01 | Franklin | Florida | 12037 | 3079 | 52 |
2457572 | 2457572 | 2022-04-30 | Franklin | Florida | 12037 | 3079 | 52 |
2454316 | 2454316 | 2022-04-29 | Franklin | Florida | 12037 | 3079 | 52 |
2451060 | 2451060 | 2022-04-28 | Franklin | Florida | 12037 | 3079 | 52 |
2447804 | 2447804 | 2022-04-27 | Franklin | Florida | 12037 | 3079 | 52 |
2444548 | 2444548 | 2022-04-26 | Franklin | Florida | 12037 | 3079 | 52 |
2441292 | 2441292 | 2022-04-25 | Franklin | Florida | 12037 | 3079 | 52 |
2438036 | 2438036 | 2022-04-24 | Franklin | Florida | 12037 | 3079 | 52 |
2434780 | 2434780 | 2022-04-23 | Franklin | Florida | 12037 | 3079 | 52 |
2431524 | 2431524 | 2022-04-22 | Franklin | Florida | 12037 | 3079 | 52 |
2428268 | 2428268 | 2022-04-21 | Franklin | Florida | 12037 | 3076 | 52 |
2425012 | 2425012 | 2022-04-20 | Franklin | Florida | 12037 | 3076 | 52 |
2421756 | 2421756 | 2022-04-19 | Franklin | Florida | 12037 | 3076 | 52 |
2418500 | 2418500 | 2022-04-18 | Franklin | Florida | 12037 | 3076 | 52 |
2415244 | 2415244 | 2022-04-17 | Franklin | Florida | 12037 | 3076 | 52 |
2411988 | 2411988 | 2022-04-16 | Franklin | Florida | 12037 | 3076 | 52 |
2408732 | 2408732 | 2022-04-15 | Franklin | Florida | 12037 | 3076 | 52 |
2405476 | 2405476 | 2022-04-14 | Franklin | Florida | 12037 | 3076 | 52 |
2402221 | 2402221 | 2022-04-13 | Franklin | Florida | 12037 | 3076 | 52 |
2398966 | 2398966 | 2022-04-12 | Franklin | Florida | 12037 | 3076 | 52 |
2395711 | 2395711 | 2022-04-11 | Franklin | Florida | 12037 | 3076 | 52 |
2392455 | 2392455 | 2022-04-10 | Franklin | Florida | 12037 | 3076 | 52 |
2389199 | 2389199 | 2022-04-09 | Franklin | Florida | 12037 | 3076 | 52 |
2385944 | 2385944 | 2022-04-08 | Franklin | Florida | 12037 | 3076 | 52 |
2382689 | 2382689 | 2022-04-07 | Franklin | Florida | 12037 | 3075 | 52 |
2379434 | 2379434 | 2022-04-06 | Franklin | Florida | 12037 | 3075 | 52 |
2376180 | 2376180 | 2022-04-05 | Franklin | Florida | 12037 | 3075 | 52 |
2372928 | 2372928 | 2022-04-04 | Franklin | Florida | 12037 | 3075 | 52 |
2369675 | 2369675 | 2022-04-03 | Franklin | Florida | 12037 | 3075 | 52 |
2366422 | 2366422 | 2022-04-02 | Franklin | Florida | 12037 | 3075 | 52 |
2363169 | 2363169 | 2022-04-01 | Franklin | Florida | 12037 | 3075 | 52 |
2359915 | 2359915 | 2022-03-31 | Franklin | Florida | 12037 | 3075 | 52 |
2356661 | 2356661 | 2022-03-30 | Franklin | Florida | 12037 | 3075 | 52 |
2353408 | 2353408 | 2022-03-29 | Franklin | Florida | 12037 | 3075 | 52 |
2350156 | 2350156 | 2022-03-28 | Franklin | Florida | 12037 | 3075 | 52 |
2346903 | 2346903 | 2022-03-27 | Franklin | Florida | 12037 | 3075 | 52 |
2343650 | 2343650 | 2022-03-26 | Franklin | Florida | 12037 | 3075 | 52 |
2340397 | 2340397 | 2022-03-25 | Franklin | Florida | 12037 | 3075 | 52 |
2337144 | 2337144 | 2022-03-24 | Franklin | Florida | 12037 | 3070 | 52 |
2243679 | 2243679 | 2022-02-23 | Franklin | Maine | 23007 | 5477 | 52 |
2240428 | 2240428 | 2022-02-22 | Franklin | Maine | 23007 | 5424 | 52 |
2237177 | 2237177 | 2022-02-21 | Franklin | Maine | 23007 | 5403 | 52 |
2233926 | 2233926 | 2022-02-20 | Franklin | Maine | 23007 | 5374 | 52 |
2230675 | 2230675 | 2022-02-19 | Franklin | Maine | 23007 | 5233 | 52 |
1962515 | 1962515 | 2021-11-28 | Franklin | Vermont | 50011 | 3942 | 52 |
1959264 | 1959264 | 2021-11-27 | Franklin | Vermont | 50011 | 3942 | 52 |
1956013 | 1956013 | 2021-11-26 | Franklin | Vermont | 50011 | 3942 | 52 |
1952762 | 1952762 | 2021-11-25 | Franklin | Vermont | 50011 | 3942 | 52 |
1949511 | 1949511 | 2021-11-24 | Franklin | Vermont | 50011 | 3942 | 52 |
1946260 | 1946260 | 2021-11-23 | Franklin | Vermont | 50011 | 3925 | 52 |
1943009 | 1943009 | 2021-11-22 | Franklin | Vermont | 50011 | 3917 | 52 |
1939759 | 1939759 | 2021-11-21 | Franklin | Vermont | 50011 | 3886 | 52 |
1936509 | 1936509 | 2021-11-20 | Franklin | Vermont | 50011 | 3835 | 52 |
1933259 | 1933259 | 2021-11-19 | Franklin | Vermont | 50011 | 3793 | 52 |
1930008 | 1930008 | 2021-11-18 | Franklin | Vermont | 50011 | 3752 | 52 |
1926758 | 1926758 | 2021-11-17 | Franklin | Vermont | 50011 | 3709 | 52 |
1923508 | 1923508 | 2021-11-16 | Franklin | Vermont | 50011 | 3686 | 52 |
1920259 | 1920259 | 2021-11-15 | Franklin | Vermont | 50011 | 3652 | 52 |
1891480 | 1891480 | 2021-11-07 | Franklin | Arkansas | 5047 | 2738 | 52 |
1888230 | 1888230 | 2021-11-06 | Franklin | Arkansas | 5047 | 2738 | 52 |
1884980 | 1884980 | 2021-11-05 | Franklin | Arkansas | 5047 | 2734 | 52 |
1881731 | 1881731 | 2021-11-04 | Franklin | Arkansas | 5047 | 2733 | 52 |
1878482 | 1878482 | 2021-11-03 | Franklin | Arkansas | 5047 | 2732 | 52 |
1875233 | 1875233 | 2021-11-02 | Franklin | Arkansas | 5047 | 2730 | 52 |
1871984 | 1871984 | 2021-11-01 | Franklin | Arkansas | 5047 | 2728 | 52 |
1868735 | 1868735 | 2021-10-31 | Franklin | Arkansas | 5047 | 2728 | 52 |
1865486 | 1865486 | 2021-10-30 | Franklin | Arkansas | 5047 | 2728 | 52 |
1862237 | 1862237 | 2021-10-29 | Franklin | Arkansas | 5047 | 2724 | 52 |
1858988 | 1858988 | 2021-10-28 | Franklin | Arkansas | 5047 | 2723 | 52 |
1855739 | 1855739 | 2021-10-27 | Franklin | Arkansas | 5047 | 2722 | 52 |
1852490 | 1852490 | 2021-10-26 | Franklin | Arkansas | 5047 | 2722 | 52 |
1849241 | 1849241 | 2021-10-25 | Franklin | Arkansas | 5047 | 2719 | 52 |
1845991 | 1845991 | 2021-10-24 | Franklin | Arkansas | 5047 | 2719 | 52 |
1842741 | 1842741 | 2021-10-23 | Franklin | Arkansas | 5047 | 2720 | 52 |
1839491 | 1839491 | 2021-10-22 | Franklin | Arkansas | 5047 | 2718 | 52 |
1797253 | 1797253 | 2021-10-09 | Franklin | Arkansas | 5047 | 2689 | 52 |
1794004 | 1794004 | 2021-10-08 | Franklin | Arkansas | 5047 | 2687 | 52 |
1790756 | 1790756 | 2021-10-07 | Franklin | Arkansas | 5047 | 2681 | 52 |
1787507 | 1787507 | 2021-10-06 | Franklin | Arkansas | 5047 | 2678 | 52 |
1784258 | 1784258 | 2021-10-05 | Franklin | Arkansas | 5047 | 2668 | 52 |
1781009 | 1781009 | 2021-10-04 | Franklin | Arkansas | 5047 | 2666 | 52 |
1777759 | 1777759 | 2021-10-03 | Franklin | Arkansas | 5047 | 2664 | 52 |
1774509 | 1774509 | 2021-10-02 | Franklin | Arkansas | 5047 | 2660 | 52 |
1771259 | 1771259 | 2021-10-01 | Franklin | Arkansas | 5047 | 2658 | 52 |
1768010 | 1768010 | 2021-09-30 | Franklin | Arkansas | 5047 | 2653 | 52 |
1764761 | 1764761 | 2021-09-29 | Franklin | Arkansas | 5047 | 2651 | 52 |
1746061 | 1746061 | 2021-09-23 | Franklin | Kansas | 20059 | 3493 | 52 |
1742812 | 1742812 | 2021-09-22 | Franklin | Kansas | 20059 | 3493 | 52 |
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);