daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14,215 rows where province_or_state = "Massachusetts" sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-31 | US | Massachusetts | Middlesex | 25017 | 1340 | 17 | 0 | 1323 | 42.48607732 | -71.39049229 | 2020-03-31 23:43:56 | Middlesex, Massachusetts, US |
2020-03-31 | US | Massachusetts | Norfolk | 25021 | 738 | 12 | 0 | 726 | 42.16073095 | -71.20530408 | 2020-03-31 23:43:56 | Norfolk, Massachusetts, US |
2020-03-31 | US | Massachusetts | Plymouth | 25023 | 459 | 2 | 0 | 457 | 41.94070556 | -70.80802823 | 2020-03-31 23:43:56 | Plymouth, Massachusetts, US |
2020-03-31 | US | Massachusetts | Suffolk | 25025 | 1373 | 6 | 0 | 1367 | 42.327951399999996 | -71.07850442 | 2020-03-31 23:43:56 | Suffolk, Massachusetts, US |
2020-03-31 | US | Massachusetts | Unassigned | 333 | 9 | 0 | 324 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Massachusetts, US | |
2020-03-31 | US | Massachusetts | Worcester | 25027 | 433 | 7 | 0 | 426 | 42.35026951 | -71.90493363 | 2020-03-31 23:43:56 | Worcester, Massachusetts, US |
2020-04-01 | US | Massachusetts | Barnstable | 25001 | 255 | 3 | 0 | 252 | 41.72980578 | -70.28854339 | 2020-04-01 21:58:49 | Barnstable, Massachusetts, US |
2020-04-01 | US | Massachusetts | Berkshire | 25003 | 183 | 4 | 0 | 179 | 42.37428441 | -73.20524838 | 2020-04-01 21:58:49 | Berkshire, Massachusetts, US |
2020-04-01 | US | Massachusetts | Bristol | 25005 | 366 | 3 | 0 | 363 | 41.79228404 | -71.10872211 | 2020-04-01 21:58:49 | Bristol, Massachusetts, US |
2020-04-01 | US | Massachusetts | Dukes and Nantucket | 11 | 0 | 0 | 11 | 41.40674725 | -70.68763497 | 2020-04-01 21:58:49 | Dukes and Nantucket,Massachusetts,US | |
2020-04-01 | US | Massachusetts | Essex | 25009 | 885 | 17 | 0 | 868 | 42.6687626 | -70.94687179 | 2020-04-01 21:58:49 | Essex, Massachusetts, US |
2020-04-01 | US | Massachusetts | Franklin | 25011 | 72 | 7 | 0 | 65 | 42.58119713 | -72.58602547 | 2020-04-01 21:58:49 | Franklin, Massachusetts, US |
2020-04-01 | US | Massachusetts | Hampden | 25013 | 475 | 16 | 0 | 459 | 42.13440424 | -72.63235561 | 2020-04-01 21:58:49 | Hampden, Massachusetts, US |
2020-04-01 | US | Massachusetts | Hampshire | 25015 | 81 | 1 | 0 | 80 | 42.33997957 | -72.65898478 | 2020-04-01 21:58:49 | Hampshire, Massachusetts, US |
2020-04-01 | US | Massachusetts | Middlesex | 25017 | 1582 | 20 | 0 | 1562 | 42.48607732 | -71.39049229 | 2020-04-01 21:58:49 | Middlesex, Massachusetts, US |
2020-04-01 | US | Massachusetts | Norfolk | 25021 | 829 | 15 | 0 | 814 | 42.16073095 | -71.20530408 | 2020-04-01 21:58:49 | Norfolk, Massachusetts, US |
2020-04-01 | US | Massachusetts | Plymouth | 25023 | 561 | 5 | 0 | 556 | 41.94070556 | -70.80802823 | 2020-04-01 21:58:49 | Plymouth, Massachusetts, US |
2020-04-01 | US | Massachusetts | Suffolk | 25025 | 1624 | 13 | 0 | 1611 | 42.327951399999996 | -71.07850442 | 2020-04-01 21:58:49 | Suffolk, Massachusetts, US |
2020-04-01 | US | Massachusetts | Unassigned | 251 | 9 | 0 | 242 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, Massachusetts, US | |
2020-04-01 | US | Massachusetts | Worcester | 25027 | 563 | 9 | 0 | 554 | 42.35026951 | -71.90493363 | 2020-04-01 21:58:49 | Worcester, Massachusetts, US |
2020-04-03 | US | Massachusetts | Barnstable | 25001 | 314 | 6 | 0 | 308 | 41.72980578 | -70.28854339 | 2020-04-03 22:46:37 | Barnstable, Massachusetts, US |
2020-04-03 | US | Massachusetts | Berkshire | 25003 | 240 | 5 | 0 | 235 | 42.37428441 | -73.20524838 | 2020-04-03 22:46:37 | Berkshire, Massachusetts, US |
2020-04-03 | US | Massachusetts | Bristol | 25005 | 517 | 4 | 0 | 513 | 41.79228404 | -71.10872211 | 2020-04-03 22:46:37 | Bristol, Massachusetts, US |
2020-04-03 | US | Massachusetts | Dukes and Nantucket | 16 | 0 | 0 | 16 | 41.40674725 | -70.68763497 | 2020-04-03 22:46:37 | Dukes and Nantucket,Massachusetts,US | |
2020-04-03 | US | Massachusetts | Essex | 25009 | 1238 | 23 | 0 | 1215 | 42.6687626 | -70.94687179 | 2020-04-03 22:46:37 | Essex, Massachusetts, US |
2020-04-03 | US | Massachusetts | Franklin | 25011 | 89 | 11 | 0 | 78 | 42.58119713 | -72.58602547 | 2020-04-03 22:46:37 | Franklin, Massachusetts, US |
2020-04-03 | US | Massachusetts | Hampden | 25013 | 661 | 27 | 0 | 634 | 42.13440424 | -72.63235561 | 2020-04-03 22:46:37 | Hampden, Massachusetts, US |
2020-04-03 | US | Massachusetts | Hampshire | 25015 | 114 | 3 | 0 | 111 | 42.33997957 | -72.65898478 | 2020-04-03 22:46:37 | Hampshire, Massachusetts, US |
2020-04-03 | US | Massachusetts | Middlesex | 25017 | 2202 | 38 | 0 | 2164 | 42.48607732 | -71.39049229 | 2020-04-03 22:46:37 | Middlesex, Massachusetts, US |
2020-04-03 | US | Massachusetts | Norfolk | 25021 | 1045 | 24 | 0 | 1021 | 42.16073095 | -71.20530408 | 2020-04-03 22:46:37 | Norfolk, Massachusetts, US |
2020-04-03 | US | Massachusetts | Plymouth | 25023 | 745 | 7 | 0 | 738 | 41.94070556 | -70.80802823 | 2020-04-03 22:46:37 | Plymouth, Massachusetts, US |
2020-04-03 | US | Massachusetts | Suffolk | 25025 | 2183 | 21 | 0 | 2162 | 42.327951399999996 | -71.07850442 | 2020-04-03 22:46:37 | Suffolk, Massachusetts, US |
2020-04-03 | US | Massachusetts | Unassigned | 90025 | 213 | 9 | 0 | 204 | 42.6687626 | 0.0 | 2020-04-03 22:46:37 | Unassigned, Massachusetts, US |
2020-04-03 | US | Massachusetts | Worcester | 25027 | 825 | 14 | 0 | 811 | 42.35026951 | -71.90493363 | 2020-04-03 22:46:37 | Worcester, Massachusetts, US |
2020-04-05 | US | Massachusetts | Barnstable | 25001 | 347 | 6 | 0 | 341 | 41.72980578 | -70.28854339 | 2020-04-05 23:06:45 | Barnstable, Massachusetts, US |
2020-04-05 | US | Massachusetts | Berkshire | 25003 | 258 | 11 | 0 | 247 | 42.37428441 | -73.20524838 | 2020-04-05 23:06:45 | Berkshire, Massachusetts, US |
2020-04-05 | US | Massachusetts | Bristol | 25005 | 659 | 8 | 0 | 651 | 41.79228404 | -71.10872211 | 2020-04-05 23:06:45 | Bristol, Massachusetts, US |
2020-04-05 | US | Massachusetts | Dukes and Nantucket | 17 | 0 | 0 | 17 | 41.40674725 | -70.68763497 | 2020-04-05 23:06:45 | Dukes and Nantucket,Massachusetts,US | |
2020-04-05 | US | Massachusetts | Essex | 25009 | 1506 | 27 | 0 | 1479 | 42.6687626 | -70.94687179 | 2020-04-05 23:06:45 | Essex, Massachusetts, US |
2020-04-05 | US | Massachusetts | Franklin | 25011 | 100 | 12 | 0 | 88 | 42.58119713 | -72.58602547 | 2020-04-05 23:06:45 | Franklin, Massachusetts, US |
2020-04-05 | US | Massachusetts | Hampden | 25013 | 768 | 34 | 0 | 734 | 42.13440424 | -72.63235561 | 2020-04-05 23:06:45 | Hampden, Massachusetts, US |
2020-04-05 | US | Massachusetts | Hampshire | 25015 | 128 | 3 | 0 | 125 | 42.33997957 | -72.65898478 | 2020-04-05 23:06:45 | Hampshire, Massachusetts, US |
2020-04-05 | US | Massachusetts | Middlesex | 25017 | 2632 | 41 | 0 | 2591 | 42.48607732 | -71.39049229 | 2020-04-05 23:06:45 | Middlesex, Massachusetts, US |
2020-04-05 | US | Massachusetts | Norfolk | 25021 | 1271 | 26 | 0 | 1245 | 42.16073095 | -71.20530408 | 2020-04-05 23:06:45 | Norfolk, Massachusetts, US |
2020-04-05 | US | Massachusetts | Plymouth | 25023 | 963 | 10 | 0 | 953 | 41.94070556 | -70.80802823 | 2020-04-05 23:06:45 | Plymouth, Massachusetts, US |
2020-04-05 | US | Massachusetts | Suffolk | 25025 | 2658 | 27 | 0 | 2631 | 42.327951399999996 | -71.07850442 | 2020-04-05 23:06:45 | Suffolk, Massachusetts, US |
2020-04-05 | US | Massachusetts | Unassigned | 90025 | 215 | 9 | 0 | 206 | 42.6687626 | 0.0 | 2020-04-05 23:06:45 | Unassigned, Massachusetts, US |
2020-04-05 | US | Massachusetts | Worcester | 25027 | 978 | 17 | 0 | 961 | 42.35026951 | -71.90493363 | 2020-04-05 23:06:45 | Worcester, Massachusetts, US |
2020-04-07 | US | Massachusetts | Barnstable | 25001 | 405 | 10 | 0 | 395 | 41.72980578 | -70.28854339 | 2020-04-07 23:04:49 | Barnstable, Massachusetts, US |
2020-04-07 | US | Massachusetts | Berkshire | 25003 | 278 | 16 | 0 | 262 | 42.37428441 | -73.20524838 | 2020-04-07 23:04:49 | Berkshire, Massachusetts, US |
2020-04-07 | US | Massachusetts | Bristol | 25005 | 768 | 16 | 0 | 752 | 41.79228404 | -71.10872211 | 2020-04-07 23:04:49 | Bristol, Massachusetts, US |
2020-04-07 | US | Massachusetts | Dukes and Nantucket | 18 | 1 | 0 | 17 | 41.40674725 | -70.68763497 | 2020-04-07 23:04:49 | Dukes and Nantucket,Massachusetts,US | |
2020-04-07 | US | Massachusetts | Essex | 25009 | 1841 | 35 | 0 | 1806 | 42.6687626 | -70.94687179 | 2020-04-07 23:04:49 | Essex, Massachusetts, US |
2020-04-07 | US | Massachusetts | Franklin | 25011 | 118 | 17 | 0 | 101 | 42.58119713 | -72.58602547 | 2020-04-07 23:04:49 | Franklin, Massachusetts, US |
2020-04-07 | US | Massachusetts | Hampden | 25013 | 997 | 55 | 0 | 942 | 42.13440424 | -72.63235561 | 2020-04-07 23:04:49 | Hampden, Massachusetts, US |
2020-04-07 | US | Massachusetts | Hampshire | 25015 | 158 | 3 | 0 | 155 | 42.33997957 | -72.65898478 | 2020-04-07 23:04:49 | Hampshire, Massachusetts, US |
2020-04-07 | US | Massachusetts | Middlesex | 25017 | 3187 | 68 | 0 | 3119 | 42.48607732 | -71.39049229 | 2020-04-07 23:04:49 | Middlesex, Massachusetts, US |
2020-04-07 | US | Massachusetts | Norfolk | 25021 | 1592 | 35 | 0 | 1557 | 42.16073095 | -71.20530408 | 2020-04-07 23:04:49 | Norfolk, Massachusetts, US |
2020-04-07 | US | Massachusetts | Plymouth | 25023 | 1194 | 26 | 0 | 1168 | 41.94070556 | -70.80802823 | 2020-04-07 23:04:49 | Plymouth, Massachusetts, US |
2020-04-07 | US | Massachusetts | Suffolk | 25025 | 3245 | 40 | 0 | 3205 | 42.327951399999996 | -71.07850442 | 2020-04-07 23:04:49 | Suffolk, Massachusetts, US |
2020-04-07 | US | Massachusetts | Unassigned | 90025 | 229 | 11 | 0 | 218 | 42.6687626 | 0.0 | 2020-04-07 23:04:49 | Unassigned, Massachusetts, US |
2020-04-07 | US | Massachusetts | Worcester | 25027 | 1172 | 23 | 0 | 1149 | 42.35026951 | -71.90493363 | 2020-04-07 23:04:49 | Worcester, Massachusetts, US |
2020-04-08 | US | Massachusetts | Barnstable | 25001 | 423 | 11 | 0 | 412 | 41.72980578 | -70.28854339 | 2020-04-08 22:51:58 | Barnstable, Massachusetts, US |
2020-04-08 | US | Massachusetts | Berkshire | 25003 | 281 | 18 | 0 | 263 | 42.37428441 | -73.20524838 | 2020-04-08 22:51:58 | Berkshire, Massachusetts, US |
2020-04-08 | US | Massachusetts | Bristol | 25005 | 835 | 23 | 0 | 812 | 41.79228404 | -71.10872211 | 2020-04-08 22:51:58 | Bristol, Massachusetts, US |
2020-04-08 | US | Massachusetts | Dukes and Nantucket | 17 | 1 | 0 | 16 | 41.40674725 | -70.68763497 | 2020-04-08 22:51:58 | Dukes and Nantucket,Massachusetts,US | |
2020-04-08 | US | Massachusetts | Essex | 25009 | 2103 | 50 | 0 | 2053 | 42.6687626 | -70.94687179 | 2020-04-08 22:51:58 | Essex, Massachusetts, US |
2020-04-08 | US | Massachusetts | Franklin | 25011 | 117 | 21 | 0 | 96 | 42.58119713 | -72.58602547 | 2020-04-08 22:51:58 | Franklin, Massachusetts, US |
2020-04-08 | US | Massachusetts | Hampden | 25013 | 1081 | 62 | 0 | 1019 | 42.13440424 | -72.63235561 | 2020-04-08 22:51:58 | Hampden, Massachusetts, US |
2020-04-08 | US | Massachusetts | Hampshire | 25015 | 164 | 3 | 0 | 161 | 42.33997957 | -72.65898478 | 2020-04-08 22:51:58 | Hampshire, Massachusetts, US |
2020-04-08 | US | Massachusetts | Middlesex | 25017 | 3545 | 80 | 0 | 3465 | 42.48607732 | -71.39049229 | 2020-04-08 22:51:58 | Middlesex, Massachusetts, US |
2020-04-08 | US | Massachusetts | Norfolk | 25021 | 1778 | 41 | 0 | 1737 | 42.16073095 | -71.20530408 | 2020-04-08 22:51:58 | Norfolk, Massachusetts, US |
2020-04-08 | US | Massachusetts | Plymouth | 25023 | 1327 | 33 | 0 | 1294 | 41.94070556 | -70.80802823 | 2020-04-08 22:51:58 | Plymouth, Massachusetts, US |
2020-04-08 | US | Massachusetts | Suffolk | 25025 | 3600 | 48 | 0 | 3552 | 42.327951399999996 | -71.07850442 | 2020-04-08 22:51:58 | Suffolk, Massachusetts, US |
2020-04-08 | US | Massachusetts | Unassigned | 90025 | 223 | 13 | 0 | 210 | 42.6687626 | 0.0 | 2020-04-08 22:51:58 | Unassigned, Massachusetts, US |
2020-04-08 | US | Massachusetts | Worcester | 25027 | 1296 | 29 | 0 | 1267 | 42.35026951 | -71.90493363 | 2020-04-08 22:51:58 | Worcester, Massachusetts, US |
2020-04-09 | US | Massachusetts | Barnstable | 25001 | 444 | 11 | 0 | 433 | 41.72980578 | -70.28854339 | 2020-04-09 23:02:37 | Barnstable, Massachusetts, US |
2020-04-09 | US | Massachusetts | Berkshire | 25003 | 304 | 18 | 0 | 286 | 42.37428441 | -73.20524838 | 2020-04-09 23:02:37 | Berkshire, Massachusetts, US |
2020-04-09 | US | Massachusetts | Bristol | 25005 | 994 | 23 | 0 | 971 | 41.79228404 | -71.10872211 | 2020-04-09 23:02:37 | Bristol, Massachusetts, US |
2020-04-09 | US | Massachusetts | Dukes and Nantucket | 18 | 1 | 0 | 17 | 41.40674725 | -70.68763497 | 2020-04-09 23:02:37 | Dukes and Nantucket,Massachusetts,US | |
2020-04-09 | US | Massachusetts | Essex | 25009 | 2336 | 50 | 0 | 2286 | 42.6687626 | -70.94687179 | 2020-04-09 23:02:37 | Essex, Massachusetts, US |
2020-04-09 | US | Massachusetts | Franklin | 25011 | 128 | 21 | 0 | 107 | 42.58119713 | -72.58602547 | 2020-04-09 23:02:37 | Franklin, Massachusetts, US |
2020-04-09 | US | Massachusetts | Hampden | 25013 | 1276 | 62 | 0 | 1214 | 42.13440424 | -72.63235561 | 2020-04-09 23:02:37 | Hampden, Massachusetts, US |
2020-04-09 | US | Massachusetts | Hampshire | 25015 | 177 | 3 | 0 | 174 | 42.33997957 | -72.65898478 | 2020-04-09 23:02:37 | Hampshire, Massachusetts, US |
2020-04-09 | US | Massachusetts | Middlesex | 25017 | 4045 | 80 | 0 | 3965 | 42.48607732 | -71.39049229 | 2020-04-09 23:02:37 | Middlesex, Massachusetts, US |
2020-04-09 | US | Massachusetts | Norfolk | 25021 | 2007 | 41 | 0 | 1966 | 42.16073095 | -71.20530408 | 2020-04-09 23:02:37 | Norfolk, Massachusetts, US |
2020-04-09 | US | Massachusetts | Plymouth | 25023 | 1507 | 33 | 0 | 1474 | 41.94070556 | -70.80802823 | 2020-04-09 23:02:37 | Plymouth, Massachusetts, US |
2020-04-09 | US | Massachusetts | Suffolk | 25025 | 4041 | 48 | 0 | 3993 | 42.327951399999996 | -71.07850442 | 2020-04-09 23:02:37 | Suffolk, Massachusetts, US |
2020-04-09 | US | Massachusetts | Unassigned | 90025 | 203 | 83 | 0 | 120 | 42.6687626 | 0.0 | 2020-04-09 23:02:37 | Unassigned, Massachusetts, US |
2020-04-09 | US | Massachusetts | Worcester | 25027 | 1461 | 29 | 0 | 1432 | 42.35026951 | -71.90493363 | 2020-04-09 23:02:37 | Worcester, Massachusetts, US |
2020-04-10 | US | Massachusetts | Barnstable | 25001 | 464 | 11 | 0 | 453 | 41.72980578 | -70.28854339 | 2020-04-10 22:54:07 | Barnstable, Massachusetts, US |
2020-04-10 | US | Massachusetts | Berkshire | 25003 | 329 | 18 | 0 | 311 | 42.37428441 | -73.20524838 | 2020-04-10 22:54:07 | Berkshire, Massachusetts, US |
2020-04-10 | US | Massachusetts | Bristol | 25005 | 1086 | 23 | 0 | 1063 | 41.79228404 | -71.10872211 | 2020-04-10 22:54:07 | Bristol, Massachusetts, US |
2020-04-10 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-10 22:54:07 | Dukes and Nantucket,Massachusetts,US | |
2020-04-10 | US | Massachusetts | Essex | 25009 | 2670 | 50 | 0 | 2620 | 42.6687626 | -70.94687179 | 2020-04-10 22:54:07 | Essex, Massachusetts, US |
2020-04-10 | US | Massachusetts | Franklin | 25011 | 135 | 21 | 0 | 114 | 42.58119713 | -72.58602547 | 2020-04-10 22:54:07 | Franklin, Massachusetts, US |
2020-04-10 | US | Massachusetts | Hampden | 25013 | 1394 | 62 | 0 | 1332 | 42.13440424 | -72.63235561 | 2020-04-10 22:54:07 | Hampden, Massachusetts, US |
2020-04-10 | US | Massachusetts | Hampshire | 25015 | 194 | 3 | 0 | 191 | 42.33997957 | -72.65898478 | 2020-04-10 22:54:07 | Hampshire, Massachusetts, US |
2020-04-10 | US | Massachusetts | Middlesex | 25017 | 4447 | 80 | 0 | 4367 | 42.48607732 | -71.39049229 | 2020-04-10 22:54:07 | Middlesex, Massachusetts, US |
2020-04-10 | US | Massachusetts | Norfolk | 25021 | 2216 | 41 | 0 | 2175 | 42.16073095 | -71.20530408 | 2020-04-10 22:54:07 | Norfolk, Massachusetts, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;