ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
741 rows where county = "Yancey" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501585 | 2501585 | 2022-05-13 | Yancey | North Carolina | 37199 | 5353 | 57 |
2498327 | 2498327 | 2022-05-12 | Yancey | North Carolina | 37199 | 5353 | 57 |
2495069 | 2495069 | 2022-05-11 | Yancey | North Carolina | 37199 | 5353 | 57 |
2491811 | 2491811 | 2022-05-10 | Yancey | North Carolina | 37199 | 5331 | 57 |
2488553 | 2488553 | 2022-05-09 | Yancey | North Carolina | 37199 | 5331 | 57 |
2485296 | 2485296 | 2022-05-08 | Yancey | North Carolina | 37199 | 5331 | 57 |
2482038 | 2482038 | 2022-05-07 | Yancey | North Carolina | 37199 | 5331 | 57 |
2478780 | 2478780 | 2022-05-06 | Yancey | North Carolina | 37199 | 5331 | 57 |
2475522 | 2475522 | 2022-05-05 | Yancey | North Carolina | 37199 | 5331 | 57 |
2472265 | 2472265 | 2022-05-04 | Yancey | North Carolina | 37199 | 5331 | 57 |
2469009 | 2469009 | 2022-05-03 | Yancey | North Carolina | 37199 | 5305 | 51 |
2465753 | 2465753 | 2022-05-02 | Yancey | North Carolina | 37199 | 5305 | 51 |
2462498 | 2462498 | 2022-05-01 | Yancey | North Carolina | 37199 | 5305 | 51 |
2459242 | 2459242 | 2022-04-30 | Yancey | North Carolina | 37199 | 5305 | 51 |
2455986 | 2455986 | 2022-04-29 | Yancey | North Carolina | 37199 | 5305 | 51 |
2452730 | 2452730 | 2022-04-28 | Yancey | North Carolina | 37199 | 5305 | 51 |
2449474 | 2449474 | 2022-04-27 | Yancey | North Carolina | 37199 | 5305 | 51 |
2446217 | 2446217 | 2022-04-26 | Yancey | North Carolina | 37199 | 5231 | 51 |
2442962 | 2442962 | 2022-04-25 | Yancey | North Carolina | 37199 | 5231 | 51 |
2439706 | 2439706 | 2022-04-24 | Yancey | North Carolina | 37199 | 5231 | 51 |
2436450 | 2436450 | 2022-04-23 | Yancey | North Carolina | 37199 | 5231 | 51 |
2433194 | 2433194 | 2022-04-22 | Yancey | North Carolina | 37199 | 5231 | 51 |
2429938 | 2429938 | 2022-04-21 | Yancey | North Carolina | 37199 | 5231 | 51 |
2426682 | 2426682 | 2022-04-20 | Yancey | North Carolina | 37199 | 5231 | 51 |
2423426 | 2423426 | 2022-04-19 | Yancey | North Carolina | 37199 | 5074 | 51 |
2420169 | 2420169 | 2022-04-18 | Yancey | North Carolina | 37199 | 5074 | 51 |
2416914 | 2416914 | 2022-04-17 | Yancey | North Carolina | 37199 | 5074 | 51 |
2413658 | 2413658 | 2022-04-16 | Yancey | North Carolina | 37199 | 5074 | 51 |
2410402 | 2410402 | 2022-04-15 | Yancey | North Carolina | 37199 | 5074 | 51 |
2407146 | 2407146 | 2022-04-14 | Yancey | North Carolina | 37199 | 5074 | 51 |
2403890 | 2403890 | 2022-04-13 | Yancey | North Carolina | 37199 | 5074 | 51 |
2400635 | 2400635 | 2022-04-12 | Yancey | North Carolina | 37199 | 5016 | 51 |
2397380 | 2397380 | 2022-04-11 | Yancey | North Carolina | 37199 | 5016 | 51 |
2394125 | 2394125 | 2022-04-10 | Yancey | North Carolina | 37199 | 5016 | 51 |
2390869 | 2390869 | 2022-04-09 | Yancey | North Carolina | 37199 | 5016 | 51 |
2387613 | 2387613 | 2022-04-08 | Yancey | North Carolina | 37199 | 5016 | 51 |
2384358 | 2384358 | 2022-04-07 | Yancey | North Carolina | 37199 | 5016 | 51 |
2381103 | 2381103 | 2022-04-06 | Yancey | North Carolina | 37199 | 5016 | 51 |
2377848 | 2377848 | 2022-04-05 | Yancey | North Carolina | 37199 | 5012 | 51 |
2374595 | 2374595 | 2022-04-04 | Yancey | North Carolina | 37199 | 5010 | 51 |
2371343 | 2371343 | 2022-04-03 | Yancey | North Carolina | 37199 | 5001 | 51 |
2368090 | 2368090 | 2022-04-02 | Yancey | North Carolina | 37199 | 5001 | 51 |
2364837 | 2364837 | 2022-04-01 | Yancey | North Carolina | 37199 | 5001 | 51 |
2361583 | 2361583 | 2022-03-31 | Yancey | North Carolina | 37199 | 4999 | 51 |
2358329 | 2358329 | 2022-03-30 | Yancey | North Carolina | 37199 | 4997 | 51 |
2355075 | 2355075 | 2022-03-29 | Yancey | North Carolina | 37199 | 4997 | 51 |
2351822 | 2351822 | 2022-03-28 | Yancey | North Carolina | 37199 | 4997 | 51 |
2348570 | 2348570 | 2022-03-27 | Yancey | North Carolina | 37199 | 4994 | 51 |
2345317 | 2345317 | 2022-03-26 | Yancey | North Carolina | 37199 | 4994 | 51 |
2342064 | 2342064 | 2022-03-25 | Yancey | North Carolina | 37199 | 4994 | 51 |
2338811 | 2338811 | 2022-03-24 | Yancey | North Carolina | 37199 | 4993 | 51 |
2335557 | 2335557 | 2022-03-23 | Yancey | North Carolina | 37199 | 4992 | 51 |
2332303 | 2332303 | 2022-03-22 | Yancey | North Carolina | 37199 | 4981 | 51 |
2329050 | 2329050 | 2022-03-21 | Yancey | North Carolina | 37199 | 4979 | 51 |
2325798 | 2325798 | 2022-03-20 | Yancey | North Carolina | 37199 | 4975 | 51 |
2322545 | 2322545 | 2022-03-19 | Yancey | North Carolina | 37199 | 4975 | 51 |
2319291 | 2319291 | 2022-03-18 | Yancey | North Carolina | 37199 | 4975 | 51 |
2316037 | 2316037 | 2022-03-17 | Yancey | North Carolina | 37199 | 4953 | 51 |
2312784 | 2312784 | 2022-03-16 | Yancey | North Carolina | 37199 | 4946 | 51 |
2309531 | 2309531 | 2022-03-15 | Yancey | North Carolina | 37199 | 4937 | 51 |
2306278 | 2306278 | 2022-03-14 | Yancey | North Carolina | 37199 | 4932 | 51 |
2303027 | 2303027 | 2022-03-13 | Yancey | North Carolina | 37199 | 4906 | 51 |
2299775 | 2299775 | 2022-03-12 | Yancey | North Carolina | 37199 | 4906 | 51 |
2296523 | 2296523 | 2022-03-11 | Yancey | North Carolina | 37199 | 4906 | 51 |
2293271 | 2293271 | 2022-03-10 | Yancey | North Carolina | 37199 | 4890 | 51 |
2290019 | 2290019 | 2022-03-09 | Yancey | North Carolina | 37199 | 4886 | 51 |
2286767 | 2286767 | 2022-03-08 | Yancey | North Carolina | 37199 | 4880 | 51 |
2283515 | 2283515 | 2022-03-07 | Yancey | North Carolina | 37199 | 4872 | 51 |
2280263 | 2280263 | 2022-03-06 | Yancey | North Carolina | 37199 | 4855 | 51 |
2277010 | 2277010 | 2022-03-05 | Yancey | North Carolina | 37199 | 4855 | 51 |
2273757 | 2273757 | 2022-03-04 | Yancey | North Carolina | 37199 | 4855 | 51 |
2270504 | 2270504 | 2022-03-03 | Yancey | North Carolina | 37199 | 4844 | 51 |
2267252 | 2267252 | 2022-03-02 | Yancey | North Carolina | 37199 | 4824 | 51 |
2264000 | 2264000 | 2022-03-01 | Yancey | North Carolina | 37199 | 4800 | 51 |
2260749 | 2260749 | 2022-02-28 | Yancey | North Carolina | 37199 | 4794 | 51 |
2257498 | 2257498 | 2022-02-27 | Yancey | North Carolina | 37199 | 4769 | 50 |
2254247 | 2254247 | 2022-02-26 | Yancey | North Carolina | 37199 | 4769 | 50 |
2250996 | 2250996 | 2022-02-25 | Yancey | North Carolina | 37199 | 4769 | 50 |
2247745 | 2247745 | 2022-02-24 | Yancey | North Carolina | 37199 | 4755 | 50 |
2244494 | 2244494 | 2022-02-23 | Yancey | North Carolina | 37199 | 4748 | 50 |
2241243 | 2241243 | 2022-02-22 | Yancey | North Carolina | 37199 | 4745 | 50 |
2237992 | 2237992 | 2022-02-21 | Yancey | North Carolina | 37199 | 4735 | 50 |
2234741 | 2234741 | 2022-02-20 | Yancey | North Carolina | 37199 | 4709 | 50 |
2231490 | 2231490 | 2022-02-19 | Yancey | North Carolina | 37199 | 4709 | 50 |
2228239 | 2228239 | 2022-02-18 | Yancey | North Carolina | 37199 | 4709 | 50 |
2224988 | 2224988 | 2022-02-17 | Yancey | North Carolina | 37199 | 4696 | 50 |
2221737 | 2221737 | 2022-02-16 | Yancey | North Carolina | 37199 | 4679 | 50 |
2218486 | 2218486 | 2022-02-15 | Yancey | North Carolina | 37199 | 4664 | 50 |
2215235 | 2215235 | 2022-02-14 | Yancey | North Carolina | 37199 | 4663 | 50 |
2211984 | 2211984 | 2022-02-13 | Yancey | North Carolina | 37199 | 4621 | 49 |
2208731 | 2208731 | 2022-02-12 | Yancey | North Carolina | 37199 | 4621 | 49 |
2205478 | 2205478 | 2022-02-11 | Yancey | North Carolina | 37199 | 4621 | 49 |
2202225 | 2202225 | 2022-02-10 | Yancey | North Carolina | 37199 | 4602 | 49 |
2198971 | 2198971 | 2022-02-09 | Yancey | North Carolina | 37199 | 4581 | 49 |
2195717 | 2195717 | 2022-02-08 | Yancey | North Carolina | 37199 | 4548 | 49 |
2192463 | 2192463 | 2022-02-07 | Yancey | North Carolina | 37199 | 4491 | 49 |
2189209 | 2189209 | 2022-02-06 | Yancey | North Carolina | 37199 | 4439 | 48 |
2185956 | 2185956 | 2022-02-05 | Yancey | North Carolina | 37199 | 4439 | 48 |
2182704 | 2182704 | 2022-02-04 | Yancey | North Carolina | 37199 | 4439 | 48 |
2179452 | 2179452 | 2022-02-03 | Yancey | North Carolina | 37199 | 4425 | 46 |
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);