ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

758 rows where fips = 51057 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

fips 1

  • 51057 · 758 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502546 2502546 2022-05-13 Essex Virginia 51057 2285 33
2499288 2499288 2022-05-12 Essex Virginia 51057 2279 33
2496030 2496030 2022-05-11 Essex Virginia 51057 2278 33
2492772 2492772 2022-05-10 Essex Virginia 51057 2277 33
2489514 2489514 2022-05-09 Essex Virginia 51057 2278 33
2486257 2486257 2022-05-08 Essex Virginia 51057 2277 33
2482999 2482999 2022-05-07 Essex Virginia 51057 2277 33
2479741 2479741 2022-05-06 Essex Virginia 51057 2277 33
2476483 2476483 2022-05-05 Essex Virginia 51057 2274 33
2473225 2473225 2022-05-04 Essex Virginia 51057 2272 33
2469969 2469969 2022-05-03 Essex Virginia 51057 2272 33
2466713 2466713 2022-05-02 Essex Virginia 51057 2271 33
2463458 2463458 2022-05-01 Essex Virginia 51057 2265 33
2460202 2460202 2022-04-30 Essex Virginia 51057 2265 33
2456946 2456946 2022-04-29 Essex Virginia 51057 2265 33
2453690 2453690 2022-04-28 Essex Virginia 51057 2265 33
2450434 2450434 2022-04-27 Essex Virginia 51057 2264 33
2447177 2447177 2022-04-26 Essex Virginia 51057 2263 33
2443922 2443922 2022-04-25 Essex Virginia 51057 2263 33
2440666 2440666 2022-04-24 Essex Virginia 51057 2261 33
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);