TPJ

Data Generation

These are the steps to get the tables from TPJ database. This assumes you are using DBeaver Community software and have a valid login to their server.

Contributors

Export this script as the INFTX table "contributors": SELECT Ctrib_ID,FullName,Surname,FirstName,Suffix,title,City,StateAbbr,ZipCode,Employer_ID,EMPLOYER,Occupation,InterestCode,OtherInterests FROM dbo.videalContributor_v2

Contributions

Get the last election cycle contributions, by exporting this script to a new table: SELECT DISTINCT IDNO,CTRIB_AMT,CONT_DATE,eYear,ctrib_ID,iFiler_ID FROM dbo.contribs WHERE eYear = 2020 AND ctrib_ID > 0