ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,547 rows where county = "McDowell" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501544 | 2501544 | 2022-05-13 | McDowell | North Carolina | 37111 | 13855 | 176 |
2502709 | 2502709 | 2022-05-13 | McDowell | West Virginia | 54047 | 5662 | 75 |
2498286 | 2498286 | 2022-05-12 | McDowell | North Carolina | 37111 | 13855 | 176 |
2499451 | 2499451 | 2022-05-12 | McDowell | West Virginia | 54047 | 5663 | 75 |
2495028 | 2495028 | 2022-05-11 | McDowell | North Carolina | 37111 | 13855 | 176 |
2496193 | 2496193 | 2022-05-11 | McDowell | West Virginia | 54047 | 5658 | 75 |
2491770 | 2491770 | 2022-05-10 | McDowell | North Carolina | 37111 | 13821 | 176 |
2492935 | 2492935 | 2022-05-10 | McDowell | West Virginia | 54047 | 5652 | 75 |
2488512 | 2488512 | 2022-05-09 | McDowell | North Carolina | 37111 | 13821 | 176 |
2489677 | 2489677 | 2022-05-09 | McDowell | West Virginia | 54047 | 5652 | 75 |
2485255 | 2485255 | 2022-05-08 | McDowell | North Carolina | 37111 | 13821 | 176 |
2486420 | 2486420 | 2022-05-08 | McDowell | West Virginia | 54047 | 5645 | 75 |
2481997 | 2481997 | 2022-05-07 | McDowell | North Carolina | 37111 | 13821 | 176 |
2483162 | 2483162 | 2022-05-07 | McDowell | West Virginia | 54047 | 5645 | 75 |
2478739 | 2478739 | 2022-05-06 | McDowell | North Carolina | 37111 | 13821 | 176 |
2479904 | 2479904 | 2022-05-06 | McDowell | West Virginia | 54047 | 5645 | 75 |
2475481 | 2475481 | 2022-05-05 | McDowell | North Carolina | 37111 | 13821 | 176 |
2476646 | 2476646 | 2022-05-05 | McDowell | West Virginia | 54047 | 5642 | 75 |
2472224 | 2472224 | 2022-05-04 | McDowell | North Carolina | 37111 | 13821 | 176 |
2473388 | 2473388 | 2022-05-04 | McDowell | West Virginia | 54047 | 5637 | 75 |
2468968 | 2468968 | 2022-05-03 | McDowell | North Carolina | 37111 | 13778 | 170 |
2470131 | 2470131 | 2022-05-03 | McDowell | West Virginia | 54047 | 5632 | 75 |
2465712 | 2465712 | 2022-05-02 | McDowell | North Carolina | 37111 | 13778 | 170 |
2466875 | 2466875 | 2022-05-02 | McDowell | West Virginia | 54047 | 5632 | 75 |
2462457 | 2462457 | 2022-05-01 | McDowell | North Carolina | 37111 | 13778 | 170 |
2463620 | 2463620 | 2022-05-01 | McDowell | West Virginia | 54047 | 5630 | 75 |
2459201 | 2459201 | 2022-04-30 | McDowell | North Carolina | 37111 | 13778 | 170 |
2460364 | 2460364 | 2022-04-30 | McDowell | West Virginia | 54047 | 5630 | 75 |
2455945 | 2455945 | 2022-04-29 | McDowell | North Carolina | 37111 | 13778 | 170 |
2457108 | 2457108 | 2022-04-29 | McDowell | West Virginia | 54047 | 5630 | 75 |
2452689 | 2452689 | 2022-04-28 | McDowell | North Carolina | 37111 | 13778 | 170 |
2453852 | 2453852 | 2022-04-28 | McDowell | West Virginia | 54047 | 5628 | 75 |
2449433 | 2449433 | 2022-04-27 | McDowell | North Carolina | 37111 | 13778 | 170 |
2450596 | 2450596 | 2022-04-27 | McDowell | West Virginia | 54047 | 5628 | 75 |
2446176 | 2446176 | 2022-04-26 | McDowell | North Carolina | 37111 | 13698 | 169 |
2447340 | 2447340 | 2022-04-26 | McDowell | West Virginia | 54047 | 5624 | 75 |
2442921 | 2442921 | 2022-04-25 | McDowell | North Carolina | 37111 | 13698 | 169 |
2444084 | 2444084 | 2022-04-25 | McDowell | West Virginia | 54047 | 5620 | 74 |
2439665 | 2439665 | 2022-04-24 | McDowell | North Carolina | 37111 | 13698 | 169 |
2440828 | 2440828 | 2022-04-24 | McDowell | West Virginia | 54047 | 5619 | 74 |
2436409 | 2436409 | 2022-04-23 | McDowell | North Carolina | 37111 | 13698 | 169 |
2437572 | 2437572 | 2022-04-23 | McDowell | West Virginia | 54047 | 5619 | 74 |
2433153 | 2433153 | 2022-04-22 | McDowell | North Carolina | 37111 | 13698 | 169 |
2434316 | 2434316 | 2022-04-22 | McDowell | West Virginia | 54047 | 5619 | 74 |
2429897 | 2429897 | 2022-04-21 | McDowell | North Carolina | 37111 | 13698 | 169 |
2431060 | 2431060 | 2022-04-21 | McDowell | West Virginia | 54047 | 5617 | 74 |
2426641 | 2426641 | 2022-04-20 | McDowell | North Carolina | 37111 | 13698 | 169 |
2427804 | 2427804 | 2022-04-20 | McDowell | West Virginia | 54047 | 5617 | 73 |
2423385 | 2423385 | 2022-04-19 | McDowell | North Carolina | 37111 | 13685 | 169 |
2424548 | 2424548 | 2022-04-19 | McDowell | West Virginia | 54047 | 5614 | 73 |
2420128 | 2420128 | 2022-04-18 | McDowell | North Carolina | 37111 | 13685 | 169 |
2421292 | 2421292 | 2022-04-18 | McDowell | West Virginia | 54047 | 5613 | 73 |
2416873 | 2416873 | 2022-04-17 | McDowell | North Carolina | 37111 | 13685 | 169 |
2418036 | 2418036 | 2022-04-17 | McDowell | West Virginia | 54047 | 5610 | 73 |
2413617 | 2413617 | 2022-04-16 | McDowell | North Carolina | 37111 | 13685 | 169 |
2414780 | 2414780 | 2022-04-16 | McDowell | West Virginia | 54047 | 5610 | 73 |
2410361 | 2410361 | 2022-04-15 | McDowell | North Carolina | 37111 | 13685 | 169 |
2411524 | 2411524 | 2022-04-15 | McDowell | West Virginia | 54047 | 5610 | 73 |
2407105 | 2407105 | 2022-04-14 | McDowell | North Carolina | 37111 | 13685 | 169 |
2408268 | 2408268 | 2022-04-14 | McDowell | West Virginia | 54047 | 5609 | 73 |
2403849 | 2403849 | 2022-04-13 | McDowell | North Carolina | 37111 | 13685 | 169 |
2405012 | 2405012 | 2022-04-13 | McDowell | West Virginia | 54047 | 5607 | 73 |
2400594 | 2400594 | 2022-04-12 | McDowell | North Carolina | 37111 | 13673 | 169 |
2401757 | 2401757 | 2022-04-12 | McDowell | West Virginia | 54047 | 5607 | 73 |
2397339 | 2397339 | 2022-04-11 | McDowell | North Carolina | 37111 | 13673 | 169 |
2398502 | 2398502 | 2022-04-11 | McDowell | West Virginia | 54047 | 5607 | 72 |
2394084 | 2394084 | 2022-04-10 | McDowell | North Carolina | 37111 | 13673 | 169 |
2395247 | 2395247 | 2022-04-10 | McDowell | West Virginia | 54047 | 5607 | 72 |
2390828 | 2390828 | 2022-04-09 | McDowell | North Carolina | 37111 | 13673 | 169 |
2391991 | 2391991 | 2022-04-09 | McDowell | West Virginia | 54047 | 5607 | 72 |
2387572 | 2387572 | 2022-04-08 | McDowell | North Carolina | 37111 | 13673 | 169 |
2388735 | 2388735 | 2022-04-08 | McDowell | West Virginia | 54047 | 5607 | 72 |
2384317 | 2384317 | 2022-04-07 | McDowell | North Carolina | 37111 | 13673 | 169 |
2385480 | 2385480 | 2022-04-07 | McDowell | West Virginia | 54047 | 5604 | 72 |
2381062 | 2381062 | 2022-04-06 | McDowell | North Carolina | 37111 | 13673 | 169 |
2382225 | 2382225 | 2022-04-06 | McDowell | West Virginia | 54047 | 5599 | 72 |
2377807 | 2377807 | 2022-04-05 | McDowell | North Carolina | 37111 | 13669 | 169 |
2378970 | 2378970 | 2022-04-05 | McDowell | West Virginia | 54047 | 5598 | 71 |
2374554 | 2374554 | 2022-04-04 | McDowell | North Carolina | 37111 | 13660 | 168 |
2375716 | 2375716 | 2022-04-04 | McDowell | West Virginia | 54047 | 5595 | 71 |
2371302 | 2371302 | 2022-04-03 | McDowell | North Carolina | 37111 | 13659 | 167 |
2372464 | 2372464 | 2022-04-03 | McDowell | West Virginia | 54047 | 5595 | 71 |
2368049 | 2368049 | 2022-04-02 | McDowell | North Carolina | 37111 | 13659 | 167 |
2369211 | 2369211 | 2022-04-02 | McDowell | West Virginia | 54047 | 5595 | 71 |
2364796 | 2364796 | 2022-04-01 | McDowell | North Carolina | 37111 | 13659 | 167 |
2365958 | 2365958 | 2022-04-01 | McDowell | West Virginia | 54047 | 5595 | 71 |
2361542 | 2361542 | 2022-03-31 | McDowell | North Carolina | 37111 | 13657 | 167 |
2362705 | 2362705 | 2022-03-31 | McDowell | West Virginia | 54047 | 5594 | 71 |
2358288 | 2358288 | 2022-03-30 | McDowell | North Carolina | 37111 | 13653 | 167 |
2359451 | 2359451 | 2022-03-30 | McDowell | West Virginia | 54047 | 5593 | 71 |
2355034 | 2355034 | 2022-03-29 | McDowell | North Carolina | 37111 | 13650 | 167 |
2356197 | 2356197 | 2022-03-29 | McDowell | West Virginia | 54047 | 5592 | 71 |
2351781 | 2351781 | 2022-03-28 | McDowell | North Carolina | 37111 | 13650 | 167 |
2352944 | 2352944 | 2022-03-28 | McDowell | West Virginia | 54047 | 5591 | 69 |
2348529 | 2348529 | 2022-03-27 | McDowell | North Carolina | 37111 | 13647 | 167 |
2349692 | 2349692 | 2022-03-27 | McDowell | West Virginia | 54047 | 5586 | 69 |
2345276 | 2345276 | 2022-03-26 | McDowell | North Carolina | 37111 | 13647 | 167 |
2346439 | 2346439 | 2022-03-26 | McDowell | West Virginia | 54047 | 5586 | 69 |
2342023 | 2342023 | 2022-03-25 | McDowell | North Carolina | 37111 | 13647 | 167 |
2343186 | 2343186 | 2022-03-25 | McDowell | West Virginia | 54047 | 5586 | 69 |
Advanced export
JSON shape: default, array, newline-delimited
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);