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 224
- Chittenden 220
- Washington 217
- Windsor 217
- Orange 215
- Addison 211
- Rutland 211
- Franklin 210
- Windham 210
- Unknown 208
- Caledonia 207
- Orleans 207
- Lamoille 206
- Grand Isle 193
- Essex 192
state 1
- Vermont · 3,148 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637788 | 637788 | 2020-10-16 | Addison | Vermont | 50001 | 114 | 2 |
637789 | 637789 | 2020-10-16 | Bennington | Vermont | 50003 | 132 | 1 |
637790 | 637790 | 2020-10-16 | Caledonia | Vermont | 50005 | 35 | 0 |
637791 | 637791 | 2020-10-16 | Chittenden | Vermont | 50007 | 897 | 39 |
637792 | 637792 | 2020-10-16 | Essex | Vermont | 50009 | 6 | 0 |
637793 | 637793 | 2020-10-16 | Franklin | Vermont | 50011 | 131 | 7 |
637794 | 637794 | 2020-10-16 | Grand Isle | Vermont | 50013 | 16 | 0 |
637795 | 637795 | 2020-10-16 | Lamoille | Vermont | 50015 | 60 | 1 |
637796 | 637796 | 2020-10-16 | Orange | Vermont | 50017 | 28 | 0 |
637797 | 637797 | 2020-10-16 | Orleans | Vermont | 50019 | 24 | 0 |
637798 | 637798 | 2020-10-16 | Rutland | Vermont | 50021 | 133 | 1 |
637799 | 637799 | 2020-10-16 | Unknown | Vermont | 8 | 0 | |
637800 | 637800 | 2020-10-16 | Washington | Vermont | 50023 | 94 | 2 |
637801 | 637801 | 2020-10-16 | Windham | Vermont | 50025 | 131 | 3 |
637802 | 637802 | 2020-10-16 | Windsor | Vermont | 50027 | 106 | 2 |
634543 | 634543 | 2020-10-15 | Addison | Vermont | 50001 | 114 | 2 |
634544 | 634544 | 2020-10-15 | Bennington | Vermont | 50003 | 129 | 1 |
634545 | 634545 | 2020-10-15 | Caledonia | Vermont | 50005 | 35 | 0 |
634546 | 634546 | 2020-10-15 | Chittenden | Vermont | 50007 | 891 | 39 |
634547 | 634547 | 2020-10-15 | Essex | Vermont | 50009 | 6 | 0 |
634548 | 634548 | 2020-10-15 | Franklin | Vermont | 50011 | 131 | 7 |
634549 | 634549 | 2020-10-15 | Grand Isle | Vermont | 50013 | 16 | 0 |
634550 | 634550 | 2020-10-15 | Lamoille | Vermont | 50015 | 61 | 1 |
634551 | 634551 | 2020-10-15 | Orange | Vermont | 50017 | 27 | 0 |
634552 | 634552 | 2020-10-15 | Orleans | Vermont | 50019 | 24 | 0 |
634553 | 634553 | 2020-10-15 | Rutland | Vermont | 50021 | 134 | 1 |
634554 | 634554 | 2020-10-15 | Unknown | Vermont | 8 | 0 | |
634555 | 634555 | 2020-10-15 | Washington | Vermont | 50023 | 92 | 2 |
634556 | 634556 | 2020-10-15 | Windham | Vermont | 50025 | 130 | 3 |
634557 | 634557 | 2020-10-15 | Windsor | Vermont | 50027 | 105 | 2 |
631298 | 631298 | 2020-10-14 | Addison | Vermont | 50001 | 113 | 2 |
631299 | 631299 | 2020-10-14 | Bennington | Vermont | 50003 | 129 | 1 |
631300 | 631300 | 2020-10-14 | Caledonia | Vermont | 50005 | 35 | 0 |
631301 | 631301 | 2020-10-14 | Chittenden | Vermont | 50007 | 885 | 39 |
631302 | 631302 | 2020-10-14 | Essex | Vermont | 50009 | 6 | 0 |
631303 | 631303 | 2020-10-14 | Franklin | Vermont | 50011 | 131 | 7 |
631304 | 631304 | 2020-10-14 | Grand Isle | Vermont | 50013 | 16 | 0 |
631305 | 631305 | 2020-10-14 | Lamoille | Vermont | 50015 | 59 | 1 |
631306 | 631306 | 2020-10-14 | Orange | Vermont | 50017 | 27 | 0 |
631307 | 631307 | 2020-10-14 | Orleans | Vermont | 50019 | 22 | 0 |
631308 | 631308 | 2020-10-14 | Rutland | Vermont | 50021 | 134 | 1 |
631309 | 631309 | 2020-10-14 | Unknown | Vermont | 8 | 0 | |
631310 | 631310 | 2020-10-14 | Washington | Vermont | 50023 | 90 | 2 |
631311 | 631311 | 2020-10-14 | Windham | Vermont | 50025 | 130 | 3 |
631312 | 631312 | 2020-10-14 | Windsor | Vermont | 50027 | 104 | 2 |
628054 | 628054 | 2020-10-13 | Addison | Vermont | 50001 | 113 | 2 |
628055 | 628055 | 2020-10-13 | Bennington | Vermont | 50003 | 129 | 1 |
628056 | 628056 | 2020-10-13 | Caledonia | Vermont | 50005 | 34 | 0 |
628057 | 628057 | 2020-10-13 | Chittenden | Vermont | 50007 | 884 | 39 |
628058 | 628058 | 2020-10-13 | Essex | Vermont | 50009 | 6 | 0 |
628059 | 628059 | 2020-10-13 | Franklin | Vermont | 50011 | 131 | 7 |
628060 | 628060 | 2020-10-13 | Grand Isle | Vermont | 50013 | 17 | 0 |
628061 | 628061 | 2020-10-13 | Lamoille | Vermont | 50015 | 59 | 1 |
628062 | 628062 | 2020-10-13 | Orange | Vermont | 50017 | 27 | 0 |
628063 | 628063 | 2020-10-13 | Orleans | Vermont | 50019 | 22 | 0 |
628064 | 628064 | 2020-10-13 | Rutland | Vermont | 50021 | 133 | 1 |
628065 | 628065 | 2020-10-13 | Unknown | Vermont | 8 | 0 | |
628066 | 628066 | 2020-10-13 | Washington | Vermont | 50023 | 89 | 2 |
628067 | 628067 | 2020-10-13 | Windham | Vermont | 50025 | 130 | 3 |
628068 | 628068 | 2020-10-13 | Windsor | Vermont | 50027 | 104 | 2 |
624811 | 624811 | 2020-10-12 | Addison | Vermont | 50001 | 113 | 2 |
624812 | 624812 | 2020-10-12 | Bennington | Vermont | 50003 | 127 | 1 |
624813 | 624813 | 2020-10-12 | Caledonia | Vermont | 50005 | 34 | 0 |
624814 | 624814 | 2020-10-12 | Chittenden | Vermont | 50007 | 881 | 39 |
624815 | 624815 | 2020-10-12 | Essex | Vermont | 50009 | 6 | 0 |
624816 | 624816 | 2020-10-12 | Franklin | Vermont | 50011 | 131 | 7 |
624817 | 624817 | 2020-10-12 | Grand Isle | Vermont | 50013 | 17 | 0 |
624818 | 624818 | 2020-10-12 | Lamoille | Vermont | 50015 | 59 | 1 |
624819 | 624819 | 2020-10-12 | Orange | Vermont | 50017 | 26 | 0 |
624820 | 624820 | 2020-10-12 | Orleans | Vermont | 50019 | 21 | 0 |
624821 | 624821 | 2020-10-12 | Rutland | Vermont | 50021 | 133 | 1 |
624822 | 624822 | 2020-10-12 | Unknown | Vermont | 8 | 0 | |
624823 | 624823 | 2020-10-12 | Washington | Vermont | 50023 | 86 | 2 |
624824 | 624824 | 2020-10-12 | Windham | Vermont | 50025 | 130 | 3 |
624825 | 624825 | 2020-10-12 | Windsor | Vermont | 50027 | 104 | 2 |
621568 | 621568 | 2020-10-11 | Addison | Vermont | 50001 | 113 | 2 |
621569 | 621569 | 2020-10-11 | Bennington | Vermont | 50003 | 127 | 1 |
621570 | 621570 | 2020-10-11 | Caledonia | Vermont | 50005 | 34 | 0 |
621571 | 621571 | 2020-10-11 | Chittenden | Vermont | 50007 | 880 | 39 |
621572 | 621572 | 2020-10-11 | Essex | Vermont | 50009 | 6 | 0 |
621573 | 621573 | 2020-10-11 | Franklin | Vermont | 50011 | 131 | 7 |
621574 | 621574 | 2020-10-11 | Grand Isle | Vermont | 50013 | 17 | 0 |
621575 | 621575 | 2020-10-11 | Lamoille | Vermont | 50015 | 59 | 1 |
621576 | 621576 | 2020-10-11 | Orange | Vermont | 50017 | 25 | 0 |
621577 | 621577 | 2020-10-11 | Orleans | Vermont | 50019 | 21 | 0 |
621578 | 621578 | 2020-10-11 | Rutland | Vermont | 50021 | 133 | 1 |
621579 | 621579 | 2020-10-11 | Unknown | Vermont | 8 | 0 | |
621580 | 621580 | 2020-10-11 | Washington | Vermont | 50023 | 82 | 2 |
621581 | 621581 | 2020-10-11 | Windham | Vermont | 50025 | 129 | 3 |
621582 | 621582 | 2020-10-11 | Windsor | Vermont | 50027 | 103 | 2 |
618325 | 618325 | 2020-10-10 | Addison | Vermont | 50001 | 112 | 2 |
618326 | 618326 | 2020-10-10 | Bennington | Vermont | 50003 | 127 | 1 |
618327 | 618327 | 2020-10-10 | Caledonia | Vermont | 50005 | 34 | 0 |
618328 | 618328 | 2020-10-10 | Chittenden | Vermont | 50007 | 873 | 39 |
618329 | 618329 | 2020-10-10 | Essex | Vermont | 50009 | 6 | 0 |
618330 | 618330 | 2020-10-10 | Franklin | Vermont | 50011 | 131 | 7 |
618331 | 618331 | 2020-10-10 | Grand Isle | Vermont | 50013 | 16 | 0 |
618332 | 618332 | 2020-10-10 | Lamoille | Vermont | 50015 | 59 | 1 |
618333 | 618333 | 2020-10-10 | Orange | Vermont | 50017 | 25 | 0 |
618334 | 618334 | 2020-10-10 | Orleans | Vermont | 50019 | 21 | 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);