ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "McDowell" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501544 | 2501544 | 2022-05-13 | McDowell | North Carolina | 37111 | 13855 | 176 |
2498286 | 2498286 | 2022-05-12 | McDowell | North Carolina | 37111 | 13855 | 176 |
2495028 | 2495028 | 2022-05-11 | McDowell | North Carolina | 37111 | 13855 | 176 |
2491770 | 2491770 | 2022-05-10 | McDowell | North Carolina | 37111 | 13821 | 176 |
2488512 | 2488512 | 2022-05-09 | McDowell | North Carolina | 37111 | 13821 | 176 |
2485255 | 2485255 | 2022-05-08 | McDowell | North Carolina | 37111 | 13821 | 176 |
2481997 | 2481997 | 2022-05-07 | McDowell | North Carolina | 37111 | 13821 | 176 |
2478739 | 2478739 | 2022-05-06 | McDowell | North Carolina | 37111 | 13821 | 176 |
2475481 | 2475481 | 2022-05-05 | McDowell | North Carolina | 37111 | 13821 | 176 |
2472224 | 2472224 | 2022-05-04 | McDowell | North Carolina | 37111 | 13821 | 176 |
2468968 | 2468968 | 2022-05-03 | McDowell | North Carolina | 37111 | 13778 | 170 |
2465712 | 2465712 | 2022-05-02 | McDowell | North Carolina | 37111 | 13778 | 170 |
2462457 | 2462457 | 2022-05-01 | McDowell | North Carolina | 37111 | 13778 | 170 |
2459201 | 2459201 | 2022-04-30 | McDowell | North Carolina | 37111 | 13778 | 170 |
2455945 | 2455945 | 2022-04-29 | McDowell | North Carolina | 37111 | 13778 | 170 |
2452689 | 2452689 | 2022-04-28 | McDowell | North Carolina | 37111 | 13778 | 170 |
2449433 | 2449433 | 2022-04-27 | McDowell | North Carolina | 37111 | 13778 | 170 |
2446176 | 2446176 | 2022-04-26 | McDowell | North Carolina | 37111 | 13698 | 169 |
2442921 | 2442921 | 2022-04-25 | McDowell | North Carolina | 37111 | 13698 | 169 |
2439665 | 2439665 | 2022-04-24 | McDowell | North Carolina | 37111 | 13698 | 169 |
2436409 | 2436409 | 2022-04-23 | McDowell | North Carolina | 37111 | 13698 | 169 |
2433153 | 2433153 | 2022-04-22 | McDowell | North Carolina | 37111 | 13698 | 169 |
2429897 | 2429897 | 2022-04-21 | McDowell | North Carolina | 37111 | 13698 | 169 |
2426641 | 2426641 | 2022-04-20 | McDowell | North Carolina | 37111 | 13698 | 169 |
2423385 | 2423385 | 2022-04-19 | McDowell | North Carolina | 37111 | 13685 | 169 |
2420128 | 2420128 | 2022-04-18 | McDowell | North Carolina | 37111 | 13685 | 169 |
2416873 | 2416873 | 2022-04-17 | McDowell | North Carolina | 37111 | 13685 | 169 |
2413617 | 2413617 | 2022-04-16 | McDowell | North Carolina | 37111 | 13685 | 169 |
2410361 | 2410361 | 2022-04-15 | McDowell | North Carolina | 37111 | 13685 | 169 |
2407105 | 2407105 | 2022-04-14 | McDowell | North Carolina | 37111 | 13685 | 169 |
2403849 | 2403849 | 2022-04-13 | McDowell | North Carolina | 37111 | 13685 | 169 |
2400594 | 2400594 | 2022-04-12 | McDowell | North Carolina | 37111 | 13673 | 169 |
2397339 | 2397339 | 2022-04-11 | McDowell | North Carolina | 37111 | 13673 | 169 |
2394084 | 2394084 | 2022-04-10 | McDowell | North Carolina | 37111 | 13673 | 169 |
2390828 | 2390828 | 2022-04-09 | McDowell | North Carolina | 37111 | 13673 | 169 |
2387572 | 2387572 | 2022-04-08 | McDowell | North Carolina | 37111 | 13673 | 169 |
2384317 | 2384317 | 2022-04-07 | McDowell | North Carolina | 37111 | 13673 | 169 |
2381062 | 2381062 | 2022-04-06 | McDowell | North Carolina | 37111 | 13673 | 169 |
2377807 | 2377807 | 2022-04-05 | McDowell | North Carolina | 37111 | 13669 | 169 |
2374554 | 2374554 | 2022-04-04 | McDowell | North Carolina | 37111 | 13660 | 168 |
2371302 | 2371302 | 2022-04-03 | McDowell | North Carolina | 37111 | 13659 | 167 |
2368049 | 2368049 | 2022-04-02 | McDowell | North Carolina | 37111 | 13659 | 167 |
2364796 | 2364796 | 2022-04-01 | McDowell | North Carolina | 37111 | 13659 | 167 |
2361542 | 2361542 | 2022-03-31 | McDowell | North Carolina | 37111 | 13657 | 167 |
2358288 | 2358288 | 2022-03-30 | McDowell | North Carolina | 37111 | 13653 | 167 |
2355034 | 2355034 | 2022-03-29 | McDowell | North Carolina | 37111 | 13650 | 167 |
2351781 | 2351781 | 2022-03-28 | McDowell | North Carolina | 37111 | 13650 | 167 |
2348529 | 2348529 | 2022-03-27 | McDowell | North Carolina | 37111 | 13647 | 167 |
2345276 | 2345276 | 2022-03-26 | McDowell | North Carolina | 37111 | 13647 | 167 |
2342023 | 2342023 | 2022-03-25 | McDowell | North Carolina | 37111 | 13647 | 167 |
2338770 | 2338770 | 2022-03-24 | McDowell | North Carolina | 37111 | 13646 | 167 |
2335516 | 2335516 | 2022-03-23 | McDowell | North Carolina | 37111 | 13643 | 167 |
2332262 | 2332262 | 2022-03-22 | McDowell | North Carolina | 37111 | 13631 | 167 |
2329009 | 2329009 | 2022-03-21 | McDowell | North Carolina | 37111 | 13609 | 167 |
2325757 | 2325757 | 2022-03-20 | McDowell | North Carolina | 37111 | 13588 | 168 |
2322504 | 2322504 | 2022-03-19 | McDowell | North Carolina | 37111 | 13588 | 168 |
2319250 | 2319250 | 2022-03-18 | McDowell | North Carolina | 37111 | 13588 | 168 |
2315996 | 2315996 | 2022-03-17 | McDowell | North Carolina | 37111 | 13564 | 168 |
2312743 | 2312743 | 2022-03-16 | McDowell | North Carolina | 37111 | 13533 | 164 |
2309490 | 2309490 | 2022-03-15 | McDowell | North Carolina | 37111 | 13481 | 165 |
2306237 | 2306237 | 2022-03-14 | McDowell | North Carolina | 37111 | 13482 | 165 |
2302986 | 2302986 | 2022-03-13 | McDowell | North Carolina | 37111 | 13471 | 164 |
2299734 | 2299734 | 2022-03-12 | McDowell | North Carolina | 37111 | 13471 | 164 |
2296482 | 2296482 | 2022-03-11 | McDowell | North Carolina | 37111 | 13471 | 164 |
2293230 | 2293230 | 2022-03-10 | McDowell | North Carolina | 37111 | 13461 | 164 |
2289978 | 2289978 | 2022-03-09 | McDowell | North Carolina | 37111 | 13455 | 163 |
2286726 | 2286726 | 2022-03-08 | McDowell | North Carolina | 37111 | 13447 | 163 |
2283474 | 2283474 | 2022-03-07 | McDowell | North Carolina | 37111 | 13443 | 163 |
2280222 | 2280222 | 2022-03-06 | McDowell | North Carolina | 37111 | 13421 | 162 |
2276969 | 2276969 | 2022-03-05 | McDowell | North Carolina | 37111 | 13421 | 162 |
2273716 | 2273716 | 2022-03-04 | McDowell | North Carolina | 37111 | 13421 | 162 |
2270463 | 2270463 | 2022-03-03 | McDowell | North Carolina | 37111 | 13403 | 162 |
2267211 | 2267211 | 2022-03-02 | McDowell | North Carolina | 37111 | 13391 | 161 |
2263959 | 2263959 | 2022-03-01 | McDowell | North Carolina | 37111 | 13377 | 160 |
2260708 | 2260708 | 2022-02-28 | McDowell | North Carolina | 37111 | 13370 | 160 |
2257457 | 2257457 | 2022-02-27 | McDowell | North Carolina | 37111 | 13330 | 159 |
2254206 | 2254206 | 2022-02-26 | McDowell | North Carolina | 37111 | 13330 | 159 |
2250955 | 2250955 | 2022-02-25 | McDowell | North Carolina | 37111 | 13330 | 159 |
2247704 | 2247704 | 2022-02-24 | McDowell | North Carolina | 37111 | 13305 | 159 |
2244453 | 2244453 | 2022-02-23 | McDowell | North Carolina | 37111 | 13288 | 159 |
2241202 | 2241202 | 2022-02-22 | McDowell | North Carolina | 37111 | 13261 | 159 |
2237951 | 2237951 | 2022-02-21 | McDowell | North Carolina | 37111 | 13245 | 159 |
2234700 | 2234700 | 2022-02-20 | McDowell | North Carolina | 37111 | 13137 | 159 |
2231449 | 2231449 | 2022-02-19 | McDowell | North Carolina | 37111 | 13137 | 159 |
2228198 | 2228198 | 2022-02-18 | McDowell | North Carolina | 37111 | 13137 | 159 |
2224947 | 2224947 | 2022-02-17 | McDowell | North Carolina | 37111 | 13099 | 159 |
2221696 | 2221696 | 2022-02-16 | McDowell | North Carolina | 37111 | 13028 | 159 |
2218445 | 2218445 | 2022-02-15 | McDowell | North Carolina | 37111 | 12974 | 151 |
2215194 | 2215194 | 2022-02-14 | McDowell | North Carolina | 37111 | 12964 | 151 |
2211943 | 2211943 | 2022-02-13 | McDowell | North Carolina | 37111 | 12838 | 150 |
2208690 | 2208690 | 2022-02-12 | McDowell | North Carolina | 37111 | 12838 | 150 |
2205437 | 2205437 | 2022-02-11 | McDowell | North Carolina | 37111 | 12838 | 150 |
2202184 | 2202184 | 2022-02-10 | McDowell | North Carolina | 37111 | 12767 | 150 |
2198930 | 2198930 | 2022-02-09 | McDowell | North Carolina | 37111 | 12675 | 143 |
2195676 | 2195676 | 2022-02-08 | McDowell | North Carolina | 37111 | 12616 | 142 |
2192422 | 2192422 | 2022-02-07 | McDowell | North Carolina | 37111 | 12592 | 142 |
2189168 | 2189168 | 2022-02-06 | McDowell | North Carolina | 37111 | 12374 | 142 |
2185915 | 2185915 | 2022-02-05 | McDowell | North Carolina | 37111 | 12374 | 142 |
2182663 | 2182663 | 2022-02-04 | McDowell | North Carolina | 37111 | 12374 | 142 |
2179411 | 2179411 | 2022-02-03 | McDowell | North Carolina | 37111 | 12279 | 142 |
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);