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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 15
county 15
- Bennington 147
- Chittenden 143
- Washington 140
- Windsor 140
- Orange 138
- Addison 134
- Rutland 134
- Franklin 133
- Windham 133
- Unknown 131
- Caledonia 130
- Orleans 130
- Lamoille 129
- Grand Isle 116
- Essex 115
state 1
- Vermont · 1,993 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388815 | 388815 | 2020-07-31 | Addison | Vermont | 50001 | 71 | 2 |
388816 | 388816 | 2020-07-31 | Bennington | Vermont | 50003 | 83 | 1 |
388817 | 388817 | 2020-07-31 | Caledonia | Vermont | 50005 | 26 | 0 |
388818 | 388818 | 2020-07-31 | Chittenden | Vermont | 50007 | 715 | 39 |
388819 | 388819 | 2020-07-31 | Essex | Vermont | 50009 | 4 | 0 |
388820 | 388820 | 2020-07-31 | Franklin | Vermont | 50011 | 117 | 6 |
388821 | 388821 | 2020-07-31 | Grand Isle | Vermont | 50013 | 13 | 0 |
388822 | 388822 | 2020-07-31 | Lamoille | Vermont | 50015 | 42 | 1 |
388823 | 388823 | 2020-07-31 | Orange | Vermont | 50017 | 15 | 0 |
388824 | 388824 | 2020-07-31 | Orleans | Vermont | 50019 | 14 | 0 |
388825 | 388825 | 2020-07-31 | Rutland | Vermont | 50021 | 89 | 1 |
388826 | 388826 | 2020-07-31 | Unknown | Vermont | 7 | 0 | |
388827 | 388827 | 2020-07-31 | Washington | Vermont | 50023 | 47 | 2 |
388828 | 388828 | 2020-07-31 | Windham | Vermont | 50025 | 101 | 3 |
388829 | 388829 | 2020-07-31 | Windsor | Vermont | 50027 | 70 | 2 |
385598 | 385598 | 2020-07-30 | Addison | Vermont | 50001 | 71 | 2 |
385599 | 385599 | 2020-07-30 | Bennington | Vermont | 50003 | 83 | 1 |
385600 | 385600 | 2020-07-30 | Caledonia | Vermont | 50005 | 26 | 0 |
385601 | 385601 | 2020-07-30 | Chittenden | Vermont | 50007 | 715 | 39 |
385602 | 385602 | 2020-07-30 | Essex | Vermont | 50009 | 4 | 0 |
385603 | 385603 | 2020-07-30 | Franklin | Vermont | 50011 | 115 | 6 |
385604 | 385604 | 2020-07-30 | Grand Isle | Vermont | 50013 | 13 | 0 |
385605 | 385605 | 2020-07-30 | Lamoille | Vermont | 50015 | 42 | 1 |
385606 | 385606 | 2020-07-30 | Orange | Vermont | 50017 | 15 | 0 |
385607 | 385607 | 2020-07-30 | Orleans | Vermont | 50019 | 14 | 0 |
385608 | 385608 | 2020-07-30 | Rutland | Vermont | 50021 | 84 | 1 |
385609 | 385609 | 2020-07-30 | Unknown | Vermont | 7 | 0 | |
385610 | 385610 | 2020-07-30 | Washington | Vermont | 50023 | 47 | 2 |
385611 | 385611 | 2020-07-30 | Windham | Vermont | 50025 | 101 | 3 |
385612 | 385612 | 2020-07-30 | Windsor | Vermont | 50027 | 70 | 2 |
382380 | 382380 | 2020-07-29 | Addison | Vermont | 50001 | 71 | 2 |
382381 | 382381 | 2020-07-29 | Bennington | Vermont | 50003 | 83 | 1 |
382382 | 382382 | 2020-07-29 | Caledonia | Vermont | 50005 | 26 | 0 |
382383 | 382383 | 2020-07-29 | Chittenden | Vermont | 50007 | 715 | 39 |
382384 | 382384 | 2020-07-29 | Essex | Vermont | 50009 | 4 | 0 |
382385 | 382385 | 2020-07-29 | Franklin | Vermont | 50011 | 115 | 6 |
382386 | 382386 | 2020-07-29 | Grand Isle | Vermont | 50013 | 13 | 0 |
382387 | 382387 | 2020-07-29 | Lamoille | Vermont | 50015 | 42 | 1 |
382388 | 382388 | 2020-07-29 | Orange | Vermont | 50017 | 15 | 0 |
382389 | 382389 | 2020-07-29 | Orleans | Vermont | 50019 | 14 | 0 |
382390 | 382390 | 2020-07-29 | Rutland | Vermont | 50021 | 84 | 1 |
382391 | 382391 | 2020-07-29 | Unknown | Vermont | 7 | 0 | |
382392 | 382392 | 2020-07-29 | Washington | Vermont | 50023 | 47 | 1 |
382393 | 382393 | 2020-07-29 | Windham | Vermont | 50025 | 101 | 3 |
382394 | 382394 | 2020-07-29 | Windsor | Vermont | 50027 | 69 | 2 |
379163 | 379163 | 2020-07-28 | Addison | Vermont | 50001 | 71 | 2 |
379164 | 379164 | 2020-07-28 | Bennington | Vermont | 50003 | 82 | 1 |
379165 | 379165 | 2020-07-28 | Caledonia | Vermont | 50005 | 26 | 0 |
379166 | 379166 | 2020-07-28 | Chittenden | Vermont | 50007 | 715 | 39 |
379167 | 379167 | 2020-07-28 | Essex | Vermont | 50009 | 4 | 0 |
379168 | 379168 | 2020-07-28 | Franklin | Vermont | 50011 | 115 | 6 |
379169 | 379169 | 2020-07-28 | Grand Isle | Vermont | 50013 | 13 | 0 |
379170 | 379170 | 2020-07-28 | Lamoille | Vermont | 50015 | 42 | 1 |
379171 | 379171 | 2020-07-28 | Orange | Vermont | 50017 | 15 | 0 |
379172 | 379172 | 2020-07-28 | Orleans | Vermont | 50019 | 14 | 0 |
379173 | 379173 | 2020-07-28 | Rutland | Vermont | 50021 | 84 | 1 |
379174 | 379174 | 2020-07-28 | Unknown | Vermont | 7 | 0 | |
379175 | 379175 | 2020-07-28 | Washington | Vermont | 50023 | 47 | 1 |
379176 | 379176 | 2020-07-28 | Windham | Vermont | 50025 | 101 | 3 |
379177 | 379177 | 2020-07-28 | Windsor | Vermont | 50027 | 69 | 2 |
375947 | 375947 | 2020-07-27 | Addison | Vermont | 50001 | 71 | 2 |
375948 | 375948 | 2020-07-27 | Bennington | Vermont | 50003 | 82 | 1 |
375949 | 375949 | 2020-07-27 | Caledonia | Vermont | 50005 | 25 | 0 |
375950 | 375950 | 2020-07-27 | Chittenden | Vermont | 50007 | 713 | 39 |
375951 | 375951 | 2020-07-27 | Essex | Vermont | 50009 | 4 | 0 |
375952 | 375952 | 2020-07-27 | Franklin | Vermont | 50011 | 115 | 6 |
375953 | 375953 | 2020-07-27 | Grand Isle | Vermont | 50013 | 13 | 0 |
375954 | 375954 | 2020-07-27 | Lamoille | Vermont | 50015 | 42 | 1 |
375955 | 375955 | 2020-07-27 | Orange | Vermont | 50017 | 15 | 0 |
375956 | 375956 | 2020-07-27 | Orleans | Vermont | 50019 | 14 | 0 |
375957 | 375957 | 2020-07-27 | Rutland | Vermont | 50021 | 84 | 1 |
375958 | 375958 | 2020-07-27 | Unknown | Vermont | 7 | 0 | |
375959 | 375959 | 2020-07-27 | Washington | Vermont | 50023 | 47 | 1 |
375960 | 375960 | 2020-07-27 | Windham | Vermont | 50025 | 101 | 3 |
375961 | 375961 | 2020-07-27 | Windsor | Vermont | 50027 | 69 | 2 |
372733 | 372733 | 2020-07-26 | Addison | Vermont | 50001 | 71 | 2 |
372734 | 372734 | 2020-07-26 | Bennington | Vermont | 50003 | 82 | 1 |
372735 | 372735 | 2020-07-26 | Caledonia | Vermont | 50005 | 25 | 0 |
372736 | 372736 | 2020-07-26 | Chittenden | Vermont | 50007 | 713 | 39 |
372737 | 372737 | 2020-07-26 | Essex | Vermont | 50009 | 4 | 0 |
372738 | 372738 | 2020-07-26 | Franklin | Vermont | 50011 | 114 | 6 |
372739 | 372739 | 2020-07-26 | Grand Isle | Vermont | 50013 | 13 | 0 |
372740 | 372740 | 2020-07-26 | Lamoille | Vermont | 50015 | 42 | 1 |
372741 | 372741 | 2020-07-26 | Orange | Vermont | 50017 | 14 | 0 |
372742 | 372742 | 2020-07-26 | Orleans | Vermont | 50019 | 14 | 0 |
372743 | 372743 | 2020-07-26 | Rutland | Vermont | 50021 | 84 | 1 |
372744 | 372744 | 2020-07-26 | Unknown | Vermont | 7 | 0 | |
372745 | 372745 | 2020-07-26 | Washington | Vermont | 50023 | 47 | 1 |
372746 | 372746 | 2020-07-26 | Windham | Vermont | 50025 | 101 | 3 |
372747 | 372747 | 2020-07-26 | Windsor | Vermont | 50027 | 69 | 2 |
369521 | 369521 | 2020-07-25 | Addison | Vermont | 50001 | 71 | 2 |
369522 | 369522 | 2020-07-25 | Bennington | Vermont | 50003 | 81 | 1 |
369523 | 369523 | 2020-07-25 | Caledonia | Vermont | 50005 | 25 | 0 |
369524 | 369524 | 2020-07-25 | Chittenden | Vermont | 50007 | 711 | 39 |
369525 | 369525 | 2020-07-25 | Essex | Vermont | 50009 | 4 | 0 |
369526 | 369526 | 2020-07-25 | Franklin | Vermont | 50011 | 114 | 6 |
369527 | 369527 | 2020-07-25 | Grand Isle | Vermont | 50013 | 13 | 0 |
369528 | 369528 | 2020-07-25 | Lamoille | Vermont | 50015 | 42 | 1 |
369529 | 369529 | 2020-07-25 | Orange | Vermont | 50017 | 14 | 0 |
369530 | 369530 | 2020-07-25 | Orleans | Vermont | 50019 | 14 | 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);