ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40113 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195314 | 1195314 | 2021-04-06 | Osage | Oklahoma | 40113 | 4592 | 57 |
1192066 | 1192066 | 2021-04-05 | Osage | Oklahoma | 40113 | 4592 | 57 |
1188817 | 1188817 | 2021-04-04 | Osage | Oklahoma | 40113 | 4592 | 57 |
1185570 | 1185570 | 2021-04-03 | Osage | Oklahoma | 40113 | 4592 | 57 |
1182323 | 1182323 | 2021-04-02 | Osage | Oklahoma | 40113 | 4592 | 57 |
1179076 | 1179076 | 2021-04-01 | Osage | Oklahoma | 40113 | 4592 | 57 |
1175829 | 1175829 | 2021-03-31 | Osage | Oklahoma | 40113 | 4592 | 57 |
1172582 | 1172582 | 2021-03-30 | Osage | Oklahoma | 40113 | 4552 | 56 |
1169335 | 1169335 | 2021-03-29 | Osage | Oklahoma | 40113 | 4552 | 56 |
1166087 | 1166087 | 2021-03-28 | Osage | Oklahoma | 40113 | 4552 | 56 |
1162839 | 1162839 | 2021-03-27 | Osage | Oklahoma | 40113 | 4552 | 56 |
1159590 | 1159590 | 2021-03-26 | Osage | Oklahoma | 40113 | 4552 | 56 |
1156343 | 1156343 | 2021-03-25 | Osage | Oklahoma | 40113 | 4552 | 56 |
1153096 | 1153096 | 2021-03-24 | Osage | Oklahoma | 40113 | 4552 | 56 |
1149849 | 1149849 | 2021-03-23 | Osage | Oklahoma | 40113 | 4538 | 56 |
1146602 | 1146602 | 2021-03-22 | Osage | Oklahoma | 40113 | 4538 | 56 |
1143355 | 1143355 | 2021-03-21 | Osage | Oklahoma | 40113 | 4538 | 56 |
1140108 | 1140108 | 2021-03-20 | Osage | Oklahoma | 40113 | 4538 | 56 |
1136862 | 1136862 | 2021-03-19 | Osage | Oklahoma | 40113 | 4538 | 56 |
1133616 | 1133616 | 2021-03-18 | Osage | Oklahoma | 40113 | 4538 | 56 |
1130368 | 1130368 | 2021-03-17 | Osage | Oklahoma | 40113 | 4538 | 56 |
1127121 | 1127121 | 2021-03-16 | Osage | Oklahoma | 40113 | 4538 | 56 |
1123875 | 1123875 | 2021-03-15 | Osage | Oklahoma | 40113 | 4538 | 56 |
1120629 | 1120629 | 2021-03-14 | Osage | Oklahoma | 40113 | 4532 | 56 |
1117382 | 1117382 | 2021-03-13 | Osage | Oklahoma | 40113 | 4531 | 56 |
1114135 | 1114135 | 2021-03-12 | Osage | Oklahoma | 40113 | 4527 | 56 |
1110889 | 1110889 | 2021-03-11 | Osage | Oklahoma | 40113 | 4524 | 56 |
1107643 | 1107643 | 2021-03-10 | Osage | Oklahoma | 40113 | 4519 | 56 |
1104397 | 1104397 | 2021-03-09 | Osage | Oklahoma | 40113 | 4517 | 56 |
1101151 | 1101151 | 2021-03-08 | Osage | Oklahoma | 40113 | 4515 | 52 |
1097905 | 1097905 | 2021-03-07 | Osage | Oklahoma | 40113 | 4512 | 52 |
1094657 | 1094657 | 2021-03-06 | Osage | Oklahoma | 40113 | 4510 | 52 |
1091411 | 1091411 | 2021-03-05 | Osage | Oklahoma | 40113 | 4504 | 52 |
1088165 | 1088165 | 2021-03-04 | Osage | Oklahoma | 40113 | 4499 | 52 |
1084920 | 1084920 | 2021-03-03 | Osage | Oklahoma | 40113 | 4490 | 52 |
1081674 | 1081674 | 2021-03-02 | Osage | Oklahoma | 40113 | 4488 | 52 |
1078428 | 1078428 | 2021-03-01 | Osage | Oklahoma | 40113 | 4489 | 50 |
1075183 | 1075183 | 2021-02-28 | Osage | Oklahoma | 40113 | 4485 | 49 |
1071937 | 1071937 | 2021-02-27 | Osage | Oklahoma | 40113 | 4476 | 49 |
1068691 | 1068691 | 2021-02-26 | Osage | Oklahoma | 40113 | 4473 | 44 |
1065446 | 1065446 | 2021-02-25 | Osage | Oklahoma | 40113 | 4452 | 44 |
1062202 | 1062202 | 2021-02-24 | Osage | Oklahoma | 40113 | 4440 | 44 |
1058956 | 1058956 | 2021-02-23 | Osage | Oklahoma | 40113 | 4431 | 44 |
1055710 | 1055710 | 2021-02-22 | Osage | Oklahoma | 40113 | 4427 | 44 |
1052464 | 1052464 | 2021-02-21 | Osage | Oklahoma | 40113 | 4419 | 44 |
1049217 | 1049217 | 2021-02-20 | Osage | Oklahoma | 40113 | 4407 | 44 |
1045970 | 1045970 | 2021-02-19 | Osage | Oklahoma | 40113 | 4398 | 44 |
1042725 | 1042725 | 2021-02-18 | Osage | Oklahoma | 40113 | 4389 | 44 |
1039480 | 1039480 | 2021-02-17 | Osage | Oklahoma | 40113 | 4384 | 44 |
1036235 | 1036235 | 2021-02-16 | Osage | Oklahoma | 40113 | 4370 | 44 |
1032990 | 1032990 | 2021-02-15 | Osage | Oklahoma | 40113 | 4363 | 44 |
1029744 | 1029744 | 2021-02-14 | Osage | Oklahoma | 40113 | 4358 | 43 |
1026497 | 1026497 | 2021-02-13 | Osage | Oklahoma | 40113 | 4346 | 41 |
1023252 | 1023252 | 2021-02-12 | Osage | Oklahoma | 40113 | 4318 | 41 |
1020007 | 1020007 | 2021-02-11 | Osage | Oklahoma | 40113 | 4303 | 41 |
1016762 | 1016762 | 2021-02-10 | Osage | Oklahoma | 40113 | 4284 | 41 |
1013517 | 1013517 | 2021-02-09 | Osage | Oklahoma | 40113 | 4270 | 40 |
1010272 | 1010272 | 2021-02-08 | Osage | Oklahoma | 40113 | 4261 | 40 |
1007026 | 1007026 | 2021-02-07 | Osage | Oklahoma | 40113 | 4251 | 40 |
1003780 | 1003780 | 2021-02-06 | Osage | Oklahoma | 40113 | 4223 | 40 |
1000534 | 1000534 | 2021-02-05 | Osage | Oklahoma | 40113 | 4206 | 39 |
997288 | 997288 | 2021-02-04 | Osage | Oklahoma | 40113 | 4176 | 39 |
994042 | 994042 | 2021-02-03 | Osage | Oklahoma | 40113 | 4148 | 39 |
990796 | 990796 | 2021-02-02 | Osage | Oklahoma | 40113 | 4121 | 38 |
987550 | 987550 | 2021-02-01 | Osage | Oklahoma | 40113 | 4108 | 38 |
984303 | 984303 | 2021-01-31 | Osage | Oklahoma | 40113 | 4095 | 38 |
981056 | 981056 | 2021-01-30 | Osage | Oklahoma | 40113 | 4052 | 38 |
977810 | 977810 | 2021-01-29 | Osage | Oklahoma | 40113 | 4030 | 38 |
974565 | 974565 | 2021-01-28 | Osage | Oklahoma | 40113 | 3999 | 38 |
971320 | 971320 | 2021-01-27 | Osage | Oklahoma | 40113 | 3971 | 38 |
968075 | 968075 | 2021-01-26 | Osage | Oklahoma | 40113 | 3937 | 38 |
964831 | 964831 | 2021-01-25 | Osage | Oklahoma | 40113 | 3920 | 38 |
961586 | 961586 | 2021-01-24 | Osage | Oklahoma | 40113 | 3897 | 38 |
958341 | 958341 | 2021-01-23 | Osage | Oklahoma | 40113 | 3866 | 37 |
955095 | 955095 | 2021-01-22 | Osage | Oklahoma | 40113 | 3830 | 35 |
951850 | 951850 | 2021-01-21 | Osage | Oklahoma | 40113 | 3795 | 35 |
948605 | 948605 | 2021-01-20 | Osage | Oklahoma | 40113 | 3774 | 35 |
945359 | 945359 | 2021-01-19 | Osage | Oklahoma | 40113 | 3751 | 34 |
942112 | 942112 | 2021-01-18 | Osage | Oklahoma | 40113 | 3737 | 34 |
938867 | 938867 | 2021-01-17 | Osage | Oklahoma | 40113 | 3716 | 34 |
935622 | 935622 | 2021-01-16 | Osage | Oklahoma | 40113 | 3665 | 33 |
932377 | 932377 | 2021-01-15 | Osage | Oklahoma | 40113 | 3629 | 33 |
929132 | 929132 | 2021-01-14 | Osage | Oklahoma | 40113 | 3583 | 33 |
925887 | 925887 | 2021-01-13 | Osage | Oklahoma | 40113 | 3548 | 33 |
922641 | 922641 | 2021-01-12 | Osage | Oklahoma | 40113 | 3524 | 32 |
919396 | 919396 | 2021-01-11 | Osage | Oklahoma | 40113 | 3502 | 31 |
916151 | 916151 | 2021-01-10 | Osage | Oklahoma | 40113 | 3470 | 31 |
912906 | 912906 | 2021-01-09 | Osage | Oklahoma | 40113 | 3406 | 31 |
909661 | 909661 | 2021-01-08 | Osage | Oklahoma | 40113 | 3358 | 30 |
906416 | 906416 | 2021-01-07 | Osage | Oklahoma | 40113 | 3299 | 29 |
903170 | 903170 | 2021-01-06 | Osage | Oklahoma | 40113 | 3255 | 27 |
899925 | 899925 | 2021-01-05 | Osage | Oklahoma | 40113 | 3234 | 27 |
896680 | 896680 | 2021-01-04 | Osage | Oklahoma | 40113 | 3211 | 27 |
893434 | 893434 | 2021-01-03 | Osage | Oklahoma | 40113 | 3175 | 27 |
890188 | 890188 | 2021-01-02 | Osage | Oklahoma | 40113 | 3076 | 27 |
886941 | 886941 | 2021-01-01 | Osage | Oklahoma | 40113 | 3016 | 26 |
883696 | 883696 | 2020-12-31 | Osage | Oklahoma | 40113 | 3016 | 26 |
880451 | 880451 | 2020-12-30 | Osage | Oklahoma | 40113 | 2968 | 26 |
877206 | 877206 | 2020-12-29 | Osage | Oklahoma | 40113 | 2902 | 25 |
873961 | 873961 | 2020-12-28 | Osage | Oklahoma | 40113 | 2897 | 25 |
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);