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

797 rows where county = "Kitsap" 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 · 797 ✖

fips 1

county 1

  • Kitsap · 797 ✖
Link rowid date ▲ county state fips cases deaths
2502660 2502660 2022-05-13 Kitsap Washington 53035 41506 344
2499402 2499402 2022-05-12 Kitsap Washington 53035 41312 343
2496144 2496144 2022-05-11 Kitsap Washington 53035 41312 343
2492886 2492886 2022-05-10 Kitsap Washington 53035 41135 340
2489628 2489628 2022-05-09 Kitsap Washington 53035 41135 340
2486371 2486371 2022-05-08 Kitsap Washington 53035 40671 338
2483113 2483113 2022-05-07 Kitsap Washington 53035 40671 338
2479855 2479855 2022-05-06 Kitsap Washington 53035 40671 338
2476597 2476597 2022-05-05 Kitsap Washington 53035 40671 338
2473339 2473339 2022-05-04 Kitsap Washington 53035 40671 338
2470083 2470083 2022-05-03 Kitsap Washington 53035 41003 338
2466827 2466827 2022-05-02 Kitsap Washington 53035 41003 338
2463572 2463572 2022-05-01 Kitsap Washington 53035 40344 338
2460316 2460316 2022-04-30 Kitsap Washington 53035 40344 338
2457060 2457060 2022-04-29 Kitsap Washington 53035 40344 338
2453804 2453804 2022-04-28 Kitsap Washington 53035 40204 338
2450548 2450548 2022-04-27 Kitsap Washington 53035 40204 338
2447292 2447292 2022-04-26 Kitsap Washington 53035 40049 337
2444036 2444036 2022-04-25 Kitsap Washington 53035 40049 337
2440780 2440780 2022-04-24 Kitsap Washington 53035 39866 337
2437524 2437524 2022-04-23 Kitsap Washington 53035 39866 337
2434268 2434268 2022-04-22 Kitsap Washington 53035 39866 337
2431012 2431012 2022-04-21 Kitsap Washington 53035 39722 338
2427756 2427756 2022-04-20 Kitsap Washington 53035 39722 338
2424500 2424500 2022-04-19 Kitsap Washington 53035 39638 336
2421244 2421244 2022-04-18 Kitsap Washington 53035 39638 336
2417988 2417988 2022-04-17 Kitsap Washington 53035 39540 335
2414732 2414732 2022-04-16 Kitsap Washington 53035 39540 335
2411476 2411476 2022-04-15 Kitsap Washington 53035 39540 335
2408220 2408220 2022-04-14 Kitsap Washington 53035 39462 334
2404964 2404964 2022-04-13 Kitsap Washington 53035 39462 334
2401709 2401709 2022-04-12 Kitsap Washington 53035 39373 334
2398454 2398454 2022-04-11 Kitsap Washington 53035 39373 334
2395199 2395199 2022-04-10 Kitsap Washington 53035 39373 334
2391943 2391943 2022-04-09 Kitsap Washington 53035 39373 334
2388687 2388687 2022-04-08 Kitsap Washington 53035 39373 334
2385432 2385432 2022-04-07 Kitsap Washington 53035 39319 334
2382177 2382177 2022-04-06 Kitsap Washington 53035 39319 334
2378922 2378922 2022-04-05 Kitsap Washington 53035 39268 334
2375668 2375668 2022-04-04 Kitsap Washington 53035 39268 334
2372416 2372416 2022-04-03 Kitsap Washington 53035 39217 333
2369163 2369163 2022-04-02 Kitsap Washington 53035 39217 333
2365910 2365910 2022-04-01 Kitsap Washington 53035 39217 333
2362657 2362657 2022-03-31 Kitsap Washington 53035 39161 335
2359403 2359403 2022-03-30 Kitsap Washington 53035 39161 335
2356149 2356149 2022-03-29 Kitsap Washington 53035 39133 335
2352896 2352896 2022-03-28 Kitsap Washington 53035 39133 335
2349644 2349644 2022-03-27 Kitsap Washington 53035 39076 333
2346391 2346391 2022-03-26 Kitsap Washington 53035 39076 333
2343138 2343138 2022-03-25 Kitsap Washington 53035 39076 333
2339885 2339885 2022-03-24 Kitsap Washington 53035 39021 333
2336632 2336632 2022-03-23 Kitsap Washington 53035 39021 333
2333378 2333378 2022-03-22 Kitsap Washington 53035 38980 332
2330124 2330124 2022-03-21 Kitsap Washington 53035 38980 332
2326872 2326872 2022-03-20 Kitsap Washington 53035 38949 330
2323619 2323619 2022-03-19 Kitsap Washington 53035 38949 330
2320365 2320365 2022-03-18 Kitsap Washington 53035 38949 330
2317111 2317111 2022-03-17 Kitsap Washington 53035 38903 328
2313858 2313858 2022-03-16 Kitsap Washington 53035 38903 328
2310605 2310605 2022-03-15 Kitsap Washington 53035 38871 326
2307352 2307352 2022-03-14 Kitsap Washington 53035 38871 326
2304101 2304101 2022-03-13 Kitsap Washington 53035 38783 327
2300849 2300849 2022-03-12 Kitsap Washington 53035 38783 327
2297597 2297597 2022-03-11 Kitsap Washington 53035 38783 327
2294345 2294345 2022-03-10 Kitsap Washington 53035 38728 323
2291093 2291093 2022-03-09 Kitsap Washington 53035 38728 323
2287841 2287841 2022-03-08 Kitsap Washington 53035 38670 323
2284589 2284589 2022-03-07 Kitsap Washington 53035 38670 323
2281337 2281337 2022-03-06 Kitsap Washington 53035 38604 321
2278084 2278084 2022-03-05 Kitsap Washington 53035 38604 321
2274831 2274831 2022-03-04 Kitsap Washington 53035 38604 321
2271578 2271578 2022-03-03 Kitsap Washington 53035 38485 321
2268326 2268326 2022-03-02 Kitsap Washington 53035 38485 321
2265073 2265073 2022-03-01 Kitsap Washington 53035 38357 321
2261823 2261823 2022-02-28 Kitsap Washington 53035 38357 321
2258572 2258572 2022-02-27 Kitsap Washington 53035 38199 318
2255321 2255321 2022-02-26 Kitsap Washington 53035 38199 318
2252070 2252070 2022-02-25 Kitsap Washington 53035 38199 318
2248819 2248819 2022-02-24 Kitsap Washington 53035 38073 309
2245568 2245568 2022-02-23 Kitsap Washington 53035 38073 309
2242317 2242317 2022-02-22 Kitsap Washington 53035 37938 307
2239066 2239066 2022-02-21 Kitsap Washington 53035 37938 307
2235815 2235815 2022-02-20 Kitsap Washington 53035 37938 307
2232564 2232564 2022-02-19 Kitsap Washington 53035 37938 307
2229313 2229313 2022-02-18 Kitsap Washington 53035 37938 307
2226062 2226062 2022-02-17 Kitsap Washington 53035 37937 310
2222811 2222811 2022-02-16 Kitsap Washington 53035 37937 310
2219560 2219560 2022-02-15 Kitsap Washington 53035 37921 305
2216310 2216310 2022-02-14 Kitsap Washington 53035 37921 305
2213059 2213059 2022-02-13 Kitsap Washington 53035 37827 303
2209806 2209806 2022-02-12 Kitsap Washington 53035 37827 303
2206553 2206553 2022-02-11 Kitsap Washington 53035 37827 303
2203300 2203300 2022-02-10 Kitsap Washington 53035 37017 298
2200046 2200046 2022-02-09 Kitsap Washington 53035 37017 298
2196792 2196792 2022-02-08 Kitsap Washington 53035 36773 294
2193537 2193537 2022-02-07 Kitsap Washington 53035 36773 294
2190284 2190284 2022-02-06 Kitsap Washington 53035 36380 289
2187031 2187031 2022-02-05 Kitsap Washington 53035 36380 289
2183778 2183778 2022-02-04 Kitsap Washington 53035 36380 289
2180526 2180526 2022-02-03 Kitsap Washington 53035 36042 282

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