violation

One row per OSHA standard cited on an inspection. Joins to inspection via activity_nr. Each row carries the cited standard, citation type (serious/willful/repeat/etc.), gravity, the current and initial penalty amounts, and the dates the violation was issued, contested, and reached final order. Failure-to-abate ("fta_*") columns track penalties added for not correcting earlier violations.
abate_complete
Date abatement was verified, or status code.
abate_date
Date by which the employer was required to abate the violation.
activity_nr
Foreign key to inspection.activity_nr.
citation_id
Citation identifier within the inspection (one inspection can have many citations).
contest_date
Date the employer formally contested the citation, if applicable.
current_penalty
Current penalty amount in dollars (post-settlement, after reductions or increases).
delete_flag
Flag indicating the citation was deleted or superseded.
emphasis
Whether the inspection was part of an emphasis program (NEP/SEP).
final_order_date
Date the citation became a final order.
fta_contest_date
Contest date for the failure-to-abate citation.
fta_final_order_date
Final-order date for the failure-to-abate citation.
fta_insp_nr
Inspection number of the prior inspection on which the failure-to-abate is based.
fta_issuance_date
Issuance date of the failure-to-abate citation.
fta_penalty
Failure-to-abate penalty amount in dollars.
gravity
Gravity-based penalty severity, an integer rating used by OSHA penalty-calculation guidelines.
hazcat
Hazard category code.
hazsub1
First hazardous-substance code associated with the violation.
hazsub2
Second hazardous-substance code.
hazsub3
Third hazardous-substance code.
hazsub4
Fourth hazardous-substance code.
hazsub5
Fifth hazardous-substance code.
initial_penalty
Initial penalty proposed when the citation was issued, in dollars.
issuance_date
Date the citation was issued.
load_dt
Timestamp when this row was loaded.
nr_exposed
Number of employees exposed to the cited hazard.
nr_instances
Number of instances of the violation cited.
rec
Recordkeeping flag.
standard
OSHA standard cited (e.g., "19260451" for scaffold standard 29 CFR 1926.451).
viol_type
Violation type — "S" (serious), "W" (willful), "R" (repeat), "O" (other-than-serious), "U" (unclassified), "FTA" (failure to abate), etc.

