ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where county = "Richland" and deaths = 9 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Richland · 49 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
873412 | 873412 | 2020-12-28 | Richland | Montana | 30083 | 864 | 9 |
870167 | 870167 | 2020-12-27 | Richland | Montana | 30083 | 864 | 9 |
866922 | 866922 | 2020-12-26 | Richland | Montana | 30083 | 862 | 9 |
863677 | 863677 | 2020-12-25 | Richland | Montana | 30083 | 848 | 9 |
860432 | 860432 | 2020-12-24 | Richland | Montana | 30083 | 848 | 9 |
857187 | 857187 | 2020-12-23 | Richland | Montana | 30083 | 847 | 9 |
853942 | 853942 | 2020-12-22 | Richland | Montana | 30083 | 832 | 9 |
850697 | 850697 | 2020-12-21 | Richland | Montana | 30083 | 830 | 9 |
847452 | 847452 | 2020-12-20 | Richland | Montana | 30083 | 828 | 9 |
844206 | 844206 | 2020-12-19 | Richland | Montana | 30083 | 828 | 9 |
840961 | 840961 | 2020-12-18 | Richland | Montana | 30083 | 787 | 9 |
837716 | 837716 | 2020-12-17 | Richland | Montana | 30083 | 779 | 9 |
834470 | 834470 | 2020-12-16 | Richland | Montana | 30083 | 762 | 9 |
831223 | 831223 | 2020-12-15 | Richland | Montana | 30083 | 761 | 9 |
827977 | 827977 | 2020-12-14 | Richland | Montana | 30083 | 760 | 9 |
824730 | 824730 | 2020-12-13 | Richland | Montana | 30083 | 760 | 9 |
821484 | 821484 | 2020-12-12 | Richland | Montana | 30083 | 738 | 9 |
818238 | 818238 | 2020-12-11 | Richland | Montana | 30083 | 737 | 9 |
814992 | 814992 | 2020-12-10 | Richland | Montana | 30083 | 730 | 9 |
811747 | 811747 | 2020-12-09 | Richland | Montana | 30083 | 729 | 9 |
808502 | 808502 | 2020-12-08 | Richland | Montana | 30083 | 728 | 9 |
805257 | 805257 | 2020-12-07 | Richland | Montana | 30083 | 728 | 9 |
802012 | 802012 | 2020-12-06 | Richland | Montana | 30083 | 717 | 9 |
798767 | 798767 | 2020-12-05 | Richland | Montana | 30083 | 716 | 9 |
795522 | 795522 | 2020-12-04 | Richland | Montana | 30083 | 716 | 9 |
792277 | 792277 | 2020-12-03 | Richland | Montana | 30083 | 715 | 9 |
702969 | 702969 | 2020-11-05 | Richland | Wisconsin | 55103 | 566 | 9 |
699726 | 699726 | 2020-11-04 | Richland | Wisconsin | 55103 | 558 | 9 |
696482 | 696482 | 2020-11-03 | Richland | Wisconsin | 55103 | 549 | 9 |
693240 | 693240 | 2020-11-02 | Richland | Wisconsin | 55103 | 535 | 9 |
689996 | 689996 | 2020-11-01 | Richland | Wisconsin | 55103 | 516 | 9 |
686751 | 686751 | 2020-10-31 | Richland | Wisconsin | 55103 | 513 | 9 |
683508 | 683508 | 2020-10-30 | Richland | Wisconsin | 55103 | 504 | 9 |
612861 | 612861 | 2020-10-09 | Richland | Illinois | 17159 | 278 | 9 |
609619 | 609619 | 2020-10-08 | Richland | Illinois | 17159 | 275 | 9 |
606376 | 606376 | 2020-10-07 | Richland | Illinois | 17159 | 267 | 9 |
603134 | 603134 | 2020-10-06 | Richland | Illinois | 17159 | 264 | 9 |
503234 | 503234 | 2020-09-05 | Richland | Louisiana | 22083 | 716 | 9 |
500001 | 500001 | 2020-09-04 | Richland | Louisiana | 22083 | 716 | 9 |
490300 | 490300 | 2020-09-01 | Richland | Louisiana | 22083 | 696 | 9 |
487067 | 487067 | 2020-08-31 | Richland | Louisiana | 22083 | 687 | 9 |
483832 | 483832 | 2020-08-30 | Richland | Louisiana | 22083 | 686 | 9 |
480598 | 480598 | 2020-08-29 | Richland | Louisiana | 22083 | 682 | 9 |
477365 | 477365 | 2020-08-28 | Richland | Louisiana | 22083 | 682 | 9 |
474132 | 474132 | 2020-08-27 | Richland | Louisiana | 22083 | 678 | 9 |
470900 | 470900 | 2020-08-26 | Richland | Louisiana | 22083 | 666 | 9 |
467671 | 467671 | 2020-08-25 | Richland | Louisiana | 22083 | 664 | 9 |
464442 | 464442 | 2020-08-24 | Richland | Louisiana | 22083 | 667 | 9 |
378394 | 378394 | 2020-07-28 | Richland | Ohio | 39139 | 491 | 9 |
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);