home / datasette

trk_data

Data source: Bloomberg FOIA Request

7 rows where gender = "male" and worksite_zip = "98119.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country_of_birth, country_of_nationality, ben_year_of_birth, fein, mail_addr, city, state, zip, ben_multi_reg_ind, first_decision_date, i129_employer_name, ben_country_of_birth, ben_current_class, job_title, worksite_street, valid_to, num_of_emp_in_us, ben_education_code, ed_level_definition, ben_pfield_of_study, 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
6495 6495 CHN CHN 1993.0 male Expedia, Inc. 911996083.0 1111 Expedia Group Way W Seattle WA 98119 2023.0 SELECTED 1.0 6/3/2022 Approved 6/9/2022 EXPEDIA INC 1B1 A B 1.0 M CHINA F1 SOFTWARE DEVELOPMENT ENGINEER 1111 EXPEDIA GROUP WAY W SEATTLE WA 98119.0 Y 134680.0 YEAR 10/1/2022 8/24/2025 6999.0 N N G MASTER'S DEGREE COMPUTER SCIENCE 134680.0 30.0 5191.0 M N 2023.0
7754 7754 CHN CHN 1994.0 male Rec Room Inc. 811915556.0 300 Elliott Avenue W Seattle WA 98119 2023.0 SELECTED 0.0 6/29/2022 Approved 7/8/2022 REC ROOM INC 1B1 A B 1.0 M CHINA F1 SOFTWARE ENGINEER 300 ELLIOTT AVE W SEATTLE WA 98119.0 Y 102820.0 YEAR 10/1/2022 9/30/2025 203.0 N N F BACHELOR'S DEGREE ENTERTAINMENT TECHNOLOGY 102820.0 30.0 511210.0 M N 2023.0
14141 14141 ETH ETH 1987.0 male Expedia, Inc. 911996083.0 1111 Expedia Group Way W Seattle WA 98119 2023.0 SELECTED 0.0 6/24/2022 Approved 7/5/2022 EXPEDIA INC 1B1 A B 1.0 M ETHIO F1 SOFTWARE DEVELOPMENT ENGINEER 1111 EXPEDIA GROUP WAY W SEATTLE WA 98119.0 Y 135605.0 YEAR 10/1/2022 8/24/2025 6999.0 N N G MASTER'S DEGREE COMPUTER SCIENCE 135605.0 30.0 5191.0 M N 2023.0
17981 17981 KOR KOR 1998.0 male EAN.com, LP 421612329.0 5400 Lyndon B Johnson Fwy Dallas TX 75240-1019 2023.0 SELECTED 0.0 6/30/2022 Approved 7/5/2022 EAN.COM LP 1B1 A B 1.0 M SKORE F1 SOFTWARE ENGINEER 1111 EXPIDEIA GROUP WAY W SEATTLE WA 98119.0 Y 119000.0 YEAR 10/1/2022 9/30/2025 305.0 N N F BACHELOR'S DEGREE INFORMATION SYSTEMS 119000.0 30.0 5191.0 B N 2023.0
18922 18922 MEX MEX 1991.0 male Expedia, Inc. 911996083.0 1111 Expedia Group Way W Seattle WA 98119 2023.0 SELECTED 0.0 6/28/2022 Approved 7/8/2022 EXPEDIA INC 1B1 A B 1.0 M MEXIC TN SENIOR SOFTWARE DEVELOPMENT ENGINEER 1111 EXPEDIA GROUP WAY W SEATTLE WA 98119.0 Y 190134.0 YEAR 10/1/2022 8/10/2025 6999.0 N N F BACHELOR'S DEGREE COMPUTER SYSTEMS ENGINEERING 190134.0 30.0 5192.0 B N 2023.0
23965 23965 TWN TWN 1993.0 male Expedia, Inc. 911996083.0 1111 Expedia Group Way W Seattle WA 98119 2023.0 SELECTED 0.0 4/8/2022 Approved 4/13/2022 EXPEDIA INC 1B1 A B 1.0 M TAIWA F1 SOFTWARE DEVELOPMENT ENGINEER 1111 EXPEDIA GROUP WAY W SEATTLE WA 98119.0 Y 145000.0 YEAR 10/1/2022 8/24/2025 6999.0 N N F BACHELOR'S DEGREE ELECTRICAL ENGINEERING 145000.0 30.0 5191.0 M N 2023.0
25194 25194 VNM VNM 1999.0 male Expedia, Inc. 911996083.0 1111 Expedia Group Way W Seattle WA 98119 2023.0 SELECTED 0.0 6/28/2022 Approved 7/8/2022 EXPEDIA INC 1B1 A B 1.0 M VIETN F1 SOFTWARE DEVELOPMENT ENGINEER 1111 EXPEDIA GROUP WAY W SEATTLE WA 98119.0 Y 122542.0 YEAR 10/1/2022 8/2/2025 6999.0 N N F BACHELOR'S DEGREE COMPUTER SCIENCE 122542.0 30.0 5192.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 2147.548ms · Data source: Bloomberg FOIA Request