crash_reports

Table actions

2 rows where "datetime" is on date 2019-06-05 and hit_run = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)

Case number:
1900000579
Date:
2019-06-05
Time:
11:51
Address:
83 LEXINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
MV#1 was parked over night in front of #83 Lexington St. When operator returned to MV#1 today the front bumper had significant damage. No other information available at this time.
Keywords:
Night
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3573089
Longitude:
-71.2401589
Location:
83 Lexington St, Auburndale, MA 02466, USA
Case number:
1900000580
Date:
2019-06-05
Time:
13:42
Address:
18 BARNES RD
Speed limit:
25
Violation cited:
no
Narrative:
OWNER OF MV 1 STATED SHE HAD PARKED HER CAR AROUND 9 AM IN FRONT OF 18 BARNES ROAD. WHEN SHE LEFT HER HOUSE AROUND 1:45 PM, SHE NOTICED THE REAR DRIVERS SIDE OF HER VEHICLE WAS STRUCK BY ANOTHER UNKNOWN VEHICLE ( POSSIBLE LANDSCAPER TRUCK) CAUSING MODERATE DAMAGE. NO WITNESSES TO THE CRASH.
Keywords:
Crash, Moderate
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3567685
Longitude:
-71.1753701
Location:
18 Barnes Rd, Newton, MA 02458, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);