ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 40031 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055669 | 1055669 | 2021-02-22 | Comanche | Oklahoma | 40031 | 11783 | 128 |
1052423 | 1052423 | 2021-02-21 | Comanche | Oklahoma | 40031 | 11769 | 127 |
1049176 | 1049176 | 2021-02-20 | Comanche | Oklahoma | 40031 | 11726 | 127 |
1045929 | 1045929 | 2021-02-19 | Comanche | Oklahoma | 40031 | 11654 | 127 |
1042684 | 1042684 | 2021-02-18 | Comanche | Oklahoma | 40031 | 11599 | 126 |
1039439 | 1039439 | 2021-02-17 | Comanche | Oklahoma | 40031 | 11570 | 125 |
1036194 | 1036194 | 2021-02-16 | Comanche | Oklahoma | 40031 | 11499 | 124 |
1032949 | 1032949 | 2021-02-15 | Comanche | Oklahoma | 40031 | 11479 | 124 |
1029703 | 1029703 | 2021-02-14 | Comanche | Oklahoma | 40031 | 11443 | 124 |
1026456 | 1026456 | 2021-02-13 | Comanche | Oklahoma | 40031 | 11411 | 123 |
1023211 | 1023211 | 2021-02-12 | Comanche | Oklahoma | 40031 | 11366 | 123 |
1019966 | 1019966 | 2021-02-11 | Comanche | Oklahoma | 40031 | 11317 | 123 |
1016721 | 1016721 | 2021-02-10 | Comanche | Oklahoma | 40031 | 11172 | 122 |
1013476 | 1013476 | 2021-02-09 | Comanche | Oklahoma | 40031 | 11105 | 121 |
1010231 | 1010231 | 2021-02-08 | Comanche | Oklahoma | 40031 | 11042 | 120 |
1006985 | 1006985 | 2021-02-07 | Comanche | Oklahoma | 40031 | 11025 | 120 |
1003739 | 1003739 | 2021-02-06 | Comanche | Oklahoma | 40031 | 10951 | 117 |
1000493 | 1000493 | 2021-02-05 | Comanche | Oklahoma | 40031 | 10884 | 115 |
997247 | 997247 | 2021-02-04 | Comanche | Oklahoma | 40031 | 10742 | 115 |
994001 | 994001 | 2021-02-03 | Comanche | Oklahoma | 40031 | 10568 | 111 |
990755 | 990755 | 2021-02-02 | Comanche | Oklahoma | 40031 | 10401 | 109 |
987509 | 987509 | 2021-02-01 | Comanche | Oklahoma | 40031 | 10334 | 106 |
984262 | 984262 | 2021-01-31 | Comanche | Oklahoma | 40031 | 10251 | 106 |
981015 | 981015 | 2021-01-30 | Comanche | Oklahoma | 40031 | 10085 | 105 |
977769 | 977769 | 2021-01-29 | Comanche | Oklahoma | 40031 | 10023 | 104 |
974524 | 974524 | 2021-01-28 | Comanche | Oklahoma | 40031 | 9892 | 104 |
971279 | 971279 | 2021-01-27 | Comanche | Oklahoma | 40031 | 9791 | 104 |
968034 | 968034 | 2021-01-26 | Comanche | Oklahoma | 40031 | 9627 | 100 |
964790 | 964790 | 2021-01-25 | Comanche | Oklahoma | 40031 | 9470 | 100 |
961545 | 961545 | 2021-01-24 | Comanche | Oklahoma | 40031 | 9431 | 99 |
958300 | 958300 | 2021-01-23 | Comanche | Oklahoma | 40031 | 9322 | 96 |
955054 | 955054 | 2021-01-22 | Comanche | Oklahoma | 40031 | 9099 | 95 |
951809 | 951809 | 2021-01-21 | Comanche | Oklahoma | 40031 | 8980 | 95 |
948564 | 948564 | 2021-01-20 | Comanche | Oklahoma | 40031 | 8907 | 92 |
945318 | 945318 | 2021-01-19 | Comanche | Oklahoma | 40031 | 8863 | 89 |
942071 | 942071 | 2021-01-18 | Comanche | Oklahoma | 40031 | 8828 | 87 |
938826 | 938826 | 2021-01-17 | Comanche | Oklahoma | 40031 | 8784 | 87 |
935581 | 935581 | 2021-01-16 | Comanche | Oklahoma | 40031 | 8678 | 85 |
932336 | 932336 | 2021-01-15 | Comanche | Oklahoma | 40031 | 8556 | 85 |
929091 | 929091 | 2021-01-14 | Comanche | Oklahoma | 40031 | 8438 | 84 |
925846 | 925846 | 2021-01-13 | Comanche | Oklahoma | 40031 | 8356 | 81 |
922600 | 922600 | 2021-01-12 | Comanche | Oklahoma | 40031 | 8145 | 79 |
919355 | 919355 | 2021-01-11 | Comanche | Oklahoma | 40031 | 8084 | 78 |
916110 | 916110 | 2021-01-10 | Comanche | Oklahoma | 40031 | 7981 | 78 |
912865 | 912865 | 2021-01-09 | Comanche | Oklahoma | 40031 | 7728 | 77 |
909620 | 909620 | 2021-01-08 | Comanche | Oklahoma | 40031 | 7620 | 74 |
906375 | 906375 | 2021-01-07 | Comanche | Oklahoma | 40031 | 7539 | 70 |
903129 | 903129 | 2021-01-06 | Comanche | Oklahoma | 40031 | 7431 | 70 |
899884 | 899884 | 2021-01-05 | Comanche | Oklahoma | 40031 | 7326 | 63 |
896639 | 896639 | 2021-01-04 | Comanche | Oklahoma | 40031 | 7299 | 62 |
893393 | 893393 | 2021-01-03 | Comanche | Oklahoma | 40031 | 7269 | 62 |
890147 | 890147 | 2021-01-02 | Comanche | Oklahoma | 40031 | 7126 | 60 |
886900 | 886900 | 2021-01-01 | Comanche | Oklahoma | 40031 | 6994 | 60 |
883655 | 883655 | 2020-12-31 | Comanche | Oklahoma | 40031 | 6994 | 60 |
880410 | 880410 | 2020-12-30 | Comanche | Oklahoma | 40031 | 6857 | 58 |
877165 | 877165 | 2020-12-29 | Comanche | Oklahoma | 40031 | 6771 | 56 |
873920 | 873920 | 2020-12-28 | Comanche | Oklahoma | 40031 | 6752 | 56 |
870675 | 870675 | 2020-12-27 | Comanche | Oklahoma | 40031 | 6694 | 55 |
867430 | 867430 | 2020-12-26 | Comanche | Oklahoma | 40031 | 6654 | 55 |
864185 | 864185 | 2020-12-25 | Comanche | Oklahoma | 40031 | 6559 | 55 |
860940 | 860940 | 2020-12-24 | Comanche | Oklahoma | 40031 | 6559 | 55 |
857695 | 857695 | 2020-12-23 | Comanche | Oklahoma | 40031 | 6517 | 54 |
854450 | 854450 | 2020-12-22 | Comanche | Oklahoma | 40031 | 6372 | 50 |
851205 | 851205 | 2020-12-21 | Comanche | Oklahoma | 40031 | 6335 | 50 |
847960 | 847960 | 2020-12-20 | Comanche | Oklahoma | 40031 | 6302 | 50 |
844715 | 844715 | 2020-12-19 | Comanche | Oklahoma | 40031 | 6172 | 50 |
841469 | 841469 | 2020-12-18 | Comanche | Oklahoma | 40031 | 6118 | 50 |
838224 | 838224 | 2020-12-17 | Comanche | Oklahoma | 40031 | 6030 | 50 |
834978 | 834978 | 2020-12-16 | Comanche | Oklahoma | 40031 | 5970 | 50 |
831732 | 831732 | 2020-12-15 | Comanche | Oklahoma | 40031 | 5829 | 46 |
828485 | 828485 | 2020-12-14 | Comanche | Oklahoma | 40031 | 5804 | 46 |
825239 | 825239 | 2020-12-13 | Comanche | Oklahoma | 40031 | 5785 | 46 |
821992 | 821992 | 2020-12-12 | Comanche | Oklahoma | 40031 | 5620 | 45 |
818746 | 818746 | 2020-12-11 | Comanche | Oklahoma | 40031 | 5565 | 43 |
815500 | 815500 | 2020-12-10 | Comanche | Oklahoma | 40031 | 5490 | 42 |
812254 | 812254 | 2020-12-09 | Comanche | Oklahoma | 40031 | 5443 | 41 |
809010 | 809010 | 2020-12-08 | Comanche | Oklahoma | 40031 | 5408 | 39 |
805765 | 805765 | 2020-12-07 | Comanche | Oklahoma | 40031 | 5377 | 39 |
802520 | 802520 | 2020-12-06 | Comanche | Oklahoma | 40031 | 5322 | 38 |
799275 | 799275 | 2020-12-05 | Comanche | Oklahoma | 40031 | 5255 | 37 |
796030 | 796030 | 2020-12-04 | Comanche | Oklahoma | 40031 | 5171 | 35 |
792785 | 792785 | 2020-12-03 | Comanche | Oklahoma | 40031 | 5043 | 35 |
789540 | 789540 | 2020-12-02 | Comanche | Oklahoma | 40031 | 4989 | 34 |
786295 | 786295 | 2020-12-01 | Comanche | Oklahoma | 40031 | 4921 | 33 |
783051 | 783051 | 2020-11-30 | Comanche | Oklahoma | 40031 | 4877 | 33 |
779805 | 779805 | 2020-11-29 | Comanche | Oklahoma | 40031 | 4788 | 33 |
776560 | 776560 | 2020-11-28 | Comanche | Oklahoma | 40031 | 4742 | 33 |
773315 | 773315 | 2020-11-27 | Comanche | Oklahoma | 40031 | 4553 | 33 |
770070 | 770070 | 2020-11-26 | Comanche | Oklahoma | 40031 | 4439 | 32 |
766824 | 766824 | 2020-11-25 | Comanche | Oklahoma | 40031 | 4439 | 32 |
763579 | 763579 | 2020-11-24 | Comanche | Oklahoma | 40031 | 4313 | 31 |
760334 | 760334 | 2020-11-23 | Comanche | Oklahoma | 40031 | 4218 | 30 |
757089 | 757089 | 2020-11-22 | Comanche | Oklahoma | 40031 | 4086 | 30 |
753842 | 753842 | 2020-11-21 | Comanche | Oklahoma | 40031 | 3988 | 29 |
750596 | 750596 | 2020-11-20 | Comanche | Oklahoma | 40031 | 3901 | 28 |
747350 | 747350 | 2020-11-19 | Comanche | Oklahoma | 40031 | 3819 | 28 |
744104 | 744104 | 2020-11-18 | Comanche | Oklahoma | 40031 | 3733 | 27 |
740857 | 740857 | 2020-11-17 | Comanche | Oklahoma | 40031 | 3616 | 27 |
737611 | 737611 | 2020-11-16 | Comanche | Oklahoma | 40031 | 3574 | 27 |
734367 | 734367 | 2020-11-15 | Comanche | Oklahoma | 40031 | 3503 | 26 |
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);