ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 217 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Oklahoma · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449657 | 2449657 | 2022-04-27 | Kay | Oklahoma | 40071 | 12283 | 217 |
2446400 | 2446400 | 2022-04-26 | Kay | Oklahoma | 40071 | 12283 | 217 |
2443145 | 2443145 | 2022-04-25 | Kay | Oklahoma | 40071 | 12283 | 217 |
2439889 | 2439889 | 2022-04-24 | Kay | Oklahoma | 40071 | 12283 | 217 |
2436633 | 2436633 | 2022-04-23 | Kay | Oklahoma | 40071 | 12283 | 217 |
2433377 | 2433377 | 2022-04-22 | Kay | Oklahoma | 40071 | 12283 | 217 |
2430121 | 2430121 | 2022-04-21 | Kay | Oklahoma | 40071 | 12283 | 217 |
2426865 | 2426865 | 2022-04-20 | Kay | Oklahoma | 40071 | 12277 | 217 |
2423609 | 2423609 | 2022-04-19 | Kay | Oklahoma | 40071 | 12277 | 217 |
2420352 | 2420352 | 2022-04-18 | Kay | Oklahoma | 40071 | 12277 | 217 |
2417097 | 2417097 | 2022-04-17 | Kay | Oklahoma | 40071 | 12277 | 217 |
2413841 | 2413841 | 2022-04-16 | Kay | Oklahoma | 40071 | 12277 | 217 |
2410585 | 2410585 | 2022-04-15 | Kay | Oklahoma | 40071 | 12277 | 217 |
2407329 | 2407329 | 2022-04-14 | Kay | Oklahoma | 40071 | 12277 | 217 |
2404073 | 2404073 | 2022-04-13 | Kay | Oklahoma | 40071 | 12271 | 217 |
2400818 | 2400818 | 2022-04-12 | Kay | Oklahoma | 40071 | 12271 | 217 |
2397563 | 2397563 | 2022-04-11 | Kay | Oklahoma | 40071 | 12271 | 217 |
2394308 | 2394308 | 2022-04-10 | Kay | Oklahoma | 40071 | 12271 | 217 |
2391052 | 2391052 | 2022-04-09 | Kay | Oklahoma | 40071 | 12271 | 217 |
2387796 | 2387796 | 2022-04-08 | Kay | Oklahoma | 40071 | 12271 | 217 |
2384541 | 2384541 | 2022-04-07 | Kay | Oklahoma | 40071 | 12271 | 217 |
2381286 | 2381286 | 2022-04-06 | Kay | Oklahoma | 40071 | 12259 | 217 |
2378031 | 2378031 | 2022-04-05 | Kay | Oklahoma | 40071 | 12259 | 217 |
2374777 | 2374777 | 2022-04-04 | Kay | Oklahoma | 40071 | 12259 | 217 |
2371525 | 2371525 | 2022-04-03 | Kay | Oklahoma | 40071 | 12259 | 217 |
2368272 | 2368272 | 2022-04-02 | Kay | Oklahoma | 40071 | 12259 | 217 |
2365019 | 2365019 | 2022-04-01 | Kay | Oklahoma | 40071 | 12259 | 217 |
2361766 | 2361766 | 2022-03-31 | Kay | Oklahoma | 40071 | 12259 | 217 |
2313004 | 2313004 | 2022-03-16 | Unknown | Oklahoma | 1931 | 217 | |
2309751 | 2309751 | 2022-03-15 | Unknown | Oklahoma | 1931 | 217 | |
2059335 | 2059335 | 2021-12-28 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2056086 | 2056086 | 2021-12-27 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2052837 | 2052837 | 2021-12-26 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2049587 | 2049587 | 2021-12-25 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2046337 | 2046337 | 2021-12-24 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2043087 | 2043087 | 2021-12-23 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
2039838 | 2039838 | 2021-12-22 | Wagoner | Oklahoma | 40145 | 13680 | 217 |
1991028 | 1991028 | 2021-12-07 | Garfield | Oklahoma | 40047 | 10591 | 217 |
1987777 | 1987777 | 2021-12-06 | Garfield | Oklahoma | 40047 | 10591 | 217 |
1984527 | 1984527 | 2021-12-05 | Garfield | Oklahoma | 40047 | 10591 | 217 |
1981277 | 1981277 | 2021-12-04 | Garfield | Oklahoma | 40047 | 10591 | 217 |
1978027 | 1978027 | 2021-12-03 | Garfield | Oklahoma | 40047 | 10591 | 217 |
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);