ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 80 and state = "Vermont" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
county 9
state 1
- Vermont · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1858525 | 1858525 | 2021-10-27 | Unknown | Vermont | 80 | 0 | |
894140 | 894140 | 2021-01-03 | Essex | Vermont | 50009 | 80 | 0 |
890894 | 890894 | 2021-01-02 | Essex | Vermont | 50009 | 80 | 0 |
887647 | 887647 | 2021-01-01 | Essex | Vermont | 50009 | 80 | 0 |
884402 | 884402 | 2020-12-31 | Essex | Vermont | 50009 | 80 | 0 |
881157 | 881157 | 2020-12-30 | Essex | Vermont | 50009 | 80 | 0 |
877912 | 877912 | 2020-12-29 | Essex | Vermont | 50009 | 80 | 0 |
874667 | 874667 | 2020-12-28 | Essex | Vermont | 50009 | 80 | 0 |
871422 | 871422 | 2020-12-27 | Essex | Vermont | 50009 | 80 | 0 |
858442 | 858442 | 2020-12-23 | Essex | Vermont | 50009 | 80 | 0 |
725382 | 725382 | 2020-11-12 | Lamoille | Vermont | 50015 | 80 | 1 |
508214 | 508214 | 2020-09-06 | Windsor | Vermont | 50027 | 80 | 2 |
504982 | 504982 | 2020-09-05 | Windsor | Vermont | 50027 | 80 | 2 |
501748 | 501748 | 2020-09-04 | Windsor | Vermont | 50027 | 80 | 2 |
492047 | 492047 | 2020-09-01 | Windsor | Vermont | 50027 | 80 | 2 |
475865 | 475865 | 2020-08-27 | Addison | Vermont | 50001 | 80 | 2 |
363107 | 363107 | 2020-07-23 | Bennington | Vermont | 50003 | 80 | 1 |
363116 | 363116 | 2020-07-23 | Rutland | Vermont | 50021 | 80 | 1 |
359900 | 359900 | 2020-07-22 | Bennington | Vermont | 50003 | 80 | 1 |
359909 | 359909 | 2020-07-22 | Rutland | Vermont | 50021 | 80 | 1 |
356695 | 356695 | 2020-07-21 | Bennington | Vermont | 50003 | 80 | 1 |
356704 | 356704 | 2020-07-21 | Rutland | Vermont | 50021 | 80 | 1 |
353501 | 353501 | 2020-07-20 | Rutland | Vermont | 50021 | 80 | 1 |
350299 | 350299 | 2020-07-19 | Rutland | Vermont | 50021 | 80 | 1 |
184272 | 184272 | 2020-05-27 | Windham | Vermont | 50025 | 80 | 3 |
181221 | 181221 | 2020-05-26 | Windham | Vermont | 50025 | 80 | 3 |
178177 | 178177 | 2020-05-25 | Windham | Vermont | 50025 | 80 | 3 |
175132 | 175132 | 2020-05-24 | Windham | Vermont | 50025 | 80 | 3 |
172089 | 172089 | 2020-05-23 | Windham | Vermont | 50025 | 80 | 3 |
169048 | 169048 | 2020-05-22 | Windham | Vermont | 50025 | 80 | 3 |
166012 | 166012 | 2020-05-21 | Windham | Vermont | 50025 | 80 | 3 |
50784 | 50784 | 2020-04-11 | Franklin | Vermont | 50011 | 80 | 3 |
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);