ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 40049 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955063 | 955063 | 2021-01-22 | Garvin | Oklahoma | 40049 | 3027 | 24 |
951818 | 951818 | 2021-01-21 | Garvin | Oklahoma | 40049 | 2999 | 24 |
948573 | 948573 | 2021-01-20 | Garvin | Oklahoma | 40049 | 2978 | 23 |
945327 | 945327 | 2021-01-19 | Garvin | Oklahoma | 40049 | 2968 | 23 |
942080 | 942080 | 2021-01-18 | Garvin | Oklahoma | 40049 | 2960 | 23 |
938835 | 938835 | 2021-01-17 | Garvin | Oklahoma | 40049 | 2936 | 23 |
935590 | 935590 | 2021-01-16 | Garvin | Oklahoma | 40049 | 2918 | 23 |
932345 | 932345 | 2021-01-15 | Garvin | Oklahoma | 40049 | 2867 | 23 |
929100 | 929100 | 2021-01-14 | Garvin | Oklahoma | 40049 | 2830 | 22 |
925855 | 925855 | 2021-01-13 | Garvin | Oklahoma | 40049 | 2805 | 22 |
922609 | 922609 | 2021-01-12 | Garvin | Oklahoma | 40049 | 2782 | 22 |
919364 | 919364 | 2021-01-11 | Garvin | Oklahoma | 40049 | 2764 | 20 |
916119 | 916119 | 2021-01-10 | Garvin | Oklahoma | 40049 | 2735 | 20 |
912874 | 912874 | 2021-01-09 | Garvin | Oklahoma | 40049 | 2684 | 20 |
909629 | 909629 | 2021-01-08 | Garvin | Oklahoma | 40049 | 2653 | 20 |
906384 | 906384 | 2021-01-07 | Garvin | Oklahoma | 40049 | 2540 | 20 |
903138 | 903138 | 2021-01-06 | Garvin | Oklahoma | 40049 | 2484 | 20 |
899893 | 899893 | 2021-01-05 | Garvin | Oklahoma | 40049 | 2457 | 20 |
896648 | 896648 | 2021-01-04 | Garvin | Oklahoma | 40049 | 2450 | 20 |
893402 | 893402 | 2021-01-03 | Garvin | Oklahoma | 40049 | 2430 | 19 |
890156 | 890156 | 2021-01-02 | Garvin | Oklahoma | 40049 | 2344 | 18 |
886909 | 886909 | 2021-01-01 | Garvin | Oklahoma | 40049 | 2306 | 18 |
883664 | 883664 | 2020-12-31 | Garvin | Oklahoma | 40049 | 2306 | 18 |
880419 | 880419 | 2020-12-30 | Garvin | Oklahoma | 40049 | 2279 | 18 |
877174 | 877174 | 2020-12-29 | Garvin | Oklahoma | 40049 | 2243 | 18 |
873929 | 873929 | 2020-12-28 | Garvin | Oklahoma | 40049 | 2230 | 18 |
870684 | 870684 | 2020-12-27 | Garvin | Oklahoma | 40049 | 2215 | 18 |
867439 | 867439 | 2020-12-26 | Garvin | Oklahoma | 40049 | 2188 | 18 |
864194 | 864194 | 2020-12-25 | Garvin | Oklahoma | 40049 | 2146 | 18 |
860949 | 860949 | 2020-12-24 | Garvin | Oklahoma | 40049 | 2146 | 18 |
857704 | 857704 | 2020-12-23 | Garvin | Oklahoma | 40049 | 2100 | 18 |
854459 | 854459 | 2020-12-22 | Garvin | Oklahoma | 40049 | 2062 | 18 |
851214 | 851214 | 2020-12-21 | Garvin | Oklahoma | 40049 | 2047 | 18 |
847969 | 847969 | 2020-12-20 | Garvin | Oklahoma | 40049 | 2026 | 18 |
844724 | 844724 | 2020-12-19 | Garvin | Oklahoma | 40049 | 1997 | 18 |
841478 | 841478 | 2020-12-18 | Garvin | Oklahoma | 40049 | 1949 | 18 |
838233 | 838233 | 2020-12-17 | Garvin | Oklahoma | 40049 | 1928 | 18 |
834987 | 834987 | 2020-12-16 | Garvin | Oklahoma | 40049 | 1896 | 18 |
831741 | 831741 | 2020-12-15 | Garvin | Oklahoma | 40049 | 1860 | 18 |
828494 | 828494 | 2020-12-14 | Garvin | Oklahoma | 40049 | 1849 | 18 |
825248 | 825248 | 2020-12-13 | Garvin | Oklahoma | 40049 | 1833 | 18 |
822001 | 822001 | 2020-12-12 | Garvin | Oklahoma | 40049 | 1804 | 18 |
818755 | 818755 | 2020-12-11 | Garvin | Oklahoma | 40049 | 1787 | 18 |
815509 | 815509 | 2020-12-10 | Garvin | Oklahoma | 40049 | 1767 | 18 |
812263 | 812263 | 2020-12-09 | Garvin | Oklahoma | 40049 | 1756 | 18 |
809019 | 809019 | 2020-12-08 | Garvin | Oklahoma | 40049 | 1740 | 18 |
805774 | 805774 | 2020-12-07 | Garvin | Oklahoma | 40049 | 1730 | 18 |
802529 | 802529 | 2020-12-06 | Garvin | Oklahoma | 40049 | 1711 | 18 |
799284 | 799284 | 2020-12-05 | Garvin | Oklahoma | 40049 | 1695 | 17 |
796039 | 796039 | 2020-12-04 | Garvin | Oklahoma | 40049 | 1671 | 17 |
792794 | 792794 | 2020-12-03 | Garvin | Oklahoma | 40049 | 1644 | 16 |
789549 | 789549 | 2020-12-02 | Garvin | Oklahoma | 40049 | 1636 | 16 |
786304 | 786304 | 2020-12-01 | Garvin | Oklahoma | 40049 | 1619 | 16 |
783060 | 783060 | 2020-11-30 | Garvin | Oklahoma | 40049 | 1610 | 15 |
779814 | 779814 | 2020-11-29 | Garvin | Oklahoma | 40049 | 1595 | 15 |
776569 | 776569 | 2020-11-28 | Garvin | Oklahoma | 40049 | 1578 | 15 |
773324 | 773324 | 2020-11-27 | Garvin | Oklahoma | 40049 | 1529 | 12 |
770079 | 770079 | 2020-11-26 | Garvin | Oklahoma | 40049 | 1511 | 12 |
766833 | 766833 | 2020-11-25 | Garvin | Oklahoma | 40049 | 1511 | 12 |
763588 | 763588 | 2020-11-24 | Garvin | Oklahoma | 40049 | 1477 | 12 |
760343 | 760343 | 2020-11-23 | Garvin | Oklahoma | 40049 | 1431 | 12 |
757098 | 757098 | 2020-11-22 | Garvin | Oklahoma | 40049 | 1416 | 11 |
753851 | 753851 | 2020-11-21 | Garvin | Oklahoma | 40049 | 1384 | 11 |
750605 | 750605 | 2020-11-20 | Garvin | Oklahoma | 40049 | 1348 | 11 |
747359 | 747359 | 2020-11-19 | Garvin | Oklahoma | 40049 | 1325 | 10 |
744113 | 744113 | 2020-11-18 | Garvin | Oklahoma | 40049 | 1291 | 10 |
740866 | 740866 | 2020-11-17 | Garvin | Oklahoma | 40049 | 1256 | 9 |
737620 | 737620 | 2020-11-16 | Garvin | Oklahoma | 40049 | 1224 | 8 |
734376 | 734376 | 2020-11-15 | Garvin | Oklahoma | 40049 | 1198 | 8 |
731130 | 731130 | 2020-11-14 | Garvin | Oklahoma | 40049 | 1154 | 8 |
727886 | 727886 | 2020-11-13 | Garvin | Oklahoma | 40049 | 1112 | 8 |
724642 | 724642 | 2020-11-12 | Garvin | Oklahoma | 40049 | 1070 | 8 |
721399 | 721399 | 2020-11-11 | Garvin | Oklahoma | 40049 | 1031 | 8 |
718156 | 718156 | 2020-11-10 | Garvin | Oklahoma | 40049 | 997 | 8 |
714913 | 714913 | 2020-11-09 | Garvin | Oklahoma | 40049 | 990 | 8 |
711669 | 711669 | 2020-11-08 | Garvin | Oklahoma | 40049 | 966 | 8 |
708425 | 708425 | 2020-11-07 | Garvin | Oklahoma | 40049 | 966 | 8 |
705182 | 705182 | 2020-11-06 | Garvin | Oklahoma | 40049 | 898 | 8 |
701939 | 701939 | 2020-11-05 | Garvin | Oklahoma | 40049 | 863 | 8 |
698695 | 698695 | 2020-11-04 | Garvin | Oklahoma | 40049 | 818 | 8 |
695452 | 695452 | 2020-11-03 | Garvin | Oklahoma | 40049 | 806 | 8 |
692210 | 692210 | 2020-11-02 | Garvin | Oklahoma | 40049 | 791 | 6 |
688966 | 688966 | 2020-11-01 | Garvin | Oklahoma | 40049 | 774 | 6 |
685721 | 685721 | 2020-10-31 | Garvin | Oklahoma | 40049 | 752 | 6 |
682478 | 682478 | 2020-10-30 | Garvin | Oklahoma | 40049 | 721 | 6 |
679235 | 679235 | 2020-10-29 | Garvin | Oklahoma | 40049 | 699 | 6 |
675992 | 675992 | 2020-10-28 | Garvin | Oklahoma | 40049 | 689 | 6 |
672749 | 672749 | 2020-10-27 | Garvin | Oklahoma | 40049 | 679 | 6 |
669507 | 669507 | 2020-10-26 | Garvin | Oklahoma | 40049 | 661 | 6 |
666263 | 666263 | 2020-10-25 | Garvin | Oklahoma | 40049 | 653 | 6 |
663018 | 663018 | 2020-10-24 | Garvin | Oklahoma | 40049 | 632 | 6 |
659774 | 659774 | 2020-10-23 | Garvin | Oklahoma | 40049 | 613 | 6 |
656530 | 656530 | 2020-10-22 | Garvin | Oklahoma | 40049 | 606 | 6 |
653285 | 653285 | 2020-10-21 | Garvin | Oklahoma | 40049 | 597 | 6 |
650040 | 650040 | 2020-10-20 | Garvin | Oklahoma | 40049 | 588 | 6 |
646796 | 646796 | 2020-10-19 | Garvin | Oklahoma | 40049 | 574 | 6 |
643550 | 643550 | 2020-10-18 | Garvin | Oklahoma | 40049 | 569 | 6 |
640302 | 640302 | 2020-10-17 | Garvin | Oklahoma | 40049 | 561 | 6 |
637056 | 637056 | 2020-10-16 | Garvin | Oklahoma | 40049 | 558 | 6 |
633810 | 633810 | 2020-10-15 | Garvin | Oklahoma | 40049 | 547 | 6 |
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);