ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where date = "2020-05-22" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
166904 | 166904 | 2020-05-22 | Adams | Illinois | 17001 | 44 | 1 |
166905 | 166905 | 2020-05-22 | Alexander | Illinois | 17003 | 8 | 0 |
166906 | 166906 | 2020-05-22 | Bond | Illinois | 17005 | 10 | 1 |
166907 | 166907 | 2020-05-22 | Boone | Illinois | 17007 | 368 | 16 |
166908 | 166908 | 2020-05-22 | Brown | Illinois | 17009 | 10 | 0 |
166909 | 166909 | 2020-05-22 | Bureau | Illinois | 17011 | 15 | 1 |
166910 | 166910 | 2020-05-22 | Calhoun | Illinois | 17013 | 1 | 0 |
166911 | 166911 | 2020-05-22 | Carroll | Illinois | 17015 | 13 | 2 |
166912 | 166912 | 2020-05-22 | Cass | Illinois | 17017 | 67 | 0 |
166913 | 166913 | 2020-05-22 | Champaign | Illinois | 17019 | 515 | 7 |
166914 | 166914 | 2020-05-22 | Christian | Illinois | 17021 | 32 | 5 |
166915 | 166915 | 2020-05-22 | Clark | Illinois | 17023 | 10 | 0 |
166916 | 166916 | 2020-05-22 | Clay | Illinois | 17025 | 2 | 0 |
166917 | 166917 | 2020-05-22 | Clinton | Illinois | 17027 | 173 | 16 |
166918 | 166918 | 2020-05-22 | Coles | Illinois | 17029 | 95 | 7 |
166919 | 166919 | 2020-05-22 | Cook | Illinois | 17031 | 68949 | 3187 |
166920 | 166920 | 2020-05-22 | Crawford | Illinois | 17033 | 11 | 0 |
166921 | 166921 | 2020-05-22 | Cumberland | Illinois | 17035 | 10 | 0 |
166922 | 166922 | 2020-05-22 | De Witt | Illinois | 17039 | 4 | 0 |
166923 | 166923 | 2020-05-22 | DeKalb | Illinois | 17037 | 307 | 3 |
166924 | 166924 | 2020-05-22 | Douglas | Illinois | 17041 | 27 | 0 |
166925 | 166925 | 2020-05-22 | DuPage | Illinois | 17043 | 6744 | 337 |
166926 | 166926 | 2020-05-22 | Edwards | Illinois | 17047 | 2 | 0 |
166927 | 166927 | 2020-05-22 | Effingham | Illinois | 17049 | 6 | 1 |
166928 | 166928 | 2020-05-22 | Fayette | Illinois | 17051 | 19 | 2 |
166929 | 166929 | 2020-05-22 | Ford | Illinois | 17053 | 19 | 1 |
166930 | 166930 | 2020-05-22 | Franklin | Illinois | 17055 | 11 | 0 |
166931 | 166931 | 2020-05-22 | Fulton | Illinois | 17057 | 10 | 0 |
166932 | 166932 | 2020-05-22 | Gallatin | Illinois | 17059 | 2 | 0 |
166933 | 166933 | 2020-05-22 | Greene | Illinois | 17061 | 5 | 0 |
166934 | 166934 | 2020-05-22 | Grundy | Illinois | 17063 | 84 | 2 |
166935 | 166935 | 2020-05-22 | Hamilton | Illinois | 17065 | 2 | 0 |
166936 | 166936 | 2020-05-22 | Hancock | Illinois | 17067 | 13 | 0 |
166937 | 166937 | 2020-05-22 | Hardin | Illinois | 17069 | 1 | 0 |
166938 | 166938 | 2020-05-22 | Henderson | Illinois | 17071 | 8 | 0 |
166939 | 166939 | 2020-05-22 | Henry | Illinois | 17073 | 65 | 0 |
166940 | 166940 | 2020-05-22 | Iroquois | Illinois | 17075 | 124 | 4 |
166941 | 166941 | 2020-05-22 | Jackson | Illinois | 17077 | 197 | 10 |
166942 | 166942 | 2020-05-22 | Jasper | Illinois | 17079 | 45 | 7 |
166943 | 166943 | 2020-05-22 | Jefferson | Illinois | 17081 | 99 | 16 |
166944 | 166944 | 2020-05-22 | Jersey | Illinois | 17083 | 20 | 1 |
166945 | 166945 | 2020-05-22 | Jo Daviess | Illinois | 17085 | 24 | 0 |
166946 | 166946 | 2020-05-22 | Johnson | Illinois | 17087 | 7 | 0 |
166947 | 166947 | 2020-05-22 | Kane | Illinois | 17089 | 5327 | 150 |
166948 | 166948 | 2020-05-22 | Kankakee | Illinois | 17091 | 1041 | 47 |
166949 | 166949 | 2020-05-22 | Kendall | Illinois | 17093 | 680 | 22 |
166950 | 166950 | 2020-05-22 | Knox | Illinois | 17095 | 93 | 0 |
166951 | 166951 | 2020-05-22 | LaSalle | Illinois | 17099 | 130 | 10 |
166952 | 166952 | 2020-05-22 | Lake | Illinois | 17097 | 7291 | 249 |
166953 | 166953 | 2020-05-22 | Lawrence | Illinois | 17101 | 4 | 0 |
166954 | 166954 | 2020-05-22 | Lee | Illinois | 17103 | 75 | 1 |
166955 | 166955 | 2020-05-22 | Livingston | Illinois | 17105 | 30 | 2 |
166956 | 166956 | 2020-05-22 | Logan | Illinois | 17107 | 10 | 0 |
166957 | 166957 | 2020-05-22 | Macon | Illinois | 17115 | 184 | 17 |
166958 | 166958 | 2020-05-22 | Macoupin | Illinois | 17117 | 41 | 1 |
166959 | 166959 | 2020-05-22 | Madison | Illinois | 17119 | 516 | 49 |
166960 | 166960 | 2020-05-22 | Marion | Illinois | 17121 | 50 | 0 |
166961 | 166961 | 2020-05-22 | Marshall | Illinois | 17123 | 5 | 0 |
166962 | 166962 | 2020-05-22 | Mason | Illinois | 17125 | 16 | 0 |
166963 | 166963 | 2020-05-22 | Massac | Illinois | 17127 | 7 | 0 |
166964 | 166964 | 2020-05-22 | McDonough | Illinois | 17109 | 75 | 4 |
166965 | 166965 | 2020-05-22 | McHenry | Illinois | 17111 | 1323 | 67 |
166966 | 166966 | 2020-05-22 | McLean | Illinois | 17113 | 195 | 9 |
166967 | 166967 | 2020-05-22 | Menard | Illinois | 17129 | 17 | 0 |
166968 | 166968 | 2020-05-22 | Mercer | Illinois | 17131 | 14 | 0 |
166969 | 166969 | 2020-05-22 | Monroe | Illinois | 17133 | 91 | 11 |
166970 | 166970 | 2020-05-22 | Montgomery | Illinois | 17135 | 38 | 0 |
166971 | 166971 | 2020-05-22 | Morgan | Illinois | 17137 | 34 | 1 |
166972 | 166972 | 2020-05-22 | Moultrie | Illinois | 17139 | 8 | 0 |
166973 | 166973 | 2020-05-22 | Ogle | Illinois | 17141 | 193 | 2 |
166974 | 166974 | 2020-05-22 | Peoria | Illinois | 17143 | 176 | 7 |
166975 | 166975 | 2020-05-22 | Perry | Illinois | 17145 | 40 | 0 |
166976 | 166976 | 2020-05-22 | Piatt | Illinois | 17147 | 9 | 0 |
166977 | 166977 | 2020-05-22 | Pike | Illinois | 17149 | 1 | 0 |
166978 | 166978 | 2020-05-22 | Pope | Illinois | 17151 | 1 | 0 |
166979 | 166979 | 2020-05-22 | Pulaski | Illinois | 17153 | 40 | 0 |
166980 | 166980 | 2020-05-22 | Putnam | Illinois | 17155 | 1 | 0 |
166981 | 166981 | 2020-05-22 | Randolph | Illinois | 17157 | 251 | 3 |
166982 | 166982 | 2020-05-22 | Richland | Illinois | 17159 | 3 | 0 |
166983 | 166983 | 2020-05-22 | Rock Island | Illinois | 17161 | 665 | 25 |
166984 | 166984 | 2020-05-22 | Saline | Illinois | 17165 | 6 | 0 |
166985 | 166985 | 2020-05-22 | Sangamon | Illinois | 17167 | 334 | 28 |
166986 | 166986 | 2020-05-22 | Schuyler | Illinois | 17169 | 9 | 0 |
166987 | 166987 | 2020-05-22 | Shelby | Illinois | 17173 | 15 | 1 |
166988 | 166988 | 2020-05-22 | St. Clair | Illinois | 17163 | 983 | 74 |
166989 | 166989 | 2020-05-22 | Stark | Illinois | 17175 | 3 | 0 |
166990 | 166990 | 2020-05-22 | Stephenson | Illinois | 17177 | 173 | 2 |
166991 | 166991 | 2020-05-22 | Tazewell | Illinois | 17179 | 66 | 4 |
166992 | 166992 | 2020-05-22 | Union | Illinois | 17181 | 136 | 5 |
166993 | 166993 | 2020-05-22 | Vermilion | Illinois | 17183 | 39 | 1 |
166994 | 166994 | 2020-05-22 | Wabash | Illinois | 17185 | 1 | 0 |
166995 | 166995 | 2020-05-22 | Warren | Illinois | 17187 | 112 | 0 |
166996 | 166996 | 2020-05-22 | Washington | Illinois | 17189 | 18 | 0 |
166997 | 166997 | 2020-05-22 | Wayne | Illinois | 17191 | 9 | 1 |
166998 | 166998 | 2020-05-22 | White | Illinois | 17193 | 2 | 0 |
166999 | 166999 | 2020-05-22 | Whiteside | Illinois | 17195 | 133 | 10 |
167000 | 167000 | 2020-05-22 | Will | Illinois | 17197 | 4966 | 255 |
167001 | 167001 | 2020-05-22 | Williamson | Illinois | 17199 | 54 | 1 |
167002 | 167002 | 2020-05-22 | Winnebago | Illinois | 17201 | 1780 | 52 |
167003 | 167003 | 2020-05-22 | Woodford | Illinois | 17203 | 18 | 2 |
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);