trk_data
Data source: Bloomberg FOIA Request
21 rows where gender = "male" and job_title = "DESIGNER"
This data as json, CSV (advanced)
Suggested facets: country_of_birth, country_of_nationality, ben_year_of_birth, fein, mail_addr, city, state, zip, first_decision_date, i129_employer_name, requested_action, ben_country_of_birth, ben_current_class, worksite_street, worksite_city, worksite_state, worksite_zip, wage_amt, valid_from, valid_to, num_of_emp_in_us, ben_education_code, ed_level_definition, ben_pfield_of_study, ben_comp_paid, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 18 | ALB | ALB | 1992.0 | male | Clark Kjos Architects, LLC | 931092300.0 | 621 Sw Alder St Ste 700 | Portland | OR | 97205-3622 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 7/19/2022 | CLARK KJOS ARCHITECTS LLC | 1B1 | A | B | 1.0 | M | ALBAN | F1 | DESIGNER | 621 SW ALDER ST | PORTLAND | OR | 56905.48740771989 | Y | 58500.0 | YEAR | 10/1/2022 | 9/30/2025 | 21.0 | N | N | F | BACHELOR'S DEGREE | ARCHITECTURE | 58500.0 | 66.20872744614896 | 541310.0 | B | N | 2023.0 |
| 1000 | 1000 | BOL | BOL | 1995.0 | male | ZYSCOVICH, INC. | 592754852.0 | 100 Biscayne Boulevard | Miami | FL | 33132 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 7/14/2022 | ZYSCOVICH INC | 1B1 | A | B | 1.0 | M | BOLIV | F1 | DESIGNER | 100 BISCAYNE BOULEVARD | MIAMI | FL | 33132.0 | Y | 46000.0 | YEAR | 10/1/2022 | 9/30/2025 | 144.0 | N | N | F | BACHELOR'S DEGREE | MASTER OF CONSTRUCTION MANAGEMENT | 46000.0 | 142.0 | 541310.0 | M | N | 2023.0 |
| 1425 | 1425 | BRA | BRA | 1992.0 | male | Microsoft Corporation | 911144442.0 | One Microsoft Way | Redmond | WA | 98052 | 2023.0 | SELECTED | 0.0 | 6/21/2022 | Approved | 6/28/2022 | MICROSOFT CORPORATION | 1B1 | A | A | 1.0 | M | BRAZI | F1 | DESIGNER | ONE MICROSOFT WAY | REDMOND | WA | 98052.0 | Y | 150000.0 | YEAR | 10/1/2022 | 9/26/2025 | 103894.0 | N | N | F | BACHELOR'S DEGREE | PRODUCT DESIGN | 150000.0 | 149.0 | 511210.0 | B | N | 2023.0 |
| 5209 | 5209 | CHN | CHN | 1991.0 | male | Vetter Architects, Inc. | 391723757.0 | 161 South First Street | Milwaukee | WI | 53204 | 2023.0 | SELECTED | 0.0 | 5/23/2022 | Approved | 8/17/2022 | VETTER ARCHITECTS INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | DESIGNER | 161 SOUTH FIRST ST | MILWAUKEE | WI | 53204.0 | Y | 69243.0 | YEAR | 10/1/2022 | 9/30/2025 | 6.0 | N | N | G | MASTER'S DEGREE | ARCHITECTURE & LANDSCAPE ARCHITECTURE | 69243.0 | 1.0 | 541310.0 | B | N | 2023.0 |
| 7593 | 7593 | CHN | CHN | 1994.0 | male | JDX Studio LLC | 461388757.0 | 49 Bleecker St | New York | NY | 10012 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 10/14/2022 | JDX STUDIO LLC D B A DE YAN | 1B1 | A | B | 1.0 | M | CHINA | F1 | DESIGNER | 49 BLEECKER STREET | NEW YORK | NY | 10012.0 | Y | 60000.0 | YEAR | 10/14/2022 | 9/30/2025 | 10.0 | N | N | G | MASTER'S DEGREE | ADVANCE ARCHITECTURAL DESIGN | 60000.0 | 19.0 | 54149.0 | B | N | 2023.0 |
| 7627 | 7627 | CHN | CHN | 1994.0 | male | M. Arthur Gensler Jr. & Associates, Inc. | 941663305.0 | 45 Fremont St Ste 1500 | San Francisco | CA | 94105-2214 | 2023.0 | SELECTED | 0.0 | 5/3/2022 | Approved | 5/6/2022 | M ARTHUR GENSLER JR & ASSOCIATES INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | DESIGNER | 999 PEACHTREE STREET NE | ATLANTA | GA | 30309.0 | Y | 55000.0 | YEAR | 10/1/2022 | 9/30/2025 | 5400.0 | N | N | F | BACHELOR'S DEGREE | MASTER OF FINE ARTS IN INTERIOR DESIGN | 55000.0 | 142.0 | 541310.0 | B | Y | 2023.0 |
| 7707 | 7707 | CHN | CHN | 1994.0 | male | NBBJ LP | 911574838.0 | 223 Yale Avenue North Seattle | Seattle | WA | 98109 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 7/19/2022 | NBBJ LP | 1B1 | A | B | 1.0 | M | CHINA | F1 | DESIGNER | ONE BEACON STREET | BOSTON | MA | 2108.0 | Y | 64800.0 | YEAR | 10/1/2022 | 9/30/2025 | 455.0 | N | N | G | MASTER'S DEGREE | ARCHITECTURE | 64800.0 | 1.0 | 541310.0 | B | N | 2023.0 |
| 10340 | 10340 | CHN | CHN | 1996.0 | male | Johnson Rudolph Architects, PC | 814680787.0 | 2718 W Avenue 34 | Los Angeles | CA | 90065-2807 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 8/16/2022 | JOHNSON RUDOLPH ARCHITECTS PC DBA DESIGN BITCHES | 1B1 | A | B | 1.0 | M | CHINA | F1 | DESIGNER | 2718 W AVENUE 34 | LOS ANGELES | CA | 90065.0 | Y | 58500.0 | YEAR | 10/1/2022 | 9/30/2025 | 5.0 | N | N | F | BACHELOR'S DEGREE | ARCHITECTURE | 58500.0 | 1.0 | 541310.0 | B | N | 2023.0 |
| 12768 | 12768 | CHN | CHN | 1999.0 | male | Microsoft Corporation | 911144442.0 | One Microsoft Way | Redmond | WA | 98052 | 2023.0 | SELECTED | 0.0 | 6/17/2022 | Approved | 8/19/2022 | MICROSOFT CORPORATION | 1B1 | A | B | 1.0 | M | CHINA | F1 | DESIGNER | ONE MICROSOFT WAY | REDMOND | WA | 98052.0 | Y | 112500.0 | YEAR | 10/1/2022 | 7/30/2025 | 103894.0 | N | N | F | BACHELOR'S DEGREE | DESIGN INTERACTION DESIGN | 112500.0 | 149.0 | 511210.0 | B | N | 2023.0 |
| 13801 | 13801 | ECU | ECU | 1997.0 | male | EDSA, Inc. | 591265229.0 | 1512 E Broward Blvd | Ft Lauderdale | FL | 33301-2126 | 2023.0 | SELECTED | 0.0 | 5/5/2022 | Approved | 6/1/2022 | EDSA INC | 1B1 | A | B | 1.0 | M | ECUAD | F1 | DESIGNER | 1512 E BROWARD BLVD | FORT LAUDERDALE | FL | 33301.0 | Y | 65000.0 | YEAR | 10/1/2022 | 9/30/2025 | 116.0 | N | N | G | MASTER'S DEGREE | MASTER OF LANDSCAPE ARCHITECTURE | 65000.0 | 1.0 | 541320.0 | M | N | 2023.0 |
| 14439 | 14439 | FRA | FRA | 1996.0 | male | WorkandCo International, Inc. | 462436774.0 | 231 Front St Fl 5 | Brooklyn | NY | 11201-1217 | 2023.0 | SELECTED | 0.0 | 5/23/2022 | Approved | 9/1/2022 | WORKANDCO INTERNATIONAL INC DBA WORK CO | 1B1 | A | B | 1.0 | M | FRANC | J1 | DESIGNER | 231 FRONT ST | BROOKLYN | NY | 11201.0 | Y | 70000.0 | YEAR | 10/1/2022 | 9/30/2025 | 300.0 | N | N | F | BACHELOR'S DEGREE | DIGITAL COMMUNICATIONS AND MEDIA | 70000.0 | 141.0 | 541511.0 | B | N | 2023.0 |
| 15471 | 15471 | IDN | IDN | 1994.0 | male | Hart Howerton, LTD | 942787680.0 | One Union Street | San Francisco | CA | 94111 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 6/7/2022 | HART HOWERTON LTD | 1B1 | A | B | 1.0 | M | INDON | F1 | DESIGNER | ONE UNION STREET | SAN FRANCISCO | CA | 94111.0 | Y | 79123.0 | YEAR | 10/1/2022 | 9/30/2025 | 83.0 | N | N | G | MASTER'S DEGREE | INDUSTRIAL DESIGN | 79123.0 | 1.0 | 541310.0 | B | N | 2023.0 |
| 16422 | 16422 | IRN | IRN | 1995.0 | male | General Motors Company | 270383222.0 | 300 Renaissance Center | Detroit | MI | 48265 | 2023.0 | SELECTED | 0.0 | 5/17/2022 | Approved | 5/23/2022 | GENERAL MOTORS COMPANY | 1B1 | A | B | 1.0 | M | IRAN | F1 | DESIGNER | 6350 HARLEY EARL BOULEVARD | WARREN | MI | 48092.0 | Y | 88000.0 | YEAR | 10/1/2022 | 9/30/2025 | 98000.0 | N | N | G | MASTER'S DEGREE | TRANSPORTATION DESIGN | 88000.0 | 142.0 | 336111.0 | M | N | 2023.0 |
| 16691 | 16691 | ITA | ITA | 1995.0 | male | Artisan Cabinet Inc | 843894713.0 | 234 Middle St | Middletown | CT | 06457-7517 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 6/7/2023 | ARTISAN CABINET INC | 1B1 | A | A | 1.0 | M | ITALY | F1 | DESIGNER | 520 N MAIN ST | PORT CHESTER | NY | 10573.0 | Y | 60000.0 | YEAR | 6/7/2023 | 9/30/2025 | 36.0 | N | N | F | BACHELOR'S DEGREE | INTERIOR DESIGN | 60000.0 | 142.0 | 337110.0 | B | N | 2023.0 |
| 17086 | 17086 | KEN | KEN | 1985.0 | male | Studio Troika, Inc. | 200253943.0 | 15 Channel Center Street | Boston | MA | 02210 | 2023.0 | SELECTED | 0.0 | 5/24/2022 | Approved | 12/17/2022 | STUDIO TROIKA INC | 1B1 | A | B | 1.0 | M | KENYA | F1 | DESIGNER | 15 CHANNEL CENTER STREET | BOSTON | MA | 2210.0 | Y | 65000.0 | YEAR | 12/17/2022 | 9/30/2025 | 22.0 | N | N | F | BACHELOR'S DEGREE | ARCHITECTURE | 65000.0 | 1.0 | 541310.0 | M | N | 2023.0 |
| 19008 | 19008 | MEX | MEX | 1992.0 | male | RIVIAN AUTOMOTIVE, LLC | 473556480.0 | 14600 Myford Road | Irvine | CA | 92606 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 6/13/2022 | RIVIAN AUTOMOTIVE LLC | 1B1 | A | B | 1.0 | M | MEXIC | TN2 | DESIGNER | 100 N RIVIAN MOTORWAY | NORMAL | IL | 61761.0 | Y | 123900.0 | YEAR | 10/1/2022 | 9/30/2025 | 10000.0 | N | N | F | BACHELOR'S DEGREE | MECHATRONIC ENGINEERING | 123900.0 | 19.0 | 336111.0 | B | N | 2023.0 |
| 19258 | 19258 | MMR | MMR | 1995.0 | male | AHA Consulting Engineers, Inc. | 43130168.0 | 24 Hartwell Ave | Lexington | MA | 02421-3139 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 7/11/2022 | AHA CONSULTING ENGINEERS INC | 1B1 | A | B | 1.0 | M | BURMA | F1 | DESIGNER | 24 HARTWELL AVE | LEXINGTON | MA | 2421.0 | Y | 72738.0 | YEAR | 10/1/2022 | 9/30/2025 | 130.0 | N | N | F | BACHELOR'S DEGREE | ENERGY SYSTEMS | 124203.22674832083 | 7.0 | 541330.0 | M | N | 2023.0 |
| 22558 | 22558 | SAU | SAU | 1990.0 | male | M. Arthur Gensler Jr. & Associates, Inc. | 941663305.0 | 45 Fremont St Ste 1500 | San Francisco | CA | 94105-2214 | 2023.0 | SELECTED | 0.0 | 6/7/2022 | Approved | 6/30/2022 | M ARTHUR GENSLER JR & ASSOCIATES INC | 1B1 | A | B | 1.0 | M | SAUDI | F1 | DESIGNER | 4675 MACARTHUR COURT | NEWPORT BEACH | CA | 92660.0 | Y | 69000.0 | YEAR | 10/1/2022 | 9/30/2025 | 5400.0 | N | N | F | BACHELOR'S DEGREE | MASTER OF SCIENCE IN ADVANCED ARCHITECTURAL DESIGN | 69000.0 | 142.0 | 541310.0 | M | Y | 2023.0 |
| 23681 | 23681 | TWN | TWN | 1988.0 | male | RIOS, INC. | 954019625.0 | 3101 W. Exposition Place | Los Angeles | CA | 90018 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 8/13/2022 | RIOS INC | 1B1 | A | B | 1.0 | M | TAIWA | F1 | DESIGNER | 3101 W EXPOSITION PLACE | LOS ANGELES | CA | 90018.0 | Y | 60000.0 | YEAR | 10/1/2022 | 9/30/2025 | 240.0 | N | N | F | BACHELOR'S DEGREE | ARCHITECTURE | 60000.0 | 1.0 | 541310.0 | B | N | 2023.0 |
| 25220 | 25220 | VNM | VNM | 2000.0 | male | Hord Coplan Macht, Inc. | 522136408.0 | 700 E. Pratt Street | Baltimore | MD | 21202 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 7/27/2022 | HORD COPLAN MACHT INC | 1B1 | A | B | 1.0 | M | VIETN | F1 | DESIGNER | 1925 BALLENGER AVENUE | ALEXANDRIA | VA | 22314.0 | Y | 59000.0 | YEAR | 10/1/2022 | 9/30/2025 | 265.0 | N | N | F | BACHELOR'S DEGREE | ARCHITECTURE | 59000.0 | 1.0 | 54131.0 | B | N | 2023.0 |
| 25327 | 25327 | ZAF | ZAF | 1994.0 | male | Future Firm PLLC | 810727696.0 | 3149 S. Morgan St. | Chicago | IL | 60608 | 2023.0 | SELECTED | 0.0 | 6/17/2022 | Approved | 7/9/2022 | FUTURE FIRM PLLC | 1B1 | A | B | 1.0 | M | SAFRI | F1 | DESIGNER | 3149 S MORGAN ST | CHICAGO | IL | 60608.0 | Y | 48500.0 | YEAR | 10/1/2022 | 9/30/2025 | 6.0 | N | N | F | BACHELOR'S DEGREE | MASTER OF ARCHITECTURE | 48500.0 | 17.0 | 541310.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]);