trk_data
Data source: Bloomberg FOIA Request
18 rows where city = "San Ramon", 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, fein, mail_addr, zip, ben_multi_reg_ind, first_decision_date, i129_employer_name, requested_action, number_of_beneficiaries, ben_sex, ben_country_of_birth, ben_current_class, job_title, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1454 | 1454 | BRA | BRA | 1993.0 | male | Prediktive LLC | 611817181.0 | 2603 Camino Ramon | San Ramon | CA | 94583-9136 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 11/1/2022 | PREDIKTIVE LLC | 1B1 | A | A | 1.0 | M | BRAZI | UU | Back End Engineer | 2603 CAMINO RAMON | SAN RAMON | CA | 94583.0 | Y | 172000.0 | YEAR | 11/1/2022 | 9/30/2025 | 113.0 | N | N | F | BACHELOR'S DEGREE | COMP SCI | 172000.0 | 30.0 | 541512.0 | B | N | 2023.0 |
| 3827 | 3827 | CHN | CHN | 1988.0 | male | GE Energy Management Services LLC | 351886526.0 | 2700 Camino Ramon | San Ramon | CA | 94583 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 6/21/2022 | GE ENERGY MANAGEMENT SERVICES LLC | 1B1 | A | B | 1.0 | M | CHINA | O1A | SOFTWARE ENGINEER | 19015 NORTH CREEK PARKWAY | BOTHELL | WA | 98011.0 | Y | 100800.0 | YEAR | 10/1/2022 | 9/30/2025 | 168000.0 | N | N | I | DOCTORATE DEGREE | ELECTRICAL AND COMPUTER ENGINEERING | 100800.0 | 3.0 | 333611.0 | B | N | 2023.0 |
| 3940 | 3940 | CHN | CHN | 1989.0 | female | Armanino LLP | 946214841.0 | 12657 Alcosta Blvd | San Ramon | CA | 94583-4600 | 2023.0 | SELECTED | 0.0 | 5/10/2022 | Approved | 5/13/2022 | ARMANINO LLP | 1B1 | A | A | 1.0 | F | CHINA | J2 | MANAGER AUDIT | 6716 HART LN | AUSTIN | TX | 56905.48740771989 | Y | 117500.0 | YEAR | 10/1/2022 | 9/14/2025 | 1500.0 | N | N | F | BACHELOR'S DEGREE | ACCOUNTING | 117500.0 | 160.0 | 541611.0 | M | N | 2023.0 |
| 4108 | 4108 | CHN | CHN | 1989.0 | male | Chevron Corporation | 940890210.0 | 6001 Bollinger Canyon Road | San Ramon | CA | 94583 | 2023.0 | SELECTED | 0.0 | 4/29/2022 | Approved | 5/26/2022 | CHEVRON CORPORATION | 1B1 | A | A | 1.0 | M | CHINA | F1 | SIMULATION ENGINEER | 1500 LOUISIANA STREET | HOUSTON | TX | 77002.0 | Y | 145750.0 | YEAR | 10/1/2022 | 8/26/2025 | 32468.0 | N | N | I | DOCTORATE DEGREE | PETROLEUM ENGINEERING | 145750.0 | 10.0 | 21111.0 | M | N | 2023.0 |
| 4525 | 4525 | CHN | CHN | 1990.0 | male | Chevron Corporation | 940890210.0 | 6001 Bollinger Canyon Road | San Ramon | CA | 94583 | 2023.0 | SELECTED | 0.0 | 4/27/2022 | Approved | 9/15/2022 | CHEVRON CORPORATION | 1B1 | A | A | 1.0 | M | CHINA | F1 | SEISMIC IMAGING RESEARCH GEOPHYSICIST | 1500 LOUISIANA STREET | HOUSTON | TX | 77002.0 | Y | 127000.0 | YEAR | 10/1/2022 | 8/26/2025 | 32468.0 | N | N | F | BACHELOR'S DEGREE | EARTH SCIENCE | 127000.0 | 24.0 | 21111.0 | M | N | 2023.0 |
| 4840 | 4840 | CHN | CHN | 1991.0 | female | LONGi Solar Technology US Inc | 475663539.0 | 3000 Executive Pkwy Ste 375 | San Ramon | CA | 94583-4335 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 10/27/2022 | LONGI SOLAR TECHNOLOGY U S INC | 1B1 | A | B | 1.0 | F | CHINA | F1 | LOGISTICS SPECIALIST | 4741 CALAVERAS AVE | FREMONT | CA | 94538.0 | Y | 70000.0 | YEAR | 10/27/2022 | 9/30/2025 | 38.0 | N | N | G | MASTER'S DEGREE | INDUSTRIAL ENGINEERING | 70000.0 | 12.0 | 221114.0 | B | Y | 2023.0 |
| 5149 | 5149 | CHN | CHN | 1991.0 | male | Mott MacDonald Group Inc. | 223789761.0 | 12647 Alcosta Blvd | San Ramon | CA | 94583-4439 | 2023.0 | SELECTED | 0.0 | 6/4/2022 | Approved | 8/1/2022 | MOTT MACDONALD GROUP INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | ENGINEER III GEOTECHNICAL | 855 LEEWARD WAY | NEWARK | CA | 94560.0 | Y | 81120.0 | YEAR | 10/1/2022 | 9/30/2025 | 2420.0 | N | N | I | DOCTORATE DEGREE | STRUCTURAL ENGINEERING | 81120.0 | 5.0 | 541330.0 | B | N | 2023.0 |
| 11085 | 11085 | CHN | CHN | 1997.0 | female | NanoCred Consulting Inc. | 871900246.0 | 2010 Crow Canyon Pl | San Ramon | CA | 94583-1344 | 2023.0 | SELECTED | 0.0 | 5/18/2022 | Approved | 8/10/2022 | NANOCRED CONSULTING INC | 1B1 | A | A | 0.9999597536925987 | F | CHINA | F1 | BUSINESS ANALYST | 42 WELLMAN ST | LOWELL | MA | 1851.0 | Y | 84000.0 | YEAR | 10/1/2022 | 9/30/2025 | 18.0 | N | N | F | BACHELOR'S DEGREE | APPLIED STATISTICS | 84000.0 | 186.0 | 541600.0 | B | N | 2023.0 |
| 14136 | 14136 | ETH | ETH | 1986.0 | male | Grid Dynamics Holdings, Inc. | 830632724.0 | 5000 Executive Pkwy | San Ramon | CA | 94583-4282 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 6/10/2022 | GRID DYNAMICS HOLDINGS INC | 1B1 | A | B | 1.0 | M | ETHIO | F1 | SENIOR SOFTWARE ENGINEER | 5649 NAAMAN FOREST BLVD | GARLAND | TX | 75044.0 | Y | 120000.0 | YEAR | 10/1/2022 | 9/30/2025 | 250.0 | N | N | G | MASTER'S DEGREE | COMPUTER SCIENCE | 120000.0 | 30.0 | 541512.0 | M | N | 2023.0 |
| 14151 | 14151 | ETH | ETH | 1990.0 | male | Grid Dynamics Holdings, Inc. | 830632724.0 | 5000 Executive Pkwy | San Ramon | CA | 94583-4282 | 2023.0 | SELECTED | 0.0 | 5/25/2022 | Approved | 9/14/2022 | GRID DYNAMICS HOLDINGS INC | 1B1 | A | B | 1.0 | M | ETHIO | F1 | SENIOR SOFTWARE ENGINEER | 5000 EXECUTIVE PKWY | SAN RAMON | CA | 94583.0 | Y | 131000.0 | YEAR | 10/1/2022 | 9/30/2025 | 250.0 | N | N | F | BACHELOR'S DEGREE | COMPUTER ENGINEERING | 131000.0 | 30.0 | 541512.0 | B | Y | 2023.0 |
| 15239 | 15239 | HKG | CHN | 1992.0 | male | Reputation.com Inc. | 510589907.0 | 6111 Bollinger Canyon Rd | San Ramon | CA | 94583-5100 | 2023.0 | SELECTED | 0.0 | 6/24/2022 | Approved | 7/2/2022 | REPUTATION COM INC | 1B1 | A | B | 1.0 | M | HONGK | F1 | SOFTWARE ENGINEER | 2701 N THANKSGIVING WAY | LEHI | UT | 84043.0 | Y | 59200.0 | YEAR | 10/1/2022 | 9/30/2025 | 410.0 | N | N | F | BACHELOR'S DEGREE | MBA MARKETING EMPHASIS | 59200.0 | 50.0 | 519130.0 | B | N | 2023.0 |
| 15352 | 15352 | HKG | NZL | 1997.0 | male | Cooley Architectural Corporation | 474232800.0 | 2570 San Ramon Valley Blvd | San Ramon | CA | 94583-1637 | 2023.0 | SELECTED | 0.0 | 5/2/2022 | Approved | 7/19/2022 | COOLEY ARCHITECTURAL CORPORATION | 1B1 | A | B | 1.0 | M | HONGK | F1 | ARCHITECTURAL DESIGNER | 2570 SR VALLEY BLVD | SAN RAMON | CA | 94583.0 | Y | 62400.0 | YEAR | 10/1/2022 | 9/30/2025 | 3.0 | N | N | F | BACHELOR'S DEGREE | ARCHITECTURE | 62400.0 | 1.0 | 541310.0 | B | N | 2023.0 |
| 15748 | 15748 | IND | CAN | 1987.0 | male | Robert Half International, Inc. | 941648752.0 | 2613 Camino Ramon | San Ramon | CA | 94583 | 2023.0 | SELECTED | 0.0 | 5/13/2022 | Approved | 5/23/2022 | ROBERT HALF INTERNATIONAL INC | 1B1 | A | B | 1.0 | M | INDIA | TN | BUSINESS SYSTEMS ANALYST III | 2613 CAMINO RAMON | SAN RAMON | CA | 94583.0 | Y | 120000.0 | YEAR | 10/1/2022 | 9/30/2025 | 7575.0 | N | N | F | BACHELOR'S DEGREE | COMPUTING SCIENCE | 120000.0 | 39.0 | 561311.0 | B | N | 2023.0 |
| 15899 | 15899 | IND | GBR | 1979.0 | male | HAMAARA TECHNOLOGIES LLC | 880687139.0 | 6983 Emerson Ln | San Ramon | CA | 94582 | 2023.0 | SELECTED | 1.0 | 6/30/2022 | Approved | 10/22/2022 | HAMAARA TECHNOLOGIES LLC | 1B1 | A | A | 1.0 | M | INDIA | F1 | SOFTWARE ENGINEER | 3100 MOWRY AVE | FREMONT | CA | 94538.0 | Y | 121763.0 | YEAR | 10/22/2022 | 9/30/2025 | 1.0 | N | N | F | BACHELOR'S DEGREE | BACHELOR OF TECHNOLOGY IN MECHANICAL ENGINEERING | 121763.0 | 30.0 | 541511.0 | B | N | 2023.0 |
| 21089 | 21089 | PAK | PAK | 1988.0 | male | The Danville Group Inc. | 562583904.0 | 5000 Executive Pkwy | San Ramon | CA | 94583-4210 | 2023.0 | SELECTED | 0.0 | 5/18/2022 | Approved | 5/27/2022 | THE DANVILLE GROUP INC DBA ROOSTOCK SOFTWARE | 1B1 | A | A | 1.0 | M | PAKIS | UU | CUSTOMER SUPPORT MANAGER | 5000 EXECUTIVE PKWY | SAN RAMON | CA | 94583.0 | Y | 160000.0 | YEAR | 10/1/2022 | 9/30/2025 | 70.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING | 160000.0 | 3.0 | 541512.0 | B | N | 2023.0 |
| 21252 | 21252 | PAK | PAK | 1993.0 | male | GE Energy Management Services LLC | 351886526.0 | 2700 Camino Ramon | San Ramon | CA | 94583 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 6/21/2022 | GE ENERGY MANAGEMENT SERVICES LLC | 1B1 | A | B | 1.0 | M | PAKIS | F1 | SOFTWARE ENGINEER | 19015 NORTH CREEK PARKWAY | BOTHELL | WA | 98011.0 | Y | 105000.0 | YEAR | 10/1/2022 | 9/30/2025 | 168000.0 | N | N | F | BACHELOR'S DEGREE | ELECTRICAL ENGINEERING | 105000.0 | 3.0 | 333611.0 | B | N | 2023.0 |
| 22500 | 22500 | SAU | EGY | 1986.0 | male | GE Energy Management Services LLC | 351886526.0 | 2700 Camino Ramon | San Ramon | CA | 94583 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 6/13/2022 | GE ENERGY MANAGEMENT SERVICES LLC | 1B1 | A | B | 1.0 | M | SAUDI | F1 | SOFTWARE ENGINEER | 19015 NORTH CREEK PARKWAY | BOTHELL | WA | 98011.0 | Y | 105000.0 | YEAR | 10/1/2022 | 9/5/2025 | 168000.0 | N | N | I | DOCTORATE DEGREE | ELECTRICAL ENGINEERING | 105000.0 | 3.0 | 333611.0 | M | N | 2023.0 |
| 24620 | 24620 | UKR | UKR | 1996.0 | male | SevenSecur Inc. | 852833940.0 | 539 Wycombe Ct | San Ramon | CA | 94583-9101 | 2023.0 | SELECTED | 0.0 | 5/31/2022 | Approved | 8/15/2022 | SEVENSECUR INC | 1B1 | A | B | 1.0 | M | UKRAI | F1 | Information Security Engineer | 539 WYCOMBE CT | SAN RAMON | CA | 94583.0 | Y | 90000.0 | YEAR | 10/1/2022 | 9/30/2025 | 10.0 | N | N | F | BACHELOR'S DEGREE | SECURITY SYSTEMS ENGINEERING AND MATHEMATICS | 90000.0 | 30.0 | 541512.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]);