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?

  1. Please create an issue in the left nav of this database


Queries

Ibrohim Abdivokhidovillustrious-mole315
21032024
abbylondon.malick@gmail.comtaut-spider657
Displays the count of certified case status for every job title, sorted to show the highest certified count to the lowest.
Akruti Ambadepositive-dogfish689
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.
Alberto Castroirritating-sandpiper347
Query of table Jobs
Ali Nassrallahgolden-kingfisher747
maciel.gamez96@gmail.comdigital-tarsier126
The state with the highest H-1b Visas
carolinepark17@gmail.comprestigious-salmon952
Jobs with 'analyst' near VA - includes NC, VA, DC, MD.
Anderson Garcés Molinamonthly-trout414
Number of employees per country
andilemkhize444@gmail.comelated-mule605
500$ challenge
andilemkhize444@gmail.comelated-mule605
Sort 500$ challenge
Andres Caballero Encaladarosy-llama513
anmol.1591@outlook.comgray-wolverine139
Top 10 job titles with the highest number of cases
aneupane84@gmail.comtart-swallow741
job_title='Software Engineer'
Sunny Tiwarigaseous-slug411
Data analyst
Melissa Roywild-stork88
Mohd Amerenvious-buffalo850
Best Job titles sorted from best to worst.
parupallibhavana99@gmail.comrough-spoonbill250
Count the number of cases for each visa class
brent pepperpowerful-jackal487
Victor Amachreebrilliant-camel303
Count of Job_titles
tom.oira@gmail.comstiff-panther287
Selects Top 100 rows of Business Analysts who are Certified(case_status certified)
Yatri Patelbulky-chough522
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.
Yatri Patelbulky-chough522
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.
j_mattie@live.capiercing-rat433
Lists companies which are within [3000] postal code units of their attorney alphabetically.
Amey Meherwoozy-swallow324
Conversion rate of H1B applications
dorothykunth@gmx.debad-curlew788
list of data jobs
dorothykunth@gmx.debad-curlew788
list of data jobs
lcanche douquarrelsome-jaguar134
Jess Ramosfrequent-dogfish97
Jess Ramos Test
ashish1qwerty1@gmail.comunwitting-marten20
comparing jobs
Taya Bryantunderstated-spider879
sort.sterile584@passinbox.combuoyant-nightingale135
This shows how many visas were denied in 2023 by SOC title.
Pablo Cayuelaearly-hamster416
List the Different Case Status of the H1B Visas.
geekygogo@gmail.combreakable-wallaby553
duplicate case_number
Charles Andersondigital-owl788
counting jobs by job grouping
Tyson Eyrelanky-vulture718
Emma Wilcoxzesty-cat451
Jess Ramos SQl challenge query
Aaron Heckmannaheckmann
Record count by employer_name
j_mattie@live.capiercing-rat433
Identifies companies which are situated within 500 postal-code units of their attorney. Lists companies by ascending postal code..
fatima.aitlamin03@gmail.comagreeable-sparrow104
Janelle Clarke Smithorderly-elephant881
This query lists all the employees with a "Manager" job title.
Vivien Santapartial-deer31
geekygogo@gmail.combreakable-wallaby553
check the number of entries in each visa class
brent pepperpowerful-jackal487
mindiritzman@gmail.comlong-panther72
List of candidates in Cupertino
Himanshu Dhimanhumiliating-chimpanzee747
Query to show 10 records of the table.
Ishika Rathodsame-termite872
This query shows the list of all those whose employer country is Birmingham and they are ordered in ascending order of their case_id
jhonalex.umss@gmail.comscaly-dogfish529
What are the 'soc_title' with their respective 'visa_class' with more than 10,000 'Certified' status
Justin R Paprecklined-wildcat585
John Currangray-ibex317
Kristen Brandonwavy-gnat575
Ken Beatcreepy-walrus100
1 select * from public jobs where = Data Analyst
ndinh2@ggc.educurly-vulture103
Number of Full Time and Not Full Time IT Professionals
Kevin Wilkienippy-dotterel847
Latest Developers with H1Bs
One GirlyGeekimperfect-magpie884
case expression
Miguel Johnsonenraged-hummingbird358
Test Query
bruno.albuquerque50@gmail.comcreative-pig120
adam.kuhn@lightning.aisoupy-pelican325
Ngozi M. Chukwumasoupy-scorpion248
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
nidhinkmathai@gmail.comenchanting-squid717
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.
nidhinkmathai@gmail.comenchanting-squid717
Case number- with group by
nidhinkmathai@gmail.comenchanting-squid717
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.
geekygogo@gmail.combreakable-wallaby553
listing top 100 columns where the visa class is not equal to H-1B
Louis Lavinjudicious-mandrill530
olatunbosunfikayo@gmail.comunacceptable-wren86
Analysts job title
Osvaldo Marquez Rubioinsidious-bear535
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.
sophiayuen.da@gmail.comevil-tarsier146
mariamvasquezh20@gmail.comsilver-narwhal93
It filters the results to only include jobs located in CA and with a wage rate greater than $100,000.
Saba Imrandetermined-narwhal60
georgesamuel194@gmail.comtasty-curlew73
Hope it be user friendly and lively community
suryaceiiit@gmail.comexcited-mantis626
Soundarya Abiraminoxious-hamster380
SQL
aikaruwa2005@hotmail.comsecondary-slug610
Fetch rows where by the job title contains the word "Data"
John Currangray-ibex317
Ishikawatchful-stinkbug400
This query gets the data of those whose employer is Google and it is in ascending order of their case_number.
John Currangray-ibex317
John Currangray-ibex317
meghaparakattwork@gmail.comslight-alpaca475
This query gives state wise count of professionals working in data related roles wose H1B case status is 'certified'.
suryaceiiit@gmail.comexcited-mantis626
Sikyun Leeimaginary-swan779
preview of the table using LIMIT clause
adegitetaiwo24@gmail.comharmonious-pony45
Number of cases in each Visa-Class.
bhaleraotanvi.24@gmail.compale-giraffe113
Query to find the cases valid for year 2024 without duplicates
Taya Bryantunderstated-spider879
all rows where job is some kind of "SOFTWARE DEVELOPER"
Himanshu Dhimanhumiliating-chimpanzee747
Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
Himanshu Dhimanhumiliating-chimpanzee747
Bringing out the big guns with the 'select *' strategy! Let's hope for no overflow errors! 😅
t.m.tomasovic@gmail.comhalf-starling135
Select the last record to have a decision.
t.m.tomasovic@gmail.comhalf-starling135
Selected first 10 records, all columns
Gray Randolphidiotic-deer282
This query outputs the 3 job titles with the most open positions by state.
Sri Shivanandarepentant-owl502
Top employers sponsoring H1B cases
svignesh2623@gmail.comtart-echidna255
svignesh2623@gmail.comtart-echidna255
svignesh2623@gmail.comtart-echidna255
Justin R Paprecklined-wildcat585
smith.leighton015@gmail.comstrict-sardine482
job title, employer name, wage from
Suman Yellaordinary-gazelle410
SELECT orders.*, customers.* FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;
Suman Yellaordinary-gazelle410
SELECT orders.*, customers.* FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id;
Suman Yellaordinary-gazelle410
zacharytphinney@protonmail.comunripe-swallow958
Used a query to select case_status
zacharytphinney@protonmail.comunripe-swallow958
Ran a query to view all the decisions dates from the public.jobs table