ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where county = "Grant", deaths = 29 and state = "West Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1696267 | 1696267 | 2021-09-07 | Grant | West Virginia | 54023 | 1561 | 29 |
1693019 | 1693019 | 2021-09-06 | Grant | West Virginia | 54023 | 1544 | 29 |
1689770 | 1689770 | 2021-09-05 | Grant | West Virginia | 54023 | 1533 | 29 |
1686520 | 1686520 | 2021-09-04 | Grant | West Virginia | 54023 | 1512 | 29 |
1683269 | 1683269 | 2021-09-03 | Grant | West Virginia | 54023 | 1491 | 29 |
1680019 | 1680019 | 2021-09-02 | Grant | West Virginia | 54023 | 1482 | 29 |
1676771 | 1676771 | 2021-09-01 | Grant | West Virginia | 54023 | 1462 | 29 |
1673524 | 1673524 | 2021-08-31 | Grant | West Virginia | 54023 | 1445 | 29 |
1670276 | 1670276 | 2021-08-30 | Grant | West Virginia | 54023 | 1443 | 29 |
1667029 | 1667029 | 2021-08-29 | Grant | West Virginia | 54023 | 1434 | 29 |
1663781 | 1663781 | 2021-08-28 | Grant | West Virginia | 54023 | 1400 | 29 |
1660533 | 1660533 | 2021-08-27 | Grant | West Virginia | 54023 | 1400 | 29 |
1657285 | 1657285 | 2021-08-26 | Grant | West Virginia | 54023 | 1393 | 29 |
1654037 | 1654037 | 2021-08-25 | Grant | West Virginia | 54023 | 1388 | 29 |
1650791 | 1650791 | 2021-08-24 | Grant | West Virginia | 54023 | 1387 | 29 |
1647542 | 1647542 | 2021-08-23 | Grant | West Virginia | 54023 | 1383 | 29 |
1644293 | 1644293 | 2021-08-22 | Grant | West Virginia | 54023 | 1372 | 29 |
1641043 | 1641043 | 2021-08-21 | Grant | West Virginia | 54023 | 1372 | 29 |
1637793 | 1637793 | 2021-08-20 | Grant | West Virginia | 54023 | 1372 | 29 |
1634543 | 1634543 | 2021-08-19 | Grant | West Virginia | 54023 | 1369 | 29 |
1631295 | 1631295 | 2021-08-18 | Grant | West Virginia | 54023 | 1365 | 29 |
1628048 | 1628048 | 2021-08-17 | Grant | West Virginia | 54023 | 1360 | 29 |
1624801 | 1624801 | 2021-08-16 | Grant | West Virginia | 54023 | 1352 | 29 |
1621554 | 1621554 | 2021-08-15 | Grant | West Virginia | 54023 | 1345 | 29 |
1618306 | 1618306 | 2021-08-14 | Grant | West Virginia | 54023 | 1345 | 29 |
1615058 | 1615058 | 2021-08-13 | Grant | West Virginia | 54023 | 1345 | 29 |
1611809 | 1611809 | 2021-08-12 | Grant | West Virginia | 54023 | 1342 | 29 |
1608562 | 1608562 | 2021-08-11 | Grant | West Virginia | 54023 | 1340 | 29 |
1605313 | 1605313 | 2021-08-10 | Grant | West Virginia | 54023 | 1338 | 29 |
1602063 | 1602063 | 2021-08-09 | Grant | West Virginia | 54023 | 1337 | 29 |
1598815 | 1598815 | 2021-08-08 | Grant | West Virginia | 54023 | 1331 | 29 |
1595566 | 1595566 | 2021-08-07 | Grant | West Virginia | 54023 | 1331 | 29 |
1592317 | 1592317 | 2021-08-06 | Grant | West Virginia | 54023 | 1331 | 29 |
1589068 | 1589068 | 2021-08-05 | Grant | West Virginia | 54023 | 1329 | 29 |
1585819 | 1585819 | 2021-08-04 | Grant | West Virginia | 54023 | 1328 | 29 |
1582569 | 1582569 | 2021-08-03 | Grant | West Virginia | 54023 | 1325 | 29 |
1579319 | 1579319 | 2021-08-02 | Grant | West Virginia | 54023 | 1325 | 29 |
1576071 | 1576071 | 2021-08-01 | Grant | West Virginia | 54023 | 1324 | 29 |
1572823 | 1572823 | 2021-07-31 | Grant | West Virginia | 54023 | 1324 | 29 |
1569575 | 1569575 | 2021-07-30 | Grant | West Virginia | 54023 | 1324 | 29 |
1566327 | 1566327 | 2021-07-29 | Grant | West Virginia | 54023 | 1322 | 29 |
1563079 | 1563079 | 2021-07-28 | Grant | West Virginia | 54023 | 1320 | 29 |
1559831 | 1559831 | 2021-07-27 | Grant | West Virginia | 54023 | 1320 | 29 |
1556584 | 1556584 | 2021-07-26 | Grant | West Virginia | 54023 | 1320 | 29 |
1553337 | 1553337 | 2021-07-25 | Grant | West Virginia | 54023 | 1322 | 29 |
1550090 | 1550090 | 2021-07-24 | Grant | West Virginia | 54023 | 1322 | 29 |
1546843 | 1546843 | 2021-07-23 | Grant | West Virginia | 54023 | 1322 | 29 |
1261170 | 1261170 | 2021-04-26 | Grant | West Virginia | 54023 | 1248 | 29 |
1257923 | 1257923 | 2021-04-25 | Grant | West Virginia | 54023 | 1248 | 29 |
1254676 | 1254676 | 2021-04-24 | Grant | West Virginia | 54023 | 1247 | 29 |
1251429 | 1251429 | 2021-04-23 | Grant | West Virginia | 54023 | 1243 | 29 |
1248182 | 1248182 | 2021-04-22 | Grant | West Virginia | 54023 | 1242 | 29 |
1244935 | 1244935 | 2021-04-21 | Grant | West Virginia | 54023 | 1240 | 29 |
1241688 | 1241688 | 2021-04-20 | Grant | West Virginia | 54023 | 1239 | 29 |
1238441 | 1238441 | 2021-04-19 | Grant | West Virginia | 54023 | 1241 | 29 |
1235194 | 1235194 | 2021-04-18 | Grant | West Virginia | 54023 | 1239 | 29 |
1231946 | 1231946 | 2021-04-17 | Grant | West Virginia | 54023 | 1240 | 29 |
1228698 | 1228698 | 2021-04-16 | Grant | West Virginia | 54023 | 1237 | 29 |
1225450 | 1225450 | 2021-04-15 | Grant | West Virginia | 54023 | 1237 | 29 |
1222203 | 1222203 | 2021-04-14 | Grant | West Virginia | 54023 | 1234 | 29 |
1218955 | 1218955 | 2021-04-13 | Grant | West Virginia | 54023 | 1232 | 29 |
1215707 | 1215707 | 2021-04-12 | Grant | West Virginia | 54023 | 1227 | 29 |
1212460 | 1212460 | 2021-04-11 | Grant | West Virginia | 54023 | 1223 | 29 |
1209211 | 1209211 | 2021-04-10 | Grant | West Virginia | 54023 | 1221 | 29 |
1205963 | 1205963 | 2021-04-09 | Grant | West Virginia | 54023 | 1219 | 29 |
1202715 | 1202715 | 2021-04-08 | Grant | West Virginia | 54023 | 1214 | 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);