daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14,215 rows where province_or_state = "Massachusetts" sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-15 | US | Massachusetts | Dukes and Nantucket | 0 | 1 | 0 | 0 | 41.40674725 | -70.68763497 | 2020-06-16 04:33:09 | Dukes and Nantucket, Massachusetts, US | |
2020-03-27 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 2020-03-27 22:14:55 | Dukes, Massachusetts, US |
2020-03-27 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 2020-03-27 22:14:55 | Nantucket, Massachusetts, US |
2020-03-26 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 2020-03-26 23:48:35 | Dukes, Massachusetts, US |
2020-03-26 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 2020-03-26 23:48:35 | Nantucket, Massachusetts, US |
2020-03-25 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 2020-03-25 23:33:19 | Dukes, Massachusetts, US |
2020-03-25 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 2020-03-25 23:33:19 | Nantucket, Massachusetts, US |
2020-03-24 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 2020-03-24 23:37:31 | Dukes, Massachusetts, US |
2020-03-24 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 2020-03-24 23:37:31 | Nantucket, Massachusetts, US |
2020-03-30 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 3/30/20 22:52 | Dukes, Massachusetts, US |
2020-03-30 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 3/30/20 22:52 | Nantucket, Massachusetts, US |
2020-03-23 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 2020-03-23 23:19:34 | Dukes, Massachusetts, US |
2020-03-23 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 2020-03-23 23:19:34 | Nantucket, Massachusetts, US |
2020-03-29 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 3/29/20 23:08 | Dukes, Massachusetts, US |
2020-03-29 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 3/29/20 23:08 | Nantucket, Massachusetts, US |
2020-03-22 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 3/22/20 23:45 | Dukes, Massachusetts, US |
2020-03-22 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 3/22/20 23:45 | Nantucket, Massachusetts, US |
2020-03-28 | US | Massachusetts | Dukes | 25007 | 0 | 0 | 0 | 0 | 41.40674725 | -70.68763497 | 3/28/20 23:05 | Dukes, Massachusetts, US |
2020-03-28 | US | Massachusetts | Nantucket | 25019 | 0 | 0 | 0 | 0 | 41.2942019 | -70.08774729 | 3/28/20 23:05 | Nantucket, Massachusetts, US |
2020-03-23 | US | Massachusetts | Dukes and Nantucket | 1 | 0 | 0 | 1 | 41.40674725 | -70.68763497 | 2020-03-23 23:19:34 | Dukes and Nantucket,Massachusetts,US | |
2020-03-22 | US | Massachusetts | Dukes and Nantucket | 1 | 0 | 0 | 1 | 42.6687626 | 0.0 | 3/22/20 23:45 | Dukes and Nantucket, Massachusetts, US | |
2020-03-24 | US | Massachusetts | Dukes and Nantucket | 2 | 0 | 0 | 2 | 41.40674725 | -70.68763497 | 2020-03-24 23:37:31 | Dukes and Nantucket,Massachusetts,US | |
2020-03-26 | US | Massachusetts | Dukes and Nantucket | 3 | 0 | 0 | 3 | 41.40674725 | -70.68763497 | 2020-03-26 23:48:35 | Dukes and Nantucket,Massachusetts,US | |
2020-03-25 | US | Massachusetts | Dukes and Nantucket | 3 | 0 | 0 | 3 | 41.40674725 | -70.68763497 | 2020-03-25 23:33:19 | Dukes and Nantucket,Massachusetts,US | |
2020-03-27 | US | Massachusetts | Dukes and Nantucket | 4 | 0 | 0 | 4 | 41.40674725 | -70.68763497 | 2020-03-27 22:14:55 | Dukes and Nantucket,Massachusetts,US | |
2020-03-22 | US | Massachusetts | Hampshire | 25015 | 4 | 0 | 0 | 4 | 42.33997957 | -72.65898478 | 3/22/20 23:45 | Hampshire, Massachusetts, US |
2020-03-23 | US | Massachusetts | Franklin | 25011 | 6 | 0 | 0 | 6 | 42.58119713 | -72.58602547 | 2020-03-23 23:19:34 | Franklin, Massachusetts, US |
2020-03-23 | US | Massachusetts | Hampshire | 25015 | 6 | 0 | 0 | 6 | 42.33997957 | -72.65898478 | 2020-03-23 23:19:34 | Hampshire, Massachusetts, US |
2020-03-22 | US | Massachusetts | Franklin | 25011 | 6 | 0 | 0 | 6 | 42.58119713 | -72.58602547 | 3/22/20 23:45 | Franklin, Massachusetts, US |
2020-03-22 | US | Massachusetts | Brockton | 6 | 0 | 0 | 6 | 42.6687626 | 0.0 | 3/22/20 23:45 | Brockton, Massachusetts, US | |
2020-03-24 | US | Massachusetts | Hampshire | 25015 | 8 | 0 | 0 | 8 | 42.33997957 | -72.65898478 | 2020-03-24 23:37:31 | Hampshire, Massachusetts, US |
2020-03-30 | US | Massachusetts | Dukes and Nantucket | 8 | 0 | 0 | 8 | 41.40674725 | -70.68763497 | 3/30/20 22:52 | Dukes and Nantucket,Massachusetts,US | |
2020-03-29 | US | Massachusetts | Dukes and Nantucket | 8 | 0 | 0 | 8 | 41.40674725 | -70.68763497 | 3/29/20 23:08 | Dukes and Nantucket,Massachusetts,US | |
2020-03-31 | US | Massachusetts | Dukes and Nantucket | 8 | 0 | 0 | 8 | 41.40674725 | -70.68763497 | 2020-03-31 23:43:56 | Dukes and Nantucket,Massachusetts,US | |
2020-03-28 | US | Massachusetts | Dukes and Nantucket | 8 | 0 | 0 | 8 | 41.40674725 | -70.68763497 | 3/28/20 23:05 | Dukes and Nantucket,Massachusetts,US | |
2020-03-24 | US | Massachusetts | Franklin | 25011 | 10 | 0 | 0 | 10 | 42.58119713 | -72.58602547 | 2020-03-24 23:37:31 | Franklin, Massachusetts, US |
2020-03-25 | US | Massachusetts | Hampshire | 25015 | 11 | 0 | 0 | 11 | 42.33997957 | -72.65898478 | 2020-03-25 23:33:19 | Hampshire, 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-03-22 | US | Massachusetts | Hampden | 25013 | 12 | 0 | 0 | 12 | 42.13440424 | -72.63235561 | 3/22/20 23:45 | Hampden, Massachusetts, US |
2020-04-02 | US | Massachusetts | Dukes and Nantucket | 12 | 0 | 0 | 12 | 41.40674725 | -70.68763497 | 4/2/20 23:25 | Dukes and Nantucket,Massachusetts,US | |
2020-06-15 | US | Massachusetts | Nantucket | 25019 | 13 | 0 | 0 | 13 | 41.2942019 | -70.08774729 | 2020-06-16 04:33:09 | Nantucket, Massachusetts, US |
2020-03-25 | US | Massachusetts | Franklin | 25011 | 14 | 0 | 0 | 14 | 42.58119713 | -72.58602547 | 2020-03-25 23:33:19 | Franklin, Massachusetts, US |
2020-03-23 | US | Massachusetts | Hampden | 25013 | 15 | 0 | 0 | 15 | 42.13440424 | -72.63235561 | 2020-03-23 23:19:34 | Hampden, Massachusetts, US |
2020-03-26 | US | Massachusetts | Franklin | 25011 | 16 | 1 | 0 | 15 | 42.58119713 | -72.58602547 | 2020-03-26 23:48:35 | Franklin, Massachusetts, US |
2020-04-04 | US | Massachusetts | Dukes and Nantucket | 16 | 0 | 0 | 16 | 41.40674725 | -70.68763497 | 4/4/20 23:34 | Dukes and Nantucket,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-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-03-26 | US | Massachusetts | Hampshire | 25015 | 17 | 0 | 0 | 17 | 42.33997957 | -72.65898478 | 2020-03-26 23:48:35 | Hampshire, 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-06 | US | Massachusetts | Dukes and Nantucket | 17 | 1 | 0 | 16 | 41.40674725 | -70.68763497 | 4/6/20 23:22 | Dukes and Nantucket,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-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-03-27 | US | Massachusetts | Hampshire | 25015 | 20 | 0 | 0 | 20 | 42.33997957 | -72.65898478 | 2020-03-27 22:14:55 | Hampshire, Massachusetts, US |
2020-04-15 | US | Massachusetts | Dukes and Nantucket | 20 | 1 | 0 | 19 | 41.40674725 | -70.68763497 | 2020-04-15 22:56:51 | Dukes and Nantucket, Massachusetts, US | |
2020-04-13 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-13 23:07:54 | Dukes and Nantucket, Massachusetts, US | |
2020-04-17 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-17 23:30:52 | Dukes and Nantucket, Massachusetts, US | |
2020-04-16 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-16 23:30:51 | Dukes and Nantucket, 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-11 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-11 22:45:33 | Dukes and Nantucket,Massachusetts,US | |
2020-04-12 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-12 23:18:00 | Dukes and Nantucket, Massachusetts, US | |
2020-04-14 | US | Massachusetts | Dukes and Nantucket | 21 | 1 | 0 | 20 | 41.40674725 | -70.68763497 | 2020-04-14 23:33:31 | Dukes and Nantucket, Massachusetts, US | |
2020-04-18 | US | Massachusetts | Dukes and Nantucket | 23 | 1 | 0 | 22 | 41.40674725 | -70.68763497 | 2020-04-18 22:32:47 | Dukes and Nantucket, Massachusetts, US | |
2020-04-21 | US | Massachusetts | Dukes and Nantucket | 23 | 1 | 0 | 22 | 41.40674725 | -70.68763497 | 2020-04-21 23:30:50 | Dukes and Nantucket, Massachusetts, US | |
2020-04-22 | US | Massachusetts | Dukes and Nantucket | 23 | 1 | 0 | 22 | 41.40674725 | -70.68763497 | 2020-04-22 23:30:53 | Dukes and Nantucket, Massachusetts, US | |
2020-04-19 | US | Massachusetts | Dukes and Nantucket | 23 | 1 | 0 | 22 | 41.40674725 | -70.68763497 | 2020-04-19 23:41:01 | Dukes and Nantucket, Massachusetts, US | |
2020-04-20 | US | Massachusetts | Dukes and Nantucket | 23 | 1 | 0 | 22 | 41.40674725 | -70.68763497 | 2020-04-20 23:36:47 | Dukes and Nantucket, Massachusetts, US | |
2020-04-23 | US | Massachusetts | Dukes and Nantucket | 23 | 1 | 0 | 22 | 41.40674725 | -70.68763497 | 2020-04-24 03:30:50 | Dukes and Nantucket, Massachusetts, US | |
2020-03-22 | US | Massachusetts | Berkshire | 25003 | 23 | 0 | 0 | 23 | 42.37428441 | -73.20524838 | 3/22/20 23:45 | Berkshire, Massachusetts, US |
2020-03-27 | US | Massachusetts | Franklin | 25011 | 24 | 2 | 0 | 22 | 42.58119713 | -72.58602547 | 2020-03-27 22:14:55 | Franklin, Massachusetts, US |
2020-04-24 | US | Massachusetts | Dukes and Nantucket | 24 | 1 | 0 | 23 | 41.40674725 | -70.68763497 | 2020-04-25 06:30:53 | Dukes and Nantucket, Massachusetts, US | |
2020-03-24 | US | Massachusetts | Hampden | 25013 | 24 | 0 | 0 | 24 | 42.13440424 | -72.63235561 | 2020-03-24 23:37:31 | Hampden, Massachusetts, US |
2020-03-22 | US | Massachusetts | Barnstable | 25001 | 24 | 0 | 0 | 24 | 41.72980578 | -70.28854339 | 3/22/20 23:45 | Barnstable, Massachusetts, US |
2020-03-22 | US | Massachusetts | Bristol | 25005 | 24 | 0 | 0 | 24 | 41.79228404 | -71.10872211 | 3/22/20 23:45 | Bristol, Massachusetts, US |
2020-03-22 | US | Massachusetts | Unassigned | 24 | 3 | 0 | 21 | 0.0 | 0.0 | 3/22/20 23:45 | Unassigned, Massachusetts, US | |
2020-04-25 | US | Massachusetts | Dukes and Nantucket | 24 | 1 | 0 | 23 | 41.40674725 | -70.68763497 | 2020-04-26 02:30:51 | Dukes and Nantucket, Massachusetts, US | |
2020-03-23 | US | Massachusetts | Bristol | 25005 | 25 | 0 | 0 | 25 | 41.79228404 | -71.10872211 | 2020-03-23 23:19:34 | Bristol, Massachusetts, US |
2020-03-22 | US | Massachusetts | Plymouth | 25023 | 25 | 0 | 0 | 25 | 41.94070556 | -70.80802823 | 3/22/20 23:45 | Plymouth, Massachusetts, US |
2020-04-27 | US | Massachusetts | Dukes and Nantucket | 25 | 1 | 0 | 24 | 41.40674725 | -70.68763497 | 2020-04-28 02:30:51 | Dukes and Nantucket, Massachusetts, US | |
2020-04-26 | US | Massachusetts | Dukes and Nantucket | 25 | 1 | 0 | 24 | 41.40674725 | -70.68763497 | 2020-04-27 02:30:52 | Dukes and Nantucket, Massachusetts, US | |
2020-04-28 | US | Massachusetts | Dukes and Nantucket | 26 | 1 | 0 | 25 | 41.40674725 | -70.68763497 | 2020-04-29 02:32:29 | Dukes and Nantucket, Massachusetts, US | |
2020-03-23 | US | Massachusetts | Berkshire | 25003 | 26 | 0 | 0 | 26 | 42.37428441 | -73.20524838 | 2020-03-23 23:19:34 | Berkshire, Massachusetts, US |
2020-04-29 | US | Massachusetts | Dukes and Nantucket | 27 | 1 | 0 | 26 | 41.40674725 | -70.68763497 | 2020-04-30 02:32:27 | Dukes and Nantucket, Massachusetts, US | |
2020-04-30 | US | Massachusetts | Dukes and Nantucket | 28 | 1 | 0 | 27 | 41.40674725 | -70.68763497 | 2020-05-01 02:32:28 | Dukes and Nantucket, Massachusetts, US | |
2020-05-01 | US | Massachusetts | Dukes and Nantucket | 29 | 1 | 0 | 28 | 41.40674725 | -70.68763497 | 2020-05-02 02:32:27 | Dukes and Nantucket, Massachusetts, US | |
2020-05-02 | US | Massachusetts | Dukes and Nantucket | 29 | 1 | 0 | 28 | 41.40674725 | -70.68763497 | 2020-05-03 02:32:28 | Dukes and Nantucket, Massachusetts, US | |
2020-03-23 | US | Massachusetts | Barnstable | 25001 | 30 | 0 | 0 | 30 | 41.72980578 | -70.28854339 | 2020-03-23 23:19:34 | Barnstable, Massachusetts, US |
2020-03-28 | US | Massachusetts | Hampshire | 25015 | 30 | 0 | 0 | 30 | 42.33997957 | -72.65898478 | 3/28/20 23:05 | Hampshire, Massachusetts, US |
2020-03-24 | US | Massachusetts | Bristol | 25005 | 31 | 0 | 0 | 31 | 41.79228404 | -71.10872211 | 2020-03-24 23:37:31 | Bristol, Massachusetts, US |
2020-05-05 | US | Massachusetts | Dukes and Nantucket | 32 | 1 | 0 | 31 | 41.40674725 | -70.68763497 | 2020-05-06 02:32:31 | Dukes and Nantucket, Massachusetts, US | |
2020-03-23 | US | Massachusetts | Plymouth | 25023 | 32 | 0 | 0 | 32 | 41.94070556 | -70.80802823 | 2020-03-23 23:19:34 | Plymouth, Massachusetts, US |
2020-05-03 | US | Massachusetts | Dukes and Nantucket | 32 | 1 | 0 | 31 | 41.40674725 | -70.68763497 | 2020-05-04 02:32:28 | Dukes and Nantucket, Massachusetts, US | |
2020-05-04 | US | Massachusetts | Dukes and Nantucket | 32 | 1 | 0 | 31 | 41.40674725 | -70.68763497 | 2020-05-05 02:32:34 | Dukes and Nantucket, Massachusetts, US | |
2020-05-08 | US | Massachusetts | Dukes and Nantucket | 33 | 1 | 0 | 32 | 41.40674725 | -70.68763497 | 2020-05-09 02:32:35 | Dukes and Nantucket, Massachusetts, US | |
2020-05-07 | US | Massachusetts | Dukes and Nantucket | 33 | 1 | 0 | 32 | 41.40674725 | -70.68763497 | 2020-05-08 02:32:32 | Dukes and Nantucket, Massachusetts, US | |
2020-05-06 | US | Massachusetts | Dukes and Nantucket | 34 | 1 | 0 | 33 | 41.40674725 | -70.68763497 | 2020-05-07 02:32:28 | Dukes and Nantucket, Massachusetts, US | |
2020-05-09 | US | Massachusetts | Dukes and Nantucket | 34 | 1 | 0 | 33 | 41.40674725 | -70.68763497 | 2020-05-10 02:32:30 | Dukes and Nantucket, Massachusetts, US | |
2020-05-12 | US | Massachusetts | Dukes and Nantucket | 35 | 1 | 0 | 34 | 41.40674725 | -70.68763497 | 2020-05-13 03:32:26 | Dukes and Nantucket, Massachusetts, US | |
2020-05-11 | US | Massachusetts | Dukes and Nantucket | 35 | 1 | 0 | 34 | 41.40674725 | -70.68763497 | 2020-05-12 03:32:27 | Dukes and Nantucket, Massachusetts, US | |
2020-05-10 | US | Massachusetts | Dukes and Nantucket | 35 | 1 | 0 | 34 | 41.40674725 | -70.68763497 | 2020-05-11 02:32:30 | Dukes and Nantucket, Massachusetts, US | |
2020-05-13 | US | Massachusetts | Dukes and Nantucket | 35 | 1 | 0 | 34 | 41.40674725 | -70.68763497 | 2020-05-14 03:32:28 | Dukes and Nantucket, Massachusetts, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;