ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 17099 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535069 | 535069 | 2020-09-15 | LaSalle | Illinois | 17099 | 1518 | 54 |
531834 | 531834 | 2020-09-14 | LaSalle | Illinois | 17099 | 1508 | 54 |
528597 | 528597 | 2020-09-13 | LaSalle | Illinois | 17099 | 1496 | 54 |
525361 | 525361 | 2020-09-12 | LaSalle | Illinois | 17099 | 1475 | 54 |
522125 | 522125 | 2020-09-11 | LaSalle | Illinois | 17099 | 1457 | 54 |
518888 | 518888 | 2020-09-10 | LaSalle | Illinois | 17099 | 1429 | 54 |
515653 | 515653 | 2020-09-09 | LaSalle | Illinois | 17099 | 1419 | 54 |
512420 | 512420 | 2020-09-08 | LaSalle | Illinois | 17099 | 1413 | 53 |
509187 | 509187 | 2020-09-07 | LaSalle | Illinois | 17099 | 1406 | 53 |
505955 | 505955 | 2020-09-06 | LaSalle | Illinois | 17099 | 1399 | 52 |
502721 | 502721 | 2020-09-05 | LaSalle | Illinois | 17099 | 1376 | 52 |
499487 | 499487 | 2020-09-04 | LaSalle | Illinois | 17099 | 1357 | 52 |
496254 | 496254 | 2020-09-03 | LaSalle | Illinois | 17099 | 1302 | 51 |
493020 | 493020 | 2020-09-02 | LaSalle | Illinois | 17099 | 1291 | 50 |
489787 | 489787 | 2020-09-01 | LaSalle | Illinois | 17099 | 1273 | 48 |
486554 | 486554 | 2020-08-31 | LaSalle | Illinois | 17099 | 1256 | 45 |
483319 | 483319 | 2020-08-30 | LaSalle | Illinois | 17099 | 1237 | 45 |
480085 | 480085 | 2020-08-29 | LaSalle | Illinois | 17099 | 1219 | 45 |
476852 | 476852 | 2020-08-28 | LaSalle | Illinois | 17099 | 1203 | 45 |
473619 | 473619 | 2020-08-27 | LaSalle | Illinois | 17099 | 1180 | 45 |
470387 | 470387 | 2020-08-26 | LaSalle | Illinois | 17099 | 1148 | 43 |
467158 | 467158 | 2020-08-25 | LaSalle | Illinois | 17099 | 1128 | 42 |
463929 | 463929 | 2020-08-24 | LaSalle | Illinois | 17099 | 1115 | 39 |
460700 | 460700 | 2020-08-23 | LaSalle | Illinois | 17099 | 1093 | 39 |
457473 | 457473 | 2020-08-22 | LaSalle | Illinois | 17099 | 1085 | 39 |
454245 | 454245 | 2020-08-21 | LaSalle | Illinois | 17099 | 1063 | 39 |
451017 | 451017 | 2020-08-20 | LaSalle | Illinois | 17099 | 1031 | 38 |
447789 | 447789 | 2020-08-19 | LaSalle | Illinois | 17099 | 1008 | 37 |
444562 | 444562 | 2020-08-18 | LaSalle | Illinois | 17099 | 992 | 34 |
441336 | 441336 | 2020-08-17 | LaSalle | Illinois | 17099 | 960 | 33 |
438110 | 438110 | 2020-08-16 | LaSalle | Illinois | 17099 | 953 | 30 |
434884 | 434884 | 2020-08-15 | LaSalle | Illinois | 17099 | 932 | 29 |
431659 | 431659 | 2020-08-14 | LaSalle | Illinois | 17099 | 910 | 28 |
428431 | 428431 | 2020-08-13 | LaSalle | Illinois | 17099 | 878 | 28 |
425207 | 425207 | 2020-08-12 | LaSalle | Illinois | 17099 | 825 | 25 |
421986 | 421986 | 2020-08-11 | LaSalle | Illinois | 17099 | 801 | 24 |
418763 | 418763 | 2020-08-10 | LaSalle | Illinois | 17099 | 783 | 24 |
415542 | 415542 | 2020-08-09 | LaSalle | Illinois | 17099 | 766 | 24 |
412322 | 412322 | 2020-08-08 | LaSalle | Illinois | 17099 | 739 | 24 |
409103 | 409103 | 2020-08-07 | LaSalle | Illinois | 17099 | 684 | 24 |
405883 | 405883 | 2020-08-06 | LaSalle | Illinois | 17099 | 666 | 21 |
402665 | 402665 | 2020-08-05 | LaSalle | Illinois | 17099 | 590 | 21 |
399449 | 399449 | 2020-08-04 | LaSalle | Illinois | 17099 | 577 | 20 |
396233 | 396233 | 2020-08-03 | LaSalle | Illinois | 17099 | 560 | 20 |
393017 | 393017 | 2020-08-02 | LaSalle | Illinois | 17099 | 515 | 18 |
389800 | 389800 | 2020-08-01 | LaSalle | Illinois | 17099 | 497 | 18 |
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 |
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);