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.
Full company payload
| Company ID | company:ks2 tx pc |
| Name | KS2 TX, PC |
| Normalized Name | ks2 tx pc |
| Source Company Ids | company_dol_oflc_lca_ks2_tx_pc, company_uscis_h1b_datahub_ks2_tx_pc_d_b_a_kool_smiles_tax_7724, company_uscis_h1b_datahub_ks2_tx_pc_dba_kool_smiles_tax_7724, company_uscis_h1b_datahub_ks2_tx_pc_d_b_a_kool_smiles_pc_tax_3986 |
| Source Names | KS2 TX, PC, KS2 TX PC D/B/A KOOL SMILES, KS2 TX PC DBA KOOL SMILES, KS2 TX PC D/B/A KOOL SMILES PC |
| Aliases | KOOL SMILES, KS2 TX PC D/B/A KOOL SMILES, KS2 TX PC DBA KOOL SMILES, KS2 TX PC D/B/A KOOL SMILES PC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "7724",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "3986",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 37,
"case_count": 37,
"role_title_count": 1,
"worksite_count": 21,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-01",
"certified_count": 37,
"denied_count": 0
}Petition Activity
{
"total_approval": 16,
"total_denial": 0,
"fiscal_years": [
"2015",
"2016",
"2017",
"2018"
],
"year_metrics": [
{
"cities": [
"Marietta"
],
"states": [
"GA"
],
"fiscal_year": 2015,
"naics_codes": [
"33",
"62"
],
"postal_codes": [
"30067"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_ks2_tx_pc_d_b_a_kool_smiles_tax_7724_2015",
"source_record_ids": [
"sr_uscis_h1b_datahub_2015_row_013932",
"sr_uscis_h1b_datahub_2015_row_013933"
],
"continuing_approval": 2
},
{
"cities": [
"Marietta"
],
"states": [
"GA"
],
"fiscal_year": 2018,
"naics_codes": [
"62"
],
"postal_codes": [
"30067"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 3,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_ks2_tx_pc_d_b_a_kool_smiles_tax_7724_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_013860"
],
"continuing_approval": 1
},
{
"cities": [
"Marietta"
],
"states": [
"GA"
],
"fiscal_year": 2016,
"naics_codes": [
"62"
],
"postal_codes": [
"30067"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_ks2_tx_pc_dba_kool_smiles_tax_7724_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_014523"
],
"continuing_approval": 1
},
{
"cities": [
"Marietta"
],
"states": [
"GA"
],
"fiscal_year": 2017,
"naics_codes": [
"62"
],
"postal_codes": [
"30067"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_ks2_tx_pc_dba_kool_smiles_tax_7724_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_012972"
],
"continuing_approval": 1
},
{
"cities": [
"Marietta"
],
"states": [
"GA"
],
"fiscal_year": 2016,
"naics_codes": [
"62"
],
"postal_codes": [
"30067"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_ks2_tx_pc_d_b_a_kool_smiles_pc_tax_3986_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_009865"
],
"continuing_approval": 0
}
]
}Geography
{
"states": [
"TX",
"GA"
],
"cities": [
"Longview",
"Abilene",
"El Paso",
"Lubbock",
"Odessa",
"San Angelo",
"Tyler",
"Bryan",
"Killeen",
"Lufkin",
"Mcallen",
"Midland",
"San Antonio",
"Waco",
"Weslaco",
"Wichita Falls",
"Marietta"
],
"postal_codes": [
"75605",
"79605",
"79907",
"79936",
"79925",
"79415",
"79763",
"76901",
"75701",
"77802",
"79912",
"79924",
"76543",
"75901",
"78501",
"79701",
"78223",
"78238",
"76710",
"78596",
"76308",
"30067"
],
"top_markets": [
{
"city": "Longview",
"state": "TX",
"postal_code": "75605",
"lca_count": 5,
"role_title_count": 1,
"wage_low_min": 131040,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Abilene",
"state": "TX",
"postal_code": "79605",
"lca_count": 4,
"role_title_count": 1,
"wage_low_min": 150000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018
},
{
"city": "El Paso",
"state": "TX",
"postal_code": "79907",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 125000,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "El Paso",
"state": "TX",
"postal_code": "79936",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 125000,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "El Paso",
"state": "TX",
"postal_code": "79925",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 156000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018
},
{
"city": "Lubbock",
"state": "TX",
"postal_code": "79415",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 150000,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Odessa",
"state": "TX",
"postal_code": "79763",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 150000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
},
{
"city": "San Angelo",
"state": "TX",
"postal_code": "76901",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 130000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018
},
{
"city": "Tyler",
"state": "TX",
"postal_code": "75701",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 131040,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017
},
{
"city": "Bryan",
"state": "TX",
"postal_code": "77802",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 168480,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
}
]
}Industry
{
"naics_codes": [
"621210",
"33",
"62"
]
}Wage Summary
{
"annualized_low_min": 125000,
"annualized_high_max": 0,
"annualized_low_avg": 150698.378378378
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 7,
"case_count": 7,
"role_title_count": 1,
"worksite_count": 5,
"wage_low_min": 125000,
"wage_high_max": 0,
"wage_low_avg": 130297.142857143
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 24,
"case_count": 24,
"role_title_count": 1,
"worksite_count": 18,
"wage_low_min": 125000,
"wage_high_max": 0,
"wage_low_avg": 157156.666666667
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 6,
"case_count": 6,
"role_title_count": 1,
"worksite_count": 6,
"wage_low_min": 130000,
"wage_high_max": 0,
"wage_low_avg": 148666.666666667
}
]Links
{
"roles": "/v1/roles?company=KS2%20TX%2C%20PC",
"wages": "/v1/wages?company=KS2%20TX%2C%20PC",
"trends": "/v1/trends?company=KS2%20TX%2C%20PC"
}