home / datasette

trk_data

Data source: Bloomberg FOIA Request

9 rows where num_of_emp_in_us = "330.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country_of_birth, country_of_nationality, gender, fein, mail_addr, city, state, zip, first_decision_date, i129_employer_name, requested_action, ben_sex, ben_country_of_birth, ben_current_class, job_title, worksite_street, worksite_city, worksite_state, worksite_zip, valid_from, valid_to, ben_education_code, ed_level_definition, 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
4890 4890 CHN CHN 1991.0 female QIAGEN Sciences, LLC 263811768.0 19300 Germantown Road Germantown MD 20874 2023.0 SELECTED 0.0 5/20/2022 Approved 5/26/2022 QIAGEN SCIENCES LLC 1B1 A B 1.0 F CHINA F1 BIOINFORMATICS SCEINTIST 6951 EXECUTIVE WAY FREDERICK MD 21703.0 Y 95000.0 YEAR 10/1/2022 9/30/2025 330.0 N N I DOCTORATE DEGREE COMPUTATIONAL BIOLOGY AND BIOINFORMATICS 95000.0 39.0 5417.0 B N 2023.0
7088 7088 CHN CHN 1994.0 female MediaMath Inc. 270611297.0 4 World Trade Center, 150 Greenwich St. New York NY 10007 2023.0 SELECTED 0.0 5/27/2022 Approved 6/8/2022 MEDIAMATH INC 1B1 A B 1.0 F CHINA F1 SOFTWARE ENGINEER 8730 COSTA VERDE VILLAGE SAN DIEGO CA 92122.0 Y 75000.0 YEAR 10/1/2022 9/30/2025 330.0 N N F BACHELOR'S DEGREE BUSINESS ANALYTICS 75000.0 20.0 541830.0 M N 2023.0
13444 13444 CYP GBR 1996.0 male QIAGEN Sciences, LLC 263811768.0 19300 Germantown Road Germantown MD 20874 2023.0 SELECTED 0.0 6/8/2022 Approved 6/28/2022 QIAGEN SCIENCES LLC 1B1 A B 1.0 M CYPRU F1 ASSOCIATE OPERATIONS PRODUCT MANAGER 6951 EXECUTIVE WAY FREDERICK MD 21703.0 Y 69430.0 YEAR 10/1/2022 9/30/2025 330.0 N N F BACHELOR'S DEGREE BIOTECHNOLOGY 69430.0 41.0 5417.0 B N 2023.0
14114 14114 ESP IRN 1988.0 male Sezzle, Inc. 810971660.0 251 North 1st Avenue Minneapolis MN 55401 2023.0 SELECTED 0.0 6/27/2022 Approved 7/7/2022 SEZZLE INC 1B1 A A 1.0 M SPAIN UU SOFTWARE ENGINEER 251 NORTH 1ST AVENUE MINNEAPOLIS MN 55401.0 Y 151000.0 YEAR 10/1/2022 9/30/2025 330.0 N N F BACHELOR'S DEGREE ELECTRICAL & COMP ENGRG 151000.0 30.0 541511.0 B N 2023.0
16568 16568 ISR XXA 1993.0 male TeleTracking Technologies, Inc. 251828750.0 336 Fourth Avenue Pittsburgh PA 15222-2004 2023.0 SELECTED 0.0 4/27/2022 Approved 6/27/2022 TELETRACKING TECHNOLOGIES INC 1B1 A B 1.0 M PALES F1 SOFTWARE ENGINEER II 336 FOURTH AVENUE THE TIMES BUILDING PITTSBURGH PA 56905.48740771989 Y 100339.0 YEAR 10/1/2022 9/1/2025 330.0 N N F BACHELOR'S DEGREE COMPUTER SYSTEMS ENGINEERING 100339.0 30.0 541511.0 B N 2023.0
19472 19472 MYS MYS 1998.0 male Sezzle, Inc. 810971660.0 251 North 1st Avenue Minneapolis MN 55401 2023.0 SELECTED 0.0 6/24/2022 Approved 7/5/2022 SEZZLE INC 1B1 A B 1.0 M MALAY F1 Software Engineer I 251 1ST AVE N MINNEAPOLIS MN 56905.48740771989 Y 84000.0 YEAR 10/1/2022 9/30/2025 330.0 N N F BACHELOR'S DEGREE COMPUTATIONAL PHYSICS 84000.0 30.0 541511.0 B N 2023.0
19828 19828 NGA NGA 1995.0 female Sezzle, Inc. 810971660.0 251 North 1st Avenue Minneapolis MN 55401 2023.0 SELECTED 0.0 6/24/2022 Approved 7/4/2022 SEZZLE INC 1B1 A B 1.0 F NIGIA F1 SOFTWARE ENGINEER II 251 N 1ST AVE MINNEAPOLIS MN 55401.0 Y 102500.0 YEAR 10/1/2022 9/30/2025 330.0 N N F BACHELOR'S DEGREE COMPUTER SCIENCE 102500.0 30.0 541511.0 B N 2023.0
22117 22117 ROU ROU 1984.0 female SCHENKER AMERICAS, INC. 813229612.0 800 Nw 62nd Ave Miami FL 33126-4998 2023.0 SELECTED 0.0 6/24/2022 Approved 10/25/2022 SCHENKER AMERICAS INC 1B1 A A 1.0 F ROMAN L1B SOFTWARE ENGINEER 800 NW 62ND AVE MIAMI FL 33126.0 Y 82000.0 YEAR 10/25/2022 9/3/2024 330.0 N N F BACHELOR'S DEGREE FINANCE 82000.0 162.0 551114.0 B N 2023.0
22191 22191 RUS RUS 1976.0 male Sezzle, Inc. 810971660.0 251 North 1st Avenue Minneapolis MN 55401 2023.0 SELECTED 0.0 6/24/2022 Approved 7/7/2022 SEZZLE INC 1B1 A A 1.0 M RUSSI F1 ENGINEER MANAGER 251 N 1ST AVE MINNEAPOLIS MN 55401.0 Y 179026.0 YEAR 10/1/2022 9/30/2025 330.0 N N F BACHELOR'S DEGREE MATHEMATICS COMPUTER SCIENCE 179026.0 169.0 541511.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 1756.925ms · Data source: Bloomberg FOIA Request