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

795 rows where county = "Whatcom", fips = 53073 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Washington · 795 ✖

fips 1

  • 53073 · 795 ✖

county 1

  • Whatcom · 795 ✖
Link rowid date ▲ county state fips cases deaths
2502680 2502680 2022-05-13 Whatcom Washington 53073 39343 301
2499422 2499422 2022-05-12 Whatcom Washington 53073 39188 300
2496164 2496164 2022-05-11 Whatcom Washington 53073 39188 300
2492906 2492906 2022-05-10 Whatcom Washington 53073 39030 300
2489648 2489648 2022-05-09 Whatcom Washington 53073 39030 300
2486391 2486391 2022-05-08 Whatcom Washington 53073 38720 298
2483133 2483133 2022-05-07 Whatcom Washington 53073 38720 298
2479875 2479875 2022-05-06 Whatcom Washington 53073 38720 298
2476617 2476617 2022-05-05 Whatcom Washington 53073 38720 298
2473359 2473359 2022-05-04 Whatcom Washington 53073 38720 298
2470102 2470102 2022-05-03 Whatcom Washington 53073 38680 298
2466846 2466846 2022-05-02 Whatcom Washington 53073 38680 298
2463591 2463591 2022-05-01 Whatcom Washington 53073 38378 298
2460335 2460335 2022-04-30 Whatcom Washington 53073 38378 298
2457079 2457079 2022-04-29 Whatcom Washington 53073 38378 298
2453823 2453823 2022-04-28 Whatcom Washington 53073 38094 299
2450567 2450567 2022-04-27 Whatcom Washington 53073 38094 299
2447311 2447311 2022-04-26 Whatcom Washington 53073 38014 298
2444055 2444055 2022-04-25 Whatcom Washington 53073 38014 298
2440799 2440799 2022-04-24 Whatcom Washington 53073 37877 298
2437543 2437543 2022-04-23 Whatcom Washington 53073 37877 298
2434287 2434287 2022-04-22 Whatcom Washington 53073 37877 298
2431031 2431031 2022-04-21 Whatcom Washington 53073 37792 296
2427775 2427775 2022-04-20 Whatcom Washington 53073 37792 296
2424519 2424519 2022-04-19 Whatcom Washington 53073 37741 293
2421263 2421263 2022-04-18 Whatcom Washington 53073 37741 293
2418007 2418007 2022-04-17 Whatcom Washington 53073 37658 293
2414751 2414751 2022-04-16 Whatcom Washington 53073 37658 293
2411495 2411495 2022-04-15 Whatcom Washington 53073 37658 293
2408239 2408239 2022-04-14 Whatcom Washington 53073 37577 293
2404983 2404983 2022-04-13 Whatcom Washington 53073 37577 293
2401728 2401728 2022-04-12 Whatcom Washington 53073 37429 292
2398473 2398473 2022-04-11 Whatcom Washington 53073 37429 292
2395218 2395218 2022-04-10 Whatcom Washington 53073 37429 292
2391962 2391962 2022-04-09 Whatcom Washington 53073 37429 292
2388706 2388706 2022-04-08 Whatcom Washington 53073 37429 292
2385451 2385451 2022-04-07 Whatcom Washington 53073 37357 292
2382196 2382196 2022-04-06 Whatcom Washington 53073 37357 292
2378941 2378941 2022-04-05 Whatcom Washington 53073 37263 290
2375687 2375687 2022-04-04 Whatcom Washington 53073 37263 290
2372435 2372435 2022-04-03 Whatcom Washington 53073 37226 290
2369182 2369182 2022-04-02 Whatcom Washington 53073 37226 290
2365929 2365929 2022-04-01 Whatcom Washington 53073 37226 290
2362676 2362676 2022-03-31 Whatcom Washington 53073 37191 290
2359422 2359422 2022-03-30 Whatcom Washington 53073 37191 290
2356168 2356168 2022-03-29 Whatcom Washington 53073 37150 289
2352915 2352915 2022-03-28 Whatcom Washington 53073 37150 289
2349663 2349663 2022-03-27 Whatcom Washington 53073 37098 289
2346410 2346410 2022-03-26 Whatcom Washington 53073 37098 289
2343157 2343157 2022-03-25 Whatcom Washington 53073 37098 289
2339904 2339904 2022-03-24 Whatcom Washington 53073 37040 287
2336651 2336651 2022-03-23 Whatcom Washington 53073 37040 287
2333397 2333397 2022-03-22 Whatcom Washington 53073 36983 286
2330143 2330143 2022-03-21 Whatcom Washington 53073 36983 286
2326891 2326891 2022-03-20 Whatcom Washington 53073 36921 287
2323638 2323638 2022-03-19 Whatcom Washington 53073 36921 287
2320384 2320384 2022-03-18 Whatcom Washington 53073 36921 287
2317130 2317130 2022-03-17 Whatcom Washington 53073 36854 282
2313877 2313877 2022-03-16 Whatcom Washington 53073 36854 282
2310624 2310624 2022-03-15 Whatcom Washington 53073 36799 279
2307371 2307371 2022-03-14 Whatcom Washington 53073 36799 279
2304120 2304120 2022-03-13 Whatcom Washington 53073 36747 279
2300868 2300868 2022-03-12 Whatcom Washington 53073 36747 279
2297616 2297616 2022-03-11 Whatcom Washington 53073 36747 279
2294364 2294364 2022-03-10 Whatcom Washington 53073 36663 278
2291112 2291112 2022-03-09 Whatcom Washington 53073 36663 278
2287860 2287860 2022-03-08 Whatcom Washington 53073 36608 274
2284608 2284608 2022-03-07 Whatcom Washington 53073 36608 274
2281356 2281356 2022-03-06 Whatcom Washington 53073 36538 271
2278103 2278103 2022-03-05 Whatcom Washington 53073 36538 271
2274850 2274850 2022-03-04 Whatcom Washington 53073 36538 271
2271597 2271597 2022-03-03 Whatcom Washington 53073 36448 270
2268345 2268345 2022-03-02 Whatcom Washington 53073 36448 270
2265092 2265092 2022-03-01 Whatcom Washington 53073 36352 267
2261842 2261842 2022-02-28 Whatcom Washington 53073 36352 267
2258591 2258591 2022-02-27 Whatcom Washington 53073 36245 267
2255340 2255340 2022-02-26 Whatcom Washington 53073 36245 267
2252089 2252089 2022-02-25 Whatcom Washington 53073 36245 267
2248838 2248838 2022-02-24 Whatcom Washington 53073 36211 262
2245587 2245587 2022-02-23 Whatcom Washington 53073 36211 262
2242336 2242336 2022-02-22 Whatcom Washington 53073 36176 260
2239085 2239085 2022-02-21 Whatcom Washington 53073 36176 260
2235834 2235834 2022-02-20 Whatcom Washington 53073 36176 260
2232583 2232583 2022-02-19 Whatcom Washington 53073 36176 260
2229332 2229332 2022-02-18 Whatcom Washington 53073 36176 260
2226081 2226081 2022-02-17 Whatcom Washington 53073 36240 259
2222830 2222830 2022-02-16 Whatcom Washington 53073 36240 259
2219579 2219579 2022-02-15 Whatcom Washington 53073 36248 253
2216329 2216329 2022-02-14 Whatcom Washington 53073 36248 253
2213078 2213078 2022-02-13 Whatcom Washington 53073 36154 252
2209825 2209825 2022-02-12 Whatcom Washington 53073 36154 252
2206572 2206572 2022-02-11 Whatcom Washington 53073 36154 252
2203319 2203319 2022-02-10 Whatcom Washington 53073 35385 246
2200065 2200065 2022-02-09 Whatcom Washington 53073 35385 246
2196811 2196811 2022-02-08 Whatcom Washington 53073 35140 242
2193556 2193556 2022-02-07 Whatcom Washington 53073 35140 242
2190303 2190303 2022-02-06 Whatcom Washington 53073 34652 242
2187050 2187050 2022-02-05 Whatcom Washington 53073 34652 242
2183797 2183797 2022-02-04 Whatcom Washington 53073 34652 242
2180545 2180545 2022-02-03 Whatcom Washington 53073 34259 238

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