ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
754 rows where fips = 17193 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535118 | 535118 | 2020-09-15 | White | Illinois | 17193 | 150 | 0 |
531883 | 531883 | 2020-09-14 | White | Illinois | 17193 | 149 | 0 |
528646 | 528646 | 2020-09-13 | White | Illinois | 17193 | 149 | 0 |
525410 | 525410 | 2020-09-12 | White | Illinois | 17193 | 147 | 0 |
522174 | 522174 | 2020-09-11 | White | Illinois | 17193 | 144 | 0 |
518937 | 518937 | 2020-09-10 | White | Illinois | 17193 | 145 | 0 |
515702 | 515702 | 2020-09-09 | White | Illinois | 17193 | 144 | 0 |
512469 | 512469 | 2020-09-08 | White | Illinois | 17193 | 144 | 0 |
509236 | 509236 | 2020-09-07 | White | Illinois | 17193 | 145 | 0 |
506004 | 506004 | 2020-09-06 | White | Illinois | 17193 | 144 | 0 |
502770 | 502770 | 2020-09-05 | White | Illinois | 17193 | 141 | 0 |
499536 | 499536 | 2020-09-04 | White | Illinois | 17193 | 139 | 0 |
496303 | 496303 | 2020-09-03 | White | Illinois | 17193 | 129 | 0 |
493069 | 493069 | 2020-09-02 | White | Illinois | 17193 | 128 | 0 |
489836 | 489836 | 2020-09-01 | White | Illinois | 17193 | 125 | 0 |
486603 | 486603 | 2020-08-31 | White | Illinois | 17193 | 123 | 0 |
483368 | 483368 | 2020-08-30 | White | Illinois | 17193 | 121 | 0 |
480134 | 480134 | 2020-08-29 | White | Illinois | 17193 | 119 | 0 |
476901 | 476901 | 2020-08-28 | White | Illinois | 17193 | 114 | 0 |
473668 | 473668 | 2020-08-27 | White | Illinois | 17193 | 114 | 0 |
470436 | 470436 | 2020-08-26 | White | Illinois | 17193 | 113 | 0 |
467207 | 467207 | 2020-08-25 | White | Illinois | 17193 | 113 | 0 |
463978 | 463978 | 2020-08-24 | White | Illinois | 17193 | 113 | 0 |
460749 | 460749 | 2020-08-23 | White | Illinois | 17193 | 112 | 0 |
457522 | 457522 | 2020-08-22 | White | Illinois | 17193 | 108 | 0 |
454294 | 454294 | 2020-08-21 | White | Illinois | 17193 | 102 | 0 |
451066 | 451066 | 2020-08-20 | White | Illinois | 17193 | 101 | 0 |
447838 | 447838 | 2020-08-19 | White | Illinois | 17193 | 98 | 0 |
444611 | 444611 | 2020-08-18 | White | Illinois | 17193 | 95 | 0 |
441385 | 441385 | 2020-08-17 | White | Illinois | 17193 | 87 | 0 |
438159 | 438159 | 2020-08-16 | White | Illinois | 17193 | 84 | 0 |
434933 | 434933 | 2020-08-15 | White | Illinois | 17193 | 80 | 0 |
431708 | 431708 | 2020-08-14 | White | Illinois | 17193 | 80 | 0 |
428480 | 428480 | 2020-08-13 | White | Illinois | 17193 | 75 | 0 |
425256 | 425256 | 2020-08-12 | White | Illinois | 17193 | 72 | 0 |
422035 | 422035 | 2020-08-11 | White | Illinois | 17193 | 71 | 0 |
418812 | 418812 | 2020-08-10 | White | Illinois | 17193 | 69 | 0 |
415591 | 415591 | 2020-08-09 | White | Illinois | 17193 | 68 | 0 |
412371 | 412371 | 2020-08-08 | White | Illinois | 17193 | 67 | 0 |
409152 | 409152 | 2020-08-07 | White | Illinois | 17193 | 64 | 0 |
405932 | 405932 | 2020-08-06 | White | Illinois | 17193 | 64 | 0 |
402714 | 402714 | 2020-08-05 | White | Illinois | 17193 | 61 | 0 |
399498 | 399498 | 2020-08-04 | White | Illinois | 17193 | 60 | 0 |
396282 | 396282 | 2020-08-03 | White | Illinois | 17193 | 58 | 0 |
393066 | 393066 | 2020-08-02 | White | Illinois | 17193 | 57 | 0 |
389849 | 389849 | 2020-08-01 | White | Illinois | 17193 | 57 | 0 |
386632 | 386632 | 2020-07-31 | White | Illinois | 17193 | 56 | 0 |
383414 | 383414 | 2020-07-30 | White | Illinois | 17193 | 55 | 0 |
380197 | 380197 | 2020-07-29 | White | Illinois | 17193 | 50 | 0 |
376980 | 376980 | 2020-07-28 | White | Illinois | 17193 | 49 | 0 |
373765 | 373765 | 2020-07-27 | White | Illinois | 17193 | 48 | 0 |
370553 | 370553 | 2020-07-26 | White | Illinois | 17193 | 48 | 0 |
367343 | 367343 | 2020-07-25 | White | Illinois | 17193 | 41 | 0 |
364136 | 364136 | 2020-07-24 | White | Illinois | 17193 | 38 | 0 |
360929 | 360929 | 2020-07-23 | White | Illinois | 17193 | 34 | 0 |
357724 | 357724 | 2020-07-22 | White | Illinois | 17193 | 33 | 0 |
354522 | 354522 | 2020-07-21 | White | Illinois | 17193 | 32 | 0 |
351320 | 351320 | 2020-07-20 | White | Illinois | 17193 | 31 | 0 |
348120 | 348120 | 2020-07-19 | White | Illinois | 17193 | 28 | 0 |
344919 | 344919 | 2020-07-18 | White | Illinois | 17193 | 24 | 0 |
341719 | 341719 | 2020-07-17 | White | Illinois | 17193 | 24 | 0 |
338523 | 338523 | 2020-07-16 | White | Illinois | 17193 | 22 | 0 |
335327 | 335327 | 2020-07-15 | White | Illinois | 17193 | 17 | 0 |
332134 | 332134 | 2020-07-14 | White | Illinois | 17193 | 10 | 0 |
328947 | 328947 | 2020-07-13 | White | Illinois | 17193 | 10 | 0 |
325761 | 325761 | 2020-07-12 | White | Illinois | 17193 | 10 | 0 |
322580 | 322580 | 2020-07-11 | White | Illinois | 17193 | 10 | 0 |
319401 | 319401 | 2020-07-10 | White | Illinois | 17193 | 9 | 0 |
316228 | 316228 | 2020-07-09 | White | Illinois | 17193 | 8 | 0 |
313054 | 313054 | 2020-07-08 | White | Illinois | 17193 | 9 | 0 |
309884 | 309884 | 2020-07-07 | White | Illinois | 17193 | 8 | 0 |
306716 | 306716 | 2020-07-06 | White | Illinois | 17193 | 8 | 0 |
303551 | 303551 | 2020-07-05 | White | Illinois | 17193 | 8 | 0 |
300387 | 300387 | 2020-07-04 | White | Illinois | 17193 | 6 | 0 |
297225 | 297225 | 2020-07-03 | White | Illinois | 17193 | 6 | 0 |
294067 | 294067 | 2020-07-02 | White | Illinois | 17193 | 5 | 0 |
290913 | 290913 | 2020-07-01 | White | Illinois | 17193 | 5 | 0 |
287763 | 287763 | 2020-06-30 | White | Illinois | 17193 | 4 | 0 |
284614 | 284614 | 2020-06-29 | White | Illinois | 17193 | 4 | 0 |
281469 | 281469 | 2020-06-28 | White | Illinois | 17193 | 4 | 0 |
278321 | 278321 | 2020-06-27 | White | Illinois | 17193 | 4 | 0 |
275173 | 275173 | 2020-06-26 | White | Illinois | 17193 | 4 | 0 |
272031 | 272031 | 2020-06-25 | White | Illinois | 17193 | 4 | 0 |
268894 | 268894 | 2020-06-24 | White | Illinois | 17193 | 3 | 0 |
265764 | 265764 | 2020-06-23 | White | Illinois | 17193 | 3 | 0 |
262636 | 262636 | 2020-06-22 | White | Illinois | 17193 | 3 | 0 |
259509 | 259509 | 2020-06-21 | White | Illinois | 17193 | 3 | 0 |
256383 | 256383 | 2020-06-20 | White | Illinois | 17193 | 3 | 0 |
253263 | 253263 | 2020-06-19 | White | Illinois | 17193 | 3 | 0 |
250148 | 250148 | 2020-06-18 | White | Illinois | 17193 | 3 | 0 |
247036 | 247036 | 2020-06-17 | White | Illinois | 17193 | 3 | 0 |
243923 | 243923 | 2020-06-16 | White | Illinois | 17193 | 3 | 0 |
240812 | 240812 | 2020-06-15 | White | Illinois | 17193 | 3 | 0 |
237704 | 237704 | 2020-06-14 | White | Illinois | 17193 | 3 | 0 |
234597 | 234597 | 2020-06-13 | White | Illinois | 17193 | 3 | 0 |
231491 | 231491 | 2020-06-12 | White | Illinois | 17193 | 2 | 0 |
228388 | 228388 | 2020-06-11 | White | Illinois | 17193 | 2 | 0 |
225286 | 225286 | 2020-06-10 | White | Illinois | 17193 | 2 | 0 |
222191 | 222191 | 2020-06-09 | White | Illinois | 17193 | 2 | 0 |
219096 | 219096 | 2020-06-08 | White | Illinois | 17193 | 2 | 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);