ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,546 rows where county = "Craig" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195275 | 1195275 | 2021-04-06 | Craig | Oklahoma | 40035 | 1936 | 12 |
1196064 | 1196064 | 2021-04-06 | Craig | Virginia | 51045 | 277 | 5 |
1192027 | 1192027 | 2021-04-05 | Craig | Oklahoma | 40035 | 1936 | 12 |
1192816 | 1192816 | 2021-04-05 | Craig | Virginia | 51045 | 276 | 5 |
1188778 | 1188778 | 2021-04-04 | Craig | Oklahoma | 40035 | 1936 | 12 |
1189566 | 1189566 | 2021-04-04 | Craig | Virginia | 51045 | 276 | 5 |
1185531 | 1185531 | 2021-04-03 | Craig | Oklahoma | 40035 | 1936 | 12 |
1186319 | 1186319 | 2021-04-03 | Craig | Virginia | 51045 | 274 | 5 |
1182284 | 1182284 | 2021-04-02 | Craig | Oklahoma | 40035 | 1936 | 12 |
1183072 | 1183072 | 2021-04-02 | Craig | Virginia | 51045 | 273 | 5 |
1179037 | 1179037 | 2021-04-01 | Craig | Oklahoma | 40035 | 1936 | 12 |
1179825 | 1179825 | 2021-04-01 | Craig | Virginia | 51045 | 273 | 5 |
1175790 | 1175790 | 2021-03-31 | Craig | Oklahoma | 40035 | 1936 | 12 |
1176578 | 1176578 | 2021-03-31 | Craig | Virginia | 51045 | 272 | 5 |
1172543 | 1172543 | 2021-03-30 | Craig | Oklahoma | 40035 | 1932 | 11 |
1173331 | 1173331 | 2021-03-30 | Craig | Virginia | 51045 | 270 | 5 |
1169296 | 1169296 | 2021-03-29 | Craig | Oklahoma | 40035 | 1932 | 11 |
1170084 | 1170084 | 2021-03-29 | Craig | Virginia | 51045 | 270 | 5 |
1166048 | 1166048 | 2021-03-28 | Craig | Oklahoma | 40035 | 1932 | 11 |
1166836 | 1166836 | 2021-03-28 | Craig | Virginia | 51045 | 269 | 5 |
1162800 | 1162800 | 2021-03-27 | Craig | Oklahoma | 40035 | 1932 | 11 |
1163588 | 1163588 | 2021-03-27 | Craig | Virginia | 51045 | 268 | 5 |
1159551 | 1159551 | 2021-03-26 | Craig | Oklahoma | 40035 | 1932 | 11 |
1160340 | 1160340 | 2021-03-26 | Craig | Virginia | 51045 | 265 | 5 |
1156304 | 1156304 | 2021-03-25 | Craig | Oklahoma | 40035 | 1932 | 11 |
1157092 | 1157092 | 2021-03-25 | Craig | Virginia | 51045 | 264 | 5 |
1153057 | 1153057 | 2021-03-24 | Craig | Oklahoma | 40035 | 1932 | 11 |
1153845 | 1153845 | 2021-03-24 | Craig | Virginia | 51045 | 264 | 5 |
1149810 | 1149810 | 2021-03-23 | Craig | Oklahoma | 40035 | 1916 | 11 |
1150598 | 1150598 | 2021-03-23 | Craig | Virginia | 51045 | 260 | 5 |
1146563 | 1146563 | 2021-03-22 | Craig | Oklahoma | 40035 | 1916 | 11 |
1147351 | 1147351 | 2021-03-22 | Craig | Virginia | 51045 | 258 | 5 |
1143316 | 1143316 | 2021-03-21 | Craig | Oklahoma | 40035 | 1916 | 11 |
1144104 | 1144104 | 2021-03-21 | Craig | Virginia | 51045 | 257 | 5 |
1140069 | 1140069 | 2021-03-20 | Craig | Oklahoma | 40035 | 1916 | 11 |
1140857 | 1140857 | 2021-03-20 | Craig | Virginia | 51045 | 255 | 5 |
1136823 | 1136823 | 2021-03-19 | Craig | Oklahoma | 40035 | 1916 | 11 |
1137611 | 1137611 | 2021-03-19 | Craig | Virginia | 51045 | 254 | 5 |
1133577 | 1133577 | 2021-03-18 | Craig | Oklahoma | 40035 | 1916 | 11 |
1134365 | 1134365 | 2021-03-18 | Craig | Virginia | 51045 | 251 | 5 |
1130329 | 1130329 | 2021-03-17 | Craig | Oklahoma | 40035 | 1916 | 11 |
1131117 | 1131117 | 2021-03-17 | Craig | Virginia | 51045 | 250 | 5 |
1127082 | 1127082 | 2021-03-16 | Craig | Oklahoma | 40035 | 1916 | 11 |
1127870 | 1127870 | 2021-03-16 | Craig | Virginia | 51045 | 248 | 5 |
1123836 | 1123836 | 2021-03-15 | Craig | Oklahoma | 40035 | 1916 | 11 |
1124624 | 1124624 | 2021-03-15 | Craig | Virginia | 51045 | 249 | 5 |
1120590 | 1120590 | 2021-03-14 | Craig | Oklahoma | 40035 | 1914 | 11 |
1121378 | 1121378 | 2021-03-14 | Craig | Virginia | 51045 | 249 | 5 |
1117343 | 1117343 | 2021-03-13 | Craig | Oklahoma | 40035 | 1911 | 11 |
1118131 | 1118131 | 2021-03-13 | Craig | Virginia | 51045 | 248 | 5 |
1114096 | 1114096 | 2021-03-12 | Craig | Oklahoma | 40035 | 1910 | 11 |
1114884 | 1114884 | 2021-03-12 | Craig | Virginia | 51045 | 246 | 5 |
1110850 | 1110850 | 2021-03-11 | Craig | Oklahoma | 40035 | 1905 | 11 |
1111638 | 1111638 | 2021-03-11 | Craig | Virginia | 51045 | 246 | 5 |
1107604 | 1107604 | 2021-03-10 | Craig | Oklahoma | 40035 | 1904 | 11 |
1108392 | 1108392 | 2021-03-10 | Craig | Virginia | 51045 | 247 | 6 |
1104358 | 1104358 | 2021-03-09 | Craig | Oklahoma | 40035 | 1900 | 11 |
1105146 | 1105146 | 2021-03-09 | Craig | Virginia | 51045 | 247 | 6 |
1101112 | 1101112 | 2021-03-08 | Craig | Oklahoma | 40035 | 1898 | 11 |
1101900 | 1101900 | 2021-03-08 | Craig | Virginia | 51045 | 246 | 6 |
1097866 | 1097866 | 2021-03-07 | Craig | Oklahoma | 40035 | 1898 | 11 |
1098654 | 1098654 | 2021-03-07 | Craig | Virginia | 51045 | 246 | 6 |
1094618 | 1094618 | 2021-03-06 | Craig | Oklahoma | 40035 | 1899 | 11 |
1095406 | 1095406 | 2021-03-06 | Craig | Virginia | 51045 | 246 | 6 |
1091372 | 1091372 | 2021-03-05 | Craig | Oklahoma | 40035 | 1897 | 11 |
1092160 | 1092160 | 2021-03-05 | Craig | Virginia | 51045 | 243 | 5 |
1088126 | 1088126 | 2021-03-04 | Craig | Oklahoma | 40035 | 1896 | 11 |
1088914 | 1088914 | 2021-03-04 | Craig | Virginia | 51045 | 241 | 5 |
1084881 | 1084881 | 2021-03-03 | Craig | Oklahoma | 40035 | 1893 | 11 |
1085669 | 1085669 | 2021-03-03 | Craig | Virginia | 51045 | 241 | 5 |
1081635 | 1081635 | 2021-03-02 | Craig | Oklahoma | 40035 | 1892 | 11 |
1082423 | 1082423 | 2021-03-02 | Craig | Virginia | 51045 | 241 | 5 |
1078389 | 1078389 | 2021-03-01 | Craig | Oklahoma | 40035 | 1892 | 11 |
1079177 | 1079177 | 2021-03-01 | Craig | Virginia | 51045 | 241 | 5 |
1075144 | 1075144 | 2021-02-28 | Craig | Oklahoma | 40035 | 1892 | 11 |
1075932 | 1075932 | 2021-02-28 | Craig | Virginia | 51045 | 241 | 4 |
1071898 | 1071898 | 2021-02-27 | Craig | Oklahoma | 40035 | 1890 | 11 |
1072686 | 1072686 | 2021-02-27 | Craig | Virginia | 51045 | 240 | 4 |
1068652 | 1068652 | 2021-02-26 | Craig | Oklahoma | 40035 | 1888 | 11 |
1069440 | 1069440 | 2021-02-26 | Craig | Virginia | 51045 | 240 | 4 |
1065407 | 1065407 | 2021-02-25 | Craig | Oklahoma | 40035 | 1884 | 11 |
1066195 | 1066195 | 2021-02-25 | Craig | Virginia | 51045 | 237 | 4 |
1062163 | 1062163 | 2021-02-24 | Craig | Oklahoma | 40035 | 1884 | 11 |
1062950 | 1062950 | 2021-02-24 | Craig | Virginia | 51045 | 238 | 4 |
1058917 | 1058917 | 2021-02-23 | Craig | Oklahoma | 40035 | 1880 | 11 |
1059705 | 1059705 | 2021-02-23 | Craig | Virginia | 51045 | 238 | 4 |
1055671 | 1055671 | 2021-02-22 | Craig | Oklahoma | 40035 | 1878 | 11 |
1056459 | 1056459 | 2021-02-22 | Craig | Virginia | 51045 | 236 | 4 |
1052425 | 1052425 | 2021-02-21 | Craig | Oklahoma | 40035 | 1878 | 11 |
1053213 | 1053213 | 2021-02-21 | Craig | Virginia | 51045 | 236 | 3 |
1049178 | 1049178 | 2021-02-20 | Craig | Oklahoma | 40035 | 1877 | 11 |
1049966 | 1049966 | 2021-02-20 | Craig | Virginia | 51045 | 236 | 3 |
1045931 | 1045931 | 2021-02-19 | Craig | Oklahoma | 40035 | 1876 | 11 |
1046719 | 1046719 | 2021-02-19 | Craig | Virginia | 51045 | 234 | 3 |
1042686 | 1042686 | 2021-02-18 | Craig | Oklahoma | 40035 | 1874 | 11 |
1043474 | 1043474 | 2021-02-18 | Craig | Virginia | 51045 | 231 | 3 |
1039441 | 1039441 | 2021-02-17 | Craig | Oklahoma | 40035 | 1874 | 11 |
1040229 | 1040229 | 2021-02-17 | Craig | Virginia | 51045 | 230 | 3 |
1036196 | 1036196 | 2021-02-16 | Craig | Oklahoma | 40035 | 1873 | 11 |
1036984 | 1036984 | 2021-02-16 | Craig | Virginia | 51045 | 230 | 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);