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

781 rows where fips = 40097 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 · 781 ✖

fips 1

  • 40097 · 781 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501778 2501778 2022-05-13 Mayes Oklahoma 40097 10399 163
2498520 2498520 2022-05-12 Mayes Oklahoma 40097 10399 163
2495262 2495262 2022-05-11 Mayes Oklahoma 40097 10384 163
2492004 2492004 2022-05-10 Mayes Oklahoma 40097 10384 163
2488746 2488746 2022-05-09 Mayes Oklahoma 40097 10384 163
2485489 2485489 2022-05-08 Mayes Oklahoma 40097 10384 163
2482231 2482231 2022-05-07 Mayes Oklahoma 40097 10384 163
2478973 2478973 2022-05-06 Mayes Oklahoma 40097 10384 163
2475715 2475715 2022-05-05 Mayes Oklahoma 40097 10384 163
2472458 2472458 2022-05-04 Mayes Oklahoma 40097 10325 163
2469202 2469202 2022-05-03 Mayes Oklahoma 40097 10325 163
2465946 2465946 2022-05-02 Mayes Oklahoma 40097 10325 163
2462691 2462691 2022-05-01 Mayes Oklahoma 40097 10325 163
2459435 2459435 2022-04-30 Mayes Oklahoma 40097 10325 163
2456179 2456179 2022-04-29 Mayes Oklahoma 40097 10325 163
2452923 2452923 2022-04-28 Mayes Oklahoma 40097 10325 163
2449667 2449667 2022-04-27 Mayes Oklahoma 40097 10310 163
2446410 2446410 2022-04-26 Mayes Oklahoma 40097 10310 163
2443155 2443155 2022-04-25 Mayes Oklahoma 40097 10310 163
2439899 2439899 2022-04-24 Mayes Oklahoma 40097 10310 163
2436643 2436643 2022-04-23 Mayes Oklahoma 40097 10310 163
2433387 2433387 2022-04-22 Mayes Oklahoma 40097 10310 163
2430131 2430131 2022-04-21 Mayes Oklahoma 40097 10310 163
2426875 2426875 2022-04-20 Mayes Oklahoma 40097 10302 163
2423619 2423619 2022-04-19 Mayes Oklahoma 40097 10302 163
2420362 2420362 2022-04-18 Mayes Oklahoma 40097 10302 163
2417107 2417107 2022-04-17 Mayes Oklahoma 40097 10302 163
2413851 2413851 2022-04-16 Mayes Oklahoma 40097 10302 163
2410595 2410595 2022-04-15 Mayes Oklahoma 40097 10302 163
2407339 2407339 2022-04-14 Mayes Oklahoma 40097 10302 163
2404083 2404083 2022-04-13 Mayes Oklahoma 40097 10285 162
2400828 2400828 2022-04-12 Mayes Oklahoma 40097 10285 162
2397573 2397573 2022-04-11 Mayes Oklahoma 40097 10285 162
2394318 2394318 2022-04-10 Mayes Oklahoma 40097 10285 162
2391062 2391062 2022-04-09 Mayes Oklahoma 40097 10285 162
2387806 2387806 2022-04-08 Mayes Oklahoma 40097 10285 162
2384551 2384551 2022-04-07 Mayes Oklahoma 40097 10285 162
2381296 2381296 2022-04-06 Mayes Oklahoma 40097 10280 161
2378041 2378041 2022-04-05 Mayes Oklahoma 40097 10280 161
2374787 2374787 2022-04-04 Mayes Oklahoma 40097 10280 161
2371535 2371535 2022-04-03 Mayes Oklahoma 40097 10280 161
2368282 2368282 2022-04-02 Mayes Oklahoma 40097 10280 161
2365029 2365029 2022-04-01 Mayes Oklahoma 40097 10280 161
2361776 2361776 2022-03-31 Mayes Oklahoma 40097 10280 161
2358522 2358522 2022-03-30 Mayes Oklahoma 40097 10257 158
2355268 2355268 2022-03-29 Mayes Oklahoma 40097 10257 158
2352015 2352015 2022-03-28 Mayes Oklahoma 40097 10257 158
2348763 2348763 2022-03-27 Mayes Oklahoma 40097 10257 158
2345510 2345510 2022-03-26 Mayes Oklahoma 40097 10257 158
2342257 2342257 2022-03-25 Mayes Oklahoma 40097 10257 158
2339004 2339004 2022-03-24 Mayes Oklahoma 40097 10257 158
2335750 2335750 2022-03-23 Mayes Oklahoma 40097 10248 156
2332496 2332496 2022-03-22 Mayes Oklahoma 40097 10248 156
2329243 2329243 2022-03-21 Mayes Oklahoma 40097 10248 156
2325991 2325991 2022-03-20 Mayes Oklahoma 40097 10248 156
2322738 2322738 2022-03-19 Mayes Oklahoma 40097 10248 156
2319484 2319484 2022-03-18 Mayes Oklahoma 40097 10248 156
2316230 2316230 2022-03-17 Mayes Oklahoma 40097 10248 156
2312977 2312977 2022-03-16 Mayes Oklahoma 40097 10224 155
2309724 2309724 2022-03-15 Mayes Oklahoma 40097 10224 155
2306471 2306471 2022-03-14 Mayes Oklahoma 40097 10224 155
2303220 2303220 2022-03-13 Mayes Oklahoma 40097 10224 155
2299968 2299968 2022-03-12 Mayes Oklahoma 40097 10224 155
2296716 2296716 2022-03-11 Mayes Oklahoma 40097 10224 155
2293464 2293464 2022-03-10 Mayes Oklahoma 40097 10224 155
2290212 2290212 2022-03-09 Mayes Oklahoma 40097 10196 153
2286960 2286960 2022-03-08 Mayes Oklahoma 40097 10196 153
2283708 2283708 2022-03-07 Mayes Oklahoma 40097 10196 153
2280456 2280456 2022-03-06 Mayes Oklahoma 40097 10196 153
2277203 2277203 2022-03-05 Mayes Oklahoma 40097 10196 153
2273950 2273950 2022-03-04 Mayes Oklahoma 40097 10196 153
2270697 2270697 2022-03-03 Mayes Oklahoma 40097 10196 153
2267445 2267445 2022-03-02 Mayes Oklahoma 40097 10196 153
2264192 2264192 2022-03-01 Mayes Oklahoma 40097 10157 148
2260942 2260942 2022-02-28 Mayes Oklahoma 40097 10157 148
2257691 2257691 2022-02-27 Mayes Oklahoma 40097 10157 148
2254440 2254440 2022-02-26 Mayes Oklahoma 40097 10157 148
2251189 2251189 2022-02-25 Mayes Oklahoma 40097 10157 148
2247938 2247938 2022-02-24 Mayes Oklahoma 40097 10157 148
2244687 2244687 2022-02-23 Mayes Oklahoma 40097 10157 148
2241436 2241436 2022-02-22 Mayes Oklahoma 40097 10072 145
2238185 2238185 2022-02-21 Mayes Oklahoma 40097 10072 145
2234934 2234934 2022-02-20 Mayes Oklahoma 40097 10072 145
2231683 2231683 2022-02-19 Mayes Oklahoma 40097 10072 145
2228432 2228432 2022-02-18 Mayes Oklahoma 40097 10072 145
2225181 2225181 2022-02-17 Mayes Oklahoma 40097 10072 145
2221930 2221930 2022-02-16 Mayes Oklahoma 40097 10072 145
2218679 2218679 2022-02-15 Mayes Oklahoma 40097 9935 144
2215428 2215428 2022-02-14 Mayes Oklahoma 40097 9935 144
2212177 2212177 2022-02-13 Mayes Oklahoma 40097 9935 144
2208924 2208924 2022-02-12 Mayes Oklahoma 40097 9935 144
2205671 2205671 2022-02-11 Mayes Oklahoma 40097 9935 144
2202418 2202418 2022-02-10 Mayes Oklahoma 40097 9935 144
2199164 2199164 2022-02-09 Mayes Oklahoma 40097 9935 144
2195910 2195910 2022-02-08 Mayes Oklahoma 40097 9704 140
2192656 2192656 2022-02-07 Mayes Oklahoma 40097 9704 140
2189402 2189402 2022-02-06 Mayes Oklahoma 40097 9704 140
2186149 2186149 2022-02-05 Mayes Oklahoma 40097 9704 140
2182897 2182897 2022-02-04 Mayes Oklahoma 40097 9704 140
2179645 2179645 2022-02-03 Mayes Oklahoma 40097 9704 140

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