ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Nowata" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195310 | 1195310 | 2021-04-06 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1192062 | 1192062 | 2021-04-05 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1188813 | 1188813 | 2021-04-04 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1185566 | 1185566 | 2021-04-03 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1182319 | 1182319 | 2021-04-02 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1179072 | 1179072 | 2021-04-01 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1175825 | 1175825 | 2021-03-31 | Nowata | Oklahoma | 40105 | 1126 | 16 |
1172578 | 1172578 | 2021-03-30 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1169331 | 1169331 | 2021-03-29 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1166083 | 1166083 | 2021-03-28 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1162835 | 1162835 | 2021-03-27 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1159586 | 1159586 | 2021-03-26 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1156339 | 1156339 | 2021-03-25 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1153092 | 1153092 | 2021-03-24 | Nowata | Oklahoma | 40105 | 1123 | 16 |
1149845 | 1149845 | 2021-03-23 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1146598 | 1146598 | 2021-03-22 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1143351 | 1143351 | 2021-03-21 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1140104 | 1140104 | 2021-03-20 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1136858 | 1136858 | 2021-03-19 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1133612 | 1133612 | 2021-03-18 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1130364 | 1130364 | 2021-03-17 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1127117 | 1127117 | 2021-03-16 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1123871 | 1123871 | 2021-03-15 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1120625 | 1120625 | 2021-03-14 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1117378 | 1117378 | 2021-03-13 | Nowata | Oklahoma | 40105 | 1119 | 16 |
1114131 | 1114131 | 2021-03-12 | Nowata | Oklahoma | 40105 | 1118 | 16 |
1110885 | 1110885 | 2021-03-11 | Nowata | Oklahoma | 40105 | 1116 | 16 |
1107639 | 1107639 | 2021-03-10 | Nowata | Oklahoma | 40105 | 1115 | 16 |
1104393 | 1104393 | 2021-03-09 | Nowata | Oklahoma | 40105 | 1114 | 16 |
1101147 | 1101147 | 2021-03-08 | Nowata | Oklahoma | 40105 | 1113 | 16 |
1097901 | 1097901 | 2021-03-07 | Nowata | Oklahoma | 40105 | 1113 | 16 |
1094653 | 1094653 | 2021-03-06 | Nowata | Oklahoma | 40105 | 1112 | 16 |
1091407 | 1091407 | 2021-03-05 | Nowata | Oklahoma | 40105 | 1109 | 16 |
1088161 | 1088161 | 2021-03-04 | Nowata | Oklahoma | 40105 | 1101 | 16 |
1084916 | 1084916 | 2021-03-03 | Nowata | Oklahoma | 40105 | 1101 | 16 |
1081670 | 1081670 | 2021-03-02 | Nowata | Oklahoma | 40105 | 1100 | 16 |
1078424 | 1078424 | 2021-03-01 | Nowata | Oklahoma | 40105 | 1099 | 16 |
1075179 | 1075179 | 2021-02-28 | Nowata | Oklahoma | 40105 | 1098 | 16 |
1071933 | 1071933 | 2021-02-27 | Nowata | Oklahoma | 40105 | 1093 | 16 |
1068687 | 1068687 | 2021-02-26 | Nowata | Oklahoma | 40105 | 1095 | 15 |
1065442 | 1065442 | 2021-02-25 | Nowata | Oklahoma | 40105 | 1094 | 15 |
1062198 | 1062198 | 2021-02-24 | Nowata | Oklahoma | 40105 | 1088 | 15 |
1058952 | 1058952 | 2021-02-23 | Nowata | Oklahoma | 40105 | 1085 | 15 |
1055706 | 1055706 | 2021-02-22 | Nowata | Oklahoma | 40105 | 1084 | 15 |
1052460 | 1052460 | 2021-02-21 | Nowata | Oklahoma | 40105 | 1080 | 15 |
1049213 | 1049213 | 2021-02-20 | Nowata | Oklahoma | 40105 | 1078 | 15 |
1045966 | 1045966 | 2021-02-19 | Nowata | Oklahoma | 40105 | 1079 | 15 |
1042721 | 1042721 | 2021-02-18 | Nowata | Oklahoma | 40105 | 1076 | 15 |
1039476 | 1039476 | 2021-02-17 | Nowata | Oklahoma | 40105 | 1073 | 15 |
1036231 | 1036231 | 2021-02-16 | Nowata | Oklahoma | 40105 | 1066 | 15 |
1032986 | 1032986 | 2021-02-15 | Nowata | Oklahoma | 40105 | 1065 | 15 |
1029740 | 1029740 | 2021-02-14 | Nowata | Oklahoma | 40105 | 1063 | 15 |
1026493 | 1026493 | 2021-02-13 | Nowata | Oklahoma | 40105 | 1057 | 15 |
1023248 | 1023248 | 2021-02-12 | Nowata | Oklahoma | 40105 | 1054 | 15 |
1020003 | 1020003 | 2021-02-11 | Nowata | Oklahoma | 40105 | 1048 | 15 |
1016758 | 1016758 | 2021-02-10 | Nowata | Oklahoma | 40105 | 1047 | 15 |
1013513 | 1013513 | 2021-02-09 | Nowata | Oklahoma | 40105 | 1044 | 15 |
1010268 | 1010268 | 2021-02-08 | Nowata | Oklahoma | 40105 | 1043 | 15 |
1007022 | 1007022 | 2021-02-07 | Nowata | Oklahoma | 40105 | 1041 | 15 |
1003776 | 1003776 | 2021-02-06 | Nowata | Oklahoma | 40105 | 1039 | 14 |
1000530 | 1000530 | 2021-02-05 | Nowata | Oklahoma | 40105 | 1036 | 14 |
997284 | 997284 | 2021-02-04 | Nowata | Oklahoma | 40105 | 1030 | 14 |
994038 | 994038 | 2021-02-03 | Nowata | Oklahoma | 40105 | 1024 | 14 |
990792 | 990792 | 2021-02-02 | Nowata | Oklahoma | 40105 | 1011 | 14 |
987546 | 987546 | 2021-02-01 | Nowata | Oklahoma | 40105 | 1008 | 14 |
984299 | 984299 | 2021-01-31 | Nowata | Oklahoma | 40105 | 1007 | 14 |
981052 | 981052 | 2021-01-30 | Nowata | Oklahoma | 40105 | 995 | 14 |
977806 | 977806 | 2021-01-29 | Nowata | Oklahoma | 40105 | 985 | 14 |
974561 | 974561 | 2021-01-28 | Nowata | Oklahoma | 40105 | 979 | 13 |
971316 | 971316 | 2021-01-27 | Nowata | Oklahoma | 40105 | 968 | 12 |
968071 | 968071 | 2021-01-26 | Nowata | Oklahoma | 40105 | 959 | 12 |
964827 | 964827 | 2021-01-25 | Nowata | Oklahoma | 40105 | 957 | 12 |
961582 | 961582 | 2021-01-24 | Nowata | Oklahoma | 40105 | 954 | 12 |
958337 | 958337 | 2021-01-23 | Nowata | Oklahoma | 40105 | 952 | 12 |
955091 | 955091 | 2021-01-22 | Nowata | Oklahoma | 40105 | 939 | 12 |
951846 | 951846 | 2021-01-21 | Nowata | Oklahoma | 40105 | 928 | 12 |
948601 | 948601 | 2021-01-20 | Nowata | Oklahoma | 40105 | 917 | 12 |
945355 | 945355 | 2021-01-19 | Nowata | Oklahoma | 40105 | 912 | 12 |
942108 | 942108 | 2021-01-18 | Nowata | Oklahoma | 40105 | 906 | 11 |
938863 | 938863 | 2021-01-17 | Nowata | Oklahoma | 40105 | 902 | 11 |
935618 | 935618 | 2021-01-16 | Nowata | Oklahoma | 40105 | 883 | 11 |
932373 | 932373 | 2021-01-15 | Nowata | Oklahoma | 40105 | 871 | 11 |
929128 | 929128 | 2021-01-14 | Nowata | Oklahoma | 40105 | 853 | 10 |
925883 | 925883 | 2021-01-13 | Nowata | Oklahoma | 40105 | 842 | 10 |
922637 | 922637 | 2021-01-12 | Nowata | Oklahoma | 40105 | 830 | 10 |
919392 | 919392 | 2021-01-11 | Nowata | Oklahoma | 40105 | 821 | 10 |
916147 | 916147 | 2021-01-10 | Nowata | Oklahoma | 40105 | 813 | 10 |
912902 | 912902 | 2021-01-09 | Nowata | Oklahoma | 40105 | 801 | 10 |
909657 | 909657 | 2021-01-08 | Nowata | Oklahoma | 40105 | 788 | 10 |
906412 | 906412 | 2021-01-07 | Nowata | Oklahoma | 40105 | 761 | 10 |
903166 | 903166 | 2021-01-06 | Nowata | Oklahoma | 40105 | 751 | 10 |
899921 | 899921 | 2021-01-05 | Nowata | Oklahoma | 40105 | 739 | 9 |
896676 | 896676 | 2021-01-04 | Nowata | Oklahoma | 40105 | 737 | 9 |
893430 | 893430 | 2021-01-03 | Nowata | Oklahoma | 40105 | 726 | 9 |
890184 | 890184 | 2021-01-02 | Nowata | Oklahoma | 40105 | 699 | 9 |
886937 | 886937 | 2021-01-01 | Nowata | Oklahoma | 40105 | 681 | 9 |
883692 | 883692 | 2020-12-31 | Nowata | Oklahoma | 40105 | 681 | 9 |
880447 | 880447 | 2020-12-30 | Nowata | Oklahoma | 40105 | 672 | 8 |
877202 | 877202 | 2020-12-29 | Nowata | Oklahoma | 40105 | 663 | 8 |
873957 | 873957 | 2020-12-28 | Nowata | Oklahoma | 40105 | 660 | 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);