ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 58, fips = 51177 and state = "Virginia" 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 |
---|---|---|---|---|---|---|---|
832609 | 832609 | 2020-12-15 | Spotsylvania | Virginia | 51177 | 3818 | 58 |
829362 | 829362 | 2020-12-14 | Spotsylvania | Virginia | 51177 | 3786 | 58 |
826116 | 826116 | 2020-12-13 | Spotsylvania | Virginia | 51177 | 3709 | 58 |
822869 | 822869 | 2020-12-12 | Spotsylvania | Virginia | 51177 | 3705 | 58 |
819623 | 819623 | 2020-12-11 | Spotsylvania | Virginia | 51177 | 3652 | 58 |
816377 | 816377 | 2020-12-10 | Spotsylvania | Virginia | 51177 | 3610 | 58 |
813131 | 813131 | 2020-12-09 | Spotsylvania | Virginia | 51177 | 3574 | 58 |
809887 | 809887 | 2020-12-08 | Spotsylvania | Virginia | 51177 | 3529 | 58 |
806642 | 806642 | 2020-12-07 | Spotsylvania | Virginia | 51177 | 3472 | 58 |
803397 | 803397 | 2020-12-06 | Spotsylvania | Virginia | 51177 | 3394 | 58 |
800152 | 800152 | 2020-12-05 | Spotsylvania | Virginia | 51177 | 3340 | 58 |
796907 | 796907 | 2020-12-04 | Spotsylvania | Virginia | 51177 | 3292 | 58 |
793662 | 793662 | 2020-12-03 | Spotsylvania | Virginia | 51177 | 3248 | 58 |
790417 | 790417 | 2020-12-02 | Spotsylvania | Virginia | 51177 | 3218 | 58 |
787172 | 787172 | 2020-12-01 | Spotsylvania | Virginia | 51177 | 3185 | 58 |
783928 | 783928 | 2020-11-30 | Spotsylvania | Virginia | 51177 | 3161 | 58 |
780683 | 780683 | 2020-11-29 | Spotsylvania | Virginia | 51177 | 3147 | 58 |
777437 | 777437 | 2020-11-28 | Spotsylvania | Virginia | 51177 | 3109 | 58 |
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);