{"took":8,"timed_out":false,"_shards":{"total":5,"successful":5,"skipped":0,"failed":0},"hits":{"total":{"value":6,"relation":"eq"},"max_score":null,"hits":[{"_index":"ceilingrates-2026-10-22_02-00-02","_id":"1709720194","_score":null,"_source":{"contract_end":"2030-04-13","security_clearance":false,"next_year_price":236.94,"second_year_price":236.94,"vendor_name":"FTI CONSULTING, INC.","idv_piid":"47QRAA25D0086","business_size":"O","contract_start":"2025-04-14","data_source":"ACR","labor_category":"Consultant","schedule":"MAS","cont_end_dtg":"20300413","min_years_experience":0,"sin":"541611","worksite":"Contractor_Facility","education_level":"Bachelors","id":1709720194,"current_price":236.94,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Business Administrative Services; Complementary SINs","_timestamp":"2026-10-22T02:00:02Z","cont_beg_dtg":"20250414"},"sort":[236.94]},{"_index":"ceilingrates-2026-10-22_02-00-02","_id":"1709720193","_score":null,"_source":{"contract_end":"2030-04-13","security_clearance":false,"next_year_price":279.56,"second_year_price":279.56,"vendor_name":"FTI CONSULTING, INC.","idv_piid":"47QRAA25D0086","business_size":"O","contract_start":"2025-04-14","data_source":"ACR","labor_category":"Senior Consultant","schedule":"MAS","cont_end_dtg":"20300413","min_years_experience":2,"sin":"541611","worksite":"Contractor_Facility","education_level":"Bachelors","id":1709720193,"current_price":279.56,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Business Administrative Services; Complementary SINs","_timestamp":"2026-10-22T02:00:02Z","cont_beg_dtg":"20250414"},"sort":[279.56]},{"_index":"ceilingrates-2026-10-22_02-00-02","_id":"1709720192","_score":null,"_source":{"contract_end":"2030-04-13","security_clearance":false,"next_year_price":324.78,"second_year_price":324.78,"vendor_name":"FTI CONSULTING, INC.","idv_piid":"47QRAA25D0086","business_size":"O","contract_start":"2025-04-14","data_source":"ACR","labor_category":"Director","schedule":"MAS","cont_end_dtg":"20300413","min_years_experience":4,"sin":"541611","worksite":"Contractor_Facility","education_level":"Bachelors","id":1709720192,"current_price":324.78,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Business Administrative Services; Complementary SINs","_timestamp":"2026-10-22T02:00:02Z","cont_beg_dtg":"20250414"},"sort":[324.78]},{"_index":"ceilingrates-2026-10-22_02-00-02","_id":"1709720191","_score":null,"_source":{"contract_end":"2030-04-13","security_clearance":false,"next_year_price":393.5,"second_year_price":393.5,"vendor_name":"FTI CONSULTING, INC.","idv_piid":"47QRAA25D0086","business_size":"O","contract_start":"2025-04-14","data_source":"ACR","labor_category":"Senior Director","schedule":"MAS","cont_end_dtg":"20300413","min_years_experience":7,"sin":"541611","worksite":"Contractor_Facility","education_level":"Bachelors","id":1709720191,"current_price":393.5,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Business Administrative Services; Complementary SINs","_timestamp":"2026-10-22T02:00:02Z","cont_beg_dtg":"20250414"},"sort":[393.5]},{"_index":"ceilingrates-2026-10-22_02-00-02","_id":"1709720190","_score":null,"_source":{"contract_end":"2030-04-13","security_clearance":false,"next_year_price":437.67,"second_year_price":437.67,"vendor_name":"FTI CONSULTING, INC.","idv_piid":"47QRAA25D0086","business_size":"O","contract_start":"2025-04-14","data_source":"ACR","labor_category":"Managing Director","schedule":"MAS","cont_end_dtg":"20300413","min_years_experience":9,"sin":"541611","worksite":"Contractor_Facility","education_level":"Bachelors","id":1709720190,"current_price":437.67,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Business Administrative Services; Complementary SINs","_timestamp":"2026-10-22T02:00:02Z","cont_beg_dtg":"20250414"},"sort":[437.67]},{"_index":"ceilingrates-2026-10-22_02-00-02","_id":"1709720189","_score":null,"_source":{"contract_end":"2030-04-13","security_clearance":false,"next_year_price":491.62,"second_year_price":491.62,"vendor_name":"FTI CONSULTING, INC.","idv_piid":"47QRAA25D0086","business_size":"O","contract_start":"2025-04-14","data_source":"ACR","labor_category":"Senior Managing Director","schedule":"MAS","cont_end_dtg":"20300413","min_years_experience":12,"sin":"541611","worksite":"Contractor_Facility","education_level":"Bachelors","id":1709720189,"current_price":491.62,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Business Administrative Services; Complementary SINs","_timestamp":"2026-10-22T02:00:02Z","cont_beg_dtg":"20250414"},"sort":[491.62]}]},"aggregations":{"labor_category":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"Consultant","doc_count":1},{"key":"Director","doc_count":1},{"key":"Managing Director","doc_count":1},{"key":"Senior Consultant","doc_count":1},{"key":"Senior Director","doc_count":1},{"key":"Senior Managing Director","doc_count":1}]},"security_clearance":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"false","doc_count":6}]},"histogram_percentiles":{"values":{"10.0":236.94000244140625,"25.0":279.55999755859375,"30.0":279.55999755859375,"35.0":324.7799987792969,"50.0":393.5,"65.0":393.5,"70.0":437.6700134277344,"75.0":437.6700134277344,"90.0":491.6199951171875}},"min_years_experience":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"0","doc_count":1},{"key":"12","doc_count":1},{"key":"2","doc_count":1},{"key":"4","doc_count":1},{"key":"7","doc_count":1},{"key":"9","doc_count":1}]},"worksite":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"Contractor_Facility","doc_count":6}]},"wage_histogram":{"buckets":[{"min":236.94000244140625,"key":236.94000244140625,"max":236.94000244140625,"doc_count":1},{"min":279.55999755859375,"key":279.55999755859375,"max":279.55999755859375,"doc_count":1},{"min":324.7799987792969,"key":324.7799987792969,"max":324.7799987792969,"doc_count":1},{"min":393.5,"key":393.5,"max":393.5,"doc_count":1},{"min":437.6700134277344,"key":437.6700134277344,"max":437.6700134277344,"doc_count":1},{"min":491.6199951171875,"key":491.6199951171875,"max":491.6199951171875,"doc_count":1}]},"education_level":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"Bachelors","doc_count":6}]},"current_price":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"236.94","doc_count":1},{"key":"279.56","doc_count":1},{"key":"324.78","doc_count":1},{"key":"393.5","doc_count":1},{"key":"437.67","doc_count":1},{"key":"491.62","doc_count":1}]},"business_size":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"O","doc_count":6}]},"wage_stats":{"count":6,"min":236.94000244140625,"max":491.6199951171875,"avg":360.67833455403644,"sum":2164.0700073242188,"sum_of_squares":827863.9148518313,"variance":7888.458125298435,"variance_population":7888.458125298435,"variance_sampling":9466.149750358123,"std_deviation":88.81699232296957,"std_deviation_population":88.81699232296957,"std_deviation_sampling":97.2941403701072,"std_deviation_bounds":{"upper":538.3123191999756,"lower":183.0443499080973,"upper_population":538.3123191999756,"lower_population":183.0443499080973,"upper_sampling":555.2666152942509,"lower_sampling":166.09005381382204}},"median_price":{"values":{"50.0":393.5}},"education_level_counts":{"buckets":[{"key":"AA","doc_count":0},{"key":"BA","doc_count":6},{"key":"HS","doc_count":0},{"key":"MA","doc_count":0},{"key":"PHD","doc_count":0},{"key":"TEC","doc_count":0}]}}}