ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where deaths = 7 and fips = 51036 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 |
---|---|---|---|---|---|---|---|
839006 | 839006 | 2020-12-17 | Charles City | Virginia | 51036 | 162 | 7 |
835760 | 835760 | 2020-12-16 | Charles City | Virginia | 51036 | 162 | 7 |
832514 | 832514 | 2020-12-15 | Charles City | Virginia | 51036 | 162 | 7 |
829267 | 829267 | 2020-12-14 | Charles City | Virginia | 51036 | 161 | 7 |
826021 | 826021 | 2020-12-13 | Charles City | Virginia | 51036 | 159 | 7 |
822774 | 822774 | 2020-12-12 | Charles City | Virginia | 51036 | 156 | 7 |
819528 | 819528 | 2020-12-11 | Charles City | Virginia | 51036 | 154 | 7 |
816282 | 816282 | 2020-12-10 | Charles City | Virginia | 51036 | 153 | 7 |
813036 | 813036 | 2020-12-09 | Charles City | Virginia | 51036 | 151 | 7 |
809792 | 809792 | 2020-12-08 | Charles City | Virginia | 51036 | 151 | 7 |
806547 | 806547 | 2020-12-07 | Charles City | Virginia | 51036 | 150 | 7 |
803302 | 803302 | 2020-12-06 | Charles City | Virginia | 51036 | 149 | 7 |
800057 | 800057 | 2020-12-05 | Charles City | Virginia | 51036 | 150 | 7 |
796812 | 796812 | 2020-12-04 | Charles City | Virginia | 51036 | 146 | 7 |
793567 | 793567 | 2020-12-03 | Charles City | Virginia | 51036 | 145 | 7 |
790322 | 790322 | 2020-12-02 | Charles City | Virginia | 51036 | 145 | 7 |
787077 | 787077 | 2020-12-01 | Charles City | Virginia | 51036 | 145 | 7 |
783833 | 783833 | 2020-11-30 | Charles City | Virginia | 51036 | 142 | 7 |
780588 | 780588 | 2020-11-29 | Charles City | Virginia | 51036 | 141 | 7 |
777342 | 777342 | 2020-11-28 | Charles City | Virginia | 51036 | 141 | 7 |
774097 | 774097 | 2020-11-27 | Charles City | Virginia | 51036 | 141 | 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);