Ah, again specifying which attribute we are giving a value to gives us problems- name became description and now the script doesn't work. No worries, we can just get rid of the attribute specifications and everything's dandy. :D Also made the comment at the start a little more simple.
no domain specified for survey_id, no comma before the next attribute definition, no conventional dropping of the table before we create it, added local keyword to load statement, removed commas from the table we are loading into, removed attribute specifications in inserts for speaker_team, fixed comments to the same format