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)
deaths 301 ✖
- 469 27
- 174 14
- 471 14
- 470 13
- 0 11
- 158 11
- 485 11
- 186 10
- 488 10
- 461 9
- 169 8
- 516 8
- 538 8
- 155 7
- 164 7
- 165 7
- 190 7
- 466 7
- 484 7
- 517 7
- 157 6
- 182 6
- 462 6
- 483 6
- 509 6
- 514 6
- 528 6
- 552 6
- 2 5
- 123 5
- 154 5
- 181 5
- 453 5
- 507 5
- 515 5
- 578 5
- 150 4
- 151 4
- 185 4
- 192 4
- 197 4
- 465 4
- 487 4
- 490 4
- 495 4
- 501 4
- 6 3
- 127 3
- 152 3
- 156 3
- 171 3
- 172 3
- 175 3
- 178 3
- 183 3
- 188 3
- 191 3
- 342 3
- 418 3
- 424 3
- 459 3
- 463 3
- 474 3
- 486 3
- 519 3
- 525 3
- 535 3
- 546 3
- 559 3
- 568 3
- 593 3
- 610 3
- 1 2
- 3 2
- 17 2
- 18 2
- 20 2
- 21 2
- 37 2
- 39 2
- 47 2
- 73 2
- 110 2
- 115 2
- 116 2
- 118 2
- 121 2
- 130 2
- 136 2
- 140 2
- 143 2
- 144 2
- 145 2
- 149 2
- 166 2
- 168 2
- 170 2
- 176 2
- 202 2
- 226 2
- 229 2
- 238 2
- 277 2
- 322 2
- 380 2
- 391 2
- 405 2
- 421 2
- 428 2
- 429 2
- 445 2
- 446 2
- 448 2
- 450 2
- 454 2
- 455 2
- 457 2
- 464 2
- 473 2
- 494 2
- 513 2
- 518 2
- 524 2
- 556 2
- 577 2
- 7 1
- 10 1
- 11 1
- 12 1
- 13 1
- 15 1
- 16 1
- 22 1
- 27 1
- 28 1
- 32 1
- 40 1
- 43 1
- 45 1
- 46 1
- 48 1
- 55 1
- 57 1
- 61 1
- 66 1
- 68 1
- 79 1
- 82 1
- 86 1
- 90 1
- 93 1
- 95 1
- 96 1
- 98 1
- 99 1
- 103 1
- 107 1
- 109 1
- 111 1
- 128 1
- 131 1
- 133 1
- 135 1
- 137 1
- 138 1
- 141 1
- 147 1
- 148 1
- 153 1
- 173 1
- 177 1
- 180 1
- 187 1
- 194 1
- 195 1
- 198 1
- 200 1
- 204 1
- 206 1
- 207 1
- 210 1
- 211 1
- 212 1
- 213 1
- 215 1
- 217 1
- 220 1
- 221 1
- 223 1
- 227 1
- 228 1
- 234 1
- 240 1
- 249 1
- 253 1
- 256 1
- 262 1
- 269 1
- 271 1
- 275 1
- 276 1
- 283 1
- 288 1
- 291 1
- 294 1
- 300 1
- 302 1
- 303 1
- 308 1
- 312 1
- 315 1
- 318 1
- 323 1
- 327 1
- 329 1
- 334 1
- 340 1
- 345 1
- 346 1
- 348 1
- 351 1
- 354 1
- 358 1
- 361 1
- 362 1
- 368 1
- 372 1
- 376 1
- 377 1
- 384 1
- 386 1
- 387 1
- 389 1
- 393 1
- 396 1
- 398 1
- 401 1
- 403 1
- 404 1
- 407 1
- 408 1
- 410 1
- 411 1
- 413 1
- 415 1
- 422 1
- 427 1
- 430 1
- 435 1
- 437 1
- 438 1
- 440 1
- 441 1
- 442 1
- 443 1
- 444 1
- 452 1
- 467 1
- 468 1
- 472 1
- 477 1
- 479 1
- 480 1
- 482 1
- 491 1
- 492 1
- 496 1
- 499 1
- 500 1
- 503 1
- 505 1
- 506 1
- 512 1
- 520 1
- 523 1
- 526 1
- 527 1
- 529 1
- 532 1
- 534 1
- 540 1
- 542 1
- 543 1
- 547 1
- 551 1
- 554 1
- 560 1
- 562 1
- 565 1
- 566 1
- 570 1
- 573 1
- 581 1
- 587 1
- 598 1
- 600 1
- 607 1
- 608 1
- 619 1
- 624 1
- 630 1
state 1
- Massachusetts 691
fips 1
- 25001 691
county 1
- Barnstable · 691 ✖
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);