ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
297 rows where deaths = 84 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Orange 21
- Wise 20
- Amherst 18
- Scott 15
- Caroline 14
- Dinwiddie 14
- Franklin 14
- Norfolk city 12
- Petersburg city 12
- York 11
- Campbell 10
- Accomack 9
- Louisa 8
- Carroll 7
- Hampton city 7
- Mecklenburg 7
- Montgomery 7
- Staunton city 7
- Buchanan 6
- Martinsville city 6
- Russell 6
- Alleghany 5
- Gloucester 5
- Smyth 5
- Warren 5
- Augusta 4
- Page 4
- Salem city 4
- Loudoun 3
- Nottoway 3
- …
state 1
- Virginia · 297 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466748 | 2466748 | 2022-05-02 | Louisa | Virginia | 51109 | 6750 | 84 |
2463441 | 2463441 | 2022-05-01 | Caroline | Virginia | 51033 | 6862 | 84 |
2463493 | 2463493 | 2022-05-01 | Louisa | Virginia | 51109 | 6740 | 84 |
2460185 | 2460185 | 2022-04-30 | Caroline | Virginia | 51033 | 6862 | 84 |
2460237 | 2460237 | 2022-04-30 | Louisa | Virginia | 51109 | 6740 | 84 |
2456929 | 2456929 | 2022-04-29 | Caroline | Virginia | 51033 | 6862 | 84 |
2456981 | 2456981 | 2022-04-29 | Louisa | Virginia | 51109 | 6740 | 84 |
2453673 | 2453673 | 2022-04-28 | Caroline | Virginia | 51033 | 6856 | 84 |
2453725 | 2453725 | 2022-04-28 | Louisa | Virginia | 51109 | 6736 | 84 |
2450417 | 2450417 | 2022-04-27 | Caroline | Virginia | 51033 | 6850 | 84 |
2450469 | 2450469 | 2022-04-27 | Louisa | Virginia | 51109 | 6734 | 84 |
2447160 | 2447160 | 2022-04-26 | Caroline | Virginia | 51033 | 6849 | 84 |
2447212 | 2447212 | 2022-04-26 | Louisa | Virginia | 51109 | 6729 | 84 |
2443905 | 2443905 | 2022-04-25 | Caroline | Virginia | 51033 | 6843 | 84 |
2443957 | 2443957 | 2022-04-25 | Louisa | Virginia | 51109 | 6724 | 84 |
2440649 | 2440649 | 2022-04-24 | Caroline | Virginia | 51033 | 6838 | 84 |
2437393 | 2437393 | 2022-04-23 | Caroline | Virginia | 51033 | 6838 | 84 |
2434137 | 2434137 | 2022-04-22 | Caroline | Virginia | 51033 | 6838 | 84 |
2430881 | 2430881 | 2022-04-21 | Caroline | Virginia | 51033 | 6836 | 84 |
2427625 | 2427625 | 2022-04-20 | Caroline | Virginia | 51033 | 6837 | 84 |
2424369 | 2424369 | 2022-04-19 | Caroline | Virginia | 51033 | 6840 | 84 |
2421113 | 2421113 | 2022-04-18 | Caroline | Virginia | 51033 | 6836 | 84 |
2404904 | 2404904 | 2022-04-13 | Orange | Virginia | 51137 | 6807 | 84 |
2401649 | 2401649 | 2022-04-12 | Orange | Virginia | 51137 | 6803 | 84 |
2398394 | 2398394 | 2022-04-11 | Orange | Virginia | 51137 | 6798 | 84 |
2395139 | 2395139 | 2022-04-10 | Orange | Virginia | 51137 | 6788 | 84 |
2391883 | 2391883 | 2022-04-09 | Orange | Virginia | 51137 | 6788 | 84 |
2388627 | 2388627 | 2022-04-08 | Orange | Virginia | 51137 | 6788 | 84 |
2349499 | 2349499 | 2022-03-27 | Amherst | Virginia | 51009 | 7179 | 84 |
2346246 | 2346246 | 2022-03-26 | Amherst | Virginia | 51009 | 7179 | 84 |
2342993 | 2342993 | 2022-03-25 | Amherst | Virginia | 51009 | 7179 | 84 |
2339740 | 2339740 | 2022-03-24 | Amherst | Virginia | 51009 | 7176 | 84 |
2336486 | 2336486 | 2022-03-23 | Amherst | Virginia | 51009 | 7176 | 84 |
2333232 | 2333232 | 2022-03-22 | Amherst | Virginia | 51009 | 7170 | 84 |
2329979 | 2329979 | 2022-03-21 | Amherst | Virginia | 51009 | 7170 | 84 |
2326727 | 2326727 | 2022-03-20 | Amherst | Virginia | 51009 | 7166 | 84 |
2326756 | 2326756 | 2022-03-20 | Dinwiddie | Virginia | 51053 | 5273 | 84 |
2323474 | 2323474 | 2022-03-19 | Amherst | Virginia | 51009 | 7166 | 84 |
2323503 | 2323503 | 2022-03-19 | Dinwiddie | Virginia | 51053 | 5273 | 84 |
2320220 | 2320220 | 2022-03-18 | Amherst | Virginia | 51009 | 7166 | 84 |
2320249 | 2320249 | 2022-03-18 | Dinwiddie | Virginia | 51053 | 5273 | 84 |
2316966 | 2316966 | 2022-03-17 | Amherst | Virginia | 51009 | 7147 | 84 |
2316995 | 2316995 | 2022-03-17 | Dinwiddie | Virginia | 51053 | 5271 | 84 |
2313713 | 2313713 | 2022-03-16 | Amherst | Virginia | 51009 | 7128 | 84 |
2313742 | 2313742 | 2022-03-16 | Dinwiddie | Virginia | 51053 | 5266 | 84 |
2310460 | 2310460 | 2022-03-15 | Amherst | Virginia | 51009 | 7096 | 84 |
2310489 | 2310489 | 2022-03-15 | Dinwiddie | Virginia | 51053 | 5262 | 84 |
2310545 | 2310545 | 2022-03-15 | Orange | Virginia | 51137 | 6852 | 84 |
2307207 | 2307207 | 2022-03-14 | Amherst | Virginia | 51009 | 7073 | 84 |
2307236 | 2307236 | 2022-03-14 | Dinwiddie | Virginia | 51053 | 5258 | 84 |
2307292 | 2307292 | 2022-03-14 | Orange | Virginia | 51137 | 6840 | 84 |
2303956 | 2303956 | 2022-03-13 | Amherst | Virginia | 51009 | 7052 | 84 |
2303985 | 2303985 | 2022-03-13 | Dinwiddie | Virginia | 51053 | 5255 | 84 |
2304041 | 2304041 | 2022-03-13 | Orange | Virginia | 51137 | 6847 | 84 |
2300704 | 2300704 | 2022-03-12 | Amherst | Virginia | 51009 | 7052 | 84 |
2300733 | 2300733 | 2022-03-12 | Dinwiddie | Virginia | 51053 | 5255 | 84 |
2300789 | 2300789 | 2022-03-12 | Orange | Virginia | 51137 | 6847 | 84 |
2297452 | 2297452 | 2022-03-11 | Amherst | Virginia | 51009 | 7052 | 84 |
2297481 | 2297481 | 2022-03-11 | Dinwiddie | Virginia | 51053 | 5255 | 84 |
2297537 | 2297537 | 2022-03-11 | Orange | Virginia | 51137 | 6847 | 84 |
2294200 | 2294200 | 2022-03-10 | Amherst | Virginia | 51009 | 7041 | 84 |
2294229 | 2294229 | 2022-03-10 | Dinwiddie | Virginia | 51053 | 5243 | 84 |
2290977 | 2290977 | 2022-03-09 | Dinwiddie | Virginia | 51053 | 5239 | 84 |
2287725 | 2287725 | 2022-03-08 | Dinwiddie | Virginia | 51053 | 5228 | 84 |
2284473 | 2284473 | 2022-03-07 | Dinwiddie | Virginia | 51053 | 5223 | 84 |
2281276 | 2281276 | 2022-03-06 | Nottoway | Virginia | 51135 | 3962 | 84 |
2278023 | 2278023 | 2022-03-05 | Nottoway | Virginia | 51135 | 3962 | 84 |
2274770 | 2274770 | 2022-03-04 | Nottoway | Virginia | 51135 | 3962 | 84 |
2258537 | 2258537 | 2022-02-27 | Southampton | Virginia | 51175 | 3262 | 84 |
2255286 | 2255286 | 2022-02-26 | Southampton | Virginia | 51175 | 3262 | 84 |
2252035 | 2252035 | 2022-02-25 | Southampton | Virginia | 51175 | 3262 | 84 |
2245508 | 2245508 | 2022-02-23 | Orange | Virginia | 51137 | 6843 | 84 |
2242257 | 2242257 | 2022-02-22 | Orange | Virginia | 51137 | 6846 | 84 |
2239006 | 2239006 | 2022-02-21 | Orange | Virginia | 51137 | 6839 | 84 |
2235755 | 2235755 | 2022-02-20 | Orange | Virginia | 51137 | 6814 | 84 |
2232504 | 2232504 | 2022-02-19 | Orange | Virginia | 51137 | 6814 | 84 |
2229253 | 2229253 | 2022-02-18 | Orange | Virginia | 51137 | 6814 | 84 |
2226002 | 2226002 | 2022-02-17 | Orange | Virginia | 51137 | 6800 | 84 |
2222751 | 2222751 | 2022-02-16 | Orange | Virginia | 51137 | 6778 | 84 |
2219500 | 2219500 | 2022-02-15 | Orange | Virginia | 51137 | 6774 | 84 |
2216250 | 2216250 | 2022-02-14 | Orange | Virginia | 51137 | 6761 | 84 |
2177235 | 2177235 | 2022-02-02 | Russell | Virginia | 51167 | 6017 | 84 |
2173982 | 2173982 | 2022-02-01 | Russell | Virginia | 51167 | 5948 | 84 |
2170730 | 2170730 | 2022-01-31 | Russell | Virginia | 51167 | 5905 | 84 |
2167477 | 2167477 | 2022-01-30 | Russell | Virginia | 51167 | 5794 | 84 |
2164222 | 2164222 | 2022-01-29 | Russell | Virginia | 51167 | 5794 | 84 |
2160967 | 2160967 | 2022-01-28 | Russell | Virginia | 51167 | 5794 | 84 |
2144639 | 2144639 | 2022-01-23 | Gloucester | Virginia | 51073 | 6356 | 84 |
2141384 | 2141384 | 2022-01-22 | Gloucester | Virginia | 51073 | 6356 | 84 |
2138128 | 2138128 | 2022-01-21 | Gloucester | Virginia | 51073 | 6356 | 84 |
2134874 | 2134874 | 2022-01-20 | Gloucester | Virginia | 51073 | 6254 | 84 |
2131622 | 2131622 | 2022-01-19 | Gloucester | Virginia | 51073 | 6151 | 84 |
2112058 | 2112058 | 2022-01-13 | Accomack | Virginia | 51001 | 5532 | 84 |
2108806 | 2108806 | 2022-01-12 | Accomack | Virginia | 51001 | 5403 | 84 |
2105555 | 2105555 | 2022-01-11 | Accomack | Virginia | 51001 | 5271 | 84 |
2102304 | 2102304 | 2022-01-10 | Accomack | Virginia | 51001 | 5205 | 84 |
2102415 | 2102415 | 2022-01-10 | Salem city | Virginia | 51775 | 4931 | 84 |
2099053 | 2099053 | 2022-01-09 | Accomack | Virginia | 51001 | 4927 | 84 |
2099164 | 2099164 | 2022-01-09 | Salem city | Virginia | 51775 | 4669 | 84 |
2095802 | 2095802 | 2022-01-08 | Accomack | Virginia | 51001 | 4927 | 84 |
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);