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

765 rows where fips = 51063 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

  • 51063 · 765 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2502551 2502551 2022-05-13 Floyd Virginia 51063 2587 49
2499293 2499293 2022-05-12 Floyd Virginia 51063 2583 49
2496035 2496035 2022-05-11 Floyd Virginia 51063 2580 49
2492777 2492777 2022-05-10 Floyd Virginia 51063 2579 49
2489519 2489519 2022-05-09 Floyd Virginia 51063 2579 49
2486262 2486262 2022-05-08 Floyd Virginia 51063 2574 49
2483004 2483004 2022-05-07 Floyd Virginia 51063 2574 49
2479746 2479746 2022-05-06 Floyd Virginia 51063 2574 49
2476488 2476488 2022-05-05 Floyd Virginia 51063 2570 49
2473230 2473230 2022-05-04 Floyd Virginia 51063 2565 49
2469974 2469974 2022-05-03 Floyd Virginia 51063 2564 49
2466718 2466718 2022-05-02 Floyd Virginia 51063 2564 49
2463463 2463463 2022-05-01 Floyd Virginia 51063 2560 49
2460207 2460207 2022-04-30 Floyd Virginia 51063 2560 49
2456951 2456951 2022-04-29 Floyd Virginia 51063 2560 49
2453695 2453695 2022-04-28 Floyd Virginia 51063 2559 49
2450439 2450439 2022-04-27 Floyd Virginia 51063 2556 49
2447182 2447182 2022-04-26 Floyd Virginia 51063 2556 49
2443927 2443927 2022-04-25 Floyd Virginia 51063 2556 49
2440671 2440671 2022-04-24 Floyd Virginia 51063 2556 49
2437415 2437415 2022-04-23 Floyd Virginia 51063 2556 49
2434159 2434159 2022-04-22 Floyd Virginia 51063 2556 49
2430903 2430903 2022-04-21 Floyd Virginia 51063 2555 49
2427647 2427647 2022-04-20 Floyd Virginia 51063 2556 49
2424391 2424391 2022-04-19 Floyd Virginia 51063 2554 47
2421135 2421135 2022-04-18 Floyd Virginia 51063 2554 47
2417879 2417879 2022-04-17 Floyd Virginia 51063 2552 47
2414623 2414623 2022-04-16 Floyd Virginia 51063 2552 47
2411367 2411367 2022-04-15 Floyd Virginia 51063 2552 47
2408111 2408111 2022-04-14 Floyd Virginia 51063 2552 47
2404855 2404855 2022-04-13 Floyd Virginia 51063 2552 47
2401600 2401600 2022-04-12 Floyd Virginia 51063 2552 47
2398345 2398345 2022-04-11 Floyd Virginia 51063 2552 47
2395090 2395090 2022-04-10 Floyd Virginia 51063 2552 47
2391834 2391834 2022-04-09 Floyd Virginia 51063 2552 47
2388578 2388578 2022-04-08 Floyd Virginia 51063 2552 47
2385323 2385323 2022-04-07 Floyd Virginia 51063 2552 47
2382068 2382068 2022-04-06 Floyd Virginia 51063 2552 47
2378813 2378813 2022-04-05 Floyd Virginia 51063 2553 47
2375559 2375559 2022-04-04 Floyd Virginia 51063 2553 47
2372307 2372307 2022-04-03 Floyd Virginia 51063 2553 47
2369054 2369054 2022-04-02 Floyd Virginia 51063 2553 47
2365801 2365801 2022-04-01 Floyd Virginia 51063 2553 47
2362548 2362548 2022-03-31 Floyd Virginia 51063 2552 47
2359294 2359294 2022-03-30 Floyd Virginia 51063 2553 46
2356040 2356040 2022-03-29 Floyd Virginia 51063 2553 46
2352787 2352787 2022-03-28 Floyd Virginia 51063 2554 46
2349535 2349535 2022-03-27 Floyd Virginia 51063 2553 46
2346282 2346282 2022-03-26 Floyd Virginia 51063 2553 46
2343029 2343029 2022-03-25 Floyd Virginia 51063 2553 46
2339776 2339776 2022-03-24 Floyd Virginia 51063 2551 46
2336522 2336522 2022-03-23 Floyd Virginia 51063 2549 46
2333268 2333268 2022-03-22 Floyd Virginia 51063 2546 46
2330015 2330015 2022-03-21 Floyd Virginia 51063 2546 46
2326763 2326763 2022-03-20 Floyd Virginia 51063 2544 46
2323510 2323510 2022-03-19 Floyd Virginia 51063 2544 46
2320256 2320256 2022-03-18 Floyd Virginia 51063 2544 46
2317002 2317002 2022-03-17 Floyd Virginia 51063 2541 46
2313749 2313749 2022-03-16 Floyd Virginia 51063 2539 46
2310496 2310496 2022-03-15 Floyd Virginia 51063 2537 46
2307243 2307243 2022-03-14 Floyd Virginia 51063 2537 46
2303992 2303992 2022-03-13 Floyd Virginia 51063 2536 45
2300740 2300740 2022-03-12 Floyd Virginia 51063 2536 45
2297488 2297488 2022-03-11 Floyd Virginia 51063 2536 45
2294236 2294236 2022-03-10 Floyd Virginia 51063 2533 45
2290984 2290984 2022-03-09 Floyd Virginia 51063 2533 45
2287732 2287732 2022-03-08 Floyd Virginia 51063 2531 45
2284480 2284480 2022-03-07 Floyd Virginia 51063 2531 45
2281228 2281228 2022-03-06 Floyd Virginia 51063 2527 45
2277975 2277975 2022-03-05 Floyd Virginia 51063 2527 45
2274722 2274722 2022-03-04 Floyd Virginia 51063 2527 45
2271469 2271469 2022-03-03 Floyd Virginia 51063 2512 44
2268217 2268217 2022-03-02 Floyd Virginia 51063 2509 44
2264964 2264964 2022-03-01 Floyd Virginia 51063 2499 43
2261714 2261714 2022-02-28 Floyd Virginia 51063 2495 43
2258463 2258463 2022-02-27 Floyd Virginia 51063 2474 42
2255212 2255212 2022-02-26 Floyd Virginia 51063 2474 42
2251961 2251961 2022-02-25 Floyd Virginia 51063 2474 42
2248710 2248710 2022-02-24 Floyd Virginia 51063 2468 42
2245459 2245459 2022-02-23 Floyd Virginia 51063 2464 42
2242208 2242208 2022-02-22 Floyd Virginia 51063 2445 42
2238957 2238957 2022-02-21 Floyd Virginia 51063 2436 42
2235706 2235706 2022-02-20 Floyd Virginia 51063 2411 42
2232455 2232455 2022-02-19 Floyd Virginia 51063 2411 42
2229204 2229204 2022-02-18 Floyd Virginia 51063 2411 42
2225953 2225953 2022-02-17 Floyd Virginia 51063 2408 41
2222702 2222702 2022-02-16 Floyd Virginia 51063 2406 40
2219451 2219451 2022-02-15 Floyd Virginia 51063 2399 40
2216201 2216201 2022-02-14 Floyd Virginia 51063 2398 40
2212950 2212950 2022-02-13 Floyd Virginia 51063 2380 36
2209697 2209697 2022-02-12 Floyd Virginia 51063 2380 36
2206444 2206444 2022-02-11 Floyd Virginia 51063 2380 36
2203191 2203191 2022-02-10 Floyd Virginia 51063 2368 36
2199937 2199937 2022-02-09 Floyd Virginia 51063 2365 36
2196683 2196683 2022-02-08 Floyd Virginia 51063 2355 36
2193428 2193428 2022-02-07 Floyd Virginia 51063 2344 36
2190175 2190175 2022-02-06 Floyd Virginia 51063 2317 34
2186922 2186922 2022-02-05 Floyd Virginia 51063 2317 34
2183669 2183669 2022-02-04 Floyd Virginia 51063 2317 34
2180417 2180417 2022-02-03 Floyd Virginia 51063 2301 33

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