crash_reports
2 rows where "datetime" is on date 2021-02-12, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date)
Case
number:
Date:
2021-02-12
Time:
16:47
Address:
330 LINWOOD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1, was parked outside house #330 on Linwood Avenue between the hours of 0800-1430hrs. When reporting party, Rielly Smolinsky returned to her vehicle (owned/registered to her father, Edward Smolinsky) after 1430hrs, MV1 had significant damage to its front driver side, over the tire area. The vehicle was not disabled and no injuries reported as it was unoccupied. At this time, no one has claimed responsibility for damaging MV1.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.357234
Longitude:
-71.2109682
Location:
Case
number:
Date:
2021-02-12
Time:
15:23
Address:
157 HERRICK RD
Speed
limit:
0
Violation
cited:
no
Narrative:
MV1 was parked off to the shoulder of the roadway inside the parking lot of the Adelaide. Operator of MV1 came out from getting his COVID-19 vaccine and saw his vehicle had suffered front end damage. Operator of MV1 canvassed the area yielding negative results for any vehicle that could have struck his vehicle. Operator of MV1 spoke with the staff from the Adelaide who informed him there are no cameras in the parking lot. Operator of MV1 wanted this hit and run documented.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3255677
Longitude:
-71.1910346
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);