ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where county = "Marengo", deaths = 6 and state = "Alabama" 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 |
---|---|---|---|---|---|---|---|
221560 | 221560 | 2020-06-09 | Marengo | Alabama | 1091 | 188 | 6 |
218468 | 218468 | 2020-06-08 | Marengo | Alabama | 1091 | 188 | 6 |
215378 | 215378 | 2020-06-07 | Marengo | Alabama | 1091 | 185 | 6 |
212291 | 212291 | 2020-06-06 | Marengo | Alabama | 1091 | 183 | 6 |
209206 | 209206 | 2020-06-05 | Marengo | Alabama | 1091 | 180 | 6 |
206124 | 206124 | 2020-06-04 | Marengo | Alabama | 1091 | 176 | 6 |
203045 | 203045 | 2020-06-03 | Marengo | Alabama | 1091 | 175 | 6 |
199969 | 199969 | 2020-06-02 | Marengo | Alabama | 1091 | 175 | 6 |
196896 | 196896 | 2020-06-01 | Marengo | Alabama | 1091 | 172 | 6 |
193826 | 193826 | 2020-05-31 | Marengo | Alabama | 1091 | 170 | 6 |
190760 | 190760 | 2020-05-30 | Marengo | Alabama | 1091 | 163 | 6 |
187696 | 187696 | 2020-05-29 | Marengo | Alabama | 1091 | 160 | 6 |
184639 | 184639 | 2020-05-28 | Marengo | Alabama | 1091 | 155 | 6 |
181587 | 181587 | 2020-05-27 | Marengo | Alabama | 1091 | 150 | 6 |
178543 | 178543 | 2020-05-26 | Marengo | Alabama | 1091 | 145 | 6 |
175498 | 175498 | 2020-05-25 | Marengo | Alabama | 1091 | 141 | 6 |
172455 | 172455 | 2020-05-24 | Marengo | Alabama | 1091 | 133 | 6 |
169414 | 169414 | 2020-05-23 | Marengo | Alabama | 1091 | 132 | 6 |
166378 | 166378 | 2020-05-22 | Marengo | Alabama | 1091 | 125 | 6 |
163346 | 163346 | 2020-05-21 | Marengo | Alabama | 1091 | 121 | 6 |
160318 | 160318 | 2020-05-20 | Marengo | Alabama | 1091 | 118 | 6 |
157294 | 157294 | 2020-05-19 | Marengo | Alabama | 1091 | 116 | 6 |
154278 | 154278 | 2020-05-18 | Marengo | Alabama | 1091 | 104 | 6 |
151266 | 151266 | 2020-05-17 | Marengo | Alabama | 1091 | 103 | 6 |
148257 | 148257 | 2020-05-16 | Marengo | Alabama | 1091 | 102 | 6 |
145254 | 145254 | 2020-05-15 | Marengo | Alabama | 1091 | 101 | 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);