Groups
Groups
Sign in
Groups
Groups
OpenSecrets Open Data
Conversations
About
Send feedback
Help
OpenSecrets Open Data
1–30 of 460
Mark all as read
Report group
0 selected
Sidse Marie Hornø
Jun 14
Top 100 Lobbying firms in Washington DC
I'm helping one of my uni-professors with some research on the top Lobbying firms i Washington (
unread,
Top 100 Lobbying firms in Washington DC
I'm helping one of my uni-professors with some research on the top Lobbying firms i Washington (
Jun 14
Helena Bach
Apr 29
Merging Lobbying Data with firm level data
I've noticed that several questions about how to merge this dataset with Compustat remain
unread,
Merging Lobbying Data with firm level data
I've noticed that several questions about how to merge this dataset with Compustat remain
Apr 29
Ayan Sule
Apr 17
Matching Firms to OpenSecrets Data
Hey, I'm trying to match Open Secrets Data to gvkey in Compustat. Any idea on how to do this?
unread,
Matching Firms to OpenSecrets Data
Hey, I'm trying to match Open Secrets Data to gvkey in Compustat. Any idea on how to do this?
Apr 17
Niels Selling
,
Kamron Eck
2
Apr 10
2024 Campaign Finance Data
Check out stanfords DIME data base On Monday, February 3, 2025 at 6:06:55 AM UTC-8 Niels Selling
unread,
2024 Campaign Finance Data
Check out stanfords DIME data base On Monday, February 3, 2025 at 6:06:55 AM UTC-8 Niels Selling
Apr 10
Helena Bach
Apr 10
Lobbying at the state level
Good afternoon, Is there a way to download Bulk data for State level lobbying? Thank you!
unread,
Lobbying at the state level
Good afternoon, Is there a way to download Bulk data for State level lobbying? Thank you!
Apr 10
Matthias Rémy
2
Mar 24
Closing date for 2025 filings at FEC bulk
Input from CRP staff especially appreciated, since I'm sure they confront this very question each
unread,
Closing date for 2025 filings at FEC bulk
Input from CRP staff especially appreciated, since I'm sure they confront this very question each
Mar 24
Frank Vasquez
Feb 28
500 Internal Server Error
Can't seem to login, anyone else getting this error? thanks! best, Frank Vasquez
unread,
500 Internal Server Error
Can't seem to login, anyone else getting this error? thanks! best, Frank Vasquez
Feb 28
Peter Sloniewsky
Feb 12
Can't get into data
I got an email that I was approved this morning but the login page says that I still need to be
unread,
Can't get into data
I got an email that I was approved this morning but the login page says that I still need to be
Feb 12
Don Lee
Feb 10
Firms' PAC contributions to recipients by party
Hello, I would like to obtain data on firms' PAC donations by party of recipients, very similar
unread,
Firms' PAC contributions to recipients by party
Hello, I would like to obtain data on firms' PAC donations by party of recipients, very similar
Feb 10
Helena Bach
, …
dau...@opensecrets.org
9
Jan 31
Income vs Expenses
Hello, Starting in 2008, reports are filed quarterly and you should use all four to get a total for
unread,
Income vs Expenses
Hello, Starting in 2008, reports are filed quarterly and you should use all four to get a total for
Jan 31
Hannah Kraus
,
dau...@opensecrets.org
2
12/30/24
Definitions of Catcode in Lobbying
Hello, The industry codes are available in the CRP_Categories.txt file you can find on the bulk data
unread,
Definitions of Catcode in Lobbying
Hello, The industry codes are available in the CRP_Categories.txt file you can find on the bulk data
12/30/24
Amol Raswan
12/6/24
Discrepancies in OpenSecrets Bulk Data vs website
Hi everyone, First, I want to thank the OpenSecrets team for the incredible work they do in promoting
unread,
Discrepancies in OpenSecrets Bulk Data vs website
Hi everyone, First, I want to thank the OpenSecrets team for the incredible work they do in promoting
12/6/24
Amol Raswan
10/3/24
Calculating firms' direct contributions
Hello everyone, I am trying to compute the "direct" contributions made by S&P500
unread,
Calculating firms' direct contributions
Hello everyone, I am trying to compute the "direct" contributions made by S&P500
10/3/24
Kamron Eck
9/12/24
Connecting Vote View (VoteView.org) to open secrets
This git hub page has a linking table that has open secrets ids and vote view ids https://github.com/
unread,
Connecting Vote View (VoteView.org) to open secrets
This git hub page has a linking table that has open secrets ids and vote view ids https://github.com/
9/12/24
Pier Luigi Giardino
,
Kamron Eck
2
8/17/24
Identify bulk data
Maybe this will help On Thursday, August 15, 2024 at 10:12:34 PM UTC-7 Pier Luigi Giardino wrote: Hi
unread,
Identify bulk data
Maybe this will help On Thursday, August 15, 2024 at 10:12:34 PM UTC-7 Pier Luigi Giardino wrote: Hi
8/17/24
Pier Luigi Giardino
,
Kamron Eck
2
8/15/24
Merging bulk data
Because there is no universal identifier that links the data perfectly, you will have to do some
unread,
Merging bulk data
Because there is no universal identifier that links the data perfectly, you will have to do some
8/15/24
shr...@tamu.edu
, …
Kamron Eck
4
7/25/24
Campaign Finance Data
You have to use a string matching approach. Match based on a self-established probability that two
unread,
Campaign Finance Data
You have to use a string matching approach. Match based on a self-established probability that two
7/25/24
Joel Gwynn
, …
Adam S
11
6/27/24
How to import
I've found this R code works well for dealing with the delimiters in the OpenSecrets data files.
unread,
How to import
I've found this R code works well for dealing with the delimiters in the OpenSecrets data files.
6/27/24
Swadip Bhattacharjee
6/24/24
Lobbying expenses Bulk data
Hi Scholars, I am a PhD student currently collecting data on lobbying expenses and contributions. I
unread,
Lobbying expenses Bulk data
Hi Scholars, I am a PhD student currently collecting data on lobbying expenses and contributions. I
6/24/24
PRITI BISWAS
5/31/24
Quarterly PAC contributions data
Hello, I am new to the CRP database and I have a query. In few research papers I have found that they
unread,
Quarterly PAC contributions data
Hello, I am new to the CRP database and I have a query. In few research papers I have found that they
5/31/24
Ijaz Ahmad
,
dau...@opensecrets.org
2
4/9/24
For-profit Education Lobbying Data
Hello Ijaz, The second link going to For-Profit Education specifically is accurate and does not
unread,
For-profit Education Lobbying Data
Hello Ijaz, The second link going to For-Profit Education specifically is accurate and does not
4/9/24
Ijaz Ahmad
,
HJ Rivera
2
4/2/24
How to login to an approved Bulk Data Account
Hi Ijaz, You can log in to your bulk data account here: https://www.opensecrets.org/bulk-data Regards
unread,
How to login to an approved Bulk Data Account
Hi Ijaz, You can log in to your bulk data account here: https://www.opensecrets.org/bulk-data Regards
4/2/24
Dan Vegeto
, …
ying zhao
8
1/14/24
Calculating corporate contribution totals
Dear all, I am also trying to merge the Campaign Finance Data (PAC data) with the Compustat data at
unread,
Calculating corporate contribution totals
Dear all, I am also trying to merge the Campaign Finance Data (PAC data) with the Compustat data at
1/14/24
Maisha Khan
, …
ying zhao
5
1/14/24
merging Campaign data and Compustat data
Dear all, I am also trying to merge the Campaign Finance Data (PAC data) with the Compustat data at
unread,
merging Campaign data and Compustat data
Dear all, I am also trying to merge the Campaign Finance Data (PAC data) with the Compustat data at
1/14/24
Linda
, …
ying zhao
7
1/14/24
Firms unique ids (CRP_id)
Dear all, I am also trying to merge the Campaign Finance Data (PAC data) with the Compustat data at
unread,
Firms unique ids (CRP_id)
Dear all, I am also trying to merge the Campaign Finance Data (PAC data) with the Compustat data at
1/14/24
Eden Zhang
, …
ying zhao
4
1/14/24
Question on the standardization of the data and the construction of ultorg variable
Dear all, I am also trying to merge the Campaign Finance Data with the Compustat data at the firm
unread,
Question on the standardization of the data and the construction of ultorg variable
Dear all, I am also trying to merge the Campaign Finance Data with the Compustat data at the firm
1/14/24
Andrea Catalina Fajardo
1/4/24
ISIC - UNSPSC
I have a quick question: Do you know whether there is a way to map the UNSPSC and ISIC codes for risk
unread,
ISIC - UNSPSC
I have a quick question: Do you know whether there is a way to map the UNSPSC and ISIC codes for risk
1/4/24
Yifan Liu
12/8/23
Personal Finance Data still maintained?
The Personal Finance Data (PFD Tables) was last updated in 2021. Is it still maintained?
unread,
Personal Finance Data still maintained?
The Personal Finance Data (PFD Tables) was last updated in 2021. Is it still maintained?
12/8/23
Chris Krenn
, …
str...@crp.org
4
10/26/23
CRP_IDs for 2022 candidates
Hi Alan, The bioguide_ids and FecCandids are now accurate. Skyler On Monday, March 13, 2023 at 8:08:
unread,
CRP_IDs for 2022 candidates
Hi Alan, The bioguide_ids and FecCandids are now accurate. Skyler On Monday, March 13, 2023 at 8:08:
10/26/23
Marco
,
str...@crp.org
2
10/26/23
Unitemized Contributions
Hi Marco - We do not currently include unitemized contributions in bulk data. The information about
unread,
Unitemized Contributions
Hi Marco - We do not currently include unitemized contributions in bulk data. The information about
10/26/23