ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,148 rows where deaths = 7 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Goochland 185
- Falls Church city 147
- Norton city 142
- Fairfax city 96
- Bristol city 85
- King and Queen 84
- Highland 74
- Greensville 64
- Prince George 64
- Manassas Park city 62
- Amelia 50
- Rappahannock 48
- Hopewell city 44
- New Kent 42
- Brunswick 36
- Powhatan 34
- Wythe 33
- Appomattox 30
- Augusta 28
- Richmond 28
- Orange 25
- Radford city 25
- Roanoke 25
- Poquoson city 23
- Botetourt 22
- Charles City 21
- Halifax 21
- Gloucester 20
- Sussex 20
- Lee 19
- …
state 1
- Virginia · 2,148 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502570 | 2502570 | 2022-05-13 | Highland | Virginia | 51091 | 387 | 7 |
2499312 | 2499312 | 2022-05-12 | Highland | Virginia | 51091 | 387 | 7 |
2496054 | 2496054 | 2022-05-11 | Highland | Virginia | 51091 | 384 | 7 |
2492796 | 2492796 | 2022-05-10 | Highland | Virginia | 51091 | 384 | 7 |
2489538 | 2489538 | 2022-05-09 | Highland | Virginia | 51091 | 382 | 7 |
2486281 | 2486281 | 2022-05-08 | Highland | Virginia | 51091 | 381 | 7 |
2483023 | 2483023 | 2022-05-07 | Highland | Virginia | 51091 | 381 | 7 |
2479765 | 2479765 | 2022-05-06 | Highland | Virginia | 51091 | 381 | 7 |
2476507 | 2476507 | 2022-05-05 | Highland | Virginia | 51091 | 378 | 7 |
2473249 | 2473249 | 2022-05-04 | Highland | Virginia | 51091 | 378 | 7 |
2469993 | 2469993 | 2022-05-03 | Highland | Virginia | 51091 | 377 | 7 |
2466737 | 2466737 | 2022-05-02 | Highland | Virginia | 51091 | 377 | 7 |
2463482 | 2463482 | 2022-05-01 | Highland | Virginia | 51091 | 375 | 7 |
2460226 | 2460226 | 2022-04-30 | Highland | Virginia | 51091 | 375 | 7 |
2456970 | 2456970 | 2022-04-29 | Highland | Virginia | 51091 | 375 | 7 |
2453714 | 2453714 | 2022-04-28 | Highland | Virginia | 51091 | 372 | 7 |
2450458 | 2450458 | 2022-04-27 | Highland | Virginia | 51091 | 367 | 7 |
2447201 | 2447201 | 2022-04-26 | Highland | Virginia | 51091 | 367 | 7 |
2443946 | 2443946 | 2022-04-25 | Highland | Virginia | 51091 | 367 | 7 |
2440690 | 2440690 | 2022-04-24 | Highland | Virginia | 51091 | 366 | 7 |
2437434 | 2437434 | 2022-04-23 | Highland | Virginia | 51091 | 366 | 7 |
2434178 | 2434178 | 2022-04-22 | Highland | Virginia | 51091 | 366 | 7 |
2430922 | 2430922 | 2022-04-21 | Highland | Virginia | 51091 | 366 | 7 |
2427666 | 2427666 | 2022-04-20 | Highland | Virginia | 51091 | 365 | 7 |
2424410 | 2424410 | 2022-04-19 | Highland | Virginia | 51091 | 366 | 7 |
2421154 | 2421154 | 2022-04-18 | Highland | Virginia | 51091 | 366 | 7 |
2417898 | 2417898 | 2022-04-17 | Highland | Virginia | 51091 | 366 | 7 |
2414642 | 2414642 | 2022-04-16 | Highland | Virginia | 51091 | 366 | 7 |
2411386 | 2411386 | 2022-04-15 | Highland | Virginia | 51091 | 366 | 7 |
2408130 | 2408130 | 2022-04-14 | Highland | Virginia | 51091 | 366 | 7 |
2404874 | 2404874 | 2022-04-13 | Highland | Virginia | 51091 | 366 | 7 |
2401619 | 2401619 | 2022-04-12 | Highland | Virginia | 51091 | 365 | 7 |
2398364 | 2398364 | 2022-04-11 | Highland | Virginia | 51091 | 365 | 7 |
2395109 | 2395109 | 2022-04-10 | Highland | Virginia | 51091 | 365 | 7 |
2391853 | 2391853 | 2022-04-09 | Highland | Virginia | 51091 | 365 | 7 |
2388597 | 2388597 | 2022-04-08 | Highland | Virginia | 51091 | 365 | 7 |
2385342 | 2385342 | 2022-04-07 | Highland | Virginia | 51091 | 365 | 7 |
2382087 | 2382087 | 2022-04-06 | Highland | Virginia | 51091 | 365 | 7 |
2378832 | 2378832 | 2022-04-05 | Highland | Virginia | 51091 | 365 | 7 |
2375578 | 2375578 | 2022-04-04 | Highland | Virginia | 51091 | 365 | 7 |
2372326 | 2372326 | 2022-04-03 | Highland | Virginia | 51091 | 365 | 7 |
2369073 | 2369073 | 2022-04-02 | Highland | Virginia | 51091 | 365 | 7 |
2365820 | 2365820 | 2022-04-01 | Highland | Virginia | 51091 | 365 | 7 |
2362567 | 2362567 | 2022-03-31 | Highland | Virginia | 51091 | 365 | 7 |
2359313 | 2359313 | 2022-03-30 | Highland | Virginia | 51091 | 365 | 7 |
2356059 | 2356059 | 2022-03-29 | Highland | Virginia | 51091 | 364 | 7 |
2352806 | 2352806 | 2022-03-28 | Highland | Virginia | 51091 | 364 | 7 |
2349554 | 2349554 | 2022-03-27 | Highland | Virginia | 51091 | 364 | 7 |
2346301 | 2346301 | 2022-03-26 | Highland | Virginia | 51091 | 364 | 7 |
2343048 | 2343048 | 2022-03-25 | Highland | Virginia | 51091 | 364 | 7 |
2339795 | 2339795 | 2022-03-24 | Highland | Virginia | 51091 | 362 | 7 |
2336541 | 2336541 | 2022-03-23 | Highland | Virginia | 51091 | 362 | 7 |
2333287 | 2333287 | 2022-03-22 | Highland | Virginia | 51091 | 362 | 7 |
2330034 | 2330034 | 2022-03-21 | Highland | Virginia | 51091 | 362 | 7 |
2326782 | 2326782 | 2022-03-20 | Highland | Virginia | 51091 | 362 | 7 |
2323529 | 2323529 | 2022-03-19 | Highland | Virginia | 51091 | 362 | 7 |
2320275 | 2320275 | 2022-03-18 | Highland | Virginia | 51091 | 362 | 7 |
2317021 | 2317021 | 2022-03-17 | Highland | Virginia | 51091 | 362 | 7 |
2313768 | 2313768 | 2022-03-16 | Highland | Virginia | 51091 | 362 | 7 |
2310515 | 2310515 | 2022-03-15 | Highland | Virginia | 51091 | 362 | 7 |
2307262 | 2307262 | 2022-03-14 | Highland | Virginia | 51091 | 362 | 7 |
2304011 | 2304011 | 2022-03-13 | Highland | Virginia | 51091 | 361 | 7 |
2300759 | 2300759 | 2022-03-12 | Highland | Virginia | 51091 | 361 | 7 |
2297507 | 2297507 | 2022-03-11 | Highland | Virginia | 51091 | 361 | 7 |
2294255 | 2294255 | 2022-03-10 | Highland | Virginia | 51091 | 361 | 7 |
2291003 | 2291003 | 2022-03-09 | Highland | Virginia | 51091 | 359 | 7 |
2287751 | 2287751 | 2022-03-08 | Highland | Virginia | 51091 | 359 | 7 |
2284499 | 2284499 | 2022-03-07 | Highland | Virginia | 51091 | 359 | 7 |
2281247 | 2281247 | 2022-03-06 | Highland | Virginia | 51091 | 358 | 7 |
2277994 | 2277994 | 2022-03-05 | Highland | Virginia | 51091 | 358 | 7 |
2274741 | 2274741 | 2022-03-04 | Highland | Virginia | 51091 | 358 | 7 |
2271488 | 2271488 | 2022-03-03 | Highland | Virginia | 51091 | 358 | 7 |
2268236 | 2268236 | 2022-03-02 | Highland | Virginia | 51091 | 357 | 7 |
2264983 | 2264983 | 2022-03-01 | Highland | Virginia | 51091 | 357 | 7 |
2173975 | 2173975 | 2022-02-01 | Rappahannock | Virginia | 51157 | 884 | 7 |
2170723 | 2170723 | 2022-01-31 | Rappahannock | Virginia | 51157 | 881 | 7 |
2167470 | 2167470 | 2022-01-30 | Rappahannock | Virginia | 51157 | 875 | 7 |
2164215 | 2164215 | 2022-01-29 | Rappahannock | Virginia | 51157 | 875 | 7 |
2160960 | 2160960 | 2022-01-28 | Rappahannock | Virginia | 51157 | 875 | 7 |
2157704 | 2157704 | 2022-01-27 | Rappahannock | Virginia | 51157 | 872 | 7 |
2154451 | 2154451 | 2022-01-26 | Rappahannock | Virginia | 51157 | 868 | 7 |
2151198 | 2151198 | 2022-01-25 | Rappahannock | Virginia | 51157 | 863 | 7 |
2147946 | 2147946 | 2022-01-24 | Rappahannock | Virginia | 51157 | 861 | 7 |
2144693 | 2144693 | 2022-01-23 | Rappahannock | Virginia | 51157 | 840 | 7 |
2141438 | 2141438 | 2022-01-22 | Rappahannock | Virginia | 51157 | 840 | 7 |
2138182 | 2138182 | 2022-01-21 | Rappahannock | Virginia | 51157 | 840 | 7 |
2134928 | 2134928 | 2022-01-20 | Rappahannock | Virginia | 51157 | 833 | 7 |
2131676 | 2131676 | 2022-01-19 | Rappahannock | Virginia | 51157 | 831 | 7 |
2128422 | 2128422 | 2022-01-18 | Rappahannock | Virginia | 51157 | 817 | 7 |
2125169 | 2125169 | 2022-01-17 | Rappahannock | Virginia | 51157 | 812 | 7 |
2121917 | 2121917 | 2022-01-16 | Rappahannock | Virginia | 51157 | 804 | 7 |
2118665 | 2118665 | 2022-01-15 | Rappahannock | Virginia | 51157 | 804 | 7 |
2115413 | 2115413 | 2022-01-14 | Rappahannock | Virginia | 51157 | 804 | 7 |
2112161 | 2112161 | 2022-01-13 | Rappahannock | Virginia | 51157 | 799 | 7 |
2108909 | 2108909 | 2022-01-12 | Rappahannock | Virginia | 51157 | 794 | 7 |
2105658 | 2105658 | 2022-01-11 | Rappahannock | Virginia | 51157 | 791 | 7 |
2102407 | 2102407 | 2022-01-10 | Rappahannock | Virginia | 51157 | 788 | 7 |
2099156 | 2099156 | 2022-01-09 | Rappahannock | Virginia | 51157 | 762 | 7 |
2095905 | 2095905 | 2022-01-08 | Rappahannock | Virginia | 51157 | 762 | 7 |
2092653 | 2092653 | 2022-01-07 | Rappahannock | Virginia | 51157 | 762 | 7 |
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);