ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
975 rows where deaths = 5 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Alfalfa 87
- Grant 68
- Seminole 62
- Rogers 53
- Ellis 49
- Pawnee 45
- Grady 32
- Haskell 32
- Mayes 30
- Woodward 30
- Woods 29
- Stephens 28
- Roger Mills 25
- Johnston 24
- Payne 24
- Cimarron 21
- Okmulgee 21
- Garvin 20
- Bryan 17
- Okfuskee 16
- Noble 15
- Nowata 15
- Comanche 14
- Latimer 13
- Tillman 13
- Craig 12
- Texas 12
- Logan 11
- Adair 10
- Blaine 10
- …
state 1
- Oklahoma · 975 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2264159 | 2264159 | 2022-03-01 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2260909 | 2260909 | 2022-02-28 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2257658 | 2257658 | 2022-02-27 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2254407 | 2254407 | 2022-02-26 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2251156 | 2251156 | 2022-02-25 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2247905 | 2247905 | 2022-02-24 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2244654 | 2244654 | 2022-02-23 | Cimarron | Oklahoma | 40025 | 559 | 5 |
2241403 | 2241403 | 2022-02-22 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2238152 | 2238152 | 2022-02-21 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2234901 | 2234901 | 2022-02-20 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2231650 | 2231650 | 2022-02-19 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2228399 | 2228399 | 2022-02-18 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2225148 | 2225148 | 2022-02-17 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2221897 | 2221897 | 2022-02-16 | Cimarron | Oklahoma | 40025 | 556 | 5 |
2218646 | 2218646 | 2022-02-15 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2215395 | 2215395 | 2022-02-14 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2212144 | 2212144 | 2022-02-13 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2208891 | 2208891 | 2022-02-12 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2205638 | 2205638 | 2022-02-11 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2202385 | 2202385 | 2022-02-10 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2199131 | 2199131 | 2022-02-09 | Cimarron | Oklahoma | 40025 | 545 | 5 |
1354388 | 1354388 | 2021-05-25 | Ellis | Oklahoma | 40045 | 357 | 5 |
1351142 | 1351142 | 2021-05-24 | Ellis | Oklahoma | 40045 | 357 | 5 |
1347896 | 1347896 | 2021-05-23 | Ellis | Oklahoma | 40045 | 357 | 5 |
1344648 | 1344648 | 2021-05-22 | Ellis | Oklahoma | 40045 | 357 | 5 |
1341400 | 1341400 | 2021-05-21 | Ellis | Oklahoma | 40045 | 357 | 5 |
1338152 | 1338152 | 2021-05-20 | Ellis | Oklahoma | 40045 | 357 | 5 |
1334905 | 1334905 | 2021-05-19 | Ellis | Oklahoma | 40045 | 357 | 5 |
1331658 | 1331658 | 2021-05-18 | Ellis | Oklahoma | 40045 | 357 | 5 |
1328411 | 1328411 | 2021-05-17 | Ellis | Oklahoma | 40045 | 357 | 5 |
1325165 | 1325165 | 2021-05-16 | Ellis | Oklahoma | 40045 | 357 | 5 |
1321919 | 1321919 | 2021-05-15 | Ellis | Oklahoma | 40045 | 357 | 5 |
1318673 | 1318673 | 2021-05-14 | Ellis | Oklahoma | 40045 | 357 | 5 |
1315425 | 1315425 | 2021-05-13 | Ellis | Oklahoma | 40045 | 357 | 5 |
1312179 | 1312179 | 2021-05-12 | Ellis | Oklahoma | 40045 | 357 | 5 |
1308932 | 1308932 | 2021-05-11 | Ellis | Oklahoma | 40045 | 356 | 5 |
1305686 | 1305686 | 2021-05-10 | Ellis | Oklahoma | 40045 | 356 | 5 |
1302440 | 1302440 | 2021-05-09 | Ellis | Oklahoma | 40045 | 356 | 5 |
1299192 | 1299192 | 2021-05-08 | Ellis | Oklahoma | 40045 | 356 | 5 |
1295946 | 1295946 | 2021-05-07 | Ellis | Oklahoma | 40045 | 356 | 5 |
1292700 | 1292700 | 2021-05-06 | Ellis | Oklahoma | 40045 | 356 | 5 |
1289454 | 1289454 | 2021-05-05 | Ellis | Oklahoma | 40045 | 356 | 5 |
1286208 | 1286208 | 2021-05-04 | Ellis | Oklahoma | 40045 | 354 | 5 |
1282962 | 1282962 | 2021-05-03 | Ellis | Oklahoma | 40045 | 354 | 5 |
1279715 | 1279715 | 2021-05-02 | Ellis | Oklahoma | 40045 | 354 | 5 |
1276468 | 1276468 | 2021-05-01 | Ellis | Oklahoma | 40045 | 354 | 5 |
1273221 | 1273221 | 2021-04-30 | Ellis | Oklahoma | 40045 | 354 | 5 |
1269974 | 1269974 | 2021-04-29 | Ellis | Oklahoma | 40045 | 354 | 5 |
1266727 | 1266727 | 2021-04-28 | Ellis | Oklahoma | 40045 | 354 | 5 |
1263480 | 1263480 | 2021-04-27 | Ellis | Oklahoma | 40045 | 354 | 5 |
1260233 | 1260233 | 2021-04-26 | Ellis | Oklahoma | 40045 | 354 | 5 |
1256986 | 1256986 | 2021-04-25 | Ellis | Oklahoma | 40045 | 354 | 5 |
1253739 | 1253739 | 2021-04-24 | Ellis | Oklahoma | 40045 | 354 | 5 |
1250492 | 1250492 | 2021-04-23 | Ellis | Oklahoma | 40045 | 354 | 5 |
1247245 | 1247245 | 2021-04-22 | Ellis | Oklahoma | 40045 | 354 | 5 |
1243998 | 1243998 | 2021-04-21 | Ellis | Oklahoma | 40045 | 354 | 5 |
1240751 | 1240751 | 2021-04-20 | Ellis | Oklahoma | 40045 | 353 | 5 |
1237504 | 1237504 | 2021-04-19 | Ellis | Oklahoma | 40045 | 353 | 5 |
1234257 | 1234257 | 2021-04-18 | Ellis | Oklahoma | 40045 | 353 | 5 |
1231009 | 1231009 | 2021-04-17 | Ellis | Oklahoma | 40045 | 353 | 5 |
1227761 | 1227761 | 2021-04-16 | Ellis | Oklahoma | 40045 | 353 | 5 |
1224513 | 1224513 | 2021-04-15 | Ellis | Oklahoma | 40045 | 353 | 5 |
1221266 | 1221266 | 2021-04-14 | Ellis | Oklahoma | 40045 | 353 | 5 |
1218018 | 1218018 | 2021-04-13 | Ellis | Oklahoma | 40045 | 353 | 5 |
1214770 | 1214770 | 2021-04-12 | Ellis | Oklahoma | 40045 | 353 | 5 |
1211523 | 1211523 | 2021-04-11 | Ellis | Oklahoma | 40045 | 353 | 5 |
1208274 | 1208274 | 2021-04-10 | Ellis | Oklahoma | 40045 | 353 | 5 |
1205026 | 1205026 | 2021-04-09 | Ellis | Oklahoma | 40045 | 353 | 5 |
1201778 | 1201778 | 2021-04-08 | Ellis | Oklahoma | 40045 | 353 | 5 |
1198529 | 1198529 | 2021-04-07 | Ellis | Oklahoma | 40045 | 353 | 5 |
1195259 | 1195259 | 2021-04-06 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1192011 | 1192011 | 2021-04-05 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1188762 | 1188762 | 2021-04-04 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1185515 | 1185515 | 2021-04-03 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1182268 | 1182268 | 2021-04-02 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1179021 | 1179021 | 2021-04-01 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1175774 | 1175774 | 2021-03-31 | Alfalfa | Oklahoma | 40003 | 1155 | 5 |
1172527 | 1172527 | 2021-03-30 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1169280 | 1169280 | 2021-03-29 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1166032 | 1166032 | 2021-03-28 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1162784 | 1162784 | 2021-03-27 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1159535 | 1159535 | 2021-03-26 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1156288 | 1156288 | 2021-03-25 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1153041 | 1153041 | 2021-03-24 | Alfalfa | Oklahoma | 40003 | 1151 | 5 |
1149794 | 1149794 | 2021-03-23 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1146547 | 1146547 | 2021-03-22 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1143300 | 1143300 | 2021-03-21 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1140053 | 1140053 | 2021-03-20 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1136807 | 1136807 | 2021-03-19 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1133561 | 1133561 | 2021-03-18 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1130313 | 1130313 | 2021-03-17 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1127066 | 1127066 | 2021-03-16 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1123820 | 1123820 | 2021-03-15 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1120574 | 1120574 | 2021-03-14 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1117327 | 1117327 | 2021-03-13 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1114080 | 1114080 | 2021-03-12 | Alfalfa | Oklahoma | 40003 | 1149 | 5 |
1110834 | 1110834 | 2021-03-11 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1107588 | 1107588 | 2021-03-10 | Alfalfa | Oklahoma | 40003 | 1150 | 5 |
1104342 | 1104342 | 2021-03-09 | Alfalfa | Oklahoma | 40003 | 1149 | 5 |
1101096 | 1101096 | 2021-03-08 | Alfalfa | Oklahoma | 40003 | 1149 | 5 |
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);