ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40001 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955039 | 955039 | 2021-01-22 | Adair | Oklahoma | 40001 | 2609 | 18 |
951794 | 951794 | 2021-01-21 | Adair | Oklahoma | 40001 | 2594 | 18 |
948549 | 948549 | 2021-01-20 | Adair | Oklahoma | 40001 | 2554 | 17 |
945303 | 945303 | 2021-01-19 | Adair | Oklahoma | 40001 | 2544 | 17 |
942056 | 942056 | 2021-01-18 | Adair | Oklahoma | 40001 | 2533 | 17 |
938811 | 938811 | 2021-01-17 | Adair | Oklahoma | 40001 | 2520 | 17 |
935566 | 935566 | 2021-01-16 | Adair | Oklahoma | 40001 | 2500 | 17 |
932321 | 932321 | 2021-01-15 | Adair | Oklahoma | 40001 | 2480 | 15 |
929076 | 929076 | 2021-01-14 | Adair | Oklahoma | 40001 | 2454 | 15 |
925831 | 925831 | 2021-01-13 | Adair | Oklahoma | 40001 | 2370 | 15 |
922585 | 922585 | 2021-01-12 | Adair | Oklahoma | 40001 | 2325 | 15 |
919340 | 919340 | 2021-01-11 | Adair | Oklahoma | 40001 | 2273 | 15 |
916095 | 916095 | 2021-01-10 | Adair | Oklahoma | 40001 | 2235 | 15 |
912850 | 912850 | 2021-01-09 | Adair | Oklahoma | 40001 | 2191 | 15 |
909605 | 909605 | 2021-01-08 | Adair | Oklahoma | 40001 | 2149 | 14 |
906360 | 906360 | 2021-01-07 | Adair | Oklahoma | 40001 | 2093 | 14 |
903114 | 903114 | 2021-01-06 | Adair | Oklahoma | 40001 | 2045 | 14 |
899869 | 899869 | 2021-01-05 | Adair | Oklahoma | 40001 | 2012 | 14 |
896624 | 896624 | 2021-01-04 | Adair | Oklahoma | 40001 | 1988 | 14 |
893378 | 893378 | 2021-01-03 | Adair | Oklahoma | 40001 | 1962 | 14 |
890132 | 890132 | 2021-01-02 | Adair | Oklahoma | 40001 | 1901 | 14 |
886885 | 886885 | 2021-01-01 | Adair | Oklahoma | 40001 | 1870 | 14 |
883640 | 883640 | 2020-12-31 | Adair | Oklahoma | 40001 | 1870 | 14 |
880395 | 880395 | 2020-12-30 | Adair | Oklahoma | 40001 | 1820 | 14 |
877150 | 877150 | 2020-12-29 | Adair | Oklahoma | 40001 | 1786 | 14 |
873905 | 873905 | 2020-12-28 | Adair | Oklahoma | 40001 | 1778 | 14 |
870660 | 870660 | 2020-12-27 | Adair | Oklahoma | 40001 | 1761 | 13 |
867415 | 867415 | 2020-12-26 | Adair | Oklahoma | 40001 | 1760 | 13 |
864170 | 864170 | 2020-12-25 | Adair | Oklahoma | 40001 | 1747 | 13 |
860925 | 860925 | 2020-12-24 | Adair | Oklahoma | 40001 | 1747 | 13 |
857680 | 857680 | 2020-12-23 | Adair | Oklahoma | 40001 | 1729 | 13 |
854435 | 854435 | 2020-12-22 | Adair | Oklahoma | 40001 | 1713 | 13 |
851190 | 851190 | 2020-12-21 | Adair | Oklahoma | 40001 | 1694 | 13 |
847945 | 847945 | 2020-12-20 | Adair | Oklahoma | 40001 | 1663 | 13 |
844700 | 844700 | 2020-12-19 | Adair | Oklahoma | 40001 | 1623 | 13 |
841454 | 841454 | 2020-12-18 | Adair | Oklahoma | 40001 | 1586 | 13 |
838209 | 838209 | 2020-12-17 | Adair | Oklahoma | 40001 | 1560 | 13 |
834963 | 834963 | 2020-12-16 | Adair | Oklahoma | 40001 | 1540 | 13 |
831717 | 831717 | 2020-12-15 | Adair | Oklahoma | 40001 | 1515 | 13 |
828470 | 828470 | 2020-12-14 | Adair | Oklahoma | 40001 | 1493 | 13 |
825224 | 825224 | 2020-12-13 | Adair | Oklahoma | 40001 | 1482 | 13 |
821977 | 821977 | 2020-12-12 | Adair | Oklahoma | 40001 | 1465 | 13 |
818731 | 818731 | 2020-12-11 | Adair | Oklahoma | 40001 | 1438 | 13 |
815485 | 815485 | 2020-12-10 | Adair | Oklahoma | 40001 | 1394 | 13 |
812239 | 812239 | 2020-12-09 | Adair | Oklahoma | 40001 | 1379 | 13 |
808995 | 808995 | 2020-12-08 | Adair | Oklahoma | 40001 | 1357 | 13 |
805750 | 805750 | 2020-12-07 | Adair | Oklahoma | 40001 | 1355 | 13 |
802505 | 802505 | 2020-12-06 | Adair | Oklahoma | 40001 | 1343 | 13 |
799260 | 799260 | 2020-12-05 | Adair | Oklahoma | 40001 | 1321 | 13 |
796015 | 796015 | 2020-12-04 | Adair | Oklahoma | 40001 | 1294 | 13 |
792770 | 792770 | 2020-12-03 | Adair | Oklahoma | 40001 | 1272 | 13 |
789525 | 789525 | 2020-12-02 | Adair | Oklahoma | 40001 | 1251 | 13 |
786280 | 786280 | 2020-12-01 | Adair | Oklahoma | 40001 | 1241 | 13 |
783036 | 783036 | 2020-11-30 | Adair | Oklahoma | 40001 | 1239 | 13 |
779790 | 779790 | 2020-11-29 | Adair | Oklahoma | 40001 | 1221 | 13 |
776545 | 776545 | 2020-11-28 | Adair | Oklahoma | 40001 | 1218 | 13 |
773300 | 773300 | 2020-11-27 | Adair | Oklahoma | 40001 | 1179 | 13 |
770055 | 770055 | 2020-11-26 | Adair | Oklahoma | 40001 | 1149 | 13 |
766809 | 766809 | 2020-11-25 | Adair | Oklahoma | 40001 | 1149 | 13 |
763564 | 763564 | 2020-11-24 | Adair | Oklahoma | 40001 | 1144 | 13 |
760319 | 760319 | 2020-11-23 | Adair | Oklahoma | 40001 | 1142 | 13 |
757074 | 757074 | 2020-11-22 | Adair | Oklahoma | 40001 | 1135 | 13 |
753827 | 753827 | 2020-11-21 | Adair | Oklahoma | 40001 | 1129 | 13 |
750581 | 750581 | 2020-11-20 | Adair | Oklahoma | 40001 | 1115 | 13 |
747335 | 747335 | 2020-11-19 | Adair | Oklahoma | 40001 | 1093 | 13 |
744089 | 744089 | 2020-11-18 | Adair | Oklahoma | 40001 | 1076 | 13 |
740842 | 740842 | 2020-11-17 | Adair | Oklahoma | 40001 | 1070 | 13 |
737596 | 737596 | 2020-11-16 | Adair | Oklahoma | 40001 | 1067 | 13 |
734352 | 734352 | 2020-11-15 | Adair | Oklahoma | 40001 | 1059 | 13 |
731106 | 731106 | 2020-11-14 | Adair | Oklahoma | 40001 | 1038 | 13 |
727862 | 727862 | 2020-11-13 | Adair | Oklahoma | 40001 | 1024 | 13 |
724618 | 724618 | 2020-11-12 | Adair | Oklahoma | 40001 | 1018 | 13 |
721375 | 721375 | 2020-11-11 | Adair | Oklahoma | 40001 | 981 | 13 |
718132 | 718132 | 2020-11-10 | Adair | Oklahoma | 40001 | 976 | 13 |
714889 | 714889 | 2020-11-09 | Adair | Oklahoma | 40001 | 971 | 13 |
711645 | 711645 | 2020-11-08 | Adair | Oklahoma | 40001 | 952 | 13 |
708401 | 708401 | 2020-11-07 | Adair | Oklahoma | 40001 | 952 | 13 |
705158 | 705158 | 2020-11-06 | Adair | Oklahoma | 40001 | 934 | 13 |
701915 | 701915 | 2020-11-05 | Adair | Oklahoma | 40001 | 912 | 12 |
698671 | 698671 | 2020-11-04 | Adair | Oklahoma | 40001 | 889 | 12 |
695428 | 695428 | 2020-11-03 | Adair | Oklahoma | 40001 | 873 | 12 |
692186 | 692186 | 2020-11-02 | Adair | Oklahoma | 40001 | 859 | 12 |
688942 | 688942 | 2020-11-01 | Adair | Oklahoma | 40001 | 855 | 11 |
685697 | 685697 | 2020-10-31 | Adair | Oklahoma | 40001 | 850 | 11 |
682454 | 682454 | 2020-10-30 | Adair | Oklahoma | 40001 | 832 | 11 |
679211 | 679211 | 2020-10-29 | Adair | Oklahoma | 40001 | 819 | 11 |
675968 | 675968 | 2020-10-28 | Adair | Oklahoma | 40001 | 815 | 11 |
672725 | 672725 | 2020-10-27 | Adair | Oklahoma | 40001 | 801 | 11 |
669483 | 669483 | 2020-10-26 | Adair | Oklahoma | 40001 | 795 | 11 |
666239 | 666239 | 2020-10-25 | Adair | Oklahoma | 40001 | 788 | 11 |
662994 | 662994 | 2020-10-24 | Adair | Oklahoma | 40001 | 783 | 11 |
659750 | 659750 | 2020-10-23 | Adair | Oklahoma | 40001 | 769 | 11 |
656506 | 656506 | 2020-10-22 | Adair | Oklahoma | 40001 | 752 | 11 |
653261 | 653261 | 2020-10-21 | Adair | Oklahoma | 40001 | 740 | 11 |
650016 | 650016 | 2020-10-20 | Adair | Oklahoma | 40001 | 734 | 11 |
646772 | 646772 | 2020-10-19 | Adair | Oklahoma | 40001 | 722 | 11 |
643526 | 643526 | 2020-10-18 | Adair | Oklahoma | 40001 | 717 | 11 |
640278 | 640278 | 2020-10-17 | Adair | Oklahoma | 40001 | 719 | 11 |
637032 | 637032 | 2020-10-16 | Adair | Oklahoma | 40001 | 719 | 11 |
633786 | 633786 | 2020-10-15 | Adair | Oklahoma | 40001 | 715 | 11 |
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);