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

793 rows where county = "Columbia", fips = 53013 and state = "Washington" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Washington · 793 ✖

fips 1

  • 53013 · 793 ✖

county 1

  • Columbia · 793 ✖
Link rowid date ▲ county state fips cases deaths
2502649 2502649 2022-05-13 Columbia Washington 53013 613 16
2499391 2499391 2022-05-12 Columbia Washington 53013 613 16
2496133 2496133 2022-05-11 Columbia Washington 53013 613 16
2492875 2492875 2022-05-10 Columbia Washington 53013 612 16
2489617 2489617 2022-05-09 Columbia Washington 53013 612 16
2486360 2486360 2022-05-08 Columbia Washington 53013 610 16
2483102 2483102 2022-05-07 Columbia Washington 53013 610 16
2479844 2479844 2022-05-06 Columbia Washington 53013 610 16
2476586 2476586 2022-05-05 Columbia Washington 53013 610 16
2473328 2473328 2022-05-04 Columbia Washington 53013 610 16
2470072 2470072 2022-05-03 Columbia Washington 53013 609 16
2466816 2466816 2022-05-02 Columbia Washington 53013 609 16
2463561 2463561 2022-05-01 Columbia Washington 53013 609 16
2460305 2460305 2022-04-30 Columbia Washington 53013 609 16
2457049 2457049 2022-04-29 Columbia Washington 53013 609 16
2453793 2453793 2022-04-28 Columbia Washington 53013 608 16
2450537 2450537 2022-04-27 Columbia Washington 53013 608 16
2447281 2447281 2022-04-26 Columbia Washington 53013 608 16
2444025 2444025 2022-04-25 Columbia Washington 53013 608 16
2440769 2440769 2022-04-24 Columbia Washington 53013 608 16
2437513 2437513 2022-04-23 Columbia Washington 53013 608 16
2434257 2434257 2022-04-22 Columbia Washington 53013 608 16
2431001 2431001 2022-04-21 Columbia Washington 53013 608 16
2427745 2427745 2022-04-20 Columbia Washington 53013 608 16
2424489 2424489 2022-04-19 Columbia Washington 53013 608 16
2421233 2421233 2022-04-18 Columbia Washington 53013 608 16
2417977 2417977 2022-04-17 Columbia Washington 53013 608 16
2414721 2414721 2022-04-16 Columbia Washington 53013 608 16
2411465 2411465 2022-04-15 Columbia Washington 53013 608 16
2408209 2408209 2022-04-14 Columbia Washington 53013 608 16
2404953 2404953 2022-04-13 Columbia Washington 53013 608 16
2401698 2401698 2022-04-12 Columbia Washington 53013 608 16
2398443 2398443 2022-04-11 Columbia Washington 53013 608 16
2395188 2395188 2022-04-10 Columbia Washington 53013 608 16
2391932 2391932 2022-04-09 Columbia Washington 53013 608 16
2388676 2388676 2022-04-08 Columbia Washington 53013 608 16
2385421 2385421 2022-04-07 Columbia Washington 53013 608 15
2382166 2382166 2022-04-06 Columbia Washington 53013 608 15
2378911 2378911 2022-04-05 Columbia Washington 53013 608 15
2375657 2375657 2022-04-04 Columbia Washington 53013 608 15
2372405 2372405 2022-04-03 Columbia Washington 53013 608 15
2369152 2369152 2022-04-02 Columbia Washington 53013 608 15
2365899 2365899 2022-04-01 Columbia Washington 53013 608 15
2362646 2362646 2022-03-31 Columbia Washington 53013 608 15
2359392 2359392 2022-03-30 Columbia Washington 53013 608 15
2356138 2356138 2022-03-29 Columbia Washington 53013 608 15
2352885 2352885 2022-03-28 Columbia Washington 53013 608 15
2349633 2349633 2022-03-27 Columbia Washington 53013 608 15
2346380 2346380 2022-03-26 Columbia Washington 53013 608 15
2343127 2343127 2022-03-25 Columbia Washington 53013 608 15
2339874 2339874 2022-03-24 Columbia Washington 53013 608 15
2336621 2336621 2022-03-23 Columbia Washington 53013 608 15
2333367 2333367 2022-03-22 Columbia Washington 53013 608 15
2330113 2330113 2022-03-21 Columbia Washington 53013 608 15
2326861 2326861 2022-03-20 Columbia Washington 53013 607 15
2323608 2323608 2022-03-19 Columbia Washington 53013 607 15
2320354 2320354 2022-03-18 Columbia Washington 53013 607 15
2317100 2317100 2022-03-17 Columbia Washington 53013 607 15
2313847 2313847 2022-03-16 Columbia Washington 53013 607 15
2310594 2310594 2022-03-15 Columbia Washington 53013 607 15
2307341 2307341 2022-03-14 Columbia Washington 53013 607 15
2304090 2304090 2022-03-13 Columbia Washington 53013 607 15
2300838 2300838 2022-03-12 Columbia Washington 53013 607 15
2297586 2297586 2022-03-11 Columbia Washington 53013 607 15
2294334 2294334 2022-03-10 Columbia Washington 53013 605 15
2291082 2291082 2022-03-09 Columbia Washington 53013 605 15
2287830 2287830 2022-03-08 Columbia Washington 53013 603 15
2284578 2284578 2022-03-07 Columbia Washington 53013 603 15
2281326 2281326 2022-03-06 Columbia Washington 53013 603 15
2278073 2278073 2022-03-05 Columbia Washington 53013 603 15
2274820 2274820 2022-03-04 Columbia Washington 53013 603 15
2271567 2271567 2022-03-03 Columbia Washington 53013 604 15
2268315 2268315 2022-03-02 Columbia Washington 53013 604 15
2265062 2265062 2022-03-01 Columbia Washington 53013 602 15
2261812 2261812 2022-02-28 Columbia Washington 53013 602 15
2258561 2258561 2022-02-27 Columbia Washington 53013 606 15
2255310 2255310 2022-02-26 Columbia Washington 53013 606 15
2252059 2252059 2022-02-25 Columbia Washington 53013 606 15
2248808 2248808 2022-02-24 Columbia Washington 53013 604 15
2245557 2245557 2022-02-23 Columbia Washington 53013 604 15
2242306 2242306 2022-02-22 Columbia Washington 53013 603 15
2239055 2239055 2022-02-21 Columbia Washington 53013 603 15
2235804 2235804 2022-02-20 Columbia Washington 53013 603 15
2232553 2232553 2022-02-19 Columbia Washington 53013 603 15
2229302 2229302 2022-02-18 Columbia Washington 53013 603 15
2226051 2226051 2022-02-17 Columbia Washington 53013 601 13
2222800 2222800 2022-02-16 Columbia Washington 53013 601 13
2219549 2219549 2022-02-15 Columbia Washington 53013 592 13
2216299 2216299 2022-02-14 Columbia Washington 53013 592 13
2213048 2213048 2022-02-13 Columbia Washington 53013 589 13
2209795 2209795 2022-02-12 Columbia Washington 53013 589 13
2206542 2206542 2022-02-11 Columbia Washington 53013 589 13
2203289 2203289 2022-02-10 Columbia Washington 53013 576 13
2200035 2200035 2022-02-09 Columbia Washington 53013 576 13
2196781 2196781 2022-02-08 Columbia Washington 53013 570 13
2193526 2193526 2022-02-07 Columbia Washington 53013 570 13
2190273 2190273 2022-02-06 Columbia Washington 53013 557 11
2187020 2187020 2022-02-05 Columbia Washington 53013 557 11
2183767 2183767 2022-02-04 Columbia Washington 53013 557 11
2180515 2180515 2022-02-03 Columbia Washington 53013 553 11

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