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

1,446 rows where county = "Deuel" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 2

fips 2

county 1

  • Deuel · 1,446 ✖
Link rowid date ▲ county state fips cases deaths
2501273 2501273 2022-05-13 Deuel Nebraska 31049 317 2
2502063 2502063 2022-05-13 Deuel South Dakota 46039 1043 12
2498015 2498015 2022-05-12 Deuel Nebraska 31049 316 2
2498805 2498805 2022-05-12 Deuel South Dakota 46039 1043 12
2494757 2494757 2022-05-11 Deuel Nebraska 31049 316 2
2495547 2495547 2022-05-11 Deuel South Dakota 46039 1043 12
2491499 2491499 2022-05-10 Deuel Nebraska 31049 324 2
2492289 2492289 2022-05-10 Deuel South Dakota 46039 1042 12
2488241 2488241 2022-05-09 Deuel Nebraska 31049 324 2
2489031 2489031 2022-05-09 Deuel South Dakota 46039 1042 12
2484984 2484984 2022-05-08 Deuel Nebraska 31049 323 2
2485774 2485774 2022-05-08 Deuel South Dakota 46039 1042 12
2481726 2481726 2022-05-07 Deuel Nebraska 31049 323 2
2482516 2482516 2022-05-07 Deuel South Dakota 46039 1042 12
2478468 2478468 2022-05-06 Deuel Nebraska 31049 323 2
2479258 2479258 2022-05-06 Deuel South Dakota 46039 1042 12
2475210 2475210 2022-05-05 Deuel Nebraska 31049 323 2
2476000 2476000 2022-05-05 Deuel South Dakota 46039 1042 12
2471953 2471953 2022-05-04 Deuel Nebraska 31049 323 2
2472743 2472743 2022-05-04 Deuel South Dakota 46039 1042 12
2468697 2468697 2022-05-03 Deuel Nebraska 31049 322 2
2469487 2469487 2022-05-03 Deuel South Dakota 46039 1038 12
2465441 2465441 2022-05-02 Deuel Nebraska 31049 322 2
2466231 2466231 2022-05-02 Deuel South Dakota 46039 1038 12
2462186 2462186 2022-05-01 Deuel Nebraska 31049 322 2
2462976 2462976 2022-05-01 Deuel South Dakota 46039 1038 12
2458930 2458930 2022-04-30 Deuel Nebraska 31049 322 2
2459720 2459720 2022-04-30 Deuel South Dakota 46039 1038 12
2455674 2455674 2022-04-29 Deuel Nebraska 31049 322 2
2456464 2456464 2022-04-29 Deuel South Dakota 46039 1038 12
2452418 2452418 2022-04-28 Deuel Nebraska 31049 322 2
2453208 2453208 2022-04-28 Deuel South Dakota 46039 1038 12
2449162 2449162 2022-04-27 Deuel Nebraska 31049 322 2
2449952 2449952 2022-04-27 Deuel South Dakota 46039 1038 12
2445905 2445905 2022-04-26 Deuel Nebraska 31049 322 2
2446695 2446695 2022-04-26 Deuel South Dakota 46039 1037 12
2442650 2442650 2022-04-25 Deuel Nebraska 31049 322 2
2443440 2443440 2022-04-25 Deuel South Dakota 46039 1037 12
2439394 2439394 2022-04-24 Deuel Nebraska 31049 322 2
2440184 2440184 2022-04-24 Deuel South Dakota 46039 1037 12
2436138 2436138 2022-04-23 Deuel Nebraska 31049 322 2
2436928 2436928 2022-04-23 Deuel South Dakota 46039 1037 12
2432882 2432882 2022-04-22 Deuel Nebraska 31049 322 2
2433672 2433672 2022-04-22 Deuel South Dakota 46039 1037 12
2429626 2429626 2022-04-21 Deuel Nebraska 31049 322 2
2430416 2430416 2022-04-21 Deuel South Dakota 46039 1037 12
2426370 2426370 2022-04-20 Deuel Nebraska 31049 322 2
2427160 2427160 2022-04-20 Deuel South Dakota 46039 1037 12
2423114 2423114 2022-04-19 Deuel Nebraska 31049 322 2
2423904 2423904 2022-04-19 Deuel South Dakota 46039 1036 12
2419857 2419857 2022-04-18 Deuel Nebraska 31049 323 2
2420648 2420648 2022-04-18 Deuel South Dakota 46039 1036 12
2416602 2416602 2022-04-17 Deuel Nebraska 31049 323 2
2417392 2417392 2022-04-17 Deuel South Dakota 46039 1036 12
2413346 2413346 2022-04-16 Deuel Nebraska 31049 323 2
2414136 2414136 2022-04-16 Deuel South Dakota 46039 1036 12
2410090 2410090 2022-04-15 Deuel Nebraska 31049 323 2
2410880 2410880 2022-04-15 Deuel South Dakota 46039 1036 12
2406834 2406834 2022-04-14 Deuel Nebraska 31049 323 2
2407624 2407624 2022-04-14 Deuel South Dakota 46039 1036 12
2403578 2403578 2022-04-13 Deuel Nebraska 31049 323 2
2404368 2404368 2022-04-13 Deuel South Dakota 46039 1036 12
2400323 2400323 2022-04-12 Deuel Nebraska 31049 323 2
2401113 2401113 2022-04-12 Deuel South Dakota 46039 1035 12
2397068 2397068 2022-04-11 Deuel Nebraska 31049 323 2
2397858 2397858 2022-04-11 Deuel South Dakota 46039 1035 12
2393813 2393813 2022-04-10 Deuel Nebraska 31049 323 2
2394603 2394603 2022-04-10 Deuel South Dakota 46039 1035 12
2390557 2390557 2022-04-09 Deuel Nebraska 31049 323 2
2391347 2391347 2022-04-09 Deuel South Dakota 46039 1035 12
2387301 2387301 2022-04-08 Deuel Nebraska 31049 323 2
2388091 2388091 2022-04-08 Deuel South Dakota 46039 1035 12
2384046 2384046 2022-04-07 Deuel Nebraska 31049 323 2
2384836 2384836 2022-04-07 Deuel South Dakota 46039 1035 12
2380791 2380791 2022-04-06 Deuel Nebraska 31049 323 2
2381581 2381581 2022-04-06 Deuel South Dakota 46039 1035 12
2377536 2377536 2022-04-05 Deuel Nebraska 31049 323 2
2378326 2378326 2022-04-05 Deuel South Dakota 46039 1035 12
2374283 2374283 2022-04-04 Deuel Nebraska 31049 323 2
2375072 2375072 2022-04-04 Deuel South Dakota 46039 1035 12
2371031 2371031 2022-04-03 Deuel Nebraska 31049 323 2
2371820 2371820 2022-04-03 Deuel South Dakota 46039 1035 12
2367778 2367778 2022-04-02 Deuel Nebraska 31049 323 2
2368567 2368567 2022-04-02 Deuel South Dakota 46039 1035 12
2364525 2364525 2022-04-01 Deuel Nebraska 31049 323 2
2365314 2365314 2022-04-01 Deuel South Dakota 46039 1035 12
2361271 2361271 2022-03-31 Deuel Nebraska 31049 323 2
2362061 2362061 2022-03-31 Deuel South Dakota 46039 1035 12
2358017 2358017 2022-03-30 Deuel Nebraska 31049 323 2
2358807 2358807 2022-03-30 Deuel South Dakota 46039 1035 12
2354764 2354764 2022-03-29 Deuel Nebraska 31049 322 2
2355553 2355553 2022-03-29 Deuel South Dakota 46039 1035 12
2351511 2351511 2022-03-28 Deuel Nebraska 31049 324 2
2352300 2352300 2022-03-28 Deuel South Dakota 46039 1035 12
2348259 2348259 2022-03-27 Deuel Nebraska 31049 324 2
2349048 2349048 2022-03-27 Deuel South Dakota 46039 1035 12
2345006 2345006 2022-03-26 Deuel Nebraska 31049 324 2
2345795 2345795 2022-03-26 Deuel South Dakota 46039 1035 12
2341753 2341753 2022-03-25 Deuel Nebraska 31049 324 2
2342542 2342542 2022-03-25 Deuel South Dakota 46039 1035 12

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