violation_event

where activity_nr = 101477

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ activity_nr citation_id pen_fta hist_event hist_date hist_penalty hist_abate_date hist_vtype hist_insp_nr load_dt
37 37 101477 101477 01001 P I 1984-04-09 120.0 1984-03-21 S   2011-10-14 16:48:14 EDT
38 38 101477 101477 01001 P Z 1984-03-19 120.0 1984-03-21 S   2011-10-14 16:48:14 EDT 
CREATE TABLE "violation_event" (
"activity_nr" INTEGER,
  "citation_id" TEXT,
  "pen_fta" TEXT,
  "hist_event" TEXT,
  "hist_date" TEXT,
  "hist_penalty" REAL,
  "hist_abate_date" TEXT,
  "hist_vtype" TEXT,
  "hist_insp_nr" INTEGER,
  "load_dt" TEXT,
   FOREIGN KEY([activity_nr]) REFERENCES [violation]([activity_nr])
);