ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

11,914 rows where state = "Massachusetts" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips 15

county 15

state 1

  • Massachusetts · 11,914 ✖
Link rowid date ▲ county state fips cases deaths
2500806 2500806 2022-05-13 Barnstable Massachusetts 25001 37644 584
2500807 2500807 2022-05-13 Berkshire Massachusetts 25003 26169 378
2500808 2500808 2022-05-13 Bristol Massachusetts 25005 154820 2163
2500809 2500809 2022-05-13 Dukes Massachusetts 25007 3587 0
2500810 2500810 2022-05-13 Essex Massachusetts 25009 214332 2758
2500811 2500811 2022-05-13 Franklin Massachusetts 25011 11403 140
2500812 2500812 2022-05-13 Hampden Massachusetts 25013 139047 1804
2500813 2500813 2022-05-13 Hampshire Massachusetts 25015 30837 358
2500814 2500814 2022-05-13 Middlesex Massachusetts 25017 352032 3998
2500815 2500815 2022-05-13 Nantucket Massachusetts 25019 3481 0
2500816 2500816 2022-05-13 Norfolk Massachusetts 25021 141128 1901
2500817 2500817 2022-05-13 Plymouth Massachusetts 25023 120081 1685
2500818 2500818 2022-05-13 Suffolk Massachusetts 25025 226017 2006
2500819 2500819 2022-05-13 Unknown Massachusetts   147062 22
2500820 2500820 2022-05-13 Worcester Massachusetts 25027 201669 2596
2497548 2497548 2022-05-12 Barnstable Massachusetts 25001 37492 582
2497549 2497549 2022-05-12 Berkshire Massachusetts 25003 26008 378
2497550 2497550 2022-05-12 Bristol Massachusetts 25005 154506 2163
2497551 2497551 2022-05-12 Dukes Massachusetts 25007 3569 0
2497552 2497552 2022-05-12 Essex Massachusetts 25009 213890 2758
2497553 2497553 2022-05-12 Franklin Massachusetts 25011 11371 140
2497554 2497554 2022-05-12 Hampden Massachusetts 25013 138649 1803
2497555 2497555 2022-05-12 Hampshire Massachusetts 25015 30670 358
2497556 2497556 2022-05-12 Middlesex Massachusetts 25017 350880 3996
2497557 2497557 2022-05-12 Nantucket Massachusetts 25019 3477 0
2497558 2497558 2022-05-12 Norfolk Massachusetts 25021 140637 1901
2497559 2497559 2022-05-12 Plymouth Massachusetts 25023 119841 1682
2497560 2497560 2022-05-12 Suffolk Massachusetts 25025 225419 2005
2497561 2497561 2022-05-12 Unknown Massachusetts   146235 22
2497562 2497562 2022-05-12 Worcester Massachusetts 25027 201187 2595
2494290 2494290 2022-05-11 Barnstable Massachusetts 25001 37352 582
2494291 2494291 2022-05-11 Berkshire Massachusetts 25003 25834 378
2494292 2494292 2022-05-11 Bristol Massachusetts 25005 154195 2157
2494293 2494293 2022-05-11 Dukes Massachusetts 25007 3564 0
2494294 2494294 2022-05-11 Essex Massachusetts 25009 213261 2758
2494295 2494295 2022-05-11 Franklin Massachusetts 25011 11343 138
2494296 2494296 2022-05-11 Hampden Massachusetts 25013 138220 1802
2494297 2494297 2022-05-11 Hampshire Massachusetts 25015 30453 357
2494298 2494298 2022-05-11 Middlesex Massachusetts 25017 349443 3993
2494299 2494299 2022-05-11 Nantucket Massachusetts 25019 3475 0
2494300 2494300 2022-05-11 Norfolk Massachusetts 25021 140123 1901
2494301 2494301 2022-05-11 Plymouth Massachusetts 25023 119552 1681
2494302 2494302 2022-05-11 Suffolk Massachusetts 25025 224692 2002
2494303 2494303 2022-05-11 Unknown Massachusetts   145286 22
2494304 2494304 2022-05-11 Worcester Massachusetts 25027 200515 2594
2491032 2491032 2022-05-10 Barnstable Massachusetts 25001 37218 582
2491033 2491033 2022-05-10 Berkshire Massachusetts 25003 25674 378
2491034 2491034 2022-05-10 Bristol Massachusetts 25005 154020 2156
2491035 2491035 2022-05-10 Dukes Massachusetts 25007 3554 0
2491036 2491036 2022-05-10 Essex Massachusetts 25009 212871 2757
2491037 2491037 2022-05-10 Franklin Massachusetts 25011 11295 138
2491038 2491038 2022-05-10 Hampden Massachusetts 25013 137917 1802
2491039 2491039 2022-05-10 Hampshire Massachusetts 25015 30279 356
2491040 2491040 2022-05-10 Middlesex Massachusetts 25017 348380 3991
2491041 2491041 2022-05-10 Nantucket Massachusetts 25019 3471 0
2491042 2491042 2022-05-10 Norfolk Massachusetts 25021 139746 1900
2491043 2491043 2022-05-10 Plymouth Massachusetts 25023 119375 1681
2491044 2491044 2022-05-10 Suffolk Massachusetts 25025 224160 2001
2491045 2491045 2022-05-10 Unknown Massachusetts   144701 22
2491046 2491046 2022-05-10 Worcester Massachusetts 25027 200061 2593
2487775 2487775 2022-05-09 Barnstable Massachusetts 25001 37110 582
2487776 2487776 2022-05-09 Berkshire Massachusetts 25003 25586 377
2487777 2487777 2022-05-09 Bristol Massachusetts 25005 153837 2154
2487778 2487778 2022-05-09 Dukes Massachusetts 25007 3550 0
2487779 2487779 2022-05-09 Essex Massachusetts 25009 212536 2747
2487780 2487780 2022-05-09 Franklin Massachusetts 25011 11276 138
2487781 2487781 2022-05-09 Hampden Massachusetts 25013 137700 1801
2487782 2487782 2022-05-09 Hampshire Massachusetts 25015 30208 356
2487783 2487783 2022-05-09 Middlesex Massachusetts 25017 347746 3988
2487784 2487784 2022-05-09 Nantucket Massachusetts 25019 3468 0
2487785 2487785 2022-05-09 Norfolk Massachusetts 25021 139419 1897
2487786 2487786 2022-05-09 Plymouth Massachusetts 25023 119169 1681
2487787 2487787 2022-05-09 Suffolk Massachusetts 25025 223727 2001
2487788 2487788 2022-05-09 Unknown Massachusetts   144011 22
2487789 2487789 2022-05-09 Worcester Massachusetts 25027 199773 2591
2484517 2484517 2022-05-08 Barnstable Massachusetts 25001 36841 582
2484518 2484518 2022-05-08 Berkshire Massachusetts 25003 25244 377
2484519 2484519 2022-05-08 Bristol Massachusetts 25005 153341 2154
2484520 2484520 2022-05-08 Dukes Massachusetts 25007 3534 0
2484521 2484521 2022-05-08 Essex Massachusetts 25009 211651 2748
2484522 2484522 2022-05-08 Franklin Massachusetts 25011 11197 137
2484523 2484523 2022-05-08 Hampden Massachusetts 25013 137100 1802
2484524 2484524 2022-05-08 Hampshire Massachusetts 25015 29916 356
2484525 2484525 2022-05-08 Middlesex Massachusetts 25017 345386 3988
2484526 2484526 2022-05-08 Nantucket Massachusetts 25019 3457 0
2484527 2484527 2022-05-08 Norfolk Massachusetts 25021 138588 1897
2484528 2484528 2022-05-08 Plymouth Massachusetts 25023 118740 1681
2484529 2484529 2022-05-08 Suffolk Massachusetts 25025 222693 2001
2484530 2484530 2022-05-08 Unknown Massachusetts   143325 22
2484531 2484531 2022-05-08 Worcester Massachusetts 25027 198816 2589
2481259 2481259 2022-05-07 Barnstable Massachusetts 25001 36841 582
2481260 2481260 2022-05-07 Berkshire Massachusetts 25003 25244 377
2481261 2481261 2022-05-07 Bristol Massachusetts 25005 153341 2154
2481262 2481262 2022-05-07 Dukes Massachusetts 25007 3534 0
2481263 2481263 2022-05-07 Essex Massachusetts 25009 211651 2748
2481264 2481264 2022-05-07 Franklin Massachusetts 25011 11197 137
2481265 2481265 2022-05-07 Hampden Massachusetts 25013 137100 1802
2481266 2481266 2022-05-07 Hampshire Massachusetts 25015 29916 356
2481267 2481267 2022-05-07 Middlesex Massachusetts 25017 345386 3988
2481268 2481268 2022-05-07 Nantucket Massachusetts 25019 3457 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);