ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where county = "Vermilion", deaths = 3, fips = 22113 and state = "Louisiana" 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 |
---|---|---|---|---|---|---|---|
204133 | 204133 | 2020-06-03 | Vermilion | Louisiana | 22113 | 58 | 3 |
201056 | 201056 | 2020-06-02 | Vermilion | Louisiana | 22113 | 57 | 3 |
197984 | 197984 | 2020-06-01 | Vermilion | Louisiana | 22113 | 55 | 3 |
194913 | 194913 | 2020-05-31 | Vermilion | Louisiana | 22113 | 53 | 3 |
191845 | 191845 | 2020-05-30 | Vermilion | Louisiana | 22113 | 53 | 3 |
188781 | 188781 | 2020-05-29 | Vermilion | Louisiana | 22113 | 53 | 3 |
185723 | 185723 | 2020-05-28 | Vermilion | Louisiana | 22113 | 53 | 3 |
182668 | 182668 | 2020-05-27 | Vermilion | Louisiana | 22113 | 53 | 3 |
179623 | 179623 | 2020-05-26 | Vermilion | Louisiana | 22113 | 51 | 3 |
176579 | 176579 | 2020-05-25 | Vermilion | Louisiana | 22113 | 50 | 3 |
173535 | 173535 | 2020-05-24 | Vermilion | Louisiana | 22113 | 50 | 3 |
170494 | 170494 | 2020-05-23 | Vermilion | Louisiana | 22113 | 50 | 3 |
167456 | 167456 | 2020-05-22 | Vermilion | Louisiana | 22113 | 50 | 3 |
164420 | 164420 | 2020-05-21 | Vermilion | Louisiana | 22113 | 50 | 3 |
161391 | 161391 | 2020-05-20 | Vermilion | Louisiana | 22113 | 45 | 3 |
158365 | 158365 | 2020-05-19 | Vermilion | Louisiana | 22113 | 45 | 3 |
155347 | 155347 | 2020-05-18 | Vermilion | Louisiana | 22113 | 45 | 3 |
152333 | 152333 | 2020-05-17 | Vermilion | Louisiana | 22113 | 44 | 3 |
149322 | 149322 | 2020-05-16 | Vermilion | Louisiana | 22113 | 44 | 3 |
146317 | 146317 | 2020-05-15 | Vermilion | Louisiana | 22113 | 43 | 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);