ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Comanche" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195273 | 1195273 | 2021-04-06 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1192025 | 1192025 | 2021-04-05 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1188776 | 1188776 | 2021-04-04 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1185529 | 1185529 | 2021-04-03 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1182282 | 1182282 | 2021-04-02 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1179035 | 1179035 | 2021-04-01 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1175788 | 1175788 | 2021-03-31 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1172541 | 1172541 | 2021-03-30 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1169294 | 1169294 | 2021-03-29 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1166046 | 1166046 | 2021-03-28 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1162798 | 1162798 | 2021-03-27 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1159549 | 1159549 | 2021-03-26 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1156302 | 1156302 | 2021-03-25 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1153055 | 1153055 | 2021-03-24 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1149808 | 1149808 | 2021-03-23 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1146561 | 1146561 | 2021-03-22 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1143314 | 1143314 | 2021-03-21 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1140067 | 1140067 | 2021-03-20 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1136821 | 1136821 | 2021-03-19 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1133575 | 1133575 | 2021-03-18 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1130327 | 1130327 | 2021-03-17 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1127080 | 1127080 | 2021-03-16 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1123834 | 1123834 | 2021-03-15 | Comanche | Oklahoma | 40031 | 12535 | 145 |
1120588 | 1120588 | 2021-03-14 | Comanche | Oklahoma | 40031 | 12503 | 145 |
1117341 | 1117341 | 2021-03-13 | Comanche | Oklahoma | 40031 | 12455 | 145 |
1114094 | 1114094 | 2021-03-12 | Comanche | Oklahoma | 40031 | 12391 | 145 |
1110848 | 1110848 | 2021-03-11 | Comanche | Oklahoma | 40031 | 12355 | 145 |
1107602 | 1107602 | 2021-03-10 | Comanche | Oklahoma | 40031 | 12323 | 145 |
1104356 | 1104356 | 2021-03-09 | Comanche | Oklahoma | 40031 | 12288 | 145 |
1101110 | 1101110 | 2021-03-08 | Comanche | Oklahoma | 40031 | 12271 | 140 |
1097864 | 1097864 | 2021-03-07 | Comanche | Oklahoma | 40031 | 12244 | 140 |
1094616 | 1094616 | 2021-03-06 | Comanche | Oklahoma | 40031 | 12218 | 140 |
1091370 | 1091370 | 2021-03-05 | Comanche | Oklahoma | 40031 | 12179 | 140 |
1088124 | 1088124 | 2021-03-04 | Comanche | Oklahoma | 40031 | 12142 | 140 |
1084879 | 1084879 | 2021-03-03 | Comanche | Oklahoma | 40031 | 12091 | 140 |
1081633 | 1081633 | 2021-03-02 | Comanche | Oklahoma | 40031 | 12072 | 140 |
1078387 | 1078387 | 2021-03-01 | Comanche | Oklahoma | 40031 | 12053 | 135 |
1075142 | 1075142 | 2021-02-28 | Comanche | Oklahoma | 40031 | 11995 | 131 |
1071896 | 1071896 | 2021-02-27 | Comanche | Oklahoma | 40031 | 11986 | 131 |
1068650 | 1068650 | 2021-02-26 | Comanche | Oklahoma | 40031 | 11951 | 131 |
1065405 | 1065405 | 2021-02-25 | Comanche | Oklahoma | 40031 | 11899 | 130 |
1062161 | 1062161 | 2021-02-24 | Comanche | Oklahoma | 40031 | 11854 | 129 |
1058915 | 1058915 | 2021-02-23 | Comanche | Oklahoma | 40031 | 11802 | 128 |
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 |
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);