ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Okmulgee" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637087 | 637087 | 2020-10-16 | Okmulgee | Oklahoma | 40111 | 1033 | 8 |
633841 | 633841 | 2020-10-15 | Okmulgee | Oklahoma | 40111 | 1002 | 8 |
630596 | 630596 | 2020-10-14 | Okmulgee | Oklahoma | 40111 | 988 | 8 |
627352 | 627352 | 2020-10-13 | Okmulgee | Oklahoma | 40111 | 979 | 8 |
624110 | 624110 | 2020-10-12 | Okmulgee | Oklahoma | 40111 | 959 | 8 |
620867 | 620867 | 2020-10-11 | Okmulgee | Oklahoma | 40111 | 955 | 8 |
617625 | 617625 | 2020-10-10 | Okmulgee | Oklahoma | 40111 | 951 | 8 |
614383 | 614383 | 2020-10-09 | Okmulgee | Oklahoma | 40111 | 937 | 8 |
611142 | 611142 | 2020-10-08 | Okmulgee | Oklahoma | 40111 | 931 | 8 |
607900 | 607900 | 2020-10-07 | Okmulgee | Oklahoma | 40111 | 911 | 8 |
604657 | 604657 | 2020-10-06 | Okmulgee | Oklahoma | 40111 | 899 | 8 |
601415 | 601415 | 2020-10-05 | Okmulgee | Oklahoma | 40111 | 893 | 8 |
598172 | 598172 | 2020-10-04 | Okmulgee | Oklahoma | 40111 | 890 | 8 |
594929 | 594929 | 2020-10-03 | Okmulgee | Oklahoma | 40111 | 889 | 8 |
591688 | 591688 | 2020-10-02 | Okmulgee | Oklahoma | 40111 | 876 | 8 |
588447 | 588447 | 2020-10-01 | Okmulgee | Oklahoma | 40111 | 864 | 8 |
585207 | 585207 | 2020-09-30 | Okmulgee | Oklahoma | 40111 | 852 | 8 |
581967 | 581967 | 2020-09-29 | Okmulgee | Oklahoma | 40111 | 849 | 7 |
578727 | 578727 | 2020-09-28 | Okmulgee | Oklahoma | 40111 | 835 | 7 |
575486 | 575486 | 2020-09-27 | Okmulgee | Oklahoma | 40111 | 832 | 7 |
572242 | 572242 | 2020-09-26 | Okmulgee | Oklahoma | 40111 | 833 | 7 |
569000 | 569000 | 2020-09-25 | Okmulgee | Oklahoma | 40111 | 823 | 7 |
565759 | 565759 | 2020-09-24 | Okmulgee | Oklahoma | 40111 | 816 | 7 |
562518 | 562518 | 2020-09-23 | Okmulgee | Oklahoma | 40111 | 795 | 5 |
559281 | 559281 | 2020-09-22 | Okmulgee | Oklahoma | 40111 | 791 | 5 |
556044 | 556044 | 2020-09-21 | Okmulgee | Oklahoma | 40111 | 775 | 5 |
552807 | 552807 | 2020-09-20 | Okmulgee | Oklahoma | 40111 | 771 | 5 |
549568 | 549568 | 2020-09-19 | Okmulgee | Oklahoma | 40111 | 769 | 5 |
546329 | 546329 | 2020-09-18 | Okmulgee | Oklahoma | 40111 | 755 | 5 |
543092 | 543092 | 2020-09-17 | Okmulgee | Oklahoma | 40111 | 747 | 5 |
539856 | 539856 | 2020-09-16 | Okmulgee | Oklahoma | 40111 | 736 | 5 |
536619 | 536619 | 2020-09-15 | Okmulgee | Oklahoma | 40111 | 729 | 5 |
533383 | 533383 | 2020-09-14 | Okmulgee | Oklahoma | 40111 | 719 | 5 |
530148 | 530148 | 2020-09-13 | Okmulgee | Oklahoma | 40111 | 710 | 5 |
526911 | 526911 | 2020-09-12 | Okmulgee | Oklahoma | 40111 | 703 | 5 |
523675 | 523675 | 2020-09-11 | Okmulgee | Oklahoma | 40111 | 700 | 5 |
520439 | 520439 | 2020-09-10 | Okmulgee | Oklahoma | 40111 | 691 | 5 |
517203 | 517203 | 2020-09-09 | Okmulgee | Oklahoma | 40111 | 688 | 5 |
513968 | 513968 | 2020-09-08 | Okmulgee | Oklahoma | 40111 | 678 | 5 |
510735 | 510735 | 2020-09-07 | Okmulgee | Oklahoma | 40111 | 673 | 5 |
507502 | 507502 | 2020-09-06 | Okmulgee | Oklahoma | 40111 | 668 | 5 |
504270 | 504270 | 2020-09-05 | Okmulgee | Oklahoma | 40111 | 654 | 5 |
501036 | 501036 | 2020-09-04 | Okmulgee | Oklahoma | 40111 | 649 | 5 |
497802 | 497802 | 2020-09-03 | Okmulgee | Oklahoma | 40111 | 640 | 5 |
494569 | 494569 | 2020-09-02 | Okmulgee | Oklahoma | 40111 | 630 | 4 |
491335 | 491335 | 2020-09-01 | Okmulgee | Oklahoma | 40111 | 621 | 4 |
488102 | 488102 | 2020-08-31 | Okmulgee | Oklahoma | 40111 | 613 | 4 |
484869 | 484869 | 2020-08-30 | Okmulgee | Oklahoma | 40111 | 614 | 4 |
481634 | 481634 | 2020-08-29 | Okmulgee | Oklahoma | 40111 | 613 | 4 |
478400 | 478400 | 2020-08-28 | Okmulgee | Oklahoma | 40111 | 592 | 4 |
475167 | 475167 | 2020-08-27 | Okmulgee | Oklahoma | 40111 | 585 | 4 |
471933 | 471933 | 2020-08-26 | Okmulgee | Oklahoma | 40111 | 585 | 4 |
468701 | 468701 | 2020-08-25 | Okmulgee | Oklahoma | 40111 | 578 | 4 |
465473 | 465473 | 2020-08-24 | Okmulgee | Oklahoma | 40111 | 567 | 4 |
462244 | 462244 | 2020-08-23 | Okmulgee | Oklahoma | 40111 | 566 | 4 |
459016 | 459016 | 2020-08-22 | Okmulgee | Oklahoma | 40111 | 561 | 4 |
455788 | 455788 | 2020-08-21 | Okmulgee | Oklahoma | 40111 | 553 | 4 |
452560 | 452560 | 2020-08-20 | Okmulgee | Oklahoma | 40111 | 531 | 3 |
449332 | 449332 | 2020-08-19 | Okmulgee | Oklahoma | 40111 | 522 | 3 |
446104 | 446104 | 2020-08-18 | Okmulgee | Oklahoma | 40111 | 520 | 3 |
442878 | 442878 | 2020-08-17 | Okmulgee | Oklahoma | 40111 | 508 | 3 |
439651 | 439651 | 2020-08-16 | Okmulgee | Oklahoma | 40111 | 505 | 3 |
436426 | 436426 | 2020-08-15 | Okmulgee | Oklahoma | 40111 | 504 | 3 |
433200 | 433200 | 2020-08-14 | Okmulgee | Oklahoma | 40111 | 500 | 3 |
429974 | 429974 | 2020-08-13 | Okmulgee | Oklahoma | 40111 | 496 | 3 |
426749 | 426749 | 2020-08-12 | Okmulgee | Oklahoma | 40111 | 494 | 3 |
423526 | 423526 | 2020-08-11 | Okmulgee | Oklahoma | 40111 | 479 | 3 |
420303 | 420303 | 2020-08-10 | Okmulgee | Oklahoma | 40111 | 469 | 3 |
417083 | 417083 | 2020-08-09 | Okmulgee | Oklahoma | 40111 | 467 | 3 |
413862 | 413862 | 2020-08-08 | Okmulgee | Oklahoma | 40111 | 466 | 3 |
410642 | 410642 | 2020-08-07 | Okmulgee | Oklahoma | 40111 | 453 | 3 |
407422 | 407422 | 2020-08-06 | Okmulgee | Oklahoma | 40111 | 441 | 3 |
404203 | 404203 | 2020-08-05 | Okmulgee | Oklahoma | 40111 | 411 | 3 |
400985 | 400985 | 2020-08-04 | Okmulgee | Oklahoma | 40111 | 405 | 3 |
397770 | 397770 | 2020-08-03 | Okmulgee | Oklahoma | 40111 | 396 | 3 |
394553 | 394553 | 2020-08-02 | Okmulgee | Oklahoma | 40111 | 399 | 3 |
391337 | 391337 | 2020-08-01 | Okmulgee | Oklahoma | 40111 | 394 | 3 |
388120 | 388120 | 2020-07-31 | Okmulgee | Oklahoma | 40111 | 370 | 2 |
384903 | 384903 | 2020-07-30 | Okmulgee | Oklahoma | 40111 | 369 | 2 |
381685 | 381685 | 2020-07-29 | Okmulgee | Oklahoma | 40111 | 353 | 1 |
378468 | 378468 | 2020-07-28 | Okmulgee | Oklahoma | 40111 | 349 | 0 |
375251 | 375251 | 2020-07-27 | Okmulgee | Oklahoma | 40111 | 326 | 0 |
372039 | 372039 | 2020-07-26 | Okmulgee | Oklahoma | 40111 | 312 | 0 |
368827 | 368827 | 2020-07-25 | Okmulgee | Oklahoma | 40111 | 280 | 0 |
365618 | 365618 | 2020-07-24 | Okmulgee | Oklahoma | 40111 | 272 | 0 |
362412 | 362412 | 2020-07-23 | Okmulgee | Oklahoma | 40111 | 251 | 0 |
359206 | 359206 | 2020-07-22 | Okmulgee | Oklahoma | 40111 | 242 | 0 |
356002 | 356002 | 2020-07-21 | Okmulgee | Oklahoma | 40111 | 233 | 0 |
352799 | 352799 | 2020-07-20 | Okmulgee | Oklahoma | 40111 | 219 | 0 |
349596 | 349596 | 2020-07-19 | Okmulgee | Oklahoma | 40111 | 218 | 0 |
346396 | 346396 | 2020-07-18 | Okmulgee | Oklahoma | 40111 | 216 | 0 |
343196 | 343196 | 2020-07-17 | Okmulgee | Oklahoma | 40111 | 204 | 0 |
339998 | 339998 | 2020-07-16 | Okmulgee | Oklahoma | 40111 | 201 | 0 |
336802 | 336802 | 2020-07-15 | Okmulgee | Oklahoma | 40111 | 196 | 0 |
333608 | 333608 | 2020-07-14 | Okmulgee | Oklahoma | 40111 | 186 | 0 |
330416 | 330416 | 2020-07-13 | Okmulgee | Oklahoma | 40111 | 157 | 0 |
327229 | 327229 | 2020-07-12 | Okmulgee | Oklahoma | 40111 | 151 | 0 |
324044 | 324044 | 2020-07-11 | Okmulgee | Oklahoma | 40111 | 146 | 0 |
320864 | 320864 | 2020-07-10 | Okmulgee | Oklahoma | 40111 | 136 | 0 |
317687 | 317687 | 2020-07-09 | Okmulgee | Oklahoma | 40111 | 127 | 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);