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 |
---|---|---|---|---|---|---|---|
1418356 | 1418356 | 2021-06-14 | Barnstable | Massachusetts | 25001 | 13926 | 469 |
1418357 | 1418357 | 2021-06-14 | Berkshire | Massachusetts | 25003 | 6536 | 287 |
1418358 | 1418358 | 2021-06-14 | Bristol | Massachusetts | 25005 | 66821 | 1740 |
1418359 | 1418359 | 2021-06-14 | Dukes | Massachusetts | 25007 | 1412 | 0 |
1418360 | 1418360 | 2021-06-14 | Essex | Massachusetts | 25009 | 97819 | 2398 |
1418361 | 1418361 | 2021-06-14 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1418362 | 1418362 | 2021-06-14 | Hampden | Massachusetts | 25013 | 52359 | 1535 |
1418363 | 1418363 | 2021-06-14 | Hampshire | Massachusetts | 25015 | 9156 | 298 |
1418364 | 1418364 | 2021-06-14 | Middlesex | Massachusetts | 25017 | 135191 | 3770 |
1418365 | 1418365 | 2021-06-14 | Nantucket | Massachusetts | 25019 | 1519 | 0 |
1418366 | 1418366 | 2021-06-14 | Norfolk | Massachusetts | 25021 | 54942 | 1797 |
1418367 | 1418367 | 2021-06-14 | Plymouth | Massachusetts | 25023 | 49237 | 1442 |
1418368 | 1418368 | 2021-06-14 | Suffolk | Massachusetts | 25025 | 93002 | 1845 |
1418369 | 1418369 | 2021-06-14 | Unknown | Massachusetts | 47130 | 12 | |
1418370 | 1418370 | 2021-06-14 | Worcester | Massachusetts | 25027 | 77304 | 2241 |
1415111 | 1415111 | 2021-06-13 | Barnstable | Massachusetts | 25001 | 13926 | 469 |
1415112 | 1415112 | 2021-06-13 | Berkshire | Massachusetts | 25003 | 6536 | 287 |
1415113 | 1415113 | 2021-06-13 | Bristol | Massachusetts | 25005 | 66819 | 1737 |
1415114 | 1415114 | 2021-06-13 | Dukes | Massachusetts | 25007 | 1412 | 2 |
1415115 | 1415115 | 2021-06-13 | Essex | Massachusetts | 25009 | 97809 | 2396 |
1415116 | 1415116 | 2021-06-13 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1415117 | 1415117 | 2021-06-13 | Hampden | Massachusetts | 25013 | 52355 | 1535 |
1415118 | 1415118 | 2021-06-13 | Hampshire | Massachusetts | 25015 | 9158 | 298 |
1415119 | 1415119 | 2021-06-13 | Middlesex | Massachusetts | 25017 | 135182 | 3770 |
1415120 | 1415120 | 2021-06-13 | Nantucket | Massachusetts | 25019 | 1519 | 3 |
1415121 | 1415121 | 2021-06-13 | Norfolk | Massachusetts | 25021 | 54937 | 1796 |
1415122 | 1415122 | 2021-06-13 | Plymouth | Massachusetts | 25023 | 49236 | 1441 |
1415123 | 1415123 | 2021-06-13 | Suffolk | Massachusetts | 25025 | 92991 | 1845 |
1415124 | 1415124 | 2021-06-13 | Unknown | Massachusetts | 47117 | 7 | |
1415125 | 1415125 | 2021-06-13 | Worcester | Massachusetts | 25027 | 77299 | 2240 |
1411865 | 1411865 | 2021-06-12 | Barnstable | Massachusetts | 25001 | 13925 | 470 |
1411866 | 1411866 | 2021-06-12 | Berkshire | Massachusetts | 25003 | 6535 | 287 |
1411867 | 1411867 | 2021-06-12 | Bristol | Massachusetts | 25005 | 66814 | 1737 |
1411868 | 1411868 | 2021-06-12 | Dukes | Massachusetts | 25007 | 1413 | 0 |
1411869 | 1411869 | 2021-06-12 | Essex | Massachusetts | 25009 | 97803 | 2396 |
1411870 | 1411870 | 2021-06-12 | Franklin | Massachusetts | 25011 | 2579 | 113 |
1411871 | 1411871 | 2021-06-12 | Hampden | Massachusetts | 25013 | 52359 | 1534 |
1411872 | 1411872 | 2021-06-12 | Hampshire | Massachusetts | 25015 | 9158 | 298 |
1411873 | 1411873 | 2021-06-12 | Middlesex | Massachusetts | 25017 | 135172 | 3770 |
1411874 | 1411874 | 2021-06-12 | Nantucket | Massachusetts | 25019 | 1519 | 0 |
1411875 | 1411875 | 2021-06-12 | Norfolk | Massachusetts | 25021 | 54935 | 1796 |
1411876 | 1411876 | 2021-06-12 | Plymouth | Massachusetts | 25023 | 49234 | 1441 |
1411877 | 1411877 | 2021-06-12 | Suffolk | Massachusetts | 25025 | 92989 | 1845 |
1411878 | 1411878 | 2021-06-12 | Unknown | Massachusetts | 47110 | 12 | |
1411879 | 1411879 | 2021-06-12 | Worcester | Massachusetts | 25027 | 77291 | 2240 |
1408620 | 1408620 | 2021-06-11 | Barnstable | Massachusetts | 25001 | 13923 | 470 |
1408621 | 1408621 | 2021-06-11 | Berkshire | Massachusetts | 25003 | 6535 | 287 |
1408622 | 1408622 | 2021-06-11 | Bristol | Massachusetts | 25005 | 66796 | 1737 |
1408623 | 1408623 | 2021-06-11 | Dukes | Massachusetts | 25007 | 1413 | 0 |
1408624 | 1408624 | 2021-06-11 | Essex | Massachusetts | 25009 | 97789 | 2396 |
1408625 | 1408625 | 2021-06-11 | Franklin | Massachusetts | 25011 | 2577 | 113 |
1408626 | 1408626 | 2021-06-11 | Hampden | Massachusetts | 25013 | 52351 | 1534 |
1408627 | 1408627 | 2021-06-11 | Hampshire | Massachusetts | 25015 | 9154 | 298 |
1408628 | 1408628 | 2021-06-11 | Middlesex | Massachusetts | 25017 | 135151 | 3770 |
1408629 | 1408629 | 2021-06-11 | Nantucket | Massachusetts | 25019 | 1519 | 0 |
1408630 | 1408630 | 2021-06-11 | Norfolk | Massachusetts | 25021 | 54929 | 1795 |
1408631 | 1408631 | 2021-06-11 | Plymouth | Massachusetts | 25023 | 49228 | 1441 |
1408632 | 1408632 | 2021-06-11 | Suffolk | Massachusetts | 25025 | 92983 | 1844 |
1408633 | 1408633 | 2021-06-11 | Unknown | Massachusetts | 47097 | 12 | |
1408634 | 1408634 | 2021-06-11 | Worcester | Massachusetts | 25027 | 77265 | 2240 |
1405375 | 1405375 | 2021-06-10 | Barnstable | Massachusetts | 25001 | 13922 | 470 |
1405376 | 1405376 | 2021-06-10 | Berkshire | Massachusetts | 25003 | 6533 | 287 |
1405377 | 1405377 | 2021-06-10 | Bristol | Massachusetts | 25005 | 66782 | 1735 |
1405378 | 1405378 | 2021-06-10 | Dukes | Massachusetts | 25007 | 1413 | 0 |
1405379 | 1405379 | 2021-06-10 | Essex | Massachusetts | 25009 | 97770 | 2395 |
1405380 | 1405380 | 2021-06-10 | Franklin | Massachusetts | 25011 | 2577 | 113 |
1405381 | 1405381 | 2021-06-10 | Hampden | Massachusetts | 25013 | 52337 | 1532 |
1405382 | 1405382 | 2021-06-10 | Hampshire | Massachusetts | 25015 | 9152 | 298 |
1405383 | 1405383 | 2021-06-10 | Middlesex | Massachusetts | 25017 | 135136 | 3770 |
1405384 | 1405384 | 2021-06-10 | Nantucket | Massachusetts | 25019 | 1519 | 0 |
1405385 | 1405385 | 2021-06-10 | Norfolk | Massachusetts | 25021 | 54922 | 1795 |
1405386 | 1405386 | 2021-06-10 | Plymouth | Massachusetts | 25023 | 49223 | 1440 |
1405387 | 1405387 | 2021-06-10 | Suffolk | Massachusetts | 25025 | 92958 | 1844 |
1405388 | 1405388 | 2021-06-10 | Unknown | Massachusetts | 47086 | 12 | |
1405389 | 1405389 | 2021-06-10 | Worcester | Massachusetts | 25027 | 77249 | 2238 |
1402129 | 1402129 | 2021-06-09 | Barnstable | Massachusetts | 25001 | 13919 | 469 |
1402130 | 1402130 | 2021-06-09 | Berkshire | Massachusetts | 25003 | 6531 | 287 |
1402131 | 1402131 | 2021-06-09 | Bristol | Massachusetts | 25005 | 66767 | 1733 |
1402132 | 1402132 | 2021-06-09 | Dukes | Massachusetts | 25007 | 1413 | 0 |
1402133 | 1402133 | 2021-06-09 | Essex | Massachusetts | 25009 | 97759 | 2394 |
1402134 | 1402134 | 2021-06-09 | Franklin | Massachusetts | 25011 | 2577 | 113 |
1402135 | 1402135 | 2021-06-09 | Hampden | Massachusetts | 25013 | 52331 | 1532 |
1402136 | 1402136 | 2021-06-09 | Hampshire | Massachusetts | 25015 | 9152 | 298 |
1402137 | 1402137 | 2021-06-09 | Middlesex | Massachusetts | 25017 | 135121 | 3769 |
1402138 | 1402138 | 2021-06-09 | Nantucket | Massachusetts | 25019 | 1519 | 0 |
1402139 | 1402139 | 2021-06-09 | Norfolk | Massachusetts | 25021 | 54919 | 1795 |
1402140 | 1402140 | 2021-06-09 | Plymouth | Massachusetts | 25023 | 49215 | 1440 |
1402141 | 1402141 | 2021-06-09 | Suffolk | Massachusetts | 25025 | 92948 | 1842 |
1402142 | 1402142 | 2021-06-09 | Unknown | Massachusetts | 47051 | 12 | |
1402143 | 1402143 | 2021-06-09 | Worcester | Massachusetts | 25027 | 77237 | 2238 |
1398884 | 1398884 | 2021-06-08 | Barnstable | Massachusetts | 25001 | 13917 | 469 |
1398885 | 1398885 | 2021-06-08 | Berkshire | Massachusetts | 25003 | 6529 | 287 |
1398886 | 1398886 | 2021-06-08 | Bristol | Massachusetts | 25005 | 66761 | 1731 |
1398887 | 1398887 | 2021-06-08 | Dukes | Massachusetts | 25007 | 1413 | 0 |
1398888 | 1398888 | 2021-06-08 | Essex | Massachusetts | 25009 | 97740 | 2394 |
1398889 | 1398889 | 2021-06-08 | Franklin | Massachusetts | 25011 | 2576 | 113 |
1398890 | 1398890 | 2021-06-08 | Hampden | Massachusetts | 25013 | 52326 | 1531 |
1398891 | 1398891 | 2021-06-08 | Hampshire | Massachusetts | 25015 | 9150 | 298 |
1398892 | 1398892 | 2021-06-08 | Middlesex | Massachusetts | 25017 | 135107 | 3768 |
1398893 | 1398893 | 2021-06-08 | Nantucket | Massachusetts | 25019 | 1519 | 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);