ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,331 rows where county = "McLean" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Kentucky 744
- North Dakota 744
- Illinois 743
county 1
- McLean · 2,231 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
102004 | 102004 | 2020-04-30 | McLean | Kentucky | 21149 | 14 | 0 |
102842 | 102842 | 2020-04-30 | McLean | North Dakota | 38055 | 3 | 0 |
104491 | 104491 | 2020-05-01 | McLean | Illinois | 17113 | 97 | 3 |
104865 | 104865 | 2020-05-01 | McLean | Kentucky | 21149 | 15 | 0 |
105704 | 105704 | 2020-05-01 | McLean | North Dakota | 38055 | 3 | 0 |
107356 | 107356 | 2020-05-02 | McLean | Illinois | 17113 | 99 | 3 |
107730 | 107730 | 2020-05-02 | McLean | Kentucky | 21149 | 14 | 0 |
108571 | 108571 | 2020-05-02 | McLean | North Dakota | 38055 | 5 | 0 |
110226 | 110226 | 2020-05-03 | McLean | Illinois | 17113 | 99 | 3 |
110601 | 110601 | 2020-05-03 | McLean | Kentucky | 21149 | 15 | 0 |
111445 | 111445 | 2020-05-03 | McLean | North Dakota | 38055 | 5 | 0 |
113101 | 113101 | 2020-05-04 | McLean | Illinois | 17113 | 103 | 3 |
113478 | 113478 | 2020-05-04 | McLean | Kentucky | 21149 | 16 | 0 |
114326 | 114326 | 2020-05-04 | McLean | North Dakota | 38055 | 5 | 0 |
115984 | 115984 | 2020-05-05 | McLean | Illinois | 17113 | 103 | 3 |
116360 | 116360 | 2020-05-05 | McLean | Kentucky | 21149 | 16 | 0 |
117206 | 117206 | 2020-05-05 | McLean | North Dakota | 38055 | 5 | 0 |
118944 | 118944 | 2020-05-06 | McLean | Illinois | 17113 | 108 | 3 |
119321 | 119321 | 2020-05-06 | McLean | Kentucky | 21149 | 16 | 0 |
120167 | 120167 | 2020-05-06 | McLean | North Dakota | 38055 | 5 | 0 |
121914 | 121914 | 2020-05-07 | McLean | Illinois | 17113 | 110 | 3 |
122292 | 122292 | 2020-05-07 | McLean | Kentucky | 21149 | 16 | 0 |
123143 | 123143 | 2020-05-07 | McLean | North Dakota | 38055 | 5 | 0 |
124893 | 124893 | 2020-05-08 | McLean | Illinois | 17113 | 112 | 3 |
125274 | 125274 | 2020-05-08 | McLean | Kentucky | 21149 | 18 | 0 |
126126 | 126126 | 2020-05-08 | McLean | North Dakota | 38055 | 5 | 0 |
127880 | 127880 | 2020-05-09 | McLean | Illinois | 17113 | 115 | 3 |
128262 | 128262 | 2020-05-09 | McLean | Kentucky | 21149 | 18 | 0 |
129115 | 129115 | 2020-05-09 | McLean | North Dakota | 38055 | 5 | 0 |
130871 | 130871 | 2020-05-10 | McLean | Illinois | 17113 | 117 | 3 |
131252 | 131252 | 2020-05-10 | McLean | Kentucky | 21149 | 18 | 0 |
132104 | 132104 | 2020-05-10 | McLean | North Dakota | 38055 | 5 | 0 |
133862 | 133862 | 2020-05-11 | McLean | Illinois | 17113 | 121 | 3 |
134243 | 134243 | 2020-05-11 | McLean | Kentucky | 21149 | 18 | 0 |
135095 | 135095 | 2020-05-11 | McLean | North Dakota | 38055 | 5 | 0 |
136851 | 136851 | 2020-05-12 | McLean | Illinois | 17113 | 126 | 3 |
137233 | 137233 | 2020-05-12 | McLean | Kentucky | 21149 | 18 | 0 |
138085 | 138085 | 2020-05-12 | McLean | North Dakota | 38055 | 5 | 0 |
139843 | 139843 | 2020-05-13 | McLean | Illinois | 17113 | 127 | 3 |
140226 | 140226 | 2020-05-13 | McLean | Kentucky | 21149 | 19 | 0 |
141081 | 141081 | 2020-05-13 | McLean | North Dakota | 38055 | 5 | 0 |
142839 | 142839 | 2020-05-14 | McLean | Illinois | 17113 | 130 | 3 |
143222 | 143222 | 2020-05-14 | McLean | Kentucky | 21149 | 19 | 0 |
144076 | 144076 | 2020-05-14 | McLean | North Dakota | 38055 | 5 | 0 |
145839 | 145839 | 2020-05-15 | McLean | Illinois | 17113 | 132 | 4 |
146222 | 146222 | 2020-05-15 | McLean | Kentucky | 21149 | 19 | 0 |
147077 | 147077 | 2020-05-15 | McLean | North Dakota | 38055 | 5 | 0 |
148842 | 148842 | 2020-05-16 | McLean | Illinois | 17113 | 158 | 4 |
149227 | 149227 | 2020-05-16 | McLean | Kentucky | 21149 | 19 | 0 |
150084 | 150084 | 2020-05-16 | McLean | North Dakota | 38055 | 5 | 0 |
151851 | 151851 | 2020-05-17 | McLean | Illinois | 17113 | 170 | 6 |
152238 | 152238 | 2020-05-17 | McLean | Kentucky | 21149 | 19 | 0 |
153094 | 153094 | 2020-05-17 | McLean | North Dakota | 38055 | 6 | 0 |
154863 | 154863 | 2020-05-18 | McLean | Illinois | 17113 | 186 | 6 |
155252 | 155252 | 2020-05-18 | McLean | Kentucky | 21149 | 19 | 0 |
156111 | 156111 | 2020-05-18 | McLean | North Dakota | 38055 | 6 | 0 |
157879 | 157879 | 2020-05-19 | McLean | Illinois | 17113 | 189 | 6 |
158269 | 158269 | 2020-05-19 | McLean | Kentucky | 21149 | 20 | 0 |
159131 | 159131 | 2020-05-19 | McLean | North Dakota | 38055 | 7 | 0 |
160905 | 160905 | 2020-05-20 | McLean | Illinois | 17113 | 191 | 6 |
161295 | 161295 | 2020-05-20 | McLean | Kentucky | 21149 | 20 | 1 |
162158 | 162158 | 2020-05-20 | McLean | North Dakota | 38055 | 7 | 0 |
163933 | 163933 | 2020-05-21 | McLean | Illinois | 17113 | 195 | 9 |
164324 | 164324 | 2020-05-21 | McLean | Kentucky | 21149 | 20 | 1 |
165187 | 165187 | 2020-05-21 | McLean | North Dakota | 38055 | 7 | 0 |
166966 | 166966 | 2020-05-22 | McLean | Illinois | 17113 | 195 | 9 |
167360 | 167360 | 2020-05-22 | McLean | Kentucky | 21149 | 20 | 1 |
168223 | 168223 | 2020-05-22 | McLean | North Dakota | 38055 | 7 | 0 |
170003 | 170003 | 2020-05-23 | McLean | Illinois | 17113 | 202 | 9 |
170398 | 170398 | 2020-05-23 | McLean | Kentucky | 21149 | 20 | 1 |
171262 | 171262 | 2020-05-23 | McLean | North Dakota | 38055 | 7 | 0 |
173044 | 173044 | 2020-05-24 | McLean | Illinois | 17113 | 204 | 10 |
173439 | 173439 | 2020-05-24 | McLean | Kentucky | 21149 | 23 | 1 |
174304 | 174304 | 2020-05-24 | McLean | North Dakota | 38055 | 7 | 0 |
176088 | 176088 | 2020-05-25 | McLean | Illinois | 17113 | 211 | 10 |
176483 | 176483 | 2020-05-25 | McLean | Kentucky | 21149 | 22 | 0 |
177348 | 177348 | 2020-05-25 | McLean | North Dakota | 38055 | 7 | 0 |
179132 | 179132 | 2020-05-26 | McLean | Illinois | 17113 | 212 | 10 |
179527 | 179527 | 2020-05-26 | McLean | Kentucky | 21149 | 22 | 0 |
180391 | 180391 | 2020-05-26 | McLean | North Dakota | 38055 | 7 | 0 |
182176 | 182176 | 2020-05-27 | McLean | Illinois | 17113 | 215 | 13 |
182572 | 182572 | 2020-05-27 | McLean | Kentucky | 21149 | 23 | 0 |
183439 | 183439 | 2020-05-27 | McLean | North Dakota | 38055 | 7 | 0 |
185230 | 185230 | 2020-05-28 | McLean | Illinois | 17113 | 216 | 13 |
185627 | 185627 | 2020-05-28 | McLean | Kentucky | 21149 | 23 | 0 |
186496 | 186496 | 2020-05-28 | McLean | North Dakota | 38055 | 7 | 0 |
188288 | 188288 | 2020-05-29 | McLean | Illinois | 17113 | 217 | 13 |
188685 | 188685 | 2020-05-29 | McLean | Kentucky | 21149 | 23 | 0 |
189556 | 189556 | 2020-05-29 | McLean | North Dakota | 38055 | 7 | 0 |
191353 | 191353 | 2020-05-30 | McLean | Illinois | 17113 | 218 | 13 |
191749 | 191749 | 2020-05-30 | McLean | Kentucky | 21149 | 23 | 0 |
192620 | 192620 | 2020-05-30 | McLean | North Dakota | 38055 | 7 | 0 |
194420 | 194420 | 2020-05-31 | McLean | Illinois | 17113 | 220 | 13 |
194817 | 194817 | 2020-05-31 | McLean | Kentucky | 21149 | 23 | 0 |
195690 | 195690 | 2020-05-31 | McLean | North Dakota | 38055 | 7 | 0 |
197490 | 197490 | 2020-06-01 | McLean | Illinois | 17113 | 220 | 13 |
197888 | 197888 | 2020-06-01 | McLean | Kentucky | 21149 | 23 | 0 |
198763 | 198763 | 2020-06-01 | McLean | North Dakota | 38055 | 7 | 0 |
200563 | 200563 | 2020-06-02 | McLean | Illinois | 17113 | 221 | 13 |
200960 | 200960 | 2020-06-02 | McLean | Kentucky | 21149 | 23 | 0 |
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);