ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 18057 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 |
---|---|---|---|---|---|---|---|
2500308 | 2500308 | 2022-05-13 | Hamilton | Indiana | 18057 | 83430 | 661 |
2497050 | 2497050 | 2022-05-12 | Hamilton | Indiana | 18057 | 83231 | 661 |
2493792 | 2493792 | 2022-05-11 | Hamilton | Indiana | 18057 | 83231 | 661 |
2490534 | 2490534 | 2022-05-10 | Hamilton | Indiana | 18057 | 83088 | 661 |
2487277 | 2487277 | 2022-05-09 | Hamilton | Indiana | 18057 | 83088 | 661 |
2484019 | 2484019 | 2022-05-08 | Hamilton | Indiana | 18057 | 82726 | 661 |
2480761 | 2480761 | 2022-05-07 | Hamilton | Indiana | 18057 | 82726 | 661 |
2477503 | 2477503 | 2022-05-06 | Hamilton | Indiana | 18057 | 82726 | 661 |
2474245 | 2474245 | 2022-05-05 | Hamilton | Indiana | 18057 | 82726 | 661 |
2470988 | 2470988 | 2022-05-04 | Hamilton | Indiana | 18057 | 82726 | 661 |
2467732 | 2467732 | 2022-05-03 | Hamilton | Indiana | 18057 | 82605 | 661 |
2464477 | 2464477 | 2022-05-02 | Hamilton | Indiana | 18057 | 82605 | 661 |
2461221 | 2461221 | 2022-05-01 | Hamilton | Indiana | 18057 | 82492 | 661 |
2457965 | 2457965 | 2022-04-30 | Hamilton | Indiana | 18057 | 82492 | 661 |
2454709 | 2454709 | 2022-04-29 | Hamilton | Indiana | 18057 | 82492 | 661 |
2451453 | 2451453 | 2022-04-28 | Hamilton | Indiana | 18057 | 82373 | 661 |
2448197 | 2448197 | 2022-04-27 | Hamilton | Indiana | 18057 | 82373 | 661 |
2444941 | 2444941 | 2022-04-26 | Hamilton | Indiana | 18057 | 82271 | 661 |
2441685 | 2441685 | 2022-04-25 | Hamilton | Indiana | 18057 | 82271 | 661 |
2438429 | 2438429 | 2022-04-24 | Hamilton | Indiana | 18057 | 82116 | 661 |
2435173 | 2435173 | 2022-04-23 | Hamilton | Indiana | 18057 | 82116 | 661 |
2431917 | 2431917 | 2022-04-22 | Hamilton | Indiana | 18057 | 82116 | 661 |
2428661 | 2428661 | 2022-04-21 | Hamilton | Indiana | 18057 | 82039 | 661 |
2425405 | 2425405 | 2022-04-20 | Hamilton | Indiana | 18057 | 82039 | 661 |
2422149 | 2422149 | 2022-04-19 | Hamilton | Indiana | 18057 | 81980 | 660 |
2418893 | 2418893 | 2022-04-18 | Hamilton | Indiana | 18057 | 81980 | 660 |
2415637 | 2415637 | 2022-04-17 | Hamilton | Indiana | 18057 | 81880 | 660 |
2412381 | 2412381 | 2022-04-16 | Hamilton | Indiana | 18057 | 81880 | 660 |
2409125 | 2409125 | 2022-04-15 | Hamilton | Indiana | 18057 | 81880 | 660 |
2405869 | 2405869 | 2022-04-14 | Hamilton | Indiana | 18057 | 81880 | 660 |
2402614 | 2402614 | 2022-04-13 | Hamilton | Indiana | 18057 | 81880 | 660 |
2399359 | 2399359 | 2022-04-12 | Hamilton | Indiana | 18057 | 81852 | 659 |
2396104 | 2396104 | 2022-04-11 | Hamilton | Indiana | 18057 | 81852 | 659 |
2392848 | 2392848 | 2022-04-10 | Hamilton | Indiana | 18057 | 81823 | 659 |
2389592 | 2389592 | 2022-04-09 | Hamilton | Indiana | 18057 | 81823 | 659 |
2386337 | 2386337 | 2022-04-08 | Hamilton | Indiana | 18057 | 81823 | 659 |
2383082 | 2383082 | 2022-04-07 | Hamilton | Indiana | 18057 | 81801 | 658 |
2379827 | 2379827 | 2022-04-06 | Hamilton | Indiana | 18057 | 81801 | 658 |
2376573 | 2376573 | 2022-04-05 | Hamilton | Indiana | 18057 | 81784 | 657 |
2373321 | 2373321 | 2022-04-04 | Hamilton | Indiana | 18057 | 81784 | 657 |
2370068 | 2370068 | 2022-04-03 | Hamilton | Indiana | 18057 | 81748 | 656 |
2366815 | 2366815 | 2022-04-02 | Hamilton | Indiana | 18057 | 81748 | 656 |
2363562 | 2363562 | 2022-04-01 | Hamilton | Indiana | 18057 | 81748 | 656 |
2360308 | 2360308 | 2022-03-31 | Hamilton | Indiana | 18057 | 81697 | 656 |
2357054 | 2357054 | 2022-03-30 | Hamilton | Indiana | 18057 | 81697 | 656 |
2353801 | 2353801 | 2022-03-29 | Hamilton | Indiana | 18057 | 81765 | 656 |
2350549 | 2350549 | 2022-03-28 | Hamilton | Indiana | 18057 | 81754 | 654 |
2347296 | 2347296 | 2022-03-27 | Hamilton | Indiana | 18057 | 81728 | 654 |
2344043 | 2344043 | 2022-03-26 | Hamilton | Indiana | 18057 | 81728 | 654 |
2340790 | 2340790 | 2022-03-25 | Hamilton | Indiana | 18057 | 81728 | 654 |
2337537 | 2337537 | 2022-03-24 | Hamilton | Indiana | 18057 | 81715 | 654 |
2334283 | 2334283 | 2022-03-23 | Hamilton | Indiana | 18057 | 81704 | 654 |
2331029 | 2331029 | 2022-03-22 | Hamilton | Indiana | 18057 | 81689 | 653 |
2327777 | 2327777 | 2022-03-21 | Hamilton | Indiana | 18057 | 81670 | 653 |
2324524 | 2324524 | 2022-03-20 | Hamilton | Indiana | 18057 | 81626 | 653 |
2321270 | 2321270 | 2022-03-19 | Hamilton | Indiana | 18057 | 81626 | 653 |
2318016 | 2318016 | 2022-03-18 | Hamilton | Indiana | 18057 | 81626 | 653 |
2314763 | 2314763 | 2022-03-17 | Hamilton | Indiana | 18057 | 81601 | 652 |
2311510 | 2311510 | 2022-03-16 | Hamilton | Indiana | 18057 | 81588 | 652 |
2308257 | 2308257 | 2022-03-15 | Hamilton | Indiana | 18057 | 81573 | 652 |
2305006 | 2305006 | 2022-03-14 | Hamilton | Indiana | 18057 | 81563 | 651 |
2301754 | 2301754 | 2022-03-13 | Hamilton | Indiana | 18057 | 81531 | 650 |
2298502 | 2298502 | 2022-03-12 | Hamilton | Indiana | 18057 | 81531 | 650 |
2295250 | 2295250 | 2022-03-11 | Hamilton | Indiana | 18057 | 81531 | 650 |
2291998 | 2291998 | 2022-03-10 | Hamilton | Indiana | 18057 | 81517 | 648 |
2288746 | 2288746 | 2022-03-09 | Hamilton | Indiana | 18057 | 81498 | 648 |
2285495 | 2285495 | 2022-03-08 | Hamilton | Indiana | 18057 | 81444 | 647 |
2282243 | 2282243 | 2022-03-07 | Hamilton | Indiana | 18057 | 81430 | 646 |
2278990 | 2278990 | 2022-03-06 | Hamilton | Indiana | 18057 | 81329 | 646 |
2275737 | 2275737 | 2022-03-05 | Hamilton | Indiana | 18057 | 81329 | 646 |
2272484 | 2272484 | 2022-03-04 | Hamilton | Indiana | 18057 | 81329 | 646 |
2269232 | 2269232 | 2022-03-03 | Hamilton | Indiana | 18057 | 81315 | 646 |
2265979 | 2265979 | 2022-03-02 | Hamilton | Indiana | 18057 | 81296 | 646 |
2262728 | 2262728 | 2022-03-01 | Hamilton | Indiana | 18057 | 81281 | 642 |
2259477 | 2259477 | 2022-02-28 | Hamilton | Indiana | 18057 | 81256 | 640 |
2256226 | 2256226 | 2022-02-27 | Hamilton | Indiana | 18057 | 81221 | 639 |
2252975 | 2252975 | 2022-02-26 | Hamilton | Indiana | 18057 | 81221 | 639 |
2249724 | 2249724 | 2022-02-25 | Hamilton | Indiana | 18057 | 81221 | 639 |
2246473 | 2246473 | 2022-02-24 | Hamilton | Indiana | 18057 | 81194 | 639 |
2243222 | 2243222 | 2022-02-23 | Hamilton | Indiana | 18057 | 81161 | 639 |
2239971 | 2239971 | 2022-02-22 | Hamilton | Indiana | 18057 | 81115 | 635 |
2236720 | 2236720 | 2022-02-21 | Hamilton | Indiana | 18057 | 81094 | 633 |
2233469 | 2233469 | 2022-02-20 | Hamilton | Indiana | 18057 | 80719 | 631 |
2230218 | 2230218 | 2022-02-19 | Hamilton | Indiana | 18057 | 80719 | 631 |
2226967 | 2226967 | 2022-02-18 | Hamilton | Indiana | 18057 | 80719 | 631 |
2223716 | 2223716 | 2022-02-17 | Hamilton | Indiana | 18057 | 80652 | 629 |
2220465 | 2220465 | 2022-02-16 | Hamilton | Indiana | 18057 | 80577 | 626 |
2217214 | 2217214 | 2022-02-15 | Hamilton | Indiana | 18057 | 80521 | 623 |
2213963 | 2213963 | 2022-02-14 | Hamilton | Indiana | 18057 | 80470 | 622 |
2210711 | 2210711 | 2022-02-13 | Hamilton | Indiana | 18057 | 80297 | 620 |
2207458 | 2207458 | 2022-02-12 | Hamilton | Indiana | 18057 | 80297 | 620 |
2204205 | 2204205 | 2022-02-11 | Hamilton | Indiana | 18057 | 80297 | 620 |
2200952 | 2200952 | 2022-02-10 | Hamilton | Indiana | 18057 | 80145 | 615 |
2197698 | 2197698 | 2022-02-09 | Hamilton | Indiana | 18057 | 79897 | 612 |
2194444 | 2194444 | 2022-02-08 | Hamilton | Indiana | 18057 | 79897 | 612 |
2191190 | 2191190 | 2022-02-07 | Hamilton | Indiana | 18057 | 79781 | 611 |
2187937 | 2187937 | 2022-02-06 | Hamilton | Indiana | 18057 | 79536 | 606 |
2184684 | 2184684 | 2022-02-05 | Hamilton | Indiana | 18057 | 79536 | 606 |
2181432 | 2181432 | 2022-02-04 | Hamilton | Indiana | 18057 | 79536 | 606 |
2178181 | 2178181 | 2022-02-03 | Hamilton | Indiana | 18057 | 79365 | 602 |
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);