ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Shenandoah", fips = 51171 and state = "Virginia" 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 |
---|---|---|---|---|---|---|---|
2502623 | 2502623 | 2022-05-13 | Shenandoah | Virginia | 51171 | 10936 | 222 |
2499365 | 2499365 | 2022-05-12 | Shenandoah | Virginia | 51171 | 10929 | 222 |
2496107 | 2496107 | 2022-05-11 | Shenandoah | Virginia | 51171 | 10919 | 222 |
2492849 | 2492849 | 2022-05-10 | Shenandoah | Virginia | 51171 | 10908 | 222 |
2489591 | 2489591 | 2022-05-09 | Shenandoah | Virginia | 51171 | 10907 | 222 |
2486334 | 2486334 | 2022-05-08 | Shenandoah | Virginia | 51171 | 10895 | 222 |
2483076 | 2483076 | 2022-05-07 | Shenandoah | Virginia | 51171 | 10895 | 222 |
2479818 | 2479818 | 2022-05-06 | Shenandoah | Virginia | 51171 | 10895 | 222 |
2476560 | 2476560 | 2022-05-05 | Shenandoah | Virginia | 51171 | 10882 | 222 |
2473302 | 2473302 | 2022-05-04 | Shenandoah | Virginia | 51171 | 10873 | 222 |
2470046 | 2470046 | 2022-05-03 | Shenandoah | Virginia | 51171 | 10867 | 222 |
2466790 | 2466790 | 2022-05-02 | Shenandoah | Virginia | 51171 | 10866 | 222 |
2463535 | 2463535 | 2022-05-01 | Shenandoah | Virginia | 51171 | 10854 | 222 |
2460279 | 2460279 | 2022-04-30 | Shenandoah | Virginia | 51171 | 10854 | 222 |
2457023 | 2457023 | 2022-04-29 | Shenandoah | Virginia | 51171 | 10854 | 222 |
2453767 | 2453767 | 2022-04-28 | Shenandoah | Virginia | 51171 | 10847 | 221 |
2450511 | 2450511 | 2022-04-27 | Shenandoah | Virginia | 51171 | 10840 | 221 |
2447254 | 2447254 | 2022-04-26 | Shenandoah | Virginia | 51171 | 10840 | 221 |
2443999 | 2443999 | 2022-04-25 | Shenandoah | Virginia | 51171 | 10836 | 222 |
2440743 | 2440743 | 2022-04-24 | Shenandoah | Virginia | 51171 | 10825 | 222 |
2437487 | 2437487 | 2022-04-23 | Shenandoah | Virginia | 51171 | 10825 | 222 |
2434231 | 2434231 | 2022-04-22 | Shenandoah | Virginia | 51171 | 10825 | 222 |
2430975 | 2430975 | 2022-04-21 | Shenandoah | Virginia | 51171 | 10823 | 222 |
2427719 | 2427719 | 2022-04-20 | Shenandoah | Virginia | 51171 | 10822 | 222 |
2424463 | 2424463 | 2022-04-19 | Shenandoah | Virginia | 51171 | 10822 | 222 |
2421207 | 2421207 | 2022-04-18 | Shenandoah | Virginia | 51171 | 10817 | 222 |
2417951 | 2417951 | 2022-04-17 | Shenandoah | Virginia | 51171 | 10806 | 222 |
2414695 | 2414695 | 2022-04-16 | Shenandoah | Virginia | 51171 | 10806 | 222 |
2411439 | 2411439 | 2022-04-15 | Shenandoah | Virginia | 51171 | 10806 | 222 |
2408183 | 2408183 | 2022-04-14 | Shenandoah | Virginia | 51171 | 10805 | 222 |
2404927 | 2404927 | 2022-04-13 | Shenandoah | Virginia | 51171 | 10801 | 222 |
2401672 | 2401672 | 2022-04-12 | Shenandoah | Virginia | 51171 | 10797 | 221 |
2398417 | 2398417 | 2022-04-11 | Shenandoah | Virginia | 51171 | 10794 | 221 |
2395162 | 2395162 | 2022-04-10 | Shenandoah | Virginia | 51171 | 10789 | 221 |
2391906 | 2391906 | 2022-04-09 | Shenandoah | Virginia | 51171 | 10789 | 221 |
2388650 | 2388650 | 2022-04-08 | Shenandoah | Virginia | 51171 | 10789 | 221 |
2385395 | 2385395 | 2022-04-07 | Shenandoah | Virginia | 51171 | 10787 | 221 |
2382140 | 2382140 | 2022-04-06 | Shenandoah | Virginia | 51171 | 10783 | 221 |
2378885 | 2378885 | 2022-04-05 | Shenandoah | Virginia | 51171 | 10785 | 221 |
2375631 | 2375631 | 2022-04-04 | Shenandoah | Virginia | 51171 | 10790 | 221 |
2372379 | 2372379 | 2022-04-03 | Shenandoah | Virginia | 51171 | 10790 | 221 |
2369126 | 2369126 | 2022-04-02 | Shenandoah | Virginia | 51171 | 10790 | 221 |
2365873 | 2365873 | 2022-04-01 | Shenandoah | Virginia | 51171 | 10790 | 221 |
2362620 | 2362620 | 2022-03-31 | Shenandoah | Virginia | 51171 | 10793 | 221 |
2359366 | 2359366 | 2022-03-30 | Shenandoah | Virginia | 51171 | 10793 | 221 |
2356112 | 2356112 | 2022-03-29 | Shenandoah | Virginia | 51171 | 10790 | 221 |
2352859 | 2352859 | 2022-03-28 | Shenandoah | Virginia | 51171 | 10785 | 221 |
2349607 | 2349607 | 2022-03-27 | Shenandoah | Virginia | 51171 | 10780 | 221 |
2346354 | 2346354 | 2022-03-26 | Shenandoah | Virginia | 51171 | 10780 | 221 |
2343101 | 2343101 | 2022-03-25 | Shenandoah | Virginia | 51171 | 10780 | 221 |
2339848 | 2339848 | 2022-03-24 | Shenandoah | Virginia | 51171 | 10779 | 221 |
2336594 | 2336594 | 2022-03-23 | Shenandoah | Virginia | 51171 | 10777 | 221 |
2333340 | 2333340 | 2022-03-22 | Shenandoah | Virginia | 51171 | 10779 | 221 |
2330087 | 2330087 | 2022-03-21 | Shenandoah | Virginia | 51171 | 10779 | 221 |
2326835 | 2326835 | 2022-03-20 | Shenandoah | Virginia | 51171 | 10769 | 220 |
2323582 | 2323582 | 2022-03-19 | Shenandoah | Virginia | 51171 | 10769 | 220 |
2320328 | 2320328 | 2022-03-18 | Shenandoah | Virginia | 51171 | 10769 | 220 |
2317074 | 2317074 | 2022-03-17 | Shenandoah | Virginia | 51171 | 10762 | 220 |
2313821 | 2313821 | 2022-03-16 | Shenandoah | Virginia | 51171 | 10759 | 220 |
2310568 | 2310568 | 2022-03-15 | Shenandoah | Virginia | 51171 | 10754 | 220 |
2307315 | 2307315 | 2022-03-14 | Shenandoah | Virginia | 51171 | 10752 | 220 |
2304064 | 2304064 | 2022-03-13 | Shenandoah | Virginia | 51171 | 10743 | 219 |
2300812 | 2300812 | 2022-03-12 | Shenandoah | Virginia | 51171 | 10743 | 219 |
2297560 | 2297560 | 2022-03-11 | Shenandoah | Virginia | 51171 | 10743 | 219 |
2294308 | 2294308 | 2022-03-10 | Shenandoah | Virginia | 51171 | 10738 | 219 |
2291056 | 2291056 | 2022-03-09 | Shenandoah | Virginia | 51171 | 10731 | 219 |
2287804 | 2287804 | 2022-03-08 | Shenandoah | Virginia | 51171 | 10727 | 219 |
2284552 | 2284552 | 2022-03-07 | Shenandoah | Virginia | 51171 | 10722 | 219 |
2281300 | 2281300 | 2022-03-06 | Shenandoah | Virginia | 51171 | 10702 | 219 |
2278047 | 2278047 | 2022-03-05 | Shenandoah | Virginia | 51171 | 10702 | 219 |
2274794 | 2274794 | 2022-03-04 | Shenandoah | Virginia | 51171 | 10702 | 219 |
2271541 | 2271541 | 2022-03-03 | Shenandoah | Virginia | 51171 | 10699 | 219 |
2268289 | 2268289 | 2022-03-02 | Shenandoah | Virginia | 51171 | 10695 | 219 |
2265036 | 2265036 | 2022-03-01 | Shenandoah | Virginia | 51171 | 10688 | 219 |
2261786 | 2261786 | 2022-02-28 | Shenandoah | Virginia | 51171 | 10681 | 219 |
2258535 | 2258535 | 2022-02-27 | Shenandoah | Virginia | 51171 | 10670 | 219 |
2255284 | 2255284 | 2022-02-26 | Shenandoah | Virginia | 51171 | 10670 | 219 |
2252033 | 2252033 | 2022-02-25 | Shenandoah | Virginia | 51171 | 10670 | 219 |
2248782 | 2248782 | 2022-02-24 | Shenandoah | Virginia | 51171 | 10660 | 219 |
2245531 | 2245531 | 2022-02-23 | Shenandoah | Virginia | 51171 | 10650 | 217 |
2242280 | 2242280 | 2022-02-22 | Shenandoah | Virginia | 51171 | 10641 | 217 |
2239029 | 2239029 | 2022-02-21 | Shenandoah | Virginia | 51171 | 10622 | 217 |
2235778 | 2235778 | 2022-02-20 | Shenandoah | Virginia | 51171 | 10577 | 217 |
2232527 | 2232527 | 2022-02-19 | Shenandoah | Virginia | 51171 | 10577 | 217 |
2229276 | 2229276 | 2022-02-18 | Shenandoah | Virginia | 51171 | 10577 | 217 |
2226025 | 2226025 | 2022-02-17 | Shenandoah | Virginia | 51171 | 10552 | 216 |
2222774 | 2222774 | 2022-02-16 | Shenandoah | Virginia | 51171 | 10529 | 215 |
2219523 | 2219523 | 2022-02-15 | Shenandoah | Virginia | 51171 | 10515 | 215 |
2216273 | 2216273 | 2022-02-14 | Shenandoah | Virginia | 51171 | 10497 | 215 |
2213022 | 2213022 | 2022-02-13 | Shenandoah | Virginia | 51171 | 10457 | 214 |
2209769 | 2209769 | 2022-02-12 | Shenandoah | Virginia | 51171 | 10457 | 214 |
2206516 | 2206516 | 2022-02-11 | Shenandoah | Virginia | 51171 | 10457 | 214 |
2203263 | 2203263 | 2022-02-10 | Shenandoah | Virginia | 51171 | 10440 | 213 |
2200009 | 2200009 | 2022-02-09 | Shenandoah | Virginia | 51171 | 10413 | 212 |
2196755 | 2196755 | 2022-02-08 | Shenandoah | Virginia | 51171 | 10389 | 211 |
2193500 | 2193500 | 2022-02-07 | Shenandoah | Virginia | 51171 | 10368 | 210 |
2190247 | 2190247 | 2022-02-06 | Shenandoah | Virginia | 51171 | 10295 | 203 |
2186994 | 2186994 | 2022-02-05 | Shenandoah | Virginia | 51171 | 10295 | 203 |
2183741 | 2183741 | 2022-02-04 | Shenandoah | Virginia | 51171 | 10295 | 203 |
2180489 | 2180489 | 2022-02-03 | Shenandoah | Virginia | 51171 | 10269 | 199 |
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);