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

784 rows where county = "Franklin", fips = 50011 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 · 784 ✖

fips 1

  • 50011 · 784 ✖

county 1

  • Franklin · 784 ✖
Link rowid date ▲ county state fips cases deaths
2502497 2502497 2022-05-13 Franklin Vermont 50011 10325 67
2499239 2499239 2022-05-12 Franklin Vermont 50011 10312 67
2495981 2495981 2022-05-11 Franklin Vermont 50011 10288 67
2492723 2492723 2022-05-10 Franklin Vermont 50011 10272 67
2489465 2489465 2022-05-09 Franklin Vermont 50011 10261 67
2486207 2486207 2022-05-08 Franklin Vermont 50011 10220 67
2482949 2482949 2022-05-07 Franklin Vermont 50011 10220 67
2479691 2479691 2022-05-06 Franklin Vermont 50011 10220 67
2476433 2476433 2022-05-05 Franklin Vermont 50011 10202 67
2473176 2473176 2022-05-04 Franklin Vermont 50011 10188 67
2469920 2469920 2022-05-03 Franklin Vermont 50011 10161 67
2466664 2466664 2022-05-02 Franklin Vermont 50011 10143 67
2463409 2463409 2022-05-01 Franklin Vermont 50011 10090 66
2460153 2460153 2022-04-30 Franklin Vermont 50011 10090 66
2456897 2456897 2022-04-29 Franklin Vermont 50011 10090 66
2453641 2453641 2022-04-28 Franklin Vermont 50011 10059 66
2450385 2450385 2022-04-27 Franklin Vermont 50011 9942 66
2447128 2447128 2022-04-26 Franklin Vermont 50011 9942 66
2443873 2443873 2022-04-25 Franklin Vermont 50011 9942 66
2440617 2440617 2022-04-24 Franklin Vermont 50011 9874 66
2437361 2437361 2022-04-23 Franklin Vermont 50011 9874 66
2434105 2434105 2022-04-22 Franklin Vermont 50011 9874 66
2430849 2430849 2022-04-21 Franklin Vermont 50011 9845 66
2427593 2427593 2022-04-20 Franklin Vermont 50011 9821 66
2424337 2424337 2022-04-19 Franklin Vermont 50011 9784 66
2421081 2421081 2022-04-18 Franklin Vermont 50011 9771 66
2417825 2417825 2022-04-17 Franklin Vermont 50011 9718 66
2414569 2414569 2022-04-16 Franklin Vermont 50011 9718 66
2411313 2411313 2022-04-15 Franklin Vermont 50011 9718 66
2408057 2408057 2022-04-14 Franklin Vermont 50011 9694 66
2404801 2404801 2022-04-13 Franklin Vermont 50011 9666 66
2401546 2401546 2022-04-12 Franklin Vermont 50011 9645 66
2398291 2398291 2022-04-11 Franklin Vermont 50011 9631 66
2395036 2395036 2022-04-10 Franklin Vermont 50011 9584 66
2391780 2391780 2022-04-09 Franklin Vermont 50011 9584 66
2388524 2388524 2022-04-08 Franklin Vermont 50011 9584 66
2385269 2385269 2022-04-07 Franklin Vermont 50011 9569 66
2382014 2382014 2022-04-06 Franklin Vermont 50011 9551 66
2378759 2378759 2022-04-05 Franklin Vermont 50011 9529 66
2375505 2375505 2022-04-04 Franklin Vermont 50011 9522 66
2372253 2372253 2022-04-03 Franklin Vermont 50011 9497 66
2369000 2369000 2022-04-02 Franklin Vermont 50011 9497 66
2365747 2365747 2022-04-01 Franklin Vermont 50011 9497 66
2362494 2362494 2022-03-31 Franklin Vermont 50011 9487 66
2359240 2359240 2022-03-30 Franklin Vermont 50011 9474 66
2355986 2355986 2022-03-29 Franklin Vermont 50011 9454 66
2352733 2352733 2022-03-28 Franklin Vermont 50011 9447 66
2349481 2349481 2022-03-27 Franklin Vermont 50011 9409 66
2346228 2346228 2022-03-26 Franklin Vermont 50011 9409 66
2342975 2342975 2022-03-25 Franklin Vermont 50011 9409 66
2339722 2339722 2022-03-24 Franklin Vermont 50011 9400 66
2336468 2336468 2022-03-23 Franklin Vermont 50011 9391 66
2333214 2333214 2022-03-22 Franklin Vermont 50011 9378 66
2329961 2329961 2022-03-21 Franklin Vermont 50011 9377 66
2326709 2326709 2022-03-20 Franklin Vermont 50011 9360 66
2323456 2323456 2022-03-19 Franklin Vermont 50011 9360 66
2320202 2320202 2022-03-18 Franklin Vermont 50011 9360 66
2316948 2316948 2022-03-17 Franklin Vermont 50011 9354 66
2313695 2313695 2022-03-16 Franklin Vermont 50011 9343 66
2310442 2310442 2022-03-15 Franklin Vermont 50011 9333 66
2307189 2307189 2022-03-14 Franklin Vermont 50011 9327 66
2303938 2303938 2022-03-13 Franklin Vermont 50011 9300 66
2300686 2300686 2022-03-12 Franklin Vermont 50011 9300 66
2297434 2297434 2022-03-11 Franklin Vermont 50011 9300 66
2294182 2294182 2022-03-10 Franklin Vermont 50011 9293 66
2290930 2290930 2022-03-09 Franklin Vermont 50011 9287 66
2287678 2287678 2022-03-08 Franklin Vermont 50011 9279 66
2284426 2284426 2022-03-07 Franklin Vermont 50011 9273 66
2281174 2281174 2022-03-06 Franklin Vermont 50011 9267 66
2277921 2277921 2022-03-05 Franklin Vermont 50011 9267 66
2274668 2274668 2022-03-04 Franklin Vermont 50011 9267 66
2271415 2271415 2022-03-03 Franklin Vermont 50011 9262 66
2268163 2268163 2022-03-02 Franklin Vermont 50011 9251 65
2264910 2264910 2022-03-01 Franklin Vermont 50011 8360 63
2261660 2261660 2022-02-28 Franklin Vermont 50011 8360 63
2258409 2258409 2022-02-27 Franklin Vermont 50011 8319 62
2255158 2255158 2022-02-26 Franklin Vermont 50011 8319 62
2251907 2251907 2022-02-25 Franklin Vermont 50011 8319 62
2248656 2248656 2022-02-24 Franklin Vermont 50011 8302 62
2245405 2245405 2022-02-23 Franklin Vermont 50011 8271 62
2242154 2242154 2022-02-22 Franklin Vermont 50011 8265 62
2238903 2238903 2022-02-21 Franklin Vermont 50011 8233 61
2235652 2235652 2022-02-20 Franklin Vermont 50011 8233 61
2232401 2232401 2022-02-19 Franklin Vermont 50011 8233 61
2229150 2229150 2022-02-18 Franklin Vermont 50011 8233 61
2225899 2225899 2022-02-17 Franklin Vermont 50011 8221 61
2222648 2222648 2022-02-16 Franklin Vermont 50011 8207 60
2219397 2219397 2022-02-15 Franklin Vermont 50011 8185 60
2216146 2216146 2022-02-14 Franklin Vermont 50011 8180 60
2212895 2212895 2022-02-13 Franklin Vermont 50011 8140 60
2209642 2209642 2022-02-12 Franklin Vermont 50011 8140 60
2206389 2206389 2022-02-11 Franklin Vermont 50011 8140 60
2203136 2203136 2022-02-10 Franklin Vermont 50011 8124 60
2199882 2199882 2022-02-09 Franklin Vermont 50011 8102 59
2196628 2196628 2022-02-08 Franklin Vermont 50011 8085 59
2193374 2193374 2022-02-07 Franklin Vermont 50011 8081 59
2190121 2190121 2022-02-06 Franklin Vermont 50011 8023 59
2186868 2186868 2022-02-05 Franklin Vermont 50011 8023 59
2183615 2183615 2022-02-04 Franklin Vermont 50011 8023 59
2180363 2180363 2022-02-03 Franklin Vermont 50011 8001 58

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