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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 396
- 40109 389
- 40065 388
- 40071 387
- 40119 387
- 40027 386
- 40017 385
- 40117 385
- 40051 383
- 40083 383
- 40087 383
- 40147 383
- 40039 382
- 40049 382
- 40101 380
- 40103 380
- 40123 379
- 40097 378
- 40145 378
- 40113 377
- 40125 377
- 40137 377
- 40001 376
- 40013 376
- 40019 376
- 40037 376
- 40041 376
- 40081 376
- 40111 376
- 40115 376
- …
county >30
- Tulsa 396
- Oklahoma 389
- Jackson 388
- Kay 387
- Payne 387
- Cleveland 386
- Canadian 385
- Pawnee 385
- Grady 383
- Logan 383
- McClain 383
- Washington 383
- Custer 382
- Garvin 382
- Muskogee 380
- Noble 380
- Pontotoc 379
- Mayes 378
- Wagoner 378
- Osage 377
- Pottawatomie 377
- Stephens 377
- Adair 376
- Bryan 376
- Carter 376
- Creek 376
- Delaware 376
- Lincoln 376
- Okmulgee 376
- Ottawa 376
- …
state 1
- Oklahoma · 28,467 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1192032 | 1192032 | 2021-04-05 | Ellis | Oklahoma | 40045 | 354 | 3 |
1192033 | 1192033 | 2021-04-05 | Garfield | Oklahoma | 40047 | 7696 | 89 |
1192034 | 1192034 | 2021-04-05 | Garvin | Oklahoma | 40049 | 3539 | 56 |
1192035 | 1192035 | 2021-04-05 | Grady | Oklahoma | 40051 | 5809 | 88 |
1192036 | 1192036 | 2021-04-05 | Grant | Oklahoma | 40053 | 548 | 7 |
1192037 | 1192037 | 2021-04-05 | Greer | Oklahoma | 40055 | 571 | 17 |
1192038 | 1192038 | 2021-04-05 | Harmon | Oklahoma | 40057 | 307 | 3 |
1192039 | 1192039 | 2021-04-05 | Harper | Oklahoma | 40059 | 409 | 4 |
1192040 | 1192040 | 2021-04-05 | Haskell | Oklahoma | 40061 | 1240 | 11 |
1192041 | 1192041 | 2021-04-05 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1192042 | 1192042 | 2021-04-05 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1192043 | 1192043 | 2021-04-05 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1192044 | 1192044 | 2021-04-05 | Johnston | Oklahoma | 40069 | 1358 | 20 |
1192045 | 1192045 | 2021-04-05 | Kay | Oklahoma | 40071 | 5244 | 86 |
1192046 | 1192046 | 2021-04-05 | Kingfisher | Oklahoma | 40073 | 2023 | 27 |
1192047 | 1192047 | 2021-04-05 | Kiowa | Oklahoma | 40075 | 805 | 16 |
1192048 | 1192048 | 2021-04-05 | Latimer | Oklahoma | 40077 | 828 | 10 |
1192049 | 1192049 | 2021-04-05 | Le Flore | Oklahoma | 40079 | 5509 | 47 |
1192050 | 1192050 | 2021-04-05 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1192051 | 1192051 | 2021-04-05 | Logan | Oklahoma | 40083 | 4122 | 34 |
1192052 | 1192052 | 2021-04-05 | Love | Oklahoma | 40085 | 1457 | 13 |
1192053 | 1192053 | 2021-04-05 | Major | Oklahoma | 40093 | 949 | 13 |
1192054 | 1192054 | 2021-04-05 | Marshall | Oklahoma | 40095 | 1978 | 13 |
1192055 | 1192055 | 2021-04-05 | Mayes | Oklahoma | 40097 | 4126 | 43 |
1192056 | 1192056 | 2021-04-05 | McClain | Oklahoma | 40087 | 5153 | 57 |
1192057 | 1192057 | 2021-04-05 | McCurtain | Oklahoma | 40089 | 3887 | 71 |
1192058 | 1192058 | 2021-04-05 | McIntosh | Oklahoma | 40091 | 1971 | 39 |
1192059 | 1192059 | 2021-04-05 | Murray | Oklahoma | 40099 | 1957 | 23 |
1192060 | 1192060 | 2021-04-05 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1192061 | 1192061 | 2021-04-05 | Noble | Oklahoma | 40103 | 1370 | 16 |
1192062 | 1192062 | 2021-04-05 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1192063 | 1192063 | 2021-04-05 | Okfuskee | Oklahoma | 40107 | 1776 | 21 |
1192064 | 1192064 | 2021-04-05 | Oklahoma | Oklahoma | 40109 | 83647 | 837 |
1192065 | 1192065 | 2021-04-05 | Okmulgee | Oklahoma | 40111 | 3676 | 53 |
1192066 | 1192066 | 2021-04-05 | Osage | Oklahoma | 40113 | 4592 | 57 |
1192067 | 1192067 | 2021-04-05 | Ottawa | Oklahoma | 40115 | 3782 | 51 |
1192068 | 1192068 | 2021-04-05 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1192069 | 1192069 | 2021-04-05 | Payne | Oklahoma | 40119 | 8571 | 52 |
1192070 | 1192070 | 2021-04-05 | Pittsburg | Oklahoma | 40121 | 4581 | 47 |
1192071 | 1192071 | 2021-04-05 | Pontotoc | Oklahoma | 40123 | 5037 | 50 |
1192072 | 1192072 | 2021-04-05 | Pottawatomie | Oklahoma | 40125 | 8140 | 86 |
1192073 | 1192073 | 2021-04-05 | Pushmataha | Oklahoma | 40127 | 1005 | 14 |
1192074 | 1192074 | 2021-04-05 | Roger Mills | Oklahoma | 40129 | 386 | 9 |
1192075 | 1192075 | 2021-04-05 | Rogers | Oklahoma | 40131 | 10199 | 131 |
1192076 | 1192076 | 2021-04-05 | Seminole | Oklahoma | 40133 | 2817 | 43 |
1192077 | 1192077 | 2021-04-05 | Sequoyah | Oklahoma | 40135 | 4051 | 35 |
1192078 | 1192078 | 2021-04-05 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1192079 | 1192079 | 2021-04-05 | Texas | Oklahoma | 40139 | 3490 | 27 |
1192080 | 1192080 | 2021-04-05 | Tillman | Oklahoma | 40141 | 780 | 16 |
1192081 | 1192081 | 2021-04-05 | Tulsa | Oklahoma | 40143 | 72684 | 794 |
1192082 | 1192082 | 2021-04-05 | Unknown | Oklahoma | 2169 | 0 | |
1192083 | 1192083 | 2021-04-05 | Wagoner | Oklahoma | 40145 | 7848 | 91 |
1192084 | 1192084 | 2021-04-05 | Washington | Oklahoma | 40147 | 5047 | 95 |
1192085 | 1192085 | 2021-04-05 | Washita | Oklahoma | 40149 | 1067 | 9 |
1192086 | 1192086 | 2021-04-05 | Woods | Oklahoma | 40151 | 1197 | 11 |
1192087 | 1192087 | 2021-04-05 | Woodward | Oklahoma | 40153 | 3129 | 21 |
1188761 | 1188761 | 2021-04-04 | Adair | Oklahoma | 40001 | 3151 | 26 |
1188762 | 1188762 | 2021-04-04 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1188763 | 1188763 | 2021-04-04 | Atoka | Oklahoma | 40005 | 1856 | 15 |
1188764 | 1188764 | 2021-04-04 | Beaver | Oklahoma | 40007 | 459 | 6 |
1188765 | 1188765 | 2021-04-04 | Beckham | Oklahoma | 40009 | 2848 | 41 |
1188766 | 1188766 | 2021-04-04 | Blaine | Oklahoma | 40011 | 1016 | 9 |
1188767 | 1188767 | 2021-04-04 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1188768 | 1188768 | 2021-04-04 | Caddo | Oklahoma | 40015 | 3915 | 61 |
1188769 | 1188769 | 2021-04-04 | Canadian | Oklahoma | 40017 | 16434 | 106 |
1188770 | 1188770 | 2021-04-04 | Carter | Oklahoma | 40019 | 5937 | 65 |
1188771 | 1188771 | 2021-04-04 | Cherokee | Oklahoma | 40021 | 5558 | 47 |
1188772 | 1188772 | 2021-04-04 | Choctaw | Oklahoma | 40023 | 1601 | 16 |
1188773 | 1188773 | 2021-04-04 | Cimarron | Oklahoma | 40025 | 209 | 1 |
1188774 | 1188774 | 2021-04-04 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1188775 | 1188775 | 2021-04-04 | Coal | Oklahoma | 40029 | 689 | 14 |
1188776 | 1188776 | 2021-04-04 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1188777 | 1188777 | 2021-04-04 | Cotton | Oklahoma | 40033 | 666 | 14 |
1188778 | 1188778 | 2021-04-04 | Craig | Oklahoma | 40035 | 1936 | 12 |
1188779 | 1188779 | 2021-04-04 | Creek | Oklahoma | 40037 | 6757 | 124 |
1188780 | 1188780 | 2021-04-04 | Custer | Oklahoma | 40039 | 4058 | 73 |
1188781 | 1188781 | 2021-04-04 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1188782 | 1188782 | 2021-04-04 | Dewey | Oklahoma | 40043 | 543 | 6 |
1188783 | 1188783 | 2021-04-04 | Ellis | Oklahoma | 40045 | 354 | 3 |
1188784 | 1188784 | 2021-04-04 | Garfield | Oklahoma | 40047 | 7696 | 89 |
1188785 | 1188785 | 2021-04-04 | Garvin | Oklahoma | 40049 | 3539 | 56 |
1188786 | 1188786 | 2021-04-04 | Grady | Oklahoma | 40051 | 5809 | 88 |
1188787 | 1188787 | 2021-04-04 | Grant | Oklahoma | 40053 | 548 | 7 |
1188788 | 1188788 | 2021-04-04 | Greer | Oklahoma | 40055 | 571 | 17 |
1188789 | 1188789 | 2021-04-04 | Harmon | Oklahoma | 40057 | 307 | 3 |
1188790 | 1188790 | 2021-04-04 | Harper | Oklahoma | 40059 | 409 | 4 |
1188791 | 1188791 | 2021-04-04 | Haskell | Oklahoma | 40061 | 1240 | 11 |
1188792 | 1188792 | 2021-04-04 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1188793 | 1188793 | 2021-04-04 | Jackson | Oklahoma | 40065 | 3027 | 47 |
1188794 | 1188794 | 2021-04-04 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1188795 | 1188795 | 2021-04-04 | Johnston | Oklahoma | 40069 | 1358 | 20 |
1188796 | 1188796 | 2021-04-04 | Kay | Oklahoma | 40071 | 5244 | 86 |
1188797 | 1188797 | 2021-04-04 | Kingfisher | Oklahoma | 40073 | 2023 | 27 |
1188798 | 1188798 | 2021-04-04 | Kiowa | Oklahoma | 40075 | 805 | 16 |
1188799 | 1188799 | 2021-04-04 | Latimer | Oklahoma | 40077 | 828 | 10 |
1188800 | 1188800 | 2021-04-04 | Le Flore | Oklahoma | 40079 | 5509 | 47 |
1188801 | 1188801 | 2021-04-04 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1188802 | 1188802 | 2021-04-04 | Logan | Oklahoma | 40083 | 4122 | 34 |
1188803 | 1188803 | 2021-04-04 | Love | Oklahoma | 40085 | 1457 | 13 |
1188804 | 1188804 | 2021-04-04 | Major | Oklahoma | 40093 | 949 | 13 |
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);