ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 51600 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499290 | 2499290 | 2022-05-12 | Fairfax city | Virginia | 51600 | 2055 | 43 |
2496032 | 2496032 | 2022-05-11 | Fairfax city | Virginia | 51600 | 2049 | 43 |
2492774 | 2492774 | 2022-05-10 | Fairfax city | Virginia | 51600 | 2047 | 43 |
2489516 | 2489516 | 2022-05-09 | Fairfax city | Virginia | 51600 | 2043 | 43 |
2486259 | 2486259 | 2022-05-08 | Fairfax city | Virginia | 51600 | 2033 | 43 |
2483001 | 2483001 | 2022-05-07 | Fairfax city | Virginia | 51600 | 2033 | 43 |
2479743 | 2479743 | 2022-05-06 | Fairfax city | Virginia | 51600 | 2033 | 43 |
2476485 | 2476485 | 2022-05-05 | Fairfax city | Virginia | 51600 | 2030 | 43 |
2473227 | 2473227 | 2022-05-04 | Fairfax city | Virginia | 51600 | 2026 | 43 |
2469971 | 2469971 | 2022-05-03 | Fairfax city | Virginia | 51600 | 2014 | 43 |
2466715 | 2466715 | 2022-05-02 | Fairfax city | Virginia | 51600 | 2011 | 43 |
2463460 | 2463460 | 2022-05-01 | Fairfax city | Virginia | 51600 | 2006 | 43 |
2460204 | 2460204 | 2022-04-30 | Fairfax city | Virginia | 51600 | 2006 | 43 |
2456948 | 2456948 | 2022-04-29 | Fairfax city | Virginia | 51600 | 2006 | 43 |
2453692 | 2453692 | 2022-04-28 | Fairfax city | Virginia | 51600 | 2004 | 43 |
2450436 | 2450436 | 2022-04-27 | Fairfax city | Virginia | 51600 | 2001 | 43 |
2447179 | 2447179 | 2022-04-26 | Fairfax city | Virginia | 51600 | 1998 | 43 |
2443924 | 2443924 | 2022-04-25 | Fairfax city | Virginia | 51600 | 1998 | 43 |
2440668 | 2440668 | 2022-04-24 | Fairfax city | Virginia | 51600 | 1991 | 42 |
2437412 | 2437412 | 2022-04-23 | Fairfax city | Virginia | 51600 | 1991 | 42 |
2434156 | 2434156 | 2022-04-22 | Fairfax city | Virginia | 51600 | 1991 | 42 |
2430900 | 2430900 | 2022-04-21 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2427644 | 2427644 | 2022-04-20 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2424388 | 2424388 | 2022-04-19 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2421132 | 2421132 | 2022-04-18 | Fairfax city | Virginia | 51600 | 1987 | 42 |
2417876 | 2417876 | 2022-04-17 | Fairfax city | Virginia | 51600 | 1982 | 42 |
2414620 | 2414620 | 2022-04-16 | Fairfax city | Virginia | 51600 | 1982 | 42 |
2411364 | 2411364 | 2022-04-15 | Fairfax city | Virginia | 51600 | 1982 | 42 |
2408108 | 2408108 | 2022-04-14 | Fairfax city | Virginia | 51600 | 1981 | 42 |
2404852 | 2404852 | 2022-04-13 | Fairfax city | Virginia | 51600 | 1980 | 42 |
2401597 | 2401597 | 2022-04-12 | Fairfax city | Virginia | 51600 | 1980 | 42 |
2398342 | 2398342 | 2022-04-11 | Fairfax city | Virginia | 51600 | 1980 | 42 |
2395087 | 2395087 | 2022-04-10 | Fairfax city | Virginia | 51600 | 1975 | 42 |
2391831 | 2391831 | 2022-04-09 | Fairfax city | Virginia | 51600 | 1975 | 42 |
2388575 | 2388575 | 2022-04-08 | Fairfax city | Virginia | 51600 | 1975 | 42 |
2385320 | 2385320 | 2022-04-07 | Fairfax city | Virginia | 51600 | 1971 | 42 |
2382065 | 2382065 | 2022-04-06 | Fairfax city | Virginia | 51600 | 1970 | 42 |
2378810 | 2378810 | 2022-04-05 | Fairfax city | Virginia | 51600 | 1968 | 42 |
2375556 | 2375556 | 2022-04-04 | Fairfax city | Virginia | 51600 | 1967 | 42 |
2372304 | 2372304 | 2022-04-03 | Fairfax city | Virginia | 51600 | 1964 | 42 |
2369051 | 2369051 | 2022-04-02 | Fairfax city | Virginia | 51600 | 1964 | 42 |
2365798 | 2365798 | 2022-04-01 | Fairfax city | Virginia | 51600 | 1964 | 42 |
2362545 | 2362545 | 2022-03-31 | Fairfax city | Virginia | 51600 | 1961 | 42 |
2359291 | 2359291 | 2022-03-30 | Fairfax city | Virginia | 51600 | 1960 | 42 |
2356037 | 2356037 | 2022-03-29 | Fairfax city | Virginia | 51600 | 1958 | 42 |
2352784 | 2352784 | 2022-03-28 | Fairfax city | Virginia | 51600 | 1954 | 42 |
2349532 | 2349532 | 2022-03-27 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2346279 | 2346279 | 2022-03-26 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2343026 | 2343026 | 2022-03-25 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2339773 | 2339773 | 2022-03-24 | Fairfax city | Virginia | 51600 | 1953 | 42 |
2336519 | 2336519 | 2022-03-23 | Fairfax city | Virginia | 51600 | 1954 | 42 |
2333265 | 2333265 | 2022-03-22 | Fairfax city | Virginia | 51600 | 1949 | 42 |
2330012 | 2330012 | 2022-03-21 | Fairfax city | Virginia | 51600 | 1949 | 42 |
2326760 | 2326760 | 2022-03-20 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2323507 | 2323507 | 2022-03-19 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2320253 | 2320253 | 2022-03-18 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2316999 | 2316999 | 2022-03-17 | Fairfax city | Virginia | 51600 | 1947 | 43 |
2313746 | 2313746 | 2022-03-16 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2310493 | 2310493 | 2022-03-15 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2307240 | 2307240 | 2022-03-14 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2303989 | 2303989 | 2022-03-13 | Fairfax city | Virginia | 51600 | 1954 | 43 |
2300737 | 2300737 | 2022-03-12 | Fairfax city | Virginia | 51600 | 1954 | 43 |
2297485 | 2297485 | 2022-03-11 | Fairfax city | Virginia | 51600 | 1954 | 43 |
2294233 | 2294233 | 2022-03-10 | Fairfax city | Virginia | 51600 | 1953 | 43 |
2290981 | 2290981 | 2022-03-09 | Fairfax city | Virginia | 51600 | 1952 | 43 |
2287729 | 2287729 | 2022-03-08 | Fairfax city | Virginia | 51600 | 1952 | 43 |
2284477 | 2284477 | 2022-03-07 | Fairfax city | Virginia | 51600 | 1953 | 43 |
2281225 | 2281225 | 2022-03-06 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2277972 | 2277972 | 2022-03-05 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2274719 | 2274719 | 2022-03-04 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2271466 | 2271466 | 2022-03-03 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2268214 | 2268214 | 2022-03-02 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2264961 | 2264961 | 2022-03-01 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2261711 | 2261711 | 2022-02-28 | Fairfax city | Virginia | 51600 | 1953 | 43 |
2258460 | 2258460 | 2022-02-27 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2255209 | 2255209 | 2022-02-26 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2251958 | 2251958 | 2022-02-25 | Fairfax city | Virginia | 51600 | 1950 | 43 |
2248707 | 2248707 | 2022-02-24 | Fairfax city | Virginia | 51600 | 1952 | 42 |
2245456 | 2245456 | 2022-02-23 | Fairfax city | Virginia | 51600 | 1952 | 41 |
2242205 | 2242205 | 2022-02-22 | Fairfax city | Virginia | 51600 | 1952 | 41 |
2238954 | 2238954 | 2022-02-21 | Fairfax city | Virginia | 51600 | 1952 | 41 |
2235703 | 2235703 | 2022-02-20 | Fairfax city | Virginia | 51600 | 1951 | 40 |
2232452 | 2232452 | 2022-02-19 | Fairfax city | Virginia | 51600 | 1951 | 40 |
2229201 | 2229201 | 2022-02-18 | Fairfax city | Virginia | 51600 | 1951 | 40 |
2225950 | 2225950 | 2022-02-17 | Fairfax city | Virginia | 51600 | 1950 | 40 |
2222699 | 2222699 | 2022-02-16 | Fairfax city | Virginia | 51600 | 1948 | 40 |
2219448 | 2219448 | 2022-02-15 | Fairfax city | Virginia | 51600 | 1946 | 40 |
2216198 | 2216198 | 2022-02-14 | Fairfax city | Virginia | 51600 | 1946 | 40 |
2212947 | 2212947 | 2022-02-13 | Fairfax city | Virginia | 51600 | 1941 | 39 |
2209694 | 2209694 | 2022-02-12 | Fairfax city | Virginia | 51600 | 1941 | 39 |
2206441 | 2206441 | 2022-02-11 | Fairfax city | Virginia | 51600 | 1941 | 39 |
2203188 | 2203188 | 2022-02-10 | Fairfax city | Virginia | 51600 | 1938 | 39 |
2199934 | 2199934 | 2022-02-09 | Fairfax city | Virginia | 51600 | 1936 | 39 |
2196680 | 2196680 | 2022-02-08 | Fairfax city | Virginia | 51600 | 1932 | 39 |
2193425 | 2193425 | 2022-02-07 | Fairfax city | Virginia | 51600 | 1934 | 39 |
2190172 | 2190172 | 2022-02-06 | Fairfax city | Virginia | 51600 | 1928 | 37 |
2186919 | 2186919 | 2022-02-05 | Fairfax city | Virginia | 51600 | 1928 | 37 |
2183666 | 2183666 | 2022-02-04 | Fairfax city | Virginia | 51600 | 1928 | 37 |
2180414 | 2180414 | 2022-02-03 | Fairfax city | Virginia | 51600 | 1924 | 37 |
2177163 | 2177163 | 2022-02-02 | Fairfax city | Virginia | 51600 | 1918 | 37 |
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);