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

788 rows where fips = 40117 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 · 788 ✖

fips 1

  • 40117 · 788 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501791 2501791 2022-05-13 Pawnee Oklahoma 40117 4121 85
2498533 2498533 2022-05-12 Pawnee Oklahoma 40117 4121 85
2495275 2495275 2022-05-11 Pawnee Oklahoma 40117 4115 84
2492017 2492017 2022-05-10 Pawnee Oklahoma 40117 4115 84
2488759 2488759 2022-05-09 Pawnee Oklahoma 40117 4115 84
2485502 2485502 2022-05-08 Pawnee Oklahoma 40117 4115 84
2482244 2482244 2022-05-07 Pawnee Oklahoma 40117 4115 84
2478986 2478986 2022-05-06 Pawnee Oklahoma 40117 4115 84
2475728 2475728 2022-05-05 Pawnee Oklahoma 40117 4115 84
2472471 2472471 2022-05-04 Pawnee Oklahoma 40117 4113 85
2469215 2469215 2022-05-03 Pawnee Oklahoma 40117 4113 85
2465959 2465959 2022-05-02 Pawnee Oklahoma 40117 4113 85
2462704 2462704 2022-05-01 Pawnee Oklahoma 40117 4113 85
2459448 2459448 2022-04-30 Pawnee Oklahoma 40117 4113 85
2456192 2456192 2022-04-29 Pawnee Oklahoma 40117 4113 85
2452936 2452936 2022-04-28 Pawnee Oklahoma 40117 4113 85
2449680 2449680 2022-04-27 Pawnee Oklahoma 40117 4106 85
2446423 2446423 2022-04-26 Pawnee Oklahoma 40117 4106 85
2443168 2443168 2022-04-25 Pawnee Oklahoma 40117 4106 85
2439912 2439912 2022-04-24 Pawnee Oklahoma 40117 4106 85
2436656 2436656 2022-04-23 Pawnee Oklahoma 40117 4106 85
2433400 2433400 2022-04-22 Pawnee Oklahoma 40117 4106 85
2430144 2430144 2022-04-21 Pawnee Oklahoma 40117 4106 85
2426888 2426888 2022-04-20 Pawnee Oklahoma 40117 4100 85
2423632 2423632 2022-04-19 Pawnee Oklahoma 40117 4100 85
2420375 2420375 2022-04-18 Pawnee Oklahoma 40117 4100 85
2417120 2417120 2022-04-17 Pawnee Oklahoma 40117 4100 85
2413864 2413864 2022-04-16 Pawnee Oklahoma 40117 4100 85
2410608 2410608 2022-04-15 Pawnee Oklahoma 40117 4100 85
2407352 2407352 2022-04-14 Pawnee Oklahoma 40117 4100 85
2404096 2404096 2022-04-13 Pawnee Oklahoma 40117 4100 84
2400841 2400841 2022-04-12 Pawnee Oklahoma 40117 4100 84
2397586 2397586 2022-04-11 Pawnee Oklahoma 40117 4100 84
2394331 2394331 2022-04-10 Pawnee Oklahoma 40117 4100 84
2391075 2391075 2022-04-09 Pawnee Oklahoma 40117 4100 84
2387819 2387819 2022-04-08 Pawnee Oklahoma 40117 4100 84
2384564 2384564 2022-04-07 Pawnee Oklahoma 40117 4100 84
2381309 2381309 2022-04-06 Pawnee Oklahoma 40117 4106 84
2378054 2378054 2022-04-05 Pawnee Oklahoma 40117 4106 84
2374800 2374800 2022-04-04 Pawnee Oklahoma 40117 4106 84
2371548 2371548 2022-04-03 Pawnee Oklahoma 40117 4106 84
2368295 2368295 2022-04-02 Pawnee Oklahoma 40117 4106 84
2365042 2365042 2022-04-01 Pawnee Oklahoma 40117 4106 84
2361789 2361789 2022-03-31 Pawnee Oklahoma 40117 4106 84
2358535 2358535 2022-03-30 Pawnee Oklahoma 40117 4103 84
2355281 2355281 2022-03-29 Pawnee Oklahoma 40117 4103 84
2352028 2352028 2022-03-28 Pawnee Oklahoma 40117 4103 84
2348776 2348776 2022-03-27 Pawnee Oklahoma 40117 4103 84
2345523 2345523 2022-03-26 Pawnee Oklahoma 40117 4103 84
2342270 2342270 2022-03-25 Pawnee Oklahoma 40117 4103 84
2339017 2339017 2022-03-24 Pawnee Oklahoma 40117 4103 84
2335763 2335763 2022-03-23 Pawnee Oklahoma 40117 4105 84
2332509 2332509 2022-03-22 Pawnee Oklahoma 40117 4105 84
2329256 2329256 2022-03-21 Pawnee Oklahoma 40117 4105 84
2326004 2326004 2022-03-20 Pawnee Oklahoma 40117 4105 84
2322751 2322751 2022-03-19 Pawnee Oklahoma 40117 4105 84
2319497 2319497 2022-03-18 Pawnee Oklahoma 40117 4105 84
2316243 2316243 2022-03-17 Pawnee Oklahoma 40117 4105 84
2312990 2312990 2022-03-16 Pawnee Oklahoma 40117 4087 83
2309737 2309737 2022-03-15 Pawnee Oklahoma 40117 4087 83
2306484 2306484 2022-03-14 Pawnee Oklahoma 40117 4087 83
2303233 2303233 2022-03-13 Pawnee Oklahoma 40117 4087 83
2299981 2299981 2022-03-12 Pawnee Oklahoma 40117 4087 83
2296729 2296729 2022-03-11 Pawnee Oklahoma 40117 4087 83
2293477 2293477 2022-03-10 Pawnee Oklahoma 40117 4087 83
2290225 2290225 2022-03-09 Pawnee Oklahoma 40117 4069 82
2286973 2286973 2022-03-08 Pawnee Oklahoma 40117 4069 82
2283721 2283721 2022-03-07 Pawnee Oklahoma 40117 4069 82
2280469 2280469 2022-03-06 Pawnee Oklahoma 40117 4069 82
2277216 2277216 2022-03-05 Pawnee Oklahoma 40117 4069 82
2273963 2273963 2022-03-04 Pawnee Oklahoma 40117 4069 82
2270710 2270710 2022-03-03 Pawnee Oklahoma 40117 4069 82
2267458 2267458 2022-03-02 Pawnee Oklahoma 40117 4069 82
2264205 2264205 2022-03-01 Pawnee Oklahoma 40117 4063 79
2260955 2260955 2022-02-28 Pawnee Oklahoma 40117 4063 79
2257704 2257704 2022-02-27 Pawnee Oklahoma 40117 4063 79
2254453 2254453 2022-02-26 Pawnee Oklahoma 40117 4063 79
2251202 2251202 2022-02-25 Pawnee Oklahoma 40117 4063 79
2247951 2247951 2022-02-24 Pawnee Oklahoma 40117 4063 79
2244700 2244700 2022-02-23 Pawnee Oklahoma 40117 4063 79
2241449 2241449 2022-02-22 Pawnee Oklahoma 40117 4048 76
2238198 2238198 2022-02-21 Pawnee Oklahoma 40117 4048 76
2234947 2234947 2022-02-20 Pawnee Oklahoma 40117 4048 76
2231696 2231696 2022-02-19 Pawnee Oklahoma 40117 4048 76
2228445 2228445 2022-02-18 Pawnee Oklahoma 40117 4048 76
2225194 2225194 2022-02-17 Pawnee Oklahoma 40117 4048 76
2221943 2221943 2022-02-16 Pawnee Oklahoma 40117 4048 76
2218692 2218692 2022-02-15 Pawnee Oklahoma 40117 4002 74
2215441 2215441 2022-02-14 Pawnee Oklahoma 40117 4002 74
2212190 2212190 2022-02-13 Pawnee Oklahoma 40117 4002 74
2208937 2208937 2022-02-12 Pawnee Oklahoma 40117 4002 74
2205684 2205684 2022-02-11 Pawnee Oklahoma 40117 4002 74
2202431 2202431 2022-02-10 Pawnee Oklahoma 40117 4002 74
2199177 2199177 2022-02-09 Pawnee Oklahoma 40117 4002 74
2195923 2195923 2022-02-08 Pawnee Oklahoma 40117 3905 73
2192669 2192669 2022-02-07 Pawnee Oklahoma 40117 3905 73
2189415 2189415 2022-02-06 Pawnee Oklahoma 40117 3905 73
2186162 2186162 2022-02-05 Pawnee Oklahoma 40117 3905 73
2182910 2182910 2022-02-04 Pawnee Oklahoma 40117 3905 73
2179658 2179658 2022-02-03 Pawnee Oklahoma 40117 3905 73

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