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

786 rows where county = "Bayfield" and state = "Wisconsin" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Wisconsin · 786 ✖

fips 1

county 1

  • Bayfield · 786 ✖
Link rowid date ▲ county state fips cases deaths
2502741 2502741 2022-05-13 Bayfield Wisconsin 55007 3425 41
2499483 2499483 2022-05-12 Bayfield Wisconsin 55007 3417 41
2496225 2496225 2022-05-11 Bayfield Wisconsin 55007 3409 41
2492967 2492967 2022-05-10 Bayfield Wisconsin 55007 3402 41
2489709 2489709 2022-05-09 Bayfield Wisconsin 55007 3395 40
2486452 2486452 2022-05-08 Bayfield Wisconsin 55007 3386 40
2483194 2483194 2022-05-07 Bayfield Wisconsin 55007 3386 40
2479936 2479936 2022-05-06 Bayfield Wisconsin 55007 3386 40
2476678 2476678 2022-05-05 Bayfield Wisconsin 55007 3382 40
2473420 2473420 2022-05-04 Bayfield Wisconsin 55007 3377 40
2470163 2470163 2022-05-03 Bayfield Wisconsin 55007 3370 40
2466907 2466907 2022-05-02 Bayfield Wisconsin 55007 3361 40
2463652 2463652 2022-05-01 Bayfield Wisconsin 55007 3356 40
2460396 2460396 2022-04-30 Bayfield Wisconsin 55007 3356 40
2457140 2457140 2022-04-29 Bayfield Wisconsin 55007 3356 40
2453884 2453884 2022-04-28 Bayfield Wisconsin 55007 3354 40
2450628 2450628 2022-04-27 Bayfield Wisconsin 55007 3348 40
2447372 2447372 2022-04-26 Bayfield Wisconsin 55007 3339 40
2444116 2444116 2022-04-25 Bayfield Wisconsin 55007 3333 40
2440860 2440860 2022-04-24 Bayfield Wisconsin 55007 3325 40
2437604 2437604 2022-04-23 Bayfield Wisconsin 55007 3325 40
2434348 2434348 2022-04-22 Bayfield Wisconsin 55007 3325 40
2431092 2431092 2022-04-21 Bayfield Wisconsin 55007 3326 40
2427836 2427836 2022-04-20 Bayfield Wisconsin 55007 3315 40
2424580 2424580 2022-04-19 Bayfield Wisconsin 55007 3311 40
2421324 2421324 2022-04-18 Bayfield Wisconsin 55007 3310 40
2418068 2418068 2022-04-17 Bayfield Wisconsin 55007 3306 40
2414812 2414812 2022-04-16 Bayfield Wisconsin 55007 3306 40
2411556 2411556 2022-04-15 Bayfield Wisconsin 55007 3306 40
2408300 2408300 2022-04-14 Bayfield Wisconsin 55007 3304 40
2405044 2405044 2022-04-13 Bayfield Wisconsin 55007 3296 40
2401789 2401789 2022-04-12 Bayfield Wisconsin 55007 3291 40
2398534 2398534 2022-04-11 Bayfield Wisconsin 55007 3287 40
2395279 2395279 2022-04-10 Bayfield Wisconsin 55007 3286 40
2392023 2392023 2022-04-09 Bayfield Wisconsin 55007 3286 40
2388767 2388767 2022-04-08 Bayfield Wisconsin 55007 3286 40
2385512 2385512 2022-04-07 Bayfield Wisconsin 55007 3283 40
2382257 2382257 2022-04-06 Bayfield Wisconsin 55007 3280 40
2379002 2379002 2022-04-05 Bayfield Wisconsin 55007 3279 40
2375748 2375748 2022-04-04 Bayfield Wisconsin 55007 3273 40
2372496 2372496 2022-04-03 Bayfield Wisconsin 55007 3272 40
2369243 2369243 2022-04-02 Bayfield Wisconsin 55007 3272 40
2365990 2365990 2022-04-01 Bayfield Wisconsin 55007 3272 40
2362737 2362737 2022-03-31 Bayfield Wisconsin 55007 3271 40
2359483 2359483 2022-03-30 Bayfield Wisconsin 55007 3270 39
2356229 2356229 2022-03-29 Bayfield Wisconsin 55007 3270 39
2352976 2352976 2022-03-28 Bayfield Wisconsin 55007 3270 39
2349724 2349724 2022-03-27 Bayfield Wisconsin 55007 3266 39
2346471 2346471 2022-03-26 Bayfield Wisconsin 55007 3266 39
2343218 2343218 2022-03-25 Bayfield Wisconsin 55007 3266 39
2339965 2339965 2022-03-24 Bayfield Wisconsin 55007 3263 39
2336712 2336712 2022-03-23 Bayfield Wisconsin 55007 3257 39
2333458 2333458 2022-03-22 Bayfield Wisconsin 55007 3255 39
2330204 2330204 2022-03-21 Bayfield Wisconsin 55007 3253 39
2326952 2326952 2022-03-20 Bayfield Wisconsin 55007 3251 38
2323699 2323699 2022-03-19 Bayfield Wisconsin 55007 3251 38
2320445 2320445 2022-03-18 Bayfield Wisconsin 55007 3251 38
2317191 2317191 2022-03-17 Bayfield Wisconsin 55007 3251 38
2313938 2313938 2022-03-16 Bayfield Wisconsin 55007 3245 38
2310685 2310685 2022-03-15 Bayfield Wisconsin 55007 3245 38
2307432 2307432 2022-03-14 Bayfield Wisconsin 55007 3241 38
2304181 2304181 2022-03-13 Bayfield Wisconsin 55007 3237 38
2300929 2300929 2022-03-12 Bayfield Wisconsin 55007 3237 38
2297677 2297677 2022-03-11 Bayfield Wisconsin 55007 3237 38
2294425 2294425 2022-03-10 Bayfield Wisconsin 55007 3235 38
2291173 2291173 2022-03-09 Bayfield Wisconsin 55007 3225 38
2287921 2287921 2022-03-08 Bayfield Wisconsin 55007 3222 38
2284669 2284669 2022-03-07 Bayfield Wisconsin 55007 3220 38
2281417 2281417 2022-03-06 Bayfield Wisconsin 55007 3215 38
2278164 2278164 2022-03-05 Bayfield Wisconsin 55007 3215 38
2274911 2274911 2022-03-04 Bayfield Wisconsin 55007 3215 38
2271658 2271658 2022-03-03 Bayfield Wisconsin 55007 3212 38
2268406 2268406 2022-03-02 Bayfield Wisconsin 55007 3209 38
2265153 2265153 2022-03-01 Bayfield Wisconsin 55007 3202 38
2261903 2261903 2022-02-28 Bayfield Wisconsin 55007 3202 38
2258652 2258652 2022-02-27 Bayfield Wisconsin 55007 3193 38
2255401 2255401 2022-02-26 Bayfield Wisconsin 55007 3193 38
2252150 2252150 2022-02-25 Bayfield Wisconsin 55007 3193 38
2248899 2248899 2022-02-24 Bayfield Wisconsin 55007 3186 38
2245648 2245648 2022-02-23 Bayfield Wisconsin 55007 3178 38
2242397 2242397 2022-02-22 Bayfield Wisconsin 55007 3177 38
2239146 2239146 2022-02-21 Bayfield Wisconsin 55007 3174 38
2235895 2235895 2022-02-20 Bayfield Wisconsin 55007 3163 38
2232644 2232644 2022-02-19 Bayfield Wisconsin 55007 3163 38
2229393 2229393 2022-02-18 Bayfield Wisconsin 55007 3163 38
2226142 2226142 2022-02-17 Bayfield Wisconsin 55007 3153 38
2222891 2222891 2022-02-16 Bayfield Wisconsin 55007 3150 38
2219640 2219640 2022-02-15 Bayfield Wisconsin 55007 3137 38
2216390 2216390 2022-02-14 Bayfield Wisconsin 55007 3130 38
2213139 2213139 2022-02-13 Bayfield Wisconsin 55007 3113 38
2209886 2209886 2022-02-12 Bayfield Wisconsin 55007 3113 38
2206633 2206633 2022-02-11 Bayfield Wisconsin 55007 3113 38
2203380 2203380 2022-02-10 Bayfield Wisconsin 55007 3105 38
2200126 2200126 2022-02-09 Bayfield Wisconsin 55007 3086 38
2196872 2196872 2022-02-08 Bayfield Wisconsin 55007 3079 37
2193617 2193617 2022-02-07 Bayfield Wisconsin 55007 3069 37
2190364 2190364 2022-02-06 Bayfield Wisconsin 55007 3035 37
2187111 2187111 2022-02-05 Bayfield Wisconsin 55007 3035 37
2183858 2183858 2022-02-04 Bayfield Wisconsin 55007 3035 37
2180606 2180606 2022-02-03 Bayfield Wisconsin 55007 3028 37

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