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 |
---|---|---|---|---|---|---|---|
1948568 | 1948568 | 2021-11-24 | Onslow | North Carolina | 37133 | 30468 | 272 |
1945317 | 1945317 | 2021-11-23 | Onslow | North Carolina | 37133 | 30445 | 272 |
1942066 | 1942066 | 2021-11-22 | Onslow | North Carolina | 37133 | 30430 | 272 |
1938816 | 1938816 | 2021-11-21 | Onslow | North Carolina | 37133 | 30391 | 272 |
1935566 | 1935566 | 2021-11-20 | Onslow | North Carolina | 37133 | 30391 | 272 |
1932316 | 1932316 | 2021-11-19 | Onslow | North Carolina | 37133 | 30391 | 272 |
1929065 | 1929065 | 2021-11-18 | Onslow | North Carolina | 37133 | 30361 | 272 |
1925815 | 1925815 | 2021-11-17 | Onslow | North Carolina | 37133 | 30347 | 272 |
1922566 | 1922566 | 2021-11-16 | Onslow | North Carolina | 37133 | 30308 | 271 |
1919316 | 1919316 | 2021-11-15 | Onslow | North Carolina | 37133 | 30303 | 271 |
1916066 | 1916066 | 2021-11-14 | Onslow | North Carolina | 37133 | 30321 | 271 |
1912816 | 1912816 | 2021-11-13 | Onslow | North Carolina | 37133 | 30321 | 271 |
1909566 | 1909566 | 2021-11-12 | Onslow | North Carolina | 37133 | 30321 | 271 |
1906317 | 1906317 | 2021-11-11 | Onslow | North Carolina | 37133 | 30286 | 271 |
1903068 | 1903068 | 2021-11-10 | Onslow | North Carolina | 37133 | 30286 | 271 |
1899818 | 1899818 | 2021-11-09 | Onslow | North Carolina | 37133 | 30227 | 269 |
1896568 | 1896568 | 2021-11-08 | Onslow | North Carolina | 37133 | 30195 | 268 |
1893318 | 1893318 | 2021-11-07 | Onslow | North Carolina | 37133 | 30094 | 264 |
1890068 | 1890068 | 2021-11-06 | Onslow | North Carolina | 37133 | 30094 | 264 |
1886818 | 1886818 | 2021-11-05 | Onslow | North Carolina | 37133 | 30094 | 264 |
1883569 | 1883569 | 2021-11-04 | Onslow | North Carolina | 37133 | 29987 | 261 |
1880320 | 1880320 | 2021-11-03 | Onslow | North Carolina | 37133 | 29877 | 261 |
1877071 | 1877071 | 2021-11-02 | Onslow | North Carolina | 37133 | 29828 | 261 |
1873822 | 1873822 | 2021-11-01 | Onslow | North Carolina | 37133 | 29772 | 261 |
1870573 | 1870573 | 2021-10-31 | Onslow | North Carolina | 37133 | 29587 | 259 |
1867324 | 1867324 | 2021-10-30 | Onslow | North Carolina | 37133 | 29587 | 259 |
1864075 | 1864075 | 2021-10-29 | Onslow | North Carolina | 37133 | 29587 | 259 |
1860826 | 1860826 | 2021-10-28 | Onslow | North Carolina | 37133 | 29459 | 259 |
1857577 | 1857577 | 2021-10-27 | Onslow | North Carolina | 37133 | 29367 | 258 |
1854328 | 1854328 | 2021-10-26 | Onslow | North Carolina | 37133 | 29311 | 257 |
1851079 | 1851079 | 2021-10-25 | Onslow | North Carolina | 37133 | 29283 | 256 |
1847829 | 1847829 | 2021-10-24 | Onslow | North Carolina | 37133 | 29016 | 255 |
1844579 | 1844579 | 2021-10-23 | Onslow | North Carolina | 37133 | 29016 | 255 |
1841329 | 1841329 | 2021-10-22 | Onslow | North Carolina | 37133 | 29016 | 255 |
1838080 | 1838080 | 2021-10-21 | Onslow | North Carolina | 37133 | 28846 | 254 |
1834831 | 1834831 | 2021-10-20 | Onslow | North Carolina | 37133 | 28639 | 253 |
1831582 | 1831582 | 2021-10-19 | Onslow | North Carolina | 37133 | 28463 | 253 |
1828333 | 1828333 | 2021-10-18 | Onslow | North Carolina | 37133 | 28373 | 250 |
1825084 | 1825084 | 2021-10-17 | Onslow | North Carolina | 37133 | 28084 | 249 |
1821835 | 1821835 | 2021-10-16 | Onslow | North Carolina | 37133 | 28084 | 249 |
1818586 | 1818586 | 2021-10-15 | Onslow | North Carolina | 37133 | 28084 | 249 |
1815337 | 1815337 | 2021-10-14 | Onslow | North Carolina | 37133 | 27932 | 246 |
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 |
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);