home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

4 rows where "datetime" is on date 2021-02-11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: intersection, speed_limit, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
2100000104
Date:
2021-02-11
Time:
09:02
Address:
CHESTNUT ST & COMMONWEALTH AVE
Speed limit:
30
Violation cited:
yes
Narrative:
Operator of Motor Vehicle #1 stated that she was stopped at the red light Northbound on Chestnut Street. Motor Vehicle #2 was traveling Westbound on Commonwealth Avenue a took a left turn onto Chestnut Street ( Southbound). Motor Vehicle #2 turned into Motor Vehicle #1 causing major damage to its drivers side front panel. Operator of motor vehicle #2 stated she took a left turn onto Chestnut Street from Commonwealth Avenue and her vehicle fishtailed causing her to strike motor vehicle #1. Medics arrived on scene and both parties signed medical refusal forms. Tody's towed motor vehicle #1. Motor vehicle #1 sustained major left side damage and motor Vehicle #2 sustained moderate front end damage. Operator of motor vehicle #2 was issued a Citation T1447521 for Ch. 89 S. 4A Marked Lanes and Ch. 90 S.11 License Not Accessible.
Keywords:
Citation, Moderate
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.336717
Longitude:
-71.223643
Location:
Commonwealth Avenue & Chestnut St, Newton, MA 02465, USA
Case number:
2100000105
Date:
2021-02-11
Time:
10:07
Address:
155 LEXINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV#1 stated that he was traveling south on Lexington St (#155) when he looked down for a second and his MV stuck MV#2. MV#2 was parked and unoccupied in front of #155 Lexington St at the time of the crash. No injuries, both MV's towed from the scene.
Keywords:
Crash
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3555308
Longitude:
-71.2423822
Location:
155 Lexington St, Auburndale, MA 02466, USA
Case number:
2100000106
Date:
2021-02-11
Time:
15:06
Address:
11 NEAL ST
Speed limit:
25
Violation cited:
no
Narrative:
The owner of MV#1 states he parked his vehicle on the street today at approx. 0900 hrs. When he came back to his vehicle at approx. 1500 hrs., he noticed damage to the front left area above his wheel. Based on the narrow roadway and the damage, he believes the unknown vehicle might have backed into his vehicle. I observed some white or light colored paint transference was left on his blue vehicle. The owner of MV#1 states that #4 Neal Street has a camera pointed nearby but the owners aren't home yet and he will notify us if anything useful is found on surveillance.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3301514
Longitude:
-71.2612732
Location:
11 Neal St, Newton, MA 02462, USA
Case number:
2100000107
Date:
2021-02-11
Time:
16:28
Address:
WATERTOWN ST & EDINBORO ST
Speed limit:
25
Violation cited:
no
Narrative:
Opr of MV1 stated she was traveling through the intersection from Walker Street to Edinboro Street. Opr of MV1 stated she had the green light, started to travel forward, and got struck by MV2 on Watertown Street. Opr of MV2 stated he was traveling westbound on Watertown Street. Opr of MV2 stated he could not see the light signal or MV1 at the intersection due to the glare from the sun. Opr of MV2 stated he attempted to brake once he realized he had the red light, but could not in time and struck MV1. Opr of MV1 suffered injuries and was transported to NWH. Both vehicles were towed by Tody's.
Keywords:
Glare, Solar, Walk
Dcc:
Glare
Report url:
report
Image url:
image
Latitude:
42.3546945
Longitude:
-71.2121576
Location:
Watertown St & Edinboro 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);
Powered by Datasette · Queries took 337.47ms