Additional Notes
0 / 100
Column HeaderRequiredData typeDescriptionExample
id Integer Unique Id for the record in the database. Do not assign this when uploading 100
month Integer Month the record was submitted in. No leading zeros 1 or 12
day Integer Day of the month. No leading zeros 1 or 30
year Integer Submission year, in format "yyyy" 2010
icpsr Integer Unique id for the member of congress. Please see: link 10
mc_name varchar Full name of the member of congress. In format <last name, first name> Washington, George
agency varchar Full name of the agency contacted. If the agency is already in our database, please match. Armed Forces Retirement Home
log_description varchar Description logged by the agency in the contact record Taxes
multimember Integer Flag for multiple members of Congress. 0 = False, 1 = True 0