ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where deaths = 40 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Amherst 66
- Russell 66
- Lexington city 54
- Grayson 43
- Orange 43
- Caroline 40
- Clarke 34
- Dickenson 33
- Southampton 33
- Amelia 23
- Sussex 22
- Accomack 21
- Charlottesville city 18
- Harrisonburg city 18
- Buckingham 17
- Greensville 17
- Warren 17
- Northampton 16
- Franklin city 14
- Hanover 11
- Patrick 11
- Prince Edward 11
- Buchanan 10
- Shenandoah 10
- Louisa 9
- Scott 9
- Page 8
- Bristol city 7
- Fairfax city 7
- Goochland 7
- …
state 1
- Virginia · 784 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502563 | 2502563 | 2022-05-13 | Greensville | Virginia | 51081 | 3341 | 40 |
2502579 | 2502579 | 2022-05-13 | Lexington city | Virginia | 51678 | 2857 | 40 |
2499305 | 2499305 | 2022-05-12 | Greensville | Virginia | 51081 | 3341 | 40 |
2499321 | 2499321 | 2022-05-12 | Lexington city | Virginia | 51678 | 2855 | 40 |
2496047 | 2496047 | 2022-05-11 | Greensville | Virginia | 51081 | 3340 | 40 |
2496063 | 2496063 | 2022-05-11 | Lexington city | Virginia | 51678 | 2849 | 40 |
2492789 | 2492789 | 2022-05-10 | Greensville | Virginia | 51081 | 3338 | 40 |
2492805 | 2492805 | 2022-05-10 | Lexington city | Virginia | 51678 | 2848 | 40 |
2489531 | 2489531 | 2022-05-09 | Greensville | Virginia | 51081 | 3340 | 40 |
2489547 | 2489547 | 2022-05-09 | Lexington city | Virginia | 51678 | 2849 | 40 |
2486274 | 2486274 | 2022-05-08 | Greensville | Virginia | 51081 | 3334 | 40 |
2486290 | 2486290 | 2022-05-08 | Lexington city | Virginia | 51678 | 2847 | 40 |
2483016 | 2483016 | 2022-05-07 | Greensville | Virginia | 51081 | 3334 | 40 |
2483032 | 2483032 | 2022-05-07 | Lexington city | Virginia | 51678 | 2847 | 40 |
2479758 | 2479758 | 2022-05-06 | Greensville | Virginia | 51081 | 3334 | 40 |
2479774 | 2479774 | 2022-05-06 | Lexington city | Virginia | 51678 | 2847 | 40 |
2476500 | 2476500 | 2022-05-05 | Greensville | Virginia | 51081 | 3333 | 40 |
2476516 | 2476516 | 2022-05-05 | Lexington city | Virginia | 51678 | 2847 | 40 |
2473242 | 2473242 | 2022-05-04 | Greensville | Virginia | 51081 | 3333 | 40 |
2473258 | 2473258 | 2022-05-04 | Lexington city | Virginia | 51678 | 2843 | 40 |
2469986 | 2469986 | 2022-05-03 | Greensville | Virginia | 51081 | 3330 | 40 |
2470002 | 2470002 | 2022-05-03 | Lexington city | Virginia | 51678 | 2842 | 40 |
2466730 | 2466730 | 2022-05-02 | Greensville | Virginia | 51081 | 3330 | 40 |
2466746 | 2466746 | 2022-05-02 | Lexington city | Virginia | 51678 | 2841 | 40 |
2463475 | 2463475 | 2022-05-01 | Greensville | Virginia | 51081 | 3332 | 40 |
2463491 | 2463491 | 2022-05-01 | Lexington city | Virginia | 51678 | 2839 | 40 |
2460219 | 2460219 | 2022-04-30 | Greensville | Virginia | 51081 | 3332 | 40 |
2460235 | 2460235 | 2022-04-30 | Lexington city | Virginia | 51678 | 2839 | 40 |
2456963 | 2456963 | 2022-04-29 | Greensville | Virginia | 51081 | 3332 | 40 |
2456979 | 2456979 | 2022-04-29 | Lexington city | Virginia | 51678 | 2839 | 40 |
2453707 | 2453707 | 2022-04-28 | Greensville | Virginia | 51081 | 3330 | 40 |
2453723 | 2453723 | 2022-04-28 | Lexington city | Virginia | 51678 | 2840 | 40 |
2450451 | 2450451 | 2022-04-27 | Greensville | Virginia | 51081 | 3330 | 40 |
2450467 | 2450467 | 2022-04-27 | Lexington city | Virginia | 51678 | 2838 | 40 |
2447210 | 2447210 | 2022-04-26 | Lexington city | Virginia | 51678 | 2835 | 40 |
2443955 | 2443955 | 2022-04-25 | Lexington city | Virginia | 51678 | 2837 | 40 |
2440699 | 2440699 | 2022-04-24 | Lexington city | Virginia | 51678 | 2837 | 40 |
2437443 | 2437443 | 2022-04-23 | Lexington city | Virginia | 51678 | 2837 | 40 |
2434187 | 2434187 | 2022-04-22 | Lexington city | Virginia | 51678 | 2837 | 40 |
2430931 | 2430931 | 2022-04-21 | Lexington city | Virginia | 51678 | 2836 | 40 |
2427675 | 2427675 | 2022-04-20 | Lexington city | Virginia | 51678 | 2832 | 40 |
2424419 | 2424419 | 2022-04-19 | Lexington city | Virginia | 51678 | 2831 | 40 |
2424424 | 2424424 | 2022-04-19 | Madison | Virginia | 51113 | 2380 | 40 |
2421163 | 2421163 | 2022-04-18 | Lexington city | Virginia | 51678 | 2832 | 40 |
2421168 | 2421168 | 2022-04-18 | Madison | Virginia | 51113 | 2371 | 40 |
2417907 | 2417907 | 2022-04-17 | Lexington city | Virginia | 51678 | 2829 | 40 |
2417912 | 2417912 | 2022-04-17 | Madison | Virginia | 51113 | 2359 | 40 |
2414651 | 2414651 | 2022-04-16 | Lexington city | Virginia | 51678 | 2829 | 40 |
2414656 | 2414656 | 2022-04-16 | Madison | Virginia | 51113 | 2359 | 40 |
2411395 | 2411395 | 2022-04-15 | Lexington city | Virginia | 51678 | 2829 | 40 |
2411400 | 2411400 | 2022-04-15 | Madison | Virginia | 51113 | 2359 | 40 |
2408139 | 2408139 | 2022-04-14 | Lexington city | Virginia | 51678 | 2828 | 40 |
2408144 | 2408144 | 2022-04-14 | Madison | Virginia | 51113 | 2350 | 40 |
2404883 | 2404883 | 2022-04-13 | Lexington city | Virginia | 51678 | 2828 | 40 |
2401628 | 2401628 | 2022-04-12 | Lexington city | Virginia | 51678 | 2828 | 40 |
2398373 | 2398373 | 2022-04-11 | Lexington city | Virginia | 51678 | 2828 | 40 |
2395118 | 2395118 | 2022-04-10 | Lexington city | Virginia | 51678 | 2827 | 40 |
2391862 | 2391862 | 2022-04-09 | Lexington city | Virginia | 51678 | 2827 | 40 |
2388606 | 2388606 | 2022-04-08 | Lexington city | Virginia | 51678 | 2827 | 40 |
2385351 | 2385351 | 2022-04-07 | Lexington city | Virginia | 51678 | 2827 | 40 |
2385403 | 2385403 | 2022-04-07 | Sussex | Virginia | 51183 | 2421 | 40 |
2382096 | 2382096 | 2022-04-06 | Lexington city | Virginia | 51678 | 2826 | 40 |
2382148 | 2382148 | 2022-04-06 | Sussex | Virginia | 51183 | 2420 | 40 |
2378818 | 2378818 | 2022-04-05 | Fredericksburg city | Virginia | 51630 | 5286 | 40 |
2378841 | 2378841 | 2022-04-05 | Lexington city | Virginia | 51678 | 2826 | 40 |
2378893 | 2378893 | 2022-04-05 | Sussex | Virginia | 51183 | 2422 | 40 |
2375587 | 2375587 | 2022-04-04 | Lexington city | Virginia | 51678 | 2826 | 40 |
2375639 | 2375639 | 2022-04-04 | Sussex | Virginia | 51183 | 2422 | 40 |
2372335 | 2372335 | 2022-04-03 | Lexington city | Virginia | 51678 | 2826 | 40 |
2372387 | 2372387 | 2022-04-03 | Sussex | Virginia | 51183 | 2422 | 40 |
2369082 | 2369082 | 2022-04-02 | Lexington city | Virginia | 51678 | 2826 | 40 |
2369134 | 2369134 | 2022-04-02 | Sussex | Virginia | 51183 | 2422 | 40 |
2365829 | 2365829 | 2022-04-01 | Lexington city | Virginia | 51678 | 2826 | 40 |
2365881 | 2365881 | 2022-04-01 | Sussex | Virginia | 51183 | 2422 | 40 |
2362576 | 2362576 | 2022-03-31 | Lexington city | Virginia | 51678 | 2825 | 40 |
2362628 | 2362628 | 2022-03-31 | Sussex | Virginia | 51183 | 2422 | 40 |
2359322 | 2359322 | 2022-03-30 | Lexington city | Virginia | 51678 | 2826 | 40 |
2359374 | 2359374 | 2022-03-30 | Sussex | Virginia | 51183 | 2420 | 40 |
2356068 | 2356068 | 2022-03-29 | Lexington city | Virginia | 51678 | 2826 | 40 |
2356120 | 2356120 | 2022-03-29 | Sussex | Virginia | 51183 | 2419 | 40 |
2352815 | 2352815 | 2022-03-28 | Lexington city | Virginia | 51678 | 2827 | 40 |
2352867 | 2352867 | 2022-03-28 | Sussex | Virginia | 51183 | 2417 | 40 |
2349563 | 2349563 | 2022-03-27 | Lexington city | Virginia | 51678 | 2829 | 40 |
2349615 | 2349615 | 2022-03-27 | Sussex | Virginia | 51183 | 2417 | 40 |
2346310 | 2346310 | 2022-03-26 | Lexington city | Virginia | 51678 | 2829 | 40 |
2346362 | 2346362 | 2022-03-26 | Sussex | Virginia | 51183 | 2417 | 40 |
2343057 | 2343057 | 2022-03-25 | Lexington city | Virginia | 51678 | 2829 | 40 |
2343109 | 2343109 | 2022-03-25 | Sussex | Virginia | 51183 | 2417 | 40 |
2339804 | 2339804 | 2022-03-24 | Lexington city | Virginia | 51678 | 2829 | 40 |
2339856 | 2339856 | 2022-03-24 | Sussex | Virginia | 51183 | 2416 | 40 |
2336507 | 2336507 | 2022-03-23 | Clarke | Virginia | 51043 | 2591 | 40 |
2336550 | 2336550 | 2022-03-23 | Lexington city | Virginia | 51678 | 2826 | 40 |
2336602 | 2336602 | 2022-03-23 | Sussex | Virginia | 51183 | 2415 | 40 |
2333253 | 2333253 | 2022-03-22 | Clarke | Virginia | 51043 | 2586 | 40 |
2333296 | 2333296 | 2022-03-22 | Lexington city | Virginia | 51678 | 2824 | 40 |
2333348 | 2333348 | 2022-03-22 | Sussex | Virginia | 51183 | 2413 | 40 |
2330000 | 2330000 | 2022-03-21 | Clarke | Virginia | 51043 | 2586 | 40 |
2330043 | 2330043 | 2022-03-21 | Lexington city | Virginia | 51678 | 2824 | 40 |
2330095 | 2330095 | 2022-03-21 | Sussex | Virginia | 51183 | 2413 | 40 |
2326739 | 2326739 | 2022-03-20 | Buena Vista city | Virginia | 51530 | 1998 | 40 |
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);