ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
758 rows where county = "Essex" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2437410 | 2437410 | 2022-04-23 | Essex | Virginia | 51057 | 2261 | 33 |
2434154 | 2434154 | 2022-04-22 | Essex | Virginia | 51057 | 2261 | 33 |
2430898 | 2430898 | 2022-04-21 | Essex | Virginia | 51057 | 2260 | 32 |
2427642 | 2427642 | 2022-04-20 | Essex | Virginia | 51057 | 2259 | 32 |
2424386 | 2424386 | 2022-04-19 | Essex | Virginia | 51057 | 2258 | 32 |
2421130 | 2421130 | 2022-04-18 | Essex | Virginia | 51057 | 2259 | 32 |
2417874 | 2417874 | 2022-04-17 | Essex | Virginia | 51057 | 2258 | 32 |
2414618 | 2414618 | 2022-04-16 | Essex | Virginia | 51057 | 2258 | 32 |
2411362 | 2411362 | 2022-04-15 | Essex | Virginia | 51057 | 2258 | 32 |
2408106 | 2408106 | 2022-04-14 | Essex | Virginia | 51057 | 2259 | 32 |
2404850 | 2404850 | 2022-04-13 | Essex | Virginia | 51057 | 2257 | 32 |
2401595 | 2401595 | 2022-04-12 | Essex | Virginia | 51057 | 2257 | 32 |
2398340 | 2398340 | 2022-04-11 | Essex | Virginia | 51057 | 2257 | 32 |
2395085 | 2395085 | 2022-04-10 | Essex | Virginia | 51057 | 2257 | 32 |
2391829 | 2391829 | 2022-04-09 | Essex | Virginia | 51057 | 2257 | 32 |
2388573 | 2388573 | 2022-04-08 | Essex | Virginia | 51057 | 2257 | 32 |
2385318 | 2385318 | 2022-04-07 | Essex | Virginia | 51057 | 2257 | 32 |
2382063 | 2382063 | 2022-04-06 | Essex | Virginia | 51057 | 2256 | 32 |
2378808 | 2378808 | 2022-04-05 | Essex | Virginia | 51057 | 2256 | 32 |
2375554 | 2375554 | 2022-04-04 | Essex | Virginia | 51057 | 2256 | 32 |
2372302 | 2372302 | 2022-04-03 | Essex | Virginia | 51057 | 2256 | 32 |
2369049 | 2369049 | 2022-04-02 | Essex | Virginia | 51057 | 2256 | 32 |
2365796 | 2365796 | 2022-04-01 | Essex | Virginia | 51057 | 2256 | 32 |
2362543 | 2362543 | 2022-03-31 | Essex | Virginia | 51057 | 2256 | 32 |
2359289 | 2359289 | 2022-03-30 | Essex | Virginia | 51057 | 2256 | 32 |
2356035 | 2356035 | 2022-03-29 | Essex | Virginia | 51057 | 2256 | 32 |
2352782 | 2352782 | 2022-03-28 | Essex | Virginia | 51057 | 2256 | 32 |
2349530 | 2349530 | 2022-03-27 | Essex | Virginia | 51057 | 2255 | 32 |
2346277 | 2346277 | 2022-03-26 | Essex | Virginia | 51057 | 2255 | 32 |
2343024 | 2343024 | 2022-03-25 | Essex | Virginia | 51057 | 2255 | 32 |
2339771 | 2339771 | 2022-03-24 | Essex | Virginia | 51057 | 2255 | 32 |
2336517 | 2336517 | 2022-03-23 | Essex | Virginia | 51057 | 2255 | 32 |
2333263 | 2333263 | 2022-03-22 | Essex | Virginia | 51057 | 2252 | 31 |
2330010 | 2330010 | 2022-03-21 | Essex | Virginia | 51057 | 2252 | 31 |
2326758 | 2326758 | 2022-03-20 | Essex | Virginia | 51057 | 2250 | 31 |
2323505 | 2323505 | 2022-03-19 | Essex | Virginia | 51057 | 2250 | 31 |
2320251 | 2320251 | 2022-03-18 | Essex | Virginia | 51057 | 2250 | 31 |
2316997 | 2316997 | 2022-03-17 | Essex | Virginia | 51057 | 2250 | 31 |
2313744 | 2313744 | 2022-03-16 | Essex | Virginia | 51057 | 2250 | 31 |
2310491 | 2310491 | 2022-03-15 | Essex | Virginia | 51057 | 2249 | 31 |
2307238 | 2307238 | 2022-03-14 | Essex | Virginia | 51057 | 2248 | 31 |
2303987 | 2303987 | 2022-03-13 | Essex | Virginia | 51057 | 2247 | 31 |
2300735 | 2300735 | 2022-03-12 | Essex | Virginia | 51057 | 2247 | 31 |
2297483 | 2297483 | 2022-03-11 | Essex | Virginia | 51057 | 2247 | 31 |
2294231 | 2294231 | 2022-03-10 | Essex | Virginia | 51057 | 2247 | 31 |
2290979 | 2290979 | 2022-03-09 | Essex | Virginia | 51057 | 2247 | 31 |
2287727 | 2287727 | 2022-03-08 | Essex | Virginia | 51057 | 2247 | 31 |
2284475 | 2284475 | 2022-03-07 | Essex | Virginia | 51057 | 2246 | 31 |
2281223 | 2281223 | 2022-03-06 | Essex | Virginia | 51057 | 2243 | 31 |
2277970 | 2277970 | 2022-03-05 | Essex | Virginia | 51057 | 2243 | 31 |
2274717 | 2274717 | 2022-03-04 | Essex | Virginia | 51057 | 2243 | 31 |
2271464 | 2271464 | 2022-03-03 | Essex | Virginia | 51057 | 2240 | 31 |
2268212 | 2268212 | 2022-03-02 | Essex | Virginia | 51057 | 2238 | 31 |
2264959 | 2264959 | 2022-03-01 | Essex | Virginia | 51057 | 2238 | 30 |
2261709 | 2261709 | 2022-02-28 | Essex | Virginia | 51057 | 2236 | 30 |
2258458 | 2258458 | 2022-02-27 | Essex | Virginia | 51057 | 2227 | 28 |
2255207 | 2255207 | 2022-02-26 | Essex | Virginia | 51057 | 2227 | 28 |
2251956 | 2251956 | 2022-02-25 | Essex | Virginia | 51057 | 2227 | 28 |
2248705 | 2248705 | 2022-02-24 | Essex | Virginia | 51057 | 2226 | 28 |
2245454 | 2245454 | 2022-02-23 | Essex | Virginia | 51057 | 2223 | 28 |
2242203 | 2242203 | 2022-02-22 | Essex | Virginia | 51057 | 2223 | 28 |
2238952 | 2238952 | 2022-02-21 | Essex | Virginia | 51057 | 2219 | 26 |
2235701 | 2235701 | 2022-02-20 | Essex | Virginia | 51057 | 2212 | 26 |
2232450 | 2232450 | 2022-02-19 | Essex | Virginia | 51057 | 2212 | 26 |
2229199 | 2229199 | 2022-02-18 | Essex | Virginia | 51057 | 2212 | 26 |
2225948 | 2225948 | 2022-02-17 | Essex | Virginia | 51057 | 2210 | 25 |
2222697 | 2222697 | 2022-02-16 | Essex | Virginia | 51057 | 2205 | 25 |
2219446 | 2219446 | 2022-02-15 | Essex | Virginia | 51057 | 2203 | 24 |
2216196 | 2216196 | 2022-02-14 | Essex | Virginia | 51057 | 2199 | 24 |
2212945 | 2212945 | 2022-02-13 | Essex | Virginia | 51057 | 2187 | 24 |
2209692 | 2209692 | 2022-02-12 | Essex | Virginia | 51057 | 2187 | 24 |
2206439 | 2206439 | 2022-02-11 | Essex | Virginia | 51057 | 2187 | 24 |
2203186 | 2203186 | 2022-02-10 | Essex | Virginia | 51057 | 2183 | 24 |
2199932 | 2199932 | 2022-02-09 | Essex | Virginia | 51057 | 2178 | 24 |
2196678 | 2196678 | 2022-02-08 | Essex | Virginia | 51057 | 2171 | 24 |
2193423 | 2193423 | 2022-02-07 | Essex | Virginia | 51057 | 2168 | 24 |
2190170 | 2190170 | 2022-02-06 | Essex | Virginia | 51057 | 2145 | 24 |
2186917 | 2186917 | 2022-02-05 | Essex | Virginia | 51057 | 2145 | 24 |
2183664 | 2183664 | 2022-02-04 | Essex | Virginia | 51057 | 2145 | 24 |
2180412 | 2180412 | 2022-02-03 | Essex | Virginia | 51057 | 2139 | 23 |
2177161 | 2177161 | 2022-02-02 | Essex | Virginia | 51057 | 2128 | 23 |
2173908 | 2173908 | 2022-02-01 | Essex | Virginia | 51057 | 2122 | 23 |
2170656 | 2170656 | 2022-01-31 | Essex | Virginia | 51057 | 2118 | 23 |
2167403 | 2167403 | 2022-01-30 | Essex | Virginia | 51057 | 2089 | 22 |
2164148 | 2164148 | 2022-01-29 | Essex | Virginia | 51057 | 2089 | 22 |
2160893 | 2160893 | 2022-01-28 | Essex | Virginia | 51057 | 2089 | 22 |
2157637 | 2157637 | 2022-01-27 | Essex | Virginia | 51057 | 2074 | 22 |
2154384 | 2154384 | 2022-01-26 | Essex | Virginia | 51057 | 2060 | 22 |
2151131 | 2151131 | 2022-01-25 | Essex | Virginia | 51057 | 2050 | 22 |
2147879 | 2147879 | 2022-01-24 | Essex | Virginia | 51057 | 2035 | 22 |
2144626 | 2144626 | 2022-01-23 | Essex | Virginia | 51057 | 1986 | 22 |
2141371 | 2141371 | 2022-01-22 | Essex | Virginia | 51057 | 1986 | 22 |
2138115 | 2138115 | 2022-01-21 | Essex | Virginia | 51057 | 1986 | 22 |
2134861 | 2134861 | 2022-01-20 | Essex | Virginia | 51057 | 1968 | 22 |
2131609 | 2131609 | 2022-01-19 | Essex | Virginia | 51057 | 1961 | 22 |
2128355 | 2128355 | 2022-01-18 | Essex | Virginia | 51057 | 1931 | 22 |
2125102 | 2125102 | 2022-01-17 | Essex | Virginia | 51057 | 1923 | 22 |
2121850 | 2121850 | 2022-01-16 | Essex | Virginia | 51057 | 1860 | 22 |
2118598 | 2118598 | 2022-01-15 | Essex | Virginia | 51057 | 1860 | 22 |
2115346 | 2115346 | 2022-01-14 | Essex | Virginia | 51057 | 1860 | 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);