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

777 rows where county = "Gosper" 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 · 777 ✖

fips 1

county 1

  • Gosper · 777 ✖
Link rowid date ▲ county state fips cases deaths
2501285 2501285 2022-05-13 Gosper Nebraska 31073 381 7
2498027 2498027 2022-05-12 Gosper Nebraska 31073 381 7
2494769 2494769 2022-05-11 Gosper Nebraska 31073 381 7
2491511 2491511 2022-05-10 Gosper Nebraska 31073 379 7
2488253 2488253 2022-05-09 Gosper Nebraska 31073 379 7
2484996 2484996 2022-05-08 Gosper Nebraska 31073 377 7
2481738 2481738 2022-05-07 Gosper Nebraska 31073 377 7
2478480 2478480 2022-05-06 Gosper Nebraska 31073 377 7
2475222 2475222 2022-05-05 Gosper Nebraska 31073 377 7
2471965 2471965 2022-05-04 Gosper Nebraska 31073 380 7
2468709 2468709 2022-05-03 Gosper Nebraska 31073 380 7
2465453 2465453 2022-05-02 Gosper Nebraska 31073 381 7
2462198 2462198 2022-05-01 Gosper Nebraska 31073 381 7
2458942 2458942 2022-04-30 Gosper Nebraska 31073 381 7
2455686 2455686 2022-04-29 Gosper Nebraska 31073 381 7
2452430 2452430 2022-04-28 Gosper Nebraska 31073 379 7
2449174 2449174 2022-04-27 Gosper Nebraska 31073 379 7
2445917 2445917 2022-04-26 Gosper Nebraska 31073 379 7
2442662 2442662 2022-04-25 Gosper Nebraska 31073 378 7
2439406 2439406 2022-04-24 Gosper Nebraska 31073 378 7
2436150 2436150 2022-04-23 Gosper Nebraska 31073 378 7
2432894 2432894 2022-04-22 Gosper Nebraska 31073 378 7
2429638 2429638 2022-04-21 Gosper Nebraska 31073 373 7
2426382 2426382 2022-04-20 Gosper Nebraska 31073 373 7
2423126 2423126 2022-04-19 Gosper Nebraska 31073 373 7
2419869 2419869 2022-04-18 Gosper Nebraska 31073 373 7
2416614 2416614 2022-04-17 Gosper Nebraska 31073 373 7
2413358 2413358 2022-04-16 Gosper Nebraska 31073 373 7
2410102 2410102 2022-04-15 Gosper Nebraska 31073 373 7
2406846 2406846 2022-04-14 Gosper Nebraska 31073 373 7
2403590 2403590 2022-04-13 Gosper Nebraska 31073 373 7
2400335 2400335 2022-04-12 Gosper Nebraska 31073 372 7
2397080 2397080 2022-04-11 Gosper Nebraska 31073 372 7
2393825 2393825 2022-04-10 Gosper Nebraska 31073 372 7
2390569 2390569 2022-04-09 Gosper Nebraska 31073 372 7
2387313 2387313 2022-04-08 Gosper Nebraska 31073 372 7
2384058 2384058 2022-04-07 Gosper Nebraska 31073 372 7
2380803 2380803 2022-04-06 Gosper Nebraska 31073 372 7
2377548 2377548 2022-04-05 Gosper Nebraska 31073 372 7
2374295 2374295 2022-04-04 Gosper Nebraska 31073 372 7
2371043 2371043 2022-04-03 Gosper Nebraska 31073 372 7
2367790 2367790 2022-04-02 Gosper Nebraska 31073 372 7
2364537 2364537 2022-04-01 Gosper Nebraska 31073 372 7
2361283 2361283 2022-03-31 Gosper Nebraska 31073 372 7
2358029 2358029 2022-03-30 Gosper Nebraska 31073 372 7
2354776 2354776 2022-03-29 Gosper Nebraska 31073 372 7
2351523 2351523 2022-03-28 Gosper Nebraska 31073 372 7
2348271 2348271 2022-03-27 Gosper Nebraska 31073 372 7
2345018 2345018 2022-03-26 Gosper Nebraska 31073 372 7
2341765 2341765 2022-03-25 Gosper Nebraska 31073 372 7
2338512 2338512 2022-03-24 Gosper Nebraska 31073 372 7
2335258 2335258 2022-03-23 Gosper Nebraska 31073 371 7
2332004 2332004 2022-03-22 Gosper Nebraska 31073 371 7
2328751 2328751 2022-03-21 Gosper Nebraska 31073 371 7
2325499 2325499 2022-03-20 Gosper Nebraska 31073 371 7
2322245 2322245 2022-03-19 Gosper Nebraska 31073 371 7
2318991 2318991 2022-03-18 Gosper Nebraska 31073 371 7
2315738 2315738 2022-03-17 Gosper Nebraska 31073 371 7
2312485 2312485 2022-03-16 Gosper Nebraska 31073 371 7
2309232 2309232 2022-03-15 Gosper Nebraska 31073 371 7
2305980 2305980 2022-03-14 Gosper Nebraska 31073 371 7
2302729 2302729 2022-03-13 Gosper Nebraska 31073 371 7
2299477 2299477 2022-03-12 Gosper Nebraska 31073 371 7
2296225 2296225 2022-03-11 Gosper Nebraska 31073 371 7
2292973 2292973 2022-03-10 Gosper Nebraska 31073 371 7
2289721 2289721 2022-03-09 Gosper Nebraska 31073 370 7
2286469 2286469 2022-03-08 Gosper Nebraska 31073 370 7
2283217 2283217 2022-03-07 Gosper Nebraska 31073 369 7
2279964 2279964 2022-03-06 Gosper Nebraska 31073 369 7
2276711 2276711 2022-03-05 Gosper Nebraska 31073 369 7
2273458 2273458 2022-03-04 Gosper Nebraska 31073 369 7
2270206 2270206 2022-03-03 Gosper Nebraska 31073 368 7
2266953 2266953 2022-03-02 Gosper Nebraska 31073 368 7
2263702 2263702 2022-03-01 Gosper Nebraska 31073 368 7
2260451 2260451 2022-02-28 Gosper Nebraska 31073 367 7
2257200 2257200 2022-02-27 Gosper Nebraska 31073 353 7
2253949 2253949 2022-02-26 Gosper Nebraska 31073 353 7
2250698 2250698 2022-02-25 Gosper Nebraska 31073 353 7
2247447 2247447 2022-02-24 Gosper Nebraska 31073 353 7
2244196 2244196 2022-02-23 Gosper Nebraska 31073 353 7
2240945 2240945 2022-02-22 Gosper Nebraska 31073 352 7
2237694 2237694 2022-02-21 Gosper Nebraska 31073 352 7
2234443 2234443 2022-02-20 Gosper Nebraska 31073 352 7
2231192 2231192 2022-02-19 Gosper Nebraska 31073 352 7
2227941 2227941 2022-02-18 Gosper Nebraska 31073 352 7
2224690 2224690 2022-02-17 Gosper Nebraska 31073 352 7
2221439 2221439 2022-02-16 Gosper Nebraska 31073 351 7
2218188 2218188 2022-02-15 Gosper Nebraska 31073 351 7
2214937 2214937 2022-02-14 Gosper Nebraska 31073 351 7
2211685 2211685 2022-02-13 Gosper Nebraska 31073 352 7
2208432 2208432 2022-02-12 Gosper Nebraska 31073 352 7
2205179 2205179 2022-02-11 Gosper Nebraska 31073 352 7
2201926 2201926 2022-02-10 Gosper Nebraska 31073 352 7
2198672 2198672 2022-02-09 Gosper Nebraska 31073 352 7
2195418 2195418 2022-02-08 Gosper Nebraska 31073 352 7
2192164 2192164 2022-02-07 Gosper Nebraska 31073 349 7
2188911 2188911 2022-02-06 Gosper Nebraska 31073 349 7
2185658 2185658 2022-02-05 Gosper Nebraska 31073 349 7
2182406 2182406 2022-02-04 Gosper Nebraska 31073 349 7
2179154 2179154 2022-02-03 Gosper Nebraska 31073 348 7

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