ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,109 rows where deaths = 14 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Covington city 127
- Williamsburg city 126
- Falls Church city 94
- Madison 67
- Mathews 51
- Bath 40
- Dickenson 38
- King William 37
- Accomack 35
- Lunenburg 34
- Dinwiddie 33
- Fredericksburg city 33
- Manassas Park city 28
- Nottoway 23
- Caroline 21
- Richmond 21
- New Kent 14
- Surry 14
- Culpeper 13
- Carroll 11
- Botetourt 10
- Nelson 10
- Powhatan 9
- Charlotte 8
- Franklin city 8
- Prince Edward 8
- Sussex 8
- Bland 7
- Lee 7
- Roanoke 7
- …
state 1
- Virginia · 1,109 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2216199 | 2216199 | 2022-02-14 | Falls Church city | Virginia | 51610 | 1871 | 14 |
2212948 | 2212948 | 2022-02-13 | Falls Church city | Virginia | 51610 | 1859 | 14 |
2209695 | 2209695 | 2022-02-12 | Falls Church city | Virginia | 51610 | 1859 | 14 |
2206442 | 2206442 | 2022-02-11 | Falls Church city | Virginia | 51610 | 1859 | 14 |
2203189 | 2203189 | 2022-02-10 | Falls Church city | Virginia | 51610 | 1853 | 14 |
2199935 | 2199935 | 2022-02-09 | Falls Church city | Virginia | 51610 | 1847 | 14 |
2196681 | 2196681 | 2022-02-08 | Falls Church city | Virginia | 51610 | 1841 | 14 |
2193426 | 2193426 | 2022-02-07 | Falls Church city | Virginia | 51610 | 1836 | 14 |
2190173 | 2190173 | 2022-02-06 | Falls Church city | Virginia | 51610 | 1813 | 14 |
2190254 | 2190254 | 2022-02-06 | Surry | Virginia | 51181 | 1040 | 14 |
2186920 | 2186920 | 2022-02-05 | Falls Church city | Virginia | 51610 | 1813 | 14 |
2187001 | 2187001 | 2022-02-05 | Surry | Virginia | 51181 | 1040 | 14 |
2183667 | 2183667 | 2022-02-04 | Falls Church city | Virginia | 51610 | 1813 | 14 |
2183748 | 2183748 | 2022-02-04 | Surry | Virginia | 51181 | 1040 | 14 |
2180496 | 2180496 | 2022-02-03 | Surry | Virginia | 51181 | 1028 | 14 |
2177245 | 2177245 | 2022-02-02 | Surry | Virginia | 51181 | 1017 | 14 |
2173911 | 2173911 | 2022-02-01 | Falls Church city | Virginia | 51610 | 1783 | 14 |
2173992 | 2173992 | 2022-02-01 | Surry | Virginia | 51181 | 1013 | 14 |
2170659 | 2170659 | 2022-01-31 | Falls Church city | Virginia | 51610 | 1774 | 14 |
2170740 | 2170740 | 2022-01-31 | Surry | Virginia | 51181 | 999 | 14 |
2167406 | 2167406 | 2022-01-30 | Falls Church city | Virginia | 51610 | 1738 | 14 |
2167487 | 2167487 | 2022-01-30 | Surry | Virginia | 51181 | 989 | 14 |
2164151 | 2164151 | 2022-01-29 | Falls Church city | Virginia | 51610 | 1738 | 14 |
2164232 | 2164232 | 2022-01-29 | Surry | Virginia | 51181 | 989 | 14 |
2160896 | 2160896 | 2022-01-28 | Falls Church city | Virginia | 51610 | 1738 | 14 |
2160977 | 2160977 | 2022-01-28 | Surry | Virginia | 51181 | 989 | 14 |
2157640 | 2157640 | 2022-01-27 | Falls Church city | Virginia | 51610 | 1724 | 14 |
2157721 | 2157721 | 2022-01-27 | Surry | Virginia | 51181 | 980 | 14 |
2154387 | 2154387 | 2022-01-26 | Falls Church city | Virginia | 51610 | 1711 | 14 |
2154468 | 2154468 | 2022-01-26 | Surry | Virginia | 51181 | 972 | 14 |
2151134 | 2151134 | 2022-01-25 | Falls Church city | Virginia | 51610 | 1700 | 14 |
2151215 | 2151215 | 2022-01-25 | Surry | Virginia | 51181 | 965 | 14 |
2147882 | 2147882 | 2022-01-24 | Falls Church city | Virginia | 51610 | 1674 | 14 |
2147963 | 2147963 | 2022-01-24 | Surry | Virginia | 51181 | 957 | 14 |
2144629 | 2144629 | 2022-01-23 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2141374 | 2141374 | 2022-01-22 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2138118 | 2138118 | 2022-01-21 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2134864 | 2134864 | 2022-01-20 | Falls Church city | Virginia | 51610 | 1617 | 14 |
2131612 | 2131612 | 2022-01-19 | Falls Church city | Virginia | 51610 | 1601 | 14 |
2128358 | 2128358 | 2022-01-18 | Falls Church city | Virginia | 51610 | 1584 | 14 |
2125105 | 2125105 | 2022-01-17 | Falls Church city | Virginia | 51610 | 1572 | 14 |
2121853 | 2121853 | 2022-01-16 | Falls Church city | Virginia | 51610 | 1494 | 14 |
2118601 | 2118601 | 2022-01-15 | Falls Church city | Virginia | 51610 | 1494 | 14 |
2115349 | 2115349 | 2022-01-14 | Falls Church city | Virginia | 51610 | 1494 | 14 |
2112097 | 2112097 | 2022-01-13 | Falls Church city | Virginia | 51610 | 1460 | 14 |
2108845 | 2108845 | 2022-01-12 | Falls Church city | Virginia | 51610 | 1417 | 14 |
2105594 | 2105594 | 2022-01-11 | Falls Church city | Virginia | 51610 | 1361 | 14 |
2102343 | 2102343 | 2022-01-10 | Falls Church city | Virginia | 51610 | 1325 | 14 |
2099092 | 2099092 | 2022-01-09 | Falls Church city | Virginia | 51610 | 1214 | 14 |
2095841 | 2095841 | 2022-01-08 | Falls Church city | Virginia | 51610 | 1214 | 14 |
2092589 | 2092589 | 2022-01-07 | Falls Church city | Virginia | 51610 | 1214 | 14 |
2089337 | 2089337 | 2022-01-06 | Falls Church city | Virginia | 51610 | 1170 | 14 |
2086086 | 2086086 | 2022-01-05 | Falls Church city | Virginia | 51610 | 1142 | 14 |
2082834 | 2082834 | 2022-01-04 | Falls Church city | Virginia | 51610 | 1072 | 14 |
2079582 | 2079582 | 2022-01-03 | Falls Church city | Virginia | 51610 | 1050 | 14 |
2076330 | 2076330 | 2022-01-02 | Falls Church city | Virginia | 51610 | 984 | 14 |
2073079 | 2073079 | 2022-01-01 | Falls Church city | Virginia | 51610 | 984 | 14 |
2069828 | 2069828 | 2021-12-31 | Falls Church city | Virginia | 51610 | 984 | 14 |
2066577 | 2066577 | 2021-12-30 | Falls Church city | Virginia | 51610 | 945 | 14 |
2063327 | 2063327 | 2021-12-29 | Falls Church city | Virginia | 51610 | 920 | 14 |
2060077 | 2060077 | 2021-12-28 | Falls Church city | Virginia | 51610 | 898 | 14 |
2056828 | 2056828 | 2021-12-27 | Falls Church city | Virginia | 51610 | 879 | 14 |
2053579 | 2053579 | 2021-12-26 | Falls Church city | Virginia | 51610 | 828 | 14 |
2050329 | 2050329 | 2021-12-25 | Falls Church city | Virginia | 51610 | 828 | 14 |
2047079 | 2047079 | 2021-12-24 | Falls Church city | Virginia | 51610 | 828 | 14 |
2043829 | 2043829 | 2021-12-23 | Falls Church city | Virginia | 51610 | 821 | 14 |
2040580 | 2040580 | 2021-12-22 | Falls Church city | Virginia | 51610 | 803 | 14 |
2037330 | 2037330 | 2021-12-21 | Falls Church city | Virginia | 51610 | 790 | 14 |
2034080 | 2034080 | 2021-12-20 | Falls Church city | Virginia | 51610 | 785 | 14 |
2030830 | 2030830 | 2021-12-19 | Falls Church city | Virginia | 51610 | 754 | 14 |
2027579 | 2027579 | 2021-12-18 | Falls Church city | Virginia | 51610 | 754 | 14 |
2024328 | 2024328 | 2021-12-17 | Falls Church city | Virginia | 51610 | 754 | 14 |
2021077 | 2021077 | 2021-12-16 | Falls Church city | Virginia | 51610 | 749 | 14 |
2017826 | 2017826 | 2021-12-15 | Falls Church city | Virginia | 51610 | 746 | 14 |
2014576 | 2014576 | 2021-12-14 | Falls Church city | Virginia | 51610 | 741 | 14 |
2011325 | 2011325 | 2021-12-13 | Falls Church city | Virginia | 51610 | 741 | 14 |
2008074 | 2008074 | 2021-12-12 | Falls Church city | Virginia | 51610 | 736 | 14 |
2004823 | 2004823 | 2021-12-11 | Falls Church city | Virginia | 51610 | 736 | 14 |
2001572 | 2001572 | 2021-12-10 | Falls Church city | Virginia | 51610 | 736 | 14 |
1998322 | 1998322 | 2021-12-09 | Falls Church city | Virginia | 51610 | 736 | 14 |
1995071 | 1995071 | 2021-12-08 | Falls Church city | Virginia | 51610 | 736 | 14 |
1995107 | 1995107 | 2021-12-08 | Manassas Park city | Virginia | 51685 | 1294 | 14 |
1991820 | 1991820 | 2021-12-07 | Falls Church city | Virginia | 51610 | 733 | 14 |
1991856 | 1991856 | 2021-12-07 | Manassas Park city | Virginia | 51685 | 1294 | 14 |
1988569 | 1988569 | 2021-12-06 | Falls Church city | Virginia | 51610 | 728 | 14 |
1988605 | 1988605 | 2021-12-06 | Manassas Park city | Virginia | 51685 | 1291 | 14 |
1985319 | 1985319 | 2021-12-05 | Falls Church city | Virginia | 51610 | 719 | 14 |
1985355 | 1985355 | 2021-12-05 | Manassas Park city | Virginia | 51685 | 1290 | 14 |
1982069 | 1982069 | 2021-12-04 | Falls Church city | Virginia | 51610 | 719 | 14 |
1982105 | 1982105 | 2021-12-04 | Manassas Park city | Virginia | 51685 | 1290 | 14 |
1978819 | 1978819 | 2021-12-03 | Falls Church city | Virginia | 51610 | 719 | 14 |
1978855 | 1978855 | 2021-12-03 | Manassas Park city | Virginia | 51685 | 1290 | 14 |
1975569 | 1975569 | 2021-12-02 | Falls Church city | Virginia | 51610 | 717 | 14 |
1975605 | 1975605 | 2021-12-02 | Manassas Park city | Virginia | 51685 | 1289 | 14 |
1972320 | 1972320 | 2021-12-01 | Falls Church city | Virginia | 51610 | 718 | 14 |
1972356 | 1972356 | 2021-12-01 | Manassas Park city | Virginia | 51685 | 1288 | 14 |
1969070 | 1969070 | 2021-11-30 | Falls Church city | Virginia | 51610 | 716 | 14 |
1969106 | 1969106 | 2021-11-30 | Manassas Park city | Virginia | 51685 | 1285 | 14 |
1965820 | 1965820 | 2021-11-29 | Falls Church city | Virginia | 51610 | 715 | 14 |
1965856 | 1965856 | 2021-11-29 | Manassas Park city | Virginia | 51685 | 1285 | 14 |
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);