crash_reports
3 rows where date = "2021-06-23", "retrieved" is on date 2021-07-04 and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-23
Time:
07:23
Address:
228 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mr. David DeVito, the owner of vehicle#1 stated that he heard a crash at approximately 1030 last night, but wasn't aware his car was struck until this morning. I then viewed the damage and observed fresh damage to the driver side rear quarter panel and side of Mr. DeVito's vehicle. The vehicle was parked in front of the residence at 228 California Street. There are no witnesses to the crash or description of the other vehicle involved at this time.
Keywords:
Crash, Night
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3646353
Longitude:
-71.1975345
Location:
Case
number:
Date:
2021-06-23
Time:
08:47
Address:
12 MYRTLE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Motor vehicle 1 (MV1) was traveling northbound on Myrtle Street when it crashed into a low hanging City of Newton tree in front of 12 Myrtle Street. As a result of the crash the tree completely uprooted and ripped out the telephone/internet services to 10 and 12 Myrtle Street, as well as 1560 and 1554 Washington Street. MV1 sustained moderate front/top passengers side damage. The City of Newton Forestry division was able to respond and remove the downed tree. I took five pictures of the damage to City property and submitted them to the IT bureau.
Keywords:
Crash, Moderate, Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.344429
Longitude:
-71.2341087
Location:
Case
number:
Date:
2021-06-23
Time:
11:28
Address:
2090 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 states that she was traveling east on Commonwealth Ave approaching Lexington St in the left hand lane when MV#2 entered her travel lane and crash occurred. The operator of MV#2 states that she was also traveling east on Commonwealth Ave approaching Lexington St in the right hand lane, but had signaled that she was about to enter the left hand lane when crash occurred with MV#1. Both MV's sustained minor damaged, no tows and no injuries.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3477526
Longitude:
-71.2473518
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);