ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Franklin" and fips = 17055 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500204 | 2500204 | 2022-05-13 | Franklin | Illinois | 17055 | 12272 | 178 |
2496946 | 2496946 | 2022-05-12 | Franklin | Illinois | 17055 | 12266 | 178 |
2493688 | 2493688 | 2022-05-11 | Franklin | Illinois | 17055 | 12261 | 178 |
2490430 | 2490430 | 2022-05-10 | Franklin | Illinois | 17055 | 12256 | 178 |
2487173 | 2487173 | 2022-05-09 | Franklin | Illinois | 17055 | 12255 | 178 |
2483915 | 2483915 | 2022-05-08 | Franklin | Illinois | 17055 | 12254 | 178 |
2480657 | 2480657 | 2022-05-07 | Franklin | Illinois | 17055 | 12254 | 178 |
2477399 | 2477399 | 2022-05-06 | Franklin | Illinois | 17055 | 12254 | 178 |
2474141 | 2474141 | 2022-05-05 | Franklin | Illinois | 17055 | 12248 | 178 |
2470884 | 2470884 | 2022-05-04 | Franklin | Illinois | 17055 | 12248 | 177 |
2467628 | 2467628 | 2022-05-03 | Franklin | Illinois | 17055 | 12247 | 177 |
2464373 | 2464373 | 2022-05-02 | Franklin | Illinois | 17055 | 12245 | 177 |
2461117 | 2461117 | 2022-05-01 | Franklin | Illinois | 17055 | 12239 | 177 |
2457861 | 2457861 | 2022-04-30 | Franklin | Illinois | 17055 | 12239 | 177 |
2454605 | 2454605 | 2022-04-29 | Franklin | Illinois | 17055 | 12239 | 177 |
2451349 | 2451349 | 2022-04-28 | Franklin | Illinois | 17055 | 12237 | 177 |
2448093 | 2448093 | 2022-04-27 | Franklin | Illinois | 17055 | 12235 | 177 |
2444837 | 2444837 | 2022-04-26 | Franklin | Illinois | 17055 | 12236 | 177 |
2441581 | 2441581 | 2022-04-25 | Franklin | Illinois | 17055 | 12235 | 177 |
2438325 | 2438325 | 2022-04-24 | Franklin | Illinois | 17055 | 12231 | 177 |
2435069 | 2435069 | 2022-04-23 | Franklin | Illinois | 17055 | 12231 | 177 |
2431813 | 2431813 | 2022-04-22 | Franklin | Illinois | 17055 | 12231 | 177 |
2428557 | 2428557 | 2022-04-21 | Franklin | Illinois | 17055 | 12235 | 177 |
2425301 | 2425301 | 2022-04-20 | Franklin | Illinois | 17055 | 12261 | 177 |
2422045 | 2422045 | 2022-04-19 | Franklin | Illinois | 17055 | 12265 | 177 |
2418789 | 2418789 | 2022-04-18 | Franklin | Illinois | 17055 | 12267 | 177 |
2415533 | 2415533 | 2022-04-17 | Franklin | Illinois | 17055 | 12267 | 177 |
2412277 | 2412277 | 2022-04-16 | Franklin | Illinois | 17055 | 12267 | 177 |
2409021 | 2409021 | 2022-04-15 | Franklin | Illinois | 17055 | 12267 | 177 |
2405765 | 2405765 | 2022-04-14 | Franklin | Illinois | 17055 | 12266 | 177 |
2402510 | 2402510 | 2022-04-13 | Franklin | Illinois | 17055 | 12272 | 177 |
2399255 | 2399255 | 2022-04-12 | Franklin | Illinois | 17055 | 12272 | 177 |
2396000 | 2396000 | 2022-04-11 | Franklin | Illinois | 17055 | 12275 | 177 |
2392744 | 2392744 | 2022-04-10 | Franklin | Illinois | 17055 | 12271 | 177 |
2389488 | 2389488 | 2022-04-09 | Franklin | Illinois | 17055 | 12271 | 177 |
2386233 | 2386233 | 2022-04-08 | Franklin | Illinois | 17055 | 12271 | 177 |
2382978 | 2382978 | 2022-04-07 | Franklin | Illinois | 17055 | 12270 | 177 |
2379723 | 2379723 | 2022-04-06 | Franklin | Illinois | 17055 | 12274 | 177 |
2376469 | 2376469 | 2022-04-05 | Franklin | Illinois | 17055 | 12272 | 177 |
2373217 | 2373217 | 2022-04-04 | Franklin | Illinois | 17055 | 12271 | 177 |
2369964 | 2369964 | 2022-04-03 | Franklin | Illinois | 17055 | 12269 | 177 |
2366711 | 2366711 | 2022-04-02 | Franklin | Illinois | 17055 | 12269 | 177 |
2363458 | 2363458 | 2022-04-01 | Franklin | Illinois | 17055 | 12269 | 177 |
2360204 | 2360204 | 2022-03-31 | Franklin | Illinois | 17055 | 12268 | 177 |
2356950 | 2356950 | 2022-03-30 | Franklin | Illinois | 17055 | 12265 | 177 |
2353697 | 2353697 | 2022-03-29 | Franklin | Illinois | 17055 | 12264 | 177 |
2350445 | 2350445 | 2022-03-28 | Franklin | Illinois | 17055 | 12262 | 177 |
2347192 | 2347192 | 2022-03-27 | Franklin | Illinois | 17055 | 12259 | 177 |
2343939 | 2343939 | 2022-03-26 | Franklin | Illinois | 17055 | 12259 | 177 |
2340686 | 2340686 | 2022-03-25 | Franklin | Illinois | 17055 | 12259 | 177 |
2337433 | 2337433 | 2022-03-24 | Franklin | Illinois | 17055 | 12259 | 177 |
2334179 | 2334179 | 2022-03-23 | Franklin | Illinois | 17055 | 12258 | 177 |
2330925 | 2330925 | 2022-03-22 | Franklin | Illinois | 17055 | 12258 | 177 |
2327673 | 2327673 | 2022-03-21 | Franklin | Illinois | 17055 | 12259 | 177 |
2324420 | 2324420 | 2022-03-20 | Franklin | Illinois | 17055 | 12255 | 177 |
2321166 | 2321166 | 2022-03-19 | Franklin | Illinois | 17055 | 12255 | 177 |
2317912 | 2317912 | 2022-03-18 | Franklin | Illinois | 17055 | 12255 | 177 |
2314659 | 2314659 | 2022-03-17 | Franklin | Illinois | 17055 | 12252 | 177 |
2311406 | 2311406 | 2022-03-16 | Franklin | Illinois | 17055 | 12253 | 176 |
2308153 | 2308153 | 2022-03-15 | Franklin | Illinois | 17055 | 12251 | 176 |
2304902 | 2304902 | 2022-03-14 | Franklin | Illinois | 17055 | 12249 | 176 |
2301650 | 2301650 | 2022-03-13 | Franklin | Illinois | 17055 | 12249 | 176 |
2298398 | 2298398 | 2022-03-12 | Franklin | Illinois | 17055 | 12249 | 176 |
2295146 | 2295146 | 2022-03-11 | Franklin | Illinois | 17055 | 12249 | 176 |
2291894 | 2291894 | 2022-03-10 | Franklin | Illinois | 17055 | 12249 | 176 |
2288642 | 2288642 | 2022-03-09 | Franklin | Illinois | 17055 | 12244 | 176 |
2285391 | 2285391 | 2022-03-08 | Franklin | Illinois | 17055 | 12239 | 176 |
2282139 | 2282139 | 2022-03-07 | Franklin | Illinois | 17055 | 12236 | 176 |
2278886 | 2278886 | 2022-03-06 | Franklin | Illinois | 17055 | 12231 | 176 |
2275633 | 2275633 | 2022-03-05 | Franklin | Illinois | 17055 | 12231 | 176 |
2272380 | 2272380 | 2022-03-04 | Franklin | Illinois | 17055 | 12231 | 176 |
2269128 | 2269128 | 2022-03-03 | Franklin | Illinois | 17055 | 12230 | 176 |
2265875 | 2265875 | 2022-03-02 | Franklin | Illinois | 17055 | 12228 | 176 |
2262624 | 2262624 | 2022-03-01 | Franklin | Illinois | 17055 | 12223 | 175 |
2259373 | 2259373 | 2022-02-28 | Franklin | Illinois | 17055 | 12219 | 175 |
2256122 | 2256122 | 2022-02-27 | Franklin | Illinois | 17055 | 12203 | 175 |
2252871 | 2252871 | 2022-02-26 | Franklin | Illinois | 17055 | 12203 | 175 |
2249620 | 2249620 | 2022-02-25 | Franklin | Illinois | 17055 | 12203 | 175 |
2246369 | 2246369 | 2022-02-24 | Franklin | Illinois | 17055 | 12195 | 172 |
2243118 | 2243118 | 2022-02-23 | Franklin | Illinois | 17055 | 12189 | 171 |
2239867 | 2239867 | 2022-02-22 | Franklin | Illinois | 17055 | 12181 | 171 |
2236616 | 2236616 | 2022-02-21 | Franklin | Illinois | 17055 | 12150 | 169 |
2233365 | 2233365 | 2022-02-20 | Franklin | Illinois | 17055 | 12150 | 169 |
2230114 | 2230114 | 2022-02-19 | Franklin | Illinois | 17055 | 12150 | 169 |
2226863 | 2226863 | 2022-02-18 | Franklin | Illinois | 17055 | 12150 | 169 |
2223612 | 2223612 | 2022-02-17 | Franklin | Illinois | 17055 | 12136 | 168 |
2220361 | 2220361 | 2022-02-16 | Franklin | Illinois | 17055 | 12131 | 167 |
2217110 | 2217110 | 2022-02-15 | Franklin | Illinois | 17055 | 12127 | 166 |
2213859 | 2213859 | 2022-02-14 | Franklin | Illinois | 17055 | 12104 | 166 |
2210607 | 2210607 | 2022-02-13 | Franklin | Illinois | 17055 | 12015 | 166 |
2207354 | 2207354 | 2022-02-12 | Franklin | Illinois | 17055 | 12015 | 166 |
2204101 | 2204101 | 2022-02-11 | Franklin | Illinois | 17055 | 12015 | 166 |
2200848 | 2200848 | 2022-02-10 | Franklin | Illinois | 17055 | 12015 | 166 |
2197594 | 2197594 | 2022-02-09 | Franklin | Illinois | 17055 | 11974 | 166 |
2194340 | 2194340 | 2022-02-08 | Franklin | Illinois | 17055 | 11944 | 163 |
2191086 | 2191086 | 2022-02-07 | Franklin | Illinois | 17055 | 11898 | 163 |
2187833 | 2187833 | 2022-02-06 | Franklin | Illinois | 17055 | 11827 | 163 |
2184580 | 2184580 | 2022-02-05 | Franklin | Illinois | 17055 | 11827 | 163 |
2181328 | 2181328 | 2022-02-04 | Franklin | Illinois | 17055 | 11827 | 163 |
2178077 | 2178077 | 2022-02-03 | Franklin | Illinois | 17055 | 11738 | 162 |
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);