trk_data

Data source: Bloomberg FOIA Request

5 rows where city = "Charleston", first_decision = "Approved" and s1q1b = "N"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: gender, zip, requested_action, ben_sex, worksite_city, worksite_state, worksite_zip, dot_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
474 474 BEL BEL 1997.0 male Beemok Management, LLC 853593760.0 200 Meeting Street Charleston SC 29401 2023.0 SELECTED 0.0 6/30/2022 Approved 8/20/2022 BEEMOK MANAGEMENT LLC 1B1 A B 1.0 M BELGI F1 account manager 1513 MATHIS FERRY RD MOUNT PLEASANT SC 29464.0 Y 70000.0 YEAR 10/1/2022 9/30/2025 53.0 N N F BACHELOR'S DEGREE ECONOMICS 70000.0 199.0 55111.0 B N 2023.0
1461 1461 BRA BRA 1994.0 female Century Restaurants 825344105.0 295 Seven Farms Drive Charleston SC 29492 2023.0 SELECTED 0.0 5/25/2022 Approved 6/6/2022 CENTURY RESTAURANTS INC 1B1 A B 1.0 F BRAZI F1 QUALITY ASSURANCE & CONTINUED TRAINING COORDINATOR QAACT 6 FLAGSTONE DR HUDSON NH 3051.0 Y 60000.0 YEAR 10/1/2022 9/30/2025 800.0 N N F BACHELOR'S DEGREE MBA BUSINESS ADMINISTRATION LEADERSHIP 60000.0 168.0 722513.0 B N 2023.0
2676 2676 CHL CHL 1996.0 male Randy Pate Tennis Academy, Inc. 202406272.0 1107 Barfield Street Charleston SC 29492 2023.0 SELECTED 0.0 6/30/2022 Approved 7/25/2022 RANDY PATE TENNIS ACADEMY INC DBA PATE ACADEMY AT LTP TENNIS 1B1 A B 1.0 M CHILE F1 SOUTH AMERICA BUSINESS DEVELOPMENT PLAYER TRAINING SPEC 1513 MATHIS FERRY ROAD MOUNT PLEASANT SC 29464.0 Y 39000.0 YEAR 10/1/2022 9/30/2025 6.0 N N F BACHELOR'S DEGREE BUSINESS ADMINISTRATION AND MANAGEMENT 39000.0 169.0 611620.0 B N 2023.0
15304 15304 HKG GBR 1989.0 female The Charleston Library Society 570314372.0 164 King Street Charleston SC 29401 2023.0 SELECTED 0.0 5/31/2022 Approved 7/28/2022 THE CHARLESTON LIBRARY SOCIETY 1B1 A B 1.0 F HONGK F1 SOFTWARE ENGINEER 164 KING ST CHARLESTON SC 29401.0 Y 42037.0 YEAR 10/1/2022 9/30/2025 16.0 N N F BACHELOR'S DEGREE ARTS MGT 42037.0 999.0 467727.31226619415 B N 2023.0
22025 22025 POL POL 1995.0 female Obviouslee Marketing 203137343.0 654 King St Charleston SC 29403-4854 2023.0 SELECTED 0.0 6/29/2022 Approved 8/31/2022 OBVIOUSLEE MARKETING 1B1 A A 1.0 F POLAN F1 DIGITAL MARKETING ANALYST 654 KING ST CHARLESTON SC 29403.0 Y 45000.0 YEAR 10/1/2022 9/30/2025 28.0 N N F BACHELOR'S DEGREE MARKETING 45000.0 169.0 541613.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]);