ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 18157 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 658 ✖
- 29874 5
- 33227 5
- 50116 5
- 51236 5
- 2 4
- 23033 4
- 25706 4
- 34574 4
- 22961 3
- 23111 3
- 23215 3
- 23353 3
- 23591 3
- 23883 3
- 24230 3
- 24645 3
- 25162 3
- 26160 3
- 26599 3
- 26925 3
- 27175 3
- 27423 3
- 27704 3
- 27943 3
- 28189 3
- 28474 3
- 28966 3
- 29467 3
- 30819 3
- 31749 3
- 32669 3
- 37079 3
- 40851 3
- 44423 3
- 47140 3
- 48494 3
- 48994 3
- 49332 3
- 49552 3
- 49664 3
- 49740 3
- 49795 3
- 49866 3
- 49936 3
- 50042 3
- 50427 3
- 50955 3
- 11 2
- 14 2
- 45 2
- 46 2
- 59 2
- 468 2
- 22692 2
- 22753 2
- 22854 2
- 22906 2
- 48740 2
- 49902 2
- 49970 2
- 50005 2
- 50076 2
- 50245 2
- 50317 2
- 50678 2
- 50819 2
- 51087 2
- 51554 2
- 51667 2
- 1 1
- 3 1
- 4 1
- 7 1
- 8 1
- 18 1
- 19 1
- 26 1
- 28 1
- 29 1
- 34 1
- 36 1
- 38 1
- 40 1
- 42 1
- 43 1
- 51 1
- 53 1
- 55 1
- 56 1
- 58 1
- 62 1
- 64 1
- 71 1
- 75 1
- 90 1
- 95 1
- 102 1
- 110 1
- 115 1
- 121 1
- 157 1
- 182 1
- 191 1
- 198 1
- 203 1
- 208 1
- 226 1
- 234 1
- 245 1
- 249 1
- 262 1
- 269 1
- 282 1
- 292 1
- 304 1
- 308 1
- 315 1
- 333 1
- 344 1
- 350 1
- 358 1
- 371 1
- 375 1
- 377 1
- 382 1
- 384 1
- 392 1
- 395 1
- 404 1
- 416 1
- 420 1
- 423 1
- 431 1
- 436 1
- 443 1
- 455 1
- 458 1
- 462 1
- 474 1
- 481 1
- 488 1
- 493 1
- 494 1
- 500 1
- 509 1
- 513 1
- 529 1
- 533 1
- 542 1
- 544 1
- 547 1
- 558 1
- 582 1
- 602 1
- 612 1
- 627 1
- 636 1
- 643 1
- 662 1
- 680 1
- 697 1
- 718 1
- 729 1
- 730 1
- 738 1
- 746 1
- 762 1
- 773 1
- 782 1
- 788 1
- 798 1
- 805 1
- 817 1
- 829 1
- 855 1
- 878 1
- 889 1
- 892 1
- 910 1
- 924 1
- 945 1
- 963 1
- 975 1
- 982 1
- 1000 1
- 1022 1
- 1034 1
- 1056 1
- 1088 1
- 1097 1
- 1106 1
- 1121 1
- 1126 1
- 1149 1
- 1180 1
- 1192 1
- 1214 1
- 1224 1
- 1241 1
- 1248 1
- 1266 1
- 1296 1
- 1319 1
- 1340 1
- 1355 1
- 1366 1
- 1372 1
- 1386 1
- 1405 1
- 1436 1
- 1445 1
- 1467 1
- 1478 1
- 1503 1
- 1518 1
- 1529 1
- 1557 1
- 1573 1
- 1587 1
- 1592 1
- 1621 1
- 1637 1
- 1693 1
- 1709 1
- 1739 1
- 1758 1
- 1764 1
- 1788 1
- 1822 1
- 1905 1
- 1967 1
- 1994 1
- 2001 1
- 2032 1
- 2085 1
- 2116 1
- 2145 1
- 2187 1
- 2213 1
- 2236 1
- 2272 1
- 2315 1
- 2350 1
- 2394 1
- 2486 1
- 2526 1
- 2569 1
- 2593 1
- 2655 1
- 2690 1
- 2733 1
- 2780 1
- 2815 1
- 2846 1
- 2869 1
- 2917 1
- 2963 1
- 3038 1
- 3083 1
- 3133 1
- 3172 1
- 3207 1
- 3247 1
- 3314 1
- 3380 1
- 3431 1
- 3467 1
- 3512 1
- 3550 1
- 3590 1
- 3698 1
- 3762 1
- 3839 1
- 3921 1
- 3970 1
- 4027 1
- 4101 1
- 4249 1
- 4368 1
- 4424 1
- 4502 1
- 4625 1
- 4691 1
- 4819 1
- 5006 1
- 5140 1
- 5297 1
- 5449 1
- 5573 1
- 5749 1
- 5845 1
- 6049 1
- 6135 1
- 6421 1
- 6570 1
- 6814 1
- 6984 1
- 7156 1
- 7418 1
- 7627 1
- 7868 1
- 8079 1
- 8270 1
- 8452 1
- 8590 1
- 8809 1
- 8970 1
- 9077 1
- 9205 1
- 9484 1
- 9651 1
- 9914 1
- 10126 1
- 10413 1
- 10688 1
- 10846 1
- 11067 1
- 11259 1
- 11441 1
- 11638 1
- 11866 1
- 12150 1
- 12256 1
- 12523 1
- 12704 1
- 12876 1
- 13083 1
- 13242 1
- 13395 1
- 13546 1
- 13713 1
- 13855 1
- 13977 1
- 14133 1
- 14302 1
- 14429 1
- 14513 1
- 14553 1
- 14673 1
- 14796 1
- 15018 1
- 15179 1
- 15315 1
- 15382 1
- 15517 1
- 15618 1
- 15873 1
- 16050 1
- 16299 1
- 16495 1
- 16612 1
- 16749 1
- 16811 1
- 16893 1
- 17002 1
- 17164 1
- 17309 1
- 17426 1
- 17486 1
- 17642 1
- 17705 1
- 17803 1
- 17909 1
- 17974 1
- 18047 1
- 18112 1
- 18154 1
- 18246 1
- 18313 1
- 18414 1
- 18459 1
- 18513 1
- 18570 1
- 18629 1
- 18669 1
- 18747 1
- 18820 1
- 18975 1
- 18989 1
- 19027 1
- 19102 1
- 19132 1
- 19227 1
- 19262 1
- 19323 1
- 19377 1
- 19418 1
- 19459 1
- 19489 1
- 19545 1
- 19603 1
- 19676 1
- 19708 1
- 19736 1
- 19772 1
- 19822 1
- 19880 1
- 19934 1
- 19984 1
- 20007 1
- 20031 1
- 20057 1
- 20103 1
- 20150 1
- 20192 1
- 20227 1
- 20247 1
- 20266 1
- 20308 1
- 20330 1
- 20369 1
- 20400 1
- 20414 1
- 20426 1
- 20454 1
- 20471 1
- 20499 1
- 20523 1
- 20539 1
- 20557 1
- 20575 1
- 20595 1
- 20614 1
- 20649 1
- 20680 1
- 20720 1
- 20754 1
- 20792 1
- 20812 1
- 20860 1
- 20913 1
- 20968 1
- 21035 1
- 21078 1
- 21124 1
- 21150 1
- 21196 1
- 21254 1
- 21321 1
- 21375 1
- 21445 1
- 21488 1
- 21537 1
- 21565 1
- 21607 1
- 21676 1
- 21730 1
- 21770 1
- 21823 1
- 21858 1
- 21891 1
- 21932 1
- 21972 1
- 22008 1
- 22037 1
- 22063 1
- 22083 1
- 22102 1
- 22141 1
- 22178 1
- 22207 1
- 22233 1
- 22253 1
- 22280 1
- 22302 1
- 22320 1
- 22341 1
- 22364 1
- 22380 1
- 22391 1
- 22402 1
- 22407 1
- 22417 1
- 22424 1
- 22437 1
- 22454 1
- 22469 1
- 22480 1
- 22493 1
- 22512 1
- 22540 1
- 22561 1
- 22572 1
- 22586 1
- 22601 1
- 22610 1
- 22634 1
- 22655 1
- 22672 1
- 22686 1
- 22701 1
- 22709 1
- 22726 1
- 22743 1
- 22780 1
- 22794 1
- 22807 1
- 22823 1
- 22838 1
- 22867 1
- 22876 1
- 22884 1
- 22891 1
- 22899 1
- 22919 1
- 22931 1
- 22943 1
- 22952 1
- 22989 1
- 22994 1
- 23006 1
- 23015 1
- 23066 1
- 23080 1
- 23101 1
- 23149 1
- 23163 1
- 23184 1
- 23201 1
- 23259 1
- 23278 1
- 23296 1
- 23327 1
- 23447 1
- 23486 1
- 23510 1
- 23551 1
- 23686 1
- 23739 1
- 23786 1
- 23832 1
- 24007 1
- 24050 1
- 24098 1
- 24171 1
- 24413 1
- 24473 1
- 24539 1
- 24587 1
- 24817 1
- 24879 1
- 24967 1
- 25065 1
- 25392 1
- 25453 1
- 25542 1
- 25617 1
- 25921 1
- 25974 1
- 26058 1
- 26318 1
- 26381 1
- 26451 1
- 26525 1
- 26748 1
- 26789 1
- 26830 1
- 26882 1
- 27022 1
- 27047 1
- 27071 1
- 27109 1
- 27265 1
- 27300 1
- 27334 1
- 27361 1
- 27538 1
- 27561 1
- 27597 1
- 27654 1
- 27806 1
- 27834 1
- 27869 1
- 27908 1
- 28047 1
- 28063 1
- 28092 1
- 28139 1
- 28317 1
- 28366 1
- 28385 1
- 28427 1
- 28608 1
- 28648 1
- 28698 1
- 28860 1
- 29150 1
- 29216 1
- 29286 1
- 29369 1
- 29731 1
- 29802 1
- 30248 1
- 30347 1
- 30495 1
- 30665 1
- 31223 1
- 31313 1
- 31475 1
- 31598 1
- 32138 1
- 32232 1
- 32336 1
- 32514 1
- 32969 1
- 33094 1
- 33802 1
- 34024 1
- 34200 1
- 35486 1
- 35764 1
- 36191 1
- 36643 1
- 38478 1
- 38951 1
- 39428 1
- 40222 1
- 42127 1
- 42562 1
- 43194 1
- 43776 1
- 45733 1
- 46146 1
- 46268 1
- 46776 1
- 47871 1
- 48030 1
- 48227 1
- 48413 1
- 48631 1
- 48920 1
- 49134 1
- 49190 1
- 49228 1
- 49278 1
- 49409 1
- 49441 1
- 49474 1
- 49519 1
- 49609 1
- 49633 1
- 49637 1
- 49650 1
- 49690 1
- 49700 1
- 49712 1
- 49731 1
- 49752 1
- 49762 1
- 49771 1
- 49782 1
- 49810 1
- 49822 1
- 49838 1
- 49855 1
- 49904 1
- 49917 1
- 51787 1
state 1
- Indiana 786
fips 1
- 18157 · 786 ✖
county 1
- Tippecanoe 786
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4639 | 4639 | 2020-03-19 | Tippecanoe | Indiana | 18157 | 1 | 0 |
5448 | 5448 | 2020-03-20 | Tippecanoe | Indiana | 18157 | 2 | 0 |
6388 | 6388 | 2020-03-21 | Tippecanoe | Indiana | 18157 | 2 | 0 |
7447 | 7447 | 2020-03-22 | Tippecanoe | Indiana | 18157 | 2 | 0 |
8605 | 8605 | 2020-03-23 | Tippecanoe | Indiana | 18157 | 2 | 0 |
9880 | 9880 | 2020-03-24 | Tippecanoe | Indiana | 18157 | 3 | 0 |
11276 | 11276 | 2020-03-25 | Tippecanoe | Indiana | 18157 | 4 | 0 |
12836 | 12836 | 2020-03-26 | Tippecanoe | Indiana | 18157 | 7 | 0 |
14522 | 14522 | 2020-03-27 | Tippecanoe | Indiana | 18157 | 8 | 1 |
16322 | 16322 | 2020-03-28 | Tippecanoe | Indiana | 18157 | 11 | 1 |
18227 | 18227 | 2020-03-29 | Tippecanoe | Indiana | 18157 | 11 | 1 |
20233 | 20233 | 2020-03-30 | Tippecanoe | Indiana | 18157 | 14 | 1 |
22328 | 22328 | 2020-03-31 | Tippecanoe | Indiana | 18157 | 14 | 1 |
24499 | 24499 | 2020-04-01 | Tippecanoe | Indiana | 18157 | 18 | 1 |
26739 | 26739 | 2020-04-02 | Tippecanoe | Indiana | 18157 | 19 | 1 |
29050 | 29050 | 2020-04-03 | Tippecanoe | Indiana | 18157 | 26 | 1 |
31417 | 31417 | 2020-04-04 | Tippecanoe | Indiana | 18157 | 28 | 1 |
33828 | 33828 | 2020-04-05 | Tippecanoe | Indiana | 18157 | 29 | 1 |
36282 | 36282 | 2020-04-06 | Tippecanoe | Indiana | 18157 | 34 | 1 |
38780 | 38780 | 2020-04-07 | Tippecanoe | Indiana | 18157 | 36 | 1 |
41326 | 41326 | 2020-04-08 | Tippecanoe | Indiana | 18157 | 38 | 1 |
43902 | 43902 | 2020-04-09 | Tippecanoe | Indiana | 18157 | 40 | 1 |
46507 | 46507 | 2020-04-10 | Tippecanoe | Indiana | 18157 | 42 | 1 |
49141 | 49141 | 2020-04-11 | Tippecanoe | Indiana | 18157 | 43 | 1 |
51805 | 51805 | 2020-04-12 | Tippecanoe | Indiana | 18157 | 45 | 1 |
54486 | 54486 | 2020-04-13 | Tippecanoe | Indiana | 18157 | 45 | 1 |
57179 | 57179 | 2020-04-14 | Tippecanoe | Indiana | 18157 | 46 | 1 |
59887 | 59887 | 2020-04-15 | Tippecanoe | Indiana | 18157 | 46 | 2 |
62608 | 62608 | 2020-04-16 | Tippecanoe | Indiana | 18157 | 51 | 2 |
65342 | 65342 | 2020-04-17 | Tippecanoe | Indiana | 18157 | 53 | 2 |
68091 | 68091 | 2020-04-18 | Tippecanoe | Indiana | 18157 | 55 | 2 |
70853 | 70853 | 2020-04-19 | Tippecanoe | Indiana | 18157 | 56 | 2 |
73624 | 73624 | 2020-04-20 | Tippecanoe | Indiana | 18157 | 58 | 2 |
76401 | 76401 | 2020-04-21 | Tippecanoe | Indiana | 18157 | 59 | 2 |
79185 | 79185 | 2020-04-22 | Tippecanoe | Indiana | 18157 | 59 | 2 |
81978 | 81978 | 2020-04-23 | Tippecanoe | Indiana | 18157 | 62 | 2 |
84778 | 84778 | 2020-04-24 | Tippecanoe | Indiana | 18157 | 64 | 2 |
87588 | 87588 | 2020-04-25 | Tippecanoe | Indiana | 18157 | 71 | 2 |
90404 | 90404 | 2020-04-26 | Tippecanoe | Indiana | 18157 | 75 | 2 |
93223 | 93223 | 2020-04-27 | Tippecanoe | Indiana | 18157 | 90 | 2 |
96055 | 96055 | 2020-04-28 | Tippecanoe | Indiana | 18157 | 95 | 2 |
98899 | 98899 | 2020-04-29 | Tippecanoe | Indiana | 18157 | 102 | 2 |
101750 | 101750 | 2020-04-30 | Tippecanoe | Indiana | 18157 | 110 | 2 |
104606 | 104606 | 2020-05-01 | Tippecanoe | Indiana | 18157 | 115 | 2 |
107471 | 107471 | 2020-05-02 | Tippecanoe | Indiana | 18157 | 121 | 2 |
110341 | 110341 | 2020-05-03 | Tippecanoe | Indiana | 18157 | 157 | 2 |
113216 | 113216 | 2020-05-04 | Tippecanoe | Indiana | 18157 | 182 | 2 |
116099 | 116099 | 2020-05-05 | Tippecanoe | Indiana | 18157 | 191 | 2 |
119059 | 119059 | 2020-05-06 | Tippecanoe | Indiana | 18157 | 198 | 2 |
122029 | 122029 | 2020-05-07 | Tippecanoe | Indiana | 18157 | 203 | 2 |
125009 | 125009 | 2020-05-08 | Tippecanoe | Indiana | 18157 | 208 | 2 |
127996 | 127996 | 2020-05-09 | Tippecanoe | Indiana | 18157 | 226 | 2 |
130987 | 130987 | 2020-05-10 | Tippecanoe | Indiana | 18157 | 234 | 2 |
133977 | 133977 | 2020-05-11 | Tippecanoe | Indiana | 18157 | 245 | 2 |
136966 | 136966 | 2020-05-12 | Tippecanoe | Indiana | 18157 | 249 | 2 |
139958 | 139958 | 2020-05-13 | Tippecanoe | Indiana | 18157 | 262 | 2 |
142954 | 142954 | 2020-05-14 | Tippecanoe | Indiana | 18157 | 269 | 2 |
145954 | 145954 | 2020-05-15 | Tippecanoe | Indiana | 18157 | 282 | 2 |
148958 | 148958 | 2020-05-16 | Tippecanoe | Indiana | 18157 | 292 | 2 |
151967 | 151967 | 2020-05-17 | Tippecanoe | Indiana | 18157 | 304 | 2 |
154979 | 154979 | 2020-05-18 | Tippecanoe | Indiana | 18157 | 308 | 2 |
157995 | 157995 | 2020-05-19 | Tippecanoe | Indiana | 18157 | 315 | 2 |
161021 | 161021 | 2020-05-20 | Tippecanoe | Indiana | 18157 | 333 | 3 |
164049 | 164049 | 2020-05-21 | Tippecanoe | Indiana | 18157 | 344 | 3 |
167082 | 167082 | 2020-05-22 | Tippecanoe | Indiana | 18157 | 350 | 3 |
170119 | 170119 | 2020-05-23 | Tippecanoe | Indiana | 18157 | 358 | 3 |
173160 | 173160 | 2020-05-24 | Tippecanoe | Indiana | 18157 | 371 | 3 |
176204 | 176204 | 2020-05-25 | Tippecanoe | Indiana | 18157 | 375 | 3 |
179248 | 179248 | 2020-05-26 | Tippecanoe | Indiana | 18157 | 377 | 3 |
182292 | 182292 | 2020-05-27 | Tippecanoe | Indiana | 18157 | 382 | 3 |
185346 | 185346 | 2020-05-28 | Tippecanoe | Indiana | 18157 | 384 | 3 |
188404 | 188404 | 2020-05-29 | Tippecanoe | Indiana | 18157 | 392 | 3 |
191469 | 191469 | 2020-05-30 | Tippecanoe | Indiana | 18157 | 395 | 3 |
194536 | 194536 | 2020-05-31 | Tippecanoe | Indiana | 18157 | 404 | 3 |
197606 | 197606 | 2020-06-01 | Tippecanoe | Indiana | 18157 | 416 | 3 |
200679 | 200679 | 2020-06-02 | Tippecanoe | Indiana | 18157 | 420 | 4 |
203755 | 203755 | 2020-06-03 | Tippecanoe | Indiana | 18157 | 423 | 4 |
206835 | 206835 | 2020-06-04 | Tippecanoe | Indiana | 18157 | 431 | 4 |
209916 | 209916 | 2020-06-05 | Tippecanoe | Indiana | 18157 | 436 | 4 |
213001 | 213001 | 2020-06-06 | Tippecanoe | Indiana | 18157 | 443 | 4 |
216088 | 216088 | 2020-06-07 | Tippecanoe | Indiana | 18157 | 455 | 5 |
219180 | 219180 | 2020-06-08 | Tippecanoe | Indiana | 18157 | 458 | 5 |
222275 | 222275 | 2020-06-09 | Tippecanoe | Indiana | 18157 | 462 | 5 |
225370 | 225370 | 2020-06-10 | Tippecanoe | Indiana | 18157 | 468 | 5 |
228472 | 228472 | 2020-06-11 | Tippecanoe | Indiana | 18157 | 468 | 5 |
231575 | 231575 | 2020-06-12 | Tippecanoe | Indiana | 18157 | 474 | 5 |
234681 | 234681 | 2020-06-13 | Tippecanoe | Indiana | 18157 | 481 | 5 |
237788 | 237788 | 2020-06-14 | Tippecanoe | Indiana | 18157 | 488 | 5 |
240896 | 240896 | 2020-06-15 | Tippecanoe | Indiana | 18157 | 493 | 5 |
244007 | 244007 | 2020-06-16 | Tippecanoe | Indiana | 18157 | 494 | 5 |
247120 | 247120 | 2020-06-17 | Tippecanoe | Indiana | 18157 | 500 | 7 |
250232 | 250232 | 2020-06-18 | Tippecanoe | Indiana | 18157 | 509 | 8 |
253347 | 253347 | 2020-06-19 | Tippecanoe | Indiana | 18157 | 513 | 8 |
256467 | 256467 | 2020-06-20 | Tippecanoe | Indiana | 18157 | 529 | 8 |
259593 | 259593 | 2020-06-21 | Tippecanoe | Indiana | 18157 | 533 | 8 |
262720 | 262720 | 2020-06-22 | Tippecanoe | Indiana | 18157 | 542 | 8 |
265848 | 265848 | 2020-06-23 | Tippecanoe | Indiana | 18157 | 544 | 9 |
268978 | 268978 | 2020-06-24 | Tippecanoe | Indiana | 18157 | 547 | 9 |
272115 | 272115 | 2020-06-25 | Tippecanoe | Indiana | 18157 | 558 | 9 |
275257 | 275257 | 2020-06-26 | Tippecanoe | Indiana | 18157 | 582 | 9 |
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);