violation_event

where activity_nr = 104000

✎ 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
93 93 104000 104000 01001 P Z 1984-02-21 40.0 1984-03-26 S   2011-10-14 16:48:14 EDT
94 94 104000 104000 01001 P I 1984-02-29 40.0 1984-03-26 S   2011-10-14 16:48:14 EDT
95 95 104000 104000 01002 P Z 1984-02-21 120.0 1984-03-26 S   2011-10-14 16:48:14 EDT
96 96 104000 104000 01002 P I 1984-02-29 120.0 1984-03-26 S   2011-10-14 16:48:14 EDT
97 97 104000 104000 02002 P Z 1984-02-21   1984-03-05 O   2011-10-14 16:48:14 EDT
98 98 104000 104000 02002 P I 1984-02-29   1984-03-05 O   2011-10-14 16:48:14 EDT
99 99 104000 104000 02003 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
100 100 104000 104000 02003 P I 1984-02-29   1984-03-26 O   2011-10-14 16:48:14 EDT
101 101 104000 104000 02004 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
102 102 104000 104000 02004 P I 1984-02-29   1984-03-26 O   2011-10-14 16:48:14 EDT
103 103 104000 104000 02005 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
104 104 104000 104000 02005 P I 1984-02-29   1984-03-26 O   2011-10-14 16:48:14 EDT
105 105 104000 104000 02006 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
106 106 104000 104000 02006 P I 1984-02-29   1984-03-26 O   2011-10-14 16:48:14 EDT
107 107 104000 104000 02007 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
108 108 104000 104000 02007 P I 1984-02-29   1984-03-26 O   2011-10-14 16:48:14 EDT
109 109 104000 104000 02008 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
110 110 104000 104000 02008 P I 1984-02-29   1984-03-26 O   2011-10-14 16:48:14 EDT
111 111 104000 104000 02009 P Z 1984-02-21   1984-03-26 O   2011-10-14 16:48:14 EDT
112 112 104000 104000 02009 P I 1984-02-29   1984-03-26 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])
);