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: deaths, date (date)
cases 668 ✖
- 49538 5
- 55189 5
- 81880 5
- 82726 5
- 36778 4
- 41367 4
- 57908 4
- 1 3
- 36696 3
- 36856 3
- 36978 3
- 37177 3
- 37504 3
- 37908 3
- 38480 3
- 39320 3
- 40288 3
- 42308 3
- 43331 3
- 44132 3
- 44869 3
- 45464 3
- 46017 3
- 46405 3
- 46826 3
- 47295 3
- 48019 3
- 48924 3
- 51117 3
- 52750 3
- 54177 3
- 63192 3
- 68720 3
- 73699 3
- 77550 3
- 79536 3
- 80297 3
- 80719 3
- 81221 3
- 81329 3
- 81531 3
- 81626 3
- 81728 3
- 81748 3
- 81823 3
- 82116 3
- 82492 3
- 2 2
- 36214 2
- 36432 2
- 36551 2
- 36634 2
- 79897 2
- 81697 2
- 81784 2
- 81801 2
- 81852 2
- 81980 2
- 82039 2
- 82271 2
- 82373 2
- 82605 2
- 83088 2
- 83231 2
- 5 1
- 10 1
- 18 1
- 21 1
- 25 1
- 30 1
- 40 1
- 53 1
- 64 1
- 83 1
- 106 1
- 127 1
- 179 1
- 207 1
- 220 1
- 265 1
- 300 1
- 335 1
- 363 1
- 392 1
- 395 1
- 431 1
- 444 1
- 479 1
- 491 1
- 500 1
- 511 1
- 521 1
- 543 1
- 564 1
- 584 1
- 599 1
- 617 1
- 626 1
- 649 1
- 675 1
- 704 1
- 709 1
- 725 1
- 735 1
- 752 1
- 762 1
- 802 1
- 818 1
- 832 1
- 853 1
- 867 1
- 890 1
- 903 1
- 913 1
- 930 1
- 935 1
- 946 1
- 966 1
- 970 1
- 978 1
- 987 1
- 1012 1
- 1032 1
- 1044 1
- 1055 1
- 1067 1
- 1084 1
- 1097 1
- 1105 1
- 1109 1
- 1112 1
- 1128 1
- 1136 1
- 1146 1
- 1168 1
- 1170 1
- 1173 1
- 1176 1
- 1184 1
- 1194 1
- 1197 1
- 1205 1
- 1217 1
- 1219 1
- 1223 1
- 1234 1
- 1255 1
- 1258 1
- 1263 1
- 1270 1
- 1290 1
- 1362 1
- 1370 1
- 1372 1
- 1378 1
- 1381 1
- 1382 1
- 1384 1
- 1387 1
- 1407 1
- 1412 1
- 1425 1
- 1431 1
- 1442 1
- 1448 1
- 1463 1
- 1478 1
- 1499 1
- 1517 1
- 1536 1
- 1560 1
- 1574 1
- 1589 1
- 1622 1
- 1632 1
- 1652 1
- 1688 1
- 1713 1
- 1730 1
- 1757 1
- 1801 1
- 1822 1
- 1851 1
- 1868 1
- 1913 1
- 1958 1
- 1978 1
- 2017 1
- 2059 1
- 2109 1
- 2161 1
- 2209 1
- 2257 1
- 2281 1
- 2317 1
- 2345 1
- 2395 1
- 2439 1
- 2475 1
- 2518 1
- 2542 1
- 2573 1
- 2601 1
- 2639 1
- 2697 1
- 2752 1
- 2793 1
- 2833 1
- 2860 1
- 2918 1
- 2972 1
- 3064 1
- 3134 1
- 3175 1
- 3200 1
- 3262 1
- 3296 1
- 3339 1
- 3374 1
- 3430 1
- 3454 1
- 3560 1
- 3619 1
- 3670 1
- 3723 1
- 3771 1
- 3842 1
- 3883 1
- 3945 1
- 3988 1
- 4029 1
- 4087 1
- 4132 1
- 4184 1
- 4232 1
- 4254 1
- 4272 1
- 4290 1
- 4339 1
- 4401 1
- 4457 1
- 4546 1
- 4568 1
- 4578 1
- 4597 1
- 4621 1
- 4632 1
- 4678 1
- 4708 1
- 4727 1
- 4756 1
- 4793 1
- 4835 1
- 4880 1
- 4925 1
- 4941 1
- 4970 1
- 4997 1
- 5029 1
- 5062 1
- 5142 1
- 5182 1
- 5231 1
- 5257 1
- 5277 1
- 5317 1
- 5357 1
- 5414 1
- 5473 1
- 5508 1
- 5561 1
- 5593 1
- 5635 1
- 5691 1
- 5791 1
- 5854 1
- 5904 1
- 5955 1
- 5994 1
- 6032 1
- 6150 1
- 6248 1
- 6326 1
- 6368 1
- 6433 1
- 6495 1
- 6574 1
- 6730 1
- 6832 1
- 6985 1
- 7118 1
- 7232 1
- 7316 1
- 7504 1
- 7724 1
- 7955 1
- 8220 1
- 8451 1
- 8624 1
- 8822 1
- 9023 1
- 9350 1
- 9624 1
- 9925 1
- 10224 1
- 10435 1
- 10683 1
- 10940 1
- 11307 1
- 11621 1
- 11925 1
- 12261 1
- 12495 1
- 12732 1
- 13047 1
- 13412 1
- 13648 1
- 13866 1
- 14097 1
- 14400 1
- 14654 1
- 15009 1
- 15494 1
- 15931 1
- 16325 1
- 16664 1
- 16984 1
- 17246 1
- 17542 1
- 17940 1
- 18298 1
- 18666 1
- 19048 1
- 19278 1
- 19555 1
- 19885 1
- 20223 1
- 20623 1
- 20817 1
- 21156 1
- 21403 1
- 21662 1
- 21908 1
- 22222 1
- 22520 1
- 22737 1
- 22870 1
- 23037 1
- 23322 1
- 23585 1
- 23956 1
- 24289 1
- 24551 1
- 24794 1
- 24963 1
- 25177 1
- 25457 1
- 25885 1
- 26186 1
- 26538 1
- 26811 1
- 27067 1
- 27267 1
- 27468 1
- 27717 1
- 27971 1
- 28220 1
- 28413 1
- 28575 1
- 28726 1
- 28860 1
- 29081 1
- 29282 1
- 29436 1
- 29588 1
- 29691 1
- 29794 1
- 29884 1
- 30017 1
- 30117 1
- 30232 1
- 30330 1
- 30430 1
- 30524 1
- 30587 1
- 30729 1
- 30782 1
- 30878 1
- 30949 1
- 30986 1
- 31034 1
- 31100 1
- 31190 1
- 31255 1
- 31308 1
- 31365 1
- 31401 1
- 31450 1
- 31504 1
- 31555 1
- 31595 1
- 31665 1
- 31798 1
- 31843 1
- 31883 1
- 31928 1
- 31973 1
- 32015 1
- 32071 1
- 32101 1
- 32144 1
- 32166 1
- 32184 1
- 32228 1
- 32277 1
- 32491 1
- 32535 1
- 32568 1
- 32586 1
- 32631 1
- 32670 1
- 32701 1
- 32745 1
- 32766 1
- 32785 1
- 32823 1
- 32862 1
- 32916 1
- 32954 1
- 33011 1
- 33046 1
- 33078 1
- 33104 1
- 33148 1
- 33192 1
- 33241 1
- 33301 1
- 33346 1
- 33390 1
- 33427 1
- 33490 1
- 33567 1
- 33635 1
- 33698 1
- 33735 1
- 33766 1
- 33795 1
- 33848 1
- 33914 1
- 33968 1
- 34028 1
- 34075 1
- 34134 1
- 34200 1
- 34259 1
- 34335 1
- 34415 1
- 34495 1
- 34543 1
- 34595 1
- 34626 1
- 34689 1
- 34755 1
- 34820 1
- 34878 1
- 34937 1
- 34974 1
- 35018 1
- 35077 1
- 35141 1
- 35218 1
- 35275 1
- 35334 1
- 35368 1
- 35400 1
- 35438 1
- 35486 1
- 35535 1
- 35582 1
- 35615 1
- 35643 1
- 35675 1
- 35705 1
- 35741 1
- 35781 1
- 35829 1
- 35853 1
- 35875 1
- 35905 1
- 35937 1
- 35970 1
- 36001 1
- 36035 1
- 36066 1
- 36092 1
- 36116 1
- 36124 1
- 36148 1
- 36176 1
- 36191 1
- 36241 1
- 36250 1
- 36386 1
- 36413 1
- 36457 1
- 36475 1
- 36493 1
- 36508 1
- 36533 1
- 36573 1
- 36583 1
- 36598 1
- 36607 1
- 36616 1
- 36650 1
- 36659 1
- 36664 1
- 36683 1
- 36726 1
- 36740 1
- 36757 1
- 36768 1
- 36807 1
- 36812 1
- 36839 1
- 36890 1
- 36909 1
- 36925 1
- 36959 1
- 37041 1
- 37065 1
- 37102 1
- 37144 1
- 37306 1
- 37344 1
- 37381 1
- 37441 1
- 37631 1
- 37699 1
- 37743 1
- 37823 1
- 38111 1
- 38184 1
- 38264 1
- 38378 1
- 38799 1
- 38894 1
- 38988 1
- 39155 1
- 39677 1
- 39781 1
- 39958 1
- 40142 1
- 40741 1
- 40826 1
- 40992 1
- 41163 1
- 41901 1
- 41989 1
- 42116 1
- 42748 1
- 42882 1
- 43057 1
- 43208 1
- 43652 1
- 43770 1
- 43877 1
- 44030 1
- 44376 1
- 44467 1
- 44549 1
- 44739 1
- 45114 1
- 45204 1
- 45286 1
- 45330 1
- 45688 1
- 45745 1
- 45852 1
- 45931 1
- 46154 1
- 46211 1
- 46272 1
- 46351 1
- 46553 1
- 46600 1
- 46674 1
- 46755 1
- 46977 1
- 47029 1
- 47122 1
- 47216 1
- 47494 1
- 47577 1
- 47682 1
- 47925 1
- 48289 1
- 48422 1
- 48579 1
- 48755 1
- 49294 1
- 49421 1
- 50204 1
- 50379 1
- 50624 1
- 50895 1
- 51796 1
- 52014 1
- 52211 1
- 52515 1
- 53298 1
- 53530 1
- 53696 1
- 53938 1
- 54784 1
- 54947 1
- 56402 1
- 56697 1
- 57156 1
- 60308 1
- 60676 1
- 61310 1
- 62454 1
- 65328 1
- 66210 1
- 67077 1
- 67950 1
- 70766 1
- 71332 1
- 72268 1
- 72937 1
- 75602 1
- 76119 1
- 76339 1
- 76853 1
- 78603 1
- 78820 1
- 79037 1
- 79365 1
- 79781 1
- 80145 1
- 80470 1
- 80521 1
- 80577 1
- 80652 1
- 81094 1
- 81115 1
- 81161 1
- 81194 1
- 81256 1
- 81281 1
- 81296 1
- 81315 1
- 81430 1
- 81444 1
- 81498 1
- 81517 1
- 81563 1
- 81573 1
- 81588 1
- 81601 1
- 81670 1
- 81689 1
- 81704 1
- 81715 1
- 81754 1
- 81765 1
- 83430 1
state 1
- Indiana 790
fips 1
- 18057 · 790 ✖
county 1
- Hamilton 790
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);