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

766 rows where county = "Essex" 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 · 766 ✖

fips 1

county 1

  • Essex · 766 ✖
Link rowid date ▲ county state fips cases deaths
2502496 2502496 2022-05-13 Essex Vermont 50009 1301 3
2499238 2499238 2022-05-12 Essex Vermont 50009 1296 3
2495980 2495980 2022-05-11 Essex Vermont 50009 1292 3
2492722 2492722 2022-05-10 Essex Vermont 50009 1291 3
2489464 2489464 2022-05-09 Essex Vermont 50009 1290 3
2486206 2486206 2022-05-08 Essex Vermont 50009 1286 3
2482948 2482948 2022-05-07 Essex Vermont 50009 1286 3
2479690 2479690 2022-05-06 Essex Vermont 50009 1286 3
2476432 2476432 2022-05-05 Essex Vermont 50009 1285 3
2473175 2473175 2022-05-04 Essex Vermont 50009 1283 3
2469919 2469919 2022-05-03 Essex Vermont 50009 1283 3
2466663 2466663 2022-05-02 Essex Vermont 50009 1282 3
2463408 2463408 2022-05-01 Essex Vermont 50009 1281 3
2460152 2460152 2022-04-30 Essex Vermont 50009 1281 3
2456896 2456896 2022-04-29 Essex Vermont 50009 1281 3
2453640 2453640 2022-04-28 Essex Vermont 50009 1281 3
2450384 2450384 2022-04-27 Essex Vermont 50009 1291 3
2447127 2447127 2022-04-26 Essex Vermont 50009 1291 3
2443872 2443872 2022-04-25 Essex Vermont 50009 1291 3
2440616 2440616 2022-04-24 Essex Vermont 50009 1291 3
2437360 2437360 2022-04-23 Essex Vermont 50009 1291 3
2434104 2434104 2022-04-22 Essex Vermont 50009 1291 3
2430848 2430848 2022-04-21 Essex Vermont 50009 1289 3
2427592 2427592 2022-04-20 Essex Vermont 50009 1288 3
2424336 2424336 2022-04-19 Essex Vermont 50009 1289 3
2421080 2421080 2022-04-18 Essex Vermont 50009 1289 3
2417824 2417824 2022-04-17 Essex Vermont 50009 1285 3
2414568 2414568 2022-04-16 Essex Vermont 50009 1285 3
2411312 2411312 2022-04-15 Essex Vermont 50009 1285 3
2408056 2408056 2022-04-14 Essex Vermont 50009 1285 3
2404800 2404800 2022-04-13 Essex Vermont 50009 1284 3
2401545 2401545 2022-04-12 Essex Vermont 50009 1285 3
2398290 2398290 2022-04-11 Essex Vermont 50009 1285 3
2395035 2395035 2022-04-10 Essex Vermont 50009 1279 3
2391779 2391779 2022-04-09 Essex Vermont 50009 1279 3
2388523 2388523 2022-04-08 Essex Vermont 50009 1279 3
2385268 2385268 2022-04-07 Essex Vermont 50009 1279 3
2382013 2382013 2022-04-06 Essex Vermont 50009 1279 3
2378758 2378758 2022-04-05 Essex Vermont 50009 1280 3
2375504 2375504 2022-04-04 Essex Vermont 50009 1280 3
2372252 2372252 2022-04-03 Essex Vermont 50009 1275 3
2368999 2368999 2022-04-02 Essex Vermont 50009 1275 3
2365746 2365746 2022-04-01 Essex Vermont 50009 1275 3
2362493 2362493 2022-03-31 Essex Vermont 50009 1275 3
2359239 2359239 2022-03-30 Essex Vermont 50009 1275 3
2355985 2355985 2022-03-29 Essex Vermont 50009 1274 3
2352732 2352732 2022-03-28 Essex Vermont 50009 1275 3
2349480 2349480 2022-03-27 Essex Vermont 50009 1274 3
2346227 2346227 2022-03-26 Essex Vermont 50009 1274 3
2342974 2342974 2022-03-25 Essex Vermont 50009 1274 3
2339721 2339721 2022-03-24 Essex Vermont 50009 1265 3
2336467 2336467 2022-03-23 Essex Vermont 50009 1262 3
2333213 2333213 2022-03-22 Essex Vermont 50009 1255 3
2329960 2329960 2022-03-21 Essex Vermont 50009 1254 3
2326708 2326708 2022-03-20 Essex Vermont 50009 1240 3
2323455 2323455 2022-03-19 Essex Vermont 50009 1240 3
2320201 2320201 2022-03-18 Essex Vermont 50009 1240 3
2316947 2316947 2022-03-17 Essex Vermont 50009 1239 3
2313694 2313694 2022-03-16 Essex Vermont 50009 1232 3
2310441 2310441 2022-03-15 Essex Vermont 50009 1224 3
2307188 2307188 2022-03-14 Essex Vermont 50009 1224 3
2303937 2303937 2022-03-13 Essex Vermont 50009 1219 3
2300685 2300685 2022-03-12 Essex Vermont 50009 1219 3
2297433 2297433 2022-03-11 Essex Vermont 50009 1219 3
2294181 2294181 2022-03-10 Essex Vermont 50009 1217 3
2290929 2290929 2022-03-09 Essex Vermont 50009 1215 3
2287677 2287677 2022-03-08 Essex Vermont 50009 1214 3
2284425 2284425 2022-03-07 Essex Vermont 50009 1214 3
2281173 2281173 2022-03-06 Essex Vermont 50009 1212 3
2277920 2277920 2022-03-05 Essex Vermont 50009 1212 3
2274667 2274667 2022-03-04 Essex Vermont 50009 1212 3
2271414 2271414 2022-03-03 Essex Vermont 50009 1212 3
2268162 2268162 2022-03-02 Essex Vermont 50009 1212 3
2264909 2264909 2022-03-01 Essex Vermont 50009 1107 3
2261659 2261659 2022-02-28 Essex Vermont 50009 1107 3
2258408 2258408 2022-02-27 Essex Vermont 50009 1094 3
2255157 2255157 2022-02-26 Essex Vermont 50009 1094 3
2251906 2251906 2022-02-25 Essex Vermont 50009 1094 3
2248655 2248655 2022-02-24 Essex Vermont 50009 1093 3
2245404 2245404 2022-02-23 Essex Vermont 50009 1091 3
2242153 2242153 2022-02-22 Essex Vermont 50009 1090 3
2238902 2238902 2022-02-21 Essex Vermont 50009 1086 3
2235651 2235651 2022-02-20 Essex Vermont 50009 1086 3
2232400 2232400 2022-02-19 Essex Vermont 50009 1086 3
2229149 2229149 2022-02-18 Essex Vermont 50009 1086 3
2225898 2225898 2022-02-17 Essex Vermont 50009 1086 3
2222647 2222647 2022-02-16 Essex Vermont 50009 1086 3
2219396 2219396 2022-02-15 Essex Vermont 50009 1081 3
2216145 2216145 2022-02-14 Essex Vermont 50009 1082 3
2212894 2212894 2022-02-13 Essex Vermont 50009 1075 3
2209641 2209641 2022-02-12 Essex Vermont 50009 1075 3
2206388 2206388 2022-02-11 Essex Vermont 50009 1075 3
2203135 2203135 2022-02-10 Essex Vermont 50009 1075 3
2199881 2199881 2022-02-09 Essex Vermont 50009 1074 3
2196627 2196627 2022-02-08 Essex Vermont 50009 1074 3
2193373 2193373 2022-02-07 Essex Vermont 50009 1071 3
2190120 2190120 2022-02-06 Essex Vermont 50009 1068 3
2186867 2186867 2022-02-05 Essex Vermont 50009 1068 3
2183614 2183614 2022-02-04 Essex Vermont 50009 1068 3
2180362 2180362 2022-02-03 Essex Vermont 50009 1064 3

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