ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where county = "Knox", deaths = 3 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
596617 | 596617 | 2020-10-04 | Knox | Illinois | 17095 | 761 | 3 |
593375 | 593375 | 2020-10-03 | Knox | Illinois | 17095 | 749 | 3 |
590134 | 590134 | 2020-10-02 | Knox | Illinois | 17095 | 744 | 3 |
586893 | 586893 | 2020-10-01 | Knox | Illinois | 17095 | 718 | 3 |
583653 | 583653 | 2020-09-30 | Knox | Illinois | 17095 | 704 | 3 |
580414 | 580414 | 2020-09-29 | Knox | Illinois | 17095 | 680 | 3 |
577173 | 577173 | 2020-09-28 | Knox | Illinois | 17095 | 672 | 3 |
573931 | 573931 | 2020-09-27 | Knox | Illinois | 17095 | 670 | 3 |
570688 | 570688 | 2020-09-26 | Knox | Illinois | 17095 | 648 | 3 |
567446 | 567446 | 2020-09-25 | Knox | Illinois | 17095 | 640 | 3 |
564206 | 564206 | 2020-09-24 | Knox | Illinois | 17095 | 631 | 3 |
560966 | 560966 | 2020-09-23 | Knox | Illinois | 17095 | 627 | 3 |
557730 | 557730 | 2020-09-22 | Knox | Illinois | 17095 | 613 | 3 |
554493 | 554493 | 2020-09-21 | Knox | Illinois | 17095 | 605 | 3 |
551254 | 551254 | 2020-09-20 | Knox | Illinois | 17095 | 598 | 3 |
548015 | 548015 | 2020-09-19 | Knox | Illinois | 17095 | 581 | 3 |
544777 | 544777 | 2020-09-18 | Knox | Illinois | 17095 | 565 | 3 |
541541 | 541541 | 2020-09-17 | Knox | Illinois | 17095 | 552 | 3 |
538304 | 538304 | 2020-09-16 | Knox | Illinois | 17095 | 548 | 3 |
535068 | 535068 | 2020-09-15 | Knox | Illinois | 17095 | 538 | 3 |
531833 | 531833 | 2020-09-14 | Knox | Illinois | 17095 | 527 | 3 |
528596 | 528596 | 2020-09-13 | Knox | Illinois | 17095 | 525 | 3 |
525360 | 525360 | 2020-09-12 | Knox | Illinois | 17095 | 521 | 3 |
522124 | 522124 | 2020-09-11 | Knox | Illinois | 17095 | 511 | 3 |
518887 | 518887 | 2020-09-10 | Knox | Illinois | 17095 | 506 | 3 |
515652 | 515652 | 2020-09-09 | Knox | Illinois | 17095 | 505 | 3 |
512419 | 512419 | 2020-09-08 | Knox | Illinois | 17095 | 498 | 3 |
509186 | 509186 | 2020-09-07 | Knox | Illinois | 17095 | 497 | 3 |
505954 | 505954 | 2020-09-06 | Knox | Illinois | 17095 | 497 | 3 |
502720 | 502720 | 2020-09-05 | Knox | Illinois | 17095 | 484 | 3 |
499486 | 499486 | 2020-09-04 | Knox | Illinois | 17095 | 483 | 3 |
496253 | 496253 | 2020-09-03 | Knox | Illinois | 17095 | 468 | 3 |
493019 | 493019 | 2020-09-02 | Knox | Illinois | 17095 | 460 | 3 |
489786 | 489786 | 2020-09-01 | Knox | Illinois | 17095 | 459 | 3 |
486553 | 486553 | 2020-08-31 | Knox | Illinois | 17095 | 458 | 3 |
483318 | 483318 | 2020-08-30 | Knox | Illinois | 17095 | 449 | 3 |
480084 | 480084 | 2020-08-29 | Knox | Illinois | 17095 | 441 | 3 |
476851 | 476851 | 2020-08-28 | Knox | Illinois | 17095 | 441 | 3 |
473618 | 473618 | 2020-08-27 | Knox | Illinois | 17095 | 440 | 3 |
470386 | 470386 | 2020-08-26 | Knox | Illinois | 17095 | 436 | 3 |
467157 | 467157 | 2020-08-25 | Knox | Illinois | 17095 | 429 | 3 |
463928 | 463928 | 2020-08-24 | Knox | Illinois | 17095 | 425 | 3 |
460699 | 460699 | 2020-08-23 | Knox | Illinois | 17095 | 422 | 3 |
457472 | 457472 | 2020-08-22 | Knox | Illinois | 17095 | 415 | 3 |
454244 | 454244 | 2020-08-21 | Knox | Illinois | 17095 | 406 | 3 |
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);