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 county = "Clay" and fips = 1027 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

  • 1027 · 780 ✖

county 1

  • Clay · 780 ✖
Link rowid date ▲ county state fips cases deaths
2499588 2499588 2022-05-13 Clay Alabama 1027 4099 82
2496330 2496330 2022-05-12 Clay Alabama 1027 4097 82
2493072 2493072 2022-05-11 Clay Alabama 1027 4092 82
2489814 2489814 2022-05-10 Clay Alabama 1027 4092 82
2486557 2486557 2022-05-09 Clay Alabama 1027 4091 82
2483299 2483299 2022-05-08 Clay Alabama 1027 4090 82
2480041 2480041 2022-05-07 Clay Alabama 1027 4090 82
2476783 2476783 2022-05-06 Clay Alabama 1027 4090 82
2473525 2473525 2022-05-05 Clay Alabama 1027 4090 82
2470268 2470268 2022-05-04 Clay Alabama 1027 4089 82
2467012 2467012 2022-05-03 Clay Alabama 1027 4089 82
2463757 2463757 2022-05-02 Clay Alabama 1027 4088 82
2460501 2460501 2022-05-01 Clay Alabama 1027 4086 82
2457245 2457245 2022-04-30 Clay Alabama 1027 4086 82
2453989 2453989 2022-04-29 Clay Alabama 1027 4086 82
2450733 2450733 2022-04-28 Clay Alabama 1027 4085 82
2447477 2447477 2022-04-27 Clay Alabama 1027 4085 82
2444221 2444221 2022-04-26 Clay Alabama 1027 4085 82
2440965 2440965 2022-04-25 Clay Alabama 1027 4084 82
2437709 2437709 2022-04-24 Clay Alabama 1027 4085 82
2434453 2434453 2022-04-23 Clay Alabama 1027 4085 82
2431197 2431197 2022-04-22 Clay Alabama 1027 4085 82
2427941 2427941 2022-04-21 Clay Alabama 1027 4083 82
2424685 2424685 2022-04-20 Clay Alabama 1027 4082 82
2421429 2421429 2022-04-19 Clay Alabama 1027 4082 81
2418173 2418173 2022-04-18 Clay Alabama 1027 4081 81
2414917 2414917 2022-04-17 Clay Alabama 1027 4081 81
2411661 2411661 2022-04-16 Clay Alabama 1027 4081 81
2408405 2408405 2022-04-15 Clay Alabama 1027 4081 81
2405149 2405149 2022-04-14 Clay Alabama 1027 4080 81
2401894 2401894 2022-04-13 Clay Alabama 1027 4080 81
2398639 2398639 2022-04-12 Clay Alabama 1027 4080 81
2395384 2395384 2022-04-11 Clay Alabama 1027 4080 81
2392128 2392128 2022-04-10 Clay Alabama 1027 4080 81
2388872 2388872 2022-04-09 Clay Alabama 1027 4080 81
2385617 2385617 2022-04-08 Clay Alabama 1027 4080 81
2382362 2382362 2022-04-07 Clay Alabama 1027 4080 81
2379107 2379107 2022-04-06 Clay Alabama 1027 4083 81
2375853 2375853 2022-04-05 Clay Alabama 1027 4083 81
2372601 2372601 2022-04-04 Clay Alabama 1027 4083 81
2369348 2369348 2022-04-03 Clay Alabama 1027 4083 81
2366095 2366095 2022-04-02 Clay Alabama 1027 4083 81
2362842 2362842 2022-04-01 Clay Alabama 1027 4083 81
2359588 2359588 2022-03-31 Clay Alabama 1027 4083 81
2356334 2356334 2022-03-30 Clay Alabama 1027 4089 81
2353081 2353081 2022-03-29 Clay Alabama 1027 4084 81
2349829 2349829 2022-03-28 Clay Alabama 1027 4084 81
2346576 2346576 2022-03-27 Clay Alabama 1027 4085 81
2343323 2343323 2022-03-26 Clay Alabama 1027 4085 81
2340070 2340070 2022-03-25 Clay Alabama 1027 4085 81
2336817 2336817 2022-03-24 Clay Alabama 1027 4083 81
2333563 2333563 2022-03-23 Clay Alabama 1027 4081 81
2330309 2330309 2022-03-22 Clay Alabama 1027 4084 81
2327057 2327057 2022-03-21 Clay Alabama 1027 4087 81
2323804 2323804 2022-03-20 Clay Alabama 1027 4086 81
2320550 2320550 2022-03-19 Clay Alabama 1027 4086 81
2317296 2317296 2022-03-18 Clay Alabama 1027 4086 81
2314043 2314043 2022-03-17 Clay Alabama 1027 4086 81
2310790 2310790 2022-03-16 Clay Alabama 1027 4085 81
2307537 2307537 2022-03-15 Clay Alabama 1027 4087 81
2304286 2304286 2022-03-14 Clay Alabama 1027 4084 80
2301034 2301034 2022-03-13 Clay Alabama 1027 4084 80
2297782 2297782 2022-03-12 Clay Alabama 1027 4084 80
2294530 2294530 2022-03-11 Clay Alabama 1027 4084 80
2291278 2291278 2022-03-10 Clay Alabama 1027 4084 78
2288026 2288026 2022-03-09 Clay Alabama 1027 4082 78
2284774 2284774 2022-03-08 Clay Alabama 1027 4080 78
2281522 2281522 2022-03-07 Clay Alabama 1027 4078 78
2278269 2278269 2022-03-06 Clay Alabama 1027 4078 78
2275016 2275016 2022-03-05 Clay Alabama 1027 4078 78
2271763 2271763 2022-03-04 Clay Alabama 1027 4078 78
2268511 2268511 2022-03-03 Clay Alabama 1027 4077 78
2265258 2265258 2022-03-02 Clay Alabama 1027 4069 76
2262008 2262008 2022-03-01 Clay Alabama 1027 4066 76
2258757 2258757 2022-02-28 Clay Alabama 1027 4065 76
2255506 2255506 2022-02-27 Clay Alabama 1027 4065 76
2252255 2252255 2022-02-26 Clay Alabama 1027 4065 76
2249004 2249004 2022-02-25 Clay Alabama 1027 4064 76
2245753 2245753 2022-02-24 Clay Alabama 1027 4064 75
2242502 2242502 2022-02-23 Clay Alabama 1027 4064 74
2239251 2239251 2022-02-22 Clay Alabama 1027 4061 74
2236000 2236000 2022-02-21 Clay Alabama 1027 4059 74
2232749 2232749 2022-02-20 Clay Alabama 1027 4057 74
2229498 2229498 2022-02-19 Clay Alabama 1027 4056 74
2226247 2226247 2022-02-18 Clay Alabama 1027 4047 73
2222996 2222996 2022-02-17 Clay Alabama 1027 4045 73
2219745 2219745 2022-02-16 Clay Alabama 1027 4038 73
2216495 2216495 2022-02-15 Clay Alabama 1027 4038 73
2213244 2213244 2022-02-14 Clay Alabama 1027 4039 73
2209991 2209991 2022-02-13 Clay Alabama 1027 4035 73
2206738 2206738 2022-02-12 Clay Alabama 1027 4033 73
2203485 2203485 2022-02-11 Clay Alabama 1027 4026 73
2200231 2200231 2022-02-10 Clay Alabama 1027 4021 73
2196977 2196977 2022-02-09 Clay Alabama 1027 4012 73
2193722 2193722 2022-02-08 Clay Alabama 1027 3989 72
2190469 2190469 2022-02-07 Clay Alabama 1027 3966 72
2187216 2187216 2022-02-06 Clay Alabama 1027 3957 72
2183963 2183963 2022-02-05 Clay Alabama 1027 3957 72
2180711 2180711 2022-02-04 Clay Alabama 1027 3955 72
2177460 2177460 2022-02-03 Clay Alabama 1027 3932 72

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