ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 40009 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501737 | 2501737 | 2022-05-13 | Beckham | Oklahoma | 40009 | 5983 | 106 |
2498479 | 2498479 | 2022-05-12 | Beckham | Oklahoma | 40009 | 5983 | 106 |
2495221 | 2495221 | 2022-05-11 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2491963 | 2491963 | 2022-05-10 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2488705 | 2488705 | 2022-05-09 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2485448 | 2485448 | 2022-05-08 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2482190 | 2482190 | 2022-05-07 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2478932 | 2478932 | 2022-05-06 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2475674 | 2475674 | 2022-05-05 | Beckham | Oklahoma | 40009 | 5975 | 106 |
2472417 | 2472417 | 2022-05-04 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2469161 | 2469161 | 2022-05-03 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2465905 | 2465905 | 2022-05-02 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2462650 | 2462650 | 2022-05-01 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2459394 | 2459394 | 2022-04-30 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2456138 | 2456138 | 2022-04-29 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2452882 | 2452882 | 2022-04-28 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2449626 | 2449626 | 2022-04-27 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2446369 | 2446369 | 2022-04-26 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2443114 | 2443114 | 2022-04-25 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2439858 | 2439858 | 2022-04-24 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2436602 | 2436602 | 2022-04-23 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2433346 | 2433346 | 2022-04-22 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2430090 | 2430090 | 2022-04-21 | Beckham | Oklahoma | 40009 | 5972 | 106 |
2426834 | 2426834 | 2022-04-20 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2423578 | 2423578 | 2022-04-19 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2420321 | 2420321 | 2022-04-18 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2417066 | 2417066 | 2022-04-17 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2413810 | 2413810 | 2022-04-16 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2410554 | 2410554 | 2022-04-15 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2407298 | 2407298 | 2022-04-14 | Beckham | Oklahoma | 40009 | 5943 | 106 |
2404042 | 2404042 | 2022-04-13 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2400787 | 2400787 | 2022-04-12 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2397532 | 2397532 | 2022-04-11 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2394277 | 2394277 | 2022-04-10 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2391021 | 2391021 | 2022-04-09 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2387765 | 2387765 | 2022-04-08 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2384510 | 2384510 | 2022-04-07 | Beckham | Oklahoma | 40009 | 5930 | 106 |
2381255 | 2381255 | 2022-04-06 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2378000 | 2378000 | 2022-04-05 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2374746 | 2374746 | 2022-04-04 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2371494 | 2371494 | 2022-04-03 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2368241 | 2368241 | 2022-04-02 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2364988 | 2364988 | 2022-04-01 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2361735 | 2361735 | 2022-03-31 | Beckham | Oklahoma | 40009 | 5931 | 107 |
2358481 | 2358481 | 2022-03-30 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2355227 | 2355227 | 2022-03-29 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2351974 | 2351974 | 2022-03-28 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2348722 | 2348722 | 2022-03-27 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2345469 | 2345469 | 2022-03-26 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2342216 | 2342216 | 2022-03-25 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2338963 | 2338963 | 2022-03-24 | Beckham | Oklahoma | 40009 | 5928 | 106 |
2335709 | 2335709 | 2022-03-23 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2332455 | 2332455 | 2022-03-22 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2329202 | 2329202 | 2022-03-21 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2325950 | 2325950 | 2022-03-20 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2322697 | 2322697 | 2022-03-19 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2319443 | 2319443 | 2022-03-18 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2316189 | 2316189 | 2022-03-17 | Beckham | Oklahoma | 40009 | 5924 | 105 |
2312936 | 2312936 | 2022-03-16 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2309683 | 2309683 | 2022-03-15 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2306430 | 2306430 | 2022-03-14 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2303179 | 2303179 | 2022-03-13 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2299927 | 2299927 | 2022-03-12 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2296675 | 2296675 | 2022-03-11 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2293423 | 2293423 | 2022-03-10 | Beckham | Oklahoma | 40009 | 5906 | 104 |
2290171 | 2290171 | 2022-03-09 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2286919 | 2286919 | 2022-03-08 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2283667 | 2283667 | 2022-03-07 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2280415 | 2280415 | 2022-03-06 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2277162 | 2277162 | 2022-03-05 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2273909 | 2273909 | 2022-03-04 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2270656 | 2270656 | 2022-03-03 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2267404 | 2267404 | 2022-03-02 | Beckham | Oklahoma | 40009 | 5885 | 100 |
2264151 | 2264151 | 2022-03-01 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2260901 | 2260901 | 2022-02-28 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2257650 | 2257650 | 2022-02-27 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2254399 | 2254399 | 2022-02-26 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2251148 | 2251148 | 2022-02-25 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2247897 | 2247897 | 2022-02-24 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2244646 | 2244646 | 2022-02-23 | Beckham | Oklahoma | 40009 | 5813 | 99 |
2241395 | 2241395 | 2022-02-22 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2238144 | 2238144 | 2022-02-21 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2234893 | 2234893 | 2022-02-20 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2231642 | 2231642 | 2022-02-19 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2228391 | 2228391 | 2022-02-18 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2225140 | 2225140 | 2022-02-17 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2221889 | 2221889 | 2022-02-16 | Beckham | Oklahoma | 40009 | 5767 | 95 |
2218638 | 2218638 | 2022-02-15 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2215387 | 2215387 | 2022-02-14 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2212136 | 2212136 | 2022-02-13 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2208883 | 2208883 | 2022-02-12 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2205630 | 2205630 | 2022-02-11 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2202377 | 2202377 | 2022-02-10 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2199123 | 2199123 | 2022-02-09 | Beckham | Oklahoma | 40009 | 5725 | 90 |
2195869 | 2195869 | 2022-02-08 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2192615 | 2192615 | 2022-02-07 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2189361 | 2189361 | 2022-02-06 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2186108 | 2186108 | 2022-02-05 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2182856 | 2182856 | 2022-02-04 | Beckham | Oklahoma | 40009 | 5624 | 90 |
2179604 | 2179604 | 2022-02-03 | Beckham | Oklahoma | 40009 | 5624 | 90 |
Advanced export
JSON shape: default, array, newline-delimited
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);