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 state
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 |
---|---|---|---|---|---|---|---|
2444 | 2444 | 2020-03-15 | Hamilton | Indiana | 18057 | 1 | 0 |
2889 | 2889 | 2020-03-16 | Hamilton | Indiana | 18057 | 1 | 0 |
3379 | 3379 | 2020-03-17 | Hamilton | Indiana | 18057 | 1 | 0 |
3951 | 3951 | 2020-03-18 | Hamilton | Indiana | 18057 | 2 | 0 |
4627 | 4627 | 2020-03-19 | Hamilton | Indiana | 18057 | 2 | 0 |
5435 | 5435 | 2020-03-20 | Hamilton | Indiana | 18057 | 5 | 0 |
6372 | 6372 | 2020-03-21 | Hamilton | Indiana | 18057 | 10 | 0 |
7426 | 7426 | 2020-03-22 | Hamilton | Indiana | 18057 | 18 | 0 |
8584 | 8584 | 2020-03-23 | Hamilton | Indiana | 18057 | 21 | 0 |
9852 | 9852 | 2020-03-24 | Hamilton | Indiana | 18057 | 25 | 0 |
11246 | 11246 | 2020-03-25 | Hamilton | Indiana | 18057 | 30 | 0 |
12803 | 12803 | 2020-03-26 | Hamilton | Indiana | 18057 | 40 | 0 |
14484 | 14484 | 2020-03-27 | Hamilton | Indiana | 18057 | 53 | 0 |
16282 | 16282 | 2020-03-28 | Hamilton | Indiana | 18057 | 64 | 0 |
18185 | 18185 | 2020-03-29 | Hamilton | Indiana | 18057 | 83 | 0 |
20191 | 20191 | 2020-03-30 | Hamilton | Indiana | 18057 | 106 | 0 |
22285 | 22285 | 2020-03-31 | Hamilton | Indiana | 18057 | 127 | 0 |
24455 | 24455 | 2020-04-01 | Hamilton | Indiana | 18057 | 179 | 4 |
26694 | 26694 | 2020-04-02 | Hamilton | Indiana | 18057 | 207 | 4 |
29004 | 29004 | 2020-04-03 | Hamilton | Indiana | 18057 | 220 | 4 |
31370 | 31370 | 2020-04-04 | Hamilton | Indiana | 18057 | 265 | 4 |
33781 | 33781 | 2020-04-05 | Hamilton | Indiana | 18057 | 300 | 5 |
36234 | 36234 | 2020-04-06 | Hamilton | Indiana | 18057 | 335 | 5 |
38732 | 38732 | 2020-04-07 | Hamilton | Indiana | 18057 | 363 | 10 |
41278 | 41278 | 2020-04-08 | Hamilton | Indiana | 18057 | 392 | 15 |
43854 | 43854 | 2020-04-09 | Hamilton | Indiana | 18057 | 395 | 16 |
46458 | 46458 | 2020-04-10 | Hamilton | Indiana | 18057 | 431 | 19 |
49092 | 49092 | 2020-04-11 | Hamilton | Indiana | 18057 | 444 | 23 |
51755 | 51755 | 2020-04-12 | Hamilton | Indiana | 18057 | 479 | 24 |
54436 | 54436 | 2020-04-13 | Hamilton | Indiana | 18057 | 491 | 25 |
57129 | 57129 | 2020-04-14 | Hamilton | Indiana | 18057 | 500 | 28 |
59837 | 59837 | 2020-04-15 | Hamilton | Indiana | 18057 | 511 | 28 |
62558 | 62558 | 2020-04-16 | Hamilton | Indiana | 18057 | 521 | 30 |
65292 | 65292 | 2020-04-17 | Hamilton | Indiana | 18057 | 543 | 32 |
68041 | 68041 | 2020-04-18 | Hamilton | Indiana | 18057 | 564 | 36 |
70803 | 70803 | 2020-04-19 | Hamilton | Indiana | 18057 | 584 | 36 |
73574 | 73574 | 2020-04-20 | Hamilton | Indiana | 18057 | 599 | 36 |
76351 | 76351 | 2020-04-21 | Hamilton | Indiana | 18057 | 617 | 40 |
79135 | 79135 | 2020-04-22 | Hamilton | Indiana | 18057 | 626 | 42 |
81928 | 81928 | 2020-04-23 | Hamilton | Indiana | 18057 | 649 | 43 |
84728 | 84728 | 2020-04-24 | Hamilton | Indiana | 18057 | 675 | 46 |
87538 | 87538 | 2020-04-25 | Hamilton | Indiana | 18057 | 704 | 52 |
90354 | 90354 | 2020-04-26 | Hamilton | Indiana | 18057 | 709 | 53 |
93173 | 93173 | 2020-04-27 | Hamilton | Indiana | 18057 | 725 | 53 |
96005 | 96005 | 2020-04-28 | Hamilton | Indiana | 18057 | 735 | 60 |
98849 | 98849 | 2020-04-29 | Hamilton | Indiana | 18057 | 752 | 62 |
101700 | 101700 | 2020-04-30 | Hamilton | Indiana | 18057 | 762 | 64 |
104556 | 104556 | 2020-05-01 | Hamilton | Indiana | 18057 | 802 | 70 |
107421 | 107421 | 2020-05-02 | Hamilton | Indiana | 18057 | 818 | 71 |
110291 | 110291 | 2020-05-03 | Hamilton | Indiana | 18057 | 832 | 72 |
113166 | 113166 | 2020-05-04 | Hamilton | Indiana | 18057 | 853 | 75 |
116049 | 116049 | 2020-05-05 | Hamilton | Indiana | 18057 | 867 | 77 |
119009 | 119009 | 2020-05-06 | Hamilton | Indiana | 18057 | 890 | 80 |
121979 | 121979 | 2020-05-07 | Hamilton | Indiana | 18057 | 903 | 82 |
124959 | 124959 | 2020-05-08 | Hamilton | Indiana | 18057 | 913 | 82 |
127946 | 127946 | 2020-05-09 | Hamilton | Indiana | 18057 | 930 | 84 |
130937 | 130937 | 2020-05-10 | Hamilton | Indiana | 18057 | 935 | 84 |
133927 | 133927 | 2020-05-11 | Hamilton | Indiana | 18057 | 946 | 86 |
136916 | 136916 | 2020-05-12 | Hamilton | Indiana | 18057 | 966 | 88 |
139908 | 139908 | 2020-05-13 | Hamilton | Indiana | 18057 | 970 | 88 |
142904 | 142904 | 2020-05-14 | Hamilton | Indiana | 18057 | 978 | 88 |
145904 | 145904 | 2020-05-15 | Hamilton | Indiana | 18057 | 987 | 91 |
148908 | 148908 | 2020-05-16 | Hamilton | Indiana | 18057 | 1012 | 95 |
151917 | 151917 | 2020-05-17 | Hamilton | Indiana | 18057 | 1032 | 95 |
154929 | 154929 | 2020-05-18 | Hamilton | Indiana | 18057 | 1044 | 95 |
157945 | 157945 | 2020-05-19 | Hamilton | Indiana | 18057 | 1055 | 97 |
160971 | 160971 | 2020-05-20 | Hamilton | Indiana | 18057 | 1067 | 96 |
163999 | 163999 | 2020-05-21 | Hamilton | Indiana | 18057 | 1084 | 96 |
167032 | 167032 | 2020-05-22 | Hamilton | Indiana | 18057 | 1097 | 96 |
170069 | 170069 | 2020-05-23 | Hamilton | Indiana | 18057 | 1105 | 96 |
173110 | 173110 | 2020-05-24 | Hamilton | Indiana | 18057 | 1109 | 96 |
176154 | 176154 | 2020-05-25 | Hamilton | Indiana | 18057 | 1112 | 97 |
179198 | 179198 | 2020-05-26 | Hamilton | Indiana | 18057 | 1128 | 97 |
182242 | 182242 | 2020-05-27 | Hamilton | Indiana | 18057 | 1136 | 96 |
185296 | 185296 | 2020-05-28 | Hamilton | Indiana | 18057 | 1146 | 98 |
188354 | 188354 | 2020-05-29 | Hamilton | Indiana | 18057 | 1170 | 99 |
191419 | 191419 | 2020-05-30 | Hamilton | Indiana | 18057 | 1168 | 99 |
194486 | 194486 | 2020-05-31 | Hamilton | Indiana | 18057 | 1173 | 99 |
197556 | 197556 | 2020-06-01 | Hamilton | Indiana | 18057 | 1176 | 99 |
200629 | 200629 | 2020-06-02 | Hamilton | Indiana | 18057 | 1184 | 99 |
203705 | 203705 | 2020-06-03 | Hamilton | Indiana | 18057 | 1194 | 100 |
206785 | 206785 | 2020-06-04 | Hamilton | Indiana | 18057 | 1197 | 100 |
209866 | 209866 | 2020-06-05 | Hamilton | Indiana | 18057 | 1205 | 100 |
212951 | 212951 | 2020-06-06 | Hamilton | Indiana | 18057 | 1217 | 100 |
216038 | 216038 | 2020-06-07 | Hamilton | Indiana | 18057 | 1219 | 100 |
219130 | 219130 | 2020-06-08 | Hamilton | Indiana | 18057 | 1223 | 100 |
222225 | 222225 | 2020-06-09 | Hamilton | Indiana | 18057 | 1234 | 99 |
225320 | 225320 | 2020-06-10 | Hamilton | Indiana | 18057 | 1255 | 100 |
228422 | 228422 | 2020-06-11 | Hamilton | Indiana | 18057 | 1258 | 100 |
231525 | 231525 | 2020-06-12 | Hamilton | Indiana | 18057 | 1263 | 101 |
234631 | 234631 | 2020-06-13 | Hamilton | Indiana | 18057 | 1270 | 101 |
237738 | 237738 | 2020-06-14 | Hamilton | Indiana | 18057 | 1290 | 101 |
240846 | 240846 | 2020-06-15 | Hamilton | Indiana | 18057 | 1370 | 101 |
243957 | 243957 | 2020-06-16 | Hamilton | Indiana | 18057 | 1381 | 101 |
247070 | 247070 | 2020-06-17 | Hamilton | Indiana | 18057 | 1384 | 101 |
250182 | 250182 | 2020-06-18 | Hamilton | Indiana | 18057 | 1362 | 101 |
253297 | 253297 | 2020-06-19 | Hamilton | Indiana | 18057 | 1372 | 101 |
256417 | 256417 | 2020-06-20 | Hamilton | Indiana | 18057 | 1378 | 102 |
259543 | 259543 | 2020-06-21 | Hamilton | Indiana | 18057 | 1382 | 102 |
262670 | 262670 | 2020-06-22 | Hamilton | Indiana | 18057 | 1387 | 102 |
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);