ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where county = "Haskell", deaths = 7 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
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);