ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where deaths = 3, fips = 19185 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
684438 | 684438 | 2020-10-31 | Wayne | Iowa | 19185 | 161 | 3 |
681195 | 681195 | 2020-10-30 | Wayne | Iowa | 19185 | 155 | 3 |
677952 | 677952 | 2020-10-29 | Wayne | Iowa | 19185 | 137 | 3 |
674709 | 674709 | 2020-10-28 | Wayne | Iowa | 19185 | 135 | 3 |
671467 | 671467 | 2020-10-27 | Wayne | Iowa | 19185 | 132 | 3 |
668224 | 668224 | 2020-10-26 | Wayne | Iowa | 19185 | 121 | 3 |
664980 | 664980 | 2020-10-25 | Wayne | Iowa | 19185 | 120 | 3 |
661735 | 661735 | 2020-10-24 | Wayne | Iowa | 19185 | 117 | 3 |
658491 | 658491 | 2020-10-23 | Wayne | Iowa | 19185 | 116 | 3 |
655246 | 655246 | 2020-10-22 | Wayne | Iowa | 19185 | 113 | 3 |
652001 | 652001 | 2020-10-21 | Wayne | Iowa | 19185 | 115 | 3 |
648757 | 648757 | 2020-10-20 | Wayne | Iowa | 19185 | 112 | 3 |
645512 | 645512 | 2020-10-19 | Wayne | Iowa | 19185 | 112 | 3 |
642265 | 642265 | 2020-10-18 | Wayne | Iowa | 19185 | 111 | 3 |
639018 | 639018 | 2020-10-17 | Wayne | Iowa | 19185 | 111 | 3 |
635772 | 635772 | 2020-10-16 | Wayne | Iowa | 19185 | 110 | 3 |
632526 | 632526 | 2020-10-15 | Wayne | Iowa | 19185 | 110 | 3 |
629282 | 629282 | 2020-10-14 | Wayne | Iowa | 19185 | 109 | 3 |
626039 | 626039 | 2020-10-13 | Wayne | Iowa | 19185 | 109 | 3 |
622797 | 622797 | 2020-10-12 | Wayne | Iowa | 19185 | 106 | 3 |
619553 | 619553 | 2020-10-11 | Wayne | Iowa | 19185 | 102 | 3 |
616311 | 616311 | 2020-10-10 | Wayne | Iowa | 19185 | 101 | 3 |
613070 | 613070 | 2020-10-09 | Wayne | Iowa | 19185 | 101 | 3 |
609828 | 609828 | 2020-10-08 | Wayne | Iowa | 19185 | 98 | 3 |
606585 | 606585 | 2020-10-07 | Wayne | Iowa | 19185 | 97 | 3 |
603343 | 603343 | 2020-10-06 | Wayne | Iowa | 19185 | 94 | 3 |
600100 | 600100 | 2020-10-05 | Wayne | Iowa | 19185 | 94 | 3 |
596858 | 596858 | 2020-10-04 | Wayne | Iowa | 19185 | 91 | 3 |
593616 | 593616 | 2020-10-03 | Wayne | Iowa | 19185 | 91 | 3 |
590375 | 590375 | 2020-10-02 | Wayne | Iowa | 19185 | 90 | 3 |
587134 | 587134 | 2020-10-01 | Wayne | Iowa | 19185 | 89 | 3 |
583894 | 583894 | 2020-09-30 | Wayne | Iowa | 19185 | 89 | 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);