ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where deaths = 40, fips = 51175 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 |
---|---|---|---|---|---|---|---|
855326 | 855326 | 2020-12-22 | Southampton | Virginia | 51175 | 1095 | 40 |
852081 | 852081 | 2020-12-21 | Southampton | Virginia | 51175 | 1092 | 40 |
848836 | 848836 | 2020-12-20 | Southampton | Virginia | 51175 | 1087 | 40 |
845591 | 845591 | 2020-12-19 | Southampton | Virginia | 51175 | 1081 | 40 |
842345 | 842345 | 2020-12-18 | Southampton | Virginia | 51175 | 1073 | 40 |
839100 | 839100 | 2020-12-17 | Southampton | Virginia | 51175 | 1071 | 40 |
835854 | 835854 | 2020-12-16 | Southampton | Virginia | 51175 | 1066 | 40 |
832608 | 832608 | 2020-12-15 | Southampton | Virginia | 51175 | 1060 | 40 |
829361 | 829361 | 2020-12-14 | Southampton | Virginia | 51175 | 1053 | 40 |
826115 | 826115 | 2020-12-13 | Southampton | Virginia | 51175 | 1044 | 40 |
822868 | 822868 | 2020-12-12 | Southampton | Virginia | 51175 | 1042 | 40 |
819622 | 819622 | 2020-12-11 | Southampton | Virginia | 51175 | 1036 | 40 |
816376 | 816376 | 2020-12-10 | Southampton | Virginia | 51175 | 1031 | 40 |
813130 | 813130 | 2020-12-09 | Southampton | Virginia | 51175 | 1029 | 40 |
809886 | 809886 | 2020-12-08 | Southampton | Virginia | 51175 | 1024 | 40 |
806641 | 806641 | 2020-12-07 | Southampton | Virginia | 51175 | 1021 | 40 |
803396 | 803396 | 2020-12-06 | Southampton | Virginia | 51175 | 1018 | 40 |
800151 | 800151 | 2020-12-05 | Southampton | Virginia | 51175 | 1004 | 40 |
796906 | 796906 | 2020-12-04 | Southampton | Virginia | 51175 | 998 | 40 |
793661 | 793661 | 2020-12-03 | Southampton | Virginia | 51175 | 997 | 40 |
790416 | 790416 | 2020-12-02 | Southampton | Virginia | 51175 | 996 | 40 |
787171 | 787171 | 2020-12-01 | Southampton | Virginia | 51175 | 988 | 40 |
783927 | 783927 | 2020-11-30 | Southampton | Virginia | 51175 | 986 | 40 |
780682 | 780682 | 2020-11-29 | Southampton | Virginia | 51175 | 988 | 40 |
777436 | 777436 | 2020-11-28 | Southampton | Virginia | 51175 | 985 | 40 |
774191 | 774191 | 2020-11-27 | Southampton | Virginia | 51175 | 983 | 40 |
770946 | 770946 | 2020-11-26 | Southampton | Virginia | 51175 | 981 | 40 |
767700 | 767700 | 2020-11-25 | Southampton | Virginia | 51175 | 977 | 40 |
764455 | 764455 | 2020-11-24 | Southampton | Virginia | 51175 | 976 | 40 |
761210 | 761210 | 2020-11-23 | Southampton | Virginia | 51175 | 970 | 40 |
757965 | 757965 | 2020-11-22 | Southampton | Virginia | 51175 | 966 | 40 |
754718 | 754718 | 2020-11-21 | Southampton | Virginia | 51175 | 964 | 40 |
751472 | 751472 | 2020-11-20 | Southampton | Virginia | 51175 | 962 | 40 |
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);