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": 6,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 5,
"relation": "eq"
},
"max_score": null,
"hits": [
{
"_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": "2024-10-06T10:00:17Z",
"cont_beg_dtg": "20240715"
},
"sort": [
85.62
]
},
{
"_index": "ceilingrates",
"_id": "5395408",
"_score": null,
"_source": {
"contract_end": "2024-12-22",
"security_clearance": null,
"next_year_price": 100.99,
"second_year_price": null,
"vendor_name": "Enterprise Solutions",
"idv_piid": "47QTCA20D003G",
"business_size": "S",
"contract_start": "2019-12-23",
"labor_category": "Project Manager II",
"schedule": "MAS",
"cont_end_dtg": "20291222",
"min_years_experience": 10,
"sin": "132-51",
"worksite": "Customer",
"education_level": "BA",
"id": 5395408,
"current_price": 100.99,
"dt_termg": null,
"category": "Information Technology;Miscellaneous",
"subcategory": "Complementary SINs;IT Services",
"_timestamp": "2024-10-06T10:00:17Z",
"cont_beg_dtg": "20191223"
},
"sort": [
100.99
]
},
{
"_index": "ceilingrates",
"_id": "6323428",
"_score": null,
"_source": {
"contract_end": "2028-02-23",
"security_clearance": "No",
"next_year_price": 114.22,
"second_year_price": 118.79,
"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": 114.22,
"dt_termg": null,
"category": "Professional Services;Miscellaneous;Scientific Management and Solutions",
"subcategory": "Technical and Engineering Services (Non IT);Complementary SINs;Testing and Analysis",
"_timestamp": "2024-10-06T10:00:17Z",
"cont_beg_dtg": "20230224"
},
"sort": [
114.22
]
},
{
"_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": "2024-10-06T10:00:17Z",
"cont_beg_dtg": "20240614"
},
"sort": [
116.88
]
},
{
"_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": "2024-10-06T10:00:17Z",
"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": 5
}
]
},
"security_clearance": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "No",
"doc_count": 4
}
]
},
"worksite": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "Customer Facility",
"doc_count": 3
},
{
"key": "Customer",
"doc_count": 1
},
{
"key": "Customer Site",
"doc_count": 1
}
]
},
"min_years_experience": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "10",
"doc_count": 1
},
{
"key": "16",
"doc_count": 1
},
{
"key": "4",
"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": 5
}
]
},
"wage_histogram": {
"buckets": [
{
"min": 85.62000274658203,
"key": 85.62000274658203,
"max": 85.62000274658203,
"doc_count": 1
},
{
"min": 100.98999786376953,
"key": 100.98999786376953,
"max": 100.98999786376953,
"doc_count": 1
},
{
"min": 114.22000122070312,
"key": 114.22000122070312,
"max": 114.22000122070312,
"doc_count": 1
},
{
"min": 116.87999725341797,
"key": 116.87999725341797,
"max": 116.87999725341797,
"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": "100.99",
"doc_count": 1
},
{
"key": "114.22",
"doc_count": 1
},
{
"key": "116.88",
"doc_count": 1
},
{
"key": "120.06",
"doc_count": 1
},
{
"key": "85.62",
"doc_count": 1
}
]
},
"business_size": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "S",
"doc_count": 5
}
]
},
"median_price": {
"values": {
"50.0": 114.22000122070312
}
},
"wage_stats": {
"count": 5,
"min": 85.62000274658203,
"max": 120.05999755859375,
"avg": 107.55399932861329,
"sum": 537.7699966430664,
"sum_of_squares": 58651.30998943484,
"variance": 162.39922630762157,
"variance_population": 162.39922630762157,
"variance_sampling": 202.99903288452697,
"std_deviation": 12.743595501569468,
"std_deviation_population": 12.743595501569468,
"std_deviation_sampling": 14.247772909634929,
"std_deviation_bounds": {
"upper": 133.04119033175223,
"lower": 82.06680832547436,
"upper_population": 133.04119033175223,
"lower_population": 82.06680832547436,
"upper_sampling": 136.04954514788315,
"lower_sampling": 79.05845350934342
}
}
}
}