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

786 rows where county = "Custer" and state = "Oklahoma" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Oklahoma · 786 ✖

fips 1

county 1

  • Custer · 786 ✖
Link rowid date ▲ county state fips cases deaths
2501752 2501752 2022-05-13 Custer Oklahoma 40039 7935 169
2498494 2498494 2022-05-12 Custer Oklahoma 40039 7935 169
2495236 2495236 2022-05-11 Custer Oklahoma 40039 7920 169
2491978 2491978 2022-05-10 Custer Oklahoma 40039 7920 169
2488720 2488720 2022-05-09 Custer Oklahoma 40039 7920 169
2485463 2485463 2022-05-08 Custer Oklahoma 40039 7920 169
2482205 2482205 2022-05-07 Custer Oklahoma 40039 7920 169
2478947 2478947 2022-05-06 Custer Oklahoma 40039 7920 169
2475689 2475689 2022-05-05 Custer Oklahoma 40039 7920 169
2472432 2472432 2022-05-04 Custer Oklahoma 40039 7910 167
2469176 2469176 2022-05-03 Custer Oklahoma 40039 7910 167
2465920 2465920 2022-05-02 Custer Oklahoma 40039 7910 167
2462665 2462665 2022-05-01 Custer Oklahoma 40039 7910 167
2459409 2459409 2022-04-30 Custer Oklahoma 40039 7910 167
2456153 2456153 2022-04-29 Custer Oklahoma 40039 7910 167
2452897 2452897 2022-04-28 Custer Oklahoma 40039 7910 167
2449641 2449641 2022-04-27 Custer Oklahoma 40039 7907 167
2446384 2446384 2022-04-26 Custer Oklahoma 40039 7907 167
2443129 2443129 2022-04-25 Custer Oklahoma 40039 7907 167
2439873 2439873 2022-04-24 Custer Oklahoma 40039 7907 167
2436617 2436617 2022-04-23 Custer Oklahoma 40039 7907 167
2433361 2433361 2022-04-22 Custer Oklahoma 40039 7907 167
2430105 2430105 2022-04-21 Custer Oklahoma 40039 7907 167
2426849 2426849 2022-04-20 Custer Oklahoma 40039 7901 166
2423593 2423593 2022-04-19 Custer Oklahoma 40039 7901 166
2420336 2420336 2022-04-18 Custer Oklahoma 40039 7901 166
2417081 2417081 2022-04-17 Custer Oklahoma 40039 7901 166
2413825 2413825 2022-04-16 Custer Oklahoma 40039 7901 166
2410569 2410569 2022-04-15 Custer Oklahoma 40039 7901 166
2407313 2407313 2022-04-14 Custer Oklahoma 40039 7901 166
2404057 2404057 2022-04-13 Custer Oklahoma 40039 7893 166
2400802 2400802 2022-04-12 Custer Oklahoma 40039 7893 166
2397547 2397547 2022-04-11 Custer Oklahoma 40039 7893 166
2394292 2394292 2022-04-10 Custer Oklahoma 40039 7893 166
2391036 2391036 2022-04-09 Custer Oklahoma 40039 7893 166
2387780 2387780 2022-04-08 Custer Oklahoma 40039 7893 166
2384525 2384525 2022-04-07 Custer Oklahoma 40039 7893 166
2381270 2381270 2022-04-06 Custer Oklahoma 40039 7869 165
2378015 2378015 2022-04-05 Custer Oklahoma 40039 7869 165
2374761 2374761 2022-04-04 Custer Oklahoma 40039 7869 165
2371509 2371509 2022-04-03 Custer Oklahoma 40039 7869 165
2368256 2368256 2022-04-02 Custer Oklahoma 40039 7869 165
2365003 2365003 2022-04-01 Custer Oklahoma 40039 7869 165
2361750 2361750 2022-03-31 Custer Oklahoma 40039 7869 165
2358496 2358496 2022-03-30 Custer Oklahoma 40039 7845 164
2355242 2355242 2022-03-29 Custer Oklahoma 40039 7845 164
2351989 2351989 2022-03-28 Custer Oklahoma 40039 7845 164
2348737 2348737 2022-03-27 Custer Oklahoma 40039 7845 164
2345484 2345484 2022-03-26 Custer Oklahoma 40039 7845 164
2342231 2342231 2022-03-25 Custer Oklahoma 40039 7845 164
2338978 2338978 2022-03-24 Custer Oklahoma 40039 7845 164
2335724 2335724 2022-03-23 Custer Oklahoma 40039 7828 163
2332470 2332470 2022-03-22 Custer Oklahoma 40039 7828 163
2329217 2329217 2022-03-21 Custer Oklahoma 40039 7828 163
2325965 2325965 2022-03-20 Custer Oklahoma 40039 7828 163
2322712 2322712 2022-03-19 Custer Oklahoma 40039 7828 163
2319458 2319458 2022-03-18 Custer Oklahoma 40039 7828 163
2316204 2316204 2022-03-17 Custer Oklahoma 40039 7828 163
2312951 2312951 2022-03-16 Custer Oklahoma 40039 7817 162
2309698 2309698 2022-03-15 Custer Oklahoma 40039 7817 162
2306445 2306445 2022-03-14 Custer Oklahoma 40039 7817 162
2303194 2303194 2022-03-13 Custer Oklahoma 40039 7817 162
2299942 2299942 2022-03-12 Custer Oklahoma 40039 7817 162
2296690 2296690 2022-03-11 Custer Oklahoma 40039 7817 162
2293438 2293438 2022-03-10 Custer Oklahoma 40039 7817 162
2290186 2290186 2022-03-09 Custer Oklahoma 40039 7747 160
2286934 2286934 2022-03-08 Custer Oklahoma 40039 7747 160
2283682 2283682 2022-03-07 Custer Oklahoma 40039 7747 160
2280430 2280430 2022-03-06 Custer Oklahoma 40039 7747 160
2277177 2277177 2022-03-05 Custer Oklahoma 40039 7747 160
2273924 2273924 2022-03-04 Custer Oklahoma 40039 7747 160
2270671 2270671 2022-03-03 Custer Oklahoma 40039 7747 160
2267419 2267419 2022-03-02 Custer Oklahoma 40039 7747 160
2264166 2264166 2022-03-01 Custer Oklahoma 40039 7691 157
2260916 2260916 2022-02-28 Custer Oklahoma 40039 7691 157
2257665 2257665 2022-02-27 Custer Oklahoma 40039 7691 157
2254414 2254414 2022-02-26 Custer Oklahoma 40039 7691 157
2251163 2251163 2022-02-25 Custer Oklahoma 40039 7691 157
2247912 2247912 2022-02-24 Custer Oklahoma 40039 7691 157
2244661 2244661 2022-02-23 Custer Oklahoma 40039 7691 157
2241410 2241410 2022-02-22 Custer Oklahoma 40039 7648 151
2238159 2238159 2022-02-21 Custer Oklahoma 40039 7648 151
2234908 2234908 2022-02-20 Custer Oklahoma 40039 7648 151
2231657 2231657 2022-02-19 Custer Oklahoma 40039 7648 151
2228406 2228406 2022-02-18 Custer Oklahoma 40039 7648 151
2225155 2225155 2022-02-17 Custer Oklahoma 40039 7648 151
2221904 2221904 2022-02-16 Custer Oklahoma 40039 7648 151
2218653 2218653 2022-02-15 Custer Oklahoma 40039 7583 146
2215402 2215402 2022-02-14 Custer Oklahoma 40039 7583 146
2212151 2212151 2022-02-13 Custer Oklahoma 40039 7583 146
2208898 2208898 2022-02-12 Custer Oklahoma 40039 7583 146
2205645 2205645 2022-02-11 Custer Oklahoma 40039 7583 146
2202392 2202392 2022-02-10 Custer Oklahoma 40039 7583 146
2199138 2199138 2022-02-09 Custer Oklahoma 40039 7583 146
2195884 2195884 2022-02-08 Custer Oklahoma 40039 7465 143
2192630 2192630 2022-02-07 Custer Oklahoma 40039 7465 143
2189376 2189376 2022-02-06 Custer Oklahoma 40039 7465 143
2186123 2186123 2022-02-05 Custer Oklahoma 40039 7465 143
2182871 2182871 2022-02-04 Custer Oklahoma 40039 7465 143
2179619 2179619 2022-02-03 Custer Oklahoma 40039 7465 143

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