ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where county = "Page", deaths = 29, fips = 51139 and state = "Virginia" 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 |
---|---|---|---|---|---|---|---|
628163 | 628163 | 2020-10-13 | Page | Virginia | 51139 | 439 | 29 |
624920 | 624920 | 2020-10-12 | Page | Virginia | 51139 | 432 | 29 |
621677 | 621677 | 2020-10-11 | Page | Virginia | 51139 | 430 | 29 |
618434 | 618434 | 2020-10-10 | Page | Virginia | 51139 | 428 | 29 |
615192 | 615192 | 2020-10-09 | Page | Virginia | 51139 | 424 | 29 |
611951 | 611951 | 2020-10-08 | Page | Virginia | 51139 | 422 | 29 |
608709 | 608709 | 2020-10-07 | Page | Virginia | 51139 | 415 | 29 |
605466 | 605466 | 2020-10-06 | Page | Virginia | 51139 | 414 | 29 |
602224 | 602224 | 2020-10-05 | Page | Virginia | 51139 | 412 | 29 |
598981 | 598981 | 2020-10-04 | Page | Virginia | 51139 | 410 | 29 |
595738 | 595738 | 2020-10-03 | Page | Virginia | 51139 | 407 | 29 |
592496 | 592496 | 2020-10-02 | Page | Virginia | 51139 | 405 | 29 |
589256 | 589256 | 2020-10-01 | Page | Virginia | 51139 | 405 | 29 |
586015 | 586015 | 2020-09-30 | Page | Virginia | 51139 | 404 | 29 |
582775 | 582775 | 2020-09-29 | Page | Virginia | 51139 | 398 | 29 |
579536 | 579536 | 2020-09-28 | Page | Virginia | 51139 | 397 | 29 |
576295 | 576295 | 2020-09-27 | Page | Virginia | 51139 | 393 | 29 |
573051 | 573051 | 2020-09-26 | Page | Virginia | 51139 | 393 | 29 |
569809 | 569809 | 2020-09-25 | Page | Virginia | 51139 | 390 | 29 |
566568 | 566568 | 2020-09-24 | Page | Virginia | 51139 | 389 | 29 |
563327 | 563327 | 2020-09-23 | Page | Virginia | 51139 | 389 | 29 |
560088 | 560088 | 2020-09-22 | Page | Virginia | 51139 | 385 | 29 |
556852 | 556852 | 2020-09-21 | Page | Virginia | 51139 | 384 | 29 |
553615 | 553615 | 2020-09-20 | Page | Virginia | 51139 | 382 | 29 |
550376 | 550376 | 2020-09-19 | Page | Virginia | 51139 | 380 | 29 |
547137 | 547137 | 2020-09-18 | Page | Virginia | 51139 | 379 | 29 |
543900 | 543900 | 2020-09-17 | Page | Virginia | 51139 | 378 | 29 |
540664 | 540664 | 2020-09-16 | Page | Virginia | 51139 | 378 | 29 |
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);