ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Livingston" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535073 | 535073 | 2020-09-15 | Livingston | Illinois | 17105 | 272 | 4 |
531838 | 531838 | 2020-09-14 | Livingston | Illinois | 17105 | 270 | 4 |
528601 | 528601 | 2020-09-13 | Livingston | Illinois | 17105 | 266 | 4 |
525365 | 525365 | 2020-09-12 | Livingston | Illinois | 17105 | 263 | 4 |
522129 | 522129 | 2020-09-11 | Livingston | Illinois | 17105 | 258 | 4 |
518892 | 518892 | 2020-09-10 | Livingston | Illinois | 17105 | 253 | 4 |
515657 | 515657 | 2020-09-09 | Livingston | Illinois | 17105 | 245 | 4 |
512424 | 512424 | 2020-09-08 | Livingston | Illinois | 17105 | 245 | 4 |
509191 | 509191 | 2020-09-07 | Livingston | Illinois | 17105 | 243 | 4 |
505959 | 505959 | 2020-09-06 | Livingston | Illinois | 17105 | 235 | 4 |
502725 | 502725 | 2020-09-05 | Livingston | Illinois | 17105 | 229 | 4 |
499491 | 499491 | 2020-09-04 | Livingston | Illinois | 17105 | 224 | 4 |
496258 | 496258 | 2020-09-03 | Livingston | Illinois | 17105 | 210 | 4 |
493024 | 493024 | 2020-09-02 | Livingston | Illinois | 17105 | 207 | 4 |
489791 | 489791 | 2020-09-01 | Livingston | Illinois | 17105 | 199 | 4 |
486558 | 486558 | 2020-08-31 | Livingston | Illinois | 17105 | 193 | 4 |
483323 | 483323 | 2020-08-30 | Livingston | Illinois | 17105 | 189 | 4 |
480089 | 480089 | 2020-08-29 | Livingston | Illinois | 17105 | 181 | 4 |
476856 | 476856 | 2020-08-28 | Livingston | Illinois | 17105 | 180 | 4 |
473623 | 473623 | 2020-08-27 | Livingston | Illinois | 17105 | 179 | 4 |
470391 | 470391 | 2020-08-26 | Livingston | Illinois | 17105 | 172 | 4 |
467162 | 467162 | 2020-08-25 | Livingston | Illinois | 17105 | 173 | 3 |
463933 | 463933 | 2020-08-24 | Livingston | Illinois | 17105 | 170 | 3 |
460704 | 460704 | 2020-08-23 | Livingston | Illinois | 17105 | 166 | 3 |
457477 | 457477 | 2020-08-22 | Livingston | Illinois | 17105 | 165 | 3 |
454249 | 454249 | 2020-08-21 | Livingston | Illinois | 17105 | 157 | 3 |
451021 | 451021 | 2020-08-20 | Livingston | Illinois | 17105 | 157 | 3 |
447793 | 447793 | 2020-08-19 | Livingston | Illinois | 17105 | 152 | 3 |
444566 | 444566 | 2020-08-18 | Livingston | Illinois | 17105 | 151 | 3 |
441340 | 441340 | 2020-08-17 | Livingston | Illinois | 17105 | 151 | 3 |
438114 | 438114 | 2020-08-16 | Livingston | Illinois | 17105 | 150 | 3 |
434888 | 434888 | 2020-08-15 | Livingston | Illinois | 17105 | 143 | 3 |
431663 | 431663 | 2020-08-14 | Livingston | Illinois | 17105 | 140 | 3 |
428435 | 428435 | 2020-08-13 | Livingston | Illinois | 17105 | 134 | 3 |
425211 | 425211 | 2020-08-12 | Livingston | Illinois | 17105 | 130 | 3 |
421990 | 421990 | 2020-08-11 | Livingston | Illinois | 17105 | 122 | 3 |
418767 | 418767 | 2020-08-10 | Livingston | Illinois | 17105 | 116 | 2 |
415546 | 415546 | 2020-08-09 | Livingston | Illinois | 17105 | 115 | 2 |
412326 | 412326 | 2020-08-08 | Livingston | Illinois | 17105 | 110 | 2 |
409107 | 409107 | 2020-08-07 | Livingston | Illinois | 17105 | 105 | 2 |
405887 | 405887 | 2020-08-06 | Livingston | Illinois | 17105 | 103 | 2 |
402669 | 402669 | 2020-08-05 | Livingston | Illinois | 17105 | 99 | 2 |
399453 | 399453 | 2020-08-04 | Livingston | Illinois | 17105 | 96 | 2 |
396237 | 396237 | 2020-08-03 | Livingston | Illinois | 17105 | 92 | 2 |
393021 | 393021 | 2020-08-02 | Livingston | Illinois | 17105 | 92 | 2 |
389804 | 389804 | 2020-08-01 | Livingston | Illinois | 17105 | 92 | 2 |
386587 | 386587 | 2020-07-31 | Livingston | Illinois | 17105 | 85 | 2 |
383369 | 383369 | 2020-07-30 | Livingston | Illinois | 17105 | 83 | 2 |
380152 | 380152 | 2020-07-29 | Livingston | Illinois | 17105 | 79 | 2 |
376935 | 376935 | 2020-07-28 | Livingston | Illinois | 17105 | 76 | 2 |
373720 | 373720 | 2020-07-27 | Livingston | Illinois | 17105 | 74 | 2 |
370508 | 370508 | 2020-07-26 | Livingston | Illinois | 17105 | 71 | 2 |
367298 | 367298 | 2020-07-25 | Livingston | Illinois | 17105 | 69 | 2 |
364091 | 364091 | 2020-07-24 | Livingston | Illinois | 17105 | 66 | 2 |
360884 | 360884 | 2020-07-23 | Livingston | Illinois | 17105 | 65 | 2 |
357679 | 357679 | 2020-07-22 | Livingston | Illinois | 17105 | 63 | 2 |
354477 | 354477 | 2020-07-21 | Livingston | Illinois | 17105 | 61 | 2 |
351275 | 351275 | 2020-07-20 | Livingston | Illinois | 17105 | 60 | 2 |
348075 | 348075 | 2020-07-19 | Livingston | Illinois | 17105 | 60 | 2 |
344874 | 344874 | 2020-07-18 | Livingston | Illinois | 17105 | 58 | 2 |
341674 | 341674 | 2020-07-17 | Livingston | Illinois | 17105 | 58 | 2 |
338478 | 338478 | 2020-07-16 | Livingston | Illinois | 17105 | 57 | 2 |
335282 | 335282 | 2020-07-15 | Livingston | Illinois | 17105 | 58 | 2 |
332089 | 332089 | 2020-07-14 | Livingston | Illinois | 17105 | 55 | 2 |
328902 | 328902 | 2020-07-13 | Livingston | Illinois | 17105 | 55 | 2 |
325716 | 325716 | 2020-07-12 | Livingston | Illinois | 17105 | 55 | 2 |
322535 | 322535 | 2020-07-11 | Livingston | Illinois | 17105 | 54 | 2 |
319356 | 319356 | 2020-07-10 | Livingston | Illinois | 17105 | 54 | 2 |
316183 | 316183 | 2020-07-09 | Livingston | Illinois | 17105 | 54 | 2 |
313009 | 313009 | 2020-07-08 | Livingston | Illinois | 17105 | 53 | 2 |
309839 | 309839 | 2020-07-07 | Livingston | Illinois | 17105 | 53 | 2 |
306671 | 306671 | 2020-07-06 | Livingston | Illinois | 17105 | 52 | 2 |
303506 | 303506 | 2020-07-05 | Livingston | Illinois | 17105 | 52 | 2 |
300342 | 300342 | 2020-07-04 | Livingston | Illinois | 17105 | 52 | 2 |
297180 | 297180 | 2020-07-03 | Livingston | Illinois | 17105 | 50 | 2 |
294023 | 294023 | 2020-07-02 | Livingston | Illinois | 17105 | 47 | 2 |
290869 | 290869 | 2020-07-01 | Livingston | Illinois | 17105 | 45 | 2 |
287719 | 287719 | 2020-06-30 | Livingston | Illinois | 17105 | 43 | 2 |
284570 | 284570 | 2020-06-29 | Livingston | Illinois | 17105 | 43 | 2 |
281425 | 281425 | 2020-06-28 | Livingston | Illinois | 17105 | 43 | 2 |
278277 | 278277 | 2020-06-27 | Livingston | Illinois | 17105 | 42 | 2 |
275129 | 275129 | 2020-06-26 | Livingston | Illinois | 17105 | 42 | 2 |
271987 | 271987 | 2020-06-25 | Livingston | Illinois | 17105 | 40 | 2 |
268850 | 268850 | 2020-06-24 | Livingston | Illinois | 17105 | 40 | 2 |
265720 | 265720 | 2020-06-23 | Livingston | Illinois | 17105 | 38 | 2 |
262592 | 262592 | 2020-06-22 | Livingston | Illinois | 17105 | 37 | 2 |
259465 | 259465 | 2020-06-21 | Livingston | Illinois | 17105 | 37 | 2 |
256339 | 256339 | 2020-06-20 | Livingston | Illinois | 17105 | 37 | 2 |
253219 | 253219 | 2020-06-19 | Livingston | Illinois | 17105 | 36 | 2 |
250104 | 250104 | 2020-06-18 | Livingston | Illinois | 17105 | 35 | 2 |
246992 | 246992 | 2020-06-17 | Livingston | Illinois | 17105 | 35 | 2 |
243879 | 243879 | 2020-06-16 | Livingston | Illinois | 17105 | 35 | 2 |
240768 | 240768 | 2020-06-15 | Livingston | Illinois | 17105 | 37 | 2 |
237660 | 237660 | 2020-06-14 | Livingston | Illinois | 17105 | 39 | 2 |
234553 | 234553 | 2020-06-13 | Livingston | Illinois | 17105 | 37 | 2 |
231447 | 231447 | 2020-06-12 | Livingston | Illinois | 17105 | 36 | 2 |
228344 | 228344 | 2020-06-11 | Livingston | Illinois | 17105 | 36 | 2 |
225242 | 225242 | 2020-06-10 | Livingston | Illinois | 17105 | 36 | 2 |
222147 | 222147 | 2020-06-09 | Livingston | Illinois | 17105 | 36 | 2 |
219052 | 219052 | 2020-06-08 | Livingston | Illinois | 17105 | 36 | 2 |
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);