super_pacs_cont
499 rows where committee_type = "527 Political Organization"
This data as json, CSV (advanced)
Suggested facets: committee, state, occupation, contributor_type, contribution_type
Link | rowid ▼ | committee | committee_type | contribution_amount | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA COLORADO ACTION FUND (PHRMA COLORADO ACTION FUN | 527 Political Organization | 145000.0 | 2/16/23 | Pharmaceutical Research & Manufacturers Of America Better Government Committee | Washington | CO | 20004 | Other | Monetary (Itemized) | Contribution | ||
22 | 22 | PHARMACEUTICAL RESEARCH AND MANUFACTURERS OF AMERICA COLORADO ACTION FUND (PHRMA COLORADO ACTION FUN | 527 Political Organization | 50000.0 | 5/4/23 | Pharmaceutical Research & Manufacturers Of America Better Government Committee | Washington | CO | 20004 | Other | Monetary (Itemized) | Contribution | ||
25 | 25 | COLORADO BEVERAGE ASSOCIATION 527 | 527 Political Organization | 50000.0 | 7/11/23 | Colorado Beverage Association | Denver | CO | 80203 | Corporation | Monetary (Itemized) | |||
29 | 29 | COLORADO BEVERAGE ASSOCIATION 527 | 527 Political Organization | 41600.0 | 1/25/23 | Colorado Beverage Association | Denver | CO | 80203 | Corporation | Monetary (Itemized) | |||
46 | 46 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 20000.0 | 2/20/23 | Apc Resources, Llc | Golden | CO | 80103 | Business | Monetary (Itemized) | Campaign Contribution. | ||
47 | 47 | SENATE MAJORITY FUND | 527 Political Organization | 20000.0 | 8/14/23 | Anhueser Busch | St. Louis | MO | 63118 | Corporation | Monetary (Itemized) | |||
51 | 51 | CLCS ACTION 527 | 527 Political Organization | 20000.0 | 10/12/23 | Clcs Action | Denver | CO | 80203 | Corporation | Monetary (Itemized) | Monetary Contribution | ||
62 | 62 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 15000.0 | 3/2/23 | Kraemer North America | Castle Rock | CO | 80109 | Business | Monetary (Itemized) | Campaign Contribution. A Better Denver | ||
64 | 64 | SENATE MAJORITY FUND | 527 Political Organization | 15000.0 | 4/30/23 | At&T Services Inc | Centennial | CO | 80112 | Corporation | Monetary (Itemized) | |||
67 | 67 | ALL TOGETHER COLORADO | 527 Political Organization | 15000.0 | 8/8/23 | At&T | Englewood | CO | 80112 | Business | Monetary (Itemized) | |||
68 | 68 | COLORADO BEVERAGE ASSOCIATION 527 | 527 Political Organization | 15000.0 | 9/21/23 | Colorado Beverage Association | Denver | CO | 80203 | Corporation | Monetary (Itemized) | |||
75 | 75 | SENATE MAJORITY FUND | 527 Political Organization | 11600.0 | 9/30/23 | Cynthia Fisher | Palm Beach | FL | 33480 | Patientsrightsadvocate.Org | General Business | Individual | Monetary (Itemized) | |
77 | 77 | ALL TOGETHER COLORADO | 527 Political Organization | 10000.0 | 1/5/23 | Learning Network | Lakewood | CO | 80228 | Business | Monetary (Itemized) | |||
78 | 78 | ALL TOGETHER COLORADO | 527 Political Organization | 10000.0 | 1/5/23 | The Home Depot Inc. Political Action Committee | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
81 | 81 | SENATE MAJORITY FUND | 527 Political Organization | 10000.0 | 1/5/23 | Pharmaceutical Research And Manufacturers Of America Colorado Action Fund (Phrma Colorado Action Fun | Denver | CO | 80202 | 527 Political Organization | Monetary (Itemized) | |||
82 | 82 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 10000.0 | 1/7/23 | Pharmaceutical Research And Manufacturers Of America Colorado Action Fund (Phrma Colorado Action Fun | Denver | CO | 80202 | 527 Political Organization | Monetary (Itemized) | |||
83 | 83 | BETTER COLORADO ALLIANCE | 527 Political Organization | 10000.0 | 1/17/23 | The Home Depot Inc. Political Action Committee | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
85 | 85 | SENATE MAJORITY FUND | 527 Political Organization | 10000.0 | 2/22/23 | Pdc Energy | Denver | CO | 80203 | Corporation | Monetary (Itemized) | |||
86 | 86 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 10000.0 | 2/24/23 | T. Lowell Construction, Inc. | Castle Rock | CO | 80109 | Business | Monetary (Itemized) | Campaign Contribution. A Better Denver | ||
87 | 87 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 10000.0 | 3/27/23 | Ames Construction, Inc. | Burnsville | MN | 55306 | Business | Monetary (Itemized) | Campaign Contribution. | ||
91 | 91 | SENATE MAJORITY FUND | 527 Political Organization | 10000.0 | 8/14/23 | United Airlines | Houston | TX | 77210 | Corporation | Monetary (Itemized) | |||
92 | 92 | ALL TOGETHER COLORADO | 527 Political Organization | 10000.0 | 8/17/23 | United | Houston | TX | 77210 | Business | Monetary (Itemized) | |||
98 | 98 | SENATE MAJORITY FUND | 527 Political Organization | 10000.0 | 9/26/23 | Doordash | Denver | CO | 80221 | Corporation | Monetary (Itemized) | |||
109 | 109 | COLORADO WAY FORWARD | 527 Political Organization | 9320.03 | 7/20/23 | Better Colorado Alliance | Denver | CO | 80206 | 527 Political Organization | Monetary (Itemized) | |||
112 | 112 | SENATE MAJORITY FUND | 527 Political Organization | 8537.0 | 9/26/23 | Anheuser Busch | St. Louis | MO | 63118 | Corporation | Monetary (Itemized) | |||
119 | 119 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 7500.0 | 1/26/23 | Ameristar Casino Black Hawk | Las Vegas | NV | 89169 | Corporation | Monetary (Itemized) | |||
121 | 121 | SENATE MAJORITY FUND | 527 Political Organization | 7500.0 | 1/31/23 | Ameristar Casino Black Hawk | Black Hawk | CO | 80422 | Corporation | Monetary (Itemized) | |||
123 | 123 | SENATE MAJORITY FUND | 527 Political Organization | 7500.0 | 6/28/23 | Colorado Ski Country Usa Inc | Denver | CO | 80209 | Corporation | Monetary (Itemized) | |||
124 | 124 | BETTER COLORADO ALLIANCE | 527 Political Organization | 7500.0 | 7/17/23 | Visa | Austin | TX | 78720 | Business | Monetary (Itemized) | |||
131 | 131 | SENATE MAJORITY FUND | 527 Political Organization | 6289.58 | 6/28/23 | Restore Colorado Leadership Fund | Denver | CO | 80205 | 527 Political Organization | Monetary (Itemized) | Split Of Event Fee | ||
132 | 132 | GREAT SCHOOLS GREAT TEACHERS BV | 527 Political Organization | 6229.27 | 10/18/23 | Colorado Fund For Children And Public Education | Denver | CO | 80203 | Other | Monetary (Itemized) | Transfer From Terminated Political Committee To 527 | ||
136 | 136 | SENATE MAJORITY FUND | 527 Political Organization | 6000.0 | 9/4/23 | The Cigna Group Employee Pac | Philadelphia | PA | 19192 | Other | Monetary (Itemized) | Federal Pac | ||
156 | 156 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/5/23 | Learning Network Llc | Lakewood | CO | 80228 | Individual (Member of LLC: LEARNING NETWORK LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 5000.00) | |||
157 | 157 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/5/23 | American Fuel And Petrochemical Manufacturers | Washington | DC | 20036 | Other | Monetary (Itemized) | |||
158 | 158 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/5/23 | Lumen Technologies Service Group | Monroe | LA | 71211 | Corporation | Monetary (Itemized) | |||
159 | 159 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/5/23 | Brownstein Hyatt Farber Schreck, Llp | Denver | CO | 80202 | Corporation | Monetary (Itemized) | |||
160 | 160 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/5/23 | Colorado Health Care Association Pc | Denver | CO | 80203 | Political Committee | Monetary (Itemized) | |||
161 | 161 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/5/23 | Bnsf Railway Company | Fort Worth | TX | 76131 | Corporation | Monetary (Itemized) | |||
162 | 162 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/6/23 | Newmont | Denver | CO | 80237 | Corporation | Monetary (Itemized) | |||
163 | 163 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/7/23 | The Learning Network | Lakewood | CO | 80228 | Individual (Member of LLC: THE LEARNING NETWORK) | Monetary (Itemized) - LLC Contribution (Total Amount: 5000.00) | |||
164 | 164 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/7/23 | Kum & Go | Des Moines | IA | 50309 | Corporation | Monetary (Itemized) | |||
165 | 165 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/7/23 | Lumen Technologies Service Group | Monroe | LA | 71211 | Corporation | Monetary (Itemized) | |||
166 | 166 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/7/23 | Brownstein Hyatt Farber Shreck | Denver | CO | 80202 | Corporation | Monetary (Itemized) | |||
167 | 167 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/7/23 | Bnsf Railway Company | Fort Worth | TX | 76131 | Corporation | Monetary (Itemized) | |||
174 | 174 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/31/23 | Dentaquest Pac | Nashville | TN | 37203 | Other | Monetary (Itemized) | Federal Pac | ||
175 | 175 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 5000.0 | 1/31/23 | Occidental Petroleum Company | Houston | TX | 77252 | Corporation | Monetary (Itemized) | |||
176 | 176 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/31/23 | Beyond Broadway | Denver | CO | 80216 | Corporation | Monetary (Itemized) | |||
177 | 177 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 1/31/23 | Occidental Petroleum Corporation | Houston | TX | 77252 | Corporation | Monetary (Itemized) | |||
181 | 181 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 5000.0 | 2/20/23 | Transwest | Brighton | CO | 80601 | Business | Monetary (Itemized) | Campaign Contribution. | ||
183 | 183 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 5000.0 | 3/15/23 | Kraemer North America | Castle Rock | CO | 80109 | Business | Monetary (Itemized) | Campaign Contribution. | ||
184 | 184 | COLORADO CONSTRUCTION INDUSTRY COALITION - 527 (CCIC - 527) | 527 Political Organization | 5000.0 | 3/17/23 | Concrete Express, Inc. | Denver | CO | 80204 | Business | Monetary (Itemized) | Campaign Contribution. A Better Denver | ||
189 | 189 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 6/21/23 | Andrew Hamrick | Greenwood Village | CO | 80111 | Apartment Association Of Metro Denver | Attorney/Legal | Individual | Monetary (Itemized) | |
193 | 193 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 7/20/23 | Colorado Chamber Political Action Committee | Denver | CO | 80202 | Political Committee | Monetary (Itemized) | |||
200 | 200 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/14/23 | Bail Roundtable | Denver | CO | 80205 | Other | Monetary (Itemized) | |||
201 | 201 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/14/23 | Anthem Blue Cross Blue Shield | Cincinnati | OH | 45209 | Corporation | Monetary (Itemized) | |||
202 | 202 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/14/23 | Colorado Wyoming Petroleum Marketers Association Action Fund | Denver | CO | 80203 | 527 Political Organization | Monetary (Itemized) | |||
203 | 203 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/14/23 | Colorado Health Care Association Pc | Denver | CO | 80203 | Political Committee | Monetary (Itemized) | |||
204 | 204 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/14/23 | Colorado Bankers Association State Pac | Denver | CO | 80203 | Political Committee | Monetary (Itemized) | |||
208 | 208 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/22/23 | Civitas Resources Inc | Denver | CO | 80202 | Corporation | Monetary (Itemized) | |||
209 | 209 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 8/23/23 | Stanton Dodge | Castle Rock | CO | 80108 | Draftkings | Attorney/Legal | Individual | Monetary (Itemized) | |
210 | 210 | ALL TOGETHER COLORADO | 527 Political Organization | 5000.0 | 8/24/23 | Colorado Bankers Assoc | Denver | CO | 80203 | Other | Monetary (Itemized) | |||
215 | 215 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 9/4/23 | Colorado Hospitals Action Fund | Greenwood Village | CO | 80111 | Independent Expenditure Committee | Monetary (Itemized) | |||
216 | 216 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 9/4/23 | Corecivic | Nashville | TN | 37215 | Corporation | Monetary (Itemized) | |||
217 | 217 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 9/4/23 | Ready Colorado | Centennial | CO | 80202 | Other | Monetary (Itemized) | |||
230 | 230 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 9/26/23 | Core Electric Cooperative | Sedalia | CO | 80135 | Corporation | Monetary (Itemized) | |||
231 | 231 | SENATE MAJORITY FUND | 527 Political Organization | 5000.0 | 9/26/23 | Nextera Energy Constructions Llc | Juno Beach | FL | 33408 | Individual (Member of LLC: NEXTERA ENERGY CONSTRUCTIONS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 5000.00) | |||
236 | 236 | CLCS ACTION 527 | 527 Political Organization | 5000.0 | 12/21/22 | Clcs Action | Denver | CO | 80203 | Corporation | Monetary (Itemized) | Monetary Contribution - Unrestricted Grant | ||
241 | 241 | CLCS ACTION 527 | 527 Political Organization | 4000.0 | 8/10/23 | Clcs Action | Denver | CO | 80203 | Corporation | Monetary (Itemized) | Monetary Contribution | ||
255 | 255 | SENATE MAJORITY FUND | 527 Political Organization | 3000.0 | 1/5/23 | Pepsico | Purchase | NY | 10577 | Corporation | Monetary (Itemized) | |||
257 | 257 | SENATE MAJORITY FUND | 527 Political Organization | 3000.0 | 2/22/23 | Colorado Independents Pac (Coinpac) | Littleton | CO | 80123-4573 | Political Committee | Monetary (Itemized) | |||
264 | 264 | SENATE MAJORITY FUND | 527 Political Organization | 2625.0 | 8/22/23 | Colorado Independent Auto Dealers Political Committee | Littleton | CO | 80120 | Political Committee | Monetary (Itemized) | |||
277 | 277 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Ed And Shirley'S Inc. | Black Hawk | CO | 80422 | Corporation | Monetary (Itemized) | |||
278 | 278 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Healthier Colorado Political Committee | Denver | CO | 80202 | Political Committee | Monetary (Itemized) | |||
279 | 279 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | The Home Depot Inc. Political Action Committee | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
280 | 280 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Michael Best Strategies | Milwaukee | WI | 53202 | Corporation | Monetary (Itemized) | |||
281 | 281 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Realtor Small Donor Committee (Rsdc) | Englewood | CO | 80112 | Small Donor Committee | Monetary (Itemized) | |||
282 | 282 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Colorado Optometric Association Small Donor Committee | Denver | CO | 80202 | Small Donor Committee | Monetary (Itemized) | |||
283 | 283 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Colorado Cable Telecommunications | Denver | CO | 80209 | Other | Monetary (Itemized) | |||
284 | 284 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Corecivic | Nashville | TN | 37215 | Corporation | Monetary (Itemized) | |||
285 | 285 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Colorado Hospitals Action Fund | Greenwood Village | CO | 80111 | Independent Expenditure Committee | Monetary (Itemized) | |||
286 | 286 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Ready Colorado | Centennial | CO | 80202 | Other | Monetary (Itemized) | |||
287 | 287 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Colorado Dental Pac (Codpac) | Greenwood Village | CO | 80111 | Political Committee | Monetary (Itemized) | |||
288 | 288 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Fresenius Medical Care | Waltham | MA | 02451 | Corporation | Monetary (Itemized) | |||
289 | 289 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/5/23 | Freeport Minerals Corporation | Phoenix | AZ | 85004 | Corporation | Monetary (Itemized) | |||
290 | 290 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Colorado Hospitals Action Fund | Greenwood Village | CO | 80111 | Independent Expenditure Committee | Monetary (Itemized) | |||
291 | 291 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Ed & Shirley'S Inc | Black Hawk | CO | 80422 | Corporation | Monetary (Itemized) | |||
292 | 292 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Healthier Colorado Political Committee | Denver | CO | 80202 | Political Committee | Monetary (Itemized) | |||
293 | 293 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | The Home Depot Inc. Political Action Committee | Washington | DC | 20004 | Political Committee | Monetary (Itemized) | |||
294 | 294 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Michael Best Strategies | Waukeshaw | WI | 53188 | Corporation | Monetary (Itemized) | |||
295 | 295 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Colorado Dental Pac (Codpac) | Greenwood Village | CO | 80111 | Political Committee | Monetary (Itemized) | |||
296 | 296 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Realtor Small Donor Committee (Rsdc) | Englewood | CO | 80112 | Small Donor Committee | Monetary (Itemized) | |||
297 | 297 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Colorado Health Care Association | Glendale | CO | 80246 | Other | Monetary (Itemized) | |||
298 | 298 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Colorado Cable Telecommunications Association | Denver | CO | 80209 | Other | Monetary (Itemized) | |||
299 | 299 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Colorado Optometric Association Small Donor Committee | Denver | CO | 80202 | Small Donor Committee | Monetary (Itemized) | |||
300 | 300 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/7/23 | Ready Colorado | Centennial | CO | 80122 | Other | Monetary (Itemized) | |||
301 | 301 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/12/23 | Bail Roundtable | Denver | CO | 80205 | Other | Monetary (Itemized) | |||
302 | 302 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/16/23 | Jeff Weist | Denver | CO | 80209 | Colorado Cable Telecommunications Association | Office and Administrative Occupations | Individual | Monetary (Itemized) | |
303 | 303 | SENATE MAJORITY FUND | 527 Political Organization | 2500.0 | 1/16/23 | Jeff Weist | Denver | CO | 80209 | Colorado Cable Telecommunications Association | Other | Individual | Monetary (Itemized) | |
311 | 311 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/31/23 | Dcp Operating Company | Denver | CO | 80202 | Corporation | Monetary (Itemized) | |||
312 | 312 | RESTORE COLORADO LEADERSHIP FUND | 527 Political Organization | 2500.0 | 1/31/23 | Elevance Health Care | Cincinnati | OH | 45209 | Corporation | Monetary (Itemized) |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "super_pacs_cont" ( "committee" TEXT, "committee_type" TEXT, "contribution_amount" REAL, "contribution_date" TEXT, "contributor" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "employer" TEXT, "occupation" TEXT, "contributor_type" TEXT, "contribution_type" TEXT, "explanation" TEXT );