violation_event

where activity_nr = 102244

✎ 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
69 69 102244 102244 01002 P I 1984-05-31   1984-05-18 O   2011-10-14 16:48:14 EDT
70 70 102244 102244 01002 P Z 1984-05-16   1984-05-18 O   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])
);