ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
765 rows where county = "Jones" 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 |
---|---|---|---|---|---|---|---|
2111087 | 2111087 | 2022-01-13 | Jones | North Carolina | 37103 | 1620 | 38 |
2107835 | 2107835 | 2022-01-12 | Jones | North Carolina | 37103 | 1598 | 38 |
2104584 | 2104584 | 2022-01-11 | Jones | North Carolina | 37103 | 1567 | 38 |
2101333 | 2101333 | 2022-01-10 | Jones | North Carolina | 37103 | 1583 | 38 |
2098082 | 2098082 | 2022-01-09 | Jones | North Carolina | 37103 | 1520 | 38 |
2094830 | 2094830 | 2022-01-08 | Jones | North Carolina | 37103 | 1520 | 38 |
2091578 | 2091578 | 2022-01-07 | Jones | North Carolina | 37103 | 1520 | 38 |
2088327 | 2088327 | 2022-01-06 | Jones | North Carolina | 37103 | 1507 | 38 |
2085075 | 2085075 | 2022-01-05 | Jones | North Carolina | 37103 | 1490 | 38 |
2081823 | 2081823 | 2022-01-04 | Jones | North Carolina | 37103 | 1477 | 38 |
2078571 | 2078571 | 2022-01-03 | Jones | North Carolina | 37103 | 1486 | 38 |
2075320 | 2075320 | 2022-01-02 | Jones | North Carolina | 37103 | 1447 | 38 |
2072069 | 2072069 | 2022-01-01 | Jones | North Carolina | 37103 | 1447 | 38 |
2068818 | 2068818 | 2021-12-31 | Jones | North Carolina | 37103 | 1447 | 38 |
2065567 | 2065567 | 2021-12-30 | Jones | North Carolina | 37103 | 1438 | 38 |
2062317 | 2062317 | 2021-12-29 | Jones | North Carolina | 37103 | 1426 | 37 |
2059068 | 2059068 | 2021-12-28 | Jones | North Carolina | 37103 | 1419 | 37 |
2055819 | 2055819 | 2021-12-27 | Jones | North Carolina | 37103 | 1414 | 36 |
2052569 | 2052569 | 2021-12-26 | Jones | North Carolina | 37103 | 1414 | 36 |
2049319 | 2049319 | 2021-12-25 | Jones | North Carolina | 37103 | 1414 | 36 |
2046069 | 2046069 | 2021-12-24 | Jones | North Carolina | 37103 | 1414 | 36 |
2042819 | 2042819 | 2021-12-23 | Jones | North Carolina | 37103 | 1414 | 36 |
2039570 | 2039570 | 2021-12-22 | Jones | North Carolina | 37103 | 1414 | 36 |
2036320 | 2036320 | 2021-12-21 | Jones | North Carolina | 37103 | 1411 | 36 |
2033070 | 2033070 | 2021-12-20 | Jones | North Carolina | 37103 | 1422 | 36 |
2029820 | 2029820 | 2021-12-19 | Jones | North Carolina | 37103 | 1406 | 36 |
2026569 | 2026569 | 2021-12-18 | Jones | North Carolina | 37103 | 1406 | 36 |
2023318 | 2023318 | 2021-12-17 | Jones | North Carolina | 37103 | 1406 | 36 |
2020067 | 2020067 | 2021-12-16 | Jones | North Carolina | 37103 | 1406 | 36 |
2016816 | 2016816 | 2021-12-15 | Jones | North Carolina | 37103 | 1402 | 36 |
2013566 | 2013566 | 2021-12-14 | Jones | North Carolina | 37103 | 1398 | 36 |
2010315 | 2010315 | 2021-12-13 | Jones | North Carolina | 37103 | 1398 | 36 |
2007064 | 2007064 | 2021-12-12 | Jones | North Carolina | 37103 | 1393 | 36 |
2003813 | 2003813 | 2021-12-11 | Jones | North Carolina | 37103 | 1393 | 36 |
2000562 | 2000562 | 2021-12-10 | Jones | North Carolina | 37103 | 1393 | 36 |
1997312 | 1997312 | 2021-12-09 | Jones | North Carolina | 37103 | 1393 | 36 |
1994061 | 1994061 | 2021-12-08 | Jones | North Carolina | 37103 | 1392 | 36 |
1990810 | 1990810 | 2021-12-07 | Jones | North Carolina | 37103 | 1389 | 36 |
1987559 | 1987559 | 2021-12-06 | Jones | North Carolina | 37103 | 1391 | 35 |
1984309 | 1984309 | 2021-12-05 | Jones | North Carolina | 37103 | 1386 | 35 |
1981059 | 1981059 | 2021-12-04 | Jones | North Carolina | 37103 | 1386 | 35 |
1977809 | 1977809 | 2021-12-03 | Jones | North Carolina | 37103 | 1386 | 35 |
1974559 | 1974559 | 2021-12-02 | Jones | North Carolina | 37103 | 1385 | 35 |
1971310 | 1971310 | 2021-12-01 | Jones | North Carolina | 37103 | 1384 | 35 |
1968060 | 1968060 | 2021-11-30 | Jones | North Carolina | 37103 | 1387 | 35 |
1964809 | 1964809 | 2021-11-29 | Jones | North Carolina | 37103 | 1386 | 35 |
1961557 | 1961557 | 2021-11-28 | Jones | North Carolina | 37103 | 1379 | 35 |
1958306 | 1958306 | 2021-11-27 | Jones | North Carolina | 37103 | 1379 | 35 |
1955055 | 1955055 | 2021-11-26 | Jones | North Carolina | 37103 | 1379 | 35 |
1951804 | 1951804 | 2021-11-25 | Jones | North Carolina | 37103 | 1379 | 35 |
1948553 | 1948553 | 2021-11-24 | Jones | North Carolina | 37103 | 1379 | 35 |
1945302 | 1945302 | 2021-11-23 | Jones | North Carolina | 37103 | 1379 | 35 |
1942051 | 1942051 | 2021-11-22 | Jones | North Carolina | 37103 | 1378 | 35 |
1938801 | 1938801 | 2021-11-21 | Jones | North Carolina | 37103 | 1377 | 35 |
1935551 | 1935551 | 2021-11-20 | Jones | North Carolina | 37103 | 1377 | 35 |
1932301 | 1932301 | 2021-11-19 | Jones | North Carolina | 37103 | 1377 | 35 |
1929050 | 1929050 | 2021-11-18 | Jones | North Carolina | 37103 | 1373 | 34 |
1925800 | 1925800 | 2021-11-17 | Jones | North Carolina | 37103 | 1374 | 34 |
1922551 | 1922551 | 2021-11-16 | Jones | North Carolina | 37103 | 1373 | 34 |
1919301 | 1919301 | 2021-11-15 | Jones | North Carolina | 37103 | 1375 | 34 |
1916051 | 1916051 | 2021-11-14 | Jones | North Carolina | 37103 | 1368 | 34 |
1912801 | 1912801 | 2021-11-13 | Jones | North Carolina | 37103 | 1368 | 34 |
1909551 | 1909551 | 2021-11-12 | Jones | North Carolina | 37103 | 1368 | 34 |
1906302 | 1906302 | 2021-11-11 | Jones | North Carolina | 37103 | 1366 | 34 |
1903053 | 1903053 | 2021-11-10 | Jones | North Carolina | 37103 | 1366 | 34 |
1899803 | 1899803 | 2021-11-09 | Jones | North Carolina | 37103 | 1366 | 34 |
1896553 | 1896553 | 2021-11-08 | Jones | North Carolina | 37103 | 1369 | 34 |
1893303 | 1893303 | 2021-11-07 | Jones | North Carolina | 37103 | 1367 | 34 |
1890053 | 1890053 | 2021-11-06 | Jones | North Carolina | 37103 | 1367 | 34 |
1886803 | 1886803 | 2021-11-05 | Jones | North Carolina | 37103 | 1367 | 34 |
1883554 | 1883554 | 2021-11-04 | Jones | North Carolina | 37103 | 1366 | 34 |
1880305 | 1880305 | 2021-11-03 | Jones | North Carolina | 37103 | 1362 | 34 |
1877056 | 1877056 | 2021-11-02 | Jones | North Carolina | 37103 | 1354 | 34 |
1873807 | 1873807 | 2021-11-01 | Jones | North Carolina | 37103 | 1354 | 34 |
1870558 | 1870558 | 2021-10-31 | Jones | North Carolina | 37103 | 1351 | 34 |
1867309 | 1867309 | 2021-10-30 | Jones | North Carolina | 37103 | 1351 | 34 |
1864060 | 1864060 | 2021-10-29 | Jones | North Carolina | 37103 | 1351 | 34 |
1860811 | 1860811 | 2021-10-28 | Jones | North Carolina | 37103 | 1343 | 34 |
1857562 | 1857562 | 2021-10-27 | Jones | North Carolina | 37103 | 1334 | 31 |
1854313 | 1854313 | 2021-10-26 | Jones | North Carolina | 37103 | 1333 | 31 |
1851064 | 1851064 | 2021-10-25 | Jones | North Carolina | 37103 | 1336 | 31 |
1847814 | 1847814 | 2021-10-24 | Jones | North Carolina | 37103 | 1320 | 31 |
1844564 | 1844564 | 2021-10-23 | Jones | North Carolina | 37103 | 1320 | 31 |
1841314 | 1841314 | 2021-10-22 | Jones | North Carolina | 37103 | 1320 | 31 |
1838065 | 1838065 | 2021-10-21 | Jones | North Carolina | 37103 | 1314 | 31 |
1834816 | 1834816 | 2021-10-20 | Jones | North Carolina | 37103 | 1313 | 29 |
1831567 | 1831567 | 2021-10-19 | Jones | North Carolina | 37103 | 1310 | 29 |
1828318 | 1828318 | 2021-10-18 | Jones | North Carolina | 37103 | 1306 | 29 |
1825069 | 1825069 | 2021-10-17 | Jones | North Carolina | 37103 | 1297 | 29 |
1821820 | 1821820 | 2021-10-16 | Jones | North Carolina | 37103 | 1297 | 29 |
1818571 | 1818571 | 2021-10-15 | Jones | North Carolina | 37103 | 1297 | 29 |
1815322 | 1815322 | 2021-10-14 | Jones | North Carolina | 37103 | 1296 | 29 |
1812074 | 1812074 | 2021-10-13 | Jones | North Carolina | 37103 | 1292 | 29 |
1808825 | 1808825 | 2021-10-12 | Jones | North Carolina | 37103 | 1292 | 29 |
1805574 | 1805574 | 2021-10-11 | Jones | North Carolina | 37103 | 1290 | 29 |
1802325 | 1802325 | 2021-10-10 | Jones | North Carolina | 37103 | 1284 | 29 |
1799076 | 1799076 | 2021-10-09 | Jones | North Carolina | 37103 | 1284 | 29 |
1795827 | 1795827 | 2021-10-08 | Jones | North Carolina | 37103 | 1284 | 29 |
1792578 | 1792578 | 2021-10-07 | Jones | North Carolina | 37103 | 1280 | 29 |
1789329 | 1789329 | 2021-10-06 | Jones | North Carolina | 37103 | 1278 | 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);