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

782 rows where county = "Washington" and state = "Nebraska" sorted by date descending

✎ View and edit SQL

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

state 1

  • Nebraska · 782 ✖

fips 1

county 1

  • Washington · 782 ✖
Link rowid date ▲ county state fips cases deaths
2501338 2501338 2022-05-13 Washington Nebraska 31177 4582 45
2498080 2498080 2022-05-12 Washington Nebraska 31177 4575 43
2494822 2494822 2022-05-11 Washington Nebraska 31177 4575 43
2491564 2491564 2022-05-10 Washington Nebraska 31177 4598 43
2488306 2488306 2022-05-09 Washington Nebraska 31177 4598 43
2485049 2485049 2022-05-08 Washington Nebraska 31177 4595 43
2481791 2481791 2022-05-07 Washington Nebraska 31177 4595 43
2478533 2478533 2022-05-06 Washington Nebraska 31177 4595 43
2475275 2475275 2022-05-05 Washington Nebraska 31177 4595 43
2472018 2472018 2022-05-04 Washington Nebraska 31177 4585 43
2468762 2468762 2022-05-03 Washington Nebraska 31177 4585 43
2465506 2465506 2022-05-02 Washington Nebraska 31177 4585 43
2462251 2462251 2022-05-01 Washington Nebraska 31177 4585 43
2458995 2458995 2022-04-30 Washington Nebraska 31177 4585 43
2455739 2455739 2022-04-29 Washington Nebraska 31177 4585 43
2452483 2452483 2022-04-28 Washington Nebraska 31177 4579 43
2449227 2449227 2022-04-27 Washington Nebraska 31177 4576 43
2445970 2445970 2022-04-26 Washington Nebraska 31177 4572 43
2442715 2442715 2022-04-25 Washington Nebraska 31177 4571 43
2439459 2439459 2022-04-24 Washington Nebraska 31177 4570 43
2436203 2436203 2022-04-23 Washington Nebraska 31177 4570 43
2432947 2432947 2022-04-22 Washington Nebraska 31177 4570 43
2429691 2429691 2022-04-21 Washington Nebraska 31177 4551 43
2426435 2426435 2022-04-20 Washington Nebraska 31177 4551 43
2423179 2423179 2022-04-19 Washington Nebraska 31177 4551 43
2419922 2419922 2022-04-18 Washington Nebraska 31177 4549 43
2416667 2416667 2022-04-17 Washington Nebraska 31177 4547 43
2413411 2413411 2022-04-16 Washington Nebraska 31177 4547 43
2410155 2410155 2022-04-15 Washington Nebraska 31177 4547 43
2406899 2406899 2022-04-14 Washington Nebraska 31177 4547 43
2403643 2403643 2022-04-13 Washington Nebraska 31177 4547 43
2400388 2400388 2022-04-12 Washington Nebraska 31177 4547 36
2397133 2397133 2022-04-11 Washington Nebraska 31177 4543 36
2393878 2393878 2022-04-10 Washington Nebraska 31177 4542 36
2390622 2390622 2022-04-09 Washington Nebraska 31177 4542 36
2387366 2387366 2022-04-08 Washington Nebraska 31177 4542 36
2384111 2384111 2022-04-07 Washington Nebraska 31177 4542 36
2380856 2380856 2022-04-06 Washington Nebraska 31177 4542 36
2377601 2377601 2022-04-05 Washington Nebraska 31177 4546 36
2374348 2374348 2022-04-04 Washington Nebraska 31177 4544 36
2371096 2371096 2022-04-03 Washington Nebraska 31177 4546 36
2367843 2367843 2022-04-02 Washington Nebraska 31177 4546 36
2364590 2364590 2022-04-01 Washington Nebraska 31177 4546 36
2361336 2361336 2022-03-31 Washington Nebraska 31177 4546 36
2358082 2358082 2022-03-30 Washington Nebraska 31177 4547 36
2354829 2354829 2022-03-29 Washington Nebraska 31177 4552 36
2351576 2351576 2022-03-28 Washington Nebraska 31177 4553 36
2348324 2348324 2022-03-27 Washington Nebraska 31177 4544 36
2345071 2345071 2022-03-26 Washington Nebraska 31177 4544 36
2341818 2341818 2022-03-25 Washington Nebraska 31177 4544 36
2338565 2338565 2022-03-24 Washington Nebraska 31177 4544 36
2335311 2335311 2022-03-23 Washington Nebraska 31177 4544 36
2332057 2332057 2022-03-22 Washington Nebraska 31177 4544 36
2328804 2328804 2022-03-21 Washington Nebraska 31177 4544 36
2325552 2325552 2022-03-20 Washington Nebraska 31177 4549 36
2322298 2322298 2022-03-19 Washington Nebraska 31177 4549 36
2319044 2319044 2022-03-18 Washington Nebraska 31177 4546 36
2315791 2315791 2022-03-17 Washington Nebraska 31177 4546 36
2312538 2312538 2022-03-16 Washington Nebraska 31177 4547 36
2309285 2309285 2022-03-15 Washington Nebraska 31177 4543 36
2306033 2306033 2022-03-14 Washington Nebraska 31177 4545 36
2302782 2302782 2022-03-13 Washington Nebraska 31177 4539 36
2299530 2299530 2022-03-12 Washington Nebraska 31177 4539 36
2296278 2296278 2022-03-11 Washington Nebraska 31177 4539 36
2293026 2293026 2022-03-10 Washington Nebraska 31177 4539 36
2289774 2289774 2022-03-09 Washington Nebraska 31177 4538 34
2286522 2286522 2022-03-08 Washington Nebraska 31177 4537 34
2283270 2283270 2022-03-07 Washington Nebraska 31177 4540 34
2280017 2280017 2022-03-06 Washington Nebraska 31177 4541 34
2276764 2276764 2022-03-05 Washington Nebraska 31177 4541 34
2273511 2273511 2022-03-04 Washington Nebraska 31177 4541 34
2270259 2270259 2022-03-03 Washington Nebraska 31177 4539 34
2267006 2267006 2022-03-02 Washington Nebraska 31177 4545 34
2263755 2263755 2022-03-01 Washington Nebraska 31177 4541 34
2260504 2260504 2022-02-28 Washington Nebraska 31177 4539 34
2257253 2257253 2022-02-27 Washington Nebraska 31177 4374 34
2254002 2254002 2022-02-26 Washington Nebraska 31177 4374 34
2250751 2250751 2022-02-25 Washington Nebraska 31177 4374 34
2247500 2247500 2022-02-24 Washington Nebraska 31177 4375 34
2244249 2244249 2022-02-23 Washington Nebraska 31177 4378 34
2240998 2240998 2022-02-22 Washington Nebraska 31177 4376 34
2237747 2237747 2022-02-21 Washington Nebraska 31177 4375 34
2234496 2234496 2022-02-20 Washington Nebraska 31177 4369 34
2231245 2231245 2022-02-19 Washington Nebraska 31177 4369 34
2227994 2227994 2022-02-18 Washington Nebraska 31177 4369 34
2224743 2224743 2022-02-17 Washington Nebraska 31177 4361 34
2221492 2221492 2022-02-16 Washington Nebraska 31177 4355 34
2218241 2218241 2022-02-15 Washington Nebraska 31177 4356 33
2214990 2214990 2022-02-14 Washington Nebraska 31177 4349 33
2211738 2211738 2022-02-13 Washington Nebraska 31177 4344 33
2208485 2208485 2022-02-12 Washington Nebraska 31177 4344 33
2205232 2205232 2022-02-11 Washington Nebraska 31177 4344 33
2201979 2201979 2022-02-10 Washington Nebraska 31177 4337 33
2198725 2198725 2022-02-09 Washington Nebraska 31177 4331 33
2195471 2195471 2022-02-08 Washington Nebraska 31177 4329 33
2192217 2192217 2022-02-07 Washington Nebraska 31177 4321 33
2188964 2188964 2022-02-06 Washington Nebraska 31177 4308 33
2185711 2185711 2022-02-05 Washington Nebraska 31177 4308 33
2182459 2182459 2022-02-04 Washington Nebraska 31177 4308 33
2179207 2179207 2022-02-03 Washington Nebraska 31177 4294 33

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