It looks like EDGAR has a rest API and a full text search as well
SEC has the Edgar database where you can lookup any company and access there different SEC forms, but you still need to know which forms to look for the information in. For example, the 10k of one company had the ownership informing of top shareholders, but I wasn’t able to find that info in the 10k of another company (possibly because I didn’t know where to look). I know you can use EDGAR database to at least lookup these forms, but I do not know the full capabilities of the database (such as if you can query for ownership directly) because I just discovered it the other day.
I don’t currently have adequate understanding of different SEC FORMS, and although I can use python I have no experience writing web crawlers at the moment.
I do not currently have adequate knowledge of different SEC forms for this task
I would also be really interested in a dataset like this. Institutional investors for public companies are sometimes listed in the SEC 10k form, but I have yet to fully learn the structure of these documents. Someone intelligent could probably make a web crawler to scrape institutional and single person ownership of companies from SEC filings. Ideally with a proper dataset like this you could map out who owns each company, and who owns each of the owning companies etc. which would be really interesting information.
I'm curious to give the new json functions a spin, specifically json_arrayagg.
I’m all for making Boston more bike friendly.
I'm from US, but I was rooting for Germany. USA didn't deserve to win with that roster.