ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 18069 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 |
---|---|---|---|---|---|---|---|
2500314 | 2500314 | 2022-05-13 | Huntington | Indiana | 18069 | 11572 | 157 |
2497056 | 2497056 | 2022-05-12 | Huntington | Indiana | 18069 | 11562 | 157 |
2493798 | 2493798 | 2022-05-11 | Huntington | Indiana | 18069 | 11562 | 157 |
2490540 | 2490540 | 2022-05-10 | Huntington | Indiana | 18069 | 11554 | 157 |
2487283 | 2487283 | 2022-05-09 | Huntington | Indiana | 18069 | 11554 | 157 |
2484025 | 2484025 | 2022-05-08 | Huntington | Indiana | 18069 | 11542 | 157 |
2480767 | 2480767 | 2022-05-07 | Huntington | Indiana | 18069 | 11542 | 157 |
2477509 | 2477509 | 2022-05-06 | Huntington | Indiana | 18069 | 11542 | 157 |
2474251 | 2474251 | 2022-05-05 | Huntington | Indiana | 18069 | 11542 | 157 |
2470994 | 2470994 | 2022-05-04 | Huntington | Indiana | 18069 | 11542 | 157 |
2467738 | 2467738 | 2022-05-03 | Huntington | Indiana | 18069 | 11535 | 157 |
2464483 | 2464483 | 2022-05-02 | Huntington | Indiana | 18069 | 11535 | 157 |
2461227 | 2461227 | 2022-05-01 | Huntington | Indiana | 18069 | 11525 | 157 |
2457971 | 2457971 | 2022-04-30 | Huntington | Indiana | 18069 | 11525 | 157 |
2454715 | 2454715 | 2022-04-29 | Huntington | Indiana | 18069 | 11525 | 157 |
2451459 | 2451459 | 2022-04-28 | Huntington | Indiana | 18069 | 11516 | 157 |
2448203 | 2448203 | 2022-04-27 | Huntington | Indiana | 18069 | 11516 | 157 |
2444947 | 2444947 | 2022-04-26 | Huntington | Indiana | 18069 | 11510 | 157 |
2441691 | 2441691 | 2022-04-25 | Huntington | Indiana | 18069 | 11510 | 157 |
2438435 | 2438435 | 2022-04-24 | Huntington | Indiana | 18069 | 11504 | 157 |
2435179 | 2435179 | 2022-04-23 | Huntington | Indiana | 18069 | 11504 | 157 |
2431923 | 2431923 | 2022-04-22 | Huntington | Indiana | 18069 | 11504 | 157 |
2428667 | 2428667 | 2022-04-21 | Huntington | Indiana | 18069 | 11503 | 157 |
2425411 | 2425411 | 2022-04-20 | Huntington | Indiana | 18069 | 11503 | 157 |
2422155 | 2422155 | 2022-04-19 | Huntington | Indiana | 18069 | 11499 | 156 |
2418899 | 2418899 | 2022-04-18 | Huntington | Indiana | 18069 | 11499 | 156 |
2415643 | 2415643 | 2022-04-17 | Huntington | Indiana | 18069 | 11495 | 156 |
2412387 | 2412387 | 2022-04-16 | Huntington | Indiana | 18069 | 11495 | 156 |
2409131 | 2409131 | 2022-04-15 | Huntington | Indiana | 18069 | 11495 | 156 |
2405875 | 2405875 | 2022-04-14 | Huntington | Indiana | 18069 | 11495 | 156 |
2402620 | 2402620 | 2022-04-13 | Huntington | Indiana | 18069 | 11495 | 156 |
2399365 | 2399365 | 2022-04-12 | Huntington | Indiana | 18069 | 11492 | 155 |
2396110 | 2396110 | 2022-04-11 | Huntington | Indiana | 18069 | 11492 | 155 |
2392854 | 2392854 | 2022-04-10 | Huntington | Indiana | 18069 | 11490 | 155 |
2389598 | 2389598 | 2022-04-09 | Huntington | Indiana | 18069 | 11490 | 155 |
2386343 | 2386343 | 2022-04-08 | Huntington | Indiana | 18069 | 11490 | 155 |
2383088 | 2383088 | 2022-04-07 | Huntington | Indiana | 18069 | 11490 | 155 |
2379833 | 2379833 | 2022-04-06 | Huntington | Indiana | 18069 | 11490 | 155 |
2376579 | 2376579 | 2022-04-05 | Huntington | Indiana | 18069 | 11490 | 155 |
2373327 | 2373327 | 2022-04-04 | Huntington | Indiana | 18069 | 11490 | 155 |
2370074 | 2370074 | 2022-04-03 | Huntington | Indiana | 18069 | 11486 | 155 |
2366821 | 2366821 | 2022-04-02 | Huntington | Indiana | 18069 | 11486 | 155 |
2363568 | 2363568 | 2022-04-01 | Huntington | Indiana | 18069 | 11486 | 155 |
2360314 | 2360314 | 2022-03-31 | Huntington | Indiana | 18069 | 11485 | 155 |
2357060 | 2357060 | 2022-03-30 | Huntington | Indiana | 18069 | 11485 | 155 |
2353807 | 2353807 | 2022-03-29 | Huntington | Indiana | 18069 | 11493 | 155 |
2350555 | 2350555 | 2022-03-28 | Huntington | Indiana | 18069 | 11492 | 155 |
2347302 | 2347302 | 2022-03-27 | Huntington | Indiana | 18069 | 11493 | 155 |
2344049 | 2344049 | 2022-03-26 | Huntington | Indiana | 18069 | 11493 | 155 |
2340796 | 2340796 | 2022-03-25 | Huntington | Indiana | 18069 | 11493 | 155 |
2337543 | 2337543 | 2022-03-24 | Huntington | Indiana | 18069 | 11492 | 155 |
2334289 | 2334289 | 2022-03-23 | Huntington | Indiana | 18069 | 11490 | 155 |
2331035 | 2331035 | 2022-03-22 | Huntington | Indiana | 18069 | 11487 | 155 |
2327783 | 2327783 | 2022-03-21 | Huntington | Indiana | 18069 | 11486 | 155 |
2324530 | 2324530 | 2022-03-20 | Huntington | Indiana | 18069 | 11481 | 155 |
2321276 | 2321276 | 2022-03-19 | Huntington | Indiana | 18069 | 11481 | 155 |
2318022 | 2318022 | 2022-03-18 | Huntington | Indiana | 18069 | 11481 | 155 |
2314769 | 2314769 | 2022-03-17 | Huntington | Indiana | 18069 | 11480 | 155 |
2311516 | 2311516 | 2022-03-16 | Huntington | Indiana | 18069 | 11480 | 155 |
2308263 | 2308263 | 2022-03-15 | Huntington | Indiana | 18069 | 11479 | 153 |
2305012 | 2305012 | 2022-03-14 | Huntington | Indiana | 18069 | 11478 | 153 |
2301760 | 2301760 | 2022-03-13 | Huntington | Indiana | 18069 | 11473 | 153 |
2298508 | 2298508 | 2022-03-12 | Huntington | Indiana | 18069 | 11473 | 153 |
2295256 | 2295256 | 2022-03-11 | Huntington | Indiana | 18069 | 11473 | 153 |
2292004 | 2292004 | 2022-03-10 | Huntington | Indiana | 18069 | 11473 | 153 |
2288752 | 2288752 | 2022-03-09 | Huntington | Indiana | 18069 | 11471 | 153 |
2285501 | 2285501 | 2022-03-08 | Huntington | Indiana | 18069 | 11470 | 153 |
2282249 | 2282249 | 2022-03-07 | Huntington | Indiana | 18069 | 11469 | 153 |
2278996 | 2278996 | 2022-03-06 | Huntington | Indiana | 18069 | 11461 | 153 |
2275743 | 2275743 | 2022-03-05 | Huntington | Indiana | 18069 | 11461 | 153 |
2272490 | 2272490 | 2022-03-04 | Huntington | Indiana | 18069 | 11461 | 153 |
2269238 | 2269238 | 2022-03-03 | Huntington | Indiana | 18069 | 11458 | 153 |
2265985 | 2265985 | 2022-03-02 | Huntington | Indiana | 18069 | 11453 | 153 |
2262734 | 2262734 | 2022-03-01 | Huntington | Indiana | 18069 | 11442 | 153 |
2259483 | 2259483 | 2022-02-28 | Huntington | Indiana | 18069 | 11439 | 152 |
2256232 | 2256232 | 2022-02-27 | Huntington | Indiana | 18069 | 11430 | 152 |
2252981 | 2252981 | 2022-02-26 | Huntington | Indiana | 18069 | 11430 | 152 |
2249730 | 2249730 | 2022-02-25 | Huntington | Indiana | 18069 | 11430 | 152 |
2246479 | 2246479 | 2022-02-24 | Huntington | Indiana | 18069 | 11421 | 152 |
2243228 | 2243228 | 2022-02-23 | Huntington | Indiana | 18069 | 11415 | 152 |
2239977 | 2239977 | 2022-02-22 | Huntington | Indiana | 18069 | 11409 | 152 |
2236726 | 2236726 | 2022-02-21 | Huntington | Indiana | 18069 | 11402 | 152 |
2233475 | 2233475 | 2022-02-20 | Huntington | Indiana | 18069 | 11389 | 151 |
2230224 | 2230224 | 2022-02-19 | Huntington | Indiana | 18069 | 11389 | 151 |
2226973 | 2226973 | 2022-02-18 | Huntington | Indiana | 18069 | 11389 | 151 |
2223722 | 2223722 | 2022-02-17 | Huntington | Indiana | 18069 | 11380 | 150 |
2220471 | 2220471 | 2022-02-16 | Huntington | Indiana | 18069 | 11374 | 150 |
2217220 | 2217220 | 2022-02-15 | Huntington | Indiana | 18069 | 11363 | 149 |
2213969 | 2213969 | 2022-02-14 | Huntington | Indiana | 18069 | 11355 | 148 |
2210717 | 2210717 | 2022-02-13 | Huntington | Indiana | 18069 | 11331 | 148 |
2207464 | 2207464 | 2022-02-12 | Huntington | Indiana | 18069 | 11331 | 148 |
2204211 | 2204211 | 2022-02-11 | Huntington | Indiana | 18069 | 11331 | 148 |
2200958 | 2200958 | 2022-02-10 | Huntington | Indiana | 18069 | 11317 | 148 |
2197704 | 2197704 | 2022-02-09 | Huntington | Indiana | 18069 | 11280 | 147 |
2194450 | 2194450 | 2022-02-08 | Huntington | Indiana | 18069 | 11280 | 147 |
2191196 | 2191196 | 2022-02-07 | Huntington | Indiana | 18069 | 11261 | 146 |
2187943 | 2187943 | 2022-02-06 | Huntington | Indiana | 18069 | 11218 | 146 |
2184690 | 2184690 | 2022-02-05 | Huntington | Indiana | 18069 | 11218 | 146 |
2181438 | 2181438 | 2022-02-04 | Huntington | Indiana | 18069 | 11218 | 146 |
2178187 | 2178187 | 2022-02-03 | Huntington | Indiana | 18069 | 11184 | 146 |
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);