ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Alleghany" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501488 | 2501488 | 2022-05-13 | Alleghany | North Carolina | 37005 | 2981 | 16 |
2502513 | 2502513 | 2022-05-13 | Alleghany | Virginia | 51005 | 3364 | 98 |
2498230 | 2498230 | 2022-05-12 | Alleghany | North Carolina | 37005 | 2981 | 16 |
2499255 | 2499255 | 2022-05-12 | Alleghany | Virginia | 51005 | 3367 | 98 |
2494972 | 2494972 | 2022-05-11 | Alleghany | North Carolina | 37005 | 2981 | 16 |
2495997 | 2495997 | 2022-05-11 | Alleghany | Virginia | 51005 | 3364 | 98 |
2491714 | 2491714 | 2022-05-10 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2492739 | 2492739 | 2022-05-10 | Alleghany | Virginia | 51005 | 3362 | 98 |
2488456 | 2488456 | 2022-05-09 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2489481 | 2489481 | 2022-05-09 | Alleghany | Virginia | 51005 | 3363 | 98 |
2485199 | 2485199 | 2022-05-08 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2486224 | 2486224 | 2022-05-08 | Alleghany | Virginia | 51005 | 3363 | 98 |
2481941 | 2481941 | 2022-05-07 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2482966 | 2482966 | 2022-05-07 | Alleghany | Virginia | 51005 | 3363 | 98 |
2478683 | 2478683 | 2022-05-06 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2479708 | 2479708 | 2022-05-06 | Alleghany | Virginia | 51005 | 3363 | 98 |
2475425 | 2475425 | 2022-05-05 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2476450 | 2476450 | 2022-05-05 | Alleghany | Virginia | 51005 | 3365 | 98 |
2472168 | 2472168 | 2022-05-04 | Alleghany | North Carolina | 37005 | 2966 | 16 |
2473192 | 2473192 | 2022-05-04 | Alleghany | Virginia | 51005 | 3370 | 98 |
2468912 | 2468912 | 2022-05-03 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2469936 | 2469936 | 2022-05-03 | Alleghany | Virginia | 51005 | 3372 | 98 |
2465656 | 2465656 | 2022-05-02 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2466680 | 2466680 | 2022-05-02 | Alleghany | Virginia | 51005 | 3372 | 98 |
2462401 | 2462401 | 2022-05-01 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2463425 | 2463425 | 2022-05-01 | Alleghany | Virginia | 51005 | 3375 | 98 |
2459145 | 2459145 | 2022-04-30 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2460169 | 2460169 | 2022-04-30 | Alleghany | Virginia | 51005 | 3375 | 98 |
2455889 | 2455889 | 2022-04-29 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2456913 | 2456913 | 2022-04-29 | Alleghany | Virginia | 51005 | 3375 | 98 |
2452633 | 2452633 | 2022-04-28 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2453657 | 2453657 | 2022-04-28 | Alleghany | Virginia | 51005 | 3377 | 98 |
2449377 | 2449377 | 2022-04-27 | Alleghany | North Carolina | 37005 | 2957 | 12 |
2450401 | 2450401 | 2022-04-27 | Alleghany | Virginia | 51005 | 3378 | 98 |
2446120 | 2446120 | 2022-04-26 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2447144 | 2447144 | 2022-04-26 | Alleghany | Virginia | 51005 | 3376 | 98 |
2442865 | 2442865 | 2022-04-25 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2443889 | 2443889 | 2022-04-25 | Alleghany | Virginia | 51005 | 3378 | 98 |
2439609 | 2439609 | 2022-04-24 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2440633 | 2440633 | 2022-04-24 | Alleghany | Virginia | 51005 | 3380 | 98 |
2436353 | 2436353 | 2022-04-23 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2437377 | 2437377 | 2022-04-23 | Alleghany | Virginia | 51005 | 3380 | 98 |
2433097 | 2433097 | 2022-04-22 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2434121 | 2434121 | 2022-04-22 | Alleghany | Virginia | 51005 | 3380 | 98 |
2429841 | 2429841 | 2022-04-21 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2430865 | 2430865 | 2022-04-21 | Alleghany | Virginia | 51005 | 3382 | 98 |
2426585 | 2426585 | 2022-04-20 | Alleghany | North Carolina | 37005 | 2953 | 12 |
2427609 | 2427609 | 2022-04-20 | Alleghany | Virginia | 51005 | 3383 | 98 |
2423329 | 2423329 | 2022-04-19 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2424353 | 2424353 | 2022-04-19 | Alleghany | Virginia | 51005 | 3386 | 98 |
2420072 | 2420072 | 2022-04-18 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2421097 | 2421097 | 2022-04-18 | Alleghany | Virginia | 51005 | 3387 | 98 |
2416817 | 2416817 | 2022-04-17 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2417841 | 2417841 | 2022-04-17 | Alleghany | Virginia | 51005 | 3388 | 98 |
2413561 | 2413561 | 2022-04-16 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2414585 | 2414585 | 2022-04-16 | Alleghany | Virginia | 51005 | 3388 | 98 |
2410305 | 2410305 | 2022-04-15 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2411329 | 2411329 | 2022-04-15 | Alleghany | Virginia | 51005 | 3388 | 98 |
2407049 | 2407049 | 2022-04-14 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2408073 | 2408073 | 2022-04-14 | Alleghany | Virginia | 51005 | 3388 | 97 |
2403793 | 2403793 | 2022-04-13 | Alleghany | North Carolina | 37005 | 2951 | 12 |
2404817 | 2404817 | 2022-04-13 | Alleghany | Virginia | 51005 | 3389 | 96 |
2400538 | 2400538 | 2022-04-12 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2401562 | 2401562 | 2022-04-12 | Alleghany | Virginia | 51005 | 3389 | 95 |
2397283 | 2397283 | 2022-04-11 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2398307 | 2398307 | 2022-04-11 | Alleghany | Virginia | 51005 | 3391 | 95 |
2394028 | 2394028 | 2022-04-10 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2395052 | 2395052 | 2022-04-10 | Alleghany | Virginia | 51005 | 3391 | 94 |
2390772 | 2390772 | 2022-04-09 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2391796 | 2391796 | 2022-04-09 | Alleghany | Virginia | 51005 | 3391 | 94 |
2387516 | 2387516 | 2022-04-08 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2388540 | 2388540 | 2022-04-08 | Alleghany | Virginia | 51005 | 3391 | 94 |
2384261 | 2384261 | 2022-04-07 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2385285 | 2385285 | 2022-04-07 | Alleghany | Virginia | 51005 | 3393 | 93 |
2381006 | 2381006 | 2022-04-06 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2382030 | 2382030 | 2022-04-06 | Alleghany | Virginia | 51005 | 3395 | 93 |
2377751 | 2377751 | 2022-04-05 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2378775 | 2378775 | 2022-04-05 | Alleghany | Virginia | 51005 | 3394 | 93 |
2374498 | 2374498 | 2022-04-04 | Alleghany | North Carolina | 37005 | 2948 | 12 |
2375521 | 2375521 | 2022-04-04 | Alleghany | Virginia | 51005 | 3393 | 93 |
2371246 | 2371246 | 2022-04-03 | Alleghany | North Carolina | 37005 | 2946 | 12 |
2372269 | 2372269 | 2022-04-03 | Alleghany | Virginia | 51005 | 3403 | 93 |
2367993 | 2367993 | 2022-04-02 | Alleghany | North Carolina | 37005 | 2946 | 12 |
2369016 | 2369016 | 2022-04-02 | Alleghany | Virginia | 51005 | 3403 | 93 |
2364740 | 2364740 | 2022-04-01 | Alleghany | North Carolina | 37005 | 2946 | 12 |
2365763 | 2365763 | 2022-04-01 | Alleghany | Virginia | 51005 | 3403 | 93 |
2361486 | 2361486 | 2022-03-31 | Alleghany | North Carolina | 37005 | 2946 | 12 |
2362510 | 2362510 | 2022-03-31 | Alleghany | Virginia | 51005 | 3422 | 93 |
2358232 | 2358232 | 2022-03-30 | Alleghany | North Carolina | 37005 | 2944 | 12 |
2359256 | 2359256 | 2022-03-30 | Alleghany | Virginia | 51005 | 3443 | 93 |
2354978 | 2354978 | 2022-03-29 | Alleghany | North Carolina | 37005 | 2941 | 12 |
2356002 | 2356002 | 2022-03-29 | Alleghany | Virginia | 51005 | 3450 | 93 |
2351725 | 2351725 | 2022-03-28 | Alleghany | North Carolina | 37005 | 2941 | 12 |
2352749 | 2352749 | 2022-03-28 | Alleghany | Virginia | 51005 | 3468 | 93 |
2348473 | 2348473 | 2022-03-27 | Alleghany | North Carolina | 37005 | 2939 | 12 |
2349497 | 2349497 | 2022-03-27 | Alleghany | Virginia | 51005 | 3475 | 94 |
2345220 | 2345220 | 2022-03-26 | Alleghany | North Carolina | 37005 | 2939 | 12 |
2346244 | 2346244 | 2022-03-26 | Alleghany | Virginia | 51005 | 3475 | 94 |
2341967 | 2341967 | 2022-03-25 | Alleghany | North Carolina | 37005 | 2939 | 12 |
2342991 | 2342991 | 2022-03-25 | Alleghany | Virginia | 51005 | 3475 | 94 |
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);