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 353
- Chittenden 349
- Washington 346
- Windsor 346
- Orange 344
- Addison 340
- Rutland 340
- Franklin 339
- Windham 339
- Unknown 337
- Caledonia 336
- Orleans 336
- Lamoille 335
- Grand Isle 322
- Essex 321
state 1
- Vermont · 5,083 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056412 | 1056412 | 2021-02-22 | Addison | Vermont | 50001 | 709 | 8 |
1056413 | 1056413 | 2021-02-22 | Bennington | Vermont | 50003 | 1384 | 8 |
1056414 | 1056414 | 2021-02-22 | Caledonia | Vermont | 50005 | 404 | 5 |
1056415 | 1056415 | 2021-02-22 | Chittenden | Vermont | 50007 | 4712 | 85 |
1056416 | 1056416 | 2021-02-22 | Essex | Vermont | 50009 | 160 | 1 |
1056417 | 1056417 | 2021-02-22 | Franklin | Vermont | 50011 | 1166 | 35 |
1056418 | 1056418 | 2021-02-22 | Grand Isle | Vermont | 50013 | 101 | 0 |
1056419 | 1056419 | 2021-02-22 | Lamoille | Vermont | 50015 | 435 | 2 |
1056420 | 1056420 | 2021-02-22 | Orange | Vermont | 50017 | 494 | 2 |
1056421 | 1056421 | 2021-02-22 | Orleans | Vermont | 50019 | 409 | 6 |
1056422 | 1056422 | 2021-02-22 | Rutland | Vermont | 50021 | 1252 | 12 |
1056423 | 1056423 | 2021-02-22 | Unknown | Vermont | 8 | 0 | |
1056424 | 1056424 | 2021-02-22 | Washington | Vermont | 50023 | 1424 | 13 |
1056425 | 1056425 | 2021-02-22 | Windham | Vermont | 50025 | 933 | 12 |
1056426 | 1056426 | 2021-02-22 | Windsor | Vermont | 50027 | 1017 | 9 |
1053166 | 1053166 | 2021-02-21 | Addison | Vermont | 50001 | 705 | 8 |
1053167 | 1053167 | 2021-02-21 | Bennington | Vermont | 50003 | 1372 | 8 |
1053168 | 1053168 | 2021-02-21 | Caledonia | Vermont | 50005 | 402 | 5 |
1053169 | 1053169 | 2021-02-21 | Chittenden | Vermont | 50007 | 4664 | 85 |
1053170 | 1053170 | 2021-02-21 | Essex | Vermont | 50009 | 160 | 1 |
1053171 | 1053171 | 2021-02-21 | Franklin | Vermont | 50011 | 1159 | 35 |
1053172 | 1053172 | 2021-02-21 | Grand Isle | Vermont | 50013 | 100 | 0 |
1053173 | 1053173 | 2021-02-21 | Lamoille | Vermont | 50015 | 428 | 2 |
1053174 | 1053174 | 2021-02-21 | Orange | Vermont | 50017 | 492 | 2 |
1053175 | 1053175 | 2021-02-21 | Orleans | Vermont | 50019 | 408 | 6 |
1053176 | 1053176 | 2021-02-21 | Rutland | Vermont | 50021 | 1242 | 11 |
1053177 | 1053177 | 2021-02-21 | Unknown | Vermont | 8 | 0 | |
1053178 | 1053178 | 2021-02-21 | Washington | Vermont | 50023 | 1416 | 13 |
1053179 | 1053179 | 2021-02-21 | Windham | Vermont | 50025 | 925 | 12 |
1053180 | 1053180 | 2021-02-21 | Windsor | Vermont | 50027 | 1012 | 9 |
1049919 | 1049919 | 2021-02-20 | Addison | Vermont | 50001 | 696 | 8 |
1049920 | 1049920 | 2021-02-20 | Bennington | Vermont | 50003 | 1360 | 8 |
1049921 | 1049921 | 2021-02-20 | Caledonia | Vermont | 50005 | 401 | 5 |
1049922 | 1049922 | 2021-02-20 | Chittenden | Vermont | 50007 | 4620 | 85 |
1049923 | 1049923 | 2021-02-20 | Essex | Vermont | 50009 | 160 | 1 |
1049924 | 1049924 | 2021-02-20 | Franklin | Vermont | 50011 | 1133 | 35 |
1049925 | 1049925 | 2021-02-20 | Grand Isle | Vermont | 50013 | 99 | 0 |
1049926 | 1049926 | 2021-02-20 | Lamoille | Vermont | 50015 | 424 | 2 |
1049927 | 1049927 | 2021-02-20 | Orange | Vermont | 50017 | 488 | 2 |
1049928 | 1049928 | 2021-02-20 | Orleans | Vermont | 50019 | 405 | 6 |
1049929 | 1049929 | 2021-02-20 | Rutland | Vermont | 50021 | 1230 | 10 |
1049930 | 1049930 | 2021-02-20 | Unknown | Vermont | 9 | 0 | |
1049931 | 1049931 | 2021-02-20 | Washington | Vermont | 50023 | 1406 | 13 |
1049932 | 1049932 | 2021-02-20 | Windham | Vermont | 50025 | 919 | 12 |
1049933 | 1049933 | 2021-02-20 | Windsor | Vermont | 50027 | 1009 | 9 |
1046672 | 1046672 | 2021-02-19 | Addison | Vermont | 50001 | 685 | 8 |
1046673 | 1046673 | 2021-02-19 | Bennington | Vermont | 50003 | 1352 | 8 |
1046674 | 1046674 | 2021-02-19 | Caledonia | Vermont | 50005 | 401 | 5 |
1046675 | 1046675 | 2021-02-19 | Chittenden | Vermont | 50007 | 4590 | 83 |
1046676 | 1046676 | 2021-02-19 | Essex | Vermont | 50009 | 158 | 1 |
1046677 | 1046677 | 2021-02-19 | Franklin | Vermont | 50011 | 1107 | 35 |
1046678 | 1046678 | 2021-02-19 | Grand Isle | Vermont | 50013 | 97 | 0 |
1046679 | 1046679 | 2021-02-19 | Lamoille | Vermont | 50015 | 420 | 2 |
1046680 | 1046680 | 2021-02-19 | Orange | Vermont | 50017 | 482 | 2 |
1046681 | 1046681 | 2021-02-19 | Orleans | Vermont | 50019 | 404 | 6 |
1046682 | 1046682 | 2021-02-19 | Rutland | Vermont | 50021 | 1227 | 9 |
1046683 | 1046683 | 2021-02-19 | Unknown | Vermont | 8 | 0 | |
1046684 | 1046684 | 2021-02-19 | Washington | Vermont | 50023 | 1404 | 13 |
1046685 | 1046685 | 2021-02-19 | Windham | Vermont | 50025 | 909 | 12 |
1046686 | 1046686 | 2021-02-19 | Windsor | Vermont | 50027 | 1007 | 9 |
1043427 | 1043427 | 2021-02-18 | Addison | Vermont | 50001 | 684 | 8 |
1043428 | 1043428 | 2021-02-18 | Bennington | Vermont | 50003 | 1345 | 8 |
1043429 | 1043429 | 2021-02-18 | Caledonia | Vermont | 50005 | 399 | 5 |
1043430 | 1043430 | 2021-02-18 | Chittenden | Vermont | 50007 | 4553 | 83 |
1043431 | 1043431 | 2021-02-18 | Essex | Vermont | 50009 | 158 | 1 |
1043432 | 1043432 | 2021-02-18 | Franklin | Vermont | 50011 | 1095 | 35 |
1043433 | 1043433 | 2021-02-18 | Grand Isle | Vermont | 50013 | 96 | 0 |
1043434 | 1043434 | 2021-02-18 | Lamoille | Vermont | 50015 | 413 | 2 |
1043435 | 1043435 | 2021-02-18 | Orange | Vermont | 50017 | 481 | 2 |
1043436 | 1043436 | 2021-02-18 | Orleans | Vermont | 50019 | 398 | 6 |
1043437 | 1043437 | 2021-02-18 | Rutland | Vermont | 50021 | 1222 | 9 |
1043438 | 1043438 | 2021-02-18 | Unknown | Vermont | 8 | 0 | |
1043439 | 1043439 | 2021-02-18 | Washington | Vermont | 50023 | 1400 | 13 |
1043440 | 1043440 | 2021-02-18 | Windham | Vermont | 50025 | 895 | 12 |
1043441 | 1043441 | 2021-02-18 | Windsor | Vermont | 50027 | 1002 | 9 |
1040182 | 1040182 | 2021-02-17 | Addison | Vermont | 50001 | 676 | 8 |
1040183 | 1040183 | 2021-02-17 | Bennington | Vermont | 50003 | 1334 | 8 |
1040184 | 1040184 | 2021-02-17 | Caledonia | Vermont | 50005 | 396 | 5 |
1040185 | 1040185 | 2021-02-17 | Chittenden | Vermont | 50007 | 4502 | 82 |
1040186 | 1040186 | 2021-02-17 | Essex | Vermont | 50009 | 158 | 1 |
1040187 | 1040187 | 2021-02-17 | Franklin | Vermont | 50011 | 1079 | 35 |
1040188 | 1040188 | 2021-02-17 | Grand Isle | Vermont | 50013 | 93 | 0 |
1040189 | 1040189 | 2021-02-17 | Lamoille | Vermont | 50015 | 410 | 2 |
1040190 | 1040190 | 2021-02-17 | Orange | Vermont | 50017 | 478 | 2 |
1040191 | 1040191 | 2021-02-17 | Orleans | Vermont | 50019 | 395 | 6 |
1040192 | 1040192 | 2021-02-17 | Rutland | Vermont | 50021 | 1207 | 9 |
1040193 | 1040193 | 2021-02-17 | Unknown | Vermont | 8 | 0 | |
1040194 | 1040194 | 2021-02-17 | Washington | Vermont | 50023 | 1384 | 12 |
1040195 | 1040195 | 2021-02-17 | Windham | Vermont | 50025 | 880 | 12 |
1040196 | 1040196 | 2021-02-17 | Windsor | Vermont | 50027 | 996 | 9 |
1036937 | 1036937 | 2021-02-16 | Addison | Vermont | 50001 | 674 | 8 |
1036938 | 1036938 | 2021-02-16 | Bennington | Vermont | 50003 | 1330 | 8 |
1036939 | 1036939 | 2021-02-16 | Caledonia | Vermont | 50005 | 393 | 5 |
1036940 | 1036940 | 2021-02-16 | Chittenden | Vermont | 50007 | 4481 | 82 |
1036941 | 1036941 | 2021-02-16 | Essex | Vermont | 50009 | 154 | 1 |
1036942 | 1036942 | 2021-02-16 | Franklin | Vermont | 50011 | 1065 | 35 |
1036943 | 1036943 | 2021-02-16 | Grand Isle | Vermont | 50013 | 93 | 0 |
1036944 | 1036944 | 2021-02-16 | Lamoille | Vermont | 50015 | 408 | 2 |
1036945 | 1036945 | 2021-02-16 | Orange | Vermont | 50017 | 476 | 2 |
1036946 | 1036946 | 2021-02-16 | Orleans | Vermont | 50019 | 395 | 6 |
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);