violation_event

✎ 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
1 1 16865 16865 01001 P I 1984-01-27 140.0 1984-02-11 S   2017-10-03 01:08:37 EDT
2 2 16865 16865 01001 P Z 1984-02-07 280.0 1984-02-11 S   2017-10-03 01:08:37 EDT
3 3 100586 100586 01001 P I 1984-02-10 40.0 1984-02-17 S   2011-10-14 16:48:14 EDT
4 4 100586 100586 01001 P Z 1984-02-29 80.0 1984-02-17 S   2011-10-14 16:48:14 EDT
5 5 100784 100784 01001 P I 1984-03-10 50.0 1984-03-09 S   2011-10-14 16:48:14 EDT
6 6 100784 100784 01001 P Z 1984-03-07 100.0 1984-03-09 S   2011-10-14 16:48:14 EDT
7 7 100818 100818 01002A P Z 1984-03-09 150.0 1984-03-12 S   2011-10-14 16:48:14 EDT
8 8 100818 100818 01001B P R 1984-09-17   1984-03-12 S   2011-10-14 16:48:14 EDT
9 9 100818 100818 01001B P Z 1984-03-09   1984-03-12 S   2011-10-14 16:48:14 EDT
10 10 100818 100818 01001A P R 1984-09-17 60.0 1984-03-12 S   2011-10-14 16:48:14 EDT
11 11 100818 100818 01001A P Z 1984-03-09 100.0 1984-03-12 S   2011-10-14 16:48:14 EDT
12 12 100818 100818 01002A P R 1984-09-17 115.0 1984-03-12 S   2011-10-14 16:48:14 EDT
13 13 100818 100818 01002C P R 1984-09-17   1984-03-12 S   2011-10-14 16:48:14 EDT
14 14 100818 100818 01002C P Z 1984-03-09   1984-03-12 S   2011-10-14 16:48:14 EDT
15 15 100818 100818 01002B P R 1984-09-17   1984-03-12 S   2011-10-14 16:48:14 EDT
16 16 100818 100818 01002B P Z 1984-03-09   1984-03-12 S   2011-10-14 16:48:14 EDT
17 17 100982 100982 01001 P I 1984-02-17 75.0 1984-02-22 S   2011-10-14 16:48:14 EDT
18 18 100982 100982 01003 P I 1984-02-17 200.0 1984-02-22 S   2011-10-14 16:48:14 EDT
19 19 100982 100982 01002 P Z 1984-03-07 250.0 1984-02-22 S   2011-10-14 16:48:14 EDT
20 20 100982 100982 01002 P I 1984-02-17 175.0 1984-02-22 S   2011-10-14 16:48:14 EDT
21 21 100982 100982 01001 P Z 1984-03-07 100.0 1984-02-22 S   2011-10-14 16:48:14 EDT
22 22 100982 100982 01003 P Z 1984-03-07 300.0 1984-02-22 S   2011-10-14 16:48:14 EDT
23 23 101246 101246 01003 P Z 1984-04-17 300.0 1984-04-25 S   2011-10-14 16:48:14 EDT
24 24 101246 101246 01003 P R 1984-07-12 125.0 1984-04-25 S   2011-10-14 16:48:14 EDT
25 25 101246 101246 02001 P Z 1984-04-17 1000.0 1984-04-20 R   2011-10-14 16:48:14 EDT
26 26 101246 101246 02001 P R 1984-07-12 500.0 1984-04-20 R   2011-10-14 16:48:14 EDT
27 27 101246 101246 02002 P Z 1984-04-17 500.0 1984-04-19 R   2011-10-14 16:48:14 EDT
28 28 101246 101246 02002 P R 1984-07-12 200.0 1984-04-19 R   2011-10-14 16:48:14 EDT
29 29 101246 101246 02003 P Z 1984-04-17 800.0 1984-04-19 R   2011-10-14 16:48:14 EDT
30 30 101246 101246 02003 P R 1984-07-12 300.0 1984-04-19 R   2011-10-14 16:48:14 EDT
31 31 101246 101246 01001 P Z 1984-04-17 300.0 1984-04-25 S   2011-10-14 16:48:14 EDT
32 32 101246 101246 01001 P R 1984-07-12 125.0 1984-04-25 S   2011-10-14 16:48:14 EDT
33 33 101246 101246 01002 P Z 1984-04-17 400.0 1984-04-20 S   2011-10-14 16:48:14 EDT
34 34 101246 101246 01002 P R 1984-07-12 150.0 1984-04-20 S   2011-10-14 16:48:14 EDT
35 35 101261 101261 01001 P R 1984-10-26 320.0 1984-03-09 R   2011-10-14 16:48:14 EDT
36 36 101261 101261 01001 P Z 1984-03-07 320.0 1984-03-09 R   2011-10-14 16:48:14 EDT
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
39 39 101519 101519 01001 P I 1984-04-18 180.0 1984-03-12 S   2011-10-14 16:48:14 EDT
40 40 101519 101519 01001 P Z 1984-03-09 180.0 1984-03-12 S   2011-10-14 16:48:14 EDT
41 41 101618 101618 01001 P Z 1984-03-22 100.0 1984-03-25 S   2011-10-14 16:48:14 EDT
42 42 101618 101618 01001 P J 1985-01-24 100.0 1984-03-25 S   2011-10-14 16:48:14 EDT
43 43 101634 101634 01001 P Z 1984-03-22 180.0 1984-03-28 S   2011-10-14 16:48:14 EDT
44 44 101634 101634 01001 P I 1984-04-09 125.0 1984-03-28 S   2011-10-14 16:48:14 EDT
45 45 101634 101634 02001 P Z 1984-03-22 280.0 1984-03-26 R   2011-10-14 16:48:14 EDT
46 46 101634 101634 02001 P I 1984-04-09 200.0 1984-03-26 R   2011-10-14 16:48:14 EDT
47 47 101675 101675 01001 P Z 1984-03-19 120.0 1984-03-21 S   2011-10-14 16:48:14 EDT
48 48 101675 101675 02001 P I 1984-04-10   1984-03-21 O   2011-10-14 16:48:14 EDT
49 49 101675 101675 02001 P Z 1984-03-19   1984-03-21 O   2011-10-14 16:48:14 EDT
50 50 101675 101675 01001 P I 1984-04-10 120.0 1984-03-21 S   2011-10-14 16:48:14 EDT
51 51 101683 101683 01003 P Z 1984-03-07 160.0 1984-03-09 S   2011-10-14 16:48:14 EDT
52 52 101683 101683 01002A P I 1984-03-27 150.0 1984-03-09 S   2011-10-14 16:48:14 EDT
53 53 101683 101683 01002A P Z 1984-03-07 200.0 1984-03-09 S   2011-10-14 16:48:14 EDT
54 54 101683 101683 01003 P I 1984-03-27 120.0 1984-03-09 S   2011-10-14 16:48:14 EDT
55 55 101774 101774 01001 P Z 1984-03-27 70.0 1984-03-29 S   2011-10-14 16:48:14 EDT
56 56 101774 101774 01001 P F 1984-11-05 35.0 1984-03-29 S   2011-10-14 16:48:14 EDT
57 57 101774 101774 02002 P F 1984-11-05   1984-04-02 O   2011-10-14 16:48:14 EDT
58 58 101774 101774 02001 P F 1984-11-05   1984-03-29 O   2011-10-14 16:48:14 EDT
59 59 101774 101774 02002 P Z 1984-03-27   1984-04-02 O   2011-10-14 16:48:14 EDT
60 60 101774 101774 02001 P Z 1984-03-27   1984-03-29 O   2011-10-14 16:48:14 EDT
61 61 101840 101840 01001 P Z 1984-03-27 210.0 1984-03-29 S   2011-10-14 16:48:14 EDT
62 62 101840 101840 01001 P R 1984-10-25 105.0 1984-03-29 S   2011-10-14 16:48:14 EDT
63 63 101840 101840 02001 P Z 1984-03-27 560.0 1984-03-29 R   2011-10-14 16:48:14 EDT
64 64 101840 101840 03001 P R 1984-10-25   1984-03-29 O   2011-10-14 16:48:14 EDT
65 65 101840 101840 02002 P Z 1984-03-27 1120.0 1984-03-29 R   2011-10-14 16:48:14 EDT
66 66 101840 101840 02002 P R 1984-10-25 560.0 1984-03-29 R   2011-10-14 16:48:14 EDT
67 67 101840 101840 03001 P Z 1984-03-27   1984-03-29 O   2011-10-14 16:48:14 EDT
68 68 101840 101840 02001 P R 1984-10-25 280.0 1984-03-29 R   2011-10-14 16:48:14 EDT
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
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
77 77 102681 102681 01001 P Z 1984-04-03 180.0 1984-04-05 R   2011-10-14 16:48:14 EDT
78 78 102681 102681 02001 P R 1984-09-24   1984-04-05 O   2011-10-14 16:48:14 EDT
79 79 102681 102681 02001 P Z 1984-04-03   1984-04-05 O   2011-10-14 16:48:14 EDT
80 80 102681 102681 01001 P R 1984-09-24 90.0 1984-04-05 R   2011-10-14 16:48:14 EDT
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
89 89 103937 103937 01001 P I 1984-02-10 125.0 1984-02-11 S   2011-10-14 16:48:14 EDT
90 90 103937 103937 01001 P Z 1984-02-16 250.0 1984-02-11 S   2011-10-14 16:48:14 EDT
91 91 103952 103952 01001 P I 1984-02-17 80.0 1984-02-21 S   2011-10-14 16:48:14 EDT
92 92 103952 103952 01001 P Z 1984-03-06 160.0 1984-02-21 S   2011-10-14 16:48:14 EDT
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

Next page

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])
);