ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where county = "Crawford", deaths = 6 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
716602 | 716602 | 2020-11-10 | Crawford | Illinois | 17033 | 776 | 6 |
713358 | 713358 | 2020-11-09 | Crawford | Illinois | 17033 | 748 | 6 |
710114 | 710114 | 2020-11-08 | Crawford | Illinois | 17033 | 744 | 6 |
706870 | 706870 | 2020-11-07 | Crawford | Illinois | 17033 | 739 | 6 |
703627 | 703627 | 2020-11-06 | Crawford | Illinois | 17033 | 730 | 6 |
700384 | 700384 | 2020-11-05 | Crawford | Illinois | 17033 | 700 | 6 |
697140 | 697140 | 2020-11-04 | Crawford | Illinois | 17033 | 690 | 6 |
693898 | 693898 | 2020-11-03 | Crawford | Illinois | 17033 | 689 | 6 |
690655 | 690655 | 2020-11-02 | Crawford | Illinois | 17033 | 686 | 6 |
687410 | 687410 | 2020-11-01 | Crawford | Illinois | 17033 | 684 | 6 |
684166 | 684166 | 2020-10-31 | Crawford | Illinois | 17033 | 676 | 6 |
680923 | 680923 | 2020-10-30 | Crawford | Illinois | 17033 | 676 | 6 |
677680 | 677680 | 2020-10-29 | Crawford | Illinois | 17033 | 668 | 6 |
674437 | 674437 | 2020-10-28 | Crawford | Illinois | 17033 | 663 | 6 |
671195 | 671195 | 2020-10-27 | Crawford | Illinois | 17033 | 653 | 6 |
667952 | 667952 | 2020-10-26 | Crawford | Illinois | 17033 | 651 | 6 |
664708 | 664708 | 2020-10-25 | Crawford | Illinois | 17033 | 647 | 6 |
661463 | 661463 | 2020-10-24 | Crawford | Illinois | 17033 | 644 | 6 |
658219 | 658219 | 2020-10-23 | Crawford | Illinois | 17033 | 645 | 6 |
654974 | 654974 | 2020-10-22 | Crawford | Illinois | 17033 | 639 | 6 |
651729 | 651729 | 2020-10-21 | Crawford | Illinois | 17033 | 636 | 6 |
648485 | 648485 | 2020-10-20 | Crawford | Illinois | 17033 | 630 | 6 |
645240 | 645240 | 2020-10-19 | Crawford | Illinois | 17033 | 624 | 6 |
641993 | 641993 | 2020-10-18 | Crawford | Illinois | 17033 | 615 | 6 |
638746 | 638746 | 2020-10-17 | Crawford | Illinois | 17033 | 609 | 6 |
635500 | 635500 | 2020-10-16 | Crawford | Illinois | 17033 | 608 | 6 |
632254 | 632254 | 2020-10-15 | Crawford | Illinois | 17033 | 604 | 6 |
629010 | 629010 | 2020-10-14 | Crawford | Illinois | 17033 | 589 | 6 |
625767 | 625767 | 2020-10-13 | Crawford | Illinois | 17033 | 576 | 6 |
622525 | 622525 | 2020-10-12 | Crawford | Illinois | 17033 | 572 | 6 |
619281 | 619281 | 2020-10-11 | Crawford | Illinois | 17033 | 561 | 6 |
616039 | 616039 | 2020-10-10 | Crawford | Illinois | 17033 | 544 | 6 |
612798 | 612798 | 2020-10-09 | Crawford | Illinois | 17033 | 539 | 6 |
609556 | 609556 | 2020-10-08 | Crawford | Illinois | 17033 | 525 | 6 |
606313 | 606313 | 2020-10-07 | Crawford | Illinois | 17033 | 505 | 6 |
603071 | 603071 | 2020-10-06 | Crawford | Illinois | 17033 | 497 | 6 |
599828 | 599828 | 2020-10-05 | Crawford | Illinois | 17033 | 491 | 6 |
596586 | 596586 | 2020-10-04 | Crawford | Illinois | 17033 | 481 | 6 |
593344 | 593344 | 2020-10-03 | Crawford | Illinois | 17033 | 478 | 6 |
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);