ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
273 rows where deaths = 42 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Pushmataha 64
- Kingfisher 42
- Atoka 21
- Marshall 21
- Le Flore 8
- Rogers 8
- Blaine 7
- Choctaw 7
- Craig 7
- Garfield 7
- Johnston 7
- Murray 7
- Pittsburg 7
- Texas 7
- Payne 6
- Pontotoc 6
- Washington 6
- Muskogee 4
- Creek 3
- Delaware 3
- Wagoner 3
- Caddo 2
- Carter 2
- Grady 2
- Jackson 2
- McClain 2
- Pottawatomie 2
- Cherokee 1
- Cleveland 1
- Comanche 1
- …
state 1
- Oklahoma · 273 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495222 | 2495222 | 2022-05-11 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2491964 | 2491964 | 2022-05-10 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2488706 | 2488706 | 2022-05-09 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2485449 | 2485449 | 2022-05-08 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2482191 | 2482191 | 2022-05-07 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2478933 | 2478933 | 2022-05-06 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2475675 | 2475675 | 2022-05-05 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2404082 | 2404082 | 2022-04-13 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2400827 | 2400827 | 2022-04-12 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2397572 | 2397572 | 2022-04-11 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2394317 | 2394317 | 2022-04-10 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2391061 | 2391061 | 2022-04-09 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2387805 | 2387805 | 2022-04-08 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2384550 | 2384550 | 2022-04-07 | Marshall | Oklahoma | 40095 | 4603 | 42 |
2381295 | 2381295 | 2022-04-06 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2378040 | 2378040 | 2022-04-05 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2374786 | 2374786 | 2022-04-04 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2371534 | 2371534 | 2022-04-03 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2368281 | 2368281 | 2022-04-02 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2365028 | 2365028 | 2022-04-01 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2361775 | 2361775 | 2022-03-31 | Marshall | Oklahoma | 40095 | 4598 | 42 |
2358521 | 2358521 | 2022-03-30 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2355267 | 2355267 | 2022-03-29 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2352014 | 2352014 | 2022-03-28 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2348762 | 2348762 | 2022-03-27 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2345509 | 2345509 | 2022-03-26 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2342256 | 2342256 | 2022-03-25 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2339003 | 2339003 | 2022-03-24 | Marshall | Oklahoma | 40095 | 4591 | 42 |
2290230 | 2290230 | 2022-03-09 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2286978 | 2286978 | 2022-03-08 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2283726 | 2283726 | 2022-03-07 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2280474 | 2280474 | 2022-03-06 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2277221 | 2277221 | 2022-03-05 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2273968 | 2273968 | 2022-03-04 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2270715 | 2270715 | 2022-03-03 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2267463 | 2267463 | 2022-03-02 | Pushmataha | Oklahoma | 40127 | 2626 | 42 |
2264210 | 2264210 | 2022-03-01 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2260960 | 2260960 | 2022-02-28 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2257709 | 2257709 | 2022-02-27 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2254458 | 2254458 | 2022-02-26 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2251207 | 2251207 | 2022-02-25 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2247956 | 2247956 | 2022-02-24 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2244705 | 2244705 | 2022-02-23 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2241393 | 2241393 | 2022-02-22 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2241454 | 2241454 | 2022-02-22 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2238142 | 2238142 | 2022-02-21 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2238203 | 2238203 | 2022-02-21 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2234891 | 2234891 | 2022-02-20 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2234952 | 2234952 | 2022-02-20 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2231640 | 2231640 | 2022-02-19 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2231701 | 2231701 | 2022-02-19 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2228389 | 2228389 | 2022-02-18 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2228450 | 2228450 | 2022-02-18 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2225138 | 2225138 | 2022-02-17 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2225199 | 2225199 | 2022-02-17 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2221887 | 2221887 | 2022-02-16 | Atoka | Oklahoma | 40005 | 3732 | 42 |
2221948 | 2221948 | 2022-02-16 | Pushmataha | Oklahoma | 40127 | 2593 | 42 |
2218636 | 2218636 | 2022-02-15 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2218697 | 2218697 | 2022-02-15 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2215385 | 2215385 | 2022-02-14 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2215446 | 2215446 | 2022-02-14 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2212134 | 2212134 | 2022-02-13 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2212195 | 2212195 | 2022-02-13 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2208881 | 2208881 | 2022-02-12 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2208942 | 2208942 | 2022-02-12 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2205628 | 2205628 | 2022-02-11 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2205689 | 2205689 | 2022-02-11 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2202375 | 2202375 | 2022-02-10 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2202436 | 2202436 | 2022-02-10 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2199121 | 2199121 | 2022-02-09 | Atoka | Oklahoma | 40005 | 3693 | 42 |
2199182 | 2199182 | 2022-02-09 | Pushmataha | Oklahoma | 40127 | 2543 | 42 |
2195867 | 2195867 | 2022-02-08 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2195882 | 2195882 | 2022-02-08 | Craig | Oklahoma | 40035 | 4435 | 42 |
2195928 | 2195928 | 2022-02-08 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2192613 | 2192613 | 2022-02-07 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2192628 | 2192628 | 2022-02-07 | Craig | Oklahoma | 40035 | 4435 | 42 |
2192674 | 2192674 | 2022-02-07 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2189359 | 2189359 | 2022-02-06 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2189374 | 2189374 | 2022-02-06 | Craig | Oklahoma | 40035 | 4435 | 42 |
2189420 | 2189420 | 2022-02-06 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2186106 | 2186106 | 2022-02-05 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2186121 | 2186121 | 2022-02-05 | Craig | Oklahoma | 40035 | 4435 | 42 |
2186167 | 2186167 | 2022-02-05 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2182854 | 2182854 | 2022-02-04 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2182869 | 2182869 | 2022-02-04 | Craig | Oklahoma | 40035 | 4435 | 42 |
2182915 | 2182915 | 2022-02-04 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2179602 | 2179602 | 2022-02-03 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2179617 | 2179617 | 2022-02-03 | Craig | Oklahoma | 40035 | 4435 | 42 |
2179663 | 2179663 | 2022-02-03 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2176351 | 2176351 | 2022-02-02 | Atoka | Oklahoma | 40005 | 3587 | 42 |
2176366 | 2176366 | 2022-02-02 | Craig | Oklahoma | 40035 | 4435 | 42 |
2176412 | 2176412 | 2022-02-02 | Pushmataha | Oklahoma | 40127 | 2445 | 42 |
2173158 | 2173158 | 2022-02-01 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2169906 | 2169906 | 2022-01-31 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2166651 | 2166651 | 2022-01-30 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2163396 | 2163396 | 2022-01-29 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2160141 | 2160141 | 2022-01-28 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2156886 | 2156886 | 2022-01-27 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2153633 | 2153633 | 2022-01-26 | Pushmataha | Oklahoma | 40127 | 2280 | 42 |
2150381 | 2150381 | 2022-01-25 | Pushmataha | Oklahoma | 40127 | 2072 | 42 |
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);