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 |
---|---|---|---|---|---|---|---|
1054734 | 1054734 | 2021-02-22 | Barnstable | Massachusetts | 25001 | 9838 | 391 |
1054735 | 1054735 | 2021-02-22 | Berkshire | Massachusetts | 25003 | 4814 | 251 |
1054736 | 1054736 | 2021-02-22 | Bristol | Massachusetts | 25005 | 54947 | 1468 |
1054737 | 1054737 | 2021-02-22 | Dukes | Massachusetts | 25007 | 850 | 0 |
1054738 | 1054738 | 2021-02-22 | Essex | Massachusetts | 25009 | 82647 | 2128 |
1054739 | 1054739 | 2021-02-22 | Franklin | Massachusetts | 25011 | 1955 | 100 |
1054740 | 1054740 | 2021-02-22 | Hampden | Massachusetts | 25013 | 40859 | 1308 |
1054741 | 1054741 | 2021-02-22 | Hampshire | Massachusetts | 25015 | 7117 | 256 |
1054742 | 1054742 | 2021-02-22 | Middlesex | Massachusetts | 25017 | 109891 | 3389 |
1054743 | 1054743 | 2021-02-22 | Nantucket | Massachusetts | 25019 | 1152 | 2 |
1054744 | 1054744 | 2021-02-22 | Norfolk | Massachusetts | 25021 | 44487 | 1599 |
1054745 | 1054745 | 2021-02-22 | Plymouth | Massachusetts | 25023 | 39545 | 1271 |
1054746 | 1054746 | 2021-02-22 | Suffolk | Massachusetts | 25025 | 76944 | 1674 |
1054747 | 1054747 | 2021-02-22 | Unknown | Massachusetts | 31247 | 8 | |
1054748 | 1054748 | 2021-02-22 | Worcester | Massachusetts | 25027 | 64253 | 2008 |
1051487 | 1051487 | 2021-02-21 | Barnstable | Massachusetts | 25001 | 9808 | 391 |
1051488 | 1051488 | 2021-02-21 | Berkshire | Massachusetts | 25003 | 4806 | 250 |
1051489 | 1051489 | 2021-02-21 | Bristol | Massachusetts | 25005 | 54825 | 1466 |
1051490 | 1051490 | 2021-02-21 | Dukes | Massachusetts | 25007 | 849 | 0 |
1051491 | 1051491 | 2021-02-21 | Essex | Massachusetts | 25009 | 82488 | 2125 |
1051492 | 1051492 | 2021-02-21 | Franklin | Massachusetts | 25011 | 1953 | 100 |
1051493 | 1051493 | 2021-02-21 | Hampden | Massachusetts | 25013 | 40740 | 1305 |
1051494 | 1051494 | 2021-02-21 | Hampshire | Massachusetts | 25015 | 7104 | 255 |
1051495 | 1051495 | 2021-02-21 | Middlesex | Massachusetts | 25017 | 109679 | 3382 |
1051496 | 1051496 | 2021-02-21 | Nantucket | Massachusetts | 25019 | 1150 | 2 |
1051497 | 1051497 | 2021-02-21 | Norfolk | Massachusetts | 25021 | 44360 | 1597 |
1051498 | 1051498 | 2021-02-21 | Plymouth | Massachusetts | 25023 | 39453 | 1269 |
1051499 | 1051499 | 2021-02-21 | Suffolk | Massachusetts | 25025 | 76787 | 1673 |
1051500 | 1051500 | 2021-02-21 | Unknown | Massachusetts | 31135 | 8 | |
1051501 | 1051501 | 2021-02-21 | Worcester | Massachusetts | 25027 | 64147 | 2003 |
1048240 | 1048240 | 2021-02-20 | Barnstable | Massachusetts | 25001 | 9763 | 389 |
1048241 | 1048241 | 2021-02-20 | Berkshire | Massachusetts | 25003 | 4794 | 248 |
1048242 | 1048242 | 2021-02-20 | Bristol | Massachusetts | 25005 | 54720 | 1462 |
1048243 | 1048243 | 2021-02-20 | Dukes | Massachusetts | 25007 | 849 | 0 |
1048244 | 1048244 | 2021-02-20 | Essex | Massachusetts | 25009 | 82291 | 2121 |
1048245 | 1048245 | 2021-02-20 | Franklin | Massachusetts | 25011 | 1946 | 99 |
1048246 | 1048246 | 2021-02-20 | Hampden | Massachusetts | 25013 | 40640 | 1301 |
1048247 | 1048247 | 2021-02-20 | Hampshire | Massachusetts | 25015 | 7065 | 255 |
1048248 | 1048248 | 2021-02-20 | Middlesex | Massachusetts | 25017 | 109457 | 3371 |
1048249 | 1048249 | 2021-02-20 | Nantucket | Massachusetts | 25019 | 1150 | 2 |
1048250 | 1048250 | 2021-02-20 | Norfolk | Massachusetts | 25021 | 44228 | 1593 |
1048251 | 1048251 | 2021-02-20 | Plymouth | Massachusetts | 25023 | 39341 | 1268 |
1048252 | 1048252 | 2021-02-20 | Suffolk | Massachusetts | 25025 | 76620 | 1668 |
1048253 | 1048253 | 2021-02-20 | Unknown | Massachusetts | 30920 | 8 | |
1048254 | 1048254 | 2021-02-20 | Worcester | Massachusetts | 25027 | 63980 | 1994 |
1044994 | 1044994 | 2021-02-19 | Barnstable | Massachusetts | 25001 | 9736 | 387 |
1044995 | 1044995 | 2021-02-19 | Berkshire | Massachusetts | 25003 | 4784 | 248 |
1044996 | 1044996 | 2021-02-19 | Bristol | Massachusetts | 25005 | 54555 | 1456 |
1044997 | 1044997 | 2021-02-19 | Dukes | Massachusetts | 25007 | 847 | 0 |
1044998 | 1044998 | 2021-02-19 | Essex | Massachusetts | 25009 | 82069 | 2112 |
1044999 | 1044999 | 2021-02-19 | Franklin | Massachusetts | 25011 | 1936 | 99 |
1045000 | 1045000 | 2021-02-19 | Hampden | Massachusetts | 25013 | 40458 | 1298 |
1045001 | 1045001 | 2021-02-19 | Hampshire | Massachusetts | 25015 | 7003 | 254 |
1045002 | 1045002 | 2021-02-19 | Middlesex | Massachusetts | 25017 | 109093 | 3361 |
1045003 | 1045003 | 2021-02-19 | Nantucket | Massachusetts | 25019 | 1146 | 2 |
1045004 | 1045004 | 2021-02-19 | Norfolk | Massachusetts | 25021 | 44062 | 1583 |
1045005 | 1045005 | 2021-02-19 | Plymouth | Massachusetts | 25023 | 39211 | 1264 |
1045006 | 1045006 | 2021-02-19 | Suffolk | Massachusetts | 25025 | 76367 | 1666 |
1045007 | 1045007 | 2021-02-19 | Unknown | Massachusetts | 30772 | 8 | |
1045008 | 1045008 | 2021-02-19 | Worcester | Massachusetts | 25027 | 63755 | 1988 |
1041749 | 1041749 | 2021-02-18 | Barnstable | Massachusetts | 25001 | 9697 | 386 |
1041750 | 1041750 | 2021-02-18 | Berkshire | Massachusetts | 25003 | 4769 | 246 |
1041751 | 1041751 | 2021-02-18 | Bristol | Massachusetts | 25005 | 54426 | 1453 |
1041752 | 1041752 | 2021-02-18 | Dukes | Massachusetts | 25007 | 843 | 0 |
1041753 | 1041753 | 2021-02-18 | Essex | Massachusetts | 25009 | 81841 | 2104 |
1041754 | 1041754 | 2021-02-18 | Franklin | Massachusetts | 25011 | 1927 | 99 |
1041755 | 1041755 | 2021-02-18 | Hampden | Massachusetts | 25013 | 40265 | 1292 |
1041756 | 1041756 | 2021-02-18 | Hampshire | Massachusetts | 25015 | 6939 | 253 |
1041757 | 1041757 | 2021-02-18 | Middlesex | Massachusetts | 25017 | 108759 | 3351 |
1041758 | 1041758 | 2021-02-18 | Nantucket | Massachusetts | 25019 | 1144 | 2 |
1041759 | 1041759 | 2021-02-18 | Norfolk | Massachusetts | 25021 | 43929 | 1581 |
1041760 | 1041760 | 2021-02-18 | Plymouth | Massachusetts | 25023 | 39083 | 1261 |
1041761 | 1041761 | 2021-02-18 | Suffolk | Massachusetts | 25025 | 76135 | 1666 |
1041762 | 1041762 | 2021-02-18 | Unknown | Massachusetts | 30631 | 8 | |
1041763 | 1041763 | 2021-02-18 | Worcester | Massachusetts | 25027 | 63588 | 1984 |
1038504 | 1038504 | 2021-02-17 | Barnstable | Massachusetts | 25001 | 9665 | 384 |
1038505 | 1038505 | 2021-02-17 | Berkshire | Massachusetts | 25003 | 4762 | 244 |
1038506 | 1038506 | 2021-02-17 | Bristol | Massachusetts | 25005 | 54252 | 1448 |
1038507 | 1038507 | 2021-02-17 | Dukes | Massachusetts | 25007 | 836 | 0 |
1038508 | 1038508 | 2021-02-17 | Essex | Massachusetts | 25009 | 81593 | 2096 |
1038509 | 1038509 | 2021-02-17 | Franklin | Massachusetts | 25011 | 1923 | 99 |
1038510 | 1038510 | 2021-02-17 | Hampden | Massachusetts | 25013 | 40130 | 1286 |
1038511 | 1038511 | 2021-02-17 | Hampshire | Massachusetts | 25015 | 6891 | 252 |
1038512 | 1038512 | 2021-02-17 | Middlesex | Massachusetts | 25017 | 108411 | 3343 |
1038513 | 1038513 | 2021-02-17 | Nantucket | Massachusetts | 25019 | 1140 | 2 |
1038514 | 1038514 | 2021-02-17 | Norfolk | Massachusetts | 25021 | 43771 | 1573 |
1038515 | 1038515 | 2021-02-17 | Plymouth | Massachusetts | 25023 | 38939 | 1256 |
1038516 | 1038516 | 2021-02-17 | Suffolk | Massachusetts | 25025 | 75876 | 1659 |
1038517 | 1038517 | 2021-02-17 | Unknown | Massachusetts | 30393 | 8 | |
1038518 | 1038518 | 2021-02-17 | Worcester | Massachusetts | 25027 | 63354 | 1973 |
1035259 | 1035259 | 2021-02-16 | Barnstable | Massachusetts | 25001 | 9644 | 380 |
1035260 | 1035260 | 2021-02-16 | Berkshire | Massachusetts | 25003 | 4746 | 243 |
1035261 | 1035261 | 2021-02-16 | Bristol | Massachusetts | 25005 | 54112 | 1448 |
1035262 | 1035262 | 2021-02-16 | Dukes | Massachusetts | 25007 | 836 | 0 |
1035263 | 1035263 | 2021-02-16 | Essex | Massachusetts | 25009 | 81390 | 2087 |
1035264 | 1035264 | 2021-02-16 | Franklin | Massachusetts | 25011 | 1918 | 99 |
1035265 | 1035265 | 2021-02-16 | Hampden | Massachusetts | 25013 | 40003 | 1282 |
1035266 | 1035266 | 2021-02-16 | Hampshire | Massachusetts | 25015 | 6812 | 251 |
1035267 | 1035267 | 2021-02-16 | Middlesex | Massachusetts | 25017 | 108172 | 3336 |
1035268 | 1035268 | 2021-02-16 | Nantucket | Massachusetts | 25019 | 1138 | 2 |
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);