ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where county = "Madison", deaths = 42 and state = "Idaho" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2077204 | 2077204 | 2022-01-03 | Madison | Idaho | 16065 | 9388 | 42 |
2073953 | 2073953 | 2022-01-02 | Madison | Idaho | 16065 | 9362 | 42 |
2070702 | 2070702 | 2022-01-01 | Madison | Idaho | 16065 | 9362 | 42 |
2067451 | 2067451 | 2021-12-31 | Madison | Idaho | 16065 | 9362 | 42 |
2064200 | 2064200 | 2021-12-30 | Madison | Idaho | 16065 | 9362 | 42 |
2060950 | 2060950 | 2021-12-29 | Madison | Idaho | 16065 | 9344 | 42 |
2057701 | 2057701 | 2021-12-28 | Madison | Idaho | 16065 | 9324 | 42 |
2054452 | 2054452 | 2021-12-27 | Madison | Idaho | 16065 | 9294 | 42 |
2051202 | 2051202 | 2021-12-26 | Madison | Idaho | 16065 | 9278 | 42 |
2047952 | 2047952 | 2021-12-25 | Madison | Idaho | 16065 | 9278 | 42 |
2044702 | 2044702 | 2021-12-24 | Madison | Idaho | 16065 | 9278 | 42 |
2041453 | 2041453 | 2021-12-23 | Madison | Idaho | 16065 | 9278 | 42 |
2038203 | 2038203 | 2021-12-22 | Madison | Idaho | 16065 | 9275 | 42 |
2034953 | 2034953 | 2021-12-21 | Madison | Idaho | 16065 | 9271 | 42 |
2031703 | 2031703 | 2021-12-20 | Madison | Idaho | 16065 | 9264 | 42 |
2028452 | 2028452 | 2021-12-19 | Madison | Idaho | 16065 | 9252 | 42 |
2025201 | 2025201 | 2021-12-18 | Madison | Idaho | 16065 | 9252 | 42 |
2021950 | 2021950 | 2021-12-17 | Madison | Idaho | 16065 | 9252 | 42 |
2018699 | 2018699 | 2021-12-16 | Madison | Idaho | 16065 | 9246 | 42 |
2015449 | 2015449 | 2021-12-15 | Madison | Idaho | 16065 | 9241 | 42 |
2012198 | 2012198 | 2021-12-14 | Madison | Idaho | 16065 | 9236 | 42 |
2008947 | 2008947 | 2021-12-13 | Madison | Idaho | 16065 | 9222 | 42 |
2005696 | 2005696 | 2021-12-12 | Madison | Idaho | 16065 | 9212 | 42 |
2002445 | 2002445 | 2021-12-11 | Madison | Idaho | 16065 | 9212 | 42 |
1999195 | 1999195 | 2021-12-10 | Madison | Idaho | 16065 | 9210 | 42 |
1995944 | 1995944 | 2021-12-09 | Madison | Idaho | 16065 | 9191 | 42 |
1992693 | 1992693 | 2021-12-08 | Madison | Idaho | 16065 | 9177 | 42 |
1989442 | 1989442 | 2021-12-07 | Madison | Idaho | 16065 | 9159 | 42 |
1986192 | 1986192 | 2021-12-06 | Madison | Idaho | 16065 | 9148 | 42 |
1982942 | 1982942 | 2021-12-05 | Madison | Idaho | 16065 | 9132 | 42 |
1979692 | 1979692 | 2021-12-04 | Madison | Idaho | 16065 | 9132 | 42 |
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);