Field

Definition

Type

Length

Source

UniqID

Corresponds to a particular report from SOPR

Varchar

36

SOPR

Lobbyist_raw

Raw value of lobbyist's name.

Varchar

50

SOPR

Lobbyist

Standardized lobbyist.

Varchar

50

CRP

Lobbyist_id

An ID assigned to each unique lobbyist.

Varchar

12

CRP

Year

The year.

Char

4

SOPR

OfficialPosition

Any previous government official position the individual lobbyist had

Varchar

100

SOPR

CID

An ID assigned to members of congress and federal candidates. It will have a value if the lobbyist is a former member of congress

Varchar

15

CRP

Formercongmem

Notes whether the lobbyist is a former member.

CRP