ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 18089 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 507 ✖
- 0 11
- 1818 9
- 1072 8
- 1817 7
- 1826 7
- 316 6
- 1069 6
- 1070 6
- 989 5
- 1042 5
- 1053 5
- 1058 5
- 1077 5
- 1270 5
- 1371 5
- 1816 5
- 254 4
- 255 4
- 258 4
- 300 4
- 341 4
- 357 4
- 1039 4
- 1046 4
- 1085 4
- 1095 4
- 1105 4
- 1225 4
- 1406 4
- 1786 4
- 9 3
- 150 3
- 179 3
- 245 3
- 268 3
- 270 3
- 281 3
- 282 3
- 291 3
- 310 3
- 326 3
- 345 3
- 376 3
- 727 3
- 957 3
- 961 3
- 985 3
- 1016 3
- 1033 3
- 1034 3
- 1047 3
- 1062 3
- 1075 3
- 1113 3
- 1132 3
- 1148 3
- 1161 3
- 1183 3
- 1199 3
- 1214 3
- 1238 3
- 1250 3
- 1260 3
- 1305 3
- 1321 3
- 1353 3
- 1451 3
- 1514 3
- 1582 3
- 1653 3
- 1696 3
- 1734 3
- 1754 3
- 1773 3
- 1802 3
- 1808 3
- 1809 3
- 1811 3
- 1813 3
- 1819 3
- 1825 3
- 1 2
- 7 2
- 28 2
- 104 2
- 204 2
- 249 2
- 264 2
- 265 2
- 285 2
- 289 2
- 290 2
- 311 2
- 314 2
- 330 2
- 336 2
- 337 2
- 353 2
- 368 2
- 370 2
- 373 2
- 460 2
- 467 2
- 481 2
- 488 2
- 516 2
- 593 2
- 676 2
- 692 2
- 883 2
- 904 2
- 930 2
- 940 2
- 945 2
- 947 2
- 955 2
- 962 2
- 1000 2
- 1038 2
- 1043 2
- 1049 2
- 1060 2
- 1068 2
- 1071 2
- 1076 2
- 1142 2
- 1256 2
- 1717 2
- 1782 2
- 1805 2
- 1820 2
- 1824 2
- 1830 2
- 1833 2
- 2 1
- 6 1
- 8 1
- 12 1
- 13 1
- 21 1
- 25 1
- 29 1
- 34 1
- 37 1
- 46 1
- 48 1
- 50 1
- 52 1
- 54 1
- 62 1
- 65 1
- 69 1
- 71 1
- 75 1
- 76 1
- 78 1
- 82 1
- 88 1
- 90 1
- 101 1
- 106 1
- 112 1
- 116 1
- 121 1
- 128 1
- 132 1
- 134 1
- 135 1
- 138 1
- 142 1
- 144 1
- 146 1
- 154 1
- 160 1
- 174 1
- 178 1
- 180 1
- 182 1
- 187 1
- 198 1
- 200 1
- 214 1
- 216 1
- 217 1
- 222 1
- 225 1
- 226 1
- 230 1
- 232 1
- 234 1
- 238 1
- 239 1
- 243 1
- 246 1
- 247 1
- 248 1
- 250 1
- 256 1
- 257 1
- 260 1
- 262 1
- 263 1
- 267 1
- 272 1
- 274 1
- 275 1
- 276 1
- 283 1
- 287 1
- 294 1
- 298 1
- 301 1
- 303 1
- 304 1
- 305 1
- 306 1
- 308 1
- 312 1
- 313 1
- 315 1
- 317 1
- 319 1
- 322 1
- 325 1
- 327 1
- 333 1
- 335 1
- 339 1
- 342 1
- 343 1
- 346 1
- 348 1
- 350 1
- 352 1
- 358 1
- 361 1
- 364 1
- 366 1
- 380 1
- 382 1
- 389 1
- 390 1
- 393 1
- 395 1
- 397 1
- 401 1
- 403 1
- 406 1
- 408 1
- 410 1
- 411 1
- 412 1
- 419 1
- 420 1
- 422 1
- 426 1
- 430 1
- 431 1
- 432 1
- 442 1
- 449 1
- 452 1
- 472 1
- 474 1
- 485 1
- 494 1
- 500 1
- 504 1
- 511 1
- 514 1
- 522 1
- 528 1
- 536 1
- 540 1
- 545 1
- 548 1
- 551 1
- 554 1
- 560 1
- 561 1
- 568 1
- 572 1
- 578 1
- 579 1
- 585 1
- 588 1
- 594 1
- 596 1
- 598 1
- 616 1
- 627 1
- 632 1
- 636 1
- 637 1
- 639 1
- 641 1
- 654 1
- 661 1
- 664 1
- 667 1
- 673 1
- 681 1
- 689 1
- 691 1
- 693 1
- 695 1
- 697 1
- 704 1
- 706 1
- 708 1
- 712 1
- 713 1
- 715 1
- 721 1
- 723 1
- 724 1
- 728 1
- 737 1
- 740 1
- 833 1
- 838 1
- 844 1
- 846 1
- 849 1
- 851 1
- 857 1
- 859 1
- 871 1
- 876 1
- 877 1
- 880 1
- 887 1
- 889 1
- 891 1
- 892 1
- 899 1
- 905 1
- 908 1
- 909 1
- 911 1
- 915 1
- 917 1
- 919 1
- 921 1
- 924 1
- 927 1
- 928 1
- 931 1
- 934 1
- 935 1
- 936 1
- 939 1
- 941 1
- 943 1
- 948 1
- 951 1
- 952 1
- 956 1
- 958 1
- 960 1
- 964 1
- 966 1
- 968 1
- 969 1
- 972 1
- 973 1
- 977 1
- 978 1
- 983 1
- 984 1
- 988 1
- 991 1
- 993 1
- 994 1
- 996 1
- 999 1
- 1002 1
- 1003 1
- 1004 1
- 1005 1
- 1006 1
- 1009 1
- 1010 1
- 1011 1
- 1015 1
- 1017 1
- 1018 1
- 1023 1
- 1027 1
- 1029 1
- 1032 1
- 1035 1
- 1036 1
- 1050 1
- 1051 1
- 1055 1
- 1056 1
- 1057 1
- 1061 1
- 1063 1
- 1079 1
- 1083 1
- 1084 1
- 1086 1
- 1091 1
- 1093 1
- 1096 1
- 1100 1
- 1102 1
- 1104 1
- 1107 1
- 1110 1
- 1112 1
- 1118 1
- 1124 1
- 1127 1
- 1129 1
- 1135 1
- 1138 1
- 1151 1
- 1155 1
- 1157 1
- 1159 1
- 1167 1
- 1168 1
- 1177 1
- 1179 1
- 1186 1
- 1189 1
- 1192 1
- 1198 1
- 1204 1
- 1205 1
- 1207 1
- 1212 1
- 1215 1
- 1218 1
- 1224 1
- 1229 1
- 1231 1
- 1236 1
- 1237 1
- 1240 1
- 1244 1
- 1246 1
- 1248 1
- 1251 1
- 1257 1
- 1263 1
- 1269 1
- 1275 1
- 1288 1
- 1294 1
- 1298 1
- 1306 1
- 1311 1
- 1316 1
- 1319 1
- 1325 1
- 1332 1
- 1344 1
- 1346 1
- 1358 1
- 1365 1
- 1376 1
- 1392 1
- 1399 1
- 1411 1
- 1429 1
- 1434 1
- 1439 1
- 1462 1
- 1478 1
- 1490 1
- 1499 1
- 1520 1
- 1540 1
- 1564 1
- 1572 1
- 1589 1
- 1605 1
- 1624 1
- 1636 1
- 1663 1
- 1671 1
- 1685 1
- 1690 1
- 1705 1
- 1725 1
- 1736 1
- 1739 1
- 1745 1
- 1747 1
- 1757 1
- 1759 1
- 1766 1
- 1768 1
- 1776 1
- 1778 1
- 1789 1
- 1796 1
- 1797 1
- 1803 1
- 1804 1
- 1810 1
- 1812 1
- 1834 1
state 1
- Indiana 788
fips 1
- 18089 · 788 ✖
county 1
- Lake 788
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3384 | 3384 | 2020-03-17 | Lake | Indiana | 18089 | 2 | 0 |
3957 | 3957 | 2020-03-18 | Lake | Indiana | 18089 | 3 | 0 |
4633 | 4633 | 2020-03-19 | Lake | Indiana | 18089 | 4 | 0 |
5441 | 5441 | 2020-03-20 | Lake | Indiana | 18089 | 6 | 0 |
6380 | 6380 | 2020-03-21 | Lake | Indiana | 18089 | 7 | 0 |
7434 | 7434 | 2020-03-22 | Lake | Indiana | 18089 | 10 | 0 |
8592 | 8592 | 2020-03-23 | Lake | Indiana | 18089 | 11 | 0 |
9861 | 9861 | 2020-03-24 | Lake | Indiana | 18089 | 17 | 0 |
11256 | 11256 | 2020-03-25 | Lake | Indiana | 18089 | 19 | 0 |
12813 | 12813 | 2020-03-26 | Lake | Indiana | 18089 | 31 | 0 |
14498 | 14498 | 2020-03-27 | Lake | Indiana | 18089 | 47 | 0 |
16296 | 16296 | 2020-03-28 | Lake | Indiana | 18089 | 68 | 1 |
18200 | 18200 | 2020-03-29 | Lake | Indiana | 18089 | 85 | 1 |
20206 | 20206 | 2020-03-30 | Lake | Indiana | 18089 | 98 | 2 |
22301 | 22301 | 2020-03-31 | Lake | Indiana | 18089 | 147 | 6 |
24472 | 24472 | 2020-04-01 | Lake | Indiana | 18089 | 181 | 7 |
26711 | 26711 | 2020-04-02 | Lake | Indiana | 18089 | 216 | 7 |
29021 | 29021 | 2020-04-03 | Lake | Indiana | 18089 | 245 | 8 |
31387 | 31387 | 2020-04-04 | Lake | Indiana | 18089 | 314 | 9 |
33798 | 33798 | 2020-04-05 | Lake | Indiana | 18089 | 336 | 9 |
36251 | 36251 | 2020-04-06 | Lake | Indiana | 18089 | 370 | 9 |
38749 | 38749 | 2020-04-07 | Lake | Indiana | 18089 | 419 | 12 |
41295 | 41295 | 2020-04-08 | Lake | Indiana | 18089 | 462 | 13 |
43871 | 43871 | 2020-04-09 | Lake | Indiana | 18089 | 527 | 21 |
46475 | 46475 | 2020-04-10 | Lake | Indiana | 18089 | 578 | 25 |
49109 | 49109 | 2020-04-11 | Lake | Indiana | 18089 | 679 | 28 |
51772 | 51772 | 2020-04-12 | Lake | Indiana | 18089 | 747 | 28 |
54453 | 54453 | 2020-04-13 | Lake | Indiana | 18089 | 799 | 29 |
57146 | 57146 | 2020-04-14 | Lake | Indiana | 18089 | 822 | 34 |
59854 | 59854 | 2020-04-15 | Lake | Indiana | 18089 | 880 | 37 |
62575 | 62575 | 2020-04-16 | Lake | Indiana | 18089 | 983 | 46 |
65309 | 65309 | 2020-04-17 | Lake | Indiana | 18089 | 1032 | 48 |
68058 | 68058 | 2020-04-18 | Lake | Indiana | 18089 | 1102 | 50 |
70820 | 70820 | 2020-04-19 | Lake | Indiana | 18089 | 1112 | 52 |
73591 | 73591 | 2020-04-20 | Lake | Indiana | 18089 | 1189 | 54 |
76368 | 76368 | 2020-04-21 | Lake | Indiana | 18089 | 1235 | 62 |
79152 | 79152 | 2020-04-22 | Lake | Indiana | 18089 | 1301 | 65 |
81945 | 81945 | 2020-04-23 | Lake | Indiana | 18089 | 1358 | 69 |
84745 | 84745 | 2020-04-24 | Lake | Indiana | 18089 | 1457 | 71 |
87555 | 87555 | 2020-04-25 | Lake | Indiana | 18089 | 1528 | 76 |
90371 | 90371 | 2020-04-26 | Lake | Indiana | 18089 | 1546 | 78 |
93190 | 93190 | 2020-04-27 | Lake | Indiana | 18089 | 1602 | 75 |
96022 | 96022 | 2020-04-28 | Lake | Indiana | 18089 | 1731 | 82 |
98866 | 98866 | 2020-04-29 | Lake | Indiana | 18089 | 1806 | 88 |
101717 | 101717 | 2020-04-30 | Lake | Indiana | 18089 | 1866 | 90 |
104573 | 104573 | 2020-05-01 | Lake | Indiana | 18089 | 1952 | 101 |
107438 | 107438 | 2020-05-02 | Lake | Indiana | 18089 | 2015 | 104 |
110308 | 110308 | 2020-05-03 | Lake | Indiana | 18089 | 2058 | 104 |
113183 | 113183 | 2020-05-04 | Lake | Indiana | 18089 | 2120 | 106 |
116066 | 116066 | 2020-05-05 | Lake | Indiana | 18089 | 2184 | 112 |
119026 | 119026 | 2020-05-06 | Lake | Indiana | 18089 | 2257 | 116 |
121996 | 121996 | 2020-05-07 | Lake | Indiana | 18089 | 2312 | 121 |
124976 | 124976 | 2020-05-08 | Lake | Indiana | 18089 | 2383 | 128 |
127963 | 127963 | 2020-05-09 | Lake | Indiana | 18089 | 2416 | 132 |
130954 | 130954 | 2020-05-10 | Lake | Indiana | 18089 | 2469 | 134 |
133944 | 133944 | 2020-05-11 | Lake | Indiana | 18089 | 2516 | 135 |
136933 | 136933 | 2020-05-12 | Lake | Indiana | 18089 | 2559 | 138 |
139925 | 139925 | 2020-05-13 | Lake | Indiana | 18089 | 2614 | 142 |
142921 | 142921 | 2020-05-14 | Lake | Indiana | 18089 | 2710 | 144 |
145921 | 145921 | 2020-05-15 | Lake | Indiana | 18089 | 2773 | 146 |
148925 | 148925 | 2020-05-16 | Lake | Indiana | 18089 | 2840 | 150 |
151934 | 151934 | 2020-05-17 | Lake | Indiana | 18089 | 2871 | 150 |
154946 | 154946 | 2020-05-18 | Lake | Indiana | 18089 | 2914 | 150 |
157962 | 157962 | 2020-05-19 | Lake | Indiana | 18089 | 2974 | 154 |
160988 | 160988 | 2020-05-20 | Lake | Indiana | 18089 | 3053 | 160 |
164016 | 164016 | 2020-05-21 | Lake | Indiana | 18089 | 3116 | 174 |
167049 | 167049 | 2020-05-22 | Lake | Indiana | 18089 | 3157 | 178 |
170086 | 170086 | 2020-05-23 | Lake | Indiana | 18089 | 3220 | 179 |
173127 | 173127 | 2020-05-24 | Lake | Indiana | 18089 | 3289 | 179 |
176171 | 176171 | 2020-05-25 | Lake | Indiana | 18089 | 3328 | 179 |
179215 | 179215 | 2020-05-26 | Lake | Indiana | 18089 | 3349 | 180 |
182259 | 182259 | 2020-05-27 | Lake | Indiana | 18089 | 3378 | 182 |
185313 | 185313 | 2020-05-28 | Lake | Indiana | 18089 | 3525 | 187 |
188371 | 188371 | 2020-05-29 | Lake | Indiana | 18089 | 3571 | 198 |
191436 | 191436 | 2020-05-30 | Lake | Indiana | 18089 | 3607 | 200 |
194503 | 194503 | 2020-05-31 | Lake | Indiana | 18089 | 3650 | 204 |
197573 | 197573 | 2020-06-01 | Lake | Indiana | 18089 | 3673 | 204 |
200646 | 200646 | 2020-06-02 | Lake | Indiana | 18089 | 3723 | 214 |
203722 | 203722 | 2020-06-03 | Lake | Indiana | 18089 | 3840 | 216 |
206802 | 206802 | 2020-06-04 | Lake | Indiana | 18089 | 3867 | 217 |
209883 | 209883 | 2020-06-05 | Lake | Indiana | 18089 | 3911 | 222 |
212968 | 212968 | 2020-06-06 | Lake | Indiana | 18089 | 3950 | 225 |
216055 | 216055 | 2020-06-07 | Lake | Indiana | 18089 | 3975 | 226 |
219147 | 219147 | 2020-06-08 | Lake | Indiana | 18089 | 3994 | 230 |
222242 | 222242 | 2020-06-09 | Lake | Indiana | 18089 | 4040 | 232 |
225337 | 225337 | 2020-06-10 | Lake | Indiana | 18089 | 4068 | 234 |
228439 | 228439 | 2020-06-11 | Lake | Indiana | 18089 | 4092 | 238 |
231542 | 231542 | 2020-06-12 | Lake | Indiana | 18089 | 4116 | 239 |
234648 | 234648 | 2020-06-13 | Lake | Indiana | 18089 | 4144 | 243 |
237755 | 237755 | 2020-06-14 | Lake | Indiana | 18089 | 4168 | 245 |
240863 | 240863 | 2020-06-15 | Lake | Indiana | 18089 | 4207 | 245 |
243974 | 243974 | 2020-06-16 | Lake | Indiana | 18089 | 4246 | 245 |
247087 | 247087 | 2020-06-17 | Lake | Indiana | 18089 | 4257 | 246 |
250199 | 250199 | 2020-06-18 | Lake | Indiana | 18089 | 4332 | 247 |
253314 | 253314 | 2020-06-19 | Lake | Indiana | 18089 | 4361 | 248 |
256434 | 256434 | 2020-06-20 | Lake | Indiana | 18089 | 4392 | 249 |
259560 | 259560 | 2020-06-21 | Lake | Indiana | 18089 | 4436 | 249 |
262687 | 262687 | 2020-06-22 | Lake | Indiana | 18089 | 4473 | 250 |
265815 | 265815 | 2020-06-23 | Lake | Indiana | 18089 | 4526 | 254 |
268945 | 268945 | 2020-06-24 | Lake | Indiana | 18089 | 4562 | 254 |
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);