ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 17079 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 376 ✖
- 46 39
- 1167 31
- 45 21
- 47 13
- 1156 13
- 1143 12
- 2670 12
- 2674 12
- 3 11
- 1114 10
- 1168 9
- 48 7
- 49 7
- 2675 7
- 2681 7
- 1148 6
- 1150 6
- 1158 6
- 2668 6
- 1101 5
- 1161 5
- 1170 5
- 1707 5
- 2671 5
- 44 4
- 50 4
- 59 4
- 1110 4
- 1137 4
- 1149 4
- 1374 4
- 1559 4
- 1589 4
- 1746 4
- 1886 4
- 1948 4
- 2203 4
- 2634 4
- 2654 4
- 2684 4
- 55 3
- 180 3
- 213 3
- 1077 3
- 1090 3
- 1119 3
- 1129 3
- 1134 3
- 1139 3
- 1140 3
- 1151 3
- 1183 3
- 1193 3
- 1237 3
- 1311 3
- 1440 3
- 1495 3
- 1534 3
- 1605 3
- 1616 3
- 1623 3
- 1638 3
- 1667 3
- 1698 3
- 1798 3
- 1838 3
- 2049 3
- 2387 3
- 2522 3
- 2597 3
- 2665 3
- 2679 3
- 2683 3
- 4 2
- 20 2
- 36 2
- 41 2
- 42 2
- 61 2
- 73 2
- 89 2
- 124 2
- 184 2
- 211 2
- 212 2
- 217 2
- 227 2
- 229 2
- 264 2
- 280 2
- 634 2
- 872 2
- 894 2
- 986 2
- 1038 2
- 1061 2
- 1087 2
- 1092 2
- 1094 2
- 1102 2
- 1105 2
- 1109 2
- 1113 2
- 1126 2
- 1132 2
- 1610 2
- 1621 2
- 1630 2
- 1664 2
- 2583 2
- 2646 2
- 2667 2
- 2672 2
- 2673 2
- 2677 2
- 2688 2
- 2691 2
- 2 1
- 7 1
- 40 1
- 51 1
- 53 1
- 54 1
- 58 1
- 60 1
- 64 1
- 66 1
- 72 1
- 75 1
- 78 1
- 87 1
- 91 1
- 100 1
- 104 1
- 111 1
- 129 1
- 132 1
- 139 1
- 141 1
- 155 1
- 156 1
- 159 1
- 162 1
- 166 1
- 167 1
- 168 1
- 175 1
- 185 1
- 186 1
- 192 1
- 196 1
- 198 1
- 199 1
- 202 1
- 203 1
- 206 1
- 214 1
- 220 1
- 221 1
- 224 1
- 228 1
- 231 1
- 234 1
- 237 1
- 239 1
- 240 1
- 247 1
- 250 1
- 257 1
- 258 1
- 260 1
- 261 1
- 266 1
- 272 1
- 275 1
- 294 1
- 295 1
- 301 1
- 306 1
- 310 1
- 408 1
- 415 1
- 418 1
- 421 1
- 435 1
- 452 1
- 454 1
- 472 1
- 482 1
- 492 1
- 500 1
- 524 1
- 534 1
- 546 1
- 559 1
- 571 1
- 581 1
- 582 1
- 605 1
- 618 1
- 639 1
- 644 1
- 652 1
- 675 1
- 685 1
- 695 1
- 710 1
- 724 1
- 727 1
- 729 1
- 742 1
- 746 1
- 759 1
- 777 1
- 788 1
- 791 1
- 792 1
- 804 1
- 815 1
- 822 1
- 829 1
- 831 1
- 833 1
- 837 1
- 847 1
- 861 1
- 869 1
- 870 1
- 873 1
- 884 1
- 887 1
- 906 1
- 911 1
- 918 1
- 946 1
- 957 1
- 970 1
- 974 1
- 989 1
- 1004 1
- 1010 1
- 1015 1
- 1019 1
- 1030 1
- 1040 1
- 1043 1
- 1047 1
- 1057 1
- 1060 1
- 1068 1
- 1069 1
- 1076 1
- 1079 1
- 1086 1
- 1091 1
- 1095 1
- 1096 1
- 1099 1
- 1100 1
- 1106 1
- 1112 1
- 1115 1
- 1116 1
- 1120 1
- 1128 1
- 1130 1
- 1131 1
- 1142 1
- 1152 1
- 1153 1
- 1155 1
- 1157 1
- 1160 1
- 1162 1
- 1163 1
- 1169 1
- 1171 1
- 1174 1
- 1179 1
- 1186 1
- 1189 1
- 1190 1
- 1192 1
- 1206 1
- 1219 1
- 1226 1
- 1229 1
- 1254 1
- 1268 1
- 1290 1
- 1301 1
- 1326 1
- 1337 1
- 1349 1
- 1359 1
- 1401 1
- 1414 1
- 1430 1
- 1453 1
- 1478 1
- 1487 1
- 1492 1
- 1506 1
- 1515 1
- 1524 1
- 1531 1
- 1540 1
- 1547 1
- 1554 1
- 1570 1
- 1581 1
- 1583 1
- 1587 1
- 1595 1
- 1598 1
- 1601 1
- 1612 1
- 1613 1
- 1618 1
- 1622 1
- 1632 1
- 1637 1
- 1649 1
- 1658 1
- 1676 1
- 1685 1
- 1687 1
- 1692 1
- 1702 1
- 1704 1
- 1719 1
- 1729 1
- 1738 1
- 1759 1
- 1769 1
- 1782 1
- 1789 1
- 1807 1
- 1815 1
- 1825 1
- 1831 1
- 1855 1
- 1869 1
- 1878 1
- 1902 1
- 1915 1
- 1922 1
- 1975 1
- 1981 1
- 2009 1
- 2034 1
- 2082 1
- 2120 1
- 2141 1
- 2176 1
- 2262 1
- 2291 1
- 2346 1
- 2433 1
- 2461 1
- 2496 1
- 2511 1
- 2555 1
- 2572 1
- 2606 1
- 2617 1
- 2621 1
- 2647 1
- 2649 1
- 2660 1
- 2661 1
- 2663 1
- 2666 1
- 2676 1
- 2678 1
- 2690 1
state 1
- Illinois · 770 ✖
fips 1
- 17079 · 770 ✖
county 1
- Jasper 770
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500216 | 2500216 | 2022-05-13 | Jasper | Illinois | 17079 | 2691 | 33 |
2496958 | 2496958 | 2022-05-12 | Jasper | Illinois | 17079 | 2691 | 33 |
2493700 | 2493700 | 2022-05-11 | Jasper | Illinois | 17079 | 2690 | 33 |
2490442 | 2490442 | 2022-05-10 | Jasper | Illinois | 17079 | 2688 | 32 |
2487185 | 2487185 | 2022-05-09 | Jasper | Illinois | 17079 | 2688 | 32 |
2483927 | 2483927 | 2022-05-08 | Jasper | Illinois | 17079 | 2684 | 32 |
2480669 | 2480669 | 2022-05-07 | Jasper | Illinois | 17079 | 2684 | 32 |
2477411 | 2477411 | 2022-05-06 | Jasper | Illinois | 17079 | 2684 | 32 |
2474153 | 2474153 | 2022-05-05 | Jasper | Illinois | 17079 | 2684 | 32 |
2470896 | 2470896 | 2022-05-04 | Jasper | Illinois | 17079 | 2683 | 32 |
2467640 | 2467640 | 2022-05-03 | Jasper | Illinois | 17079 | 2683 | 32 |
2464385 | 2464385 | 2022-05-02 | Jasper | Illinois | 17079 | 2683 | 32 |
2461129 | 2461129 | 2022-05-01 | Jasper | Illinois | 17079 | 2681 | 32 |
2457873 | 2457873 | 2022-04-30 | Jasper | Illinois | 17079 | 2681 | 32 |
2454617 | 2454617 | 2022-04-29 | Jasper | Illinois | 17079 | 2681 | 32 |
2451361 | 2451361 | 2022-04-28 | Jasper | Illinois | 17079 | 2681 | 32 |
2448105 | 2448105 | 2022-04-27 | Jasper | Illinois | 17079 | 2681 | 32 |
2444849 | 2444849 | 2022-04-26 | Jasper | Illinois | 17079 | 2681 | 32 |
2441593 | 2441593 | 2022-04-25 | Jasper | Illinois | 17079 | 2681 | 32 |
2438337 | 2438337 | 2022-04-24 | Jasper | Illinois | 17079 | 2679 | 32 |
2435081 | 2435081 | 2022-04-23 | Jasper | Illinois | 17079 | 2679 | 32 |
2431825 | 2431825 | 2022-04-22 | Jasper | Illinois | 17079 | 2679 | 32 |
2428569 | 2428569 | 2022-04-21 | Jasper | Illinois | 17079 | 2678 | 32 |
2425313 | 2425313 | 2022-04-20 | Jasper | Illinois | 17079 | 2677 | 32 |
2422057 | 2422057 | 2022-04-19 | Jasper | Illinois | 17079 | 2677 | 32 |
2418801 | 2418801 | 2022-04-18 | Jasper | Illinois | 17079 | 2676 | 32 |
2415545 | 2415545 | 2022-04-17 | Jasper | Illinois | 17079 | 2675 | 32 |
2412289 | 2412289 | 2022-04-16 | Jasper | Illinois | 17079 | 2675 | 32 |
2409033 | 2409033 | 2022-04-15 | Jasper | Illinois | 17079 | 2675 | 32 |
2405777 | 2405777 | 2022-04-14 | Jasper | Illinois | 17079 | 2675 | 32 |
2402522 | 2402522 | 2022-04-13 | Jasper | Illinois | 17079 | 2675 | 32 |
2399267 | 2399267 | 2022-04-12 | Jasper | Illinois | 17079 | 2675 | 32 |
2396012 | 2396012 | 2022-04-11 | Jasper | Illinois | 17079 | 2675 | 32 |
2392756 | 2392756 | 2022-04-10 | Jasper | Illinois | 17079 | 2674 | 32 |
2389500 | 2389500 | 2022-04-09 | Jasper | Illinois | 17079 | 2674 | 32 |
2386245 | 2386245 | 2022-04-08 | Jasper | Illinois | 17079 | 2674 | 32 |
2382990 | 2382990 | 2022-04-07 | Jasper | Illinois | 17079 | 2674 | 31 |
2379735 | 2379735 | 2022-04-06 | Jasper | Illinois | 17079 | 2674 | 31 |
2376481 | 2376481 | 2022-04-05 | Jasper | Illinois | 17079 | 2674 | 31 |
2373229 | 2373229 | 2022-04-04 | Jasper | Illinois | 17079 | 2674 | 31 |
2369976 | 2369976 | 2022-04-03 | Jasper | Illinois | 17079 | 2674 | 31 |
2366723 | 2366723 | 2022-04-02 | Jasper | Illinois | 17079 | 2674 | 31 |
2363470 | 2363470 | 2022-04-01 | Jasper | Illinois | 17079 | 2674 | 31 |
2360216 | 2360216 | 2022-03-31 | Jasper | Illinois | 17079 | 2674 | 31 |
2356962 | 2356962 | 2022-03-30 | Jasper | Illinois | 17079 | 2673 | 30 |
2353709 | 2353709 | 2022-03-29 | Jasper | Illinois | 17079 | 2673 | 30 |
2350457 | 2350457 | 2022-03-28 | Jasper | Illinois | 17079 | 2674 | 30 |
2347204 | 2347204 | 2022-03-27 | Jasper | Illinois | 17079 | 2671 | 30 |
2343951 | 2343951 | 2022-03-26 | Jasper | Illinois | 17079 | 2671 | 30 |
2340698 | 2340698 | 2022-03-25 | Jasper | Illinois | 17079 | 2671 | 30 |
2337445 | 2337445 | 2022-03-24 | Jasper | Illinois | 17079 | 2671 | 30 |
2334191 | 2334191 | 2022-03-23 | Jasper | Illinois | 17079 | 2672 | 30 |
2330937 | 2330937 | 2022-03-22 | Jasper | Illinois | 17079 | 2672 | 30 |
2327685 | 2327685 | 2022-03-21 | Jasper | Illinois | 17079 | 2671 | 30 |
2324432 | 2324432 | 2022-03-20 | Jasper | Illinois | 17079 | 2670 | 29 |
2321178 | 2321178 | 2022-03-19 | Jasper | Illinois | 17079 | 2670 | 29 |
2317924 | 2317924 | 2022-03-18 | Jasper | Illinois | 17079 | 2670 | 29 |
2314671 | 2314671 | 2022-03-17 | Jasper | Illinois | 17079 | 2670 | 29 |
2311418 | 2311418 | 2022-03-16 | Jasper | Illinois | 17079 | 2670 | 28 |
2308165 | 2308165 | 2022-03-15 | Jasper | Illinois | 17079 | 2670 | 28 |
2304914 | 2304914 | 2022-03-14 | Jasper | Illinois | 17079 | 2670 | 28 |
2301662 | 2301662 | 2022-03-13 | Jasper | Illinois | 17079 | 2670 | 28 |
2298410 | 2298410 | 2022-03-12 | Jasper | Illinois | 17079 | 2670 | 28 |
2295158 | 2295158 | 2022-03-11 | Jasper | Illinois | 17079 | 2670 | 28 |
2291906 | 2291906 | 2022-03-10 | Jasper | Illinois | 17079 | 2670 | 28 |
2288654 | 2288654 | 2022-03-09 | Jasper | Illinois | 17079 | 2670 | 28 |
2285403 | 2285403 | 2022-03-08 | Jasper | Illinois | 17079 | 2668 | 28 |
2282151 | 2282151 | 2022-03-07 | Jasper | Illinois | 17079 | 2668 | 28 |
2278898 | 2278898 | 2022-03-06 | Jasper | Illinois | 17079 | 2668 | 28 |
2275645 | 2275645 | 2022-03-05 | Jasper | Illinois | 17079 | 2668 | 28 |
2272392 | 2272392 | 2022-03-04 | Jasper | Illinois | 17079 | 2668 | 28 |
2269140 | 2269140 | 2022-03-03 | Jasper | Illinois | 17079 | 2668 | 28 |
2265887 | 2265887 | 2022-03-02 | Jasper | Illinois | 17079 | 2667 | 28 |
2262636 | 2262636 | 2022-03-01 | Jasper | Illinois | 17079 | 2667 | 28 |
2259385 | 2259385 | 2022-02-28 | Jasper | Illinois | 17079 | 2666 | 28 |
2256134 | 2256134 | 2022-02-27 | Jasper | Illinois | 17079 | 2665 | 28 |
2252883 | 2252883 | 2022-02-26 | Jasper | Illinois | 17079 | 2665 | 28 |
2249632 | 2249632 | 2022-02-25 | Jasper | Illinois | 17079 | 2665 | 28 |
2246381 | 2246381 | 2022-02-24 | Jasper | Illinois | 17079 | 2663 | 28 |
2243130 | 2243130 | 2022-02-23 | Jasper | Illinois | 17079 | 2661 | 28 |
2239879 | 2239879 | 2022-02-22 | Jasper | Illinois | 17079 | 2660 | 28 |
2236628 | 2236628 | 2022-02-21 | Jasper | Illinois | 17079 | 2654 | 27 |
2233377 | 2233377 | 2022-02-20 | Jasper | Illinois | 17079 | 2654 | 27 |
2230126 | 2230126 | 2022-02-19 | Jasper | Illinois | 17079 | 2654 | 27 |
2226875 | 2226875 | 2022-02-18 | Jasper | Illinois | 17079 | 2654 | 27 |
2223624 | 2223624 | 2022-02-17 | Jasper | Illinois | 17079 | 2649 | 27 |
2220373 | 2220373 | 2022-02-16 | Jasper | Illinois | 17079 | 2647 | 27 |
2217122 | 2217122 | 2022-02-15 | Jasper | Illinois | 17079 | 2646 | 27 |
2213871 | 2213871 | 2022-02-14 | Jasper | Illinois | 17079 | 2646 | 27 |
2210619 | 2210619 | 2022-02-13 | Jasper | Illinois | 17079 | 2634 | 27 |
2207366 | 2207366 | 2022-02-12 | Jasper | Illinois | 17079 | 2634 | 27 |
2204113 | 2204113 | 2022-02-11 | Jasper | Illinois | 17079 | 2634 | 27 |
2200860 | 2200860 | 2022-02-10 | Jasper | Illinois | 17079 | 2634 | 27 |
2197606 | 2197606 | 2022-02-09 | Jasper | Illinois | 17079 | 2621 | 27 |
2194352 | 2194352 | 2022-02-08 | Jasper | Illinois | 17079 | 2617 | 26 |
2191098 | 2191098 | 2022-02-07 | Jasper | Illinois | 17079 | 2606 | 26 |
2187845 | 2187845 | 2022-02-06 | Jasper | Illinois | 17079 | 2597 | 26 |
2184592 | 2184592 | 2022-02-05 | Jasper | Illinois | 17079 | 2597 | 26 |
2181340 | 2181340 | 2022-02-04 | Jasper | Illinois | 17079 | 2597 | 26 |
2178089 | 2178089 | 2022-02-03 | Jasper | Illinois | 17079 | 2583 | 26 |
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);