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 193
- Chittenden 189
- Washington 186
- Windsor 186
- Orange 184
- Addison 180
- Rutland 180
- Franklin 179
- Windham 179
- Unknown 177
- Caledonia 176
- Orleans 176
- Lamoille 175
- Grand Isle 162
- Essex 161
state 1
- Vermont · 2,683 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537318 | 537318 | 2020-09-15 | Addison | Vermont | 50001 | 82 | 2 |
537319 | 537319 | 2020-09-15 | Bennington | Vermont | 50003 | 108 | 1 |
537320 | 537320 | 2020-09-15 | Caledonia | Vermont | 50005 | 34 | 0 |
537321 | 537321 | 2020-09-15 | Chittenden | Vermont | 50007 | 821 | 39 |
537322 | 537322 | 2020-09-15 | Essex | Vermont | 50009 | 6 | 0 |
537323 | 537323 | 2020-09-15 | Franklin | Vermont | 50011 | 123 | 7 |
537324 | 537324 | 2020-09-15 | Grand Isle | Vermont | 50013 | 14 | 0 |
537325 | 537325 | 2020-09-15 | Lamoille | Vermont | 50015 | 51 | 1 |
537326 | 537326 | 2020-09-15 | Orange | Vermont | 50017 | 22 | 0 |
537327 | 537327 | 2020-09-15 | Orleans | Vermont | 50019 | 22 | 0 |
537328 | 537328 | 2020-09-15 | Rutland | Vermont | 50021 | 129 | 1 |
537329 | 537329 | 2020-09-15 | Unknown | Vermont | 8 | 0 | |
537330 | 537330 | 2020-09-15 | Washington | Vermont | 50023 | 76 | 2 |
537331 | 537331 | 2020-09-15 | Windham | Vermont | 50025 | 123 | 3 |
537332 | 537332 | 2020-09-15 | Windsor | Vermont | 50027 | 83 | 2 |
534082 | 534082 | 2020-09-14 | Addison | Vermont | 50001 | 82 | 2 |
534083 | 534083 | 2020-09-14 | Bennington | Vermont | 50003 | 109 | 1 |
534084 | 534084 | 2020-09-14 | Caledonia | Vermont | 50005 | 34 | 0 |
534085 | 534085 | 2020-09-14 | Chittenden | Vermont | 50007 | 818 | 39 |
534086 | 534086 | 2020-09-14 | Essex | Vermont | 50009 | 6 | 0 |
534087 | 534087 | 2020-09-14 | Franklin | Vermont | 50011 | 123 | 7 |
534088 | 534088 | 2020-09-14 | Grand Isle | Vermont | 50013 | 14 | 0 |
534089 | 534089 | 2020-09-14 | Lamoille | Vermont | 50015 | 50 | 1 |
534090 | 534090 | 2020-09-14 | Orange | Vermont | 50017 | 22 | 0 |
534091 | 534091 | 2020-09-14 | Orleans | Vermont | 50019 | 22 | 0 |
534092 | 534092 | 2020-09-14 | Rutland | Vermont | 50021 | 128 | 1 |
534093 | 534093 | 2020-09-14 | Unknown | Vermont | 8 | 0 | |
534094 | 534094 | 2020-09-14 | Washington | Vermont | 50023 | 74 | 2 |
534095 | 534095 | 2020-09-14 | Windham | Vermont | 50025 | 123 | 3 |
534096 | 534096 | 2020-09-14 | Windsor | Vermont | 50027 | 83 | 2 |
530847 | 530847 | 2020-09-13 | Addison | Vermont | 50001 | 82 | 2 |
530848 | 530848 | 2020-09-13 | Bennington | Vermont | 50003 | 108 | 1 |
530849 | 530849 | 2020-09-13 | Caledonia | Vermont | 50005 | 34 | 0 |
530850 | 530850 | 2020-09-13 | Chittenden | Vermont | 50007 | 814 | 39 |
530851 | 530851 | 2020-09-13 | Essex | Vermont | 50009 | 6 | 0 |
530852 | 530852 | 2020-09-13 | Franklin | Vermont | 50011 | 123 | 7 |
530853 | 530853 | 2020-09-13 | Grand Isle | Vermont | 50013 | 13 | 0 |
530854 | 530854 | 2020-09-13 | Lamoille | Vermont | 50015 | 48 | 1 |
530855 | 530855 | 2020-09-13 | Orange | Vermont | 50017 | 22 | 0 |
530856 | 530856 | 2020-09-13 | Orleans | Vermont | 50019 | 22 | 0 |
530857 | 530857 | 2020-09-13 | Rutland | Vermont | 50021 | 128 | 1 |
530858 | 530858 | 2020-09-13 | Unknown | Vermont | 8 | 0 | |
530859 | 530859 | 2020-09-13 | Washington | Vermont | 50023 | 71 | 2 |
530860 | 530860 | 2020-09-13 | Windham | Vermont | 50025 | 123 | 3 |
530861 | 530861 | 2020-09-13 | Windsor | Vermont | 50027 | 82 | 2 |
527610 | 527610 | 2020-09-12 | Addison | Vermont | 50001 | 82 | 2 |
527611 | 527611 | 2020-09-12 | Bennington | Vermont | 50003 | 107 | 1 |
527612 | 527612 | 2020-09-12 | Caledonia | Vermont | 50005 | 34 | 0 |
527613 | 527613 | 2020-09-12 | Chittenden | Vermont | 50007 | 811 | 39 |
527614 | 527614 | 2020-09-12 | Essex | Vermont | 50009 | 6 | 0 |
527615 | 527615 | 2020-09-12 | Franklin | Vermont | 50011 | 123 | 7 |
527616 | 527616 | 2020-09-12 | Grand Isle | Vermont | 50013 | 13 | 0 |
527617 | 527617 | 2020-09-12 | Lamoille | Vermont | 50015 | 47 | 1 |
527618 | 527618 | 2020-09-12 | Orange | Vermont | 50017 | 22 | 0 |
527619 | 527619 | 2020-09-12 | Orleans | Vermont | 50019 | 22 | 0 |
527620 | 527620 | 2020-09-12 | Rutland | Vermont | 50021 | 128 | 1 |
527621 | 527621 | 2020-09-12 | Unknown | Vermont | 8 | 0 | |
527622 | 527622 | 2020-09-12 | Washington | Vermont | 50023 | 69 | 2 |
527623 | 527623 | 2020-09-12 | Windham | Vermont | 50025 | 123 | 3 |
527624 | 527624 | 2020-09-12 | Windsor | Vermont | 50027 | 82 | 2 |
524374 | 524374 | 2020-09-11 | Addison | Vermont | 50001 | 82 | 2 |
524375 | 524375 | 2020-09-11 | Bennington | Vermont | 50003 | 107 | 1 |
524376 | 524376 | 2020-09-11 | Caledonia | Vermont | 50005 | 33 | 0 |
524377 | 524377 | 2020-09-11 | Chittenden | Vermont | 50007 | 808 | 39 |
524378 | 524378 | 2020-09-11 | Essex | Vermont | 50009 | 6 | 0 |
524379 | 524379 | 2020-09-11 | Franklin | Vermont | 50011 | 123 | 7 |
524380 | 524380 | 2020-09-11 | Grand Isle | Vermont | 50013 | 13 | 0 |
524381 | 524381 | 2020-09-11 | Lamoille | Vermont | 50015 | 47 | 1 |
524382 | 524382 | 2020-09-11 | Orange | Vermont | 50017 | 22 | 0 |
524383 | 524383 | 2020-09-11 | Orleans | Vermont | 50019 | 22 | 0 |
524384 | 524384 | 2020-09-11 | Rutland | Vermont | 50021 | 126 | 1 |
524385 | 524385 | 2020-09-11 | Unknown | Vermont | 8 | 0 | |
524386 | 524386 | 2020-09-11 | Washington | Vermont | 50023 | 66 | 2 |
524387 | 524387 | 2020-09-11 | Windham | Vermont | 50025 | 123 | 3 |
524388 | 524388 | 2020-09-11 | Windsor | Vermont | 50027 | 82 | 2 |
521138 | 521138 | 2020-09-10 | Addison | Vermont | 50001 | 82 | 2 |
521139 | 521139 | 2020-09-10 | Bennington | Vermont | 50003 | 108 | 1 |
521140 | 521140 | 2020-09-10 | Caledonia | Vermont | 50005 | 33 | 0 |
521141 | 521141 | 2020-09-10 | Chittenden | Vermont | 50007 | 804 | 39 |
521142 | 521142 | 2020-09-10 | Essex | Vermont | 50009 | 6 | 0 |
521143 | 521143 | 2020-09-10 | Franklin | Vermont | 50011 | 123 | 7 |
521144 | 521144 | 2020-09-10 | Grand Isle | Vermont | 50013 | 13 | 0 |
521145 | 521145 | 2020-09-10 | Lamoille | Vermont | 50015 | 47 | 1 |
521146 | 521146 | 2020-09-10 | Orange | Vermont | 50017 | 21 | 0 |
521147 | 521147 | 2020-09-10 | Orleans | Vermont | 50019 | 22 | 0 |
521148 | 521148 | 2020-09-10 | Rutland | Vermont | 50021 | 126 | 1 |
521149 | 521149 | 2020-09-10 | Unknown | Vermont | 8 | 0 | |
521150 | 521150 | 2020-09-10 | Washington | Vermont | 50023 | 64 | 2 |
521151 | 521151 | 2020-09-10 | Windham | Vermont | 50025 | 123 | 3 |
521152 | 521152 | 2020-09-10 | Windsor | Vermont | 50027 | 81 | 2 |
517901 | 517901 | 2020-09-09 | Addison | Vermont | 50001 | 82 | 2 |
517902 | 517902 | 2020-09-09 | Bennington | Vermont | 50003 | 108 | 1 |
517903 | 517903 | 2020-09-09 | Caledonia | Vermont | 50005 | 33 | 0 |
517904 | 517904 | 2020-09-09 | Chittenden | Vermont | 50007 | 803 | 39 |
517905 | 517905 | 2020-09-09 | Essex | Vermont | 50009 | 6 | 0 |
517906 | 517906 | 2020-09-09 | Franklin | Vermont | 50011 | 124 | 7 |
517907 | 517907 | 2020-09-09 | Grand Isle | Vermont | 50013 | 13 | 0 |
517908 | 517908 | 2020-09-09 | Lamoille | Vermont | 50015 | 46 | 1 |
517909 | 517909 | 2020-09-09 | Orange | Vermont | 50017 | 21 | 0 |
517910 | 517910 | 2020-09-09 | Orleans | Vermont | 50019 | 18 | 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);