ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where county = "Page", deaths = 24 and fips = 51139 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
414666 | 414666 | 2020-08-08 | Page | Virginia | 51139 | 343 | 24 |
411446 | 411446 | 2020-08-07 | Page | Virginia | 51139 | 337 | 24 |
408227 | 408227 | 2020-08-06 | Page | Virginia | 51139 | 335 | 24 |
405007 | 405007 | 2020-08-05 | Page | Virginia | 51139 | 337 | 24 |
401789 | 401789 | 2020-08-04 | Page | Virginia | 51139 | 334 | 24 |
398573 | 398573 | 2020-08-03 | Page | Virginia | 51139 | 333 | 24 |
395357 | 395357 | 2020-08-02 | Page | Virginia | 51139 | 332 | 24 |
392141 | 392141 | 2020-08-01 | Page | Virginia | 51139 | 331 | 24 |
388924 | 388924 | 2020-07-31 | Page | Virginia | 51139 | 330 | 24 |
385707 | 385707 | 2020-07-30 | Page | Virginia | 51139 | 331 | 24 |
382489 | 382489 | 2020-07-29 | Page | Virginia | 51139 | 330 | 24 |
379272 | 379272 | 2020-07-28 | Page | Virginia | 51139 | 330 | 24 |
376056 | 376056 | 2020-07-27 | Page | Virginia | 51139 | 329 | 24 |
372842 | 372842 | 2020-07-26 | Page | Virginia | 51139 | 328 | 24 |
369630 | 369630 | 2020-07-25 | Page | Virginia | 51139 | 328 | 24 |
366421 | 366421 | 2020-07-24 | Page | Virginia | 51139 | 326 | 24 |
363215 | 363215 | 2020-07-23 | Page | Virginia | 51139 | 326 | 24 |
293154 | 293154 | 2020-07-01 | Page | Virginia | 51139 | 275 | 24 |
290001 | 290001 | 2020-06-30 | Page | Virginia | 51139 | 269 | 24 |
286851 | 286851 | 2020-06-29 | Page | Virginia | 51139 | 267 | 24 |
283705 | 283705 | 2020-06-28 | Page | Virginia | 51139 | 267 | 24 |
280559 | 280559 | 2020-06-27 | Page | Virginia | 51139 | 267 | 24 |
277411 | 277411 | 2020-06-26 | Page | Virginia | 51139 | 266 | 24 |
274263 | 274263 | 2020-06-25 | Page | Virginia | 51139 | 266 | 24 |
271123 | 271123 | 2020-06-24 | Page | Virginia | 51139 | 264 | 24 |
267989 | 267989 | 2020-06-23 | Page | Virginia | 51139 | 264 | 24 |
264860 | 264860 | 2020-06-22 | Page | Virginia | 51139 | 263 | 24 |
261731 | 261731 | 2020-06-21 | Page | Virginia | 51139 | 263 | 24 |
258604 | 258604 | 2020-06-20 | Page | Virginia | 51139 | 261 | 24 |
255477 | 255477 | 2020-06-19 | Page | Virginia | 51139 | 261 | 24 |
252358 | 252358 | 2020-06-18 | Page | Virginia | 51139 | 259 | 24 |
249243 | 249243 | 2020-06-17 | Page | Virginia | 51139 | 256 | 24 |
246131 | 246131 | 2020-06-16 | Page | Virginia | 51139 | 256 | 24 |
243018 | 243018 | 2020-06-15 | Page | Virginia | 51139 | 252 | 24 |
239907 | 239907 | 2020-06-14 | Page | Virginia | 51139 | 251 | 24 |
236799 | 236799 | 2020-06-13 | Page | Virginia | 51139 | 251 | 24 |
233692 | 233692 | 2020-06-12 | Page | Virginia | 51139 | 250 | 24 |
230587 | 230587 | 2020-06-11 | Page | Virginia | 51139 | 249 | 24 |
227483 | 227483 | 2020-06-10 | Page | Virginia | 51139 | 247 | 24 |
224383 | 224383 | 2020-06-09 | Page | Virginia | 51139 | 246 | 24 |
221287 | 221287 | 2020-06-08 | Page | Virginia | 51139 | 245 | 24 |
218195 | 218195 | 2020-06-07 | Page | Virginia | 51139 | 244 | 24 |
215105 | 215105 | 2020-06-06 | Page | Virginia | 51139 | 237 | 24 |
212018 | 212018 | 2020-06-05 | Page | Virginia | 51139 | 233 | 24 |
208933 | 208933 | 2020-06-04 | Page | Virginia | 51139 | 231 | 24 |
205851 | 205851 | 2020-06-03 | Page | Virginia | 51139 | 231 | 24 |
202772 | 202772 | 2020-06-02 | Page | Virginia | 51139 | 230 | 24 |
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);