ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where county = "Bland", deaths = 6 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 |
---|---|---|---|---|---|---|---|
926618 | 926618 | 2021-01-13 | Bland | Virginia | 51021 | 548 | 6 |
923372 | 923372 | 2021-01-12 | Bland | Virginia | 51021 | 546 | 6 |
920127 | 920127 | 2021-01-11 | Bland | Virginia | 51021 | 546 | 6 |
916882 | 916882 | 2021-01-10 | Bland | Virginia | 51021 | 539 | 6 |
913637 | 913637 | 2021-01-09 | Bland | Virginia | 51021 | 532 | 6 |
910392 | 910392 | 2021-01-08 | Bland | Virginia | 51021 | 528 | 6 |
907147 | 907147 | 2021-01-07 | Bland | Virginia | 51021 | 521 | 6 |
903901 | 903901 | 2021-01-06 | Bland | Virginia | 51021 | 509 | 6 |
900656 | 900656 | 2021-01-05 | Bland | Virginia | 51021 | 501 | 6 |
897411 | 897411 | 2021-01-04 | Bland | Virginia | 51021 | 499 | 6 |
894165 | 894165 | 2021-01-03 | Bland | Virginia | 51021 | 497 | 6 |
890919 | 890919 | 2021-01-02 | Bland | Virginia | 51021 | 482 | 6 |
887672 | 887672 | 2021-01-01 | Bland | Virginia | 51021 | 482 | 6 |
884427 | 884427 | 2020-12-31 | Bland | Virginia | 51021 | 480 | 6 |
881182 | 881182 | 2020-12-30 | Bland | Virginia | 51021 | 458 | 6 |
877937 | 877937 | 2020-12-29 | Bland | Virginia | 51021 | 451 | 6 |
874692 | 874692 | 2020-12-28 | Bland | Virginia | 51021 | 448 | 6 |
871447 | 871447 | 2020-12-27 | Bland | Virginia | 51021 | 443 | 6 |
868202 | 868202 | 2020-12-26 | Bland | Virginia | 51021 | 434 | 6 |
864957 | 864957 | 2020-12-25 | Bland | Virginia | 51021 | 434 | 6 |
861712 | 861712 | 2020-12-24 | Bland | Virginia | 51021 | 435 | 6 |
858467 | 858467 | 2020-12-23 | Bland | Virginia | 51021 | 427 | 6 |
855222 | 855222 | 2020-12-22 | Bland | Virginia | 51021 | 422 | 6 |
851977 | 851977 | 2020-12-21 | Bland | Virginia | 51021 | 422 | 6 |
848732 | 848732 | 2020-12-20 | Bland | Virginia | 51021 | 421 | 6 |
845487 | 845487 | 2020-12-19 | Bland | Virginia | 51021 | 410 | 6 |
842241 | 842241 | 2020-12-18 | Bland | Virginia | 51021 | 401 | 6 |
838996 | 838996 | 2020-12-17 | Bland | Virginia | 51021 | 395 | 6 |
835750 | 835750 | 2020-12-16 | Bland | Virginia | 51021 | 390 | 6 |
832504 | 832504 | 2020-12-15 | Bland | Virginia | 51021 | 380 | 6 |
829257 | 829257 | 2020-12-14 | Bland | Virginia | 51021 | 375 | 6 |
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);