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 |
---|---|---|---|---|---|---|---|
1194336 | 1194336 | 2021-04-06 | Barnstable | Massachusetts | 25001 | 12578 | 448 |
1194337 | 1194337 | 2021-04-06 | Berkshire | Massachusetts | 25003 | 5704 | 279 |
1194338 | 1194338 | 2021-04-06 | Bristol | Massachusetts | 25005 | 60968 | 1654 |
1194339 | 1194339 | 2021-04-06 | Dukes | Massachusetts | 25007 | 1041 | 0 |
1194340 | 1194340 | 2021-04-06 | Essex | Massachusetts | 25009 | 90642 | 2314 |
1194341 | 1194341 | 2021-04-06 | Franklin | Massachusetts | 25011 | 2277 | 109 |
1194342 | 1194342 | 2021-04-06 | Hampden | Massachusetts | 25013 | 46855 | 1459 |
1194343 | 1194343 | 2021-04-06 | Hampshire | Massachusetts | 25015 | 8498 | 284 |
1194344 | 1194344 | 2021-04-06 | Middlesex | Massachusetts | 25017 | 124618 | 3680 |
1194345 | 1194345 | 2021-04-06 | Nantucket | Massachusetts | 25019 | 1355 | 0 |
1194346 | 1194346 | 2021-04-06 | Norfolk | Massachusetts | 25021 | 50877 | 1745 |
1194347 | 1194347 | 2021-04-06 | Plymouth | Massachusetts | 25023 | 45076 | 1385 |
1194348 | 1194348 | 2021-04-06 | Suffolk | Massachusetts | 25025 | 86365 | 1801 |
1194349 | 1194349 | 2021-04-06 | Unknown | Massachusetts | 39707 | 12 | |
1194350 | 1194350 | 2021-04-06 | Worcester | Massachusetts | 25027 | 71462 | 2167 |
1191087 | 1191087 | 2021-04-05 | Barnstable | Massachusetts | 25001 | 12539 | 448 |
1191088 | 1191088 | 2021-04-05 | Berkshire | Massachusetts | 25003 | 5685 | 279 |
1191089 | 1191089 | 2021-04-05 | Bristol | Massachusetts | 25005 | 60827 | 1653 |
1191090 | 1191090 | 2021-04-05 | Dukes | Massachusetts | 25007 | 1038 | 0 |
1191091 | 1191091 | 2021-04-05 | Essex | Massachusetts | 25009 | 90423 | 2313 |
1191092 | 1191092 | 2021-04-05 | Franklin | Massachusetts | 25011 | 2275 | 109 |
1191093 | 1191093 | 2021-04-05 | Hampden | Massachusetts | 25013 | 46719 | 1458 |
1191094 | 1191094 | 2021-04-05 | Hampshire | Massachusetts | 25015 | 8481 | 284 |
1191095 | 1191095 | 2021-04-05 | Middlesex | Massachusetts | 25017 | 124297 | 3677 |
1191096 | 1191096 | 2021-04-05 | Nantucket | Massachusetts | 25019 | 1355 | 0 |
1191097 | 1191097 | 2021-04-05 | Norfolk | Massachusetts | 25021 | 50732 | 1743 |
1191098 | 1191098 | 2021-04-05 | Plymouth | Massachusetts | 25023 | 44915 | 1384 |
1191099 | 1191099 | 2021-04-05 | Suffolk | Massachusetts | 25025 | 86144 | 1799 |
1191100 | 1191100 | 2021-04-05 | Unknown | Massachusetts | 39465 | 12 | |
1191101 | 1191101 | 2021-04-05 | Worcester | Massachusetts | 25027 | 71325 | 2166 |
1187839 | 1187839 | 2021-04-04 | Barnstable | Massachusetts | 25001 | 12432 | 446 |
1187840 | 1187840 | 2021-04-04 | Berkshire | Massachusetts | 25003 | 5641 | 278 |
1187841 | 1187841 | 2021-04-04 | Bristol | Massachusetts | 25005 | 60549 | 1650 |
1187842 | 1187842 | 2021-04-04 | Dukes | Massachusetts | 25007 | 1004 | 0 |
1187843 | 1187843 | 2021-04-04 | Essex | Massachusetts | 25009 | 90089 | 2306 |
1187844 | 1187844 | 2021-04-04 | Franklin | Massachusetts | 25011 | 2245 | 109 |
1187845 | 1187845 | 2021-04-04 | Hampden | Massachusetts | 25013 | 46464 | 1455 |
1187846 | 1187846 | 2021-04-04 | Hampshire | Massachusetts | 25015 | 8428 | 284 |
1187847 | 1187847 | 2021-04-04 | Middlesex | Massachusetts | 25017 | 123681 | 3666 |
1187848 | 1187848 | 2021-04-04 | Nantucket | Massachusetts | 25019 | 1347 | 0 |
1187849 | 1187849 | 2021-04-04 | Norfolk | Massachusetts | 25021 | 50489 | 1736 |
1187850 | 1187850 | 2021-04-04 | Plymouth | Massachusetts | 25023 | 44673 | 1383 |
1187851 | 1187851 | 2021-04-04 | Suffolk | Massachusetts | 25025 | 85736 | 1795 |
1187852 | 1187852 | 2021-04-04 | Unknown | Massachusetts | 39383 | 12 | |
1187853 | 1187853 | 2021-04-04 | Worcester | Massachusetts | 25027 | 71071 | 2161 |
1184592 | 1184592 | 2021-04-03 | Barnstable | Massachusetts | 25001 | 12432 | 446 |
1184593 | 1184593 | 2021-04-03 | Berkshire | Massachusetts | 25003 | 5641 | 278 |
1184594 | 1184594 | 2021-04-03 | Bristol | Massachusetts | 25005 | 60549 | 1650 |
1184595 | 1184595 | 2021-04-03 | Dukes | Massachusetts | 25007 | 1004 | 0 |
1184596 | 1184596 | 2021-04-03 | Essex | Massachusetts | 25009 | 90089 | 2306 |
1184597 | 1184597 | 2021-04-03 | Franklin | Massachusetts | 25011 | 2245 | 109 |
1184598 | 1184598 | 2021-04-03 | Hampden | Massachusetts | 25013 | 46464 | 1455 |
1184599 | 1184599 | 2021-04-03 | Hampshire | Massachusetts | 25015 | 8428 | 284 |
1184600 | 1184600 | 2021-04-03 | Middlesex | Massachusetts | 25017 | 123681 | 3666 |
1184601 | 1184601 | 2021-04-03 | Nantucket | Massachusetts | 25019 | 1347 | 0 |
1184602 | 1184602 | 2021-04-03 | Norfolk | Massachusetts | 25021 | 50489 | 1736 |
1184603 | 1184603 | 2021-04-03 | Plymouth | Massachusetts | 25023 | 44673 | 1383 |
1184604 | 1184604 | 2021-04-03 | Suffolk | Massachusetts | 25025 | 85736 | 1795 |
1184605 | 1184605 | 2021-04-03 | Unknown | Massachusetts | 39383 | 12 | |
1184606 | 1184606 | 2021-04-03 | Worcester | Massachusetts | 25027 | 71071 | 2161 |
1181346 | 1181346 | 2021-04-02 | Barnstable | Massachusetts | 25001 | 12347 | 445 |
1181347 | 1181347 | 2021-04-02 | Berkshire | Massachusetts | 25003 | 5606 | 277 |
1181348 | 1181348 | 2021-04-02 | Bristol | Massachusetts | 25005 | 60336 | 1645 |
1181349 | 1181349 | 2021-04-02 | Dukes | Massachusetts | 25007 | 985 | 0 |
1181350 | 1181350 | 2021-04-02 | Essex | Massachusetts | 25009 | 89805 | 2300 |
1181351 | 1181351 | 2021-04-02 | Franklin | Massachusetts | 25011 | 2235 | 108 |
1181352 | 1181352 | 2021-04-02 | Hampden | Massachusetts | 25013 | 46232 | 1453 |
1181353 | 1181353 | 2021-04-02 | Hampshire | Massachusetts | 25015 | 8391 | 284 |
1181354 | 1181354 | 2021-04-02 | Middlesex | Massachusetts | 25017 | 123209 | 3661 |
1181355 | 1181355 | 2021-04-02 | Nantucket | Massachusetts | 25019 | 1335 | 0 |
1181356 | 1181356 | 2021-04-02 | Norfolk | Massachusetts | 25021 | 50314 | 1731 |
1181357 | 1181357 | 2021-04-02 | Plymouth | Massachusetts | 25023 | 44512 | 1382 |
1181358 | 1181358 | 2021-04-02 | Suffolk | Massachusetts | 25025 | 85406 | 1794 |
1181359 | 1181359 | 2021-04-02 | Unknown | Massachusetts | 39220 | 12 | |
1181360 | 1181360 | 2021-04-02 | Worcester | Massachusetts | 25027 | 70846 | 2157 |
1178099 | 1178099 | 2021-04-01 | Barnstable | Massachusetts | 25001 | 12247 | 445 |
1178100 | 1178100 | 2021-04-01 | Berkshire | Massachusetts | 25003 | 5559 | 276 |
1178101 | 1178101 | 2021-04-01 | Bristol | Massachusetts | 25005 | 60145 | 1642 |
1178102 | 1178102 | 2021-04-01 | Dukes | Massachusetts | 25007 | 977 | 0 |
1178103 | 1178103 | 2021-04-01 | Essex | Massachusetts | 25009 | 89599 | 2299 |
1178104 | 1178104 | 2021-04-01 | Franklin | Massachusetts | 25011 | 2222 | 107 |
1178105 | 1178105 | 2021-04-01 | Hampden | Massachusetts | 25013 | 46061 | 1446 |
1178106 | 1178106 | 2021-04-01 | Hampshire | Massachusetts | 25015 | 8361 | 284 |
1178107 | 1178107 | 2021-04-01 | Middlesex | Massachusetts | 25017 | 122757 | 3654 |
1178108 | 1178108 | 2021-04-01 | Nantucket | Massachusetts | 25019 | 1326 | 0 |
1178109 | 1178109 | 2021-04-01 | Norfolk | Massachusetts | 25021 | 50141 | 1726 |
1178110 | 1178110 | 2021-04-01 | Plymouth | Massachusetts | 25023 | 44357 | 1380 |
1178111 | 1178111 | 2021-04-01 | Suffolk | Massachusetts | 25025 | 85036 | 1791 |
1178112 | 1178112 | 2021-04-01 | Unknown | Massachusetts | 38934 | 12 | |
1178113 | 1178113 | 2021-04-01 | Worcester | Massachusetts | 25027 | 70617 | 2155 |
1174852 | 1174852 | 2021-03-31 | Barnstable | Massachusetts | 25001 | 12150 | 444 |
1174853 | 1174853 | 2021-03-31 | Berkshire | Massachusetts | 25003 | 5507 | 276 |
1174854 | 1174854 | 2021-03-31 | Bristol | Massachusetts | 25005 | 59917 | 1637 |
1174855 | 1174855 | 2021-03-31 | Dukes | Massachusetts | 25007 | 961 | 0 |
1174856 | 1174856 | 2021-03-31 | Essex | Massachusetts | 25009 | 89306 | 2295 |
1174857 | 1174857 | 2021-03-31 | Franklin | Massachusetts | 25011 | 2215 | 107 |
1174858 | 1174858 | 2021-03-31 | Hampden | Massachusetts | 25013 | 45841 | 1446 |
1174859 | 1174859 | 2021-03-31 | Hampshire | Massachusetts | 25015 | 8327 | 284 |
1174860 | 1174860 | 2021-03-31 | Middlesex | Massachusetts | 25017 | 122222 | 3645 |
1174861 | 1174861 | 2021-03-31 | Nantucket | Massachusetts | 25019 | 1317 | 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);