Find companies that sponsor H1B visas with real Department of Labor data
Live Demo · Report Bug · Request Feature
- About
- Features
- Tech Stack
- Getting Started
- Project Structure
- Database Schema
- Data Processing
- Deployment
- Screenshots
- Contributing
- License
SponsorPath is a web application that helps international professionals find companies that sponsor H1B visas in the United States. The platform provides:
- Real DOL Data: Access official Department of Labor LCA (Labor Condition Application) disclosure data
- Company Insights: View approval rates, salary ranges, top job titles, and work locations
- Historical Trends: Track company sponsorship patterns over multiple years (FY2021-2025)
- Smart Search: Filter companies by industry, state, and sort by various metrics
Finding H1B sponsors is challenging. Most job seekers rely on outdated lists or word of mouth. SponsorPath solves this by:
- Processing millions of DOL records to identify active sponsors
- Calculating real approval rates and salary statistics
- Presenting data in an easy-to-use, searchable interface
- Browse 500+ verified H1B sponsor companies
- View detailed company profiles with statistics
- Filter by industry (Technology, Finance, Healthcare, etc.)
- Filter by headquarters state
- Sort by total applications, approval rate, or salary
- Overview Tab: Application status breakdown, key statistics
- Trends Tab: Historical sponsorship trends with interactive charts
- Salary Tab: Salary distribution visualization
- Job Titles Tab: Most common sponsored positions
- Locations Tab: Work location distribution
- Curated H1B policy updates and news
- Links to official USCIS and DOL resources
- Key dates for H1B cap season
- User registration and login with Supabase Auth
- Email/password authentication
- Protected routes for future premium features
| Category | Technology |
|---|---|
| Framework | Next.js 16 (App Router) |
| Language | TypeScript |
| Styling | Tailwind CSS 4 |
| Database | Supabase (PostgreSQL) |
| Authentication | Supabase Auth |
| Charts | Recharts |
| Deployment | Vercel |
| Data Source | U.S. Department of Labor |
- Node.js 18+
- npm or yarn
- Supabase account (free tier works)
-
Clone the repository
git clone https://github.com/ssaurabh760/sponsorpath.git cd sponsorpath -
Install dependencies
npm install
-
Set up Supabase
- Create a new project at supabase.com
- Go to SQL Editor and run the schema from
supabase/schema.sql - Get your project URL and anon key from Settings > API
-
Configure environment variables
cp .env.example .env.local
Edit
.env.local:NEXT_PUBLIC_SUPABASE_URL=your_supabase_url NEXT_PUBLIC_SUPABASE_ANON_KEY=your_supabase_anon_key
-
Seed the database (see Data Processing)
-
Run the development server
npm run dev
sponsorpath/
├── src/
│ ├── app/ # Next.js App Router pages
│ │ ├── page.tsx # Homepage
│ │ ├── companies/
│ │ │ ├── page.tsx # Companies listing
│ │ │ └── [slug]/
│ │ │ ├── page.tsx # Company detail (server)
│ │ │ └── company-detail-client.tsx
│ │ ├── jobs/
│ │ │ └── page.tsx # Jobs page
│ │ ├── news/
│ │ │ └── page.tsx # H1B news
│ │ └── auth/
│ │ ├── login/
│ │ ├── signup/
│ │ └── callback/
│ ├── components/
│ │ ├── ui/ # Reusable UI components
│ │ ├── charts/ # Recharts components
│ │ ├── Header.tsx
│ │ └── Footer.tsx
│ └── lib/
│ └── supabase/ # Supabase client setup
├── scripts/
│ ├── process-h1b-stream.js # Initial data processing
│ └── add-h1b-year.js # Add additional years
├── supabase/
│ └── schema.sql # Database schema
└── public/
| Table | Description |
|---|---|
companies |
Company information (name, slug, industry, HQ state) |
company_stats |
Per-year statistics (applications, approvals, salaries) |
h1b_records |
Raw H1B application records (optional) |
jobs |
Job listings (future feature) |
users |
User profiles |
saved_jobs |
User bookmarks |
user_submissions |
"I got sponsored" stories |
comments |
Company discussions |
companies (1) ──── (many) company_stats
companies (1) ──── (many) jobs
users (1) ──── (many) saved_jobs
users (1) ──── (many) user_submissions
Data comes from the Department of Labor's LCA Disclosure Data.
-
Download DOL Excel files
LCA_Disclosure_Data_FY2025_Q1.xlsx LCA_Disclosure_Data_FY2024_Q4.xlsx LCA_Disclosure_Data_FY2023_Q4.xlsx etc. -
Process with streaming script (handles large 80MB+ files)
# Initial processing node scripts/process-h1b-stream.js ~/Downloads/LCA_Disclosure_Data_FY2025_Q1.xlsx # Add additional years node scripts/add-h1b-year.js ~/Downloads/LCA_Disclosure_Data_FY2024_Q4.xlsx 2024
-
Run generated SQL in Supabase
- Open
scripts/data/seed-companies.sqloradd-year-XXXX.sql - Execute in Supabase SQL Editor
- Open
- Company name normalization (removes LLC, Inc, Corp suffixes)
- Application status counts (Certified, Denied, Withdrawn)
- Approval rate calculation
- Salary statistics (average, median)
- Top 5 job titles per company
- Top 5 work locations per company
- Industry classification (pattern matching)
- Push code to GitHub
- Import project in Vercel
- Add environment variables:
NEXT_PUBLIC_SUPABASE_URLNEXT_PUBLIC_SUPABASE_ANON_KEY
- Deploy!
| Variable | Description |
|---|---|
NEXT_PUBLIC_SUPABASE_URL |
Supabase project URL |
NEXT_PUBLIC_SUPABASE_ANON_KEY |
Supabase anonymous key |
Search for H1B sponsors with real DOL data
Browse and filter 500+ sponsor companies
Deep dive into company statistics with interactive charts
Track sponsorship trends over multiple years
Contributions are welcome! Please follow these steps:
- Fork the repository
- Create a feature branch (
git checkout -b feature/amazing-feature) - Commit your changes (
git commit -m 'Add amazing feature') - Push to the branch (
git push origin feature/amazing-feature) - Open a Pull Request
- Use TypeScript for all new code
- Follow existing code style
- Write meaningful commit messages
- Test your changes locally before submitting
This project is licensed under the MIT License - see the LICENSE file for details.
- U.S. Department of Labor for providing public H1B data
- USCIS for H1B program information
- Supabase for the amazing backend platform
- Vercel for seamless deployment
Saurabh Srivastava
Project Link: https://github.com/ssaurabh760/SponsorPath
⭐ Star this repo if you find it helpful!
Made with ❤️ for the international professional community