ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
125 rows where county = "Grant" and deaths = 27 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- West Virginia 69
- Kansas 23
- Kentucky 9
- Indiana 8
- Arkansas 7
- Washington 5
- Louisiana 3
- Wisconsin 1
county 1
- Grant · 125 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946537 | 946537 | 2021-01-20 | Grant | Arkansas | 5053 | 1296 | 27 |
949783 | 949783 | 2021-01-21 | Grant | Arkansas | 5053 | 1313 | 27 |
953028 | 953028 | 2021-01-22 | Grant | Arkansas | 5053 | 1319 | 27 |
956273 | 956273 | 2021-01-23 | Grant | Arkansas | 5053 | 1327 | 27 |
959519 | 959519 | 2021-01-24 | Grant | Arkansas | 5053 | 1333 | 27 |
962764 | 962764 | 2021-01-25 | Grant | Arkansas | 5053 | 1335 | 27 |
966009 | 966009 | 2021-01-26 | Grant | Arkansas | 5053 | 1338 | 27 |
228420 | 228420 | 2020-06-11 | Grant | Indiana | 18053 | 317 | 27 |
231523 | 231523 | 2020-06-12 | Grant | Indiana | 18053 | 320 | 27 |
234629 | 234629 | 2020-06-13 | Grant | Indiana | 18053 | 326 | 27 |
237736 | 237736 | 2020-06-14 | Grant | Indiana | 18053 | 328 | 27 |
240844 | 240844 | 2020-06-15 | Grant | Indiana | 18053 | 329 | 27 |
243955 | 243955 | 2020-06-16 | Grant | Indiana | 18053 | 331 | 27 |
247068 | 247068 | 2020-06-17 | Grant | Indiana | 18053 | 334 | 27 |
250180 | 250180 | 2020-06-18 | Grant | Indiana | 18053 | 341 | 27 |
1788303 | 1788303 | 2021-10-06 | Grant | Kansas | 20067 | 1175 | 27 |
1791552 | 1791552 | 2021-10-07 | Grant | Kansas | 20067 | 1181 | 27 |
1794800 | 1794800 | 2021-10-08 | Grant | Kansas | 20067 | 1181 | 27 |
1798049 | 1798049 | 2021-10-09 | Grant | Kansas | 20067 | 1181 | 27 |
1801298 | 1801298 | 2021-10-10 | Grant | Kansas | 20067 | 1181 | 27 |
1804547 | 1804547 | 2021-10-11 | Grant | Kansas | 20067 | 1197 | 27 |
1807798 | 1807798 | 2021-10-12 | Grant | Kansas | 20067 | 1197 | 27 |
1811047 | 1811047 | 2021-10-13 | Grant | Kansas | 20067 | 1197 | 27 |
1814296 | 1814296 | 2021-10-14 | Grant | Kansas | 20067 | 1197 | 27 |
1817544 | 1817544 | 2021-10-15 | Grant | Kansas | 20067 | 1202 | 27 |
1820793 | 1820793 | 2021-10-16 | Grant | Kansas | 20067 | 1202 | 27 |
1824042 | 1824042 | 2021-10-17 | Grant | Kansas | 20067 | 1202 | 27 |
1827291 | 1827291 | 2021-10-18 | Grant | Kansas | 20067 | 1212 | 27 |
1830540 | 1830540 | 2021-10-19 | Grant | Kansas | 20067 | 1238 | 27 |
1833789 | 1833789 | 2021-10-20 | Grant | Kansas | 20067 | 1241 | 27 |
1837038 | 1837038 | 2021-10-21 | Grant | Kansas | 20067 | 1244 | 27 |
1840287 | 1840287 | 2021-10-22 | Grant | Kansas | 20067 | 1244 | 27 |
1843537 | 1843537 | 2021-10-23 | Grant | Kansas | 20067 | 1244 | 27 |
1846787 | 1846787 | 2021-10-24 | Grant | Kansas | 20067 | 1244 | 27 |
1850037 | 1850037 | 2021-10-25 | Grant | Kansas | 20067 | 1255 | 27 |
1853286 | 1853286 | 2021-10-26 | Grant | Kansas | 20067 | 1261 | 27 |
1856535 | 1856535 | 2021-10-27 | Grant | Kansas | 20067 | 1265 | 27 |
1859784 | 1859784 | 2021-10-28 | Grant | Kansas | 20067 | 1267 | 27 |
1668208 | 1668208 | 2021-08-30 | Grant | Kentucky | 21081 | 3185 | 27 |
1671455 | 1671455 | 2021-08-31 | Grant | Kentucky | 21081 | 3207 | 27 |
1674704 | 1674704 | 2021-09-01 | Grant | Kentucky | 21081 | 3231 | 27 |
1677951 | 1677951 | 2021-09-02 | Grant | Kentucky | 21081 | 3247 | 27 |
1681199 | 1681199 | 2021-09-03 | Grant | Kentucky | 21081 | 3280 | 27 |
1684450 | 1684450 | 2021-09-04 | Grant | Kentucky | 21081 | 3280 | 27 |
1687700 | 1687700 | 2021-09-05 | Grant | Kentucky | 21081 | 3280 | 27 |
1690950 | 1690950 | 2021-09-06 | Grant | Kentucky | 21081 | 3280 | 27 |
1694199 | 1694199 | 2021-09-07 | Grant | Kentucky | 21081 | 3367 | 27 |
477345 | 477345 | 2020-08-28 | Grant | Louisiana | 22043 | 406 | 27 |
480578 | 480578 | 2020-08-29 | Grant | Louisiana | 22043 | 406 | 27 |
483812 | 483812 | 2020-08-30 | Grant | Louisiana | 22043 | 430 | 27 |
680130 | 680130 | 2020-10-29 | Grant | Washington | 53025 | 3555 | 27 |
683373 | 683373 | 2020-10-30 | Grant | Washington | 53025 | 3571 | 27 |
686616 | 686616 | 2020-10-31 | Grant | Washington | 53025 | 3571 | 27 |
689861 | 689861 | 2020-11-01 | Grant | Washington | 53025 | 3571 | 27 |
693105 | 693105 | 2020-11-02 | Grant | Washington | 53025 | 3614 | 27 |
1115038 | 1115038 | 2021-03-12 | Grant | West Virginia | 54023 | 1124 | 27 |
1118285 | 1118285 | 2021-03-13 | Grant | West Virginia | 54023 | 1126 | 27 |
1121532 | 1121532 | 2021-03-14 | Grant | West Virginia | 54023 | 1127 | 27 |
1124778 | 1124778 | 2021-03-15 | Grant | West Virginia | 54023 | 1132 | 27 |
1128024 | 1128024 | 2021-03-16 | Grant | West Virginia | 54023 | 1139 | 27 |
1131271 | 1131271 | 2021-03-17 | Grant | West Virginia | 54023 | 1139 | 27 |
1134519 | 1134519 | 2021-03-18 | Grant | West Virginia | 54023 | 1142 | 27 |
1137765 | 1137765 | 2021-03-19 | Grant | West Virginia | 54023 | 1146 | 27 |
1141011 | 1141011 | 2021-03-20 | Grant | West Virginia | 54023 | 1149 | 27 |
1144258 | 1144258 | 2021-03-21 | Grant | West Virginia | 54023 | 1149 | 27 |
1147505 | 1147505 | 2021-03-22 | Grant | West Virginia | 54023 | 1152 | 27 |
1150752 | 1150752 | 2021-03-23 | Grant | West Virginia | 54023 | 1155 | 27 |
1153999 | 1153999 | 2021-03-24 | Grant | West Virginia | 54023 | 1155 | 27 |
1157246 | 1157246 | 2021-03-25 | Grant | West Virginia | 54023 | 1159 | 27 |
1160494 | 1160494 | 2021-03-26 | Grant | West Virginia | 54023 | 1161 | 27 |
1163742 | 1163742 | 2021-03-27 | Grant | West Virginia | 54023 | 1163 | 27 |
1166990 | 1166990 | 2021-03-28 | Grant | West Virginia | 54023 | 1163 | 27 |
1170238 | 1170238 | 2021-03-29 | Grant | West Virginia | 54023 | 1166 | 27 |
1173485 | 1173485 | 2021-03-30 | Grant | West Virginia | 54023 | 1167 | 27 |
1176732 | 1176732 | 2021-03-31 | Grant | West Virginia | 54023 | 1169 | 27 |
1179979 | 1179979 | 2021-04-01 | Grant | West Virginia | 54023 | 1175 | 27 |
1183226 | 1183226 | 2021-04-02 | Grant | West Virginia | 54023 | 1179 | 27 |
1186473 | 1186473 | 2021-04-03 | Grant | West Virginia | 54023 | 1185 | 27 |
1189720 | 1189720 | 2021-04-04 | Grant | West Virginia | 54023 | 1188 | 27 |
1192970 | 1192970 | 2021-04-05 | Grant | West Virginia | 54023 | 1203 | 27 |
1196218 | 1196218 | 2021-04-06 | Grant | West Virginia | 54023 | 1205 | 27 |
1264417 | 1264417 | 2021-04-27 | Grant | West Virginia | 54023 | 1249 | 27 |
1267664 | 1267664 | 2021-04-28 | Grant | West Virginia | 54023 | 1251 | 27 |
1270911 | 1270911 | 2021-04-29 | Grant | West Virginia | 54023 | 1255 | 27 |
1274158 | 1274158 | 2021-04-30 | Grant | West Virginia | 54023 | 1261 | 27 |
1277405 | 1277405 | 2021-05-01 | Grant | West Virginia | 54023 | 1262 | 27 |
1280652 | 1280652 | 2021-05-02 | Grant | West Virginia | 54023 | 1266 | 27 |
1283899 | 1283899 | 2021-05-03 | Grant | West Virginia | 54023 | 1268 | 27 |
1287145 | 1287145 | 2021-05-04 | Grant | West Virginia | 54023 | 1270 | 27 |
1290391 | 1290391 | 2021-05-05 | Grant | West Virginia | 54023 | 1271 | 27 |
1293637 | 1293637 | 2021-05-06 | Grant | West Virginia | 54023 | 1271 | 27 |
1296883 | 1296883 | 2021-05-07 | Grant | West Virginia | 54023 | 1271 | 27 |
1300130 | 1300130 | 2021-05-08 | Grant | West Virginia | 54023 | 1272 | 27 |
1303377 | 1303377 | 2021-05-09 | Grant | West Virginia | 54023 | 1276 | 27 |
1306623 | 1306623 | 2021-05-10 | Grant | West Virginia | 54023 | 1276 | 27 |
1309869 | 1309869 | 2021-05-11 | Grant | West Virginia | 54023 | 1276 | 27 |
1313116 | 1313116 | 2021-05-12 | Grant | West Virginia | 54023 | 1278 | 27 |
1316362 | 1316362 | 2021-05-13 | Grant | West Virginia | 54023 | 1279 | 27 |
1335842 | 1335842 | 2021-05-19 | Grant | West Virginia | 54023 | 1275 | 27 |
1339089 | 1339089 | 2021-05-20 | Grant | West Virginia | 54023 | 1277 | 27 |
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);