{"took":11,"timed_out":false,"_shards":{"total":5,"successful":5,"skipped":0,"failed":0},"hits":{"total":{"value":17,"relation":"eq"},"max_score":null,"hits":[{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936187","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":29.97,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Intern","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":0,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"High School","id":1452936187,"current_price":29.97,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[29.97]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936193","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":47.1,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Other Support Staff","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":0,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Associates","id":1452936193,"current_price":47.1,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[47.1]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936188","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":55.67,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Proofreader","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":2,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Associates","id":1452936188,"current_price":55.67,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[55.67]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936186","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":55.67,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Staff Associate","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":0,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936186,"current_price":55.67,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[55.67]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936185","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":81.36,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Assistant Account Executive","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":2,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936185,"current_price":81.36,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[81.36]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936192","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":89.92,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Graphic Designer","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":2,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936192,"current_price":89.92,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[89.92]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936184","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":107.05,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Account Executive","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":3,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936184,"current_price":107.05,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[107.05]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936190","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":141.31,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Art Director","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":4,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936190,"current_price":141.31,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[141.31]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936191","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":141.31,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Senior Graphic Designer","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":5,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936191,"current_price":141.31,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[141.31]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936183","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":141.31,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Senior Account Executive","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":4,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936183,"current_price":141.31,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[141.31]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936189","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":141.31,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Information Services Director","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":10,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936189,"current_price":141.31,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[141.31]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936182","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":158.44,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Account Supervisor","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":5,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936182,"current_price":158.44,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[158.44]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936180","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":179.85,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Director","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":6,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936180,"current_price":179.85,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[179.85]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936181","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":179.85,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Senior Account Supervisor","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":6,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936181,"current_price":179.85,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[179.85]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936179","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":205.54,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Vice President","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":8,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936179,"current_price":205.54,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[205.54]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936178","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":226.95,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Senior Vice President","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":9,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936178,"current_price":226.95,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[226.95]},{"_index":"ceilingrates-2026-11-02_02-00-02","_id":"1452936177","_score":null,"_source":{"contract_end":"2028-08-09","security_clearance":false,"next_year_price":269.77,"second_year_price":null,"vendor_name":"MP&F, LLC","idv_piid":"47QRAA18D00DV","business_size":"S","contract_start":"2018-08-10","data_source":"ACR","labor_category":"Partner/ Principal","schedule":"MAS","cont_end_dtg":"20280809","min_years_experience":10,"sin":"512110,541613,541810,541820,541910","worksite":"Contractor_Facility","education_level":"Bachelors","id":1452936177,"current_price":269.77,"dt_termg":"","category":"Miscellaneous; Professional Services","subcategory":"Marketing and Public Relations; Complementary SINs","_timestamp":"2026-11-02T02:00:02Z","cont_beg_dtg":"20180810"},"sort":[269.77]}]},"aggregations":{"labor_category":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"Account Executive","doc_count":1},{"key":"Account Supervisor","doc_count":1},{"key":"Art Director","doc_count":1},{"key":"Assistant Account Executive","doc_count":1},{"key":"Director","doc_count":1},{"key":"Graphic Designer","doc_count":1},{"key":"Information Services Director","doc_count":1},{"key":"Intern","doc_count":1},{"key":"Other Support Staff","doc_count":1},{"key":"Partner/ Principal","doc_count":1},{"key":"Proofreader","doc_count":1},{"key":"Senior Account Executive","doc_count":1},{"key":"Senior Account Supervisor","doc_count":1},{"key":"Senior Graphic Designer","doc_count":1},{"key":"Senior Vice President","doc_count":1},{"key":"Staff Associate","doc_count":1},{"key":"Vice President","doc_count":1}]},"security_clearance":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"false","doc_count":17}]},"histogram_percentiles":{"values":{"10.0":47.099998474121094,"25.0":81.36000061035156,"30.0":89.91999816894531,"35.0":89.91999816894531,"50.0":141.30999755859375,"65.0":158.44000244140625,"70.0":158.44000244140625,"75.0":179.85000610351562,"90.0":226.9499969482422}},"min_years_experience":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"0","doc_count":3},{"key":"2","doc_count":3},{"key":"10","doc_count":2},{"key":"4","doc_count":2},{"key":"5","doc_count":2},{"key":"6","doc_count":2},{"key":"3","doc_count":1},{"key":"8","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":17}]},"wage_histogram":{"buckets":[{"min":29.969999313354492,"key":29.969999313354492,"max":29.969999313354492,"doc_count":1},{"min":47.099998474121094,"key":47.099998474121094,"max":47.099998474121094,"doc_count":1},{"min":55.66999816894531,"key":55.66999816894531,"max":55.66999816894531,"doc_count":2},{"min":81.36000061035156,"key":81.36000061035156,"max":81.36000061035156,"doc_count":1},{"min":89.91999816894531,"key":89.91999816894531,"max":89.91999816894531,"doc_count":1},{"min":107.05000305175781,"key":107.05000305175781,"max":107.05000305175781,"doc_count":1},{"min":141.30999755859375,"key":141.30999755859375,"max":141.30999755859375,"doc_count":4},{"min":158.44000244140625,"key":158.44000244140625,"max":158.44000244140625,"doc_count":1},{"min":179.85000610351562,"key":179.85000610351562,"max":179.85000610351562,"doc_count":2},{"min":205.5399932861328,"key":205.5399932861328,"max":205.5399932861328,"doc_count":1},{"min":226.9499969482422,"key":226.9499969482422,"max":226.9499969482422,"doc_count":1},{"min":269.7699890136719,"key":269.7699890136719,"max":269.7699890136719,"doc_count":1}]},"education_level":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"Bachelors","doc_count":14},{"key":"Associates","doc_count":2},{"key":"High School","doc_count":1}]},"current_price":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"141.31","doc_count":4},{"key":"179.85","doc_count":2},{"key":"55.67","doc_count":2},{"key":"107.05","doc_count":1},{"key":"158.44","doc_count":1},{"key":"205.54","doc_count":1},{"key":"226.95","doc_count":1},{"key":"269.77","doc_count":1},{"key":"29.97","doc_count":1},{"key":"47.1","doc_count":1},{"key":"81.36","doc_count":1},{"key":"89.92","doc_count":1}]},"business_size":{"doc_count_error_upper_bound":0,"sum_other_doc_count":0,"buckets":[{"key":"S","doc_count":17}]},"wage_stats":{"count":17,"min":29.969999313354492,"max":269.7699890136719,"avg":132.49294000513413,"sum":2252.3799800872803,"sum_of_squares":371677.84936261474,"variance":4309.023752479146,"variance_population":4309.023752479146,"variance_sampling":4578.337737009093,"std_deviation":65.64315465057378,"std_deviation_population":65.64315465057378,"std_deviation_sampling":67.66341505576771,"std_deviation_bounds":{"upper":263.7792493062817,"lower":1.2066307039865762,"upper_population":263.7792493062817,"lower_population":1.2066307039865762,"upper_sampling":267.8197701166696,"lower_sampling":-2.8338901064012987}},"median_price":{"values":{"50.0":141.30999755859375}},"education_level_counts":{"buckets":[{"key":"AA","doc_count":2},{"key":"BA","doc_count":14},{"key":"HS","doc_count":1},{"key":"MA","doc_count":0},{"key":"PHD","doc_count":0},{"key":"TEC","doc_count":0}]}}}