ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Isle of Wight" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718881 | 1718881 | 2021-09-14 | Isle of Wight | Virginia | 51093 | 3826 | 74 |
1715633 | 1715633 | 2021-09-13 | Isle of Wight | Virginia | 51093 | 3812 | 74 |
1712387 | 1712387 | 2021-09-12 | Isle of Wight | Virginia | 51093 | 3772 | 74 |
1709140 | 1709140 | 2021-09-11 | Isle of Wight | Virginia | 51093 | 3772 | 74 |
1705893 | 1705893 | 2021-09-10 | Isle of Wight | Virginia | 51093 | 3772 | 74 |
1702643 | 1702643 | 2021-09-09 | Isle of Wight | Virginia | 51093 | 3758 | 74 |
1699394 | 1699394 | 2021-09-08 | Isle of Wight | Virginia | 51093 | 3734 | 74 |
1696146 | 1696146 | 2021-09-07 | Isle of Wight | Virginia | 51093 | 3726 | 74 |
1692898 | 1692898 | 2021-09-06 | Isle of Wight | Virginia | 51093 | 3709 | 74 |
1689649 | 1689649 | 2021-09-05 | Isle of Wight | Virginia | 51093 | 3683 | 73 |
1686399 | 1686399 | 2021-09-04 | Isle of Wight | Virginia | 51093 | 3683 | 73 |
1683148 | 1683148 | 2021-09-03 | Isle of Wight | Virginia | 51093 | 3683 | 73 |
1679898 | 1679898 | 2021-09-02 | Isle of Wight | Virginia | 51093 | 3667 | 73 |
1676650 | 1676650 | 2021-09-01 | Isle of Wight | Virginia | 51093 | 3645 | 73 |
1673403 | 1673403 | 2021-08-31 | Isle of Wight | Virginia | 51093 | 3630 | 73 |
1670155 | 1670155 | 2021-08-30 | Isle of Wight | Virginia | 51093 | 3615 | 72 |
1666908 | 1666908 | 2021-08-29 | Isle of Wight | Virginia | 51093 | 3581 | 72 |
1663660 | 1663660 | 2021-08-28 | Isle of Wight | Virginia | 51093 | 3581 | 72 |
1660412 | 1660412 | 2021-08-27 | Isle of Wight | Virginia | 51093 | 3581 | 72 |
1657163 | 1657163 | 2021-08-26 | Isle of Wight | Virginia | 51093 | 3566 | 71 |
1653916 | 1653916 | 2021-08-25 | Isle of Wight | Virginia | 51093 | 3548 | 71 |
1650670 | 1650670 | 2021-08-24 | Isle of Wight | Virginia | 51093 | 3544 | 71 |
1647421 | 1647421 | 2021-08-23 | Isle of Wight | Virginia | 51093 | 3524 | 71 |
1644172 | 1644172 | 2021-08-22 | Isle of Wight | Virginia | 51093 | 3486 | 70 |
1640922 | 1640922 | 2021-08-21 | Isle of Wight | Virginia | 51093 | 3486 | 70 |
1637672 | 1637672 | 2021-08-20 | Isle of Wight | Virginia | 51093 | 3486 | 70 |
1634422 | 1634422 | 2021-08-19 | Isle of Wight | Virginia | 51093 | 3474 | 70 |
1631174 | 1631174 | 2021-08-18 | Isle of Wight | Virginia | 51093 | 3457 | 70 |
1627927 | 1627927 | 2021-08-17 | Isle of Wight | Virginia | 51093 | 3454 | 70 |
1624680 | 1624680 | 2021-08-16 | Isle of Wight | Virginia | 51093 | 3442 | 70 |
1621433 | 1621433 | 2021-08-15 | Isle of Wight | Virginia | 51093 | 3407 | 70 |
1618185 | 1618185 | 2021-08-14 | Isle of Wight | Virginia | 51093 | 3407 | 70 |
1614937 | 1614937 | 2021-08-13 | Isle of Wight | Virginia | 51093 | 3407 | 70 |
1611688 | 1611688 | 2021-08-12 | Isle of Wight | Virginia | 51093 | 3390 | 70 |
1608441 | 1608441 | 2021-08-11 | Isle of Wight | Virginia | 51093 | 3380 | 70 |
1605192 | 1605192 | 2021-08-10 | Isle of Wight | Virginia | 51093 | 3368 | 70 |
1601942 | 1601942 | 2021-08-09 | Isle of Wight | Virginia | 51093 | 3363 | 70 |
1598694 | 1598694 | 2021-08-08 | Isle of Wight | Virginia | 51093 | 3338 | 70 |
1595445 | 1595445 | 2021-08-07 | Isle of Wight | Virginia | 51093 | 3338 | 70 |
1592196 | 1592196 | 2021-08-06 | Isle of Wight | Virginia | 51093 | 3338 | 70 |
1588947 | 1588947 | 2021-08-05 | Isle of Wight | Virginia | 51093 | 3324 | 70 |
1585698 | 1585698 | 2021-08-04 | Isle of Wight | Virginia | 51093 | 3311 | 70 |
1582448 | 1582448 | 2021-08-03 | Isle of Wight | Virginia | 51093 | 3296 | 70 |
1579198 | 1579198 | 2021-08-02 | Isle of Wight | Virginia | 51093 | 3279 | 70 |
1575950 | 1575950 | 2021-08-01 | Isle of Wight | Virginia | 51093 | 3262 | 70 |
1572702 | 1572702 | 2021-07-31 | Isle of Wight | Virginia | 51093 | 3262 | 70 |
1569454 | 1569454 | 2021-07-30 | Isle of Wight | Virginia | 51093 | 3262 | 70 |
1566206 | 1566206 | 2021-07-29 | Isle of Wight | Virginia | 51093 | 3255 | 70 |
1562958 | 1562958 | 2021-07-28 | Isle of Wight | Virginia | 51093 | 3251 | 70 |
1559710 | 1559710 | 2021-07-27 | Isle of Wight | Virginia | 51093 | 3248 | 70 |
1556463 | 1556463 | 2021-07-26 | Isle of Wight | Virginia | 51093 | 3240 | 70 |
1553216 | 1553216 | 2021-07-25 | Isle of Wight | Virginia | 51093 | 3224 | 70 |
1549969 | 1549969 | 2021-07-24 | Isle of Wight | Virginia | 51093 | 3224 | 70 |
1546722 | 1546722 | 2021-07-23 | Isle of Wight | Virginia | 51093 | 3224 | 70 |
1543475 | 1543475 | 2021-07-22 | Isle of Wight | Virginia | 51093 | 3219 | 70 |
1540227 | 1540227 | 2021-07-21 | Isle of Wight | Virginia | 51093 | 3214 | 70 |
1536980 | 1536980 | 2021-07-20 | Isle of Wight | Virginia | 51093 | 3213 | 70 |
1533732 | 1533732 | 2021-07-19 | Isle of Wight | Virginia | 51093 | 3211 | 70 |
1530485 | 1530485 | 2021-07-18 | Isle of Wight | Virginia | 51093 | 3204 | 70 |
1527238 | 1527238 | 2021-07-17 | Isle of Wight | Virginia | 51093 | 3204 | 70 |
1523991 | 1523991 | 2021-07-16 | Isle of Wight | Virginia | 51093 | 3204 | 70 |
1520743 | 1520743 | 2021-07-15 | Isle of Wight | Virginia | 51093 | 3203 | 70 |
1517495 | 1517495 | 2021-07-14 | Isle of Wight | Virginia | 51093 | 3200 | 70 |
1514248 | 1514248 | 2021-07-13 | Isle of Wight | Virginia | 51093 | 3196 | 70 |
1511002 | 1511002 | 2021-07-12 | Isle of Wight | Virginia | 51093 | 3193 | 70 |
1507755 | 1507755 | 2021-07-11 | Isle of Wight | Virginia | 51093 | 3193 | 70 |
1504509 | 1504509 | 2021-07-10 | Isle of Wight | Virginia | 51093 | 3193 | 70 |
1501263 | 1501263 | 2021-07-09 | Isle of Wight | Virginia | 51093 | 3189 | 70 |
1498017 | 1498017 | 2021-07-08 | Isle of Wight | Virginia | 51093 | 3186 | 70 |
1494770 | 1494770 | 2021-07-07 | Isle of Wight | Virginia | 51093 | 3184 | 70 |
1491523 | 1491523 | 2021-07-06 | Isle of Wight | Virginia | 51093 | 3182 | 70 |
1488276 | 1488276 | 2021-07-05 | Isle of Wight | Virginia | 51093 | 3182 | 70 |
1485029 | 1485029 | 2021-07-04 | Isle of Wight | Virginia | 51093 | 3181 | 70 |
1481783 | 1481783 | 2021-07-03 | Isle of Wight | Virginia | 51093 | 3181 | 70 |
1478536 | 1478536 | 2021-07-02 | Isle of Wight | Virginia | 51093 | 3180 | 70 |
1475290 | 1475290 | 2021-07-01 | Isle of Wight | Virginia | 51093 | 3177 | 70 |
1472044 | 1472044 | 2021-06-30 | Isle of Wight | Virginia | 51093 | 3175 | 70 |
1468799 | 1468799 | 2021-06-29 | Isle of Wight | Virginia | 51093 | 3173 | 70 |
1465554 | 1465554 | 2021-06-28 | Isle of Wight | Virginia | 51093 | 3174 | 70 |
1462309 | 1462309 | 2021-06-27 | Isle of Wight | Virginia | 51093 | 3173 | 70 |
1459064 | 1459064 | 2021-06-26 | Isle of Wight | Virginia | 51093 | 3174 | 70 |
1455819 | 1455819 | 2021-06-25 | Isle of Wight | Virginia | 51093 | 3174 | 70 |
1452574 | 1452574 | 2021-06-24 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1449328 | 1449328 | 2021-06-23 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1446083 | 1446083 | 2021-06-22 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1442838 | 1442838 | 2021-06-21 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1439593 | 1439593 | 2021-06-20 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1436346 | 1436346 | 2021-06-19 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1433099 | 1433099 | 2021-06-18 | Isle of Wight | Virginia | 51093 | 3172 | 70 |
1429853 | 1429853 | 2021-06-17 | Isle of Wight | Virginia | 51093 | 3171 | 70 |
1426608 | 1426608 | 2021-06-16 | Isle of Wight | Virginia | 51093 | 3169 | 70 |
1423362 | 1423362 | 2021-06-15 | Isle of Wight | Virginia | 51093 | 3170 | 70 |
1420115 | 1420115 | 2021-06-14 | Isle of Wight | Virginia | 51093 | 3171 | 70 |
1416870 | 1416870 | 2021-06-13 | Isle of Wight | Virginia | 51093 | 3171 | 70 |
1413624 | 1413624 | 2021-06-12 | Isle of Wight | Virginia | 51093 | 3171 | 70 |
1410379 | 1410379 | 2021-06-11 | Isle of Wight | Virginia | 51093 | 3169 | 70 |
1407134 | 1407134 | 2021-06-10 | Isle of Wight | Virginia | 51093 | 3168 | 70 |
1403888 | 1403888 | 2021-06-09 | Isle of Wight | Virginia | 51093 | 3166 | 70 |
1400643 | 1400643 | 2021-06-08 | Isle of Wight | Virginia | 51093 | 3168 | 69 |
1397398 | 1397398 | 2021-06-07 | Isle of Wight | Virginia | 51093 | 3167 | 69 |
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);