ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Allen" and fips = 18003 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
cases 662 ✖
- 64407 5
- 72539 5
- 103808 5
- 104305 5
- 41909 4
- 49750 4
- 75061 4
- 41818 3
- 42075 3
- 42349 3
- 42741 3
- 43249 3
- 43914 3
- 44983 3
- 46336 3
- 47984 3
- 51279 3
- 52828 3
- 53955 3
- 55073 3
- 56184 3
- 57219 3
- 58052 3
- 58844 3
- 59811 3
- 61277 3
- 63093 3
- 67123 3
- 69483 3
- 71387 3
- 80867 3
- 87889 3
- 94675 3
- 99234 3
- 101467 3
- 102425 3
- 102883 3
- 103251 3
- 103394 3
- 103495 3
- 103599 3
- 103671 3
- 103678 3
- 103712 3
- 103743 3
- 103982 3
- 104168 3
- 4 2
- 8 2
- 89 2
- 41445 2
- 41569 2
- 41668 2
- 41747 2
- 101942 2
- 103641 2
- 103696 2
- 103767 2
- 103883 2
- 103936 2
- 104042 2
- 104131 2
- 104248 2
- 104497 2
- 104575 2
- 1 1
- 7 1
- 20 1
- 22 1
- 24 1
- 27 1
- 31 1
- 37 1
- 40 1
- 47 1
- 59 1
- 61 1
- 65 1
- 97 1
- 107 1
- 121 1
- 138 1
- 149 1
- 158 1
- 169 1
- 182 1
- 226 1
- 273 1
- 296 1
- 304 1
- 329 1
- 341 1
- 348 1
- 392 1
- 405 1
- 432 1
- 444 1
- 489 1
- 507 1
- 532 1
- 565 1
- 593 1
- 605 1
- 624 1
- 669 1
- 700 1
- 723 1
- 748 1
- 786 1
- 805 1
- 821 1
- 839 1
- 874 1
- 884 1
- 905 1
- 962 1
- 992 1
- 1003 1
- 1040 1
- 1060 1
- 1113 1
- 1146 1
- 1199 1
- 1221 1
- 1248 1
- 1285 1
- 1317 1
- 1361 1
- 1427 1
- 1459 1
- 1608 1
- 1626 1
- 1670 1
- 1719 1
- 1751 1
- 1762 1
- 1819 1
- 1860 1
- 1892 1
- 1905 1
- 1965 1
- 2023 1
- 2098 1
- 2136 1
- 2177 1
- 2204 1
- 2233 1
- 2271 1
- 2287 1
- 2334 1
- 2341 1
- 2382 1
- 2428 1
- 2442 1
- 2451 1
- 2485 1
- 2526 1
- 2566 1
- 2594 1
- 2617 1
- 2640 1
- 2668 1
- 2696 1
- 2714 1
- 2736 1
- 2756 1
- 2781 1
- 2817 1
- 2834 1
- 2854 1
- 2886 1
- 2921 1
- 2958 1
- 2971 1
- 2990 1
- 3007 1
- 3032 1
- 3055 1
- 3081 1
- 3123 1
- 3156 1
- 3189 1
- 3224 1
- 3238 1
- 3270 1
- 3304 1
- 3333 1
- 3371 1
- 3401 1
- 3442 1
- 3467 1
- 3506 1
- 3535 1
- 3583 1
- 3637 1
- 3661 1
- 3688 1
- 3721 1
- 3751 1
- 3815 1
- 3861 1
- 3928 1
- 3963 1
- 4028 1
- 4066 1
- 4129 1
- 4187 1
- 4251 1
- 4303 1
- 4340 1
- 4376 1
- 4396 1
- 4447 1
- 4488 1
- 4552 1
- 4578 1
- 4676 1
- 4740 1
- 4782 1
- 4852 1
- 4875 1
- 4932 1
- 4979 1
- 5005 1
- 5035 1
- 5088 1
- 5154 1
- 5212 1
- 5277 1
- 5321 1
- 5360 1
- 5400 1
- 5438 1
- 5491 1
- 5547 1
- 5620 1
- 5655 1
- 5680 1
- 5731 1
- 5771 1
- 5813 1
- 5877 1
- 5949 1
- 5993 1
- 6026 1
- 6057 1
- 6088 1
- 6141 1
- 6206 1
- 6273 1
- 6321 1
- 6359 1
- 6393 1
- 6440 1
- 6488 1
- 6543 1
- 6599 1
- 6650 1
- 6692 1
- 6734 1
- 6808 1
- 6882 1
- 6971 1
- 7059 1
- 7145 1
- 7192 1
- 7274 1
- 7354 1
- 7441 1
- 7577 1
- 7702 1
- 7791 1
- 7850 1
- 7915 1
- 8013 1
- 8164 1
- 8313 1
- 8459 1
- 8587 1
- 8682 1
- 8776 1
- 8921 1
- 9158 1
- 9310 1
- 9523 1
- 9673 1
- 9800 1
- 9954 1
- 10226 1
- 10477 1
- 10823 1
- 11140 1
- 11475 1
- 11681 1
- 12006 1
- 12414 1
- 12810 1
- 13191 1
- 13812 1
- 14265 1
- 14579 1
- 14889 1
- 15377 1
- 15849 1
- 16252 1
- 16684 1
- 17060 1
- 17334 1
- 17656 1
- 18045 1
- 18398 1
- 18695 1
- 19041 1
- 19361 1
- 19608 1
- 19871 1
- 20294 1
- 20706 1
- 21092 1
- 21567 1
- 21855 1
- 22179 1
- 22458 1
- 22780 1
- 22997 1
- 23459 1
- 23815 1
- 24059 1
- 24288 1
- 24463 1
- 24813 1
- 25102 1
- 25284 1
- 25568 1
- 25827 1
- 25980 1
- 26162 1
- 26399 1
- 26698 1
- 26916 1
- 27088 1
- 27150 1
- 27278 1
- 27556 1
- 27822 1
- 28059 1
- 28321 1
- 28579 1
- 28711 1
- 28954 1
- 29143 1
- 29418 1
- 29712 1
- 29978 1
- 30236 1
- 30714 1
- 30851 1
- 31055 1
- 31234 1
- 31429 1
- 31657 1
- 31846 1
- 31968 1
- 32084 1
- 32214 1
- 32380 1
- 32547 1
- 32695 1
- 32852 1
- 32940 1
- 33029 1
- 33151 1
- 33286 1
- 33417 1
- 33530 1
- 33664 1
- 33740 1
- 33824 1
- 33917 1
- 33995 1
- 34130 1
- 34199 1
- 34365 1
- 34473 1
- 34537 1
- 34622 1
- 34724 1
- 34815 1
- 34906 1
- 34978 1
- 35063 1
- 35106 1
- 35181 1
- 35256 1
- 35298 1
- 35355 1
- 35434 1
- 35490 1
- 35545 1
- 35603 1
- 35666 1
- 35715 1
- 35772 1
- 35814 1
- 35858 1
- 35913 1
- 35949 1
- 36003 1
- 36056 1
- 36103 1
- 36155 1
- 36228 1
- 36264 1
- 36305 1
- 36376 1
- 36432 1
- 36533 1
- 36621 1
- 36670 1
- 36708 1
- 36761 1
- 36837 1
- 36907 1
- 36972 1
- 37049 1
- 37126 1
- 37152 1
- 37202 1
- 37302 1
- 37391 1
- 37492 1
- 37569 1
- 37634 1
- 37699 1
- 37769 1
- 37837 1
- 37910 1
- 38005 1
- 38077 1
- 38140 1
- 38192 1
- 38233 1
- 38310 1
- 38399 1
- 38496 1
- 38566 1
- 38662 1
- 38741 1
- 38836 1
- 38922 1
- 38981 1
- 39095 1
- 39161 1
- 39240 1
- 39279 1
- 39334 1
- 39392 1
- 39469 1
- 39547 1
- 39608 1
- 39653 1
- 39706 1
- 39770 1
- 39845 1
- 39913 1
- 39995 1
- 40066 1
- 40166 1
- 40218 1
- 40278 1
- 40357 1
- 40442 1
- 40512 1
- 40584 1
- 40640 1
- 40671 1
- 40723 1
- 40789 1
- 40834 1
- 40884 1
- 40931 1
- 40968 1
- 41001 1
- 41028 1
- 41097 1
- 41152 1
- 41199 1
- 41231 1
- 41259 1
- 41275 1
- 41294 1
- 41330 1
- 41376 1
- 41413 1
- 41429 1
- 41478 1
- 41496 1
- 41523 1
- 41550 1
- 41588 1
- 41601 1
- 41627 1
- 41644 1
- 41655 1
- 41691 1
- 41697 1
- 41709 1
- 41717 1
- 41726 1
- 41765 1
- 41776 1
- 41791 1
- 41804 1
- 41841 1
- 41854 1
- 41875 1
- 41889 1
- 41962 1
- 41982 1
- 42038 1
- 42157 1
- 42194 1
- 42258 1
- 42308 1
- 42471 1
- 42531 1
- 42618 1
- 42675 1
- 42914 1
- 42994 1
- 43088 1
- 43168 1
- 43442 1
- 43556 1
- 43648 1
- 43766 1
- 44255 1
- 44418 1
- 44566 1
- 44800 1
- 45467 1
- 45625 1
- 45880 1
- 46109 1
- 46890 1
- 47128 1
- 47442 1
- 47742 1
- 48653 1
- 48857 1
- 49183 1
- 49445 1
- 50515 1
- 50672 1
- 50983 1
- 51940 1
- 52117 1
- 52357 1
- 52539 1
- 53307 1
- 53449 1
- 53665 1
- 53815 1
- 54383 1
- 54512 1
- 54670 1
- 54906 1
- 55473 1
- 55593 1
- 55794 1
- 55910 1
- 56483 1
- 56648 1
- 56825 1
- 57059 1
- 57500 1
- 57576 1
- 57733 1
- 57879 1
- 58313 1
- 58400 1
- 58547 1
- 58699 1
- 59175 1
- 59254 1
- 59444 1
- 59610 1
- 60249 1
- 60363 1
- 60619 1
- 61063 1
- 61887 1
- 62115 1
- 62378 1
- 62809 1
- 63787 1
- 64007 1
- 65597 1
- 65862 1
- 66340 1
- 66744 1
- 68064 1
- 68395 1
- 68823 1
- 69166 1
- 70199 1
- 70394 1
- 70725 1
- 71135 1
- 72068 1
- 72264 1
- 73661 1
- 73978 1
- 74434 1
- 76764 1
- 77301 1
- 78545 1
- 79733 1
- 83475 1
- 84384 1
- 85606 1
- 86748 1
- 90404 1
- 91051 1
- 92419 1
- 93646 1
- 96546 1
- 97225 1
- 97437 1
- 98216 1
- 100277 1
- 100625 1
- 100990 1
- 101249 1
- 101761 1
- 102300 1
- 102605 1
- 102658 1
- 102748 1
- 102799 1
- 103009 1
- 103108 1
- 103165 1
- 103211 1
- 103306 1
- 103324 1
- 103348 1
- 103374 1
- 103424 1
- 103443 1
- 103456 1
- 103487 1
- 103527 1
- 103563 1
- 103579 1
- 103587 1
- 103623 1
- 103639 1
- 103656 1
- 103659 1
- 103699 1
- 104713 1
state 1
- Indiana 785
fips 1
- 18003 · 785 ✖
county 1
- Allen · 785 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500281 | 2500281 | 2022-05-13 | Allen | Indiana | 18003 | 104713 | 1188 |
2497023 | 2497023 | 2022-05-12 | Allen | Indiana | 18003 | 104575 | 1187 |
2493765 | 2493765 | 2022-05-11 | Allen | Indiana | 18003 | 104575 | 1187 |
2490507 | 2490507 | 2022-05-10 | Allen | Indiana | 18003 | 104497 | 1187 |
2487250 | 2487250 | 2022-05-09 | Allen | Indiana | 18003 | 104497 | 1187 |
2483992 | 2483992 | 2022-05-08 | Allen | Indiana | 18003 | 104305 | 1186 |
2480734 | 2480734 | 2022-05-07 | Allen | Indiana | 18003 | 104305 | 1186 |
2477476 | 2477476 | 2022-05-06 | Allen | Indiana | 18003 | 104305 | 1186 |
2474218 | 2474218 | 2022-05-05 | Allen | Indiana | 18003 | 104305 | 1186 |
2470961 | 2470961 | 2022-05-04 | Allen | Indiana | 18003 | 104305 | 1186 |
2467705 | 2467705 | 2022-05-03 | Allen | Indiana | 18003 | 104248 | 1186 |
2464450 | 2464450 | 2022-05-02 | Allen | Indiana | 18003 | 104248 | 1186 |
2461194 | 2461194 | 2022-05-01 | Allen | Indiana | 18003 | 104168 | 1186 |
2457938 | 2457938 | 2022-04-30 | Allen | Indiana | 18003 | 104168 | 1186 |
2454682 | 2454682 | 2022-04-29 | Allen | Indiana | 18003 | 104168 | 1186 |
2451426 | 2451426 | 2022-04-28 | Allen | Indiana | 18003 | 104131 | 1186 |
2448170 | 2448170 | 2022-04-27 | Allen | Indiana | 18003 | 104131 | 1186 |
2444914 | 2444914 | 2022-04-26 | Allen | Indiana | 18003 | 104042 | 1185 |
2441658 | 2441658 | 2022-04-25 | Allen | Indiana | 18003 | 104042 | 1185 |
2438402 | 2438402 | 2022-04-24 | Allen | Indiana | 18003 | 103982 | 1185 |
2435146 | 2435146 | 2022-04-23 | Allen | Indiana | 18003 | 103982 | 1185 |
2431890 | 2431890 | 2022-04-22 | Allen | Indiana | 18003 | 103982 | 1185 |
2428634 | 2428634 | 2022-04-21 | Allen | Indiana | 18003 | 103936 | 1184 |
2425378 | 2425378 | 2022-04-20 | Allen | Indiana | 18003 | 103936 | 1184 |
2422122 | 2422122 | 2022-04-19 | Allen | Indiana | 18003 | 103883 | 1183 |
2418866 | 2418866 | 2022-04-18 | Allen | Indiana | 18003 | 103883 | 1183 |
2415610 | 2415610 | 2022-04-17 | Allen | Indiana | 18003 | 103808 | 1181 |
2412354 | 2412354 | 2022-04-16 | Allen | Indiana | 18003 | 103808 | 1181 |
2409098 | 2409098 | 2022-04-15 | Allen | Indiana | 18003 | 103808 | 1181 |
2405842 | 2405842 | 2022-04-14 | Allen | Indiana | 18003 | 103808 | 1181 |
2402587 | 2402587 | 2022-04-13 | Allen | Indiana | 18003 | 103808 | 1181 |
2399332 | 2399332 | 2022-04-12 | Allen | Indiana | 18003 | 103767 | 1178 |
2396077 | 2396077 | 2022-04-11 | Allen | Indiana | 18003 | 103767 | 1178 |
2392821 | 2392821 | 2022-04-10 | Allen | Indiana | 18003 | 103743 | 1178 |
2389565 | 2389565 | 2022-04-09 | Allen | Indiana | 18003 | 103743 | 1178 |
2386310 | 2386310 | 2022-04-08 | Allen | Indiana | 18003 | 103743 | 1178 |
2383055 | 2383055 | 2022-04-07 | Allen | Indiana | 18003 | 103712 | 1175 |
2379800 | 2379800 | 2022-04-06 | Allen | Indiana | 18003 | 103712 | 1175 |
2376546 | 2376546 | 2022-04-05 | Allen | Indiana | 18003 | 103696 | 1174 |
2373294 | 2373294 | 2022-04-04 | Allen | Indiana | 18003 | 103696 | 1174 |
2370041 | 2370041 | 2022-04-03 | Allen | Indiana | 18003 | 103678 | 1174 |
2366788 | 2366788 | 2022-04-02 | Allen | Indiana | 18003 | 103678 | 1174 |
2363535 | 2363535 | 2022-04-01 | Allen | Indiana | 18003 | 103678 | 1174 |
2360281 | 2360281 | 2022-03-31 | Allen | Indiana | 18003 | 103641 | 1173 |
2357027 | 2357027 | 2022-03-30 | Allen | Indiana | 18003 | 103641 | 1173 |
2353774 | 2353774 | 2022-03-29 | Allen | Indiana | 18003 | 103712 | 1173 |
2350522 | 2350522 | 2022-03-28 | Allen | Indiana | 18003 | 103699 | 1173 |
2347269 | 2347269 | 2022-03-27 | Allen | Indiana | 18003 | 103671 | 1173 |
2344016 | 2344016 | 2022-03-26 | Allen | Indiana | 18003 | 103671 | 1173 |
2340763 | 2340763 | 2022-03-25 | Allen | Indiana | 18003 | 103671 | 1173 |
2337510 | 2337510 | 2022-03-24 | Allen | Indiana | 18003 | 103659 | 1173 |
2334256 | 2334256 | 2022-03-23 | Allen | Indiana | 18003 | 103656 | 1173 |
2331002 | 2331002 | 2022-03-22 | Allen | Indiana | 18003 | 103639 | 1172 |
2327750 | 2327750 | 2022-03-21 | Allen | Indiana | 18003 | 103623 | 1172 |
2324497 | 2324497 | 2022-03-20 | Allen | Indiana | 18003 | 103599 | 1172 |
2321243 | 2321243 | 2022-03-19 | Allen | Indiana | 18003 | 103599 | 1172 |
2317989 | 2317989 | 2022-03-18 | Allen | Indiana | 18003 | 103599 | 1172 |
2314736 | 2314736 | 2022-03-17 | Allen | Indiana | 18003 | 103587 | 1171 |
2311483 | 2311483 | 2022-03-16 | Allen | Indiana | 18003 | 103579 | 1170 |
2308230 | 2308230 | 2022-03-15 | Allen | Indiana | 18003 | 103563 | 1170 |
2304979 | 2304979 | 2022-03-14 | Allen | Indiana | 18003 | 103527 | 1167 |
2301727 | 2301727 | 2022-03-13 | Allen | Indiana | 18003 | 103495 | 1167 |
2298475 | 2298475 | 2022-03-12 | Allen | Indiana | 18003 | 103495 | 1167 |
2295223 | 2295223 | 2022-03-11 | Allen | Indiana | 18003 | 103495 | 1167 |
2291971 | 2291971 | 2022-03-10 | Allen | Indiana | 18003 | 103487 | 1167 |
2288719 | 2288719 | 2022-03-09 | Allen | Indiana | 18003 | 103456 | 1166 |
2285468 | 2285468 | 2022-03-08 | Allen | Indiana | 18003 | 103443 | 1162 |
2282216 | 2282216 | 2022-03-07 | Allen | Indiana | 18003 | 103424 | 1161 |
2278963 | 2278963 | 2022-03-06 | Allen | Indiana | 18003 | 103394 | 1160 |
2275710 | 2275710 | 2022-03-05 | Allen | Indiana | 18003 | 103394 | 1160 |
2272457 | 2272457 | 2022-03-04 | Allen | Indiana | 18003 | 103394 | 1160 |
2269205 | 2269205 | 2022-03-03 | Allen | Indiana | 18003 | 103374 | 1160 |
2265952 | 2265952 | 2022-03-02 | Allen | Indiana | 18003 | 103348 | 1157 |
2262701 | 2262701 | 2022-03-01 | Allen | Indiana | 18003 | 103324 | 1154 |
2259450 | 2259450 | 2022-02-28 | Allen | Indiana | 18003 | 103306 | 1153 |
2256199 | 2256199 | 2022-02-27 | Allen | Indiana | 18003 | 103251 | 1151 |
2252948 | 2252948 | 2022-02-26 | Allen | Indiana | 18003 | 103251 | 1151 |
2249697 | 2249697 | 2022-02-25 | Allen | Indiana | 18003 | 103251 | 1151 |
2246446 | 2246446 | 2022-02-24 | Allen | Indiana | 18003 | 103211 | 1150 |
2243195 | 2243195 | 2022-02-23 | Allen | Indiana | 18003 | 103165 | 1147 |
2239944 | 2239944 | 2022-02-22 | Allen | Indiana | 18003 | 103108 | 1146 |
2236693 | 2236693 | 2022-02-21 | Allen | Indiana | 18003 | 103009 | 1139 |
2233442 | 2233442 | 2022-02-20 | Allen | Indiana | 18003 | 102883 | 1136 |
2230191 | 2230191 | 2022-02-19 | Allen | Indiana | 18003 | 102883 | 1136 |
2226940 | 2226940 | 2022-02-18 | Allen | Indiana | 18003 | 102883 | 1136 |
2223689 | 2223689 | 2022-02-17 | Allen | Indiana | 18003 | 102799 | 1132 |
2220438 | 2220438 | 2022-02-16 | Allen | Indiana | 18003 | 102748 | 1132 |
2217187 | 2217187 | 2022-02-15 | Allen | Indiana | 18003 | 102658 | 1122 |
2213936 | 2213936 | 2022-02-14 | Allen | Indiana | 18003 | 102605 | 1119 |
2210684 | 2210684 | 2022-02-13 | Allen | Indiana | 18003 | 102425 | 1117 |
2207431 | 2207431 | 2022-02-12 | Allen | Indiana | 18003 | 102425 | 1117 |
2204178 | 2204178 | 2022-02-11 | Allen | Indiana | 18003 | 102425 | 1117 |
2200925 | 2200925 | 2022-02-10 | Allen | Indiana | 18003 | 102300 | 1108 |
2197671 | 2197671 | 2022-02-09 | Allen | Indiana | 18003 | 101942 | 1099 |
2194417 | 2194417 | 2022-02-08 | Allen | Indiana | 18003 | 101942 | 1099 |
2191163 | 2191163 | 2022-02-07 | Allen | Indiana | 18003 | 101761 | 1094 |
2187910 | 2187910 | 2022-02-06 | Allen | Indiana | 18003 | 101467 | 1091 |
2184657 | 2184657 | 2022-02-05 | Allen | Indiana | 18003 | 101467 | 1091 |
2181405 | 2181405 | 2022-02-04 | Allen | Indiana | 18003 | 101467 | 1091 |
2178154 | 2178154 | 2022-02-03 | Allen | Indiana | 18003 | 101249 | 1091 |
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);