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

762 rows where county = "Dakota" 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 · 762 ✖

fips 1

county 1

  • Dakota · 762 ✖
Link rowid date ▲ county state fips cases deaths
2501270 2501270 2022-05-13 Dakota Nebraska 31043 6849 82
2498012 2498012 2022-05-12 Dakota Nebraska 31043 6844 82
2494754 2494754 2022-05-11 Dakota Nebraska 31043 6844 82
2491496 2491496 2022-05-10 Dakota Nebraska 31043 6849 82
2488238 2488238 2022-05-09 Dakota Nebraska 31043 6849 82
2484981 2484981 2022-05-08 Dakota Nebraska 31043 6847 82
2481723 2481723 2022-05-07 Dakota Nebraska 31043 6847 82
2478465 2478465 2022-05-06 Dakota Nebraska 31043 6847 82
2475207 2475207 2022-05-05 Dakota Nebraska 31043 6847 82
2471950 2471950 2022-05-04 Dakota Nebraska 31043 6847 82
2468694 2468694 2022-05-03 Dakota Nebraska 31043 6846 82
2465438 2465438 2022-05-02 Dakota Nebraska 31043 6848 82
2462183 2462183 2022-05-01 Dakota Nebraska 31043 6848 82
2458927 2458927 2022-04-30 Dakota Nebraska 31043 6848 82
2455671 2455671 2022-04-29 Dakota Nebraska 31043 6848 82
2452415 2452415 2022-04-28 Dakota Nebraska 31043 6850 82
2449159 2449159 2022-04-27 Dakota Nebraska 31043 6850 82
2445902 2445902 2022-04-26 Dakota Nebraska 31043 6850 82
2442647 2442647 2022-04-25 Dakota Nebraska 31043 6846 82
2439391 2439391 2022-04-24 Dakota Nebraska 31043 6846 82
2436135 2436135 2022-04-23 Dakota Nebraska 31043 6846 82
2432879 2432879 2022-04-22 Dakota Nebraska 31043 6846 82
2429623 2429623 2022-04-21 Dakota Nebraska 31043 6900 82
2426367 2426367 2022-04-20 Dakota Nebraska 31043 6900 82
2423111 2423111 2022-04-19 Dakota Nebraska 31043 6900 82
2419854 2419854 2022-04-18 Dakota Nebraska 31043 6899 82
2416599 2416599 2022-04-17 Dakota Nebraska 31043 6899 82
2413343 2413343 2022-04-16 Dakota Nebraska 31043 6899 82
2410087 2410087 2022-04-15 Dakota Nebraska 31043 6899 82
2406831 2406831 2022-04-14 Dakota Nebraska 31043 6899 82
2403575 2403575 2022-04-13 Dakota Nebraska 31043 6899 82
2400320 2400320 2022-04-12 Dakota Nebraska 31043 6900 82
2397065 2397065 2022-04-11 Dakota Nebraska 31043 6900 82
2393810 2393810 2022-04-10 Dakota Nebraska 31043 6900 82
2390554 2390554 2022-04-09 Dakota Nebraska 31043 6900 82
2387298 2387298 2022-04-08 Dakota Nebraska 31043 6900 82
2384043 2384043 2022-04-07 Dakota Nebraska 31043 6900 82
2380788 2380788 2022-04-06 Dakota Nebraska 31043 6900 82
2377533 2377533 2022-04-05 Dakota Nebraska 31043 6900 82
2374280 2374280 2022-04-04 Dakota Nebraska 31043 6900 82
2371028 2371028 2022-04-03 Dakota Nebraska 31043 6900 82
2367775 2367775 2022-04-02 Dakota Nebraska 31043 6900 82
2364522 2364522 2022-04-01 Dakota Nebraska 31043 6900 82
2361268 2361268 2022-03-31 Dakota Nebraska 31043 6900 82
2358014 2358014 2022-03-30 Dakota Nebraska 31043 6904 82
2354761 2354761 2022-03-29 Dakota Nebraska 31043 6904 82
2351508 2351508 2022-03-28 Dakota Nebraska 31043 6904 82
2348256 2348256 2022-03-27 Dakota Nebraska 31043 6904 82
2345003 2345003 2022-03-26 Dakota Nebraska 31043 6904 82
2341750 2341750 2022-03-25 Dakota Nebraska 31043 6904 82
2338497 2338497 2022-03-24 Dakota Nebraska 31043 6904 82
2335243 2335243 2022-03-23 Dakota Nebraska 31043 6904 82
2331989 2331989 2022-03-22 Dakota Nebraska 31043 6904 82
2328736 2328736 2022-03-21 Dakota Nebraska 31043 6907 82
2325484 2325484 2022-03-20 Dakota Nebraska 31043 6905 82
2322230 2322230 2022-03-19 Dakota Nebraska 31043 6905 82
2318976 2318976 2022-03-18 Dakota Nebraska 31043 6903 82
2315723 2315723 2022-03-17 Dakota Nebraska 31043 6903 82
2312470 2312470 2022-03-16 Dakota Nebraska 31043 6905 82
2309217 2309217 2022-03-15 Dakota Nebraska 31043 6902 82
2305965 2305965 2022-03-14 Dakota Nebraska 31043 6909 82
2302714 2302714 2022-03-13 Dakota Nebraska 31043 6905 82
2299462 2299462 2022-03-12 Dakota Nebraska 31043 6905 82
2296210 2296210 2022-03-11 Dakota Nebraska 31043 6905 82
2292958 2292958 2022-03-10 Dakota Nebraska 31043 6906 82
2289706 2289706 2022-03-09 Dakota Nebraska 31043 6908 82
2286454 2286454 2022-03-08 Dakota Nebraska 31043 6905 82
2283202 2283202 2022-03-07 Dakota Nebraska 31043 6901 82
2279949 2279949 2022-03-06 Dakota Nebraska 31043 6904 82
2276696 2276696 2022-03-05 Dakota Nebraska 31043 6904 82
2273443 2273443 2022-03-04 Dakota Nebraska 31043 6904 82
2270191 2270191 2022-03-03 Dakota Nebraska 31043 6899 82
2266938 2266938 2022-03-02 Dakota Nebraska 31043 6900 82
2263687 2263687 2022-03-01 Dakota Nebraska 31043 6898 82
2260436 2260436 2022-02-28 Dakota Nebraska 31043 6898 82
2257185 2257185 2022-02-27 Dakota Nebraska 31043 6546 82
2253934 2253934 2022-02-26 Dakota Nebraska 31043 6546 82
2250683 2250683 2022-02-25 Dakota Nebraska 31043 6546 82
2247432 2247432 2022-02-24 Dakota Nebraska 31043 6543 82
2244181 2244181 2022-02-23 Dakota Nebraska 31043 6537 82
2240930 2240930 2022-02-22 Dakota Nebraska 31043 6519 82
2237679 2237679 2022-02-21 Dakota Nebraska 31043 6520 82
2234428 2234428 2022-02-20 Dakota Nebraska 31043 6507 82
2231177 2231177 2022-02-19 Dakota Nebraska 31043 6507 82
2227926 2227926 2022-02-18 Dakota Nebraska 31043 6507 82
2224675 2224675 2022-02-17 Dakota Nebraska 31043 6492 82
2221424 2221424 2022-02-16 Dakota Nebraska 31043 6486 82
2218173 2218173 2022-02-15 Dakota Nebraska 31043 6480 82
2214922 2214922 2022-02-14 Dakota Nebraska 31043 6476 82
2211670 2211670 2022-02-13 Dakota Nebraska 31043 6472 82
2208417 2208417 2022-02-12 Dakota Nebraska 31043 6472 82
2205164 2205164 2022-02-11 Dakota Nebraska 31043 6472 82
2201911 2201911 2022-02-10 Dakota Nebraska 31043 6466 82
2198657 2198657 2022-02-09 Dakota Nebraska 31043 6460 82
2195403 2195403 2022-02-08 Dakota Nebraska 31043 6458 82
2192149 2192149 2022-02-07 Dakota Nebraska 31043 6426 82
2188896 2188896 2022-02-06 Dakota Nebraska 31043 6421 82
2185643 2185643 2022-02-05 Dakota Nebraska 31043 6421 82
2182391 2182391 2022-02-04 Dakota Nebraska 31043 6421 82
2179139 2179139 2022-02-03 Dakota Nebraska 31043 6408 82

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