ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where fips = 40141 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195328 | 1195328 | 2021-04-06 | Tillman | Oklahoma | 40141 | 780 | 16 |
1192080 | 1192080 | 2021-04-05 | Tillman | Oklahoma | 40141 | 780 | 16 |
1188831 | 1188831 | 2021-04-04 | Tillman | Oklahoma | 40141 | 780 | 16 |
1185584 | 1185584 | 2021-04-03 | Tillman | Oklahoma | 40141 | 780 | 16 |
1182337 | 1182337 | 2021-04-02 | Tillman | Oklahoma | 40141 | 780 | 16 |
1179090 | 1179090 | 2021-04-01 | Tillman | Oklahoma | 40141 | 780 | 16 |
1175843 | 1175843 | 2021-03-31 | Tillman | Oklahoma | 40141 | 780 | 16 |
1172596 | 1172596 | 2021-03-30 | Tillman | Oklahoma | 40141 | 772 | 16 |
1169349 | 1169349 | 2021-03-29 | Tillman | Oklahoma | 40141 | 772 | 16 |
1166101 | 1166101 | 2021-03-28 | Tillman | Oklahoma | 40141 | 772 | 16 |
1162853 | 1162853 | 2021-03-27 | Tillman | Oklahoma | 40141 | 772 | 16 |
1159604 | 1159604 | 2021-03-26 | Tillman | Oklahoma | 40141 | 772 | 16 |
1156357 | 1156357 | 2021-03-25 | Tillman | Oklahoma | 40141 | 772 | 16 |
1153110 | 1153110 | 2021-03-24 | Tillman | Oklahoma | 40141 | 772 | 16 |
1149863 | 1149863 | 2021-03-23 | Tillman | Oklahoma | 40141 | 762 | 16 |
1146616 | 1146616 | 2021-03-22 | Tillman | Oklahoma | 40141 | 762 | 16 |
1143369 | 1143369 | 2021-03-21 | Tillman | Oklahoma | 40141 | 762 | 16 |
1140122 | 1140122 | 2021-03-20 | Tillman | Oklahoma | 40141 | 762 | 16 |
1136876 | 1136876 | 2021-03-19 | Tillman | Oklahoma | 40141 | 762 | 16 |
1133630 | 1133630 | 2021-03-18 | Tillman | Oklahoma | 40141 | 762 | 16 |
1130382 | 1130382 | 2021-03-17 | Tillman | Oklahoma | 40141 | 762 | 16 |
1127135 | 1127135 | 2021-03-16 | Tillman | Oklahoma | 40141 | 762 | 16 |
1123889 | 1123889 | 2021-03-15 | Tillman | Oklahoma | 40141 | 762 | 15 |
1120643 | 1120643 | 2021-03-14 | Tillman | Oklahoma | 40141 | 761 | 15 |
1117396 | 1117396 | 2021-03-13 | Tillman | Oklahoma | 40141 | 760 | 15 |
1114149 | 1114149 | 2021-03-12 | Tillman | Oklahoma | 40141 | 760 | 15 |
1110903 | 1110903 | 2021-03-11 | Tillman | Oklahoma | 40141 | 757 | 15 |
1107657 | 1107657 | 2021-03-10 | Tillman | Oklahoma | 40141 | 757 | 15 |
1104411 | 1104411 | 2021-03-09 | Tillman | Oklahoma | 40141 | 757 | 15 |
1101165 | 1101165 | 2021-03-08 | Tillman | Oklahoma | 40141 | 756 | 14 |
1097919 | 1097919 | 2021-03-07 | Tillman | Oklahoma | 40141 | 756 | 14 |
1094671 | 1094671 | 2021-03-06 | Tillman | Oklahoma | 40141 | 756 | 14 |
1091425 | 1091425 | 2021-03-05 | Tillman | Oklahoma | 40141 | 751 | 14 |
1088179 | 1088179 | 2021-03-04 | Tillman | Oklahoma | 40141 | 750 | 14 |
1084934 | 1084934 | 2021-03-03 | Tillman | Oklahoma | 40141 | 750 | 14 |
1081688 | 1081688 | 2021-03-02 | Tillman | Oklahoma | 40141 | 749 | 14 |
1078442 | 1078442 | 2021-03-01 | Tillman | Oklahoma | 40141 | 749 | 14 |
1075197 | 1075197 | 2021-02-28 | Tillman | Oklahoma | 40141 | 749 | 14 |
1071951 | 1071951 | 2021-02-27 | Tillman | Oklahoma | 40141 | 748 | 14 |
1068705 | 1068705 | 2021-02-26 | Tillman | Oklahoma | 40141 | 748 | 14 |
1065460 | 1065460 | 2021-02-25 | Tillman | Oklahoma | 40141 | 747 | 14 |
1062216 | 1062216 | 2021-02-24 | Tillman | Oklahoma | 40141 | 744 | 14 |
1058970 | 1058970 | 2021-02-23 | Tillman | Oklahoma | 40141 | 743 | 14 |
1055724 | 1055724 | 2021-02-22 | Tillman | Oklahoma | 40141 | 743 | 14 |
1052478 | 1052478 | 2021-02-21 | Tillman | Oklahoma | 40141 | 743 | 14 |
1049231 | 1049231 | 2021-02-20 | Tillman | Oklahoma | 40141 | 741 | 14 |
1045984 | 1045984 | 2021-02-19 | Tillman | Oklahoma | 40141 | 740 | 14 |
1042739 | 1042739 | 2021-02-18 | Tillman | Oklahoma | 40141 | 740 | 14 |
1039494 | 1039494 | 2021-02-17 | Tillman | Oklahoma | 40141 | 739 | 14 |
1036249 | 1036249 | 2021-02-16 | Tillman | Oklahoma | 40141 | 731 | 14 |
1033004 | 1033004 | 2021-02-15 | Tillman | Oklahoma | 40141 | 730 | 14 |
1029758 | 1029758 | 2021-02-14 | Tillman | Oklahoma | 40141 | 730 | 14 |
1026511 | 1026511 | 2021-02-13 | Tillman | Oklahoma | 40141 | 730 | 14 |
1023266 | 1023266 | 2021-02-12 | Tillman | Oklahoma | 40141 | 729 | 14 |
1020021 | 1020021 | 2021-02-11 | Tillman | Oklahoma | 40141 | 729 | 14 |
1016776 | 1016776 | 2021-02-10 | Tillman | Oklahoma | 40141 | 727 | 14 |
1013531 | 1013531 | 2021-02-09 | Tillman | Oklahoma | 40141 | 723 | 14 |
1010286 | 1010286 | 2021-02-08 | Tillman | Oklahoma | 40141 | 723 | 14 |
1007040 | 1007040 | 2021-02-07 | Tillman | Oklahoma | 40141 | 720 | 14 |
1003794 | 1003794 | 2021-02-06 | Tillman | Oklahoma | 40141 | 718 | 14 |
1000548 | 1000548 | 2021-02-05 | Tillman | Oklahoma | 40141 | 716 | 14 |
997302 | 997302 | 2021-02-04 | Tillman | Oklahoma | 40141 | 711 | 14 |
994056 | 994056 | 2021-02-03 | Tillman | Oklahoma | 40141 | 702 | 14 |
990810 | 990810 | 2021-02-02 | Tillman | Oklahoma | 40141 | 702 | 14 |
987564 | 987564 | 2021-02-01 | Tillman | Oklahoma | 40141 | 701 | 13 |
984317 | 984317 | 2021-01-31 | Tillman | Oklahoma | 40141 | 701 | 13 |
981070 | 981070 | 2021-01-30 | Tillman | Oklahoma | 40141 | 700 | 13 |
977824 | 977824 | 2021-01-29 | Tillman | Oklahoma | 40141 | 699 | 13 |
974579 | 974579 | 2021-01-28 | Tillman | Oklahoma | 40141 | 691 | 13 |
971334 | 971334 | 2021-01-27 | Tillman | Oklahoma | 40141 | 691 | 13 |
968089 | 968089 | 2021-01-26 | Tillman | Oklahoma | 40141 | 679 | 13 |
964845 | 964845 | 2021-01-25 | Tillman | Oklahoma | 40141 | 675 | 13 |
961600 | 961600 | 2021-01-24 | Tillman | Oklahoma | 40141 | 674 | 13 |
958355 | 958355 | 2021-01-23 | Tillman | Oklahoma | 40141 | 671 | 13 |
955109 | 955109 | 2021-01-22 | Tillman | Oklahoma | 40141 | 663 | 13 |
951864 | 951864 | 2021-01-21 | Tillman | Oklahoma | 40141 | 661 | 13 |
948619 | 948619 | 2021-01-20 | Tillman | Oklahoma | 40141 | 659 | 12 |
945373 | 945373 | 2021-01-19 | Tillman | Oklahoma | 40141 | 658 | 11 |
942126 | 942126 | 2021-01-18 | Tillman | Oklahoma | 40141 | 652 | 11 |
938881 | 938881 | 2021-01-17 | Tillman | Oklahoma | 40141 | 650 | 11 |
935636 | 935636 | 2021-01-16 | Tillman | Oklahoma | 40141 | 643 | 11 |
932391 | 932391 | 2021-01-15 | Tillman | Oklahoma | 40141 | 640 | 10 |
929146 | 929146 | 2021-01-14 | Tillman | Oklahoma | 40141 | 636 | 10 |
925901 | 925901 | 2021-01-13 | Tillman | Oklahoma | 40141 | 634 | 10 |
922655 | 922655 | 2021-01-12 | Tillman | Oklahoma | 40141 | 626 | 10 |
919410 | 919410 | 2021-01-11 | Tillman | Oklahoma | 40141 | 623 | 10 |
916165 | 916165 | 2021-01-10 | Tillman | Oklahoma | 40141 | 614 | 10 |
912920 | 912920 | 2021-01-09 | Tillman | Oklahoma | 40141 | 597 | 10 |
909675 | 909675 | 2021-01-08 | Tillman | Oklahoma | 40141 | 592 | 9 |
906430 | 906430 | 2021-01-07 | Tillman | Oklahoma | 40141 | 583 | 9 |
903184 | 903184 | 2021-01-06 | Tillman | Oklahoma | 40141 | 572 | 9 |
899939 | 899939 | 2021-01-05 | Tillman | Oklahoma | 40141 | 567 | 9 |
896694 | 896694 | 2021-01-04 | Tillman | Oklahoma | 40141 | 565 | 9 |
893448 | 893448 | 2021-01-03 | Tillman | Oklahoma | 40141 | 564 | 9 |
890202 | 890202 | 2021-01-02 | Tillman | Oklahoma | 40141 | 554 | 9 |
886955 | 886955 | 2021-01-01 | Tillman | Oklahoma | 40141 | 544 | 9 |
883710 | 883710 | 2020-12-31 | Tillman | Oklahoma | 40141 | 544 | 9 |
880465 | 880465 | 2020-12-30 | Tillman | Oklahoma | 40141 | 538 | 9 |
877220 | 877220 | 2020-12-29 | Tillman | Oklahoma | 40141 | 536 | 8 |
873975 | 873975 | 2020-12-28 | Tillman | Oklahoma | 40141 | 535 | 8 |
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);