crash_reports
3 rows where "datetime" is on date 2021-02-23, dcc = "["Unknown"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-23
Time:
08:02
Address:
67 GREEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday February 23, 2021 at approx 0800 hours I responded to 67 Green Street for a report of a past hit/run. Owner of V1 stated vehicle was parked opposite 67 Green Street at approx. 1530 hours on Monday February 22, 2021. When owner came out this morning she noticed the damage to her driver side. It should be noted another vehicle was struck on drivers side at 58 Green Street. I canvassed the area for any video, video door bells I found in area are only limited to their porch. This hit/run possibly happened on February 22, 2021 between 1730 hours through 1900 hours.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3583722
Longitude:
-71.1982998
Location:
Case
number:
Date:
2021-02-23
Time:
08:53
Address:
58 GREEN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday February 23, 2021 at approx 0800 hours I responded to 58 Green Street for a report of a past hit/run. Owner of V1 stated vehicle was parked at 58 Green Street at approx. 1730 hours on Monday February 22, 2021. When owner came out this morning she noticed the damage to her driver side. She stated a neighbor observed the damage at approx. 1900 last night. It should be noted another vehicle was struck on drivers side at 67 Green Street. I canvassed the area for any video, video door bells I found in area are only limited to their porch. This hit/run possibly happened on February 22, 2021 between 1730 hours through 1900 hours.
Keywords:
Night
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.35838
Longitude:
-71.1977875
Location:
Case
number:
Date:
2021-02-23
Time:
12:05
Address:
2370 COMMONWEALTH AVE
Speed
limit:
5
Violation
cited:
no
Narrative:
MV #1 was parked and unoccupied at #2370 Commonwealth Ave., The Speedway Gas Station at the time of the crash. The operator of MV#2 stated that she was entering the Speedway Gas Station at the south entrance/exit and attempted to go around MV#1 when crash occurred. No injuries, no tows.
Keywords:
Crash, Speed
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.344635
Longitude:
-71.258199
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);