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

Home / Companies / DATAPILLARS INC.

DATAPILLARS INC. 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
DATAPILLARS INC.
DATAPILLARS INC
321FY2017 to FY2020
Latest decision 2020-08-12
2MICROSTRATEGY PROGRAMMER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings3
Certified LCAs3
Denied LCAs0
Role titles2
Worksites1
Latest decision2020-08-12
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
DATAPILLARS INCDATAPILLARS INC., DATAPILLARS INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MICROSTRATEGY PROGRAMMER15-1132.00
Software Developers, Applications
2$139,360$139,360
MICROSTRATEGY DEVELOPER15-11311$89,440$97,760

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
WashingtonDC200023289,440139,3602,0172,020

Full company payload

Company IDcompany:datapillars
NameDATAPILLARS INC.
Normalized Namedatapillars
Source Company Idscompany_dol_oflc_lca_datapillars_inc, company_uscis_h1b_datahub_datapillars_inc_tax_2470
Source NamesDATAPILLARS INC., DATAPILLARS INC
AliasesDATAPILLARS INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "DATAPILLARS INC.",
    "DATAPILLARS INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "DATAPILLARS INC",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DATAPILLARS INC.",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DATAPILLARS INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2470",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 2,
  "worksite_count": 1,
  "total_workers": 3,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-09-23",
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-08-12",
  "certified_count": 3,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2018",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Washington"
      ],
      "states": [
        "DC"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "20002"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_datapillars_inc_tax_2470_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_031837"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Washington"
      ],
      "states": [
        "DC"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20002"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_datapillars_inc_tax_2470_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_013155"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "WASHINGTON DC 20002",
      "city": "Washington",
      "state": "DC",
      "postal_code": "20002",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-08-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WASHINGTON DC 20002",
      "city": "Washington",
      "county": "District Of Columbia",
      "state": "DC",
      "postal_code": "20002",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-08-12",
      "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": [
    "DC"
  ],
  "cities": [
    "Washington"
  ],
  "postal_codes": [
    "20002"
  ],
  "top_markets": [
    {
      "city": "Washington",
      "state": "DC",
      "postal_code": "20002",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 89440,
      "wage_high_max": 139360,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54",
    "99"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 89440,
  "annualized_high_max": 139360,
  "annualized_low_avg": 122720
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 89440,
    "wage_high_max": 97760,
    "wage_low_avg": 89440
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 139360,
    "wage_high_max": 139360,
    "wage_low_avg": 139360
  }
]
Links
{
  "roles": "/v1/roles?company=DATAPILLARS%20INC.",
  "wages": "/v1/wages?company=DATAPILLARS%20INC.",
  "trends": "/v1/trends?company=DATAPILLARS%20INC."
}
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=datapillars+inc&limit=5JSON