ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 40103 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955090 | 955090 | 2021-01-22 | Noble | Oklahoma | 40103 | 1191 | 8 |
951845 | 951845 | 2021-01-21 | Noble | Oklahoma | 40103 | 1176 | 8 |
948600 | 948600 | 2021-01-20 | Noble | Oklahoma | 40103 | 1175 | 8 |
945354 | 945354 | 2021-01-19 | Noble | Oklahoma | 40103 | 1165 | 8 |
942107 | 942107 | 2021-01-18 | Noble | Oklahoma | 40103 | 1164 | 7 |
938862 | 938862 | 2021-01-17 | Noble | Oklahoma | 40103 | 1154 | 7 |
935617 | 935617 | 2021-01-16 | Noble | Oklahoma | 40103 | 1148 | 7 |
932372 | 932372 | 2021-01-15 | Noble | Oklahoma | 40103 | 1132 | 7 |
929127 | 929127 | 2021-01-14 | Noble | Oklahoma | 40103 | 1126 | 7 |
925882 | 925882 | 2021-01-13 | Noble | Oklahoma | 40103 | 1118 | 7 |
922636 | 922636 | 2021-01-12 | Noble | Oklahoma | 40103 | 1111 | 7 |
919391 | 919391 | 2021-01-11 | Noble | Oklahoma | 40103 | 1102 | 7 |
916146 | 916146 | 2021-01-10 | Noble | Oklahoma | 40103 | 1098 | 7 |
912901 | 912901 | 2021-01-09 | Noble | Oklahoma | 40103 | 1087 | 7 |
909656 | 909656 | 2021-01-08 | Noble | Oklahoma | 40103 | 1067 | 7 |
906411 | 906411 | 2021-01-07 | Noble | Oklahoma | 40103 | 1058 | 7 |
903165 | 903165 | 2021-01-06 | Noble | Oklahoma | 40103 | 1053 | 7 |
899920 | 899920 | 2021-01-05 | Noble | Oklahoma | 40103 | 1039 | 7 |
896675 | 896675 | 2021-01-04 | Noble | Oklahoma | 40103 | 1036 | 7 |
893429 | 893429 | 2021-01-03 | Noble | Oklahoma | 40103 | 1034 | 7 |
890183 | 890183 | 2021-01-02 | Noble | Oklahoma | 40103 | 1002 | 7 |
886936 | 886936 | 2021-01-01 | Noble | Oklahoma | 40103 | 984 | 7 |
883691 | 883691 | 2020-12-31 | Noble | Oklahoma | 40103 | 984 | 7 |
880446 | 880446 | 2020-12-30 | Noble | Oklahoma | 40103 | 972 | 7 |
877201 | 877201 | 2020-12-29 | Noble | Oklahoma | 40103 | 946 | 7 |
873956 | 873956 | 2020-12-28 | Noble | Oklahoma | 40103 | 946 | 7 |
870711 | 870711 | 2020-12-27 | Noble | Oklahoma | 40103 | 936 | 5 |
867466 | 867466 | 2020-12-26 | Noble | Oklahoma | 40103 | 933 | 5 |
864221 | 864221 | 2020-12-25 | Noble | Oklahoma | 40103 | 916 | 5 |
860976 | 860976 | 2020-12-24 | Noble | Oklahoma | 40103 | 916 | 5 |
857731 | 857731 | 2020-12-23 | Noble | Oklahoma | 40103 | 902 | 5 |
854486 | 854486 | 2020-12-22 | Noble | Oklahoma | 40103 | 885 | 5 |
851241 | 851241 | 2020-12-21 | Noble | Oklahoma | 40103 | 873 | 5 |
847996 | 847996 | 2020-12-20 | Noble | Oklahoma | 40103 | 863 | 5 |
844751 | 844751 | 2020-12-19 | Noble | Oklahoma | 40103 | 842 | 5 |
841505 | 841505 | 2020-12-18 | Noble | Oklahoma | 40103 | 810 | 5 |
838260 | 838260 | 2020-12-17 | Noble | Oklahoma | 40103 | 803 | 5 |
835014 | 835014 | 2020-12-16 | Noble | Oklahoma | 40103 | 784 | 5 |
831768 | 831768 | 2020-12-15 | Noble | Oklahoma | 40103 | 777 | 5 |
828521 | 828521 | 2020-12-14 | Noble | Oklahoma | 40103 | 766 | 5 |
825275 | 825275 | 2020-12-13 | Noble | Oklahoma | 40103 | 759 | 5 |
822028 | 822028 | 2020-12-12 | Noble | Oklahoma | 40103 | 741 | 4 |
818782 | 818782 | 2020-12-11 | Noble | Oklahoma | 40103 | 712 | 4 |
815536 | 815536 | 2020-12-10 | Noble | Oklahoma | 40103 | 693 | 4 |
812290 | 812290 | 2020-12-09 | Noble | Oklahoma | 40103 | 683 | 4 |
809046 | 809046 | 2020-12-08 | Noble | Oklahoma | 40103 | 663 | 4 |
805801 | 805801 | 2020-12-07 | Noble | Oklahoma | 40103 | 649 | 4 |
802556 | 802556 | 2020-12-06 | Noble | Oklahoma | 40103 | 633 | 4 |
799311 | 799311 | 2020-12-05 | Noble | Oklahoma | 40103 | 619 | 4 |
796066 | 796066 | 2020-12-04 | Noble | Oklahoma | 40103 | 590 | 4 |
792821 | 792821 | 2020-12-03 | Noble | Oklahoma | 40103 | 574 | 4 |
789576 | 789576 | 2020-12-02 | Noble | Oklahoma | 40103 | 563 | 4 |
786331 | 786331 | 2020-12-01 | Noble | Oklahoma | 40103 | 554 | 4 |
783087 | 783087 | 2020-11-30 | Noble | Oklahoma | 40103 | 551 | 4 |
779841 | 779841 | 2020-11-29 | Noble | Oklahoma | 40103 | 548 | 4 |
776596 | 776596 | 2020-11-28 | Noble | Oklahoma | 40103 | 547 | 4 |
773351 | 773351 | 2020-11-27 | Noble | Oklahoma | 40103 | 493 | 4 |
770106 | 770106 | 2020-11-26 | Noble | Oklahoma | 40103 | 488 | 4 |
766860 | 766860 | 2020-11-25 | Noble | Oklahoma | 40103 | 488 | 4 |
763615 | 763615 | 2020-11-24 | Noble | Oklahoma | 40103 | 472 | 4 |
760370 | 760370 | 2020-11-23 | Noble | Oklahoma | 40103 | 446 | 4 |
757125 | 757125 | 2020-11-22 | Noble | Oklahoma | 40103 | 382 | 4 |
753878 | 753878 | 2020-11-21 | Noble | Oklahoma | 40103 | 364 | 4 |
750632 | 750632 | 2020-11-20 | Noble | Oklahoma | 40103 | 350 | 4 |
747386 | 747386 | 2020-11-19 | Noble | Oklahoma | 40103 | 345 | 4 |
744140 | 744140 | 2020-11-18 | Noble | Oklahoma | 40103 | 342 | 4 |
740893 | 740893 | 2020-11-17 | Noble | Oklahoma | 40103 | 337 | 3 |
737647 | 737647 | 2020-11-16 | Noble | Oklahoma | 40103 | 337 | 3 |
734403 | 734403 | 2020-11-15 | Noble | Oklahoma | 40103 | 326 | 3 |
731157 | 731157 | 2020-11-14 | Noble | Oklahoma | 40103 | 306 | 3 |
727913 | 727913 | 2020-11-13 | Noble | Oklahoma | 40103 | 302 | 3 |
724669 | 724669 | 2020-11-12 | Noble | Oklahoma | 40103 | 284 | 3 |
721426 | 721426 | 2020-11-11 | Noble | Oklahoma | 40103 | 276 | 3 |
718183 | 718183 | 2020-11-10 | Noble | Oklahoma | 40103 | 268 | 3 |
714940 | 714940 | 2020-11-09 | Noble | Oklahoma | 40103 | 262 | 3 |
711696 | 711696 | 2020-11-08 | Noble | Oklahoma | 40103 | 258 | 3 |
708452 | 708452 | 2020-11-07 | Noble | Oklahoma | 40103 | 258 | 3 |
705209 | 705209 | 2020-11-06 | Noble | Oklahoma | 40103 | 239 | 3 |
701966 | 701966 | 2020-11-05 | Noble | Oklahoma | 40103 | 230 | 3 |
698722 | 698722 | 2020-11-04 | Noble | Oklahoma | 40103 | 228 | 3 |
695479 | 695479 | 2020-11-03 | Noble | Oklahoma | 40103 | 213 | 3 |
692237 | 692237 | 2020-11-02 | Noble | Oklahoma | 40103 | 206 | 3 |
688993 | 688993 | 2020-11-01 | Noble | Oklahoma | 40103 | 205 | 3 |
685748 | 685748 | 2020-10-31 | Noble | Oklahoma | 40103 | 199 | 3 |
682505 | 682505 | 2020-10-30 | Noble | Oklahoma | 40103 | 190 | 3 |
679262 | 679262 | 2020-10-29 | Noble | Oklahoma | 40103 | 183 | 3 |
676019 | 676019 | 2020-10-28 | Noble | Oklahoma | 40103 | 183 | 3 |
672776 | 672776 | 2020-10-27 | Noble | Oklahoma | 40103 | 179 | 3 |
669534 | 669534 | 2020-10-26 | Noble | Oklahoma | 40103 | 175 | 3 |
666290 | 666290 | 2020-10-25 | Noble | Oklahoma | 40103 | 175 | 3 |
663045 | 663045 | 2020-10-24 | Noble | Oklahoma | 40103 | 175 | 3 |
659801 | 659801 | 2020-10-23 | Noble | Oklahoma | 40103 | 173 | 3 |
656557 | 656557 | 2020-10-22 | Noble | Oklahoma | 40103 | 172 | 3 |
653312 | 653312 | 2020-10-21 | Noble | Oklahoma | 40103 | 171 | 3 |
650067 | 650067 | 2020-10-20 | Noble | Oklahoma | 40103 | 170 | 3 |
646823 | 646823 | 2020-10-19 | Noble | Oklahoma | 40103 | 170 | 3 |
643577 | 643577 | 2020-10-18 | Noble | Oklahoma | 40103 | 170 | 3 |
640329 | 640329 | 2020-10-17 | Noble | Oklahoma | 40103 | 170 | 3 |
637083 | 637083 | 2020-10-16 | Noble | Oklahoma | 40103 | 169 | 3 |
633837 | 633837 | 2020-10-15 | Noble | Oklahoma | 40103 | 167 | 3 |
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);