trk_data
Data source: Bloomberg FOIA Request
4 rows where city = "San Leandro" and first_decision = "Approved"
This data as json, CSV (advanced)
Suggested facets: country_of_birth, country_of_nationality, gender, ben_multi_reg_ind, ben_sex, ben_country_of_birth, ben_current_class, worksite_city, ed_level_definition
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9089 | 9089 | CHN | CHN | 1995.0 | male | THE YT GROUP INC. | 611958305.0 | 1617 Regent Dr | San Leandro | CA | 94577-5323 | 2023.0 | SELECTED | 1.0 | 6/29/2022 | Approved | 7/19/2022 | YT GROUP INC | 1B1 | A | B | 1.0 | M | CHINA | F1 | IT ADMINISTRATOR | 110 S B ST | SAN MATEO | CA | 94401.0 | Y | 68349.0 | YEAR | 10/1/2022 | 9/30/2025 | 15.0 | N | N | F | BACHELOR'S DEGREE | ELECTROMECHANICAL SYSTEMS ENGINEERING TECHNOLOGY | 68349.0 | 33.0 | 445299.0 | B | N | 2023.0 |
| 13168 | 13168 | COL | COL | 1990.0 | female | AGROWTH | 833057828.0 | 1200 Business Center Dr | San Leandro | CA | 94577-2241 | 2023.0 | SELECTED | 0.0 | 6/27/2022 | Approved | 10/25/2022 | AGROWTH | 1B1 | A | B | 1.0 | F | COLOM | F2 | BIOANALYST | 1200 BUSINESS CENTER DRIVE | SAN LEANDRO | CA | 94577.0 | Y | 84365.0 | YEAR | 10/25/2022 | 9/30/2025 | 35.0 | N | N | F | BACHELOR'S DEGREE | MICROBIOLOGY BIOANALYSIS | 84365.0 | 8.0 | 339999.0 | B | N | 2023.0 |
| 17564 | 17564 | KOR | KOR | 1991.0 | male | Cuberg, Inc. | 862272851.0 | 2020 Williams St Unit E | San Leandro | CA | 94577-2335 | 2023.0 | SELECTED | 0.0 | 6/22/2022 | Approved | 8/31/2022 | CUBERG INC | 1B1 | A | B | 1.0 | M | SKORE | F1 | DATA ANALYST | 2020 WILLIAMS STREET BUILDING E | SAN LEANDRO | CA | 94577.0 | Y | 97200.0 | YEAR | 10/1/2022 | 9/30/2025 | 74.0 | N | N | F | BACHELOR'S DEGREE | APPLIED MATHEMATICS WITH A MINOR IN COMPUTER SCIENCE | 97200.0 | 20.0 | 33531.0 | B | N | 2023.0 |
| 17669 | 17669 | KOR | KOR | 1993.0 | female | Korean Community Center of the East Bay | 942503925.0 | 101 Callan Avenue | San Leandro | CA | 94577 | 2023.0 | SELECTED | 0.0 | 6/30/2022 | Approved | 7/13/2022 | KOREAN COMMUNITY CENTER OF THE EAST BAY | 1B1 | A | B | 1.0 | F | SKORE | F1 | WELLNESS COUNSELOR & CASE MANAGER | 101 CALLAN AVENUE | SAN LEANDRO | CA | 94577.0 | Y | 58906.0 | YEAR | 10/1/2022 | 9/30/2025 | 16.0 | N | N | G | MASTER'S DEGREE | MARRIAGE AND FAMILY THERAPY | 58906.0 | 79.0 | 813410.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]);