ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2021-08-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 |
---|---|---|---|---|---|---|---|
1667768 | 1667768 | 2021-08-30 | Adams | Illinois | 17001 | 11539 | 167 |
1667769 | 1667769 | 2021-08-30 | Alexander | Illinois | 17003 | 600 | 11 |
1667770 | 1667770 | 2021-08-30 | Bond | Illinois | 17005 | 2303 | 29 |
1667771 | 1667771 | 2021-08-30 | Boone | Illinois | 17007 | 7272 | 93 |
1667772 | 1667772 | 2021-08-30 | Brown | Illinois | 17009 | 977 | 13 |
1667773 | 1667773 | 2021-08-30 | Bureau | Illinois | 17011 | 4046 | 99 |
1667774 | 1667774 | 2021-08-30 | Calhoun | Illinois | 17013 | 592 | 5 |
1667775 | 1667775 | 2021-08-30 | Carroll | Illinois | 17015 | 2132 | 38 |
1667776 | 1667776 | 2021-08-30 | Cass | Illinois | 17017 | 2286 | 36 |
1667777 | 1667777 | 2021-08-30 | Champaign | Illinois | 17019 | 24037 | 180 |
1667778 | 1667778 | 2021-08-30 | Christian | Illinois | 17021 | 4382 | 96 |
1667779 | 1667779 | 2021-08-30 | Clark | Illinois | 17023 | 2169 | 44 |
1667780 | 1667780 | 2021-08-30 | Clay | Illinois | 17025 | 1979 | 49 |
1667781 | 1667781 | 2021-08-30 | Clinton | Illinois | 17027 | 6470 | 103 |
1667782 | 1667782 | 2021-08-30 | Coles | Illinois | 17029 | 6537 | 106 |
1667783 | 1667783 | 2021-08-30 | Cook | Illinois | 17031 | 590825 | 11294 |
1667784 | 1667784 | 2021-08-30 | Crawford | Illinois | 17033 | 2722 | 43 |
1667785 | 1667785 | 2021-08-30 | Cumberland | Illinois | 17035 | 1460 | 33 |
1667786 | 1667786 | 2021-08-30 | De Witt | Illinois | 17039 | 1784 | 37 |
1667787 | 1667787 | 2021-08-30 | DeKalb | Illinois | 17037 | 11189 | 129 |
1667788 | 1667788 | 2021-08-30 | Douglas | Illinois | 17041 | 2850 | 42 |
1667789 | 1667789 | 2021-08-30 | DuPage | Illinois | 17043 | 99315 | 1421 |
1667790 | 1667790 | 2021-08-30 | Edgar | Illinois | 17045 | 1988 | 62 |
1667791 | 1667791 | 2021-08-30 | Edwards | Illinois | 17047 | 833 | 14 |
1667792 | 1667792 | 2021-08-30 | Effingham | Illinois | 17049 | 5190 | 88 |
1667793 | 1667793 | 2021-08-30 | Fayette | Illinois | 17051 | 3504 | 59 |
1667794 | 1667794 | 2021-08-30 | Ford | Illinois | 17053 | 2151 | 60 |
1667795 | 1667795 | 2021-08-30 | Franklin | Illinois | 17055 | 5997 | 97 |
1667796 | 1667796 | 2021-08-30 | Fulton | Illinois | 17057 | 4482 | 70 |
1667797 | 1667797 | 2021-08-30 | Gallatin | Illinois | 17059 | 650 | 5 |
1667798 | 1667798 | 2021-08-30 | Greene | Illinois | 17061 | 1828 | 49 |
1667799 | 1667799 | 2021-08-30 | Grundy | Illinois | 17063 | 6566 | 84 |
1667800 | 1667800 | 2021-08-30 | Hamilton | Illinois | 17065 | 1073 | 20 |
1667801 | 1667801 | 2021-08-30 | Hancock | Illinois | 17067 | 2278 | 44 |
1667802 | 1667802 | 2021-08-30 | Hardin | Illinois | 17069 | 508 | 12 |
1667803 | 1667803 | 2021-08-30 | Henderson | Illinois | 17071 | 586 | 23 |
1667804 | 1667804 | 2021-08-30 | Henry | Illinois | 17073 | 5613 | 100 |
1667805 | 1667805 | 2021-08-30 | Iroquois | Illinois | 17075 | 3613 | 71 |
1667806 | 1667806 | 2021-08-30 | Jackson | Illinois | 17077 | 6773 | 82 |
1667807 | 1667807 | 2021-08-30 | Jasper | Illinois | 17079 | 1326 | 20 |
1667808 | 1667808 | 2021-08-30 | Jefferson | Illinois | 17081 | 5410 | 127 |
1667809 | 1667809 | 2021-08-30 | Jersey | Illinois | 17083 | 3056 | 71 |
1667810 | 1667810 | 2021-08-30 | Jo Daviess | Illinois | 17085 | 1941 | 27 |
1667811 | 1667811 | 2021-08-30 | Johnson | Illinois | 17087 | 1905 | 25 |
1667812 | 1667812 | 2021-08-30 | Kane | Illinois | 17089 | 63236 | 880 |
1667813 | 1667813 | 2021-08-30 | Kankakee | Illinois | 17091 | 15635 | 235 |
1667814 | 1667814 | 2021-08-30 | Kendall | Illinois | 17093 | 14851 | 112 |
1667815 | 1667815 | 2021-08-30 | Knox | Illinois | 17095 | 6129 | 188 |
1667816 | 1667816 | 2021-08-30 | LaSalle | Illinois | 17099 | 13690 | 320 |
1667817 | 1667817 | 2021-08-30 | Lake | Illinois | 17097 | 73464 | 1110 |
1667818 | 1667818 | 2021-08-30 | Lawrence | Illinois | 17101 | 2706 | 38 |
1667819 | 1667819 | 2021-08-30 | Lee | Illinois | 17103 | 4373 | 95 |
1667820 | 1667820 | 2021-08-30 | Livingston | Illinois | 17105 | 5249 | 106 |
1667821 | 1667821 | 2021-08-30 | Logan | Illinois | 17107 | 4538 | 81 |
1667822 | 1667822 | 2021-08-30 | Macon | Illinois | 17115 | 12799 | 231 |
1667823 | 1667823 | 2021-08-30 | Macoupin | Illinois | 17117 | 5713 | 122 |
1667824 | 1667824 | 2021-08-30 | Madison | Illinois | 17119 | 35834 | 626 |
1667825 | 1667825 | 2021-08-30 | Marion | Illinois | 17121 | 5833 | 137 |
1667826 | 1667826 | 2021-08-30 | Marshall | Illinois | 17123 | 1243 | 21 |
1667827 | 1667827 | 2021-08-30 | Mason | Illinois | 17125 | 1838 | 50 |
1667828 | 1667828 | 2021-08-30 | Massac | Illinois | 17127 | 1717 | 45 |
1667829 | 1667829 | 2021-08-30 | McDonough | Illinois | 17109 | 3373 | 65 |
1667830 | 1667830 | 2021-08-30 | McHenry | Illinois | 17111 | 31493 | 329 |
1667831 | 1667831 | 2021-08-30 | McLean | Illinois | 17113 | 20507 | 234 |
1667832 | 1667832 | 2021-08-30 | Menard | Illinois | 17129 | 1445 | 16 |
1667833 | 1667833 | 2021-08-30 | Mercer | Illinois | 17131 | 1711 | 34 |
1667834 | 1667834 | 2021-08-30 | Monroe | Illinois | 17133 | 4867 | 96 |
1667835 | 1667835 | 2021-08-30 | Montgomery | Illinois | 17135 | 4235 | 80 |
1667836 | 1667836 | 2021-08-30 | Morgan | Illinois | 17137 | 4724 | 117 |
1667837 | 1667837 | 2021-08-30 | Moultrie | Illinois | 17139 | 1858 | 37 |
1667838 | 1667838 | 2021-08-30 | Ogle | Illinois | 17141 | 6641 | 92 |
1667839 | 1667839 | 2021-08-30 | Peoria | Illinois | 17143 | 24909 | 382 |
1667840 | 1667840 | 2021-08-30 | Perry | Illinois | 17145 | 3814 | 76 |
1667841 | 1667841 | 2021-08-30 | Piatt | Illinois | 17147 | 1745 | 20 |
1667842 | 1667842 | 2021-08-30 | Pike | Illinois | 17149 | 2365 | 57 |
1667843 | 1667843 | 2021-08-30 | Pope | Illinois | 17151 | 409 | 4 |
1667844 | 1667844 | 2021-08-30 | Pulaski | Illinois | 17153 | 892 | 11 |
1667845 | 1667845 | 2021-08-30 | Putnam | Illinois | 17155 | 519 | 5 |
1667846 | 1667846 | 2021-08-30 | Randolph | Illinois | 17157 | 4945 | 97 |
1667847 | 1667847 | 2021-08-30 | Richland | Illinois | 17159 | 2183 | 58 |
1667848 | 1667848 | 2021-08-30 | Rock Island | Illinois | 17161 | 16713 | 375 |
1667849 | 1667849 | 2021-08-30 | Saline | Illinois | 17165 | 3375 | 76 |
1667850 | 1667850 | 2021-08-30 | Sangamon | Illinois | 17167 | 22570 | 293 |
1667851 | 1667851 | 2021-08-30 | Schuyler | Illinois | 17169 | 906 | 19 |
1667852 | 1667852 | 2021-08-30 | Scott | Illinois | 17171 | 655 | 2 |
1667853 | 1667853 | 2021-08-30 | Shelby | Illinois | 17173 | 2636 | 43 |
1667854 | 1667854 | 2021-08-30 | St. Clair | Illinois | 17163 | 36884 | 590 |
1667855 | 1667855 | 2021-08-30 | Stark | Illinois | 17175 | 725 | 26 |
1667856 | 1667856 | 2021-08-30 | Stephenson | Illinois | 17177 | 5116 | 106 |
1667857 | 1667857 | 2021-08-30 | Tazewell | Illinois | 17179 | 18769 | 351 |
1667858 | 1667858 | 2021-08-30 | Union | Illinois | 17181 | 2788 | 46 |
1667859 | 1667859 | 2021-08-30 | Unknown | Illinois | 0 | 518 | |
1667860 | 1667860 | 2021-08-30 | Vermilion | Illinois | 17183 | 11828 | 181 |
1667861 | 1667861 | 2021-08-30 | Wabash | Illinois | 17185 | 1780 | 16 |
1667862 | 1667862 | 2021-08-30 | Warren | Illinois | 17187 | 2005 | 54 |
1667863 | 1667863 | 2021-08-30 | Washington | Illinois | 17189 | 1919 | 32 |
1667864 | 1667864 | 2021-08-30 | Wayne | Illinois | 17191 | 2335 | 55 |
1667865 | 1667865 | 2021-08-30 | White | Illinois | 17193 | 2222 | 37 |
1667866 | 1667866 | 2021-08-30 | Whiteside | Illinois | 17195 | 7628 | 216 |
1667867 | 1667867 | 2021-08-30 | Will | Illinois | 17197 | 83247 | 1137 |
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);