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

790 rows where county = "Washington" and fips = 27163 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 27163 · 790 ✖

county 1

  • Washington · 790 ✖
Link rowid date ▲ county state fips cases deaths
2500987 2500987 2022-05-13 Washington Minnesota 27163 69180 481
2497729 2497729 2022-05-12 Washington Minnesota 27163 69030 480
2494471 2494471 2022-05-11 Washington Minnesota 27163 68919 480
2491213 2491213 2022-05-10 Washington Minnesota 27163 68829 480
2487956 2487956 2022-05-09 Washington Minnesota 27163 68496 479
2484698 2484698 2022-05-08 Washington Minnesota 27163 68361 479
2481440 2481440 2022-05-07 Washington Minnesota 27163 68361 479
2478182 2478182 2022-05-06 Washington Minnesota 27163 68361 479
2474924 2474924 2022-05-05 Washington Minnesota 27163 68249 479
2471667 2471667 2022-05-04 Washington Minnesota 27163 68153 479
2468411 2468411 2022-05-03 Washington Minnesota 27163 67997 479
2465156 2465156 2022-05-02 Washington Minnesota 27163 67868 479
2461900 2461900 2022-05-01 Washington Minnesota 27163 67767 479
2458644 2458644 2022-04-30 Washington Minnesota 27163 67767 479
2455388 2455388 2022-04-29 Washington Minnesota 27163 67767 479
2452132 2452132 2022-04-28 Washington Minnesota 27163 67669 479
2448876 2448876 2022-04-27 Washington Minnesota 27163 67591 479
2445620 2445620 2022-04-26 Washington Minnesota 27163 67515 479
2442364 2442364 2022-04-25 Washington Minnesota 27163 67360 479
2439108 2439108 2022-04-24 Washington Minnesota 27163 67311 479
2435852 2435852 2022-04-23 Washington Minnesota 27163 67311 479
2432596 2432596 2022-04-22 Washington Minnesota 27163 67311 479
2429340 2429340 2022-04-21 Washington Minnesota 27163 67253 479
2426084 2426084 2022-04-20 Washington Minnesota 27163 67228 479
2422828 2422828 2022-04-19 Washington Minnesota 27163 67195 479
2419572 2419572 2022-04-18 Washington Minnesota 27163 67092 479
2416316 2416316 2022-04-17 Washington Minnesota 27163 67056 479
2413060 2413060 2022-04-16 Washington Minnesota 27163 67056 479
2409804 2409804 2022-04-15 Washington Minnesota 27163 67056 479
2406548 2406548 2022-04-14 Washington Minnesota 27163 67021 479
2403292 2403292 2022-04-13 Washington Minnesota 27163 66982 479
2400038 2400038 2022-04-12 Washington Minnesota 27163 66959 479
2396782 2396782 2022-04-11 Washington Minnesota 27163 66866 479
2393527 2393527 2022-04-10 Washington Minnesota 27163 66827 479
2390271 2390271 2022-04-09 Washington Minnesota 27163 66827 479
2387015 2387015 2022-04-08 Washington Minnesota 27163 66827 479
2383760 2383760 2022-04-07 Washington Minnesota 27163 66782 478
2380505 2380505 2022-04-06 Washington Minnesota 27163 66753 478
2377250 2377250 2022-04-05 Washington Minnesota 27163 66743 477
2373998 2373998 2022-04-04 Washington Minnesota 27163 66690 477
2370745 2370745 2022-04-03 Washington Minnesota 27163 66671 477
2367492 2367492 2022-04-02 Washington Minnesota 27163 66671 477
2364239 2364239 2022-04-01 Washington Minnesota 27163 66671 477
2360985 2360985 2022-03-31 Washington Minnesota 27163 66649 477
2357731 2357731 2022-03-30 Washington Minnesota 27163 66612 477
2354478 2354478 2022-03-29 Washington Minnesota 27163 66596 477
2351226 2351226 2022-03-28 Washington Minnesota 27163 66544 476
2347973 2347973 2022-03-27 Washington Minnesota 27163 66524 476
2344720 2344720 2022-03-26 Washington Minnesota 27163 66524 476
2341467 2341467 2022-03-25 Washington Minnesota 27163 66524 476
2338214 2338214 2022-03-24 Washington Minnesota 27163 66508 476
2334960 2334960 2022-03-23 Washington Minnesota 27163 66471 476
2331706 2331706 2022-03-22 Washington Minnesota 27163 66457 476
2328454 2328454 2022-03-21 Washington Minnesota 27163 66404 474
2325201 2325201 2022-03-20 Washington Minnesota 27163 66384 474
2321947 2321947 2022-03-19 Washington Minnesota 27163 66384 474
2318693 2318693 2022-03-18 Washington Minnesota 27163 66384 474
2315440 2315440 2022-03-17 Washington Minnesota 27163 66356 474
2312187 2312187 2022-03-16 Washington Minnesota 27163 66348 473
2308934 2308934 2022-03-15 Washington Minnesota 27163 66293 471
2305683 2305683 2022-03-14 Washington Minnesota 27163 66260 471
2302431 2302431 2022-03-13 Washington Minnesota 27163 66232 470
2299179 2299179 2022-03-12 Washington Minnesota 27163 66232 470
2295927 2295927 2022-03-11 Washington Minnesota 27163 66232 470
2292675 2292675 2022-03-10 Washington Minnesota 27163 66096 470
2289423 2289423 2022-03-09 Washington Minnesota 27163 66068 470
2286172 2286172 2022-03-08 Washington Minnesota 27163 66048 470
2282920 2282920 2022-03-07 Washington Minnesota 27163 65943 469
2279667 2279667 2022-03-06 Washington Minnesota 27163 65913 469
2276414 2276414 2022-03-05 Washington Minnesota 27163 65913 469
2273161 2273161 2022-03-04 Washington Minnesota 27163 65913 469
2269909 2269909 2022-03-03 Washington Minnesota 27163 65855 469
2266656 2266656 2022-03-02 Washington Minnesota 27163 65821 467
2263405 2263405 2022-03-01 Washington Minnesota 27163 65861 467
2260154 2260154 2022-02-28 Washington Minnesota 27163 65754 467
2256903 2256903 2022-02-27 Washington Minnesota 27163 65707 466
2253652 2253652 2022-02-26 Washington Minnesota 27163 65707 466
2250401 2250401 2022-02-25 Washington Minnesota 27163 65707 466
2247150 2247150 2022-02-24 Washington Minnesota 27163 65673 466
2243899 2243899 2022-02-23 Washington Minnesota 27163 65623 466
2240648 2240648 2022-02-22 Washington Minnesota 27163 65449 465
2237397 2237397 2022-02-21 Washington Minnesota 27163 65380 463
2234146 2234146 2022-02-20 Washington Minnesota 27163 65380 463
2230895 2230895 2022-02-19 Washington Minnesota 27163 65380 463
2227644 2227644 2022-02-18 Washington Minnesota 27163 65380 463
2224393 2224393 2022-02-17 Washington Minnesota 27163 65153 463
2221142 2221142 2022-02-16 Washington Minnesota 27163 65116 463
2217891 2217891 2022-02-15 Washington Minnesota 27163 65069 461
2214640 2214640 2022-02-14 Washington Minnesota 27163 64816 461
2211388 2211388 2022-02-13 Washington Minnesota 27163 64540 461
2208135 2208135 2022-02-12 Washington Minnesota 27163 64540 461
2204882 2204882 2022-02-11 Washington Minnesota 27163 64540 461
2201629 2201629 2022-02-10 Washington Minnesota 27163 64402 460
2198375 2198375 2022-02-09 Washington Minnesota 27163 64218 459
2195121 2195121 2022-02-08 Washington Minnesota 27163 63957 458
2191867 2191867 2022-02-07 Washington Minnesota 27163 63571 457
2188614 2188614 2022-02-06 Washington Minnesota 27163 63275 453
2185361 2185361 2022-02-05 Washington Minnesota 27163 63275 453
2182109 2182109 2022-02-04 Washington Minnesota 27163 63275 453
2178857 2178857 2022-02-03 Washington Minnesota 27163 63020 450

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