ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11,914 rows where state = "Massachusetts" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
2092 | 2092 | 2020-03-14 | Barnstable | Massachusetts | 25001 | 1 | 0 |
2493 | 2493 | 2020-03-15 | Barnstable | Massachusetts | 25001 | 1 | 0 |
2942 | 2942 | 2020-03-16 | Barnstable | Massachusetts | 25001 | 1 | 0 |
3443 | 3443 | 2020-03-17 | Barnstable | Massachusetts | 25001 | 2 | 0 |
4025 | 4025 | 2020-03-18 | Barnstable | Massachusetts | 25001 | 2 | 0 |
4729 | 4729 | 2020-03-19 | Barnstable | Massachusetts | 25001 | 5 | 0 |
5548 | 5548 | 2020-03-20 | Barnstable | Massachusetts | 25001 | 9 | 0 |
6507 | 6507 | 2020-03-21 | Barnstable | Massachusetts | 25001 | 11 | 0 |
7584 | 7584 | 2020-03-22 | Barnstable | Massachusetts | 25001 | 24 | 0 |
8756 | 8756 | 2020-03-23 | Barnstable | Massachusetts | 25001 | 30 | 0 |
10045 | 10045 | 2020-03-24 | Barnstable | Massachusetts | 25001 | 40 | 0 |
11456 | 11456 | 2020-03-25 | Barnstable | Massachusetts | 25001 | 51 | 1 |
13037 | 13037 | 2020-03-26 | Barnstable | Massachusetts | 25001 | 67 | 1 |
14745 | 14745 | 2020-03-27 | Barnstable | Massachusetts | 25001 | 100 | 2 |
16565 | 16565 | 2020-03-28 | Barnstable | Massachusetts | 25001 | 133 | 2 |
18480 | 18480 | 2020-03-29 | Barnstable | Massachusetts | 25001 | 148 | 2 |
20496 | 20496 | 2020-03-30 | Barnstable | Massachusetts | 25001 | 173 | 2 |
22605 | 22605 | 2020-03-31 | Barnstable | Massachusetts | 25001 | 191 | 2 |
24784 | 24784 | 2020-04-01 | Barnstable | Massachusetts | 25001 | 255 | 3 |
27036 | 27036 | 2020-04-02 | Barnstable | Massachusetts | 25001 | 283 | 3 |
29354 | 29354 | 2020-04-03 | Barnstable | Massachusetts | 25001 | 314 | 6 |
31732 | 31732 | 2020-04-04 | Barnstable | Massachusetts | 25001 | 330 | 6 |
34157 | 34157 | 2020-04-05 | Barnstable | Massachusetts | 25001 | 347 | 6 |
36616 | 36616 | 2020-04-06 | Barnstable | Massachusetts | 25001 | 383 | 7 |
39124 | 39124 | 2020-04-07 | Barnstable | Massachusetts | 25001 | 405 | 10 |
41676 | 41676 | 2020-04-08 | Barnstable | Massachusetts | 25001 | 423 | 11 |
44252 | 44252 | 2020-04-09 | Barnstable | Massachusetts | 25001 | 444 | 12 |
46860 | 46860 | 2020-04-10 | Barnstable | Massachusetts | 25001 | 464 | 13 |
49502 | 49502 | 2020-04-11 | Barnstable | Massachusetts | 25001 | 480 | 15 |
52172 | 52172 | 2020-04-12 | Barnstable | Massachusetts | 25001 | 501 | 16 |
54853 | 54853 | 2020-04-13 | Barnstable | Massachusetts | 25001 | 502 | 17 |
57551 | 57551 | 2020-04-14 | Barnstable | Massachusetts | 25001 | 514 | 17 |
60260 | 60260 | 2020-04-15 | Barnstable | Massachusetts | 25001 | 530 | 18 |
62981 | 62981 | 2020-04-16 | Barnstable | Massachusetts | 25001 | 550 | 18 |
65719 | 65719 | 2020-04-17 | Barnstable | Massachusetts | 25001 | 573 | 20 |
68469 | 68469 | 2020-04-18 | Barnstable | Massachusetts | 25001 | 590 | 20 |
71233 | 71233 | 2020-04-19 | Barnstable | Massachusetts | 25001 | 632 | 21 |
74005 | 74005 | 2020-04-20 | Barnstable | Massachusetts | 25001 | 664 | 21 |
76785 | 76785 | 2020-04-21 | Barnstable | Massachusetts | 25001 | 672 | 22 |
79571 | 79571 | 2020-04-22 | Barnstable | Massachusetts | 25001 | 678 | 27 |
82366 | 82366 | 2020-04-23 | Barnstable | Massachusetts | 25001 | 708 | 28 |
85170 | 85170 | 2020-04-24 | Barnstable | Massachusetts | 25001 | 747 | 32 |
87980 | 87980 | 2020-04-25 | Barnstable | Massachusetts | 25001 | 756 | 37 |
90796 | 90796 | 2020-04-26 | Barnstable | Massachusetts | 25001 | 772 | 37 |
93617 | 93617 | 2020-04-27 | Barnstable | Massachusetts | 25001 | 798 | 39 |
96452 | 96452 | 2020-04-28 | Barnstable | Massachusetts | 25001 | 820 | 39 |
99298 | 99298 | 2020-04-29 | Barnstable | Massachusetts | 25001 | 842 | 40 |
102150 | 102150 | 2020-04-30 | Barnstable | Massachusetts | 25001 | 860 | 43 |
105010 | 105010 | 2020-05-01 | Barnstable | Massachusetts | 25001 | 902 | 45 |
107874 | 107874 | 2020-05-02 | Barnstable | Massachusetts | 25001 | 937 | 46 |
110746 | 110746 | 2020-05-03 | Barnstable | Massachusetts | 25001 | 946 | 47 |
113624 | 113624 | 2020-05-04 | Barnstable | Massachusetts | 25001 | 961 | 47 |
116505 | 116505 | 2020-05-05 | Barnstable | Massachusetts | 25001 | 969 | 48 |
119466 | 119466 | 2020-05-06 | Barnstable | Massachusetts | 25001 | 997 | 55 |
122438 | 122438 | 2020-05-07 | Barnstable | Massachusetts | 25001 | 1021 | 57 |
125420 | 125420 | 2020-05-08 | Barnstable | Massachusetts | 25001 | 1038 | 61 |
128407 | 128407 | 2020-05-09 | Barnstable | Massachusetts | 25001 | 1056 | 66 |
131397 | 131397 | 2020-05-10 | Barnstable | Massachusetts | 25001 | 1068 | 68 |
134388 | 134388 | 2020-05-11 | Barnstable | Massachusetts | 25001 | 1075 | 73 |
137378 | 137378 | 2020-05-12 | Barnstable | Massachusetts | 25001 | 1093 | 73 |
140372 | 140372 | 2020-05-13 | Barnstable | Massachusetts | 25001 | 1111 | 79 |
143367 | 143367 | 2020-05-14 | Barnstable | Massachusetts | 25001 | 1119 | 82 |
146367 | 146367 | 2020-05-15 | Barnstable | Massachusetts | 25001 | 1137 | 86 |
149372 | 149372 | 2020-05-16 | Barnstable | Massachusetts | 25001 | 1147 | 90 |
152383 | 152383 | 2020-05-17 | Barnstable | Massachusetts | 25001 | 1150 | 93 |
155397 | 155397 | 2020-05-18 | Barnstable | Massachusetts | 25001 | 1155 | 95 |
158415 | 158415 | 2020-05-19 | Barnstable | Massachusetts | 25001 | 1177 | 96 |
161441 | 161441 | 2020-05-20 | Barnstable | Massachusetts | 25001 | 1197 | 98 |
164470 | 164470 | 2020-05-21 | Barnstable | Massachusetts | 25001 | 1202 | 99 |
167506 | 167506 | 2020-05-22 | Barnstable | Massachusetts | 25001 | 1257 | 103 |
170543 | 170543 | 2020-05-23 | Barnstable | Massachusetts | 25001 | 1264 | 107 |
173585 | 173585 | 2020-05-24 | Barnstable | Massachusetts | 25001 | 1269 | 109 |
176628 | 176628 | 2020-05-25 | Barnstable | Massachusetts | 25001 | 1277 | 110 |
179672 | 179672 | 2020-05-26 | Barnstable | Massachusetts | 25001 | 1280 | 110 |
182718 | 182718 | 2020-05-27 | Barnstable | Massachusetts | 25001 | 1286 | 111 |
185773 | 185773 | 2020-05-28 | Barnstable | Massachusetts | 25001 | 1295 | 115 |
188831 | 188831 | 2020-05-29 | Barnstable | Massachusetts | 25001 | 1303 | 116 |
191895 | 191895 | 2020-05-30 | Barnstable | Massachusetts | 25001 | 1305 | 115 |
194963 | 194963 | 2020-05-31 | Barnstable | Massachusetts | 25001 | 1312 | 116 |
198034 | 198034 | 2020-06-01 | Barnstable | Massachusetts | 25001 | 1424 | 118 |
201106 | 201106 | 2020-06-02 | Barnstable | Massachusetts | 25001 | 1430 | 118 |
204183 | 204183 | 2020-06-03 | Barnstable | Massachusetts | 25001 | 1435 | 121 |
207264 | 207264 | 2020-06-04 | Barnstable | Massachusetts | 25001 | 1443 | 121 |
210345 | 210345 | 2020-06-05 | Barnstable | Massachusetts | 25001 | 1446 | 123 |
213429 | 213429 | 2020-06-06 | Barnstable | Massachusetts | 25001 | 1450 | 123 |
216517 | 216517 | 2020-06-07 | Barnstable | Massachusetts | 25001 | 1456 | 123 |
219609 | 219609 | 2020-06-08 | Barnstable | Massachusetts | 25001 | 1458 | 123 |
222704 | 222704 | 2020-06-09 | Barnstable | Massachusetts | 25001 | 1462 | 123 |
225800 | 225800 | 2020-06-10 | Barnstable | Massachusetts | 25001 | 1467 | 127 |
228902 | 228902 | 2020-06-11 | Barnstable | Massachusetts | 25001 | 1474 | 127 |
232006 | 232006 | 2020-06-12 | Barnstable | Massachusetts | 25001 | 1479 | 127 |
235111 | 235111 | 2020-06-13 | Barnstable | Massachusetts | 25001 | 1486 | 128 |
238218 | 238218 | 2020-06-14 | Barnstable | Massachusetts | 25001 | 1487 | 130 |
241327 | 241327 | 2020-06-15 | Barnstable | Massachusetts | 25001 | 1489 | 130 |
244438 | 244438 | 2020-06-16 | Barnstable | Massachusetts | 25001 | 1494 | 131 |
247551 | 247551 | 2020-06-17 | Barnstable | Massachusetts | 25001 | 1497 | 133 |
250663 | 250663 | 2020-06-18 | Barnstable | Massachusetts | 25001 | 1502 | 135 |
253778 | 253778 | 2020-06-19 | Barnstable | Massachusetts | 25001 | 1508 | 136 |
256898 | 256898 | 2020-06-20 | Barnstable | Massachusetts | 25001 | 1513 | 136 |
260024 | 260024 | 2020-06-21 | Barnstable | Massachusetts | 25001 | 1515 | 137 |
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);