ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 18011 and state = "Indiana" 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 |
---|---|---|---|---|---|---|---|
2500285 | 2500285 | 2022-05-13 | Boone | Indiana | 18011 | 15456 | 186 |
2497027 | 2497027 | 2022-05-12 | Boone | Indiana | 18011 | 15430 | 186 |
2493769 | 2493769 | 2022-05-11 | Boone | Indiana | 18011 | 15430 | 186 |
2490511 | 2490511 | 2022-05-10 | Boone | Indiana | 18011 | 15404 | 185 |
2487254 | 2487254 | 2022-05-09 | Boone | Indiana | 18011 | 15404 | 185 |
2483996 | 2483996 | 2022-05-08 | Boone | Indiana | 18011 | 15357 | 184 |
2480738 | 2480738 | 2022-05-07 | Boone | Indiana | 18011 | 15357 | 184 |
2477480 | 2477480 | 2022-05-06 | Boone | Indiana | 18011 | 15357 | 184 |
2474222 | 2474222 | 2022-05-05 | Boone | Indiana | 18011 | 15357 | 184 |
2470965 | 2470965 | 2022-05-04 | Boone | Indiana | 18011 | 15357 | 184 |
2467709 | 2467709 | 2022-05-03 | Boone | Indiana | 18011 | 15345 | 184 |
2464454 | 2464454 | 2022-05-02 | Boone | Indiana | 18011 | 15345 | 184 |
2461198 | 2461198 | 2022-05-01 | Boone | Indiana | 18011 | 15328 | 183 |
2457942 | 2457942 | 2022-04-30 | Boone | Indiana | 18011 | 15328 | 183 |
2454686 | 2454686 | 2022-04-29 | Boone | Indiana | 18011 | 15328 | 183 |
2451430 | 2451430 | 2022-04-28 | Boone | Indiana | 18011 | 15319 | 184 |
2448174 | 2448174 | 2022-04-27 | Boone | Indiana | 18011 | 15319 | 184 |
2444918 | 2444918 | 2022-04-26 | Boone | Indiana | 18011 | 15299 | 184 |
2441662 | 2441662 | 2022-04-25 | Boone | Indiana | 18011 | 15299 | 184 |
2438406 | 2438406 | 2022-04-24 | Boone | Indiana | 18011 | 15258 | 184 |
2435150 | 2435150 | 2022-04-23 | Boone | Indiana | 18011 | 15258 | 184 |
2431894 | 2431894 | 2022-04-22 | Boone | Indiana | 18011 | 15258 | 184 |
2428638 | 2428638 | 2022-04-21 | Boone | Indiana | 18011 | 15255 | 183 |
2425382 | 2425382 | 2022-04-20 | Boone | Indiana | 18011 | 15255 | 183 |
2422126 | 2422126 | 2022-04-19 | Boone | Indiana | 18011 | 15244 | 183 |
2418870 | 2418870 | 2022-04-18 | Boone | Indiana | 18011 | 15244 | 183 |
2415614 | 2415614 | 2022-04-17 | Boone | Indiana | 18011 | 15226 | 183 |
2412358 | 2412358 | 2022-04-16 | Boone | Indiana | 18011 | 15226 | 183 |
2409102 | 2409102 | 2022-04-15 | Boone | Indiana | 18011 | 15226 | 183 |
2405846 | 2405846 | 2022-04-14 | Boone | Indiana | 18011 | 15226 | 183 |
2402591 | 2402591 | 2022-04-13 | Boone | Indiana | 18011 | 15226 | 183 |
2399336 | 2399336 | 2022-04-12 | Boone | Indiana | 18011 | 15215 | 183 |
2396081 | 2396081 | 2022-04-11 | Boone | Indiana | 18011 | 15215 | 183 |
2392825 | 2392825 | 2022-04-10 | Boone | Indiana | 18011 | 15203 | 182 |
2389569 | 2389569 | 2022-04-09 | Boone | Indiana | 18011 | 15203 | 182 |
2386314 | 2386314 | 2022-04-08 | Boone | Indiana | 18011 | 15203 | 182 |
2383059 | 2383059 | 2022-04-07 | Boone | Indiana | 18011 | 15190 | 181 |
2379804 | 2379804 | 2022-04-06 | Boone | Indiana | 18011 | 15190 | 181 |
2376550 | 2376550 | 2022-04-05 | Boone | Indiana | 18011 | 15182 | 181 |
2373298 | 2373298 | 2022-04-04 | Boone | Indiana | 18011 | 15182 | 181 |
2370045 | 2370045 | 2022-04-03 | Boone | Indiana | 18011 | 15173 | 181 |
2366792 | 2366792 | 2022-04-02 | Boone | Indiana | 18011 | 15173 | 181 |
2363539 | 2363539 | 2022-04-01 | Boone | Indiana | 18011 | 15173 | 181 |
2360285 | 2360285 | 2022-03-31 | Boone | Indiana | 18011 | 15164 | 181 |
2357031 | 2357031 | 2022-03-30 | Boone | Indiana | 18011 | 15164 | 181 |
2353778 | 2353778 | 2022-03-29 | Boone | Indiana | 18011 | 15189 | 181 |
2350526 | 2350526 | 2022-03-28 | Boone | Indiana | 18011 | 15187 | 181 |
2347273 | 2347273 | 2022-03-27 | Boone | Indiana | 18011 | 15177 | 181 |
2344020 | 2344020 | 2022-03-26 | Boone | Indiana | 18011 | 15177 | 181 |
2340767 | 2340767 | 2022-03-25 | Boone | Indiana | 18011 | 15177 | 181 |
2337514 | 2337514 | 2022-03-24 | Boone | Indiana | 18011 | 15174 | 181 |
2334260 | 2334260 | 2022-03-23 | Boone | Indiana | 18011 | 15169 | 180 |
2331006 | 2331006 | 2022-03-22 | Boone | Indiana | 18011 | 15166 | 180 |
2327754 | 2327754 | 2022-03-21 | Boone | Indiana | 18011 | 15163 | 179 |
2324501 | 2324501 | 2022-03-20 | Boone | Indiana | 18011 | 15152 | 179 |
2321247 | 2321247 | 2022-03-19 | Boone | Indiana | 18011 | 15152 | 179 |
2317993 | 2317993 | 2022-03-18 | Boone | Indiana | 18011 | 15152 | 179 |
2314740 | 2314740 | 2022-03-17 | Boone | Indiana | 18011 | 15149 | 179 |
2311487 | 2311487 | 2022-03-16 | Boone | Indiana | 18011 | 15143 | 178 |
2308234 | 2308234 | 2022-03-15 | Boone | Indiana | 18011 | 15139 | 177 |
2304983 | 2304983 | 2022-03-14 | Boone | Indiana | 18011 | 15138 | 176 |
2301731 | 2301731 | 2022-03-13 | Boone | Indiana | 18011 | 15124 | 175 |
2298479 | 2298479 | 2022-03-12 | Boone | Indiana | 18011 | 15124 | 175 |
2295227 | 2295227 | 2022-03-11 | Boone | Indiana | 18011 | 15124 | 175 |
2291975 | 2291975 | 2022-03-10 | Boone | Indiana | 18011 | 15124 | 175 |
2288723 | 2288723 | 2022-03-09 | Boone | Indiana | 18011 | 15110 | 175 |
2285472 | 2285472 | 2022-03-08 | Boone | Indiana | 18011 | 15102 | 175 |
2282220 | 2282220 | 2022-03-07 | Boone | Indiana | 18011 | 15092 | 175 |
2278967 | 2278967 | 2022-03-06 | Boone | Indiana | 18011 | 15080 | 175 |
2275714 | 2275714 | 2022-03-05 | Boone | Indiana | 18011 | 15080 | 175 |
2272461 | 2272461 | 2022-03-04 | Boone | Indiana | 18011 | 15080 | 175 |
2269209 | 2269209 | 2022-03-03 | Boone | Indiana | 18011 | 15072 | 173 |
2265956 | 2265956 | 2022-03-02 | Boone | Indiana | 18011 | 15064 | 173 |
2262705 | 2262705 | 2022-03-01 | Boone | Indiana | 18011 | 15059 | 173 |
2259454 | 2259454 | 2022-02-28 | Boone | Indiana | 18011 | 15055 | 173 |
2256203 | 2256203 | 2022-02-27 | Boone | Indiana | 18011 | 15044 | 173 |
2252952 | 2252952 | 2022-02-26 | Boone | Indiana | 18011 | 15044 | 173 |
2249701 | 2249701 | 2022-02-25 | Boone | Indiana | 18011 | 15044 | 173 |
2246450 | 2246450 | 2022-02-24 | Boone | Indiana | 18011 | 15037 | 172 |
2243199 | 2243199 | 2022-02-23 | Boone | Indiana | 18011 | 15030 | 172 |
2239948 | 2239948 | 2022-02-22 | Boone | Indiana | 18011 | 15022 | 172 |
2236697 | 2236697 | 2022-02-21 | Boone | Indiana | 18011 | 15012 | 172 |
2233446 | 2233446 | 2022-02-20 | Boone | Indiana | 18011 | 14986 | 172 |
2230195 | 2230195 | 2022-02-19 | Boone | Indiana | 18011 | 14986 | 172 |
2226944 | 2226944 | 2022-02-18 | Boone | Indiana | 18011 | 14986 | 172 |
2223693 | 2223693 | 2022-02-17 | Boone | Indiana | 18011 | 14963 | 170 |
2220442 | 2220442 | 2022-02-16 | Boone | Indiana | 18011 | 14946 | 170 |
2217191 | 2217191 | 2022-02-15 | Boone | Indiana | 18011 | 14934 | 164 |
2213940 | 2213940 | 2022-02-14 | Boone | Indiana | 18011 | 14919 | 163 |
2210688 | 2210688 | 2022-02-13 | Boone | Indiana | 18011 | 14868 | 163 |
2207435 | 2207435 | 2022-02-12 | Boone | Indiana | 18011 | 14868 | 163 |
2204182 | 2204182 | 2022-02-11 | Boone | Indiana | 18011 | 14868 | 163 |
2200929 | 2200929 | 2022-02-10 | Boone | Indiana | 18011 | 14832 | 159 |
2197675 | 2197675 | 2022-02-09 | Boone | Indiana | 18011 | 14776 | 158 |
2194421 | 2194421 | 2022-02-08 | Boone | Indiana | 18011 | 14776 | 158 |
2191167 | 2191167 | 2022-02-07 | Boone | Indiana | 18011 | 14736 | 158 |
2187914 | 2187914 | 2022-02-06 | Boone | Indiana | 18011 | 14688 | 156 |
2184661 | 2184661 | 2022-02-05 | Boone | Indiana | 18011 | 14688 | 156 |
2181409 | 2181409 | 2022-02-04 | Boone | Indiana | 18011 | 14688 | 156 |
2178158 | 2178158 | 2022-02-03 | Boone | Indiana | 18011 | 14636 | 156 |
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);