Identify bulk data

139 views
Skip to first unread message

Pier Luigi Giardino

unread,
Aug 16, 2024, 1:12:34 AM8/16/24
to OpenSecrets Open Data

Hi everyone,

I've downloaded bulk data for research on firm expenditures for lobbying and PACs. I need to extract three columns: year, firm name, and expenditures. However, I'm having trouble identifying which columns in the dataset correspond to the donation amounts, even after checking OpenSecrets.org's dictionary. I have the same issue with the "lobbying tables." Could you help me identify the correct columns?

Thanks for your time!

Cheers!

Screenshot 2024-08-16 at 07.11.30.png

Kamron Eck

unread,
Aug 17, 2024, 3:31:47 PM8/17/24
to OpenSecrets Open Data
Maybe this will help
OpenSecretsDataDefinitions.xlsx
Reply all
Reply to author
Forward
0 new messages