Campaign Finance Data

shr...@tamu.edu

unread,

Oct 27, 2020, 2:32:28 PM10/27/20

to OpenSecrets Open Data

Hi,

I want to see political donations by individuals working for S&P 500 companies. I have the Campaign Finance data for the 2018 cycle. I am working with individual files. I am trying to match the company name, but I am unsure which field to use -- employer or orgname.

Moreover, there seem to be quite a few typos in the names. For example, Colgate Palmolive has the following variations in the dataset:

colgate polmolive
colgate palmoluve
colsate palmolive

Is there a firm-level unique ID that I can use to avoid missing out on correct names due to spelling errors?

I will appreciate your help on this.

Emanuele Caggiano

unread,

Mar 7, 2022, 11:46:08 AM3/7/22

to OpenSecrets Open Data

Same problem,

I follow the conversation

Rachel

unread,

Jun 28, 2024, 3:28:15 AM6/28/24

to OpenSecrets Open Data

Same problem, too

I follow the conversation

Kamron Eck

unread,

Jul 25, 2024, 4:42:58 PM7/25/24

to OpenSecrets Open Data

You have to use a string matching approach. Match based on a self-established probability that two strings are similar.

Reply all

Reply to author

Forward