ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

11,758 rows where state = "Vermont" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 15

county 15

state 1

  • Vermont · 11,758 ✖
Link rowid date ▲ county state fips cases deaths
2502492 2502492 2022-05-13 Addison Vermont 50001 5939 18
2502493 2502493 2022-05-13 Bennington Vermont 50003 10153 71
2502494 2502494 2022-05-13 Caledonia Vermont 50005 5854 25
2502495 2502495 2022-05-13 Chittenden Vermont 50007 34629 175
2502496 2502496 2022-05-13 Essex Vermont 50009 1301 3
2502497 2502497 2022-05-13 Franklin Vermont 50011 10325 67
2502498 2502498 2022-05-13 Grand Isle Vermont 50013 1132 5
2502499 2502499 2022-05-13 Lamoille Vermont 50015 3964 17
2502500 2502500 2022-05-13 Orange Vermont 50017 4420 14
2502501 2502501 2022-05-13 Orleans Vermont 50019 6610 38
2502502 2502502 2022-05-13 Rutland Vermont 50021 13586 74
2502503 2502503 2022-05-13 Unknown Vermont   1496 2
2502504 2502504 2022-05-13 Washington Vermont 50023 12430 51
2502505 2502505 2022-05-13 Windham Vermont 50025 6994 36
2502506 2502506 2022-05-13 Windsor Vermont 50027 9638 52
2499234 2499234 2022-05-12 Addison Vermont 50001 5922 18
2499235 2499235 2022-05-12 Bennington Vermont 50003 10107 71
2499236 2499236 2022-05-12 Caledonia Vermont 50005 5831 25
2499237 2499237 2022-05-12 Chittenden Vermont 50007 34521 175
2499238 2499238 2022-05-12 Essex Vermont 50009 1296 3
2499239 2499239 2022-05-12 Franklin Vermont 50011 10312 67
2499240 2499240 2022-05-12 Grand Isle Vermont 50013 1130 5
2499241 2499241 2022-05-12 Lamoille Vermont 50015 3957 17
2499242 2499242 2022-05-12 Orange Vermont 50017 4410 14
2499243 2499243 2022-05-12 Orleans Vermont 50019 6599 38
2499244 2499244 2022-05-12 Rutland Vermont 50021 13516 74
2499245 2499245 2022-05-12 Unknown Vermont   1463 2
2499246 2499246 2022-05-12 Washington Vermont 50023 12401 51
2499247 2499247 2022-05-12 Windham Vermont 50025 6974 36
2499248 2499248 2022-05-12 Windsor Vermont 50027 9619 52
2495976 2495976 2022-05-11 Addison Vermont 50001 5902 18
2495977 2495977 2022-05-11 Bennington Vermont 50003 10078 71
2495978 2495978 2022-05-11 Caledonia Vermont 50005 5800 25
2495979 2495979 2022-05-11 Chittenden Vermont 50007 34368 175
2495980 2495980 2022-05-11 Essex Vermont 50009 1292 3
2495981 2495981 2022-05-11 Franklin Vermont 50011 10288 67
2495982 2495982 2022-05-11 Grand Isle Vermont 50013 1126 5
2495983 2495983 2022-05-11 Lamoille Vermont 50015 3937 17
2495984 2495984 2022-05-11 Orange Vermont 50017 4388 14
2495985 2495985 2022-05-11 Orleans Vermont 50019 6566 38
2495986 2495986 2022-05-11 Rutland Vermont 50021 13455 74
2495987 2495987 2022-05-11 Unknown Vermont   1442 2
2495988 2495988 2022-05-11 Washington Vermont 50023 12309 51
2495989 2495989 2022-05-11 Windham Vermont 50025 6942 36
2495990 2495990 2022-05-11 Windsor Vermont 50027 9564 52
2492718 2492718 2022-05-10 Addison Vermont 50001 5886 18
2492719 2492719 2022-05-10 Bennington Vermont 50003 10038 71
2492720 2492720 2022-05-10 Caledonia Vermont 50005 5795 25
2492721 2492721 2022-05-10 Chittenden Vermont 50007 34315 175
2492722 2492722 2022-05-10 Essex Vermont 50009 1291 3
2492723 2492723 2022-05-10 Franklin Vermont 50011 10272 67
2492724 2492724 2022-05-10 Grand Isle Vermont 50013 1125 5
2492725 2492725 2022-05-10 Lamoille Vermont 50015 3936 17
2492726 2492726 2022-05-10 Orange Vermont 50017 4376 14
2492727 2492727 2022-05-10 Orleans Vermont 50019 6559 38
2492728 2492728 2022-05-10 Rutland Vermont 50021 13404 74
2492729 2492729 2022-05-10 Unknown Vermont   1432 2
2492730 2492730 2022-05-10 Washington Vermont 50023 12297 51
2492731 2492731 2022-05-10 Windham Vermont 50025 6921 36
2492732 2492732 2022-05-10 Windsor Vermont 50027 9542 52
2489460 2489460 2022-05-09 Addison Vermont 50001 5880 17
2489461 2489461 2022-05-09 Bennington Vermont 50003 10015 70
2489462 2489462 2022-05-09 Caledonia Vermont 50005 5789 25
2489463 2489463 2022-05-09 Chittenden Vermont 50007 34258 175
2489464 2489464 2022-05-09 Essex Vermont 50009 1290 3
2489465 2489465 2022-05-09 Franklin Vermont 50011 10261 67
2489466 2489466 2022-05-09 Grand Isle Vermont 50013 1123 5
2489467 2489467 2022-05-09 Lamoille Vermont 50015 3934 17
2489468 2489468 2022-05-09 Orange Vermont 50017 4370 13
2489469 2489469 2022-05-09 Orleans Vermont 50019 6556 38
2489470 2489470 2022-05-09 Rutland Vermont 50021 13340 74
2489471 2489471 2022-05-09 Unknown Vermont   1413 2
2489472 2489472 2022-05-09 Washington Vermont 50023 12270 51
2489473 2489473 2022-05-09 Windham Vermont 50025 6907 36
2489474 2489474 2022-05-09 Windsor Vermont 50027 9531 51
2486202 2486202 2022-05-08 Addison Vermont 50001 5845 16
2486203 2486203 2022-05-08 Bennington Vermont 50003 9954 70
2486204 2486204 2022-05-08 Caledonia Vermont 50005 5755 25
2486205 2486205 2022-05-08 Chittenden Vermont 50007 34036 174
2486206 2486206 2022-05-08 Essex Vermont 50009 1286 3
2486207 2486207 2022-05-08 Franklin Vermont 50011 10220 67
2486208 2486208 2022-05-08 Grand Isle Vermont 50013 1115 5
2486209 2486209 2022-05-08 Lamoille Vermont 50015 3924 17
2486210 2486210 2022-05-08 Orange Vermont 50017 4339 13
2486211 2486211 2022-05-08 Orleans Vermont 50019 6533 38
2486212 2486212 2022-05-08 Rutland Vermont 50021 13244 74
2486213 2486213 2022-05-08 Unknown Vermont   1382 2
2486214 2486214 2022-05-08 Washington Vermont 50023 12148 51
2486215 2486215 2022-05-08 Windham Vermont 50025 6847 36
2486216 2486216 2022-05-08 Windsor Vermont 50027 9471 51
2482944 2482944 2022-05-07 Addison Vermont 50001 5845 16
2482945 2482945 2022-05-07 Bennington Vermont 50003 9954 70
2482946 2482946 2022-05-07 Caledonia Vermont 50005 5755 25
2482947 2482947 2022-05-07 Chittenden Vermont 50007 34036 174
2482948 2482948 2022-05-07 Essex Vermont 50009 1286 3
2482949 2482949 2022-05-07 Franklin Vermont 50011 10220 67
2482950 2482950 2022-05-07 Grand Isle Vermont 50013 1115 5
2482951 2482951 2022-05-07 Lamoille Vermont 50015 3924 17
2482952 2482952 2022-05-07 Orange Vermont 50017 4339 13
2482953 2482953 2022-05-07 Orleans Vermont 50019 6533 38

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);