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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
45 | 45 | 2020-02-01 | Suffolk | Massachusetts | 25025 | 1 | 0 |
53 | 53 | 2020-02-02 | Suffolk | Massachusetts | 25025 | 1 | 0 |
61 | 61 | 2020-02-03 | Suffolk | Massachusetts | 25025 | 1 | 0 |
69 | 69 | 2020-02-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
77 | 77 | 2020-02-05 | Suffolk | Massachusetts | 25025 | 1 | 0 |
86 | 86 | 2020-02-06 | Suffolk | Massachusetts | 25025 | 1 | 0 |
95 | 95 | 2020-02-07 | Suffolk | Massachusetts | 25025 | 1 | 0 |
104 | 104 | 2020-02-08 | Suffolk | Massachusetts | 25025 | 1 | 0 |
113 | 113 | 2020-02-09 | Suffolk | Massachusetts | 25025 | 1 | 0 |
123 | 123 | 2020-02-10 | Suffolk | Massachusetts | 25025 | 1 | 0 |
133 | 133 | 2020-02-11 | Suffolk | Massachusetts | 25025 | 1 | 0 |
143 | 143 | 2020-02-12 | Suffolk | Massachusetts | 25025 | 1 | 0 |
154 | 154 | 2020-02-13 | Suffolk | Massachusetts | 25025 | 1 | 0 |
165 | 165 | 2020-02-14 | Suffolk | Massachusetts | 25025 | 1 | 0 |
176 | 176 | 2020-02-15 | Suffolk | Massachusetts | 25025 | 1 | 0 |
187 | 187 | 2020-02-16 | Suffolk | Massachusetts | 25025 | 1 | 0 |
198 | 198 | 2020-02-17 | Suffolk | Massachusetts | 25025 | 1 | 0 |
210 | 210 | 2020-02-18 | Suffolk | Massachusetts | 25025 | 1 | 0 |
222 | 222 | 2020-02-19 | Suffolk | Massachusetts | 25025 | 1 | 0 |
235 | 235 | 2020-02-20 | Suffolk | Massachusetts | 25025 | 1 | 0 |
249 | 249 | 2020-02-21 | Suffolk | Massachusetts | 25025 | 1 | 0 |
263 | 263 | 2020-02-22 | Suffolk | Massachusetts | 25025 | 1 | 0 |
277 | 277 | 2020-02-23 | Suffolk | Massachusetts | 25025 | 1 | 0 |
292 | 292 | 2020-02-24 | Suffolk | Massachusetts | 25025 | 1 | 0 |
308 | 308 | 2020-02-25 | Suffolk | Massachusetts | 25025 | 1 | 0 |
328 | 328 | 2020-02-26 | Suffolk | Massachusetts | 25025 | 1 | 0 |
348 | 348 | 2020-02-27 | Suffolk | Massachusetts | 25025 | 1 | 0 |
368 | 368 | 2020-02-28 | Suffolk | Massachusetts | 25025 | 1 | 0 |
390 | 390 | 2020-02-29 | Suffolk | Massachusetts | 25025 | 1 | 0 |
415 | 415 | 2020-03-01 | Suffolk | Massachusetts | 25025 | 1 | 0 |
445 | 445 | 2020-03-02 | Norfolk | Massachusetts | 25021 | 1 | 0 |
446 | 446 | 2020-03-02 | Suffolk | Massachusetts | 25025 | 1 | 0 |
479 | 479 | 2020-03-03 | Norfolk | Massachusetts | 25021 | 1 | 0 |
480 | 480 | 2020-03-03 | Suffolk | Massachusetts | 25025 | 1 | 0 |
514 | 514 | 2020-03-04 | Norfolk | Massachusetts | 25021 | 1 | 0 |
515 | 515 | 2020-03-04 | Suffolk | Massachusetts | 25025 | 1 | 0 |
557 | 557 | 2020-03-05 | Middlesex | Massachusetts | 25017 | 1 | 0 |
558 | 558 | 2020-03-05 | Norfolk | Massachusetts | 25021 | 1 | 0 |
559 | 559 | 2020-03-05 | Suffolk | Massachusetts | 25025 | 1 | 0 |
617 | 617 | 2020-03-06 | Middlesex | Massachusetts | 25017 | 1 | 0 |
702 | 702 | 2020-03-07 | Berkshire | Massachusetts | 25003 | 1 | 0 |
804 | 804 | 2020-03-08 | Berkshire | Massachusetts | 25003 | 1 | 0 |
808 | 808 | 2020-03-08 | Worcester | Massachusetts | 25027 | 1 | 0 |
932 | 932 | 2020-03-09 | Worcester | Massachusetts | 25027 | 1 | 0 |
1075 | 1075 | 2020-03-10 | Essex | Massachusetts | 25009 | 1 | 0 |
1079 | 1079 | 2020-03-10 | Worcester | Massachusetts | 25027 | 1 | 0 |
1255 | 1255 | 2020-03-11 | Essex | Massachusetts | 25009 | 1 | 0 |
2092 | 2092 | 2020-03-14 | Barnstable | Massachusetts | 25001 | 1 | 0 |
2094 | 2094 | 2020-03-14 | Bristol | Massachusetts | 25005 | 1 | 0 |
2493 | 2493 | 2020-03-15 | Barnstable | Massachusetts | 25001 | 1 | 0 |
2495 | 2495 | 2020-03-15 | Bristol | Massachusetts | 25005 | 1 | 0 |
2497 | 2497 | 2020-03-15 | Hampden | Massachusetts | 25013 | 1 | 0 |
2942 | 2942 | 2020-03-16 | Barnstable | Massachusetts | 25001 | 1 | 0 |
2946 | 2946 | 2020-03-16 | Hampden | Massachusetts | 25013 | 1 | 0 |
2951 | 2951 | 2020-03-16 | Unknown | Massachusetts | 1 | 0 | |
3447 | 3447 | 2020-03-17 | Hampden | Massachusetts | 25013 | 1 | 0 |
3452 | 3452 | 2020-03-17 | Unknown | Massachusetts | 1 | 0 | |
4029 | 4029 | 2020-03-18 | Franklin | Massachusetts | 25011 | 1 | 0 |
4733 | 4733 | 2020-03-19 | Franklin | Massachusetts | 25011 | 1 | 0 |
4735 | 4735 | 2020-03-19 | Hampshire | Massachusetts | 25015 | 1 | 0 |
5552 | 5552 | 2020-03-20 | Franklin | Massachusetts | 25011 | 1 | 0 |
6515 | 6515 | 2020-03-21 | Nantucket | Massachusetts | 25019 | 1 | 0 |
7592 | 7592 | 2020-03-22 | Nantucket | Massachusetts | 25019 | 1 | 0 |
8764 | 8764 | 2020-03-23 | Nantucket | Massachusetts | 25019 | 1 | 0 |
11459 | 11459 | 2020-03-25 | Dukes | Massachusetts | 25007 | 1 | 0 |
13040 | 13040 | 2020-03-26 | Dukes | Massachusetts | 25007 | 1 | 0 |
14748 | 14748 | 2020-03-27 | Dukes | Massachusetts | 25007 | 1 | 0 |
16568 | 16568 | 2020-03-28 | Dukes | Massachusetts | 25007 | 1 | 0 |
18483 | 18483 | 2020-03-29 | Dukes | Massachusetts | 25007 | 1 | 0 |
20499 | 20499 | 2020-03-30 | Dukes | Massachusetts | 25007 | 1 | 0 |
22608 | 22608 | 2020-03-31 | Dukes | Massachusetts | 25007 | 1 | 0 |
24787 | 24787 | 2020-04-01 | Dukes | Massachusetts | 25007 | 1 | 0 |
1259 | 1259 | 2020-03-11 | Worcester | Massachusetts | 25027 | 2 | 0 |
1473 | 1473 | 2020-03-12 | Essex | Massachusetts | 25009 | 2 | 0 |
1477 | 1477 | 2020-03-12 | Worcester | Massachusetts | 25027 | 2 | 0 |
1752 | 1752 | 2020-03-13 | Essex | Massachusetts | 25009 | 2 | 0 |
1756 | 1756 | 2020-03-13 | Worcester | Massachusetts | 25027 | 2 | 0 |
2099 | 2099 | 2020-03-14 | Worcester | Massachusetts | 25027 | 2 | 0 |
2944 | 2944 | 2020-03-16 | Bristol | Massachusetts | 25005 | 2 | 0 |
3443 | 3443 | 2020-03-17 | Barnstable | Massachusetts | 25001 | 2 | 0 |
4025 | 4025 | 2020-03-18 | Barnstable | Massachusetts | 25001 | 2 | 0 |
4030 | 4030 | 2020-03-18 | Hampden | Massachusetts | 25013 | 2 | 0 |
5554 | 5554 | 2020-03-20 | Hampshire | Massachusetts | 25015 | 2 | 0 |
6511 | 6511 | 2020-03-21 | Franklin | Massachusetts | 25011 | 2 | 0 |
6513 | 6513 | 2020-03-21 | Hampshire | Massachusetts | 25015 | 2 | 0 |
7588 | 7588 | 2020-03-22 | Franklin | Massachusetts | 25011 | 2 | 0 |
8760 | 8760 | 2020-03-23 | Franklin | Massachusetts | 25011 | 2 | 0 |
10053 | 10053 | 2020-03-24 | Nantucket | Massachusetts | 25019 | 2 | 0 |
11465 | 11465 | 2020-03-25 | Nantucket | Massachusetts | 25019 | 2 | 0 |
13046 | 13046 | 2020-03-26 | Nantucket | Massachusetts | 25019 | 2 | 0 |
14754 | 14754 | 2020-03-27 | Nantucket | Massachusetts | 25019 | 2 | 0 |
618 | 618 | 2020-03-06 | Norfolk | Massachusetts | 25021 | 3 | 0 |
704 | 704 | 2020-03-07 | Norfolk | Massachusetts | 25021 | 3 | 0 |
2500 | 2500 | 2020-03-15 | Plymouth | Massachusetts | 25023 | 3 | 0 |
4734 | 4734 | 2020-03-19 | Hampden | Massachusetts | 25013 | 3 | 0 |
5553 | 5553 | 2020-03-20 | Hampden | Massachusetts | 25013 | 3 | 0 |
619 | 619 | 2020-03-06 | Suffolk | Massachusetts | 25025 | 4 | 0 |
705 | 705 | 2020-03-07 | Suffolk | Massachusetts | 25025 | 4 | 0 |
4035 | 4035 | 2020-03-18 | Unknown | Massachusetts | 4 | 0 | |
7590 | 7590 | 2020-03-22 | Hampshire | Massachusetts | 25015 | 4 | 0 |
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);