Hi, my name is Ijaz Ahmad. I'm PhD student at the University of Georgia's Louise McBee Institute of Higher Education. I am seeking assistance with utilizing Education Lobbyists' expenditure data from 2004 to 2023 for my doctoral research. I am encountering two primary challenges that I hope you can help me address.
First, although I have downloaded bulk data, I don't know how to extract the required data from text files because I have no knowledge of Python or API development. Therefore, I want to use Education Industry Lobbying data from the following link:
Education Lobbying Profile • OpenSecrets
However, I was unable to locate the For-profit Education data under the link above. I have found the biennial for-profit education lobbying data on another page, given below, but I assume the nature of this data is different from the data given under the first hyperlink above.
For-profit Education Lobbying • OpenSecrets
Second, once I have compiled lobbying data for both for-profit and public/non-profit education industries, I intend to aggregate it at the state level to estimate lobbying expenditure across each state. Unfortunately, the state affiliations of lobbying organizations are not included in the OpenSecrets dataset.
Any advice would be highly appreciated.
Ijaz