violation_event

where activity_nr = 102574

✎ 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
71 71 102574 102574 01001 P Z 1984-04-03 240.0 1984-04-06 S   2011-10-14 16:48:14 EDT
72 72 102574 102574 01001 P I 1984-04-21 120.0 1984-04-06 S   2011-10-14 16:48:14 EDT
73 73 102574 102574 01003 P I 1984-04-21 120.0 1984-04-06 S   2011-10-14 16:48:14 EDT
74 74 102574 102574 01002 P I 1984-04-21 120.0 1984-04-06 S   2011-10-14 16:48:14 EDT
75 75 102574 102574 01003 P Z 1984-04-03 240.0 1984-04-06 S   2011-10-14 16:48:14 EDT
76 76 102574 102574 01002 P Z 1984-04-03 240.0 1984-04-06 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])
);