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 fips = 38003 and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • North Dakota · 777 ✖

fips 1

  • 38003 · 777 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501587 2501587 2022-05-13 Barnes North Dakota 38003 3024 47
2498329 2498329 2022-05-12 Barnes North Dakota 38003 3012 47
2495071 2495071 2022-05-11 Barnes North Dakota 38003 3012 47
2491813 2491813 2022-05-10 Barnes North Dakota 38003 3012 47
2488555 2488555 2022-05-09 Barnes North Dakota 38003 3012 47
2485298 2485298 2022-05-08 Barnes North Dakota 38003 3012 47
2482040 2482040 2022-05-07 Barnes North Dakota 38003 3012 47
2478782 2478782 2022-05-06 Barnes North Dakota 38003 3012 47
2475524 2475524 2022-05-05 Barnes North Dakota 38003 2992 47
2472267 2472267 2022-05-04 Barnes North Dakota 38003 2992 47
2469011 2469011 2022-05-03 Barnes North Dakota 38003 2992 47
2465755 2465755 2022-05-02 Barnes North Dakota 38003 2992 47
2462500 2462500 2022-05-01 Barnes North Dakota 38003 2992 47
2459244 2459244 2022-04-30 Barnes North Dakota 38003 2992 47
2455988 2455988 2022-04-29 Barnes North Dakota 38003 2992 47
2452732 2452732 2022-04-28 Barnes North Dakota 38003 2980 47
2449476 2449476 2022-04-27 Barnes North Dakota 38003 2980 47
2446219 2446219 2022-04-26 Barnes North Dakota 38003 2980 47
2442964 2442964 2022-04-25 Barnes North Dakota 38003 2980 47
2439708 2439708 2022-04-24 Barnes North Dakota 38003 2980 47
2436452 2436452 2022-04-23 Barnes North Dakota 38003 2980 47
2433196 2433196 2022-04-22 Barnes North Dakota 38003 2980 47
2429940 2429940 2022-04-21 Barnes North Dakota 38003 2975 47
2426684 2426684 2022-04-20 Barnes North Dakota 38003 2975 47
2423428 2423428 2022-04-19 Barnes North Dakota 38003 2975 47
2420171 2420171 2022-04-18 Barnes North Dakota 38003 2975 47
2416916 2416916 2022-04-17 Barnes North Dakota 38003 2975 47
2413660 2413660 2022-04-16 Barnes North Dakota 38003 2975 47
2410404 2410404 2022-04-15 Barnes North Dakota 38003 2975 47
2407148 2407148 2022-04-14 Barnes North Dakota 38003 2968 47
2403892 2403892 2022-04-13 Barnes North Dakota 38003 2968 47
2400637 2400637 2022-04-12 Barnes North Dakota 38003 2968 47
2397382 2397382 2022-04-11 Barnes North Dakota 38003 2968 47
2394127 2394127 2022-04-10 Barnes North Dakota 38003 2968 47
2390871 2390871 2022-04-09 Barnes North Dakota 38003 2968 47
2387615 2387615 2022-04-08 Barnes North Dakota 38003 2968 47
2384360 2384360 2022-04-07 Barnes North Dakota 38003 2966 47
2381105 2381105 2022-04-06 Barnes North Dakota 38003 2966 47
2377850 2377850 2022-04-05 Barnes North Dakota 38003 2966 47
2374597 2374597 2022-04-04 Barnes North Dakota 38003 2966 47
2371345 2371345 2022-04-03 Barnes North Dakota 38003 2966 47
2368092 2368092 2022-04-02 Barnes North Dakota 38003 2966 47
2364839 2364839 2022-04-01 Barnes North Dakota 38003 2966 47
2361585 2361585 2022-03-31 Barnes North Dakota 38003 2963 47
2358331 2358331 2022-03-30 Barnes North Dakota 38003 2963 47
2355077 2355077 2022-03-29 Barnes North Dakota 38003 2963 47
2351824 2351824 2022-03-28 Barnes North Dakota 38003 2963 47
2348572 2348572 2022-03-27 Barnes North Dakota 38003 2963 47
2345319 2345319 2022-03-26 Barnes North Dakota 38003 2963 47
2342066 2342066 2022-03-25 Barnes North Dakota 38003 2963 47
2338813 2338813 2022-03-24 Barnes North Dakota 38003 2958 47
2335559 2335559 2022-03-23 Barnes North Dakota 38003 2958 47
2332305 2332305 2022-03-22 Barnes North Dakota 38003 2958 47
2329052 2329052 2022-03-21 Barnes North Dakota 38003 2958 47
2325800 2325800 2022-03-20 Barnes North Dakota 38003 2958 47
2322547 2322547 2022-03-19 Barnes North Dakota 38003 2958 47
2319293 2319293 2022-03-18 Barnes North Dakota 38003 2958 47
2316039 2316039 2022-03-17 Barnes North Dakota 38003 2958 47
2312786 2312786 2022-03-16 Barnes North Dakota 38003 2958 47
2309533 2309533 2022-03-15 Barnes North Dakota 38003 2960 47
2306280 2306280 2022-03-14 Barnes North Dakota 38003 2960 47
2303029 2303029 2022-03-13 Barnes North Dakota 38003 2960 47
2299777 2299777 2022-03-12 Barnes North Dakota 38003 2960 47
2296525 2296525 2022-03-11 Barnes North Dakota 38003 2968 47
2293273 2293273 2022-03-10 Barnes North Dakota 38003 2959 47
2290021 2290021 2022-03-09 Barnes North Dakota 38003 2959 46
2286769 2286769 2022-03-08 Barnes North Dakota 38003 2959 46
2283517 2283517 2022-03-07 Barnes North Dakota 38003 2959 46
2280265 2280265 2022-03-06 Barnes North Dakota 38003 2958 46
2277012 2277012 2022-03-05 Barnes North Dakota 38003 2956 46
2273759 2273759 2022-03-04 Barnes North Dakota 38003 2956 46
2270506 2270506 2022-03-03 Barnes North Dakota 38003 2953 46
2267254 2267254 2022-03-02 Barnes North Dakota 38003 2951 46
2264002 2264002 2022-03-01 Barnes North Dakota 38003 2951 46
2260751 2260751 2022-02-28 Barnes North Dakota 38003 2952 46
2257500 2257500 2022-02-27 Barnes North Dakota 38003 2952 46
2254249 2254249 2022-02-26 Barnes North Dakota 38003 2952 46
2250998 2250998 2022-02-25 Barnes North Dakota 38003 2948 46
2247747 2247747 2022-02-24 Barnes North Dakota 38003 2946 46
2244496 2244496 2022-02-23 Barnes North Dakota 38003 2944 46
2241245 2241245 2022-02-22 Barnes North Dakota 38003 2944 46
2237994 2237994 2022-02-21 Barnes North Dakota 38003 2944 46
2234743 2234743 2022-02-20 Barnes North Dakota 38003 2943 46
2231492 2231492 2022-02-19 Barnes North Dakota 38003 2943 46
2228241 2228241 2022-02-18 Barnes North Dakota 38003 2943 46
2224990 2224990 2022-02-17 Barnes North Dakota 38003 2938 46
2221739 2221739 2022-02-16 Barnes North Dakota 38003 2933 46
2218488 2218488 2022-02-15 Barnes North Dakota 38003 2928 46
2215237 2215237 2022-02-14 Barnes North Dakota 38003 2925 46
2211986 2211986 2022-02-13 Barnes North Dakota 38003 2923 46
2208733 2208733 2022-02-12 Barnes North Dakota 38003 2922 46
2205480 2205480 2022-02-11 Barnes North Dakota 38003 2914 46
2202227 2202227 2022-02-10 Barnes North Dakota 38003 2911 46
2198973 2198973 2022-02-09 Barnes North Dakota 38003 2897 46
2195719 2195719 2022-02-08 Barnes North Dakota 38003 2883 46
2192465 2192465 2022-02-07 Barnes North Dakota 38003 2860 45
2189211 2189211 2022-02-06 Barnes North Dakota 38003 2852 45
2185958 2185958 2022-02-05 Barnes North Dakota 38003 2852 45
2182706 2182706 2022-02-04 Barnes North Dakota 38003 2838 45
2179454 2179454 2022-02-03 Barnes North Dakota 38003 2819 44

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