ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where county = "Coffee", deaths = 15 and state = "Georgia" 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 |
---|---|---|---|---|---|---|---|
268631 | 268631 | 2020-06-24 | Coffee | Georgia | 13069 | 474 | 15 |
265501 | 265501 | 2020-06-23 | Coffee | Georgia | 13069 | 444 | 15 |
262373 | 262373 | 2020-06-22 | Coffee | Georgia | 13069 | 418 | 15 |
259246 | 259246 | 2020-06-21 | Coffee | Georgia | 13069 | 408 | 15 |
256119 | 256119 | 2020-06-20 | Coffee | Georgia | 13069 | 406 | 15 |
253000 | 253000 | 2020-06-19 | Coffee | Georgia | 13069 | 399 | 15 |
249885 | 249885 | 2020-06-18 | Coffee | Georgia | 13069 | 380 | 15 |
246773 | 246773 | 2020-06-17 | Coffee | Georgia | 13069 | 369 | 15 |
209570 | 209570 | 2020-06-05 | Coffee | Georgia | 13069 | 292 | 15 |
206489 | 206489 | 2020-06-04 | Coffee | Georgia | 13069 | 289 | 15 |
203409 | 203409 | 2020-06-03 | Coffee | Georgia | 13069 | 285 | 15 |
200333 | 200333 | 2020-06-02 | Coffee | Georgia | 13069 | 277 | 15 |
197260 | 197260 | 2020-06-01 | Coffee | Georgia | 13069 | 277 | 15 |
194190 | 194190 | 2020-05-31 | Coffee | Georgia | 13069 | 271 | 15 |
191123 | 191123 | 2020-05-30 | Coffee | Georgia | 13069 | 268 | 15 |
188058 | 188058 | 2020-05-29 | Coffee | Georgia | 13069 | 265 | 15 |
185002 | 185002 | 2020-05-28 | Coffee | Georgia | 13069 | 261 | 15 |
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);