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

782 rows where county = "Unknown" and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

state 1

  • Vermont · 782 ✖

fips 1

  • - 782

county 1

  • Unknown · 782 ✖
Link rowid date ▲ county state fips cases deaths
2502503 2502503 2022-05-13 Unknown Vermont   1496 2
2499245 2499245 2022-05-12 Unknown Vermont   1463 2
2495987 2495987 2022-05-11 Unknown Vermont   1442 2
2492729 2492729 2022-05-10 Unknown Vermont   1432 2
2489471 2489471 2022-05-09 Unknown Vermont   1413 2
2486213 2486213 2022-05-08 Unknown Vermont   1382 2
2482955 2482955 2022-05-07 Unknown Vermont   1382 2
2479697 2479697 2022-05-06 Unknown Vermont   1382 2
2476439 2476439 2022-05-05 Unknown Vermont   1356 2
2473182 2473182 2022-05-04 Unknown Vermont   1335 1
2469926 2469926 2022-05-03 Unknown Vermont   1306 1
2466670 2466670 2022-05-02 Unknown Vermont   1290 1
2463415 2463415 2022-05-01 Unknown Vermont   1252 1
2460159 2460159 2022-04-30 Unknown Vermont   1252 1
2456903 2456903 2022-04-29 Unknown Vermont   1252 1
2453647 2453647 2022-04-28 Unknown Vermont   1219 1
2450391 2450391 2022-04-27 Unknown Vermont   1927 2
2447134 2447134 2022-04-26 Unknown Vermont   1206 1
2443879 2443879 2022-04-25 Unknown Vermont   1206 1
2440623 2440623 2022-04-24 Unknown Vermont   1162 1
2437367 2437367 2022-04-23 Unknown Vermont   1162 1
2434111 2434111 2022-04-22 Unknown Vermont   1162 1
2430855 2430855 2022-04-21 Unknown Vermont   1144 1
2427599 2427599 2022-04-20 Unknown Vermont   1129 1
2424343 2424343 2022-04-19 Unknown Vermont   1118 1
2421087 2421087 2022-04-18 Unknown Vermont   1114 1
2417831 2417831 2022-04-17 Unknown Vermont   1092 1
2414575 2414575 2022-04-16 Unknown Vermont   1092 1
2411319 2411319 2022-04-15 Unknown Vermont   1092 1
2408063 2408063 2022-04-14 Unknown Vermont   1083 1
2404807 2404807 2022-04-13 Unknown Vermont   1066 1
2401552 2401552 2022-04-12 Unknown Vermont   1063 1
2398297 2398297 2022-04-11 Unknown Vermont   1056 1
2395042 2395042 2022-04-10 Unknown Vermont   1041 1
2391786 2391786 2022-04-09 Unknown Vermont   1041 1
2388530 2388530 2022-04-08 Unknown Vermont   1041 1
2385275 2385275 2022-04-07 Unknown Vermont   1032 1
2382020 2382020 2022-04-06 Unknown Vermont   1042 2
2378765 2378765 2022-04-05 Unknown Vermont   1044 2
2375511 2375511 2022-04-04 Unknown Vermont   1034 2
2372259 2372259 2022-04-03 Unknown Vermont   1028 2
2369006 2369006 2022-04-02 Unknown Vermont   1028 2
2365753 2365753 2022-04-01 Unknown Vermont   1028 2
2362500 2362500 2022-03-31 Unknown Vermont   1020 2
2359246 2359246 2022-03-30 Unknown Vermont   1021 2
2355992 2355992 2022-03-29 Unknown Vermont   1007 2
2352739 2352739 2022-03-28 Unknown Vermont   1010 2
2349487 2349487 2022-03-27 Unknown Vermont   1003 2
2346234 2346234 2022-03-26 Unknown Vermont   1003 2
2342981 2342981 2022-03-25 Unknown Vermont   1003 2
2339728 2339728 2022-03-24 Unknown Vermont   998 2
2336474 2336474 2022-03-23 Unknown Vermont   1010 2
2333220 2333220 2022-03-22 Unknown Vermont   998 2
2329967 2329967 2022-03-21 Unknown Vermont   1001 2
2326715 2326715 2022-03-20 Unknown Vermont   984 2
2323462 2323462 2022-03-19 Unknown Vermont   984 2
2320208 2320208 2022-03-18 Unknown Vermont   984 2
2316954 2316954 2022-03-17 Unknown Vermont   979 2
2313701 2313701 2022-03-16 Unknown Vermont   968 2
2310448 2310448 2022-03-15 Unknown Vermont   966 2
2307195 2307195 2022-03-14 Unknown Vermont   972 2
2303944 2303944 2022-03-13 Unknown Vermont   962 2
2300692 2300692 2022-03-12 Unknown Vermont   962 2
2297440 2297440 2022-03-11 Unknown Vermont   962 2
2294188 2294188 2022-03-10 Unknown Vermont   951 2
2290936 2290936 2022-03-09 Unknown Vermont   958 2
2287684 2287684 2022-03-08 Unknown Vermont   952 2
2284432 2284432 2022-03-07 Unknown Vermont   949 2
2281180 2281180 2022-03-06 Unknown Vermont   937 2
2277927 2277927 2022-03-05 Unknown Vermont   937 2
2274674 2274674 2022-03-04 Unknown Vermont   937 2
2271421 2271421 2022-03-03 Unknown Vermont   927 2
2268169 2268169 2022-03-02 Unknown Vermont   926 2
2264916 2264916 2022-03-01 Unknown Vermont   14028 16
2261666 2261666 2022-02-28 Unknown Vermont   14028 16
2258415 2258415 2022-02-27 Unknown Vermont   15364 17
2255164 2255164 2022-02-26 Unknown Vermont   15364 17
2251913 2251913 2022-02-25 Unknown Vermont   15364 17
2248662 2248662 2022-02-24 Unknown Vermont   15370 17
2245411 2245411 2022-02-23 Unknown Vermont   15457 17
2242160 2242160 2022-02-22 Unknown Vermont   15369 17
2238909 2238909 2022-02-21 Unknown Vermont   15190 16
2235658 2235658 2022-02-20 Unknown Vermont   15190 16
2232407 2232407 2022-02-19 Unknown Vermont   15190 16
2229156 2229156 2022-02-18 Unknown Vermont   15190 16
2225905 2225905 2022-02-17 Unknown Vermont   15098 15
2222654 2222654 2022-02-16 Unknown Vermont   15122 15
2219403 2219403 2022-02-15 Unknown Vermont   14948 15
2216152 2216152 2022-02-14 Unknown Vermont   14910 15
2212901 2212901 2022-02-13 Unknown Vermont   14648 12
2209648 2209648 2022-02-12 Unknown Vermont   14648 12
2206395 2206395 2022-02-11 Unknown Vermont   14648 12
2203142 2203142 2022-02-10 Unknown Vermont   14448 12
2199888 2199888 2022-02-09 Unknown Vermont   14289 11
2196634 2196634 2022-02-08 Unknown Vermont   14013 9
2193380 2193380 2022-02-07 Unknown Vermont   13989 9
2190127 2190127 2022-02-06 Unknown Vermont   13758 9
2186874 2186874 2022-02-05 Unknown Vermont   13758 9
2183621 2183621 2022-02-04 Unknown Vermont   13758 9
2180369 2180369 2022-02-03 Unknown Vermont   13496 8

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