ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where cases = 28 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Pawnee 10
- Cherokee 7
- Mayes 6
- Lincoln 4
- Payne 4
- Garfield 3
- Murray 3
- Woodward 3
- Jackson 2
- Muskogee 2
- Nowata 2
- Pottawatomie 2
- Roger Mills 2
- Sequoyah 2
- Adair 1
- Canadian 1
- Cimarron 1
- Coal 1
- Cotton 1
- Garvin 1
- Hughes 1
- Jefferson 1
- Johnston 1
- Kiowa 1
- Le Flore 1
- Logan 1
- McClain 1
- Noble 1
- Ottawa 1
- Pittsburg 1
- …
state 1
- Oklahoma · 73 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
604614 | 604614 | 2020-10-06 | Cimarron | Oklahoma | 40025 | 28 | 0 |
556053 | 556053 | 2020-09-21 | Roger Mills | Oklahoma | 40129 | 28 | 1 |
552816 | 552816 | 2020-09-20 | Roger Mills | Oklahoma | 40129 | 28 | 1 |
484830 | 484830 | 2020-08-30 | Cotton | Oklahoma | 40033 | 28 | 2 |
420322 | 420322 | 2020-08-10 | Washita | Oklahoma | 40149 | 28 | 0 |
417065 | 417065 | 2020-08-09 | Kiowa | Oklahoma | 40075 | 28 | 1 |
388079 | 388079 | 2020-07-31 | Coal | Oklahoma | 40029 | 28 | 0 |
381663 | 381663 | 2020-07-29 | Jefferson | Oklahoma | 40067 | 28 | 0 |
378489 | 378489 | 2020-07-28 | Woodward | Oklahoma | 40153 | 28 | 0 |
375273 | 375273 | 2020-07-27 | Woodward | Oklahoma | 40153 | 28 | 0 |
372060 | 372060 | 2020-07-26 | Woodward | Oklahoma | 40153 | 28 | 0 |
368806 | 368806 | 2020-07-25 | Johnston | Oklahoma | 40069 | 28 | 0 |
362388 | 362388 | 2020-07-23 | Hughes | Oklahoma | 40063 | 28 | 1 |
343190 | 343190 | 2020-07-17 | Murray | Oklahoma | 40099 | 28 | 0 |
339992 | 339992 | 2020-07-16 | Murray | Oklahoma | 40099 | 28 | 0 |
336796 | 336796 | 2020-07-15 | Murray | Oklahoma | 40099 | 28 | 0 |
279756 | 279756 | 2020-06-27 | Lincoln | Oklahoma | 40081 | 28 | 2 |
276608 | 276608 | 2020-06-26 | Lincoln | Oklahoma | 40081 | 28 | 2 |
273487 | 273487 | 2020-06-25 | Sequoyah | Oklahoma | 40135 | 28 | 3 |
270322 | 270322 | 2020-06-24 | Lincoln | Oklahoma | 40081 | 28 | 2 |
270348 | 270348 | 2020-06-24 | Sequoyah | Oklahoma | 40135 | 28 | 3 |
267187 | 267187 | 2020-06-23 | Le Flore | Oklahoma | 40079 | 28 | 1 |
267188 | 267188 | 2020-06-23 | Lincoln | Oklahoma | 40081 | 28 | 2 |
267209 | 267209 | 2020-06-23 | Pontotoc | Oklahoma | 40123 | 28 | 2 |
264072 | 264072 | 2020-06-22 | Nowata | Oklahoma | 40105 | 28 | 1 |
260933 | 260933 | 2020-06-21 | Logan | Oklahoma | 40083 | 28 | 1 |
260943 | 260943 | 2020-06-21 | Noble | Oklahoma | 40103 | 28 | 0 |
260944 | 260944 | 2020-06-21 | Nowata | Oklahoma | 40105 | 28 | 1 |
239100 | 239100 | 2020-06-14 | Garvin | Oklahoma | 40049 | 28 | 1 |
220490 | 220490 | 2020-06-08 | Jackson | Oklahoma | 40065 | 28 | 3 |
217398 | 217398 | 2020-06-07 | Jackson | Oklahoma | 40065 | 28 | 3 |
208132 | 208132 | 2020-06-04 | Garfield | Oklahoma | 40047 | 28 | 1 |
205092 | 205092 | 2020-06-03 | Seminole | Oklahoma | 40133 | 28 | 2 |
198899 | 198899 | 2020-06-01 | Garfield | Oklahoma | 40047 | 28 | 1 |
195826 | 195826 | 2020-05-31 | Garfield | Oklahoma | 40047 | 28 | 1 |
189680 | 189680 | 2020-05-29 | Cherokee | Oklahoma | 40021 | 28 | 1 |
186620 | 186620 | 2020-05-28 | Cherokee | Oklahoma | 40021 | 28 | 1 |
177471 | 177471 | 2020-05-25 | Cherokee | Oklahoma | 40021 | 28 | 1 |
174427 | 174427 | 2020-05-24 | Cherokee | Oklahoma | 40021 | 28 | 1 |
171385 | 171385 | 2020-05-23 | Cherokee | Oklahoma | 40021 | 28 | 1 |
168346 | 168346 | 2020-05-22 | Cherokee | Oklahoma | 40021 | 28 | 1 |
165310 | 165310 | 2020-05-21 | Cherokee | Oklahoma | 40021 | 28 | 1 |
165342 | 165342 | 2020-05-21 | Mayes | Oklahoma | 40097 | 28 | 4 |
162313 | 162313 | 2020-05-20 | Mayes | Oklahoma | 40097 | 28 | 4 |
159286 | 159286 | 2020-05-19 | Mayes | Oklahoma | 40097 | 28 | 4 |
156265 | 156265 | 2020-05-18 | Mayes | Oklahoma | 40097 | 28 | 4 |
153248 | 153248 | 2020-05-17 | Mayes | Oklahoma | 40097 | 28 | 4 |
150237 | 150237 | 2020-05-16 | Mayes | Oklahoma | 40097 | 28 | 4 |
126284 | 126284 | 2020-05-08 | Muskogee | Oklahoma | 40101 | 28 | 6 |
123301 | 123301 | 2020-05-07 | Muskogee | Oklahoma | 40101 | 28 | 6 |
100153 | 100153 | 2020-04-29 | Pittsburg | Oklahoma | 40121 | 28 | 2 |
88822 | 88822 | 2020-04-25 | Pawnee | Oklahoma | 40117 | 28 | 2 |
86008 | 86008 | 2020-04-24 | Pawnee | Oklahoma | 40117 | 28 | 2 |
83192 | 83192 | 2020-04-23 | McClain | Oklahoma | 40087 | 28 | 0 |
83204 | 83204 | 2020-04-23 | Pawnee | Oklahoma | 40117 | 28 | 2 |
80404 | 80404 | 2020-04-22 | Ottawa | Oklahoma | 40115 | 28 | 0 |
80405 | 80405 | 2020-04-22 | Pawnee | Oklahoma | 40117 | 28 | 2 |
77615 | 77615 | 2020-04-21 | Pawnee | Oklahoma | 40117 | 28 | 2 |
74833 | 74833 | 2020-04-20 | Pawnee | Oklahoma | 40117 | 28 | 2 |
72058 | 72058 | 2020-04-19 | Pawnee | Oklahoma | 40117 | 28 | 2 |
69291 | 69291 | 2020-04-18 | Pawnee | Oklahoma | 40117 | 28 | 2 |
66533 | 66533 | 2020-04-17 | Pawnee | Oklahoma | 40117 | 28 | 2 |
63788 | 63788 | 2020-04-16 | Pawnee | Oklahoma | 40117 | 28 | 2 |
61066 | 61066 | 2020-04-15 | Pottawatomie | Oklahoma | 40125 | 28 | 3 |
58298 | 58298 | 2020-04-14 | Adair | Oklahoma | 40001 | 28 | 2 |
58348 | 58348 | 2020-04-14 | Payne | Oklahoma | 40119 | 28 | 0 |
58351 | 58351 | 2020-04-14 | Pottawatomie | Oklahoma | 40125 | 28 | 3 |
58352 | 58352 | 2020-04-14 | Rogers | Oklahoma | 40131 | 28 | 1 |
52961 | 52961 | 2020-04-12 | Payne | Oklahoma | 40119 | 28 | 0 |
50288 | 50288 | 2020-04-11 | Payne | Oklahoma | 40119 | 28 | 0 |
47632 | 47632 | 2020-04-10 | Payne | Oklahoma | 40119 | 28 | 0 |
30062 | 30062 | 2020-04-03 | Washington | Oklahoma | 40147 | 28 | 0 |
27685 | 27685 | 2020-04-02 | Canadian | Oklahoma | 40017 | 28 | 1 |
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);