ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
29 rows where county = "Lowndes" and deaths = 9 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 |
---|---|---|---|---|---|---|---|
284406 | 284406 | 2020-06-29 | Lowndes | Georgia | 13185 | 1150 | 9 |
281260 | 281260 | 2020-06-28 | Lowndes | Georgia | 13185 | 1136 | 9 |
278113 | 278113 | 2020-06-27 | Lowndes | Georgia | 13185 | 1129 | 9 |
274965 | 274965 | 2020-06-26 | Lowndes | Georgia | 13185 | 1087 | 9 |
244665 | 244665 | 2020-06-16 | Lowndes | Mississippi | 28087 | 335 | 9 |
241554 | 241554 | 2020-06-15 | Lowndes | Mississippi | 28087 | 317 | 9 |
238445 | 238445 | 2020-06-14 | Lowndes | Mississippi | 28087 | 315 | 9 |
235338 | 235338 | 2020-06-13 | Lowndes | Mississippi | 28087 | 311 | 9 |
232232 | 232232 | 2020-06-12 | Lowndes | Mississippi | 28087 | 311 | 9 |
229128 | 229128 | 2020-06-11 | Lowndes | Mississippi | 28087 | 290 | 9 |
226026 | 226026 | 2020-06-10 | Lowndes | Mississippi | 28087 | 290 | 9 |
222928 | 222928 | 2020-06-09 | Lowndes | Mississippi | 28087 | 277 | 9 |
219833 | 219833 | 2020-06-08 | Lowndes | Mississippi | 28087 | 274 | 9 |
216741 | 216741 | 2020-06-07 | Lowndes | Mississippi | 28087 | 270 | 9 |
213653 | 213653 | 2020-06-06 | Lowndes | Mississippi | 28087 | 263 | 9 |
210569 | 210569 | 2020-06-05 | Lowndes | Mississippi | 28087 | 252 | 9 |
207488 | 207488 | 2020-06-04 | Lowndes | Mississippi | 28087 | 247 | 9 |
204407 | 204407 | 2020-06-03 | Lowndes | Mississippi | 28087 | 241 | 9 |
201330 | 201330 | 2020-06-02 | Lowndes | Mississippi | 28087 | 230 | 9 |
198257 | 198257 | 2020-06-01 | Lowndes | Mississippi | 28087 | 219 | 9 |
195186 | 195186 | 2020-05-31 | Lowndes | Mississippi | 28087 | 211 | 9 |
192118 | 192118 | 2020-05-30 | Lowndes | Mississippi | 28087 | 211 | 9 |
189054 | 189054 | 2020-05-29 | Lowndes | Mississippi | 28087 | 200 | 9 |
185996 | 185996 | 2020-05-28 | Lowndes | Mississippi | 28087 | 189 | 9 |
154275 | 154275 | 2020-05-18 | Lowndes | Alabama | 1085 | 133 | 9 |
151263 | 151263 | 2020-05-17 | Lowndes | Alabama | 1085 | 128 | 9 |
148254 | 148254 | 2020-05-16 | Lowndes | Alabama | 1085 | 128 | 9 |
145251 | 145251 | 2020-05-15 | Lowndes | Alabama | 1085 | 122 | 9 |
142252 | 142252 | 2020-05-14 | Lowndes | Alabama | 1085 | 117 | 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);