ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 226 ✖
- 1 37
- 17 22
- 16 21
- 18 17
- 439 16
- 57 14
- 351 14
- 436 14
- 305 13
- 307 13
- 308 12
- 440 11
- 0 10
- 54 10
- 278 10
- 282 9
- 309 9
- 336 9
- 345 9
- 346 9
- 302 8
- 303 8
- 322 8
- 330 8
- 13 7
- 58 7
- 247 7
- 279 7
- 298 7
- 319 7
- 320 7
- 340 7
- 342 7
- 349 7
- 434 7
- 5 6
- 8 6
- 230 6
- 429 6
- 432 6
- 24 5
- 45 5
- 257 5
- 274 5
- 281 5
- 283 5
- 304 5
- 314 5
- 386 5
- 430 5
- 2 4
- 39 4
- 56 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
- 10 3
- 52 3
- 55 3
- 60 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
- 14 2
- 20 2
- 21 2
- 28 2
- 53 2
- 59 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
- 3 1
- 7 1
- 12 1
- 25 1
- 29 1
- 30 1
- 33 1
- 34 1
- 37 1
- 38 1
- 42 1
- 43 1
- 48 1
- 50 1
- 51 1
- 61 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
state 1
- Illinois 787
fips 1
- 17099 · 787 ✖
county 1
- LaSalle 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500225 | 2500225 | 2022-05-13 | LaSalle | Illinois | 17099 | 29734 | 442 |
2496967 | 2496967 | 2022-05-12 | LaSalle | Illinois | 17099 | 29656 | 441 |
2493709 | 2493709 | 2022-05-11 | LaSalle | Illinois | 17099 | 29627 | 441 |
2490451 | 2490451 | 2022-05-10 | LaSalle | Illinois | 17099 | 29579 | 441 |
2487194 | 2487194 | 2022-05-09 | LaSalle | Illinois | 17099 | 29528 | 441 |
2483936 | 2483936 | 2022-05-08 | LaSalle | Illinois | 17099 | 29421 | 440 |
2480678 | 2480678 | 2022-05-07 | LaSalle | Illinois | 17099 | 29421 | 440 |
2477420 | 2477420 | 2022-05-06 | LaSalle | Illinois | 17099 | 29421 | 440 |
2474162 | 2474162 | 2022-05-05 | LaSalle | Illinois | 17099 | 29364 | 440 |
2470905 | 2470905 | 2022-05-04 | LaSalle | Illinois | 17099 | 29334 | 440 |
2467649 | 2467649 | 2022-05-03 | LaSalle | Illinois | 17099 | 29287 | 440 |
2464394 | 2464394 | 2022-05-02 | LaSalle | Illinois | 17099 | 29264 | 440 |
2461138 | 2461138 | 2022-05-01 | LaSalle | Illinois | 17099 | 29216 | 440 |
2457882 | 2457882 | 2022-04-30 | LaSalle | Illinois | 17099 | 29216 | 440 |
2454626 | 2454626 | 2022-04-29 | LaSalle | Illinois | 17099 | 29216 | 440 |
2451370 | 2451370 | 2022-04-28 | LaSalle | Illinois | 17099 | 29178 | 440 |
2448114 | 2448114 | 2022-04-27 | LaSalle | Illinois | 17099 | 29159 | 439 |
2444858 | 2444858 | 2022-04-26 | LaSalle | Illinois | 17099 | 29146 | 439 |
2441602 | 2441602 | 2022-04-25 | LaSalle | Illinois | 17099 | 29131 | 439 |
2438346 | 2438346 | 2022-04-24 | LaSalle | Illinois | 17099 | 29098 | 439 |
2435090 | 2435090 | 2022-04-23 | LaSalle | Illinois | 17099 | 29098 | 439 |
2431834 | 2431834 | 2022-04-22 | LaSalle | Illinois | 17099 | 29098 | 439 |
2428578 | 2428578 | 2022-04-21 | LaSalle | Illinois | 17099 | 29083 | 439 |
2425322 | 2425322 | 2022-04-20 | LaSalle | Illinois | 17099 | 29064 | 439 |
2422066 | 2422066 | 2022-04-19 | LaSalle | Illinois | 17099 | 29042 | 439 |
2418810 | 2418810 | 2022-04-18 | LaSalle | Illinois | 17099 | 29033 | 439 |
2415554 | 2415554 | 2022-04-17 | LaSalle | Illinois | 17099 | 29012 | 439 |
2412298 | 2412298 | 2022-04-16 | LaSalle | Illinois | 17099 | 29012 | 439 |
2409042 | 2409042 | 2022-04-15 | LaSalle | Illinois | 17099 | 29012 | 439 |
2405786 | 2405786 | 2022-04-14 | LaSalle | Illinois | 17099 | 28998 | 439 |
2402531 | 2402531 | 2022-04-13 | LaSalle | Illinois | 17099 | 28985 | 439 |
2399276 | 2399276 | 2022-04-12 | LaSalle | Illinois | 17099 | 28977 | 439 |
2396021 | 2396021 | 2022-04-11 | LaSalle | Illinois | 17099 | 28969 | 438 |
2392765 | 2392765 | 2022-04-10 | LaSalle | Illinois | 17099 | 28931 | 438 |
2389509 | 2389509 | 2022-04-09 | LaSalle | Illinois | 17099 | 28931 | 438 |
2386254 | 2386254 | 2022-04-08 | LaSalle | Illinois | 17099 | 28931 | 438 |
2382999 | 2382999 | 2022-04-07 | LaSalle | Illinois | 17099 | 28908 | 437 |
2379744 | 2379744 | 2022-04-06 | LaSalle | Illinois | 17099 | 28902 | 437 |
2376490 | 2376490 | 2022-04-05 | LaSalle | Illinois | 17099 | 28888 | 437 |
2373238 | 2373238 | 2022-04-04 | LaSalle | Illinois | 17099 | 28877 | 436 |
2369985 | 2369985 | 2022-04-03 | LaSalle | Illinois | 17099 | 28864 | 436 |
2366732 | 2366732 | 2022-04-02 | LaSalle | Illinois | 17099 | 28864 | 436 |
2363479 | 2363479 | 2022-04-01 | LaSalle | Illinois | 17099 | 28864 | 436 |
2360225 | 2360225 | 2022-03-31 | LaSalle | Illinois | 17099 | 28853 | 436 |
2356971 | 2356971 | 2022-03-30 | LaSalle | Illinois | 17099 | 28844 | 436 |
2353718 | 2353718 | 2022-03-29 | LaSalle | Illinois | 17099 | 28838 | 436 |
2350466 | 2350466 | 2022-03-28 | LaSalle | Illinois | 17099 | 28829 | 436 |
2347213 | 2347213 | 2022-03-27 | LaSalle | Illinois | 17099 | 28819 | 436 |
2343960 | 2343960 | 2022-03-26 | LaSalle | Illinois | 17099 | 28819 | 436 |
2340707 | 2340707 | 2022-03-25 | LaSalle | Illinois | 17099 | 28819 | 436 |
2337454 | 2337454 | 2022-03-24 | LaSalle | Illinois | 17099 | 28817 | 436 |
2334200 | 2334200 | 2022-03-23 | LaSalle | Illinois | 17099 | 28809 | 436 |
2330946 | 2330946 | 2022-03-22 | LaSalle | Illinois | 17099 | 28804 | 436 |
2327694 | 2327694 | 2022-03-21 | LaSalle | Illinois | 17099 | 28797 | 435 |
2324441 | 2324441 | 2022-03-20 | LaSalle | Illinois | 17099 | 28777 | 435 |
2321187 | 2321187 | 2022-03-19 | LaSalle | Illinois | 17099 | 28777 | 435 |
2317933 | 2317933 | 2022-03-18 | LaSalle | Illinois | 17099 | 28777 | 435 |
2314680 | 2314680 | 2022-03-17 | LaSalle | Illinois | 17099 | 28764 | 434 |
2311427 | 2311427 | 2022-03-16 | LaSalle | Illinois | 17099 | 28755 | 434 |
2308174 | 2308174 | 2022-03-15 | LaSalle | Illinois | 17099 | 28743 | 434 |
2304923 | 2304923 | 2022-03-14 | LaSalle | Illinois | 17099 | 28729 | 434 |
2301671 | 2301671 | 2022-03-13 | LaSalle | Illinois | 17099 | 28709 | 434 |
2298419 | 2298419 | 2022-03-12 | LaSalle | Illinois | 17099 | 28709 | 434 |
2295167 | 2295167 | 2022-03-11 | LaSalle | Illinois | 17099 | 28709 | 434 |
2291915 | 2291915 | 2022-03-10 | LaSalle | Illinois | 17099 | 28701 | 433 |
2288663 | 2288663 | 2022-03-09 | LaSalle | Illinois | 17099 | 28689 | 432 |
2285412 | 2285412 | 2022-03-08 | LaSalle | Illinois | 17099 | 28678 | 432 |
2282160 | 2282160 | 2022-03-07 | LaSalle | Illinois | 17099 | 28669 | 432 |
2278907 | 2278907 | 2022-03-06 | LaSalle | Illinois | 17099 | 28634 | 432 |
2275654 | 2275654 | 2022-03-05 | LaSalle | Illinois | 17099 | 28634 | 432 |
2272401 | 2272401 | 2022-03-04 | LaSalle | Illinois | 17099 | 28634 | 432 |
2269149 | 2269149 | 2022-03-03 | LaSalle | Illinois | 17099 | 28622 | 431 |
2265896 | 2265896 | 2022-03-02 | LaSalle | Illinois | 17099 | 28605 | 431 |
2262645 | 2262645 | 2022-03-01 | LaSalle | Illinois | 17099 | 28581 | 431 |
2259394 | 2259394 | 2022-02-28 | LaSalle | Illinois | 17099 | 28569 | 430 |
2256143 | 2256143 | 2022-02-27 | LaSalle | Illinois | 17099 | 28533 | 430 |
2252892 | 2252892 | 2022-02-26 | LaSalle | Illinois | 17099 | 28533 | 430 |
2249641 | 2249641 | 2022-02-25 | LaSalle | Illinois | 17099 | 28533 | 430 |
2246390 | 2246390 | 2022-02-24 | LaSalle | Illinois | 17099 | 28509 | 430 |
2243139 | 2243139 | 2022-02-23 | LaSalle | Illinois | 17099 | 28482 | 429 |
2239888 | 2239888 | 2022-02-22 | LaSalle | Illinois | 17099 | 28460 | 429 |
2236637 | 2236637 | 2022-02-21 | LaSalle | Illinois | 17099 | 28390 | 429 |
2233386 | 2233386 | 2022-02-20 | LaSalle | Illinois | 17099 | 28390 | 429 |
2230135 | 2230135 | 2022-02-19 | LaSalle | Illinois | 17099 | 28390 | 429 |
2226884 | 2226884 | 2022-02-18 | LaSalle | Illinois | 17099 | 28390 | 429 |
2223633 | 2223633 | 2022-02-17 | LaSalle | Illinois | 17099 | 28352 | 428 |
2220382 | 2220382 | 2022-02-16 | LaSalle | Illinois | 17099 | 28319 | 428 |
2217131 | 2217131 | 2022-02-15 | LaSalle | Illinois | 17099 | 28258 | 427 |
2213880 | 2213880 | 2022-02-14 | LaSalle | Illinois | 17099 | 28220 | 425 |
2210628 | 2210628 | 2022-02-13 | LaSalle | Illinois | 17099 | 28063 | 422 |
2207375 | 2207375 | 2022-02-12 | LaSalle | Illinois | 17099 | 28063 | 422 |
2204122 | 2204122 | 2022-02-11 | LaSalle | Illinois | 17099 | 28063 | 422 |
2200869 | 2200869 | 2022-02-10 | LaSalle | Illinois | 17099 | 28063 | 422 |
2197615 | 2197615 | 2022-02-09 | LaSalle | Illinois | 17099 | 27986 | 421 |
2194361 | 2194361 | 2022-02-08 | LaSalle | Illinois | 17099 | 27950 | 420 |
2191107 | 2191107 | 2022-02-07 | LaSalle | Illinois | 17099 | 27880 | 420 |
2187854 | 2187854 | 2022-02-06 | LaSalle | Illinois | 17099 | 27740 | 418 |
2184601 | 2184601 | 2022-02-05 | LaSalle | Illinois | 17099 | 27740 | 418 |
2181349 | 2181349 | 2022-02-04 | LaSalle | Illinois | 17099 | 27740 | 418 |
2178098 | 2178098 | 2022-02-03 | LaSalle | Illinois | 17099 | 27644 | 416 |
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);