ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Warrick" 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 |
---|---|---|---|---|---|---|---|
2500367 | 2500367 | 2022-05-13 | Warrick | Indiana | 18173 | 20420 | 239 |
2497109 | 2497109 | 2022-05-12 | Warrick | Indiana | 18173 | 20393 | 239 |
2493851 | 2493851 | 2022-05-11 | Warrick | Indiana | 18173 | 20393 | 239 |
2490593 | 2490593 | 2022-05-10 | Warrick | Indiana | 18173 | 20368 | 239 |
2487336 | 2487336 | 2022-05-09 | Warrick | Indiana | 18173 | 20368 | 239 |
2484078 | 2484078 | 2022-05-08 | Warrick | Indiana | 18173 | 20343 | 239 |
2480820 | 2480820 | 2022-05-07 | Warrick | Indiana | 18173 | 20343 | 239 |
2477562 | 2477562 | 2022-05-06 | Warrick | Indiana | 18173 | 20343 | 239 |
2474304 | 2474304 | 2022-05-05 | Warrick | Indiana | 18173 | 20343 | 239 |
2471047 | 2471047 | 2022-05-04 | Warrick | Indiana | 18173 | 20343 | 239 |
2467791 | 2467791 | 2022-05-03 | Warrick | Indiana | 18173 | 20328 | 239 |
2464536 | 2464536 | 2022-05-02 | Warrick | Indiana | 18173 | 20328 | 239 |
2461280 | 2461280 | 2022-05-01 | Warrick | Indiana | 18173 | 20313 | 239 |
2458024 | 2458024 | 2022-04-30 | Warrick | Indiana | 18173 | 20313 | 239 |
2454768 | 2454768 | 2022-04-29 | Warrick | Indiana | 18173 | 20313 | 239 |
2451512 | 2451512 | 2022-04-28 | Warrick | Indiana | 18173 | 20307 | 239 |
2448256 | 2448256 | 2022-04-27 | Warrick | Indiana | 18173 | 20307 | 239 |
2445000 | 2445000 | 2022-04-26 | Warrick | Indiana | 18173 | 20301 | 239 |
2441744 | 2441744 | 2022-04-25 | Warrick | Indiana | 18173 | 20301 | 239 |
2438488 | 2438488 | 2022-04-24 | Warrick | Indiana | 18173 | 20297 | 239 |
2435232 | 2435232 | 2022-04-23 | Warrick | Indiana | 18173 | 20297 | 239 |
2431976 | 2431976 | 2022-04-22 | Warrick | Indiana | 18173 | 20297 | 239 |
2428720 | 2428720 | 2022-04-21 | Warrick | Indiana | 18173 | 20285 | 238 |
2425464 | 2425464 | 2022-04-20 | Warrick | Indiana | 18173 | 20285 | 238 |
2422208 | 2422208 | 2022-04-19 | Warrick | Indiana | 18173 | 20280 | 238 |
2418952 | 2418952 | 2022-04-18 | Warrick | Indiana | 18173 | 20280 | 238 |
2415696 | 2415696 | 2022-04-17 | Warrick | Indiana | 18173 | 20267 | 238 |
2412440 | 2412440 | 2022-04-16 | Warrick | Indiana | 18173 | 20267 | 238 |
2409184 | 2409184 | 2022-04-15 | Warrick | Indiana | 18173 | 20267 | 238 |
2405928 | 2405928 | 2022-04-14 | Warrick | Indiana | 18173 | 20267 | 238 |
2402672 | 2402672 | 2022-04-13 | Warrick | Indiana | 18173 | 20267 | 238 |
2399418 | 2399418 | 2022-04-12 | Warrick | Indiana | 18173 | 20263 | 238 |
2396162 | 2396162 | 2022-04-11 | Warrick | Indiana | 18173 | 20263 | 238 |
2392907 | 2392907 | 2022-04-10 | Warrick | Indiana | 18173 | 20261 | 238 |
2389651 | 2389651 | 2022-04-09 | Warrick | Indiana | 18173 | 20261 | 238 |
2386395 | 2386395 | 2022-04-08 | Warrick | Indiana | 18173 | 20261 | 238 |
2383141 | 2383141 | 2022-04-07 | Warrick | Indiana | 18173 | 20259 | 238 |
2379886 | 2379886 | 2022-04-06 | Warrick | Indiana | 18173 | 20259 | 238 |
2376631 | 2376631 | 2022-04-05 | Warrick | Indiana | 18173 | 20258 | 238 |
2373379 | 2373379 | 2022-04-04 | Warrick | Indiana | 18173 | 20258 | 238 |
2370126 | 2370126 | 2022-04-03 | Warrick | Indiana | 18173 | 20252 | 238 |
2366873 | 2366873 | 2022-04-02 | Warrick | Indiana | 18173 | 20252 | 238 |
2363620 | 2363620 | 2022-04-01 | Warrick | Indiana | 18173 | 20252 | 238 |
2360366 | 2360366 | 2022-03-31 | Warrick | Indiana | 18173 | 20242 | 237 |
2357112 | 2357112 | 2022-03-30 | Warrick | Indiana | 18173 | 20242 | 237 |
2353859 | 2353859 | 2022-03-29 | Warrick | Indiana | 18173 | 20248 | 237 |
2350607 | 2350607 | 2022-03-28 | Warrick | Indiana | 18173 | 20246 | 237 |
2347354 | 2347354 | 2022-03-27 | Warrick | Indiana | 18173 | 20244 | 237 |
2344101 | 2344101 | 2022-03-26 | Warrick | Indiana | 18173 | 20244 | 237 |
2340848 | 2340848 | 2022-03-25 | Warrick | Indiana | 18173 | 20244 | 237 |
2337595 | 2337595 | 2022-03-24 | Warrick | Indiana | 18173 | 20243 | 237 |
2334341 | 2334341 | 2022-03-23 | Warrick | Indiana | 18173 | 20241 | 237 |
2331087 | 2331087 | 2022-03-22 | Warrick | Indiana | 18173 | 20239 | 237 |
2327835 | 2327835 | 2022-03-21 | Warrick | Indiana | 18173 | 20235 | 237 |
2324582 | 2324582 | 2022-03-20 | Warrick | Indiana | 18173 | 20230 | 237 |
2321328 | 2321328 | 2022-03-19 | Warrick | Indiana | 18173 | 20230 | 237 |
2318074 | 2318074 | 2022-03-18 | Warrick | Indiana | 18173 | 20230 | 237 |
2314821 | 2314821 | 2022-03-17 | Warrick | Indiana | 18173 | 20227 | 237 |
2311568 | 2311568 | 2022-03-16 | Warrick | Indiana | 18173 | 20225 | 236 |
2308315 | 2308315 | 2022-03-15 | Warrick | Indiana | 18173 | 20223 | 236 |
2305064 | 2305064 | 2022-03-14 | Warrick | Indiana | 18173 | 20220 | 236 |
2301812 | 2301812 | 2022-03-13 | Warrick | Indiana | 18173 | 20214 | 236 |
2298560 | 2298560 | 2022-03-12 | Warrick | Indiana | 18173 | 20214 | 236 |
2295308 | 2295308 | 2022-03-11 | Warrick | Indiana | 18173 | 20214 | 236 |
2292056 | 2292056 | 2022-03-10 | Warrick | Indiana | 18173 | 20212 | 235 |
2288804 | 2288804 | 2022-03-09 | Warrick | Indiana | 18173 | 20207 | 235 |
2285553 | 2285553 | 2022-03-08 | Warrick | Indiana | 18173 | 20203 | 233 |
2282301 | 2282301 | 2022-03-07 | Warrick | Indiana | 18173 | 20197 | 233 |
2279048 | 2279048 | 2022-03-06 | Warrick | Indiana | 18173 | 20187 | 233 |
2275795 | 2275795 | 2022-03-05 | Warrick | Indiana | 18173 | 20187 | 233 |
2272542 | 2272542 | 2022-03-04 | Warrick | Indiana | 18173 | 20187 | 233 |
2269290 | 2269290 | 2022-03-03 | Warrick | Indiana | 18173 | 20179 | 232 |
2266037 | 2266037 | 2022-03-02 | Warrick | Indiana | 18173 | 20171 | 232 |
2262786 | 2262786 | 2022-03-01 | Warrick | Indiana | 18173 | 20167 | 232 |
2259535 | 2259535 | 2022-02-28 | Warrick | Indiana | 18173 | 20158 | 232 |
2256284 | 2256284 | 2022-02-27 | Warrick | Indiana | 18173 | 20139 | 232 |
2253033 | 2253033 | 2022-02-26 | Warrick | Indiana | 18173 | 20139 | 232 |
2249782 | 2249782 | 2022-02-25 | Warrick | Indiana | 18173 | 20139 | 232 |
2246531 | 2246531 | 2022-02-24 | Warrick | Indiana | 18173 | 20126 | 232 |
2243280 | 2243280 | 2022-02-23 | Warrick | Indiana | 18173 | 20109 | 232 |
2240029 | 2240029 | 2022-02-22 | Warrick | Indiana | 18173 | 20095 | 231 |
2236778 | 2236778 | 2022-02-21 | Warrick | Indiana | 18173 | 20077 | 231 |
2233527 | 2233527 | 2022-02-20 | Warrick | Indiana | 18173 | 20030 | 229 |
2230276 | 2230276 | 2022-02-19 | Warrick | Indiana | 18173 | 20030 | 229 |
2227025 | 2227025 | 2022-02-18 | Warrick | Indiana | 18173 | 20030 | 229 |
2223774 | 2223774 | 2022-02-17 | Warrick | Indiana | 18173 | 19989 | 227 |
2220523 | 2220523 | 2022-02-16 | Warrick | Indiana | 18173 | 19970 | 227 |
2217272 | 2217272 | 2022-02-15 | Warrick | Indiana | 18173 | 19948 | 227 |
2214021 | 2214021 | 2022-02-14 | Warrick | Indiana | 18173 | 19928 | 227 |
2210769 | 2210769 | 2022-02-13 | Warrick | Indiana | 18173 | 19865 | 227 |
2207516 | 2207516 | 2022-02-12 | Warrick | Indiana | 18173 | 19865 | 227 |
2204263 | 2204263 | 2022-02-11 | Warrick | Indiana | 18173 | 19865 | 227 |
2201010 | 2201010 | 2022-02-10 | Warrick | Indiana | 18173 | 19818 | 226 |
2197756 | 2197756 | 2022-02-09 | Warrick | Indiana | 18173 | 19725 | 226 |
2194502 | 2194502 | 2022-02-08 | Warrick | Indiana | 18173 | 19725 | 226 |
2191248 | 2191248 | 2022-02-07 | Warrick | Indiana | 18173 | 19676 | 226 |
2187995 | 2187995 | 2022-02-06 | Warrick | Indiana | 18173 | 19557 | 225 |
2184742 | 2184742 | 2022-02-05 | Warrick | Indiana | 18173 | 19557 | 225 |
2181490 | 2181490 | 2022-02-04 | Warrick | Indiana | 18173 | 19557 | 225 |
2178239 | 2178239 | 2022-02-03 | Warrick | Indiana | 18173 | 19457 | 225 |
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);