13,222,011 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ activity_nr citation_id delete_flag standard viol_type issuance_date abate_date abate_complete current_penalty initial_penalty contest_date final_order_date nr_instances nr_exposed rec gravity emphasis hazcat fta_insp_nr fta_issuance_date fta_penalty fta_contest_date fta_final_order_date hazsub1 hazsub2 hazsub3 hazsub4 hazsub5 load_dt
1 1 activity_nr citation_id delete_flag standard viol_type issuance_date abate_date abate_complete current_penalty initial_penalty contest_date final_order_date nr_instances nr_exposed rec gravity emphasis hazcat fta_insp_nr fta_issuance_date fta_penalty fta_contest_date fta_final_order_date hazsub1 hazsub2 hazsub3 hazsub4 hazsub5 load_dt
2 2 308258078 308258078 01002 X 19100038 B05 S 2005-05-23 00:00:00+00:00 2008-09-24 00:00:00+00:00 X     2005-06-15 00:00:00+00:00 2007-10-22 00:00:00+00:00 1 1180   5                         2011-10-14 16:45:21+00:00
3 3 308258086 308258086 01001A   19100106 B06 S 2005-05-24 00:00:00+00:00 2005-07-12 00:00:00+00:00 X 1000.0 1000.0     1 2 C 2                         2011-10-14 16:45:21+00:00
4 4 308258086 308258086 01001B   19100106 E09 III S 2005-05-24 00:00:00+00:00 2005-07-12 00:00:00+00:00 X         1 2                             2011-10-14 16:45:21+00:00
5 5 308258086 308258086 02001   19100038 B01 O 2005-05-24 00:00:00+00:00 2005-05-27 00:00:00+00:00 X         1 2 C                           2011-10-14 16:45:21+00:00
6 6 308258086 308258086 02002   19101200 E01 O 2005-05-24 00:00:00+00:00 2005-07-12 00:00:00+00:00 X         1 2 C                           2011-10-14 16:45:21+00:00
7 7 308258102 308258102 01001   19260100 A O 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 W   1500.0     1 1   10                         2011-10-14 16:45:21+00:00
8 8 308258102 308258102 01002   19260651 D O 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 W   1050.0     3 3   5                         2011-10-14 16:45:21+00:00
9 9 308258102 308258102 01003   19260651 H01 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 W 375.0 1500.0     1 1   10                         2011-10-14 16:45:21+00:00
10 10 308258102 308258102 01004   19260651 K02 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 W 375.0 1500.0     1 1   10                         2011-10-14 16:45:21+00:00
11 11 308258102 308258102 01005   19260652 A01 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 W 375.0 1500.0     1 1   10                         2011-10-14 16:45:21+00:00
12 12 308258102 308258102 01006   19261053 B01 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 W 375.0 1500.0     1 1   10                         2011-10-14 16:45:21+00:00
13 13 308258128 308258128 01001   19100304 F04 S 2005-04-20 00:00:00+00:00 2005-04-25 00:00:00+00:00 X 1500.0 1500.0     1 600 C 2                         2011-10-14 16:45:21+00:00
14 14 308258128 308258128 01002   19100305 B01 S 2005-04-20 00:00:00+00:00 2005-04-25 00:00:00+00:00 X 1500.0 1500.0     1 600 C 2                         2011-10-14 16:45:21+00:00
15 15 308258128 308258128 02001   19040029 B01 O 2005-04-20 00:00:00+00:00 2005-05-02 00:00:00+00:00 X         1     1                         2011-10-14 16:45:21+00:00
16 16 308258151 308258151 01001   19101030 C01 I S 2005-05-09 00:00:00+00:00 2005-06-24 00:00:00+00:00 X 300.0 600.0     1 6 C 2                         2011-10-14 16:45:21+00:00
17 17 308258151 308258151 01002   19101200 E01 S 2005-05-09 00:00:00+00:00 2005-06-24 00:00:00+00:00 X 300.0 600.0     1 6   2                         2011-10-14 16:45:21+00:00
18 18 308258151 308258151 02001A   19100037 B04 O 2005-05-09 00:00:00+00:00 2005-06-24 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
19 19 308258151 308258151 02001B   19100037 B05 O 2005-05-09 00:00:00+00:00 2005-06-24 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
20 20 308258151 308258151 02002   19100157 G01 O 2005-05-09 00:00:00+00:00 2005-06-24 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
21 21 308258177 308258177 01001   19260021 B02 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X 1750.0 3500.0     1 1   10                         2011-10-14 16:45:21+00:00
22 22 308258177 308258177 01002   19260651 J02 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X 1750.0 3500.0     1 1   10                         2011-10-14 16:45:21+00:00
23 23 308258177 308258177 01003   19260651 K02 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X 1750.0 3500.0     1 1   10                         2011-10-14 16:45:21+00:00
24 24 308258177 308258177 01004   19260652 A01 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X 1750.0 3500.0     1 1   10                         2011-10-14 16:45:21+00:00
25 25 308258177 308258177 01005   19261053 B01 S 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X 1750.0 3500.0     1 1   10                         2011-10-14 16:45:21+00:00
26 26 308258193 308258193 01001   19100244 A02 III S 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X 525.0 525.0     1 2   1                         2011-10-14 16:45:21+00:00
27 27 308258201 308258201 01001   19100023 C01 S 2005-05-17 00:00:00+00:00 2005-05-20 00:00:00+00:00 X 225.0 450.0     1 4   1                         2011-10-14 16:45:21+00:00
28 28 308258201 308258201 01002   19100151 C S 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X 225.0 450.0     1 4   1                         2011-10-14 16:45:21+00:00
29 29 308258201 308258201 02001   19100022 D01 O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4   1                         2011-10-14 16:45:21+00:00
30 30 308258201 308258201 02002   19100026 C02 VII O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4   1                         2011-10-14 16:45:21+00:00
31 31 308258201 308258201 02003   19100132 D01 O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4 C 1                         2011-10-14 16:45:21+00:00
32 32 308258201 308258201 02004   19100132 F04 O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4 C 1                         2011-10-14 16:45:21+00:00
33 33 308258201 308258201 02005   19100134 C02 I O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4   1                         2011-10-14 16:45:21+00:00
34 34 308258201 308258201 02006   19100151 B O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4 C 1                         2011-10-14 16:45:21+00:00
35 35 308258201 308258201 02007   19100178 L06 O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4   1                         2011-10-14 16:45:21+00:00
36 36 308258201 308258201 02008   19100304 F04 O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4   1                         2011-10-14 16:45:21+00:00
37 37 308258201 308258201 02009   19100334 A02 I O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4   1                         2011-10-14 16:45:21+00:00
38 38 308258201 308258201 02010   19101200 E01 I O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4 C 1                         2011-10-14 16:45:21+00:00
39 39 308258201 308258201 02011   19101200 H01 O 2005-05-18 00:00:00+00:00 2005-07-15 00:00:00+00:00 X         1 4 C 1                         2011-10-14 16:45:21+00:00
40 40 308258219 308258219 01001A   19101200 E02 O 2005-05-31 00:00:00+00:00 2005-07-18 00:00:00+00:00 X 175.0 350.0     1 1 R 3                         2011-10-14 16:45:21+00:00
41 41 308258219 308258219 01001B   19101200 H02 I O 2005-05-31 00:00:00+00:00 2005-07-18 00:00:00+00:00 X         1 1 R 3                         2011-10-14 16:45:21+00:00
42 42 317294510 317294510 01004   19100215 B09 S 2014-01-14 00:00:00+00:00 2014-02-28 00:00:00+00:00 X         1 4                             2014-05-01 01:02:04+00:00
43 43 308258250 308258250 01001   880004 S 2005-06-02 00:00:00+00:00 2005-06-08 00:00:00+00:00 X 1500.0 1500.0     1 1   10                         2011-10-14 16:45:21+00:00
44 44 308258250 308258250 01002   19260251 C04 II S 2005-06-02 00:00:00+00:00 2005-06-08 00:00:00+00:00 X 1050.0 1050.0     1 1   5                         2011-10-14 16:45:21+00:00
45 45 308258268 308258268 01001A   19100217 B06 I S 2005-05-09 00:00:00+00:00 2005-05-12 00:00:00+00:00 X 813.0 1625.0     1 3 C 3                         2011-10-14 16:45:21+00:00
46 46 308258268 308258268 01001B   19100217 E01 II S 2005-05-09 00:00:00+00:00 2005-05-12 00:00:00+00:00 X         1 3 C 3                         2011-10-14 16:45:21+00:00
47 47 308258268 308258268 01001C   19100217 F02 S 2005-05-09 00:00:00+00:00 2005-05-12 00:00:00+00:00 X         1 3 C 3                         2011-10-14 16:45:21+00:00
48 48 308258268 308258268 01002   19100303 B01 S 2005-05-09 00:00:00+00:00 2005-05-12 00:00:00+00:00 X 650.0 1300.0     1 10   2                         2011-10-14 16:45:21+00:00
49 49 308258268 308258268 02001   19100134 C01 O 2005-05-09 00:00:00+00:00 2005-06-03 00:00:00+00:00 X         1 200   1                         2011-10-14 16:45:21+00:00
50 50 308258268 308258268 02002   19100147 C06 II O 2005-05-09 00:00:00+00:00 2005-05-19 00:00:00+00:00 X         1 200   1                         2011-10-14 16:45:21+00:00
51 51 308258268 308258268 02003   19100179 J02 III O 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X         1 200 C 1                         2011-10-14 16:45:21+00:00
52 52 308258268 308258268 02004   19100179 J02 IV O 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X         1 200 C 1                         2011-10-14 16:45:21+00:00
53 53 308258276 308258276 01001   19100217 B07 VA S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X 1800.0 2500.0     1 3 A 3                         2011-10-14 16:45:21+00:00
54 54 308258276 308258276 01002A   19100217 C02 IA S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X 3650.0 5000.0     1 3 A 10                         2011-10-14 16:45:21+00:00
55 55 308258276 308258276 01002B   19100217 C02 IB S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X         1 3 A 10                         2011-10-14 16:45:21+00:00
56 56 308258276 308258276 01002C   19100217 C02 ID S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X         1 1 A 10                         2011-10-14 16:45:21+00:00
57 57 308258276 308258276 01003 X 19100217 C03 VIID S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X   2500.0     1 1 A 3                         2011-10-14 16:45:21+00:00
58 58 308258276 308258276 01004A   19100217 F02 S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X 1800.0 2500.0     1 1 A 3                         2011-10-14 16:45:21+00:00
59 59 308258276 308258276 01004B   19100217 F02 S 2005-05-25 00:00:00+00:00 2005-06-01 00:00:00+00:00 X         1 2 A 3                         2011-10-14 16:45:21+00:00
60 60 308258284 308258284 01001 X 880004 S 2005-05-23 00:00:00+00:00 2006-01-30 00:00:00+00:00 X   2500.0     1 20 C 3                         2011-10-14 16:45:21+00:00
61 61 308258284 308258284 01002   19100022 D02 S 2005-05-23 00:00:00+00:00 2005-08-14 00:00:00+00:00 X 2500.0 5000.0     1 2 C 10                         2011-10-14 16:45:21+00:00
62 62 308258318 308258318 01001   19100178 M05 III S 2005-06-22 00:00:00+00:00 2005-07-21 00:00:00+00:00 X 1000.0       1 30 R 3                         2011-10-14 16:45:21+00:00
63 63 308258326 308258326 01001   19100184 E02 I S 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X 1500.0 1500.0     1 1 R 10                         2011-10-14 16:45:21+00:00
64 64 308258326 308258326 02001A   19100132 D02 O 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X         1 2                             2011-10-14 16:45:21+00:00
65 65 308258326 308258326 02001B   19100132 F04 O 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X         1 2                             2011-10-14 16:45:21+00:00
66 66 308258326 308258326 02002   19100134 C01 O 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X         1 1                             2011-10-14 16:45:21+00:00
67 67 308258326 308258326 02003   19100147 C01 O 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X         1 2                             2011-10-14 16:45:21+00:00
68 68 308258326 308258326 02004   19100178 L01II O 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X         1 2                             2011-10-14 16:45:21+00:00
69 69 308258326 308258326 02005   19101200 E01 O 2005-05-17 00:00:00+00:00 2005-07-05 00:00:00+00:00 X         1 2                             2011-10-14 16:45:21+00:00
70 70 308258359 308258359 01001   19260453 B02 V O 2005-05-09 00:00:00+00:00 2005-05-13 00:00:00+00:00 X 3000.0 3000.0     1 2   10                         2011-10-14 16:45:21+00:00
71 71 308258375 308258375 01001   19260100 A S 2005-05-09 00:00:00+00:00 2005-05-12 00:00:00+00:00 X 270.0 450.0     1 1   1                         2011-10-14 16:45:21+00:00
72 72 308258375 308258375 02001   19101200 E01 O 2005-05-09 00:00:00+00:00 2005-06-20 00:00:00+00:00 X         1 1   1                         2011-10-14 16:45:21+00:00
73 73 308258375 308258375 02002   19101200 G08 O 2005-05-09 00:00:00+00:00 2005-06-20 00:00:00+00:00 X         1 1   1                         2011-10-14 16:45:21+00:00
74 74 308258375 308258375 02003   19101200 H01 O 2005-05-09 00:00:00+00:00 2005-06-20 00:00:00+00:00 X         1 1   1                         2011-10-14 16:45:21+00:00
75 75 308258391 308258391 01001   19261052 C01 S 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X 450.0 900.0     1 6   2                         2011-10-14 16:45:21+00:00
76 76 308258391 308258391 02001A   19101200 E01 O 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
77 77 308258391 308258391 02001B   19101200 G08 O 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
78 78 308258409 308258409 01001   19260100 A S 2005-05-18 00:00:00+00:00 2005-05-24 00:00:00+00:00 X 270.0 450.0     1 1   1                         2011-10-14 16:45:21+00:00
79 79 308258409 308258409 02001   19101200 E01 O 2005-05-18 00:00:00+00:00 2005-06-14 00:00:00+00:00 X         1 1   1                         2011-10-14 16:45:21+00:00
80 80 308258409 308258409 02002   19101200 G08 O 2005-05-18 00:00:00+00:00 2005-06-14 00:00:00+00:00 X         1 1   1                         2011-10-14 16:45:21+00:00
81 81 308258409 308258409 02003   19101200 H01 O 2005-05-18 00:00:00+00:00 2005-06-14 00:00:00+00:00 X         1 1   1                         2011-10-14 16:45:21+00:00
82 82 308258417 308258417 01001A   19260404 B01 I S 2005-06-01 00:00:00+00:00 2005-06-20 00:00:00+00:00 X 750.0 1500.0     1 6   10                         2011-10-14 16:45:21+00:00
83 83 308258417 308258417 01001B   19260405 G02 IV S 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X         1 6   3                         2011-10-14 16:45:21+00:00
84 84 308258417 308258417 01001C   19260405 A02 III S 2005-06-01 00:00:00+00:00 2005-06-06 00:00:00+00:00 X         1 6   3                         2011-10-14 16:45:21+00:00
85 85 308258417 308258417 01002   19260451 G01 VII S 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X 300.0 600.0     1 6   2                         2011-10-14 16:45:21+00:00
86 86 308258417 308258417 02001A   19101200 E01 O 2005-06-01 00:00:00+00:00 2005-07-19 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
87 87 308258417 308258417 02001B   19101200 G08 O 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
88 88 308258417 308258417 02001C   19101200 H O 2005-06-01 00:00:00+00:00 2005-07-19 00:00:00+00:00 X         1 6   1                         2011-10-14 16:45:21+00:00
89 89 308258425 308258425 01001   19260405 B01 S 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X 150.0 300.0     1 2   2                         2011-10-14 16:45:21+00:00
90 90 308258425 308258425 02001   19260403 H O 2005-06-01 00:00:00+00:00 2005-06-06 00:00:00+00:00 X         1 2   1                         2011-10-14 16:45:21+00:00
91 91 308258425 308258425 02002   19260405 A02 IIE O 2005-06-01 00:00:00+00:00 2005-06-13 00:00:00+00:00 X         1 2   1                         2011-10-14 16:45:21+00:00
92 92 308258433 308258433 01001   19100147 D04 I S 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X 750.0 750.0 2005-12-27 00:00:00+00:00   1 1   3     308261098 2005-10-31 00:00:00+00:00 750.0 2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
93 93 308258433 308258433 01002A   19100305 B01 S 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X 750.0 750.0 2005-12-27 00:00:00+00:00   1 1 C 3     308261098 2005-10-31 00:00:00+00:00 750.0 2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
94 94 308258433 308258433 01002B   19100305 B02 S 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   3 1 C 3     308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
95 95 308258433 308258433 01002C   19100305 E01 S 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   1 1 C 3     308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
96 96 308258433 308258433 01002D   19100305 G01 IIIA S 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   2 1 C 3     308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
97 97 308258433 308258433 02001   19100022 A02 O 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   1 1 C       308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
98 98 308258433 308258433 02002   19100132 D02 O 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   1 1 C       308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
99 99 308258433 308258433 02003   19100147 C01 O 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   1 1         308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00
100 100 308258433 308258433 02004   19100178 L06 O 2005-06-07 00:00:00+00:00 2005-07-25 00:00:00+00:00 X     2005-12-27 00:00:00+00:00   1 1         308261098 2005-10-31 00:00:00+00:00   2005-12-27 00:00:00+00:00 2006-08-29 00:00:00+00:00           2011-10-14 16:45:21+00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "violation" (
   [activity_nr] INTEGER REFERENCES [inspection]([activity_nr]),
   [citation_id] TEXT,
   [delete_flag] TEXT,
   [standard] TEXT,
   [viol_type] TEXT,
   [issuance_date] TEXT,
   [abate_date] TEXT,
   [abate_complete] TEXT,
   [current_penalty] FLOAT,
   [initial_penalty] FLOAT,
   [contest_date] TEXT,
   [final_order_date] TEXT,
   [nr_instances] INTEGER,
   [nr_exposed] INTEGER,
   [rec] TEXT,
   [gravity] INTEGER,
   [emphasis] TEXT,
   [hazcat] TEXT,
   [fta_insp_nr] INTEGER,
   [fta_issuance_date] TEXT,
   [fta_penalty] FLOAT,
   [fta_contest_date] TEXT,
   [fta_final_order_date] TEXT,
   [hazsub1] TEXT,
   [hazsub2] TEXT,
   [hazsub3] TEXT,
   [hazsub4] TEXT,
   [hazsub5] TEXT,
   [load_dt] TEXT
);