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

Home / Companies / AgStrata LLC

AgStrata 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
AgStrata LLC
AGSTRATA LLC
311FY2017 to FY2020
Latest decision 2020-06-15
2DATABASE DEVELOPER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings3
Certified LCAs3
Denied LCAs0
Role titles1
Worksites1
Latest decision2020-06-15
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
AGSTRATA LLCAgStrata LLC, AGSTRATA LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DATABASE DEVELOPER15-11322$60,000$60,000
Database Developer15-1132.00
Software Developers, Applications
1$72,675$87,130

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
HydroOK730483160,00087,1302,0172,020

Full company payload

Company IDcompany:agstrata
NameAgStrata LLC
Normalized Nameagstrata
Source Company Idscompany_dol_oflc_lca_agstrata_llc, company_uscis_h1b_datahub_agstrata_llc_tax_7197
Source NamesAgStrata LLC, AGSTRATA LLC
AliasesAGSTRATA LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7197",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 1,
  "worksite_count": 1,
  "first_fiscal_year": 2017,
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-06-15",
  "certified_count": 3,
  "denied_count": 0
}
Petition Activity
{
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2018",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Englewood"
      ],
      "states": [
        "CO"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "80112"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_agstrata_llc_tax_7197_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_049886"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Parker"
      ],
      "states": [
        "CO"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "80138"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_agstrata_llc_tax_7197_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_001653"
      ],
      "continuing_approval": 1
    }
  ]
}
Geography
{
  "states": [
    "OK",
    "CO"
  ],
  "cities": [
    "Hydro",
    "Englewood",
    "Parker"
  ],
  "postal_codes": [
    "73048",
    "80112",
    "80138"
  ],
  "top_markets": [
    {
      "city": "Hydro",
      "state": "OK",
      "postal_code": "73048",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 87130,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ]
}
Wage Summary
{
  "annualized_low_min": 60000,
  "annualized_high_max": 87130,
  "annualized_low_avg": 64225
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 60000,
    "wage_low_avg": 60000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 72675,
    "wage_high_max": 87130,
    "wage_low_avg": 72675
  }
]
Links
{
  "roles": "/v1/roles?company=AgStrata%20LLC",
  "wages": "/v1/wages?company=AgStrata%20LLC",
  "trends": "/v1/trends?company=AgStrata%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=agstrata+llc&limit=5JSON