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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 40143 799
- 40109 792
- 40065 791
- 40027 790
- 40071 790
- 40119 790
- 40017 789
- 40117 788
- 40039 786
- 40051 786
- 40083 786
- 40087 786
- 40147 786
- 40049 785
- 40101 783
- 40103 783
- 40123 782
- 40097 781
- 40145 781
- 40013 780
- 40019 780
- 40037 780
- 40041 780
- 40113 780
- 40125 780
- 40137 780
- 40031 779
- 40035 779
- 40081 779
- 40111 779
- …
county >30
- Tulsa 799
- Oklahoma 792
- Jackson 791
- Cleveland 790
- Kay 790
- Payne 790
- Canadian 789
- Pawnee 788
- Custer 786
- Grady 786
- Logan 786
- McClain 786
- Washington 786
- Garvin 785
- Muskogee 783
- Noble 783
- Pontotoc 782
- Mayes 781
- Wagoner 781
- Bryan 780
- Carter 780
- Creek 780
- Delaware 780
- Osage 780
- Pottawatomie 780
- Stephens 780
- Comanche 779
- Craig 779
- Lincoln 779
- Okmulgee 779
- …
state 1
- Oklahoma · 59,823 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
298625 | 298625 | 2020-07-03 | Adair | Oklahoma | 40001 | 119 | 4 |
301788 | 301788 | 2020-07-04 | Adair | Oklahoma | 40001 | 120 | 4 |
304951 | 304951 | 2020-07-05 | Adair | Oklahoma | 40001 | 121 | 4 |
308118 | 308118 | 2020-07-06 | Adair | Oklahoma | 40001 | 123 | 4 |
311287 | 311287 | 2020-07-07 | Adair | Oklahoma | 40001 | 129 | 4 |
314459 | 314459 | 2020-07-08 | Adair | Oklahoma | 40001 | 130 | 4 |
317632 | 317632 | 2020-07-09 | Adair | Oklahoma | 40001 | 136 | 4 |
320809 | 320809 | 2020-07-10 | Adair | Oklahoma | 40001 | 136 | 4 |
323989 | 323989 | 2020-07-11 | Adair | Oklahoma | 40001 | 136 | 4 |
327174 | 327174 | 2020-07-12 | Adair | Oklahoma | 40001 | 137 | 4 |
330361 | 330361 | 2020-07-13 | Adair | Oklahoma | 40001 | 137 | 4 |
333553 | 333553 | 2020-07-14 | Adair | Oklahoma | 40001 | 144 | 4 |
336747 | 336747 | 2020-07-15 | Adair | Oklahoma | 40001 | 160 | 4 |
339943 | 339943 | 2020-07-16 | Adair | Oklahoma | 40001 | 163 | 4 |
343141 | 343141 | 2020-07-17 | Adair | Oklahoma | 40001 | 166 | 4 |
346341 | 346341 | 2020-07-18 | Adair | Oklahoma | 40001 | 168 | 4 |
349541 | 349541 | 2020-07-19 | Adair | Oklahoma | 40001 | 170 | 4 |
352744 | 352744 | 2020-07-20 | Adair | Oklahoma | 40001 | 172 | 4 |
355947 | 355947 | 2020-07-21 | Adair | Oklahoma | 40001 | 196 | 4 |
359151 | 359151 | 2020-07-22 | Adair | Oklahoma | 40001 | 205 | 4 |
362357 | 362357 | 2020-07-23 | Adair | Oklahoma | 40001 | 209 | 4 |
365563 | 365563 | 2020-07-24 | Adair | Oklahoma | 40001 | 215 | 4 |
368772 | 368772 | 2020-07-25 | Adair | Oklahoma | 40001 | 227 | 5 |
371984 | 371984 | 2020-07-26 | Adair | Oklahoma | 40001 | 241 | 5 |
375196 | 375196 | 2020-07-27 | Adair | Oklahoma | 40001 | 246 | 5 |
378413 | 378413 | 2020-07-28 | Adair | Oklahoma | 40001 | 266 | 5 |
381630 | 381630 | 2020-07-29 | Adair | Oklahoma | 40001 | 268 | 5 |
384848 | 384848 | 2020-07-30 | Adair | Oklahoma | 40001 | 274 | 5 |
388065 | 388065 | 2020-07-31 | Adair | Oklahoma | 40001 | 283 | 5 |
391282 | 391282 | 2020-08-01 | Adair | Oklahoma | 40001 | 289 | 5 |
394498 | 394498 | 2020-08-02 | Adair | Oklahoma | 40001 | 303 | 5 |
397715 | 397715 | 2020-08-03 | Adair | Oklahoma | 40001 | 305 | 5 |
400930 | 400930 | 2020-08-04 | Adair | Oklahoma | 40001 | 311 | 6 |
404148 | 404148 | 2020-08-05 | Adair | Oklahoma | 40001 | 314 | 6 |
407367 | 407367 | 2020-08-06 | Adair | Oklahoma | 40001 | 325 | 6 |
410587 | 410587 | 2020-08-07 | Adair | Oklahoma | 40001 | 328 | 6 |
413807 | 413807 | 2020-08-08 | Adair | Oklahoma | 40001 | 339 | 6 |
417028 | 417028 | 2020-08-09 | Adair | Oklahoma | 40001 | 340 | 6 |
420248 | 420248 | 2020-08-10 | Adair | Oklahoma | 40001 | 341 | 6 |
423471 | 423471 | 2020-08-11 | Adair | Oklahoma | 40001 | 344 | 6 |
426694 | 426694 | 2020-08-12 | Adair | Oklahoma | 40001 | 346 | 6 |
429919 | 429919 | 2020-08-13 | Adair | Oklahoma | 40001 | 358 | 6 |
433145 | 433145 | 2020-08-14 | Adair | Oklahoma | 40001 | 361 | 6 |
436371 | 436371 | 2020-08-15 | Adair | Oklahoma | 40001 | 376 | 6 |
439596 | 439596 | 2020-08-16 | Adair | Oklahoma | 40001 | 378 | 6 |
442823 | 442823 | 2020-08-17 | Adair | Oklahoma | 40001 | 383 | 6 |
446049 | 446049 | 2020-08-18 | Adair | Oklahoma | 40001 | 384 | 6 |
449277 | 449277 | 2020-08-19 | Adair | Oklahoma | 40001 | 385 | 6 |
452505 | 452505 | 2020-08-20 | Adair | Oklahoma | 40001 | 400 | 6 |
455733 | 455733 | 2020-08-21 | Adair | Oklahoma | 40001 | 395 | 6 |
458961 | 458961 | 2020-08-22 | Adair | Oklahoma | 40001 | 408 | 6 |
462189 | 462189 | 2020-08-23 | Adair | Oklahoma | 40001 | 412 | 6 |
465418 | 465418 | 2020-08-24 | Adair | Oklahoma | 40001 | 410 | 6 |
468646 | 468646 | 2020-08-25 | Adair | Oklahoma | 40001 | 413 | 6 |
471878 | 471878 | 2020-08-26 | Adair | Oklahoma | 40001 | 417 | 6 |
475112 | 475112 | 2020-08-27 | Adair | Oklahoma | 40001 | 428 | 6 |
478345 | 478345 | 2020-08-28 | Adair | Oklahoma | 40001 | 432 | 6 |
481579 | 481579 | 2020-08-29 | Adair | Oklahoma | 40001 | 438 | 8 |
484814 | 484814 | 2020-08-30 | Adair | Oklahoma | 40001 | 442 | 8 |
488047 | 488047 | 2020-08-31 | Adair | Oklahoma | 40001 | 447 | 8 |
491280 | 491280 | 2020-09-01 | Adair | Oklahoma | 40001 | 458 | 9 |
494514 | 494514 | 2020-09-02 | Adair | Oklahoma | 40001 | 469 | 10 |
497747 | 497747 | 2020-09-03 | Adair | Oklahoma | 40001 | 483 | 10 |
500981 | 500981 | 2020-09-04 | Adair | Oklahoma | 40001 | 493 | 10 |
504215 | 504215 | 2020-09-05 | Adair | Oklahoma | 40001 | 494 | 10 |
507447 | 507447 | 2020-09-06 | Adair | Oklahoma | 40001 | 500 | 10 |
510680 | 510680 | 2020-09-07 | Adair | Oklahoma | 40001 | 504 | 10 |
513913 | 513913 | 2020-09-08 | Adair | Oklahoma | 40001 | 505 | 10 |
517148 | 517148 | 2020-09-09 | Adair | Oklahoma | 40001 | 510 | 10 |
520384 | 520384 | 2020-09-10 | Adair | Oklahoma | 40001 | 514 | 10 |
523620 | 523620 | 2020-09-11 | Adair | Oklahoma | 40001 | 518 | 10 |
526856 | 526856 | 2020-09-12 | Adair | Oklahoma | 40001 | 521 | 10 |
530093 | 530093 | 2020-09-13 | Adair | Oklahoma | 40001 | 523 | 10 |
533328 | 533328 | 2020-09-14 | Adair | Oklahoma | 40001 | 530 | 10 |
536564 | 536564 | 2020-09-15 | Adair | Oklahoma | 40001 | 536 | 10 |
539801 | 539801 | 2020-09-16 | Adair | Oklahoma | 40001 | 545 | 10 |
543037 | 543037 | 2020-09-17 | Adair | Oklahoma | 40001 | 559 | 10 |
546274 | 546274 | 2020-09-18 | Adair | Oklahoma | 40001 | 562 | 10 |
549513 | 549513 | 2020-09-19 | Adair | Oklahoma | 40001 | 574 | 10 |
552752 | 552752 | 2020-09-20 | Adair | Oklahoma | 40001 | 580 | 10 |
555989 | 555989 | 2020-09-21 | Adair | Oklahoma | 40001 | 581 | 10 |
559226 | 559226 | 2020-09-22 | Adair | Oklahoma | 40001 | 590 | 10 |
562463 | 562463 | 2020-09-23 | Adair | Oklahoma | 40001 | 599 | 10 |
565704 | 565704 | 2020-09-24 | Adair | Oklahoma | 40001 | 603 | 10 |
568945 | 568945 | 2020-09-25 | Adair | Oklahoma | 40001 | 609 | 10 |
572187 | 572187 | 2020-09-26 | Adair | Oklahoma | 40001 | 614 | 10 |
575431 | 575431 | 2020-09-27 | Adair | Oklahoma | 40001 | 621 | 10 |
578672 | 578672 | 2020-09-28 | Adair | Oklahoma | 40001 | 622 | 10 |
581912 | 581912 | 2020-09-29 | Adair | Oklahoma | 40001 | 634 | 10 |
585152 | 585152 | 2020-09-30 | Adair | Oklahoma | 40001 | 639 | 10 |
588392 | 588392 | 2020-10-01 | Adair | Oklahoma | 40001 | 649 | 10 |
591633 | 591633 | 2020-10-02 | Adair | Oklahoma | 40001 | 650 | 10 |
594874 | 594874 | 2020-10-03 | Adair | Oklahoma | 40001 | 650 | 10 |
598117 | 598117 | 2020-10-04 | Adair | Oklahoma | 40001 | 651 | 10 |
601360 | 601360 | 2020-10-05 | Adair | Oklahoma | 40001 | 656 | 10 |
604602 | 604602 | 2020-10-06 | Adair | Oklahoma | 40001 | 663 | 10 |
607845 | 607845 | 2020-10-07 | Adair | Oklahoma | 40001 | 666 | 10 |
611087 | 611087 | 2020-10-08 | Adair | Oklahoma | 40001 | 673 | 10 |
614328 | 614328 | 2020-10-09 | Adair | Oklahoma | 40001 | 685 | 10 |
617570 | 617570 | 2020-10-10 | Adair | Oklahoma | 40001 | 688 | 10 |
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);