ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Franklin" and fips = 12037 sorted by deaths descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▲ |
---|---|---|---|---|---|---|---|
2337144 | 2337144 | 2022-03-24 | Franklin | Florida | 12037 | 3070 | 52 |
2340397 | 2340397 | 2022-03-25 | Franklin | Florida | 12037 | 3075 | 52 |
2343650 | 2343650 | 2022-03-26 | Franklin | Florida | 12037 | 3075 | 52 |
2346903 | 2346903 | 2022-03-27 | Franklin | Florida | 12037 | 3075 | 52 |
2350156 | 2350156 | 2022-03-28 | Franklin | Florida | 12037 | 3075 | 52 |
2353408 | 2353408 | 2022-03-29 | Franklin | Florida | 12037 | 3075 | 52 |
2356661 | 2356661 | 2022-03-30 | Franklin | Florida | 12037 | 3075 | 52 |
2359915 | 2359915 | 2022-03-31 | Franklin | Florida | 12037 | 3075 | 52 |
2363169 | 2363169 | 2022-04-01 | Franklin | Florida | 12037 | 3075 | 52 |
2366422 | 2366422 | 2022-04-02 | Franklin | Florida | 12037 | 3075 | 52 |
2369675 | 2369675 | 2022-04-03 | Franklin | Florida | 12037 | 3075 | 52 |
2372928 | 2372928 | 2022-04-04 | Franklin | Florida | 12037 | 3075 | 52 |
2376180 | 2376180 | 2022-04-05 | Franklin | Florida | 12037 | 3075 | 52 |
2379434 | 2379434 | 2022-04-06 | Franklin | Florida | 12037 | 3075 | 52 |
2382689 | 2382689 | 2022-04-07 | Franklin | Florida | 12037 | 3075 | 52 |
2385944 | 2385944 | 2022-04-08 | Franklin | Florida | 12037 | 3076 | 52 |
2389199 | 2389199 | 2022-04-09 | Franklin | Florida | 12037 | 3076 | 52 |
2392455 | 2392455 | 2022-04-10 | Franklin | Florida | 12037 | 3076 | 52 |
2395711 | 2395711 | 2022-04-11 | Franklin | Florida | 12037 | 3076 | 52 |
2398966 | 2398966 | 2022-04-12 | Franklin | Florida | 12037 | 3076 | 52 |
2402221 | 2402221 | 2022-04-13 | Franklin | Florida | 12037 | 3076 | 52 |
2405476 | 2405476 | 2022-04-14 | Franklin | Florida | 12037 | 3076 | 52 |
2408732 | 2408732 | 2022-04-15 | Franklin | Florida | 12037 | 3076 | 52 |
2411988 | 2411988 | 2022-04-16 | Franklin | Florida | 12037 | 3076 | 52 |
2415244 | 2415244 | 2022-04-17 | Franklin | Florida | 12037 | 3076 | 52 |
2418500 | 2418500 | 2022-04-18 | Franklin | Florida | 12037 | 3076 | 52 |
2421756 | 2421756 | 2022-04-19 | Franklin | Florida | 12037 | 3076 | 52 |
2425012 | 2425012 | 2022-04-20 | Franklin | Florida | 12037 | 3076 | 52 |
2428268 | 2428268 | 2022-04-21 | Franklin | Florida | 12037 | 3076 | 52 |
2431524 | 2431524 | 2022-04-22 | Franklin | Florida | 12037 | 3079 | 52 |
2434780 | 2434780 | 2022-04-23 | Franklin | Florida | 12037 | 3079 | 52 |
2438036 | 2438036 | 2022-04-24 | Franklin | Florida | 12037 | 3079 | 52 |
2441292 | 2441292 | 2022-04-25 | Franklin | Florida | 12037 | 3079 | 52 |
2444548 | 2444548 | 2022-04-26 | Franklin | Florida | 12037 | 3079 | 52 |
2447804 | 2447804 | 2022-04-27 | Franklin | Florida | 12037 | 3079 | 52 |
2451060 | 2451060 | 2022-04-28 | Franklin | Florida | 12037 | 3079 | 52 |
2454316 | 2454316 | 2022-04-29 | Franklin | Florida | 12037 | 3079 | 52 |
2457572 | 2457572 | 2022-04-30 | Franklin | Florida | 12037 | 3079 | 52 |
2460828 | 2460828 | 2022-05-01 | Franklin | Florida | 12037 | 3079 | 52 |
2464084 | 2464084 | 2022-05-02 | Franklin | Florida | 12037 | 3079 | 52 |
2467339 | 2467339 | 2022-05-03 | Franklin | Florida | 12037 | 3079 | 52 |
2470595 | 2470595 | 2022-05-04 | Franklin | Florida | 12037 | 3079 | 52 |
2473852 | 2473852 | 2022-05-05 | Franklin | Florida | 12037 | 3079 | 52 |
2477110 | 2477110 | 2022-05-06 | Franklin | Florida | 12037 | 3087 | 52 |
2480368 | 2480368 | 2022-05-07 | Franklin | Florida | 12037 | 3087 | 52 |
2483626 | 2483626 | 2022-05-08 | Franklin | Florida | 12037 | 3087 | 52 |
2486884 | 2486884 | 2022-05-09 | Franklin | Florida | 12037 | 3087 | 52 |
2490141 | 2490141 | 2022-05-10 | Franklin | Florida | 12037 | 3087 | 52 |
2493399 | 2493399 | 2022-05-11 | Franklin | Florida | 12037 | 3087 | 52 |
2496657 | 2496657 | 2022-05-12 | Franklin | Florida | 12037 | 3087 | 52 |
2499915 | 2499915 | 2022-05-13 | Franklin | Florida | 12037 | 3087 | 52 |
2311117 | 2311117 | 2022-03-16 | Franklin | Florida | 12037 | 3070 | 51 |
2314370 | 2314370 | 2022-03-17 | Franklin | Florida | 12037 | 3070 | 51 |
2317623 | 2317623 | 2022-03-18 | Franklin | Florida | 12037 | 3070 | 51 |
2320877 | 2320877 | 2022-03-19 | Franklin | Florida | 12037 | 3070 | 51 |
2324131 | 2324131 | 2022-03-20 | Franklin | Florida | 12037 | 3070 | 51 |
2327384 | 2327384 | 2022-03-21 | Franklin | Florida | 12037 | 3070 | 51 |
2330636 | 2330636 | 2022-03-22 | Franklin | Florida | 12037 | 3070 | 51 |
2333890 | 2333890 | 2022-03-23 | Franklin | Florida | 12037 | 3070 | 51 |
2265586 | 2265586 | 2022-03-02 | Franklin | Florida | 12037 | 3067 | 50 |
2268839 | 2268839 | 2022-03-03 | Franklin | Florida | 12037 | 3067 | 50 |
2272091 | 2272091 | 2022-03-04 | Franklin | Florida | 12037 | 3067 | 50 |
2275344 | 2275344 | 2022-03-05 | Franklin | Florida | 12037 | 3067 | 50 |
2278597 | 2278597 | 2022-03-06 | Franklin | Florida | 12037 | 3067 | 50 |
2281850 | 2281850 | 2022-03-07 | Franklin | Florida | 12037 | 3067 | 50 |
2285102 | 2285102 | 2022-03-08 | Franklin | Florida | 12037 | 3067 | 50 |
2288353 | 2288353 | 2022-03-09 | Franklin | Florida | 12037 | 3067 | 50 |
2291605 | 2291605 | 2022-03-10 | Franklin | Florida | 12037 | 3067 | 50 |
2294857 | 2294857 | 2022-03-11 | Franklin | Florida | 12037 | 3070 | 50 |
2298109 | 2298109 | 2022-03-12 | Franklin | Florida | 12037 | 3070 | 50 |
2301361 | 2301361 | 2022-03-13 | Franklin | Florida | 12037 | 3070 | 50 |
2304613 | 2304613 | 2022-03-14 | Franklin | Florida | 12037 | 3070 | 50 |
2307864 | 2307864 | 2022-03-15 | Franklin | Florida | 12037 | 3070 | 50 |
2242829 | 2242829 | 2022-02-23 | Franklin | Florida | 12037 | 3065 | 49 |
2246080 | 2246080 | 2022-02-24 | Franklin | Florida | 12037 | 3065 | 49 |
2249331 | 2249331 | 2022-02-25 | Franklin | Florida | 12037 | 3067 | 49 |
2252582 | 2252582 | 2022-02-26 | Franklin | Florida | 12037 | 3067 | 49 |
2255833 | 2255833 | 2022-02-27 | Franklin | Florida | 12037 | 3067 | 49 |
2259084 | 2259084 | 2022-02-28 | Franklin | Florida | 12037 | 3067 | 49 |
2262335 | 2262335 | 2022-03-01 | Franklin | Florida | 12037 | 3067 | 49 |
2060700 | 2060700 | 2021-12-29 | Franklin | Florida | 12037 | 2243 | 46 |
2063950 | 2063950 | 2021-12-30 | Franklin | Florida | 12037 | 2243 | 46 |
2067201 | 2067201 | 2021-12-31 | Franklin | Florida | 12037 | 2265 | 46 |
2070452 | 2070452 | 2022-01-01 | Franklin | Florida | 12037 | 2265 | 46 |
2073703 | 2073703 | 2022-01-02 | Franklin | Florida | 12037 | 2265 | 46 |
2076954 | 2076954 | 2022-01-03 | Franklin | Florida | 12037 | 2265 | 46 |
2080206 | 2080206 | 2022-01-04 | Franklin | Florida | 12037 | 2265 | 46 |
2083458 | 2083458 | 2022-01-05 | Franklin | Florida | 12037 | 2265 | 46 |
2086710 | 2086710 | 2022-01-06 | Franklin | Florida | 12037 | 2265 | 46 |
2089961 | 2089961 | 2022-01-07 | Franklin | Florida | 12037 | 2351 | 46 |
2093213 | 2093213 | 2022-01-08 | Franklin | Florida | 12037 | 2351 | 46 |
2096465 | 2096465 | 2022-01-09 | Franklin | Florida | 12037 | 2351 | 46 |
2099716 | 2099716 | 2022-01-10 | Franklin | Florida | 12037 | 2351 | 46 |
2102967 | 2102967 | 2022-01-11 | Franklin | Florida | 12037 | 2351 | 46 |
2106218 | 2106218 | 2022-01-12 | Franklin | Florida | 12037 | 2351 | 46 |
2109469 | 2109469 | 2022-01-13 | Franklin | Florida | 12037 | 2351 | 46 |
2112721 | 2112721 | 2022-01-14 | Franklin | Florida | 12037 | 2528 | 46 |
2115972 | 2115972 | 2022-01-15 | Franklin | Florida | 12037 | 2528 | 46 |
2119224 | 2119224 | 2022-01-16 | Franklin | Florida | 12037 | 2528 | 46 |
2122476 | 2122476 | 2022-01-17 | Franklin | Florida | 12037 | 2528 | 46 |
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);