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 fips = 40113 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

  • 40113 · 780 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501789 2501789 2022-05-13 Osage Oklahoma 40113 10965 167
2498531 2498531 2022-05-12 Osage Oklahoma 40113 10965 167
2495273 2495273 2022-05-11 Osage Oklahoma 40113 10940 167
2492015 2492015 2022-05-10 Osage Oklahoma 40113 10940 167
2488757 2488757 2022-05-09 Osage Oklahoma 40113 10940 167
2485500 2485500 2022-05-08 Osage Oklahoma 40113 10940 167
2482242 2482242 2022-05-07 Osage Oklahoma 40113 10940 167
2478984 2478984 2022-05-06 Osage Oklahoma 40113 10940 167
2475726 2475726 2022-05-05 Osage Oklahoma 40113 10940 167
2472469 2472469 2022-05-04 Osage Oklahoma 40113 10923 166
2469213 2469213 2022-05-03 Osage Oklahoma 40113 10923 166
2465957 2465957 2022-05-02 Osage Oklahoma 40113 10923 166
2462702 2462702 2022-05-01 Osage Oklahoma 40113 10923 166
2459446 2459446 2022-04-30 Osage Oklahoma 40113 10923 166
2456190 2456190 2022-04-29 Osage Oklahoma 40113 10923 166
2452934 2452934 2022-04-28 Osage Oklahoma 40113 10923 166
2449678 2449678 2022-04-27 Osage Oklahoma 40113 10918 167
2446421 2446421 2022-04-26 Osage Oklahoma 40113 10918 167
2443166 2443166 2022-04-25 Osage Oklahoma 40113 10918 167
2439910 2439910 2022-04-24 Osage Oklahoma 40113 10918 167
2436654 2436654 2022-04-23 Osage Oklahoma 40113 10918 167
2433398 2433398 2022-04-22 Osage Oklahoma 40113 10918 167
2430142 2430142 2022-04-21 Osage Oklahoma 40113 10918 167
2426886 2426886 2022-04-20 Osage Oklahoma 40113 10913 167
2423630 2423630 2022-04-19 Osage Oklahoma 40113 10913 167
2420373 2420373 2022-04-18 Osage Oklahoma 40113 10913 167
2417118 2417118 2022-04-17 Osage Oklahoma 40113 10913 167
2413862 2413862 2022-04-16 Osage Oklahoma 40113 10913 167
2410606 2410606 2022-04-15 Osage Oklahoma 40113 10913 167
2407350 2407350 2022-04-14 Osage Oklahoma 40113 10913 167
2404094 2404094 2022-04-13 Osage Oklahoma 40113 10913 167
2400839 2400839 2022-04-12 Osage Oklahoma 40113 10913 167
2397584 2397584 2022-04-11 Osage Oklahoma 40113 10913 167
2394329 2394329 2022-04-10 Osage Oklahoma 40113 10913 167
2391073 2391073 2022-04-09 Osage Oklahoma 40113 10913 167
2387817 2387817 2022-04-08 Osage Oklahoma 40113 10913 167
2384562 2384562 2022-04-07 Osage Oklahoma 40113 10913 167
2381307 2381307 2022-04-06 Osage Oklahoma 40113 10899 166
2378052 2378052 2022-04-05 Osage Oklahoma 40113 10899 166
2374798 2374798 2022-04-04 Osage Oklahoma 40113 10899 166
2371546 2371546 2022-04-03 Osage Oklahoma 40113 10899 166
2368293 2368293 2022-04-02 Osage Oklahoma 40113 10899 166
2365040 2365040 2022-04-01 Osage Oklahoma 40113 10899 166
2361787 2361787 2022-03-31 Osage Oklahoma 40113 10899 166
2358533 2358533 2022-03-30 Osage Oklahoma 40113 10881 165
2355279 2355279 2022-03-29 Osage Oklahoma 40113 10881 165
2352026 2352026 2022-03-28 Osage Oklahoma 40113 10881 165
2348774 2348774 2022-03-27 Osage Oklahoma 40113 10881 165
2345521 2345521 2022-03-26 Osage Oklahoma 40113 10881 165
2342268 2342268 2022-03-25 Osage Oklahoma 40113 10881 165
2339015 2339015 2022-03-24 Osage Oklahoma 40113 10881 165
2335761 2335761 2022-03-23 Osage Oklahoma 40113 10873 164
2332507 2332507 2022-03-22 Osage Oklahoma 40113 10873 164
2329254 2329254 2022-03-21 Osage Oklahoma 40113 10873 164
2326002 2326002 2022-03-20 Osage Oklahoma 40113 10873 164
2322749 2322749 2022-03-19 Osage Oklahoma 40113 10873 164
2319495 2319495 2022-03-18 Osage Oklahoma 40113 10873 164
2316241 2316241 2022-03-17 Osage Oklahoma 40113 10873 164
2312988 2312988 2022-03-16 Osage Oklahoma 40113 10863 159
2309735 2309735 2022-03-15 Osage Oklahoma 40113 10863 159
2306482 2306482 2022-03-14 Osage Oklahoma 40113 10863 159
2303231 2303231 2022-03-13 Osage Oklahoma 40113 10863 159
2299979 2299979 2022-03-12 Osage Oklahoma 40113 10863 159
2296727 2296727 2022-03-11 Osage Oklahoma 40113 10863 159
2293475 2293475 2022-03-10 Osage Oklahoma 40113 10863 159
2290223 2290223 2022-03-09 Osage Oklahoma 40113 10823 158
2286971 2286971 2022-03-08 Osage Oklahoma 40113 10823 158
2283719 2283719 2022-03-07 Osage Oklahoma 40113 10823 158
2280467 2280467 2022-03-06 Osage Oklahoma 40113 10823 158
2277214 2277214 2022-03-05 Osage Oklahoma 40113 10823 158
2273961 2273961 2022-03-04 Osage Oklahoma 40113 10823 158
2270708 2270708 2022-03-03 Osage Oklahoma 40113 10823 158
2267456 2267456 2022-03-02 Osage Oklahoma 40113 10823 158
2264203 2264203 2022-03-01 Osage Oklahoma 40113 10799 155
2260953 2260953 2022-02-28 Osage Oklahoma 40113 10799 155
2257702 2257702 2022-02-27 Osage Oklahoma 40113 10799 155
2254451 2254451 2022-02-26 Osage Oklahoma 40113 10799 155
2251200 2251200 2022-02-25 Osage Oklahoma 40113 10799 155
2247949 2247949 2022-02-24 Osage Oklahoma 40113 10799 155
2244698 2244698 2022-02-23 Osage Oklahoma 40113 10799 155
2241447 2241447 2022-02-22 Osage Oklahoma 40113 10749 152
2238196 2238196 2022-02-21 Osage Oklahoma 40113 10749 152
2234945 2234945 2022-02-20 Osage Oklahoma 40113 10749 152
2231694 2231694 2022-02-19 Osage Oklahoma 40113 10749 152
2228443 2228443 2022-02-18 Osage Oklahoma 40113 10749 152
2225192 2225192 2022-02-17 Osage Oklahoma 40113 10749 152
2221941 2221941 2022-02-16 Osage Oklahoma 40113 10749 152
2218690 2218690 2022-02-15 Osage Oklahoma 40113 10606 149
2215439 2215439 2022-02-14 Osage Oklahoma 40113 10606 149
2212188 2212188 2022-02-13 Osage Oklahoma 40113 10606 149
2208935 2208935 2022-02-12 Osage Oklahoma 40113 10606 149
2205682 2205682 2022-02-11 Osage Oklahoma 40113 10606 149
2202429 2202429 2022-02-10 Osage Oklahoma 40113 10606 149
2199175 2199175 2022-02-09 Osage Oklahoma 40113 10606 149
2195921 2195921 2022-02-08 Osage Oklahoma 40113 10200 146
2192667 2192667 2022-02-07 Osage Oklahoma 40113 10200 146
2189413 2189413 2022-02-06 Osage Oklahoma 40113 10200 146
2186160 2186160 2022-02-05 Osage Oklahoma 40113 10200 146
2182908 2182908 2022-02-04 Osage Oklahoma 40113 10200 146
2179656 2179656 2022-02-03 Osage Oklahoma 40113 10200 146

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