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

780 rows where fips = 50015 and state = "Vermont" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Vermont · 780 ✖

fips 1

  • 50015 · 780 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502499 2502499 2022-05-13 Lamoille Vermont 50015 3964 17
2499241 2499241 2022-05-12 Lamoille Vermont 50015 3957 17
2495983 2495983 2022-05-11 Lamoille Vermont 50015 3937 17
2492725 2492725 2022-05-10 Lamoille Vermont 50015 3936 17
2489467 2489467 2022-05-09 Lamoille Vermont 50015 3934 17
2486209 2486209 2022-05-08 Lamoille Vermont 50015 3924 17
2482951 2482951 2022-05-07 Lamoille Vermont 50015 3924 17
2479693 2479693 2022-05-06 Lamoille Vermont 50015 3924 17
2476435 2476435 2022-05-05 Lamoille Vermont 50015 3921 17
2473178 2473178 2022-05-04 Lamoille Vermont 50015 3918 17
2469922 2469922 2022-05-03 Lamoille Vermont 50015 3910 17
2466666 2466666 2022-05-02 Lamoille Vermont 50015 3905 17
2463411 2463411 2022-05-01 Lamoille Vermont 50015 3892 16
2460155 2460155 2022-04-30 Lamoille Vermont 50015 3892 16
2456899 2456899 2022-04-29 Lamoille Vermont 50015 3892 16
2453643 2453643 2022-04-28 Lamoille Vermont 50015 3894 16
2450387 2450387 2022-04-27 Lamoille Vermont 50015 3943 17
2447130 2447130 2022-04-26 Lamoille Vermont 50015 3943 17
2443875 2443875 2022-04-25 Lamoille Vermont 50015 3943 17
2440619 2440619 2022-04-24 Lamoille Vermont 50015 3932 17
2437363 2437363 2022-04-23 Lamoille Vermont 50015 3932 17
2434107 2434107 2022-04-22 Lamoille Vermont 50015 3932 17
2430851 2430851 2022-04-21 Lamoille Vermont 50015 3929 17
2427595 2427595 2022-04-20 Lamoille Vermont 50015 3924 17
2424339 2424339 2022-04-19 Lamoille Vermont 50015 3915 17
2421083 2421083 2022-04-18 Lamoille Vermont 50015 3914 17
2417827 2417827 2022-04-17 Lamoille Vermont 50015 3894 17
2414571 2414571 2022-04-16 Lamoille Vermont 50015 3894 17
2411315 2411315 2022-04-15 Lamoille Vermont 50015 3894 17
2408059 2408059 2022-04-14 Lamoille Vermont 50015 3888 17
2404803 2404803 2022-04-13 Lamoille Vermont 50015 3883 17
2401548 2401548 2022-04-12 Lamoille Vermont 50015 3878 17
2398293 2398293 2022-04-11 Lamoille Vermont 50015 3874 17
2395038 2395038 2022-04-10 Lamoille Vermont 50015 3858 17
2391782 2391782 2022-04-09 Lamoille Vermont 50015 3858 17
2388526 2388526 2022-04-08 Lamoille Vermont 50015 3858 17
2385271 2385271 2022-04-07 Lamoille Vermont 50015 3851 17
2382016 2382016 2022-04-06 Lamoille Vermont 50015 3848 17
2378761 2378761 2022-04-05 Lamoille Vermont 50015 3842 17
2375507 2375507 2022-04-04 Lamoille Vermont 50015 3841 17
2372255 2372255 2022-04-03 Lamoille Vermont 50015 3835 17
2369002 2369002 2022-04-02 Lamoille Vermont 50015 3835 17
2365749 2365749 2022-04-01 Lamoille Vermont 50015 3835 17
2362496 2362496 2022-03-31 Lamoille Vermont 50015 3831 17
2359242 2359242 2022-03-30 Lamoille Vermont 50015 3828 17
2355988 2355988 2022-03-29 Lamoille Vermont 50015 3825 17
2352735 2352735 2022-03-28 Lamoille Vermont 50015 3822 17
2349483 2349483 2022-03-27 Lamoille Vermont 50015 3813 17
2346230 2346230 2022-03-26 Lamoille Vermont 50015 3813 17
2342977 2342977 2022-03-25 Lamoille Vermont 50015 3813 17
2339724 2339724 2022-03-24 Lamoille Vermont 50015 3811 17
2336470 2336470 2022-03-23 Lamoille Vermont 50015 3809 17
2333216 2333216 2022-03-22 Lamoille Vermont 50015 3802 17
2329963 2329963 2022-03-21 Lamoille Vermont 50015 3799 17
2326711 2326711 2022-03-20 Lamoille Vermont 50015 3780 17
2323458 2323458 2022-03-19 Lamoille Vermont 50015 3780 17
2320204 2320204 2022-03-18 Lamoille Vermont 50015 3780 17
2316950 2316950 2022-03-17 Lamoille Vermont 50015 3775 17
2313697 2313697 2022-03-16 Lamoille Vermont 50015 3774 17
2310444 2310444 2022-03-15 Lamoille Vermont 50015 3766 17
2307191 2307191 2022-03-14 Lamoille Vermont 50015 3762 17
2303940 2303940 2022-03-13 Lamoille Vermont 50015 3754 17
2300688 2300688 2022-03-12 Lamoille Vermont 50015 3754 17
2297436 2297436 2022-03-11 Lamoille Vermont 50015 3754 17
2294184 2294184 2022-03-10 Lamoille Vermont 50015 3745 17
2290932 2290932 2022-03-09 Lamoille Vermont 50015 3734 17
2287680 2287680 2022-03-08 Lamoille Vermont 50015 3729 17
2284428 2284428 2022-03-07 Lamoille Vermont 50015 3728 17
2281176 2281176 2022-03-06 Lamoille Vermont 50015 3721 17
2277923 2277923 2022-03-05 Lamoille Vermont 50015 3721 17
2274670 2274670 2022-03-04 Lamoille Vermont 50015 3721 17
2271417 2271417 2022-03-03 Lamoille Vermont 50015 3718 17
2268165 2268165 2022-03-02 Lamoille Vermont 50015 3717 17
2264912 2264912 2022-03-01 Lamoille Vermont 50015 3224 16
2261662 2261662 2022-02-28 Lamoille Vermont 50015 3224 16
2258411 2258411 2022-02-27 Lamoille Vermont 50015 3218 15
2255160 2255160 2022-02-26 Lamoille Vermont 50015 3218 15
2251909 2251909 2022-02-25 Lamoille Vermont 50015 3218 15
2248658 2248658 2022-02-24 Lamoille Vermont 50015 3213 15
2245407 2245407 2022-02-23 Lamoille Vermont 50015 3210 15
2242156 2242156 2022-02-22 Lamoille Vermont 50015 3208 15
2238905 2238905 2022-02-21 Lamoille Vermont 50015 3200 15
2235654 2235654 2022-02-20 Lamoille Vermont 50015 3200 15
2232403 2232403 2022-02-19 Lamoille Vermont 50015 3200 15
2229152 2229152 2022-02-18 Lamoille Vermont 50015 3200 15
2225901 2225901 2022-02-17 Lamoille Vermont 50015 3192 15
2222650 2222650 2022-02-16 Lamoille Vermont 50015 3183 15
2219399 2219399 2022-02-15 Lamoille Vermont 50015 3178 15
2216148 2216148 2022-02-14 Lamoille Vermont 50015 3170 15
2212897 2212897 2022-02-13 Lamoille Vermont 50015 3157 15
2209644 2209644 2022-02-12 Lamoille Vermont 50015 3157 15
2206391 2206391 2022-02-11 Lamoille Vermont 50015 3157 15
2203138 2203138 2022-02-10 Lamoille Vermont 50015 3150 15
2199884 2199884 2022-02-09 Lamoille Vermont 50015 3146 14
2196630 2196630 2022-02-08 Lamoille Vermont 50015 3144 14
2193376 2193376 2022-02-07 Lamoille Vermont 50015 3142 13
2190123 2190123 2022-02-06 Lamoille Vermont 50015 3126 13
2186870 2186870 2022-02-05 Lamoille Vermont 50015 3126 13
2183617 2183617 2022-02-04 Lamoille Vermont 50015 3126 13
2180365 2180365 2022-02-03 Lamoille Vermont 50015 3124 13

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