OpenSecrets Data Definition: Personal Finances Travel
|
Field |
Description |
Type |
Length |
Source |
|
ID |
unique id within a year |
text |
15 |
CRP |
|
Chamber |
Rerfers to chamber the report was filed with. "H" for House, "S" for Senate, "E" for executive branch |
text |
1 |
Report |
|
CID |
Unique id for each filer. |
text |
9 |
CRP |
|
CalendarYear |
Year covered by report |
text |
2 |
Report |
|
ReportType |
"Y" for annual report, "A" for amendment, "N" for nominee or candidate, "T" for termination |
text |
1 |
Report |
|
TravelSource |
Travel sponsor as reported by filer |
text |
100 |
Report |
|
Orgname |
standardized version of TravelSource |
text |
40 |
CRP |
|
Ultorg |
Standardized parent organization of TravelSource |
text |
40 |
CRP |
|
Realcode |
Industry code for TravelSource |
text |
5 |
CRP |
|
Source |
Source used to determine Realcode |
text |
5 |
CRP |
|
SourceCity |
City where TravelSource is located |
text |
50 |
Report |
|
SourceState |
State where TravelSource is located |
text |
2 |
Report |
|
BeginDate |
Date that trip began |
date |
Report |
|
|
BeginDateText |
Date that trip began |
text |
25 |
Report |
|
EndDate |
Date that trip ended |
date |
Report |
|
|
EndDateText |
Date that trip ended |
text |
25 |
Report |
|
DepartCity |
City from which filer traveled to start trip |
text |
50 |
Report |
|
DepartState |
State from which filer traveled to start trip |
text |
2 |
Report |
|
DestCity |
Destination city where trip took place |
text |
50 |
Report |
|
DestState |
Destination state where trip took place |
text |
2 |
Report |
|
PofRCity |
City that filer returned to at end of trip (point of return) |
text |
50 |
Report |
|
PofRState |
City that filer returned to at end of trip (point of return) |
text |
2 |
Report |
|
Descrip |
Description of trip and purpose |
text |
255 |
Report |
|
Lodging |
Was lodging provided by TravelSource during the trip |
text |
1 |
Report |
|
Food |
Was food provided by TravelSource during the trip |
text |
1 |
Report |
|
FamilyIncl |
Was travel for family members also provided by TravelSource |
text |
1 |
Report |
|
TimeAtOwnExpense |
Description of portions of trip that were paid for at filer's expense |
text |
25 |
Report |
|
Dupe |
"D" if record is duplicated in same or subsiquent reports and should not be calculated or displayed. |
text |
1 |
CRP |