ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11,758 rows where state = "Vermont" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 15
county 15
- Bennington 798
- Chittenden 794
- Washington 791
- Windsor 791
- Orange 789
- Addison 785
- Rutland 785
- Franklin 784
- Windham 784
- Unknown 782
- Caledonia 781
- Orleans 781
- Lamoille 780
- Grand Isle 767
- Essex 766
state 1
- Vermont · 11,758 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
739 | 739 | 2020-03-07 | Bennington | Vermont | 50003 | 1 | 0 |
851 | 851 | 2020-03-08 | Bennington | Vermont | 50003 | 1 | 0 |
981 | 981 | 2020-03-09 | Bennington | Vermont | 50003 | 1 | 0 |
1143 | 1143 | 2020-03-10 | Bennington | Vermont | 50003 | 1 | 0 |
1340 | 1340 | 2020-03-11 | Bennington | Vermont | 50003 | 1 | 0 |
1341 | 1341 | 2020-03-11 | Chittenden | Vermont | 50007 | 1 | 0 |
1587 | 1587 | 2020-03-12 | Bennington | Vermont | 50003 | 1 | 0 |
1588 | 1588 | 2020-03-12 | Chittenden | Vermont | 50007 | 1 | 0 |
1896 | 1896 | 2020-03-13 | Bennington | Vermont | 50003 | 1 | 0 |
1897 | 1897 | 2020-03-13 | Chittenden | Vermont | 50007 | 1 | 0 |
2264 | 2264 | 2020-03-14 | Bennington | Vermont | 50003 | 1 | 0 |
2265 | 2265 | 2020-03-14 | Chittenden | Vermont | 50007 | 1 | 0 |
2266 | 2266 | 2020-03-14 | Washington | Vermont | 50023 | 1 | 0 |
2267 | 2267 | 2020-03-14 | Windsor | Vermont | 50027 | 2 | 0 |
2691 | 2691 | 2020-03-15 | Bennington | Vermont | 50003 | 2 | 0 |
2692 | 2692 | 2020-03-15 | Chittenden | Vermont | 50007 | 2 | 0 |
2693 | 2693 | 2020-03-15 | Washington | Vermont | 50023 | 1 | 0 |
2694 | 2694 | 2020-03-15 | Windsor | Vermont | 50027 | 3 | 0 |
3162 | 3162 | 2020-03-16 | Bennington | Vermont | 50003 | 3 | 0 |
3163 | 3163 | 2020-03-16 | Chittenden | Vermont | 50007 | 4 | 0 |
3164 | 3164 | 2020-03-16 | Orange | Vermont | 50017 | 1 | 0 |
3165 | 3165 | 2020-03-16 | Washington | Vermont | 50023 | 1 | 0 |
3166 | 3166 | 2020-03-16 | Windsor | Vermont | 50027 | 3 | 0 |
3698 | 3698 | 2020-03-17 | Bennington | Vermont | 50003 | 3 | 0 |
3699 | 3699 | 2020-03-17 | Chittenden | Vermont | 50007 | 6 | 0 |
3700 | 3700 | 2020-03-17 | Orange | Vermont | 50017 | 1 | 0 |
3701 | 3701 | 2020-03-17 | Washington | Vermont | 50023 | 1 | 0 |
3702 | 3702 | 2020-03-17 | Windsor | Vermont | 50027 | 3 | 0 |
4330 | 4330 | 2020-03-18 | Bennington | Vermont | 50003 | 3 | 0 |
4331 | 4331 | 2020-03-18 | Chittenden | Vermont | 50007 | 11 | 0 |
4332 | 4332 | 2020-03-18 | Orange | Vermont | 50017 | 1 | 0 |
4333 | 4333 | 2020-03-18 | Washington | Vermont | 50023 | 1 | 0 |
4334 | 4334 | 2020-03-18 | Windsor | Vermont | 50027 | 3 | 0 |
5086 | 5086 | 2020-03-19 | Bennington | Vermont | 50003 | 4 | 0 |
5087 | 5087 | 2020-03-19 | Chittenden | Vermont | 50007 | 12 | 1 |
5088 | 5088 | 2020-03-19 | Orange | Vermont | 50017 | 2 | 0 |
5089 | 5089 | 2020-03-19 | Washington | Vermont | 50023 | 1 | 0 |
5090 | 5090 | 2020-03-19 | Windsor | Vermont | 50027 | 3 | 1 |
5980 | 5980 | 2020-03-20 | Addison | Vermont | 50001 | 1 | 0 |
5981 | 5981 | 2020-03-20 | Bennington | Vermont | 50003 | 4 | 0 |
5982 | 5982 | 2020-03-20 | Chittenden | Vermont | 50007 | 12 | 1 |
5983 | 5983 | 2020-03-20 | Orange | Vermont | 50017 | 3 | 0 |
5984 | 5984 | 2020-03-20 | Rutland | Vermont | 50021 | 1 | 0 |
5985 | 5985 | 2020-03-20 | Washington | Vermont | 50023 | 2 | 0 |
5986 | 5986 | 2020-03-20 | Windsor | Vermont | 50027 | 6 | 1 |
7003 | 7003 | 2020-03-21 | Addison | Vermont | 50001 | 3 | 0 |
7004 | 7004 | 2020-03-21 | Bennington | Vermont | 50003 | 4 | 0 |
7005 | 7005 | 2020-03-21 | Chittenden | Vermont | 50007 | 22 | 1 |
7006 | 7006 | 2020-03-21 | Franklin | Vermont | 50011 | 2 | 0 |
7007 | 7007 | 2020-03-21 | Orange | Vermont | 50017 | 3 | 0 |
7008 | 7008 | 2020-03-21 | Rutland | Vermont | 50021 | 3 | 0 |
7009 | 7009 | 2020-03-21 | Washington | Vermont | 50023 | 2 | 0 |
7010 | 7010 | 2020-03-21 | Windham | Vermont | 50025 | 2 | 0 |
7011 | 7011 | 2020-03-21 | Windsor | Vermont | 50027 | 8 | 1 |
8133 | 8133 | 2020-03-22 | Addison | Vermont | 50001 | 3 | 0 |
8134 | 8134 | 2020-03-22 | Bennington | Vermont | 50003 | 4 | 0 |
8135 | 8135 | 2020-03-22 | Chittenden | Vermont | 50007 | 22 | 1 |
8136 | 8136 | 2020-03-22 | Franklin | Vermont | 50011 | 2 | 0 |
8137 | 8137 | 2020-03-22 | Orange | Vermont | 50017 | 3 | 0 |
8138 | 8138 | 2020-03-22 | Rutland | Vermont | 50021 | 3 | 0 |
8139 | 8139 | 2020-03-22 | Washington | Vermont | 50023 | 2 | 0 |
8140 | 8140 | 2020-03-22 | Windham | Vermont | 50025 | 5 | 0 |
8141 | 8141 | 2020-03-22 | Windsor | Vermont | 50027 | 8 | 1 |
9353 | 9353 | 2020-03-23 | Addison | Vermont | 50001 | 3 | 0 |
9354 | 9354 | 2020-03-23 | Bennington | Vermont | 50003 | 4 | 0 |
9355 | 9355 | 2020-03-23 | Chittenden | Vermont | 50007 | 22 | 1 |
9356 | 9356 | 2020-03-23 | Franklin | Vermont | 50011 | 2 | 0 |
9357 | 9357 | 2020-03-23 | Orange | Vermont | 50017 | 3 | 0 |
9358 | 9358 | 2020-03-23 | Rutland | Vermont | 50021 | 3 | 0 |
9359 | 9359 | 2020-03-23 | Unknown | Vermont | 23 | 0 | |
9360 | 9360 | 2020-03-23 | Washington | Vermont | 50023 | 2 | 0 |
9361 | 9361 | 2020-03-23 | Windham | Vermont | 50025 | 5 | 0 |
9362 | 9362 | 2020-03-23 | Windsor | Vermont | 50027 | 8 | 1 |
10697 | 10697 | 2020-03-24 | Addison | Vermont | 50001 | 8 | 0 |
10698 | 10698 | 2020-03-24 | Bennington | Vermont | 50003 | 9 | 0 |
10699 | 10699 | 2020-03-24 | Caledonia | Vermont | 50005 | 1 | 0 |
10700 | 10700 | 2020-03-24 | Chittenden | Vermont | 50007 | 40 | 1 |
10701 | 10701 | 2020-03-24 | Franklin | Vermont | 50011 | 2 | 0 |
10702 | 10702 | 2020-03-24 | Orange | Vermont | 50017 | 3 | 0 |
10703 | 10703 | 2020-03-24 | Orleans | Vermont | 50019 | 2 | 0 |
10704 | 10704 | 2020-03-24 | Rutland | Vermont | 50021 | 5 | 0 |
10705 | 10705 | 2020-03-24 | Unknown | Vermont | 2 | 5 | |
10706 | 10706 | 2020-03-24 | Washington | Vermont | 50023 | 3 | 0 |
10707 | 10707 | 2020-03-24 | Windham | Vermont | 50025 | 5 | 0 |
10708 | 10708 | 2020-03-24 | Windsor | Vermont | 50027 | 15 | 1 |
12208 | 12208 | 2020-03-25 | Addison | Vermont | 50001 | 9 | 0 |
12209 | 12209 | 2020-03-25 | Bennington | Vermont | 50003 | 11 | 0 |
12210 | 12210 | 2020-03-25 | Caledonia | Vermont | 50005 | 1 | 0 |
12211 | 12211 | 2020-03-25 | Chittenden | Vermont | 50007 | 55 | 6 |
12212 | 12212 | 2020-03-25 | Franklin | Vermont | 50011 | 3 | 0 |
12213 | 12213 | 2020-03-25 | Lamoille | Vermont | 50015 | 4 | 0 |
12214 | 12214 | 2020-03-25 | Orange | Vermont | 50017 | 3 | 0 |
12215 | 12215 | 2020-03-25 | Orleans | Vermont | 50019 | 3 | 0 |
12216 | 12216 | 2020-03-25 | Rutland | Vermont | 50021 | 5 | 0 |
12217 | 12217 | 2020-03-25 | Unknown | Vermont | 0 | 1 | |
12218 | 12218 | 2020-03-25 | Washington | Vermont | 50023 | 5 | 0 |
12219 | 12219 | 2020-03-25 | Windham | Vermont | 50025 | 7 | 0 |
12220 | 12220 | 2020-03-25 | Windsor | Vermont | 50027 | 17 | 1 |
13844 | 13844 | 2020-03-26 | Addison | Vermont | 50001 | 12 | 0 |
13845 | 13845 | 2020-03-26 | Bennington | Vermont | 50003 | 11 | 0 |
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);