trk_data
Data source: Bloomberg FOIA Request
27 rows where ben_comp_paid = "95000.0" and ben_year_of_birth = "1997.0"
This data as json, CSV (advanced)
Suggested facets: country_of_birth, country_of_nationality, gender, fein, mail_addr, city, state, zip, first_decision_date, i129_employer_name, requested_action, ben_sex, ben_country_of_birth, ben_current_class, job_title, worksite_city, worksite_state, worksite_zip, valid_from, valid_to, num_of_emp_in_us, s1q1a, ben_education_code, ed_level_definition, ben_pfield_of_study, dot_code, naics_code, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2999 | 2999 | CHN | CAN | 1997.0 | female | Sirius XM Radio Inc. | 521700207.0 | 1221 Avenue Of The Americas | New York | NY | 10020 | 2023.0 | SELECTED | 0.0 | 5/3/2022 | Approved | 5/12/2022 | SIRIUS XM RADIO INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | Associate Product Analyst | 125 PARK AVE | NEW YORK | NY | 10017.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 4564.0 | N | N | F | BACHELOR'S DEGREE | ANALYTICS | 95000.0 | 199.0 | 515111.0 | B | N | 2023.0 |
| 10619 | 10619 | CHN | CHN | 1997.0 | female | Aetna Resources LLC | 61423207.0 | 1 Cvs Drive | Woonsocket | RI | 02895 | 2023.0 | SELECTED | 0.0 | 5/18/2022 | Approved | 5/31/2022 | AETNA RESOURCES LLC | 1B1 | A | B | 1.0 | F | CHINA | F1 | SOFTWARE ENGINEER | 161 AVENUE OF AMERICAS | NEW YORK | NY | 10013.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 300000.0 | N | N | F | BACHELOR'S DEGREE | APPLIED STATS & DESCISION MAKING | 95000.0 | 20.0 | 524114.0 | B | N | 2023.0 |
| 10623 | 10623 | CHN | CHN | 1997.0 | female | Affirm, Inc. | 455413534.0 | 650 California Street | San Francisco | CA | 94108 | 2023.0 | SELECTED | 0.0 | 5/16/2022 | Approved | 5/19/2022 | AFFIRM INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | FRAUD ANALYST | 10413 CATINGA CT | LAS VEGAS | NV | 89178.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1800.0 | N | N | F | BACHELOR'S DEGREE | BUSINESS ANALYTICS | 95000.0 | 20.0 | 522390.0 | B | N | 2023.0 |
| 10718 | 10718 | CHN | CHN | 1997.0 | female | Bank of America, N.A. | 941687665.0 | 401 N Tryon Street | Charlotte | NC | 28255 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 6/15/2022 | BANK OF AMERICA NA | 1B1 | A | B | 1.0 | F | CHINA | F1 | ANALYST DATA SUPPORT ANALYST | ONE BRYANT PARK | NEW YORK | NY | 10036.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 213000.0 | N | N | F | BACHELOR'S DEGREE | MATHEMATICS ECONOMICS | 95000.0 | 199.0 | 522110.0 | B | N | 2023.0 |
| 10758 | 10758 | CHN | CHN | 1997.0 | female | Caterpillar Inc. | 370602744.0 | 100 Ne Adams St | Peoria | IL | 61629-0001 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 6/30/2022 | CATERPILLAR INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | ASSOCIATE DATA SCIENTIST | 540 W MADISON | CHICAGO | IL | 60661.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 44300.0 | N | N | G | MASTER'S DEGREE | SCIENCE IN ECONOMICS AND SCIENCE IN ANALYTICS | 95000.0 | 20.0 | 333120.0 | B | N | 2023.0 |
| 10814 | 10814 | CHN | CHN | 1997.0 | female | Devz AI Technologies Inc. | 852954763.0 | 95 Spacial | Irvine | CA | 92618 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 8/18/2022 | DEVZ AI TECHNOLOGIES INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | Software Engineer | 95 SPACIAL | IRVINE | CA | 92618.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 12.0 | N | N | G | MASTER'S DEGREE | COMPUTER SCIENCE | 95000.0 | 39.0 | 541511.0 | M | N | 2023.0 |
| 10884 | 10884 | CHN | CHN | 1997.0 | female | Goldman Sachs & Co LLC | 135108880.0 | 30 Hudson Street | Jersey City | NJ | 07302 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Approved | 6/23/2022 | GOLDMAN SACHS CO LLC | 1B1 | A | B | 1.0 | F | CHINA | F1 | ANALYST | 2001 ROSS AVENUE | DALLAS | TX | 75201.0 | Y | 95000.0 | YEAR | 10/1/2022 | 8/3/2025 | 11675.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER ENGINEERING AND ELECTRICAL SCIENCES | 95000.0 | 30.0 | 523110.0 | M | N | 2023.0 |
| 10888 | 10888 | CHN | CHN | 1997.0 | female | Goldman Sachs & Co LLC | 135108880.0 | 30 Hudson Street | Jersey City | NJ | 07302 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 6/28/2022 | GOLDMAN SACHS CO LLC | 1B1 | A | B | 1.0 | F | CHINA | F1 | ANALYST | 30 HUDSON STREET | JERSEY CITY | NJ | 7302.0 | Y | 95000.0 | YEAR | 10/1/2022 | 8/31/2025 | 11675.0 | N | N | F | BACHELOR'S DEGREE | APPLIED ANALYTICS FINANCE AND ACCOUNTING | 95000.0 | 160.0 | 523110.0 | M | N | 2023.0 |
| 10962 | 10962 | CHN | CHN | 1997.0 | female | Insurance Services Office, Inc. | 133131412.0 | 545 Washington Boulevard | Jersey City | NJ | 07310 | 2023.0 | SELECTED | 0.0 | 5/25/2022 | Approved | 6/7/2022 | INSURANCE SERVICES OFFICE INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | DATA SCIENTIST I | TWO AVENUE DE LAFAYETTE | BOSTON | MA | 2111.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 2230.0 | N | N | F | BACHELOR'S DEGREE | BUSINESS ANALYTICS | 95000.0 | 30.0 | 541611.0 | B | N | 2023.0 |
| 10975 | 10975 | CHN | CHN | 1997.0 | female | JPMorgan Chase & Co. | 132624428.0 | 10 S Dearborn St | Chicago | IL | 60603 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/5/2022 | JPMORGAN CHASE CO | 1B1 | A | B | 1.0 | F | CHINA | F1 | ASSOCIATE MODEL RISK AUDITOR | 480 WASHINGTON BOULEVARD | JERSEY CITY | NJ | 7310.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 168267.0 | N | N | G | MASTER'S DEGREE | COMPUTATIONAL FINANCE | 95000.0 | 160.0 | 551112.0 | M | N | 2023.0 |
| 11094 | 11094 | CHN | CHN | 1997.0 | female | NovaGigs, Inc. | 815281550.0 | 1765 Greensboro Station Place | Mclean | VA | 22102 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 8/10/2022 | NOVAGIGS INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | SOFTWARE ENGINEER | 151 CENTER STREET BAY | BAYONNE | NJ | 7002.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 22.0 | N | N | F | BACHELOR'S DEGREE | HEALTH POLICY & ECONOMICS | 95000.0 | 39.0 | 519190.0 | M | N | 2023.0 |
| 11098 | 11098 | CHN | CHN | 1997.0 | female | Offit Capital | 260271563.0 | 485 Lexington Ave | New York | NY | 10017-2640 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 7/8/2022 | OFFIT CAPITAL | 1B1 | A | B | 1.0 | F | CHINA | F1 | ASSOCIATE RESEARCH GROUP | 606 WEST 57TH STREET | NEW YORK | NY | 10019.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 61.0 | N | N | G | MASTER'S DEGREE | OPERATIONS RESEARCH | 95000.0 | 20.0 | 52399.0 | M | N | 2023.0 |
| 11186 | 11186 | CHN | CHN | 1997.0 | female | Slalom, LLC | 841246887.0 | 821 2nd Ave | Seattle | WA | 98104-1526 | 2023.0 | SELECTED | 0.0 | 5/27/2022 | Approved | 6/9/2022 | SLALOM LLC | 1B1 | A | B | 1.0 | F | CHINA | F1 | SOFTWARE ENGINEER | 821 2ND AVE | SEATTLE | WA | 98104.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 9101.0 | N | N | F | BACHELOR'S DEGREE | MFA PRODUCTS OF DESIGN | 95000.0 | 30.0 | 541611.0 | B | N | 2023.0 |
| 11635 | 11635 | CHN | CHN | 1997.0 | male | Guidewire Software, Inc. | 364468504.0 | 2850 S Delaware St | San Mateo | CA | 94403-2575 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Approved | 6/23/2022 | GUIDEWIRE SOFTWARE INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | SOFTWARE ENGINEER II | 7911 WESTPARK DRIVE | MC LEAN | VA | 22102.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1699.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER ENGINEERING | 95000.0 | 30.0 | 511210.0 | B | N | 2023.0 |
| 11801 | 11801 | CHN | CHN | 1997.0 | male | Red Hat, Inc. | 61364380.0 | 100 E Davie St | Raleigh | NC | 27601-1806 | 2023.0 | SELECTED | 0.0 | 5/24/2022 | Approved | 5/31/2022 | RED HAT INC | 1B1 | A | A | 1.0 | M | CHINA | F1 | SOFTWARE QUALITY ENGINEER | 100 EAST DAVIE STREET | RALEIGH | NC | 27601.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 13360.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE BIOCHEMISTRY | 95000.0 | 30.0 | 541512.0 | B | N | 2023.0 |
| 11830 | 11830 | CHN | CHN | 1997.0 | male | Sumitomo Mitsui Banking Corporation | 135611820.0 | 277 Park Avenue | New York | NY | 10172 | 2023.0 | SELECTED | 0.0 | 6/6/2022 | Approved | 6/13/2022 | SUMITOMO MITSUI BANKING CORPORATION | 1B1 | A | B | 1.0 | M | CHINA | F1 | MODEL VALIDATION ANALYST | 110 RIVER DR S | JERSEY CITY | NJ | 7310.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 1233.0 | N | N | F | BACHELOR'S DEGREE | FINANCIAL ENGINEERING | 95000.0 | 20.0 | 522110.0 | M | N | 2023.0 |
| 11847 | 11847 | CHN | CHN | 1997.0 | male | The Predictive Index, LLC | 611748187.0 | 101 Station Drive | Westwood | MA | 02090 | 2023.0 | SELECTED | 0.0 | 4/26/2022 | Approved | 5/2/2022 | THE PREDICTIVE INDEX LLC | 1B1 | A | B | 1.0 | M | CHINA | F1 | SOFTWARE ENGINEER I | 101 STATION DRIVE | WESTWOOD | MA | 2090.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 218.0 | N | N | G | MASTER'S DEGREE | COMPUTER SCIENCE | 95000.0 | 30.0 | 541612.0 | M | N | 2023.0 |
| 11864 | 11864 | CHN | CHN | 1997.0 | male | UBS Securities LLC | 133873456.0 | 315 Deaderick Street | Nashville | TN | 37238 | 2023.0 | SELECTED | 0.0 | 5/17/2022 | Approved | 7/19/2022 | UBS SECURITIES LLC | 1B1 | A | B | 1.0 | M | CHINA | F1 | ANALYST GLOBAL MARKETS | 2244 JACKSON AVE | LONG ISLAND CITY | NY | 11101.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 60000.0 | N | N | G | MASTER'S DEGREE | COMPUTATIONAL FINANCE | 95000.0 | 160.0 | 523150.0 | M | N | 2023.0 |
| 13632 | 13632 | DEU | DEU | 1997.0 | male | Kaia Health Software, Inc. | 814384042.0 | 220 E 20th St | New York | NY | 10003 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Approved | 8/1/2022 | KAIA HEALTH SOFTWARE INC | 1B1 | A | B | 1.0 | M | GERMA | F1 | SENIOR ASSOCICATE SALES ENABLEMENT | 500 7TH AVENUE | NEW YORK | NY | 10018.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 90.0 | N | N | G | MASTER'S DEGREE | BIOENGINEERING | 95000.0 | 19.0 | 621999.0 | M | N | 2023.0 |
| 14071 | 14071 | ESP | ESP | 1997.0 | female | FTI LLC | 342025396.0 | 16701 Melford Boulevard | Bowie | MD | 20715 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 6/7/2022 | FTI LLC | 1B1 | A | A | 1.0 | F | SPAIN | F1 | BUSINESS ANALYST DP | 16701 MELFORD BLVD | BOWIE | MD | 20715.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 3146.0 | N | N | F | BACHELOR'S DEGREE | COMPUTATIONAL DESIGN SCIENCE OPERATIONS RESEARCH | 95000.0 | 20.0 | 541611.0 | B | N | 2023.0 |
| 14115 | 14115 | ESP | NLD | 1997.0 | male | Bregal Investments Inc. | 371466019.0 | 277 Park Avenue | New York | NY | 10172 | 2023.0 | SELECTED | 0.0 | 5/4/2022 | Approved | 7/21/2022 | BREGAL INVESTMENTS INC | 1B1 | A | A | 1.0 | M | SPAIN | UU | SOFTWARE ENGINEER | 277 PARK AVE | NEW YORK | NY | 10172.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/26/2025 | 43.0 | N | N | F | BACHELOR'S DEGREE | POLITICS PHILOSOPHY & ECONOMICS | 95000.0 | 169.0 | 523999.0 | B | N | 2023.0 |
| 15205 | 15205 | HKG | CAN | 1997.0 | female | SessionM, Inc. | 273259827.0 | 225 Franklin Street | Boston | MA | 02110 | 2023.0 | SELECTED | 0.0 | 5/24/2022 | Approved | 6/2/2022 | SESSIONM INC | 1B1 | A | A | 1.0 | F | HONGK | TN | CONSULTANT ADVISORS CLIENT SERVICES | 595 TREMONT ST | BOSTON | MA | 2118.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 8400.0 | N | N | F | BACHELOR'S DEGREE | BUSINESS | 95000.0 | 30.0 | 522210.0 | B | N | 2023.0 |
| 17055 | 17055 | KAZ | KAZ | 1997.0 | female | Morgan Stanley Fund Services Inc. | 201768995.0 | 1585 Broadway | New York | NY | 10036 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 9/14/2022 | MORGAN STANLEY FUND SERVICES INC | 1B1 | A | B | 1.0 | F | KAZAK | F1 | Associate | 1221 AVENUE OF THE AMERICAS | NEW YORK | NY | 10020.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 47201.0 | N | N | F | BACHELOR'S DEGREE | FINANCE | 95000.0 | 186.0 | 523110.0 | M | N | 2023.0 |
| 20583 | 20583 | NPL | NPL | 1997.0 | female | Eficens Systems LLC | 843443670.0 | 5400 Laurel Springs Parkway | Suwanee | GA | 30024 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 12/5/2022 | EFICENS SYSTEMS LLC | 1B1 | A | B | 1.0 | F | NEPAL | F1 | SOFTWARE DEVOPS ENGINEER | 2525 TX 360 | EULESS | TX | 76039.0 | Y | 95000.0 | YEAR | 12/5/2022 | 9/30/2025 | 832.0 | Y | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 95000.0 | 30.0 | 5416.0 | B | Y | 2023.0 |
| 20594 | 20594 | NPL | NPL | 1997.0 | female | Signature Commercial Solutions LLC | 270221186.0 | 200 W Cypress Creek Rd | Ft Lauderdale | FL | 33309-2175 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/15/2022 | SIGNATURE COMMERCIAL SOLUTIONS LLC DBA SIGNATURE CONSULTANTS | 1B1 | A | B | 1.0 | F | NEPAL | F1 | AUTOMATION ENGINEER APPLIC DEVELOPER JAVA LEAD SOFTWARE DEV | 8270 GREENSBORO DRIVE | MCLEAN | VA | 22102.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 2000.0 | N | N | F | BACHELOR'S DEGREE | INFORMATION SYSTEMS | 95000.0 | 30.0 | 541511.0 | B | Y | 2023.0 |
| 20614 | 20614 | NPL | NPL | 1997.0 | male | Eficens Systems LLC | 843443670.0 | 5400 Laurel Springs Parkway | Suwanee | GA | 30024 | 2023.0 | SELECTED | 0.0 | 6/28/2022 | Approved | 7/19/2022 | EFICENS SYSTEMS LLC | 1B1 | A | B | 1.0 | M | NEPAL | F1 | SOFTWARE DEVOPS ENGINEER | 5400 LAUREL SPRINGS PARKWAY | SUWANEE | GA | 30024.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 832.0 | Y | N | F | BACHELOR'S DEGREE | INFORMATION SYSTEMS | 95000.0 | 30.0 | 5416.0 | B | Y | 2023.0 |
| 20625 | 20625 | NPL | NPL | 1997.0 | male | MOODY'S SHARED SERVICES, INC. | 273263953.0 | 7 World Trade Center, 250 Greenwich St | New York | NY | 10007 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/5/2022 | MOODYS SHARED SERVICES INC | 1B1 | A | B | 1.0 | M | NEPAL | F1 | SOFTWARE ENGINEER | 1101 PENNSYLVANIA AVE NW | WASHINGTON | DC | 20004.0 | Y | 95000.0 | YEAR | 10/1/2022 | 9/30/2025 | 774.0 | N | N | F | BACHELOR'S DEGREE | ECONOMICS | 95000.0 | 199.0 | 56145.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]);