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

755 rows where county = "Nelson" and fips = 38063 sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

fips 1

  • 38063 · 755 ✖

county 1

  • Nelson · 755 ✖
Link rowid date ▲ county state fips cases deaths
2501617 2501617 2022-05-13 Nelson North Dakota 38063 768 18
2498359 2498359 2022-05-12 Nelson North Dakota 38063 765 18
2495101 2495101 2022-05-11 Nelson North Dakota 38063 765 18
2491843 2491843 2022-05-10 Nelson North Dakota 38063 765 18
2488585 2488585 2022-05-09 Nelson North Dakota 38063 765 18
2485328 2485328 2022-05-08 Nelson North Dakota 38063 765 18
2482070 2482070 2022-05-07 Nelson North Dakota 38063 765 18
2478812 2478812 2022-05-06 Nelson North Dakota 38063 765 18
2475554 2475554 2022-05-05 Nelson North Dakota 38063 763 18
2472297 2472297 2022-05-04 Nelson North Dakota 38063 763 18
2469041 2469041 2022-05-03 Nelson North Dakota 38063 763 18
2465785 2465785 2022-05-02 Nelson North Dakota 38063 763 18
2462530 2462530 2022-05-01 Nelson North Dakota 38063 763 18
2459274 2459274 2022-04-30 Nelson North Dakota 38063 763 18
2456018 2456018 2022-04-29 Nelson North Dakota 38063 763 18
2452762 2452762 2022-04-28 Nelson North Dakota 38063 762 18
2449506 2449506 2022-04-27 Nelson North Dakota 38063 762 18
2446249 2446249 2022-04-26 Nelson North Dakota 38063 762 18
2442994 2442994 2022-04-25 Nelson North Dakota 38063 762 18
2439738 2439738 2022-04-24 Nelson North Dakota 38063 762 18
2436482 2436482 2022-04-23 Nelson North Dakota 38063 762 18
2433226 2433226 2022-04-22 Nelson North Dakota 38063 762 18
2429970 2429970 2022-04-21 Nelson North Dakota 38063 761 18
2426714 2426714 2022-04-20 Nelson North Dakota 38063 761 18
2423458 2423458 2022-04-19 Nelson North Dakota 38063 761 18
2420201 2420201 2022-04-18 Nelson North Dakota 38063 761 18
2416946 2416946 2022-04-17 Nelson North Dakota 38063 761 18
2413690 2413690 2022-04-16 Nelson North Dakota 38063 761 18
2410434 2410434 2022-04-15 Nelson North Dakota 38063 761 18
2407178 2407178 2022-04-14 Nelson North Dakota 38063 761 18
2403922 2403922 2022-04-13 Nelson North Dakota 38063 761 18
2400667 2400667 2022-04-12 Nelson North Dakota 38063 761 18
2397412 2397412 2022-04-11 Nelson North Dakota 38063 761 18
2394157 2394157 2022-04-10 Nelson North Dakota 38063 761 18
2390901 2390901 2022-04-09 Nelson North Dakota 38063 761 18
2387645 2387645 2022-04-08 Nelson North Dakota 38063 761 18
2384390 2384390 2022-04-07 Nelson North Dakota 38063 761 18
2381135 2381135 2022-04-06 Nelson North Dakota 38063 761 18
2377880 2377880 2022-04-05 Nelson North Dakota 38063 761 18
2374627 2374627 2022-04-04 Nelson North Dakota 38063 761 18
2371375 2371375 2022-04-03 Nelson North Dakota 38063 761 18
2368122 2368122 2022-04-02 Nelson North Dakota 38063 761 18
2364869 2364869 2022-04-01 Nelson North Dakota 38063 761 18
2361615 2361615 2022-03-31 Nelson North Dakota 38063 761 18
2358361 2358361 2022-03-30 Nelson North Dakota 38063 761 18
2355107 2355107 2022-03-29 Nelson North Dakota 38063 761 18
2351854 2351854 2022-03-28 Nelson North Dakota 38063 761 18
2348602 2348602 2022-03-27 Nelson North Dakota 38063 761 18
2345349 2345349 2022-03-26 Nelson North Dakota 38063 761 18
2342096 2342096 2022-03-25 Nelson North Dakota 38063 761 18
2338843 2338843 2022-03-24 Nelson North Dakota 38063 760 18
2335589 2335589 2022-03-23 Nelson North Dakota 38063 760 18
2332335 2332335 2022-03-22 Nelson North Dakota 38063 760 18
2329082 2329082 2022-03-21 Nelson North Dakota 38063 760 18
2325830 2325830 2022-03-20 Nelson North Dakota 38063 760 18
2322577 2322577 2022-03-19 Nelson North Dakota 38063 760 18
2319323 2319323 2022-03-18 Nelson North Dakota 38063 760 18
2316069 2316069 2022-03-17 Nelson North Dakota 38063 757 18
2312816 2312816 2022-03-16 Nelson North Dakota 38063 757 18
2309563 2309563 2022-03-15 Nelson North Dakota 38063 757 18
2306310 2306310 2022-03-14 Nelson North Dakota 38063 757 18
2303059 2303059 2022-03-13 Nelson North Dakota 38063 757 18
2299807 2299807 2022-03-12 Nelson North Dakota 38063 757 18
2296555 2296555 2022-03-11 Nelson North Dakota 38063 758 18
2293303 2293303 2022-03-10 Nelson North Dakota 38063 758 18
2290051 2290051 2022-03-09 Nelson North Dakota 38063 758 18
2286799 2286799 2022-03-08 Nelson North Dakota 38063 758 18
2283547 2283547 2022-03-07 Nelson North Dakota 38063 757 18
2280295 2280295 2022-03-06 Nelson North Dakota 38063 757 18
2277042 2277042 2022-03-05 Nelson North Dakota 38063 756 18
2273789 2273789 2022-03-04 Nelson North Dakota 38063 756 18
2270536 2270536 2022-03-03 Nelson North Dakota 38063 755 18
2267284 2267284 2022-03-02 Nelson North Dakota 38063 755 18
2264032 2264032 2022-03-01 Nelson North Dakota 38063 755 18
2260781 2260781 2022-02-28 Nelson North Dakota 38063 755 18
2257530 2257530 2022-02-27 Nelson North Dakota 38063 755 18
2254279 2254279 2022-02-26 Nelson North Dakota 38063 755 18
2251028 2251028 2022-02-25 Nelson North Dakota 38063 755 18
2247777 2247777 2022-02-24 Nelson North Dakota 38063 754 18
2244526 2244526 2022-02-23 Nelson North Dakota 38063 754 18
2241275 2241275 2022-02-22 Nelson North Dakota 38063 755 18
2238024 2238024 2022-02-21 Nelson North Dakota 38063 752 18
2234773 2234773 2022-02-20 Nelson North Dakota 38063 752 18
2231522 2231522 2022-02-19 Nelson North Dakota 38063 752 18
2228271 2228271 2022-02-18 Nelson North Dakota 38063 752 18
2225020 2225020 2022-02-17 Nelson North Dakota 38063 751 18
2221769 2221769 2022-02-16 Nelson North Dakota 38063 751 18
2218518 2218518 2022-02-15 Nelson North Dakota 38063 748 18
2215267 2215267 2022-02-14 Nelson North Dakota 38063 747 18
2212016 2212016 2022-02-13 Nelson North Dakota 38063 745 18
2208763 2208763 2022-02-12 Nelson North Dakota 38063 745 18
2205510 2205510 2022-02-11 Nelson North Dakota 38063 743 18
2202257 2202257 2022-02-10 Nelson North Dakota 38063 742 18
2199003 2199003 2022-02-09 Nelson North Dakota 38063 741 18
2195749 2195749 2022-02-08 Nelson North Dakota 38063 737 18
2192495 2192495 2022-02-07 Nelson North Dakota 38063 736 17
2189241 2189241 2022-02-06 Nelson North Dakota 38063 732 17
2185988 2185988 2022-02-05 Nelson North Dakota 38063 732 17
2182736 2182736 2022-02-04 Nelson North Dakota 38063 729 17
2179484 2179484 2022-02-03 Nelson North Dakota 38063 723 17

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