ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
757 rows where county = "Haskell" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955069 | 955069 | 2021-01-22 | Haskell | Oklahoma | 40061 | 1083 | 8 |
951824 | 951824 | 2021-01-21 | Haskell | Oklahoma | 40061 | 1072 | 7 |
948579 | 948579 | 2021-01-20 | Haskell | Oklahoma | 40061 | 1062 | 7 |
945333 | 945333 | 2021-01-19 | Haskell | Oklahoma | 40061 | 1049 | 7 |
942086 | 942086 | 2021-01-18 | Haskell | Oklahoma | 40061 | 1048 | 7 |
938841 | 938841 | 2021-01-17 | Haskell | Oklahoma | 40061 | 1040 | 7 |
935596 | 935596 | 2021-01-16 | Haskell | Oklahoma | 40061 | 1029 | 7 |
932351 | 932351 | 2021-01-15 | Haskell | Oklahoma | 40061 | 1024 | 7 |
929106 | 929106 | 2021-01-14 | Haskell | Oklahoma | 40061 | 1012 | 7 |
925861 | 925861 | 2021-01-13 | Haskell | Oklahoma | 40061 | 1004 | 7 |
922615 | 922615 | 2021-01-12 | Haskell | Oklahoma | 40061 | 999 | 7 |
919370 | 919370 | 2021-01-11 | Haskell | Oklahoma | 40061 | 992 | 7 |
916125 | 916125 | 2021-01-10 | Haskell | Oklahoma | 40061 | 985 | 7 |
912880 | 912880 | 2021-01-09 | Haskell | Oklahoma | 40061 | 963 | 7 |
909635 | 909635 | 2021-01-08 | Haskell | Oklahoma | 40061 | 947 | 7 |
906390 | 906390 | 2021-01-07 | Haskell | Oklahoma | 40061 | 929 | 7 |
903144 | 903144 | 2021-01-06 | Haskell | Oklahoma | 40061 | 922 | 7 |
899899 | 899899 | 2021-01-05 | Haskell | Oklahoma | 40061 | 911 | 7 |
896654 | 896654 | 2021-01-04 | Haskell | Oklahoma | 40061 | 909 | 7 |
893408 | 893408 | 2021-01-03 | Haskell | Oklahoma | 40061 | 903 | 7 |
890162 | 890162 | 2021-01-02 | Haskell | Oklahoma | 40061 | 890 | 7 |
886915 | 886915 | 2021-01-01 | Haskell | Oklahoma | 40061 | 878 | 7 |
883670 | 883670 | 2020-12-31 | Haskell | Oklahoma | 40061 | 878 | 7 |
880425 | 880425 | 2020-12-30 | Haskell | Oklahoma | 40061 | 851 | 7 |
877180 | 877180 | 2020-12-29 | Haskell | Oklahoma | 40061 | 830 | 7 |
873935 | 873935 | 2020-12-28 | Haskell | Oklahoma | 40061 | 826 | 7 |
870690 | 870690 | 2020-12-27 | Haskell | Oklahoma | 40061 | 822 | 7 |
867445 | 867445 | 2020-12-26 | Haskell | Oklahoma | 40061 | 814 | 7 |
864200 | 864200 | 2020-12-25 | Haskell | Oklahoma | 40061 | 798 | 7 |
860955 | 860955 | 2020-12-24 | Haskell | Oklahoma | 40061 | 798 | 7 |
857710 | 857710 | 2020-12-23 | Haskell | Oklahoma | 40061 | 783 | 7 |
854465 | 854465 | 2020-12-22 | Haskell | Oklahoma | 40061 | 768 | 7 |
851220 | 851220 | 2020-12-21 | Haskell | Oklahoma | 40061 | 764 | 7 |
847975 | 847975 | 2020-12-20 | Haskell | Oklahoma | 40061 | 761 | 7 |
844730 | 844730 | 2020-12-19 | Haskell | Oklahoma | 40061 | 746 | 7 |
841484 | 841484 | 2020-12-18 | Haskell | Oklahoma | 40061 | 738 | 7 |
838239 | 838239 | 2020-12-17 | Haskell | Oklahoma | 40061 | 734 | 7 |
834993 | 834993 | 2020-12-16 | Haskell | Oklahoma | 40061 | 733 | 7 |
831747 | 831747 | 2020-12-15 | Haskell | Oklahoma | 40061 | 724 | 7 |
828500 | 828500 | 2020-12-14 | Haskell | Oklahoma | 40061 | 723 | 7 |
825254 | 825254 | 2020-12-13 | Haskell | Oklahoma | 40061 | 715 | 7 |
822007 | 822007 | 2020-12-12 | Haskell | Oklahoma | 40061 | 705 | 7 |
818761 | 818761 | 2020-12-11 | Haskell | Oklahoma | 40061 | 696 | 7 |
815515 | 815515 | 2020-12-10 | Haskell | Oklahoma | 40061 | 691 | 7 |
812269 | 812269 | 2020-12-09 | Haskell | Oklahoma | 40061 | 680 | 7 |
809025 | 809025 | 2020-12-08 | Haskell | Oklahoma | 40061 | 674 | 7 |
805780 | 805780 | 2020-12-07 | Haskell | Oklahoma | 40061 | 672 | 7 |
802535 | 802535 | 2020-12-06 | Haskell | Oklahoma | 40061 | 671 | 7 |
799290 | 799290 | 2020-12-05 | Haskell | Oklahoma | 40061 | 663 | 7 |
796045 | 796045 | 2020-12-04 | Haskell | Oklahoma | 40061 | 658 | 7 |
792800 | 792800 | 2020-12-03 | Haskell | Oklahoma | 40061 | 655 | 7 |
789555 | 789555 | 2020-12-02 | Haskell | Oklahoma | 40061 | 653 | 7 |
786310 | 786310 | 2020-12-01 | Haskell | Oklahoma | 40061 | 646 | 6 |
783066 | 783066 | 2020-11-30 | Haskell | Oklahoma | 40061 | 646 | 6 |
779820 | 779820 | 2020-11-29 | Haskell | Oklahoma | 40061 | 646 | 6 |
776575 | 776575 | 2020-11-28 | Haskell | Oklahoma | 40061 | 644 | 6 |
773330 | 773330 | 2020-11-27 | Haskell | Oklahoma | 40061 | 637 | 6 |
770085 | 770085 | 2020-11-26 | Haskell | Oklahoma | 40061 | 630 | 6 |
766839 | 766839 | 2020-11-25 | Haskell | Oklahoma | 40061 | 630 | 6 |
763594 | 763594 | 2020-11-24 | Haskell | Oklahoma | 40061 | 623 | 6 |
760349 | 760349 | 2020-11-23 | Haskell | Oklahoma | 40061 | 618 | 6 |
757104 | 757104 | 2020-11-22 | Haskell | Oklahoma | 40061 | 609 | 6 |
753857 | 753857 | 2020-11-21 | Haskell | Oklahoma | 40061 | 601 | 6 |
750611 | 750611 | 2020-11-20 | Haskell | Oklahoma | 40061 | 595 | 6 |
747365 | 747365 | 2020-11-19 | Haskell | Oklahoma | 40061 | 585 | 6 |
744119 | 744119 | 2020-11-18 | Haskell | Oklahoma | 40061 | 574 | 6 |
740872 | 740872 | 2020-11-17 | Haskell | Oklahoma | 40061 | 565 | 6 |
737626 | 737626 | 2020-11-16 | Haskell | Oklahoma | 40061 | 565 | 6 |
734382 | 734382 | 2020-11-15 | Haskell | Oklahoma | 40061 | 557 | 6 |
731136 | 731136 | 2020-11-14 | Haskell | Oklahoma | 40061 | 535 | 5 |
727892 | 727892 | 2020-11-13 | Haskell | Oklahoma | 40061 | 522 | 5 |
724648 | 724648 | 2020-11-12 | Haskell | Oklahoma | 40061 | 510 | 5 |
721405 | 721405 | 2020-11-11 | Haskell | Oklahoma | 40061 | 502 | 5 |
718162 | 718162 | 2020-11-10 | Haskell | Oklahoma | 40061 | 500 | 5 |
714919 | 714919 | 2020-11-09 | Haskell | Oklahoma | 40061 | 495 | 5 |
711675 | 711675 | 2020-11-08 | Haskell | Oklahoma | 40061 | 487 | 5 |
708431 | 708431 | 2020-11-07 | Haskell | Oklahoma | 40061 | 487 | 5 |
705188 | 705188 | 2020-11-06 | Haskell | Oklahoma | 40061 | 453 | 5 |
701945 | 701945 | 2020-11-05 | Haskell | Oklahoma | 40061 | 440 | 5 |
698701 | 698701 | 2020-11-04 | Haskell | Oklahoma | 40061 | 431 | 5 |
695458 | 695458 | 2020-11-03 | Haskell | Oklahoma | 40061 | 420 | 5 |
692216 | 692216 | 2020-11-02 | Haskell | Oklahoma | 40061 | 407 | 5 |
688972 | 688972 | 2020-11-01 | Haskell | Oklahoma | 40061 | 404 | 5 |
685727 | 685727 | 2020-10-31 | Haskell | Oklahoma | 40061 | 400 | 5 |
682484 | 682484 | 2020-10-30 | Haskell | Oklahoma | 40061 | 395 | 5 |
679241 | 679241 | 2020-10-29 | Haskell | Oklahoma | 40061 | 391 | 5 |
675998 | 675998 | 2020-10-28 | Haskell | Oklahoma | 40061 | 384 | 5 |
672755 | 672755 | 2020-10-27 | Haskell | Oklahoma | 40061 | 381 | 5 |
669513 | 669513 | 2020-10-26 | Haskell | Oklahoma | 40061 | 377 | 5 |
666269 | 666269 | 2020-10-25 | Haskell | Oklahoma | 40061 | 376 | 5 |
663024 | 663024 | 2020-10-24 | Haskell | Oklahoma | 40061 | 375 | 5 |
659780 | 659780 | 2020-10-23 | Haskell | Oklahoma | 40061 | 371 | 5 |
656536 | 656536 | 2020-10-22 | Haskell | Oklahoma | 40061 | 368 | 5 |
653291 | 653291 | 2020-10-21 | Haskell | Oklahoma | 40061 | 363 | 5 |
650046 | 650046 | 2020-10-20 | Haskell | Oklahoma | 40061 | 358 | 5 |
646802 | 646802 | 2020-10-19 | Haskell | Oklahoma | 40061 | 356 | 5 |
643556 | 643556 | 2020-10-18 | Haskell | Oklahoma | 40061 | 351 | 5 |
640308 | 640308 | 2020-10-17 | Haskell | Oklahoma | 40061 | 346 | 5 |
637062 | 637062 | 2020-10-16 | Haskell | Oklahoma | 40061 | 346 | 5 |
633816 | 633816 | 2020-10-15 | Haskell | Oklahoma | 40061 | 342 | 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);