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

787 rows where county = "Adams", fips = 31001 and state = "Nebraska" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Nebraska · 787 ✖

fips 1

  • 31001 · 787 ✖

county 1

  • Adams · 787 ✖
Link rowid date ▲ county state fips cases deaths
2501249 2501249 2022-05-13 Adams Nebraska 31001 6541 73
2497991 2497991 2022-05-12 Adams Nebraska 31001 6529 73
2494733 2494733 2022-05-11 Adams Nebraska 31001 6529 73
2491475 2491475 2022-05-10 Adams Nebraska 31001 6655 73
2488217 2488217 2022-05-09 Adams Nebraska 31001 6655 73
2484960 2484960 2022-05-08 Adams Nebraska 31001 6660 73
2481702 2481702 2022-05-07 Adams Nebraska 31001 6660 73
2478444 2478444 2022-05-06 Adams Nebraska 31001 6660 73
2475186 2475186 2022-05-05 Adams Nebraska 31001 6660 73
2471929 2471929 2022-05-04 Adams Nebraska 31001 6660 73
2468673 2468673 2022-05-03 Adams Nebraska 31001 6657 73
2465417 2465417 2022-05-02 Adams Nebraska 31001 6657 73
2462162 2462162 2022-05-01 Adams Nebraska 31001 6654 73
2458906 2458906 2022-04-30 Adams Nebraska 31001 6654 73
2455650 2455650 2022-04-29 Adams Nebraska 31001 6654 73
2452394 2452394 2022-04-28 Adams Nebraska 31001 6647 73
2449138 2449138 2022-04-27 Adams Nebraska 31001 6646 73
2445881 2445881 2022-04-26 Adams Nebraska 31001 6650 73
2442626 2442626 2022-04-25 Adams Nebraska 31001 6648 73
2439370 2439370 2022-04-24 Adams Nebraska 31001 6648 73
2436114 2436114 2022-04-23 Adams Nebraska 31001 6648 73
2432858 2432858 2022-04-22 Adams Nebraska 31001 6648 73
2429602 2429602 2022-04-21 Adams Nebraska 31001 6506 73
2426346 2426346 2022-04-20 Adams Nebraska 31001 6506 73
2423090 2423090 2022-04-19 Adams Nebraska 31001 6506 73
2419833 2419833 2022-04-18 Adams Nebraska 31001 6505 73
2416578 2416578 2022-04-17 Adams Nebraska 31001 6500 73
2413322 2413322 2022-04-16 Adams Nebraska 31001 6500 73
2410066 2410066 2022-04-15 Adams Nebraska 31001 6500 73
2406810 2406810 2022-04-14 Adams Nebraska 31001 6500 73
2403554 2403554 2022-04-13 Adams Nebraska 31001 6498 73
2400299 2400299 2022-04-12 Adams Nebraska 31001 6501 70
2397044 2397044 2022-04-11 Adams Nebraska 31001 6501 70
2393789 2393789 2022-04-10 Adams Nebraska 31001 6501 70
2390533 2390533 2022-04-09 Adams Nebraska 31001 6501 70
2387277 2387277 2022-04-08 Adams Nebraska 31001 6501 70
2384022 2384022 2022-04-07 Adams Nebraska 31001 6501 70
2380767 2380767 2022-04-06 Adams Nebraska 31001 6500 70
2377512 2377512 2022-04-05 Adams Nebraska 31001 6500 70
2374259 2374259 2022-04-04 Adams Nebraska 31001 6498 70
2371007 2371007 2022-04-03 Adams Nebraska 31001 6498 70
2367754 2367754 2022-04-02 Adams Nebraska 31001 6498 70
2364501 2364501 2022-04-01 Adams Nebraska 31001 6498 70
2361247 2361247 2022-03-31 Adams Nebraska 31001 6498 70
2357993 2357993 2022-03-30 Adams Nebraska 31001 6501 70
2354740 2354740 2022-03-29 Adams Nebraska 31001 6499 70
2351487 2351487 2022-03-28 Adams Nebraska 31001 6499 70
2348235 2348235 2022-03-27 Adams Nebraska 31001 6465 70
2344982 2344982 2022-03-26 Adams Nebraska 31001 6465 70
2341729 2341729 2022-03-25 Adams Nebraska 31001 6465 70
2338476 2338476 2022-03-24 Adams Nebraska 31001 6465 70
2335222 2335222 2022-03-23 Adams Nebraska 31001 6465 70
2331968 2331968 2022-03-22 Adams Nebraska 31001 6465 70
2328715 2328715 2022-03-21 Adams Nebraska 31001 6463 70
2325463 2325463 2022-03-20 Adams Nebraska 31001 6461 70
2322209 2322209 2022-03-19 Adams Nebraska 31001 6461 70
2318955 2318955 2022-03-18 Adams Nebraska 31001 6457 70
2315702 2315702 2022-03-17 Adams Nebraska 31001 6457 70
2312449 2312449 2022-03-16 Adams Nebraska 31001 6454 70
2309196 2309196 2022-03-15 Adams Nebraska 31001 6451 70
2305944 2305944 2022-03-14 Adams Nebraska 31001 6451 70
2302693 2302693 2022-03-13 Adams Nebraska 31001 6448 70
2299441 2299441 2022-03-12 Adams Nebraska 31001 6448 70
2296189 2296189 2022-03-11 Adams Nebraska 31001 6448 70
2292937 2292937 2022-03-10 Adams Nebraska 31001 6448 70
2289685 2289685 2022-03-09 Adams Nebraska 31001 6440 70
2286433 2286433 2022-03-08 Adams Nebraska 31001 6438 70
2283181 2283181 2022-03-07 Adams Nebraska 31001 6422 70
2279928 2279928 2022-03-06 Adams Nebraska 31001 6408 70
2276675 2276675 2022-03-05 Adams Nebraska 31001 6408 70
2273422 2273422 2022-03-04 Adams Nebraska 31001 6408 70
2270170 2270170 2022-03-03 Adams Nebraska 31001 6389 70
2266917 2266917 2022-03-02 Adams Nebraska 31001 6392 70
2263666 2263666 2022-03-01 Adams Nebraska 31001 6382 70
2260415 2260415 2022-02-28 Adams Nebraska 31001 6382 70
2257164 2257164 2022-02-27 Adams Nebraska 31001 6229 70
2253913 2253913 2022-02-26 Adams Nebraska 31001 6229 70
2250662 2250662 2022-02-25 Adams Nebraska 31001 6229 70
2247411 2247411 2022-02-24 Adams Nebraska 31001 6223 70
2244160 2244160 2022-02-23 Adams Nebraska 31001 6216 70
2240909 2240909 2022-02-22 Adams Nebraska 31001 6211 70
2237658 2237658 2022-02-21 Adams Nebraska 31001 6205 70
2234407 2234407 2022-02-20 Adams Nebraska 31001 6201 70
2231156 2231156 2022-02-19 Adams Nebraska 31001 6201 70
2227905 2227905 2022-02-18 Adams Nebraska 31001 6201 70
2224654 2224654 2022-02-17 Adams Nebraska 31001 6196 70
2221403 2221403 2022-02-16 Adams Nebraska 31001 6197 70
2218152 2218152 2022-02-15 Adams Nebraska 31001 6189 69
2214901 2214901 2022-02-14 Adams Nebraska 31001 6180 69
2211649 2211649 2022-02-13 Adams Nebraska 31001 6177 69
2208396 2208396 2022-02-12 Adams Nebraska 31001 6177 69
2205143 2205143 2022-02-11 Adams Nebraska 31001 6177 69
2201890 2201890 2022-02-10 Adams Nebraska 31001 6170 69
2198636 2198636 2022-02-09 Adams Nebraska 31001 6147 69
2195382 2195382 2022-02-08 Adams Nebraska 31001 6133 69
2192128 2192128 2022-02-07 Adams Nebraska 31001 6120 69
2188875 2188875 2022-02-06 Adams Nebraska 31001 6097 69
2185622 2185622 2022-02-05 Adams Nebraska 31001 6097 69
2182370 2182370 2022-02-04 Adams Nebraska 31001 6097 69
2179118 2179118 2022-02-03 Adams Nebraska 31001 6083 69

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