Ceiling Rates Document
Ceiling Rate Search View Set
GET /api/v3/search/ceilingrates/?search=labor_category:Project+Manager+II&page=1&page_size=100&filter=education_level:BA%7CHS%7CMA&filter=price_range:60,130&filter=experience_range:3,40&filter=business_size:S&filter=site:customer
{
"took": 15,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 7,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_index": "ceilingrates",
"_id": "6425899",
"_score": null,
"_source": {
"contract_end": "2026-12-22",
"security_clearance": "No",
"next_year_price": 69.0,
"second_year_price": 70.8,
"vendor_name": "PARKER TIDE CORP.",
"idv_piid": "47QREA22D000G",
"business_size": "S",
"contract_start": "2021-12-23",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated",
"cont_end_dtg": "20261222",
"min_years_experience": 4,
"sin": "561320SBSA",
"worksite": "Customer Facility",
"education_level": "BA",
"id": 6425899,
"current_price": 69.0,
"dt_termg": null,
"category": "Office Management;Miscellaneous",
"subcategory": "Office Services;Complementary SINs",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20211223"
},
"sort": [
69.0
]
},
{
"_index": "ceilingrates",
"_id": "6365051",
"_score": null,
"_source": {
"contract_end": "2029-07-14",
"security_clearance": "No",
"next_year_price": 85.62,
"second_year_price": 87.55,
"vendor_name": "GRANNY'S ALLIANCE HOLDINGS, INC.",
"idv_piid": "47QSMS24D009F",
"business_size": "S",
"contract_start": "2024-07-15",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated Refresh 15+",
"cont_end_dtg": "20290714",
"min_years_experience": 8,
"sin": "238910",
"worksite": "Customer Facility",
"education_level": "BA",
"id": 6365051,
"current_price": 85.62,
"dt_termg": null,
"category": "Miscellaneous;Facilities",
"subcategory": "Structures;Complementary SINs",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20240715"
},
"sort": [
85.62
]
},
{
"_index": "ceilingrates",
"_id": "6430871",
"_score": null,
"_source": {
"contract_end": "2029-12-08",
"security_clearance": "No",
"next_year_price": 87.12,
"second_year_price": 87.12,
"vendor_name": "UNITED SUPPORT SERVICES, INC.",
"idv_piid": "47QSMS25D0029",
"business_size": "S",
"contract_start": "2024-12-09",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated Refresh 15+",
"cont_end_dtg": "20291208",
"min_years_experience": 3,
"sin": "541330ENG",
"worksite": "Customer Facility",
"education_level": "BA",
"id": 6430871,
"current_price": 87.12,
"dt_termg": null,
"category": "Information Technology;Professional Services;Miscellaneous;Transportation and Logistics Services",
"subcategory": "Motor Vehicles (non-Combat);Technical and Engineering Services (Non IT);Complementary SINs;IT Services",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20241209"
},
"sort": [
87.12
]
},
{
"_index": "ceilingrates",
"_id": "6382675",
"_score": null,
"_source": {
"contract_end": "2029-06-13",
"security_clearance": "No",
"next_year_price": 116.88,
"second_year_price": 120.85,
"vendor_name": "OPUS FEDERAL LLC",
"idv_piid": "47QRAA24D009C",
"business_size": "S",
"contract_start": "2024-06-14",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated Refresh 15+",
"cont_end_dtg": "20290613",
"min_years_experience": 7,
"sin": "54151S",
"worksite": "Customer Facility",
"education_level": "BA",
"id": 6382675,
"current_price": 116.88,
"dt_termg": null,
"category": "Information Technology;Professional Services;Miscellaneous",
"subcategory": "Business Administrative Services;Complementary SINs;IT Services",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20240614"
},
"sort": [
116.88
]
},
{
"_index": "ceilingrates",
"_id": "6416738",
"_score": null,
"_source": {
"contract_end": "2027-08-30",
"security_clearance": "None",
"next_year_price": 120.86,
"second_year_price": null,
"vendor_name": "GLOBAL SYSTEMS TECHNOLOGIES, LLC",
"idv_piid": "GS10F0461Y",
"business_size": "S",
"contract_start": "2012-08-31",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated MOD",
"cont_end_dtg": "20270830",
"min_years_experience": 5,
"sin": "541330ENG, 541380, \n541420, 541715, OLM",
"worksite": "Customer Facility",
"education_level": "BA",
"id": 6416738,
"current_price": 117.68,
"dt_termg": null,
"category": "Professional Services;Miscellaneous;Scientific Management and Solutions",
"subcategory": "Technical and Engineering Services (Non IT);Complementary SINs;Testing and Analysis",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20120831"
},
"sort": [
117.68
]
},
{
"_index": "ceilingrates",
"_id": "6323428",
"_score": null,
"_source": {
"contract_end": "2028-02-23",
"security_clearance": "No",
"next_year_price": 118.79,
"second_year_price": 123.54,
"vendor_name": "PHOTON EFLUX, LLC",
"idv_piid": "47QRAA23D0048",
"business_size": "S",
"contract_start": "2023-02-24",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated",
"cont_end_dtg": "20280223",
"min_years_experience": 4,
"sin": "541330ENG, 541330EMI, 541715, 541420, 541540",
"worksite": "Customer Facility",
"education_level": "BA",
"id": 6323428,
"current_price": 118.79,
"dt_termg": null,
"category": "Professional Services;Miscellaneous;Scientific Management and Solutions",
"subcategory": "Technical and Engineering Services (Non IT);Complementary SINs;Testing and Analysis",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20230224"
},
"sort": [
118.79
]
},
{
"_index": "ceilingrates",
"_id": "6386913",
"_score": null,
"_source": {
"contract_end": "2029-05-30",
"security_clearance": "No",
"next_year_price": 124.38,
"second_year_price": 128.86,
"vendor_name": "STRATEGIC MANAGEMENT SOLUTIONS, LLC",
"idv_piid": "47QRAA19D008M",
"business_size": "S",
"contract_start": "2019-05-31",
"labor_category": "Project Manager II",
"schedule": "MAS Consolidated MOD Refresh 15+",
"cont_end_dtg": "20290530",
"min_years_experience": 16,
"sin": "541330ENG; 541380; 541420; 541611; 541715; 541330EMI",
"worksite": "Customer Site",
"education_level": "BA",
"id": 6386913,
"current_price": 120.06,
"dt_termg": null,
"category": "Professional Services;Miscellaneous;Scientific Management and Solutions",
"subcategory": "Business Administrative Services;Technical and Engineering Services (Non IT);Complementary SINs;Testing and Analysis",
"_timestamp": "2025-03-23T10:00:22Z",
"cont_beg_dtg": "20190531"
},
"sort": [
120.06
]
}
]
},
"aggregations": {
"labor_category": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "Project Manager II",
"doc_count": 7
}
]
},
"security_clearance": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "No",
"doc_count": 6
},
{
"key": "None",
"doc_count": 1
}
]
},
"histogram_percentiles": {
"values": {
"10.0": 72.32400054931641,
"25.0": 85.99500274658203,
"30.0": 86.52000274658204,
"35.0": 87.04500274658204,
"50.0": 116.87999725341797,
"65.0": 117.73550033569336,
"70.0": 118.1240005493164,
"75.0": 118.51250076293945,
"90.0": 119.80599822998047
}
},
"worksite": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "Customer Facility",
"doc_count": 6
},
{
"key": "Customer Site",
"doc_count": 1
}
]
},
"min_years_experience": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "4",
"doc_count": 2
},
{
"key": "16",
"doc_count": 1
},
{
"key": "3",
"doc_count": 1
},
{
"key": "5",
"doc_count": 1
},
{
"key": "7",
"doc_count": 1
},
{
"key": "8",
"doc_count": 1
}
]
},
"education_level": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "BA",
"doc_count": 7
}
]
},
"wage_histogram": {
"buckets": [
{
"min": 69.0,
"key": 69.0,
"max": 69.0,
"doc_count": 1
},
{
"min": 85.62000274658203,
"key": 85.62000274658203,
"max": 85.62000274658203,
"doc_count": 1
},
{
"min": 87.12000274658203,
"key": 87.12000274658203,
"max": 87.12000274658203,
"doc_count": 1
},
{
"min": 116.87999725341797,
"key": 116.87999725341797,
"max": 116.87999725341797,
"doc_count": 1
},
{
"min": 117.68000030517578,
"key": 117.68000030517578,
"max": 117.68000030517578,
"doc_count": 1
},
{
"min": 118.79000091552734,
"key": 118.79000091552734,
"max": 118.79000091552734,
"doc_count": 1
},
{
"min": 120.05999755859375,
"key": 120.05999755859375,
"max": 120.05999755859375,
"doc_count": 1
}
]
},
"current_price": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "116.88",
"doc_count": 1
},
{
"key": "117.68",
"doc_count": 1
},
{
"key": "118.79",
"doc_count": 1
},
{
"key": "120.06",
"doc_count": 1
},
{
"key": "69.0",
"doc_count": 1
},
{
"key": "85.62",
"doc_count": 1
},
{
"key": "87.12",
"doc_count": 1
}
]
},
"business_size": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "S",
"doc_count": 7
}
]
},
"median_price": {
"values": {
"50.0": 116.87999725341797
}
},
"wage_stats": {
"count": 7,
"min": 69.0,
"max": 120.05999755859375,
"avg": 102.16428593226841,
"sum": 715.1500015258789,
"sum_of_squares": 75716.66330995486,
"variance": 379.1248670861117,
"variance_population": 379.1248670861117,
"variance_sampling": 442.31234493379696,
"std_deviation": 19.47112906551933,
"std_deviation_population": 19.47112906551933,
"std_deviation_sampling": 21.031223096477223,
"std_deviation_bounds": {
"upper": 141.10654406330707,
"lower": 63.22202780122975,
"upper_population": 141.10654406330707,
"lower_population": 63.22202780122975,
"upper_sampling": 144.22673212522287,
"lower_sampling": 60.10183973931397
}
}
}
}