ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Berkshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 226 ✖
- 46 45
- 52 29
- 288 29
- 45 27
- 51 22
- 282 21
- 287 17
- 37 16
- 0 15
- 286 15
- 44 14
- 290 14
- 40 12
- 49 12
- 323 11
- 368 11
- 285 10
- 304 9
- 331 9
- 374 9
- 312 8
- 335 8
- 375 8
- 31 7
- 42 7
- 50 7
- 281 7
- 289 7
- 313 7
- 315 7
- 262 6
- 301 6
- 330 6
- 336 6
- 365 6
- 370 6
- 404 6
- 36 5
- 269 5
- 283 5
- 303 5
- 309 5
- 327 5
- 333 5
- 371 5
- 378 5
- 22 4
- 38 4
- 41 4
- 261 4
- 306 4
- 340 4
- 344 4
- 350 4
- 352 4
- 369 4
- 373 4
- 377 4
- 381 4
- 394 4
- 2 3
- 47 3
- 138 3
- 239 3
- 264 3
- 275 3
- 297 3
- 318 3
- 320 3
- 321 3
- 322 3
- 351 3
- 361 3
- 388 3
- 392 3
- 401 3
- 410 3
- 1 2
- 4 2
- 5 2
- 6 2
- 7 2
- 13 2
- 23 2
- 26 2
- 29 2
- 53 2
- 66 2
- 120 2
- 125 2
- 163 2
- 184 2
- 242 2
- 248 2
- 251 2
- 254 2
- 267 2
- 268 2
- 271 2
- 276 2
- 278 2
- 279 2
- 293 2
- 302 2
- 310 2
- 316 2
- 337 2
- 341 2
- 349 2
- 366 2
- 372 2
- 408 2
- 10 1
- 18 1
- 20 1
- 21 1
- 27 1
- 28 1
- 34 1
- 35 1
- 39 1
- 54 1
- 55 1
- 61 1
- 63 1
- 64 1
- 65 1
- 68 1
- 73 1
- 77 1
- 81 1
- 87 1
- 91 1
- 95 1
- 97 1
- 101 1
- 103 1
- 105 1
- 112 1
- 114 1
- 116 1
- 117 1
- 119 1
- 121 1
- 126 1
- 129 1
- 131 1
- 132 1
- 136 1
- 144 1
- 145 1
- 150 1
- 155 1
- 157 1
- 158 1
- 164 1
- 166 1
- 172 1
- 178 1
- 180 1
- 183 1
- 187 1
- 190 1
- 192 1
- 193 1
- 194 1
- 195 1
- 199 1
- 200 1
- 204 1
- 206 1
- 212 1
- 215 1
- 216 1
- 217 1
- 220 1
- 222 1
- 224 1
- 226 1
- 229 1
- 230 1
- 234 1
- 237 1
- 240 1
- 243 1
- 244 1
- 246 1
- 250 1
- 257 1
- 258 1
- 263 1
- 265 1
- 266 1
- 272 1
- 277 1
- 295 1
- 298 1
- 299 1
- 307 1
- 319 1
- 324 1
- 325 1
- 328 1
- 332 1
- 338 1
- 342 1
- 347 1
- 353 1
- 357 1
- 358 1
- 362 1
- 364 1
- 367 1
- 376 1
- 379 1
- 382 1
- 383 1
- 385 1
- 387 1
- 389 1
- 395 1
- 399 1
- 400 1
- 402 1
- 403 1
- 407 1
state 1
- Massachusetts 798
fips 1
- 25003 798
county 1
- Berkshire · 798 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500807 | 2500807 | 2022-05-13 | Berkshire | Massachusetts | 25003 | 26169 | 378 |
2497549 | 2497549 | 2022-05-12 | Berkshire | Massachusetts | 25003 | 26008 | 378 |
2494291 | 2494291 | 2022-05-11 | Berkshire | Massachusetts | 25003 | 25834 | 378 |
2491033 | 2491033 | 2022-05-10 | Berkshire | Massachusetts | 25003 | 25674 | 378 |
2487776 | 2487776 | 2022-05-09 | Berkshire | Massachusetts | 25003 | 25586 | 377 |
2484518 | 2484518 | 2022-05-08 | Berkshire | Massachusetts | 25003 | 25244 | 377 |
2481260 | 2481260 | 2022-05-07 | Berkshire | Massachusetts | 25003 | 25244 | 377 |
2478002 | 2478002 | 2022-05-06 | Berkshire | Massachusetts | 25003 | 25244 | 377 |
2474744 | 2474744 | 2022-05-05 | Berkshire | Massachusetts | 25003 | 25098 | 376 |
2471487 | 2471487 | 2022-05-04 | Berkshire | Massachusetts | 25003 | 24944 | 375 |
2468231 | 2468231 | 2022-05-03 | Berkshire | Massachusetts | 25003 | 24822 | 375 |
2464976 | 2464976 | 2022-05-02 | Berkshire | Massachusetts | 25003 | 24761 | 375 |
2461720 | 2461720 | 2022-05-01 | Berkshire | Massachusetts | 25003 | 24526 | 375 |
2458464 | 2458464 | 2022-04-30 | Berkshire | Massachusetts | 25003 | 24526 | 375 |
2455208 | 2455208 | 2022-04-29 | Berkshire | Massachusetts | 25003 | 24526 | 375 |
2451952 | 2451952 | 2022-04-28 | Berkshire | Massachusetts | 25003 | 24412 | 375 |
2448696 | 2448696 | 2022-04-27 | Berkshire | Massachusetts | 25003 | 24319 | 375 |
2445440 | 2445440 | 2022-04-26 | Berkshire | Massachusetts | 25003 | 24216 | 374 |
2442184 | 2442184 | 2022-04-25 | Berkshire | Massachusetts | 25003 | 24157 | 374 |
2438928 | 2438928 | 2022-04-24 | Berkshire | Massachusetts | 25003 | 23990 | 374 |
2435672 | 2435672 | 2022-04-23 | Berkshire | Massachusetts | 25003 | 23990 | 374 |
2432416 | 2432416 | 2022-04-22 | Berkshire | Massachusetts | 25003 | 23990 | 374 |
2429160 | 2429160 | 2022-04-21 | Berkshire | Massachusetts | 25003 | 23931 | 374 |
2425904 | 2425904 | 2022-04-20 | Berkshire | Massachusetts | 25003 | 23882 | 374 |
2422648 | 2422648 | 2022-04-19 | Berkshire | Massachusetts | 25003 | 23800 | 374 |
2419392 | 2419392 | 2022-04-18 | Berkshire | Massachusetts | 25003 | 23627 | 373 |
2416136 | 2416136 | 2022-04-17 | Berkshire | Massachusetts | 25003 | 23627 | 373 |
2412880 | 2412880 | 2022-04-16 | Berkshire | Massachusetts | 25003 | 23627 | 373 |
2409624 | 2409624 | 2022-04-15 | Berkshire | Massachusetts | 25003 | 23627 | 373 |
2406368 | 2406368 | 2022-04-14 | Berkshire | Massachusetts | 25003 | 23565 | 372 |
2403112 | 2403112 | 2022-04-13 | Berkshire | Massachusetts | 25003 | 23515 | 372 |
2399858 | 2399858 | 2022-04-12 | Berkshire | Massachusetts | 25003 | 23451 | 371 |
2396602 | 2396602 | 2022-04-11 | Berkshire | Massachusetts | 25003 | 23429 | 371 |
2393347 | 2393347 | 2022-04-10 | Berkshire | Massachusetts | 25003 | 23333 | 371 |
2390091 | 2390091 | 2022-04-09 | Berkshire | Massachusetts | 25003 | 23333 | 371 |
2386835 | 2386835 | 2022-04-08 | Berkshire | Massachusetts | 25003 | 23333 | 371 |
2383580 | 2383580 | 2022-04-07 | Berkshire | Massachusetts | 25003 | 23289 | 370 |
2380325 | 2380325 | 2022-04-06 | Berkshire | Massachusetts | 25003 | 23256 | 370 |
2377070 | 2377070 | 2022-04-05 | Berkshire | Massachusetts | 25003 | 23223 | 370 |
2373818 | 2373818 | 2022-04-04 | Berkshire | Massachusetts | 25003 | 23199 | 369 |
2370565 | 2370565 | 2022-04-03 | Berkshire | Massachusetts | 25003 | 23130 | 369 |
2367312 | 2367312 | 2022-04-02 | Berkshire | Massachusetts | 25003 | 23130 | 369 |
2364059 | 2364059 | 2022-04-01 | Berkshire | Massachusetts | 25003 | 23130 | 369 |
2360805 | 2360805 | 2022-03-31 | Berkshire | Massachusetts | 25003 | 23091 | 368 |
2357551 | 2357551 | 2022-03-30 | Berkshire | Massachusetts | 25003 | 23049 | 368 |
2354298 | 2354298 | 2022-03-29 | Berkshire | Massachusetts | 25003 | 23016 | 368 |
2351046 | 2351046 | 2022-03-28 | Berkshire | Massachusetts | 25003 | 22989 | 368 |
2347793 | 2347793 | 2022-03-27 | Berkshire | Massachusetts | 25003 | 22939 | 368 |
2344540 | 2344540 | 2022-03-26 | Berkshire | Massachusetts | 25003 | 22939 | 368 |
2341287 | 2341287 | 2022-03-25 | Berkshire | Massachusetts | 25003 | 22939 | 368 |
2338034 | 2338034 | 2022-03-24 | Berkshire | Massachusetts | 25003 | 22922 | 368 |
2334780 | 2334780 | 2022-03-23 | Berkshire | Massachusetts | 25003 | 22910 | 368 |
2331526 | 2331526 | 2022-03-22 | Berkshire | Massachusetts | 25003 | 22894 | 368 |
2328274 | 2328274 | 2022-03-21 | Berkshire | Massachusetts | 25003 | 22883 | 368 |
2325021 | 2325021 | 2022-03-20 | Berkshire | Massachusetts | 25003 | 22848 | 365 |
2321767 | 2321767 | 2022-03-19 | Berkshire | Massachusetts | 25003 | 22848 | 365 |
2318513 | 2318513 | 2022-03-18 | Berkshire | Massachusetts | 25003 | 22848 | 365 |
2315260 | 2315260 | 2022-03-17 | Berkshire | Massachusetts | 25003 | 22831 | 365 |
2312007 | 2312007 | 2022-03-16 | Berkshire | Massachusetts | 25003 | 22818 | 365 |
2308754 | 2308754 | 2022-03-15 | Berkshire | Massachusetts | 25003 | 22801 | 365 |
2305503 | 2305503 | 2022-03-14 | Berkshire | Massachusetts | 25003 | 22789 | 364 |
2302251 | 2302251 | 2022-03-13 | Berkshire | Massachusetts | 25003 | 22743 | 410 |
2298999 | 2298999 | 2022-03-12 | Berkshire | Massachusetts | 25003 | 22743 | 410 |
2295747 | 2295747 | 2022-03-11 | Berkshire | Massachusetts | 25003 | 22743 | 410 |
2292495 | 2292495 | 2022-03-10 | Berkshire | Massachusetts | 25003 | 22726 | 408 |
2289243 | 2289243 | 2022-03-09 | Berkshire | Massachusetts | 25003 | 22711 | 408 |
2285992 | 2285992 | 2022-03-08 | Berkshire | Massachusetts | 25003 | 22688 | 407 |
2282740 | 2282740 | 2022-03-07 | Berkshire | Massachusetts | 25003 | 22674 | 404 |
2279487 | 2279487 | 2022-03-06 | Berkshire | Massachusetts | 25003 | 22623 | 404 |
2276234 | 2276234 | 2022-03-05 | Berkshire | Massachusetts | 25003 | 22623 | 404 |
2272981 | 2272981 | 2022-03-04 | Berkshire | Massachusetts | 25003 | 22623 | 404 |
2269729 | 2269729 | 2022-03-03 | Berkshire | Massachusetts | 25003 | 22586 | 404 |
2266476 | 2266476 | 2022-03-02 | Berkshire | Massachusetts | 25003 | 22568 | 404 |
2263225 | 2263225 | 2022-03-01 | Berkshire | Massachusetts | 25003 | 22536 | 403 |
2259974 | 2259974 | 2022-02-28 | Berkshire | Massachusetts | 25003 | 22497 | 402 |
2256723 | 2256723 | 2022-02-27 | Berkshire | Massachusetts | 25003 | 22449 | 401 |
2253472 | 2253472 | 2022-02-26 | Berkshire | Massachusetts | 25003 | 22449 | 401 |
2250221 | 2250221 | 2022-02-25 | Berkshire | Massachusetts | 25003 | 22449 | 401 |
2246970 | 2246970 | 2022-02-24 | Berkshire | Massachusetts | 25003 | 22397 | 400 |
2243719 | 2243719 | 2022-02-23 | Berkshire | Massachusetts | 25003 | 22364 | 399 |
2240468 | 2240468 | 2022-02-22 | Berkshire | Massachusetts | 25003 | 22352 | 395 |
2237217 | 2237217 | 2022-02-21 | Berkshire | Massachusetts | 25003 | 22210 | 394 |
2233966 | 2233966 | 2022-02-20 | Berkshire | Massachusetts | 25003 | 22210 | 394 |
2230715 | 2230715 | 2022-02-19 | Berkshire | Massachusetts | 25003 | 22210 | 394 |
2227464 | 2227464 | 2022-02-18 | Berkshire | Massachusetts | 25003 | 22210 | 394 |
2224213 | 2224213 | 2022-02-17 | Berkshire | Massachusetts | 25003 | 22166 | 392 |
2220962 | 2220962 | 2022-02-16 | Berkshire | Massachusetts | 25003 | 22066 | 392 |
2217711 | 2217711 | 2022-02-15 | Berkshire | Massachusetts | 25003 | 21946 | 392 |
2214460 | 2214460 | 2022-02-14 | Berkshire | Massachusetts | 25003 | 21935 | 389 |
2211208 | 2211208 | 2022-02-13 | Berkshire | Massachusetts | 25003 | 21820 | 388 |
2207955 | 2207955 | 2022-02-12 | Berkshire | Massachusetts | 25003 | 21820 | 388 |
2204702 | 2204702 | 2022-02-11 | Berkshire | Massachusetts | 25003 | 21820 | 388 |
2201449 | 2201449 | 2022-02-10 | Berkshire | Massachusetts | 25003 | 21741 | 387 |
2198195 | 2198195 | 2022-02-09 | Berkshire | Massachusetts | 25003 | 21634 | 385 |
2194941 | 2194941 | 2022-02-08 | Berkshire | Massachusetts | 25003 | 21500 | 383 |
2191687 | 2191687 | 2022-02-07 | Berkshire | Massachusetts | 25003 | 21440 | 382 |
2188434 | 2188434 | 2022-02-06 | Berkshire | Massachusetts | 25003 | 21178 | 381 |
2185181 | 2185181 | 2022-02-05 | Berkshire | Massachusetts | 25003 | 21178 | 381 |
2181929 | 2181929 | 2022-02-04 | Berkshire | Massachusetts | 25003 | 21178 | 381 |
2178677 | 2178677 | 2022-02-03 | Berkshire | Massachusetts | 25003 | 21021 | 381 |
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);