ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where "date" is on date 2020-06-18 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 |
---|---|---|---|---|---|---|---|
250052 | 250052 | 2020-06-18 | Adams | Illinois | 17001 | 46 | 1 |
250053 | 250053 | 2020-06-18 | Alexander | Illinois | 17003 | 18 | 0 |
250054 | 250054 | 2020-06-18 | Bond | Illinois | 17005 | 12 | 1 |
250055 | 250055 | 2020-06-18 | Boone | Illinois | 17007 | 546 | 19 |
250056 | 250056 | 2020-06-18 | Brown | Illinois | 17009 | 10 | 0 |
250057 | 250057 | 2020-06-18 | Bureau | Illinois | 17011 | 24 | 1 |
250058 | 250058 | 2020-06-18 | Calhoun | Illinois | 17013 | 1 | 0 |
250059 | 250059 | 2020-06-18 | Carroll | Illinois | 17015 | 18 | 2 |
250060 | 250060 | 2020-06-18 | Cass | Illinois | 17017 | 79 | 0 |
250061 | 250061 | 2020-06-18 | Champaign | Illinois | 17019 | 761 | 11 |
250062 | 250062 | 2020-06-18 | Christian | Illinois | 17021 | 42 | 5 |
250063 | 250063 | 2020-06-18 | Clark | Illinois | 17023 | 13 | 0 |
250064 | 250064 | 2020-06-18 | Clay | Illinois | 17025 | 3 | 0 |
250065 | 250065 | 2020-06-18 | Clinton | Illinois | 17027 | 220 | 17 |
250066 | 250066 | 2020-06-18 | Coles | Illinois | 17029 | 146 | 17 |
250067 | 250067 | 2020-06-18 | Cook | Illinois | 17031 | 86179 | 4333 |
250068 | 250068 | 2020-06-18 | Crawford | Illinois | 17033 | 17 | 0 |
250069 | 250069 | 2020-06-18 | Cumberland | Illinois | 17035 | 10 | 0 |
250070 | 250070 | 2020-06-18 | De Witt | Illinois | 17039 | 4 | 0 |
250071 | 250071 | 2020-06-18 | DeKalb | Illinois | 17037 | 530 | 18 |
250072 | 250072 | 2020-06-18 | Douglas | Illinois | 17041 | 40 | 0 |
250073 | 250073 | 2020-06-18 | DuPage | Illinois | 17043 | 8575 | 443 |
250074 | 250074 | 2020-06-18 | Edgar | Illinois | 17045 | 3 | 0 |
250075 | 250075 | 2020-06-18 | Edwards | Illinois | 17047 | 2 | 0 |
250076 | 250076 | 2020-06-18 | Effingham | Illinois | 17049 | 12 | 1 |
250077 | 250077 | 2020-06-18 | Fayette | Illinois | 17051 | 23 | 3 |
250078 | 250078 | 2020-06-18 | Ford | Illinois | 17053 | 22 | 1 |
250079 | 250079 | 2020-06-18 | Franklin | Illinois | 17055 | 12 | 0 |
250080 | 250080 | 2020-06-18 | Fulton | Illinois | 17057 | 12 | 0 |
250081 | 250081 | 2020-06-18 | Gallatin | Illinois | 17059 | 2 | 0 |
250082 | 250082 | 2020-06-18 | Greene | Illinois | 17061 | 8 | 0 |
250083 | 250083 | 2020-06-18 | Grundy | Illinois | 17063 | 139 | 3 |
250084 | 250084 | 2020-06-18 | Hamilton | Illinois | 17065 | 2 | 0 |
250085 | 250085 | 2020-06-18 | Hancock | Illinois | 17067 | 18 | 1 |
250086 | 250086 | 2020-06-18 | Hardin | Illinois | 17069 | 1 | 0 |
250087 | 250087 | 2020-06-18 | Henderson | Illinois | 17071 | 8 | 0 |
250088 | 250088 | 2020-06-18 | Henry | Illinois | 17073 | 72 | 1 |
250089 | 250089 | 2020-06-18 | Iroquois | Illinois | 17075 | 142 | 5 |
250090 | 250090 | 2020-06-18 | Jackson | Illinois | 17077 | 321 | 18 |
250091 | 250091 | 2020-06-18 | Jasper | Illinois | 17079 | 46 | 7 |
250092 | 250092 | 2020-06-18 | Jefferson | Illinois | 17081 | 104 | 16 |
250093 | 250093 | 2020-06-18 | Jersey | Illinois | 17083 | 29 | 1 |
250094 | 250094 | 2020-06-18 | Jo Daviess | Illinois | 17085 | 35 | 1 |
250095 | 250095 | 2020-06-18 | Johnson | Illinois | 17087 | 20 | 0 |
250096 | 250096 | 2020-06-18 | Kane | Illinois | 17089 | 7286 | 242 |
250097 | 250097 | 2020-06-18 | Kankakee | Illinois | 17091 | 1232 | 61 |
250098 | 250098 | 2020-06-18 | Kendall | Illinois | 17093 | 938 | 22 |
250099 | 250099 | 2020-06-18 | Knox | Illinois | 17095 | 115 | 0 |
250100 | 250100 | 2020-06-18 | LaSalle | Illinois | 17099 | 189 | 16 |
250101 | 250101 | 2020-06-18 | Lake | Illinois | 17097 | 9221 | 392 |
250102 | 250102 | 2020-06-18 | Lawrence | Illinois | 17101 | 5 | 0 |
250103 | 250103 | 2020-06-18 | Lee | Illinois | 17103 | 90 | 1 |
250104 | 250104 | 2020-06-18 | Livingston | Illinois | 17105 | 35 | 2 |
250105 | 250105 | 2020-06-18 | Logan | Illinois | 17107 | 11 | 0 |
250106 | 250106 | 2020-06-18 | Macon | Illinois | 17115 | 214 | 21 |
250107 | 250107 | 2020-06-18 | Macoupin | Illinois | 17117 | 46 | 3 |
250108 | 250108 | 2020-06-18 | Madison | Illinois | 17119 | 771 | 66 |
250109 | 250109 | 2020-06-18 | Marion | Illinois | 17121 | 55 | 0 |
250110 | 250110 | 2020-06-18 | Marshall | Illinois | 17123 | 5 | 0 |
250111 | 250111 | 2020-06-18 | Mason | Illinois | 17125 | 18 | 0 |
250112 | 250112 | 2020-06-18 | Massac | Illinois | 17127 | 7 | 0 |
250113 | 250113 | 2020-06-18 | McDonough | Illinois | 17109 | 100 | 15 |
250114 | 250114 | 2020-06-18 | McHenry | Illinois | 17111 | 1884 | 89 |
250115 | 250115 | 2020-06-18 | McLean | Illinois | 17113 | 246 | 13 |
250116 | 250116 | 2020-06-18 | Menard | Illinois | 17129 | 23 | 0 |
250117 | 250117 | 2020-06-18 | Mercer | Illinois | 17131 | 19 | 0 |
250118 | 250118 | 2020-06-18 | Monroe | Illinois | 17133 | 110 | 12 |
250119 | 250119 | 2020-06-18 | Montgomery | Illinois | 17135 | 41 | 0 |
250120 | 250120 | 2020-06-18 | Morgan | Illinois | 17137 | 118 | 2 |
250121 | 250121 | 2020-06-18 | Moultrie | Illinois | 17139 | 15 | 0 |
250122 | 250122 | 2020-06-18 | Ogle | Illinois | 17141 | 240 | 4 |
250123 | 250123 | 2020-06-18 | Peoria | Illinois | 17143 | 411 | 21 |
250124 | 250124 | 2020-06-18 | Perry | Illinois | 17145 | 44 | 0 |
250125 | 250125 | 2020-06-18 | Piatt | Illinois | 17147 | 17 | 0 |
250126 | 250126 | 2020-06-18 | Pike | Illinois | 17149 | 2 | 0 |
250127 | 250127 | 2020-06-18 | Pope | Illinois | 17151 | 1 | 0 |
250128 | 250128 | 2020-06-18 | Pulaski | Illinois | 17153 | 65 | 0 |
250129 | 250129 | 2020-06-18 | Putnam | Illinois | 17155 | 1 | 0 |
250130 | 250130 | 2020-06-18 | Randolph | Illinois | 17157 | 279 | 7 |
250131 | 250131 | 2020-06-18 | Richland | Illinois | 17159 | 4 | 0 |
250132 | 250132 | 2020-06-18 | Rock Island | Illinois | 17161 | 791 | 28 |
250133 | 250133 | 2020-06-18 | Saline | Illinois | 17165 | 8 | 0 |
250134 | 250134 | 2020-06-18 | Sangamon | Illinois | 17167 | 387 | 33 |
250135 | 250135 | 2020-06-18 | Schuyler | Illinois | 17169 | 13 | 0 |
250136 | 250136 | 2020-06-18 | Shelby | Illinois | 17173 | 16 | 1 |
250137 | 250137 | 2020-06-18 | St. Clair | Illinois | 17163 | 1716 | 131 |
250138 | 250138 | 2020-06-18 | Stark | Illinois | 17175 | 3 | 0 |
250139 | 250139 | 2020-06-18 | Stephenson | Illinois | 17177 | 236 | 5 |
250140 | 250140 | 2020-06-18 | Tazewell | Illinois | 17179 | 104 | 7 |
250141 | 250141 | 2020-06-18 | Union | Illinois | 17181 | 174 | 18 |
250142 | 250142 | 2020-06-18 | Unknown | Illinois | 861 | 181 | |
250143 | 250143 | 2020-06-18 | Vermilion | Illinois | 17183 | 47 | 2 |
250144 | 250144 | 2020-06-18 | Wabash | Illinois | 17185 | 14 | 0 |
250145 | 250145 | 2020-06-18 | Warren | Illinois | 17187 | 127 | 0 |
250146 | 250146 | 2020-06-18 | Washington | Illinois | 17189 | 19 | 0 |
250147 | 250147 | 2020-06-18 | Wayne | Illinois | 17191 | 10 | 1 |
250148 | 250148 | 2020-06-18 | White | Illinois | 17193 | 3 | 0 |
250149 | 250149 | 2020-06-18 | Whiteside | Illinois | 17195 | 163 | 15 |
250150 | 250150 | 2020-06-18 | Will | Illinois | 17197 | 6258 | 310 |
250151 | 250151 | 2020-06-18 | Williamson | Illinois | 17199 | 91 | 3 |
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);