daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

14 rows where "last_update" is on date 2020-11-17 and province_or_state = "Massachusetts" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Massachusetts · 14 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-11-16 US Massachusetts Barnstable 25001 2305 165 0 2117 41.72980578 -70.28854339 2020-11-17 05:25:54 Barnstable, Massachusetts, US
2020-11-16 US Massachusetts Berkshire 25003 1072 44 0 1020 42.37428441 -73.20524838 2020-11-17 05:25:54 Berkshire, Massachusetts, US
2020-11-16 US Massachusetts Bristol 25005 16146 683 0 15341 41.79228404 -71.10872211 2020-11-17 05:25:54 Bristol, Massachusetts, US
2020-11-16 US Massachusetts Dukes and Nantucket   433 2 0 431 41.40674725 -70.68763497 2020-11-17 05:25:54 Dukes and Nantucket, Massachusetts, US
2020-11-16 US Massachusetts Essex 25009 29209 1215 0 27817 42.6687626 -70.94687179 2020-11-17 05:25:54 Essex, Massachusetts, US
2020-11-16 US Massachusetts Franklin 25011 554 52 0 479 42.58119713 -72.58602547 2020-11-17 05:25:54 Franklin, Massachusetts, US
2020-11-16 US Massachusetts Hampden 25013 13101 731 0 12245 42.13440424 -72.63235561 2020-11-17 05:25:54 Hampden, Massachusetts, US
2020-11-16 US Massachusetts Hampshire 25015 1895 126 0 1735 42.33997957 -72.65898478 2020-11-17 05:25:54 Hampshire, Massachusetts, US
2020-11-16 US Massachusetts Middlesex 25017 38643 2052 0 36287 42.48607732 -71.39049229 2020-11-17 05:25:54 Middlesex, Massachusetts, US
2020-11-16 US Massachusetts Norfolk 25021 13917 990 0 12768 42.16073095 -71.20530408 2020-11-17 05:25:54 Norfolk, Massachusetts, US
2020-11-16 US Massachusetts Plymouth 25023 13031 735 0 12161 41.94070556 -70.80802823 2020-11-17 05:25:54 Plymouth, Massachusetts, US
2020-11-16 US Massachusetts Suffolk 25025 33106 1056 0 31897 42.3279514 -71.07850442 2020-11-17 05:25:54 Suffolk, Massachusetts, US
2020-11-16 US Massachusetts Unassigned 90025 6397 3 0 6390 42.6687626 0.0 2020-11-17 05:25:54 Unassigned, Massachusetts, US
2020-11-16 US Massachusetts Worcester 25027 20630 1021 0 19411 42.35026951 -71.90493363 2020-11-17 05:25:54 Worcester, Massachusetts, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;