[PLUS] How to Query SEC Litigation API and Save Results into Pandas Dataframe: Python

The SEC Litigation API Endpoint

The US Securities and Exchange Commission (SEC) hosts a public API that allows the general public to query information from EDGAR (not covered here) and also hosts an API for information related to litigation (lawsuits) filings. We are going to show you how to query their live litigation, RSS feed, which returns results in XML and format them into a Pandas Dataframe in Python. The official litigation release page is browsable; but only includes the Release Number, Date, and Respondents to filing. Using their RSS feed that returns XML, we will have these columns in our dataframe: Title (respondents), HTML Link, Description and Release Date. The will take our XML result from RSS feed, then convert to json and load the json dictionary to a dataframe. Once the data fits the Pandas Dataframe, it is very easy to save as a CSV file or to SQLite database. In our example, we will save the results to CSV.

Our example is a short 25 lines of code. In order to make our life easier, we will use an external library called xmltodict; Pandas, requests, and json python libraries. Of course, we comment every single line of code in order for your benefit and understanding. Resulting file should look like the below:

This is a premium post. Create Plus+ Account to view the live, working codebase for this article.

Notice: Information contained herein is not and should not be construed as an offer, solicitation, or recommendation to buy or sell securities. The information has been obtained from sources we believe to be reliable; however no guarantee is made or implied with respect to its accuracy, timeliness, or completeness. Author does not own the any crypto currency discussed. The information and content are subject to change without notice. CryptoDataDownload and its affiliates do not provide investment, tax, legal or accounting advice.

This material has been prepared for informational purposes only and is the opinion of the author, and is not intended to provide, and should not be relied on for, investment, tax, legal, accounting advice. You should consult your own investment, tax, legal and accounting advisors before engaging in any transaction. All content published by CryptoDataDownload is not an endorsement whatsoever. CryptoDataDownload was not compensated to submit this article. Please also visit our Privacy policy; disclaimer; and terms and conditions page for further information.

Latest Posts
Follow Us
Notify me of new content