ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,397 rows where deaths = 22 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Buena Vista city 140
- Norton city 89
- Giles 79
- Floyd 76
- Fluvanna 61
- Williamsburg city 59
- Fredericksburg city 58
- James City 52
- Stafford 40
- Charles City 37
- King George 37
- Clarke 36
- Lunenburg 32
- Sussex 31
- Charlotte 29
- Grayson 28
- Poquoson city 28
- Middlesex 27
- Westmoreland 25
- Greene 21
- Rockingham 21
- Colonial Heights city 20
- Essex 19
- Cumberland 17
- Albemarle 16
- New Kent 15
- Brunswick 13
- King William 13
- Nelson 12
- Mathews 11
- …
state 1
- Virginia · 1,397 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502598 | 2502598 | 2022-05-13 | Norton city | Virginia | 51720 | 1310 | 22 |
2502638 | 2502638 | 2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 |
2499340 | 2499340 | 2022-05-12 | Norton city | Virginia | 51720 | 1308 | 22 |
2499380 | 2499380 | 2022-05-12 | Williamsburg city | Virginia | 51830 | 1831 | 22 |
2496082 | 2496082 | 2022-05-11 | Norton city | Virginia | 51720 | 1306 | 22 |
2496122 | 2496122 | 2022-05-11 | Williamsburg city | Virginia | 51830 | 1825 | 22 |
2492824 | 2492824 | 2022-05-10 | Norton city | Virginia | 51720 | 1305 | 22 |
2492864 | 2492864 | 2022-05-10 | Williamsburg city | Virginia | 51830 | 1819 | 22 |
2489566 | 2489566 | 2022-05-09 | Norton city | Virginia | 51720 | 1305 | 22 |
2489606 | 2489606 | 2022-05-09 | Williamsburg city | Virginia | 51830 | 1816 | 22 |
2486309 | 2486309 | 2022-05-08 | Norton city | Virginia | 51720 | 1304 | 22 |
2486349 | 2486349 | 2022-05-08 | Williamsburg city | Virginia | 51830 | 1812 | 22 |
2483051 | 2483051 | 2022-05-07 | Norton city | Virginia | 51720 | 1304 | 22 |
2483091 | 2483091 | 2022-05-07 | Williamsburg city | Virginia | 51830 | 1812 | 22 |
2479793 | 2479793 | 2022-05-06 | Norton city | Virginia | 51720 | 1304 | 22 |
2479833 | 2479833 | 2022-05-06 | Williamsburg city | Virginia | 51830 | 1812 | 22 |
2476535 | 2476535 | 2022-05-05 | Norton city | Virginia | 51720 | 1304 | 22 |
2476575 | 2476575 | 2022-05-05 | Williamsburg city | Virginia | 51830 | 1811 | 22 |
2473277 | 2473277 | 2022-05-04 | Norton city | Virginia | 51720 | 1303 | 22 |
2473317 | 2473317 | 2022-05-04 | Williamsburg city | Virginia | 51830 | 1808 | 22 |
2470021 | 2470021 | 2022-05-03 | Norton city | Virginia | 51720 | 1304 | 22 |
2470061 | 2470061 | 2022-05-03 | Williamsburg city | Virginia | 51830 | 1804 | 22 |
2466765 | 2466765 | 2022-05-02 | Norton city | Virginia | 51720 | 1304 | 22 |
2466805 | 2466805 | 2022-05-02 | Williamsburg city | Virginia | 51830 | 1803 | 22 |
2463510 | 2463510 | 2022-05-01 | Norton city | Virginia | 51720 | 1302 | 22 |
2463550 | 2463550 | 2022-05-01 | Williamsburg city | Virginia | 51830 | 1800 | 22 |
2460254 | 2460254 | 2022-04-30 | Norton city | Virginia | 51720 | 1302 | 22 |
2460294 | 2460294 | 2022-04-30 | Williamsburg city | Virginia | 51830 | 1800 | 22 |
2456998 | 2456998 | 2022-04-29 | Norton city | Virginia | 51720 | 1302 | 22 |
2457038 | 2457038 | 2022-04-29 | Williamsburg city | Virginia | 51830 | 1800 | 22 |
2453742 | 2453742 | 2022-04-28 | Norton city | Virginia | 51720 | 1302 | 22 |
2453782 | 2453782 | 2022-04-28 | Williamsburg city | Virginia | 51830 | 1797 | 22 |
2450486 | 2450486 | 2022-04-27 | Norton city | Virginia | 51720 | 1304 | 22 |
2450526 | 2450526 | 2022-04-27 | Williamsburg city | Virginia | 51830 | 1791 | 22 |
2447229 | 2447229 | 2022-04-26 | Norton city | Virginia | 51720 | 1304 | 22 |
2447270 | 2447270 | 2022-04-26 | Williamsburg city | Virginia | 51830 | 1788 | 22 |
2443974 | 2443974 | 2022-04-25 | Norton city | Virginia | 51720 | 1304 | 22 |
2444014 | 2444014 | 2022-04-25 | Williamsburg city | Virginia | 51830 | 1788 | 22 |
2440718 | 2440718 | 2022-04-24 | Norton city | Virginia | 51720 | 1304 | 22 |
2440758 | 2440758 | 2022-04-24 | Williamsburg city | Virginia | 51830 | 1786 | 22 |
2437462 | 2437462 | 2022-04-23 | Norton city | Virginia | 51720 | 1304 | 22 |
2437502 | 2437502 | 2022-04-23 | Williamsburg city | Virginia | 51830 | 1786 | 22 |
2434206 | 2434206 | 2022-04-22 | Norton city | Virginia | 51720 | 1304 | 22 |
2434246 | 2434246 | 2022-04-22 | Williamsburg city | Virginia | 51830 | 1786 | 22 |
2430950 | 2430950 | 2022-04-21 | Norton city | Virginia | 51720 | 1304 | 22 |
2430990 | 2430990 | 2022-04-21 | Williamsburg city | Virginia | 51830 | 1781 | 22 |
2427617 | 2427617 | 2022-04-20 | Bland | Virginia | 51021 | 1776 | 22 |
2427694 | 2427694 | 2022-04-20 | Norton city | Virginia | 51720 | 1304 | 22 |
2427734 | 2427734 | 2022-04-20 | Williamsburg city | Virginia | 51830 | 1779 | 22 |
2424361 | 2424361 | 2022-04-19 | Bland | Virginia | 51021 | 1776 | 22 |
2424438 | 2424438 | 2022-04-19 | Norton city | Virginia | 51720 | 1305 | 22 |
2424478 | 2424478 | 2022-04-19 | Williamsburg city | Virginia | 51830 | 1770 | 22 |
2421105 | 2421105 | 2022-04-18 | Bland | Virginia | 51021 | 1774 | 22 |
2421182 | 2421182 | 2022-04-18 | Norton city | Virginia | 51720 | 1305 | 22 |
2421222 | 2421222 | 2022-04-18 | Williamsburg city | Virginia | 51830 | 1770 | 22 |
2417849 | 2417849 | 2022-04-17 | Bland | Virginia | 51021 | 1773 | 22 |
2417926 | 2417926 | 2022-04-17 | Norton city | Virginia | 51720 | 1305 | 22 |
2417966 | 2417966 | 2022-04-17 | Williamsburg city | Virginia | 51830 | 1767 | 22 |
2414593 | 2414593 | 2022-04-16 | Bland | Virginia | 51021 | 1773 | 22 |
2414670 | 2414670 | 2022-04-16 | Norton city | Virginia | 51720 | 1305 | 22 |
2414710 | 2414710 | 2022-04-16 | Williamsburg city | Virginia | 51830 | 1767 | 22 |
2411337 | 2411337 | 2022-04-15 | Bland | Virginia | 51021 | 1773 | 22 |
2411414 | 2411414 | 2022-04-15 | Norton city | Virginia | 51720 | 1305 | 22 |
2411454 | 2411454 | 2022-04-15 | Williamsburg city | Virginia | 51830 | 1767 | 22 |
2408158 | 2408158 | 2022-04-14 | Norton city | Virginia | 51720 | 1305 | 22 |
2408198 | 2408198 | 2022-04-14 | Williamsburg city | Virginia | 51830 | 1765 | 22 |
2404902 | 2404902 | 2022-04-13 | Norton city | Virginia | 51720 | 1304 | 22 |
2404942 | 2404942 | 2022-04-13 | Williamsburg city | Virginia | 51830 | 1760 | 22 |
2401647 | 2401647 | 2022-04-12 | Norton city | Virginia | 51720 | 1304 | 22 |
2401687 | 2401687 | 2022-04-12 | Williamsburg city | Virginia | 51830 | 1758 | 22 |
2398392 | 2398392 | 2022-04-11 | Norton city | Virginia | 51720 | 1303 | 22 |
2398432 | 2398432 | 2022-04-11 | Williamsburg city | Virginia | 51830 | 1757 | 22 |
2395137 | 2395137 | 2022-04-10 | Norton city | Virginia | 51720 | 1303 | 22 |
2395177 | 2395177 | 2022-04-10 | Williamsburg city | Virginia | 51830 | 1756 | 22 |
2391881 | 2391881 | 2022-04-09 | Norton city | Virginia | 51720 | 1303 | 22 |
2391921 | 2391921 | 2022-04-09 | Williamsburg city | Virginia | 51830 | 1756 | 22 |
2388625 | 2388625 | 2022-04-08 | Norton city | Virginia | 51720 | 1303 | 22 |
2388665 | 2388665 | 2022-04-08 | Williamsburg city | Virginia | 51830 | 1756 | 22 |
2385370 | 2385370 | 2022-04-07 | Norton city | Virginia | 51720 | 1305 | 22 |
2385410 | 2385410 | 2022-04-07 | Williamsburg city | Virginia | 51830 | 1756 | 22 |
2382115 | 2382115 | 2022-04-06 | Norton city | Virginia | 51720 | 1305 | 22 |
2382155 | 2382155 | 2022-04-06 | Williamsburg city | Virginia | 51830 | 1755 | 22 |
2378860 | 2378860 | 2022-04-05 | Norton city | Virginia | 51720 | 1305 | 22 |
2378900 | 2378900 | 2022-04-05 | Williamsburg city | Virginia | 51830 | 1752 | 22 |
2375606 | 2375606 | 2022-04-04 | Norton city | Virginia | 51720 | 1305 | 22 |
2375646 | 2375646 | 2022-04-04 | Williamsburg city | Virginia | 51830 | 1751 | 22 |
2372354 | 2372354 | 2022-04-03 | Norton city | Virginia | 51720 | 1305 | 22 |
2372394 | 2372394 | 2022-04-03 | Williamsburg city | Virginia | 51830 | 1751 | 22 |
2369101 | 2369101 | 2022-04-02 | Norton city | Virginia | 51720 | 1305 | 22 |
2369141 | 2369141 | 2022-04-02 | Williamsburg city | Virginia | 51830 | 1751 | 22 |
2365848 | 2365848 | 2022-04-01 | Norton city | Virginia | 51720 | 1305 | 22 |
2365888 | 2365888 | 2022-04-01 | Williamsburg city | Virginia | 51830 | 1751 | 22 |
2362595 | 2362595 | 2022-03-31 | Norton city | Virginia | 51720 | 1304 | 22 |
2362635 | 2362635 | 2022-03-31 | Williamsburg city | Virginia | 51830 | 1749 | 22 |
2359341 | 2359341 | 2022-03-30 | Norton city | Virginia | 51720 | 1303 | 22 |
2359381 | 2359381 | 2022-03-30 | Williamsburg city | Virginia | 51830 | 1750 | 22 |
2356087 | 2356087 | 2022-03-29 | Norton city | Virginia | 51720 | 1303 | 22 |
2356127 | 2356127 | 2022-03-29 | Williamsburg city | Virginia | 51830 | 1751 | 22 |
2352834 | 2352834 | 2022-03-28 | Norton city | Virginia | 51720 | 1302 | 22 |
2352874 | 2352874 | 2022-03-28 | Williamsburg city | Virginia | 51830 | 1748 | 22 |
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);