ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
59,923 rows where state = "Oklahoma" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 795
- 40109 789
- 40017 788
- 40071 788
- 40027 787
- 40049 784
- 40117 784
- 40119 783
- 40147 783
- 40103 781
- 40001 780
- 40037 780
- 40039 780
- 40083 780
- 40145 780
- 40031 779
- 40051 779
- 40087 779
- 40097 779
- 40101 779
- 40111 779
- 40113 779
- 40125 779
- 40035 778
- 40041 778
- 40065 778
- 40077 778
- 40081 778
- 40115 778
- 40121 778
- …
county >30
- Tulsa 795
- Oklahoma 789
- Canadian 788
- Kay 788
- Cleveland 787
- Garvin 784
- Pawnee 784
- Payne 783
- Washington 783
- Noble 781
- Adair 780
- Creek 780
- Custer 780
- Logan 780
- Wagoner 780
- Comanche 779
- Grady 779
- Mayes 779
- McClain 779
- Muskogee 779
- Okmulgee 779
- Osage 779
- Pottawatomie 779
- Craig 778
- Delaware 778
- Jackson 778
- Latimer 778
- Lincoln 778
- Ottawa 778
- Pittsburg 778
- …
state 1
- Oklahoma · 59,823 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
15265 | 15265 | 2020-03-27 | Craig | Oklahoma | 40035 | 1 | 0 |
15271 | 15271 | 2020-03-27 | Jackson | Oklahoma | 40065 | 1 | 0 |
15273 | 15273 | 2020-03-27 | Latimer | Oklahoma | 40077 | 1 | 0 |
15283 | 15283 | 2020-03-27 | Ottawa | Oklahoma | 40115 | 1 | 0 |
15289 | 15289 | 2020-03-27 | Sequoyah | Oklahoma | 40135 | 1 | 0 |
15290 | 15290 | 2020-03-27 | Stephens | Oklahoma | 40137 | 1 | 0 |
17102 | 17102 | 2020-03-28 | Bryan | Oklahoma | 40013 | 1 | 0 |
17103 | 17103 | 2020-03-28 | Caddo | Oklahoma | 40015 | 1 | 0 |
17105 | 17105 | 2020-03-28 | Carter | Oklahoma | 40019 | 1 | 0 |
17106 | 17106 | 2020-03-28 | Cherokee | Oklahoma | 40021 | 1 | 0 |
17107 | 17107 | 2020-03-28 | Choctaw | Oklahoma | 40023 | 1 | 0 |
17110 | 17110 | 2020-03-28 | Craig | Oklahoma | 40035 | 1 | 0 |
17116 | 17116 | 2020-03-28 | Jackson | Oklahoma | 40065 | 1 | 0 |
17118 | 17118 | 2020-03-28 | Latimer | Oklahoma | 40077 | 1 | 0 |
17119 | 17119 | 2020-03-28 | Le Flore | Oklahoma | 40079 | 1 | 0 |
17126 | 17126 | 2020-03-28 | Nowata | Oklahoma | 40105 | 1 | 0 |
19036 | 19036 | 2020-03-29 | Bryan | Oklahoma | 40013 | 1 | 0 |
19037 | 19037 | 2020-03-29 | Caddo | Oklahoma | 40015 | 1 | 0 |
19039 | 19039 | 2020-03-29 | Carter | Oklahoma | 40019 | 1 | 0 |
19040 | 19040 | 2020-03-29 | Cherokee | Oklahoma | 40021 | 1 | 0 |
19041 | 19041 | 2020-03-29 | Choctaw | Oklahoma | 40023 | 1 | 0 |
19044 | 19044 | 2020-03-29 | Craig | Oklahoma | 40035 | 1 | 0 |
19051 | 19051 | 2020-03-29 | Jackson | Oklahoma | 40065 | 1 | 0 |
19053 | 19053 | 2020-03-29 | Latimer | Oklahoma | 40077 | 1 | 0 |
19054 | 19054 | 2020-03-29 | Le Flore | Oklahoma | 40079 | 1 | 0 |
19071 | 19071 | 2020-03-29 | Rogers | Oklahoma | 40131 | 1 | 0 |
19072 | 19072 | 2020-03-29 | Seminole | Oklahoma | 40133 | 1 | 0 |
19075 | 19075 | 2020-03-29 | Texas | Oklahoma | 40139 | 1 | 0 |
21083 | 21083 | 2020-03-30 | Beckham | Oklahoma | 40009 | 1 | 0 |
21084 | 21084 | 2020-03-30 | Bryan | Oklahoma | 40013 | 1 | 0 |
21085 | 21085 | 2020-03-30 | Caddo | Oklahoma | 40015 | 1 | 0 |
21087 | 21087 | 2020-03-30 | Carter | Oklahoma | 40019 | 1 | 0 |
21088 | 21088 | 2020-03-30 | Cherokee | Oklahoma | 40021 | 1 | 0 |
21089 | 21089 | 2020-03-30 | Choctaw | Oklahoma | 40023 | 1 | 0 |
21092 | 21092 | 2020-03-30 | Cotton | Oklahoma | 40033 | 1 | 0 |
21093 | 21093 | 2020-03-30 | Craig | Oklahoma | 40035 | 1 | 0 |
21100 | 21100 | 2020-03-30 | Jackson | Oklahoma | 40065 | 1 | 0 |
21102 | 21102 | 2020-03-30 | Latimer | Oklahoma | 40077 | 1 | 0 |
21103 | 21103 | 2020-03-30 | Le Flore | Oklahoma | 40079 | 1 | 0 |
21106 | 21106 | 2020-03-30 | Love | Oklahoma | 40085 | 1 | 0 |
21121 | 21121 | 2020-03-30 | Rogers | Oklahoma | 40131 | 1 | 0 |
21122 | 21122 | 2020-03-30 | Seminole | Oklahoma | 40133 | 1 | 0 |
21125 | 21125 | 2020-03-30 | Texas | Oklahoma | 40139 | 1 | 0 |
23216 | 23216 | 2020-03-31 | Beckham | Oklahoma | 40009 | 1 | 0 |
23217 | 23217 | 2020-03-31 | Bryan | Oklahoma | 40013 | 1 | 0 |
23218 | 23218 | 2020-03-31 | Caddo | Oklahoma | 40015 | 1 | 0 |
23220 | 23220 | 2020-03-31 | Carter | Oklahoma | 40019 | 1 | 0 |
23222 | 23222 | 2020-03-31 | Choctaw | Oklahoma | 40023 | 1 | 0 |
23225 | 23225 | 2020-03-31 | Cotton | Oklahoma | 40033 | 1 | 0 |
23226 | 23226 | 2020-03-31 | Craig | Oklahoma | 40035 | 1 | 0 |
23233 | 23233 | 2020-03-31 | Jackson | Oklahoma | 40065 | 1 | 0 |
23235 | 23235 | 2020-03-31 | Latimer | Oklahoma | 40077 | 1 | 0 |
23236 | 23236 | 2020-03-31 | Le Flore | Oklahoma | 40079 | 1 | 0 |
23239 | 23239 | 2020-03-31 | Love | Oklahoma | 40085 | 1 | 0 |
23255 | 23255 | 2020-03-31 | Seminole | Oklahoma | 40133 | 1 | 0 |
23258 | 23258 | 2020-03-31 | Texas | Oklahoma | 40139 | 1 | 0 |
25412 | 25412 | 2020-04-01 | Beckham | Oklahoma | 40009 | 1 | 0 |
25413 | 25413 | 2020-04-01 | Bryan | Oklahoma | 40013 | 1 | 0 |
25414 | 25414 | 2020-04-01 | Caddo | Oklahoma | 40015 | 1 | 0 |
25416 | 25416 | 2020-04-01 | Carter | Oklahoma | 40019 | 1 | 0 |
25418 | 25418 | 2020-04-01 | Choctaw | Oklahoma | 40023 | 1 | 0 |
25421 | 25421 | 2020-04-01 | Cotton | Oklahoma | 40033 | 1 | 0 |
25433 | 25433 | 2020-04-01 | Le Flore | Oklahoma | 40079 | 1 | 0 |
25436 | 25436 | 2020-04-01 | Love | Oklahoma | 40085 | 1 | 0 |
25452 | 25452 | 2020-04-01 | Seminole | Oklahoma | 40133 | 1 | 0 |
25455 | 25455 | 2020-04-01 | Texas | Oklahoma | 40139 | 1 | 0 |
27681 | 27681 | 2020-04-02 | Atoka | Oklahoma | 40005 | 1 | 0 |
27682 | 27682 | 2020-04-02 | Beckham | Oklahoma | 40009 | 1 | 0 |
27686 | 27686 | 2020-04-02 | Carter | Oklahoma | 40019 | 1 | 0 |
27688 | 27688 | 2020-04-02 | Choctaw | Oklahoma | 40023 | 1 | 0 |
27691 | 27691 | 2020-04-02 | Cotton | Oklahoma | 40033 | 1 | 0 |
27703 | 27703 | 2020-04-02 | Kiowa | Oklahoma | 40075 | 1 | 0 |
27705 | 27705 | 2020-04-02 | Le Flore | Oklahoma | 40079 | 1 | 0 |
27724 | 27724 | 2020-04-02 | Seminole | Oklahoma | 40133 | 1 | 0 |
27727 | 27727 | 2020-04-02 | Texas | Oklahoma | 40139 | 1 | 0 |
27731 | 27731 | 2020-04-02 | Woodward | Oklahoma | 40153 | 1 | 0 |
30010 | 30010 | 2020-04-03 | Atoka | Oklahoma | 40005 | 1 | 0 |
30011 | 30011 | 2020-04-03 | Beckham | Oklahoma | 40009 | 1 | 0 |
30015 | 30015 | 2020-04-03 | Carter | Oklahoma | 40019 | 1 | 0 |
30017 | 30017 | 2020-04-03 | Choctaw | Oklahoma | 40023 | 1 | 0 |
30028 | 30028 | 2020-04-03 | Grant | Oklahoma | 40053 | 1 | 0 |
30033 | 30033 | 2020-04-03 | Kiowa | Oklahoma | 40075 | 1 | 0 |
30035 | 30035 | 2020-04-03 | Le Flore | Oklahoma | 40079 | 1 | 0 |
30039 | 30039 | 2020-04-03 | Major | Oklahoma | 40093 | 1 | 0 |
30042 | 30042 | 2020-04-03 | McCurtain | Oklahoma | 40089 | 1 | 0 |
30056 | 30056 | 2020-04-03 | Seminole | Oklahoma | 40133 | 1 | 0 |
30059 | 30059 | 2020-04-03 | Texas | Oklahoma | 40139 | 1 | 0 |
30063 | 30063 | 2020-04-03 | Woodward | Oklahoma | 40153 | 1 | 0 |
32399 | 32399 | 2020-04-04 | Atoka | Oklahoma | 40005 | 1 | 0 |
32400 | 32400 | 2020-04-04 | Beckham | Oklahoma | 40009 | 1 | 0 |
32404 | 32404 | 2020-04-04 | Carter | Oklahoma | 40019 | 1 | 0 |
32417 | 32417 | 2020-04-04 | Grant | Oklahoma | 40053 | 1 | 0 |
32422 | 32422 | 2020-04-04 | Kiowa | Oklahoma | 40075 | 1 | 0 |
32424 | 32424 | 2020-04-04 | Le Flore | Oklahoma | 40079 | 1 | 0 |
32428 | 32428 | 2020-04-04 | Major | Oklahoma | 40093 | 1 | 0 |
32431 | 32431 | 2020-04-04 | McCurtain | Oklahoma | 40089 | 1 | 0 |
32448 | 32448 | 2020-04-04 | Texas | Oklahoma | 40139 | 1 | 0 |
32449 | 32449 | 2020-04-04 | Tillman | Oklahoma | 40141 | 1 | 0 |
32453 | 32453 | 2020-04-04 | Woodward | Oklahoma | 40153 | 1 | 0 |
34833 | 34833 | 2020-04-05 | Atoka | Oklahoma | 40005 | 1 | 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);