crash_reports

Table actions

2 rows where "datetime" is on date 2019-03-04 and hit_run = 1

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000233
Date:
2019-03-04
Time:
13:29
Address:
MYRTLE AVE & SEMINARY AVE
Speed limit:
25
Violation cited:
no
Narrative:
Vehicle 1 was parked on 03/04/2019 at 0030 hours and sometime between then and 1318 hours someone struck the drivers side rear quarter panel leaving heavy damage and yellow scrapes. No note was left and no witnesses have come forward. I canvassed the area with negative results. Vehicle was unoccupied.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3415055
Longitude:
-71.247541
Location:
Myrtle Ave & Seminary Ave, Newton, MA 02466, USA
Case number:
1900000242
Date:
2019-03-04
Time:
11:01
Address:
199 WELLS AVE
Speed limit:
10
Violation cited:
no
Narrative:
OPERATOR OF MV#1 PARKED HIS VEHICLE IN THE LOT OF #199 WELLS AVE. UPON HIS RETURN TO THE VEHICLE, HE NOTICED A DENT IN THE FRONT PASSENGER QUARTER PANEL CAUSED FROM AN UNKNOWN VEHICLE.
Keywords:
[]
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.2960396
Longitude:
-71.1988318
Location:
199 Wells Ave, Newton, MA 02459, 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);