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 |
---|---|---|---|---|---|---|---|
281988 | 281988 | 2020-06-28 | Barnstable | Massachusetts | 25001 | 1532 | 144 |
281989 | 281989 | 2020-06-28 | Berkshire | Massachusetts | 25003 | 594 | 44 |
281990 | 281990 | 2020-06-28 | Bristol | Massachusetts | 25005 | 8198 | 568 |
281991 | 281991 | 2020-06-28 | Dukes | Massachusetts | 25007 | 48 | 0 |
281992 | 281992 | 2020-06-28 | Essex | Massachusetts | 25009 | 16053 | 1099 |
281993 | 281993 | 2020-06-28 | Franklin | Massachusetts | 25011 | 366 | 54 |
281994 | 281994 | 2020-06-28 | Hampden | Massachusetts | 25013 | 6760 | 663 |
281995 | 281995 | 2020-06-28 | Hampshire | Massachusetts | 25015 | 958 | 110 |
281996 | 281996 | 2020-06-28 | Middlesex | Massachusetts | 25017 | 23915 | 1855 |
281997 | 281997 | 2020-06-28 | Nantucket | Massachusetts | 25019 | 15 | 1 |
281998 | 281998 | 2020-06-28 | Norfolk | Massachusetts | 25021 | 9151 | 927 |
281999 | 281999 | 2020-06-28 | Plymouth | Massachusetts | 25023 | 8671 | 663 |
282000 | 282000 | 2020-06-28 | Suffolk | Massachusetts | 25025 | 19795 | 1004 |
282001 | 282001 | 2020-06-28 | Unknown | Massachusetts | 287 | 7 | |
282002 | 282002 | 2020-06-28 | Worcester | Massachusetts | 25027 | 12324 | 921 |
278840 | 278840 | 2020-06-27 | Barnstable | Massachusetts | 25001 | 1531 | 143 |
278841 | 278841 | 2020-06-27 | Berkshire | Massachusetts | 25003 | 594 | 44 |
278842 | 278842 | 2020-06-27 | Bristol | Massachusetts | 25005 | 8176 | 567 |
278843 | 278843 | 2020-06-27 | Dukes | Massachusetts | 25007 | 48 | 0 |
278844 | 278844 | 2020-06-27 | Essex | Massachusetts | 25009 | 16028 | 1096 |
278845 | 278845 | 2020-06-27 | Franklin | Massachusetts | 25011 | 366 | 54 |
278846 | 278846 | 2020-06-27 | Hampden | Massachusetts | 25013 | 6729 | 659 |
278847 | 278847 | 2020-06-27 | Hampshire | Massachusetts | 25015 | 955 | 110 |
278848 | 278848 | 2020-06-27 | Middlesex | Massachusetts | 25017 | 23859 | 1849 |
278849 | 278849 | 2020-06-27 | Nantucket | Massachusetts | 25019 | 15 | 0 |
278850 | 278850 | 2020-06-27 | Norfolk | Massachusetts | 25021 | 9125 | 927 |
278851 | 278851 | 2020-06-27 | Plymouth | Massachusetts | 25023 | 8661 | 660 |
278852 | 278852 | 2020-06-27 | Suffolk | Massachusetts | 25025 | 19764 | 1004 |
278853 | 278853 | 2020-06-27 | Unknown | Massachusetts | 289 | 7 | |
278854 | 278854 | 2020-06-27 | Worcester | Massachusetts | 25027 | 12303 | 920 |
275692 | 275692 | 2020-06-26 | Barnstable | Massachusetts | 25001 | 1530 | 143 |
275693 | 275693 | 2020-06-26 | Berkshire | Massachusetts | 25003 | 592 | 44 |
275694 | 275694 | 2020-06-26 | Bristol | Massachusetts | 25005 | 8142 | 565 |
275695 | 275695 | 2020-06-26 | Dukes | Massachusetts | 25007 | 46 | 0 |
275696 | 275696 | 2020-06-26 | Essex | Massachusetts | 25009 | 15975 | 1092 |
275697 | 275697 | 2020-06-26 | Franklin | Massachusetts | 25011 | 364 | 54 |
275698 | 275698 | 2020-06-26 | Hampden | Massachusetts | 25013 | 6691 | 657 |
275699 | 275699 | 2020-06-26 | Hampshire | Massachusetts | 25015 | 952 | 109 |
275700 | 275700 | 2020-06-26 | Middlesex | Massachusetts | 25017 | 23786 | 1839 |
275701 | 275701 | 2020-06-26 | Nantucket | Massachusetts | 25019 | 14 | 0 |
275702 | 275702 | 2020-06-26 | Norfolk | Massachusetts | 25021 | 9100 | 927 |
275703 | 275703 | 2020-06-26 | Plymouth | Massachusetts | 25023 | 8646 | 658 |
275704 | 275704 | 2020-06-26 | Suffolk | Massachusetts | 25025 | 19707 | 997 |
275705 | 275705 | 2020-06-26 | Unknown | Massachusetts | 285 | 7 | |
275706 | 275706 | 2020-06-26 | Worcester | Massachusetts | 25027 | 12240 | 920 |
272549 | 272549 | 2020-06-25 | Barnstable | Massachusetts | 25001 | 1525 | 141 |
272550 | 272550 | 2020-06-25 | Berkshire | Massachusetts | 25003 | 591 | 44 |
272551 | 272551 | 2020-06-25 | Bristol | Massachusetts | 25005 | 8107 | 558 |
272552 | 272552 | 2020-06-25 | Dukes | Massachusetts | 25007 | 45 | 0 |
272553 | 272553 | 2020-06-25 | Essex | Massachusetts | 25009 | 15952 | 1086 |
272554 | 272554 | 2020-06-25 | Franklin | Massachusetts | 25011 | 362 | 54 |
272555 | 272555 | 2020-06-25 | Hampden | Massachusetts | 25013 | 6658 | 654 |
272556 | 272556 | 2020-06-25 | Hampshire | Massachusetts | 25015 | 952 | 109 |
272557 | 272557 | 2020-06-25 | Middlesex | Massachusetts | 25017 | 23741 | 1825 |
272558 | 272558 | 2020-06-25 | Nantucket | Massachusetts | 25019 | 14 | 0 |
272559 | 272559 | 2020-06-25 | Norfolk | Massachusetts | 25021 | 9082 | 924 |
272560 | 272560 | 2020-06-25 | Plymouth | Massachusetts | 25023 | 8625 | 654 |
272561 | 272561 | 2020-06-25 | Suffolk | Massachusetts | 25025 | 19664 | 990 |
272562 | 272562 | 2020-06-25 | Unknown | Massachusetts | 283 | 6 | |
272563 | 272563 | 2020-06-25 | Worcester | Massachusetts | 25027 | 12236 | 917 |
269412 | 269412 | 2020-06-24 | Barnstable | Massachusetts | 25001 | 1525 | 140 |
269413 | 269413 | 2020-06-24 | Berkshire | Massachusetts | 25003 | 591 | 44 |
269414 | 269414 | 2020-06-24 | Bristol | Massachusetts | 25005 | 8086 | 555 |
269415 | 269415 | 2020-06-24 | Dukes | Massachusetts | 25007 | 45 | 0 |
269416 | 269416 | 2020-06-24 | Essex | Massachusetts | 25009 | 15920 | 1083 |
269417 | 269417 | 2020-06-24 | Franklin | Massachusetts | 25011 | 359 | 53 |
269418 | 269418 | 2020-06-24 | Hampden | Massachusetts | 25013 | 6633 | 654 |
269419 | 269419 | 2020-06-24 | Hampshire | Massachusetts | 25015 | 950 | 108 |
269420 | 269420 | 2020-06-24 | Middlesex | Massachusetts | 25017 | 23697 | 1820 |
269421 | 269421 | 2020-06-24 | Nantucket | Massachusetts | 25019 | 14 | 0 |
269422 | 269422 | 2020-06-24 | Norfolk | Massachusetts | 25021 | 9056 | 923 |
269423 | 269423 | 2020-06-24 | Plymouth | Massachusetts | 25023 | 8610 | 651 |
269424 | 269424 | 2020-06-24 | Suffolk | Massachusetts | 25025 | 19628 | 984 |
269425 | 269425 | 2020-06-24 | Unknown | Massachusetts | 290 | 8 | |
269426 | 269426 | 2020-06-24 | Worcester | Massachusetts | 25027 | 12207 | 914 |
266279 | 266279 | 2020-06-23 | Barnstable | Massachusetts | 25001 | 1523 | 140 |
266280 | 266280 | 2020-06-23 | Berkshire | Massachusetts | 25003 | 591 | 44 |
266281 | 266281 | 2020-06-23 | Bristol | Massachusetts | 25005 | 8081 | 548 |
266282 | 266282 | 2020-06-23 | Dukes | Massachusetts | 25007 | 45 | 0 |
266283 | 266283 | 2020-06-23 | Essex | Massachusetts | 25009 | 15885 | 1081 |
266284 | 266284 | 2020-06-23 | Franklin | Massachusetts | 25011 | 359 | 53 |
266285 | 266285 | 2020-06-23 | Hampden | Massachusetts | 25013 | 6620 | 649 |
266286 | 266286 | 2020-06-23 | Hampshire | Massachusetts | 25015 | 947 | 107 |
266287 | 266287 | 2020-06-23 | Middlesex | Massachusetts | 25017 | 23647 | 1812 |
266288 | 266288 | 2020-06-23 | Nantucket | Massachusetts | 25019 | 14 | 0 |
266289 | 266289 | 2020-06-23 | Norfolk | Massachusetts | 25021 | 9042 | 919 |
266290 | 266290 | 2020-06-23 | Plymouth | Massachusetts | 25023 | 8604 | 647 |
266291 | 266291 | 2020-06-23 | Suffolk | Massachusetts | 25025 | 19601 | 976 |
266292 | 266292 | 2020-06-23 | Unknown | Massachusetts | 288 | 8 | |
266293 | 266293 | 2020-06-23 | Worcester | Massachusetts | 25027 | 12192 | 905 |
263153 | 263153 | 2020-06-22 | Barnstable | Massachusetts | 25001 | 1517 | 138 |
263154 | 263154 | 2020-06-22 | Berkshire | Massachusetts | 25003 | 591 | 44 |
263155 | 263155 | 2020-06-22 | Bristol | Massachusetts | 25005 | 8057 | 546 |
263156 | 263156 | 2020-06-22 | Dukes | Massachusetts | 25007 | 45 | 0 |
263157 | 263157 | 2020-06-22 | Essex | Massachusetts | 25009 | 15851 | 1077 |
263158 | 263158 | 2020-06-22 | Franklin | Massachusetts | 25011 | 358 | 53 |
263159 | 263159 | 2020-06-22 | Hampden | Massachusetts | 25013 | 6610 | 647 |
263160 | 263160 | 2020-06-22 | Hampshire | Massachusetts | 25015 | 946 | 107 |
263161 | 263161 | 2020-06-22 | Middlesex | Massachusetts | 25017 | 23609 | 1809 |
263162 | 263162 | 2020-06-22 | Nantucket | Massachusetts | 25019 | 14 | 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);