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

1,561 rows where county = "Turner" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 2

fips 2

county 1

  • Turner · 1,561 ✖
Link rowid date ▲ county state fips cases deaths
2500107 2500107 2022-05-13 Turner Georgia 13287 2569 61
2502106 2502106 2022-05-13 Turner South Dakota 46125 1969 62
2496849 2496849 2022-05-12 Turner Georgia 13287 2569 61
2498848 2498848 2022-05-12 Turner South Dakota 46125 1969 62
2493591 2493591 2022-05-11 Turner Georgia 13287 2569 61
2495590 2495590 2022-05-11 Turner South Dakota 46125 1969 62
2490333 2490333 2022-05-10 Turner Georgia 13287 2565 60
2492332 2492332 2022-05-10 Turner South Dakota 46125 1967 62
2487076 2487076 2022-05-09 Turner Georgia 13287 2565 60
2489074 2489074 2022-05-09 Turner South Dakota 46125 1967 62
2483818 2483818 2022-05-08 Turner Georgia 13287 2565 60
2485817 2485817 2022-05-08 Turner South Dakota 46125 1967 62
2480560 2480560 2022-05-07 Turner Georgia 13287 2565 60
2482559 2482559 2022-05-07 Turner South Dakota 46125 1967 62
2477302 2477302 2022-05-06 Turner Georgia 13287 2565 60
2479301 2479301 2022-05-06 Turner South Dakota 46125 1967 62
2474044 2474044 2022-05-05 Turner Georgia 13287 2565 60
2476043 2476043 2022-05-05 Turner South Dakota 46125 1967 62
2470787 2470787 2022-05-04 Turner Georgia 13287 2565 60
2472786 2472786 2022-05-04 Turner South Dakota 46125 1967 62
2467531 2467531 2022-05-03 Turner Georgia 13287 2562 60
2469530 2469530 2022-05-03 Turner South Dakota 46125 1966 62
2464276 2464276 2022-05-02 Turner Georgia 13287 2562 60
2466274 2466274 2022-05-02 Turner South Dakota 46125 1966 62
2461020 2461020 2022-05-01 Turner Georgia 13287 2562 60
2463019 2463019 2022-05-01 Turner South Dakota 46125 1966 62
2457764 2457764 2022-04-30 Turner Georgia 13287 2562 60
2459763 2459763 2022-04-30 Turner South Dakota 46125 1966 62
2454508 2454508 2022-04-29 Turner Georgia 13287 2562 60
2456507 2456507 2022-04-29 Turner South Dakota 46125 1966 62
2451252 2451252 2022-04-28 Turner Georgia 13287 2562 60
2453251 2453251 2022-04-28 Turner South Dakota 46125 1966 62
2447996 2447996 2022-04-27 Turner Georgia 13287 2562 60
2449995 2449995 2022-04-27 Turner South Dakota 46125 1966 62
2444740 2444740 2022-04-26 Turner Georgia 13287 2552 60
2446738 2446738 2022-04-26 Turner South Dakota 46125 1965 62
2441484 2441484 2022-04-25 Turner Georgia 13287 2552 60
2443483 2443483 2022-04-25 Turner South Dakota 46125 1965 62
2438228 2438228 2022-04-24 Turner Georgia 13287 2552 60
2440227 2440227 2022-04-24 Turner South Dakota 46125 1965 62
2434972 2434972 2022-04-23 Turner Georgia 13287 2552 60
2436971 2436971 2022-04-23 Turner South Dakota 46125 1965 62
2431716 2431716 2022-04-22 Turner Georgia 13287 2552 60
2433715 2433715 2022-04-22 Turner South Dakota 46125 1965 62
2428460 2428460 2022-04-21 Turner Georgia 13287 2552 60
2430459 2430459 2022-04-21 Turner South Dakota 46125 1965 62
2425204 2425204 2022-04-20 Turner Georgia 13287 2552 60
2427203 2427203 2022-04-20 Turner South Dakota 46125 1965 62
2421948 2421948 2022-04-19 Turner Georgia 13287 2546 60
2423947 2423947 2022-04-19 Turner South Dakota 46125 1964 62
2418692 2418692 2022-04-18 Turner Georgia 13287 2546 60
2420691 2420691 2022-04-18 Turner South Dakota 46125 1964 62
2415436 2415436 2022-04-17 Turner Georgia 13287 2546 60
2417435 2417435 2022-04-17 Turner South Dakota 46125 1964 62
2412180 2412180 2022-04-16 Turner Georgia 13287 2546 60
2414179 2414179 2022-04-16 Turner South Dakota 46125 1964 62
2408924 2408924 2022-04-15 Turner Georgia 13287 2546 60
2410923 2410923 2022-04-15 Turner South Dakota 46125 1964 62
2405668 2405668 2022-04-14 Turner Georgia 13287 2545 60
2407667 2407667 2022-04-14 Turner South Dakota 46125 1964 62
2402413 2402413 2022-04-13 Turner Georgia 13287 2545 60
2404411 2404411 2022-04-13 Turner South Dakota 46125 1964 62
2399158 2399158 2022-04-12 Turner Georgia 13287 2544 60
2401156 2401156 2022-04-12 Turner South Dakota 46125 1964 62
2395903 2395903 2022-04-11 Turner Georgia 13287 2543 60
2397901 2397901 2022-04-11 Turner South Dakota 46125 1964 62
2392647 2392647 2022-04-10 Turner Georgia 13287 2543 60
2394646 2394646 2022-04-10 Turner South Dakota 46125 1964 62
2389391 2389391 2022-04-09 Turner Georgia 13287 2543 60
2391390 2391390 2022-04-09 Turner South Dakota 46125 1964 62
2386136 2386136 2022-04-08 Turner Georgia 13287 2543 60
2388134 2388134 2022-04-08 Turner South Dakota 46125 1964 62
2382881 2382881 2022-04-07 Turner Georgia 13287 2543 60
2384879 2384879 2022-04-07 Turner South Dakota 46125 1964 62
2379626 2379626 2022-04-06 Turner Georgia 13287 2543 59
2381624 2381624 2022-04-06 Turner South Dakota 46125 1964 62
2376372 2376372 2022-04-05 Turner Georgia 13287 2543 59
2378369 2378369 2022-04-05 Turner South Dakota 46125 1963 62
2373120 2373120 2022-04-04 Turner Georgia 13287 2543 59
2375115 2375115 2022-04-04 Turner South Dakota 46125 1963 62
2369867 2369867 2022-04-03 Turner Georgia 13287 2542 59
2371863 2371863 2022-04-03 Turner South Dakota 46125 1963 62
2366614 2366614 2022-04-02 Turner Georgia 13287 2542 59
2368610 2368610 2022-04-02 Turner South Dakota 46125 1963 62
2363361 2363361 2022-04-01 Turner Georgia 13287 2542 59
2365357 2365357 2022-04-01 Turner South Dakota 46125 1963 62
2360107 2360107 2022-03-31 Turner Georgia 13287 2542 58
2362104 2362104 2022-03-31 Turner South Dakota 46125 1963 62
2356853 2356853 2022-03-30 Turner Georgia 13287 2542 58
2358850 2358850 2022-03-30 Turner South Dakota 46125 1963 62
2353600 2353600 2022-03-29 Turner Georgia 13287 2542 58
2355596 2355596 2022-03-29 Turner South Dakota 46125 1962 62
2350348 2350348 2022-03-28 Turner Georgia 13287 2542 58
2352343 2352343 2022-03-28 Turner South Dakota 46125 1962 62
2347095 2347095 2022-03-27 Turner Georgia 13287 2542 58
2349091 2349091 2022-03-27 Turner South Dakota 46125 1962 62
2343842 2343842 2022-03-26 Turner Georgia 13287 2542 58
2345838 2345838 2022-03-26 Turner South Dakota 46125 1962 62
2340589 2340589 2022-03-25 Turner Georgia 13287 2542 58
2342585 2342585 2022-03-25 Turner South Dakota 46125 1962 62

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