ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where deaths = 1, fips = 51045 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 |
---|---|---|---|---|---|---|---|
903919 | 903919 | 2021-01-06 | Craig | Virginia | 51045 | 152 | 1 |
900674 | 900674 | 2021-01-05 | Craig | Virginia | 51045 | 150 | 1 |
897429 | 897429 | 2021-01-04 | Craig | Virginia | 51045 | 150 | 1 |
894183 | 894183 | 2021-01-03 | Craig | Virginia | 51045 | 150 | 1 |
890937 | 890937 | 2021-01-02 | Craig | Virginia | 51045 | 150 | 1 |
887690 | 887690 | 2021-01-01 | Craig | Virginia | 51045 | 150 | 1 |
884445 | 884445 | 2020-12-31 | Craig | Virginia | 51045 | 149 | 1 |
881200 | 881200 | 2020-12-30 | Craig | Virginia | 51045 | 148 | 1 |
877955 | 877955 | 2020-12-29 | Craig | Virginia | 51045 | 147 | 1 |
874710 | 874710 | 2020-12-28 | Craig | Virginia | 51045 | 143 | 1 |
871465 | 871465 | 2020-12-27 | Craig | Virginia | 51045 | 142 | 1 |
868220 | 868220 | 2020-12-26 | Craig | Virginia | 51045 | 141 | 1 |
864975 | 864975 | 2020-12-25 | Craig | Virginia | 51045 | 137 | 1 |
861730 | 861730 | 2020-12-24 | Craig | Virginia | 51045 | 136 | 1 |
858485 | 858485 | 2020-12-23 | Craig | Virginia | 51045 | 134 | 1 |
855240 | 855240 | 2020-12-22 | Craig | Virginia | 51045 | 130 | 1 |
851995 | 851995 | 2020-12-21 | Craig | Virginia | 51045 | 129 | 1 |
848750 | 848750 | 2020-12-20 | Craig | Virginia | 51045 | 128 | 1 |
845505 | 845505 | 2020-12-19 | Craig | Virginia | 51045 | 128 | 1 |
842259 | 842259 | 2020-12-18 | Craig | Virginia | 51045 | 123 | 1 |
839014 | 839014 | 2020-12-17 | Craig | Virginia | 51045 | 121 | 1 |
835768 | 835768 | 2020-12-16 | Craig | Virginia | 51045 | 119 | 1 |
832522 | 832522 | 2020-12-15 | Craig | Virginia | 51045 | 113 | 1 |
829275 | 829275 | 2020-12-14 | Craig | Virginia | 51045 | 112 | 1 |
826029 | 826029 | 2020-12-13 | Craig | Virginia | 51045 | 111 | 1 |
822782 | 822782 | 2020-12-12 | Craig | Virginia | 51045 | 109 | 1 |
819536 | 819536 | 2020-12-11 | Craig | Virginia | 51045 | 107 | 1 |
816290 | 816290 | 2020-12-10 | Craig | Virginia | 51045 | 106 | 1 |
813044 | 813044 | 2020-12-09 | Craig | Virginia | 51045 | 104 | 1 |
809800 | 809800 | 2020-12-08 | Craig | Virginia | 51045 | 101 | 1 |
806555 | 806555 | 2020-12-07 | Craig | Virginia | 51045 | 97 | 1 |
803310 | 803310 | 2020-12-06 | Craig | Virginia | 51045 | 97 | 1 |
800065 | 800065 | 2020-12-05 | Craig | Virginia | 51045 | 97 | 1 |
796820 | 796820 | 2020-12-04 | Craig | Virginia | 51045 | 94 | 1 |
793575 | 793575 | 2020-12-03 | Craig | Virginia | 51045 | 92 | 1 |
790330 | 790330 | 2020-12-02 | Craig | Virginia | 51045 | 90 | 1 |
787085 | 787085 | 2020-12-01 | Craig | Virginia | 51045 | 90 | 1 |
783841 | 783841 | 2020-11-30 | Craig | Virginia | 51045 | 90 | 1 |
780596 | 780596 | 2020-11-29 | Craig | Virginia | 51045 | 90 | 1 |
777350 | 777350 | 2020-11-28 | Craig | Virginia | 51045 | 90 | 1 |
774105 | 774105 | 2020-11-27 | Craig | Virginia | 51045 | 88 | 1 |
770860 | 770860 | 2020-11-26 | Craig | Virginia | 51045 | 88 | 1 |
767614 | 767614 | 2020-11-25 | Craig | Virginia | 51045 | 87 | 1 |
764369 | 764369 | 2020-11-24 | Craig | Virginia | 51045 | 85 | 1 |
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);