ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-09-30" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1768478 | 1768478 | 2021-09-30 | Adams | Illinois | 17001 | 12849 | 177 |
1768479 | 1768479 | 2021-09-30 | Alexander | Illinois | 17003 | 685 | 11 |
1768480 | 1768480 | 2021-09-30 | Bond | Illinois | 17005 | 2475 | 29 |
1768481 | 1768481 | 2021-09-30 | Boone | Illinois | 17007 | 7702 | 95 |
1768482 | 1768482 | 2021-09-30 | Brown | Illinois | 17009 | 1036 | 14 |
1768483 | 1768483 | 2021-09-30 | Bureau | Illinois | 17011 | 4314 | 101 |
1768484 | 1768484 | 2021-09-30 | Calhoun | Illinois | 17013 | 651 | 5 |
1768485 | 1768485 | 2021-09-30 | Carroll | Illinois | 17015 | 2281 | 38 |
1768486 | 1768486 | 2021-09-30 | Cass | Illinois | 17017 | 2557 | 38 |
1768487 | 1768487 | 2021-09-30 | Champaign | Illinois | 17019 | 26246 | 196 |
1768488 | 1768488 | 2021-09-30 | Christian | Illinois | 17021 | 5028 | 99 |
1768489 | 1768489 | 2021-09-30 | Clark | Illinois | 17023 | 2578 | 47 |
1768490 | 1768490 | 2021-09-30 | Clay | Illinois | 17025 | 2474 | 54 |
1768491 | 1768491 | 2021-09-30 | Clinton | Illinois | 17027 | 6883 | 109 |
1768492 | 1768492 | 2021-09-30 | Coles | Illinois | 17029 | 7548 | 118 |
1768493 | 1768493 | 2021-09-30 | Cook | Illinois | 17031 | 619576 | 11595 |
1768494 | 1768494 | 2021-09-30 | Crawford | Illinois | 17033 | 3165 | 46 |
1768495 | 1768495 | 2021-09-30 | Cumberland | Illinois | 17035 | 1826 | 38 |
1768496 | 1768496 | 2021-09-30 | De Witt | Illinois | 17039 | 1995 | 37 |
1768497 | 1768497 | 2021-09-30 | DeKalb | Illinois | 17037 | 12113 | 138 |
1768498 | 1768498 | 2021-09-30 | Douglas | Illinois | 17041 | 3124 | 42 |
1768499 | 1768499 | 2021-09-30 | DuPage | Illinois | 17043 | 105071 | 1449 |
1768500 | 1768500 | 2021-09-30 | Edgar | Illinois | 17045 | 2416 | 65 |
1768501 | 1768501 | 2021-09-30 | Edwards | Illinois | 17047 | 996 | 17 |
1768502 | 1768502 | 2021-09-30 | Effingham | Illinois | 17049 | 6309 | 96 |
1768503 | 1768503 | 2021-09-30 | Fayette | Illinois | 17051 | 4143 | 62 |
1768504 | 1768504 | 2021-09-30 | Ford | Illinois | 17053 | 2370 | 66 |
1768505 | 1768505 | 2021-09-30 | Franklin | Illinois | 17055 | 7059 | 114 |
1768506 | 1768506 | 2021-09-30 | Fulton | Illinois | 17057 | 4984 | 78 |
1768507 | 1768507 | 2021-09-30 | Gallatin | Illinois | 17059 | 771 | 8 |
1768508 | 1768508 | 2021-09-30 | Greene | Illinois | 17061 | 2018 | 52 |
1768509 | 1768509 | 2021-09-30 | Grundy | Illinois | 17063 | 7129 | 86 |
1768510 | 1768510 | 2021-09-30 | Hamilton | Illinois | 17065 | 1307 | 24 |
1768511 | 1768511 | 2021-09-30 | Hancock | Illinois | 17067 | 2640 | 44 |
1768512 | 1768512 | 2021-09-30 | Hardin | Illinois | 17069 | 567 | 15 |
1768513 | 1768513 | 2021-09-30 | Henderson | Illinois | 17071 | 680 | 23 |
1768514 | 1768514 | 2021-09-30 | Henry | Illinois | 17073 | 6359 | 105 |
1768515 | 1768515 | 2021-09-30 | Iroquois | Illinois | 17075 | 4060 | 76 |
1768516 | 1768516 | 2021-09-30 | Jackson | Illinois | 17077 | 7848 | 102 |
1768517 | 1768517 | 2021-09-30 | Jasper | Illinois | 17079 | 1559 | 22 |
1768518 | 1768518 | 2021-09-30 | Jefferson | Illinois | 17081 | 6207 | 138 |
1768519 | 1768519 | 2021-09-30 | Jersey | Illinois | 17083 | 3281 | 72 |
1768520 | 1768520 | 2021-09-30 | Jo Daviess | Illinois | 17085 | 2092 | 30 |
1768521 | 1768521 | 2021-09-30 | Johnson | Illinois | 17087 | 2190 | 33 |
1768522 | 1768522 | 2021-09-30 | Kane | Illinois | 17089 | 66595 | 909 |
1768523 | 1768523 | 2021-09-30 | Kankakee | Illinois | 17091 | 17127 | 244 |
1768524 | 1768524 | 2021-09-30 | Kendall | Illinois | 17093 | 16484 | 116 |
1768525 | 1768525 | 2021-09-30 | Knox | Illinois | 17095 | 6869 | 198 |
1768526 | 1768526 | 2021-09-30 | LaSalle | Illinois | 17099 | 14660 | 336 |
1768527 | 1768527 | 2021-09-30 | Lake | Illinois | 17097 | 78007 | 1137 |
1768528 | 1768528 | 2021-09-30 | Lawrence | Illinois | 17101 | 3137 | 41 |
1768529 | 1768529 | 2021-09-30 | Lee | Illinois | 17103 | 4645 | 99 |
1768530 | 1768530 | 2021-09-30 | Livingston | Illinois | 17105 | 5781 | 108 |
1768531 | 1768531 | 2021-09-30 | Logan | Illinois | 17107 | 4818 | 87 |
1768532 | 1768532 | 2021-09-30 | Macon | Illinois | 17115 | 14766 | 258 |
1768533 | 1768533 | 2021-09-30 | Macoupin | Illinois | 17117 | 6651 | 131 |
1768534 | 1768534 | 2021-09-30 | Madison | Illinois | 17119 | 38863 | 654 |
1768535 | 1768535 | 2021-09-30 | Marion | Illinois | 17121 | 6663 | 144 |
1768536 | 1768536 | 2021-09-30 | Marshall | Illinois | 17123 | 1366 | 23 |
1768537 | 1768537 | 2021-09-30 | Mason | Illinois | 17125 | 2043 | 52 |
1768538 | 1768538 | 2021-09-30 | Massac | Illinois | 17127 | 2043 | 48 |
1768539 | 1768539 | 2021-09-30 | McDonough | Illinois | 17109 | 3619 | 69 |
1768540 | 1768540 | 2021-09-30 | McHenry | Illinois | 17111 | 33528 | 345 |
1768541 | 1768541 | 2021-09-30 | McLean | Illinois | 17113 | 22287 | 248 |
1768542 | 1768542 | 2021-09-30 | Menard | Illinois | 17129 | 1649 | 17 |
1768543 | 1768543 | 2021-09-30 | Mercer | Illinois | 17131 | 1958 | 34 |
1768544 | 1768544 | 2021-09-30 | Monroe | Illinois | 17133 | 5145 | 99 |
1768545 | 1768545 | 2021-09-30 | Montgomery | Illinois | 17135 | 4754 | 83 |
1768546 | 1768546 | 2021-09-30 | Morgan | Illinois | 17137 | 5097 | 118 |
1768547 | 1768547 | 2021-09-30 | Moultrie | Illinois | 17139 | 2160 | 39 |
1768548 | 1768548 | 2021-09-30 | Ogle | Illinois | 17141 | 7268 | 95 |
1768549 | 1768549 | 2021-09-30 | Peoria | Illinois | 17143 | 26407 | 394 |
1768550 | 1768550 | 2021-09-30 | Perry | Illinois | 17145 | 4211 | 81 |
1768551 | 1768551 | 2021-09-30 | Piatt | Illinois | 17147 | 1949 | 20 |
1768552 | 1768552 | 2021-09-30 | Pike | Illinois | 17149 | 2594 | 59 |
1768553 | 1768553 | 2021-09-30 | Pope | Illinois | 17151 | 515 | 5 |
1768554 | 1768554 | 2021-09-30 | Pulaski | Illinois | 17153 | 1007 | 11 |
1768555 | 1768555 | 2021-09-30 | Putnam | Illinois | 17155 | 550 | 5 |
1768556 | 1768556 | 2021-09-30 | Randolph | Illinois | 17157 | 5405 | 103 |
1768557 | 1768557 | 2021-09-30 | Richland | Illinois | 17159 | 2706 | 65 |
1768558 | 1768558 | 2021-09-30 | Rock Island | Illinois | 17161 | 18093 | 394 |
1768559 | 1768559 | 2021-09-30 | Saline | Illinois | 17165 | 4207 | 84 |
1768560 | 1768560 | 2021-09-30 | Sangamon | Illinois | 17167 | 25019 | 321 |
1768561 | 1768561 | 2021-09-30 | Schuyler | Illinois | 17169 | 997 | 22 |
1768562 | 1768562 | 2021-09-30 | Scott | Illinois | 17171 | 701 | 5 |
1768563 | 1768563 | 2021-09-30 | Shelby | Illinois | 17173 | 3260 | 46 |
1768564 | 1768564 | 2021-09-30 | St. Clair | Illinois | 17163 | 39294 | 621 |
1768565 | 1768565 | 2021-09-30 | Stark | Illinois | 17175 | 781 | 27 |
1768566 | 1768566 | 2021-09-30 | Stephenson | Illinois | 17177 | 5587 | 110 |
1768567 | 1768567 | 2021-09-30 | Tazewell | Illinois | 17179 | 20045 | 360 |
1768568 | 1768568 | 2021-09-30 | Union | Illinois | 17181 | 2990 | 51 |
1768569 | 1768569 | 2021-09-30 | Unknown | Illinois | 0 | 663 | |
1768570 | 1768570 | 2021-09-30 | Vermilion | Illinois | 17183 | 13591 | 209 |
1768571 | 1768571 | 2021-09-30 | Wabash | Illinois | 17185 | 2083 | 21 |
1768572 | 1768572 | 2021-09-30 | Warren | Illinois | 17187 | 2318 | 66 |
1768573 | 1768573 | 2021-09-30 | Washington | Illinois | 17189 | 2082 | 34 |
1768574 | 1768574 | 2021-09-30 | Wayne | Illinois | 17191 | 2839 | 58 |
1768575 | 1768575 | 2021-09-30 | White | Illinois | 17193 | 2718 | 42 |
1768576 | 1768576 | 2021-09-30 | Whiteside | Illinois | 17195 | 8171 | 218 |
1768577 | 1768577 | 2021-09-30 | Will | Illinois | 17197 | 88467 | 1174 |
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);