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

794 rows where fips = 50007 and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Vermont · 794 ✖

fips 1

  • 50007 · 794 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502495 2502495 2022-05-13 Chittenden Vermont 50007 34629 175
2499237 2499237 2022-05-12 Chittenden Vermont 50007 34521 175
2495979 2495979 2022-05-11 Chittenden Vermont 50007 34368 175
2492721 2492721 2022-05-10 Chittenden Vermont 50007 34315 175
2489463 2489463 2022-05-09 Chittenden Vermont 50007 34258 175
2486205 2486205 2022-05-08 Chittenden Vermont 50007 34036 174
2482947 2482947 2022-05-07 Chittenden Vermont 50007 34036 174
2479689 2479689 2022-05-06 Chittenden Vermont 50007 34036 174
2476431 2476431 2022-05-05 Chittenden Vermont 50007 33877 174
2473174 2473174 2022-05-04 Chittenden Vermont 50007 33782 174
2469918 2469918 2022-05-03 Chittenden Vermont 50007 33619 174
2466662 2466662 2022-05-02 Chittenden Vermont 50007 33542 174
2463407 2463407 2022-05-01 Chittenden Vermont 50007 33339 174
2460151 2460151 2022-04-30 Chittenden Vermont 50007 33339 174
2456895 2456895 2022-04-29 Chittenden Vermont 50007 33339 174
2453639 2453639 2022-04-28 Chittenden Vermont 50007 33200 172
2450383 2450383 2022-04-27 Chittenden Vermont 50007 32994 171
2447126 2447126 2022-04-26 Chittenden Vermont 50007 32994 171
2443871 2443871 2022-04-25 Chittenden Vermont 50007 32994 171
2440615 2440615 2022-04-24 Chittenden Vermont 50007 32721 171
2437359 2437359 2022-04-23 Chittenden Vermont 50007 32721 171
2434103 2434103 2022-04-22 Chittenden Vermont 50007 32721 171
2430847 2430847 2022-04-21 Chittenden Vermont 50007 32614 169
2427591 2427591 2022-04-20 Chittenden Vermont 50007 32508 169
2424335 2424335 2022-04-19 Chittenden Vermont 50007 32382 169
2421079 2421079 2022-04-18 Chittenden Vermont 50007 32319 167
2417823 2417823 2022-04-17 Chittenden Vermont 50007 32039 167
2414567 2414567 2022-04-16 Chittenden Vermont 50007 32039 167
2411311 2411311 2022-04-15 Chittenden Vermont 50007 32039 167
2408055 2408055 2022-04-14 Chittenden Vermont 50007 31922 167
2404799 2404799 2022-04-13 Chittenden Vermont 50007 31790 167
2401544 2401544 2022-04-12 Chittenden Vermont 50007 31657 167
2398289 2398289 2022-04-11 Chittenden Vermont 50007 31601 167
2395034 2395034 2022-04-10 Chittenden Vermont 50007 31382 166
2391778 2391778 2022-04-09 Chittenden Vermont 50007 31382 166
2388522 2388522 2022-04-08 Chittenden Vermont 50007 31382 166
2385267 2385267 2022-04-07 Chittenden Vermont 50007 31274 166
2382012 2382012 2022-04-06 Chittenden Vermont 50007 31184 166
2378757 2378757 2022-04-05 Chittenden Vermont 50007 31105 166
2375503 2375503 2022-04-04 Chittenden Vermont 50007 31054 166
2372251 2372251 2022-04-03 Chittenden Vermont 50007 30941 164
2368998 2368998 2022-04-02 Chittenden Vermont 50007 30941 164
2365745 2365745 2022-04-01 Chittenden Vermont 50007 30941 164
2362492 2362492 2022-03-31 Chittenden Vermont 50007 30887 164
2359238 2359238 2022-03-30 Chittenden Vermont 50007 30820 164
2355984 2355984 2022-03-29 Chittenden Vermont 50007 30747 164
2352731 2352731 2022-03-28 Chittenden Vermont 50007 30716 163
2349479 2349479 2022-03-27 Chittenden Vermont 50007 30621 163
2346226 2346226 2022-03-26 Chittenden Vermont 50007 30621 163
2342973 2342973 2022-03-25 Chittenden Vermont 50007 30621 163
2339720 2339720 2022-03-24 Chittenden Vermont 50007 30573 163
2336466 2336466 2022-03-23 Chittenden Vermont 50007 30524 162
2333212 2333212 2022-03-22 Chittenden Vermont 50007 30459 162
2329959 2329959 2022-03-21 Chittenden Vermont 50007 30436 160
2326707 2326707 2022-03-20 Chittenden Vermont 50007 30348 160
2323454 2323454 2022-03-19 Chittenden Vermont 50007 30348 160
2320200 2320200 2022-03-18 Chittenden Vermont 50007 30348 160
2316946 2316946 2022-03-17 Chittenden Vermont 50007 30310 160
2313693 2313693 2022-03-16 Chittenden Vermont 50007 30254 159
2310440 2310440 2022-03-15 Chittenden Vermont 50007 30197 159
2307187 2307187 2022-03-14 Chittenden Vermont 50007 30169 159
2303936 2303936 2022-03-13 Chittenden Vermont 50007 30113 159
2300684 2300684 2022-03-12 Chittenden Vermont 50007 30113 159
2297432 2297432 2022-03-11 Chittenden Vermont 50007 30113 159
2294180 2294180 2022-03-10 Chittenden Vermont 50007 30087 159
2290928 2290928 2022-03-09 Chittenden Vermont 50007 30069 159
2287676 2287676 2022-03-08 Chittenden Vermont 50007 30047 159
2284424 2284424 2022-03-07 Chittenden Vermont 50007 30043 158
2281172 2281172 2022-03-06 Chittenden Vermont 50007 29958 158
2277919 2277919 2022-03-05 Chittenden Vermont 50007 29958 158
2274666 2274666 2022-03-04 Chittenden Vermont 50007 29958 158
2271413 2271413 2022-03-03 Chittenden Vermont 50007 29905 158
2268161 2268161 2022-03-02 Chittenden Vermont 50007 29837 158
2264908 2264908 2022-03-01 Chittenden Vermont 50007 25935 156
2261658 2261658 2022-02-28 Chittenden Vermont 50007 25935 156
2258407 2258407 2022-02-27 Chittenden Vermont 50007 25532 156
2255156 2255156 2022-02-26 Chittenden Vermont 50007 25532 156
2251905 2251905 2022-02-25 Chittenden Vermont 50007 25532 156
2248654 2248654 2022-02-24 Chittenden Vermont 50007 25474 156
2245403 2245403 2022-02-23 Chittenden Vermont 50007 25388 156
2242152 2242152 2022-02-22 Chittenden Vermont 50007 25345 156
2238901 2238901 2022-02-21 Chittenden Vermont 50007 25251 156
2235650 2235650 2022-02-20 Chittenden Vermont 50007 25251 156
2232399 2232399 2022-02-19 Chittenden Vermont 50007 25251 156
2229148 2229148 2022-02-18 Chittenden Vermont 50007 25251 156
2225897 2225897 2022-02-17 Chittenden Vermont 50007 25220 154
2222646 2222646 2022-02-16 Chittenden Vermont 50007 25174 154
2219395 2219395 2022-02-15 Chittenden Vermont 50007 25124 154
2216144 2216144 2022-02-14 Chittenden Vermont 50007 25092 154
2212893 2212893 2022-02-13 Chittenden Vermont 50007 25000 153
2209640 2209640 2022-02-12 Chittenden Vermont 50007 25000 153
2206387 2206387 2022-02-11 Chittenden Vermont 50007 25000 153
2203134 2203134 2022-02-10 Chittenden Vermont 50007 24954 152
2199880 2199880 2022-02-09 Chittenden Vermont 50007 24886 152
2196626 2196626 2022-02-08 Chittenden Vermont 50007 24840 152
2193372 2193372 2022-02-07 Chittenden Vermont 50007 24799 151
2190119 2190119 2022-02-06 Chittenden Vermont 50007 24659 151
2186866 2186866 2022-02-05 Chittenden Vermont 50007 24659 151
2183613 2183613 2022-02-04 Chittenden Vermont 50007 24659 151
2180361 2180361 2022-02-03 Chittenden Vermont 50007 24597 150

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