ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where fips = 40067 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195291 | 1195291 | 2021-04-06 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1192043 | 1192043 | 2021-04-05 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1188794 | 1188794 | 2021-04-04 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1185547 | 1185547 | 2021-04-03 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1182300 | 1182300 | 2021-04-02 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1179053 | 1179053 | 2021-04-01 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1175806 | 1175806 | 2021-03-31 | Jefferson | Oklahoma | 40067 | 683 | 12 |
1172559 | 1172559 | 2021-03-30 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1169312 | 1169312 | 2021-03-29 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1166064 | 1166064 | 2021-03-28 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1162816 | 1162816 | 2021-03-27 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1159567 | 1159567 | 2021-03-26 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1156320 | 1156320 | 2021-03-25 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1153073 | 1153073 | 2021-03-24 | Jefferson | Oklahoma | 40067 | 679 | 12 |
1149826 | 1149826 | 2021-03-23 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1146579 | 1146579 | 2021-03-22 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1143332 | 1143332 | 2021-03-21 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1140085 | 1140085 | 2021-03-20 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1136839 | 1136839 | 2021-03-19 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1133593 | 1133593 | 2021-03-18 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1130345 | 1130345 | 2021-03-17 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1127098 | 1127098 | 2021-03-16 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1123852 | 1123852 | 2021-03-15 | Jefferson | Oklahoma | 40067 | 675 | 12 |
1120606 | 1120606 | 2021-03-14 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1117359 | 1117359 | 2021-03-13 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1114112 | 1114112 | 2021-03-12 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1110866 | 1110866 | 2021-03-11 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1107620 | 1107620 | 2021-03-10 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1104374 | 1104374 | 2021-03-09 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1101128 | 1101128 | 2021-03-08 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1097882 | 1097882 | 2021-03-07 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1094634 | 1094634 | 2021-03-06 | Jefferson | Oklahoma | 40067 | 673 | 12 |
1091388 | 1091388 | 2021-03-05 | Jefferson | Oklahoma | 40067 | 672 | 12 |
1088142 | 1088142 | 2021-03-04 | Jefferson | Oklahoma | 40067 | 672 | 12 |
1084897 | 1084897 | 2021-03-03 | Jefferson | Oklahoma | 40067 | 672 | 12 |
1081651 | 1081651 | 2021-03-02 | Jefferson | Oklahoma | 40067 | 672 | 12 |
1078405 | 1078405 | 2021-03-01 | Jefferson | Oklahoma | 40067 | 672 | 11 |
1075160 | 1075160 | 2021-02-28 | Jefferson | Oklahoma | 40067 | 672 | 11 |
1071914 | 1071914 | 2021-02-27 | Jefferson | Oklahoma | 40067 | 672 | 11 |
1068668 | 1068668 | 2021-02-26 | Jefferson | Oklahoma | 40067 | 672 | 10 |
1065423 | 1065423 | 2021-02-25 | Jefferson | Oklahoma | 40067 | 673 | 10 |
1062179 | 1062179 | 2021-02-24 | Jefferson | Oklahoma | 40067 | 673 | 10 |
1058933 | 1058933 | 2021-02-23 | Jefferson | Oklahoma | 40067 | 671 | 8 |
1055687 | 1055687 | 2021-02-22 | Jefferson | Oklahoma | 40067 | 670 | 8 |
1052441 | 1052441 | 2021-02-21 | Jefferson | Oklahoma | 40067 | 670 | 8 |
1049194 | 1049194 | 2021-02-20 | Jefferson | Oklahoma | 40067 | 668 | 8 |
1045947 | 1045947 | 2021-02-19 | Jefferson | Oklahoma | 40067 | 668 | 8 |
1042702 | 1042702 | 2021-02-18 | Jefferson | Oklahoma | 40067 | 668 | 8 |
1039457 | 1039457 | 2021-02-17 | Jefferson | Oklahoma | 40067 | 668 | 8 |
1036212 | 1036212 | 2021-02-16 | Jefferson | Oklahoma | 40067 | 667 | 8 |
1032967 | 1032967 | 2021-02-15 | Jefferson | Oklahoma | 40067 | 667 | 8 |
1029721 | 1029721 | 2021-02-14 | Jefferson | Oklahoma | 40067 | 667 | 8 |
1026474 | 1026474 | 2021-02-13 | Jefferson | Oklahoma | 40067 | 664 | 8 |
1023229 | 1023229 | 2021-02-12 | Jefferson | Oklahoma | 40067 | 662 | 7 |
1019984 | 1019984 | 2021-02-11 | Jefferson | Oklahoma | 40067 | 659 | 7 |
1016739 | 1016739 | 2021-02-10 | Jefferson | Oklahoma | 40067 | 659 | 7 |
1013494 | 1013494 | 2021-02-09 | Jefferson | Oklahoma | 40067 | 657 | 7 |
1010249 | 1010249 | 2021-02-08 | Jefferson | Oklahoma | 40067 | 656 | 7 |
1007003 | 1007003 | 2021-02-07 | Jefferson | Oklahoma | 40067 | 655 | 7 |
1003757 | 1003757 | 2021-02-06 | Jefferson | Oklahoma | 40067 | 654 | 7 |
1000511 | 1000511 | 2021-02-05 | Jefferson | Oklahoma | 40067 | 647 | 7 |
997265 | 997265 | 2021-02-04 | Jefferson | Oklahoma | 40067 | 643 | 7 |
994019 | 994019 | 2021-02-03 | Jefferson | Oklahoma | 40067 | 639 | 7 |
990773 | 990773 | 2021-02-02 | Jefferson | Oklahoma | 40067 | 638 | 7 |
987527 | 987527 | 2021-02-01 | Jefferson | Oklahoma | 40067 | 638 | 7 |
984280 | 984280 | 2021-01-31 | Jefferson | Oklahoma | 40067 | 636 | 7 |
981033 | 981033 | 2021-01-30 | Jefferson | Oklahoma | 40067 | 632 | 7 |
977787 | 977787 | 2021-01-29 | Jefferson | Oklahoma | 40067 | 629 | 7 |
974542 | 974542 | 2021-01-28 | Jefferson | Oklahoma | 40067 | 622 | 7 |
971297 | 971297 | 2021-01-27 | Jefferson | Oklahoma | 40067 | 615 | 7 |
968052 | 968052 | 2021-01-26 | Jefferson | Oklahoma | 40067 | 612 | 7 |
964808 | 964808 | 2021-01-25 | Jefferson | Oklahoma | 40067 | 611 | 7 |
961563 | 961563 | 2021-01-24 | Jefferson | Oklahoma | 40067 | 611 | 7 |
958318 | 958318 | 2021-01-23 | Jefferson | Oklahoma | 40067 | 605 | 6 |
955072 | 955072 | 2021-01-22 | Jefferson | Oklahoma | 40067 | 601 | 6 |
951827 | 951827 | 2021-01-21 | Jefferson | Oklahoma | 40067 | 592 | 6 |
948582 | 948582 | 2021-01-20 | Jefferson | Oklahoma | 40067 | 588 | 4 |
945336 | 945336 | 2021-01-19 | Jefferson | Oklahoma | 40067 | 583 | 4 |
942089 | 942089 | 2021-01-18 | Jefferson | Oklahoma | 40067 | 582 | 4 |
938844 | 938844 | 2021-01-17 | Jefferson | Oklahoma | 40067 | 581 | 4 |
935599 | 935599 | 2021-01-16 | Jefferson | Oklahoma | 40067 | 572 | 4 |
932354 | 932354 | 2021-01-15 | Jefferson | Oklahoma | 40067 | 564 | 4 |
929109 | 929109 | 2021-01-14 | Jefferson | Oklahoma | 40067 | 563 | 4 |
925864 | 925864 | 2021-01-13 | Jefferson | Oklahoma | 40067 | 554 | 4 |
922618 | 922618 | 2021-01-12 | Jefferson | Oklahoma | 40067 | 548 | 4 |
919373 | 919373 | 2021-01-11 | Jefferson | Oklahoma | 40067 | 546 | 4 |
916128 | 916128 | 2021-01-10 | Jefferson | Oklahoma | 40067 | 533 | 4 |
912883 | 912883 | 2021-01-09 | Jefferson | Oklahoma | 40067 | 520 | 4 |
909638 | 909638 | 2021-01-08 | Jefferson | Oklahoma | 40067 | 504 | 4 |
906393 | 906393 | 2021-01-07 | Jefferson | Oklahoma | 40067 | 491 | 4 |
903147 | 903147 | 2021-01-06 | Jefferson | Oklahoma | 40067 | 481 | 4 |
899902 | 899902 | 2021-01-05 | Jefferson | Oklahoma | 40067 | 471 | 3 |
896657 | 896657 | 2021-01-04 | Jefferson | Oklahoma | 40067 | 469 | 3 |
893411 | 893411 | 2021-01-03 | Jefferson | Oklahoma | 40067 | 468 | 3 |
890165 | 890165 | 2021-01-02 | Jefferson | Oklahoma | 40067 | 442 | 3 |
886918 | 886918 | 2021-01-01 | Jefferson | Oklahoma | 40067 | 436 | 3 |
883673 | 883673 | 2020-12-31 | Jefferson | Oklahoma | 40067 | 436 | 3 |
880428 | 880428 | 2020-12-30 | Jefferson | Oklahoma | 40067 | 430 | 3 |
877183 | 877183 | 2020-12-29 | Jefferson | Oklahoma | 40067 | 419 | 3 |
873938 | 873938 | 2020-12-28 | Jefferson | Oklahoma | 40067 | 415 | 3 |
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);