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

772 rows where county = "Gage", fips = 31067 and state = "Nebraska" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Nebraska · 772 ✖

fips 1

  • 31067 · 772 ✖

county 1

  • Gage · 772 ✖
Link rowid date ▲ county state fips cases deaths
2501282 2501282 2022-05-13 Gage Nebraska 31067 3562 44
2498024 2498024 2022-05-12 Gage Nebraska 31067 3557 44
2494766 2494766 2022-05-11 Gage Nebraska 31067 3557 44
2491508 2491508 2022-05-10 Gage Nebraska 31067 3599 44
2488250 2488250 2022-05-09 Gage Nebraska 31067 3599 44
2484993 2484993 2022-05-08 Gage Nebraska 31067 3601 44
2481735 2481735 2022-05-07 Gage Nebraska 31067 3601 44
2478477 2478477 2022-05-06 Gage Nebraska 31067 3601 44
2475219 2475219 2022-05-05 Gage Nebraska 31067 3601 44
2471962 2471962 2022-05-04 Gage Nebraska 31067 3601 44
2468706 2468706 2022-05-03 Gage Nebraska 31067 3601 44
2465450 2465450 2022-05-02 Gage Nebraska 31067 3601 44
2462195 2462195 2022-05-01 Gage Nebraska 31067 3598 44
2458939 2458939 2022-04-30 Gage Nebraska 31067 3598 44
2455683 2455683 2022-04-29 Gage Nebraska 31067 3598 44
2452427 2452427 2022-04-28 Gage Nebraska 31067 3602 44
2449171 2449171 2022-04-27 Gage Nebraska 31067 3602 44
2445914 2445914 2022-04-26 Gage Nebraska 31067 3602 44
2442659 2442659 2022-04-25 Gage Nebraska 31067 3595 44
2439403 2439403 2022-04-24 Gage Nebraska 31067 3595 44
2436147 2436147 2022-04-23 Gage Nebraska 31067 3595 44
2432891 2432891 2022-04-22 Gage Nebraska 31067 3595 44
2429635 2429635 2022-04-21 Gage Nebraska 31067 3590 44
2426379 2426379 2022-04-20 Gage Nebraska 31067 3590 44
2423123 2423123 2022-04-19 Gage Nebraska 31067 3590 44
2419866 2419866 2022-04-18 Gage Nebraska 31067 3589 44
2416611 2416611 2022-04-17 Gage Nebraska 31067 3589 44
2413355 2413355 2022-04-16 Gage Nebraska 31067 3589 44
2410099 2410099 2022-04-15 Gage Nebraska 31067 3589 44
2406843 2406843 2022-04-14 Gage Nebraska 31067 3589 44
2403587 2403587 2022-04-13 Gage Nebraska 31067 3589 44
2400332 2400332 2022-04-12 Gage Nebraska 31067 3588 40
2397077 2397077 2022-04-11 Gage Nebraska 31067 3588 40
2393822 2393822 2022-04-10 Gage Nebraska 31067 3588 40
2390566 2390566 2022-04-09 Gage Nebraska 31067 3588 40
2387310 2387310 2022-04-08 Gage Nebraska 31067 3588 40
2384055 2384055 2022-04-07 Gage Nebraska 31067 3588 40
2380800 2380800 2022-04-06 Gage Nebraska 31067 3588 40
2377545 2377545 2022-04-05 Gage Nebraska 31067 3588 40
2374292 2374292 2022-04-04 Gage Nebraska 31067 3588 40
2371040 2371040 2022-04-03 Gage Nebraska 31067 3588 40
2367787 2367787 2022-04-02 Gage Nebraska 31067 3588 40
2364534 2364534 2022-04-01 Gage Nebraska 31067 3588 40
2361280 2361280 2022-03-31 Gage Nebraska 31067 3588 40
2358026 2358026 2022-03-30 Gage Nebraska 31067 3587 40
2354773 2354773 2022-03-29 Gage Nebraska 31067 3588 40
2351520 2351520 2022-03-28 Gage Nebraska 31067 3587 40
2348268 2348268 2022-03-27 Gage Nebraska 31067 3580 40
2345015 2345015 2022-03-26 Gage Nebraska 31067 3580 40
2341762 2341762 2022-03-25 Gage Nebraska 31067 3580 40
2338509 2338509 2022-03-24 Gage Nebraska 31067 3579 40
2335255 2335255 2022-03-23 Gage Nebraska 31067 3578 40
2332001 2332001 2022-03-22 Gage Nebraska 31067 3578 40
2328748 2328748 2022-03-21 Gage Nebraska 31067 3579 40
2325496 2325496 2022-03-20 Gage Nebraska 31067 3578 40
2322242 2322242 2022-03-19 Gage Nebraska 31067 3578 40
2318988 2318988 2022-03-18 Gage Nebraska 31067 3576 40
2315735 2315735 2022-03-17 Gage Nebraska 31067 3576 40
2312482 2312482 2022-03-16 Gage Nebraska 31067 3575 40
2309229 2309229 2022-03-15 Gage Nebraska 31067 3575 40
2305977 2305977 2022-03-14 Gage Nebraska 31067 3571 40
2302726 2302726 2022-03-13 Gage Nebraska 31067 3573 40
2299474 2299474 2022-03-12 Gage Nebraska 31067 3573 40
2296222 2296222 2022-03-11 Gage Nebraska 31067 3573 40
2292970 2292970 2022-03-10 Gage Nebraska 31067 3572 40
2289718 2289718 2022-03-09 Gage Nebraska 31067 3570 37
2286466 2286466 2022-03-08 Gage Nebraska 31067 3570 37
2283214 2283214 2022-03-07 Gage Nebraska 31067 3569 37
2279961 2279961 2022-03-06 Gage Nebraska 31067 3566 37
2276708 2276708 2022-03-05 Gage Nebraska 31067 3566 37
2273455 2273455 2022-03-04 Gage Nebraska 31067 3566 37
2270203 2270203 2022-03-03 Gage Nebraska 31067 3564 37
2266950 2266950 2022-03-02 Gage Nebraska 31067 3566 37
2263699 2263699 2022-03-01 Gage Nebraska 31067 3563 37
2260448 2260448 2022-02-28 Gage Nebraska 31067 3562 37
2257197 2257197 2022-02-27 Gage Nebraska 31067 3451 37
2253946 2253946 2022-02-26 Gage Nebraska 31067 3451 37
2250695 2250695 2022-02-25 Gage Nebraska 31067 3451 37
2247444 2247444 2022-02-24 Gage Nebraska 31067 3450 37
2244193 2244193 2022-02-23 Gage Nebraska 31067 3451 37
2240942 2240942 2022-02-22 Gage Nebraska 31067 3450 37
2237691 2237691 2022-02-21 Gage Nebraska 31067 3448 37
2234440 2234440 2022-02-20 Gage Nebraska 31067 3445 37
2231189 2231189 2022-02-19 Gage Nebraska 31067 3445 37
2227938 2227938 2022-02-18 Gage Nebraska 31067 3445 37
2224687 2224687 2022-02-17 Gage Nebraska 31067 3440 37
2221436 2221436 2022-02-16 Gage Nebraska 31067 3441 37
2218185 2218185 2022-02-15 Gage Nebraska 31067 3440 37
2214934 2214934 2022-02-14 Gage Nebraska 31067 3435 37
2211682 2211682 2022-02-13 Gage Nebraska 31067 3431 37
2208429 2208429 2022-02-12 Gage Nebraska 31067 3431 37
2205176 2205176 2022-02-11 Gage Nebraska 31067 3431 37
2201923 2201923 2022-02-10 Gage Nebraska 31067 3427 37
2198669 2198669 2022-02-09 Gage Nebraska 31067 3423 37
2195415 2195415 2022-02-08 Gage Nebraska 31067 3417 37
2192161 2192161 2022-02-07 Gage Nebraska 31067 3409 37
2188908 2188908 2022-02-06 Gage Nebraska 31067 3406 37
2185655 2185655 2022-02-05 Gage Nebraska 31067 3406 37
2182403 2182403 2022-02-04 Gage Nebraska 31067 3406 37
2179151 2179151 2022-02-03 Gage Nebraska 31067 3402 37

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