crash_reports
1 row where latitude = "42.3313535" and "retrieved" is on date 2022-05-23
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2022-05-15
Time:
10:22
Address:
35 PELHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 5/14/22 at 1628hrs, Mv#1 was parked unoccupied in front of 35 Pelham St. #1 owner Mr Brian Larsen was not home at this time. Mr Larsen's front door video system captured a grey possible Honda CRV, with passenger side front spare donut tire (no hubcap), with rear body damage above the passenger side rear tire veer to the right sideswiping his parked vehicle causing minor damage to his driver's side rear. Unknown vehicle fled continuing down Pelham St out of view. Video system was unable to zoom in on a plate number. A neighbor witness, Ms Claire Johannes, sitting on her front stoop across the street observed the collision and was also unable to see a plate number. Unknown vehicle operator was described by her as a W/F, with brown hair. Mr Larsen will email the footage to policerecords@newtonma.gov
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3313535
Longitude:
-71.1962327
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);