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

780 rows where fips = 51125 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 · 780 ✖

fips 1

  • 51125 · 780 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502592 2502592 2022-05-13 Nelson Virginia 51125 2589 36
2499334 2499334 2022-05-12 Nelson Virginia 51125 2586 36
2496076 2496076 2022-05-11 Nelson Virginia 51125 2585 36
2492818 2492818 2022-05-10 Nelson Virginia 51125 2578 35
2489560 2489560 2022-05-09 Nelson Virginia 51125 2572 35
2486303 2486303 2022-05-08 Nelson Virginia 51125 2563 35
2483045 2483045 2022-05-07 Nelson Virginia 51125 2563 35
2479787 2479787 2022-05-06 Nelson Virginia 51125 2563 35
2476529 2476529 2022-05-05 Nelson Virginia 51125 2561 35
2473271 2473271 2022-05-04 Nelson Virginia 51125 2558 35
2470015 2470015 2022-05-03 Nelson Virginia 51125 2554 35
2466759 2466759 2022-05-02 Nelson Virginia 51125 2552 35
2463504 2463504 2022-05-01 Nelson Virginia 51125 2548 35
2460248 2460248 2022-04-30 Nelson Virginia 51125 2548 35
2456992 2456992 2022-04-29 Nelson Virginia 51125 2548 35
2453736 2453736 2022-04-28 Nelson Virginia 51125 2547 35
2450480 2450480 2022-04-27 Nelson Virginia 51125 2546 35
2447223 2447223 2022-04-26 Nelson Virginia 51125 2545 35
2443968 2443968 2022-04-25 Nelson Virginia 51125 2543 35
2440712 2440712 2022-04-24 Nelson Virginia 51125 2540 35
2437456 2437456 2022-04-23 Nelson Virginia 51125 2540 35
2434200 2434200 2022-04-22 Nelson Virginia 51125 2540 35
2430944 2430944 2022-04-21 Nelson Virginia 51125 2542 35
2427688 2427688 2022-04-20 Nelson Virginia 51125 2537 34
2424432 2424432 2022-04-19 Nelson Virginia 51125 2537 33
2421176 2421176 2022-04-18 Nelson Virginia 51125 2536 33
2417920 2417920 2022-04-17 Nelson Virginia 51125 2535 33
2414664 2414664 2022-04-16 Nelson Virginia 51125 2535 33
2411408 2411408 2022-04-15 Nelson Virginia 51125 2535 33
2408152 2408152 2022-04-14 Nelson Virginia 51125 2535 33
2404896 2404896 2022-04-13 Nelson Virginia 51125 2545 34
2401641 2401641 2022-04-12 Nelson Virginia 51125 2554 34
2398386 2398386 2022-04-11 Nelson Virginia 51125 2561 34
2395131 2395131 2022-04-10 Nelson Virginia 51125 2556 34
2391875 2391875 2022-04-09 Nelson Virginia 51125 2556 34
2388619 2388619 2022-04-08 Nelson Virginia 51125 2556 34
2385364 2385364 2022-04-07 Nelson Virginia 51125 2570 34
2382109 2382109 2022-04-06 Nelson Virginia 51125 2593 34
2378854 2378854 2022-04-05 Nelson Virginia 51125 2600 34
2375600 2375600 2022-04-04 Nelson Virginia 51125 2610 32
2372348 2372348 2022-04-03 Nelson Virginia 51125 2628 32
2369095 2369095 2022-04-02 Nelson Virginia 51125 2628 32
2365842 2365842 2022-04-01 Nelson Virginia 51125 2628 32
2362589 2362589 2022-03-31 Nelson Virginia 51125 2657 32
2359335 2359335 2022-03-30 Nelson Virginia 51125 2681 32
2356081 2356081 2022-03-29 Nelson Virginia 51125 2703 33
2352828 2352828 2022-03-28 Nelson Virginia 51125 2707 33
2349576 2349576 2022-03-27 Nelson Virginia 51125 2703 33
2346323 2346323 2022-03-26 Nelson Virginia 51125 2703 33
2343070 2343070 2022-03-25 Nelson Virginia 51125 2703 33
2339817 2339817 2022-03-24 Nelson Virginia 51125 2698 33
2336563 2336563 2022-03-23 Nelson Virginia 51125 2691 33
2333309 2333309 2022-03-22 Nelson Virginia 51125 2688 33
2330056 2330056 2022-03-21 Nelson Virginia 51125 2688 33
2326804 2326804 2022-03-20 Nelson Virginia 51125 2687 32
2323551 2323551 2022-03-19 Nelson Virginia 51125 2687 32
2320297 2320297 2022-03-18 Nelson Virginia 51125 2687 32
2317043 2317043 2022-03-17 Nelson Virginia 51125 2685 32
2313790 2313790 2022-03-16 Nelson Virginia 51125 2683 32
2310537 2310537 2022-03-15 Nelson Virginia 51125 2688 32
2307284 2307284 2022-03-14 Nelson Virginia 51125 2688 32
2304033 2304033 2022-03-13 Nelson Virginia 51125 2684 32
2300781 2300781 2022-03-12 Nelson Virginia 51125 2684 32
2297529 2297529 2022-03-11 Nelson Virginia 51125 2684 32
2294277 2294277 2022-03-10 Nelson Virginia 51125 2684 32
2291025 2291025 2022-03-09 Nelson Virginia 51125 2684 32
2287773 2287773 2022-03-08 Nelson Virginia 51125 2683 32
2284521 2284521 2022-03-07 Nelson Virginia 51125 2682 32
2281269 2281269 2022-03-06 Nelson Virginia 51125 2678 32
2278016 2278016 2022-03-05 Nelson Virginia 51125 2678 32
2274763 2274763 2022-03-04 Nelson Virginia 51125 2678 32
2271510 2271510 2022-03-03 Nelson Virginia 51125 2679 32
2268258 2268258 2022-03-02 Nelson Virginia 51125 2674 32
2265005 2265005 2022-03-01 Nelson Virginia 51125 2674 32
2261755 2261755 2022-02-28 Nelson Virginia 51125 2675 32
2258504 2258504 2022-02-27 Nelson Virginia 51125 2666 32
2255253 2255253 2022-02-26 Nelson Virginia 51125 2666 32
2252002 2252002 2022-02-25 Nelson Virginia 51125 2666 32
2248751 2248751 2022-02-24 Nelson Virginia 51125 2663 32
2245500 2245500 2022-02-23 Nelson Virginia 51125 2661 31
2242249 2242249 2022-02-22 Nelson Virginia 51125 2658 30
2238998 2238998 2022-02-21 Nelson Virginia 51125 2653 29
2235747 2235747 2022-02-20 Nelson Virginia 51125 2643 27
2232496 2232496 2022-02-19 Nelson Virginia 51125 2643 27
2229245 2229245 2022-02-18 Nelson Virginia 51125 2643 27
2225994 2225994 2022-02-17 Nelson Virginia 51125 2642 26
2222743 2222743 2022-02-16 Nelson Virginia 51125 2625 26
2219492 2219492 2022-02-15 Nelson Virginia 51125 2615 26
2216242 2216242 2022-02-14 Nelson Virginia 51125 2604 25
2212991 2212991 2022-02-13 Nelson Virginia 51125 2583 25
2209738 2209738 2022-02-12 Nelson Virginia 51125 2583 25
2206485 2206485 2022-02-11 Nelson Virginia 51125 2583 25
2203232 2203232 2022-02-10 Nelson Virginia 51125 2576 25
2199978 2199978 2022-02-09 Nelson Virginia 51125 2565 25
2196724 2196724 2022-02-08 Nelson Virginia 51125 2556 25
2193469 2193469 2022-02-07 Nelson Virginia 51125 2546 25
2190216 2190216 2022-02-06 Nelson Virginia 51125 2509 25
2186963 2186963 2022-02-05 Nelson Virginia 51125 2509 25
2183710 2183710 2022-02-04 Nelson Virginia 51125 2509 25
2180458 2180458 2022-02-03 Nelson Virginia 51125 2497 25

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