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 465
- Chittenden 461
- Washington 458
- Windsor 458
- Orange 456
- Addison 452
- Rutland 452
- Franklin 451
- Windham 451
- Unknown 449
- Caledonia 448
- Orleans 448
- Lamoille 447
- Grand Isle 434
- Essex 433
state 1
- Vermont · 6,763 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420035 | 1420035 | 2021-06-14 | Addison | Vermont | 50001 | 1062 | 8 |
1420036 | 1420036 | 2021-06-14 | Bennington | Vermont | 50003 | 2046 | 15 |
1420037 | 1420037 | 2021-06-14 | Caledonia | Vermont | 50005 | 1074 | 7 |
1420038 | 1420038 | 2021-06-14 | Chittenden | Vermont | 50007 | 7515 | 104 |
1420039 | 1420039 | 2021-06-14 | Essex | Vermont | 50009 | 295 | 2 |
1420040 | 1420040 | 2021-06-14 | Franklin | Vermont | 50011 | 2030 | 39 |
1420041 | 1420041 | 2021-06-14 | Grand Isle | Vermont | 50013 | 217 | 2 |
1420042 | 1420042 | 2021-06-14 | Lamoille | Vermont | 50015 | 888 | 3 |
1420043 | 1420043 | 2021-06-14 | Orange | Vermont | 50017 | 822 | 3 |
1420044 | 1420044 | 2021-06-14 | Orleans | Vermont | 50019 | 1292 | 11 |
1420045 | 1420045 | 2021-06-14 | Rutland | Vermont | 50021 | 2281 | 20 |
1420046 | 1420046 | 2021-06-14 | Unknown | Vermont | 20 | 0 | |
1420047 | 1420047 | 2021-06-14 | Washington | Vermont | 50023 | 1897 | 15 |
1420048 | 1420048 | 2021-06-14 | Windham | Vermont | 50025 | 1389 | 14 |
1420049 | 1420049 | 2021-06-14 | Windsor | Vermont | 50027 | 1503 | 13 |
1416790 | 1416790 | 2021-06-13 | Addison | Vermont | 50001 | 1062 | 8 |
1416791 | 1416791 | 2021-06-13 | Bennington | Vermont | 50003 | 2046 | 15 |
1416792 | 1416792 | 2021-06-13 | Caledonia | Vermont | 50005 | 1073 | 7 |
1416793 | 1416793 | 2021-06-13 | Chittenden | Vermont | 50007 | 7510 | 104 |
1416794 | 1416794 | 2021-06-13 | Essex | Vermont | 50009 | 295 | 2 |
1416795 | 1416795 | 2021-06-13 | Franklin | Vermont | 50011 | 2029 | 39 |
1416796 | 1416796 | 2021-06-13 | Grand Isle | Vermont | 50013 | 217 | 2 |
1416797 | 1416797 | 2021-06-13 | Lamoille | Vermont | 50015 | 888 | 3 |
1416798 | 1416798 | 2021-06-13 | Orange | Vermont | 50017 | 821 | 3 |
1416799 | 1416799 | 2021-06-13 | Orleans | Vermont | 50019 | 1292 | 11 |
1416800 | 1416800 | 2021-06-13 | Rutland | Vermont | 50021 | 2280 | 20 |
1416801 | 1416801 | 2021-06-13 | Unknown | Vermont | 21 | 0 | |
1416802 | 1416802 | 2021-06-13 | Washington | Vermont | 50023 | 1897 | 15 |
1416803 | 1416803 | 2021-06-13 | Windham | Vermont | 50025 | 1387 | 14 |
1416804 | 1416804 | 2021-06-13 | Windsor | Vermont | 50027 | 1502 | 13 |
1413544 | 1413544 | 2021-06-12 | Addison | Vermont | 50001 | 1062 | 8 |
1413545 | 1413545 | 2021-06-12 | Bennington | Vermont | 50003 | 2046 | 15 |
1413546 | 1413546 | 2021-06-12 | Caledonia | Vermont | 50005 | 1073 | 7 |
1413547 | 1413547 | 2021-06-12 | Chittenden | Vermont | 50007 | 7510 | 104 |
1413548 | 1413548 | 2021-06-12 | Essex | Vermont | 50009 | 295 | 2 |
1413549 | 1413549 | 2021-06-12 | Franklin | Vermont | 50011 | 2029 | 39 |
1413550 | 1413550 | 2021-06-12 | Grand Isle | Vermont | 50013 | 217 | 2 |
1413551 | 1413551 | 2021-06-12 | Lamoille | Vermont | 50015 | 888 | 3 |
1413552 | 1413552 | 2021-06-12 | Orange | Vermont | 50017 | 821 | 3 |
1413553 | 1413553 | 2021-06-12 | Orleans | Vermont | 50019 | 1292 | 11 |
1413554 | 1413554 | 2021-06-12 | Rutland | Vermont | 50021 | 2280 | 20 |
1413555 | 1413555 | 2021-06-12 | Unknown | Vermont | 21 | 0 | |
1413556 | 1413556 | 2021-06-12 | Washington | Vermont | 50023 | 1897 | 15 |
1413557 | 1413557 | 2021-06-12 | Windham | Vermont | 50025 | 1387 | 14 |
1413558 | 1413558 | 2021-06-12 | Windsor | Vermont | 50027 | 1502 | 13 |
1410299 | 1410299 | 2021-06-11 | Addison | Vermont | 50001 | 1062 | 8 |
1410300 | 1410300 | 2021-06-11 | Bennington | Vermont | 50003 | 2046 | 15 |
1410301 | 1410301 | 2021-06-11 | Caledonia | Vermont | 50005 | 1073 | 7 |
1410302 | 1410302 | 2021-06-11 | Chittenden | Vermont | 50007 | 7510 | 104 |
1410303 | 1410303 | 2021-06-11 | Essex | Vermont | 50009 | 295 | 2 |
1410304 | 1410304 | 2021-06-11 | Franklin | Vermont | 50011 | 2029 | 39 |
1410305 | 1410305 | 2021-06-11 | Grand Isle | Vermont | 50013 | 217 | 2 |
1410306 | 1410306 | 2021-06-11 | Lamoille | Vermont | 50015 | 888 | 3 |
1410307 | 1410307 | 2021-06-11 | Orange | Vermont | 50017 | 821 | 3 |
1410308 | 1410308 | 2021-06-11 | Orleans | Vermont | 50019 | 1292 | 11 |
1410309 | 1410309 | 2021-06-11 | Rutland | Vermont | 50021 | 2280 | 20 |
1410310 | 1410310 | 2021-06-11 | Unknown | Vermont | 21 | 0 | |
1410311 | 1410311 | 2021-06-11 | Washington | Vermont | 50023 | 1897 | 15 |
1410312 | 1410312 | 2021-06-11 | Windham | Vermont | 50025 | 1387 | 14 |
1410313 | 1410313 | 2021-06-11 | Windsor | Vermont | 50027 | 1502 | 13 |
1407054 | 1407054 | 2021-06-10 | Addison | Vermont | 50001 | 1062 | 8 |
1407055 | 1407055 | 2021-06-10 | Bennington | Vermont | 50003 | 2046 | 15 |
1407056 | 1407056 | 2021-06-10 | Caledonia | Vermont | 50005 | 1073 | 7 |
1407057 | 1407057 | 2021-06-10 | Chittenden | Vermont | 50007 | 7508 | 104 |
1407058 | 1407058 | 2021-06-10 | Essex | Vermont | 50009 | 294 | 2 |
1407059 | 1407059 | 2021-06-10 | Franklin | Vermont | 50011 | 2029 | 39 |
1407060 | 1407060 | 2021-06-10 | Grand Isle | Vermont | 50013 | 217 | 2 |
1407061 | 1407061 | 2021-06-10 | Lamoille | Vermont | 50015 | 887 | 3 |
1407062 | 1407062 | 2021-06-10 | Orange | Vermont | 50017 | 820 | 3 |
1407063 | 1407063 | 2021-06-10 | Orleans | Vermont | 50019 | 1292 | 11 |
1407064 | 1407064 | 2021-06-10 | Rutland | Vermont | 50021 | 2280 | 20 |
1407065 | 1407065 | 2021-06-10 | Unknown | Vermont | 22 | 0 | |
1407066 | 1407066 | 2021-06-10 | Washington | Vermont | 50023 | 1896 | 15 |
1407067 | 1407067 | 2021-06-10 | Windham | Vermont | 50025 | 1387 | 14 |
1407068 | 1407068 | 2021-06-10 | Windsor | Vermont | 50027 | 1501 | 13 |
1403808 | 1403808 | 2021-06-09 | Addison | Vermont | 50001 | 1062 | 8 |
1403809 | 1403809 | 2021-06-09 | Bennington | Vermont | 50003 | 2046 | 15 |
1403810 | 1403810 | 2021-06-09 | Caledonia | Vermont | 50005 | 1073 | 7 |
1403811 | 1403811 | 2021-06-09 | Chittenden | Vermont | 50007 | 7505 | 104 |
1403812 | 1403812 | 2021-06-09 | Essex | Vermont | 50009 | 294 | 2 |
1403813 | 1403813 | 2021-06-09 | Franklin | Vermont | 50011 | 2028 | 39 |
1403814 | 1403814 | 2021-06-09 | Grand Isle | Vermont | 50013 | 217 | 2 |
1403815 | 1403815 | 2021-06-09 | Lamoille | Vermont | 50015 | 887 | 3 |
1403816 | 1403816 | 2021-06-09 | Orange | Vermont | 50017 | 818 | 3 |
1403817 | 1403817 | 2021-06-09 | Orleans | Vermont | 50019 | 1291 | 11 |
1403818 | 1403818 | 2021-06-09 | Rutland | Vermont | 50021 | 2280 | 20 |
1403819 | 1403819 | 2021-06-09 | Unknown | Vermont | 22 | 0 | |
1403820 | 1403820 | 2021-06-09 | Washington | Vermont | 50023 | 1894 | 15 |
1403821 | 1403821 | 2021-06-09 | Windham | Vermont | 50025 | 1385 | 14 |
1403822 | 1403822 | 2021-06-09 | Windsor | Vermont | 50027 | 1498 | 13 |
1400563 | 1400563 | 2021-06-08 | Addison | Vermont | 50001 | 1062 | 8 |
1400564 | 1400564 | 2021-06-08 | Bennington | Vermont | 50003 | 2046 | 15 |
1400565 | 1400565 | 2021-06-08 | Caledonia | Vermont | 50005 | 1073 | 7 |
1400566 | 1400566 | 2021-06-08 | Chittenden | Vermont | 50007 | 7503 | 104 |
1400567 | 1400567 | 2021-06-08 | Essex | Vermont | 50009 | 294 | 2 |
1400568 | 1400568 | 2021-06-08 | Franklin | Vermont | 50011 | 2028 | 39 |
1400569 | 1400569 | 2021-06-08 | Grand Isle | Vermont | 50013 | 217 | 2 |
1400570 | 1400570 | 2021-06-08 | Lamoille | Vermont | 50015 | 887 | 3 |
1400571 | 1400571 | 2021-06-08 | Orange | Vermont | 50017 | 819 | 3 |
1400572 | 1400572 | 2021-06-08 | Orleans | Vermont | 50019 | 1291 | 11 |
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);