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

Home / Companies / PYPESTREAM LLC

PYPESTREAM LLC 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
PYPESTREAM LLC
PYPESTREAM LLC
111FY2017 to FY2017
Latest decision 2017-08-24
1MARKETING SPECIALIST
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings1
Certified LCAs1
Denied LCAs0
Role titles1
Worksites1
Latest decision2017-08-24
USCIS approvals1
USCIS denials0

Aliases and source names

AliasesSource NamesSources
PYPESTREAM LLCPYPESTREAM LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MARKETING SPECIALIST13-11611$75,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
New YorkNY100011175,00002,0172,017

Full company payload

Company IDcompany:pypestream
NamePYPESTREAM LLC
Normalized Namepypestream
Source Company Idscompany_dol_oflc_lca_pypestream_llc, company_uscis_h1b_datahub_pypestream_llc_tax_5480
Source NamesPYPESTREAM LLC
AliasesPYPESTREAM LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "PYPESTREAM LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "PYPESTREAM LLC",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "PYPESTREAM LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5480",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 1,
  "case_count": 1,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 1,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-08-19",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-08-24",
  "certified_count": 1,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "E-3 Australian",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 1,
  "total_denial": 0,
  "fiscal_years": [
    "2015"
  ],
  "year_metrics": [
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10003"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_pypestream_llc_tax_5480_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_020806"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10001",
      "city": "New York",
      "state": "NY",
      "postal_code": "10001",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10001",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10001",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-24",
      "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": [
    "10001",
    "10003"
  ],
  "top_markets": [
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10001",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 75000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541613",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541613",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 75000,
  "annualized_high_max": 0,
  "annualized_low_avg": 75000
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 75000,
    "wage_high_max": 0,
    "wage_low_avg": 75000
  }
]
Links
{
  "roles": "/v1/roles?company=PYPESTREAM%20LLC",
  "wages": "/v1/wages?company=PYPESTREAM%20LLC",
  "trends": "/v1/trends?company=PYPESTREAM%20LLC"
}
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=pypestream+llc&limit=5JSON