ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where county = "Grant" and deaths = 29 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- West Virginia 66
- Indiana 24
- Kentucky 19
- Kansas 12
- Washington 7
- Arkansas 3
- Wisconsin 3
- New Mexico 1
county 1
- Grant · 135 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
995220 | 995220 | 2021-02-04 | Grant | Arkansas | 5053 | 1460 | 29 |
998466 | 998466 | 2021-02-05 | Grant | Arkansas | 5053 | 1478 | 29 |
1001712 | 1001712 | 2021-02-06 | Grant | Arkansas | 5053 | 1483 | 29 |
262668 | 262668 | 2020-06-22 | Grant | Indiana | 18053 | 354 | 29 |
265796 | 265796 | 2020-06-23 | Grant | Indiana | 18053 | 361 | 29 |
268926 | 268926 | 2020-06-24 | Grant | Indiana | 18053 | 364 | 29 |
272063 | 272063 | 2020-06-25 | Grant | Indiana | 18053 | 364 | 29 |
275205 | 275205 | 2020-06-26 | Grant | Indiana | 18053 | 371 | 29 |
278353 | 278353 | 2020-06-27 | Grant | Indiana | 18053 | 368 | 29 |
281501 | 281501 | 2020-06-28 | Grant | Indiana | 18053 | 373 | 29 |
284646 | 284646 | 2020-06-29 | Grant | Indiana | 18053 | 374 | 29 |
287795 | 287795 | 2020-06-30 | Grant | Indiana | 18053 | 376 | 29 |
290945 | 290945 | 2020-07-01 | Grant | Indiana | 18053 | 385 | 29 |
294099 | 294099 | 2020-07-02 | Grant | Indiana | 18053 | 387 | 29 |
297257 | 297257 | 2020-07-03 | Grant | Indiana | 18053 | 391 | 29 |
300419 | 300419 | 2020-07-04 | Grant | Indiana | 18053 | 398 | 29 |
303583 | 303583 | 2020-07-05 | Grant | Indiana | 18053 | 401 | 29 |
306748 | 306748 | 2020-07-06 | Grant | Indiana | 18053 | 402 | 29 |
309916 | 309916 | 2020-07-07 | Grant | Indiana | 18053 | 405 | 29 |
313086 | 313086 | 2020-07-08 | Grant | Indiana | 18053 | 414 | 29 |
316260 | 316260 | 2020-07-09 | Grant | Indiana | 18053 | 421 | 29 |
319433 | 319433 | 2020-07-10 | Grant | Indiana | 18053 | 428 | 29 |
322612 | 322612 | 2020-07-11 | Grant | Indiana | 18053 | 445 | 29 |
325793 | 325793 | 2020-07-12 | Grant | Indiana | 18053 | 449 | 29 |
328979 | 328979 | 2020-07-13 | Grant | Indiana | 18053 | 449 | 29 |
332166 | 332166 | 2020-07-14 | Grant | Indiana | 18053 | 476 | 29 |
335359 | 335359 | 2020-07-15 | Grant | Indiana | 18053 | 489 | 29 |
1863033 | 1863033 | 2021-10-29 | Grant | Kansas | 20067 | 1267 | 29 |
1866282 | 1866282 | 2021-10-30 | Grant | Kansas | 20067 | 1267 | 29 |
1869531 | 1869531 | 2021-10-31 | Grant | Kansas | 20067 | 1267 | 29 |
1872780 | 1872780 | 2021-11-01 | Grant | Kansas | 20067 | 1285 | 29 |
1876029 | 1876029 | 2021-11-02 | Grant | Kansas | 20067 | 1293 | 29 |
1879278 | 1879278 | 2021-11-03 | Grant | Kansas | 20067 | 1301 | 29 |
1882527 | 1882527 | 2021-11-04 | Grant | Kansas | 20067 | 1307 | 29 |
1885776 | 1885776 | 2021-11-05 | Grant | Kansas | 20067 | 1309 | 29 |
1889026 | 1889026 | 2021-11-06 | Grant | Kansas | 20067 | 1309 | 29 |
1892276 | 1892276 | 2021-11-07 | Grant | Kansas | 20067 | 1309 | 29 |
1895526 | 1895526 | 2021-11-08 | Grant | Kansas | 20067 | 1317 | 29 |
1898776 | 1898776 | 2021-11-09 | Grant | Kansas | 20067 | 1326 | 29 |
1700696 | 1700696 | 2021-09-09 | Grant | Kentucky | 21081 | 3413 | 29 |
1703946 | 1703946 | 2021-09-10 | Grant | Kentucky | 21081 | 3452 | 29 |
1707194 | 1707194 | 2021-09-11 | Grant | Kentucky | 21081 | 3452 | 29 |
1710441 | 1710441 | 2021-09-12 | Grant | Kentucky | 21081 | 3452 | 29 |
1713688 | 1713688 | 2021-09-13 | Grant | Kentucky | 21081 | 3510 | 29 |
1716934 | 1716934 | 2021-09-14 | Grant | Kentucky | 21081 | 3557 | 29 |
1720182 | 1720182 | 2021-09-15 | Grant | Kentucky | 21081 | 3592 | 29 |
1723431 | 1723431 | 2021-09-16 | Grant | Kentucky | 21081 | 3631 | 29 |
1726680 | 1726680 | 2021-09-17 | Grant | Kentucky | 21081 | 3665 | 29 |
1729930 | 1729930 | 2021-09-18 | Grant | Kentucky | 21081 | 3665 | 29 |
1733180 | 1733180 | 2021-09-19 | Grant | Kentucky | 21081 | 3665 | 29 |
1736430 | 1736430 | 2021-09-20 | Grant | Kentucky | 21081 | 3724 | 29 |
1739679 | 1739679 | 2021-09-21 | Grant | Kentucky | 21081 | 3751 | 29 |
1742928 | 1742928 | 2021-09-22 | Grant | Kentucky | 21081 | 3783 | 29 |
1746177 | 1746177 | 2021-09-23 | Grant | Kentucky | 21081 | 3816 | 29 |
1749427 | 1749427 | 2021-09-24 | Grant | Kentucky | 21081 | 3834 | 29 |
1752676 | 1752676 | 2021-09-25 | Grant | Kentucky | 21081 | 3834 | 29 |
1755924 | 1755924 | 2021-09-26 | Grant | Kentucky | 21081 | 3834 | 29 |
1759172 | 1759172 | 2021-09-27 | Grant | Kentucky | 21081 | 3901 | 29 |
993660 | 993660 | 2021-02-03 | Grant | New Mexico | 35017 | 1304 | 29 |
715809 | 715809 | 2020-11-09 | Grant | Washington | 53025 | 3788 | 29 |
719052 | 719052 | 2020-11-10 | Grant | Washington | 53025 | 3808 | 29 |
722295 | 722295 | 2020-11-11 | Grant | Washington | 53025 | 3808 | 29 |
725538 | 725538 | 2020-11-12 | Grant | Washington | 53025 | 3890 | 29 |
728781 | 728781 | 2020-11-13 | Grant | Washington | 53025 | 3958 | 29 |
732026 | 732026 | 2020-11-14 | Grant | Washington | 53025 | 3958 | 29 |
735272 | 735272 | 2020-11-15 | Grant | Washington | 53025 | 3958 | 29 |
1202715 | 1202715 | 2021-04-08 | Grant | West Virginia | 54023 | 1214 | 29 |
1205963 | 1205963 | 2021-04-09 | Grant | West Virginia | 54023 | 1219 | 29 |
1209211 | 1209211 | 2021-04-10 | Grant | West Virginia | 54023 | 1221 | 29 |
1212460 | 1212460 | 2021-04-11 | Grant | West Virginia | 54023 | 1223 | 29 |
1215707 | 1215707 | 2021-04-12 | Grant | West Virginia | 54023 | 1227 | 29 |
1218955 | 1218955 | 2021-04-13 | Grant | West Virginia | 54023 | 1232 | 29 |
1222203 | 1222203 | 2021-04-14 | Grant | West Virginia | 54023 | 1234 | 29 |
1225450 | 1225450 | 2021-04-15 | Grant | West Virginia | 54023 | 1237 | 29 |
1228698 | 1228698 | 2021-04-16 | Grant | West Virginia | 54023 | 1237 | 29 |
1231946 | 1231946 | 2021-04-17 | Grant | West Virginia | 54023 | 1240 | 29 |
1235194 | 1235194 | 2021-04-18 | Grant | West Virginia | 54023 | 1239 | 29 |
1238441 | 1238441 | 2021-04-19 | Grant | West Virginia | 54023 | 1241 | 29 |
1241688 | 1241688 | 2021-04-20 | Grant | West Virginia | 54023 | 1239 | 29 |
1244935 | 1244935 | 2021-04-21 | Grant | West Virginia | 54023 | 1240 | 29 |
1248182 | 1248182 | 2021-04-22 | Grant | West Virginia | 54023 | 1242 | 29 |
1251429 | 1251429 | 2021-04-23 | Grant | West Virginia | 54023 | 1243 | 29 |
1254676 | 1254676 | 2021-04-24 | Grant | West Virginia | 54023 | 1247 | 29 |
1257923 | 1257923 | 2021-04-25 | Grant | West Virginia | 54023 | 1248 | 29 |
1261170 | 1261170 | 2021-04-26 | Grant | West Virginia | 54023 | 1248 | 29 |
1546843 | 1546843 | 2021-07-23 | Grant | West Virginia | 54023 | 1322 | 29 |
1550090 | 1550090 | 2021-07-24 | Grant | West Virginia | 54023 | 1322 | 29 |
1553337 | 1553337 | 2021-07-25 | Grant | West Virginia | 54023 | 1322 | 29 |
1556584 | 1556584 | 2021-07-26 | Grant | West Virginia | 54023 | 1320 | 29 |
1559831 | 1559831 | 2021-07-27 | Grant | West Virginia | 54023 | 1320 | 29 |
1563079 | 1563079 | 2021-07-28 | Grant | West Virginia | 54023 | 1320 | 29 |
1566327 | 1566327 | 2021-07-29 | Grant | West Virginia | 54023 | 1322 | 29 |
1569575 | 1569575 | 2021-07-30 | Grant | West Virginia | 54023 | 1324 | 29 |
1572823 | 1572823 | 2021-07-31 | Grant | West Virginia | 54023 | 1324 | 29 |
1576071 | 1576071 | 2021-08-01 | Grant | West Virginia | 54023 | 1324 | 29 |
1579319 | 1579319 | 2021-08-02 | Grant | West Virginia | 54023 | 1325 | 29 |
1582569 | 1582569 | 2021-08-03 | Grant | West Virginia | 54023 | 1325 | 29 |
1585819 | 1585819 | 2021-08-04 | Grant | West Virginia | 54023 | 1328 | 29 |
1589068 | 1589068 | 2021-08-05 | Grant | West Virginia | 54023 | 1329 | 29 |
1592317 | 1592317 | 2021-08-06 | Grant | West Virginia | 54023 | 1331 | 29 |
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);