ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where deaths = 7, fips = 51025 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 |
---|---|---|---|---|---|---|---|
946093 | 946093 | 2021-01-19 | Brunswick | Virginia | 51025 | 936 | 7 |
942846 | 942846 | 2021-01-18 | Brunswick | Virginia | 51025 | 928 | 7 |
939601 | 939601 | 2021-01-17 | Brunswick | Virginia | 51025 | 916 | 7 |
936356 | 936356 | 2021-01-16 | Brunswick | Virginia | 51025 | 879 | 7 |
933111 | 933111 | 2021-01-15 | Brunswick | Virginia | 51025 | 855 | 7 |
929866 | 929866 | 2021-01-14 | Brunswick | Virginia | 51025 | 850 | 7 |
926621 | 926621 | 2021-01-13 | Brunswick | Virginia | 51025 | 841 | 7 |
923375 | 923375 | 2021-01-12 | Brunswick | Virginia | 51025 | 834 | 7 |
920130 | 920130 | 2021-01-11 | Brunswick | Virginia | 51025 | 821 | 7 |
916885 | 916885 | 2021-01-10 | Brunswick | Virginia | 51025 | 775 | 7 |
913640 | 913640 | 2021-01-09 | Brunswick | Virginia | 51025 | 776 | 7 |
910395 | 910395 | 2021-01-08 | Brunswick | Virginia | 51025 | 728 | 7 |
907150 | 907150 | 2021-01-07 | Brunswick | Virginia | 51025 | 721 | 7 |
903904 | 903904 | 2021-01-06 | Brunswick | Virginia | 51025 | 690 | 7 |
900659 | 900659 | 2021-01-05 | Brunswick | Virginia | 51025 | 676 | 7 |
897414 | 897414 | 2021-01-04 | Brunswick | Virginia | 51025 | 659 | 7 |
894168 | 894168 | 2021-01-03 | Brunswick | Virginia | 51025 | 654 | 7 |
890922 | 890922 | 2021-01-02 | Brunswick | Virginia | 51025 | 653 | 7 |
887675 | 887675 | 2021-01-01 | Brunswick | Virginia | 51025 | 650 | 7 |
884430 | 884430 | 2020-12-31 | Brunswick | Virginia | 51025 | 641 | 7 |
881185 | 881185 | 2020-12-30 | Brunswick | Virginia | 51025 | 630 | 7 |
877940 | 877940 | 2020-12-29 | Brunswick | Virginia | 51025 | 610 | 7 |
874695 | 874695 | 2020-12-28 | Brunswick | Virginia | 51025 | 599 | 7 |
871450 | 871450 | 2020-12-27 | Brunswick | Virginia | 51025 | 592 | 7 |
868205 | 868205 | 2020-12-26 | Brunswick | Virginia | 51025 | 589 | 7 |
864960 | 864960 | 2020-12-25 | Brunswick | Virginia | 51025 | 585 | 7 |
861715 | 861715 | 2020-12-24 | Brunswick | Virginia | 51025 | 583 | 7 |
858470 | 858470 | 2020-12-23 | Brunswick | Virginia | 51025 | 572 | 7 |
796805 | 796805 | 2020-12-04 | Brunswick | Virginia | 51025 | 486 | 7 |
793560 | 793560 | 2020-12-03 | Brunswick | Virginia | 51025 | 482 | 7 |
790315 | 790315 | 2020-12-02 | Brunswick | Virginia | 51025 | 474 | 7 |
787070 | 787070 | 2020-12-01 | Brunswick | Virginia | 51025 | 474 | 7 |
783826 | 783826 | 2020-11-30 | Brunswick | Virginia | 51025 | 471 | 7 |
780581 | 780581 | 2020-11-29 | Brunswick | Virginia | 51025 | 468 | 7 |
777335 | 777335 | 2020-11-28 | Brunswick | Virginia | 51025 | 468 | 7 |
774090 | 774090 | 2020-11-27 | Brunswick | Virginia | 51025 | 460 | 7 |
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);