ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Pawnee" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195316 | 1195316 | 2021-04-06 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1192068 | 1192068 | 2021-04-05 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1188819 | 1188819 | 2021-04-04 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1185572 | 1185572 | 2021-04-03 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1182325 | 1182325 | 2021-04-02 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1179078 | 1179078 | 2021-04-01 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1175831 | 1175831 | 2021-03-31 | Pawnee | Oklahoma | 40117 | 1752 | 35 |
1172584 | 1172584 | 2021-03-30 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1169337 | 1169337 | 2021-03-29 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1166089 | 1166089 | 2021-03-28 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1162841 | 1162841 | 2021-03-27 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1159592 | 1159592 | 2021-03-26 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1156345 | 1156345 | 2021-03-25 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1153098 | 1153098 | 2021-03-24 | Pawnee | Oklahoma | 40117 | 1747 | 34 |
1149851 | 1149851 | 2021-03-23 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1146604 | 1146604 | 2021-03-22 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1143357 | 1143357 | 2021-03-21 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1140110 | 1140110 | 2021-03-20 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1136864 | 1136864 | 2021-03-19 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1133618 | 1133618 | 2021-03-18 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1130370 | 1130370 | 2021-03-17 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1127123 | 1127123 | 2021-03-16 | Pawnee | Oklahoma | 40117 | 1743 | 34 |
1123877 | 1123877 | 2021-03-15 | Pawnee | Oklahoma | 40117 | 1743 | 33 |
1120631 | 1120631 | 2021-03-14 | Pawnee | Oklahoma | 40117 | 1743 | 33 |
1117384 | 1117384 | 2021-03-13 | Pawnee | Oklahoma | 40117 | 1742 | 33 |
1114137 | 1114137 | 2021-03-12 | Pawnee | Oklahoma | 40117 | 1738 | 33 |
1110891 | 1110891 | 2021-03-11 | Pawnee | Oklahoma | 40117 | 1737 | 33 |
1107645 | 1107645 | 2021-03-10 | Pawnee | Oklahoma | 40117 | 1735 | 33 |
1104399 | 1104399 | 2021-03-09 | Pawnee | Oklahoma | 40117 | 1731 | 33 |
1101153 | 1101153 | 2021-03-08 | Pawnee | Oklahoma | 40117 | 1731 | 33 |
1097907 | 1097907 | 2021-03-07 | Pawnee | Oklahoma | 40117 | 1731 | 33 |
1094659 | 1094659 | 2021-03-06 | Pawnee | Oklahoma | 40117 | 1729 | 33 |
1091413 | 1091413 | 2021-03-05 | Pawnee | Oklahoma | 40117 | 1722 | 33 |
1088167 | 1088167 | 2021-03-04 | Pawnee | Oklahoma | 40117 | 1711 | 33 |
1084922 | 1084922 | 2021-03-03 | Pawnee | Oklahoma | 40117 | 1709 | 33 |
1081676 | 1081676 | 2021-03-02 | Pawnee | Oklahoma | 40117 | 1704 | 33 |
1078430 | 1078430 | 2021-03-01 | Pawnee | Oklahoma | 40117 | 1704 | 32 |
1075185 | 1075185 | 2021-02-28 | Pawnee | Oklahoma | 40117 | 1701 | 32 |
1071939 | 1071939 | 2021-02-27 | Pawnee | Oklahoma | 40117 | 1701 | 31 |
1068693 | 1068693 | 2021-02-26 | Pawnee | Oklahoma | 40117 | 1702 | 31 |
1065448 | 1065448 | 2021-02-25 | Pawnee | Oklahoma | 40117 | 1697 | 31 |
1062204 | 1062204 | 2021-02-24 | Pawnee | Oklahoma | 40117 | 1693 | 30 |
1058958 | 1058958 | 2021-02-23 | Pawnee | Oklahoma | 40117 | 1691 | 30 |
1055712 | 1055712 | 2021-02-22 | Pawnee | Oklahoma | 40117 | 1691 | 30 |
1052466 | 1052466 | 2021-02-21 | Pawnee | Oklahoma | 40117 | 1686 | 30 |
1049219 | 1049219 | 2021-02-20 | Pawnee | Oklahoma | 40117 | 1682 | 30 |
1045972 | 1045972 | 2021-02-19 | Pawnee | Oklahoma | 40117 | 1686 | 30 |
1042727 | 1042727 | 2021-02-18 | Pawnee | Oklahoma | 40117 | 1683 | 29 |
1039482 | 1039482 | 2021-02-17 | Pawnee | Oklahoma | 40117 | 1683 | 29 |
1036237 | 1036237 | 2021-02-16 | Pawnee | Oklahoma | 40117 | 1682 | 29 |
1032992 | 1032992 | 2021-02-15 | Pawnee | Oklahoma | 40117 | 1681 | 29 |
1029746 | 1029746 | 2021-02-14 | Pawnee | Oklahoma | 40117 | 1682 | 29 |
1026499 | 1026499 | 2021-02-13 | Pawnee | Oklahoma | 40117 | 1677 | 28 |
1023254 | 1023254 | 2021-02-12 | Pawnee | Oklahoma | 40117 | 1616 | 28 |
1020009 | 1020009 | 2021-02-11 | Pawnee | Oklahoma | 40117 | 1575 | 28 |
1016764 | 1016764 | 2021-02-10 | Pawnee | Oklahoma | 40117 | 1573 | 28 |
1013519 | 1013519 | 2021-02-09 | Pawnee | Oklahoma | 40117 | 1554 | 28 |
1010274 | 1010274 | 2021-02-08 | Pawnee | Oklahoma | 40117 | 1553 | 28 |
1007028 | 1007028 | 2021-02-07 | Pawnee | Oklahoma | 40117 | 1545 | 28 |
1003782 | 1003782 | 2021-02-06 | Pawnee | Oklahoma | 40117 | 1538 | 27 |
1000536 | 1000536 | 2021-02-05 | Pawnee | Oklahoma | 40117 | 1525 | 25 |
997290 | 997290 | 2021-02-04 | Pawnee | Oklahoma | 40117 | 1514 | 25 |
994044 | 994044 | 2021-02-03 | Pawnee | Oklahoma | 40117 | 1499 | 25 |
990798 | 990798 | 2021-02-02 | Pawnee | Oklahoma | 40117 | 1492 | 25 |
987552 | 987552 | 2021-02-01 | Pawnee | Oklahoma | 40117 | 1485 | 24 |
984305 | 984305 | 2021-01-31 | Pawnee | Oklahoma | 40117 | 1479 | 23 |
981058 | 981058 | 2021-01-30 | Pawnee | Oklahoma | 40117 | 1459 | 23 |
977812 | 977812 | 2021-01-29 | Pawnee | Oklahoma | 40117 | 1455 | 23 |
974567 | 974567 | 2021-01-28 | Pawnee | Oklahoma | 40117 | 1444 | 21 |
971322 | 971322 | 2021-01-27 | Pawnee | Oklahoma | 40117 | 1436 | 21 |
968077 | 968077 | 2021-01-26 | Pawnee | Oklahoma | 40117 | 1423 | 19 |
964833 | 964833 | 2021-01-25 | Pawnee | Oklahoma | 40117 | 1423 | 19 |
961588 | 961588 | 2021-01-24 | Pawnee | Oklahoma | 40117 | 1414 | 19 |
958343 | 958343 | 2021-01-23 | Pawnee | Oklahoma | 40117 | 1402 | 18 |
955097 | 955097 | 2021-01-22 | Pawnee | Oklahoma | 40117 | 1388 | 18 |
951852 | 951852 | 2021-01-21 | Pawnee | Oklahoma | 40117 | 1379 | 18 |
948607 | 948607 | 2021-01-20 | Pawnee | Oklahoma | 40117 | 1370 | 18 |
945361 | 945361 | 2021-01-19 | Pawnee | Oklahoma | 40117 | 1363 | 18 |
942114 | 942114 | 2021-01-18 | Pawnee | Oklahoma | 40117 | 1355 | 17 |
938869 | 938869 | 2021-01-17 | Pawnee | Oklahoma | 40117 | 1346 | 17 |
935624 | 935624 | 2021-01-16 | Pawnee | Oklahoma | 40117 | 1331 | 17 |
932379 | 932379 | 2021-01-15 | Pawnee | Oklahoma | 40117 | 1306 | 17 |
929134 | 929134 | 2021-01-14 | Pawnee | Oklahoma | 40117 | 1286 | 17 |
925889 | 925889 | 2021-01-13 | Pawnee | Oklahoma | 40117 | 1272 | 17 |
922643 | 922643 | 2021-01-12 | Pawnee | Oklahoma | 40117 | 1262 | 16 |
919398 | 919398 | 2021-01-11 | Pawnee | Oklahoma | 40117 | 1252 | 16 |
916153 | 916153 | 2021-01-10 | Pawnee | Oklahoma | 40117 | 1237 | 16 |
912908 | 912908 | 2021-01-09 | Pawnee | Oklahoma | 40117 | 1209 | 16 |
909663 | 909663 | 2021-01-08 | Pawnee | Oklahoma | 40117 | 1187 | 15 |
906418 | 906418 | 2021-01-07 | Pawnee | Oklahoma | 40117 | 1170 | 14 |
903172 | 903172 | 2021-01-06 | Pawnee | Oklahoma | 40117 | 1143 | 14 |
899927 | 899927 | 2021-01-05 | Pawnee | Oklahoma | 40117 | 1129 | 14 |
896682 | 896682 | 2021-01-04 | Pawnee | Oklahoma | 40117 | 1124 | 13 |
893436 | 893436 | 2021-01-03 | Pawnee | Oklahoma | 40117 | 1115 | 13 |
890190 | 890190 | 2021-01-02 | Pawnee | Oklahoma | 40117 | 1080 | 13 |
886943 | 886943 | 2021-01-01 | Pawnee | Oklahoma | 40117 | 1065 | 12 |
883698 | 883698 | 2020-12-31 | Pawnee | Oklahoma | 40117 | 1065 | 12 |
880453 | 880453 | 2020-12-30 | Pawnee | Oklahoma | 40117 | 1046 | 11 |
877208 | 877208 | 2020-12-29 | Pawnee | Oklahoma | 40117 | 989 | 10 |
873963 | 873963 | 2020-12-28 | Pawnee | Oklahoma | 40117 | 989 | 10 |
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);