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

781 rows where county = "Dunn", fips = 38025 and state = "North Dakota" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • North Dakota · 781 ✖

fips 1

  • 38025 · 781 ✖

county 1

  • Dunn · 781 ✖
Link rowid date ▲ county state fips cases deaths
2501598 2501598 2022-05-13 Dunn North Dakota 38025 1041 8
2498340 2498340 2022-05-12 Dunn North Dakota 38025 1040 8
2495082 2495082 2022-05-11 Dunn North Dakota 38025 1040 8
2491824 2491824 2022-05-10 Dunn North Dakota 38025 1040 8
2488566 2488566 2022-05-09 Dunn North Dakota 38025 1040 8
2485309 2485309 2022-05-08 Dunn North Dakota 38025 1040 8
2482051 2482051 2022-05-07 Dunn North Dakota 38025 1040 8
2478793 2478793 2022-05-06 Dunn North Dakota 38025 1040 8
2475535 2475535 2022-05-05 Dunn North Dakota 38025 1039 8
2472278 2472278 2022-05-04 Dunn North Dakota 38025 1039 8
2469022 2469022 2022-05-03 Dunn North Dakota 38025 1039 8
2465766 2465766 2022-05-02 Dunn North Dakota 38025 1039 8
2462511 2462511 2022-05-01 Dunn North Dakota 38025 1039 8
2459255 2459255 2022-04-30 Dunn North Dakota 38025 1039 8
2455999 2455999 2022-04-29 Dunn North Dakota 38025 1039 8
2452743 2452743 2022-04-28 Dunn North Dakota 38025 1039 8
2449487 2449487 2022-04-27 Dunn North Dakota 38025 1039 8
2446230 2446230 2022-04-26 Dunn North Dakota 38025 1039 8
2442975 2442975 2022-04-25 Dunn North Dakota 38025 1039 8
2439719 2439719 2022-04-24 Dunn North Dakota 38025 1039 8
2436463 2436463 2022-04-23 Dunn North Dakota 38025 1039 8
2433207 2433207 2022-04-22 Dunn North Dakota 38025 1039 8
2429951 2429951 2022-04-21 Dunn North Dakota 38025 1038 8
2426695 2426695 2022-04-20 Dunn North Dakota 38025 1038 8
2423439 2423439 2022-04-19 Dunn North Dakota 38025 1038 8
2420182 2420182 2022-04-18 Dunn North Dakota 38025 1038 8
2416927 2416927 2022-04-17 Dunn North Dakota 38025 1038 8
2413671 2413671 2022-04-16 Dunn North Dakota 38025 1038 8
2410415 2410415 2022-04-15 Dunn North Dakota 38025 1038 8
2407159 2407159 2022-04-14 Dunn North Dakota 38025 1038 8
2403903 2403903 2022-04-13 Dunn North Dakota 38025 1038 8
2400648 2400648 2022-04-12 Dunn North Dakota 38025 1038 8
2397393 2397393 2022-04-11 Dunn North Dakota 38025 1038 8
2394138 2394138 2022-04-10 Dunn North Dakota 38025 1038 8
2390882 2390882 2022-04-09 Dunn North Dakota 38025 1038 8
2387626 2387626 2022-04-08 Dunn North Dakota 38025 1038 8
2384371 2384371 2022-04-07 Dunn North Dakota 38025 1038 8
2381116 2381116 2022-04-06 Dunn North Dakota 38025 1038 8
2377861 2377861 2022-04-05 Dunn North Dakota 38025 1038 8
2374608 2374608 2022-04-04 Dunn North Dakota 38025 1038 8
2371356 2371356 2022-04-03 Dunn North Dakota 38025 1038 8
2368103 2368103 2022-04-02 Dunn North Dakota 38025 1038 8
2364850 2364850 2022-04-01 Dunn North Dakota 38025 1038 8
2361596 2361596 2022-03-31 Dunn North Dakota 38025 1037 8
2358342 2358342 2022-03-30 Dunn North Dakota 38025 1037 8
2355088 2355088 2022-03-29 Dunn North Dakota 38025 1037 8
2351835 2351835 2022-03-28 Dunn North Dakota 38025 1037 8
2348583 2348583 2022-03-27 Dunn North Dakota 38025 1037 8
2345330 2345330 2022-03-26 Dunn North Dakota 38025 1037 8
2342077 2342077 2022-03-25 Dunn North Dakota 38025 1037 8
2338824 2338824 2022-03-24 Dunn North Dakota 38025 1034 8
2335570 2335570 2022-03-23 Dunn North Dakota 38025 1034 8
2332316 2332316 2022-03-22 Dunn North Dakota 38025 1034 8
2329063 2329063 2022-03-21 Dunn North Dakota 38025 1034 8
2325811 2325811 2022-03-20 Dunn North Dakota 38025 1034 8
2322558 2322558 2022-03-19 Dunn North Dakota 38025 1034 8
2319304 2319304 2022-03-18 Dunn North Dakota 38025 1034 8
2316050 2316050 2022-03-17 Dunn North Dakota 38025 1036 8
2312797 2312797 2022-03-16 Dunn North Dakota 38025 1033 8
2309544 2309544 2022-03-15 Dunn North Dakota 38025 1033 8
2306291 2306291 2022-03-14 Dunn North Dakota 38025 1033 8
2303040 2303040 2022-03-13 Dunn North Dakota 38025 1033 8
2299788 2299788 2022-03-12 Dunn North Dakota 38025 1033 8
2296536 2296536 2022-03-11 Dunn North Dakota 38025 1030 8
2293284 2293284 2022-03-10 Dunn North Dakota 38025 1030 8
2290032 2290032 2022-03-09 Dunn North Dakota 38025 1029 8
2286780 2286780 2022-03-08 Dunn North Dakota 38025 1032 8
2283528 2283528 2022-03-07 Dunn North Dakota 38025 1032 8
2280276 2280276 2022-03-06 Dunn North Dakota 38025 1032 8
2277023 2277023 2022-03-05 Dunn North Dakota 38025 1032 8
2273770 2273770 2022-03-04 Dunn North Dakota 38025 1032 8
2270517 2270517 2022-03-03 Dunn North Dakota 38025 1030 8
2267265 2267265 2022-03-02 Dunn North Dakota 38025 1029 8
2264013 2264013 2022-03-01 Dunn North Dakota 38025 1029 8
2260762 2260762 2022-02-28 Dunn North Dakota 38025 1029 8
2257511 2257511 2022-02-27 Dunn North Dakota 38025 1027 8
2254260 2254260 2022-02-26 Dunn North Dakota 38025 1027 8
2251009 2251009 2022-02-25 Dunn North Dakota 38025 1027 8
2247758 2247758 2022-02-24 Dunn North Dakota 38025 1027 8
2244507 2244507 2022-02-23 Dunn North Dakota 38025 1026 8
2241256 2241256 2022-02-22 Dunn North Dakota 38025 1022 8
2238005 2238005 2022-02-21 Dunn North Dakota 38025 1022 8
2234754 2234754 2022-02-20 Dunn North Dakota 38025 1022 8
2231503 2231503 2022-02-19 Dunn North Dakota 38025 1022 8
2228252 2228252 2022-02-18 Dunn North Dakota 38025 1021 8
2225001 2225001 2022-02-17 Dunn North Dakota 38025 1017 8
2221750 2221750 2022-02-16 Dunn North Dakota 38025 1017 8
2218499 2218499 2022-02-15 Dunn North Dakota 38025 1014 8
2215248 2215248 2022-02-14 Dunn North Dakota 38025 1013 8
2211997 2211997 2022-02-13 Dunn North Dakota 38025 1013 8
2208744 2208744 2022-02-12 Dunn North Dakota 38025 1013 8
2205491 2205491 2022-02-11 Dunn North Dakota 38025 1007 8
2202238 2202238 2022-02-10 Dunn North Dakota 38025 1002 8
2198984 2198984 2022-02-09 Dunn North Dakota 38025 995 8
2195730 2195730 2022-02-08 Dunn North Dakota 38025 996 8
2192476 2192476 2022-02-07 Dunn North Dakota 38025 991 8
2189222 2189222 2022-02-06 Dunn North Dakota 38025 986 8
2185969 2185969 2022-02-05 Dunn North Dakota 38025 986 8
2182717 2182717 2022-02-04 Dunn North Dakota 38025 985 8
2179465 2179465 2022-02-03 Dunn North Dakota 38025 981 8

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