Quick Command Bar

Type a command or search...

CGS Dashboard
Settings

F-1 Filing Analytics

Analyze F-1 registration statements for foreign private issuers (2020-2025)

6 Saved Queries2020-2025 DataF-1 FilingsLast updated today
Top Underwriters by F-1 Filing Count (2020-2025)
SEC EDGAR Database
Investment banks ranked by number of F-1 registration statements for foreign private issuers
Nov 3248 rows

Query Results

RankUnderwriterTotal F-1s
Showing 1 to 8 of 248 results

SQL Query

SELECT underwriter_name, COUNT(DISTINCT filing_id) as total_filings, COUNT(CASE WHEN amendment_number IS NULL THEN 1 END) as original_filings, COUNT(CASE WHEN amendment_number IS NOT NULL THEN 1 END) as amendments, SUM(offering_amount) as total_raised, AVG(offering_amount) as avg_deal_size FROM sec_filings WHERE form_type = 'F-1' AND filing_year BETWEEN 2020 AND 2025 GROUP BY underwriter_name ORDER BY total_filings DESC
F-1 Filing Volume by Year (2020-2025)
SEC EDGAR Database
Annual F-1 registration statement counts showing foreign company IPO trends
Nov 36 rows
F-1 Filings by Country of Origin
SEC EDGAR Database
Foreign companies filing F-1 forms grouped by country (2020-2025)
Nov 242 rows
F-1 Filing Status Analysis (2023-2025)
SEC EDGAR Database
Tracking F-1 filing progression from initial to effective status
Nov 3156 rows
F-1 Filing Industry Distribution
SEC EDGAR Database
F-1 filings segmented by industry sector (2020-2025)
Nov 128 rows
F-1 Amendment Analysis
SEC EDGAR Database
Analysis of F-1 amendment patterns and frequency
Oct 31892 rows