ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Berkshire" and fips = 25003 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
702 | 702 | 2020-03-07 | Berkshire | Massachusetts | 25003 | 1 | 0 |
804 | 804 | 2020-03-08 | Berkshire | Massachusetts | 25003 | 1 | 0 |
928 | 928 | 2020-03-09 | Berkshire | Massachusetts | 25003 | 5 | 0 |
1074 | 1074 | 2020-03-10 | Berkshire | Massachusetts | 25003 | 7 | 0 |
1254 | 1254 | 2020-03-11 | Berkshire | Massachusetts | 25003 | 9 | 0 |
1472 | 1472 | 2020-03-12 | Berkshire | Massachusetts | 25003 | 9 | 0 |
1751 | 1751 | 2020-03-13 | Berkshire | Massachusetts | 25003 | 9 | 0 |
2093 | 2093 | 2020-03-14 | Berkshire | Massachusetts | 25003 | 9 | 0 |
2494 | 2494 | 2020-03-15 | Berkshire | Massachusetts | 25003 | 9 | 0 |
2943 | 2943 | 2020-03-16 | Berkshire | Massachusetts | 25003 | 11 | 0 |
3444 | 3444 | 2020-03-17 | Berkshire | Massachusetts | 25003 | 14 | 0 |
4026 | 4026 | 2020-03-18 | Berkshire | Massachusetts | 25003 | 17 | 0 |
4730 | 4730 | 2020-03-19 | Berkshire | Massachusetts | 25003 | 18 | 0 |
5549 | 5549 | 2020-03-20 | Berkshire | Massachusetts | 25003 | 20 | 0 |
6508 | 6508 | 2020-03-21 | Berkshire | Massachusetts | 25003 | 21 | 0 |
7585 | 7585 | 2020-03-22 | Berkshire | Massachusetts | 25003 | 23 | 1 |
8757 | 8757 | 2020-03-23 | Berkshire | Massachusetts | 25003 | 26 | 1 |
10046 | 10046 | 2020-03-24 | Berkshire | Massachusetts | 25003 | 37 | 2 |
11457 | 11457 | 2020-03-25 | Berkshire | Massachusetts | 25003 | 71 | 2 |
13038 | 13038 | 2020-03-26 | Berkshire | Massachusetts | 25003 | 73 | 2 |
14746 | 14746 | 2020-03-27 | Berkshire | Massachusetts | 25003 | 105 | 4 |
16566 | 16566 | 2020-03-28 | Berkshire | Massachusetts | 25003 | 119 | 4 |
18481 | 18481 | 2020-03-29 | Berkshire | Massachusetts | 25003 | 151 | 5 |
20497 | 20497 | 2020-03-30 | Berkshire | Massachusetts | 25003 | 162 | 5 |
22606 | 22606 | 2020-03-31 | Berkshire | Massachusetts | 25003 | 171 | 6 |
24785 | 24785 | 2020-04-01 | Berkshire | Massachusetts | 25003 | 183 | 6 |
27037 | 27037 | 2020-04-02 | Berkshire | Massachusetts | 25003 | 213 | 7 |
29355 | 29355 | 2020-04-03 | Berkshire | Massachusetts | 25003 | 240 | 7 |
31733 | 31733 | 2020-04-04 | Berkshire | Massachusetts | 25003 | 253 | 10 |
34158 | 34158 | 2020-04-05 | Berkshire | Massachusetts | 25003 | 258 | 13 |
36617 | 36617 | 2020-04-06 | Berkshire | Massachusetts | 25003 | 268 | 13 |
39125 | 39125 | 2020-04-07 | Berkshire | Massachusetts | 25003 | 278 | 18 |
41677 | 41677 | 2020-04-08 | Berkshire | Massachusetts | 25003 | 281 | 20 |
44253 | 44253 | 2020-04-09 | Berkshire | Massachusetts | 25003 | 304 | 21 |
46861 | 46861 | 2020-04-10 | Berkshire | Massachusetts | 25003 | 329 | 22 |
49503 | 49503 | 2020-04-11 | Berkshire | Massachusetts | 25003 | 336 | 22 |
52173 | 52173 | 2020-04-12 | Berkshire | Massachusetts | 25003 | 350 | 22 |
54854 | 54854 | 2020-04-13 | Berkshire | Massachusetts | 25003 | 355 | 22 |
57552 | 57552 | 2020-04-14 | Berkshire | Massachusetts | 25003 | 360 | 23 |
60261 | 60261 | 2020-04-15 | Berkshire | Massachusetts | 25003 | 370 | 23 |
62982 | 62982 | 2020-04-16 | Berkshire | Massachusetts | 25003 | 382 | 26 |
65720 | 65720 | 2020-04-17 | Berkshire | Massachusetts | 25003 | 383 | 26 |
68470 | 68470 | 2020-04-18 | Berkshire | Massachusetts | 25003 | 385 | 27 |
74006 | 74006 | 2020-04-20 | Berkshire | Massachusetts | 25003 | 387 | 28 |
71234 | 71234 | 2020-04-19 | Berkshire | Massachusetts | 25003 | 387 | 29 |
76786 | 76786 | 2020-04-21 | Berkshire | Massachusetts | 25003 | 404 | 29 |
79572 | 79572 | 2020-04-22 | Berkshire | Massachusetts | 25003 | 404 | 31 |
82367 | 82367 | 2020-04-23 | Berkshire | Massachusetts | 25003 | 418 | 31 |
85171 | 85171 | 2020-04-24 | Berkshire | Massachusetts | 25003 | 425 | 31 |
87981 | 87981 | 2020-04-25 | Berkshire | Massachusetts | 25003 | 425 | 31 |
90797 | 90797 | 2020-04-26 | Berkshire | Massachusetts | 25003 | 428 | 31 |
93618 | 93618 | 2020-04-27 | Berkshire | Massachusetts | 25003 | 428 | 31 |
96453 | 96453 | 2020-04-28 | Berkshire | Massachusetts | 25003 | 430 | 31 |
99299 | 99299 | 2020-04-29 | Berkshire | Massachusetts | 25003 | 440 | 34 |
102151 | 102151 | 2020-04-30 | Berkshire | Massachusetts | 25003 | 442 | 35 |
105011 | 105011 | 2020-05-01 | Berkshire | Massachusetts | 25003 | 444 | 36 |
107875 | 107875 | 2020-05-02 | Berkshire | Massachusetts | 25003 | 448 | 36 |
110747 | 110747 | 2020-05-03 | Berkshire | Massachusetts | 25003 | 451 | 36 |
113625 | 113625 | 2020-05-04 | Berkshire | Massachusetts | 25003 | 453 | 36 |
116506 | 116506 | 2020-05-05 | Berkshire | Massachusetts | 25003 | 457 | 36 |
119467 | 119467 | 2020-05-06 | Berkshire | Massachusetts | 25003 | 461 | 37 |
122439 | 122439 | 2020-05-07 | Berkshire | Massachusetts | 25003 | 464 | 37 |
125421 | 125421 | 2020-05-08 | Berkshire | Massachusetts | 25003 | 472 | 37 |
128408 | 128408 | 2020-05-09 | Berkshire | Massachusetts | 25003 | 472 | 37 |
131398 | 131398 | 2020-05-10 | Berkshire | Massachusetts | 25003 | 475 | 37 |
134389 | 134389 | 2020-05-11 | Berkshire | Massachusetts | 25003 | 478 | 37 |
137379 | 137379 | 2020-05-12 | Berkshire | Massachusetts | 25003 | 485 | 37 |
140373 | 140373 | 2020-05-13 | Berkshire | Massachusetts | 25003 | 486 | 37 |
143368 | 143368 | 2020-05-14 | Berkshire | Massachusetts | 25003 | 488 | 37 |
146368 | 146368 | 2020-05-15 | Berkshire | Massachusetts | 25003 | 491 | 37 |
149373 | 149373 | 2020-05-16 | Berkshire | Massachusetts | 25003 | 495 | 37 |
152384 | 152384 | 2020-05-17 | Berkshire | Massachusetts | 25003 | 497 | 37 |
155398 | 155398 | 2020-05-18 | Berkshire | Massachusetts | 25003 | 497 | 37 |
158416 | 158416 | 2020-05-19 | Berkshire | Massachusetts | 25003 | 497 | 37 |
161442 | 161442 | 2020-05-20 | Berkshire | Massachusetts | 25003 | 500 | 37 |
164471 | 164471 | 2020-05-21 | Berkshire | Massachusetts | 25003 | 509 | 37 |
167507 | 167507 | 2020-05-22 | Berkshire | Massachusetts | 25003 | 510 | 38 |
170544 | 170544 | 2020-05-23 | Berkshire | Massachusetts | 25003 | 515 | 38 |
173586 | 173586 | 2020-05-24 | Berkshire | Massachusetts | 25003 | 520 | 38 |
176629 | 176629 | 2020-05-25 | Berkshire | Massachusetts | 25003 | 523 | 38 |
179673 | 179673 | 2020-05-26 | Berkshire | Massachusetts | 25003 | 537 | 39 |
182719 | 182719 | 2020-05-27 | Berkshire | Massachusetts | 25003 | 539 | 40 |
185774 | 185774 | 2020-05-28 | Berkshire | Massachusetts | 25003 | 539 | 40 |
188832 | 188832 | 2020-05-29 | Berkshire | Massachusetts | 25003 | 544 | 40 |
191896 | 191896 | 2020-05-30 | Berkshire | Massachusetts | 25003 | 544 | 40 |
194964 | 194964 | 2020-05-31 | Berkshire | Massachusetts | 25003 | 544 | 40 |
198035 | 198035 | 2020-06-01 | Berkshire | Massachusetts | 25003 | 567 | 40 |
201107 | 201107 | 2020-06-02 | Berkshire | Massachusetts | 25003 | 568 | 40 |
204184 | 204184 | 2020-06-03 | Berkshire | Massachusetts | 25003 | 566 | 40 |
207265 | 207265 | 2020-06-04 | Berkshire | Massachusetts | 25003 | 568 | 40 |
210346 | 210346 | 2020-06-05 | Berkshire | Massachusetts | 25003 | 571 | 40 |
213430 | 213430 | 2020-06-06 | Berkshire | Massachusetts | 25003 | 573 | 40 |
216518 | 216518 | 2020-06-07 | Berkshire | Massachusetts | 25003 | 574 | 40 |
219610 | 219610 | 2020-06-08 | Berkshire | Massachusetts | 25003 | 575 | 41 |
222705 | 222705 | 2020-06-09 | Berkshire | Massachusetts | 25003 | 575 | 41 |
225801 | 225801 | 2020-06-10 | Berkshire | Massachusetts | 25003 | 574 | 41 |
228903 | 228903 | 2020-06-11 | Berkshire | Massachusetts | 25003 | 575 | 41 |
232007 | 232007 | 2020-06-12 | Berkshire | Massachusetts | 25003 | 575 | 42 |
235112 | 235112 | 2020-06-13 | Berkshire | Massachusetts | 25003 | 580 | 42 |
238219 | 238219 | 2020-06-14 | Berkshire | Massachusetts | 25003 | 580 | 42 |
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);