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 descending
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 |
---|---|---|---|---|---|---|---|
2500358 | 2500358 | 2022-05-13 | Tippecanoe | Indiana | 18157 | 51787 | 396 |
2497100 | 2497100 | 2022-05-12 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2493842 | 2493842 | 2022-05-11 | Tippecanoe | Indiana | 18157 | 51667 | 396 |
2490584 | 2490584 | 2022-05-10 | Tippecanoe | Indiana | 18157 | 51554 | 396 |
2487327 | 2487327 | 2022-05-09 | Tippecanoe | Indiana | 18157 | 51554 | 396 |
2484069 | 2484069 | 2022-05-08 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2480811 | 2480811 | 2022-05-07 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2477553 | 2477553 | 2022-05-06 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2474295 | 2474295 | 2022-05-05 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2471038 | 2471038 | 2022-05-04 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2467782 | 2467782 | 2022-05-03 | Tippecanoe | Indiana | 18157 | 51087 | 396 |
2464527 | 2464527 | 2022-05-02 | Tippecanoe | Indiana | 18157 | 51087 | 396 |
2461271 | 2461271 | 2022-05-01 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2458015 | 2458015 | 2022-04-30 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2454759 | 2454759 | 2022-04-29 | Tippecanoe | Indiana | 18157 | 50955 | 396 |
2451503 | 2451503 | 2022-04-28 | Tippecanoe | Indiana | 18157 | 50819 | 396 |
2448247 | 2448247 | 2022-04-27 | Tippecanoe | Indiana | 18157 | 50819 | 396 |
2444991 | 2444991 | 2022-04-26 | Tippecanoe | Indiana | 18157 | 50678 | 394 |
2441735 | 2441735 | 2022-04-25 | Tippecanoe | Indiana | 18157 | 50678 | 394 |
2438479 | 2438479 | 2022-04-24 | Tippecanoe | Indiana | 18157 | 50427 | 394 |
2435223 | 2435223 | 2022-04-23 | Tippecanoe | Indiana | 18157 | 50427 | 394 |
2431967 | 2431967 | 2022-04-22 | Tippecanoe | Indiana | 18157 | 50427 | 394 |
2428711 | 2428711 | 2022-04-21 | Tippecanoe | Indiana | 18157 | 50317 | 394 |
2425455 | 2425455 | 2022-04-20 | Tippecanoe | Indiana | 18157 | 50317 | 394 |
2422199 | 2422199 | 2022-04-19 | Tippecanoe | Indiana | 18157 | 50245 | 394 |
2418943 | 2418943 | 2022-04-18 | Tippecanoe | Indiana | 18157 | 50245 | 394 |
2415687 | 2415687 | 2022-04-17 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2412431 | 2412431 | 2022-04-16 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2409175 | 2409175 | 2022-04-15 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2405919 | 2405919 | 2022-04-14 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2402664 | 2402664 | 2022-04-13 | Tippecanoe | Indiana | 18157 | 50116 | 394 |
2399409 | 2399409 | 2022-04-12 | Tippecanoe | Indiana | 18157 | 50076 | 394 |
2396154 | 2396154 | 2022-04-11 | Tippecanoe | Indiana | 18157 | 50076 | 394 |
2392898 | 2392898 | 2022-04-10 | Tippecanoe | Indiana | 18157 | 50042 | 394 |
2389642 | 2389642 | 2022-04-09 | Tippecanoe | Indiana | 18157 | 50042 | 394 |
2386387 | 2386387 | 2022-04-08 | Tippecanoe | Indiana | 18157 | 50042 | 394 |
2383132 | 2383132 | 2022-04-07 | Tippecanoe | Indiana | 18157 | 50005 | 394 |
2379877 | 2379877 | 2022-04-06 | Tippecanoe | Indiana | 18157 | 50005 | 394 |
2376623 | 2376623 | 2022-04-05 | Tippecanoe | Indiana | 18157 | 49970 | 394 |
2373371 | 2373371 | 2022-04-04 | Tippecanoe | Indiana | 18157 | 49970 | 394 |
2370118 | 2370118 | 2022-04-03 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2366865 | 2366865 | 2022-04-02 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2363612 | 2363612 | 2022-04-01 | Tippecanoe | Indiana | 18157 | 49936 | 394 |
2360358 | 2360358 | 2022-03-31 | Tippecanoe | Indiana | 18157 | 49902 | 392 |
2357104 | 2357104 | 2022-03-30 | Tippecanoe | Indiana | 18157 | 49902 | 392 |
2353851 | 2353851 | 2022-03-29 | Tippecanoe | Indiana | 18157 | 49917 | 392 |
2350599 | 2350599 | 2022-03-28 | Tippecanoe | Indiana | 18157 | 49904 | 392 |
2347346 | 2347346 | 2022-03-27 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2344093 | 2344093 | 2022-03-26 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2340840 | 2340840 | 2022-03-25 | Tippecanoe | Indiana | 18157 | 49866 | 392 |
2337587 | 2337587 | 2022-03-24 | Tippecanoe | Indiana | 18157 | 49855 | 392 |
2334333 | 2334333 | 2022-03-23 | Tippecanoe | Indiana | 18157 | 49838 | 392 |
2331079 | 2331079 | 2022-03-22 | Tippecanoe | Indiana | 18157 | 49822 | 392 |
2327827 | 2327827 | 2022-03-21 | Tippecanoe | Indiana | 18157 | 49810 | 392 |
2324574 | 2324574 | 2022-03-20 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2321320 | 2321320 | 2022-03-19 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2318066 | 2318066 | 2022-03-18 | Tippecanoe | Indiana | 18157 | 49795 | 391 |
2314813 | 2314813 | 2022-03-17 | Tippecanoe | Indiana | 18157 | 49782 | 389 |
2311560 | 2311560 | 2022-03-16 | Tippecanoe | Indiana | 18157 | 49771 | 388 |
2308307 | 2308307 | 2022-03-15 | Tippecanoe | Indiana | 18157 | 49762 | 384 |
2305056 | 2305056 | 2022-03-14 | Tippecanoe | Indiana | 18157 | 49752 | 384 |
2301804 | 2301804 | 2022-03-13 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2298552 | 2298552 | 2022-03-12 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2295300 | 2295300 | 2022-03-11 | Tippecanoe | Indiana | 18157 | 49740 | 384 |
2292048 | 2292048 | 2022-03-10 | Tippecanoe | Indiana | 18157 | 49731 | 384 |
2288796 | 2288796 | 2022-03-09 | Tippecanoe | Indiana | 18157 | 49712 | 384 |
2285545 | 2285545 | 2022-03-08 | Tippecanoe | Indiana | 18157 | 49700 | 381 |
2282293 | 2282293 | 2022-03-07 | Tippecanoe | Indiana | 18157 | 49690 | 380 |
2279040 | 2279040 | 2022-03-06 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2275787 | 2275787 | 2022-03-05 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2272534 | 2272534 | 2022-03-04 | Tippecanoe | Indiana | 18157 | 49664 | 380 |
2269282 | 2269282 | 2022-03-03 | Tippecanoe | Indiana | 18157 | 49650 | 379 |
2266029 | 2266029 | 2022-03-02 | Tippecanoe | Indiana | 18157 | 49637 | 377 |
2262778 | 2262778 | 2022-03-01 | Tippecanoe | Indiana | 18157 | 49633 | 376 |
2259527 | 2259527 | 2022-02-28 | Tippecanoe | Indiana | 18157 | 49609 | 376 |
2256276 | 2256276 | 2022-02-27 | Tippecanoe | Indiana | 18157 | 49552 | 375 |
2253025 | 2253025 | 2022-02-26 | Tippecanoe | Indiana | 18157 | 49552 | 375 |
2249774 | 2249774 | 2022-02-25 | Tippecanoe | Indiana | 18157 | 49552 | 375 |
2246523 | 2246523 | 2022-02-24 | Tippecanoe | Indiana | 18157 | 49519 | 375 |
2243272 | 2243272 | 2022-02-23 | Tippecanoe | Indiana | 18157 | 49474 | 374 |
2240021 | 2240021 | 2022-02-22 | Tippecanoe | Indiana | 18157 | 49441 | 372 |
2236770 | 2236770 | 2022-02-21 | Tippecanoe | Indiana | 18157 | 49409 | 370 |
2233519 | 2233519 | 2022-02-20 | Tippecanoe | Indiana | 18157 | 49332 | 370 |
2230268 | 2230268 | 2022-02-19 | Tippecanoe | Indiana | 18157 | 49332 | 370 |
2227017 | 2227017 | 2022-02-18 | Tippecanoe | Indiana | 18157 | 49332 | 370 |
2223766 | 2223766 | 2022-02-17 | Tippecanoe | Indiana | 18157 | 49278 | 369 |
2220515 | 2220515 | 2022-02-16 | Tippecanoe | Indiana | 18157 | 49228 | 366 |
2217264 | 2217264 | 2022-02-15 | Tippecanoe | Indiana | 18157 | 49190 | 364 |
2214013 | 2214013 | 2022-02-14 | Tippecanoe | Indiana | 18157 | 49134 | 363 |
2210761 | 2210761 | 2022-02-13 | Tippecanoe | Indiana | 18157 | 48994 | 363 |
2207508 | 2207508 | 2022-02-12 | Tippecanoe | Indiana | 18157 | 48994 | 363 |
2204255 | 2204255 | 2022-02-11 | Tippecanoe | Indiana | 18157 | 48994 | 363 |
2201002 | 2201002 | 2022-02-10 | Tippecanoe | Indiana | 18157 | 48920 | 362 |
2197748 | 2197748 | 2022-02-09 | Tippecanoe | Indiana | 18157 | 48740 | 362 |
2194494 | 2194494 | 2022-02-08 | Tippecanoe | Indiana | 18157 | 48740 | 362 |
2191240 | 2191240 | 2022-02-07 | Tippecanoe | Indiana | 18157 | 48631 | 358 |
2187987 | 2187987 | 2022-02-06 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2184734 | 2184734 | 2022-02-05 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2181482 | 2181482 | 2022-02-04 | Tippecanoe | Indiana | 18157 | 48494 | 356 |
2178231 | 2178231 | 2022-02-03 | Tippecanoe | Indiana | 18157 | 48413 | 356 |
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);