crash_reports

Table actions

1 row where latitude = "42.3563988" and "retrieved" is on date 2022-05-23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

Case number:
22000412
Date:
2022-05-16
Time:
20:26
Address:
131 CRAFTS ST
Speed limit:
30
Violation cited:
no
Narrative:
MV 1 was traveling southbound on Craft St when he rear ended MV 2. MV 1 sustained major front end damage and the front air bag was deployed. MV 1 was towed by Tody's due to it being disabled. The operator and owner of MV 1, Mr. Alan Green, sustained a head and neck injury and was transported to Newton Wellesley Hospital by Fallon medics. MV 2 was parked in front of 131 Craft St with its hazards on delivering food, when MV 1 rear ended him. MV 2 sustained major rear end damage and was towed by Tody's due to it being disabled. The operator and passenger of MV 2 sustained neck injuries and were transported to Newton Wellesley by Fallon medics. MV 3 was legally parked and unoccupied in front of MV 2 when MV 1 rear ended MV 2 and subsequently rear ended MV 3. MV 3 sustained minor damage to the rear end. A crash report number was left for the uninvolved owner, Ms. Janet Goff, of MV 3.
Keywords:
Crash, Hospital
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3563988
Longitude:
-71.2042851
Location:
131 Crafts St, Newton, MA 02460, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "crash_reports" (
   [case_number] TEXT PRIMARY KEY,
   [datetime] TEXT,
   [date] TEXT,
   [time] TEXT,
   [address] INTEGER,
   [street1] TEXT,
   [street2] TEXT,
   [intersection] INTEGER,
   [speed_limit] INTEGER,
   [hit_run] INTEGER,
   [violation_cited] INTEGER,
   [narrative] TEXT,
   [keywords] TEXT,
   [dcc] TEXT,
   [dcc_code] TEXT,
   [report_url] TEXT,
   [image_url] TEXT
, [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);