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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|
4735 | 4735 | 2020-03-19 | Hampshire | Massachusetts | 25015 | 1 | 0 |
5554 | 5554 | 2020-03-20 | Hampshire | Massachusetts | 25015 | 2 | 0 |
6513 | 6513 | 2020-03-21 | Hampshire | Massachusetts | 25015 | 2 | 0 |
7590 | 7590 | 2020-03-22 | Hampshire | Massachusetts | 25015 | 4 | 0 |
8762 | 8762 | 2020-03-23 | Hampshire | Massachusetts | 25015 | 6 | 0 |
10051 | 10051 | 2020-03-24 | Hampshire | Massachusetts | 25015 | 8 | 0 |
11463 | 11463 | 2020-03-25 | Hampshire | Massachusetts | 25015 | 11 | 0 |
13044 | 13044 | 2020-03-26 | Hampshire | Massachusetts | 25015 | 17 | 0 |
14752 | 14752 | 2020-03-27 | Hampshire | Massachusetts | 25015 | 20 | 0 |
16572 | 16572 | 2020-03-28 | Hampshire | Massachusetts | 25015 | 30 | 0 |
18487 | 18487 | 2020-03-29 | Hampshire | Massachusetts | 25015 | 37 | 0 |
20503 | 20503 | 2020-03-30 | Hampshire | Massachusetts | 25015 | 46 | 0 |
22612 | 22612 | 2020-03-31 | Hampshire | Massachusetts | 25015 | 69 | 1 |
24791 | 24791 | 2020-04-01 | Hampshire | Massachusetts | 25015 | 81 | 1 |
27043 | 27043 | 2020-04-02 | Hampshire | Massachusetts | 25015 | 102 | 2 |
29361 | 29361 | 2020-04-03 | Hampshire | Massachusetts | 25015 | 114 | 3 |
31739 | 31739 | 2020-04-04 | Hampshire | Massachusetts | 25015 | 125 | 3 |
34164 | 34164 | 2020-04-05 | Hampshire | Massachusetts | 25015 | 128 | 3 |
36623 | 36623 | 2020-04-06 | Hampshire | Massachusetts | 25015 | 147 | 3 |
39131 | 39131 | 2020-04-07 | Hampshire | Massachusetts | 25015 | 158 | 3 |
41683 | 41683 | 2020-04-08 | Hampshire | Massachusetts | 25015 | 164 | 3 |
44259 | 44259 | 2020-04-09 | Hampshire | Massachusetts | 25015 | 177 | 3 |
46867 | 46867 | 2020-04-10 | Hampshire | Massachusetts | 25015 | 194 | 4 |
49509 | 49509 | 2020-04-11 | Hampshire | Massachusetts | 25015 | 204 | 5 |
52179 | 52179 | 2020-04-12 | Hampshire | Massachusetts | 25015 | 219 | 6 |
54860 | 54860 | 2020-04-13 | Hampshire | Massachusetts | 25015 | 224 | 6 |
57558 | 57558 | 2020-04-14 | Hampshire | Massachusetts | 25015 | 233 | 6 |
60267 | 60267 | 2020-04-15 | Hampshire | Massachusetts | 25015 | 239 | 6 |
62988 | 62988 | 2020-04-16 | Hampshire | Massachusetts | 25015 | 248 | 6 |
65726 | 65726 | 2020-04-17 | Hampshire | Massachusetts | 25015 | 258 | 7 |
68476 | 68476 | 2020-04-18 | Hampshire | Massachusetts | 25015 | 306 | 7 |
71240 | 71240 | 2020-04-19 | Hampshire | Massachusetts | 25015 | 317 | 7 |
74012 | 74012 | 2020-04-20 | Hampshire | Massachusetts | 25015 | 332 | 9 |
76792 | 76792 | 2020-04-21 | Hampshire | Massachusetts | 25015 | 337 | 10 |
79578 | 79578 | 2020-04-22 | Hampshire | Massachusetts | 25015 | 345 | 14 |
82373 | 82373 | 2020-04-23 | Hampshire | Massachusetts | 25015 | 367 | 15 |
85177 | 85177 | 2020-04-24 | Hampshire | Massachusetts | 25015 | 396 | 17 |
87987 | 87987 | 2020-04-25 | Hampshire | Massachusetts | 25015 | 412 | 20 |
90803 | 90803 | 2020-04-26 | Hampshire | Massachusetts | 25015 | 427 | 24 |
93624 | 93624 | 2020-04-27 | Hampshire | Massachusetts | 25015 | 443 | 26 |
96459 | 96459 | 2020-04-28 | Hampshire | Massachusetts | 25015 | 509 | 27 |
99305 | 99305 | 2020-04-29 | Hampshire | Massachusetts | 25015 | 531 | 26 |
102157 | 102157 | 2020-04-30 | Hampshire | Massachusetts | 25015 | 546 | 30 |
105017 | 105017 | 2020-05-01 | Hampshire | Massachusetts | 25015 | 518 | 32 |
107881 | 107881 | 2020-05-02 | Hampshire | Massachusetts | 25015 | 549 | 33 |
110753 | 110753 | 2020-05-03 | Hampshire | Massachusetts | 25015 | 559 | 36 |
113631 | 113631 | 2020-05-04 | Hampshire | Massachusetts | 25015 | 563 | 36 |
116512 | 116512 | 2020-05-05 | Hampshire | Massachusetts | 25015 | 575 | 47 |
119473 | 119473 | 2020-05-06 | Hampshire | Massachusetts | 25015 | 580 | 47 |
122445 | 122445 | 2020-05-07 | Hampshire | Massachusetts | 25015 | 595 | 48 |
125427 | 125427 | 2020-05-08 | Hampshire | Massachusetts | 25015 | 654 | 48 |
128414 | 128414 | 2020-05-09 | Hampshire | Massachusetts | 25015 | 659 | 50 |
131404 | 131404 | 2020-05-10 | Hampshire | Massachusetts | 25015 | 676 | 55 |
134395 | 134395 | 2020-05-11 | Hampshire | Massachusetts | 25015 | 688 | 57 |
137385 | 137385 | 2020-05-12 | Hampshire | Massachusetts | 25015 | 702 | 57 |
140379 | 140379 | 2020-05-13 | Hampshire | Massachusetts | 25015 | 708 | 64 |
143374 | 143374 | 2020-05-14 | Hampshire | Massachusetts | 25015 | 724 | 66 |
146374 | 146374 | 2020-05-15 | Hampshire | Massachusetts | 25015 | 738 | 67 |
149379 | 149379 | 2020-05-16 | Hampshire | Massachusetts | 25015 | 751 | 69 |
152390 | 152390 | 2020-05-17 | Hampshire | Massachusetts | 25015 | 767 | 72 |
155404 | 155404 | 2020-05-18 | Hampshire | Massachusetts | 25015 | 774 | 72 |
158422 | 158422 | 2020-05-19 | Hampshire | Massachusetts | 25015 | 780 | 73 |
161448 | 161448 | 2020-05-20 | Hampshire | Massachusetts | 25015 | 792 | 76 |
164477 | 164477 | 2020-05-21 | Hampshire | Massachusetts | 25015 | 806 | 76 |
167513 | 167513 | 2020-05-22 | Hampshire | Massachusetts | 25015 | 812 | 76 |
170550 | 170550 | 2020-05-23 | Hampshire | Massachusetts | 25015 | 819 | 77 |
173592 | 173592 | 2020-05-24 | Hampshire | Massachusetts | 25015 | 830 | 78 |
176635 | 176635 | 2020-05-25 | Hampshire | Massachusetts | 25015 | 834 | 80 |
179679 | 179679 | 2020-05-26 | Hampshire | Massachusetts | 25015 | 840 | 82 |
182725 | 182725 | 2020-05-27 | Hampshire | Massachusetts | 25015 | 843 | 82 |
185780 | 185780 | 2020-05-28 | Hampshire | Massachusetts | 25015 | 845 | 83 |
188838 | 188838 | 2020-05-29 | Hampshire | Massachusetts | 25015 | 853 | 86 |
191902 | 191902 | 2020-05-30 | Hampshire | Massachusetts | 25015 | 855 | 88 |
194970 | 194970 | 2020-05-31 | Hampshire | Massachusetts | 25015 | 855 | 89 |
198041 | 198041 | 2020-06-01 | Hampshire | Massachusetts | 25015 | 886 | 89 |
201113 | 201113 | 2020-06-02 | Hampshire | Massachusetts | 25015 | 883 | 90 |
204190 | 204190 | 2020-06-03 | Hampshire | Massachusetts | 25015 | 891 | 93 |
207271 | 207271 | 2020-06-04 | Hampshire | Massachusetts | 25015 | 894 | 94 |
210352 | 210352 | 2020-06-05 | Hampshire | Massachusetts | 25015 | 900 | 95 |
213436 | 213436 | 2020-06-06 | Hampshire | Massachusetts | 25015 | 904 | 95 |
216524 | 216524 | 2020-06-07 | Hampshire | Massachusetts | 25015 | 905 | 98 |
219616 | 219616 | 2020-06-08 | Hampshire | Massachusetts | 25015 | 907 | 100 |
222711 | 222711 | 2020-06-09 | Hampshire | Massachusetts | 25015 | 905 | 100 |
225807 | 225807 | 2020-06-10 | Hampshire | Massachusetts | 25015 | 905 | 100 |
228909 | 228909 | 2020-06-11 | Hampshire | Massachusetts | 25015 | 913 | 100 |
232013 | 232013 | 2020-06-12 | Hampshire | Massachusetts | 25015 | 918 | 103 |
235118 | 235118 | 2020-06-13 | Hampshire | Massachusetts | 25015 | 921 | 103 |
238225 | 238225 | 2020-06-14 | Hampshire | Massachusetts | 25015 | 924 | 103 |
241334 | 241334 | 2020-06-15 | Hampshire | Massachusetts | 25015 | 926 | 103 |
244445 | 244445 | 2020-06-16 | Hampshire | Massachusetts | 25015 | 930 | 103 |
247558 | 247558 | 2020-06-17 | Hampshire | Massachusetts | 25015 | 936 | 105 |
250670 | 250670 | 2020-06-18 | Hampshire | Massachusetts | 25015 | 936 | 106 |
253785 | 253785 | 2020-06-19 | Hampshire | Massachusetts | 25015 | 941 | 106 |
256905 | 256905 | 2020-06-20 | Hampshire | Massachusetts | 25015 | 943 | 106 |
260031 | 260031 | 2020-06-21 | Hampshire | Massachusetts | 25015 | 944 | 107 |
263160 | 263160 | 2020-06-22 | Hampshire | Massachusetts | 25015 | 946 | 107 |
266286 | 266286 | 2020-06-23 | Hampshire | Massachusetts | 25015 | 947 | 107 |
269419 | 269419 | 2020-06-24 | Hampshire | Massachusetts | 25015 | 950 | 108 |
272556 | 272556 | 2020-06-25 | Hampshire | Massachusetts | 25015 | 952 | 109 |
275699 | 275699 | 2020-06-26 | Hampshire | Massachusetts | 25015 | 952 | 109 |
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);