id,cycle,transaction_namespace,transaction_id,transaction_type,filing_id,is_amendment,amount,date,contributor_name,contributor_ext_id,contributor_type,contributor_occupation,contributor_employer,contributor_gender,contributor_address,contributor_city,contributor_state,contributor_zipcode,contributor_category,organization_name,organization_ext_id,parent_organization_name,parent_organization_ext_id,recipient_name,recipient_ext_id,recipient_party,recipient_type,recipient_state,recipient_state_held,recipient_category,committee_name,committee_ext_id,committee_party,candidacy_status,district,district_held,seat,seat_held,seat_status,seat_result,contributor_type_manual,date_fixed,donor_name,is_ballot,new_contest_result,prop_raw,multi_props,support_prop_raw,prop_passed_raw
23737,2006,urn:nimsp:transaction,857ab887686461ad733d7a6a20ca9513,,,f,2000000.0,2006-08-24,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD,DALLAS,TX,75225,,,398,,,CALIFORNIA REPUBLICAN PARTY,1613,R,C,CA,,,CALIFORNIA REPUBLICAN PARTY,1613,R,f,,,,,,,I,2006-08-24,T. Boone Pickens Jr.,F,,,,,
23732,2006,urn:nimsp:transaction,98692abeb8f1a379aa33f07a1b75502d,,,f,972100.0,2006-05-26,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD,DALLAS,TX,75225,,,398,,,CALIFORNIA REPUBLICAN PARTY,1613,R,C,CA,,,CALIFORNIA REPUBLICAN PARTY,1613,R,f,,,,,,,I,2006-05-26,T. Boone Pickens Jr.,F,,,,,
41932,2005,urn:nimsp:transaction,de3eb81a848e85f21747913760373895,,,f,500000.0,2005-10-17,"PICKENS JR, T BOONE",,I,CHIEF EXECUTIVE OFFICER,BP CAPITAL,,8117 PRESTON ROAD STE 260,DALLAS,TX,75225,,,398,,,GOVERNOR SCHWARZENEGGERS CALIFORNIA RECOVERY TEAM,1714,I,C,CA,,,GOVERNOR SCHWARZENEGGERS CALIFORNIA RECOVERY TEAM,1714,I,f,,,,,,,I,2005-10-17,T. Boone Pickens Jr.,T,L,74,,T,F
23735,2008,urn:nimsp:transaction,ccdfe5f00b53ac697fb2401a6ff4eadc,,,f,100000.0,2008-04-15,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD STE 260,,TX,75225,,BP CAPITAL,398,,,CALIFORNIA VOTERS FIRST,3314,I,C,CA,,,CALIFORNIA VOTERS FIRST,3314,I,f,,,,,,,I,2008-04-15,T. Boone Pickens Jr.,T,W,11,,T,T
23736,2005,urn:nimsp:transaction,a7a822dafa19befec6b601a08f0854f8,,,f,50000.0,2005-05-19,"PICKENS JR, T BOONE",,I,CHIEF EXECUTIVE OFFICER,BP CAPITAL,,8117 PRESTON ROAD STE 260,DALLAS,TX,75225,,,398,,,GOVERNOR SCHWARZENEGGERS CALIFORNIA RECOVERY TEAM,1714,I,C,CA,,,GOVERNOR SCHWARZENEGGERS CALIFORNIA RECOVERY TEAM,1714,I,f,,,,,,,I,2005-05-19,T. Boone Pickens Jr.,T,L,74,,T,F
23734,2003,urn:nimsp:transaction,d2ddf35c91ef030bd6f2e2a272e86cf5,,,f,30000.0,2003-09-29,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD STE 260,DALLAS,TX,75225,,BP CAPITAL,398,,,ARNOLD SCHWARZENEGGERS TOTAL RECALL CMTE VOTE YES TO RECALL GRAY DAVIS,288,I,C,CA,,,ARNOLD SCHWARZENEGGERS TOTAL RECALL CMTE VOTE YES TO RECALL GRAY DAVIS,288,I,f,,,,,,,I,2003-09-29,T. Boone Pickens Jr.,T,W,Recall Gray Davis,F,T,T
23728,2006,urn:nimsp:transaction,a206680452d6669bc7723b34aacf966d,,,f,20000.0,2006-05-26,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD STE 260,DALLAS,TX,75225,,,398,,,"SCHWARZENEGGER, ARNOLD (COMMITTEE 2)",4450,R,P,CA,,,,,,t,,,state:governor,,,W,I,2006-05-26,T. Boone Pickens Jr.,F,W,,,,
41831,2004,urn:nimsp:transaction,a8081086b5bb634b88abcc34ce8d2016,,,f,20000.0,2004-12-01,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD STE 260,DALLAS,TX,75225,,,398,,,"SCHWARZENEGGER, ARNOLD",4450,R,P,CA,,,,,,f,,,state:governor,,,,I,2004-12-01,T. Boone Pickens Jr.,F,,,,,
23730,2006,urn:nimsp:transaction,b15ed42f78e86829a996f37ec055dcb3,,,f,13950.0,2006-05-26,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD,DALLAS,TX,75225,,,398,,,CALIFORNIA REPUBLICAN PARTY,1613,R,C,CA,,,CALIFORNIA REPUBLICAN PARTY,1613,R,f,,,,,,,I,2006-05-26,T. Boone Pickens Jr.,F,,,,,
23731,2006,urn:nimsp:transaction,db87872475be17deef7dfa13b87d12ce,,,f,13950.0,2006-05-26,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD,DALLAS,TX,75225,,,398,,,CALIFORNIA REPUBLICAN PARTY,1613,R,C,CA,,,CALIFORNIA REPUBLICAN PARTY,1613,R,f,,,,,,,I,2006-05-26,T. Boone Pickens Jr.,F,,,,,
26391,2008,urn:nimsp:transaction,289c35c6b329fa713ce0891a6a405e38,,,f,12500.0,2008-09-08,"PICKENS JR, T BOONE",,I,CHAIRMAN,BP CAPITAL,,8117 PRESTON RD STE 260,,TX,75225,,BP CAPITAL,398,,,CALIFORNIANS FOR HUMANE FARMS,3321,I,C,CA,,,CALIFORNIANS FOR HUMANE FARMS,3321,I,f,,,,,,,I,2008-09-08,T. Boone Pickens Jr.,T,W,2,,T,T
23729,2006,urn:nimsp:transaction,f77ac6d0d0c6d8ac0ea14dc37dac2d89,,,f,2300.0,2006-05-26,"PICKENS JR, T BOONE",,I,CEO,BP CAPITAL,,8117 PRESTON RD STE 260,DALLAS,TX,75225,,,398,,,"SCHWARZENEGGER, ARNOLD (COMMITTEE 2)",4450,R,P,CA,,,,,,t,,,state:governor,,,W,I,2006-05-26,T. Boone Pickens Jr.,F,W,,,,
23733,2002,urn:nimsp:transaction,4ed4192ced741f41b4630eedf88d6953,,,f,1000.0,2002-03-01,"PICKENS JR, T BOONE",,I,INVESTOR,SELF EMPLOYED,,8117 PRESTON RD,DALLAS,CA,95226,,,,,,"PENA, JOHN J",28147,R,P,CA,,,,,,t,CA-80,,state:lower,,,L,I,2002-03-01,T. Boone Pickens Jr.,F,L,,,,