ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
502 rows where cases = 2 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 93
- Dewey 43
- Love 35
- Marshall 27
- Murray 26
- Washita 23
- Jefferson 17
- McIntosh 16
- Major 14
- Harper 11
- Pushmataha 11
- Beckham 10
- Choctaw 10
- Ellis 10
- Okfuskee 9
- Garvin 8
- Pittsburg 8
- Unknown 8
- Blaine 7
- Canadian 7
- Carter 7
- Tillman 6
- Grady 5
- Kiowa 5
- McClain 5
- McCurtain 5
- Pottawatomie 5
- Sequoyah 5
- Tulsa 5
- Atoka 3
- …
state 1
- Oklahoma · 502 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1084936 | 1084936 | 2021-03-03 | Unknown | Oklahoma | 2 | 0 | |
1081690 | 1081690 | 2021-03-02 | Unknown | Oklahoma | 2 | 0 | |
1078444 | 1078444 | 2021-03-01 | Unknown | Oklahoma | 2 | 0 | |
1071953 | 1071953 | 2021-02-27 | Unknown | Oklahoma | 2 | 0 | |
1058972 | 1058972 | 2021-02-23 | Unknown | Oklahoma | 2 | 0 | |
1039496 | 1039496 | 2021-02-17 | Unknown | Oklahoma | 2 | 0 | |
442895 | 442895 | 2020-08-17 | Unknown | Oklahoma | 2 | 0 | |
429931 | 429931 | 2020-08-13 | Cimarron | Oklahoma | 40025 | 2 | 0 |
365585 | 365585 | 2020-07-24 | Ellis | Oklahoma | 40045 | 2 | 0 |
365592 | 365592 | 2020-07-24 | Harper | Oklahoma | 40059 | 2 | 0 |
362379 | 362379 | 2020-07-23 | Ellis | Oklahoma | 40045 | 2 | 0 |
362386 | 362386 | 2020-07-23 | Harper | Oklahoma | 40059 | 2 | 0 |
359180 | 359180 | 2020-07-22 | Harper | Oklahoma | 40059 | 2 | 0 |
355976 | 355976 | 2020-07-21 | Harper | Oklahoma | 40059 | 2 | 0 |
352773 | 352773 | 2020-07-20 | Harper | Oklahoma | 40059 | 2 | 0 |
349570 | 349570 | 2020-07-19 | Harper | Oklahoma | 40059 | 2 | 0 |
346370 | 346370 | 2020-07-18 | Harper | Oklahoma | 40059 | 2 | 0 |
343170 | 343170 | 2020-07-17 | Harper | Oklahoma | 40059 | 2 | 0 |
339972 | 339972 | 2020-07-16 | Harper | Oklahoma | 40059 | 2 | 0 |
340014 | 340014 | 2020-07-16 | Unknown | Oklahoma | 2 | 0 | |
336769 | 336769 | 2020-07-15 | Ellis | Oklahoma | 40045 | 2 | 0 |
336776 | 336776 | 2020-07-15 | Harper | Oklahoma | 40059 | 2 | 0 |
333575 | 333575 | 2020-07-14 | Ellis | Oklahoma | 40045 | 2 | 0 |
333582 | 333582 | 2020-07-14 | Harper | Oklahoma | 40059 | 2 | 0 |
330383 | 330383 | 2020-07-13 | Ellis | Oklahoma | 40045 | 2 | 0 |
327196 | 327196 | 2020-07-12 | Ellis | Oklahoma | 40045 | 2 | 0 |
327200 | 327200 | 2020-07-12 | Grant | Oklahoma | 40053 | 2 | 0 |
324011 | 324011 | 2020-07-11 | Ellis | Oklahoma | 40045 | 2 | 0 |
324015 | 324015 | 2020-07-11 | Grant | Oklahoma | 40053 | 2 | 0 |
320831 | 320831 | 2020-07-10 | Ellis | Oklahoma | 40045 | 2 | 0 |
320835 | 320835 | 2020-07-10 | Grant | Oklahoma | 40053 | 2 | 0 |
317654 | 317654 | 2020-07-09 | Ellis | Oklahoma | 40045 | 2 | 0 |
317658 | 317658 | 2020-07-09 | Grant | Oklahoma | 40053 | 2 | 0 |
314481 | 314481 | 2020-07-08 | Ellis | Oklahoma | 40045 | 2 | 0 |
314485 | 314485 | 2020-07-08 | Grant | Oklahoma | 40053 | 2 | 0 |
311313 | 311313 | 2020-07-07 | Grant | Oklahoma | 40053 | 2 | 0 |
308144 | 308144 | 2020-07-06 | Grant | Oklahoma | 40053 | 2 | 0 |
308146 | 308146 | 2020-07-06 | Harmon | Oklahoma | 40057 | 2 | 0 |
304977 | 304977 | 2020-07-05 | Grant | Oklahoma | 40053 | 2 | 0 |
304979 | 304979 | 2020-07-05 | Harmon | Oklahoma | 40057 | 2 | 0 |
301814 | 301814 | 2020-07-04 | Grant | Oklahoma | 40053 | 2 | 0 |
301816 | 301816 | 2020-07-04 | Harmon | Oklahoma | 40057 | 2 | 0 |
298651 | 298651 | 2020-07-03 | Grant | Oklahoma | 40053 | 2 | 0 |
295492 | 295492 | 2020-07-02 | Grant | Oklahoma | 40053 | 2 | 0 |
292336 | 292336 | 2020-07-01 | Grant | Oklahoma | 40053 | 2 | 0 |
289184 | 289184 | 2020-06-30 | Grant | Oklahoma | 40053 | 2 | 0 |
286034 | 286034 | 2020-06-29 | Grant | Oklahoma | 40053 | 2 | 0 |
282889 | 282889 | 2020-06-28 | Grant | Oklahoma | 40053 | 2 | 0 |
279743 | 279743 | 2020-06-27 | Grant | Oklahoma | 40053 | 2 | 0 |
276595 | 276595 | 2020-06-26 | Grant | Oklahoma | 40053 | 2 | 0 |
273448 | 273448 | 2020-06-25 | Grant | Oklahoma | 40053 | 2 | 0 |
270309 | 270309 | 2020-06-24 | Grant | Oklahoma | 40053 | 2 | 0 |
267175 | 267175 | 2020-06-23 | Grant | Oklahoma | 40053 | 2 | 0 |
264047 | 264047 | 2020-06-22 | Grant | Oklahoma | 40053 | 2 | 0 |
260919 | 260919 | 2020-06-21 | Grant | Oklahoma | 40053 | 2 | 0 |
257792 | 257792 | 2020-06-20 | Grant | Oklahoma | 40053 | 2 | 0 |
254666 | 254666 | 2020-06-19 | Grant | Oklahoma | 40053 | 2 | 0 |
251551 | 251551 | 2020-06-18 | Grant | Oklahoma | 40053 | 2 | 0 |
248436 | 248436 | 2020-06-17 | Grant | Oklahoma | 40053 | 2 | 0 |
245323 | 245323 | 2020-06-16 | Grant | Oklahoma | 40053 | 2 | 0 |
242211 | 242211 | 2020-06-15 | Grant | Oklahoma | 40053 | 2 | 0 |
242257 | 242257 | 2020-06-15 | Washita | Oklahoma | 40149 | 2 | 0 |
239102 | 239102 | 2020-06-14 | Grant | Oklahoma | 40053 | 2 | 0 |
239148 | 239148 | 2020-06-14 | Washita | Oklahoma | 40149 | 2 | 0 |
235990 | 235990 | 2020-06-13 | Dewey | Oklahoma | 40043 | 2 | 0 |
235994 | 235994 | 2020-06-13 | Grant | Oklahoma | 40053 | 2 | 0 |
236040 | 236040 | 2020-06-13 | Washita | Oklahoma | 40149 | 2 | 0 |
232885 | 232885 | 2020-06-12 | Dewey | Oklahoma | 40043 | 2 | 0 |
232889 | 232889 | 2020-06-12 | Grant | Oklahoma | 40053 | 2 | 0 |
232935 | 232935 | 2020-06-12 | Washita | Oklahoma | 40149 | 2 | 0 |
229780 | 229780 | 2020-06-11 | Dewey | Oklahoma | 40043 | 2 | 0 |
229784 | 229784 | 2020-06-11 | Grant | Oklahoma | 40053 | 2 | 0 |
229830 | 229830 | 2020-06-11 | Washita | Oklahoma | 40149 | 2 | 0 |
226676 | 226676 | 2020-06-10 | Dewey | Oklahoma | 40043 | 2 | 0 |
226680 | 226680 | 2020-06-10 | Grant | Oklahoma | 40053 | 2 | 0 |
226726 | 226726 | 2020-06-10 | Washita | Oklahoma | 40149 | 2 | 0 |
223580 | 223580 | 2020-06-09 | Grant | Oklahoma | 40053 | 2 | 0 |
223626 | 223626 | 2020-06-09 | Washita | Oklahoma | 40149 | 2 | 0 |
220485 | 220485 | 2020-06-08 | Grant | Oklahoma | 40053 | 2 | 0 |
220531 | 220531 | 2020-06-08 | Washita | Oklahoma | 40149 | 2 | 0 |
217393 | 217393 | 2020-06-07 | Grant | Oklahoma | 40053 | 2 | 0 |
217439 | 217439 | 2020-06-07 | Washita | Oklahoma | 40149 | 2 | 0 |
214303 | 214303 | 2020-06-06 | Grant | Oklahoma | 40053 | 2 | 0 |
214349 | 214349 | 2020-06-06 | Washita | Oklahoma | 40149 | 2 | 0 |
211217 | 211217 | 2020-06-05 | Grant | Oklahoma | 40053 | 2 | 0 |
211263 | 211263 | 2020-06-05 | Washita | Oklahoma | 40149 | 2 | 0 |
208135 | 208135 | 2020-06-04 | Grant | Oklahoma | 40053 | 2 | 0 |
208181 | 208181 | 2020-06-04 | Washita | Oklahoma | 40149 | 2 | 0 |
205054 | 205054 | 2020-06-03 | Grant | Oklahoma | 40053 | 2 | 0 |
205100 | 205100 | 2020-06-03 | Washita | Oklahoma | 40149 | 2 | 0 |
201977 | 201977 | 2020-06-02 | Grant | Oklahoma | 40053 | 2 | 0 |
202023 | 202023 | 2020-06-02 | Washita | Oklahoma | 40149 | 2 | 0 |
198902 | 198902 | 2020-06-01 | Grant | Oklahoma | 40053 | 2 | 0 |
198948 | 198948 | 2020-06-01 | Washita | Oklahoma | 40149 | 2 | 0 |
195825 | 195825 | 2020-05-31 | Dewey | Oklahoma | 40043 | 2 | 0 |
195829 | 195829 | 2020-05-31 | Grant | Oklahoma | 40053 | 2 | 0 |
195875 | 195875 | 2020-05-31 | Washita | Oklahoma | 40149 | 2 | 0 |
192756 | 192756 | 2020-05-30 | Dewey | Oklahoma | 40043 | 2 | 0 |
192760 | 192760 | 2020-05-30 | Grant | Oklahoma | 40053 | 2 | 0 |
192796 | 192796 | 2020-05-30 | Pushmataha | Oklahoma | 40127 | 2 | 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);