ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "LaPorte" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 647 ✖
- 1 7
- 2 7
- 16651 5
- 18579 5
- 25460 5
- 25721 5
- 12469 4
- 12484 4
- 13477 4
- 19369 4
- 25417 4
- 140 3
- 12444 3
- 12507 3
- 12544 3
- 12605 3
- 12704 3
- 12823 3
- 12981 3
- 13221 3
- 13741 3
- 14120 3
- 14401 3
- 14645 3
- 14819 3
- 14999 3
- 15185 3
- 15374 3
- 15631 3
- 16018 3
- 16402 3
- 17205 3
- 17782 3
- 18256 3
- 21042 3
- 22371 3
- 23613 3
- 24415 3
- 24851 3
- 25059 3
- 25183 3
- 25246 3
- 25290 3
- 25335 3
- 25373 3
- 25411 3
- 25433 3
- 25527 3
- 25653 3
- 6 2
- 21 2
- 31 2
- 360 2
- 416 2
- 466 2
- 471 2
- 12301 2
- 12358 2
- 12396 2
- 12430 2
- 12495 2
- 24959 2
- 25385 2
- 25405 2
- 25422 2
- 25426 2
- 25442 2
- 25489 2
- 25499 2
- 25580 2
- 25612 2
- 25671 2
- 25800 2
- 25842 2
- 4 1
- 8 1
- 11 1
- 14 1
- 17 1
- 19 1
- 25 1
- 28 1
- 30 1
- 33 1
- 34 1
- 36 1
- 42 1
- 112 1
- 129 1
- 134 1
- 144 1
- 148 1
- 149 1
- 156 1
- 188 1
- 192 1
- 199 1
- 209 1
- 218 1
- 224 1
- 229 1
- 251 1
- 254 1
- 268 1
- 284 1
- 303 1
- 307 1
- 321 1
- 324 1
- 329 1
- 335 1
- 340 1
- 346 1
- 352 1
- 355 1
- 358 1
- 366 1
- 374 1
- 377 1
- 388 1
- 400 1
- 409 1
- 421 1
- 425 1
- 431 1
- 434 1
- 435 1
- 437 1
- 439 1
- 447 1
- 449 1
- 456 1
- 458 1
- 461 1
- 463 1
- 464 1
- 468 1
- 472 1
- 474 1
- 480 1
- 483 1
- 484 1
- 487 1
- 491 1
- 494 1
- 496 1
- 504 1
- 512 1
- 514 1
- 523 1
- 524 1
- 536 1
- 541 1
- 543 1
- 555 1
- 565 1
- 575 1
- 581 1
- 582 1
- 585 1
- 599 1
- 607 1
- 618 1
- 625 1
- 631 1
- 641 1
- 650 1
- 660 1
- 672 1
- 686 1
- 690 1
- 697 1
- 701 1
- 708 1
- 717 1
- 738 1
- 747 1
- 753 1
- 762 1
- 773 1
- 774 1
- 790 1
- 803 1
- 821 1
- 832 1
- 842 1
- 847 1
- 854 1
- 873 1
- 887 1
- 898 1
- 915 1
- 925 1
- 935 1
- 939 1
- 961 1
- 971 1
- 983 1
- 1004 1
- 1015 1
- 1016 1
- 1021 1
- 1046 1
- 1071 1
- 1092 1
- 1101 1
- 1118 1
- 1126 1
- 1131 1
- 1144 1
- 1158 1
- 1174 1
- 1177 1
- 1189 1
- 1193 1
- 1198 1
- 1208 1
- 1216 1
- 1226 1
- 1233 1
- 1249 1
- 1254 1
- 1258 1
- 1275 1
- 1297 1
- 1306 1
- 1319 1
- 1328 1
- 1332 1
- 1340 1
- 1352 1
- 1355 1
- 1360 1
- 1371 1
- 1376 1
- 1381 1
- 1386 1
- 1409 1
- 1427 1
- 1448 1
- 1478 1
- 1495 1
- 1523 1
- 1536 1
- 1562 1
- 1600 1
- 1637 1
- 1657 1
- 1691 1
- 1702 1
- 1708 1
- 1737 1
- 1771 1
- 1805 1
- 1848 1
- 1887 1
- 1912 1
- 1932 1
- 1976 1
- 2012 1
- 2073 1
- 2092 1
- 2134 1
- 2159 1
- 2213 1
- 2232 1
- 2270 1
- 2321 1
- 2365 1
- 2396 1
- 2418 1
- 2445 1
- 2492 1
- 2566 1
- 2600 1
- 2627 1
- 2688 1
- 2749 1
- 2783 1
- 2881 1
- 2955 1
- 3051 1
- 3131 1
- 3196 1
- 3269 1
- 3337 1
- 3433 1
- 3573 1
- 3633 1
- 3764 1
- 3852 1
- 3904 1
- 4007 1
- 4086 1
- 4200 1
- 4307 1
- 4374 1
- 4475 1
- 4578 1
- 4662 1
- 4753 1
- 4818 1
- 4869 1
- 4935 1
- 5026 1
- 5107 1
- 5178 1
- 5298 1
- 5384 1
- 5465 1
- 5570 1
- 5644 1
- 5740 1
- 5789 1
- 5824 1
- 5917 1
- 6057 1
- 6133 1
- 6188 1
- 6263 1
- 6327 1
- 6448 1
- 6562 1
- 6622 1
- 6713 1
- 6777 1
- 6865 1
- 6915 1
- 7049 1
- 7131 1
- 7189 1
- 7230 1
- 7293 1
- 7350 1
- 7423 1
- 7561 1
- 7658 1
- 7744 1
- 7798 1
- 7841 1
- 7895 1
- 7956 1
- 8014 1
- 8166 1
- 8241 1
- 8310 1
- 8377 1
- 8420 1
- 8480 1
- 8598 1
- 8673 1
- 8730 1
- 8780 1
- 8834 1
- 8876 1
- 8934 1
- 8981 1
- 9016 1
- 9074 1
- 9112 1
- 9154 1
- 9182 1
- 9198 1
- 9257 1
- 9336 1
- 9356 1
- 9376 1
- 9392 1
- 9409 1
- 9420 1
- 9451 1
- 9470 1
- 9490 1
- 9504 1
- 9520 1
- 9527 1
- 9537 1
- 9559 1
- 9573 1
- 9581 1
- 9594 1
- 9601 1
- 9609 1
- 9651 1
- 9661 1
- 9682 1
- 9701 1
- 9717 1
- 9726 1
- 9730 1
- 9735 1
- 9742 1
- 9749 1
- 9765 1
- 9771 1
- 9782 1
- 9788 1
- 9800 1
- 9811 1
- 9830 1
- 9840 1
- 9847 1
- 9859 1
- 9867 1
- 9877 1
- 9894 1
- 9907 1
- 9922 1
- 9938 1
- 9947 1
- 9952 1
- 9962 1
- 9976 1
- 9991 1
- 9996 1
- 10013 1
- 10024 1
- 10042 1
- 10063 1
- 10094 1
- 10133 1
- 10168 1
- 10200 1
- 10228 1
- 10243 1
- 10269 1
- 10312 1
- 10345 1
- 10378 1
- 10408 1
- 10434 1
- 10459 1
- 10482 1
- 10530 1
- 10557 1
- 10609 1
- 10647 1
- 10692 1
- 10725 1
- 10769 1
- 10809 1
- 10851 1
- 11128 1
- 11150 1
- 11172 1
- 11185 1
- 11214 1
- 11268 1
- 11302 1
- 11335 1
- 11361 1
- 11390 1
- 11421 1
- 11456 1
- 11505 1
- 11549 1
- 11595 1
- 11642 1
- 11676 1
- 11702 1
- 11747 1
- 11784 1
- 11832 1
- 11867 1
- 11901 1
- 11925 1
- 11939 1
- 11959 1
- 11981 1
- 12022 1
- 12051 1
- 12084 1
- 12097 1
- 12109 1
- 12129 1
- 12159 1
- 12180 1
- 12192 1
- 12204 1
- 12211 1
- 12227 1
- 12247 1
- 12267 1
- 12282 1
- 12291 1
- 12313 1
- 12321 1
- 12331 1
- 12343 1
- 12366 1
- 12375 1
- 12383 1
- 12390 1
- 12395 1
- 12405 1
- 12411 1
- 12419 1
- 12426 1
- 12429 1
- 12431 1
- 12436 1
- 12440 1
- 12442 1
- 12452 1
- 12454 1
- 12459 1
- 12463 1
- 12477 1
- 12478 1
- 12489 1
- 12500 1
- 12516 1
- 12525 1
- 12532 1
- 12539 1
- 12569 1
- 12577 1
- 12589 1
- 12596 1
- 12628 1
- 12656 1
- 12666 1
- 12689 1
- 12756 1
- 12767 1
- 12779 1
- 12802 1
- 12888 1
- 12906 1
- 12931 1
- 12949 1
- 13049 1
- 13074 1
- 13118 1
- 13164 1
- 13300 1
- 13343 1
- 13374 1
- 13419 1
- 13616 1
- 13646 1
- 13684 1
- 13881 1
- 13926 1
- 13973 1
- 14041 1
- 14250 1
- 14275 1
- 14323 1
- 14362 1
- 14505 1
- 14538 1
- 14575 1
- 14611 1
- 14710 1
- 14736 1
- 14768 1
- 14785 1
- 14889 1
- 14911 1
- 14945 1
- 14969 1
- 15058 1
- 15089 1
- 15113 1
- 15136 1
- 15242 1
- 15261 1
- 15291 1
- 15327 1
- 15465 1
- 15499 1
- 15536 1
- 15576 1
- 15743 1
- 15778 1
- 15820 1
- 15958 1
- 16149 1
- 16197 1
- 16257 1
- 16326 1
- 16532 1
- 16585 1
- 16870 1
- 16937 1
- 17032 1
- 17128 1
- 17418 1
- 17499 1
- 17577 1
- 17663 1
- 17990 1
- 18073 1
- 18132 1
- 18192 1
- 18453 1
- 18522 1
- 18953 1
- 19033 1
- 19180 1
- 19995 1
- 20323 1
- 20505 1
- 20771 1
- 21680 1
- 21818 1
- 21987 1
- 22210 1
- 22907 1
- 23092 1
- 23282 1
- 23443 1
- 23934 1
- 24026 1
- 24061 1
- 24208 1
- 24600 1
- 24666 1
- 24719 1
- 24817 1
- 24925 1
- 25031 1
- 25114 1
- 25128 1
- 25149 1
- 25164 1
- 25214 1
- 25220 1
- 25235 1
- 25244 1
- 25264 1
- 25271 1
- 25274 1
- 25284 1
- 25305 1
- 25310 1
- 25326 1
- 25331 1
- 25346 1
- 25354 1
- 25360 1
- 25367 1
- 25390 1
- 25409 1
- 25421 1
- 25905 1
state 1
- Indiana 791
fips 1
- 18091 791
county 1
- LaPorte · 791 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2054 | 2054 | 2020-03-14 | LaPorte | Indiana | 18091 | 1 | 0 |
2448 | 2448 | 2020-03-15 | LaPorte | Indiana | 18091 | 1 | 0 |
2893 | 2893 | 2020-03-16 | LaPorte | Indiana | 18091 | 1 | 0 |
3383 | 3383 | 2020-03-17 | LaPorte | Indiana | 18091 | 1 | 0 |
3956 | 3956 | 2020-03-18 | LaPorte | Indiana | 18091 | 1 | 0 |
4632 | 4632 | 2020-03-19 | LaPorte | Indiana | 18091 | 1 | 0 |
5440 | 5440 | 2020-03-20 | LaPorte | Indiana | 18091 | 1 | 0 |
6379 | 6379 | 2020-03-21 | LaPorte | Indiana | 18091 | 2 | 0 |
7433 | 7433 | 2020-03-22 | LaPorte | Indiana | 18091 | 2 | 0 |
8591 | 8591 | 2020-03-23 | LaPorte | Indiana | 18091 | 2 | 0 |
9860 | 9860 | 2020-03-24 | LaPorte | Indiana | 18091 | 2 | 0 |
11255 | 11255 | 2020-03-25 | LaPorte | Indiana | 18091 | 2 | 0 |
12812 | 12812 | 2020-03-26 | LaPorte | Indiana | 18091 | 2 | 0 |
14497 | 14497 | 2020-03-27 | LaPorte | Indiana | 18091 | 2 | 0 |
16295 | 16295 | 2020-03-28 | LaPorte | Indiana | 18091 | 4 | 0 |
18199 | 18199 | 2020-03-29 | LaPorte | Indiana | 18091 | 6 | 0 |
20205 | 20205 | 2020-03-30 | LaPorte | Indiana | 18091 | 6 | 0 |
22300 | 22300 | 2020-03-31 | LaPorte | Indiana | 18091 | 8 | 0 |
24471 | 24471 | 2020-04-01 | LaPorte | Indiana | 18091 | 11 | 0 |
26710 | 26710 | 2020-04-02 | LaPorte | Indiana | 18091 | 14 | 1 |
29020 | 29020 | 2020-04-03 | LaPorte | Indiana | 18091 | 17 | 1 |
31386 | 31386 | 2020-04-04 | LaPorte | Indiana | 18091 | 19 | 2 |
33797 | 33797 | 2020-04-05 | LaPorte | Indiana | 18091 | 21 | 2 |
36250 | 36250 | 2020-04-06 | LaPorte | Indiana | 18091 | 21 | 3 |
38748 | 38748 | 2020-04-07 | LaPorte | Indiana | 18091 | 25 | 3 |
41294 | 41294 | 2020-04-08 | LaPorte | Indiana | 18091 | 28 | 3 |
43870 | 43870 | 2020-04-09 | LaPorte | Indiana | 18091 | 30 | 3 |
46474 | 46474 | 2020-04-10 | LaPorte | Indiana | 18091 | 31 | 3 |
49108 | 49108 | 2020-04-11 | LaPorte | Indiana | 18091 | 31 | 3 |
51771 | 51771 | 2020-04-12 | LaPorte | Indiana | 18091 | 33 | 3 |
54452 | 54452 | 2020-04-13 | LaPorte | Indiana | 18091 | 34 | 3 |
57145 | 57145 | 2020-04-14 | LaPorte | Indiana | 18091 | 36 | 3 |
59853 | 59853 | 2020-04-15 | LaPorte | Indiana | 18091 | 42 | 4 |
62574 | 62574 | 2020-04-16 | LaPorte | Indiana | 18091 | 112 | 5 |
65308 | 65308 | 2020-04-17 | LaPorte | Indiana | 18091 | 129 | 5 |
68057 | 68057 | 2020-04-18 | LaPorte | Indiana | 18091 | 134 | 5 |
70819 | 70819 | 2020-04-19 | LaPorte | Indiana | 18091 | 140 | 5 |
73590 | 73590 | 2020-04-20 | LaPorte | Indiana | 18091 | 140 | 5 |
76367 | 76367 | 2020-04-21 | LaPorte | Indiana | 18091 | 140 | 5 |
79151 | 79151 | 2020-04-22 | LaPorte | Indiana | 18091 | 144 | 5 |
81944 | 81944 | 2020-04-23 | LaPorte | Indiana | 18091 | 148 | 5 |
84744 | 84744 | 2020-04-24 | LaPorte | Indiana | 18091 | 149 | 5 |
87554 | 87554 | 2020-04-25 | LaPorte | Indiana | 18091 | 156 | 5 |
90370 | 90370 | 2020-04-26 | LaPorte | Indiana | 18091 | 188 | 5 |
93189 | 93189 | 2020-04-27 | LaPorte | Indiana | 18091 | 192 | 5 |
96021 | 96021 | 2020-04-28 | LaPorte | Indiana | 18091 | 199 | 5 |
98865 | 98865 | 2020-04-29 | LaPorte | Indiana | 18091 | 209 | 5 |
101716 | 101716 | 2020-04-30 | LaPorte | Indiana | 18091 | 218 | 5 |
104572 | 104572 | 2020-05-01 | LaPorte | Indiana | 18091 | 224 | 6 |
107437 | 107437 | 2020-05-02 | LaPorte | Indiana | 18091 | 229 | 7 |
110307 | 110307 | 2020-05-03 | LaPorte | Indiana | 18091 | 251 | 8 |
113182 | 113182 | 2020-05-04 | LaPorte | Indiana | 18091 | 254 | 8 |
116065 | 116065 | 2020-05-05 | LaPorte | Indiana | 18091 | 268 | 8 |
119025 | 119025 | 2020-05-06 | LaPorte | Indiana | 18091 | 284 | 9 |
121995 | 121995 | 2020-05-07 | LaPorte | Indiana | 18091 | 303 | 10 |
124975 | 124975 | 2020-05-08 | LaPorte | Indiana | 18091 | 307 | 11 |
127962 | 127962 | 2020-05-09 | LaPorte | Indiana | 18091 | 321 | 11 |
130953 | 130953 | 2020-05-10 | LaPorte | Indiana | 18091 | 324 | 11 |
133943 | 133943 | 2020-05-11 | LaPorte | Indiana | 18091 | 329 | 12 |
136932 | 136932 | 2020-05-12 | LaPorte | Indiana | 18091 | 335 | 12 |
139924 | 139924 | 2020-05-13 | LaPorte | Indiana | 18091 | 340 | 12 |
142920 | 142920 | 2020-05-14 | LaPorte | Indiana | 18091 | 346 | 13 |
145920 | 145920 | 2020-05-15 | LaPorte | Indiana | 18091 | 352 | 14 |
148924 | 148924 | 2020-05-16 | LaPorte | Indiana | 18091 | 355 | 14 |
151933 | 151933 | 2020-05-17 | LaPorte | Indiana | 18091 | 358 | 14 |
154945 | 154945 | 2020-05-18 | LaPorte | Indiana | 18091 | 360 | 16 |
157961 | 157961 | 2020-05-19 | LaPorte | Indiana | 18091 | 360 | 16 |
160987 | 160987 | 2020-05-20 | LaPorte | Indiana | 18091 | 366 | 16 |
164015 | 164015 | 2020-05-21 | LaPorte | Indiana | 18091 | 374 | 17 |
167048 | 167048 | 2020-05-22 | LaPorte | Indiana | 18091 | 377 | 20 |
170085 | 170085 | 2020-05-23 | LaPorte | Indiana | 18091 | 388 | 21 |
173126 | 173126 | 2020-05-24 | LaPorte | Indiana | 18091 | 400 | 21 |
176170 | 176170 | 2020-05-25 | LaPorte | Indiana | 18091 | 409 | 21 |
179214 | 179214 | 2020-05-26 | LaPorte | Indiana | 18091 | 416 | 22 |
182258 | 182258 | 2020-05-27 | LaPorte | Indiana | 18091 | 416 | 23 |
185312 | 185312 | 2020-05-28 | LaPorte | Indiana | 18091 | 421 | 22 |
188370 | 188370 | 2020-05-29 | LaPorte | Indiana | 18091 | 425 | 23 |
191435 | 191435 | 2020-05-30 | LaPorte | Indiana | 18091 | 431 | 23 |
194502 | 194502 | 2020-05-31 | LaPorte | Indiana | 18091 | 434 | 23 |
197572 | 197572 | 2020-06-01 | LaPorte | Indiana | 18091 | 439 | 24 |
200645 | 200645 | 2020-06-02 | LaPorte | Indiana | 18091 | 435 | 24 |
203721 | 203721 | 2020-06-03 | LaPorte | Indiana | 18091 | 437 | 24 |
206801 | 206801 | 2020-06-04 | LaPorte | Indiana | 18091 | 447 | 24 |
209882 | 209882 | 2020-06-05 | LaPorte | Indiana | 18091 | 449 | 24 |
212967 | 212967 | 2020-06-06 | LaPorte | Indiana | 18091 | 456 | 24 |
216054 | 216054 | 2020-06-07 | LaPorte | Indiana | 18091 | 458 | 24 |
219146 | 219146 | 2020-06-08 | LaPorte | Indiana | 18091 | 461 | 24 |
222241 | 222241 | 2020-06-09 | LaPorte | Indiana | 18091 | 463 | 24 |
225336 | 225336 | 2020-06-10 | LaPorte | Indiana | 18091 | 464 | 24 |
228438 | 228438 | 2020-06-11 | LaPorte | Indiana | 18091 | 466 | 24 |
231541 | 231541 | 2020-06-12 | LaPorte | Indiana | 18091 | 466 | 24 |
234647 | 234647 | 2020-06-13 | LaPorte | Indiana | 18091 | 468 | 24 |
237754 | 237754 | 2020-06-14 | LaPorte | Indiana | 18091 | 471 | 24 |
240862 | 240862 | 2020-06-15 | LaPorte | Indiana | 18091 | 471 | 24 |
243973 | 243973 | 2020-06-16 | LaPorte | Indiana | 18091 | 472 | 24 |
247086 | 247086 | 2020-06-17 | LaPorte | Indiana | 18091 | 474 | 25 |
250198 | 250198 | 2020-06-18 | LaPorte | Indiana | 18091 | 480 | 25 |
253313 | 253313 | 2020-06-19 | LaPorte | Indiana | 18091 | 483 | 25 |
256433 | 256433 | 2020-06-20 | LaPorte | Indiana | 18091 | 484 | 25 |
259559 | 259559 | 2020-06-21 | LaPorte | Indiana | 18091 | 487 | 25 |
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);