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

782 rows where county = "Walsh", fips = 38099 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 · 782 ✖

fips 1

  • 38099 · 782 ✖

county 1

  • Walsh · 782 ✖
Link rowid date ▲ county state fips cases deaths
2501636 2501636 2022-05-13 Walsh North Dakota 38099 3374 34
2498378 2498378 2022-05-12 Walsh North Dakota 38099 3368 34
2495120 2495120 2022-05-11 Walsh North Dakota 38099 3368 34
2491862 2491862 2022-05-10 Walsh North Dakota 38099 3368 34
2488604 2488604 2022-05-09 Walsh North Dakota 38099 3368 34
2485347 2485347 2022-05-08 Walsh North Dakota 38099 3368 34
2482089 2482089 2022-05-07 Walsh North Dakota 38099 3368 34
2478831 2478831 2022-05-06 Walsh North Dakota 38099 3368 34
2475573 2475573 2022-05-05 Walsh North Dakota 38099 3362 34
2472316 2472316 2022-05-04 Walsh North Dakota 38099 3362 34
2469060 2469060 2022-05-03 Walsh North Dakota 38099 3362 34
2465804 2465804 2022-05-02 Walsh North Dakota 38099 3362 34
2462549 2462549 2022-05-01 Walsh North Dakota 38099 3362 34
2459293 2459293 2022-04-30 Walsh North Dakota 38099 3362 34
2456037 2456037 2022-04-29 Walsh North Dakota 38099 3362 34
2452781 2452781 2022-04-28 Walsh North Dakota 38099 3355 34
2449525 2449525 2022-04-27 Walsh North Dakota 38099 3355 34
2446268 2446268 2022-04-26 Walsh North Dakota 38099 3355 34
2443013 2443013 2022-04-25 Walsh North Dakota 38099 3355 34
2439757 2439757 2022-04-24 Walsh North Dakota 38099 3355 34
2436501 2436501 2022-04-23 Walsh North Dakota 38099 3355 34
2433245 2433245 2022-04-22 Walsh North Dakota 38099 3355 34
2429989 2429989 2022-04-21 Walsh North Dakota 38099 3354 34
2426733 2426733 2022-04-20 Walsh North Dakota 38099 3354 34
2423477 2423477 2022-04-19 Walsh North Dakota 38099 3354 34
2420220 2420220 2022-04-18 Walsh North Dakota 38099 3354 34
2416965 2416965 2022-04-17 Walsh North Dakota 38099 3354 34
2413709 2413709 2022-04-16 Walsh North Dakota 38099 3354 34
2410453 2410453 2022-04-15 Walsh North Dakota 38099 3354 34
2407197 2407197 2022-04-14 Walsh North Dakota 38099 3352 34
2403941 2403941 2022-04-13 Walsh North Dakota 38099 3352 34
2400686 2400686 2022-04-12 Walsh North Dakota 38099 3352 34
2397431 2397431 2022-04-11 Walsh North Dakota 38099 3352 34
2394176 2394176 2022-04-10 Walsh North Dakota 38099 3352 34
2390920 2390920 2022-04-09 Walsh North Dakota 38099 3352 34
2387664 2387664 2022-04-08 Walsh North Dakota 38099 3352 34
2384409 2384409 2022-04-07 Walsh North Dakota 38099 3351 34
2381154 2381154 2022-04-06 Walsh North Dakota 38099 3351 34
2377899 2377899 2022-04-05 Walsh North Dakota 38099 3351 34
2374646 2374646 2022-04-04 Walsh North Dakota 38099 3351 34
2371394 2371394 2022-04-03 Walsh North Dakota 38099 3351 34
2368141 2368141 2022-04-02 Walsh North Dakota 38099 3351 34
2364888 2364888 2022-04-01 Walsh North Dakota 38099 3351 34
2361634 2361634 2022-03-31 Walsh North Dakota 38099 3349 34
2358380 2358380 2022-03-30 Walsh North Dakota 38099 3349 34
2355126 2355126 2022-03-29 Walsh North Dakota 38099 3349 34
2351873 2351873 2022-03-28 Walsh North Dakota 38099 3349 34
2348621 2348621 2022-03-27 Walsh North Dakota 38099 3349 34
2345368 2345368 2022-03-26 Walsh North Dakota 38099 3349 34
2342115 2342115 2022-03-25 Walsh North Dakota 38099 3349 34
2338862 2338862 2022-03-24 Walsh North Dakota 38099 3344 34
2335608 2335608 2022-03-23 Walsh North Dakota 38099 3344 34
2332354 2332354 2022-03-22 Walsh North Dakota 38099 3344 34
2329101 2329101 2022-03-21 Walsh North Dakota 38099 3344 34
2325849 2325849 2022-03-20 Walsh North Dakota 38099 3344 34
2322596 2322596 2022-03-19 Walsh North Dakota 38099 3344 34
2319342 2319342 2022-03-18 Walsh North Dakota 38099 3344 34
2316088 2316088 2022-03-17 Walsh North Dakota 38099 3339 34
2312835 2312835 2022-03-16 Walsh North Dakota 38099 3339 34
2309582 2309582 2022-03-15 Walsh North Dakota 38099 3337 34
2306329 2306329 2022-03-14 Walsh North Dakota 38099 3336 34
2303078 2303078 2022-03-13 Walsh North Dakota 38099 3335 34
2299826 2299826 2022-03-12 Walsh North Dakota 38099 3334 34
2296574 2296574 2022-03-11 Walsh North Dakota 38099 3333 34
2293322 2293322 2022-03-10 Walsh North Dakota 38099 3331 34
2290070 2290070 2022-03-09 Walsh North Dakota 38099 3331 34
2286818 2286818 2022-03-08 Walsh North Dakota 38099 3328 34
2283566 2283566 2022-03-07 Walsh North Dakota 38099 3327 34
2280314 2280314 2022-03-06 Walsh North Dakota 38099 3327 34
2277061 2277061 2022-03-05 Walsh North Dakota 38099 3326 34
2273808 2273808 2022-03-04 Walsh North Dakota 38099 3323 34
2270555 2270555 2022-03-03 Walsh North Dakota 38099 3320 34
2267303 2267303 2022-03-02 Walsh North Dakota 38099 3320 34
2264051 2264051 2022-03-01 Walsh North Dakota 38099 3312 34
2260800 2260800 2022-02-28 Walsh North Dakota 38099 3313 34
2257549 2257549 2022-02-27 Walsh North Dakota 38099 3313 34
2254298 2254298 2022-02-26 Walsh North Dakota 38099 3307 34
2251047 2251047 2022-02-25 Walsh North Dakota 38099 3307 34
2247796 2247796 2022-02-24 Walsh North Dakota 38099 3304 34
2244545 2244545 2022-02-23 Walsh North Dakota 38099 3299 34
2241294 2241294 2022-02-22 Walsh North Dakota 38099 3298 34
2238043 2238043 2022-02-21 Walsh North Dakota 38099 3295 34
2234792 2234792 2022-02-20 Walsh North Dakota 38099 3294 34
2231541 2231541 2022-02-19 Walsh North Dakota 38099 3292 34
2228290 2228290 2022-02-18 Walsh North Dakota 38099 3290 34
2225039 2225039 2022-02-17 Walsh North Dakota 38099 3287 34
2221788 2221788 2022-02-16 Walsh North Dakota 38099 3278 34
2218537 2218537 2022-02-15 Walsh North Dakota 38099 3271 34
2215286 2215286 2022-02-14 Walsh North Dakota 38099 3273 34
2212035 2212035 2022-02-13 Walsh North Dakota 38099 3273 34
2208782 2208782 2022-02-12 Walsh North Dakota 38099 3270 34
2205529 2205529 2022-02-11 Walsh North Dakota 38099 3262 34
2202276 2202276 2022-02-10 Walsh North Dakota 38099 3253 34
2199022 2199022 2022-02-09 Walsh North Dakota 38099 3248 34
2195768 2195768 2022-02-08 Walsh North Dakota 38099 3239 34
2192514 2192514 2022-02-07 Walsh North Dakota 38099 3229 34
2189260 2189260 2022-02-06 Walsh North Dakota 38099 3220 34
2186007 2186007 2022-02-05 Walsh North Dakota 38099 3220 34
2182755 2182755 2022-02-04 Walsh North Dakota 38099 3208 34
2179503 2179503 2022-02-03 Walsh North Dakota 38099 3194 34

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