ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Onslow" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812089 | 1812089 | 2021-10-13 | Onslow | North Carolina | 37133 | 27735 | 244 |
1808840 | 1808840 | 2021-10-12 | Onslow | North Carolina | 37133 | 27562 | 241 |
1805589 | 1805589 | 2021-10-11 | Onslow | North Carolina | 37133 | 27469 | 241 |
1802340 | 1802340 | 2021-10-10 | Onslow | North Carolina | 37133 | 27286 | 241 |
1799091 | 1799091 | 2021-10-09 | Onslow | North Carolina | 37133 | 27286 | 241 |
1795842 | 1795842 | 2021-10-08 | Onslow | North Carolina | 37133 | 27286 | 241 |
1792593 | 1792593 | 2021-10-07 | Onslow | North Carolina | 37133 | 27207 | 238 |
1789344 | 1789344 | 2021-10-06 | Onslow | North Carolina | 37133 | 27051 | 237 |
1786096 | 1786096 | 2021-10-05 | Onslow | North Carolina | 37133 | 26921 | 236 |
1782847 | 1782847 | 2021-10-04 | Onslow | North Carolina | 37133 | 26873 | 233 |
1779598 | 1779598 | 2021-10-03 | Onslow | North Carolina | 37133 | 26559 | 230 |
1776348 | 1776348 | 2021-10-02 | Onslow | North Carolina | 37133 | 26559 | 230 |
1773098 | 1773098 | 2021-10-01 | Onslow | North Carolina | 37133 | 26559 | 230 |
1769848 | 1769848 | 2021-09-30 | Onslow | North Carolina | 37133 | 26443 | 229 |
1766599 | 1766599 | 2021-09-29 | Onslow | North Carolina | 37133 | 26317 | 229 |
1763350 | 1763350 | 2021-09-28 | Onslow | North Carolina | 37133 | 26162 | 226 |
1760101 | 1760101 | 2021-09-27 | Onslow | North Carolina | 37133 | 26075 | 226 |
1756853 | 1756853 | 2021-09-26 | Onslow | North Carolina | 37133 | 25650 | 224 |
1753605 | 1753605 | 2021-09-25 | Onslow | North Carolina | 37133 | 25650 | 224 |
1750357 | 1750357 | 2021-09-24 | Onslow | North Carolina | 37133 | 25650 | 224 |
1747107 | 1747107 | 2021-09-23 | Onslow | North Carolina | 37133 | 25511 | 222 |
1743858 | 1743858 | 2021-09-22 | Onslow | North Carolina | 37133 | 25369 | 222 |
1740609 | 1740609 | 2021-09-21 | Onslow | North Carolina | 37133 | 25255 | 218 |
1737360 | 1737360 | 2021-09-20 | Onslow | North Carolina | 37133 | 25187 | 218 |
1734110 | 1734110 | 2021-09-19 | Onslow | North Carolina | 37133 | 24807 | 215 |
1730860 | 1730860 | 2021-09-18 | Onslow | North Carolina | 37133 | 24807 | 215 |
1727610 | 1727610 | 2021-09-17 | Onslow | North Carolina | 37133 | 24807 | 215 |
1724361 | 1724361 | 2021-09-16 | Onslow | North Carolina | 37133 | 24567 | 212 |
1721112 | 1721112 | 2021-09-15 | Onslow | North Carolina | 37133 | 24424 | 209 |
1717864 | 1717864 | 2021-09-14 | Onslow | North Carolina | 37133 | 24275 | 203 |
1714616 | 1714616 | 2021-09-13 | Onslow | North Carolina | 37133 | 24207 | 202 |
1711370 | 1711370 | 2021-09-12 | Onslow | North Carolina | 37133 | 23624 | 192 |
1708123 | 1708123 | 2021-09-11 | Onslow | North Carolina | 37133 | 23624 | 192 |
1704876 | 1704876 | 2021-09-10 | Onslow | North Carolina | 37133 | 23624 | 192 |
1701626 | 1701626 | 2021-09-09 | Onslow | North Carolina | 37133 | 23473 | 192 |
1698377 | 1698377 | 2021-09-08 | Onslow | North Carolina | 37133 | 23331 | 192 |
1695129 | 1695129 | 2021-09-07 | Onslow | North Carolina | 37133 | 23223 | 192 |
1691881 | 1691881 | 2021-09-06 | Onslow | North Carolina | 37133 | 22624 | 188 |
1688631 | 1688631 | 2021-09-05 | Onslow | North Carolina | 37133 | 22624 | 188 |
1685381 | 1685381 | 2021-09-04 | Onslow | North Carolina | 37133 | 22624 | 188 |
1682130 | 1682130 | 2021-09-03 | Onslow | North Carolina | 37133 | 22624 | 188 |
1678881 | 1678881 | 2021-09-02 | Onslow | North Carolina | 37133 | 22408 | 177 |
1675633 | 1675633 | 2021-09-01 | Onslow | North Carolina | 37133 | 22302 | 177 |
1672386 | 1672386 | 2021-08-31 | Onslow | North Carolina | 37133 | 22143 | 176 |
1669138 | 1669138 | 2021-08-30 | Onslow | North Carolina | 37133 | 22014 | 176 |
1665891 | 1665891 | 2021-08-29 | Onslow | North Carolina | 37133 | 21556 | 173 |
1662643 | 1662643 | 2021-08-28 | Onslow | North Carolina | 37133 | 21556 | 173 |
1659395 | 1659395 | 2021-08-27 | Onslow | North Carolina | 37133 | 21556 | 173 |
1656146 | 1656146 | 2021-08-26 | Onslow | North Carolina | 37133 | 21374 | 173 |
1652899 | 1652899 | 2021-08-25 | Onslow | North Carolina | 37133 | 21214 | 173 |
1649651 | 1649651 | 2021-08-24 | Onslow | North Carolina | 37133 | 21136 | 171 |
1646402 | 1646402 | 2021-08-23 | Onslow | North Carolina | 37133 | 21070 | 169 |
1643153 | 1643153 | 2021-08-22 | Onslow | North Carolina | 37133 | 20773 | 169 |
1639903 | 1639903 | 2021-08-21 | Onslow | North Carolina | 37133 | 20773 | 169 |
1636653 | 1636653 | 2021-08-20 | Onslow | North Carolina | 37133 | 20773 | 169 |
1633403 | 1633403 | 2021-08-19 | Onslow | North Carolina | 37133 | 20651 | 169 |
1630156 | 1630156 | 2021-08-18 | Onslow | North Carolina | 37133 | 20456 | 167 |
1626909 | 1626909 | 2021-08-17 | Onslow | North Carolina | 37133 | 20329 | 166 |
1623662 | 1623662 | 2021-08-16 | Onslow | North Carolina | 37133 | 20269 | 166 |
1620415 | 1620415 | 2021-08-15 | Onslow | North Carolina | 37133 | 19935 | 165 |
1617167 | 1617167 | 2021-08-14 | Onslow | North Carolina | 37133 | 19935 | 165 |
1613919 | 1613919 | 2021-08-13 | Onslow | North Carolina | 37133 | 19935 | 165 |
1610670 | 1610670 | 2021-08-12 | Onslow | North Carolina | 37133 | 19813 | 164 |
1607422 | 1607422 | 2021-08-11 | Onslow | North Carolina | 37133 | 19720 | 162 |
1604173 | 1604173 | 2021-08-10 | Onslow | North Carolina | 37133 | 19610 | 161 |
1600924 | 1600924 | 2021-08-09 | Onslow | North Carolina | 37133 | 19539 | 161 |
1597676 | 1597676 | 2021-08-08 | Onslow | North Carolina | 37133 | 19188 | 161 |
1594427 | 1594427 | 2021-08-07 | Onslow | North Carolina | 37133 | 19188 | 161 |
1591178 | 1591178 | 2021-08-06 | Onslow | North Carolina | 37133 | 19188 | 161 |
1587929 | 1587929 | 2021-08-05 | Onslow | North Carolina | 37133 | 19087 | 161 |
1584679 | 1584679 | 2021-08-04 | Onslow | North Carolina | 37133 | 19017 | 161 |
1581429 | 1581429 | 2021-08-03 | Onslow | North Carolina | 37133 | 18948 | 161 |
1578180 | 1578180 | 2021-08-02 | Onslow | North Carolina | 37133 | 18919 | 160 |
1574932 | 1574932 | 2021-08-01 | Onslow | North Carolina | 37133 | 18767 | 159 |
1571684 | 1571684 | 2021-07-31 | Onslow | North Carolina | 37133 | 18767 | 159 |
1568436 | 1568436 | 2021-07-30 | Onslow | North Carolina | 37133 | 18767 | 159 |
1565188 | 1565188 | 2021-07-29 | Onslow | North Carolina | 37133 | 18692 | 156 |
1561940 | 1561940 | 2021-07-28 | Onslow | North Carolina | 37133 | 18622 | 156 |
1558692 | 1558692 | 2021-07-27 | Onslow | North Carolina | 37133 | 18562 | 156 |
1555445 | 1555445 | 2021-07-26 | Onslow | North Carolina | 37133 | 18545 | 156 |
1552198 | 1552198 | 2021-07-25 | Onslow | North Carolina | 37133 | 18415 | 156 |
1548951 | 1548951 | 2021-07-24 | Onslow | North Carolina | 37133 | 18415 | 156 |
1545704 | 1545704 | 2021-07-23 | Onslow | North Carolina | 37133 | 18415 | 156 |
1542457 | 1542457 | 2021-07-22 | Onslow | North Carolina | 37133 | 18355 | 156 |
1539209 | 1539209 | 2021-07-21 | Onslow | North Carolina | 37133 | 18296 | 156 |
1535962 | 1535962 | 2021-07-20 | Onslow | North Carolina | 37133 | 18251 | 154 |
1532714 | 1532714 | 2021-07-19 | Onslow | North Carolina | 37133 | 18235 | 154 |
1529467 | 1529467 | 2021-07-18 | Onslow | North Carolina | 37133 | 18155 | 154 |
1526220 | 1526220 | 2021-07-17 | Onslow | North Carolina | 37133 | 18155 | 154 |
1522973 | 1522973 | 2021-07-16 | Onslow | North Carolina | 37133 | 18155 | 154 |
1519725 | 1519725 | 2021-07-15 | Onslow | North Carolina | 37133 | 18132 | 154 |
1516477 | 1516477 | 2021-07-14 | Onslow | North Carolina | 37133 | 18077 | 154 |
1513230 | 1513230 | 2021-07-13 | Onslow | North Carolina | 37133 | 18040 | 154 |
1509984 | 1509984 | 2021-07-12 | Onslow | North Carolina | 37133 | 18031 | 154 |
1506737 | 1506737 | 2021-07-11 | Onslow | North Carolina | 37133 | 17997 | 154 |
1503491 | 1503491 | 2021-07-10 | Onslow | North Carolina | 37133 | 17997 | 154 |
1500245 | 1500245 | 2021-07-09 | Onslow | North Carolina | 37133 | 17997 | 154 |
1496999 | 1496999 | 2021-07-08 | Onslow | North Carolina | 37133 | 17969 | 154 |
1493752 | 1493752 | 2021-07-07 | Onslow | North Carolina | 37133 | 17936 | 154 |
1490505 | 1490505 | 2021-07-06 | Onslow | North Carolina | 37133 | 17935 | 154 |
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);