H1-B Data
2023 H1-B Data 🔥
2023 H1-B data gathered from the Department of Labor:
https://www.dol.gov/agencies/eta/foreign-labor/performance#dis
Contains all information, including salaries.
Questions / Comments?
- Please create an issue in the left nav of this database
Queries
illustrious-mole315
21032024
21032024
jasonz
5 Apple positions
taut-spider657
Abraar Subhan - Certified H1B approvals grouped by Job Titles
Displays the count of certified case status for every job title, sorted to show the highest certified count to the lowest.
positive-dogfish689
Akruti
This query will retrieve the specified columns from the public.jobs table, filtered for cases with a status of 'Certified', ordered by the most recent received_date, and limited to the first 100 rows.
irritating-sandpiper347
Alberto Castro
Query of table Jobs
golden-kingfisher747
Ali nassrallah
digital-tarsier126
Amalia Gamez
The state with the highest H-1b Visas
prestigious-salmon952
Analyst Jobs near VA
Jobs with 'analyst' near VA - includes NC, VA, DC, MD.
monthly-trout414
Anderson Garces
Number of employees per country
elated-mule605
Andile
500$ challenge
elated-mule605
Andile
Sort 500$ challenge
rosy-llama513
Andres Caballero
gray-wolverine139
ANMOL ARORA
Top 10 job titles with the highest number of cases
jasonz
Apple last 5 jobs
jasonz
Apple Positions
tart-swallow741
Arati Neupane
job_title='Software Engineer'
gaseous-slug411
Ashish
Data analyst
wild-stork88
bananaSQL
envious-buffalo850
Best Job Titles
Best Job titles sorted from best to worst.
rough-spoonbill250
Bhavana Parupalli
Count the number of cases for each visa class
powerful-jackal487
BIA WageByStateStudy
brilliant-camel303
Biokpo Amachree
Count of Job_titles
another-goldfinch204
Case Analysis by job title and visa class
stiff-panther287
Certified Business Analysts
Selects Top 100 rows of Business Analysts who are Certified(case_status certified)
bulky-chough522
Certified cases by soc_title
This query gets the number of full time jobs and cases associated that were certified along with the number of cases that fit the above criteria for the state of TN.
bulky-chough522
Certified cases by soc_title
Gets the number of jobs under Standard Occupational Classification title and cases that were certified for full time jobs. It adds how many cases were in TN state.
piercing-rat433
Company/Attorney proximity
Lists companies which are within [3000] postal code units of their attorney alphabetically.
woozy-swallow324
Conversion rate
Conversion rate of H1B applications
best-quail309
Count of full time data related roles, their specific cities, states, and employer name
bad-curlew788
data_jobs
list of data jobs
bad-curlew788
data_jobs
list of data jobs
quarrelsome-jaguar134
data jobs query
frequent-dogfish97
Data Science Jobs
Jess Ramos Test
unwitting-marten20
data scientists versus software developers
comparing jobs
understated-spider879
demo
buoyant-nightingale135
Denied Count by SOC Title
This shows how many visas were denied in 2023 by SOC title.
early-hamster416
Different Case Status
List the Different Case Status of the H1B Visas.
breakable-wallaby553
duplicate case_number
duplicate case_number
digital-owl788
easy job list count
counting jobs by job grouping
lanky-vulture718
edu email query
zesty-cat451
Emma Wilcox
Jess Ramos SQl challenge query
aheckmann
Employer count
Record count by employer_name
piercing-rat433
Employer/Distance study
Identifies companies which are situated within 500 postal-code units of their attorney. Lists companies by ascending postal code..
agreeable-sparrow104
Fatima
orderly-elephant881
Find Managers
This query lists all the employees with a "Manager" job title.
partial-deer31
fun
frosty-quail38
Gayathry Devi Logeswaran
breakable-wallaby553
group by visa class
check the number of entries in each visa class
powerful-jackal487
h1b
long-panther72
H1-B Jobs Cupertino
List of candidates in Cupertino
humiliating-chimpanzee747
Himanshu_Select
Query to show 10 records of the table.
same-termite872
Ishika Rathod
This query shows the list of all those whose employer country is Birmingham and they are ordered in ascending order of their case_id
scaly-dogfish529
Jhonathan Alexander Gonzales Piza
What are the 'soc_title' with their respective 'visa_class' with more than 10,000 'Certified' status
lined-wildcat585
Jobs
cool-yak44
job title like lead and work state in tx, ok, la
specific-porpoise762
job titles and cases by job category
gray-ibex317
John Curran
gray-ibex317
John Curran SQL query
wavy-gnat575
KbSql
creepy-walrus100
Kenbenarduneanya
1 select * from public jobs where = Data Analyst
curly-vulture103
Kim Dinh
Number of Full Time and Not Full Time IT Professionals
jasonz
Last 5 Apple Jobs
nippy-dotterel847
Latest Devs
Latest Developers with H1Bs
imperfect-magpie884
lissa
case expression
enraged-hummingbird358
Miguel Johnson
Test Query
creative-pig120
Money
soupy-pelican325
NC Job Titles
soupy-scorpion248
Ngozi Chukwuma
This query selects the columns case_number, case_status, received_date, decision_date, visa_class, and job_title from the "jobs" table in the "public" schema. It filters the rows where the visa_class column equals 'H-1B', orders the results by the job_title column in ascending order
enchanting-squid717
Nidhin Mathai
Find the number of certified cases in the year 2023 for each employer state. Show the name and the number of certified cases in the result. Show the final result in descending order of number of certified cases.
enchanting-squid717
Nidhin Mathai
Case number- with group by
enchanting-squid717
Nidhin Mathai
Find count of h1b cases certified in the year 2023 for each state, and group the result by the name of the employer state. Finally order the result in the descending order of the number of cases certified.
breakable-wallaby553
not H-1B Visa
listing top 100 columns where the visa class is not equal to H-1B
judicious-mandrill530
number and visa type by state
periodic-ibex38
Number_FT_positions_switched_to
unacceptable-wren86
Olatunbosun Fikayo
Analysts job title
insidious-bear535
Osvaldo Marquez Rubio Query
case numbers that have worksite state as Texas and worksite city as Houston with potential starting salary equal to or greater than $50,000. Ordered by wage in descending order.
evil-tarsier146
possible case status
fancy-pigeon684
Ranking total number of case_status for each department
silver-narwhal93
Rosa Vasquez
It filters the results to only include jobs located in CA and with a wage rate greater than $100,000.
determined-narwhal60
Saba Mall
tasty-curlew73
Samuel George
Hope it be user friendly and lively community
liquid-opossum841
Select job_title and full time
energetic-goshawk91
select winner from mattytwoshoes
excited-mantis626
Software Engineer
noxious-hamster380
Soundarya
SQL
secondary-slug610
SqlLine
Fetch rows where by the job title contains the word "Data"
gray-ibex317
SQL query
watchful-stinkbug400
SQL query
This query gets the data of those whose employer is Google and it is in ascending order of their case_number.
gray-ibex317
SQL query
gray-ibex317
SQL query
slight-alpaca475
State wise data professionals count
This query gives state wise count of professionals working in data related roles wose H1B case status is 'certified'.
excited-mantis626
Surya Manduri
imaginary-swan779
table_preview
preview of the table using LIMIT clause
harmonious-pony45
Taiwo Adeegite
Number of cases in each Visa-Class.
pale-giraffe113
Tanvi
Query to find the cases valid for year 2024 without duplicates
understated-spider879
TBryant Software Developers
all rows where job is some kind of "SOFTWARE DEVELOPER"
humiliating-chimpanzee747
The Classic *
Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
humiliating-chimpanzee747
The Classic *
Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
half-starling135
Tom T
Select the last record to have a decision.
half-starling135
Tom T
Selected first 10 records, all columns
somber-finch635
Top 10 Cities with new jobs
idiotic-deer282
Top 3 Jobs by State
This query outputs the 3 job titles with the most open positions by state.
dyna
Top 5 employer per city
Dyna Kheang
repentant-owl502
Top employers sponsoring H1B cases
Top employers sponsoring H1B cases
tart-echidna255
Vignesh S
tart-echidna255
Vignesh Subramanian
tart-echidna255
Vignesh Subramanian
lined-wildcat585
Violators
strict-sardine482
wage desc
job title, employer name, wage from
ordinary-gazelle410
Yella suman
SELECT orders.*, customers.*
FROM orders
INNER JOIN customers ON orders.customer_id = customers.customer_id;
ordinary-gazelle410
Yella suman
SELECT orders.*, customers.*
FROM orders
INNER JOIN customers ON orders.customer_id = customers.customer_id;
ordinary-gazelle410
Yella Suman
unripe-swallow958
Zachary Phinney
Used a query to select case_status
unripe-swallow958
Zachary Phinney
Ran a query to view all the decisions dates from the public.jobs table