ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,552 rows where county = "Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 290 ✖
- 1 217
- 36 86
- 300 69
- 34 34
- 32 30
- 71 26
- 28 25
- 0 23
- 64 23
- 72 22
- 33 20
- 49 20
- 318 20
- 27 19
- 37 19
- 141 19
- 349 19
- 284 17
- 47 16
- 50 16
- 298 15
- 307 14
- 354 14
- 6 13
- 55 13
- 294 13
- 290 12
- 3 11
- 24 11
- 62 11
- 67 11
- 324 11
- 4 10
- 127 10
- 351 10
- 2 9
- 70 8
- 130 8
- 153 8
- 160 8
- 9 7
- 54 7
- 60 7
- 69 7
- 155 7
- 158 7
- 161 7
- 320 7
- 29 6
- 43 6
- 58 6
- 73 6
- 117 6
- 148 6
- 296 6
- 315 6
- 317 6
- 347 6
- 356 6
- 410 6
- 7 5
- 14 5
- 26 5
- 46 5
- 48 5
- 59 5
- 63 5
- 103 5
- 116 5
- 184 5
- 297 5
- 313 5
- 352 5
- 381 5
- 403 5
- 11 4
- 38 4
- 41 4
- 51 4
- 100 4
- 110 4
- 125 4
- 129 4
- 140 4
- 144 4
- 171 4
- 261 4
- 274 4
- 302 4
- 322 4
- 330 4
- 331 4
- 340 4
- 357 4
- 362 4
- 366 4
- 413 4
- 17 3
- 23 3
- 53 3
- 68 3
- 76 3
- 106 3
- 107 3
- 119 3
- 133 3
- 143 3
- 150 3
- 152 3
- 154 3
- 165 3
- 181 3
- 219 3
- 234 3
- 241 3
- 256 3
- 279 3
- 303 3
- 309 3
- 321 3
- 323 3
- 329 3
- 334 3
- 335 3
- 358 3
- 361 3
- 375 3
- 395 3
- 407 3
- 20 2
- 22 2
- 31 2
- 42 2
- 57 2
- 82 2
- 89 2
- 95 2
- 109 2
- 126 2
- 131 2
- 136 2
- 138 2
- 149 2
- 163 2
- 188 2
- 198 2
- 203 2
- 211 2
- 222 2
- 228 2
- 231 2
- 233 2
- 236 2
- 239 2
- 244 2
- 249 2
- 255 2
- 263 2
- 268 2
- 277 2
- 278 2
- 282 2
- 289 2
- 291 2
- 295 2
- 301 2
- 314 2
- 327 2
- 343 2
- 350 2
- 355 2
- 409 2
- 412 2
- 5 1
- 8 1
- 10 1
- 15 1
- 25 1
- 30 1
- 52 1
- 56 1
- 65 1
- 66 1
- 77 1
- 78 1
- 80 1
- 83 1
- 86 1
- 88 1
- 90 1
- 93 1
- 94 1
- 98 1
- 105 1
- 108 1
- 112 1
- 114 1
- 115 1
- 118 1
- 120 1
- 123 1
- 128 1
- 134 1
- 135 1
- 137 1
- 142 1
- 145 1
- 147 1
- 156 1
- 157 1
- 159 1
- 162 1
- 164 1
- 166 1
- 167 1
- 168 1
- 169 1
- 170 1
- 172 1
- 175 1
- 177 1
- 179 1
- 189 1
- 193 1
- 201 1
- 204 1
- 205 1
- 206 1
- 207 1
- 208 1
- 209 1
- 212 1
- 213 1
- 214 1
- 220 1
- 224 1
- 226 1
- 230 1
- 245 1
- 247 1
- 251 1
- 252 1
- 253 1
- 254 1
- 258 1
- 260 1
- 262 1
- 264 1
- 266 1
- 269 1
- 270 1
- 272 1
- 275 1
- 276 1
- 281 1
- 283 1
- 286 1
- 287 1
- 288 1
- 293 1
- 305 1
- 310 1
- 311 1
- 316 1
- 319 1
- 325 1
- 337 1
- 338 1
- 339 1
- 342 1
- 344 1
- 353 1
- 363 1
- 365 1
- 368 1
- 371 1
- 373 1
- 376 1
- 378 1
- 379 1
- 383 1
- 388 1
- 390 1
- 393 1
- 396 1
- 399 1
- 402 1
- 404 1
- 408 1
- 411 1
state 2
- Massachusetts 786
- West Virginia 766
county 1
- Hampshire · 1,552 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500813 | 2500813 | 2022-05-13 | Hampshire | Massachusetts | 25015 | 30837 | 358 |
2502696 | 2502696 | 2022-05-13 | Hampshire | West Virginia | 54027 | 5906 | 73 |
2497555 | 2497555 | 2022-05-12 | Hampshire | Massachusetts | 25015 | 30670 | 358 |
2499438 | 2499438 | 2022-05-12 | Hampshire | West Virginia | 54027 | 5904 | 73 |
2494297 | 2494297 | 2022-05-11 | Hampshire | Massachusetts | 25015 | 30453 | 357 |
2496180 | 2496180 | 2022-05-11 | Hampshire | West Virginia | 54027 | 5902 | 73 |
2491039 | 2491039 | 2022-05-10 | Hampshire | Massachusetts | 25015 | 30279 | 356 |
2492922 | 2492922 | 2022-05-10 | Hampshire | West Virginia | 54027 | 5901 | 73 |
2487782 | 2487782 | 2022-05-09 | Hampshire | Massachusetts | 25015 | 30208 | 356 |
2489664 | 2489664 | 2022-05-09 | Hampshire | West Virginia | 54027 | 5901 | 73 |
2484524 | 2484524 | 2022-05-08 | Hampshire | Massachusetts | 25015 | 29916 | 356 |
2486407 | 2486407 | 2022-05-08 | Hampshire | West Virginia | 54027 | 5893 | 72 |
2481266 | 2481266 | 2022-05-07 | Hampshire | Massachusetts | 25015 | 29916 | 356 |
2483149 | 2483149 | 2022-05-07 | Hampshire | West Virginia | 54027 | 5893 | 72 |
2478008 | 2478008 | 2022-05-06 | Hampshire | Massachusetts | 25015 | 29916 | 356 |
2479891 | 2479891 | 2022-05-06 | Hampshire | West Virginia | 54027 | 5893 | 72 |
2474750 | 2474750 | 2022-05-05 | Hampshire | Massachusetts | 25015 | 29774 | 356 |
2476633 | 2476633 | 2022-05-05 | Hampshire | West Virginia | 54027 | 5883 | 72 |
2471493 | 2471493 | 2022-05-04 | Hampshire | Massachusetts | 25015 | 29625 | 355 |
2473375 | 2473375 | 2022-05-04 | Hampshire | West Virginia | 54027 | 5880 | 72 |
2468237 | 2468237 | 2022-05-03 | Hampshire | Massachusetts | 25015 | 29509 | 354 |
2470118 | 2470118 | 2022-05-03 | Hampshire | West Virginia | 54027 | 5880 | 72 |
2464982 | 2464982 | 2022-05-02 | Hampshire | Massachusetts | 25015 | 29459 | 354 |
2466862 | 2466862 | 2022-05-02 | Hampshire | West Virginia | 54027 | 5879 | 72 |
2461726 | 2461726 | 2022-05-01 | Hampshire | Massachusetts | 25015 | 29232 | 354 |
2463607 | 2463607 | 2022-05-01 | Hampshire | West Virginia | 54027 | 5872 | 72 |
2458470 | 2458470 | 2022-04-30 | Hampshire | Massachusetts | 25015 | 29232 | 354 |
2460351 | 2460351 | 2022-04-30 | Hampshire | West Virginia | 54027 | 5872 | 72 |
2455214 | 2455214 | 2022-04-29 | Hampshire | Massachusetts | 25015 | 29232 | 354 |
2457095 | 2457095 | 2022-04-29 | Hampshire | West Virginia | 54027 | 5872 | 72 |
2451958 | 2451958 | 2022-04-28 | Hampshire | Massachusetts | 25015 | 29137 | 354 |
2453839 | 2453839 | 2022-04-28 | Hampshire | West Virginia | 54027 | 5868 | 72 |
2448702 | 2448702 | 2022-04-27 | Hampshire | Massachusetts | 25015 | 29041 | 354 |
2450583 | 2450583 | 2022-04-27 | Hampshire | West Virginia | 54027 | 5863 | 72 |
2445446 | 2445446 | 2022-04-26 | Hampshire | Massachusetts | 25015 | 28936 | 354 |
2447327 | 2447327 | 2022-04-26 | Hampshire | West Virginia | 54027 | 5857 | 72 |
2442190 | 2442190 | 2022-04-25 | Hampshire | Massachusetts | 25015 | 28899 | 354 |
2444071 | 2444071 | 2022-04-25 | Hampshire | West Virginia | 54027 | 5854 | 72 |
2438934 | 2438934 | 2022-04-24 | Hampshire | Massachusetts | 25015 | 28736 | 354 |
2440815 | 2440815 | 2022-04-24 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2435678 | 2435678 | 2022-04-23 | Hampshire | Massachusetts | 25015 | 28736 | 354 |
2437559 | 2437559 | 2022-04-23 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2432422 | 2432422 | 2022-04-22 | Hampshire | Massachusetts | 25015 | 28736 | 354 |
2434303 | 2434303 | 2022-04-22 | Hampshire | West Virginia | 54027 | 5846 | 72 |
2429166 | 2429166 | 2022-04-21 | Hampshire | Massachusetts | 25015 | 28669 | 354 |
2431047 | 2431047 | 2022-04-21 | Hampshire | West Virginia | 54027 | 5842 | 72 |
2425910 | 2425910 | 2022-04-20 | Hampshire | Massachusetts | 25015 | 28585 | 354 |
2427791 | 2427791 | 2022-04-20 | Hampshire | West Virginia | 54027 | 5841 | 72 |
2422654 | 2422654 | 2022-04-19 | Hampshire | Massachusetts | 25015 | 28534 | 353 |
2424535 | 2424535 | 2022-04-19 | Hampshire | West Virginia | 54027 | 5837 | 72 |
2419398 | 2419398 | 2022-04-18 | Hampshire | Massachusetts | 25015 | 28332 | 352 |
2421279 | 2421279 | 2022-04-18 | Hampshire | West Virginia | 54027 | 5837 | 71 |
2416142 | 2416142 | 2022-04-17 | Hampshire | Massachusetts | 25015 | 28332 | 352 |
2418023 | 2418023 | 2022-04-17 | Hampshire | West Virginia | 54027 | 5830 | 71 |
2412886 | 2412886 | 2022-04-16 | Hampshire | Massachusetts | 25015 | 28332 | 352 |
2414767 | 2414767 | 2022-04-16 | Hampshire | West Virginia | 54027 | 5830 | 71 |
2409630 | 2409630 | 2022-04-15 | Hampshire | Massachusetts | 25015 | 28332 | 352 |
2411511 | 2411511 | 2022-04-15 | Hampshire | West Virginia | 54027 | 5830 | 71 |
2406374 | 2406374 | 2022-04-14 | Hampshire | Massachusetts | 25015 | 28238 | 351 |
2408255 | 2408255 | 2022-04-14 | Hampshire | West Virginia | 54027 | 5825 | 71 |
2403118 | 2403118 | 2022-04-13 | Hampshire | Massachusetts | 25015 | 28078 | 351 |
2404999 | 2404999 | 2022-04-13 | Hampshire | West Virginia | 54027 | 5824 | 71 |
2399864 | 2399864 | 2022-04-12 | Hampshire | Massachusetts | 25015 | 28019 | 351 |
2401744 | 2401744 | 2022-04-12 | Hampshire | West Virginia | 54027 | 5829 | 71 |
2396608 | 2396608 | 2022-04-11 | Hampshire | Massachusetts | 25015 | 27991 | 351 |
2398489 | 2398489 | 2022-04-11 | Hampshire | West Virginia | 54027 | 5826 | 71 |
2393353 | 2393353 | 2022-04-10 | Hampshire | Massachusetts | 25015 | 27870 | 351 |
2395234 | 2395234 | 2022-04-10 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2390097 | 2390097 | 2022-04-09 | Hampshire | Massachusetts | 25015 | 27870 | 351 |
2391978 | 2391978 | 2022-04-09 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2386841 | 2386841 | 2022-04-08 | Hampshire | Massachusetts | 25015 | 27870 | 351 |
2388722 | 2388722 | 2022-04-08 | Hampshire | West Virginia | 54027 | 5822 | 71 |
2383586 | 2383586 | 2022-04-07 | Hampshire | Massachusetts | 25015 | 27817 | 351 |
2385467 | 2385467 | 2022-04-07 | Hampshire | West Virginia | 54027 | 5821 | 71 |
2380331 | 2380331 | 2022-04-06 | Hampshire | Massachusetts | 25015 | 27769 | 351 |
2382212 | 2382212 | 2022-04-06 | Hampshire | West Virginia | 54027 | 5818 | 71 |
2377076 | 2377076 | 2022-04-05 | Hampshire | Massachusetts | 25015 | 27733 | 350 |
2378957 | 2378957 | 2022-04-05 | Hampshire | West Virginia | 54027 | 5818 | 71 |
2373824 | 2373824 | 2022-04-04 | Hampshire | Massachusetts | 25015 | 27718 | 350 |
2375703 | 2375703 | 2022-04-04 | Hampshire | West Virginia | 54027 | 5817 | 71 |
2370571 | 2370571 | 2022-04-03 | Hampshire | Massachusetts | 25015 | 27645 | 349 |
2372451 | 2372451 | 2022-04-03 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2367318 | 2367318 | 2022-04-02 | Hampshire | Massachusetts | 25015 | 27645 | 349 |
2369198 | 2369198 | 2022-04-02 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2364065 | 2364065 | 2022-04-01 | Hampshire | Massachusetts | 25015 | 27645 | 349 |
2365945 | 2365945 | 2022-04-01 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2360811 | 2360811 | 2022-03-31 | Hampshire | Massachusetts | 25015 | 27609 | 349 |
2362692 | 2362692 | 2022-03-31 | Hampshire | West Virginia | 54027 | 5814 | 71 |
2357557 | 2357557 | 2022-03-30 | Hampshire | Massachusetts | 25015 | 27573 | 349 |
2359438 | 2359438 | 2022-03-30 | Hampshire | West Virginia | 54027 | 5815 | 71 |
2354304 | 2354304 | 2022-03-29 | Hampshire | Massachusetts | 25015 | 27526 | 349 |
2356184 | 2356184 | 2022-03-29 | Hampshire | West Virginia | 54027 | 5814 | 71 |
2351052 | 2351052 | 2022-03-28 | Hampshire | Massachusetts | 25015 | 27514 | 349 |
2352931 | 2352931 | 2022-03-28 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2347799 | 2347799 | 2022-03-27 | Hampshire | Massachusetts | 25015 | 27442 | 349 |
2349679 | 2349679 | 2022-03-27 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2344546 | 2344546 | 2022-03-26 | Hampshire | Massachusetts | 25015 | 27442 | 349 |
2346426 | 2346426 | 2022-03-26 | Hampshire | West Virginia | 54027 | 5811 | 71 |
2341293 | 2341293 | 2022-03-25 | Hampshire | Massachusetts | 25015 | 27442 | 349 |
2343173 | 2343173 | 2022-03-25 | Hampshire | West Virginia | 54027 | 5811 | 71 |
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);