trk_data
Data source: Bloomberg FOIA Request
73 rows where city = "Plano", first_decision = "Approved" and s1q1b = "N"
This data as json, CSV (advanced)
Suggested facets: country_of_birth, country_of_nationality, ben_year_of_birth, gender, zip, ben_multi_reg_ind, requested_action, number_of_beneficiaries, ben_sex, ben_country_of_birth, ben_current_class, worksite_city, worksite_state, worksite_zip, full_time_ind, valid_from, valid_to, s1q1a, ben_education_code, ed_level_definition, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 216 | 216 | ARM | ARM | 1983.0 | male | Siemens Industry Software Inc. | 752728894.0 | 5800 Granite Pkwy | Plano | TX | 75024-6612 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Approved | 6/24/2022 | SIEMENS INDUSTRY SOFTWARE INC | 1B1 | A | A | 1.0 | M | ARMEN | L1B | SOFTWARE ENGINEER SENIOR SOFTWARE SENIOR SENIOR | 19325 ROBIN CR | WEST LINN | OR | 97068.0 | Y | 137426.0 | YEAR | 10/1/2022 | 9/30/2025 | 6500.0 | N | N | G | MASTER'S DEGREE | Computer Science and Applied Mathematics | 137426.0 | 30.0 | 511210.0 | B | N | 2023.0 |
| 1067 | 1067 | BRA | BRA | 1977.0 | male | Ribbon Communications Operating Company, Inc. | 43387074.0 | 6500 Chase Oaks Blvd. | Plano | TX | 75023 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 7/8/2022 | RIBBON COMMUNICATIONS OPERATING COMPANY INC | 1B1 | A | B | 1.0 | M | BRAZI | L1B | SOFTWARE ENGINEER | 6500 CHASE OAKS BLVD. | PLANO | TX | 75023.0 | Y | 110162.0 | YEAR | 10/1/2022 | 9/30/2025 | 920.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING | 110162.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 1083 | 1083 | BRA | BRA | 1979.0 | male | Forescout Technologies, Inc. | 510406800.0 | 2400 Dallas Pkwy | Plano | TX | 75093-4371 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 9/30/2022 | FORESCOUT TECHNOLOGIES INC | 1B1 | A | A | 0.9999597536925987 | M | BRAZI | F1 | VICE PRESIDENT OF ECOSYTEM | 3652 FALCON RIDGE CIRCLE | WESTON | FL | 33331.0 | Y | 168750.0 | YEAR | 10/1/2022 | 9/30/2025 | 460.0 | N | N | F | BACHELOR'S DEGREE | MANAGEMENT INFORMATION SYSTEMS | 168750.0 | 30.0 | 541519.0 | B | N | 2023.0 |
| 1678 | 1678 | CAN | CAN | 1972.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/6/2022 | Approved | 9/14/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | CANAD | TN | ASIC DEVELOPER | 1703 W 5TH STREET | AUSTIN | TX | 78703.0 | Y | 215840.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING | 215840.0 | 3.0 | 334220.0 | B | N | 2023.0 |
| 2036 | 2036 | CAN | CAN | 1992.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 5/13/2022 | Approved | 7/25/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | CANAD | F1 | SOFTWARE ENGINEER | 2755 AUGUSTINE DR | SANTA CLARA | CA | 95054.0 | Y | 160371.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | I | DOCTORATE DEGREE | PHYSICS | 160371.0 | 30.0 | 33422.0 | M | N | 2023.0 |
| 3819 | 3819 | CHN | CHN | 1988.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/6/2022 | Approved | 9/12/2022 | ERICSSON INC | 1B1 | A | A | 1.0 | M | CHINA | L1B | BASEBAND SOFTWARE DEVELOPER | 1703 W 5TH ST | AUSTIN | TX | 78703.0 | Y | 153000.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | COMMUNICATION ENGINEERING AND INFORMATION SYSTEMS | 153000.0 | 3.0 | 33422.0 | B | N | 2023.0 |
| 3897 | 3897 | CHN | CHN | 1988.0 | male | Siemens Industry Software Inc. | 752728894.0 | 5800 Granite Pkwy | Plano | TX | 75024-6612 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 7/1/2022 | SIEMENS INDUSTRY SOFTWARE INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | SOFTWARE ENGINEER | 200 FIFTH AVENUE | WALTHAM | MA | 2451.0 | Y | 126723.0 | YEAR | 10/1/2022 | 9/30/2025 | 6500.0 | N | N | G | MASTER'S DEGREE | ELECTRICAL COMPUTER ENGINEERING | 126723.0 | 30.0 | 511210.0 | M | N | 2023.0 |
| 4100 | 4100 | CHN | CHN | 1989.0 | male | Brook Telecom Solutions Inc | 470881485.0 | 2500 N. Dallas Pkway | Plano | TX | 75093 | 2023.0 | SELECTED | 0.0 | 6/6/2022 | Approved | 11/18/2022 | BROOK TELECOM SOLUTIONS INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | FIELD TESTING ENGINEER | 2500 N DALLAS PKWAY | PLANO | TX | 75093.0 | Y | 58178.0 | YEAR | 11/18/2022 | 9/30/2025 | 103.0 | N | N | I | DOCTORATE DEGREE | MECHNICAL ENGINEERING | 58178.0 | 30.0 | 541512.0 | M | Y | 2023.0 |
| 4240 | 4240 | CHN | CHN | 1989.0 | male | Tinno USA Inc | 822924922.0 | 2301 W Plano Pkwy | Plano | TX | 75075-8438 | 2023.0 | SELECTED | 1.0 | 5/12/2022 | Approved | 8/16/2022 | TINNO USA INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | mobile device test engineer | 655 N CENTRAL AVE | GLENDALE | CA | 91203.0 | Y | 50400.0 | YEAR | 10/1/2022 | 9/30/2025 | 35.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 50400.0 | 33.0 | 423620.0 | M | N | 2023.0 |
| 4365 | 4365 | CHN | CHN | 1990.0 | female | Jeff Pickering, CPA | 752854099.0 | 6525 Preston Rd | Plano | TX | 75024-2610 | 2023.0 | SELECTED | 1.0 | 5/17/2022 | Approved | 7/13/2022 | JEFF PICKERING CPA | 1B1 | A | B | 1.0 | F | CHINA | F1 | STAFF ACCOUNTANT | 6525 PRESTON RD | PLANO | TX | 56905.48740771989 | Y | 55000.0 | YEAR | 10/1/2022 | 9/30/2025 | 10.0 | N | N | G | MASTER'S DEGREE | ACCOUNTING | 55000.0 | 160.0 | 541211.0 | M | N | 2023.0 |
| 4455 | 4455 | CHN | CHN | 1990.0 | female | Wintex Group LLC | 562381466.0 | 4888 Dexter Dr | Plano | TX | 75093-5505 | 2023.0 | SELECTED | 0.0 | 5/2/2022 | Approved | 8/5/2022 | WINTEX GROUP LLC DBA FIRST LENDING | 1B1 | A | B | 1.0 | F | CHINA | F1 | SOFTWARE ENGINEER | 4888 DEXTER DR | PLANO | TX | 75093.0 | Y | 63565.0 | YEAR | 10/1/2022 | 9/30/2025 | 12.0 | N | N | F | BACHELOR'S DEGREE | BUSINESS ANALYTICS | 63565.0 | 160.0 | 522310.0 | B | N | 2023.0 |
| 4917 | 4917 | CHN | CHN | 1991.0 | female | Toyota Tsusho Systems US Inc. | 450997587.0 | 5850 Granite Parkway | Plano | TX | 75024 | 2023.0 | SELECTED | 1.0 | 4/25/2022 | Approved | 7/18/2022 | TOYOTA TSUSHO SYSTEMS US INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | Data Analyst | 5850 GRANITE PKWY | PLANO | TX | 75024.0 | Y | 67475.0 | YEAR | 10/1/2022 | 9/30/2025 | 66.0 | N | N | F | BACHELOR'S DEGREE | MS IN BUS ANALYTICS BS IN INFO SYS | 67475.0 | 30.0 | 541511.0 | M | N | 2023.0 |
| 5540 | 5540 | CHN | CHN | 1992.0 | female | Wintex Group LLC | 562381466.0 | 4888 Dexter Dr | Plano | TX | 75093-5505 | 2023.0 | SELECTED | 0.0 | 5/12/2022 | Approved | 8/11/2022 | WINTEX GROUP LLC DBA FIRST LENDING | 1B1 | A | B | 1.0 | F | CHINA | F1 | CREDIT ANALYST | 4888 DEXTER DRIVE | PLANO | TX | 56905.48740771989 | N | 31782.0 | YEAR | 10/1/2022 | 9/30/2025 | 12.0 | N | N | G | MASTER'S DEGREE | FINANCE INFORMATION TECHNOLOGY MANAGEMENT | 31782.0 | 160.0 | 522310.0 | B | N | 2023.0 |
| 6324 | 6324 | CHN | CHN | 1993.0 | female | Toyota Motor North America, Inc. | 611310582.0 | 6565 Headquarters Drive | Plano | TX | 75024 | 2023.0 | SELECTED | 0.0 | 4/29/2022 | Approved | 9/7/2022 | TOYOTA MOTOR NORTH AMERICA INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | Senior Research Scientist | 1555 WOODRIDGE AVE | ANN ARBOR | MI | 48105.0 | Y | 125000.0 | YEAR | 10/1/2022 | 9/30/2025 | 36000.0 | N | N | I | DOCTORATE DEGREE | CHEMICAL ENGINEERING | 125000.0 | 19.0 | 336111.0 | M | N | 2023.0 |
| 6757 | 6757 | CHN | CHN | 1993.0 | male | Tinno USA Inc | 822924922.0 | 2301 W Plano Pkwy | Plano | TX | 75075-8438 | 2023.0 | SELECTED | 1.0 | 5/6/2022 | Approved | 5/26/2022 | TINNO USA INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | ACCOUNTANT | 2301 W PLANO PKWY | PLANO | TX | 75075.0 | Y | 56000.0 | YEAR | 10/1/2022 | 9/30/2025 | 35.0 | N | N | F | BACHELOR'S DEGREE | ACCOUNTING | 56000.0 | 160.0 | 423620.0 | B | N | 2023.0 |
| 7459 | 7459 | CHN | CHN | 1994.0 | male | Brook Telecom Solutions Inc | 470881485.0 | 2500 N. Dallas Pkway | Plano | TX | 75093 | 2023.0 | SELECTED | 0.0 | 5/26/2022 | Approved | 6/10/2022 | BROOK TELECOM SOLUTIONS INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | SOFTWARE QUALITY ASSURANCE ENGINEER | 2500 N DALLAS PKWAY | PLANO | TX | 75093.0 | Y | 60000.0 | YEAR | 10/1/2022 | 9/30/2025 | 103.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 60000.0 | 30.0 | 541512.0 | M | Y | 2023.0 |
| 8101 | 8101 | CHN | CHN | 1995.0 | female | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/13/2022 | Approved | 7/5/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | BASEBAND SOFTWARE DEVELOPER | 1703 W 5TH ST | AUSTIN | TX | 78703.0 | Y | 110313.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 110313.0 | 30.0 | 33422.0 | B | N | 2023.0 |
| 8704 | 8704 | CHN | CHN | 1995.0 | male | Brook Telecom Solutions Inc | 470881485.0 | 2500 N. Dallas Pkway | Plano | TX | 75093 | 2023.0 | SELECTED | 0.0 | 4/18/2022 | Approved | 5/23/2022 | BROOK TELECOM SOLUTIONS INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | FIELD TESTING ENGINEER | 16779 RIVER VIEW CIR | BRISTOL | PA | 56905.48740771989 | N | 63000.0 | YEAR | 10/1/2022 | 8/26/2025 | 103.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING | 63000.0 | 39.0 | 541512.0 | B | N | 2023.0 |
| 8705 | 8705 | CHN | CHN | 1995.0 | male | Brook Telecom Solutions Inc | 470881485.0 | 2500 N. Dallas Pkway | Plano | TX | 75093 | 2023.0 | SELECTED | 0.0 | 5/25/2022 | Approved | 6/25/2022 | BROOK TELECOM SOLUTIONS INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | FIELD TESTING ENGINEER | 2500 N DALLAS PKWAY | PLANO | TX | 75093.0 | Y | 58178.0 | YEAR | 10/1/2022 | 9/30/2025 | 103.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING | 58178.0 | 30.0 | 541512.0 | M | N | 2023.0 |
| 8754 | 8754 | CHN | CHN | 1995.0 | male | DSI Telecom Inc | 990381313.0 | 1400 Preston Rd | Plano | TX | 75093 | 2023.0 | SELECTED | 0.0 | 6/13/2022 | Approved | 6/24/2022 | DSI TELECOM INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | System Engineer 5G | 1400 PRESTON RD | PLANO | TX | 75093.0 | Y | 76856.0 | YEAR | 10/1/2022 | 9/30/2025 | 64.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 76856.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 9316 | 9316 | CHN | CHN | 1996.0 | female | Brook Telecom Solutions Inc | 470881485.0 | 2500 N. Dallas Pkway | Plano | TX | 75093 | 2023.0 | SELECTED | 0.0 | 5/26/2022 | Approved | 8/9/2022 | BROOK TELECOM SOLUTIONS INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | Field Testing Engineer | 2500 N DALLAS PKWAY | PLANO | TX | 75093.0 | Y | 58094.0 | YEAR | 10/1/2022 | 9/30/2025 | 103.0 | N | N | G | MASTER'S DEGREE | SECURITY INFORMATICS | 58094.0 | 30.0 | 541512.0 | M | N | 2023.0 |
| 10294 | 10294 | CHN | CHN | 1996.0 | male | GuruFocus.com LLC | 593814873.0 | 1309 W 15th St | Plano | TX | 75075-7244 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 8/15/2022 | GURUFOCUS COM LLC | 1B1 | A | B | 1.0 | M | CHINA | F1 | APPLICATIONS SOFTWARE DEVELOPER | 1309 W 15TH ST | PLANO | TX | 75075.0 | Y | 92000.0 | YEAR | 10/1/2022 | 9/30/2025 | 14.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 92000.0 | 30.0 | 519190.0 | B | N | 2023.0 |
| 10939 | 10939 | CHN | CHN | 1997.0 | female | GuruFocus.com LLC | 593814873.0 | 1309 W 15th St | Plano | TX | 75075-7244 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 7/16/2022 | GURUFOCUS COM LLC | 1B1 | A | B | 1.0 | F | CHINA | F1 | OPERATIONS RESEARCH ANALYST | 1309 W 15TH ST | PLANO | TX | 75075.0 | Y | 55869.0 | YEAR | 10/1/2022 | 9/30/2025 | 14.0 | N | N | G | MASTER'S DEGREE | ECONOMICS MASTER OF SCIENCE | 55869.0 | 20.0 | 519190.0 | M | N | 2023.0 |
| 11179 | 11179 | CHN | CHN | 1997.0 | female | Silicon, Inc. | 842350814.0 | 1255 W 15th St | Plano | TX | 75075-7254 | 2023.0 | SELECTED | 0.0 | 6/16/2022 | Approved | 10/24/2022 | SILICON INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | BUSINESS INTELLIGENCE ANALYST | 1255 W 15TH ST | PLANO | TX | 56905.48740771989 | Y | 58178.0 | YEAR | 10/24/2022 | 9/30/2025 | 11.0 | N | N | F | BACHELOR'S DEGREE | DIGITAL AGE TEACHING AND LEARNING BUSINESS ECONOMICS | 58178.0 | 39.0 | 541511.0 | B | N | 2023.0 |
| 13827 | 13827 | EGY | EGY | 1983.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/10/2022 | Approved | 8/8/2022 | ERICSSON INC | 1B1 | A | A | 1.0 | M | EGYPT | L1B | ENGINEER SERVICES RF | 6300 LEGACY DRIVE | PLANO | TX | 75024.0 | Y | 154500.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | ELECTRONICS AND ELECTRICAL COMMUNICATIONS ENGINEERING | 154500.0 | 3.0 | 33422.0 | B | Y | 2023.0 |
| 15396 | 15396 | HRV | HRV | 1971.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 5/12/2022 | Approved | 8/25/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | CROAT | L1B | Engineer - Systems | 2755 AUGUSTINE DR | SANTA CLARA | CA | 95054.0 | Y | 157512.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING IN THE FIELD OF ELECTRONICS AND AUTOMATION | 157512.0 | 3.0 | 33422.0 | B | N | 2023.0 |
| 15529 | 15529 | IDN | IDN | 1998.0 | female | Zeva Technology LLC | 752962087.0 | 5068 W Plano Pkwy | Plano | TX | 75093-5051 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 7/12/2022 | ZEVA TECHNOLOGY LLC | 1B1 | A | B | 0.9999597536925987 | F | INDON | F1 | HUMAN RESOURCES SPECIALIST | 5068 W PLANO PARKWAY | PLANO | TX | 75093.0 | Y | 52000.0 | YEAR | 10/1/2022 | 9/30/2025 | 43.0 | N | N | F | BACHELOR'S DEGREE | COMMUNICATION | 52000.0 | 166.0 | 541512.0 | B | N | 2023.0 |
| 15549 | 15549 | IDN | IDN | 1999.0 | male | Evantage, Inc | 571231596.0 | 5000 Legacy Dr | Plano | TX | 75024-3189 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 8/13/2022 | EVANTAGE INC | 1B1 | A | B | 1.0 | M | INDON | F1 | SOFTWARE ENGINEER | 5000 LEGACY DR | PLANO | TX | 75024.0 | Y | 47819.0 | YEAR | 10/1/2022 | 9/30/2025 | 17.0 | N | N | F | BACHELOR'S DEGREE | FINANCE | 47819.0 | 50.0 | 541613.0 | B | N | 2023.0 |
| 16122 | 16122 | IRN | CAN | 1967.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 5/23/2022 | Approved | 8/30/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | IRAN | TN | Android developer | 12655 W JEFFERSON BLVD | LOS ANGELES | CA | 90066.0 | Y | 150280.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 150280.0 | 30.0 | 33422.0 | B | N | 2023.0 |
| 16632 | 16632 | ITA | ITA | 1989.0 | male | Inogen | 330989359.0 | 600 Shiloh Rd | Plano | TX | 75074 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 6/28/2022 | INOGEN | 1B1 | A | B | 1.0 | M | ITALY | F1 | MARKETING DATA SR ANALYST | 301 COROMAR DR | GOLETA | CA | 93117.0 | Y | 114000.0 | YEAR | 10/1/2022 | 9/30/2025 | 965.0 | N | N | F | BACHELOR'S DEGREE | BUSINESS ANALYTICS | 114000.0 | 31.0 | 33312.0 | M | N | 2023.0 |
| 16797 | 16797 | JOR | JOR | 1987.0 | male | Tyler Technologies, INC. | 752303920.0 | 5101 Tennyson Pkwy | Plano | TX | 75024 | 2023.0 | SELECTED | 0.0 | 6/14/2022 | Approved | 7/13/2022 | TYLER TECHNOLOGIES INC | 1B1 | A | B | 1.0 | M | JORDA | F1 | SENIOR SOFTWARE ENGINEER | 5101 TENNYSON PKWY | PLANO | TX | 75024.0 | Y | 98093.0 | YEAR | 10/1/2022 | 9/30/2025 | 6058.0 | N | N | F | BACHELOR'S DEGREE | SOFTWARE ENGINEER | 98093.0 | 30.0 | 5415.0 | B | N | 2023.0 |
| 17600 | 17600 | KOR | KOR | 1992.0 | female | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 5/20/2022 | Approved | 7/23/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | F | SKORE | F1 | ASIC DEVELOPER | 1703 W 5TH ST | AUSTIN | TX | 78703.0 | Y | 128750.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | G | MASTER'S DEGREE | ELECTRICAL AND COMPUTER ENGINEERING | 128750.0 | 3.0 | 334220.0 | B | N | 2023.0 |
| 18081 | 18081 | LBN | LBN | 1987.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/6/2022 | Approved | 8/24/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | LEBAN | L1B | SOFTWARE ENGINEER | 6300 LEGACY DRIVE | PLANO | TX | 75024.0 | Y | 134828.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER COMMUNICATION ENGINEERING | 134828.0 | 30.0 | 33422.0 | B | N | 2023.0 |
| 18495 | 18495 | MEX | MEX | 1979.0 | male | Enseo, Inc. | 752859189.0 | 2201 10th Street | Plano | TX | 75074 | 2023.0 | SELECTED | 0.0 | 5/2/2022 | Approved | 7/6/2022 | ENSEO INC | 1B1 | A | B | 1.0 | M | MEXIC | TN2 | SENIOR SOFTWARE ENGINEER | 2201 10TH STREET | PLANO | TX | 75074.0 | Y | 137800.0 | YEAR | 10/1/2022 | 9/30/2025 | 102.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER SCIENCE | 137800.0 | 39.0 | 334515.0 | B | N | 2023.0 |
| 18645 | 18645 | MEX | MEX | 1985.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/10/2022 | Approved | 9/27/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | MEXIC | TN | SOFTWARE ENGINEER | 2755 AUGUSTINE DRIVE | SANTA CLARA | CA | 95054.0 | Y | 157500.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER ENGINEERING | 157500.0 | 30.0 | 334220.0 | B | N | 2023.0 |
| 18657 | 18657 | MEX | MEX | 1985.0 | male | Ribbon Communications Operating Company, Inc. | 43387074.0 | 6500 Chase Oaks Blvd. | Plano | TX | 75023 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 9/28/2022 | RIBBON COMMUNICATIONS OPERATING COMPANY INC | 1B1 | A | B | 1.0 | M | MEXIC | L1B | FIELD SUPPORT ENGINEERING TECHNICAL SPECIALIST | 5100 NW 33RD AVE | FORT LAUDERDALE | FL | 33309.0 | Y | 90000.0 | YEAR | 10/1/2022 | 9/30/2025 | 929.0 | N | N | F | BACHELOR'S DEGREE | ELECTRONICS ENGINEERING | 90000.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 18807 | 18807 | MEX | MEX | 1989.0 | female | Siemens Industry Software Inc. | 752728894.0 | 5800 Granite Pkwy | Plano | TX | 75024-6612 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 7/6/2022 | SIEMENS INDUSTRY SOFTWARE INC | 1B1 | A | A | 1.0 | F | MEXIC | L1B | APPLICATION SUPPORT ENGINEER ADVANCED | 100 TECHNOLOGY DR | ALPHARETTA | GA | 30005.0 | Y | 91375.0 | YEAR | 10/1/2022 | 9/30/2025 | 6500.0 | N | N | D | 1 OR MORE YEARS OF COLLEGE, NO DEGREE | MECHANICAL ENGINEERING | 91375.0 | 7.0 | 511210.0 | B | N | 2023.0 |
| 18865 | 18865 | MEX | MEX | 1990.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 9/22/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | MEXIC | TN2 | Network Support Engineer | 6300 LEGACY DR | PLANO | TX | 75024.0 | Y | 108150.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | ELECTRONICS ENGINEERING | 108150.0 | 3.0 | 33422.0 | B | N | 2023.0 |
| 18866 | 18866 | MEX | MEX | 1990.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 6/23/2022 | Approved | 10/31/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | MEXIC | TN | ASIC DEVELOPER | 1703 W 5TH ST | AUSTIN | TX | 78703.0 | Y | 145000.0 | YEAR | 10/31/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | COMMUNICATIONS AND ELECTRONICS ENGINEERING | 145000.0 | 3.0 | 334220.0 | B | N | 2023.0 |
| 18867 | 18867 | MEX | MEX | 1990.0 | male | Facility Interiors, Inc. | 752522490.0 | 6100 W Plano Pkwy | Plano | TX | 75093-8365 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 9/6/2022 | FACILITY INTERIORS INC | 1B1 | A | A | 1.0 | M | MEXIC | TN2 | Solutions Analyst | 1440 NORTH POST OAK ROAD | HOUSTON | TX | 77055.0 | Y | 71600.0 | YEAR | 10/1/2022 | 9/30/2025 | 55.0 | N | N | F | BACHELOR'S DEGREE | INDUSTRIAL ENGINEERING | 71600.0 | 12.0 | 423200.0 | B | N | 2023.0 |
| 19575 | 19575 | NGA | NGA | 1984.0 | male | Benchmark Payroll and Benefits, LLC | 202050387.0 | 5160 Tennyson Pkwy | Plano | TX | 75024-4355 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 9/12/2022 | BENCHMARK PAYROLL AND BENEFITS LLC | 1B1 | A | B | 1.0 | M | NIGIA | F1 | INTERNAL IT AUDITOR | 4450 S RIDGE ROAD | MCKINNEY | TX | 75070.0 | Y | 90000.0 | YEAR | 10/1/2022 | 9/30/2025 | 388.0 | N | N | F | BACHELOR'S DEGREE | MASTER IN TECHNOLOGY MANAGEMENT | 90000.0 | 39.0 | 522310.0 | M | N | 2023.0 |
| 19593 | 19593 | NGA | NGA | 1985.0 | male | Ericsson Inc. | 61119960.0 | 6300 Legacy Dr | Plano | TX | 75024-3607 | 2023.0 | SELECTED | 0.0 | 5/26/2022 | Approved | 6/8/2022 | ERICSSON INC | 1B1 | A | B | 1.0 | M | NIGIA | F1 | EGMS COMPLIANCE SPECIALIST | 6300 LEGACY DR | PLANO | TX | 56905.48740771989 | Y | 104030.0 | YEAR | 10/1/2022 | 9/30/2025 | 7596.0 | N | N | F | BACHELOR'S DEGREE | BUSINESS ADMINISTRATION | 104030.0 | 161.0 | 334220.0 | M | N | 2023.0 |
| 20091 | 20091 | NPL | NPL | 1976.0 | male | Desmata Inc | 455278274.0 | 5151 Headquarters Dr | Plano | TX | 75024 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 1/19/2023 | DESMATA INC | 1B1 | A | A | 1.0 | M | NEPAL | F1 | SOFTWARE QUALITY ASSURANCE ENGINEERS AND TES | 5151 HEADQUARTERS DRIVE | PLANO | TX | 75024.0 | Y | 71150.0 | YEAR | 1/19/2023 | 9/30/2025 | 2.0 | N | N | F | BACHELOR'S DEGREE | INDUSTRIAL SCIENCE | 71150.0 | 66.20872744614896 | 541612.0 | B | Y | 2023.0 |
| 20092 | 20092 | NPL | NPL | 1978.0 | male | RV IT SYSTEMS INC | 862776354.0 | 6220 Chase Oaks Blvd | Plano | TX | 75023 | 2023.0 | SELECTED | 1.0 | 6/30/2022 | Approved | 11/7/2022 | RV IT SYSTEMS INC | 1B1 | A | A | 1.0 | M | INDIA | F1 | SOFTWARE ENGINEER | 6220 CHASE OAKS BLVD | PLANO | TX | 75023.0 | Y | 95000.0 | YEAR | 11/7/2022 | 9/20/2025 | 3.0 | Y | N | F | BACHELOR'S DEGREE | MASTER OF SCIENCE IN INFO TECH | 95000.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 20305 | 20305 | NPL | NPL | 1992.0 | male | Technipros LLC | 203079783.0 | 6860 Dallas Pkwy | Plano | TX | 75024-4242 | 2023.0 | SELECTED | 1.0 | 6/24/2022 | Approved | 8/15/2022 | TECHNIPROS LLC | 1B1 | A | B | 1.0 | M | NEPAL | F1 | SOFTWARE ENGINEER | 6860 DALLAS PKWY | PLANO | TX | 75024.0 | Y | 114608.0 | YEAR | 10/1/2022 | 9/30/2025 | 22.0 | Y | N | F | BACHELOR'S DEGREE | ECONOMICS | 114608.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 20306 | 20306 | NPL | NPL | 1992.0 | male | VISUAL TECHNOLOGIES LLC | 300725984.0 | 5851 Legacy Cir, 6th Floor, | Plano | TX | 75024-5969 | 2023.0 | SELECTED | 0.0 | 5/16/2022 | Approved | 8/5/2022 | VISUAL TECHNOLOGIES LLC | 1B1 | A | B | 1.0 | M | NEPAL | F1 | SOFTWARE ENGINEER | 5851 LEGACY CIRCLE 6TH FLOOR | PLANO | TX | 75024.0 | Y | 94037.0 | YEAR | 10/1/2022 | 9/30/2025 | 48.0 | N | N | F | BACHELOR'S DEGREE | INFORMATION SYSTEMS | 94037.0 | 15.0 | 541511.0 | B | N | 2023.0 |
| 20327 | 20327 | NPL | NPL | 1993.0 | male | CEO Foundry LLC | 465240886.0 | 5600 Tennyson Pkwy | Plano | TX | 75024-4028 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 8/14/2022 | CEO FOUNDRY LLC | 1B1 | A | B | 1.0 | M | NEPAL | F1 | SOFTWARE DEVELOPER | 5600 TENNYSON PKWY | PLANO | TX | 75024.0 | Y | 79000.0 | YEAR | 10/1/2022 | 9/30/2024 | 21.0 | Y | N | F | BACHELOR'S DEGREE | MASTER OF SCI IN INFO TECH | 79000.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 20328 | 20328 | NPL | NPL | 1993.0 | male | CEO Foundry LLC | 465240886.0 | 5600 Tennyson Pkwy | Plano | TX | 75024-4028 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 8/29/2022 | CEO FOUNDRY LLC | 1B1 | A | B | 1.0 | M | NEPAL | F1 | SOFTWARE DEVELOPER | 5600 TENNYSON PKWY | PLANO | TX | 56905.48740771989 | Y | 80000.0 | YEAR | 10/1/2022 | 9/30/2025 | 21.0 | Y | N | F | BACHELOR'S DEGREE | MASTER OF SCIENCE IN INFORMATION TECHNOLOGY | 80000.0 | 30.0 | 541511.0 | B | Y | 2023.0 |
| 20352 | 20352 | NPL | NPL | 1993.0 | male | SVS IT SYSTEMS INC | 851618144.0 | 6220 Chase Oaks Blvd | Plano | TX | 75023 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 12/30/2022 | SVS IT SYSTEMS INC | 1B1 | A | A | 1.0 | M | NEPAL | F1 | SOFTWARE DEVELOPER | 2665 VILLA CREEK DR | FARMERS BRANCH | TX | 75234.0 | Y | 78000.0 | YEAR | 12/30/2022 | 9/20/2025 | 5.0 | Y | N | F | BACHELOR'S DEGREE | COMPUTER ENGINEERING | 78000.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 20738 | 20738 | NPL | NPL | 2000.0 | female | Tyler Technologies, INC. | 752303920.0 | 5101 Tennyson Pkwy | Plano | TX | 75024 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 8/6/2022 | TYLER TECHNOLOGIES INC | 1B1 | A | B | 1.0 | F | NEPAL | F1 | DEPLOYMENT ENGINEER | 1 TYLER DRIVE | YARMOUTH | ME | 4096.0 | Y | 58400.0 | YEAR | 10/1/2022 | 9/30/2025 | 6058.0 | N | N | F | BACHELOR'S DEGREE | INFORMATION TECHNOLOGY | 58400.0 | 30.0 | 5415.0 | B | Y | 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]);