ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 17089 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 410 ✖
- 327 17
- 0 15
- 1177 14
- 797 12
- 867 11
- 868 11
- 1179 11
- 305 10
- 948 10
- 294 7
- 860 7
- 950 7
- 1174 7
- 312 6
- 317 6
- 789 6
- 863 6
- 869 6
- 872 6
- 874 6
- 917 6
- 918 6
- 940 6
- 1173 6
- 39 5
- 281 5
- 775 5
- 805 5
- 883 5
- 909 5
- 1171 5
- 1178 5
- 277 4
- 308 4
- 335 4
- 751 4
- 821 4
- 877 4
- 993 4
- 1000 4
- 1036 4
- 1114 4
- 1137 4
- 1160 4
- 1166 4
- 7 3
- 24 3
- 57 3
- 152 3
- 215 3
- 299 3
- 341 3
- 347 3
- 351 3
- 729 3
- 752 3
- 812 3
- 813 3
- 822 3
- 830 3
- 835 3
- 851 3
- 856 3
- 859 3
- 866 3
- 870 3
- 881 3
- 887 3
- 894 3
- 904 3
- 926 3
- 937 3
- 953 3
- 956 3
- 966 3
- 982 3
- 1011 3
- 1052 3
- 1078 3
- 1102 3
- 1147 3
- 1156 3
- 1165 3
- 1 2
- 8 2
- 15 2
- 22 2
- 30 2
- 115 2
- 178 2
- 221 2
- 234 2
- 266 2
- 288 2
- 289 2
- 297 2
- 298 2
- 306 2
- 307 2
- 325 2
- 328 2
- 334 2
- 338 2
- 348 2
- 356 2
- 360 2
- 390 2
- 604 2
- 675 2
- 705 2
- 730 2
- 732 2
- 746 2
- 758 2
- 769 2
- 782 2
- 784 2
- 799 2
- 801 2
- 802 2
- 820 2
- 834 2
- 842 2
- 846 2
- 852 2
- 855 2
- 862 2
- 864 2
- 890 2
- 920 2
- 943 2
- 944 2
- 960 2
- 997 2
- 1002 2
- 1093 2
- 1127 2
- 1152 2
- 1157 2
- 1170 2
- 2 1
- 4 1
- 9 1
- 12 1
- 18 1
- 19 1
- 20 1
- 23 1
- 25 1
- 28 1
- 31 1
- 33 1
- 37 1
- 41 1
- 45 1
- 48 1
- 52 1
- 65 1
- 74 1
- 78 1
- 84 1
- 88 1
- 89 1
- 90 1
- 93 1
- 98 1
- 104 1
- 107 1
- 109 1
- 120 1
- 136 1
- 145 1
- 150 1
- 155 1
- 163 1
- 167 1
- 170 1
- 176 1
- 188 1
- 194 1
- 198 1
- 207 1
- 227 1
- 228 1
- 230 1
- 231 1
- 240 1
- 242 1
- 245 1
- 250 1
- 251 1
- 252 1
- 254 1
- 255 1
- 257 1
- 262 1
- 265 1
- 269 1
- 272 1
- 273 1
- 275 1
- 280 1
- 285 1
- 286 1
- 290 1
- 292 1
- 301 1
- 302 1
- 303 1
- 313 1
- 314 1
- 318 1
- 320 1
- 322 1
- 324 1
- 326 1
- 329 1
- 330 1
- 331 1
- 337 1
- 342 1
- 344 1
- 345 1
- 346 1
- 359 1
- 373 1
- 379 1
- 380 1
- 381 1
- 384 1
- 394 1
- 404 1
- 407 1
- 408 1
- 415 1
- 417 1
- 425 1
- 431 1
- 438 1
- 443 1
- 445 1
- 449 1
- 453 1
- 459 1
- 461 1
- 466 1
- 467 1
- 469 1
- 472 1
- 483 1
- 488 1
- 492 1
- 497 1
- 502 1
- 504 1
- 505 1
- 509 1
- 517 1
- 525 1
- 528 1
- 537 1
- 538 1
- 543 1
- 551 1
- 555 1
- 559 1
- 565 1
- 568 1
- 569 1
- 570 1
- 573 1
- 577 1
- 581 1
- 585 1
- 588 1
- 594 1
- 596 1
- 601 1
- 618 1
- 619 1
- 621 1
- 628 1
- 631 1
- 638 1
- 642 1
- 648 1
- 651 1
- 653 1
- 659 1
- 660 1
- 662 1
- 667 1
- 676 1
- 677 1
- 685 1
- 696 1
- 699 1
- 710 1
- 713 1
- 716 1
- 720 1
- 738 1
- 742 1
- 744 1
- 748 1
- 753 1
- 755 1
- 759 1
- 760 1
- 761 1
- 763 1
- 766 1
- 768 1
- 771 1
- 773 1
- 776 1
- 778 1
- 779 1
- 783 1
- 785 1
- 791 1
- 792 1
- 793 1
- 794 1
- 800 1
- 804 1
- 808 1
- 809 1
- 814 1
- 817 1
- 818 1
- 819 1
- 823 1
- 826 1
- 829 1
- 831 1
- 832 1
- 838 1
- 840 1
- 845 1
- 847 1
- 848 1
- 849 1
- 850 1
- 854 1
- 858 1
- 865 1
- 873 1
- 875 1
- 880 1
- 884 1
- 885 1
- 889 1
- 892 1
- 899 1
- 901 1
- 902 1
- 903 1
- 905 1
- 906 1
- 913 1
- 914 1
- 923 1
- 924 1
- 928 1
- 932 1
- 933 1
- 935 1
- 939 1
- 954 1
- 958 1
- 963 1
- 974 1
- 977 1
- 978 1
- 981 1
- 987 1
- 988 1
- 990 1
- 995 1
- 1006 1
- 1008 1
- 1020 1
- 1022 1
- 1025 1
- 1032 1
- 1041 1
- 1044 1
- 1047 1
- 1064 1
- 1068 1
- 1072 1
- 1074 1
- 1084 1
- 1086 1
- 1104 1
- 1107 1
- 1111 1
- 1128 1
- 1136 1
- 1141 1
- 1143 1
- 1145 1
- 1149 1
- 1155 1
- 1158 1
- 1163 1
- 1172 1
- 1175 1
- 1176 1
state 1
- Illinois 795
fips 1
- 17089 · 795 ✖
county 1
- Kane 795
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500221 | 2500221 | 2022-05-13 | Kane | Illinois | 17089 | 131751 | 1179 |
2496963 | 2496963 | 2022-05-12 | Kane | Illinois | 17089 | 131372 | 1179 |
2493705 | 2493705 | 2022-05-11 | Kane | Illinois | 17089 | 131194 | 1179 |
2490447 | 2490447 | 2022-05-10 | Kane | Illinois | 17089 | 130942 | 1179 |
2487190 | 2487190 | 2022-05-09 | Kane | Illinois | 17089 | 130712 | 1179 |
2483932 | 2483932 | 2022-05-08 | Kane | Illinois | 17089 | 130048 | 1179 |
2480674 | 2480674 | 2022-05-07 | Kane | Illinois | 17089 | 130048 | 1179 |
2477416 | 2477416 | 2022-05-06 | Kane | Illinois | 17089 | 130048 | 1179 |
2474158 | 2474158 | 2022-05-05 | Kane | Illinois | 17089 | 129700 | 1179 |
2470901 | 2470901 | 2022-05-04 | Kane | Illinois | 17089 | 129552 | 1179 |
2467645 | 2467645 | 2022-05-03 | Kane | Illinois | 17089 | 129301 | 1179 |
2464390 | 2464390 | 2022-05-02 | Kane | Illinois | 17089 | 129110 | 1177 |
2461134 | 2461134 | 2022-05-01 | Kane | Illinois | 17089 | 128685 | 1177 |
2457878 | 2457878 | 2022-04-30 | Kane | Illinois | 17089 | 128685 | 1177 |
2454622 | 2454622 | 2022-04-29 | Kane | Illinois | 17089 | 128685 | 1177 |
2451366 | 2451366 | 2022-04-28 | Kane | Illinois | 17089 | 128448 | 1177 |
2448110 | 2448110 | 2022-04-27 | Kane | Illinois | 17089 | 128228 | 1177 |
2444854 | 2444854 | 2022-04-26 | Kane | Illinois | 17089 | 128092 | 1178 |
2441598 | 2441598 | 2022-04-25 | Kane | Illinois | 17089 | 127943 | 1178 |
2438342 | 2438342 | 2022-04-24 | Kane | Illinois | 17089 | 127585 | 1178 |
2435086 | 2435086 | 2022-04-23 | Kane | Illinois | 17089 | 127585 | 1178 |
2431830 | 2431830 | 2022-04-22 | Kane | Illinois | 17089 | 127585 | 1178 |
2428574 | 2428574 | 2022-04-21 | Kane | Illinois | 17089 | 127401 | 1177 |
2425318 | 2425318 | 2022-04-20 | Kane | Illinois | 17089 | 127287 | 1177 |
2422062 | 2422062 | 2022-04-19 | Kane | Illinois | 17089 | 127119 | 1177 |
2418806 | 2418806 | 2022-04-18 | Kane | Illinois | 17089 | 127002 | 1177 |
2415550 | 2415550 | 2022-04-17 | Kane | Illinois | 17089 | 126748 | 1177 |
2412294 | 2412294 | 2022-04-16 | Kane | Illinois | 17089 | 126748 | 1177 |
2409038 | 2409038 | 2022-04-15 | Kane | Illinois | 17089 | 126748 | 1177 |
2405782 | 2405782 | 2022-04-14 | Kane | Illinois | 17089 | 126668 | 1177 |
2402527 | 2402527 | 2022-04-13 | Kane | Illinois | 17089 | 126561 | 1176 |
2399272 | 2399272 | 2022-04-12 | Kane | Illinois | 17089 | 126514 | 1175 |
2396017 | 2396017 | 2022-04-11 | Kane | Illinois | 17089 | 126461 | 1174 |
2392761 | 2392761 | 2022-04-10 | Kane | Illinois | 17089 | 126267 | 1174 |
2389505 | 2389505 | 2022-04-09 | Kane | Illinois | 17089 | 126267 | 1174 |
2386250 | 2386250 | 2022-04-08 | Kane | Illinois | 17089 | 126267 | 1174 |
2382995 | 2382995 | 2022-04-07 | Kane | Illinois | 17089 | 126181 | 1174 |
2379740 | 2379740 | 2022-04-06 | Kane | Illinois | 17089 | 126127 | 1174 |
2376486 | 2376486 | 2022-04-05 | Kane | Illinois | 17089 | 126052 | 1174 |
2373234 | 2373234 | 2022-04-04 | Kane | Illinois | 17089 | 125989 | 1173 |
2369981 | 2369981 | 2022-04-03 | Kane | Illinois | 17089 | 125897 | 1173 |
2366728 | 2366728 | 2022-04-02 | Kane | Illinois | 17089 | 125897 | 1173 |
2363475 | 2363475 | 2022-04-01 | Kane | Illinois | 17089 | 125897 | 1173 |
2360221 | 2360221 | 2022-03-31 | Kane | Illinois | 17089 | 125848 | 1173 |
2356967 | 2356967 | 2022-03-30 | Kane | Illinois | 17089 | 125806 | 1173 |
2353714 | 2353714 | 2022-03-29 | Kane | Illinois | 17089 | 125740 | 1172 |
2350462 | 2350462 | 2022-03-28 | Kane | Illinois | 17089 | 125670 | 1171 |
2347209 | 2347209 | 2022-03-27 | Kane | Illinois | 17089 | 125578 | 1171 |
2343956 | 2343956 | 2022-03-26 | Kane | Illinois | 17089 | 125578 | 1171 |
2340703 | 2340703 | 2022-03-25 | Kane | Illinois | 17089 | 125578 | 1171 |
2337450 | 2337450 | 2022-03-24 | Kane | Illinois | 17089 | 125528 | 1171 |
2334196 | 2334196 | 2022-03-23 | Kane | Illinois | 17089 | 125431 | 1170 |
2330942 | 2330942 | 2022-03-22 | Kane | Illinois | 17089 | 125365 | 1170 |
2327690 | 2327690 | 2022-03-21 | Kane | Illinois | 17089 | 125303 | 1166 |
2324437 | 2324437 | 2022-03-20 | Kane | Illinois | 17089 | 125230 | 1166 |
2321183 | 2321183 | 2022-03-19 | Kane | Illinois | 17089 | 125230 | 1166 |
2317929 | 2317929 | 2022-03-18 | Kane | Illinois | 17089 | 125230 | 1166 |
2314676 | 2314676 | 2022-03-17 | Kane | Illinois | 17089 | 125197 | 1165 |
2311423 | 2311423 | 2022-03-16 | Kane | Illinois | 17089 | 125156 | 1165 |
2308170 | 2308170 | 2022-03-15 | Kane | Illinois | 17089 | 125114 | 1165 |
2304919 | 2304919 | 2022-03-14 | Kane | Illinois | 17089 | 125056 | 1163 |
2301667 | 2301667 | 2022-03-13 | Kane | Illinois | 17089 | 124954 | 1160 |
2298415 | 2298415 | 2022-03-12 | Kane | Illinois | 17089 | 124954 | 1160 |
2295163 | 2295163 | 2022-03-11 | Kane | Illinois | 17089 | 124954 | 1160 |
2291911 | 2291911 | 2022-03-10 | Kane | Illinois | 17089 | 124908 | 1160 |
2288659 | 2288659 | 2022-03-09 | Kane | Illinois | 17089 | 124872 | 1158 |
2285408 | 2285408 | 2022-03-08 | Kane | Illinois | 17089 | 124817 | 1157 |
2282156 | 2282156 | 2022-03-07 | Kane | Illinois | 17089 | 124781 | 1157 |
2278903 | 2278903 | 2022-03-06 | Kane | Illinois | 17089 | 124670 | 1156 |
2275650 | 2275650 | 2022-03-05 | Kane | Illinois | 17089 | 124670 | 1156 |
2272397 | 2272397 | 2022-03-04 | Kane | Illinois | 17089 | 124670 | 1156 |
2269145 | 2269145 | 2022-03-03 | Kane | Illinois | 17089 | 124603 | 1155 |
2265892 | 2265892 | 2022-03-02 | Kane | Illinois | 17089 | 124566 | 1152 |
2262641 | 2262641 | 2022-03-01 | Kane | Illinois | 17089 | 124502 | 1152 |
2259390 | 2259390 | 2022-02-28 | Kane | Illinois | 17089 | 124435 | 1149 |
2256139 | 2256139 | 2022-02-27 | Kane | Illinois | 17089 | 124286 | 1147 |
2252888 | 2252888 | 2022-02-26 | Kane | Illinois | 17089 | 124286 | 1147 |
2249637 | 2249637 | 2022-02-25 | Kane | Illinois | 17089 | 124286 | 1147 |
2246386 | 2246386 | 2022-02-24 | Kane | Illinois | 17089 | 124212 | 1145 |
2243135 | 2243135 | 2022-02-23 | Kane | Illinois | 17089 | 124147 | 1143 |
2239884 | 2239884 | 2022-02-22 | Kane | Illinois | 17089 | 124029 | 1141 |
2236633 | 2236633 | 2022-02-21 | Kane | Illinois | 17089 | 123800 | 1137 |
2233382 | 2233382 | 2022-02-20 | Kane | Illinois | 17089 | 123800 | 1137 |
2230131 | 2230131 | 2022-02-19 | Kane | Illinois | 17089 | 123800 | 1137 |
2226880 | 2226880 | 2022-02-18 | Kane | Illinois | 17089 | 123800 | 1137 |
2223629 | 2223629 | 2022-02-17 | Kane | Illinois | 17089 | 123666 | 1136 |
2220378 | 2220378 | 2022-02-16 | Kane | Illinois | 17089 | 123581 | 1128 |
2217127 | 2217127 | 2022-02-15 | Kane | Illinois | 17089 | 123471 | 1127 |
2213876 | 2213876 | 2022-02-14 | Kane | Illinois | 17089 | 123343 | 1127 |
2210624 | 2210624 | 2022-02-13 | Kane | Illinois | 17089 | 122640 | 1114 |
2207371 | 2207371 | 2022-02-12 | Kane | Illinois | 17089 | 122640 | 1114 |
2204118 | 2204118 | 2022-02-11 | Kane | Illinois | 17089 | 122640 | 1114 |
2200865 | 2200865 | 2022-02-10 | Kane | Illinois | 17089 | 122640 | 1114 |
2197611 | 2197611 | 2022-02-09 | Kane | Illinois | 17089 | 122490 | 1111 |
2194357 | 2194357 | 2022-02-08 | Kane | Illinois | 17089 | 122299 | 1107 |
2191103 | 2191103 | 2022-02-07 | Kane | Illinois | 17089 | 122127 | 1104 |
2187850 | 2187850 | 2022-02-06 | Kane | Illinois | 17089 | 121407 | 1102 |
2184597 | 2184597 | 2022-02-05 | Kane | Illinois | 17089 | 121407 | 1102 |
2181345 | 2181345 | 2022-02-04 | Kane | Illinois | 17089 | 121407 | 1102 |
2178094 | 2178094 | 2022-02-03 | Kane | Illinois | 17089 | 119863 | 1093 |
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);