ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where county = "Franklin" and fips = 16041 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500153 | 2500153 | 2022-05-13 | Franklin | Idaho | 16041 | 2331 | 29 |
2496895 | 2496895 | 2022-05-12 | Franklin | Idaho | 16041 | 2330 | 29 |
2493637 | 2493637 | 2022-05-11 | Franklin | Idaho | 16041 | 2330 | 29 |
2490379 | 2490379 | 2022-05-10 | Franklin | Idaho | 16041 | 2330 | 29 |
2487122 | 2487122 | 2022-05-09 | Franklin | Idaho | 16041 | 2330 | 29 |
2483864 | 2483864 | 2022-05-08 | Franklin | Idaho | 16041 | 2330 | 29 |
2480606 | 2480606 | 2022-05-07 | Franklin | Idaho | 16041 | 2330 | 29 |
2477348 | 2477348 | 2022-05-06 | Franklin | Idaho | 16041 | 2330 | 29 |
2474090 | 2474090 | 2022-05-05 | Franklin | Idaho | 16041 | 2330 | 29 |
2470833 | 2470833 | 2022-05-04 | Franklin | Idaho | 16041 | 2330 | 29 |
2467577 | 2467577 | 2022-05-03 | Franklin | Idaho | 16041 | 2330 | 29 |
2464322 | 2464322 | 2022-05-02 | Franklin | Idaho | 16041 | 2330 | 29 |
2461066 | 2461066 | 2022-05-01 | Franklin | Idaho | 16041 | 2330 | 29 |
2457810 | 2457810 | 2022-04-30 | Franklin | Idaho | 16041 | 2330 | 29 |
2454554 | 2454554 | 2022-04-29 | Franklin | Idaho | 16041 | 2330 | 29 |
2451298 | 2451298 | 2022-04-28 | Franklin | Idaho | 16041 | 2330 | 29 |
2448042 | 2448042 | 2022-04-27 | Franklin | Idaho | 16041 | 2330 | 29 |
2444786 | 2444786 | 2022-04-26 | Franklin | Idaho | 16041 | 2330 | 29 |
2441530 | 2441530 | 2022-04-25 | Franklin | Idaho | 16041 | 2330 | 29 |
2438274 | 2438274 | 2022-04-24 | Franklin | Idaho | 16041 | 2330 | 29 |
2435018 | 2435018 | 2022-04-23 | Franklin | Idaho | 16041 | 2330 | 29 |
2431762 | 2431762 | 2022-04-22 | Franklin | Idaho | 16041 | 2330 | 29 |
2428506 | 2428506 | 2022-04-21 | Franklin | Idaho | 16041 | 2330 | 29 |
2425250 | 2425250 | 2022-04-20 | Franklin | Idaho | 16041 | 2330 | 29 |
2421994 | 2421994 | 2022-04-19 | Franklin | Idaho | 16041 | 2330 | 29 |
2418738 | 2418738 | 2022-04-18 | Franklin | Idaho | 16041 | 2330 | 29 |
2415482 | 2415482 | 2022-04-17 | Franklin | Idaho | 16041 | 2330 | 29 |
2412226 | 2412226 | 2022-04-16 | Franklin | Idaho | 16041 | 2330 | 29 |
2408970 | 2408970 | 2022-04-15 | Franklin | Idaho | 16041 | 2330 | 29 |
2405714 | 2405714 | 2022-04-14 | Franklin | Idaho | 16041 | 2330 | 29 |
2402459 | 2402459 | 2022-04-13 | Franklin | Idaho | 16041 | 2330 | 29 |
2399204 | 2399204 | 2022-04-12 | Franklin | Idaho | 16041 | 2330 | 29 |
2395949 | 2395949 | 2022-04-11 | Franklin | Idaho | 16041 | 2330 | 29 |
2392693 | 2392693 | 2022-04-10 | Franklin | Idaho | 16041 | 2330 | 29 |
2389437 | 2389437 | 2022-04-09 | Franklin | Idaho | 16041 | 2330 | 29 |
2386182 | 2386182 | 2022-04-08 | Franklin | Idaho | 16041 | 2330 | 29 |
2382927 | 2382927 | 2022-04-07 | Franklin | Idaho | 16041 | 2330 | 29 |
2379672 | 2379672 | 2022-04-06 | Franklin | Idaho | 16041 | 2330 | 29 |
2376418 | 2376418 | 2022-04-05 | Franklin | Idaho | 16041 | 2330 | 29 |
2373166 | 2373166 | 2022-04-04 | Franklin | Idaho | 16041 | 2330 | 29 |
2369913 | 2369913 | 2022-04-03 | Franklin | Idaho | 16041 | 2330 | 29 |
2366660 | 2366660 | 2022-04-02 | Franklin | Idaho | 16041 | 2330 | 29 |
2363407 | 2363407 | 2022-04-01 | Franklin | Idaho | 16041 | 2330 | 29 |
2360153 | 2360153 | 2022-03-31 | Franklin | Idaho | 16041 | 2330 | 29 |
2356899 | 2356899 | 2022-03-30 | Franklin | Idaho | 16041 | 2330 | 29 |
2353646 | 2353646 | 2022-03-29 | Franklin | Idaho | 16041 | 2330 | 29 |
2350394 | 2350394 | 2022-03-28 | Franklin | Idaho | 16041 | 2330 | 29 |
2347141 | 2347141 | 2022-03-27 | Franklin | Idaho | 16041 | 2330 | 29 |
2343888 | 2343888 | 2022-03-26 | Franklin | Idaho | 16041 | 2330 | 29 |
2340635 | 2340635 | 2022-03-25 | Franklin | Idaho | 16041 | 2330 | 29 |
2337382 | 2337382 | 2022-03-24 | Franklin | Idaho | 16041 | 2330 | 29 |
2334128 | 2334128 | 2022-03-23 | Franklin | Idaho | 16041 | 2330 | 29 |
2330874 | 2330874 | 2022-03-22 | Franklin | Idaho | 16041 | 2330 | 29 |
2327622 | 2327622 | 2022-03-21 | Franklin | Idaho | 16041 | 2330 | 29 |
2324369 | 2324369 | 2022-03-20 | Franklin | Idaho | 16041 | 2330 | 29 |
2321115 | 2321115 | 2022-03-19 | Franklin | Idaho | 16041 | 2330 | 29 |
2317861 | 2317861 | 2022-03-18 | Franklin | Idaho | 16041 | 2330 | 29 |
2314608 | 2314608 | 2022-03-17 | Franklin | Idaho | 16041 | 2330 | 29 |
2311355 | 2311355 | 2022-03-16 | Franklin | Idaho | 16041 | 2330 | 29 |
2308102 | 2308102 | 2022-03-15 | Franklin | Idaho | 16041 | 2330 | 29 |
2304851 | 2304851 | 2022-03-14 | Franklin | Idaho | 16041 | 2330 | 29 |
2301599 | 2301599 | 2022-03-13 | Franklin | Idaho | 16041 | 2330 | 29 |
2298347 | 2298347 | 2022-03-12 | Franklin | Idaho | 16041 | 2330 | 29 |
2295095 | 2295095 | 2022-03-11 | Franklin | Idaho | 16041 | 2330 | 29 |
2291843 | 2291843 | 2022-03-10 | Franklin | Idaho | 16041 | 2330 | 29 |
2288591 | 2288591 | 2022-03-09 | Franklin | Idaho | 16041 | 2331 | 29 |
2285340 | 2285340 | 2022-03-08 | Franklin | Idaho | 16041 | 2330 | 29 |
2282088 | 2282088 | 2022-03-07 | Franklin | Idaho | 16041 | 2329 | 29 |
2278835 | 2278835 | 2022-03-06 | Franklin | Idaho | 16041 | 2329 | 29 |
2275582 | 2275582 | 2022-03-05 | Franklin | Idaho | 16041 | 2329 | 29 |
2272329 | 2272329 | 2022-03-04 | Franklin | Idaho | 16041 | 2329 | 29 |
2269077 | 2269077 | 2022-03-03 | Franklin | Idaho | 16041 | 2329 | 29 |
2265824 | 2265824 | 2022-03-02 | Franklin | Idaho | 16041 | 2329 | 29 |
2262573 | 2262573 | 2022-03-01 | Franklin | Idaho | 16041 | 2329 | 29 |
2259322 | 2259322 | 2022-02-28 | Franklin | Idaho | 16041 | 2329 | 29 |
2256071 | 2256071 | 2022-02-27 | Franklin | Idaho | 16041 | 2329 | 29 |
2252820 | 2252820 | 2022-02-26 | Franklin | Idaho | 16041 | 2329 | 29 |
2249569 | 2249569 | 2022-02-25 | Franklin | Idaho | 16041 | 2329 | 29 |
2246318 | 2246318 | 2022-02-24 | Franklin | Idaho | 16041 | 2324 | 29 |
2243067 | 2243067 | 2022-02-23 | Franklin | Idaho | 16041 | 2325 | 29 |
2239816 | 2239816 | 2022-02-22 | Franklin | Idaho | 16041 | 2325 | 29 |
2236565 | 2236565 | 2022-02-21 | Franklin | Idaho | 16041 | 2322 | 29 |
2233314 | 2233314 | 2022-02-20 | Franklin | Idaho | 16041 | 2322 | 29 |
2230063 | 2230063 | 2022-02-19 | Franklin | Idaho | 16041 | 2322 | 29 |
2226812 | 2226812 | 2022-02-18 | Franklin | Idaho | 16041 | 2322 | 29 |
2223561 | 2223561 | 2022-02-17 | Franklin | Idaho | 16041 | 2313 | 29 |
2220310 | 2220310 | 2022-02-16 | Franklin | Idaho | 16041 | 2313 | 29 |
2217059 | 2217059 | 2022-02-15 | Franklin | Idaho | 16041 | 2313 | 29 |
2213808 | 2213808 | 2022-02-14 | Franklin | Idaho | 16041 | 2304 | 27 |
2210556 | 2210556 | 2022-02-13 | Franklin | Idaho | 16041 | 2285 | 27 |
2207303 | 2207303 | 2022-02-12 | Franklin | Idaho | 16041 | 2285 | 27 |
2204050 | 2204050 | 2022-02-11 | Franklin | Idaho | 16041 | 2285 | 27 |
2200797 | 2200797 | 2022-02-10 | Franklin | Idaho | 16041 | 2280 | 27 |
2197543 | 2197543 | 2022-02-09 | Franklin | Idaho | 16041 | 2255 | 27 |
2194289 | 2194289 | 2022-02-08 | Franklin | Idaho | 16041 | 2252 | 27 |
2191035 | 2191035 | 2022-02-07 | Franklin | Idaho | 16041 | 2251 | 27 |
2187782 | 2187782 | 2022-02-06 | Franklin | Idaho | 16041 | 2189 | 27 |
2184529 | 2184529 | 2022-02-05 | Franklin | Idaho | 16041 | 2189 | 27 |
2181277 | 2181277 | 2022-02-04 | Franklin | Idaho | 16041 | 2189 | 27 |
2178026 | 2178026 | 2022-02-03 | Franklin | Idaho | 16041 | 2185 | 27 |
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);