ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 17107 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535074 | 535074 | 2020-09-15 | Logan | Illinois | 17107 | 400 | 1 |
531839 | 531839 | 2020-09-14 | Logan | Illinois | 17107 | 390 | 1 |
528602 | 528602 | 2020-09-13 | Logan | Illinois | 17107 | 386 | 1 |
525366 | 525366 | 2020-09-12 | Logan | Illinois | 17107 | 380 | 1 |
522130 | 522130 | 2020-09-11 | Logan | Illinois | 17107 | 378 | 1 |
518893 | 518893 | 2020-09-10 | Logan | Illinois | 17107 | 353 | 1 |
515658 | 515658 | 2020-09-09 | Logan | Illinois | 17107 | 346 | 1 |
512425 | 512425 | 2020-09-08 | Logan | Illinois | 17107 | 323 | 1 |
509192 | 509192 | 2020-09-07 | Logan | Illinois | 17107 | 321 | 1 |
505960 | 505960 | 2020-09-06 | Logan | Illinois | 17107 | 318 | 1 |
502726 | 502726 | 2020-09-05 | Logan | Illinois | 17107 | 310 | 1 |
499492 | 499492 | 2020-09-04 | Logan | Illinois | 17107 | 306 | 1 |
496259 | 496259 | 2020-09-03 | Logan | Illinois | 17107 | 287 | 1 |
493025 | 493025 | 2020-09-02 | Logan | Illinois | 17107 | 276 | 1 |
489792 | 489792 | 2020-09-01 | Logan | Illinois | 17107 | 265 | 1 |
486559 | 486559 | 2020-08-31 | Logan | Illinois | 17107 | 263 | 1 |
483324 | 483324 | 2020-08-30 | Logan | Illinois | 17107 | 260 | 1 |
480090 | 480090 | 2020-08-29 | Logan | Illinois | 17107 | 259 | 1 |
476857 | 476857 | 2020-08-28 | Logan | Illinois | 17107 | 249 | 1 |
473624 | 473624 | 2020-08-27 | Logan | Illinois | 17107 | 247 | 1 |
470392 | 470392 | 2020-08-26 | Logan | Illinois | 17107 | 245 | 1 |
467163 | 467163 | 2020-08-25 | Logan | Illinois | 17107 | 237 | 1 |
463934 | 463934 | 2020-08-24 | Logan | Illinois | 17107 | 228 | 1 |
460705 | 460705 | 2020-08-23 | Logan | Illinois | 17107 | 228 | 1 |
457478 | 457478 | 2020-08-22 | Logan | Illinois | 17107 | 223 | 1 |
454250 | 454250 | 2020-08-21 | Logan | Illinois | 17107 | 222 | 1 |
451022 | 451022 | 2020-08-20 | Logan | Illinois | 17107 | 211 | 1 |
447794 | 447794 | 2020-08-19 | Logan | Illinois | 17107 | 208 | 1 |
444567 | 444567 | 2020-08-18 | Logan | Illinois | 17107 | 204 | 1 |
441341 | 441341 | 2020-08-17 | Logan | Illinois | 17107 | 201 | 1 |
438115 | 438115 | 2020-08-16 | Logan | Illinois | 17107 | 196 | 1 |
434889 | 434889 | 2020-08-15 | Logan | Illinois | 17107 | 190 | 1 |
431664 | 431664 | 2020-08-14 | Logan | Illinois | 17107 | 187 | 1 |
428436 | 428436 | 2020-08-13 | Logan | Illinois | 17107 | 179 | 1 |
425212 | 425212 | 2020-08-12 | Logan | Illinois | 17107 | 166 | 1 |
421991 | 421991 | 2020-08-11 | Logan | Illinois | 17107 | 157 | 1 |
418768 | 418768 | 2020-08-10 | Logan | Illinois | 17107 | 122 | 0 |
415547 | 415547 | 2020-08-09 | Logan | Illinois | 17107 | 112 | 0 |
412327 | 412327 | 2020-08-08 | Logan | Illinois | 17107 | 111 | 0 |
409108 | 409108 | 2020-08-07 | Logan | Illinois | 17107 | 106 | 0 |
405888 | 405888 | 2020-08-06 | Logan | Illinois | 17107 | 90 | 0 |
402670 | 402670 | 2020-08-05 | Logan | Illinois | 17107 | 90 | 0 |
399454 | 399454 | 2020-08-04 | Logan | Illinois | 17107 | 87 | 0 |
396238 | 396238 | 2020-08-03 | Logan | Illinois | 17107 | 86 | 0 |
393022 | 393022 | 2020-08-02 | Logan | Illinois | 17107 | 85 | 0 |
389805 | 389805 | 2020-08-01 | Logan | Illinois | 17107 | 85 | 0 |
386588 | 386588 | 2020-07-31 | Logan | Illinois | 17107 | 79 | 0 |
383370 | 383370 | 2020-07-30 | Logan | Illinois | 17107 | 74 | 0 |
380153 | 380153 | 2020-07-29 | Logan | Illinois | 17107 | 70 | 0 |
376936 | 376936 | 2020-07-28 | Logan | Illinois | 17107 | 67 | 0 |
373721 | 373721 | 2020-07-27 | Logan | Illinois | 17107 | 65 | 0 |
370509 | 370509 | 2020-07-26 | Logan | Illinois | 17107 | 65 | 0 |
367299 | 367299 | 2020-07-25 | Logan | Illinois | 17107 | 65 | 0 |
364092 | 364092 | 2020-07-24 | Logan | Illinois | 17107 | 64 | 0 |
360885 | 360885 | 2020-07-23 | Logan | Illinois | 17107 | 59 | 0 |
357680 | 357680 | 2020-07-22 | Logan | Illinois | 17107 | 57 | 0 |
354478 | 354478 | 2020-07-21 | Logan | Illinois | 17107 | 55 | 0 |
351276 | 351276 | 2020-07-20 | Logan | Illinois | 17107 | 51 | 0 |
348076 | 348076 | 2020-07-19 | Logan | Illinois | 17107 | 43 | 0 |
344875 | 344875 | 2020-07-18 | Logan | Illinois | 17107 | 41 | 0 |
341675 | 341675 | 2020-07-17 | Logan | Illinois | 17107 | 33 | 0 |
338479 | 338479 | 2020-07-16 | Logan | Illinois | 17107 | 30 | 0 |
335283 | 335283 | 2020-07-15 | Logan | Illinois | 17107 | 27 | 0 |
332090 | 332090 | 2020-07-14 | Logan | Illinois | 17107 | 24 | 0 |
328903 | 328903 | 2020-07-13 | Logan | Illinois | 17107 | 20 | 0 |
325717 | 325717 | 2020-07-12 | Logan | Illinois | 17107 | 21 | 0 |
322536 | 322536 | 2020-07-11 | Logan | Illinois | 17107 | 20 | 0 |
319357 | 319357 | 2020-07-10 | Logan | Illinois | 17107 | 18 | 0 |
316184 | 316184 | 2020-07-09 | Logan | Illinois | 17107 | 18 | 0 |
313010 | 313010 | 2020-07-08 | Logan | Illinois | 17107 | 18 | 0 |
309840 | 309840 | 2020-07-07 | Logan | Illinois | 17107 | 18 | 0 |
306672 | 306672 | 2020-07-06 | Logan | Illinois | 17107 | 18 | 0 |
303507 | 303507 | 2020-07-05 | Logan | Illinois | 17107 | 18 | 0 |
300343 | 300343 | 2020-07-04 | Logan | Illinois | 17107 | 17 | 0 |
297181 | 297181 | 2020-07-03 | Logan | Illinois | 17107 | 16 | 0 |
294024 | 294024 | 2020-07-02 | Logan | Illinois | 17107 | 15 | 0 |
290870 | 290870 | 2020-07-01 | Logan | Illinois | 17107 | 15 | 0 |
287720 | 287720 | 2020-06-30 | Logan | Illinois | 17107 | 14 | 0 |
284571 | 284571 | 2020-06-29 | Logan | Illinois | 17107 | 13 | 0 |
281426 | 281426 | 2020-06-28 | Logan | Illinois | 17107 | 13 | 0 |
278278 | 278278 | 2020-06-27 | Logan | Illinois | 17107 | 13 | 0 |
275130 | 275130 | 2020-06-26 | Logan | Illinois | 17107 | 13 | 0 |
271988 | 271988 | 2020-06-25 | Logan | Illinois | 17107 | 13 | 0 |
268851 | 268851 | 2020-06-24 | Logan | Illinois | 17107 | 13 | 0 |
265721 | 265721 | 2020-06-23 | Logan | Illinois | 17107 | 13 | 0 |
262593 | 262593 | 2020-06-22 | Logan | Illinois | 17107 | 13 | 0 |
259466 | 259466 | 2020-06-21 | Logan | Illinois | 17107 | 13 | 0 |
256340 | 256340 | 2020-06-20 | Logan | Illinois | 17107 | 13 | 0 |
253220 | 253220 | 2020-06-19 | Logan | Illinois | 17107 | 12 | 0 |
250105 | 250105 | 2020-06-18 | Logan | Illinois | 17107 | 11 | 0 |
246993 | 246993 | 2020-06-17 | Logan | Illinois | 17107 | 11 | 0 |
243880 | 243880 | 2020-06-16 | Logan | Illinois | 17107 | 11 | 0 |
240769 | 240769 | 2020-06-15 | Logan | Illinois | 17107 | 11 | 0 |
237661 | 237661 | 2020-06-14 | Logan | Illinois | 17107 | 11 | 0 |
234554 | 234554 | 2020-06-13 | Logan | Illinois | 17107 | 10 | 0 |
231448 | 231448 | 2020-06-12 | Logan | Illinois | 17107 | 10 | 0 |
228345 | 228345 | 2020-06-11 | Logan | Illinois | 17107 | 10 | 0 |
225243 | 225243 | 2020-06-10 | Logan | Illinois | 17107 | 10 | 0 |
222148 | 222148 | 2020-06-09 | Logan | Illinois | 17107 | 10 | 0 |
219053 | 219053 | 2020-06-08 | Logan | Illinois | 17107 | 10 | 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);