trk_data
Data source: Bloomberg FOIA Request
617 rows where ben_education_code = "H"
This data as json, CSV (advanced)
Suggested facets: gender, ben_multi_reg_ind, first_decision, basis_for_classification, requested_action, number_of_beneficiaries, ben_sex, ben_current_class, full_time_ind, wage_unit, s1q1a, s1q1b, s3q1, s4q1
| Link | rowid ▼ | country_of_birth | country_of_nationality | ben_year_of_birth | gender | employer_name | fein | mail_addr | city | state | zip | lottery_year | status_type | ben_multi_reg_ind | rec_date | first_decision | first_decision_date | i129_employer_name | requested_class | basis_for_classification | requested_action | number_of_beneficiaries | ben_sex | ben_country_of_birth | ben_current_class | job_title | worksite_street | worksite_city | worksite_state | worksite_zip | full_time_ind | wage_amt | wage_unit | valid_from | valid_to | num_of_emp_in_us | s1q1a | s1q1b | ben_education_code | ed_level_definition | ben_pfield_of_study | ben_comp_paid | dot_code | naics_code | s3q1 | s4q1 | fiscal_year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 53 | ARE | CAN | 1994.0 | male | Global Software, LLC | 561944603.0 | 8529 Six Forks Rd Ste 400 | Raleigh | NC | 27615-4972 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 7/6/2022 | INSIGHTSOFTWARE LLC | 1B1 | A | B | 1.0 | M | UAE | TN1 | SOFTWARE ENGINEER | 9126 CALYPSO CT | DISCOVERY BAY | CA | 94505.0 | Y | 120000.0 | YEAR | 10/1/2022 | 9/30/2025 | 240.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 120000.0 | 110.0 | 511210.0 | M | N | 2023.0 |
| 55 | 55 | ARE | CAN | 1996.0 | female | Buhler Athletic Injuries and Human Performance Clinic | 680493996.0 | 447 North 300 West | Kaysville | UT | 84037 | 2023.0 | SELECTED | 0.0 | 6/6/2022 | Approved | 9/9/2022 | BUHLER ATHLETIC INJURIES AND HUMAN PERFORMANCE CLINIC | 1B1 | A | A | 0.9999597536925987 | F | UAE | F1 | associate doctor of chiropractic | 12371 900 EAST | DRAPER | UT | 84020.0 | Y | 57000.0 | YEAR | 10/1/2022 | 9/30/2025 | 14.0 | N | N | H | PROFESSIONAL DEGREE | DOCTOR OF CHIROPRACTIC | 57000.0 | 79.0 | 621310.0 | M | N | 2023.0 |
| 56 | 56 | ARE | CAN | 1996.0 | male | ClearView Healthcare Partners | 261597664.0 | One Newton Place | Newton | MA | 02458 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 6/13/2022 | CLEARVIEW HEALTHCARE PARTNERS | 1B1 | A | B | 1.0 | M | UAE | TN | CONSULTANT | 111 W 33RD STREET | NEW YORK | NY | 10001.0 | Y | 120000.0 | YEAR | 10/1/2022 | 9/30/2025 | 360.0 | N | N | H | PROFESSIONAL DEGREE | MEDICINE | 120000.0 | 39.0 | 541715.0 | B | N | 2023.0 |
| 66 | 66 | ARE | JOR | 1994.0 | female | CVS Rx Services Inc. | 50501917.0 | 1 Cvs Drive | Woonsocket | RI | 02895 | 2023.0 | SELECTED | 0.0 | 5/20/2022 | Approved | 7/21/2022 | CVS RX SERVICES INC | 1B1 | A | A | 1.0 | F | UAE | UU | Staff Pharmacist | 525 WEST MAIN ST | MOUNT JOY | PA | 17552.0 | Y | 117312.0 | YEAR | 10/1/2022 | 9/30/2025 | 300000.0 | N | N | H | PROFESSIONAL DEGREE | PHARMACY | 117312.0 | 74.0 | 446110.0 | B | N | 2023.0 |
| 68 | 68 | ARE | LBN | 1982.0 | female | CVS Rx Services Inc. | 50501917.0 | 1 Cvs Drive | Woonsocket | RI | 02895 | 2023.0 | SELECTED | 0.0 | 5/27/2022 | Approved | 7/14/2022 | CVS RX SERVICES INC | 1B1 | A | A | 1.0 | F | UAE | UU | SOFTWARE ENGINEER | 2110 SPRING VALLEY RD | LANCASTER | PA | 17601.0 | Y | 117312.0 | YEAR | 10/1/2022 | 9/30/2023 | 300000.0 | N | N | H | PROFESSIONAL DEGREE | PHARMACY | 117312.0 | 74.0 | 446110.0 | B | N | 2023.0 |
| 88 | 88 | ARG | ARG | 1978.0 | male | Home Express Corp. | 562429411.0 | 245 Michigan Ave | Miami Beach | FL | 33139-7041 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Denied | 7/26/2023 | HOME EXPRESS CORP | 1B1 | A | A | 1.0 | M | ARGEN | F1 | DIRECTION OF OPERATIONS | 3455 NW 37TH STREET | MIAMI | FL | 33139.0 | Y | 100000.0 | YEAR | 10/1/2022 | 9/30/2025 | 9.0 | N | N | H | PROFESSIONAL DEGREE | LEGAL STUDIES BUSINESS ADMINISTRATION | 100000.0 | 185.0 | 236118.0 | B | N | 2023.0 |
| 90 | 90 | ARG | ARG | 1979.0 | male | E.R. Squibb & Sons, LLC | 136121983.0 | Route 206 & Province Line Road | Princeton | NJ | 08543 | 2023.0 | SELECTED | 0.0 | 6/17/2022 | Approved | 6/23/2022 | ER SQUIBB SONS LLC | 1B1 | A | B | 1.0 | M | ARGEN | L1B | SOFTWARE ENGINEER | 3551 LAWRENCEVILLE RD | PRINCETON | NJ | 8540.0 | Y | 161098.0 | YEAR | 10/1/2022 | 6/14/2025 | 12000.0 | N | N | H | PROFESSIONAL DEGREE | PHARMACY | 161098.0 | 79.0 | 325411.0 | B | N | 2023.0 |
| 92 | 92 | ARG | ARG | 1980.0 | female | Home Express Corp. | 562429411.0 | 245 Michigan Ave | Miami Beach | FL | 33139-7041 | 2023.0 | SELECTED | 0.0 | 6/15/2022 | Approved | 6/23/2022 | HOME EXPRESS CORP | 1B1 | A | A | 1.0 | F | ARGEN | F1 | HUMAN RESOURCES MANAGER | 1523 WEST FLAGLER STREET | MIAMI | FL | 33135.0 | Y | 100000.0 | YEAR | 10/1/2022 | 9/30/2025 | 9.0 | N | N | H | PROFESSIONAL DEGREE | LEGAL HUMAN RESOURCES | 100000.0 | 166.0 | 236118.0 | B | N | 2023.0 |
| 103 | 103 | ARG | ARG | 1985.0 | male | PROGRESSIVE DAIRY HEALTH SERVICES OF NEW MEXICO LLC | 204396526.0 | 5316 Mabry Drive | Clovis | NM | 88101 | 2023.0 | SELECTED | 1.0 | 6/22/2022 | Approved | 11/28/2022 | PROGRESSIVE DAIRY HEALTH SERVICES OF NEW MEXICO LLC | 1B1 | A | A | 1.0 | M | ARGEN | UU | ANIMAL SCIENTIST | 5316 MABRY DRIVE | CLOVIS | NM | 88101.0 | Y | 90000.0 | YEAR | 11/28/2022 | 9/30/2025 | 7.0 | N | N | H | PROFESSIONAL DEGREE | VETERINARY MEDICINE | 90000.0 | 73.0 | 541940.0 | B | N | 2023.0 |
| 110 | 110 | ARG | ARG | 1987.0 | female | White & Case LLP | 135605970.0 | 1221 Avenue Of The Americas | New York | NY | 10020 | 2023.0 | SELECTED | 0.0 | 6/17/2022 | Approved | 6/29/2022 | WHITE CASE LLP | 1B1 | A | A | 1.0 | F | ARGEN | UN | Pre-Admitted Law Clerk/Associate | 1221 AVENUE OF THE AMERICAS | NEW YORK | NY | 10020.0 | Y | 250000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1885.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 250000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 115 | 115 | ARG | ARG | 1988.0 | female | Baker and Hostetler LLP | 340082025.0 | 127 Public Square, Suite 200 | Cleveland | OH | 44114 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 9/13/2022 | BAKER HOSTETLER LLP | 1B1 | A | A | 1.0 | F | ARGEN | J1 | SOFTWARE ENGINEER | 1050 CONNECTICUT AVE N W | WASHINGTON | DC | 20006.0 | Y | 300000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1700.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 300000.0 | 110.0 | 5411110.0 | M | N | 2023.0 |
| 137 | 137 | ARG | ARG | 1990.0 | male | Cleary Gottlieb Steen & Hamilton LLP | 135599083.0 | 1 Liberty Plaza | New York | NY | 10006 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 6/27/2022 | CLEARY GOTTLIEB STEEN HAMILTON LLP | 1B1 | A | B | 1.0 | M | ARGEN | F1 | ASSOCIATE | ONE LIBERTY PLAZA | NEW YORK | NY | 10006.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1200.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 158 | 158 | ARG | ARG | 1991.0 | male | Skadden, Arps, Slate, Meagher & Flom LLP | 131777230.0 | One Manhattan West | New York | NY | 10001 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 9/1/2022 | SKADDEN ARPS SLATE MEAGHER FLOM LLP | 1B1 | A | A | 1.0 | M | ARGEN | F1 | LAW CLERK | ONE MANHATTAN WEST | NEW YORK | NY | 10001.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 3000.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 164 | 164 | ARG | ARG | 1992.0 | male | Shearman & Sterling LLP | 135514352.0 | 599 Lexington Avenue | New York City | NY | 10022 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 9/1/2022 | SHEARMAN STERLING LLP | 1B1 | A | A | 0.9999597536925987 | M | ARGEN | J1 | FOREIGN LEGAL CONSULTANT | 599 LEXINGTON AVENUE | NEW YORK | NY | 10022.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 950.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 165 | 165 | ARG | ARG | 1993.0 | female | JPMorgan Chase & Co. | 132624428.0 | 10 S Dearborn St | Chicago | IL | 60603 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 6/28/2022 | JPMORGAN CHASE CO | 1B1 | A | B | 1.0 | F | ARGEN | L1B | ASSISTANT VICE PRESIDENT SENIOR COUNSEL | 1660 N LASALLE DR | CHICAGO | IL | 60614.0 | Y | 120000.0 | YEAR | 10/1/2022 | 9/30/2025 | 168267.0 | N | N | H | PROFESSIONAL DEGREE | JURIS DOCTOR | 120000.0 | 110.0 | 551112.0 | B | N | 2023.0 |
| 171 | 171 | ARG | ARG | 1993.0 | male | Cravath, Swaine & Moore LLP | 135015405.0 | 825 Eighth Avenue | New York | NY | 10019 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 7/28/2022 | CRAVATH SWAINE & MOORE LLP | 1B1 | A | A | 1.0 | M | ARGEN | F1 | LAW CLERK | 825 EIGHTH AVENUE | NEW YORK | NY | 10019.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1059.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 173 | 173 | ARG | ARG | 1994.0 | female | Gibson, Dunn & Crutcher LLP | 951611234.0 | 333 South Grand Avenue | Los Angeles | CA | 90071 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 6/24/2022 | GIBSON DUNN & CRUTCHER LLP | 1B1 | A | A | 1.0 | F | ARGEN | F1 | VISITING ATTORNEY | 200 PARK AVENUE | NEW YORK | NY | 10166.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 2400.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 201 | 201 | ARG | FRA | 1991.0 | male | Willkie Farr & Gallagher LLP | 135536844.0 | 787 Seventh Avenue | New York | NY | 10019 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/1/2022 | WILLKIE FARR & GALLAGHER LLP | 1B1 | A | A | 1.0 | M | ARGEN | F1 | LAW CLERK | 787 SEVENTH AVENUE | NEW YORK | NY | 10019.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1017.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 248 | 248 | AUS | AUS | 1974.0 | female | SOCIETE GENERALE | 521128875.0 | 245 Park Avenue | New York | NY | 10167 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 7/5/2022 | SOCIETE GENERALE | 1B1 | A | B | 1.0 | F | RALIA | E3 | Counsel | 245 PARK AVENUE | NEW YORK | NY | 10167.0 | Y | 250000.0 | YEAR | 10/1/2022 | 8/18/2025 | 179.0 | N | N | H | PROFESSIONAL DEGREE | LAWS | 250000.0 | 110.0 | 522110.0 | B | N | 2023.0 |
| 285 | 285 | AUS | AUS | 1986.0 | female | Google LLC | 770493581.0 | 1600 Amphitheatre Parkway | Mountain View | CA | 94043 | 2023.0 | SELECTED | 0.0 | 4/14/2022 | Approved | 9/20/2022 | GOOGLE LLC | 1B1 | A | A | 1.0 | F | RALIA | UU | Compliance Program Manager | 807 11TH AVE | SUNNYVALE | CA | 94089.0 | Y | 210000.0 | YEAR | 10/1/2022 | 9/6/2025 | 91426.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 210000.0 | 30.0 | 541512.0 | B | N | 2023.0 |
| 295 | 295 | AUS | AUS | 1987.0 | female | Paul, Weiss, Rifkind, Wharton & Garrison LLP | 131662105.0 | 1285 Avenue Of The Americas | New York | NY | 10019-6064 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Approved | 6/28/2022 | PAUL WEISS RIFKIND WHARTON GARRISON LLP | 1B1 | A | A | 1.0 | F | RALIA | E3 | ASSOCIATE | 1285 AVENUE OF THE AMERICAS | NEW YORK | NY | 10019.0 | Y | 400000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1800.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 400000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 301 | 301 | AUS | AUS | 1987.0 | male | McKinsey & Company, Inc. United States | 133796161.0 | 711 3rd Ave | New York | NY | 10017-9213 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 7/5/2022 | MCKINSEY COMPANY INC UNITED STATES | 1B1 | A | A | 1.0 | M | RALIA | L1A | SOFTWARE ENGINEER | 3 WORLD TRADE CENTER 175 GEENWICH STREET | NEW YORK | NY | 10007.0 | Y | 225000.0 | YEAR | 10/1/2022 | 2/2/2025 | 9000.0 | N | N | H | PROFESSIONAL DEGREE | JURIS DOCTOR | 225000.0 | 199.0 | 541610.0 | B | N | 2023.0 |
| 327 | 327 | AUS | AUS | 1991.0 | female | Gibson, Dunn & Crutcher LLP | 951611234.0 | 333 South Grand Avenue | Los Angeles | CA | 90071 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 7/1/2022 | GIBSON DUNN & CRUTCHER LLP | 1B1 | A | A | 1.0 | F | RALIA | E3 | ASSOCIATE ATTORNEY | 200 PARK AVE | NEW YORK | NY | 10166.0 | Y | 415000.0 | YEAR | 10/1/2022 | 9/30/2025 | 2400.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 415000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 341 | 341 | AUS | AUS | 1992.0 | male | Weil, Gotshal & Manges LLP | 131456110.0 | 767 Fifth Avenue | New York | NY | 10153 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 7/6/2022 | WEIL GOTSHAL MANGES LLP | 1B1 | A | A | 1.0 | M | RALIA | E3 | ASSOCIATE | 767 FIFTH AVENUE | NEW YORK | NY | 10153.0 | Y | 295000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1600.0 | N | N | H | PROFESSIONAL DEGREE | JURIS DOCTOR | 295000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 344 | 344 | AUS | AUS | 1993.0 | female | GI Manager L.P. | 562526642.0 | 188 The Embarcadero | San Francisco | CA | 94105 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 6/29/2022 | GI MANAGER LP | 1B1 | A | A | 1.0 | F | RALIA | E3 | ASSOCIATE FINANCIAL ANALYST | 65 EAST 55TH STREET | NEW YORK | NY | 10022.0 | Y | 140000.0 | YEAR | 10/1/2022 | 9/29/2025 | 120.0 | N | N | H | PROFESSIONAL DEGREE | FINANCE | 140000.0 | 186.0 | 523920.0 | B | N | 2023.0 |
| 346 | 346 | AUS | AUS | 1993.0 | female | White & Case LLP | 135605970.0 | 1221 Avenue Of The Americas | New York | NY | 10020 | 2023.0 | SELECTED | 0.0 | 6/17/2022 | Approved | 6/25/2022 | WHITE CASE LLP | 1B1 | A | B | 1.0 | F | RALIA | F1 | SOFTWARE ENGINEER | 1221 AVENUE OF THE AMERICAS | NEW YORK | NY | 56905.48740771989 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1885.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 360 | 360 | AUS | AUS | 1995.0 | female | Paul, Weiss, Rifkind, Wharton & Garrison LLP | 131662105.0 | 1285 Avenue Of The Americas | New York | NY | 10019-6064 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 6/28/2022 | PAUL WEISS RIFKIND WHARTON GARRISON LLP | 1B1 | A | B | 1.0 | F | RALIA | F1 | LAW CLERK | 1 ASTOR PL | NEW YORK | NY | 56905.48740771989 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1800.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 365 | 365 | AUS | AUS | 1996.0 | female | Cravath, Swaine & Moore LLP | 135015405.0 | 825 Eighth Avenue | New York | NY | 10019 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 11/5/2022 | CRAVATH SWAINE & MOORE LLP | 1B1 | A | A | 1.0 | F | RALIA | F1 | LAW CLERK | 825 EIGHTH AVENUE | NEW YORK | NY | 10019.0 | Y | 215000.0 | YEAR | 11/4/2022 | 9/30/2025 | 1059.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 469 | 469 | BEL | BEL | 1996.0 | female | White & Case LLP | 135605970.0 | 1221 Avenue Of The Americas | New York | NY | 10020 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 7/11/2022 | WHITE CASE LLP | 1B1 | A | A | 1.0 | F | BELGI | F1 | INTERNATIONAL LAW CLERK | 1221 AVENUE OF THE AMERICAS | NEW YORK | NY | 56905.48740771989 | Y | 18000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1885.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 180000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 581 | 581 | BGD | BGD | 1988.0 | male | AT&T Services, Inc. | 742782655.0 | 2270 Lakeside Blvd. | Richardson | TX | 75082 | 2023.0 | SELECTED | 0.0 | 5/25/2022 | Approved | 6/3/2022 | AT&T SERVICES INC | 1B1 | A | A | 1.0 | M | BANGL | F1 | PRINCIPAL MEMBER OF TECHNICAL STAFF | 5001 EXECUTIVE PARKWAY | SAN RAMON | CA | 94583.0 | Y | 200000.0 | YEAR | 10/1/2022 | 8/1/2025 | 230760.0 | N | N | H | PROFESSIONAL DEGREE | COMPUTER SCIENCE | 200000.0 | 30.0 | 517410.0 | M | N | 2023.0 |
| 904 | 904 | BHS | BHS | 1987.0 | male | Latham & Watkins LLP | 952018373.0 | 1271 Avenue Of The Americas | New York | NY | 10020 | 2023.0 | SELECTED | 0.0 | 5/13/2022 | Approved | 8/13/2022 | LATHAM AND WATKINS LLP | 1B1 | A | A | 1.0 | M | BAHAM | J1 | ASSOCIATE | 505 MONTGOMERY STREET | SAN FRANCISCO | CA | 94111.0 | Y | 225000.0 | YEAR | 10/1/2022 | 9/30/2025 | 4082.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 225000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 922 | 922 | BIH | BIH | 1975.0 | female | GSG Consultants, Inc. | 363844476.0 | 735 Remington Rd | Schaumburg | IL | 60173-4552 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/1/2022 | GSG CONSULTANTS INC | 1B1 | A | A | 1.0 | F | BOSNI | F1 | SENIOR TECHNICAL WRITER | 735 REMINGTON RD | SCHAUMBURG | IL | 56905.48740771989 | Y | 65000.0 | YEAR | 10/1/2022 | 9/30/2025 | 126.0 | N | N | H | PROFESSIONAL DEGREE | LITERATURE | 65000.0 | 19.0 | 237990.0 | B | N | 2023.0 |
| 978 | 978 | BMU | GBR | 1975.0 | male | Yaste & Hufanda DDS PLLC | 562227080.0 | 15105 John J. Delaney Dr | Charlotte | NC | 28277 | 2023.0 | SELECTED | 0.0 | 5/13/2022 | Approved | 7/27/2022 | YASTE & HUFANDA DDS PLLC DBA BALLANTYNE DENISTRY | 1B1 | A | B | 1.0 | M | UK | F1 | SOFTWARE ENGINEER | 15105 JOHN J DELANEY DR | CHARLOTTE | NC | 28277.0 | Y | 140000.0 | YEAR | 10/1/2022 | 9/30/2025 | 28.0 | N | N | H | PROFESSIONAL DEGREE | DOCTOR OF DENTAL SURGERY IMPLANT DENISTRY | 140000.0 | 72.0 | 621210.0 | M | N | 2023.0 |
| 1051 | 1051 | BRA | BRA | 1974.0 | male | Ralco Nutrition, Inc. | 410978726.0 | 1600 Hahn Road | Marshall | MN | 56258 | 2023.0 | SELECTED | 0.0 | 5/11/2022 | Approved | 8/18/2022 | RALCO NUTRITION INC | 1B1 | A | A | 1.0 | M | BRAZI | F1 | LATIN AMERICAN TECHNICAL LIVESTOCK FEED MARKETING MANAGER | 600 MICHIGAN RD | MARSHALL | MN | 56905.48740771989 | Y | 83699.0 | YEAR | 10/1/2022 | 9/30/2025 | 150.0 | N | N | H | PROFESSIONAL DEGREE | DOCTOR OF VETERINARY MEDICINE | 83699.0 | 41.0 | 31111.0 | B | N | 2023.0 |
| 1070 | 1070 | BRA | BRA | 1978.0 | female | Arcadis U.S. Inc. | 570373224.0 | 630 Plaza Dr Ste 200 | Hghlnds Ranch | CO | 80129-2379 | 2023.0 | SELECTED | 0.0 | 6/14/2022 | Approved | 8/26/2022 | ARCADIS U S INC | 1B1 | A | A | 1.0 | F | BRAZI | O1A | SENIOR ENVIRONMENTAL ENGR | 630 PLAZA DR | HIGHLANDS RANCH | CO | 80129.0 | Y | 5190.0 | HOUR | 10/1/2022 | 9/30/2025 | 5031.0 | N | N | H | PROFESSIONAL DEGREE | CIVIL ENGINEERING | 124203.22674832083 | 29.0 | 541620.0 | M | N | 2023.0 |
| 1285 | 1285 | BRA | BRA | 1989.0 | female | Vinson & Elkins L.L.P. | 741183015.0 | 845 Texas Avenue | Houston | TX | 77002-2946 | 2023.0 | SELECTED | 0.0 | 5/5/2022 | Approved | 5/13/2022 | VINSON & ELKINS LLP | 1B1 | A | A | 1.0 | F | BRAZI | UU | ASSOCIATE ATTORNEY | 1114 AVENUE OF THE AMERICAS | NEW YORK | NY | 10036.0 | Y | 295000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1130.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 295000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 1309 | 1309 | BRA | BRA | 1989.0 | male | Gunderson Dettmer Stough Villeneuve Franklin & Hachigian, LLP | 770409988.0 | 550 Allerton St | Redwood City | CA | 94063-1524 | 2023.0 | SELECTED | 0.0 | 6/2/2022 | Approved | 6/9/2022 | GUNDERSON DETTMER STOUGH VILLENEUVE FRANKLIN & HACHIGIAN LLP | 1B1 | A | B | 1.0 | M | BRAZI | F1 | CORPORATE ASSOCIATE | 550 ALLERTON STREET | REDWOOD CITY | CA | 94063.0 | Y | 205000.0 | YEAR | 10/1/2022 | 9/30/2025 | 550.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 205000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 1315 | 1315 | BRA | BRA | 1989.0 | male | Vytelle, LLC | 371788923.0 | 80383 N. Highway 395 | Hermiston | OR | 97838 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Denied | 7/19/2022 | VYTELLE LLC | 1B1 | A | A | 1.0 | M | BRAZI | F1 | BOVINE REPRODUCTIVE SPECIALIST | 80383 N HIGHWAY 395 | HERMISTON | OR | 97838.0 | Y | 65291.0 | YEAR | 10/1/2022 | 9/30/2025 | 87.0 | N | N | H | PROFESSIONAL DEGREE | DOCTOR OF VETERINARY MEDICINE | 65291.0 | 40.0 | 112990.0 | B | N | 2023.0 |
| 1326 | 1326 | BRA | BRA | 1990.0 | female | Lehach & Filippa, LLP | 452815910.0 | 80 Pine St | New York | NY | 10005-1744 | 2023.0 | SELECTED | 0.0 | 5/18/2022 | Approved | 6/25/2022 | LEHACH AND FILIPPA LLP | 1B1 | A | A | 1.0 | F | BRAZI | UN | LAW CLERK | 80 PINE STREET | NEW YORK | NY | 10005.0 | Y | 60000.0 | YEAR | 10/1/2022 | 9/30/2025 | 7.0 | N | N | H | PROFESSIONAL DEGREE | MASTER OF LAWS | 60000.0 | 119.0 | 5411.0 | B | N | 2023.0 |
| 1340 | 1340 | BRA | BRA | 1990.0 | female | Willkie Farr & Gallagher LLP | 135536844.0 | 787 Seventh Avenue | New York | NY | 10019 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 7/8/2022 | WILLKIE FARR & GALLAGHER LLP | 1B1 | A | A | 1.0 | F | BRAZI | F1 | VISITING FOREIGN LAW CLERK | 550 WEST 54TH STREET | NEW YORK | NY | 10019.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1017.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 1354 | 1354 | BRA | BRA | 1990.0 | male | PAG.LAW, PLLC | 842989192.0 | 600 Brickell Ave | Miami | FL | 33131-3076 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 6/27/2022 | PAG LAW PLLC | 1B1 | A | A | 1.0 | M | BRAZI | UN | ASSOCIATE | 110 E 25TH STREET | NEW YORK | NY | 10010.0 | Y | 185000.0 | YEAR | 10/1/2022 | 9/30/2025 | 20.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 185000.0 | 110.0 | 54111.0 | B | N | 2023.0 |
| 1402 | 1402 | BRA | BRA | 1992.0 | female | Erick Magno, P.L. | 202323418.0 | 1200 Brickell Ave | Miami | FL | 33131-3255 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 8/31/2022 | ERICK MAGNO PL DBA MAGNO AND ASSOCIATES PL | 1B1 | A | A | 1.0 | F | BRAZI | F1 | TAZ ASSOCIATE ATTORNEY | 1200 BRICKWELL AVENUE | MIAMI | FL | 33131.0 | Y | 140000.0 | YEAR | 10/1/2022 | 9/30/2025 | 4.0 | N | N | H | PROFESSIONAL DEGREE | LAW AND TAXATION | 140000.0 | 110.0 | 999999.0 | B | N | 2023.0 |
| 1405 | 1405 | BRA | BRA | 1992.0 | female | Goodwin Procter LLP | 41378465.0 | 100 Northern Avenue | Boston | MA | 02210 | 2023.0 | SELECTED | 0.0 | 6/2/2022 | Approved | 6/7/2022 | GOODWIN PROCTER LLP | 1B1 | A | A | 1.0 | F | BRAZI | F1 | ASSOCIATE | 620 EIGHTH AVENUE THE NEW YORK TIMES BUILDING | NEW YORK | NY | 10018.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1169.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 1431 | 1431 | BRA | BRA | 1992.0 | male | White & Case LLP | 135605970.0 | 1221 Avenue Of The Americas | New York | NY | 10020 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/6/2022 | WHITE CASE LLP | 1B1 | A | A | 1.0 | M | BRAZI | F1 | INTERNATIONAL ADVISOR | 555 FLOWER STREET | LOS ANGELES | CA | 90071.0 | Y | 100000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1885.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 100000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 1459 | 1459 | BRA | BRA | 1994.0 | female | Arce Immigration Law, P.A. | 275142365.0 | 1395 Brickell Avenue | Miami | FL | 33131 | 2023.0 | SELECTED | 0.0 | 6/10/2022 | Approved | 6/21/2022 | ARCE IMMIGRATION LAW PA | 1B1 | A | A | 1.0 | F | BRAZI | UU | ASSOCIATE ATTORNEY | 1395 BRICKELL AVE | MIAMI | FL | 33131.0 | Y | 125000.0 | YEAR | 10/1/2022 | 9/30/2025 | 17.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 125000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 1463 | 1463 | BRA | BRA | 1994.0 | female | Davis Polk & Wardwell LLP | 135023295.0 | 450 Lexington Avenue | New York | NY | 10017-3904 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 7/27/2022 | DAVIS POLK WARDWELL LLP | 1B1 | A | B | 1.0 | F | BRAZI | F1 | LEGAL CONSULTANT | 450 LEXINGTON AVENUE | NEW YORK | NY | 10017.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1000.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 215000.0 | 119.0 | 541110.0 | M | N | 2023.0 |
| 1485 | 1485 | BRA | BRA | 1994.0 | male | Nelson Mullins Riley & Scarborough, LLP | 570215445.0 | 201 17th Street Nw | Atlanta | GA | 30363 | 2023.0 | SELECTED | 0.0 | 4/25/2022 | Approved | 5/4/2022 | NELSON MULLINS RILEY & SCARBOROUGH LLP | 1B1 | A | B | 1.0 | M | BRAZI | F1 | SOFTWARE ENGINEER | 2 BISCAYNE BLVD | MIAMI | FL | 33131.0 | Y | 190000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1546.0 | N | N | H | PROFESSIONAL DEGREE | LAW | 190000.0 | 110.0 | 541110.0 | M | N | 2023.0 |
| 1523 | 1523 | BRA | BRA | 1996.0 | female | Rood & Riddle and Partners | 610993798.0 | 2150 Georgetown Rd | Lexington | KY | 40511-9072 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 7/6/2022 | ROOD AND RIDDLE EQUINE HOSPITAL | 1B1 | A | A | 1.0 | F | BRAZI | F1 | VETERINARY INTERN | 5320 SOUTHSORE BLVD | LAKE WORTH | FL | 33449.0 | Y | 42000.0 | YEAR | 10/1/2022 | 9/30/2025 | 424.0 | N | N | H | PROFESSIONAL DEGREE | VETERINARY MEDICINE | 42000.0 | 79.0 | 541940.0 | B | N | 2023.0 |
| 1617 | 1617 | BRA | CRI | 1991.0 | male | Covington & Burling LLP | 530188411.0 | One Citycenter | Washington | DC | 20001 | 2023.0 | SELECTED | 0.0 | 6/3/2022 | Approved | 7/13/2022 | COVINGTON & BURLING LLP | 1B1 | A | B | 1.0 | M | BRAZI | F1 | LAW CLERK | 620 EIGHT AVE | NEW YORK | NY | 10018.0 | Y | 215000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1800.0 | N | N | H | PROFESSIONAL DEGREE | JURIS DOCTOR | 215000.0 | 110.0 | 541110.0 | B | N | 2023.0 |
| 1634 | 1634 | BRB | BRB | 1987.0 | male | VCA INC. | 954097995.0 | 12401 W Olympic Blvd | Los Angeles | CA | 90064 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 6/8/2022 | VCA INC | 1B1 | E | C | 1.0 | M | BARBA | H1B | VETERINARIAN | 5610 KEARNY MESA RD | SAN DIEGO | CA | 92111.0 | Y | 270000.0 | YEAR | 10/1/2022 | 9/30/2025 | 30000.0 | N | N | H | PROFESSIONAL DEGREE | VETERINARY MEDICINE | 270000.0 | 73.0 | 541940.0 | B | N | 2023.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "trk_data" (
"country_of_birth" TEXT,
"country_of_nationality" TEXT,
"ben_year_of_birth" REAL,
"gender" TEXT,
"employer_name" TEXT,
"fein" REAL,
"mail_addr" TEXT,
"city" TEXT,
"state" TEXT,
"zip" TEXT,
"lottery_year" REAL,
"status_type" TEXT,
"ben_multi_reg_ind" REAL,
"rec_date" TEXT,
"first_decision" TEXT,
"first_decision_date" TEXT,
"i129_employer_name" TEXT,
"requested_class" TEXT,
"basis_for_classification" TEXT,
"requested_action" TEXT,
"number_of_beneficiaries" REAL,
"ben_sex" TEXT,
"ben_country_of_birth" TEXT,
"ben_current_class" TEXT,
"job_title" TEXT,
"worksite_street" TEXT,
"worksite_city" TEXT,
"worksite_state" TEXT,
"worksite_zip" REAL,
"full_time_ind" TEXT,
"wage_amt" REAL,
"wage_unit" TEXT,
"valid_from" TEXT,
"valid_to" TEXT,
"num_of_emp_in_us" REAL,
"s1q1a" TEXT,
"s1q1b" TEXT,
"ben_education_code" TEXT,
"ed_level_definition" TEXT,
"ben_pfield_of_study" TEXT,
"ben_comp_paid" REAL,
"dot_code" REAL,
"naics_code" REAL,
"s3q1" TEXT,
"s4q1" TEXT,
"fiscal_year" REAL
);
CREATE INDEX [idx_trk_data_employer_name]
ON [trk_data] ([employer_name]);
CREATE INDEX [idx_trk_data_status_type]
ON [trk_data] ([status_type]);
CREATE INDEX [idx_trk_data_rec_date]
ON [trk_data] ([rec_date]);