Himanshu_Select

Query to show 10 records of the table.

case_number
case_status
received_date
decision_date
original_cert_date
visa_class
job_title
soc_code
soc_title
full_time_position
begin_date
end_date
total_worker_positions
new_employment
continued_employment
change_previous_employment
new_concurrent_employment
change_employer
amended_petition
employer_name
trade_name_dba
employer_address1
employer_address2
employer_city
employer_state
employer_postal_code
employer_country
employer_province
employer_phone
employer_phone_ext
naics_code
employer_poc_last_name
employer_poc_first_name
employer_poc_middle_name
employer_poc_job_title
employer_poc_address1
employer_poc_address2
employer_poc_city
employer_poc_state
employer_poc_postal_code
employer_poc_country
employer_poc_province
employer_poc_phone
employer_poc_phone_ext
employer_poc_email
agent_representing_employer
agent_attorney_last_name
agent_attorney_first_name
agent_attorney_middle_name
agent_attorney_address1
agent_attorney_address2
agent_attorney_city
agent_attorney_state
agent_attorney_postal_code
agent_attorney_country
agent_attorney_province
agent_attorney_phone
agent_attorney_phone_ext
agent_attorney_email_address
lawfirm_name_business_name
state_of_highest_court
name_of_highest_state_court
worksite_workers
secondary_entity
secondary_entity_business_name
worksite_address1
worksite_address2
worksite_city
worksite_county
worksite_state
worksite_postal_code
wage_rate_of_pay_from
wage_rate_of_pay_to
wage_unit_of_pay
prevailing_wage
pw_unit_of_pay
pw_tracking_number
pw_wage_level
pw_oes_year
pw_other_source
pw_other_year
pw_survey_publisher
pw_survey_name
total_worksite_locations
agree_to_lc_statement
h_1b_dependent
willful_violator
support_h1b
statutory_basis
appendix_a_attached
public_disclosure
preparer_last_name
preparer_first_name
preparer_middle_initial
preparer_business_name
preparer_email
I-200-23244-317261Certified - Withdrawn2023-09-01T00:00:00.000Z2023-09-30T00:00:00.000Z2023-09-11T00:00:00.000ZH-1BAnalyst, Business Sr15-2031.00Operations Research AnalystsY2024-03-01T00:00:00.000Z2027-02-28T00:00:00.000Z1010000Freedom Mortgage Corporationnull951 Yamato Rd Suite 175Boca RatonFL33431UNITED STATES OF AMERICAnull+18564037353null522292BrethauerCassie nullDirector, HR Operations951 Yamato RoadSuite 175Boca RatonFL33431UNITED STATES OF AMERICAnull+13178062360nullcassie.Brethauer@freedommortgage.comYesHarrisRyannull465 California StreetSuite 700San FranciscoCA94104UNITED STATES OF AMERICACA+14157717500nullfreedommortgage@immigrationlaw.comCorporate Immigration Partners, P.C.CASupreme Court1Nonull10255 Brookstone Court ManassasPRINCE WILLIAMVA2010996720136411Year96720YearnullII7/1/2023 - 6/30/2024nullnullnullnull1YesNoNoN/AnullN/ADisclose Businessnullnullnullnullnull
I-202-23242-306442Certified - Withdrawn2023-08-30T00:00:00.000Z2023-09-30T00:00:00.000Z2023-09-07T00:00:00.000ZH-1B1 SingaporeBoard Certified Behavior Analyst19-3034.00School PsychologistsY2023-10-17T00:00:00.000Z2026-10-16T00:00:00.000Z1010000EDTHEORY, LLCnull6701 KOLL CENTER PARKWAYSUITE#250PLEASANTONCA94566UNITED STATES OF AMERICAnull+19255008383null621340PHILIPMARVELnullCHIEF EXECUTIVE OFFICER6701 KOLL CENTER PARKWAYSUITE#250PLEASANTONCA94566UNITED STATES OF AMERICAnull+19255008383nullmarvel@edtheory.comNonullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull1YesSanta Clara County Office of Education1290 Ridder Park DrnullSan JoseSANTA CLARACA9513168182nullYear68182YearnullI7/1/2023 - 6/30/2024nullnullnullnull1YesN/AN/AN/AnullN/ADisclose Businessnullnullnullnullnull
I-200-23242-308144Certified - Withdrawn2023-08-30T00:00:00.000Z2023-09-30T00:00:00.000Z2023-09-07T00:00:00.000ZH-1BManager - Software Engineering15-1252.00Software DevelopersY2024-01-01T00:00:00.000Z2026-12-31T00:00:00.000Z1010000Capgemini America, Inc.null333 West Wacker DriveSuite 300Chicago IL60606UNITED STATES OF AMERICAnull+13123959550null541512KnottsJarednullImmigration Manager333 West Wacker DriveSuite 300ChicagoIL60606UNITED STATES OF AMERICAnull+13123959550nullJared.Knotts@sogeti.comYesRojasHugonull1 S Wacker DrSuite 550ChicagoIL60606UNITED STATES OF AMERICAnull+14699407765nullksheppard@bal.comBerry Appleman & Leiden LLPWISupreme Court of Wisconsin1Nonull4858 Lakeridge StreetApartment 1AYpsilantiWASHTENAWMI48197131533nullYear111821YearnullIII7/1/2023 - 6/30/2024nullnullnullnull2YesYesNoYes$60,000 or higher annual wageN/ADisclose BusinessSheppardKaitlyn (11606.425.22)nullBerry Appleman & Leiden LLPksheppard@bal.com
I-200-23172-131625Certified - Withdrawn2023-06-21T00:00:00.000Z2023-09-30T00:00:00.000Z2023-06-28T00:00:00.000ZH-1BSOFTWARE DEVELOPER15-1252.00Software DevelopersY2023-10-01T00:00:00.000Z2026-09-30T00:00:00.000Z1100000Edvenswa Tech Incnull11205 ALPHARETTA HWYSTE H-2ROSWELLGA30076-5648UNITED STATES OF AMERICAnull+19252646123null541511YerradoddiRamesh ReddynullChief Executive Officer3545 109th PL NE Unit 1nullBellevueWA98004UNITED STATES OF AMERICAnull+19256993990nullramesh@edvenswainc.comNonullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull1Nonull11205 ALPHARETTA HWYSTE H2ROSWELLFULTONGA30076-56488015080200Year80101YearnullI7/1/2022 - 6/30/2023nullnullnullnull1YesYesNoYes$60,000 or higher annual wageN/ADisclose Businessnullnullnullnullnull
I-200-23170-125146Certified - Withdrawn2023-06-19T00:00:00.000Z2023-09-30T00:00:00.000Z2023-06-26T00:00:00.000ZH-1BSOFTWARE DEVELOPER15-1252.00Software DevelopersY2023-10-01T00:00:00.000Z2026-09-30T00:00:00.000Z1100000Edvenswa Tech Incnull11205 ALPHARETTA HWYSTE H-2ROSWELLTX30076-5648UNITED STATES OF AMERICAnull+19252646123null541511YerradoddiRamesh ReddynullChief Executive Officer3545 109th PL NE Unit 1nullBellevueWA98004UNITED STATES OF AMERICAnull+19256993990nullramesh@edvenswainc.comNonullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull1Nonull11205 ALPHARETTA HWYSTE H2ROSWELLFULTONGA30076-56489910099200Year99008YearnullII7/1/2022 - 6/30/2023nullnullnullnull1YesYesNoYes$60,000 or higher annual wageN/ADisclose Businessnullnullnullnullnull
I-200-23170-123899Certified - Withdrawn2023-06-19T00:00:00.000Z2023-09-30T00:00:00.000Z2023-06-26T00:00:00.000ZH-1BSOFTWARE DEVELOPER15-1252.00Software DevelopersY2023-10-01T00:00:00.000Z2026-09-30T00:00:00.000Z1100000Edvenswa Tech Incnull11205 ALPHARETTA HWYSTE H-2ROSWELLGA30076-5648UNITED STATES OF AMERICAnull+19252646123null541511YerradoddiRamesh ReddynullChief Executive Officer3545 109th PL NE Unit 1nullBellevueWA98004UNITED STATES OF AMERICAnull+19256993990nullramesh@edvenswainc.comNonullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull1Nonull11205 ALPHARETTA HWYSTE H2ROSWELLFULTONGA30076-56489910099200Year99008YearnullII7/1/2022 - 6/30/2023nullnullnullnull1YesYesNoYes$60,000 or higher annual wageN/ADisclose Businessnullnullnullnullnull
I-200-23046-776502Certified - Withdrawn2023-02-15T00:00:00.000Z2023-09-30T00:00:00.000Z2023-02-22T00:00:00.000ZH-1BSenior Manager, Americas Division13-1111.00Management AnalystsY2023-02-15T00:00:00.000Z2024-06-11T00:00:00.000Z1000001Simon-Kucher & Partners Strategy & Marketing Consultants LLCnull201 Washington Street, One Boston PlaceSuite 3301BostonMA02108UNITED STATES OF AMERICAnull+16172314500null541611WashamBreannanullHuman Resources Coordinator1201 West Peachtree Street NWSuite 2700AtlantaGA30309UNITED STATES OF AMERICAnull+14046015191nullHRNorthAmerica@simon-kucher.comYesRiccioLaurieB.18 Tremont StreetSuite 601BostonMA02108UNITED STATES OF AMERICAMA+16177424444104RidaH@costariccio.comCosta & Riccio LLPMAMassachusetts Supreme Judicial Court1Nonull225 Liberty Street41st FloorNew YorkNEW YORKNY10286200000nullYear121306YearnullIII7/1/2022 - 6/30/2023nullnullnullnull2YesNoNoN/AnullN/ADisclose BusinessHussainRidanullCosta and Riccio, LLPridah@costariccio.com
I-203-22333-610021Certified - Withdrawn2022-11-29T00:00:00.000Z2023-09-30T00:00:00.000Z2022-12-06T00:00:00.000ZE-3 AustralianVice President, Engineering11-3021.00Computer and Information Systems ManagersY2023-01-01T00:00:00.000Z2024-12-31T00:00:00.000Z1000001CEadvisory, Inc.null2510 8th Avenue South2nd FloorNashvilleTN37204UNITED STATES OF AMERICAnull+16155153602null5416BusbyEricnullPresident2510 8th Avenue South2nd FloorNashvilleTN37204UNITED STATES OF AMERICAnull+16157201141nullebusby@adcritter.comYesKatzNoranull511 Union StreetSuite 2700NashvilleTN37219UNITED STATES OF AMERICAnull+16158508730nullnora.katz@wallerlaw.comWaller Lansden Dortch & Davis, LLPTNSupreme Court1Nonull2510 8th Avenue South2nd FloorNashvilleDAVIDSONTN37204140000185000Year136635YearnullIII7/1/2022 - 6/30/2023nullnullnullnull1YesN/AN/AN/AnullN/ADisclose BusinessKatzNoraFWaller Lansden Dortch and DavisNora.Katz@wallerlaw.com
I-200-22216-395597Certified - Withdrawn2022-08-03T00:00:00.000Z2023-09-30T00:00:00.000Z2022-08-10T00:00:00.000ZH-1BBUSINESS ANALYST15-1211.00Computer Systems AnalystsY2022-08-08T00:00:00.000Z2025-08-07T00:00:00.000Z1000001LILLI TECHNOLOGY LLCnull7800 PRESTON RDSTE 105PLANOTX75024UNITED STATES OF AMERICAnull+19728531511null541512HAMANNHEATHERnullPRESIDENT7800 PRESTON RDSTE 105PLANOTX75024UNITED STATES OF AMERICAnull+19728531511nullIMMIGRATION@LILLITECHNOLOGY.COMNonullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull1YesNEW YORK DEPT OF EDUCATION180 FAIRHAVEN DRAPT A24JERICHONASSAUNY1175346nullHour46HournullII7/1/2022 - 6/30/2023nullnullnullnull1YesYesNoYesBoth $60,000 or higher in annual wage and Masters Degree or higher in related specialtyN/ADisclose Businessnullnullnullnullnull
I-203-23274-403704Withdrawn2023-09-30T00:00:00.000Z2023-09-30T00:00:00.000ZnullE-3 AustralianCEO of BioBrew11-1021.00General and Operations ManagersY2023-12-16T00:00:00.000Z2025-12-15T00:00:00.000Z1010000ZX Ventures Holdings Corp.null114 West 41st StFloor 17New YorkNY10036UNITED STATES OF AMERICAnull+13322399194null523910SchaikoAllaine nullGlobal People Director, GHQ 250 Park AvenueAnheuser-Busch InBev Services, LLCNew YorkNY10177UNITED STATES OF AMERICAnull+13322399194nullallaine.schaiko@ab-inbev.comYesMcCownKellynull100 Pine StreetSuite 1250San FranciscoCA94111UNITED STATES OF AMERICAnull+14154325300nullgeorge@mccownevans.comMCCOWN & EVANS LLPCASUPREME COURT1Nonull114 West 41st StFloor 17New YorkNEW YORKNY10036224349526668Year224349YearnullIV7/1/2023 - 6/30/2024nullnullnullnull2YesN/AN/AN/AnullN/ADisclose Businessnullnullnullnullnull