ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 18145 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 630 ✖
- 13593 8
- 1 5
- 9010 5
- 10251 5
- 13622 5
- 14662 5
- 5995 4
- 6019 4
- 6041 4
- 6958 4
- 10620 4
- 14674 4
- 598 3
- 5661 3
- 6052 3
- 6064 3
- 6091 3
- 6129 3
- 6209 3
- 6311 3
- 6425 3
- 6662 3
- 7206 3
- 7460 3
- 7646 3
- 7819 3
- 8019 3
- 8153 3
- 8232 3
- 8313 3
- 8380 3
- 8681 3
- 8869 3
- 9338 3
- 9706 3
- 10054 3
- 11217 3
- 12045 3
- 12965 3
- 13582 3
- 13606 3
- 13611 3
- 13812 3
- 14321 3
- 14510 3
- 14575 3
- 14607 3
- 14640 3
- 14653 3
- 2 2
- 541 2
- 580 2
- 599 2
- 617 2
- 618 2
- 740 2
- 773 2
- 948 2
- 1103 2
- 1140 2
- 5575 2
- 5616 2
- 5679 2
- 5967 2
- 5969 2
- 5972 2
- 5976 2
- 5978 2
- 5993 2
- 6001 2
- 6047 2
- 13576 2
- 13584 2
- 13589 2
- 13592 2
- 13599 2
- 13603 2
- 13607 2
- 13610 2
- 13616 2
- 13635 2
- 13640 2
- 14434 2
- 14647 2
- 14649 2
- 6 1
- 10 1
- 12 1
- 13 1
- 15 1
- 19 1
- 24 1
- 26 1
- 32 1
- 37 1
- 46 1
- 52 1
- 60 1
- 65 1
- 67 1
- 73 1
- 77 1
- 81 1
- 83 1
- 85 1
- 92 1
- 103 1
- 105 1
- 111 1
- 118 1
- 127 1
- 132 1
- 153 1
- 162 1
- 184 1
- 188 1
- 192 1
- 199 1
- 203 1
- 217 1
- 230 1
- 248 1
- 252 1
- 254 1
- 275 1
- 294 1
- 300 1
- 311 1
- 319 1
- 325 1
- 336 1
- 354 1
- 357 1
- 359 1
- 384 1
- 386 1
- 393 1
- 403 1
- 417 1
- 427 1
- 441 1
- 455 1
- 457 1
- 458 1
- 460 1
- 461 1
- 472 1
- 522 1
- 535 1
- 539 1
- 553 1
- 578 1
- 579 1
- 581 1
- 584 1
- 592 1
- 594 1
- 601 1
- 610 1
- 613 1
- 621 1
- 622 1
- 624 1
- 627 1
- 628 1
- 631 1
- 632 1
- 637 1
- 640 1
- 642 1
- 648 1
- 651 1
- 653 1
- 654 1
- 658 1
- 665 1
- 671 1
- 676 1
- 695 1
- 700 1
- 701 1
- 710 1
- 716 1
- 719 1
- 733 1
- 741 1
- 745 1
- 753 1
- 757 1
- 759 1
- 771 1
- 797 1
- 803 1
- 813 1
- 818 1
- 826 1
- 827 1
- 829 1
- 847 1
- 854 1
- 863 1
- 871 1
- 878 1
- 885 1
- 890 1
- 913 1
- 924 1
- 933 1
- 940 1
- 947 1
- 977 1
- 987 1
- 997 1
- 1011 1
- 1018 1
- 1019 1
- 1020 1
- 1040 1
- 1045 1
- 1051 1
- 1066 1
- 1071 1
- 1073 1
- 1074 1
- 1082 1
- 1086 1
- 1090 1
- 1091 1
- 1094 1
- 1097 1
- 1098 1
- 1102 1
- 1109 1
- 1114 1
- 1118 1
- 1120 1
- 1122 1
- 1123 1
- 1128 1
- 1134 1
- 1138 1
- 1146 1
- 1149 1
- 1151 1
- 1157 1
- 1162 1
- 1165 1
- 1168 1
- 1171 1
- 1179 1
- 1182 1
- 1183 1
- 1186 1
- 1191 1
- 1192 1
- 1195 1
- 1197 1
- 1201 1
- 1208 1
- 1216 1
- 1220 1
- 1222 1
- 1237 1
- 1241 1
- 1250 1
- 1270 1
- 1280 1
- 1284 1
- 1298 1
- 1309 1
- 1318 1
- 1331 1
- 1349 1
- 1384 1
- 1406 1
- 1418 1
- 1433 1
- 1463 1
- 1477 1
- 1499 1
- 1526 1
- 1537 1
- 1553 1
- 1578 1
- 1629 1
- 1669 1
- 1704 1
- 1741 1
- 1756 1
- 1794 1
- 1853 1
- 1884 1
- 1920 1
- 1954 1
- 1996 1
- 2020 1
- 2038 1
- 2103 1
- 2150 1
- 2189 1
- 2217 1
- 2278 1
- 2318 1
- 2359 1
- 2416 1
- 2463 1
- 2538 1
- 2568 1
- 2605 1
- 2655 1
- 2702 1
- 2750 1
- 2796 1
- 2837 1
- 2912 1
- 2982 1
- 3040 1
- 3076 1
- 3135 1
- 3215 1
- 3298 1
- 3385 1
- 3435 1
- 3494 1
- 3519 1
- 3579 1
- 3622 1
- 3676 1
- 3709 1
- 3757 1
- 3805 1
- 3822 1
- 3868 1
- 3913 1
- 3962 1
- 3987 1
- 4003 1
- 4009 1
- 4031 1
- 4072 1
- 4130 1
- 4202 1
- 4250 1
- 4292 1
- 4311 1
- 4329 1
- 4373 1
- 4436 1
- 4512 1
- 4560 1
- 4611 1
- 4652 1
- 4676 1
- 4722 1
- 4751 1
- 4784 1
- 4826 1
- 4857 1
- 4872 1
- 4893 1
- 4911 1
- 4942 1
- 4969 1
- 5003 1
- 5046 1
- 5066 1
- 5079 1
- 5111 1
- 5134 1
- 5161 1
- 5182 1
- 5206 1
- 5216 1
- 5235 1
- 5257 1
- 5271 1
- 5297 1
- 5312 1
- 5336 1
- 5347 1
- 5352 1
- 5376 1
- 5394 1
- 5413 1
- 5425 1
- 5432 1
- 5444 1
- 5455 1
- 5458 1
- 5464 1
- 5469 1
- 5478 1
- 5490 1
- 5493 1
- 5496 1
- 5507 1
- 5513 1
- 5521 1
- 5528 1
- 5531 1
- 5532 1
- 5536 1
- 5540 1
- 5550 1
- 5557 1
- 5565 1
- 5573 1
- 5591 1
- 5594 1
- 5607 1
- 5609 1
- 5612 1
- 5623 1
- 5627 1
- 5633 1
- 5638 1
- 5644 1
- 5647 1
- 5649 1
- 5653 1
- 5659 1
- 5662 1
- 5663 1
- 5665 1
- 5666 1
- 5668 1
- 5671 1
- 5674 1
- 5684 1
- 5693 1
- 5698 1
- 5706 1
- 5708 1
- 5712 1
- 5718 1
- 5729 1
- 5736 1
- 5745 1
- 5750 1
- 5752 1
- 5758 1
- 5762 1
- 5769 1
- 5784 1
- 5789 1
- 5796 1
- 5799 1
- 5803 1
- 5806 1
- 5812 1
- 5821 1
- 5829 1
- 5837 1
- 5844 1
- 5846 1
- 5847 1
- 5859 1
- 5863 1
- 5872 1
- 5879 1
- 5883 1
- 5884 1
- 5889 1
- 5898 1
- 5905 1
- 5912 1
- 5918 1
- 5919 1
- 5922 1
- 5924 1
- 5926 1
- 5937 1
- 5943 1
- 5948 1
- 5953 1
- 5955 1
- 5957 1
- 5960 1
- 5964 1
- 5968 1
- 5981 1
- 5983 1
- 5984 1
- 5987 1
- 5989 1
- 5997 1
- 6004 1
- 6010 1
- 6012 1
- 6014 1
- 6024 1
- 6029 1
- 6034 1
- 6049 1
- 6057 1
- 6058 1
- 6060 1
- 6062 1
- 6068 1
- 6074 1
- 6080 1
- 6083 1
- 6097 1
- 6107 1
- 6116 1
- 6117 1
- 6141 1
- 6149 1
- 6187 1
- 6198 1
- 6231 1
- 6255 1
- 6279 1
- 6293 1
- 6340 1
- 6363 1
- 6384 1
- 6406 1
- 6498 1
- 6523 1
- 6573 1
- 6604 1
- 6784 1
- 6827 1
- 6863 1
- 6922 1
- 7049 1
- 7074 1
- 7144 1
- 7307 1
- 7345 1
- 7388 1
- 7431 1
- 7528 1
- 7544 1
- 7586 1
- 7617 1
- 7701 1
- 7719 1
- 7760 1
- 7794 1
- 7860 1
- 7899 1
- 7919 1
- 7973 1
- 8039 1
- 8077 1
- 8090 1
- 8123 1
- 8176 1
- 8199 1
- 8211 1
- 8218 1
- 8259 1
- 8281 1
- 8289 1
- 8300 1
- 8332 1
- 8339 1
- 8344 1
- 8369 1
- 8410 1
- 8434 1
- 8473 1
- 8657 1
- 8721 1
- 8776 1
- 8812 1
- 8839 1
- 8915 1
- 8964 1
- 9109 1
- 9156 1
- 9235 1
- 9268 1
- 9460 1
- 9496 1
- 9567 1
- 9628 1
- 9779 1
- 9867 1
- 9943 1
- 9989 1
- 10126 1
- 10200 1
- 10376 1
- 10464 1
- 10522 1
- 10895 1
- 10935 1
- 10996 1
- 11096 1
- 11618 1
- 11680 1
- 11817 1
- 11909 1
- 12312 1
- 12357 1
- 12570 1
- 12737 1
- 13312 1
- 13377 1
- 13451 1
- 13561 1
- 13647 1
- 14024 1
- 14067 1
- 14193 1
- 14276 1
- 14383 1
- 14484 1
- 14525 1
- 14548 1
- 14553 1
- 14564 1
- 14581 1
- 14591 1
- 14597 1
- 14603 1
- 14620 1
- 14622 1
- 14627 1
- 14635 1
- 14656 1
- 14660 1
- 14665 1
- 14667 1
- 14669 1
- 14673 1
- 14677 1
state 1
- Indiana 785
fips 1
- 18145 · 785 ✖
county 1
- Shelby 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500351 | 2500351 | 2022-05-13 | Shelby | Indiana | 18145 | 13647 | 182 |
2497093 | 2497093 | 2022-05-12 | Shelby | Indiana | 18145 | 13640 | 182 |
2493835 | 2493835 | 2022-05-11 | Shelby | Indiana | 18145 | 13640 | 182 |
2490577 | 2490577 | 2022-05-10 | Shelby | Indiana | 18145 | 13635 | 182 |
2487320 | 2487320 | 2022-05-09 | Shelby | Indiana | 18145 | 13635 | 182 |
2484062 | 2484062 | 2022-05-08 | Shelby | Indiana | 18145 | 13622 | 182 |
2480804 | 2480804 | 2022-05-07 | Shelby | Indiana | 18145 | 13622 | 182 |
2477546 | 2477546 | 2022-05-06 | Shelby | Indiana | 18145 | 13622 | 182 |
2474288 | 2474288 | 2022-05-05 | Shelby | Indiana | 18145 | 13622 | 182 |
2471031 | 2471031 | 2022-05-04 | Shelby | Indiana | 18145 | 13622 | 182 |
2467775 | 2467775 | 2022-05-03 | Shelby | Indiana | 18145 | 13616 | 182 |
2464520 | 2464520 | 2022-05-02 | Shelby | Indiana | 18145 | 13616 | 182 |
2461264 | 2461264 | 2022-05-01 | Shelby | Indiana | 18145 | 13611 | 182 |
2458008 | 2458008 | 2022-04-30 | Shelby | Indiana | 18145 | 13611 | 182 |
2454752 | 2454752 | 2022-04-29 | Shelby | Indiana | 18145 | 13611 | 182 |
2451496 | 2451496 | 2022-04-28 | Shelby | Indiana | 18145 | 13610 | 182 |
2448240 | 2448240 | 2022-04-27 | Shelby | Indiana | 18145 | 13610 | 182 |
2444984 | 2444984 | 2022-04-26 | Shelby | Indiana | 18145 | 13607 | 182 |
2441728 | 2441728 | 2022-04-25 | Shelby | Indiana | 18145 | 13607 | 182 |
2438472 | 2438472 | 2022-04-24 | Shelby | Indiana | 18145 | 13606 | 182 |
2435216 | 2435216 | 2022-04-23 | Shelby | Indiana | 18145 | 13606 | 182 |
2431960 | 2431960 | 2022-04-22 | Shelby | Indiana | 18145 | 13606 | 182 |
2428704 | 2428704 | 2022-04-21 | Shelby | Indiana | 18145 | 13603 | 182 |
2425448 | 2425448 | 2022-04-20 | Shelby | Indiana | 18145 | 13603 | 182 |
2422192 | 2422192 | 2022-04-19 | Shelby | Indiana | 18145 | 13599 | 182 |
2418936 | 2418936 | 2022-04-18 | Shelby | Indiana | 18145 | 13599 | 182 |
2415680 | 2415680 | 2022-04-17 | Shelby | Indiana | 18145 | 13593 | 182 |
2412424 | 2412424 | 2022-04-16 | Shelby | Indiana | 18145 | 13593 | 182 |
2409168 | 2409168 | 2022-04-15 | Shelby | Indiana | 18145 | 13593 | 182 |
2405912 | 2405912 | 2022-04-14 | Shelby | Indiana | 18145 | 13593 | 182 |
2402657 | 2402657 | 2022-04-13 | Shelby | Indiana | 18145 | 13593 | 182 |
2399402 | 2399402 | 2022-04-12 | Shelby | Indiana | 18145 | 13592 | 182 |
2396147 | 2396147 | 2022-04-11 | Shelby | Indiana | 18145 | 13592 | 182 |
2392891 | 2392891 | 2022-04-10 | Shelby | Indiana | 18145 | 13593 | 182 |
2389635 | 2389635 | 2022-04-09 | Shelby | Indiana | 18145 | 13593 | 182 |
2386380 | 2386380 | 2022-04-08 | Shelby | Indiana | 18145 | 13593 | 182 |
2383125 | 2383125 | 2022-04-07 | Shelby | Indiana | 18145 | 13589 | 181 |
2379870 | 2379870 | 2022-04-06 | Shelby | Indiana | 18145 | 13589 | 181 |
2376616 | 2376616 | 2022-04-05 | Shelby | Indiana | 18145 | 13584 | 181 |
2373364 | 2373364 | 2022-04-04 | Shelby | Indiana | 18145 | 13584 | 181 |
2370111 | 2370111 | 2022-04-03 | Shelby | Indiana | 18145 | 13582 | 181 |
2366858 | 2366858 | 2022-04-02 | Shelby | Indiana | 18145 | 13582 | 181 |
2363605 | 2363605 | 2022-04-01 | Shelby | Indiana | 18145 | 13582 | 181 |
2360351 | 2360351 | 2022-03-31 | Shelby | Indiana | 18145 | 13576 | 181 |
2357097 | 2357097 | 2022-03-30 | Shelby | Indiana | 18145 | 13576 | 181 |
2353844 | 2353844 | 2022-03-29 | Shelby | Indiana | 18145 | 14677 | 181 |
2350592 | 2350592 | 2022-03-28 | Shelby | Indiana | 18145 | 14674 | 181 |
2347339 | 2347339 | 2022-03-27 | Shelby | Indiana | 18145 | 14674 | 181 |
2344086 | 2344086 | 2022-03-26 | Shelby | Indiana | 18145 | 14674 | 181 |
2340833 | 2340833 | 2022-03-25 | Shelby | Indiana | 18145 | 14674 | 181 |
2337580 | 2337580 | 2022-03-24 | Shelby | Indiana | 18145 | 14673 | 181 |
2334326 | 2334326 | 2022-03-23 | Shelby | Indiana | 18145 | 14669 | 181 |
2331072 | 2331072 | 2022-03-22 | Shelby | Indiana | 18145 | 14667 | 181 |
2327820 | 2327820 | 2022-03-21 | Shelby | Indiana | 18145 | 14665 | 181 |
2324567 | 2324567 | 2022-03-20 | Shelby | Indiana | 18145 | 14662 | 181 |
2321313 | 2321313 | 2022-03-19 | Shelby | Indiana | 18145 | 14662 | 181 |
2318059 | 2318059 | 2022-03-18 | Shelby | Indiana | 18145 | 14662 | 181 |
2314806 | 2314806 | 2022-03-17 | Shelby | Indiana | 18145 | 14662 | 181 |
2311553 | 2311553 | 2022-03-16 | Shelby | Indiana | 18145 | 14662 | 181 |
2308300 | 2308300 | 2022-03-15 | Shelby | Indiana | 18145 | 14660 | 181 |
2305049 | 2305049 | 2022-03-14 | Shelby | Indiana | 18145 | 14656 | 181 |
2301797 | 2301797 | 2022-03-13 | Shelby | Indiana | 18145 | 14653 | 181 |
2298545 | 2298545 | 2022-03-12 | Shelby | Indiana | 18145 | 14653 | 181 |
2295293 | 2295293 | 2022-03-11 | Shelby | Indiana | 18145 | 14653 | 181 |
2292041 | 2292041 | 2022-03-10 | Shelby | Indiana | 18145 | 14649 | 180 |
2288789 | 2288789 | 2022-03-09 | Shelby | Indiana | 18145 | 14649 | 180 |
2285538 | 2285538 | 2022-03-08 | Shelby | Indiana | 18145 | 14647 | 180 |
2282286 | 2282286 | 2022-03-07 | Shelby | Indiana | 18145 | 14647 | 180 |
2279033 | 2279033 | 2022-03-06 | Shelby | Indiana | 18145 | 14640 | 180 |
2275780 | 2275780 | 2022-03-05 | Shelby | Indiana | 18145 | 14640 | 180 |
2272527 | 2272527 | 2022-03-04 | Shelby | Indiana | 18145 | 14640 | 180 |
2269275 | 2269275 | 2022-03-03 | Shelby | Indiana | 18145 | 14635 | 180 |
2266022 | 2266022 | 2022-03-02 | Shelby | Indiana | 18145 | 14627 | 180 |
2262771 | 2262771 | 2022-03-01 | Shelby | Indiana | 18145 | 14622 | 180 |
2259520 | 2259520 | 2022-02-28 | Shelby | Indiana | 18145 | 14620 | 180 |
2256269 | 2256269 | 2022-02-27 | Shelby | Indiana | 18145 | 14607 | 180 |
2253018 | 2253018 | 2022-02-26 | Shelby | Indiana | 18145 | 14607 | 180 |
2249767 | 2249767 | 2022-02-25 | Shelby | Indiana | 18145 | 14607 | 180 |
2246516 | 2246516 | 2022-02-24 | Shelby | Indiana | 18145 | 14603 | 180 |
2243265 | 2243265 | 2022-02-23 | Shelby | Indiana | 18145 | 14597 | 178 |
2240014 | 2240014 | 2022-02-22 | Shelby | Indiana | 18145 | 14591 | 178 |
2236763 | 2236763 | 2022-02-21 | Shelby | Indiana | 18145 | 14581 | 178 |
2233512 | 2233512 | 2022-02-20 | Shelby | Indiana | 18145 | 14575 | 178 |
2230261 | 2230261 | 2022-02-19 | Shelby | Indiana | 18145 | 14575 | 178 |
2227010 | 2227010 | 2022-02-18 | Shelby | Indiana | 18145 | 14575 | 178 |
2223759 | 2223759 | 2022-02-17 | Shelby | Indiana | 18145 | 14564 | 176 |
2220508 | 2220508 | 2022-02-16 | Shelby | Indiana | 18145 | 14553 | 176 |
2217257 | 2217257 | 2022-02-15 | Shelby | Indiana | 18145 | 14548 | 174 |
2214006 | 2214006 | 2022-02-14 | Shelby | Indiana | 18145 | 14525 | 172 |
2210754 | 2210754 | 2022-02-13 | Shelby | Indiana | 18145 | 14510 | 172 |
2207501 | 2207501 | 2022-02-12 | Shelby | Indiana | 18145 | 14510 | 172 |
2204248 | 2204248 | 2022-02-11 | Shelby | Indiana | 18145 | 14510 | 172 |
2200995 | 2200995 | 2022-02-10 | Shelby | Indiana | 18145 | 14484 | 171 |
2197741 | 2197741 | 2022-02-09 | Shelby | Indiana | 18145 | 14434 | 169 |
2194487 | 2194487 | 2022-02-08 | Shelby | Indiana | 18145 | 14434 | 169 |
2191233 | 2191233 | 2022-02-07 | Shelby | Indiana | 18145 | 14383 | 168 |
2187980 | 2187980 | 2022-02-06 | Shelby | Indiana | 18145 | 14321 | 167 |
2184727 | 2184727 | 2022-02-05 | Shelby | Indiana | 18145 | 14321 | 167 |
2181475 | 2181475 | 2022-02-04 | Shelby | Indiana | 18145 | 14321 | 167 |
2178224 | 2178224 | 2022-02-03 | Shelby | Indiana | 18145 | 14276 | 167 |
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);