ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 17083 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535062 | 535062 | 2020-09-15 | Jersey | Illinois | 17083 | 361 | 13 |
531827 | 531827 | 2020-09-14 | Jersey | Illinois | 17083 | 360 | 12 |
528590 | 528590 | 2020-09-13 | Jersey | Illinois | 17083 | 356 | 12 |
525354 | 525354 | 2020-09-12 | Jersey | Illinois | 17083 | 353 | 12 |
522118 | 522118 | 2020-09-11 | Jersey | Illinois | 17083 | 349 | 12 |
518881 | 518881 | 2020-09-10 | Jersey | Illinois | 17083 | 333 | 11 |
515646 | 515646 | 2020-09-09 | Jersey | Illinois | 17083 | 326 | 7 |
512413 | 512413 | 2020-09-08 | Jersey | Illinois | 17083 | 324 | 6 |
509180 | 509180 | 2020-09-07 | Jersey | Illinois | 17083 | 321 | 6 |
505948 | 505948 | 2020-09-06 | Jersey | Illinois | 17083 | 320 | 6 |
502714 | 502714 | 2020-09-05 | Jersey | Illinois | 17083 | 317 | 6 |
499480 | 499480 | 2020-09-04 | Jersey | Illinois | 17083 | 315 | 6 |
496247 | 496247 | 2020-09-03 | Jersey | Illinois | 17083 | 285 | 6 |
493013 | 493013 | 2020-09-02 | Jersey | Illinois | 17083 | 285 | 6 |
489780 | 489780 | 2020-09-01 | Jersey | Illinois | 17083 | 278 | 6 |
486547 | 486547 | 2020-08-31 | Jersey | Illinois | 17083 | 276 | 6 |
483312 | 483312 | 2020-08-30 | Jersey | Illinois | 17083 | 275 | 6 |
480078 | 480078 | 2020-08-29 | Jersey | Illinois | 17083 | 275 | 6 |
476845 | 476845 | 2020-08-28 | Jersey | Illinois | 17083 | 271 | 5 |
473612 | 473612 | 2020-08-27 | Jersey | Illinois | 17083 | 264 | 3 |
470380 | 470380 | 2020-08-26 | Jersey | Illinois | 17083 | 246 | 3 |
467151 | 467151 | 2020-08-25 | Jersey | Illinois | 17083 | 239 | 3 |
463922 | 463922 | 2020-08-24 | Jersey | Illinois | 17083 | 229 | 2 |
460693 | 460693 | 2020-08-23 | Jersey | Illinois | 17083 | 223 | 2 |
457466 | 457466 | 2020-08-22 | Jersey | Illinois | 17083 | 213 | 2 |
454238 | 454238 | 2020-08-21 | Jersey | Illinois | 17083 | 206 | 2 |
451010 | 451010 | 2020-08-20 | Jersey | Illinois | 17083 | 199 | 2 |
447782 | 447782 | 2020-08-19 | Jersey | Illinois | 17083 | 174 | 2 |
444555 | 444555 | 2020-08-18 | Jersey | Illinois | 17083 | 173 | 2 |
441329 | 441329 | 2020-08-17 | Jersey | Illinois | 17083 | 157 | 2 |
438103 | 438103 | 2020-08-16 | Jersey | Illinois | 17083 | 151 | 2 |
434877 | 434877 | 2020-08-15 | Jersey | Illinois | 17083 | 145 | 2 |
431652 | 431652 | 2020-08-14 | Jersey | Illinois | 17083 | 143 | 2 |
428424 | 428424 | 2020-08-13 | Jersey | Illinois | 17083 | 141 | 2 |
425200 | 425200 | 2020-08-12 | Jersey | Illinois | 17083 | 122 | 2 |
421979 | 421979 | 2020-08-11 | Jersey | Illinois | 17083 | 117 | 2 |
418756 | 418756 | 2020-08-10 | Jersey | Illinois | 17083 | 115 | 2 |
415535 | 415535 | 2020-08-09 | Jersey | Illinois | 17083 | 105 | 2 |
412315 | 412315 | 2020-08-08 | Jersey | Illinois | 17083 | 104 | 2 |
409096 | 409096 | 2020-08-07 | Jersey | Illinois | 17083 | 98 | 2 |
405876 | 405876 | 2020-08-06 | Jersey | Illinois | 17083 | 85 | 1 |
402658 | 402658 | 2020-08-05 | Jersey | Illinois | 17083 | 74 | 1 |
399442 | 399442 | 2020-08-04 | Jersey | Illinois | 17083 | 73 | 1 |
396226 | 396226 | 2020-08-03 | Jersey | Illinois | 17083 | 70 | 1 |
393010 | 393010 | 2020-08-02 | Jersey | Illinois | 17083 | 69 | 1 |
389793 | 389793 | 2020-08-01 | Jersey | Illinois | 17083 | 65 | 1 |
386576 | 386576 | 2020-07-31 | Jersey | Illinois | 17083 | 62 | 1 |
383358 | 383358 | 2020-07-30 | Jersey | Illinois | 17083 | 61 | 1 |
380141 | 380141 | 2020-07-29 | Jersey | Illinois | 17083 | 59 | 1 |
376924 | 376924 | 2020-07-28 | Jersey | Illinois | 17083 | 59 | 1 |
373709 | 373709 | 2020-07-27 | Jersey | Illinois | 17083 | 59 | 1 |
370497 | 370497 | 2020-07-26 | Jersey | Illinois | 17083 | 59 | 1 |
367287 | 367287 | 2020-07-25 | Jersey | Illinois | 17083 | 59 | 1 |
364080 | 364080 | 2020-07-24 | Jersey | Illinois | 17083 | 58 | 1 |
360873 | 360873 | 2020-07-23 | Jersey | Illinois | 17083 | 57 | 1 |
357668 | 357668 | 2020-07-22 | Jersey | Illinois | 17083 | 56 | 1 |
354466 | 354466 | 2020-07-21 | Jersey | Illinois | 17083 | 54 | 1 |
351264 | 351264 | 2020-07-20 | Jersey | Illinois | 17083 | 54 | 1 |
348064 | 348064 | 2020-07-19 | Jersey | Illinois | 17083 | 52 | 1 |
344863 | 344863 | 2020-07-18 | Jersey | Illinois | 17083 | 51 | 1 |
341663 | 341663 | 2020-07-17 | Jersey | Illinois | 17083 | 51 | 1 |
338467 | 338467 | 2020-07-16 | Jersey | Illinois | 17083 | 50 | 1 |
335271 | 335271 | 2020-07-15 | Jersey | Illinois | 17083 | 48 | 1 |
332078 | 332078 | 2020-07-14 | Jersey | Illinois | 17083 | 45 | 1 |
328891 | 328891 | 2020-07-13 | Jersey | Illinois | 17083 | 44 | 1 |
325705 | 325705 | 2020-07-12 | Jersey | Illinois | 17083 | 43 | 1 |
322524 | 322524 | 2020-07-11 | Jersey | Illinois | 17083 | 40 | 1 |
319345 | 319345 | 2020-07-10 | Jersey | Illinois | 17083 | 40 | 1 |
316172 | 316172 | 2020-07-09 | Jersey | Illinois | 17083 | 38 | 1 |
312998 | 312998 | 2020-07-08 | Jersey | Illinois | 17083 | 37 | 1 |
309828 | 309828 | 2020-07-07 | Jersey | Illinois | 17083 | 36 | 1 |
306660 | 306660 | 2020-07-06 | Jersey | Illinois | 17083 | 35 | 1 |
303495 | 303495 | 2020-07-05 | Jersey | Illinois | 17083 | 35 | 1 |
300331 | 300331 | 2020-07-04 | Jersey | Illinois | 17083 | 35 | 1 |
297169 | 297169 | 2020-07-03 | Jersey | Illinois | 17083 | 35 | 1 |
294012 | 294012 | 2020-07-02 | Jersey | Illinois | 17083 | 35 | 1 |
290858 | 290858 | 2020-07-01 | Jersey | Illinois | 17083 | 35 | 1 |
287708 | 287708 | 2020-06-30 | Jersey | Illinois | 17083 | 35 | 1 |
284559 | 284559 | 2020-06-29 | Jersey | Illinois | 17083 | 35 | 1 |
281414 | 281414 | 2020-06-28 | Jersey | Illinois | 17083 | 35 | 1 |
278266 | 278266 | 2020-06-27 | Jersey | Illinois | 17083 | 35 | 1 |
275118 | 275118 | 2020-06-26 | Jersey | Illinois | 17083 | 35 | 1 |
271976 | 271976 | 2020-06-25 | Jersey | Illinois | 17083 | 34 | 1 |
268839 | 268839 | 2020-06-24 | Jersey | Illinois | 17083 | 33 | 1 |
265709 | 265709 | 2020-06-23 | Jersey | Illinois | 17083 | 32 | 1 |
262581 | 262581 | 2020-06-22 | Jersey | Illinois | 17083 | 33 | 1 |
259454 | 259454 | 2020-06-21 | Jersey | Illinois | 17083 | 31 | 1 |
256328 | 256328 | 2020-06-20 | Jersey | Illinois | 17083 | 29 | 1 |
253208 | 253208 | 2020-06-19 | Jersey | Illinois | 17083 | 29 | 1 |
250093 | 250093 | 2020-06-18 | Jersey | Illinois | 17083 | 29 | 1 |
246981 | 246981 | 2020-06-17 | Jersey | Illinois | 17083 | 29 | 1 |
243868 | 243868 | 2020-06-16 | Jersey | Illinois | 17083 | 29 | 1 |
240757 | 240757 | 2020-06-15 | Jersey | Illinois | 17083 | 28 | 1 |
237649 | 237649 | 2020-06-14 | Jersey | Illinois | 17083 | 28 | 1 |
234542 | 234542 | 2020-06-13 | Jersey | Illinois | 17083 | 28 | 1 |
231436 | 231436 | 2020-06-12 | Jersey | Illinois | 17083 | 28 | 1 |
228333 | 228333 | 2020-06-11 | Jersey | Illinois | 17083 | 28 | 1 |
225231 | 225231 | 2020-06-10 | Jersey | Illinois | 17083 | 27 | 1 |
222136 | 222136 | 2020-06-09 | Jersey | Illinois | 17083 | 26 | 1 |
219041 | 219041 | 2020-06-08 | Jersey | Illinois | 17083 | 25 | 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);