home / datasette

trk_data

Data source: Bloomberg FOIA Request

9 rows where worksite_zip = "60004.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country_of_birth, country_of_nationality, ben_year_of_birth, gender, fein, mail_addr, city, state, zip, ben_multi_reg_ind, first_decision, i129_employer_name, ben_sex, ben_country_of_birth, ben_current_class, job_title, worksite_street, worksite_city, wage_amt, valid_from, valid_to, ben_education_code, ed_level_definition, ben_comp_paid, dot_code, naics_code, 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
299 299 AUS AUS 1987.0 male HSBC Technology & Services USA Inc. 200362763.0 95 Washington St Buffalo NY 14203 2023.0 SELECTED 0.0 6/21/2022 Approved 6/30/2022 HSBC TECHNOLOGY SERVICES USA INC 1B1 A A 1.0 M RALIA E3 IT DATA BI ANALYST 1421 W SHURE DRIVE ARLINGTON HEIGHTS IL 60004.0 Y 155232.0 YEAR 10/1/2022 9/30/2025 11000.0 N N G MASTER'S DEGREE INFORMATION TECHNOLOGY 155232.0 30.0 522110.0 B N 2023.0
1710 1710 CAN CAN 1976.0 male International Services, Inc. 363788558.0 3850 N Wilke Road Arlington Heights IL 60004 2023.0 SELECTED 1.0 6/7/2022 Approved 6/13/2022 INTERNATIONAL SERVICES INC 1B1 A A 1.0 M CANAD DA SENIOR BUSINESS CONSULTANT 3850 N WILKE ROAD ARLINGTON HEIGHTS IL 60004.0 Y 115000.0 YEAR 10/1/2022 9/30/2025 683.0 N N F BACHELOR'S DEGREE BUSINESS AND MANAGEMENT 115000.0 160.0 541611.0 B N 2023.0
15912 15912 IND GBR 1981.0 male CPC TECHNOLOGIES LLC 845158047.0 5 E College Dr Arlington Hts IL 60004-1960 2023.0 SELECTED 1.0 6/30/2022 Denied 5/24/2023 CPC TECHNOLOGIES LLC 1B1 A A 1.0 M INDIA F1 SOFTWARE DEVELOPER 5 E COLLEGE DR ARLINGTON HTS IL 60004.0 Y 91000.0 YEAR 10/1/2022 9/30/2025 6.0 N N F BACHELOR'S DEGREE COMPUTER SCIENCE AND ENGINEERING 91000.0 30.0 541511.0 B N 2023.0
17154 17154 KGZ KGZ 1974.0 male Bright Way, LLC 872032937.0 891 Cenrtal Ave Highland Park IL 60035 2023.0 SELECTED 1.0 6/28/2022 Approved 9/30/2022 BRIGHT WAY LLC 1B1 A A 1.0 M KYRGY F1 BUSINESS DEVELOPMENT SPECIALIST 1114 N ARLINGTON HEIGHTS ROAD ARLINGTON HEIGHTS IL 60004.0 Y 67766.0 YEAR 10/1/2022 9/29/2025 1.0 N N F BACHELOR'S DEGREE INTERNATIONAL ECONOMICS 67766.0 50.0 541611.0 B N 2023.0
17155 17155 KGZ KGZ 1986.0 male Bright Way, LLC 872032937.0 891 Cenrtal Ave Highland Park IL 60035 2023.0 SELECTED 1.0 6/28/2022 Approved 10/4/2022 BRIGHT WAY LLC 1B1 A A 1.0 M KYRGY F1 ENGINEERING CONSULTANT 1114 N ARLINGTON HEIGHTS ROAD ARLINGTON HEIGHTS IL 60004.0 Y 65125.0 YEAR 10/4/2022 9/29/2025 1.0 N N F BACHELOR'S DEGREE ELECTRICAL ENGINEERING 65125.0 3.0 541611.0 B N 2023.0
17168 17168 KGZ KGZ 1995.0 male Bright Way, LLC 872032937.0 891 Cenrtal Ave Highland Park IL 60035 2023.0 SELECTED 0.0 6/28/2022 Approved 9/13/2022 BRIGHT WAY LLC 1B1 A A 1.0 M KYRGY F1 FOREIGN LAW CONSULTANT 1114 N ARLINGTON HEIGHTS ROAD ARLINGTON HEIGHTS IL 60004.0 Y 76648.0 YEAR 10/1/2022 9/29/2025 1.0 N N F BACHELOR'S DEGREE LAW LEGAL STUDIES 76648.0 110.0 541611.0 B N 2023.0
17171 17171 KGZ KGZ 1997.0 male Bright Way, LLC 872032937.0 891 Cenrtal Ave Highland Park IL 60035 2023.0 SELECTED 1.0 6/29/2022 Denied 2/16/2023 BRIGHT WAY LLC 1B1 A A 1.0 M KYRGY F1 CHEF 1114 N ARLINGTON HEIGHTS ROAD ARLINGTON HEIGHTS IL 60004.0 Y 42000.0 YEAR 10/1/2022 9/30/2025 1.0 N N F BACHELOR'S DEGREE FOOD TECHNOLOGY 42000.0 199.0 722511.0 B Y 2023.0
18203 18203 LKA LKA 1987.0 female CPC TECHNOLOGIES LLC 845158047.0 5 E College Dr Arlington Hts IL 60004-1960 2023.0 SELECTED 0.0 6/30/2022 Approved 10/5/2022 CPC TECHNOLOGIES LLC 1B1 A A 1.0 F SRILA F1 SOFTWARE DEVELOPER 5 E COLLEGE DRIVE ARLINGTON HEIGHTS IL 60004.0 Y 91000.0 YEAR 10/5/2022 9/30/2025 6.0 N N F BACHELOR'S DEGREE SCIENCE BUSINESS ADMINISTRATION 91000.0 30.0 541511.0 B N 2023.0
21512 21512 PAN PAN 1991.0 male International Services, Inc. 363788558.0 3850 N Wilke Road Arlington Heights IL 60004 2023.0 SELECTED 1.0 6/9/2022 Approved 8/29/2022 INTERNATIONAL SERVICES INC 1B1 A A 1.0 M PANAM UU Valuation Analyst 3850 N WILKE RD ARLINGTON HEIGHTS IL 60004.0 Y 60341.0 YEAR 10/1/2022 9/30/2025 683.0 N N G MASTER'S DEGREE ENTREPRENEURSHIP 60341.0 191.0 541611.0 B N 2023.0

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Queries took 2130.507ms · Data source: Bloomberg FOIA Request