crash_reports
3 rows where intersection = 0 and "retrieved" is on date 2021-08-31
This data as json, CSV (advanced)
Suggested facets: date, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-08-24
Time:
15:55
Address:
1200 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she parked her vehicle for approximately 10 minutes on Beacon Street while she attended the farmers market and when she returned she noticed the drivers side mirror was damaged. No witnesses to the accident and no information left on MV2.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3311133
Longitude:
-71.2132723
Location:
Case
number:
Date:
2021-08-24
Time:
16:25
Address:
265 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Was traveling around the rotary at Newton Corner in the left lane when he was struck from behind by the MV#2 at 265 Washington St. OPMV#1 Stated the other vehicle wouldn't let him in the lane and when he went through the light at the rotary the other vehicle sped through. Then when I breaked in traffic he hit the back of my car becoming irate. MV#2 Was traveling around the rotary at Newton Corner when he collided with MV#1 in traffic. OPMV#2 Stated he was cut off by MV#1 and when he went through the intersection MV#1 breaked and he had no time to stop before colliding with him.
Keywords:
[]
Dcc:
Followed too closely, Inattention, Unknown
Report
url:
Image
url:
Latitude:
42.3573777
Longitude:
-71.1847578
Location:
Case
number:
Date:
2021-08-27
Time:
10:45
Address:
68 GREEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Owner of MV1 states she parked her vehicle unoccupied in front of 68 Green Street and at some point during the day MV2 struck MV1 and fled the scene. No information on MV2. MV1 sustained damage to the back left corner panel.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3582351
Longitude:
-71.1981352
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);