crash_reports

1 row where "date" is on date 2019-11-06 and speed_limit = 20

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900001146

Date:

2019-11-06

Time:

13:31

Address:

45 BEETHOVEN AVE

Speed limit:

20

Violation cited:

no

Narrative:

I SPOKE TO THE RP IDENTIFIED AS JUILANNA BERRY WHO STATED THAT SHE PARKED HER RENTAL VEHICLE ( FL REG KCSF74) ACROSS THE STREET FROM 45 BEETHOVEN AVE IN A LEGAL PARKING SPACE. WHEN SHE CAME BACK TO HER VEHICLE SHE OBSERVED FRESH DAMAGE TO THE DRIVERS SIDE MIRROR WHICH APPEARED TO HAVE GOTTEN STRUCK BY AN UNKNOWN VEHICLE WHO DID NOT LEAVE THEIR INFORMATION.

Keywords:

[]

Dcc:

[]

Report url:

report

Image url:

image

Latitude:

42.3289164

Longitude:

-71.2186953

Location:

45 Beethoven Ave, Waban, MA 02468, USA

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