ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,394 rows where deaths = 7 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Grant 232
- Alfalfa 182
- Greer 82
- Kay 70
- Creek 66
- Cimarron 65
- Ellis 64
- Texas 57
- Haskell 51
- Grady 43
- Harmon 37
- Roger Mills 33
- Hughes 29
- Cherokee 22
- Noble 22
- Latimer 21
- McClain 21
- Craig 20
- Jefferson 20
- Blaine 17
- Jackson 16
- Kingfisher 13
- Washita 13
- Custer 11
- Seminole 11
- Woodward 11
- Cotton 10
- Payne 10
- Unknown 10
- Comanche 9
- …
state 1
- Oklahoma · 1,394 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501745 | 2501745 | 2022-05-13 | Cimarron | Oklahoma | 40025 | 566 | 7 |
2498487 | 2498487 | 2022-05-12 | Cimarron | Oklahoma | 40025 | 566 | 7 |
2495229 | 2495229 | 2022-05-11 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2491971 | 2491971 | 2022-05-10 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2488713 | 2488713 | 2022-05-09 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2485456 | 2485456 | 2022-05-08 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2482198 | 2482198 | 2022-05-07 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2478940 | 2478940 | 2022-05-06 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2475682 | 2475682 | 2022-05-05 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2472425 | 2472425 | 2022-05-04 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2469169 | 2469169 | 2022-05-03 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2465913 | 2465913 | 2022-05-02 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2462658 | 2462658 | 2022-05-01 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2459402 | 2459402 | 2022-04-30 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2456146 | 2456146 | 2022-04-29 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2452890 | 2452890 | 2022-04-28 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2449634 | 2449634 | 2022-04-27 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2446377 | 2446377 | 2022-04-26 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2443122 | 2443122 | 2022-04-25 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2439866 | 2439866 | 2022-04-24 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2436610 | 2436610 | 2022-04-23 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2433354 | 2433354 | 2022-04-22 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2430098 | 2430098 | 2022-04-21 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2426842 | 2426842 | 2022-04-20 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2426902 | 2426902 | 2022-04-20 | Unknown | Oklahoma | 1988 | 7 | |
2423586 | 2423586 | 2022-04-19 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2423646 | 2423646 | 2022-04-19 | Unknown | Oklahoma | 1988 | 7 | |
2420329 | 2420329 | 2022-04-18 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2417074 | 2417074 | 2022-04-17 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2413818 | 2413818 | 2022-04-16 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2410562 | 2410562 | 2022-04-15 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2407306 | 2407306 | 2022-04-14 | Cimarron | Oklahoma | 40025 | 567 | 7 |
2404050 | 2404050 | 2022-04-13 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2400795 | 2400795 | 2022-04-12 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2397540 | 2397540 | 2022-04-11 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2394285 | 2394285 | 2022-04-10 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2391029 | 2391029 | 2022-04-09 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2387773 | 2387773 | 2022-04-08 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2384518 | 2384518 | 2022-04-07 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2381263 | 2381263 | 2022-04-06 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2378008 | 2378008 | 2022-04-05 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2374754 | 2374754 | 2022-04-04 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2371502 | 2371502 | 2022-04-03 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2368249 | 2368249 | 2022-04-02 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2364996 | 2364996 | 2022-04-01 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2361743 | 2361743 | 2022-03-31 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2358489 | 2358489 | 2022-03-30 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2358499 | 2358499 | 2022-03-30 | Ellis | Oklahoma | 40045 | 769 | 7 |
2355235 | 2355235 | 2022-03-29 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2355245 | 2355245 | 2022-03-29 | Ellis | Oklahoma | 40045 | 769 | 7 |
2351982 | 2351982 | 2022-03-28 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2351992 | 2351992 | 2022-03-28 | Ellis | Oklahoma | 40045 | 769 | 7 |
2348730 | 2348730 | 2022-03-27 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2348740 | 2348740 | 2022-03-27 | Ellis | Oklahoma | 40045 | 769 | 7 |
2345477 | 2345477 | 2022-03-26 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2345487 | 2345487 | 2022-03-26 | Ellis | Oklahoma | 40045 | 769 | 7 |
2342224 | 2342224 | 2022-03-25 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2342234 | 2342234 | 2022-03-25 | Ellis | Oklahoma | 40045 | 769 | 7 |
2338971 | 2338971 | 2022-03-24 | Cimarron | Oklahoma | 40025 | 574 | 7 |
2338981 | 2338981 | 2022-03-24 | Ellis | Oklahoma | 40045 | 769 | 7 |
2335717 | 2335717 | 2022-03-23 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2335727 | 2335727 | 2022-03-23 | Ellis | Oklahoma | 40045 | 768 | 7 |
2332463 | 2332463 | 2022-03-22 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2332473 | 2332473 | 2022-03-22 | Ellis | Oklahoma | 40045 | 768 | 7 |
2329210 | 2329210 | 2022-03-21 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2329220 | 2329220 | 2022-03-21 | Ellis | Oklahoma | 40045 | 768 | 7 |
2325958 | 2325958 | 2022-03-20 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2325968 | 2325968 | 2022-03-20 | Ellis | Oklahoma | 40045 | 768 | 7 |
2322705 | 2322705 | 2022-03-19 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2322715 | 2322715 | 2022-03-19 | Ellis | Oklahoma | 40045 | 768 | 7 |
2319451 | 2319451 | 2022-03-18 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2319461 | 2319461 | 2022-03-18 | Ellis | Oklahoma | 40045 | 768 | 7 |
2316197 | 2316197 | 2022-03-17 | Cimarron | Oklahoma | 40025 | 570 | 7 |
2316207 | 2316207 | 2022-03-17 | Ellis | Oklahoma | 40045 | 768 | 7 |
2312944 | 2312944 | 2022-03-16 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2312954 | 2312954 | 2022-03-16 | Ellis | Oklahoma | 40045 | 767 | 7 |
2309691 | 2309691 | 2022-03-15 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2309701 | 2309701 | 2022-03-15 | Ellis | Oklahoma | 40045 | 767 | 7 |
2306438 | 2306438 | 2022-03-14 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2306448 | 2306448 | 2022-03-14 | Ellis | Oklahoma | 40045 | 767 | 7 |
2303187 | 2303187 | 2022-03-13 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2303197 | 2303197 | 2022-03-13 | Ellis | Oklahoma | 40045 | 767 | 7 |
2299935 | 2299935 | 2022-03-12 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2299945 | 2299945 | 2022-03-12 | Ellis | Oklahoma | 40045 | 767 | 7 |
2296683 | 2296683 | 2022-03-11 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2296693 | 2296693 | 2022-03-11 | Ellis | Oklahoma | 40045 | 767 | 7 |
2293431 | 2293431 | 2022-03-10 | Cimarron | Oklahoma | 40025 | 563 | 7 |
2293441 | 2293441 | 2022-03-10 | Ellis | Oklahoma | 40045 | 767 | 7 |
2290189 | 2290189 | 2022-03-09 | Ellis | Oklahoma | 40045 | 766 | 7 |
2286937 | 2286937 | 2022-03-08 | Ellis | Oklahoma | 40045 | 766 | 7 |
2283685 | 2283685 | 2022-03-07 | Ellis | Oklahoma | 40045 | 766 | 7 |
2280433 | 2280433 | 2022-03-06 | Ellis | Oklahoma | 40045 | 766 | 7 |
2277180 | 2277180 | 2022-03-05 | Ellis | Oklahoma | 40045 | 766 | 7 |
2273927 | 2273927 | 2022-03-04 | Ellis | Oklahoma | 40045 | 766 | 7 |
2270674 | 2270674 | 2022-03-03 | Ellis | Oklahoma | 40045 | 766 | 7 |
2267422 | 2267422 | 2022-03-02 | Ellis | Oklahoma | 40045 | 766 | 7 |
2264169 | 2264169 | 2022-03-01 | Ellis | Oklahoma | 40045 | 761 | 7 |
2260919 | 2260919 | 2022-02-28 | Ellis | Oklahoma | 40045 | 761 | 7 |
2257668 | 2257668 | 2022-02-27 | Ellis | Oklahoma | 40045 | 761 | 7 |
2254417 | 2254417 | 2022-02-26 | Ellis | Oklahoma | 40045 | 761 | 7 |
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);