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 323
- 40109 316
- 40065 315
- 40027 314
- 40071 314
- 40119 314
- 40017 313
- 40117 312
- 40039 310
- 40051 310
- 40083 310
- 40087 310
- 40147 310
- 40049 309
- 40101 307
- 40103 307
- 40123 306
- 40097 305
- 40145 305
- 40001 304
- 40013 304
- 40019 304
- 40037 304
- 40041 304
- 40113 304
- 40125 304
- 40137 304
- 40031 303
- 40035 303
- 40081 303
- …
county >30
- Tulsa 323
- Oklahoma 316
- Jackson 315
- Cleveland 314
- Kay 314
- Payne 314
- Canadian 313
- Pawnee 312
- Custer 310
- Grady 310
- Logan 310
- McClain 310
- Washington 310
- Garvin 309
- Muskogee 307
- Noble 307
- Pontotoc 306
- Mayes 305
- Wagoner 305
- Adair 304
- Bryan 304
- Carter 304
- Creek 304
- Delaware 304
- Osage 304
- Pottawatomie 304
- Stephens 304
- Comanche 303
- Craig 303
- Lincoln 303
- …
state 1
- Oklahoma · 22,796 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955039 | 955039 | 2021-01-22 | Adair | Oklahoma | 40001 | 2609 | 18 |
955040 | 955040 | 2021-01-22 | Alfalfa | Oklahoma | 40003 | 1051 | 5 |
955041 | 955041 | 2021-01-22 | Atoka | Oklahoma | 40005 | 1581 | 8 |
955042 | 955042 | 2021-01-22 | Beaver | Oklahoma | 40007 | 357 | 3 |
955043 | 955043 | 2021-01-22 | Beckham | Oklahoma | 40009 | 2358 | 27 |
955044 | 955044 | 2021-01-22 | Blaine | Oklahoma | 40011 | 816 | 5 |
955045 | 955045 | 2021-01-22 | Bryan | Oklahoma | 40013 | 5011 | 44 |
955046 | 955046 | 2021-01-22 | Caddo | Oklahoma | 40015 | 3380 | 44 |
955047 | 955047 | 2021-01-22 | Canadian | Oklahoma | 40017 | 13483 | 59 |
955048 | 955048 | 2021-01-22 | Carter | Oklahoma | 40019 | 4604 | 22 |
955049 | 955049 | 2021-01-22 | Cherokee | Oklahoma | 40021 | 4817 | 27 |
955050 | 955050 | 2021-01-22 | Choctaw | Oklahoma | 40023 | 1365 | 9 |
955051 | 955051 | 2021-01-22 | Cimarron | Oklahoma | 40025 | 114 | 1 |
955052 | 955052 | 2021-01-22 | Cleveland | Oklahoma | 40027 | 24467 | 195 |
955053 | 955053 | 2021-01-22 | Coal | Oklahoma | 40029 | 592 | 8 |
955054 | 955054 | 2021-01-22 | Comanche | Oklahoma | 40031 | 9099 | 95 |
955055 | 955055 | 2021-01-22 | Cotton | Oklahoma | 40033 | 550 | 13 |
955056 | 955056 | 2021-01-22 | Craig | Oklahoma | 40035 | 1742 | 8 |
955057 | 955057 | 2021-01-22 | Creek | Oklahoma | 40037 | 5352 | 81 |
955058 | 955058 | 2021-01-22 | Custer | Oklahoma | 40039 | 3596 | 48 |
955059 | 955059 | 2021-01-22 | Delaware | Oklahoma | 40041 | 3873 | 53 |
955060 | 955060 | 2021-01-22 | Dewey | Oklahoma | 40043 | 487 | 4 |
955061 | 955061 | 2021-01-22 | Ellis | Oklahoma | 40045 | 331 | 1 |
955062 | 955062 | 2021-01-22 | Garfield | Oklahoma | 40047 | 6474 | 55 |
955063 | 955063 | 2021-01-22 | Garvin | Oklahoma | 40049 | 3027 | 24 |
955064 | 955064 | 2021-01-22 | Grady | Oklahoma | 40051 | 4964 | 52 |
955065 | 955065 | 2021-01-22 | Grant | Oklahoma | 40053 | 468 | 5 |
955066 | 955066 | 2021-01-22 | Greer | Oklahoma | 40055 | 441 | 10 |
955067 | 955067 | 2021-01-22 | Harmon | Oklahoma | 40057 | 250 | 1 |
955068 | 955068 | 2021-01-22 | Harper | Oklahoma | 40059 | 383 | 3 |
955069 | 955069 | 2021-01-22 | Haskell | Oklahoma | 40061 | 1083 | 8 |
955070 | 955070 | 2021-01-22 | Hughes | Oklahoma | 40063 | 1021 | 13 |
955071 | 955071 | 2021-01-22 | Jackson | Oklahoma | 40065 | 2624 | 40 |
955072 | 955072 | 2021-01-22 | Jefferson | Oklahoma | 40067 | 601 | 6 |
955073 | 955073 | 2021-01-22 | Johnston | Oklahoma | 40069 | 1124 | 12 |
955074 | 955074 | 2021-01-22 | Kay | Oklahoma | 40071 | 4437 | 52 |
955075 | 955075 | 2021-01-22 | Kingfisher | Oklahoma | 40073 | 1769 | 16 |
955076 | 955076 | 2021-01-22 | Kiowa | Oklahoma | 40075 | 673 | 13 |
955077 | 955077 | 2021-01-22 | Latimer | Oklahoma | 40077 | 692 | 7 |
955078 | 955078 | 2021-01-22 | Le Flore | Oklahoma | 40079 | 4591 | 37 |
955079 | 955079 | 2021-01-22 | Lincoln | Oklahoma | 40081 | 2652 | 38 |
955080 | 955080 | 2021-01-22 | Logan | Oklahoma | 40083 | 3402 | 20 |
955081 | 955081 | 2021-01-22 | Love | Oklahoma | 40085 | 1266 | 8 |
955082 | 955082 | 2021-01-22 | Major | Oklahoma | 40093 | 844 | 4 |
955083 | 955083 | 2021-01-22 | Marshall | Oklahoma | 40095 | 1583 | 10 |
955084 | 955084 | 2021-01-22 | Mayes | Oklahoma | 40097 | 3342 | 30 |
955085 | 955085 | 2021-01-22 | McClain | Oklahoma | 40087 | 4441 | 36 |
955086 | 955086 | 2021-01-22 | McCurtain | Oklahoma | 40089 | 3318 | 57 |
955087 | 955087 | 2021-01-22 | McIntosh | Oklahoma | 40091 | 1692 | 25 |
955088 | 955088 | 2021-01-22 | Murray | Oklahoma | 40099 | 1602 | 14 |
955089 | 955089 | 2021-01-22 | Muskogee | Oklahoma | 40101 | 8036 | 66 |
955090 | 955090 | 2021-01-22 | Noble | Oklahoma | 40103 | 1191 | 8 |
955091 | 955091 | 2021-01-22 | Nowata | Oklahoma | 40105 | 939 | 12 |
955092 | 955092 | 2021-01-22 | Okfuskee | Oklahoma | 40107 | 1613 | 16 |
955093 | 955093 | 2021-01-22 | Oklahoma | Oklahoma | 40109 | 71058 | 524 |
955094 | 955094 | 2021-01-22 | Okmulgee | Oklahoma | 40111 | 3164 | 36 |
955095 | 955095 | 2021-01-22 | Osage | Oklahoma | 40113 | 3830 | 35 |
955096 | 955096 | 2021-01-22 | Ottawa | Oklahoma | 40115 | 3300 | 34 |
955097 | 955097 | 2021-01-22 | Pawnee | Oklahoma | 40117 | 1388 | 18 |
955098 | 955098 | 2021-01-22 | Payne | Oklahoma | 40119 | 7395 | 38 |
955099 | 955099 | 2021-01-22 | Pittsburg | Oklahoma | 40121 | 3850 | 30 |
955100 | 955100 | 2021-01-22 | Pontotoc | Oklahoma | 40123 | 4076 | 36 |
955101 | 955101 | 2021-01-22 | Pottawatomie | Oklahoma | 40125 | 6824 | 48 |
955102 | 955102 | 2021-01-22 | Pushmataha | Oklahoma | 40127 | 855 | 8 |
955103 | 955103 | 2021-01-22 | Roger Mills | Oklahoma | 40129 | 353 | 6 |
955104 | 955104 | 2021-01-22 | Rogers | Oklahoma | 40131 | 8490 | 93 |
955105 | 955105 | 2021-01-22 | Seminole | Oklahoma | 40133 | 2353 | 25 |
955106 | 955106 | 2021-01-22 | Sequoyah | Oklahoma | 40135 | 3341 | 23 |
955107 | 955107 | 2021-01-22 | Stephens | Oklahoma | 40137 | 4008 | 42 |
955108 | 955108 | 2021-01-22 | Texas | Oklahoma | 40139 | 3267 | 19 |
955109 | 955109 | 2021-01-22 | Tillman | Oklahoma | 40141 | 663 | 13 |
955110 | 955110 | 2021-01-22 | Tulsa | Oklahoma | 40143 | 60142 | 526 |
955111 | 955111 | 2021-01-22 | Unknown | Oklahoma | 144 | 0 | |
955112 | 955112 | 2021-01-22 | Wagoner | Oklahoma | 40145 | 6426 | 65 |
955113 | 955113 | 2021-01-22 | Washington | Oklahoma | 40147 | 3944 | 70 |
955114 | 955114 | 2021-01-22 | Washita | Oklahoma | 40149 | 951 | 5 |
955115 | 955115 | 2021-01-22 | Woods | Oklahoma | 40151 | 1121 | 5 |
955116 | 955116 | 2021-01-22 | Woodward | Oklahoma | 40153 | 2871 | 12 |
951794 | 951794 | 2021-01-21 | Adair | Oklahoma | 40001 | 2594 | 18 |
951795 | 951795 | 2021-01-21 | Alfalfa | Oklahoma | 40003 | 1049 | 5 |
951796 | 951796 | 2021-01-21 | Atoka | Oklahoma | 40005 | 1574 | 8 |
951797 | 951797 | 2021-01-21 | Beaver | Oklahoma | 40007 | 355 | 3 |
951798 | 951798 | 2021-01-21 | Beckham | Oklahoma | 40009 | 2347 | 27 |
951799 | 951799 | 2021-01-21 | Blaine | Oklahoma | 40011 | 811 | 5 |
951800 | 951800 | 2021-01-21 | Bryan | Oklahoma | 40013 | 4945 | 44 |
951801 | 951801 | 2021-01-21 | Caddo | Oklahoma | 40015 | 3365 | 44 |
951802 | 951802 | 2021-01-21 | Canadian | Oklahoma | 40017 | 13384 | 59 |
951803 | 951803 | 2021-01-21 | Carter | Oklahoma | 40019 | 4568 | 21 |
951804 | 951804 | 2021-01-21 | Cherokee | Oklahoma | 40021 | 4792 | 27 |
951805 | 951805 | 2021-01-21 | Choctaw | Oklahoma | 40023 | 1362 | 9 |
951806 | 951806 | 2021-01-21 | Cimarron | Oklahoma | 40025 | 114 | 1 |
951807 | 951807 | 2021-01-21 | Cleveland | Oklahoma | 40027 | 24249 | 194 |
951808 | 951808 | 2021-01-21 | Coal | Oklahoma | 40029 | 588 | 8 |
951809 | 951809 | 2021-01-21 | Comanche | Oklahoma | 40031 | 8980 | 95 |
951810 | 951810 | 2021-01-21 | Cotton | Oklahoma | 40033 | 543 | 13 |
951811 | 951811 | 2021-01-21 | Craig | Oklahoma | 40035 | 1733 | 8 |
951812 | 951812 | 2021-01-21 | Creek | Oklahoma | 40037 | 5302 | 81 |
951813 | 951813 | 2021-01-21 | Custer | Oklahoma | 40039 | 3582 | 44 |
951814 | 951814 | 2021-01-21 | Delaware | Oklahoma | 40041 | 3842 | 52 |
951815 | 951815 | 2021-01-21 | Dewey | Oklahoma | 40043 | 485 | 4 |
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);