crash_reports
2 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2021-07-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (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:
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);