ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,566 rows where county = "LaSalle" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 241 ✖
- 0 118
- 46 97
- 37 77
- 1 51
- 10 36
- 33 36
- 36 36
- 56 28
- 16 26
- 5 24
- 45 24
- 2 23
- 7 23
- 17 22
- 38 22
- 41 20
- 23 19
- 39 19
- 20 18
- 57 18
- 18 17
- 34 17
- 49 17
- 60 17
- 439 16
- 35 15
- 44 14
- 53 14
- 351 14
- 436 14
- 24 13
- 59 13
- 305 13
- 307 13
- 308 12
- 440 11
- 52 10
- 54 10
- 278 10
- 58 9
- 282 9
- 309 9
- 336 9
- 345 9
- 346 9
- 8 8
- 22 8
- 302 8
- 303 8
- 322 8
- 330 8
- 4 7
- 13 7
- 51 7
- 247 7
- 279 7
- 298 7
- 319 7
- 320 7
- 340 7
- 342 7
- 349 7
- 434 7
- 11 6
- 21 6
- 28 6
- 61 6
- 230 6
- 429 6
- 432 6
- 257 5
- 274 5
- 281 5
- 283 5
- 304 5
- 314 5
- 386 5
- 430 5
- 47 4
- 48 4
- 63 4
- 250 4
- 267 4
- 277 4
- 287 4
- 289 4
- 294 4
- 299 4
- 301 4
- 311 4
- 313 4
- 337 4
- 363 4
- 376 4
- 393 4
- 422 4
- 435 4
- 438 4
- 441 4
- 3 3
- 29 3
- 55 3
- 119 3
- 153 3
- 219 3
- 255 3
- 265 3
- 269 3
- 288 3
- 300 3
- 326 3
- 333 3
- 344 3
- 347 3
- 354 3
- 403 3
- 410 3
- 418 3
- 431 3
- 437 3
- 12 2
- 14 2
- 31 2
- 32 2
- 43 2
- 50 2
- 65 2
- 68 2
- 69 2
- 70 2
- 87 2
- 100 2
- 133 2
- 144 2
- 237 2
- 240 2
- 244 2
- 252 2
- 260 2
- 271 2
- 273 2
- 286 2
- 296 2
- 327 2
- 343 2
- 348 2
- 358 2
- 369 2
- 380 2
- 406 2
- 416 2
- 420 2
- 428 2
- 25 1
- 26 1
- 27 1
- 30 1
- 42 1
- 67 1
- 73 1
- 79 1
- 80 1
- 81 1
- 82 1
- 88 1
- 90 1
- 91 1
- 95 1
- 107 1
- 111 1
- 116 1
- 127 1
- 130 1
- 132 1
- 134 1
- 136 1
- 139 1
- 149 1
- 160 1
- 163 1
- 167 1
- 169 1
- 176 1
- 177 1
- 178 1
- 182 1
- 184 1
- 189 1
- 192 1
- 199 1
- 200 1
- 202 1
- 210 1
- 212 1
- 217 1
- 221 1
- 222 1
- 235 1
- 239 1
- 245 1
- 248 1
- 249 1
- 258 1
- 263 1
- 266 1
- 270 1
- 275 1
- 276 1
- 280 1
- 285 1
- 290 1
- 292 1
- 293 1
- 295 1
- 306 1
- 310 1
- 321 1
- 328 1
- 334 1
- 335 1
- 338 1
- 352 1
- 353 1
- 360 1
- 370 1
- 378 1
- 387 1
- 388 1
- 390 1
- 395 1
- 396 1
- 398 1
- 404 1
- 409 1
- 414 1
- 415 1
- 421 1
- 425 1
- 427 1
- 433 1
- 442 1
county 1
- LaSalle · 1,566 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3931 | 3931 | 2020-03-18 | LaSalle | Illinois | 17099 | 1 | 0 |
4607 | 4607 | 2020-03-19 | LaSalle | Illinois | 17099 | 1 | 0 |
5412 | 5412 | 2020-03-20 | LaSalle | Illinois | 17099 | 1 | 0 |
6347 | 6347 | 2020-03-21 | LaSalle | Illinois | 17099 | 1 | 0 |
7398 | 7398 | 2020-03-22 | LaSalle | Illinois | 17099 | 1 | 0 |
8553 | 8553 | 2020-03-23 | LaSalle | Illinois | 17099 | 2 | 0 |
9817 | 9817 | 2020-03-24 | LaSalle | Illinois | 17099 | 3 | 0 |
11208 | 11208 | 2020-03-25 | LaSalle | Illinois | 17099 | 3 | 0 |
12764 | 12764 | 2020-03-26 | LaSalle | Illinois | 17099 | 3 | 0 |
14442 | 14442 | 2020-03-27 | LaSalle | Illinois | 17099 | 3 | 0 |
16237 | 16237 | 2020-03-28 | LaSalle | Illinois | 17099 | 4 | 1 |
18137 | 18137 | 2020-03-29 | LaSalle | Illinois | 17099 | 4 | 2 |
20139 | 20139 | 2020-03-30 | LaSalle | Illinois | 17099 | 5 | 2 |
22231 | 22231 | 2020-03-31 | LaSalle | Illinois | 17099 | 6 | 1 |
24399 | 24399 | 2020-04-01 | LaSalle | Illinois | 17099 | 6 | 1 |
26632 | 26632 | 2020-04-02 | LaSalle | Illinois | 17099 | 6 | 1 |
28942 | 28942 | 2020-04-03 | LaSalle | Illinois | 17099 | 6 | 1 |
31305 | 31305 | 2020-04-04 | LaSalle | Illinois | 17099 | 7 | 1 |
33715 | 33715 | 2020-04-05 | LaSalle | Illinois | 17099 | 8 | 1 |
36167 | 36167 | 2020-04-06 | LaSalle | Illinois | 17099 | 11 | 1 |
38662 | 38662 | 2020-04-07 | LaSalle | Illinois | 17099 | 15 | 1 |
41207 | 41207 | 2020-04-08 | LaSalle | Illinois | 17099 | 17 | 1 |
43781 | 43781 | 2020-04-09 | LaSalle | Illinois | 17099 | 17 | 1 |
46385 | 46385 | 2020-04-10 | LaSalle | Illinois | 17099 | 19 | 1 |
49016 | 49016 | 2020-04-11 | LaSalle | Illinois | 17099 | 18 | 1 |
51678 | 51678 | 2020-04-12 | LaSalle | Illinois | 17099 | 20 | 1 |
54359 | 54359 | 2020-04-13 | LaSalle | Illinois | 17099 | 21 | 1 |
57052 | 57052 | 2020-04-14 | LaSalle | Illinois | 17099 | 23 | 1 |
59759 | 59759 | 2020-04-15 | LaSalle | Illinois | 17099 | 24 | 1 |
62480 | 62480 | 2020-04-16 | LaSalle | Illinois | 17099 | 25 | 1 |
65213 | 65213 | 2020-04-17 | LaSalle | Illinois | 17099 | 27 | 1 |
67962 | 67962 | 2020-04-18 | LaSalle | Illinois | 17099 | 27 | 1 |
70724 | 70724 | 2020-04-19 | LaSalle | Illinois | 17099 | 28 | 1 |
73494 | 73494 | 2020-04-20 | LaSalle | Illinois | 17099 | 30 | 1 |
76271 | 76271 | 2020-04-21 | LaSalle | Illinois | 17099 | 33 | 1 |
79055 | 79055 | 2020-04-22 | LaSalle | Illinois | 17099 | 38 | 1 |
81848 | 81848 | 2020-04-23 | LaSalle | Illinois | 17099 | 39 | 1 |
84648 | 84648 | 2020-04-24 | LaSalle | Illinois | 17099 | 42 | 1 |
87458 | 87458 | 2020-04-25 | LaSalle | Illinois | 17099 | 43 | 1 |
90274 | 90274 | 2020-04-26 | LaSalle | Illinois | 17099 | 44 | 1 |
93093 | 93093 | 2020-04-27 | LaSalle | Illinois | 17099 | 46 | 1 |
95925 | 95925 | 2020-04-28 | LaSalle | Illinois | 17099 | 49 | 1 |
98769 | 98769 | 2020-04-29 | LaSalle | Illinois | 17099 | 49 | 1 |
101620 | 101620 | 2020-04-30 | LaSalle | Illinois | 17099 | 53 | 1 |
104476 | 104476 | 2020-05-01 | LaSalle | Illinois | 17099 | 54 | 1 |
107341 | 107341 | 2020-05-02 | LaSalle | Illinois | 17099 | 65 | 1 |
110211 | 110211 | 2020-05-03 | LaSalle | Illinois | 17099 | 67 | 1 |
113086 | 113086 | 2020-05-04 | LaSalle | Illinois | 17099 | 70 | 1 |
115969 | 115969 | 2020-05-05 | LaSalle | Illinois | 17099 | 69 | 1 |
118929 | 118929 | 2020-05-06 | LaSalle | Illinois | 17099 | 84 | 2 |
121899 | 121899 | 2020-05-07 | LaSalle | Illinois | 17099 | 91 | 2 |
124878 | 124878 | 2020-05-08 | LaSalle | Illinois | 17099 | 93 | 3 |
127865 | 127865 | 2020-05-09 | LaSalle | Illinois | 17099 | 102 | 5 |
130856 | 130856 | 2020-05-10 | LaSalle | Illinois | 17099 | 105 | 5 |
133847 | 133847 | 2020-05-11 | LaSalle | Illinois | 17099 | 105 | 5 |
136836 | 136836 | 2020-05-12 | LaSalle | Illinois | 17099 | 106 | 5 |
139828 | 139828 | 2020-05-13 | LaSalle | Illinois | 17099 | 111 | 5 |
142824 | 142824 | 2020-05-14 | LaSalle | Illinois | 17099 | 113 | 5 |
145824 | 145824 | 2020-05-15 | LaSalle | Illinois | 17099 | 117 | 7 |
148827 | 148827 | 2020-05-16 | LaSalle | Illinois | 17099 | 121 | 8 |
151836 | 151836 | 2020-05-17 | LaSalle | Illinois | 17099 | 120 | 8 |
154848 | 154848 | 2020-05-18 | LaSalle | Illinois | 17099 | 121 | 8 |
157864 | 157864 | 2020-05-19 | LaSalle | Illinois | 17099 | 121 | 8 |
160890 | 160890 | 2020-05-20 | LaSalle | Illinois | 17099 | 130 | 8 |
163918 | 163918 | 2020-05-21 | LaSalle | Illinois | 17099 | 129 | 8 |
166951 | 166951 | 2020-05-22 | LaSalle | Illinois | 17099 | 130 | 10 |
169988 | 169988 | 2020-05-23 | LaSalle | Illinois | 17099 | 134 | 10 |
173029 | 173029 | 2020-05-24 | LaSalle | Illinois | 17099 | 139 | 10 |
176073 | 176073 | 2020-05-25 | LaSalle | Illinois | 17099 | 140 | 12 |
179117 | 179117 | 2020-05-26 | LaSalle | Illinois | 17099 | 140 | 13 |
182161 | 182161 | 2020-05-27 | LaSalle | Illinois | 17099 | 140 | 13 |
185215 | 185215 | 2020-05-28 | LaSalle | Illinois | 17099 | 141 | 13 |
188273 | 188273 | 2020-05-29 | LaSalle | Illinois | 17099 | 147 | 13 |
191338 | 191338 | 2020-05-30 | LaSalle | Illinois | 17099 | 150 | 13 |
194405 | 194405 | 2020-05-31 | LaSalle | Illinois | 17099 | 153 | 13 |
197475 | 197475 | 2020-06-01 | LaSalle | Illinois | 17099 | 153 | 13 |
200548 | 200548 | 2020-06-02 | LaSalle | Illinois | 17099 | 154 | 14 |
203624 | 203624 | 2020-06-03 | LaSalle | Illinois | 17099 | 157 | 14 |
206704 | 206704 | 2020-06-04 | LaSalle | Illinois | 17099 | 159 | 16 |
209785 | 209785 | 2020-06-05 | LaSalle | Illinois | 17099 | 160 | 16 |
212870 | 212870 | 2020-06-06 | LaSalle | Illinois | 17099 | 160 | 16 |
215957 | 215957 | 2020-06-07 | LaSalle | Illinois | 17099 | 164 | 16 |
219048 | 219048 | 2020-06-08 | LaSalle | Illinois | 17099 | 166 | 16 |
222143 | 222143 | 2020-06-09 | LaSalle | Illinois | 17099 | 168 | 16 |
225238 | 225238 | 2020-06-10 | LaSalle | Illinois | 17099 | 172 | 16 |
228340 | 228340 | 2020-06-11 | LaSalle | Illinois | 17099 | 175 | 16 |
231443 | 231443 | 2020-06-12 | LaSalle | Illinois | 17099 | 177 | 16 |
234549 | 234549 | 2020-06-13 | LaSalle | Illinois | 17099 | 177 | 16 |
237656 | 237656 | 2020-06-14 | LaSalle | Illinois | 17099 | 178 | 16 |
240764 | 240764 | 2020-06-15 | LaSalle | Illinois | 17099 | 181 | 16 |
243875 | 243875 | 2020-06-16 | LaSalle | Illinois | 17099 | 183 | 16 |
246988 | 246988 | 2020-06-17 | LaSalle | Illinois | 17099 | 183 | 16 |
250100 | 250100 | 2020-06-18 | LaSalle | Illinois | 17099 | 189 | 16 |
253215 | 253215 | 2020-06-19 | LaSalle | Illinois | 17099 | 188 | 16 |
256335 | 256335 | 2020-06-20 | LaSalle | Illinois | 17099 | 188 | 16 |
259461 | 259461 | 2020-06-21 | LaSalle | Illinois | 17099 | 190 | 16 |
262588 | 262588 | 2020-06-22 | LaSalle | Illinois | 17099 | 190 | 16 |
265716 | 265716 | 2020-06-23 | LaSalle | Illinois | 17099 | 191 | 16 |
268846 | 268846 | 2020-06-24 | LaSalle | Illinois | 17099 | 195 | 16 |
271983 | 271983 | 2020-06-25 | LaSalle | Illinois | 17099 | 199 | 17 |
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);