ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Kendall" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 450 ✖
- 13888 8
- 16770 8
- 17421 8
- 18282 8
- 11863 7
- 12009 7
- 12244 7
- 12426 7
- 12666 7
- 13008 7
- 13181 7
- 13411 7
- 13589 7
- 13676 7
- 13780 7
- 13817 7
- 13853 7
- 13873 7
- 13945 7
- 13977 7
- 14023 7
- 14083 7
- 14220 7
- 14437 7
- 14682 7
- 14851 7
- 15100 7
- 15549 7
- 15844 7
- 16321 7
- 16484 7
- 17102 7
- 17252 7
- 18680 7
- 19339 7
- 11772 6
- 13912 6
- 16957 6
- 17710 6
- 17933 6
- 19942 6
- 3 4
- 20271 4
- 21819 4
- 26259 4
- 29872 4
- 30316 4
- 4 3
- 1029 3
- 1099 3
- 1775 3
- 10612 3
- 11509 3
- 24302 3
- 27769 3
- 28853 3
- 29474 3
- 30458 3
- 30547 3
- 30637 3
- 30735 3
- 30824 3
- 30893 3
- 31010 3
- 31139 3
- 31346 3
- 31600 3
- 31968 3
- 114 2
- 135 2
- 793 2
- 869 2
- 906 2
- 946 2
- 990 2
- 1170 2
- 1249 2
- 1329 2
- 1411 2
- 1504 2
- 1607 2
- 1684 2
- 1693 2
- 1852 2
- 1932 2
- 2061 2
- 2160 2
- 2293 2
- 2485 2
- 8771 2
- 8851 2
- 9364 2
- 9681 2
- 9909 2
- 10081 2
- 10382 2
- 10768 2
- 10800 2
- 10908 2
- 11308 2
- 29304 2
- 6 1
- 7 1
- 8 1
- 11 1
- 15 1
- 18 1
- 19 1
- 27 1
- 36 1
- 37 1
- 47 1
- 49 1
- 55 1
- 61 1
- 79 1
- 86 1
- 92 1
- 103 1
- 105 1
- 116 1
- 119 1
- 123 1
- 138 1
- 146 1
- 157 1
- 171 1
- 191 1
- 203 1
- 208 1
- 218 1
- 235 1
- 255 1
- 266 1
- 281 1
- 291 1
- 305 1
- 326 1
- 334 1
- 346 1
- 363 1
- 373 1
- 388 1
- 421 1
- 431 1
- 477 1
- 497 1
- 518 1
- 531 1
- 559 1
- 563 1
- 579 1
- 602 1
- 635 1
- 650 1
- 680 1
- 705 1
- 709 1
- 722 1
- 754 1
- 769 1
- 781 1
- 798 1
- 832 1
- 843 1
- 853 1
- 860 1
- 868 1
- 874 1
- 886 1
- 893 1
- 898 1
- 905 1
- 911 1
- 924 1
- 928 1
- 938 1
- 943 1
- 949 1
- 966 1
- 971 1
- 982 1
- 985 1
- 1001 1
- 1008 1
- 1013 1
- 1021 1
- 1050 1
- 1058 1
- 1071 1
- 1078 1
- 1084 1
- 1127 1
- 1141 1
- 1152 1
- 1157 1
- 1184 1
- 1198 1
- 1210 1
- 1218 1
- 1235 1
- 1274 1
- 1287 1
- 1295 1
- 1309 1
- 1322 1
- 1338 1
- 1350 1
- 1362 1
- 1377 1
- 1391 1
- 1434 1
- 1451 1
- 1457 1
- 1474 1
- 1486 1
- 1514 1
- 1542 1
- 1563 1
- 1579 1
- 1602 1
- 1629 1
- 1640 1
- 1660 1
- 1671 1
- 1681 1
- 1716 1
- 1741 1
- 1762 1
- 1797 1
- 1819 1
- 1824 1
- 1847 1
- 1867 1
- 1881 1
- 1894 1
- 1905 1
- 1928 1
- 1965 1
- 1978 1
- 1995 1
- 2031 1
- 2042 1
- 2078 1
- 2106 1
- 2120 1
- 2135 1
- 2151 1
- 2182 1
- 2201 1
- 2232 1
- 2252 1
- 2271 1
- 2311 1
- 2346 1
- 2365 1
- 2422 1
- 2464 1
- 2523 1
- 2540 1
- 2585 1
- 2614 1
- 2633 1
- 2653 1
- 2670 1
- 2714 1
- 2753 1
- 2797 1
- 2869 1
- 2938 1
- 2942 1
- 3083 1
- 3138 1
- 3228 1
- 3331 1
- 3428 1
- 3619 1
- 3801 1
- 3903 1
- 3999 1
- 4144 1
- 4292 1
- 4455 1
- 4602 1
- 4695 1
- 4818 1
- 4913 1
- 5066 1
- 5149 1
- 5298 1
- 5443 1
- 5566 1
- 5646 1
- 5739 1
- 5833 1
- 5947 1
- 6060 1
- 6133 1
- 6216 1
- 6269 1
- 6318 1
- 6495 1
- 6580 1
- 6658 1
- 6757 1
- 6838 1
- 6907 1
- 6967 1
- 7055 1
- 7130 1
- 7191 1
- 7241 1
- 7308 1
- 7376 1
- 7453 1
- 7516 1
- 7591 1
- 7695 1
- 7755 1
- 7816 1
- 7863 1
- 7903 1
- 7953 1
- 8018 1
- 8102 1
- 8148 1
- 8166 1
- 8207 1
- 8258 1
- 8300 1
- 8634 1
- 9010 1
- 9067 1
- 9131 1
- 9203 1
- 9276 1
- 9453 1
- 9514 1
- 9583 1
- 9622 1
- 9717 1
- 9782 1
- 9855 1
- 10015 1
- 10135 1
- 10190 1
- 10256 1
- 10301 1
- 10346 1
- 10438 1
- 10496 1
- 10524 1
- 10563 1
- 10682 1
- 10713 1
- 10746 1
- 10816 1
- 10829 1
- 10850 1
- 10875 1
- 10891 1
- 10935 1
- 10965 1
- 10988 1
- 11131 1
- 11291 1
- 11366 1
- 11418 1
- 11442 1
- 11461 1
- 11492 1
- 11710 1
- 11722 1
- 11747 1
- 20017 1
- 20878 1
- 21176 1
- 21421 1
- 22832 1
- 23071 1
- 23429 1
- 23962 1
- 25117 1
- 25410 1
- 25706 1
- 26023 1
- 27089 1
- 27304 1
- 27505 1
- 28239 1
- 28356 1
- 28527 1
- 28697 1
- 29089 1
- 29224 1
- 29649 1
- 29735 1
- 29791 1
- 30131 1
- 30227 1
- 30265 1
- 30289 1
- 30387 1
- 30418 1
- 30434 1
- 30495 1
- 30513 1
- 30519 1
- 30532 1
- 30574 1
- 30582 1
- 30600 1
- 30614 1
- 30671 1
- 30682 1
- 30693 1
- 30713 1
- 30772 1
- 30784 1
- 30794 1
- 30809 1
- 30850 1
- 30857 1
- 30862 1
- 30877 1
- 30930 1
- 30947 1
- 30980 1
- 30991 1
- 31053 1
- 31069 1
- 31087 1
- 31115 1
- 31187 1
- 31220 1
- 31261 1
- 31307 1
- 31442 1
- 31468 1
- 31502 1
- 31560 1
- 31719 1
- 31774 1
- 31827 1
- 31874 1
- 32197 1
- 32269 1
- 32345 1
- 32402 1
- 32538 1
state 1
- Illinois · 787 ✖
fips 1
- 17093 787
county 1
- Kendall · 787 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500223 | 2500223 | 2022-05-13 | Kendall | Illinois | 17093 | 32538 | 171 |
2496965 | 2496965 | 2022-05-12 | Kendall | Illinois | 17093 | 32402 | 171 |
2493707 | 2493707 | 2022-05-11 | Kendall | Illinois | 17093 | 32345 | 171 |
2490449 | 2490449 | 2022-05-10 | Kendall | Illinois | 17093 | 32269 | 170 |
2487192 | 2487192 | 2022-05-09 | Kendall | Illinois | 17093 | 32197 | 170 |
2483934 | 2483934 | 2022-05-08 | Kendall | Illinois | 17093 | 31968 | 170 |
2480676 | 2480676 | 2022-05-07 | Kendall | Illinois | 17093 | 31968 | 170 |
2477418 | 2477418 | 2022-05-06 | Kendall | Illinois | 17093 | 31968 | 170 |
2474160 | 2474160 | 2022-05-05 | Kendall | Illinois | 17093 | 31874 | 170 |
2470903 | 2470903 | 2022-05-04 | Kendall | Illinois | 17093 | 31827 | 170 |
2467647 | 2467647 | 2022-05-03 | Kendall | Illinois | 17093 | 31774 | 170 |
2464392 | 2464392 | 2022-05-02 | Kendall | Illinois | 17093 | 31719 | 170 |
2461136 | 2461136 | 2022-05-01 | Kendall | Illinois | 17093 | 31600 | 170 |
2457880 | 2457880 | 2022-04-30 | Kendall | Illinois | 17093 | 31600 | 170 |
2454624 | 2454624 | 2022-04-29 | Kendall | Illinois | 17093 | 31600 | 170 |
2451368 | 2451368 | 2022-04-28 | Kendall | Illinois | 17093 | 31560 | 170 |
2448112 | 2448112 | 2022-04-27 | Kendall | Illinois | 17093 | 31502 | 170 |
2444856 | 2444856 | 2022-04-26 | Kendall | Illinois | 17093 | 31468 | 170 |
2441600 | 2441600 | 2022-04-25 | Kendall | Illinois | 17093 | 31442 | 170 |
2438344 | 2438344 | 2022-04-24 | Kendall | Illinois | 17093 | 31346 | 170 |
2435088 | 2435088 | 2022-04-23 | Kendall | Illinois | 17093 | 31346 | 170 |
2431832 | 2431832 | 2022-04-22 | Kendall | Illinois | 17093 | 31346 | 170 |
2428576 | 2428576 | 2022-04-21 | Kendall | Illinois | 17093 | 31307 | 170 |
2425320 | 2425320 | 2022-04-20 | Kendall | Illinois | 17093 | 31261 | 170 |
2422064 | 2422064 | 2022-04-19 | Kendall | Illinois | 17093 | 31220 | 170 |
2418808 | 2418808 | 2022-04-18 | Kendall | Illinois | 17093 | 31187 | 170 |
2415552 | 2415552 | 2022-04-17 | Kendall | Illinois | 17093 | 31139 | 170 |
2412296 | 2412296 | 2022-04-16 | Kendall | Illinois | 17093 | 31139 | 170 |
2409040 | 2409040 | 2022-04-15 | Kendall | Illinois | 17093 | 31139 | 170 |
2405784 | 2405784 | 2022-04-14 | Kendall | Illinois | 17093 | 31115 | 170 |
2402529 | 2402529 | 2022-04-13 | Kendall | Illinois | 17093 | 31087 | 170 |
2399274 | 2399274 | 2022-04-12 | Kendall | Illinois | 17093 | 31069 | 170 |
2396019 | 2396019 | 2022-04-11 | Kendall | Illinois | 17093 | 31053 | 170 |
2392763 | 2392763 | 2022-04-10 | Kendall | Illinois | 17093 | 31010 | 170 |
2389507 | 2389507 | 2022-04-09 | Kendall | Illinois | 17093 | 31010 | 170 |
2386252 | 2386252 | 2022-04-08 | Kendall | Illinois | 17093 | 31010 | 170 |
2382997 | 2382997 | 2022-04-07 | Kendall | Illinois | 17093 | 30991 | 170 |
2379742 | 2379742 | 2022-04-06 | Kendall | Illinois | 17093 | 30980 | 170 |
2376488 | 2376488 | 2022-04-05 | Kendall | Illinois | 17093 | 30947 | 170 |
2373236 | 2373236 | 2022-04-04 | Kendall | Illinois | 17093 | 30930 | 170 |
2369983 | 2369983 | 2022-04-03 | Kendall | Illinois | 17093 | 30893 | 170 |
2366730 | 2366730 | 2022-04-02 | Kendall | Illinois | 17093 | 30893 | 170 |
2363477 | 2363477 | 2022-04-01 | Kendall | Illinois | 17093 | 30893 | 170 |
2360223 | 2360223 | 2022-03-31 | Kendall | Illinois | 17093 | 30877 | 170 |
2356969 | 2356969 | 2022-03-30 | Kendall | Illinois | 17093 | 30862 | 169 |
2353716 | 2353716 | 2022-03-29 | Kendall | Illinois | 17093 | 30857 | 169 |
2350464 | 2350464 | 2022-03-28 | Kendall | Illinois | 17093 | 30850 | 169 |
2347211 | 2347211 | 2022-03-27 | Kendall | Illinois | 17093 | 30824 | 169 |
2343958 | 2343958 | 2022-03-26 | Kendall | Illinois | 17093 | 30824 | 169 |
2340705 | 2340705 | 2022-03-25 | Kendall | Illinois | 17093 | 30824 | 169 |
2337452 | 2337452 | 2022-03-24 | Kendall | Illinois | 17093 | 30809 | 169 |
2334198 | 2334198 | 2022-03-23 | Kendall | Illinois | 17093 | 30794 | 169 |
2330944 | 2330944 | 2022-03-22 | Kendall | Illinois | 17093 | 30784 | 169 |
2327692 | 2327692 | 2022-03-21 | Kendall | Illinois | 17093 | 30772 | 169 |
2324439 | 2324439 | 2022-03-20 | Kendall | Illinois | 17093 | 30735 | 168 |
2321185 | 2321185 | 2022-03-19 | Kendall | Illinois | 17093 | 30735 | 168 |
2317931 | 2317931 | 2022-03-18 | Kendall | Illinois | 17093 | 30735 | 168 |
2314678 | 2314678 | 2022-03-17 | Kendall | Illinois | 17093 | 30713 | 167 |
2311425 | 2311425 | 2022-03-16 | Kendall | Illinois | 17093 | 30693 | 167 |
2308172 | 2308172 | 2022-03-15 | Kendall | Illinois | 17093 | 30682 | 167 |
2304921 | 2304921 | 2022-03-14 | Kendall | Illinois | 17093 | 30671 | 166 |
2301669 | 2301669 | 2022-03-13 | Kendall | Illinois | 17093 | 30637 | 166 |
2298417 | 2298417 | 2022-03-12 | Kendall | Illinois | 17093 | 30637 | 166 |
2295165 | 2295165 | 2022-03-11 | Kendall | Illinois | 17093 | 30637 | 166 |
2291913 | 2291913 | 2022-03-10 | Kendall | Illinois | 17093 | 30614 | 166 |
2288661 | 2288661 | 2022-03-09 | Kendall | Illinois | 17093 | 30600 | 165 |
2285410 | 2285410 | 2022-03-08 | Kendall | Illinois | 17093 | 30582 | 165 |
2282158 | 2282158 | 2022-03-07 | Kendall | Illinois | 17093 | 30574 | 165 |
2278905 | 2278905 | 2022-03-06 | Kendall | Illinois | 17093 | 30547 | 165 |
2275652 | 2275652 | 2022-03-05 | Kendall | Illinois | 17093 | 30547 | 165 |
2272399 | 2272399 | 2022-03-04 | Kendall | Illinois | 17093 | 30547 | 165 |
2269147 | 2269147 | 2022-03-03 | Kendall | Illinois | 17093 | 30532 | 164 |
2265894 | 2265894 | 2022-03-02 | Kendall | Illinois | 17093 | 30519 | 164 |
2262643 | 2262643 | 2022-03-01 | Kendall | Illinois | 17093 | 30513 | 164 |
2259392 | 2259392 | 2022-02-28 | Kendall | Illinois | 17093 | 30495 | 164 |
2256141 | 2256141 | 2022-02-27 | Kendall | Illinois | 17093 | 30458 | 163 |
2252890 | 2252890 | 2022-02-26 | Kendall | Illinois | 17093 | 30458 | 163 |
2249639 | 2249639 | 2022-02-25 | Kendall | Illinois | 17093 | 30458 | 163 |
2246388 | 2246388 | 2022-02-24 | Kendall | Illinois | 17093 | 30434 | 163 |
2243137 | 2243137 | 2022-02-23 | Kendall | Illinois | 17093 | 30418 | 162 |
2239886 | 2239886 | 2022-02-22 | Kendall | Illinois | 17093 | 30387 | 162 |
2236635 | 2236635 | 2022-02-21 | Kendall | Illinois | 17093 | 30316 | 161 |
2233384 | 2233384 | 2022-02-20 | Kendall | Illinois | 17093 | 30316 | 161 |
2230133 | 2230133 | 2022-02-19 | Kendall | Illinois | 17093 | 30316 | 161 |
2226882 | 2226882 | 2022-02-18 | Kendall | Illinois | 17093 | 30316 | 161 |
2223631 | 2223631 | 2022-02-17 | Kendall | Illinois | 17093 | 30289 | 161 |
2220380 | 2220380 | 2022-02-16 | Kendall | Illinois | 17093 | 30265 | 160 |
2217129 | 2217129 | 2022-02-15 | Kendall | Illinois | 17093 | 30227 | 158 |
2213878 | 2213878 | 2022-02-14 | Kendall | Illinois | 17093 | 30131 | 158 |
2210626 | 2210626 | 2022-02-13 | Kendall | Illinois | 17093 | 29872 | 158 |
2207373 | 2207373 | 2022-02-12 | Kendall | Illinois | 17093 | 29872 | 158 |
2204120 | 2204120 | 2022-02-11 | Kendall | Illinois | 17093 | 29872 | 158 |
2200867 | 2200867 | 2022-02-10 | Kendall | Illinois | 17093 | 29872 | 158 |
2197613 | 2197613 | 2022-02-09 | Kendall | Illinois | 17093 | 29791 | 157 |
2194359 | 2194359 | 2022-02-08 | Kendall | Illinois | 17093 | 29735 | 156 |
2191105 | 2191105 | 2022-02-07 | Kendall | Illinois | 17093 | 29649 | 155 |
2187852 | 2187852 | 2022-02-06 | Kendall | Illinois | 17093 | 29474 | 153 |
2184599 | 2184599 | 2022-02-05 | Kendall | Illinois | 17093 | 29474 | 153 |
2181347 | 2181347 | 2022-02-04 | Kendall | Illinois | 17093 | 29474 | 153 |
2178096 | 2178096 | 2022-02-03 | Kendall | Illinois | 17093 | 29304 | 152 |
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);