ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where date = "2020-04-03" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
30009 | 30009 | 2020-04-03 | Adair | Oklahoma | 40001 | 14 | 0 |
30010 | 30010 | 2020-04-03 | Atoka | Oklahoma | 40005 | 1 | 0 |
30011 | 30011 | 2020-04-03 | Beckham | Oklahoma | 40009 | 1 | 0 |
30012 | 30012 | 2020-04-03 | Bryan | Oklahoma | 40013 | 3 | 0 |
30013 | 30013 | 2020-04-03 | Caddo | Oklahoma | 40015 | 2 | 0 |
30014 | 30014 | 2020-04-03 | Canadian | Oklahoma | 40017 | 29 | 1 |
30015 | 30015 | 2020-04-03 | Carter | Oklahoma | 40019 | 1 | 0 |
30016 | 30016 | 2020-04-03 | Cherokee | Oklahoma | 40021 | 7 | 0 |
30017 | 30017 | 2020-04-03 | Choctaw | Oklahoma | 40023 | 1 | 0 |
30018 | 30018 | 2020-04-03 | Cleveland | Oklahoma | 40027 | 130 | 7 |
30019 | 30019 | 2020-04-03 | Comanche | Oklahoma | 40031 | 33 | 0 |
30020 | 30020 | 2020-04-03 | Cotton | Oklahoma | 40033 | 4 | 0 |
30021 | 30021 | 2020-04-03 | Craig | Oklahoma | 40035 | 2 | 0 |
30022 | 30022 | 2020-04-03 | Creek | Oklahoma | 40037 | 39 | 1 |
30023 | 30023 | 2020-04-03 | Custer | Oklahoma | 40039 | 5 | 0 |
30024 | 30024 | 2020-04-03 | Delaware | Oklahoma | 40041 | 11 | 0 |
30025 | 30025 | 2020-04-03 | Garfield | Oklahoma | 40047 | 5 | 0 |
30026 | 30026 | 2020-04-03 | Garvin | Oklahoma | 40049 | 8 | 0 |
30027 | 30027 | 2020-04-03 | Grady | Oklahoma | 40051 | 5 | 0 |
30028 | 30028 | 2020-04-03 | Grant | Oklahoma | 40053 | 1 | 0 |
30029 | 30029 | 2020-04-03 | Greer | Oklahoma | 40055 | 5 | 1 |
30030 | 30030 | 2020-04-03 | Jackson | Oklahoma | 40065 | 4 | 0 |
30031 | 30031 | 2020-04-03 | Kay | Oklahoma | 40071 | 25 | 1 |
30032 | 30032 | 2020-04-03 | Kingfisher | Oklahoma | 40073 | 3 | 0 |
30033 | 30033 | 2020-04-03 | Kiowa | Oklahoma | 40075 | 1 | 0 |
30034 | 30034 | 2020-04-03 | Latimer | Oklahoma | 40077 | 2 | 0 |
30035 | 30035 | 2020-04-03 | Le Flore | Oklahoma | 40079 | 1 | 0 |
30036 | 30036 | 2020-04-03 | Lincoln | Oklahoma | 40081 | 7 | 0 |
30037 | 30037 | 2020-04-03 | Logan | Oklahoma | 40083 | 5 | 0 |
30038 | 30038 | 2020-04-03 | Love | Oklahoma | 40085 | 2 | 0 |
30039 | 30039 | 2020-04-03 | Major | Oklahoma | 40093 | 1 | 0 |
30040 | 30040 | 2020-04-03 | Mayes | Oklahoma | 40097 | 5 | 1 |
30041 | 30041 | 2020-04-03 | McClain | Oklahoma | 40087 | 11 | 0 |
30042 | 30042 | 2020-04-03 | McCurtain | Oklahoma | 40089 | 1 | 0 |
30043 | 30043 | 2020-04-03 | Muskogee | Oklahoma | 40101 | 16 | 2 |
30044 | 30044 | 2020-04-03 | Noble | Oklahoma | 40103 | 5 | 0 |
30045 | 30045 | 2020-04-03 | Nowata | Oklahoma | 40105 | 7 | 0 |
30046 | 30046 | 2020-04-03 | Oklahoma | Oklahoma | 40109 | 237 | 10 |
30047 | 30047 | 2020-04-03 | Okmulgee | Oklahoma | 40111 | 7 | 0 |
30048 | 30048 | 2020-04-03 | Osage | Oklahoma | 40113 | 22 | 1 |
30049 | 30049 | 2020-04-03 | Ottawa | Oklahoma | 40115 | 8 | 0 |
30050 | 30050 | 2020-04-03 | Pawnee | Oklahoma | 40117 | 16 | 1 |
30051 | 30051 | 2020-04-03 | Payne | Oklahoma | 40119 | 18 | 0 |
30052 | 30052 | 2020-04-03 | Pittsburg | Oklahoma | 40121 | 2 | 0 |
30053 | 30053 | 2020-04-03 | Pontotoc | Oklahoma | 40123 | 7 | 0 |
30054 | 30054 | 2020-04-03 | Pottawatomie | Oklahoma | 40125 | 11 | 0 |
30055 | 30055 | 2020-04-03 | Rogers | Oklahoma | 40131 | 10 | 0 |
30056 | 30056 | 2020-04-03 | Seminole | Oklahoma | 40133 | 1 | 0 |
30057 | 30057 | 2020-04-03 | Sequoyah | Oklahoma | 40135 | 4 | 1 |
30058 | 30058 | 2020-04-03 | Stephens | Oklahoma | 40137 | 8 | 1 |
30059 | 30059 | 2020-04-03 | Texas | Oklahoma | 40139 | 1 | 0 |
30060 | 30060 | 2020-04-03 | Tulsa | Oklahoma | 40143 | 175 | 8 |
30061 | 30061 | 2020-04-03 | Wagoner | Oklahoma | 40145 | 30 | 2 |
30062 | 30062 | 2020-04-03 | Washington | Oklahoma | 40147 | 28 | 0 |
30063 | 30063 | 2020-04-03 | Woodward | Oklahoma | 40153 | 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);