ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
877 rows where cases = 1 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Cimarron 113
- Alfalfa 105
- Harper 87
- Atoka 54
- Woodward 48
- Okfuskee 33
- Carter 29
- Ellis 24
- Pushmataha 23
- Tillman 23
- Murray 21
- Jackson 18
- Beaver 16
- Beckham 16
- Jefferson 15
- Coal 13
- Le Flore 12
- Kiowa 11
- Major 11
- Marshall 11
- Washita 10
- Bryan 8
- Choctaw 8
- Dewey 8
- Grant 8
- Grady 7
- McClain 7
- Payne 7
- Texas 7
- Unknown 7
- …
state 1
- Oklahoma · 877 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1075199 | 1075199 | 2021-02-28 | Unknown | Oklahoma | 1 | 0 | |
1065462 | 1065462 | 2021-02-25 | Unknown | Oklahoma | 1 | 0 | |
1055726 | 1055726 | 2021-02-22 | Unknown | Oklahoma | 1 | 0 | |
1052480 | 1052480 | 2021-02-21 | Unknown | Oklahoma | 1 | 0 | |
446121 | 446121 | 2020-08-18 | Unknown | Oklahoma | 1 | 0 | |
423483 | 423483 | 2020-08-11 | Cimarron | Oklahoma | 40025 | 1 | 0 |
420260 | 420260 | 2020-08-10 | Cimarron | Oklahoma | 40025 | 1 | 0 |
417040 | 417040 | 2020-08-09 | Cimarron | Oklahoma | 40025 | 1 | 0 |
413819 | 413819 | 2020-08-08 | Cimarron | Oklahoma | 40025 | 1 | 0 |
410599 | 410599 | 2020-08-07 | Cimarron | Oklahoma | 40025 | 1 | 0 |
407379 | 407379 | 2020-08-06 | Cimarron | Oklahoma | 40025 | 1 | 0 |
404160 | 404160 | 2020-08-05 | Cimarron | Oklahoma | 40025 | 1 | 0 |
400942 | 400942 | 2020-08-04 | Cimarron | Oklahoma | 40025 | 1 | 0 |
397727 | 397727 | 2020-08-03 | Cimarron | Oklahoma | 40025 | 1 | 0 |
394510 | 394510 | 2020-08-02 | Cimarron | Oklahoma | 40025 | 1 | 0 |
391294 | 391294 | 2020-08-01 | Cimarron | Oklahoma | 40025 | 1 | 0 |
388077 | 388077 | 2020-07-31 | Cimarron | Oklahoma | 40025 | 1 | 0 |
384860 | 384860 | 2020-07-30 | Cimarron | Oklahoma | 40025 | 1 | 0 |
381642 | 381642 | 2020-07-29 | Cimarron | Oklahoma | 40025 | 1 | 0 |
378425 | 378425 | 2020-07-28 | Cimarron | Oklahoma | 40025 | 1 | 0 |
375208 | 375208 | 2020-07-27 | Cimarron | Oklahoma | 40025 | 1 | 0 |
375268 | 375268 | 2020-07-27 | Unknown | Oklahoma | 1 | 0 | |
371985 | 371985 | 2020-07-26 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
371996 | 371996 | 2020-07-26 | Cimarron | Oklahoma | 40025 | 1 | 0 |
368773 | 368773 | 2020-07-25 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
368784 | 368784 | 2020-07-25 | Cimarron | Oklahoma | 40025 | 1 | 0 |
365564 | 365564 | 2020-07-24 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
365575 | 365575 | 2020-07-24 | Cimarron | Oklahoma | 40025 | 1 | 0 |
362358 | 362358 | 2020-07-23 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
362369 | 362369 | 2020-07-23 | Cimarron | Oklahoma | 40025 | 1 | 0 |
359152 | 359152 | 2020-07-22 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
359163 | 359163 | 2020-07-22 | Cimarron | Oklahoma | 40025 | 1 | 0 |
359173 | 359173 | 2020-07-22 | Ellis | Oklahoma | 40045 | 1 | 0 |
355948 | 355948 | 2020-07-21 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
355959 | 355959 | 2020-07-21 | Cimarron | Oklahoma | 40025 | 1 | 0 |
355969 | 355969 | 2020-07-21 | Ellis | Oklahoma | 40045 | 1 | 0 |
352745 | 352745 | 2020-07-20 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
352756 | 352756 | 2020-07-20 | Cimarron | Oklahoma | 40025 | 1 | 0 |
352766 | 352766 | 2020-07-20 | Ellis | Oklahoma | 40045 | 1 | 0 |
349542 | 349542 | 2020-07-19 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
349553 | 349553 | 2020-07-19 | Cimarron | Oklahoma | 40025 | 1 | 0 |
349563 | 349563 | 2020-07-19 | Ellis | Oklahoma | 40045 | 1 | 0 |
346342 | 346342 | 2020-07-18 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
346353 | 346353 | 2020-07-18 | Cimarron | Oklahoma | 40025 | 1 | 0 |
346363 | 346363 | 2020-07-18 | Ellis | Oklahoma | 40045 | 1 | 0 |
343142 | 343142 | 2020-07-17 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
343153 | 343153 | 2020-07-17 | Cimarron | Oklahoma | 40025 | 1 | 0 |
343163 | 343163 | 2020-07-17 | Ellis | Oklahoma | 40045 | 1 | 0 |
339944 | 339944 | 2020-07-16 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
339955 | 339955 | 2020-07-16 | Cimarron | Oklahoma | 40025 | 1 | 0 |
339965 | 339965 | 2020-07-16 | Ellis | Oklahoma | 40045 | 1 | 0 |
336748 | 336748 | 2020-07-15 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
336759 | 336759 | 2020-07-15 | Cimarron | Oklahoma | 40025 | 1 | 0 |
333554 | 333554 | 2020-07-14 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
333565 | 333565 | 2020-07-14 | Cimarron | Oklahoma | 40025 | 1 | 0 |
330362 | 330362 | 2020-07-13 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
330373 | 330373 | 2020-07-13 | Cimarron | Oklahoma | 40025 | 1 | 0 |
330390 | 330390 | 2020-07-13 | Harper | Oklahoma | 40059 | 1 | 0 |
327175 | 327175 | 2020-07-12 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
327186 | 327186 | 2020-07-12 | Cimarron | Oklahoma | 40025 | 1 | 0 |
327203 | 327203 | 2020-07-12 | Harper | Oklahoma | 40059 | 1 | 0 |
327238 | 327238 | 2020-07-12 | Roger Mills | Oklahoma | 40129 | 1 | 0 |
323990 | 323990 | 2020-07-11 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
324001 | 324001 | 2020-07-11 | Cimarron | Oklahoma | 40025 | 1 | 0 |
324018 | 324018 | 2020-07-11 | Harper | Oklahoma | 40059 | 1 | 0 |
324053 | 324053 | 2020-07-11 | Roger Mills | Oklahoma | 40129 | 1 | 0 |
320810 | 320810 | 2020-07-10 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
320821 | 320821 | 2020-07-10 | Cimarron | Oklahoma | 40025 | 1 | 0 |
320838 | 320838 | 2020-07-10 | Harper | Oklahoma | 40059 | 1 | 0 |
320873 | 320873 | 2020-07-10 | Roger Mills | Oklahoma | 40129 | 1 | 0 |
317633 | 317633 | 2020-07-09 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
317644 | 317644 | 2020-07-09 | Cimarron | Oklahoma | 40025 | 1 | 0 |
317661 | 317661 | 2020-07-09 | Harper | Oklahoma | 40059 | 1 | 0 |
314460 | 314460 | 2020-07-08 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
314471 | 314471 | 2020-07-08 | Cimarron | Oklahoma | 40025 | 1 | 0 |
314488 | 314488 | 2020-07-08 | Harper | Oklahoma | 40059 | 1 | 0 |
311288 | 311288 | 2020-07-07 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
311299 | 311299 | 2020-07-07 | Cimarron | Oklahoma | 40025 | 1 | 0 |
311309 | 311309 | 2020-07-07 | Ellis | Oklahoma | 40045 | 1 | 0 |
311316 | 311316 | 2020-07-07 | Harper | Oklahoma | 40059 | 1 | 0 |
308119 | 308119 | 2020-07-06 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
308130 | 308130 | 2020-07-06 | Cimarron | Oklahoma | 40025 | 1 | 0 |
308140 | 308140 | 2020-07-06 | Ellis | Oklahoma | 40045 | 1 | 0 |
308147 | 308147 | 2020-07-06 | Harper | Oklahoma | 40059 | 1 | 0 |
304952 | 304952 | 2020-07-05 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
304963 | 304963 | 2020-07-05 | Cimarron | Oklahoma | 40025 | 1 | 0 |
304973 | 304973 | 2020-07-05 | Ellis | Oklahoma | 40045 | 1 | 0 |
304980 | 304980 | 2020-07-05 | Harper | Oklahoma | 40059 | 1 | 0 |
301789 | 301789 | 2020-07-04 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
301800 | 301800 | 2020-07-04 | Cimarron | Oklahoma | 40025 | 1 | 0 |
301810 | 301810 | 2020-07-04 | Ellis | Oklahoma | 40045 | 1 | 0 |
301817 | 301817 | 2020-07-04 | Harper | Oklahoma | 40059 | 1 | 0 |
298626 | 298626 | 2020-07-03 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
298637 | 298637 | 2020-07-03 | Cimarron | Oklahoma | 40025 | 1 | 0 |
298647 | 298647 | 2020-07-03 | Ellis | Oklahoma | 40045 | 1 | 0 |
298653 | 298653 | 2020-07-03 | Harmon | Oklahoma | 40057 | 1 | 0 |
298654 | 298654 | 2020-07-03 | Harper | Oklahoma | 40059 | 1 | 0 |
295467 | 295467 | 2020-07-02 | Alfalfa | Oklahoma | 40003 | 1 | 0 |
295478 | 295478 | 2020-07-02 | Cimarron | Oklahoma | 40025 | 1 | 0 |
295488 | 295488 | 2020-07-02 | Ellis | Oklahoma | 40045 | 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);