violation_event

where activity_nr = 102814

✎ 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
81 81 102814 102814 01001 P Z 1984-06-14 280.0 1984-06-18 S   2011-10-14 16:48:14 EDT
82 82 102814 102814 01001 P I 1984-07-02 150.0 1984-06-18 S   2011-10-14 16:48:14 EDT
83 83 102814 102814 01002 P Z 1984-06-14 210.0 1984-06-18 S   2011-10-14 16:48:14 EDT
84 84 102814 102814 01004 P I 1984-08-10 200.0 1984-06-18 S   2011-10-14 16:48:14 EDT
85 85 102814 102814 01003 P Z 1984-06-14 490.0 1984-06-18 S   2011-10-14 16:48:14 EDT
86 86 102814 102814 01003 P I 1984-07-02 250.0 1984-06-18 S   2011-10-14 16:48:14 EDT
87 87 102814 102814 01004 P Z 1984-06-14 350.0 1984-06-18 S   2011-10-14 16:48:14 EDT
88 88 102814 102814 01002 P I 1984-07-02 150.0 1984-06-18 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])
);