ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-09-02" 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 |
---|---|---|---|---|---|---|---|
1677511 | 1677511 | 2021-09-02 | Adams | Illinois | 17001 | 11811 | 170 |
1677512 | 1677512 | 2021-09-02 | Alexander | Illinois | 17003 | 619 | 11 |
1677513 | 1677513 | 2021-09-02 | Bond | Illinois | 17005 | 2327 | 29 |
1677514 | 1677514 | 2021-09-02 | Boone | Illinois | 17007 | 7317 | 93 |
1677515 | 1677515 | 2021-09-02 | Brown | Illinois | 17009 | 990 | 13 |
1677516 | 1677516 | 2021-09-02 | Bureau | Illinois | 17011 | 4096 | 99 |
1677517 | 1677517 | 2021-09-02 | Calhoun | Illinois | 17013 | 607 | 5 |
1677518 | 1677518 | 2021-09-02 | Carroll | Illinois | 17015 | 2158 | 38 |
1677519 | 1677519 | 2021-09-02 | Cass | Illinois | 17017 | 2323 | 36 |
1677520 | 1677520 | 2021-09-02 | Champaign | Illinois | 17019 | 24436 | 182 |
1677521 | 1677521 | 2021-09-02 | Christian | Illinois | 17021 | 4467 | 96 |
1677522 | 1677522 | 2021-09-02 | Clark | Illinois | 17023 | 2210 | 44 |
1677523 | 1677523 | 2021-09-02 | Clay | Illinois | 17025 | 2059 | 49 |
1677524 | 1677524 | 2021-09-02 | Clinton | Illinois | 17027 | 6545 | 103 |
1677525 | 1677525 | 2021-09-02 | Coles | Illinois | 17029 | 6678 | 106 |
1677526 | 1677526 | 2021-09-02 | Cook | Illinois | 17031 | 594250 | 11342 |
1677527 | 1677527 | 2021-09-02 | Crawford | Illinois | 17033 | 2774 | 44 |
1677528 | 1677528 | 2021-09-02 | Cumberland | Illinois | 17035 | 1548 | 33 |
1677529 | 1677529 | 2021-09-02 | De Witt | Illinois | 17039 | 1818 | 37 |
1677530 | 1677530 | 2021-09-02 | DeKalb | Illinois | 17037 | 11301 | 129 |
1677531 | 1677531 | 2021-09-02 | Douglas | Illinois | 17041 | 2880 | 42 |
1677532 | 1677532 | 2021-09-02 | DuPage | Illinois | 17043 | 100120 | 1426 |
1677533 | 1677533 | 2021-09-02 | Edgar | Illinois | 17045 | 2073 | 62 |
1677534 | 1677534 | 2021-09-02 | Edwards | Illinois | 17047 | 859 | 14 |
1677535 | 1677535 | 2021-09-02 | Effingham | Illinois | 17049 | 5313 | 88 |
1677536 | 1677536 | 2021-09-02 | Fayette | Illinois | 17051 | 3590 | 59 |
1677537 | 1677537 | 2021-09-02 | Ford | Illinois | 17053 | 2209 | 61 |
1677538 | 1677538 | 2021-09-02 | Franklin | Illinois | 17055 | 6145 | 97 |
1677539 | 1677539 | 2021-09-02 | Fulton | Illinois | 17057 | 4535 | 72 |
1677540 | 1677540 | 2021-09-02 | Gallatin | Illinois | 17059 | 661 | 5 |
1677541 | 1677541 | 2021-09-02 | Greene | Illinois | 17061 | 1865 | 49 |
1677542 | 1677542 | 2021-09-02 | Grundy | Illinois | 17063 | 6623 | 84 |
1677543 | 1677543 | 2021-09-02 | Hamilton | Illinois | 17065 | 1121 | 21 |
1677544 | 1677544 | 2021-09-02 | Hancock | Illinois | 17067 | 2319 | 44 |
1677545 | 1677545 | 2021-09-02 | Hardin | Illinois | 17069 | 523 | 12 |
1677546 | 1677546 | 2021-09-02 | Henderson | Illinois | 17071 | 595 | 23 |
1677547 | 1677547 | 2021-09-02 | Henry | Illinois | 17073 | 5695 | 100 |
1677548 | 1677548 | 2021-09-02 | Iroquois | Illinois | 17075 | 3673 | 71 |
1677549 | 1677549 | 2021-09-02 | Jackson | Illinois | 17077 | 6930 | 84 |
1677550 | 1677550 | 2021-09-02 | Jasper | Illinois | 17079 | 1359 | 20 |
1677551 | 1677551 | 2021-09-02 | Jefferson | Illinois | 17081 | 5555 | 129 |
1677552 | 1677552 | 2021-09-02 | Jersey | Illinois | 17083 | 3088 | 71 |
1677553 | 1677553 | 2021-09-02 | Jo Daviess | Illinois | 17085 | 1955 | 27 |
1677554 | 1677554 | 2021-09-02 | Johnson | Illinois | 17087 | 1955 | 26 |
1677555 | 1677555 | 2021-09-02 | Kane | Illinois | 17089 | 63706 | 881 |
1677556 | 1677556 | 2021-09-02 | Kankakee | Illinois | 17091 | 15788 | 236 |
1677557 | 1677557 | 2021-09-02 | Kendall | Illinois | 17093 | 15100 | 112 |
1677558 | 1677558 | 2021-09-02 | Knox | Illinois | 17095 | 6176 | 189 |
1677559 | 1677559 | 2021-09-02 | LaSalle | Illinois | 17099 | 13812 | 322 |
1677560 | 1677560 | 2021-09-02 | Lake | Illinois | 17097 | 74077 | 1114 |
1677561 | 1677561 | 2021-09-02 | Lawrence | Illinois | 17101 | 2754 | 38 |
1677562 | 1677562 | 2021-09-02 | Lee | Illinois | 17103 | 4410 | 95 |
1677563 | 1677563 | 2021-09-02 | Livingston | Illinois | 17105 | 5314 | 106 |
1677564 | 1677564 | 2021-09-02 | Logan | Illinois | 17107 | 4586 | 81 |
1677565 | 1677565 | 2021-09-02 | Macon | Illinois | 17115 | 13075 | 231 |
1677566 | 1677566 | 2021-09-02 | Macoupin | Illinois | 17117 | 5857 | 122 |
1677567 | 1677567 | 2021-09-02 | Madison | Illinois | 17119 | 36182 | 632 |
1677568 | 1677568 | 2021-09-02 | Marion | Illinois | 17121 | 5972 | 137 |
1677569 | 1677569 | 2021-09-02 | Marshall | Illinois | 17123 | 1260 | 21 |
1677570 | 1677570 | 2021-09-02 | Mason | Illinois | 17125 | 1874 | 50 |
1677571 | 1677571 | 2021-09-02 | Massac | Illinois | 17127 | 1771 | 45 |
1677572 | 1677572 | 2021-09-02 | McDonough | Illinois | 17109 | 3393 | 65 |
1677573 | 1677573 | 2021-09-02 | McHenry | Illinois | 17111 | 31715 | 330 |
1677574 | 1677574 | 2021-09-02 | McLean | Illinois | 17113 | 20719 | 236 |
1677575 | 1677575 | 2021-09-02 | Menard | Illinois | 17129 | 1465 | 16 |
1677576 | 1677576 | 2021-09-02 | Mercer | Illinois | 17131 | 1756 | 34 |
1677577 | 1677577 | 2021-09-02 | Monroe | Illinois | 17133 | 4887 | 96 |
1677578 | 1677578 | 2021-09-02 | Montgomery | Illinois | 17135 | 4331 | 81 |
1677579 | 1677579 | 2021-09-02 | Morgan | Illinois | 17137 | 4778 | 117 |
1677580 | 1677580 | 2021-09-02 | Moultrie | Illinois | 17139 | 1912 | 37 |
1677581 | 1677581 | 2021-09-02 | Ogle | Illinois | 17141 | 6713 | 92 |
1677582 | 1677582 | 2021-09-02 | Peoria | Illinois | 17143 | 25087 | 384 |
1677583 | 1677583 | 2021-09-02 | Perry | Illinois | 17145 | 3869 | 78 |
1677584 | 1677584 | 2021-09-02 | Piatt | Illinois | 17147 | 1791 | 20 |
1677585 | 1677585 | 2021-09-02 | Pike | Illinois | 17149 | 2402 | 58 |
1677586 | 1677586 | 2021-09-02 | Pope | Illinois | 17151 | 423 | 4 |
1677587 | 1677587 | 2021-09-02 | Pulaski | Illinois | 17153 | 931 | 11 |
1677588 | 1677588 | 2021-09-02 | Putnam | Illinois | 17155 | 523 | 5 |
1677589 | 1677589 | 2021-09-02 | Randolph | Illinois | 17157 | 4989 | 97 |
1677590 | 1677590 | 2021-09-02 | Richland | Illinois | 17159 | 2270 | 58 |
1677591 | 1677591 | 2021-09-02 | Rock Island | Illinois | 17161 | 16858 | 377 |
1677592 | 1677592 | 2021-09-02 | Saline | Illinois | 17165 | 3491 | 76 |
1677593 | 1677593 | 2021-09-02 | Sangamon | Illinois | 17167 | 22905 | 294 |
1677594 | 1677594 | 2021-09-02 | Schuyler | Illinois | 17169 | 917 | 19 |
1677595 | 1677595 | 2021-09-02 | Scott | Illinois | 17171 | 664 | 2 |
1677596 | 1677596 | 2021-09-02 | Shelby | Illinois | 17173 | 2695 | 43 |
1677597 | 1677597 | 2021-09-02 | St. Clair | Illinois | 17163 | 37266 | 593 |
1677598 | 1677598 | 2021-09-02 | Stark | Illinois | 17175 | 730 | 26 |
1677599 | 1677599 | 2021-09-02 | Stephenson | Illinois | 17177 | 5169 | 106 |
1677600 | 1677600 | 2021-09-02 | Tazewell | Illinois | 17179 | 18914 | 351 |
1677601 | 1677601 | 2021-09-02 | Union | Illinois | 17181 | 2827 | 46 |
1677602 | 1677602 | 2021-09-02 | Unknown | Illinois | 0 | 514 | |
1677603 | 1677603 | 2021-09-02 | Vermilion | Illinois | 17183 | 12067 | 182 |
1677604 | 1677604 | 2021-09-02 | Wabash | Illinois | 17185 | 1825 | 16 |
1677605 | 1677605 | 2021-09-02 | Warren | Illinois | 17187 | 2039 | 54 |
1677606 | 1677606 | 2021-09-02 | Washington | Illinois | 17189 | 1940 | 32 |
1677607 | 1677607 | 2021-09-02 | Wayne | Illinois | 17191 | 2398 | 55 |
1677608 | 1677608 | 2021-09-02 | White | Illinois | 17193 | 2290 | 37 |
1677609 | 1677609 | 2021-09-02 | Whiteside | Illinois | 17195 | 7678 | 216 |
1677610 | 1677610 | 2021-09-02 | Will | Illinois | 17197 | 83855 | 1140 |
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);