bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / COLUMBIA ACUPUNCTURE PC

COLUMBIA ACUPUNCTURE PC H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
COLUMBIA ACUPUNCTURE PC
COLUMBIA ACUPUNCTURE PC
611FY2016 to FY2016
Latest decision 2016-03-30
4BUSINESS OPERATIONS SPECIALIST
6 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings6
Certified LCAs6
Denied LCAs0
Role titles1
Worksites1
Latest decision2016-03-30
USCIS approvals4
USCIS denials0

Aliases and source names

AliasesSource NamesSources
COLUMBIA ACUPUNCTURE PCCOLUMBIA ACUPUNCTURE PCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
BUSINESS OPERATIONS SPECIALIST13-11996$47,819$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
New YorkNY100326147,81902,0162,016

Full company payload

Company IDcompany:columbia acupuncture pc
NameCOLUMBIA ACUPUNCTURE PC
Normalized Namecolumbia acupuncture pc
Source Company Idscompany_dol_oflc_lca_columbia_acupuncture_pc, company_uscis_h1b_datahub_columbia_acupuncture_pc_tax_3651
Source NamesCOLUMBIA ACUPUNCTURE PC
AliasesCOLUMBIA ACUPUNCTURE PC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "COLUMBIA ACUPUNCTURE PC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "COLUMBIA ACUPUNCTURE PC",
      "filing_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBIA ACUPUNCTURE PC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3651",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 6,
  "case_count": 6,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 6,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-24",
  "latest_fiscal_year": 2016,
  "latest_decision_date": "2016-03-30",
  "certified_count": 6,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": []
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 4,
  "total_denial": 0,
  "fiscal_years": [
    "2015",
    "2017",
    "2018",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "10032"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_acupuncture_pc_tax_3651_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_044834"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "10032"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_acupuncture_pc_tax_3651_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_046087"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "10032"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_acupuncture_pc_tax_3651_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_052056"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "10032"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_acupuncture_pc_tax_3651_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_010990"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10032",
      "city": "New York",
      "state": "NY",
      "postal_code": "10032",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10032",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10032",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 1,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "NY"
  ],
  "cities": [
    "New York"
  ],
  "postal_codes": [
    "10032"
  ],
  "top_markets": [
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10032",
      "lca_count": 6,
      "role_title_count": 1,
      "wage_low_min": 47819,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "62"
  ],
  "naics_breakdown": []
}
Wage Summary
{
  "annualized_low_min": 47819,
  "annualized_high_max": 0,
  "annualized_low_avg": 47829.5
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 47819,
    "wage_high_max": 0,
    "wage_low_avg": 47829.5
  }
]
Links
{
  "roles": "/v1/roles?company=COLUMBIA%20ACUPUNCTURE%20PC",
  "wages": "/v1/wages?company=COLUMBIA%20ACUPUNCTURE%20PC",
  "trends": "/v1/trends?company=COLUMBIA%20ACUPUNCTURE%20PC"
}
Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=columbia+acupuncture+pc&limit=5JSON