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

773 rows where fips = 51183 and state = "Virginia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Virginia · 773 ✖

fips 1

  • 51183 · 773 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502631 2502631 2022-05-13 Sussex Virginia 51183 2419 42
2499373 2499373 2022-05-12 Sussex Virginia 51183 2416 42
2496115 2496115 2022-05-11 Sussex Virginia 51183 2412 42
2492857 2492857 2022-05-10 Sussex Virginia 51183 2413 42
2489599 2489599 2022-05-09 Sussex Virginia 51183 2411 42
2486342 2486342 2022-05-08 Sussex Virginia 51183 2411 42
2483084 2483084 2022-05-07 Sussex Virginia 51183 2411 42
2479826 2479826 2022-05-06 Sussex Virginia 51183 2411 42
2476568 2476568 2022-05-05 Sussex Virginia 51183 2410 42
2473310 2473310 2022-05-04 Sussex Virginia 51183 2407 42
2470054 2470054 2022-05-03 Sussex Virginia 51183 2409 41
2466798 2466798 2022-05-02 Sussex Virginia 51183 2410 41
2463543 2463543 2022-05-01 Sussex Virginia 51183 2411 41
2460287 2460287 2022-04-30 Sussex Virginia 51183 2411 41
2457031 2457031 2022-04-29 Sussex Virginia 51183 2411 41
2453775 2453775 2022-04-28 Sussex Virginia 51183 2416 41
2450519 2450519 2022-04-27 Sussex Virginia 51183 2416 41
2447262 2447262 2022-04-26 Sussex Virginia 51183 2421 41
2444007 2444007 2022-04-25 Sussex Virginia 51183 2420 41
2440751 2440751 2022-04-24 Sussex Virginia 51183 2422 41
2437495 2437495 2022-04-23 Sussex Virginia 51183 2422 41
2434239 2434239 2022-04-22 Sussex Virginia 51183 2422 41
2430983 2430983 2022-04-21 Sussex Virginia 51183 2423 41
2427727 2427727 2022-04-20 Sussex Virginia 51183 2422 41
2424471 2424471 2022-04-19 Sussex Virginia 51183 2423 41
2421215 2421215 2022-04-18 Sussex Virginia 51183 2425 41
2417959 2417959 2022-04-17 Sussex Virginia 51183 2424 41
2414703 2414703 2022-04-16 Sussex Virginia 51183 2424 41
2411447 2411447 2022-04-15 Sussex Virginia 51183 2424 41
2408191 2408191 2022-04-14 Sussex Virginia 51183 2424 41
2404935 2404935 2022-04-13 Sussex Virginia 51183 2423 41
2401680 2401680 2022-04-12 Sussex Virginia 51183 2422 41
2398425 2398425 2022-04-11 Sussex Virginia 51183 2422 41
2395170 2395170 2022-04-10 Sussex Virginia 51183 2421 41
2391914 2391914 2022-04-09 Sussex Virginia 51183 2421 41
2388658 2388658 2022-04-08 Sussex Virginia 51183 2421 41
2385403 2385403 2022-04-07 Sussex Virginia 51183 2421 40
2382148 2382148 2022-04-06 Sussex Virginia 51183 2420 40
2378893 2378893 2022-04-05 Sussex Virginia 51183 2422 40
2375639 2375639 2022-04-04 Sussex Virginia 51183 2422 40
2372387 2372387 2022-04-03 Sussex Virginia 51183 2422 40
2369134 2369134 2022-04-02 Sussex Virginia 51183 2422 40
2365881 2365881 2022-04-01 Sussex Virginia 51183 2422 40
2362628 2362628 2022-03-31 Sussex Virginia 51183 2422 40
2359374 2359374 2022-03-30 Sussex Virginia 51183 2420 40
2356120 2356120 2022-03-29 Sussex Virginia 51183 2419 40
2352867 2352867 2022-03-28 Sussex Virginia 51183 2417 40
2349615 2349615 2022-03-27 Sussex Virginia 51183 2417 40
2346362 2346362 2022-03-26 Sussex Virginia 51183 2417 40
2343109 2343109 2022-03-25 Sussex Virginia 51183 2417 40
2339856 2339856 2022-03-24 Sussex Virginia 51183 2416 40
2336602 2336602 2022-03-23 Sussex Virginia 51183 2415 40
2333348 2333348 2022-03-22 Sussex Virginia 51183 2413 40
2330095 2330095 2022-03-21 Sussex Virginia 51183 2413 40
2326843 2326843 2022-03-20 Sussex Virginia 51183 2413 40
2323590 2323590 2022-03-19 Sussex Virginia 51183 2413 40
2320336 2320336 2022-03-18 Sussex Virginia 51183 2413 40
2317082 2317082 2022-03-17 Sussex Virginia 51183 2413 40
2313829 2313829 2022-03-16 Sussex Virginia 51183 2412 39
2310576 2310576 2022-03-15 Sussex Virginia 51183 2409 39
2307323 2307323 2022-03-14 Sussex Virginia 51183 2408 39
2304072 2304072 2022-03-13 Sussex Virginia 51183 2409 39
2300820 2300820 2022-03-12 Sussex Virginia 51183 2409 39
2297568 2297568 2022-03-11 Sussex Virginia 51183 2409 39
2294316 2294316 2022-03-10 Sussex Virginia 51183 2408 39
2291064 2291064 2022-03-09 Sussex Virginia 51183 2404 39
2287812 2287812 2022-03-08 Sussex Virginia 51183 2404 39
2284560 2284560 2022-03-07 Sussex Virginia 51183 2405 39
2281308 2281308 2022-03-06 Sussex Virginia 51183 2405 39
2278055 2278055 2022-03-05 Sussex Virginia 51183 2405 39
2274802 2274802 2022-03-04 Sussex Virginia 51183 2405 39
2271549 2271549 2022-03-03 Sussex Virginia 51183 2405 39
2268297 2268297 2022-03-02 Sussex Virginia 51183 2400 39
2265044 2265044 2022-03-01 Sussex Virginia 51183 2399 38
2261794 2261794 2022-02-28 Sussex Virginia 51183 2398 38
2258543 2258543 2022-02-27 Sussex Virginia 51183 2399 38
2255292 2255292 2022-02-26 Sussex Virginia 51183 2399 38
2252041 2252041 2022-02-25 Sussex Virginia 51183 2399 38
2248790 2248790 2022-02-24 Sussex Virginia 51183 2398 38
2245539 2245539 2022-02-23 Sussex Virginia 51183 2396 38
2242288 2242288 2022-02-22 Sussex Virginia 51183 2394 37
2239037 2239037 2022-02-21 Sussex Virginia 51183 2391 37
2235786 2235786 2022-02-20 Sussex Virginia 51183 2378 37
2232535 2232535 2022-02-19 Sussex Virginia 51183 2378 37
2229284 2229284 2022-02-18 Sussex Virginia 51183 2378 37
2226033 2226033 2022-02-17 Sussex Virginia 51183 2376 37
2222782 2222782 2022-02-16 Sussex Virginia 51183 2374 35
2219531 2219531 2022-02-15 Sussex Virginia 51183 2372 34
2216281 2216281 2022-02-14 Sussex Virginia 51183 2368 33
2213030 2213030 2022-02-13 Sussex Virginia 51183 2362 33
2209777 2209777 2022-02-12 Sussex Virginia 51183 2362 33
2206524 2206524 2022-02-11 Sussex Virginia 51183 2362 33
2203271 2203271 2022-02-10 Sussex Virginia 51183 2359 33
2200017 2200017 2022-02-09 Sussex Virginia 51183 2356 33
2196763 2196763 2022-02-08 Sussex Virginia 51183 2353 32
2193508 2193508 2022-02-07 Sussex Virginia 51183 2349 32
2190255 2190255 2022-02-06 Sussex Virginia 51183 2363 32
2187002 2187002 2022-02-05 Sussex Virginia 51183 2363 32
2183749 2183749 2022-02-04 Sussex Virginia 51183 2363 32
2180497 2180497 2022-02-03 Sussex Virginia 51183 2342 32

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