ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where county = "Elmore" and deaths = 4 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
736024 | 736024 | 2020-11-16 | Elmore | Idaho | 16039 | 758 | 4 |
732778 | 732778 | 2020-11-15 | Elmore | Idaho | 16039 | 740 | 4 |
729533 | 729533 | 2020-11-14 | Elmore | Idaho | 16039 | 740 | 4 |
726290 | 726290 | 2020-11-13 | Elmore | Idaho | 16039 | 740 | 4 |
723047 | 723047 | 2020-11-12 | Elmore | Idaho | 16039 | 726 | 4 |
719804 | 719804 | 2020-11-11 | Elmore | Idaho | 16039 | 710 | 4 |
716561 | 716561 | 2020-11-10 | Elmore | Idaho | 16039 | 692 | 4 |
713317 | 713317 | 2020-11-09 | Elmore | Idaho | 16039 | 689 | 4 |
710073 | 710073 | 2020-11-08 | Elmore | Idaho | 16039 | 659 | 4 |
706829 | 706829 | 2020-11-07 | Elmore | Idaho | 16039 | 647 | 4 |
703586 | 703586 | 2020-11-06 | Elmore | Idaho | 16039 | 647 | 4 |
700343 | 700343 | 2020-11-05 | Elmore | Idaho | 16039 | 629 | 4 |
697099 | 697099 | 2020-11-04 | Elmore | Idaho | 16039 | 622 | 4 |
693857 | 693857 | 2020-11-03 | Elmore | Idaho | 16039 | 608 | 4 |
690614 | 690614 | 2020-11-02 | Elmore | Idaho | 16039 | 592 | 4 |
687369 | 687369 | 2020-11-01 | Elmore | Idaho | 16039 | 581 | 4 |
684125 | 684125 | 2020-10-31 | Elmore | Idaho | 16039 | 577 | 4 |
680882 | 680882 | 2020-10-30 | Elmore | Idaho | 16039 | 568 | 4 |
677639 | 677639 | 2020-10-29 | Elmore | Idaho | 16039 | 556 | 4 |
674396 | 674396 | 2020-10-28 | Elmore | Idaho | 16039 | 542 | 4 |
671154 | 671154 | 2020-10-27 | Elmore | Idaho | 16039 | 529 | 4 |
667911 | 667911 | 2020-10-26 | Elmore | Idaho | 16039 | 529 | 4 |
664666 | 664666 | 2020-10-25 | Elmore | Idaho | 16039 | 516 | 4 |
661422 | 661422 | 2020-10-24 | Elmore | Idaho | 16039 | 516 | 4 |
658178 | 658178 | 2020-10-23 | Elmore | Idaho | 16039 | 516 | 4 |
654933 | 654933 | 2020-10-22 | Elmore | Idaho | 16039 | 505 | 4 |
651688 | 651688 | 2020-10-21 | Elmore | Idaho | 16039 | 494 | 4 |
648444 | 648444 | 2020-10-20 | Elmore | Idaho | 16039 | 476 | 4 |
645199 | 645199 | 2020-10-19 | Elmore | Idaho | 16039 | 468 | 4 |
641951 | 641951 | 2020-10-18 | Elmore | Idaho | 16039 | 447 | 4 |
638704 | 638704 | 2020-10-17 | Elmore | Idaho | 16039 | 447 | 4 |
635459 | 635459 | 2020-10-16 | Elmore | Idaho | 16039 | 447 | 4 |
632213 | 632213 | 2020-10-15 | Elmore | Idaho | 16039 | 447 | 4 |
628969 | 628969 | 2020-10-14 | Elmore | Idaho | 16039 | 433 | 4 |
625726 | 625726 | 2020-10-13 | Elmore | Idaho | 16039 | 428 | 4 |
622483 | 622483 | 2020-10-12 | Elmore | Idaho | 16039 | 424 | 4 |
619240 | 619240 | 2020-10-11 | Elmore | Idaho | 16039 | 415 | 4 |
615998 | 615998 | 2020-10-10 | Elmore | Idaho | 16039 | 415 | 4 |
612757 | 612757 | 2020-10-09 | Elmore | Idaho | 16039 | 415 | 4 |
609515 | 609515 | 2020-10-08 | Elmore | Idaho | 16039 | 404 | 4 |
606272 | 606272 | 2020-10-07 | Elmore | Idaho | 16039 | 398 | 4 |
603030 | 603030 | 2020-10-06 | Elmore | Idaho | 16039 | 395 | 4 |
599787 | 599787 | 2020-10-05 | Elmore | Idaho | 16039 | 391 | 4 |
596544 | 596544 | 2020-10-04 | Elmore | Idaho | 16039 | 379 | 4 |
593302 | 593302 | 2020-10-03 | Elmore | Idaho | 16039 | 379 | 4 |
590062 | 590062 | 2020-10-02 | Elmore | Idaho | 16039 | 379 | 4 |
136248 | 136248 | 2020-05-12 | Elmore | Alabama | 1051 | 156 | 4 |
133258 | 133258 | 2020-05-11 | Elmore | Alabama | 1051 | 152 | 4 |
130268 | 130268 | 2020-05-10 | Elmore | Alabama | 1051 | 150 | 4 |
127278 | 127278 | 2020-05-09 | Elmore | Alabama | 1051 | 135 | 4 |
124293 | 124293 | 2020-05-08 | Elmore | Alabama | 1051 | 130 | 4 |
121313 | 121313 | 2020-05-07 | Elmore | Alabama | 1051 | 127 | 4 |
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);