trk_data
Data source: Bloomberg FOIA Request
10 rows where city = "Corning", 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, i129_employer_name, requested_action, ben_sex, ben_country_of_birth, ben_current_class, worksite_street, worksite_city, worksite_state, worksite_zip, wage_amt, valid_from, num_of_emp_in_us, ben_education_code, ed_level_definition, ben_pfield_of_study, ben_comp_paid, dot_code, naics_code, s3q1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2030 | 2030 | CAN | CAN | 1992.0 | male | Corning Research & Development Corporation | 475305180.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/6/2022 | Approved | 8/23/2022 | CORNING RESEARCH DEVELOPMENT CORPORATION | 1B1 | A | A | 1.0 | M | CANAD | TN1 | Chemical Engineer | 1 SCIENCE CTR DR | PAINTED POST | NY | 14870.0 | Y | 108368.0 | YEAR | 10/1/2022 | 9/30/2025 | 1544.0 | N | N | I | DOCTORATE DEGREE | CHEMICAL ENGRG | 108368.0 | 8.0 | 54171.0 | B | N | 2023.0 |
| 3135 | 3135 | CHN | CHN | 1978.0 | female | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/24/2022 | Approved | 7/25/2022 | CORNING INCORPORATED | 1B1 | A | B | 1.0 | F | CHINA | F1 | Machine Learning Modeling Engineer | 1 SCIENCE CTR DR | PAINTED POST | NY | 14870.0 | Y | 110968.0 | YEAR | 10/1/2022 | 9/30/2025 | 11302.0 | N | N | I | DOCTORATE DEGREE | SYSTEMS SCI | 110968.0 | 39.0 | 327210.0 | M | N | 2023.0 |
| 3610 | 3610 | CHN | CHN | 1987.0 | male | Corning Research & Development Corporation | 475305180.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/4/2022 | Approved | 8/20/2022 | CORNING RESEARCH DEVELOPMENT CORPORATION | 1B1 | A | A | 1.0 | M | CHINA | F1 | Applied Mechanics Modeling Scientist | ONE SCIENCE CENTER DR | PAINTED POST | NY | 14870.0 | Y | 101754.0 | YEAR | 10/1/2022 | 9/30/2025 | 1544.0 | N | N | I | DOCTORATE DEGREE | MECHANICAL ENGINEERING | 101754.0 | 7.0 | 54171.0 | M | N | 2023.0 |
| 5672 | 5672 | CHN | CHN | 1992.0 | male | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/6/2022 | Approved | 8/5/2022 | CORNING INCORPORATED | 1B1 | A | A | 1.0 | M | CHINA | F1 | PROCESS SIMULATION ENGINEER | ONE SCIENCE CENTER DRIVE | PAINTED POST | NY | 14870.0 | Y | 105000.0 | YEAR | 10/1/2022 | 9/30/2025 | 11302.0 | N | N | I | DOCTORATE DEGREE | MECHANICAL ENGINEERING | 105000.0 | 7.0 | 327210.0 | M | N | 2023.0 |
| 14984 | 14984 | GHA | GHA | 1993.0 | male | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/24/2022 | Approved | 7/9/2022 | CORNING INCORPORATED | 1B1 | A | B | 1.0 | M | GHANA | F1 | THERMAL EQUIPMENT DESIGN ENGINEER | 100 PULTENEY ST | CORNING | NY | 14830.0 | Y | 101754.0 | YEAR | 10/1/2022 | 9/30/2025 | 11302.0 | N | N | I | DOCTORATE DEGREE | MECHANICAL ENGINEERING | 101754.0 | 7.0 | 327210.0 | M | N | 2023.0 |
| 17009 | 17009 | KAZ | DEU | 1983.0 | male | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 7/8/2022 | CORNING INCORPORATED | 1B1 | A | A | 1.0 | M | KAZAK | E2 | STERILE PRODUCTS MANUFACTURING STRATEGIST PROGRAM MANAGER | 1 BECTON CIRCLE | DURHAM | NC | 27712.0 | Y | 205000.0 | YEAR | 10/1/2022 | 9/30/2025 | 11302.0 | N | N | F | BACHELOR'S DEGREE | ENGINEERING MANAGEMENT | 205000.0 | 189.0 | 327210.0 | B | N | 2023.0 |
| 17122 | 17122 | KEN | KEN | 1994.0 | female | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/11/2022 | Approved | 6/14/2022 | CORNING INCORPORATED | 1B1 | A | B | 1.0 | F | KENYA | F1 | PROCESS ENGINEER MELTING | 100 PULTENEY STREET | CORNING | NY | 14830.0 | Y | 90000.0 | YEAR | 10/1/2022 | 9/30/2025 | 11302.0 | N | N | I | DOCTORATE DEGREE | MECHANICAL ENGINEERING | 90000.0 | 7.0 | 327210.0 | B | N | 2023.0 |
| 18756 | 18756 | MEX | MEX | 1988.0 | male | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 5/6/2022 | Approved | 7/20/2022 | CORNING INCORPORATED | 1B1 | A | B | 1.0 | M | MEXIC | F1 | MATERIALS ENGINEER | 100 PULTENEY STREET | CORNING | NY | 14830.0 | Y | 85000.0 | YEAR | 10/1/2022 | 9/30/2025 | 11302.0 | N | N | I | DOCTORATE DEGREE | MATERIALS ENGRG | 85000.0 | 19.0 | 327210.0 | M | N | 2023.0 |
| 19081 | 19081 | MEX | MEX | 1994.0 | male | Corning Incorporated | 160393470.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 6/29/2022 | Approved | 11/2/2022 | CORNING INCORPORATED | 1B1 | A | A | 1.0 | M | MEXIC | TN | OPERATIONAL TECHNOLOGY SOFTWARE ENGINEER | 100 PULTENEY STREET | CORNING | NY | 14830.0 | Y | 91800.0 | YEAR | 11/2/2022 | 9/30/2025 | 11302.0 | N | N | F | BACHELOR'S DEGREE | MECAHTRONICS ENGINEERING | 91800.0 | 19.0 | 32721.0 | B | N | 2023.0 |
| 23714 | 23714 | TWN | TWN | 1989.0 | male | Corning Research & Development Corporation | 475305180.0 | 1 Riverfront Plz | Corning | NY | 14831-0001 | 2023.0 | SELECTED | 0.0 | 6/8/2022 | Approved | 8/13/2022 | CORNING RESEARCH DEVELOPMENT CORPORATION | 1B1 | A | B | 1.0 | M | TAIWA | F1 | SOFTWARE ENGINEER | ONE SCIENCE CENTER DRIVE | PAINTED POST | NY | 14870.0 | Y | 104437.0 | YEAR | 10/1/2022 | 9/30/2025 | 1544.0 | N | N | I | DOCTORATE DEGREE | MATERIALS SCIENCE AND ENGINEERING | 104437.0 | 29.0 | 54171.0 | M | 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]);