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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636112 | 636112 | 2020-10-16 | Barnstable | Massachusetts | 25001 | 1888 | 180 |
636113 | 636113 | 2020-10-16 | Berkshire | Massachusetts | 25003 | 735 | 51 |
636114 | 636114 | 2020-10-16 | Bristol | Massachusetts | 25005 | 10864 | 729 |
636115 | 636115 | 2020-10-16 | Dukes | Massachusetts | 25007 | 70 | 0 |
636116 | 636116 | 2020-10-16 | Essex | Massachusetts | 25009 | 21736 | 1320 |
636117 | 636117 | 2020-10-16 | Franklin | Massachusetts | 25011 | 432 | 71 |
636118 | 636118 | 2020-10-16 | Hampden | Massachusetts | 25013 | 8971 | 796 |
636119 | 636119 | 2020-10-16 | Hampshire | Massachusetts | 25015 | 1386 | 152 |
636120 | 636120 | 2020-10-16 | Middlesex | Massachusetts | 25017 | 29728 | 2214 |
636121 | 636121 | 2020-10-16 | Nantucket | Massachusetts | 25019 | 132 | 1 |
636122 | 636122 | 2020-10-16 | Norfolk | Massachusetts | 25021 | 11050 | 1087 |
636123 | 636123 | 2020-10-16 | Plymouth | Massachusetts | 25023 | 10540 | 800 |
636124 | 636124 | 2020-10-16 | Suffolk | Massachusetts | 25025 | 26160 | 1155 |
636125 | 636125 | 2020-10-16 | Unknown | Massachusetts | 3297 | 6 | |
636126 | 636126 | 2020-10-16 | Worcester | Massachusetts | 25027 | 15357 | 1140 |
632866 | 632866 | 2020-10-15 | Barnstable | Massachusetts | 25001 | 1882 | 178 |
632867 | 632867 | 2020-10-15 | Berkshire | Massachusetts | 25003 | 735 | 51 |
632868 | 632868 | 2020-10-15 | Bristol | Massachusetts | 25005 | 10828 | 727 |
632869 | 632869 | 2020-10-15 | Dukes | Massachusetts | 25007 | 70 | 0 |
632870 | 632870 | 2020-10-15 | Essex | Massachusetts | 25009 | 21619 | 1318 |
632871 | 632871 | 2020-10-15 | Franklin | Massachusetts | 25011 | 426 | 71 |
632872 | 632872 | 2020-10-15 | Hampden | Massachusetts | 25013 | 8921 | 794 |
632873 | 632873 | 2020-10-15 | Hampshire | Massachusetts | 25015 | 1376 | 152 |
632874 | 632874 | 2020-10-15 | Middlesex | Massachusetts | 25017 | 29587 | 2205 |
632875 | 632875 | 2020-10-15 | Nantucket | Massachusetts | 25019 | 132 | 1 |
632876 | 632876 | 2020-10-15 | Norfolk | Massachusetts | 25021 | 11008 | 1086 |
632877 | 632877 | 2020-10-15 | Plymouth | Massachusetts | 25023 | 10486 | 793 |
632878 | 632878 | 2020-10-15 | Suffolk | Massachusetts | 25025 | 26012 | 1153 |
632879 | 632879 | 2020-10-15 | Unknown | Massachusetts | 3217 | 6 | |
632880 | 632880 | 2020-10-15 | Worcester | Massachusetts | 25027 | 15280 | 1137 |
629621 | 629621 | 2020-10-14 | Barnstable | Massachusetts | 25001 | 1877 | 178 |
629622 | 629622 | 2020-10-14 | Berkshire | Massachusetts | 25003 | 733 | 51 |
629623 | 629623 | 2020-10-14 | Bristol | Massachusetts | 25005 | 10777 | 725 |
629624 | 629624 | 2020-10-14 | Dukes | Massachusetts | 25007 | 70 | 0 |
629625 | 629625 | 2020-10-14 | Essex | Massachusetts | 25009 | 21516 | 1315 |
629626 | 629626 | 2020-10-14 | Franklin | Massachusetts | 25011 | 426 | 71 |
629627 | 629627 | 2020-10-14 | Hampden | Massachusetts | 25013 | 8894 | 794 |
629628 | 629628 | 2020-10-14 | Hampshire | Massachusetts | 25015 | 1374 | 152 |
629629 | 629629 | 2020-10-14 | Middlesex | Massachusetts | 25017 | 29460 | 2200 |
629630 | 629630 | 2020-10-14 | Nantucket | Massachusetts | 25019 | 131 | 1 |
629631 | 629631 | 2020-10-14 | Norfolk | Massachusetts | 25021 | 10975 | 1086 |
629632 | 629632 | 2020-10-14 | Plymouth | Massachusetts | 25023 | 10424 | 786 |
629633 | 629633 | 2020-10-14 | Suffolk | Massachusetts | 25025 | 25896 | 1150 |
629634 | 629634 | 2020-10-14 | Unknown | Massachusetts | 3201 | 6 | |
629635 | 629635 | 2020-10-14 | Worcester | Massachusetts | 25027 | 15238 | 1132 |
626377 | 626377 | 2020-10-13 | Barnstable | Massachusetts | 25001 | 1878 | 178 |
626378 | 626378 | 2020-10-13 | Berkshire | Massachusetts | 25003 | 732 | 51 |
626379 | 626379 | 2020-10-13 | Bristol | Massachusetts | 25005 | 10739 | 725 |
626380 | 626380 | 2020-10-13 | Dukes | Massachusetts | 25007 | 70 | 0 |
626381 | 626381 | 2020-10-13 | Essex | Massachusetts | 25009 | 21380 | 1313 |
626382 | 626382 | 2020-10-13 | Franklin | Massachusetts | 25011 | 426 | 71 |
626383 | 626383 | 2020-10-13 | Hampden | Massachusetts | 25013 | 8854 | 792 |
626384 | 626384 | 2020-10-13 | Hampshire | Massachusetts | 25015 | 1364 | 150 |
626385 | 626385 | 2020-10-13 | Middlesex | Massachusetts | 25017 | 29358 | 2196 |
626386 | 626386 | 2020-10-13 | Nantucket | Massachusetts | 25019 | 131 | 1 |
626387 | 626387 | 2020-10-13 | Norfolk | Massachusetts | 25021 | 10942 | 1084 |
626388 | 626388 | 2020-10-13 | Plymouth | Massachusetts | 25023 | 10380 | 784 |
626389 | 626389 | 2020-10-13 | Suffolk | Massachusetts | 25025 | 25824 | 1148 |
626390 | 626390 | 2020-10-13 | Unknown | Massachusetts | 3145 | 6 | |
626391 | 626391 | 2020-10-13 | Worcester | Massachusetts | 25027 | 15189 | 1131 |
623135 | 623135 | 2020-10-12 | Barnstable | Massachusetts | 25001 | 1876 | 177 |
623136 | 623136 | 2020-10-12 | Berkshire | Massachusetts | 25003 | 730 | 51 |
623137 | 623137 | 2020-10-12 | Bristol | Massachusetts | 25005 | 10670 | 724 |
623138 | 623138 | 2020-10-12 | Dukes | Massachusetts | 25007 | 70 | 0 |
623139 | 623139 | 2020-10-12 | Essex | Massachusetts | 25009 | 21296 | 1311 |
623140 | 623140 | 2020-10-12 | Franklin | Massachusetts | 25011 | 426 | 71 |
623141 | 623141 | 2020-10-12 | Hampden | Massachusetts | 25013 | 8818 | 792 |
623142 | 623142 | 2020-10-12 | Hampshire | Massachusetts | 25015 | 1359 | 150 |
623143 | 623143 | 2020-10-12 | Middlesex | Massachusetts | 25017 | 29225 | 2192 |
623144 | 623144 | 2020-10-12 | Nantucket | Massachusetts | 25019 | 131 | 1 |
623145 | 623145 | 2020-10-12 | Norfolk | Massachusetts | 25021 | 10880 | 1083 |
623146 | 623146 | 2020-10-12 | Plymouth | Massachusetts | 25023 | 10324 | 783 |
623147 | 623147 | 2020-10-12 | Suffolk | Massachusetts | 25025 | 25702 | 1147 |
623148 | 623148 | 2020-10-12 | Unknown | Massachusetts | 3015 | 6 | |
623149 | 623149 | 2020-10-12 | Worcester | Massachusetts | 25027 | 15141 | 1129 |
619892 | 619892 | 2020-10-11 | Barnstable | Massachusetts | 25001 | 1863 | 176 |
619893 | 619893 | 2020-10-11 | Berkshire | Massachusetts | 25003 | 730 | 51 |
619894 | 619894 | 2020-10-11 | Bristol | Massachusetts | 25005 | 10599 | 721 |
619895 | 619895 | 2020-10-11 | Dukes | Massachusetts | 25007 | 69 | 0 |
619896 | 619896 | 2020-10-11 | Essex | Massachusetts | 25009 | 21193 | 1309 |
619897 | 619897 | 2020-10-11 | Franklin | Massachusetts | 25011 | 426 | 71 |
619898 | 619898 | 2020-10-11 | Hampden | Massachusetts | 25013 | 8754 | 792 |
619899 | 619899 | 2020-10-11 | Hampshire | Massachusetts | 25015 | 1356 | 150 |
619900 | 619900 | 2020-10-11 | Middlesex | Massachusetts | 25017 | 29055 | 2190 |
619901 | 619901 | 2020-10-11 | Nantucket | Massachusetts | 25019 | 131 | 1 |
619902 | 619902 | 2020-10-11 | Norfolk | Massachusetts | 25021 | 10824 | 1082 |
619903 | 619903 | 2020-10-11 | Plymouth | Massachusetts | 25023 | 10218 | 780 |
619904 | 619904 | 2020-10-11 | Suffolk | Massachusetts | 25025 | 25562 | 1147 |
619905 | 619905 | 2020-10-11 | Unknown | Massachusetts | 3033 | 6 | |
619906 | 619906 | 2020-10-11 | Worcester | Massachusetts | 25027 | 15090 | 1128 |
616650 | 616650 | 2020-10-10 | Barnstable | Massachusetts | 25001 | 1858 | 176 |
616651 | 616651 | 2020-10-10 | Berkshire | Massachusetts | 25003 | 730 | 51 |
616652 | 616652 | 2020-10-10 | Bristol | Massachusetts | 25005 | 10555 | 718 |
616653 | 616653 | 2020-10-10 | Dukes | Massachusetts | 25007 | 69 | 0 |
616654 | 616654 | 2020-10-10 | Essex | Massachusetts | 25009 | 21078 | 1307 |
616655 | 616655 | 2020-10-10 | Franklin | Massachusetts | 25011 | 425 | 69 |
616656 | 616656 | 2020-10-10 | Hampden | Massachusetts | 25013 | 8716 | 792 |
616657 | 616657 | 2020-10-10 | Hampshire | Massachusetts | 25015 | 1352 | 149 |
616658 | 616658 | 2020-10-10 | Middlesex | Massachusetts | 25017 | 28917 | 2186 |
616659 | 616659 | 2020-10-10 | Nantucket | Massachusetts | 25019 | 129 | 1 |
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);