ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where county = "Bay" and deaths = 4 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 |
---|---|---|---|---|---|---|---|
287395 | 287395 | 2020-06-30 | Bay | Florida | 12005 | 384 | 4 |
284249 | 284249 | 2020-06-29 | Bay | Florida | 12005 | 347 | 4 |
281103 | 281103 | 2020-06-28 | Bay | Florida | 12005 | 322 | 4 |
277956 | 277956 | 2020-06-27 | Bay | Florida | 12005 | 305 | 4 |
274808 | 274808 | 2020-06-26 | Bay | Florida | 12005 | 287 | 4 |
271668 | 271668 | 2020-06-25 | Bay | Florida | 12005 | 248 | 4 |
268532 | 268532 | 2020-06-24 | Bay | Florida | 12005 | 240 | 4 |
265402 | 265402 | 2020-06-23 | Bay | Florida | 12005 | 230 | 4 |
262274 | 262274 | 2020-06-22 | Bay | Florida | 12005 | 205 | 4 |
259147 | 259147 | 2020-06-21 | Bay | Florida | 12005 | 190 | 4 |
256020 | 256020 | 2020-06-20 | Bay | Florida | 12005 | 188 | 4 |
252901 | 252901 | 2020-06-19 | Bay | Florida | 12005 | 175 | 4 |
249786 | 249786 | 2020-06-18 | Bay | Florida | 12005 | 167 | 4 |
246674 | 246674 | 2020-06-17 | Bay | Florida | 12005 | 161 | 4 |
243561 | 243561 | 2020-06-16 | Bay | Florida | 12005 | 157 | 4 |
240450 | 240450 | 2020-06-15 | Bay | Florida | 12005 | 153 | 4 |
237342 | 237342 | 2020-06-14 | Bay | Florida | 12005 | 145 | 4 |
234235 | 234235 | 2020-06-13 | Bay | Florida | 12005 | 141 | 4 |
231129 | 231129 | 2020-06-12 | Bay | Florida | 12005 | 139 | 4 |
228026 | 228026 | 2020-06-11 | Bay | Florida | 12005 | 135 | 4 |
224924 | 224924 | 2020-06-10 | Bay | Florida | 12005 | 135 | 4 |
221829 | 221829 | 2020-06-09 | Bay | Florida | 12005 | 133 | 4 |
218734 | 218734 | 2020-06-08 | Bay | Florida | 12005 | 132 | 4 |
215643 | 215643 | 2020-06-07 | Bay | Florida | 12005 | 130 | 4 |
212556 | 212556 | 2020-06-06 | Bay | Florida | 12005 | 123 | 4 |
209471 | 209471 | 2020-06-05 | Bay | Florida | 12005 | 115 | 4 |
206390 | 206390 | 2020-06-04 | Bay | Florida | 12005 | 111 | 4 |
102172 | 102172 | 2020-04-30 | Bay | Michigan | 26017 | 143 | 4 |
99320 | 99320 | 2020-04-29 | Bay | Michigan | 26017 | 142 | 4 |
96474 | 96474 | 2020-04-28 | Bay | Michigan | 26017 | 135 | 4 |
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);