ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where "date" is on date 2020-07-23 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
360832 | 360832 | 2020-07-23 | Adams | Illinois | 17001 | 302 | 1 |
360833 | 360833 | 2020-07-23 | Alexander | Illinois | 17003 | 33 | 0 |
360834 | 360834 | 2020-07-23 | Bond | Illinois | 17005 | 30 | 1 |
360835 | 360835 | 2020-07-23 | Boone | Illinois | 17007 | 669 | 22 |
360836 | 360836 | 2020-07-23 | Brown | Illinois | 17009 | 12 | 0 |
360837 | 360837 | 2020-07-23 | Bureau | Illinois | 17011 | 65 | 2 |
360838 | 360838 | 2020-07-23 | Calhoun | Illinois | 17013 | 4 | 0 |
360839 | 360839 | 2020-07-23 | Carroll | Illinois | 17015 | 27 | 2 |
360840 | 360840 | 2020-07-23 | Cass | Illinois | 17017 | 161 | 11 |
360841 | 360841 | 2020-07-23 | Champaign | Illinois | 17019 | 1318 | 17 |
360842 | 360842 | 2020-07-23 | Christian | Illinois | 17021 | 65 | 5 |
360843 | 360843 | 2020-07-23 | Clark | Illinois | 17023 | 51 | 0 |
360844 | 360844 | 2020-07-23 | Clay | Illinois | 17025 | 9 | 0 |
360845 | 360845 | 2020-07-23 | Clinton | Illinois | 17027 | 288 | 17 |
360846 | 360846 | 2020-07-23 | Coles | Illinois | 17029 | 273 | 17 |
360847 | 360847 | 2020-07-23 | Cook | Illinois | 17031 | 100795 | 4810 |
360848 | 360848 | 2020-07-23 | Crawford | Illinois | 17033 | 28 | 0 |
360849 | 360849 | 2020-07-23 | Cumberland | Illinois | 17035 | 37 | 1 |
360850 | 360850 | 2020-07-23 | De Witt | Illinois | 17039 | 24 | 0 |
360851 | 360851 | 2020-07-23 | DeKalb | Illinois | 17037 | 774 | 24 |
360852 | 360852 | 2020-07-23 | Douglas | Illinois | 17041 | 92 | 1 |
360853 | 360853 | 2020-07-23 | DuPage | Illinois | 17043 | 10627 | 502 |
360854 | 360854 | 2020-07-23 | Edgar | Illinois | 17045 | 20 | 0 |
360855 | 360855 | 2020-07-23 | Edwards | Illinois | 17047 | 6 | 0 |
360856 | 360856 | 2020-07-23 | Effingham | Illinois | 17049 | 51 | 1 |
360857 | 360857 | 2020-07-23 | Fayette | Illinois | 17051 | 40 | 3 |
360858 | 360858 | 2020-07-23 | Ford | Illinois | 17053 | 35 | 1 |
360859 | 360859 | 2020-07-23 | Franklin | Illinois | 17055 | 84 | 0 |
360860 | 360860 | 2020-07-23 | Fulton | Illinois | 17057 | 20 | 0 |
360861 | 360861 | 2020-07-23 | Gallatin | Illinois | 17059 | 26 | 0 |
360862 | 360862 | 2020-07-23 | Greene | Illinois | 17061 | 14 | 0 |
360863 | 360863 | 2020-07-23 | Grundy | Illinois | 17063 | 231 | 5 |
360864 | 360864 | 2020-07-23 | Hamilton | Illinois | 17065 | 11 | 0 |
360865 | 360865 | 2020-07-23 | Hancock | Illinois | 17067 | 22 | 1 |
360866 | 360866 | 2020-07-23 | Hardin | Illinois | 17069 | 9 | 0 |
360867 | 360867 | 2020-07-23 | Henderson | Illinois | 17071 | 8 | 0 |
360868 | 360868 | 2020-07-23 | Henry | Illinois | 17073 | 153 | 1 |
360869 | 360869 | 2020-07-23 | Iroquois | Illinois | 17075 | 202 | 5 |
360870 | 360870 | 2020-07-23 | Jackson | Illinois | 17077 | 450 | 19 |
360871 | 360871 | 2020-07-23 | Jasper | Illinois | 17079 | 49 | 7 |
360872 | 360872 | 2020-07-23 | Jefferson | Illinois | 17081 | 142 | 17 |
360873 | 360873 | 2020-07-23 | Jersey | Illinois | 17083 | 57 | 1 |
360874 | 360874 | 2020-07-23 | Jo Daviess | Illinois | 17085 | 84 | 1 |
360875 | 360875 | 2020-07-23 | Johnson | Illinois | 17087 | 47 | 0 |
360876 | 360876 | 2020-07-23 | Kane | Illinois | 17089 | 8623 | 294 |
360877 | 360877 | 2020-07-23 | Kankakee | Illinois | 17091 | 1641 | 66 |
360878 | 360878 | 2020-07-23 | Kendall | Illinois | 17093 | 1218 | 23 |
360879 | 360879 | 2020-07-23 | Knox | Illinois | 17095 | 199 | 1 |
360880 | 360880 | 2020-07-23 | LaSalle | Illinois | 17099 | 379 | 18 |
360881 | 360881 | 2020-07-23 | Lake | Illinois | 17097 | 11163 | 438 |
360882 | 360882 | 2020-07-23 | Lawrence | Illinois | 17101 | 32 | 0 |
360883 | 360883 | 2020-07-23 | Lee | Illinois | 17103 | 120 | 2 |
360884 | 360884 | 2020-07-23 | Livingston | Illinois | 17105 | 65 | 2 |
360885 | 360885 | 2020-07-23 | Logan | Illinois | 17107 | 59 | 0 |
360886 | 360886 | 2020-07-23 | Macon | Illinois | 17115 | 297 | 22 |
360887 | 360887 | 2020-07-23 | Macoupin | Illinois | 17117 | 101 | 3 |
360888 | 360888 | 2020-07-23 | Madison | Illinois | 17119 | 1655 | 71 |
360889 | 360889 | 2020-07-23 | Marion | Illinois | 17121 | 107 | 0 |
360890 | 360890 | 2020-07-23 | Marshall | Illinois | 17123 | 15 | 0 |
360891 | 360891 | 2020-07-23 | Mason | Illinois | 17125 | 36 | 0 |
360892 | 360892 | 2020-07-23 | Massac | Illinois | 17127 | 26 | 0 |
360893 | 360893 | 2020-07-23 | McDonough | Illinois | 17109 | 119 | 15 |
360894 | 360894 | 2020-07-23 | McHenry | Illinois | 17111 | 2654 | 111 |
360895 | 360895 | 2020-07-23 | McLean | Illinois | 17113 | 432 | 15 |
360896 | 360896 | 2020-07-23 | Menard | Illinois | 17129 | 37 | 0 |
360897 | 360897 | 2020-07-23 | Mercer | Illinois | 17131 | 42 | 0 |
360898 | 360898 | 2020-07-23 | Monroe | Illinois | 17133 | 210 | 13 |
360899 | 360899 | 2020-07-23 | Montgomery | Illinois | 17135 | 115 | 2 |
360900 | 360900 | 2020-07-23 | Morgan | Illinois | 17137 | 148 | 5 |
360901 | 360901 | 2020-07-23 | Moultrie | Illinois | 17139 | 37 | 0 |
360902 | 360902 | 2020-07-23 | Ogle | Illinois | 17141 | 361 | 5 |
360903 | 360903 | 2020-07-23 | Peoria | Illinois | 17143 | 923 | 32 |
360904 | 360904 | 2020-07-23 | Perry | Illinois | 17145 | 80 | 1 |
360905 | 360905 | 2020-07-23 | Piatt | Illinois | 17147 | 30 | 0 |
360906 | 360906 | 2020-07-23 | Pike | Illinois | 17149 | 9 | 0 |
360907 | 360907 | 2020-07-23 | Pope | Illinois | 17151 | 3 | 0 |
360908 | 360908 | 2020-07-23 | Pulaski | Illinois | 17153 | 88 | 0 |
360909 | 360909 | 2020-07-23 | Putnam | Illinois | 17155 | 4 | 0 |
360910 | 360910 | 2020-07-23 | Randolph | Illinois | 17157 | 384 | 7 |
360911 | 360911 | 2020-07-23 | Richland | Illinois | 17159 | 9 | 0 |
360912 | 360912 | 2020-07-23 | Rock Island | Illinois | 17161 | 1429 | 30 |
360913 | 360913 | 2020-07-23 | Saline | Illinois | 17165 | 64 | 0 |
360914 | 360914 | 2020-07-23 | Sangamon | Illinois | 17167 | 761 | 34 |
360915 | 360915 | 2020-07-23 | Schuyler | Illinois | 17169 | 14 | 0 |
360916 | 360916 | 2020-07-23 | Scott | Illinois | 17171 | 6 | 0 |
360917 | 360917 | 2020-07-23 | Shelby | Illinois | 17173 | 32 | 1 |
360918 | 360918 | 2020-07-23 | St. Clair | Illinois | 17163 | 3270 | 152 |
360919 | 360919 | 2020-07-23 | Stark | Illinois | 17175 | 6 | 0 |
360920 | 360920 | 2020-07-23 | Stephenson | Illinois | 17177 | 296 | 6 |
360921 | 360921 | 2020-07-23 | Tazewell | Illinois | 17179 | 251 | 8 |
360922 | 360922 | 2020-07-23 | Union | Illinois | 17181 | 256 | 21 |
360923 | 360923 | 2020-07-23 | Unknown | Illinois | 1175 | 193 | |
360924 | 360924 | 2020-07-23 | Vermilion | Illinois | 17183 | 146 | 2 |
360925 | 360925 | 2020-07-23 | Wabash | Illinois | 17185 | 25 | 0 |
360926 | 360926 | 2020-07-23 | Warren | Illinois | 17187 | 160 | 0 |
360927 | 360927 | 2020-07-23 | Washington | Illinois | 17189 | 40 | 0 |
360928 | 360928 | 2020-07-23 | Wayne | Illinois | 17191 | 27 | 1 |
360929 | 360929 | 2020-07-23 | White | Illinois | 17193 | 34 | 0 |
360930 | 360930 | 2020-07-23 | Whiteside | Illinois | 17195 | 269 | 16 |
360931 | 360931 | 2020-07-23 | Will | Illinois | 17197 | 7925 | 338 |
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);