ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "LaSalle" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386583 | 386583 | 2020-07-31 | LaSalle | Illinois | 17099 | 480 | 18 |
383365 | 383365 | 2020-07-30 | LaSalle | Illinois | 17099 | 463 | 18 |
380148 | 380148 | 2020-07-29 | LaSalle | Illinois | 17099 | 442 | 18 |
376931 | 376931 | 2020-07-28 | LaSalle | Illinois | 17099 | 428 | 18 |
373716 | 373716 | 2020-07-27 | LaSalle | Illinois | 17099 | 419 | 18 |
370504 | 370504 | 2020-07-26 | LaSalle | Illinois | 17099 | 414 | 18 |
367294 | 367294 | 2020-07-25 | LaSalle | Illinois | 17099 | 409 | 18 |
364087 | 364087 | 2020-07-24 | LaSalle | Illinois | 17099 | 388 | 18 |
360880 | 360880 | 2020-07-23 | LaSalle | Illinois | 17099 | 379 | 18 |
357675 | 357675 | 2020-07-22 | LaSalle | Illinois | 17099 | 362 | 18 |
354473 | 354473 | 2020-07-21 | LaSalle | Illinois | 17099 | 350 | 18 |
351271 | 351271 | 2020-07-20 | LaSalle | Illinois | 17099 | 343 | 18 |
348071 | 348071 | 2020-07-19 | LaSalle | Illinois | 17099 | 328 | 18 |
344870 | 344870 | 2020-07-18 | LaSalle | Illinois | 17099 | 313 | 18 |
341670 | 341670 | 2020-07-17 | LaSalle | Illinois | 17099 | 306 | 18 |
338474 | 338474 | 2020-07-16 | LaSalle | Illinois | 17099 | 298 | 17 |
335278 | 335278 | 2020-07-15 | LaSalle | Illinois | 17099 | 286 | 17 |
332085 | 332085 | 2020-07-14 | LaSalle | Illinois | 17099 | 280 | 17 |
328898 | 328898 | 2020-07-13 | LaSalle | Illinois | 17099 | 270 | 17 |
325712 | 325712 | 2020-07-12 | LaSalle | Illinois | 17099 | 259 | 17 |
322531 | 322531 | 2020-07-11 | LaSalle | Illinois | 17099 | 254 | 17 |
319352 | 319352 | 2020-07-10 | LaSalle | Illinois | 17099 | 246 | 17 |
316179 | 316179 | 2020-07-09 | LaSalle | Illinois | 17099 | 239 | 17 |
313005 | 313005 | 2020-07-08 | LaSalle | Illinois | 17099 | 237 | 17 |
309835 | 309835 | 2020-07-07 | LaSalle | Illinois | 17099 | 233 | 17 |
306667 | 306667 | 2020-07-06 | LaSalle | Illinois | 17099 | 228 | 17 |
303502 | 303502 | 2020-07-05 | LaSalle | Illinois | 17099 | 226 | 17 |
300338 | 300338 | 2020-07-04 | LaSalle | Illinois | 17099 | 225 | 17 |
297176 | 297176 | 2020-07-03 | LaSalle | Illinois | 17099 | 224 | 17 |
294019 | 294019 | 2020-07-02 | LaSalle | Illinois | 17099 | 220 | 17 |
290865 | 290865 | 2020-07-01 | LaSalle | Illinois | 17099 | 219 | 17 |
287715 | 287715 | 2020-06-30 | LaSalle | Illinois | 17099 | 216 | 17 |
284566 | 284566 | 2020-06-29 | LaSalle | Illinois | 17099 | 208 | 17 |
281421 | 281421 | 2020-06-28 | LaSalle | Illinois | 17099 | 205 | 17 |
278273 | 278273 | 2020-06-27 | LaSalle | Illinois | 17099 | 205 | 17 |
275125 | 275125 | 2020-06-26 | LaSalle | Illinois | 17099 | 201 | 17 |
271983 | 271983 | 2020-06-25 | LaSalle | Illinois | 17099 | 199 | 17 |
268846 | 268846 | 2020-06-24 | LaSalle | Illinois | 17099 | 195 | 16 |
265716 | 265716 | 2020-06-23 | LaSalle | Illinois | 17099 | 191 | 16 |
262588 | 262588 | 2020-06-22 | LaSalle | Illinois | 17099 | 190 | 16 |
259461 | 259461 | 2020-06-21 | LaSalle | Illinois | 17099 | 190 | 16 |
256335 | 256335 | 2020-06-20 | LaSalle | Illinois | 17099 | 188 | 16 |
253215 | 253215 | 2020-06-19 | LaSalle | Illinois | 17099 | 188 | 16 |
250100 | 250100 | 2020-06-18 | LaSalle | Illinois | 17099 | 189 | 16 |
246988 | 246988 | 2020-06-17 | LaSalle | Illinois | 17099 | 183 | 16 |
243875 | 243875 | 2020-06-16 | LaSalle | Illinois | 17099 | 183 | 16 |
240764 | 240764 | 2020-06-15 | LaSalle | Illinois | 17099 | 181 | 16 |
237656 | 237656 | 2020-06-14 | LaSalle | Illinois | 17099 | 178 | 16 |
234549 | 234549 | 2020-06-13 | LaSalle | Illinois | 17099 | 177 | 16 |
231443 | 231443 | 2020-06-12 | LaSalle | Illinois | 17099 | 177 | 16 |
228340 | 228340 | 2020-06-11 | LaSalle | Illinois | 17099 | 175 | 16 |
225238 | 225238 | 2020-06-10 | LaSalle | Illinois | 17099 | 172 | 16 |
222143 | 222143 | 2020-06-09 | LaSalle | Illinois | 17099 | 168 | 16 |
219048 | 219048 | 2020-06-08 | LaSalle | Illinois | 17099 | 166 | 16 |
215957 | 215957 | 2020-06-07 | LaSalle | Illinois | 17099 | 164 | 16 |
212870 | 212870 | 2020-06-06 | LaSalle | Illinois | 17099 | 160 | 16 |
209785 | 209785 | 2020-06-05 | LaSalle | Illinois | 17099 | 160 | 16 |
206704 | 206704 | 2020-06-04 | LaSalle | Illinois | 17099 | 159 | 16 |
203624 | 203624 | 2020-06-03 | LaSalle | Illinois | 17099 | 157 | 14 |
200548 | 200548 | 2020-06-02 | LaSalle | Illinois | 17099 | 154 | 14 |
197475 | 197475 | 2020-06-01 | LaSalle | Illinois | 17099 | 153 | 13 |
194405 | 194405 | 2020-05-31 | LaSalle | Illinois | 17099 | 153 | 13 |
191338 | 191338 | 2020-05-30 | LaSalle | Illinois | 17099 | 150 | 13 |
188273 | 188273 | 2020-05-29 | LaSalle | Illinois | 17099 | 147 | 13 |
185215 | 185215 | 2020-05-28 | LaSalle | Illinois | 17099 | 141 | 13 |
182161 | 182161 | 2020-05-27 | LaSalle | Illinois | 17099 | 140 | 13 |
179117 | 179117 | 2020-05-26 | LaSalle | Illinois | 17099 | 140 | 13 |
176073 | 176073 | 2020-05-25 | LaSalle | Illinois | 17099 | 140 | 12 |
173029 | 173029 | 2020-05-24 | LaSalle | Illinois | 17099 | 139 | 10 |
169988 | 169988 | 2020-05-23 | LaSalle | Illinois | 17099 | 134 | 10 |
166951 | 166951 | 2020-05-22 | LaSalle | Illinois | 17099 | 130 | 10 |
163918 | 163918 | 2020-05-21 | LaSalle | Illinois | 17099 | 129 | 8 |
160890 | 160890 | 2020-05-20 | LaSalle | Illinois | 17099 | 130 | 8 |
157864 | 157864 | 2020-05-19 | LaSalle | Illinois | 17099 | 121 | 8 |
154848 | 154848 | 2020-05-18 | LaSalle | Illinois | 17099 | 121 | 8 |
151836 | 151836 | 2020-05-17 | LaSalle | Illinois | 17099 | 120 | 8 |
148827 | 148827 | 2020-05-16 | LaSalle | Illinois | 17099 | 121 | 8 |
145824 | 145824 | 2020-05-15 | LaSalle | Illinois | 17099 | 117 | 7 |
142824 | 142824 | 2020-05-14 | LaSalle | Illinois | 17099 | 113 | 5 |
139828 | 139828 | 2020-05-13 | LaSalle | Illinois | 17099 | 111 | 5 |
136836 | 136836 | 2020-05-12 | LaSalle | Illinois | 17099 | 106 | 5 |
133847 | 133847 | 2020-05-11 | LaSalle | Illinois | 17099 | 105 | 5 |
130856 | 130856 | 2020-05-10 | LaSalle | Illinois | 17099 | 105 | 5 |
127865 | 127865 | 2020-05-09 | LaSalle | Illinois | 17099 | 102 | 5 |
124878 | 124878 | 2020-05-08 | LaSalle | Illinois | 17099 | 93 | 3 |
121899 | 121899 | 2020-05-07 | LaSalle | Illinois | 17099 | 91 | 2 |
118929 | 118929 | 2020-05-06 | LaSalle | Illinois | 17099 | 84 | 2 |
115969 | 115969 | 2020-05-05 | LaSalle | Illinois | 17099 | 69 | 1 |
113086 | 113086 | 2020-05-04 | LaSalle | Illinois | 17099 | 70 | 1 |
110211 | 110211 | 2020-05-03 | LaSalle | Illinois | 17099 | 67 | 1 |
107341 | 107341 | 2020-05-02 | LaSalle | Illinois | 17099 | 65 | 1 |
104476 | 104476 | 2020-05-01 | LaSalle | Illinois | 17099 | 54 | 1 |
101620 | 101620 | 2020-04-30 | LaSalle | Illinois | 17099 | 53 | 1 |
98769 | 98769 | 2020-04-29 | LaSalle | Illinois | 17099 | 49 | 1 |
95925 | 95925 | 2020-04-28 | LaSalle | Illinois | 17099 | 49 | 1 |
93093 | 93093 | 2020-04-27 | LaSalle | Illinois | 17099 | 46 | 1 |
90274 | 90274 | 2020-04-26 | LaSalle | Illinois | 17099 | 44 | 1 |
87458 | 87458 | 2020-04-25 | LaSalle | Illinois | 17099 | 43 | 1 |
84648 | 84648 | 2020-04-24 | LaSalle | Illinois | 17099 | 42 | 1 |
81848 | 81848 | 2020-04-23 | LaSalle | Illinois | 17099 | 39 | 1 |
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);