ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Plymouth" and state = "Massachusetts" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500 | 2500 | 2020-03-15 | Plymouth | Massachusetts | 25023 | 3 | 0 |
2949 | 2949 | 2020-03-16 | Plymouth | Massachusetts | 25023 | 5 | 0 |
3450 | 3450 | 2020-03-17 | Plymouth | Massachusetts | 25023 | 5 | 0 |
4033 | 4033 | 2020-03-18 | Plymouth | Massachusetts | 25023 | 5 | 0 |
4738 | 4738 | 2020-03-19 | Plymouth | Massachusetts | 25023 | 5 | 0 |
5557 | 5557 | 2020-03-20 | Plymouth | Massachusetts | 25023 | 11 | 0 |
6517 | 6517 | 2020-03-21 | Plymouth | Massachusetts | 25023 | 20 | 0 |
7594 | 7594 | 2020-03-22 | Plymouth | Massachusetts | 25023 | 25 | 0 |
8766 | 8766 | 2020-03-23 | Plymouth | Massachusetts | 25023 | 32 | 0 |
10055 | 10055 | 2020-03-24 | Plymouth | Massachusetts | 25023 | 64 | 0 |
11467 | 11467 | 2020-03-25 | Plymouth | Massachusetts | 25023 | 101 | 0 |
13048 | 13048 | 2020-03-26 | Plymouth | Massachusetts | 25023 | 138 | 0 |
14756 | 14756 | 2020-03-27 | Plymouth | Massachusetts | 25023 | 187 | 0 |
16576 | 16576 | 2020-03-28 | Plymouth | Massachusetts | 25023 | 272 | 0 |
18491 | 18491 | 2020-03-29 | Plymouth | Massachusetts | 25023 | 325 | 0 |
20507 | 20507 | 2020-03-30 | Plymouth | Massachusetts | 25023 | 380 | 0 |
22616 | 22616 | 2020-03-31 | Plymouth | Massachusetts | 25023 | 459 | 2 |
24795 | 24795 | 2020-04-01 | Plymouth | Massachusetts | 25023 | 561 | 5 |
27047 | 27047 | 2020-04-02 | Plymouth | Massachusetts | 25023 | 621 | 6 |
29365 | 29365 | 2020-04-03 | Plymouth | Massachusetts | 25023 | 745 | 7 |
31743 | 31743 | 2020-04-04 | Plymouth | Massachusetts | 25023 | 898 | 8 |
34168 | 34168 | 2020-04-05 | Plymouth | Massachusetts | 25023 | 963 | 10 |
36627 | 36627 | 2020-04-06 | Plymouth | Massachusetts | 25023 | 1067 | 14 |
39135 | 39135 | 2020-04-07 | Plymouth | Massachusetts | 25023 | 1194 | 25 |
41687 | 41687 | 2020-04-08 | Plymouth | Massachusetts | 25023 | 1327 | 32 |
44263 | 44263 | 2020-04-09 | Plymouth | Massachusetts | 25023 | 1507 | 38 |
46871 | 46871 | 2020-04-10 | Plymouth | Massachusetts | 25023 | 1677 | 46 |
49513 | 49513 | 2020-04-11 | Plymouth | Massachusetts | 25023 | 1809 | 50 |
52183 | 52183 | 2020-04-12 | Plymouth | Massachusetts | 25023 | 2024 | 54 |
54864 | 54864 | 2020-04-13 | Plymouth | Massachusetts | 25023 | 2141 | 65 |
57562 | 57562 | 2020-04-14 | Plymouth | Massachusetts | 25023 | 2207 | 76 |
60271 | 60271 | 2020-04-15 | Plymouth | Massachusetts | 25023 | 2308 | 88 |
62992 | 62992 | 2020-04-16 | Plymouth | Massachusetts | 25023 | 2466 | 92 |
65730 | 65730 | 2020-04-17 | Plymouth | Massachusetts | 25023 | 2577 | 104 |
68480 | 68480 | 2020-04-18 | Plymouth | Massachusetts | 25023 | 2688 | 121 |
71244 | 71244 | 2020-04-19 | Plymouth | Massachusetts | 25023 | 2832 | 130 |
74016 | 74016 | 2020-04-20 | Plymouth | Massachusetts | 25023 | 2976 | 134 |
76796 | 76796 | 2020-04-21 | Plymouth | Massachusetts | 25023 | 3043 | 141 |
79582 | 79582 | 2020-04-22 | Plymouth | Massachusetts | 25023 | 3253 | 157 |
82377 | 82377 | 2020-04-23 | Plymouth | Massachusetts | 25023 | 3529 | 176 |
85181 | 85181 | 2020-04-24 | Plymouth | Massachusetts | 25023 | 4160 | 197 |
87991 | 87991 | 2020-04-25 | Plymouth | Massachusetts | 25023 | 4380 | 212 |
90807 | 90807 | 2020-04-26 | Plymouth | Massachusetts | 25023 | 4495 | 230 |
93628 | 93628 | 2020-04-27 | Plymouth | Massachusetts | 25023 | 4607 | 240 |
96463 | 96463 | 2020-04-28 | Plymouth | Massachusetts | 25023 | 4744 | 256 |
99309 | 99309 | 2020-04-29 | Plymouth | Massachusetts | 25023 | 4871 | 273 |
102161 | 102161 | 2020-04-30 | Plymouth | Massachusetts | 25023 | 5083 | 285 |
105021 | 105021 | 2020-05-01 | Plymouth | Massachusetts | 25023 | 5259 | 301 |
107885 | 107885 | 2020-05-02 | Plymouth | Massachusetts | 25023 | 5409 | 312 |
110757 | 110757 | 2020-05-03 | Plymouth | Massachusetts | 25023 | 5507 | 323 |
113635 | 113635 | 2020-05-04 | Plymouth | Massachusetts | 25023 | 5602 | 333 |
116516 | 116516 | 2020-05-05 | Plymouth | Massachusetts | 25023 | 5736 | 341 |
119477 | 119477 | 2020-05-06 | Plymouth | Massachusetts | 25023 | 5899 | 357 |
122449 | 122449 | 2020-05-07 | Plymouth | Massachusetts | 25023 | 6081 | 364 |
125431 | 125431 | 2020-05-08 | Plymouth | Massachusetts | 25023 | 6194 | 375 |
128418 | 128418 | 2020-05-09 | Plymouth | Massachusetts | 25023 | 6311 | 384 |
131408 | 131408 | 2020-05-10 | Plymouth | Massachusetts | 25023 | 6382 | 393 |
134399 | 134399 | 2020-05-11 | Plymouth | Massachusetts | 25023 | 6457 | 408 |
137389 | 137389 | 2020-05-12 | Plymouth | Massachusetts | 25023 | 6507 | 409 |
140383 | 140383 | 2020-05-13 | Plymouth | Massachusetts | 25023 | 6592 | 424 |
143378 | 143378 | 2020-05-14 | Plymouth | Massachusetts | 25023 | 6774 | 435 |
146378 | 146378 | 2020-05-15 | Plymouth | Massachusetts | 25023 | 6875 | 444 |
149383 | 149383 | 2020-05-16 | Plymouth | Massachusetts | 25023 | 6987 | 455 |
152394 | 152394 | 2020-05-17 | Plymouth | Massachusetts | 25023 | 7064 | 460 |
155408 | 155408 | 2020-05-18 | Plymouth | Massachusetts | 25023 | 7139 | 464 |
158426 | 158426 | 2020-05-19 | Plymouth | Massachusetts | 25023 | 7198 | 470 |
161452 | 161452 | 2020-05-20 | Plymouth | Massachusetts | 25023 | 7280 | 481 |
164481 | 164481 | 2020-05-21 | Plymouth | Massachusetts | 25023 | 7366 | 487 |
167517 | 167517 | 2020-05-22 | Plymouth | Massachusetts | 25023 | 7424 | 492 |
170554 | 170554 | 2020-05-23 | Plymouth | Massachusetts | 25023 | 7480 | 501 |
173596 | 173596 | 2020-05-24 | Plymouth | Massachusetts | 25023 | 7559 | 508 |
176639 | 176639 | 2020-05-25 | Plymouth | Massachusetts | 25023 | 7594 | 513 |
179683 | 179683 | 2020-05-26 | Plymouth | Massachusetts | 25023 | 7632 | 522 |
182729 | 182729 | 2020-05-27 | Plymouth | Massachusetts | 25023 | 7656 | 530 |
185784 | 185784 | 2020-05-28 | Plymouth | Massachusetts | 25023 | 7724 | 539 |
188842 | 188842 | 2020-05-29 | Plymouth | Massachusetts | 25023 | 7766 | 542 |
191906 | 191906 | 2020-05-30 | Plymouth | Massachusetts | 25023 | 7819 | 548 |
194974 | 194974 | 2020-05-31 | Plymouth | Massachusetts | 25023 | 7859 | 552 |
198045 | 198045 | 2020-06-01 | Plymouth | Massachusetts | 25023 | 8200 | 562 |
201117 | 201117 | 2020-06-02 | Plymouth | Massachusetts | 25023 | 8228 | 568 |
204194 | 204194 | 2020-06-03 | Plymouth | Massachusetts | 25023 | 8243 | 572 |
207275 | 207275 | 2020-06-04 | Plymouth | Massachusetts | 25023 | 8282 | 579 |
210356 | 210356 | 2020-06-05 | Plymouth | Massachusetts | 25023 | 8313 | 581 |
213440 | 213440 | 2020-06-06 | Plymouth | Massachusetts | 25023 | 8347 | 588 |
216528 | 216528 | 2020-06-07 | Plymouth | Massachusetts | 25023 | 8363 | 591 |
219620 | 219620 | 2020-06-08 | Plymouth | Massachusetts | 25023 | 8372 | 595 |
222715 | 222715 | 2020-06-09 | Plymouth | Massachusetts | 25023 | 8404 | 603 |
225811 | 225811 | 2020-06-10 | Plymouth | Massachusetts | 25023 | 8418 | 608 |
228913 | 228913 | 2020-06-11 | Plymouth | Massachusetts | 25023 | 8440 | 612 |
232017 | 232017 | 2020-06-12 | Plymouth | Massachusetts | 25023 | 8462 | 619 |
235122 | 235122 | 2020-06-13 | Plymouth | Massachusetts | 25023 | 8478 | 621 |
238229 | 238229 | 2020-06-14 | Plymouth | Massachusetts | 25023 | 8507 | 621 |
241338 | 241338 | 2020-06-15 | Plymouth | Massachusetts | 25023 | 8512 | 626 |
244449 | 244449 | 2020-06-16 | Plymouth | Massachusetts | 25023 | 8514 | 629 |
247562 | 247562 | 2020-06-17 | Plymouth | Massachusetts | 25023 | 8522 | 631 |
250674 | 250674 | 2020-06-18 | Plymouth | Massachusetts | 25023 | 8555 | 636 |
253789 | 253789 | 2020-06-19 | Plymouth | Massachusetts | 25023 | 8566 | 640 |
256909 | 256909 | 2020-06-20 | Plymouth | Massachusetts | 25023 | 8576 | 641 |
260035 | 260035 | 2020-06-21 | Plymouth | Massachusetts | 25023 | 8583 | 643 |
263164 | 263164 | 2020-06-22 | Plymouth | Massachusetts | 25023 | 8592 | 646 |
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);