ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Cleveland" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195271 | 1195271 | 2021-04-06 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1192023 | 1192023 | 2021-04-05 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1188774 | 1188774 | 2021-04-04 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1185527 | 1185527 | 2021-04-03 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1182280 | 1182280 | 2021-04-02 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1179033 | 1179033 | 2021-04-01 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1175786 | 1175786 | 2021-03-31 | Cleveland | Oklahoma | 40027 | 29767 | 308 |
1172539 | 1172539 | 2021-03-30 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1169292 | 1169292 | 2021-03-29 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1166044 | 1166044 | 2021-03-28 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1162796 | 1162796 | 2021-03-27 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1159547 | 1159547 | 2021-03-26 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1156300 | 1156300 | 2021-03-25 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1153053 | 1153053 | 2021-03-24 | Cleveland | Oklahoma | 40027 | 29546 | 292 |
1149806 | 1149806 | 2021-03-23 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1146559 | 1146559 | 2021-03-22 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1143312 | 1143312 | 2021-03-21 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1140065 | 1140065 | 2021-03-20 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1136819 | 1136819 | 2021-03-19 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1133573 | 1133573 | 2021-03-18 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1130325 | 1130325 | 2021-03-17 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1127078 | 1127078 | 2021-03-16 | Cleveland | Oklahoma | 40027 | 29247 | 290 |
1123832 | 1123832 | 2021-03-15 | Cleveland | Oklahoma | 40027 | 29247 | 282 |
1120586 | 1120586 | 2021-03-14 | Cleveland | Oklahoma | 40027 | 29235 | 282 |
1117339 | 1117339 | 2021-03-13 | Cleveland | Oklahoma | 40027 | 29192 | 282 |
1114092 | 1114092 | 2021-03-12 | Cleveland | Oklahoma | 40027 | 29140 | 282 |
1110846 | 1110846 | 2021-03-11 | Cleveland | Oklahoma | 40027 | 29117 | 282 |
1107600 | 1107600 | 2021-03-10 | Cleveland | Oklahoma | 40027 | 29059 | 282 |
1104354 | 1104354 | 2021-03-09 | Cleveland | Oklahoma | 40027 | 29001 | 282 |
1101108 | 1101108 | 2021-03-08 | Cleveland | Oklahoma | 40027 | 28981 | 274 |
1097862 | 1097862 | 2021-03-07 | Cleveland | Oklahoma | 40027 | 28977 | 274 |
1094614 | 1094614 | 2021-03-06 | Cleveland | Oklahoma | 40027 | 28948 | 274 |
1091368 | 1091368 | 2021-03-05 | Cleveland | Oklahoma | 40027 | 28905 | 274 |
1088122 | 1088122 | 2021-03-04 | Cleveland | Oklahoma | 40027 | 28821 | 274 |
1084877 | 1084877 | 2021-03-03 | Cleveland | Oklahoma | 40027 | 28758 | 274 |
1081631 | 1081631 | 2021-03-02 | Cleveland | Oklahoma | 40027 | 28716 | 274 |
1078385 | 1078385 | 2021-03-01 | Cleveland | Oklahoma | 40027 | 28727 | 273 |
1075140 | 1075140 | 2021-02-28 | Cleveland | Oklahoma | 40027 | 28695 | 268 |
1071894 | 1071894 | 2021-02-27 | Cleveland | Oklahoma | 40027 | 28649 | 265 |
1068648 | 1068648 | 2021-02-26 | Cleveland | Oklahoma | 40027 | 28605 | 262 |
1065403 | 1065403 | 2021-02-25 | Cleveland | Oklahoma | 40027 | 28580 | 261 |
1062159 | 1062159 | 2021-02-24 | Cleveland | Oklahoma | 40027 | 28520 | 260 |
1058913 | 1058913 | 2021-02-23 | Cleveland | Oklahoma | 40027 | 28441 | 257 |
1055667 | 1055667 | 2021-02-22 | Cleveland | Oklahoma | 40027 | 28400 | 257 |
1052421 | 1052421 | 2021-02-21 | Cleveland | Oklahoma | 40027 | 28332 | 256 |
1049174 | 1049174 | 2021-02-20 | Cleveland | Oklahoma | 40027 | 28198 | 256 |
1045927 | 1045927 | 2021-02-19 | Cleveland | Oklahoma | 40027 | 28186 | 254 |
1042682 | 1042682 | 2021-02-18 | Cleveland | Oklahoma | 40027 | 28171 | 254 |
1039437 | 1039437 | 2021-02-17 | Cleveland | Oklahoma | 40027 | 28147 | 253 |
1036192 | 1036192 | 2021-02-16 | Cleveland | Oklahoma | 40027 | 28011 | 252 |
1032947 | 1032947 | 2021-02-15 | Cleveland | Oklahoma | 40027 | 27965 | 250 |
1029701 | 1029701 | 2021-02-14 | Cleveland | Oklahoma | 40027 | 27918 | 249 |
1026454 | 1026454 | 2021-02-13 | Cleveland | Oklahoma | 40027 | 27846 | 248 |
1023209 | 1023209 | 2021-02-12 | Cleveland | Oklahoma | 40027 | 27710 | 247 |
1019964 | 1019964 | 2021-02-11 | Cleveland | Oklahoma | 40027 | 27584 | 246 |
1016719 | 1016719 | 2021-02-10 | Cleveland | Oklahoma | 40027 | 27480 | 243 |
1013474 | 1013474 | 2021-02-09 | Cleveland | Oklahoma | 40027 | 27397 | 240 |
1010229 | 1010229 | 2021-02-08 | Cleveland | Oklahoma | 40027 | 27264 | 237 |
1006983 | 1006983 | 2021-02-07 | Cleveland | Oklahoma | 40027 | 27186 | 236 |
1003737 | 1003737 | 2021-02-06 | Cleveland | Oklahoma | 40027 | 27059 | 235 |
1000491 | 1000491 | 2021-02-05 | Cleveland | Oklahoma | 40027 | 26900 | 232 |
997245 | 997245 | 2021-02-04 | Cleveland | Oklahoma | 40027 | 26746 | 231 |
993999 | 993999 | 2021-02-03 | Cleveland | Oklahoma | 40027 | 26603 | 231 |
990753 | 990753 | 2021-02-02 | Cleveland | Oklahoma | 40027 | 26517 | 229 |
987507 | 987507 | 2021-02-01 | Cleveland | Oklahoma | 40027 | 26427 | 228 |
984260 | 984260 | 2021-01-31 | Cleveland | Oklahoma | 40027 | 26314 | 227 |
981013 | 981013 | 2021-01-30 | Cleveland | Oklahoma | 40027 | 26148 | 219 |
977767 | 977767 | 2021-01-29 | Cleveland | Oklahoma | 40027 | 25981 | 218 |
974522 | 974522 | 2021-01-28 | Cleveland | Oklahoma | 40027 | 25763 | 216 |
971277 | 971277 | 2021-01-27 | Cleveland | Oklahoma | 40027 | 25591 | 215 |
968032 | 968032 | 2021-01-26 | Cleveland | Oklahoma | 40027 | 25475 | 204 |
964788 | 964788 | 2021-01-25 | Cleveland | Oklahoma | 40027 | 25366 | 200 |
961543 | 961543 | 2021-01-24 | Cleveland | Oklahoma | 40027 | 25182 | 199 |
958298 | 958298 | 2021-01-23 | Cleveland | Oklahoma | 40027 | 24919 | 197 |
955052 | 955052 | 2021-01-22 | Cleveland | Oklahoma | 40027 | 24467 | 195 |
951807 | 951807 | 2021-01-21 | Cleveland | Oklahoma | 40027 | 24249 | 194 |
948562 | 948562 | 2021-01-20 | Cleveland | Oklahoma | 40027 | 24045 | 193 |
945316 | 945316 | 2021-01-19 | Cleveland | Oklahoma | 40027 | 23922 | 191 |
942069 | 942069 | 2021-01-18 | Cleveland | Oklahoma | 40027 | 23832 | 190 |
938824 | 938824 | 2021-01-17 | Cleveland | Oklahoma | 40027 | 23695 | 190 |
935579 | 935579 | 2021-01-16 | Cleveland | Oklahoma | 40027 | 23475 | 186 |
932334 | 932334 | 2021-01-15 | Cleveland | Oklahoma | 40027 | 23169 | 183 |
929089 | 929089 | 2021-01-14 | Cleveland | Oklahoma | 40027 | 22992 | 179 |
925844 | 925844 | 2021-01-13 | Cleveland | Oklahoma | 40027 | 22709 | 178 |
922598 | 922598 | 2021-01-12 | Cleveland | Oklahoma | 40027 | 22518 | 177 |
919353 | 919353 | 2021-01-11 | Cleveland | Oklahoma | 40027 | 22325 | 173 |
916108 | 916108 | 2021-01-10 | Cleveland | Oklahoma | 40027 | 22062 | 171 |
912863 | 912863 | 2021-01-09 | Cleveland | Oklahoma | 40027 | 21633 | 171 |
909618 | 909618 | 2021-01-08 | Cleveland | Oklahoma | 40027 | 21308 | 170 |
906373 | 906373 | 2021-01-07 | Cleveland | Oklahoma | 40027 | 20953 | 170 |
903127 | 903127 | 2021-01-06 | Cleveland | Oklahoma | 40027 | 20692 | 168 |
899882 | 899882 | 2021-01-05 | Cleveland | Oklahoma | 40027 | 20518 | 168 |
896637 | 896637 | 2021-01-04 | Cleveland | Oklahoma | 40027 | 20392 | 166 |
893391 | 893391 | 2021-01-03 | Cleveland | Oklahoma | 40027 | 20209 | 166 |
890145 | 890145 | 2021-01-02 | Cleveland | Oklahoma | 40027 | 19636 | 164 |
886898 | 886898 | 2021-01-01 | Cleveland | Oklahoma | 40027 | 19231 | 163 |
883653 | 883653 | 2020-12-31 | Cleveland | Oklahoma | 40027 | 19231 | 163 |
880408 | 880408 | 2020-12-30 | Cleveland | Oklahoma | 40027 | 18898 | 163 |
877163 | 877163 | 2020-12-29 | Cleveland | Oklahoma | 40027 | 18704 | 153 |
873918 | 873918 | 2020-12-28 | Cleveland | Oklahoma | 40027 | 18586 | 151 |
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);