ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
178 rows where cases = 8 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- McCurtain 24
- Major 17
- Kingfisher 16
- Roger Mills 12
- Marshall 10
- Beckham 8
- Coal 6
- Craig 6
- Pushmataha 5
- Seminole 5
- Unknown 5
- Atoka 4
- Bryan 4
- Dewey 4
- Johnston 4
- Wagoner 4
- Washita 4
- Haskell 3
- Pittsburg 3
- Blaine 2
- Carter 2
- Garvin 2
- Jackson 2
- Jefferson 2
- Kiowa 2
- Le Flore 2
- Ottawa 2
- Woodward 2
- Adair 1
- Beaver 1
- …
state 1
- Oklahoma · 178 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1110905 | 1110905 | 2021-03-11 | Unknown | Oklahoma | 8 | 0 | |
1094673 | 1094673 | 2021-03-06 | Unknown | Oklahoma | 8 | 0 | |
663066 | 663066 | 2020-10-24 | Unknown | Oklahoma | 8 | 0 | |
653333 | 653333 | 2020-10-21 | Unknown | Oklahoma | 8 | 0 | |
549535 | 549535 | 2020-09-19 | Ellis | Oklahoma | 40045 | 8 | 0 |
471950 | 471950 | 2020-08-26 | Unknown | Oklahoma | 8 | 0 | |
420312 | 420312 | 2020-08-10 | Roger Mills | Oklahoma | 40129 | 8 | 1 |
417092 | 417092 | 2020-08-09 | Roger Mills | Oklahoma | 40129 | 8 | 1 |
413871 | 413871 | 2020-08-08 | Roger Mills | Oklahoma | 40129 | 8 | 1 |
410651 | 410651 | 2020-08-07 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
407388 | 407388 | 2020-08-06 | Dewey | Oklahoma | 40043 | 8 | 0 |
407431 | 407431 | 2020-08-06 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
404169 | 404169 | 2020-08-05 | Dewey | Oklahoma | 40043 | 8 | 0 |
404212 | 404212 | 2020-08-05 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
400951 | 400951 | 2020-08-04 | Dewey | Oklahoma | 40043 | 8 | 0 |
400994 | 400994 | 2020-08-04 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
397736 | 397736 | 2020-08-03 | Dewey | Oklahoma | 40043 | 8 | 0 |
397779 | 397779 | 2020-08-03 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
394562 | 394562 | 2020-08-02 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
391346 | 391346 | 2020-08-01 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
388129 | 388129 | 2020-07-31 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
384912 | 384912 | 2020-07-30 | Roger Mills | Oklahoma | 40129 | 8 | 0 |
330434 | 330434 | 2020-07-13 | Washita | Oklahoma | 40149 | 8 | 0 |
327248 | 327248 | 2020-07-12 | Washita | Oklahoma | 40149 | 8 | 0 |
324063 | 324063 | 2020-07-11 | Washita | Oklahoma | 40149 | 8 | 0 |
320883 | 320883 | 2020-07-10 | Washita | Oklahoma | 40149 | 8 | 0 |
311303 | 311303 | 2020-07-07 | Cotton | Oklahoma | 40033 | 8 | 2 |
311330 | 311330 | 2020-07-07 | Major | Oklahoma | 40093 | 8 | 1 |
311361 | 311361 | 2020-07-07 | Woods | Oklahoma | 40151 | 8 | 0 |
308161 | 308161 | 2020-07-06 | Major | Oklahoma | 40093 | 8 | 1 |
304994 | 304994 | 2020-07-05 | Major | Oklahoma | 40093 | 8 | 1 |
301831 | 301831 | 2020-07-04 | Major | Oklahoma | 40093 | 8 | 1 |
298639 | 298639 | 2020-07-03 | Coal | Oklahoma | 40029 | 8 | 0 |
298668 | 298668 | 2020-07-03 | Major | Oklahoma | 40093 | 8 | 1 |
295480 | 295480 | 2020-07-02 | Coal | Oklahoma | 40029 | 8 | 0 |
295509 | 295509 | 2020-07-02 | Major | Oklahoma | 40093 | 8 | 1 |
292324 | 292324 | 2020-07-01 | Coal | Oklahoma | 40029 | 8 | 0 |
292343 | 292343 | 2020-07-01 | Jefferson | Oklahoma | 40067 | 8 | 0 |
292353 | 292353 | 2020-07-01 | Major | Oklahoma | 40093 | 8 | 1 |
289172 | 289172 | 2020-06-30 | Coal | Oklahoma | 40029 | 8 | 0 |
289190 | 289190 | 2020-06-30 | Jefferson | Oklahoma | 40067 | 8 | 0 |
289200 | 289200 | 2020-06-30 | Major | Oklahoma | 40093 | 8 | 1 |
286022 | 286022 | 2020-06-29 | Coal | Oklahoma | 40029 | 8 | 0 |
286044 | 286044 | 2020-06-29 | Kiowa | Oklahoma | 40075 | 8 | 1 |
286050 | 286050 | 2020-06-29 | Major | Oklahoma | 40093 | 8 | 1 |
282877 | 282877 | 2020-06-28 | Coal | Oklahoma | 40029 | 8 | 0 |
282892 | 282892 | 2020-06-28 | Haskell | Oklahoma | 40061 | 8 | 0 |
282899 | 282899 | 2020-06-28 | Kiowa | Oklahoma | 40075 | 8 | 1 |
282905 | 282905 | 2020-06-28 | Major | Oklahoma | 40093 | 8 | 1 |
279746 | 279746 | 2020-06-27 | Haskell | Oklahoma | 40061 | 8 | 0 |
279759 | 279759 | 2020-06-27 | Major | Oklahoma | 40093 | 8 | 1 |
276598 | 276598 | 2020-06-26 | Haskell | Oklahoma | 40061 | 8 | 0 |
276611 | 276611 | 2020-06-26 | Major | Oklahoma | 40093 | 8 | 1 |
273464 | 273464 | 2020-06-25 | Major | Oklahoma | 40093 | 8 | 1 |
270325 | 270325 | 2020-06-24 | Major | Oklahoma | 40093 | 8 | 1 |
270345 | 270345 | 2020-06-24 | Pushmataha | Oklahoma | 40127 | 8 | 0 |
267191 | 267191 | 2020-06-23 | Major | Oklahoma | 40093 | 8 | 1 |
267211 | 267211 | 2020-06-23 | Pushmataha | Oklahoma | 40127 | 8 | 0 |
264063 | 264063 | 2020-06-22 | Major | Oklahoma | 40093 | 8 | 1 |
264083 | 264083 | 2020-06-22 | Pushmataha | Oklahoma | 40127 | 8 | 0 |
260897 | 260897 | 2020-06-21 | Beckham | Oklahoma | 40009 | 8 | 0 |
260926 | 260926 | 2020-06-21 | Johnston | Oklahoma | 40069 | 8 | 0 |
260935 | 260935 | 2020-06-21 | Major | Oklahoma | 40093 | 8 | 1 |
260955 | 260955 | 2020-06-21 | Pushmataha | Oklahoma | 40127 | 8 | 0 |
257771 | 257771 | 2020-06-20 | Beckham | Oklahoma | 40009 | 8 | 0 |
257799 | 257799 | 2020-06-20 | Johnston | Oklahoma | 40069 | 8 | 0 |
254645 | 254645 | 2020-06-19 | Beckham | Oklahoma | 40009 | 8 | 0 |
254673 | 254673 | 2020-06-19 | Johnston | Oklahoma | 40069 | 8 | 0 |
254702 | 254702 | 2020-06-19 | Pushmataha | Oklahoma | 40127 | 8 | 0 |
251530 | 251530 | 2020-06-18 | Beckham | Oklahoma | 40009 | 8 | 0 |
251558 | 251558 | 2020-06-18 | Johnston | Oklahoma | 40069 | 8 | 0 |
248415 | 248415 | 2020-06-17 | Beckham | Oklahoma | 40009 | 8 | 0 |
245302 | 245302 | 2020-06-16 | Beckham | Oklahoma | 40009 | 8 | 0 |
242188 | 242188 | 2020-06-15 | Atoka | Oklahoma | 40005 | 8 | 0 |
242190 | 242190 | 2020-06-15 | Beckham | Oklahoma | 40009 | 8 | 0 |
239079 | 239079 | 2020-06-14 | Atoka | Oklahoma | 40005 | 8 | 0 |
239081 | 239081 | 2020-06-14 | Beckham | Oklahoma | 40009 | 8 | 0 |
235971 | 235971 | 2020-06-13 | Atoka | Oklahoma | 40005 | 8 | 0 |
232866 | 232866 | 2020-06-12 | Atoka | Oklahoma | 40005 | 8 | 0 |
232913 | 232913 | 2020-06-12 | Noble | Oklahoma | 40103 | 8 | 0 |
226728 | 226728 | 2020-06-10 | Woodward | Oklahoma | 40153 | 8 | 0 |
223628 | 223628 | 2020-06-09 | Woodward | Oklahoma | 40153 | 8 | 0 |
208115 | 208115 | 2020-06-04 | Blaine | Oklahoma | 40011 | 8 | 0 |
205034 | 205034 | 2020-06-03 | Blaine | Oklahoma | 40011 | 8 | 0 |
205071 | 205071 | 2020-06-03 | Marshall | Oklahoma | 40095 | 8 | 0 |
201994 | 201994 | 2020-06-02 | Marshall | Oklahoma | 40095 | 8 | 0 |
198919 | 198919 | 2020-06-01 | Marshall | Oklahoma | 40095 | 8 | 0 |
195846 | 195846 | 2020-05-31 | Marshall | Oklahoma | 40095 | 8 | 0 |
192777 | 192777 | 2020-05-30 | Marshall | Oklahoma | 40095 | 8 | 0 |
189712 | 189712 | 2020-05-29 | Marshall | Oklahoma | 40095 | 8 | 0 |
186651 | 186651 | 2020-05-28 | Marshall | Oklahoma | 40095 | 8 | 0 |
183594 | 183594 | 2020-05-27 | Marshall | Oklahoma | 40095 | 8 | 0 |
180545 | 180545 | 2020-05-26 | Marshall | Oklahoma | 40095 | 8 | 0 |
177502 | 177502 | 2020-05-25 | Marshall | Oklahoma | 40095 | 8 | 0 |
150205 | 150205 | 2020-05-16 | Carter | Oklahoma | 40019 | 8 | 1 |
147198 | 147198 | 2020-05-15 | Carter | Oklahoma | 40019 | 8 | 1 |
147233 | 147233 | 2020-05-15 | McIntosh | Oklahoma | 40091 | 8 | 0 |
141236 | 141236 | 2020-05-13 | McCurtain | Oklahoma | 40089 | 8 | 0 |
138240 | 138240 | 2020-05-12 | McCurtain | Oklahoma | 40089 | 8 | 0 |
135239 | 135239 | 2020-05-11 | Kingfisher | Oklahoma | 40073 | 8 | 0 |
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);