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 = "Creek" 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 · 780 ✖

fips 1

county 1

  • Creek · 780 ✖
Link rowid date ▲ county state fips cases deaths
2501751 2501751 2022-05-13 Creek Oklahoma 40037 18245 338
2498493 2498493 2022-05-12 Creek Oklahoma 40037 18245 338
2495235 2495235 2022-05-11 Creek Oklahoma 40037 18225 337
2491977 2491977 2022-05-10 Creek Oklahoma 40037 18225 337
2488719 2488719 2022-05-09 Creek Oklahoma 40037 18225 337
2485462 2485462 2022-05-08 Creek Oklahoma 40037 18225 337
2482204 2482204 2022-05-07 Creek Oklahoma 40037 18225 337
2478946 2478946 2022-05-06 Creek Oklahoma 40037 18225 337
2475688 2475688 2022-05-05 Creek Oklahoma 40037 18225 337
2472431 2472431 2022-05-04 Creek Oklahoma 40037 18210 336
2469175 2469175 2022-05-03 Creek Oklahoma 40037 18210 336
2465919 2465919 2022-05-02 Creek Oklahoma 40037 18210 336
2462664 2462664 2022-05-01 Creek Oklahoma 40037 18210 336
2459408 2459408 2022-04-30 Creek Oklahoma 40037 18210 336
2456152 2456152 2022-04-29 Creek Oklahoma 40037 18210 336
2452896 2452896 2022-04-28 Creek Oklahoma 40037 18210 336
2449640 2449640 2022-04-27 Creek Oklahoma 40037 18181 334
2446383 2446383 2022-04-26 Creek Oklahoma 40037 18181 334
2443128 2443128 2022-04-25 Creek Oklahoma 40037 18181 334
2439872 2439872 2022-04-24 Creek Oklahoma 40037 18181 334
2436616 2436616 2022-04-23 Creek Oklahoma 40037 18181 334
2433360 2433360 2022-04-22 Creek Oklahoma 40037 18181 334
2430104 2430104 2022-04-21 Creek Oklahoma 40037 18181 334
2426848 2426848 2022-04-20 Creek Oklahoma 40037 18158 333
2423592 2423592 2022-04-19 Creek Oklahoma 40037 18158 333
2420335 2420335 2022-04-18 Creek Oklahoma 40037 18158 333
2417080 2417080 2022-04-17 Creek Oklahoma 40037 18158 333
2413824 2413824 2022-04-16 Creek Oklahoma 40037 18158 333
2410568 2410568 2022-04-15 Creek Oklahoma 40037 18158 333
2407312 2407312 2022-04-14 Creek Oklahoma 40037 18158 333
2404056 2404056 2022-04-13 Creek Oklahoma 40037 18141 333
2400801 2400801 2022-04-12 Creek Oklahoma 40037 18141 333
2397546 2397546 2022-04-11 Creek Oklahoma 40037 18141 333
2394291 2394291 2022-04-10 Creek Oklahoma 40037 18141 333
2391035 2391035 2022-04-09 Creek Oklahoma 40037 18141 333
2387779 2387779 2022-04-08 Creek Oklahoma 40037 18141 333
2384524 2384524 2022-04-07 Creek Oklahoma 40037 18141 333
2381269 2381269 2022-04-06 Creek Oklahoma 40037 18118 332
2378014 2378014 2022-04-05 Creek Oklahoma 40037 18118 332
2374760 2374760 2022-04-04 Creek Oklahoma 40037 18118 332
2371508 2371508 2022-04-03 Creek Oklahoma 40037 18118 332
2368255 2368255 2022-04-02 Creek Oklahoma 40037 18118 332
2365002 2365002 2022-04-01 Creek Oklahoma 40037 18118 332
2361749 2361749 2022-03-31 Creek Oklahoma 40037 18118 332
2358495 2358495 2022-03-30 Creek Oklahoma 40037 18113 329
2355241 2355241 2022-03-29 Creek Oklahoma 40037 18113 329
2351988 2351988 2022-03-28 Creek Oklahoma 40037 18113 329
2348736 2348736 2022-03-27 Creek Oklahoma 40037 18113 329
2345483 2345483 2022-03-26 Creek Oklahoma 40037 18113 329
2342230 2342230 2022-03-25 Creek Oklahoma 40037 18113 329
2338977 2338977 2022-03-24 Creek Oklahoma 40037 18113 329
2335723 2335723 2022-03-23 Creek Oklahoma 40037 18094 324
2332469 2332469 2022-03-22 Creek Oklahoma 40037 18094 324
2329216 2329216 2022-03-21 Creek Oklahoma 40037 18094 324
2325964 2325964 2022-03-20 Creek Oklahoma 40037 18094 324
2322711 2322711 2022-03-19 Creek Oklahoma 40037 18094 324
2319457 2319457 2022-03-18 Creek Oklahoma 40037 18094 324
2316203 2316203 2022-03-17 Creek Oklahoma 40037 18094 324
2312950 2312950 2022-03-16 Creek Oklahoma 40037 18079 319
2309697 2309697 2022-03-15 Creek Oklahoma 40037 18079 319
2306444 2306444 2022-03-14 Creek Oklahoma 40037 18079 319
2303193 2303193 2022-03-13 Creek Oklahoma 40037 18079 319
2299941 2299941 2022-03-12 Creek Oklahoma 40037 18079 319
2296689 2296689 2022-03-11 Creek Oklahoma 40037 18079 319
2293437 2293437 2022-03-10 Creek Oklahoma 40037 18079 319
2290185 2290185 2022-03-09 Creek Oklahoma 40037 18045 312
2286933 2286933 2022-03-08 Creek Oklahoma 40037 18045 312
2283681 2283681 2022-03-07 Creek Oklahoma 40037 18045 312
2280429 2280429 2022-03-06 Creek Oklahoma 40037 18045 312
2277176 2277176 2022-03-05 Creek Oklahoma 40037 18045 312
2273923 2273923 2022-03-04 Creek Oklahoma 40037 18045 312
2270670 2270670 2022-03-03 Creek Oklahoma 40037 18045 312
2267418 2267418 2022-03-02 Creek Oklahoma 40037 18045 312
2264165 2264165 2022-03-01 Creek Oklahoma 40037 17986 306
2260915 2260915 2022-02-28 Creek Oklahoma 40037 17986 306
2257664 2257664 2022-02-27 Creek Oklahoma 40037 17986 306
2254413 2254413 2022-02-26 Creek Oklahoma 40037 17986 306
2251162 2251162 2022-02-25 Creek Oklahoma 40037 17986 306
2247911 2247911 2022-02-24 Creek Oklahoma 40037 17986 306
2244660 2244660 2022-02-23 Creek Oklahoma 40037 17986 306
2241409 2241409 2022-02-22 Creek Oklahoma 40037 17891 303
2238158 2238158 2022-02-21 Creek Oklahoma 40037 17891 303
2234907 2234907 2022-02-20 Creek Oklahoma 40037 17891 303
2231656 2231656 2022-02-19 Creek Oklahoma 40037 17891 303
2228405 2228405 2022-02-18 Creek Oklahoma 40037 17891 303
2225154 2225154 2022-02-17 Creek Oklahoma 40037 17891 303
2221903 2221903 2022-02-16 Creek Oklahoma 40037 17891 303
2218652 2218652 2022-02-15 Creek Oklahoma 40037 17720 296
2215401 2215401 2022-02-14 Creek Oklahoma 40037 17720 296
2212150 2212150 2022-02-13 Creek Oklahoma 40037 17720 296
2208897 2208897 2022-02-12 Creek Oklahoma 40037 17720 296
2205644 2205644 2022-02-11 Creek Oklahoma 40037 17720 296
2202391 2202391 2022-02-10 Creek Oklahoma 40037 17720 296
2199137 2199137 2022-02-09 Creek Oklahoma 40037 17720 296
2195883 2195883 2022-02-08 Creek Oklahoma 40037 17298 291
2192629 2192629 2022-02-07 Creek Oklahoma 40037 17298 291
2189375 2189375 2022-02-06 Creek Oklahoma 40037 17298 291
2186122 2186122 2022-02-05 Creek Oklahoma 40037 17298 291
2182870 2182870 2022-02-04 Creek Oklahoma 40037 17298 291
2179618 2179618 2022-02-03 Creek Oklahoma 40037 17298 291

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