home / datasette

trk_data

Data source: Bloomberg FOIA Request

13 rows where gender = "male" and worksite_zip = "30005.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, i129_employer_name, requested_action, number_of_beneficiaries, ben_country_of_birth, ben_current_class, job_title, worksite_street, wage_amt, valid_from, valid_to, num_of_emp_in_us, s1q1a, 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
1009 1009 BOL BOL 1997.0 male ETrade Securities LLC 352167612.0 1585 Broadway New York NY 10036 2023.0 SELECTED 0.0 6/29/2022 Approved 7/12/2022 ETRADE SECURITIES LLC 1B1 A B 1.0 M BOLIV F1 ANALYST 3 EDISON DRIVE ALPHARETTA GA 30005.0 Y 70000.0 YEAR 10/1/2022 9/30/2025 69545.62016407946 N N F BACHELOR'S DEGREE BUSINESS ADMINISTRATION WITH A CONCENTRATION IN BUSINESS INFORMATION TECH AND BUSINESS MANAGEMENT 70000.0 33.0 523110.0 B N 2023.0
5043 5043 CHN CHN 1991.0 male Change Healthcare Technologies, LLC 581651222.0 5995 Windward Parkway Alpharetta GA 30005 2023.0 SELECTED 0.0 6/15/2022 Approved 7/23/2022 CHANGE HEALTHCARE TECHNOLOGIES LLC 1B1 A B 1.0 M CHINA F1 DATA SCIENTIST III 5995 WINDWARD PARKWAY ALPHARETTA GA 30005.0 Y 130000.0 YEAR 10/1/2022 9/30/2025 15000.0 N N I DOCTORATE DEGREE MECHANICAL ENGINEERING 130000.0 20.0 541900.0 M N 2023.0
9102 9102 CHN CHN 1995.0 male Total System Services LLC 581493818.0 1 Tsys Way Columbus GA 31901-4222 2023.0 SELECTED 0.0 6/6/2022 Approved 6/14/2022 TOTAL SYSTEM SERVICES LLC 1B1 A B 1.0 M CHINA F1 Software Engineer I 5995 WINDWARD PKWY ALPHARETTA GA 30005.0 Y 77000.0 YEAR 10/1/2022 9/30/2025 13000.0 N N G MASTER'S DEGREE COMP SCI & ENGRG 77000.0 30.0 522390.0 M N 2023.0
13013 13013 CMR CMR 1993.0 male DataSeers Incorporated 820753359.0 3015 Windward Plaza Alpharetta GA 30005 2023.0 SELECTED 0.0 6/28/2022 Approved 7/20/2022 DATASEERS INCORPORATED 1B1 A B 1.0 M CAMER F1 ETL DEVELOPER 3025 WINDWARD PLAZA ALPHARETTA GA 30005.0 Y 75670.0 YEAR 10/1/2022 9/30/2025 15.0 N N F BACHELOR'S DEGREE COMPUTER SCIENCE 75670.0 30.0 511210.0 B N 2023.0
15191 15191 HKG CAN 1991.0 male Siemens Industry, Inc. 132762488.0 1000 Deerfield Parkway Buffalo Grove IL 60089-4547 2023.0 SELECTED 0.0 6/10/2022 Approved 6/17/2022 SIEMENS INDUSTRY INC 1B1 A A 1.0 M HONGK F1 STRATEGY AND DIGITAL BUSINESS KEY EXPERT CONSULTANT 1000 TECHNOLOGY DRIVE ALPHARETTA GA 30005.0 Y 145000.0 YEAR 10/1/2022 9/30/2025 49937.0 N N F BACHELOR'S DEGREE SOCIAL SCIENCES PHILOSOPHY POLITICS AND LAW 145000.0 161.0 541330.0 B N 2023.0
15580 15580 IND AUS 1974.0 male Rivic Systems Inc. 813530272.0 4080 Mcginnis Ferry Rd Ste 1208 Alpharetta GA 30005-1773 2023.0 SELECTED 0.0 6/21/2022 Denied 4/24/2023 RIVIC SYSTEMS INC 1B1 A A 0.9999597536925987 M INDIA F1 Software Developer 4080 MCGINNIS FERRY RD ALPHARETTA GA 30005.0 Y 87500.0 YEAR 10/1/2022 9/30/2025 9.0 N N F BACHELOR'S DEGREE PRODUCTION ENGINEERING COMPUTER INTEGRATED MANUFACTURING 87500.0 30.0 541512.0 B N 2023.0
15618 15618 IND BEL 1979.0 male RAPIDIT INC 30529614.0 4080 Mcginnis Ferry Rd Alpharetta GA 30005-1773 2023.0 SELECTED 1.0 6/27/2022 Approved 1/17/2023 RAPIDIT INC 1B1 A A 1.0 M INDIA F1 SOFTWARE ENGINEER 4080 MCGINNIS FERRY RD ALPHARETTA GA 30005.0 Y 88000.0 YEAR 1/17/2023 9/30/2025 103.0 Y N F BACHELOR'S DEGREE BACHELOR OF MECH ENGRG 88000.0 30.0 541511.0 B N 2023.0
15630 15630 IND CAN 1971.0 male Adroix Corp 273349132.0 3970 Old Milton Pkwy Alpharetta GA 30005-6410 2023.0 SELECTED 0.0 6/17/2022 Approved 10/5/2022 ADROIX CORP DBA CODEFORCE 360 1B1 A B 1.0 M INDIA UU SOFTWARE ENGINEER 3970 OLD MILTON PARKWAY ALPHARETTA GA 30005.0 Y 102000.0 YEAR 10/5/2022 9/30/2025 200.0 Y N F BACHELOR'S DEGREE ENGINEERING 102000.0 30.0 541511.0 B N 2023.0
15870 15870 IND GBR 1970.0 male RWaltz Software Services Group Inc. 251877047.0 5910 Shiloh Rd E Alpharetta GA 30005-1718 2023.0 SELECTED 0.0 6/30/2022 Approved 3/3/2023 RWALTZ SOFTWARE SERVICES GROUP INC 1B1 A A 1.0 M INDIA UU SOFTWARE ENGINEER 5910 SHILOH RD E ALPHARETTA GA 30005.0 Y 80500.0 YEAR 3/3/2023 9/30/2025 27.0 Y N F BACHELOR'S DEGREE INFORMATION TECHNOLOGY 80500.0 30.0 541511.0 B N 2023.0
17885 17885 KOR KOR 1996.0 male ADP Technology Services, Inc. 273727214.0 1 Adp Blvd. Roseland NJ 07068-1728 2023.0 SELECTED 0.0 6/21/2022 Approved 8/4/2022 ADP TECHNOLOGY SERVICES INC 1B1 A B 1.0 M KOREA F1 ASSOCIATE APPLICATION DEVELOPER 5800 WINDWARD PARKWAY ALPHARETTA GA 30005.0 Y 85000.0 YEAR 10/1/2022 9/27/2025 30840.0 N N F BACHELOR'S DEGREE COMPUTER SCIENCE 85000.0 30.0 518210.0 B N 2023.0
21073 21073 PAK PAK 1988.0 male Conflux Systems, Inc 261206788.0 11539 Park Woods Circle, Alpharetta GA 30005 2023.0 SELECTED 1.0 6/29/2022 Approved 11/8/2022 CONFLUX SYSTEMS INC 1B1 A B 1.0 M PAKIS F1 SOFTWARE DEVELOPER 11539 PARK WOODS CIRCLE ALPHARETTA GA 30005.0 Y 88000.0 YEAR 11/8/2022 9/30/2025 337.0 Y N F BACHELOR'S DEGREE BUSINESS ADMINISTRATION 88000.0 30.0 541511.0 B Y 2023.0
21686 21686 PHL PHL 1970.0 male Georgia IT Inc 260704271.0 5490 Mcginnis Village Pl Ste 203 Alpharetta GA 30005-1735 2023.0 SELECTED 0.0 6/27/2022 Approved 10/15/2022 GEORGIA IT INC 1B1 A A 1.0 M PHILI F1 NETWORK SUPERVISOR DATACENTER 5490 MCGINNIS VILLAGE PL ALPHARETTA GA 30005.0 Y 97469.0 YEAR 10/15/2022 9/30/2025 16.0 N N F BACHELOR'S DEGREE ELECTRONICS COMMUNICATION ENGINEERING TECHNOLOGY 97469.0 30.0 541511.0 B N 2023.0
24419 24419 TZA TZA 1989.0 male Total System Services LLC 581493818.0 1 Tsys Way Columbus GA 31901-4222 2023.0 SELECTED 0.0 4/22/2022 Approved 4/27/2022 TOTAL SYSTEM SERVICES LLC 1B1 A B 1.0 M TANZA F1 SOFTWARE ENGINEER II 5995 WINDWARD PARKWAY ALPHARETTA GA 30005.0 Y 87000.0 YEAR 10/1/2022 9/30/2025 13000.0 N N G MASTER'S DEGREE MS OF SCIENCE IN COMPUTER SCIENCE 87000.0 30.0 522390.0 M 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 3012.564ms · Data source: Bloomberg FOIA Request