ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2022-02-06" 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 |
---|---|---|---|---|---|---|---|
2187806 | 2187806 | 2022-02-06 | Adams | Illinois | 17001 | 21483 | 220 |
2187807 | 2187807 | 2022-02-06 | Alexander | Illinois | 17003 | 1240 | 13 |
2187808 | 2187808 | 2022-02-06 | Bond | Illinois | 17005 | 4196 | 34 |
2187809 | 2187809 | 2022-02-06 | Boone | Illinois | 17007 | 13306 | 115 |
2187810 | 2187810 | 2022-02-06 | Brown | Illinois | 17009 | 2319 | 19 |
2187811 | 2187811 | 2022-02-06 | Bureau | Illinois | 17011 | 8035 | 135 |
2187812 | 2187812 | 2022-02-06 | Calhoun | Illinois | 17013 | 1490 | 8 |
2187813 | 2187813 | 2022-02-06 | Carroll | Illinois | 17015 | 4018 | 46 |
2187814 | 2187814 | 2022-02-06 | Cass | Illinois | 17017 | 4488 | 43 |
2187815 | 2187815 | 2022-02-06 | Champaign | Illinois | 17019 | 59383 | 273 |
2187816 | 2187816 | 2022-02-06 | Christian | Illinois | 17021 | 9642 | 122 |
2187817 | 2187817 | 2022-02-06 | Clark | Illinois | 17023 | 4616 | 55 |
2187818 | 2187818 | 2022-02-06 | Clay | Illinois | 17025 | 4557 | 68 |
2187819 | 2187819 | 2022-02-06 | Clinton | Illinois | 17027 | 11515 | 119 |
2187820 | 2187820 | 2022-02-06 | Coles | Illinois | 17029 | 14701 | 159 |
2187821 | 2187821 | 2022-02-06 | Cook | Illinois | 17031 | 1089942 | 14052 |
2187822 | 2187822 | 2022-02-06 | Crawford | Illinois | 17033 | 5930 | 55 |
2187823 | 2187823 | 2022-02-06 | Cumberland | Illinois | 17035 | 3255 | 49 |
2187824 | 2187824 | 2022-02-06 | De Witt | Illinois | 17039 | 4210 | 40 |
2187825 | 2187825 | 2022-02-06 | DeKalb | Illinois | 17037 | 22328 | 188 |
2187826 | 2187826 | 2022-02-06 | Douglas | Illinois | 17041 | 6290 | 56 |
2187827 | 2187827 | 2022-02-06 | DuPage | Illinois | 17043 | 200020 | 1696 |
2187828 | 2187828 | 2022-02-06 | Edgar | Illinois | 17045 | 4955 | 76 |
2187829 | 2187829 | 2022-02-06 | Edwards | Illinois | 17047 | 1732 | 26 |
2187830 | 2187830 | 2022-02-06 | Effingham | Illinois | 17049 | 10337 | 137 |
2187831 | 2187831 | 2022-02-06 | Fayette | Illinois | 17051 | 6896 | 93 |
2187832 | 2187832 | 2022-02-06 | Ford | Illinois | 17053 | 4284 | 70 |
2187833 | 2187833 | 2022-02-06 | Franklin | Illinois | 17055 | 11827 | 163 |
2187834 | 2187834 | 2022-02-06 | Fulton | Illinois | 17057 | 9620 | 120 |
2187835 | 2187835 | 2022-02-06 | Gallatin | Illinois | 17059 | 1302 | 13 |
2187836 | 2187836 | 2022-02-06 | Greene | Illinois | 17061 | 3504 | 55 |
2187837 | 2187837 | 2022-02-06 | Grundy | Illinois | 17063 | 12269 | 130 |
2187838 | 2187838 | 2022-02-06 | Hamilton | Illinois | 17065 | 2097 | 31 |
2187839 | 2187839 | 2022-02-06 | Hancock | Illinois | 17067 | 4185 | 53 |
2187840 | 2187840 | 2022-02-06 | Hardin | Illinois | 17069 | 1017 | 18 |
2187841 | 2187841 | 2022-02-06 | Henderson | Illinois | 17071 | 1107 | 26 |
2187842 | 2187842 | 2022-02-06 | Henry | Illinois | 17073 | 12129 | 139 |
2187843 | 2187843 | 2022-02-06 | Iroquois | Illinois | 17075 | 6934 | 107 |
2187844 | 2187844 | 2022-02-06 | Jackson | Illinois | 17077 | 14839 | 120 |
2187845 | 2187845 | 2022-02-06 | Jasper | Illinois | 17079 | 2597 | 26 |
2187846 | 2187846 | 2022-02-06 | Jefferson | Illinois | 17081 | 10560 | 163 |
2187847 | 2187847 | 2022-02-06 | Jersey | Illinois | 17083 | 6057 | 83 |
2187848 | 2187848 | 2022-02-06 | Jo Daviess | Illinois | 17085 | 3824 | 36 |
2187849 | 2187849 | 2022-02-06 | Johnson | Illinois | 17087 | 4073 | 44 |
2187850 | 2187850 | 2022-02-06 | Kane | Illinois | 17089 | 121407 | 1102 |
2187851 | 2187851 | 2022-02-06 | Kankakee | Illinois | 17091 | 28055 | 353 |
2187852 | 2187852 | 2022-02-06 | Kendall | Illinois | 17093 | 29474 | 153 |
2187853 | 2187853 | 2022-02-06 | Knox | Illinois | 17095 | 12099 | 230 |
2187854 | 2187854 | 2022-02-06 | LaSalle | Illinois | 17099 | 27740 | 418 |
2187855 | 2187855 | 2022-02-06 | Lake | Illinois | 17097 | 142547 | 1322 |
2187856 | 2187856 | 2022-02-06 | Lawrence | Illinois | 17101 | 5292 | 49 |
2187857 | 2187857 | 2022-02-06 | Lee | Illinois | 17103 | 8383 | 114 |
2187858 | 2187858 | 2022-02-06 | Livingston | Illinois | 17105 | 10328 | 139 |
2187859 | 2187859 | 2022-02-06 | Logan | Illinois | 17107 | 9121 | 96 |
2187860 | 2187860 | 2022-02-06 | Macon | Illinois | 17115 | 29501 | 327 |
2187861 | 2187861 | 2022-02-06 | Macoupin | Illinois | 17117 | 12314 | 158 |
2187862 | 2187862 | 2022-02-06 | Madison | Illinois | 17119 | 68023 | 805 |
2187863 | 2187863 | 2022-02-06 | Marion | Illinois | 17121 | 11430 | 198 |
2187864 | 2187864 | 2022-02-06 | Marshall | Illinois | 17123 | 2654 | 31 |
2187865 | 2187865 | 2022-02-06 | Mason | Illinois | 17125 | 3783 | 60 |
2187866 | 2187866 | 2022-02-06 | Massac | Illinois | 17127 | 3668 | 67 |
2187867 | 2187867 | 2022-02-06 | McDonough | Illinois | 17109 | 6795 | 92 |
2187868 | 2187868 | 2022-02-06 | McHenry | Illinois | 17111 | 72604 | 456 |
2187869 | 2187869 | 2022-02-06 | McLean | Illinois | 17113 | 47442 | 309 |
2187870 | 2187870 | 2022-02-06 | Menard | Illinois | 17129 | 3395 | 22 |
2187871 | 2187871 | 2022-02-06 | Mercer | Illinois | 17131 | 3849 | 41 |
2187872 | 2187872 | 2022-02-06 | Monroe | Illinois | 17133 | 9178 | 121 |
2187873 | 2187873 | 2022-02-06 | Montgomery | Illinois | 17135 | 9315 | 100 |
2187874 | 2187874 | 2022-02-06 | Morgan | Illinois | 17137 | 9072 | 133 |
2187875 | 2187875 | 2022-02-06 | Moultrie | Illinois | 17139 | 3947 | 50 |
2187876 | 2187876 | 2022-02-06 | Ogle | Illinois | 17141 | 13403 | 134 |
2187877 | 2187877 | 2022-02-06 | Peoria | Illinois | 17143 | 44879 | 532 |
2187878 | 2187878 | 2022-02-06 | Perry | Illinois | 17145 | 7072 | 100 |
2187879 | 2187879 | 2022-02-06 | Piatt | Illinois | 17147 | 4202 | 27 |
2187880 | 2187880 | 2022-02-06 | Pike | Illinois | 17149 | 4874 | 66 |
2187881 | 2187881 | 2022-02-06 | Pope | Illinois | 17151 | 925 | 7 |
2187882 | 2187882 | 2022-02-06 | Pulaski | Illinois | 17153 | 1667 | 16 |
2187883 | 2187883 | 2022-02-06 | Putnam | Illinois | 17155 | 1097 | 8 |
2187884 | 2187884 | 2022-02-06 | Randolph | Illinois | 17157 | 10013 | 121 |
2187885 | 2187885 | 2022-02-06 | Richland | Illinois | 17159 | 5031 | 80 |
2187886 | 2187886 | 2022-02-06 | Rock Island | Illinois | 17161 | 31908 | 492 |
2187887 | 2187887 | 2022-02-06 | Saline | Illinois | 17165 | 7425 | 100 |
2187888 | 2187888 | 2022-02-06 | Sangamon | Illinois | 17167 | 52699 | 390 |
2187889 | 2187889 | 2022-02-06 | Schuyler | Illinois | 17169 | 1907 | 29 |
2187890 | 2187890 | 2022-02-06 | Scott | Illinois | 17171 | 1233 | 11 |
2187891 | 2187891 | 2022-02-06 | Shelby | Illinois | 17173 | 5949 | 67 |
2187892 | 2187892 | 2022-02-06 | St. Clair | Illinois | 17163 | 66836 | 737 |
2187893 | 2187893 | 2022-02-06 | Stark | Illinois | 17175 | 1447 | 31 |
2187894 | 2187894 | 2022-02-06 | Stephenson | Illinois | 17177 | 11025 | 170 |
2187895 | 2187895 | 2022-02-06 | Tazewell | Illinois | 17179 | 35358 | 471 |
2187896 | 2187896 | 2022-02-06 | Union | Illinois | 17181 | 5149 | 65 |
2187897 | 2187897 | 2022-02-06 | Unknown | Illinois | 0 | 1814 | |
2187898 | 2187898 | 2022-02-06 | Vermilion | Illinois | 17183 | 27151 | 287 |
2187899 | 2187899 | 2022-02-06 | Wabash | Illinois | 17185 | 3624 | 24 |
2187900 | 2187900 | 2022-02-06 | Warren | Illinois | 17187 | 3859 | 82 |
2187901 | 2187901 | 2022-02-06 | Washington | Illinois | 17189 | 3329 | 39 |
2187902 | 2187902 | 2022-02-06 | Wayne | Illinois | 17191 | 5074 | 75 |
2187903 | 2187903 | 2022-02-06 | White | Illinois | 17193 | 4217 | 50 |
2187904 | 2187904 | 2022-02-06 | Whiteside | Illinois | 17195 | 14619 | 257 |
2187905 | 2187905 | 2022-02-06 | Will | Illinois | 17197 | 156637 | 1482 |
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);