ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Barnstable" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175424 | 2175424 | 2022-02-02 | Barnstable | Massachusetts | 25001 | 33206 | 630 |
2172171 | 2172171 | 2022-02-01 | Barnstable | Massachusetts | 25001 | 33094 | 624 |
2168918 | 2168918 | 2022-01-31 | Barnstable | Massachusetts | 25001 | 32973 | 619 |
2165663 | 2165663 | 2022-01-30 | Barnstable | Massachusetts | 25001 | 32656 | 610 |
2162408 | 2162408 | 2022-01-29 | Barnstable | Massachusetts | 25001 | 32656 | 610 |
2159153 | 2159153 | 2022-01-28 | Barnstable | Massachusetts | 25001 | 32656 | 610 |
2155899 | 2155899 | 2022-01-27 | Barnstable | Massachusetts | 25001 | 32438 | 608 |
2152646 | 2152646 | 2022-01-26 | Barnstable | Massachusetts | 25001 | 32270 | 607 |
2149394 | 2149394 | 2022-01-25 | Barnstable | Massachusetts | 25001 | 32099 | 600 |
2146142 | 2146142 | 2022-01-24 | Barnstable | Massachusetts | 25001 | 31601 | 598 |
2142887 | 2142887 | 2022-01-23 | Barnstable | Massachusetts | 25001 | 31311 | 593 |
2139632 | 2139632 | 2022-01-22 | Barnstable | Massachusetts | 25001 | 31311 | 593 |
2136376 | 2136376 | 2022-01-21 | Barnstable | Massachusetts | 25001 | 31311 | 593 |
2133124 | 2133124 | 2022-01-20 | Barnstable | Massachusetts | 25001 | 30988 | 587 |
2129871 | 2129871 | 2022-01-19 | Barnstable | Massachusetts | 25001 | 30664 | 581 |
2126617 | 2126617 | 2022-01-18 | Barnstable | Massachusetts | 25001 | 30317 | 578 |
2123365 | 2123365 | 2022-01-17 | Barnstable | Massachusetts | 25001 | 29315 | 578 |
2120113 | 2120113 | 2022-01-16 | Barnstable | Massachusetts | 25001 | 29315 | 578 |
2116861 | 2116861 | 2022-01-15 | Barnstable | Massachusetts | 25001 | 29315 | 578 |
2113610 | 2113610 | 2022-01-14 | Barnstable | Massachusetts | 25001 | 29315 | 578 |
2110358 | 2110358 | 2022-01-13 | Barnstable | Massachusetts | 25001 | 29131 | 577 |
2107107 | 2107107 | 2022-01-12 | Barnstable | Massachusetts | 25001 | 28765 | 577 |
2103856 | 2103856 | 2022-01-11 | Barnstable | Massachusetts | 25001 | 28411 | 573 |
2100605 | 2100605 | 2022-01-10 | Barnstable | Massachusetts | 25001 | 28028 | 570 |
2097354 | 2097354 | 2022-01-09 | Barnstable | Massachusetts | 25001 | 27010 | 568 |
2094102 | 2094102 | 2022-01-08 | Barnstable | Massachusetts | 25001 | 27010 | 568 |
2090850 | 2090850 | 2022-01-07 | Barnstable | Massachusetts | 25001 | 27010 | 568 |
2087599 | 2087599 | 2022-01-06 | Barnstable | Massachusetts | 25001 | 26492 | 566 |
2084347 | 2084347 | 2022-01-05 | Barnstable | Massachusetts | 25001 | 26145 | 565 |
2081095 | 2081095 | 2022-01-04 | Barnstable | Massachusetts | 25001 | 25701 | 562 |
2077843 | 2077843 | 2022-01-03 | Barnstable | Massachusetts | 25001 | 25290 | 560 |
2074592 | 2074592 | 2022-01-02 | Barnstable | Massachusetts | 25001 | 24650 | 559 |
2071341 | 2071341 | 2022-01-01 | Barnstable | Massachusetts | 25001 | 24650 | 559 |
2068090 | 2068090 | 2021-12-31 | Barnstable | Massachusetts | 25001 | 24650 | 559 |
2064839 | 2064839 | 2021-12-30 | Barnstable | Massachusetts | 25001 | 24390 | 556 |
2061589 | 2061589 | 2021-12-29 | Barnstable | Massachusetts | 25001 | 24105 | 556 |
2058340 | 2058340 | 2021-12-28 | Barnstable | Massachusetts | 25001 | 23845 | 554 |
2055091 | 2055091 | 2021-12-27 | Barnstable | Massachusetts | 25001 | 23663 | 552 |
2051841 | 2051841 | 2021-12-26 | Barnstable | Massachusetts | 25001 | 23141 | 552 |
2048591 | 2048591 | 2021-12-25 | Barnstable | Massachusetts | 25001 | 23141 | 552 |
2045341 | 2045341 | 2021-12-24 | Barnstable | Massachusetts | 25001 | 23141 | 552 |
2042091 | 2042091 | 2021-12-23 | Barnstable | Massachusetts | 25001 | 22932 | 552 |
2038842 | 2038842 | 2021-12-22 | Barnstable | Massachusetts | 25001 | 22702 | 552 |
2035592 | 2035592 | 2021-12-21 | Barnstable | Massachusetts | 25001 | 22485 | 551 |
2032342 | 2032342 | 2021-12-20 | Barnstable | Massachusetts | 25001 | 22374 | 547 |
2029091 | 2029091 | 2021-12-19 | Barnstable | Massachusetts | 25001 | 21986 | 546 |
2025840 | 2025840 | 2021-12-18 | Barnstable | Massachusetts | 25001 | 21986 | 546 |
2022589 | 2022589 | 2021-12-17 | Barnstable | Massachusetts | 25001 | 21986 | 546 |
2019338 | 2019338 | 2021-12-16 | Barnstable | Massachusetts | 25001 | 21807 | 543 |
2016088 | 2016088 | 2021-12-15 | Barnstable | Massachusetts | 25001 | 21624 | 542 |
2012837 | 2012837 | 2021-12-14 | Barnstable | Massachusetts | 25001 | 21463 | 540 |
2009586 | 2009586 | 2021-12-13 | Barnstable | Massachusetts | 25001 | 21375 | 538 |
2006335 | 2006335 | 2021-12-12 | Barnstable | Massachusetts | 25001 | 21021 | 538 |
2003084 | 2003084 | 2021-12-11 | Barnstable | Massachusetts | 25001 | 21021 | 538 |
1999834 | 1999834 | 2021-12-10 | Barnstable | Massachusetts | 25001 | 21021 | 538 |
1996583 | 1996583 | 2021-12-09 | Barnstable | Massachusetts | 25001 | 20842 | 538 |
1993332 | 1993332 | 2021-12-08 | Barnstable | Massachusetts | 25001 | 20734 | 538 |
1990081 | 1990081 | 2021-12-07 | Barnstable | Massachusetts | 25001 | 20551 | 538 |
1986831 | 1986831 | 2021-12-06 | Barnstable | Massachusetts | 25001 | 20484 | 538 |
1983581 | 1983581 | 2021-12-05 | Barnstable | Massachusetts | 25001 | 20174 | 535 |
1980331 | 1980331 | 2021-12-04 | Barnstable | Massachusetts | 25001 | 20174 | 535 |
1977081 | 1977081 | 2021-12-03 | Barnstable | Massachusetts | 25001 | 20174 | 535 |
1973831 | 1973831 | 2021-12-02 | Barnstable | Massachusetts | 25001 | 20040 | 534 |
1970582 | 1970582 | 2021-12-01 | Barnstable | Massachusetts | 25001 | 19877 | 532 |
1967332 | 1967332 | 2021-11-30 | Barnstable | Massachusetts | 25001 | 19713 | 529 |
1964080 | 1964080 | 2021-11-29 | Barnstable | Massachusetts | 25001 | 19650 | 528 |
1960829 | 1960829 | 2021-11-28 | Barnstable | Massachusetts | 25001 | 19460 | 528 |
1957578 | 1957578 | 2021-11-27 | Barnstable | Massachusetts | 25001 | 19460 | 528 |
1954327 | 1954327 | 2021-11-26 | Barnstable | Massachusetts | 25001 | 19460 | 528 |
1951076 | 1951076 | 2021-11-25 | Barnstable | Massachusetts | 25001 | 19273 | 528 |
1947825 | 1947825 | 2021-11-24 | Barnstable | Massachusetts | 25001 | 19273 | 528 |
1944574 | 1944574 | 2021-11-23 | Barnstable | Massachusetts | 25001 | 19186 | 527 |
1941323 | 1941323 | 2021-11-22 | Barnstable | Massachusetts | 25001 | 19100 | 526 |
1938073 | 1938073 | 2021-11-21 | Barnstable | Massachusetts | 25001 | 18838 | 525 |
1934823 | 1934823 | 2021-11-20 | Barnstable | Massachusetts | 25001 | 18838 | 525 |
1931573 | 1931573 | 2021-11-19 | Barnstable | Massachusetts | 25001 | 18838 | 525 |
1928322 | 1928322 | 2021-11-18 | Barnstable | Massachusetts | 25001 | 18744 | 524 |
1925072 | 1925072 | 2021-11-17 | Barnstable | Massachusetts | 25001 | 18660 | 524 |
1921823 | 1921823 | 2021-11-16 | Barnstable | Massachusetts | 25001 | 18557 | 523 |
1918573 | 1918573 | 2021-11-15 | Barnstable | Massachusetts | 25001 | 18499 | 520 |
1915323 | 1915323 | 2021-11-14 | Barnstable | Massachusetts | 25001 | 18355 | 519 |
1912073 | 1912073 | 2021-11-13 | Barnstable | Massachusetts | 25001 | 18355 | 519 |
1908823 | 1908823 | 2021-11-12 | Barnstable | Massachusetts | 25001 | 18355 | 519 |
1905574 | 1905574 | 2021-11-11 | Barnstable | Massachusetts | 25001 | 18266 | 518 |
1902325 | 1902325 | 2021-11-10 | Barnstable | Massachusetts | 25001 | 18266 | 518 |
1899075 | 1899075 | 2021-11-09 | Barnstable | Massachusetts | 25001 | 18227 | 517 |
1895825 | 1895825 | 2021-11-08 | Barnstable | Massachusetts | 25001 | 18204 | 517 |
1892575 | 1892575 | 2021-11-07 | Barnstable | Massachusetts | 25001 | 18049 | 517 |
1889325 | 1889325 | 2021-11-06 | Barnstable | Massachusetts | 25001 | 18049 | 517 |
1886075 | 1886075 | 2021-11-05 | Barnstable | Massachusetts | 25001 | 18049 | 517 |
1882826 | 1882826 | 2021-11-04 | Barnstable | Massachusetts | 25001 | 18009 | 517 |
1879577 | 1879577 | 2021-11-03 | Barnstable | Massachusetts | 25001 | 17976 | 517 |
1876328 | 1876328 | 2021-11-02 | Barnstable | Massachusetts | 25001 | 17927 | 516 |
1873079 | 1873079 | 2021-11-01 | Barnstable | Massachusetts | 25001 | 17895 | 516 |
1869830 | 1869830 | 2021-10-31 | Barnstable | Massachusetts | 25001 | 17810 | 516 |
1866581 | 1866581 | 2021-10-30 | Barnstable | Massachusetts | 25001 | 17810 | 516 |
1863332 | 1863332 | 2021-10-29 | Barnstable | Massachusetts | 25001 | 17810 | 516 |
1860083 | 1860083 | 2021-10-28 | Barnstable | Massachusetts | 25001 | 17768 | 516 |
1856834 | 1856834 | 2021-10-27 | Barnstable | Massachusetts | 25001 | 17748 | 516 |
1853585 | 1853585 | 2021-10-26 | Barnstable | Massachusetts | 25001 | 17711 | 516 |
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);