ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40041 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195278 | 1195278 | 2021-04-06 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1192030 | 1192030 | 2021-04-05 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1188781 | 1188781 | 2021-04-04 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1185534 | 1185534 | 2021-04-03 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1182287 | 1182287 | 2021-04-02 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1179040 | 1179040 | 2021-04-01 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1175793 | 1175793 | 2021-03-31 | Delaware | Oklahoma | 40041 | 4526 | 66 |
1172546 | 1172546 | 2021-03-30 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1169299 | 1169299 | 2021-03-29 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1166051 | 1166051 | 2021-03-28 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1162803 | 1162803 | 2021-03-27 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1159554 | 1159554 | 2021-03-26 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1156307 | 1156307 | 2021-03-25 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1153060 | 1153060 | 2021-03-24 | Delaware | Oklahoma | 40041 | 4502 | 64 |
1149813 | 1149813 | 2021-03-23 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1146566 | 1146566 | 2021-03-22 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1143319 | 1143319 | 2021-03-21 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1140072 | 1140072 | 2021-03-20 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1136826 | 1136826 | 2021-03-19 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1133580 | 1133580 | 2021-03-18 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1130332 | 1130332 | 2021-03-17 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1127085 | 1127085 | 2021-03-16 | Delaware | Oklahoma | 40041 | 4477 | 64 |
1123839 | 1123839 | 2021-03-15 | Delaware | Oklahoma | 40041 | 4477 | 63 |
1120593 | 1120593 | 2021-03-14 | Delaware | Oklahoma | 40041 | 4473 | 63 |
1117346 | 1117346 | 2021-03-13 | Delaware | Oklahoma | 40041 | 4466 | 63 |
1114099 | 1114099 | 2021-03-12 | Delaware | Oklahoma | 40041 | 4462 | 63 |
1110853 | 1110853 | 2021-03-11 | Delaware | Oklahoma | 40041 | 4454 | 63 |
1107607 | 1107607 | 2021-03-10 | Delaware | Oklahoma | 40041 | 4438 | 63 |
1104361 | 1104361 | 2021-03-09 | Delaware | Oklahoma | 40041 | 4430 | 63 |
1101115 | 1101115 | 2021-03-08 | Delaware | Oklahoma | 40041 | 4429 | 62 |
1097869 | 1097869 | 2021-03-07 | Delaware | Oklahoma | 40041 | 4429 | 62 |
1094621 | 1094621 | 2021-03-06 | Delaware | Oklahoma | 40041 | 4419 | 62 |
1091375 | 1091375 | 2021-03-05 | Delaware | Oklahoma | 40041 | 4384 | 62 |
1088129 | 1088129 | 2021-03-04 | Delaware | Oklahoma | 40041 | 4379 | 62 |
1084884 | 1084884 | 2021-03-03 | Delaware | Oklahoma | 40041 | 4374 | 62 |
1081638 | 1081638 | 2021-03-02 | Delaware | Oklahoma | 40041 | 4372 | 62 |
1078392 | 1078392 | 2021-03-01 | Delaware | Oklahoma | 40041 | 4372 | 62 |
1075147 | 1075147 | 2021-02-28 | Delaware | Oklahoma | 40041 | 4370 | 62 |
1071901 | 1071901 | 2021-02-27 | Delaware | Oklahoma | 40041 | 4365 | 61 |
1068655 | 1068655 | 2021-02-26 | Delaware | Oklahoma | 40041 | 4359 | 61 |
1065410 | 1065410 | 2021-02-25 | Delaware | Oklahoma | 40041 | 4348 | 61 |
1062166 | 1062166 | 2021-02-24 | Delaware | Oklahoma | 40041 | 4341 | 61 |
1058920 | 1058920 | 2021-02-23 | Delaware | Oklahoma | 40041 | 4338 | 61 |
1055674 | 1055674 | 2021-02-22 | Delaware | Oklahoma | 40041 | 4336 | 61 |
1052428 | 1052428 | 2021-02-21 | Delaware | Oklahoma | 40041 | 4333 | 61 |
1049181 | 1049181 | 2021-02-20 | Delaware | Oklahoma | 40041 | 4333 | 61 |
1045934 | 1045934 | 2021-02-19 | Delaware | Oklahoma | 40041 | 4303 | 61 |
1042689 | 1042689 | 2021-02-18 | Delaware | Oklahoma | 40041 | 4295 | 60 |
1039444 | 1039444 | 2021-02-17 | Delaware | Oklahoma | 40041 | 4289 | 60 |
1036199 | 1036199 | 2021-02-16 | Delaware | Oklahoma | 40041 | 4286 | 60 |
1032954 | 1032954 | 2021-02-15 | Delaware | Oklahoma | 40041 | 4284 | 59 |
1029708 | 1029708 | 2021-02-14 | Delaware | Oklahoma | 40041 | 4282 | 59 |
1026461 | 1026461 | 2021-02-13 | Delaware | Oklahoma | 40041 | 4266 | 59 |
1023216 | 1023216 | 2021-02-12 | Delaware | Oklahoma | 40041 | 4249 | 59 |
1019971 | 1019971 | 2021-02-11 | Delaware | Oklahoma | 40041 | 4229 | 59 |
1016726 | 1016726 | 2021-02-10 | Delaware | Oklahoma | 40041 | 4225 | 59 |
1013481 | 1013481 | 2021-02-09 | Delaware | Oklahoma | 40041 | 4209 | 59 |
1010236 | 1010236 | 2021-02-08 | Delaware | Oklahoma | 40041 | 4208 | 58 |
1006990 | 1006990 | 2021-02-07 | Delaware | Oklahoma | 40041 | 4199 | 58 |
1003744 | 1003744 | 2021-02-06 | Delaware | Oklahoma | 40041 | 4193 | 57 |
1000498 | 1000498 | 2021-02-05 | Delaware | Oklahoma | 40041 | 4183 | 57 |
997252 | 997252 | 2021-02-04 | Delaware | Oklahoma | 40041 | 4168 | 55 |
994006 | 994006 | 2021-02-03 | Delaware | Oklahoma | 40041 | 4136 | 55 |
990760 | 990760 | 2021-02-02 | Delaware | Oklahoma | 40041 | 4118 | 55 |
987514 | 987514 | 2021-02-01 | Delaware | Oklahoma | 40041 | 4111 | 54 |
984267 | 984267 | 2021-01-31 | Delaware | Oklahoma | 40041 | 4099 | 54 |
981020 | 981020 | 2021-01-30 | Delaware | Oklahoma | 40041 | 4070 | 54 |
977774 | 977774 | 2021-01-29 | Delaware | Oklahoma | 40041 | 4049 | 54 |
974529 | 974529 | 2021-01-28 | Delaware | Oklahoma | 40041 | 4013 | 54 |
971284 | 971284 | 2021-01-27 | Delaware | Oklahoma | 40041 | 3985 | 54 |
968039 | 968039 | 2021-01-26 | Delaware | Oklahoma | 40041 | 3963 | 54 |
964795 | 964795 | 2021-01-25 | Delaware | Oklahoma | 40041 | 3950 | 54 |
961550 | 961550 | 2021-01-24 | Delaware | Oklahoma | 40041 | 3936 | 54 |
958305 | 958305 | 2021-01-23 | Delaware | Oklahoma | 40041 | 3905 | 53 |
955059 | 955059 | 2021-01-22 | Delaware | Oklahoma | 40041 | 3873 | 53 |
951814 | 951814 | 2021-01-21 | Delaware | Oklahoma | 40041 | 3842 | 52 |
948569 | 948569 | 2021-01-20 | Delaware | Oklahoma | 40041 | 3818 | 51 |
945323 | 945323 | 2021-01-19 | Delaware | Oklahoma | 40041 | 3814 | 50 |
942076 | 942076 | 2021-01-18 | Delaware | Oklahoma | 40041 | 3790 | 46 |
938831 | 938831 | 2021-01-17 | Delaware | Oklahoma | 40041 | 3770 | 46 |
935586 | 935586 | 2021-01-16 | Delaware | Oklahoma | 40041 | 3724 | 46 |
932341 | 932341 | 2021-01-15 | Delaware | Oklahoma | 40041 | 3684 | 46 |
929096 | 929096 | 2021-01-14 | Delaware | Oklahoma | 40041 | 3621 | 46 |
925851 | 925851 | 2021-01-13 | Delaware | Oklahoma | 40041 | 3585 | 46 |
922605 | 922605 | 2021-01-12 | Delaware | Oklahoma | 40041 | 3549 | 46 |
919360 | 919360 | 2021-01-11 | Delaware | Oklahoma | 40041 | 3491 | 46 |
916115 | 916115 | 2021-01-10 | Delaware | Oklahoma | 40041 | 3456 | 46 |
912870 | 912870 | 2021-01-09 | Delaware | Oklahoma | 40041 | 3407 | 45 |
909625 | 909625 | 2021-01-08 | Delaware | Oklahoma | 40041 | 3359 | 45 |
906380 | 906380 | 2021-01-07 | Delaware | Oklahoma | 40041 | 3243 | 45 |
903134 | 903134 | 2021-01-06 | Delaware | Oklahoma | 40041 | 3200 | 44 |
899889 | 899889 | 2021-01-05 | Delaware | Oklahoma | 40041 | 3159 | 44 |
896644 | 896644 | 2021-01-04 | Delaware | Oklahoma | 40041 | 3143 | 44 |
893398 | 893398 | 2021-01-03 | Delaware | Oklahoma | 40041 | 3080 | 44 |
890152 | 890152 | 2021-01-02 | Delaware | Oklahoma | 40041 | 2977 | 44 |
886905 | 886905 | 2021-01-01 | Delaware | Oklahoma | 40041 | 2915 | 44 |
883660 | 883660 | 2020-12-31 | Delaware | Oklahoma | 40041 | 2915 | 44 |
880415 | 880415 | 2020-12-30 | Delaware | Oklahoma | 40041 | 2873 | 44 |
877170 | 877170 | 2020-12-29 | Delaware | Oklahoma | 40041 | 2838 | 44 |
873925 | 873925 | 2020-12-28 | Delaware | Oklahoma | 40041 | 2815 | 44 |
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);