ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where date = "2020-08-24" 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 |
---|---|---|---|---|---|---|---|
463881 | 463881 | 2020-08-24 | Adams | Illinois | 17001 | 727 | 7 |
463882 | 463882 | 2020-08-24 | Alexander | Illinois | 17003 | 40 | 0 |
463883 | 463883 | 2020-08-24 | Bond | Illinois | 17005 | 107 | 3 |
463884 | 463884 | 2020-08-24 | Boone | Illinois | 17007 | 827 | 23 |
463885 | 463885 | 2020-08-24 | Brown | Illinois | 17009 | 16 | 0 |
463886 | 463886 | 2020-08-24 | Bureau | Illinois | 17011 | 322 | 4 |
463887 | 463887 | 2020-08-24 | Calhoun | Illinois | 17013 | 22 | 0 |
463888 | 463888 | 2020-08-24 | Carroll | Illinois | 17015 | 115 | 4 |
463889 | 463889 | 2020-08-24 | Cass | Illinois | 17017 | 287 | 11 |
463890 | 463890 | 2020-08-24 | Champaign | Illinois | 17019 | 2078 | 20 |
463891 | 463891 | 2020-08-24 | Christian | Illinois | 17021 | 185 | 5 |
463892 | 463892 | 2020-08-24 | Clark | Illinois | 17023 | 112 | 2 |
463893 | 463893 | 2020-08-24 | Clay | Illinois | 17025 | 60 | 0 |
463894 | 463894 | 2020-08-24 | Clinton | Illinois | 17027 | 606 | 17 |
463895 | 463895 | 2020-08-24 | Coles | Illinois | 17029 | 786 | 21 |
463896 | 463896 | 2020-08-24 | Cook | Illinois | 17031 | 121894 | 5015 |
463897 | 463897 | 2020-08-24 | Crawford | Illinois | 17033 | 57 | 0 |
463898 | 463898 | 2020-08-24 | Cumberland | Illinois | 17035 | 109 | 3 |
463899 | 463899 | 2020-08-24 | De Witt | Illinois | 17039 | 38 | 1 |
463900 | 463900 | 2020-08-24 | DeKalb | Illinois | 17037 | 1080 | 33 |
463901 | 463901 | 2020-08-24 | Douglas | Illinois | 17041 | 189 | 4 |
463902 | 463902 | 2020-08-24 | DuPage | Illinois | 17043 | 13909 | 530 |
463903 | 463903 | 2020-08-24 | Edgar | Illinois | 17045 | 61 | 0 |
463904 | 463904 | 2020-08-24 | Edwards | Illinois | 17047 | 31 | 0 |
463905 | 463905 | 2020-08-24 | Effingham | Illinois | 17049 | 398 | 1 |
463906 | 463906 | 2020-08-24 | Fayette | Illinois | 17051 | 120 | 3 |
463907 | 463907 | 2020-08-24 | Ford | Illinois | 17053 | 70 | 2 |
463908 | 463908 | 2020-08-24 | Franklin | Illinois | 17055 | 293 | 1 |
463909 | 463909 | 2020-08-24 | Fulton | Illinois | 17057 | 73 | 0 |
463910 | 463910 | 2020-08-24 | Gallatin | Illinois | 17059 | 60 | 2 |
463911 | 463911 | 2020-08-24 | Greene | Illinois | 17061 | 98 | 0 |
463912 | 463912 | 2020-08-24 | Grundy | Illinois | 17063 | 436 | 5 |
463913 | 463913 | 2020-08-24 | Hamilton | Illinois | 17065 | 42 | 0 |
463914 | 463914 | 2020-08-24 | Hancock | Illinois | 17067 | 116 | 1 |
463915 | 463915 | 2020-08-24 | Hardin | Illinois | 17069 | 18 | 0 |
463916 | 463916 | 2020-08-24 | Henderson | Illinois | 17071 | 36 | 0 |
463917 | 463917 | 2020-08-24 | Henry | Illinois | 17073 | 396 | 1 |
463918 | 463918 | 2020-08-24 | Iroquois | Illinois | 17075 | 284 | 18 |
463919 | 463919 | 2020-08-24 | Jackson | Illinois | 17077 | 851 | 20 |
463920 | 463920 | 2020-08-24 | Jasper | Illinois | 17079 | 89 | 7 |
463921 | 463921 | 2020-08-24 | Jefferson | Illinois | 17081 | 402 | 31 |
463922 | 463922 | 2020-08-24 | Jersey | Illinois | 17083 | 229 | 2 |
463923 | 463923 | 2020-08-24 | Jo Daviess | Illinois | 17085 | 166 | 2 |
463924 | 463924 | 2020-08-24 | Johnson | Illinois | 17087 | 95 | 0 |
463925 | 463925 | 2020-08-24 | Kane | Illinois | 17089 | 10863 | 308 |
463926 | 463926 | 2020-08-24 | Kankakee | Illinois | 17091 | 2123 | 71 |
463927 | 463927 | 2020-08-24 | Kendall | Illinois | 17093 | 1629 | 25 |
463928 | 463928 | 2020-08-24 | Knox | Illinois | 17095 | 425 | 3 |
463929 | 463929 | 2020-08-24 | LaSalle | Illinois | 17099 | 1115 | 39 |
463930 | 463930 | 2020-08-24 | Lake | Illinois | 17097 | 13939 | 455 |
463931 | 463931 | 2020-08-24 | Lawrence | Illinois | 17101 | 87 | 0 |
463932 | 463932 | 2020-08-24 | Lee | Illinois | 17103 | 218 | 1 |
463933 | 463933 | 2020-08-24 | Livingston | Illinois | 17105 | 170 | 3 |
463934 | 463934 | 2020-08-24 | Logan | Illinois | 17107 | 228 | 1 |
463935 | 463935 | 2020-08-24 | Macon | Illinois | 17115 | 852 | 24 |
463936 | 463936 | 2020-08-24 | Macoupin | Illinois | 17117 | 301 | 3 |
463937 | 463937 | 2020-08-24 | Madison | Illinois | 17119 | 3606 | 91 |
463938 | 463938 | 2020-08-24 | Marion | Illinois | 17121 | 234 | 0 |
463939 | 463939 | 2020-08-24 | Marshall | Illinois | 17123 | 39 | 0 |
463940 | 463940 | 2020-08-24 | Mason | Illinois | 17125 | 72 | 1 |
463941 | 463941 | 2020-08-24 | Massac | Illinois | 17127 | 56 | 0 |
463942 | 463942 | 2020-08-24 | McDonough | Illinois | 17109 | 161 | 15 |
463943 | 463943 | 2020-08-24 | McHenry | Illinois | 17111 | 3680 | 115 |
463944 | 463944 | 2020-08-24 | McLean | Illinois | 17113 | 1138 | 16 |
463945 | 463945 | 2020-08-24 | Menard | Illinois | 17129 | 63 | 0 |
463946 | 463946 | 2020-08-24 | Mercer | Illinois | 17131 | 90 | 4 |
463947 | 463947 | 2020-08-24 | Monroe | Illinois | 17133 | 402 | 14 |
463948 | 463948 | 2020-08-24 | Montgomery | Illinois | 17135 | 223 | 7 |
463949 | 463949 | 2020-08-24 | Morgan | Illinois | 17137 | 480 | 18 |
463950 | 463950 | 2020-08-24 | Moultrie | Illinois | 17139 | 133 | 0 |
463951 | 463951 | 2020-08-24 | Ogle | Illinois | 17141 | 473 | 5 |
463952 | 463952 | 2020-08-24 | Peoria | Illinois | 17143 | 2191 | 38 |
463953 | 463953 | 2020-08-24 | Perry | Illinois | 17145 | 271 | 6 |
463954 | 463954 | 2020-08-24 | Piatt | Illinois | 17147 | 70 | 0 |
463955 | 463955 | 2020-08-24 | Pike | Illinois | 17149 | 57 | 0 |
463956 | 463956 | 2020-08-24 | Pope | Illinois | 17151 | 11 | 0 |
463957 | 463957 | 2020-08-24 | Pulaski | Illinois | 17153 | 106 | 1 |
463958 | 463958 | 2020-08-24 | Putnam | Illinois | 17155 | 13 | 0 |
463959 | 463959 | 2020-08-24 | Randolph | Illinois | 17157 | 647 | 7 |
463960 | 463960 | 2020-08-24 | Richland | Illinois | 17159 | 54 | 1 |
463961 | 463961 | 2020-08-24 | Rock Island | Illinois | 17161 | 2061 | 53 |
463962 | 463962 | 2020-08-24 | Saline | Illinois | 17165 | 155 | 2 |
463963 | 463963 | 2020-08-24 | Sangamon | Illinois | 17167 | 1689 | 38 |
463964 | 463964 | 2020-08-24 | Schuyler | Illinois | 17169 | 19 | 0 |
463965 | 463965 | 2020-08-24 | Scott | Illinois | 17171 | 41 | 0 |
463966 | 463966 | 2020-08-24 | Shelby | Illinois | 17173 | 153 | 2 |
463967 | 463967 | 2020-08-24 | St. Clair | Illinois | 17163 | 5449 | 173 |
463968 | 463968 | 2020-08-24 | Stark | Illinois | 17175 | 10 | 0 |
463969 | 463969 | 2020-08-24 | Stephenson | Illinois | 17177 | 368 | 6 |
463970 | 463970 | 2020-08-24 | Tazewell | Illinois | 17179 | 959 | 9 |
463971 | 463971 | 2020-08-24 | Union | Illinois | 17181 | 400 | 23 |
463972 | 463972 | 2020-08-24 | Unknown | Illinois | 1361 | 209 | |
463973 | 463973 | 2020-08-24 | Vermilion | Illinois | 17183 | 298 | 2 |
463974 | 463974 | 2020-08-24 | Wabash | Illinois | 17185 | 93 | 1 |
463975 | 463975 | 2020-08-24 | Warren | Illinois | 17187 | 230 | 0 |
463976 | 463976 | 2020-08-24 | Washington | Illinois | 17189 | 92 | 1 |
463977 | 463977 | 2020-08-24 | Wayne | Illinois | 17191 | 86 | 2 |
463978 | 463978 | 2020-08-24 | White | Illinois | 17193 | 113 | 0 |
463979 | 463979 | 2020-08-24 | Whiteside | Illinois | 17195 | 466 | 18 |
463980 | 463980 | 2020-08-24 | Will | Illinois | 17197 | 10830 | 354 |
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);