home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

5 rows where "datetime" is on date 2020-01-22 and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, keywords, 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:
2000000082
Date:
2020-01-22
Time:
10:15
Address:
20 VINE ST
Speed limit:
30
Violation cited:
no
Narrative:
Owner of vehicle #1 stated her vehicle was parked in front of 20 Vine St. Vehicle #1 was unoccupied when it was struck by an unknown vehicle that left the scene.
Keywords:
[]
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3041129
Longitude:
-71.1749756
Location:
20 Vine St, Chestnut Hill, MA 02467, USA
Case number:
2000000083
Date:
2020-01-22
Time:
11:18
Address:
60 NEEDHAM STREET
Speed limit:
30
Violation cited:
no
Narrative:
MV#1 was stopped in traffic on Needham Street when it was struck by MV#2. -OpMv#1 stated he was stopped in traffic on Needham Street when it was struck by MV#2. -OpMv#2 stated she was traveling east on Needham Street and as she closed the distance between her and Mv#1 she misjudged the distance and collided with MV#1. -There were no vehicle towed from the scene and no injuries were reported at this time.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3152652
Longitude:
-71.2100632
Location:
60 Needham St, Newton Highlands, MA 02461, USA
Case number:
2000000084
Date:
2020-01-22
Time:
10:09
Address:
2040 COMMONWEALTH AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator of vehicle 1 stated she was parked in a parking spot when vehicle 2 started pulling headfirst in the spot on her drivers side. As vehicle 2 pulled in it made contact with vehicle 1 and operator 1 sounded her horn and tried to notify the other operator. Operator of vehicle 1 stated she got into a verbal argument with the other operator and then vehicle 2 backed out of the spot and parked on the opposite side of the parking lot. Operator of vehicle 1 walked over and again told the other operator she hit her but again a verbal argument started and operator of vehicle 2 walked away in to the market. I was able to find the operator of vehicle 2 inside of the store and she immediately denied any wrong doing and became argumentative when I tried to speak to her. Vehicle 2 had minor damage to its front passenger side consistent with scrapes on the drivers side of vehicle 1. Operator of vehicle 2 stated her damage was old damage and that it was not scrapes on vehicle 1 but dirt and walked over and tried to rub it off with her hand. I had to advise the operator of vehicle 2 several times to return to her vehicle. I advised both operators that I would document the incident with a report and sent them on their way with no further incident. Neither vehicle required a tow and neither operator reported any injuries.
Keywords:
Walk
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, USA
Case number:
2000000085
Date:
2020-01-22
Time:
14:01
Address:
101 EXETER ST
Speed limit:
25
Violation cited:
no
Narrative:
On 1/22/2020 at approx 1400 hrs while assigned to 497 I responded to 101 Exeter St for a report of a crash without injury. Upon arrival I met with Kyle FRAZIER who stated he had just pulled his work van to the side of the road when he was struck from behind by the operator of Ma Reg 777EK4 Jane FRANTZ. FRANTZ had left the area after providing FRAZIER with her info due to the minor nature of the crash. FRAZIER stated he is required to have a police report regardless of damage.
Keywords:
Crash
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3384243
Longitude:
-71.2296477
Location:
101 Exeter St, Newton, MA 02465, USA
Case number:
2000000086
Date:
2020-01-22
Time:
17:00
Address:
239 WATERTOWN ST
Speed limit:
0
Violation cited:
no
Narrative:
Owner of V1 stated between the hours of 3:00pm and 5:00pm her vehicle was hit by an unknown vehicle. V1 was parked in the parking lot of 239 Watertown Street. The unknown vehicle left the crash and did not leave any information. V1 sustained significant damage to the right rear side of the vehicle. No injuries and no tows.
Keywords:
Crash
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3616588
Longitude:
-71.1959663
Location:
239 Watertown St, Watertown, MA 02472, 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 487.265ms