Ceiling Rates Document
Ceiling Rate Search View Set
GET /api/v3/search/ceilingrates/?keyword=king&page=8&page_size=50
{
"took": 7,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 142,
"relation": "eq"
},
"max_score": null,
"hits": []
},
"aggregations": {
"labor_category": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "Networking Engineer",
"doc_count": 2
},
{
"key": "Project Manager",
"doc_count": 2
},
{
"key": "*Carpenter, Maintenance",
"doc_count": 1
},
{
"key": "*Electrician, Maintenance",
"doc_count": 1
},
{
"key": "*Gardener",
"doc_count": 1
},
{
"key": "*General Clerk I",
"doc_count": 1
},
{
"key": "*General Maintenance Worker",
"doc_count": 1
},
{
"key": "*Grounds Maintenance Laborer",
"doc_count": 1
},
{
"key": "*HVAC Mechanic",
"doc_count": 1
},
{
"key": "*Heavy Equipment Mechanic",
"doc_count": 1
},
{
"key": "*Heavy Equipment Operator",
"doc_count": 1
},
{
"key": "*Janitor",
"doc_count": 1
},
{
"key": "*Laborer",
"doc_count": 1
},
{
"key": "*Painter",
"doc_count": 1
},
{
"key": "*Pest Control Technician",
"doc_count": 1
},
{
"key": "*Plumber",
"doc_count": 1
},
{
"key": "*Tractor Operator",
"doc_count": 1
},
{
"key": "Actor (standard speaking, non-specialty role)",
"doc_count": 1
},
{
"key": "Actors, On Camera, Speaking (SAG/AFTRA)",
"doc_count": 1
},
{
"key": "Actors, On Camera, Speaking (non-union)",
"doc_count": 1
},
{
"key": "Ad Trafficking Coordinator",
"doc_count": 1
},
{
"key": "Administrative Assistant**",
"doc_count": 1
},
{
"key": "Analyst I",
"doc_count": 1
},
{
"key": "Analyst II",
"doc_count": 1
},
{
"key": "Analyst III",
"doc_count": 1
},
{
"key": "Assistant Project Manager",
"doc_count": 1
},
{
"key": "Booking Agent",
"doc_count": 1
},
{
"key": "Business Process Engineer – Senior",
"doc_count": 1
},
{
"key": "CBA Working Chief Engineer - Detroit Ann Arbor",
"doc_count": 1
},
{
"key": "Cloud Compliance Analyst",
"doc_count": 1
},
{
"key": "Cloud Data Engineer",
"doc_count": 1
},
{
"key": "Cloud DevOps Engineer",
"doc_count": 1
},
{
"key": "Cloud Financial Analyst",
"doc_count": 1
},
{
"key": "Cloud Full-Stack Developer",
"doc_count": 1
},
{
"key": "Cloud Infrastructure Engineer",
"doc_count": 1
},
{
"key": "Cloud Migration Specialist",
"doc_count": 1
},
{
"key": "Cloud Operations Manager",
"doc_count": 1
},
{
"key": "Cloud Project Manager",
"doc_count": 1
},
{
"key": "Cloud Security Specialist",
"doc_count": 1
},
{
"key": "Cloud Service Manager",
"doc_count": 1
},
{
"key": "Cloud Solutions Architect",
"doc_count": 1
},
{
"key": "Cloud Subject Matter Expert (SME) Level 2",
"doc_count": 1
},
{
"key": "Cloud Support Specialist",
"doc_count": 1
},
{
"key": "Cloud Training Specialist",
"doc_count": 1
},
{
"key": "Cloud Web Designer",
"doc_count": 1
},
{
"key": "Cloud Web Developer",
"doc_count": 1
},
{
"key": "CloudSubject Matter Expert (SME) Level 1",
"doc_count": 1
},
{
"key": "CloudSubject Matter Expert (SME) Level 3",
"doc_count": 1
},
{
"key": "CloudSubject Matter Expert (SME) Level 4",
"doc_count": 1
},
{
"key": "Customer Service Representative**",
"doc_count": 1
},
{
"key": "Cyber Hunter",
"doc_count": 1
},
{
"key": "Cybersecurity Analyst",
"doc_count": 1
},
{
"key": "Cybersecurity Analyst (Intermediate)",
"doc_count": 1
},
{
"key": "Cybersecurity Engineer",
"doc_count": 1
},
{
"key": "Cybersecurity Enterprise Architect",
"doc_count": 1
},
{
"key": "Cybersecurity Incident Response Analyst",
"doc_count": 1
},
{
"key": "Cybersecurity Manager",
"doc_count": 1
},
{
"key": "Cybersecurity Program/Project Manager",
"doc_count": 1
},
{
"key": "Cybersecurity Project Delivery Specialist",
"doc_count": 1
},
{
"key": "Cybersecurity Senior Consultant",
"doc_count": 1
},
{
"key": "Cybersecurity Subject Matter Expert (SME)",
"doc_count": 1
},
{
"key": "Data Entry**",
"doc_count": 1
},
{
"key": "Database Administrator - Middle",
"doc_count": 1
},
{
"key": "Database Administrator II",
"doc_count": 1
},
{
"key": "Database Administrator III",
"doc_count": 1
},
{
"key": "Database Administrator IV",
"doc_count": 1
},
{
"key": "Design and Development Engineer, Senior",
"doc_count": 1
},
{
"key": "Extra, Non-Speaking",
"doc_count": 1
},
{
"key": "Facilities (parking) Attendant**",
"doc_count": 1
},
{
"key": "Facility Site Manager",
"doc_count": 1
},
{
"key": "Functional Specialist I",
"doc_count": 1
},
{
"key": "Functional Specialist II",
"doc_count": 1
},
{
"key": "Functional Specialist III",
"doc_count": 1
},
{
"key": "Greeter/Customer Service**",
"doc_count": 1
},
{
"key": "HIT Business Process Engineer – Senior",
"doc_count": 1
},
{
"key": "HIT Database Administrator – Middle",
"doc_count": 1
},
{
"key": "HIT Design and Development Engineer, Senior",
"doc_count": 1
},
{
"key": "HIT Information Assurance Officer (IAO)",
"doc_count": 1
},
{
"key": "HIT Program Manager",
"doc_count": 1
},
{
"key": "HIT Programmer – Senior",
"doc_count": 1
},
{
"key": "HIT Project Manager",
"doc_count": 1
},
{
"key": "HIT Security Subject Matter Expert (SME)",
"doc_count": 1
},
{
"key": "HIT Subject Matter Expert- Functional 1",
"doc_count": 1
},
{
"key": "HIT Subject Matter Expert- Functional 2",
"doc_count": 1
},
{
"key": "HIT Subject Matter Expert- Functional 3",
"doc_count": 1
},
{
"key": "HIT Subject Matter Expert- Functional 4",
"doc_count": 1
},
{
"key": "HIT System Administrator",
"doc_count": 1
},
{
"key": "HIT System Administrator – Senior",
"doc_count": 1
},
{
"key": "Health IT Networking Professional/Consultant",
"doc_count": 1
},
{
"key": "IT Developer I",
"doc_count": 1
},
{
"key": "IT Developer II",
"doc_count": 1
},
{
"key": "IT Developer III",
"doc_count": 1
},
{
"key": "IT Developer IV",
"doc_count": 1
},
{
"key": "IT Developer V",
"doc_count": 1
},
{
"key": "IT SME I",
"doc_count": 1
},
{
"key": "IT SME II",
"doc_count": 1
},
{
"key": "IT SME III",
"doc_count": 1
},
{
"key": "IT SME IV",
"doc_count": 1
},
{
"key": "IT SME V",
"doc_count": 1
},
{
"key": "Information Assurance Engineer",
"doc_count": 1
},
{
"key": "Maintenance Personnel**",
"doc_count": 1
},
{
"key": "Media Ad Trafficking & Reconciliation",
"doc_count": 1
},
{
"key": "Models/Extras (non-speaking roles)",
"doc_count": 1
},
{
"key": "Networking Professional/Consultant",
"doc_count": 1
},
{
"key": "On-Site Supervisor/Asst. PM",
"doc_count": 1
},
{
"key": "Packing (Design and Labor)",
"doc_count": 1
},
{
"key": "Packing Supervisor**",
"doc_count": 1
},
{
"key": "Parking Administrative Assistant",
"doc_count": 1
},
{
"key": "Parking Cashier**",
"doc_count": 1
},
{
"key": "Parking and Lot Attendant",
"doc_count": 1
},
{
"key": "Parking and Lot Attendant (SCLS)",
"doc_count": 1
},
{
"key": "Program Manager I",
"doc_count": 1
},
{
"key": "Program Manager II",
"doc_count": 1
},
{
"key": "Program Manager III",
"doc_count": 1
},
{
"key": "Program/Project Manager",
"doc_count": 1
},
{
"key": "Programmer – Senior",
"doc_count": 1
},
{
"key": "Project Manager I",
"doc_count": 1
},
{
"key": "Project Manager II",
"doc_count": 1
},
{
"key": "Project Manager III",
"doc_count": 1
},
{
"key": "Project Manager V",
"doc_count": 1
},
{
"key": "Quality Manager",
"doc_count": 1
},
{
"key": "Risk Vulnerability Assessment Analyst",
"doc_count": 1
},
{
"key": "Secretarial/Clerical**",
"doc_count": 1
},
{
"key": "Secretary**",
"doc_count": 1
},
{
"key": "Security Subject Matter Expert (SME)",
"doc_count": 1
},
{
"key": "Senior System Analysis",
"doc_count": 1
},
{
"key": "Service Order Dispatcher",
"doc_count": 1
},
{
"key": "Subject Matter Expert (SME)",
"doc_count": 1
},
{
"key": "Subject Matter Expert – Level 2",
"doc_count": 1
},
{
"key": "Subject Matter Expert – Level 3",
"doc_count": 1
},
{
"key": "Subject Matter Expert – Level 4",
"doc_count": 1
},
{
"key": "System Administration / Information Assurance Office",
"doc_count": 1
},
{
"key": "System Administrator - Senior",
"doc_count": 1
},
{
"key": "System Engineer I",
"doc_count": 1
},
{
"key": "System Engineer II",
"doc_count": 1
},
{
"key": "System Engineer III",
"doc_count": 1
},
{
"key": "System Engineer IV",
"doc_count": 1
},
{
"key": "System Engineer V",
"doc_count": 1
},
{
"key": "Tasking Coordinator",
"doc_count": 1
},
{
"key": "Word Processor**",
"doc_count": 1
}
]
},
"security_clearance": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "No",
"doc_count": 76
},
{
"key": "None",
"doc_count": 65
},
{
"key": "Yes",
"doc_count": 1
}
]
},
"histogram_percentiles": {
"values": {
"10.0": 44.96300048828125,
"25.0": 75.22000122070312,
"30.0": 89.11300277709961,
"35.0": 100.63399963378906,
"50.0": 118.76499938964844,
"65.0": 132.5500030517578,
"70.0": 138.26600341796876,
"75.0": 143.17999267578125,
"90.0": 176.0929977416992
}
},
"worksite": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "Contractor Facility",
"doc_count": 66
},
{
"key": "Both",
"doc_count": 46
},
{
"key": "Customer Facility",
"doc_count": 30
}
]
},
"min_years_experience": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "3",
"doc_count": 23
},
{
"key": "5",
"doc_count": 17
},
{
"key": "8",
"doc_count": 17
},
{
"key": "2",
"doc_count": 16
},
{
"key": "10",
"doc_count": 14
},
{
"key": "7",
"doc_count": 13
},
{
"key": "1",
"doc_count": 11
},
{
"key": "4",
"doc_count": 11
},
{
"key": "6",
"doc_count": 7
},
{
"key": "0",
"doc_count": 6
},
{
"key": "12",
"doc_count": 4
},
{
"key": "15",
"doc_count": 2
},
{
"key": "9",
"doc_count": 1
}
]
},
"education_level": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "BA",
"doc_count": 100
},
{
"key": "AA",
"doc_count": 24
},
{
"key": "HS",
"doc_count": 18
}
]
},
"wage_histogram": {
"buckets": [
{
"min": 23.719999313354492,
"key": 26.174999713897705,
"max": 30.229999542236328,
"doc_count": 4
},
{
"min": 38.65999984741211,
"key": 48.08115357619066,
"max": 63.150001525878906,
"doc_count": 26
},
{
"min": 66.08999633789062,
"key": 72.07249927520752,
"max": 78.56999969482422,
"doc_count": 8
},
{
"min": 83.58000183105469,
"key": 88.91555531819661,
"max": 95.72000122070312,
"doc_count": 9
},
{
"min": 98.66000366210938,
"key": 104.3846669514974,
"max": 110.08000183105469,
"doc_count": 15
},
{
"min": 111.4000015258789,
"key": 122.04700063069662,
"max": 130.99000549316406,
"doc_count": 30
},
{
"min": 132.94000244140625,
"key": 142.2233315927011,
"max": 154.00999450683594,
"doc_count": 27
},
{
"min": 159.74000549316406,
"key": 160.85000228881836,
"max": 164.11000061035156,
"doc_count": 4
},
{
"min": 171.2899932861328,
"key": 177.30444505479602,
"max": 185.19000244140625,
"doc_count": 9
},
{
"min": 191.44000244140625,
"key": 201.26666768391928,
"max": 210.5800018310547,
"doc_count": 6
},
{
"min": 239.30999755859375,
"key": 244.33666483561197,
"max": 251.88999938964844,
"doc_count": 3
},
{
"min": 300.260009765625,
"key": 300.260009765625,
"max": 300.260009765625,
"doc_count": 1
}
]
},
"current_price": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "119.65",
"doc_count": 3
},
{
"key": "105.03",
"doc_count": 2
},
{
"key": "105.29",
"doc_count": 2
},
{
"key": "114.86",
"doc_count": 2
},
{
"key": "118.13",
"doc_count": 2
},
{
"key": "124.43",
"doc_count": 2
},
{
"key": "128.15",
"doc_count": 2
},
{
"key": "134.01",
"doc_count": 2
},
{
"key": "159.74",
"doc_count": 2
},
{
"key": "210.58",
"doc_count": 2
},
{
"key": "39.29",
"doc_count": 2
},
{
"key": "100.5",
"doc_count": 1
},
{
"key": "101.17",
"doc_count": 1
},
{
"key": "101.58",
"doc_count": 1
},
{
"key": "103.32",
"doc_count": 1
},
{
"key": "104.66",
"doc_count": 1
},
{
"key": "107.88",
"doc_count": 1
},
{
"key": "108.5",
"doc_count": 1
},
{
"key": "109.28",
"doc_count": 1
},
{
"key": "110.08",
"doc_count": 1
},
{
"key": "111.4",
"doc_count": 1
},
{
"key": "112.01",
"doc_count": 1
},
{
"key": "113.08",
"doc_count": 1
},
{
"key": "113.98",
"doc_count": 1
},
{
"key": "115.5",
"doc_count": 1
},
{
"key": "119.4",
"doc_count": 1
},
{
"key": "121.41",
"doc_count": 1
},
{
"key": "122.26",
"doc_count": 1
},
{
"key": "124.35",
"doc_count": 1
},
{
"key": "125.67",
"doc_count": 1
},
{
"key": "125.69",
"doc_count": 1
},
{
"key": "125.94",
"doc_count": 1
},
{
"key": "126.57",
"doc_count": 1
},
{
"key": "126.92",
"doc_count": 1
},
{
"key": "128.47",
"doc_count": 1
},
{
"key": "128.99",
"doc_count": 1
},
{
"key": "129.22",
"doc_count": 1
},
{
"key": "129.47",
"doc_count": 1
},
{
"key": "130.99",
"doc_count": 1
},
{
"key": "132.94",
"doc_count": 1
},
{
"key": "133.97",
"doc_count": 1
},
{
"key": "135.35",
"doc_count": 1
},
{
"key": "136.71",
"doc_count": 1
},
{
"key": "138.23",
"doc_count": 1
},
{
"key": "138.27",
"doc_count": 1
},
{
"key": "138.53",
"doc_count": 1
},
{
"key": "138.79",
"doc_count": 1
},
{
"key": "140.43",
"doc_count": 1
},
{
"key": "141.06",
"doc_count": 1
},
{
"key": "141.08",
"doc_count": 1
},
{
"key": "143.01",
"doc_count": 1
},
{
"key": "143.18",
"doc_count": 1
},
{
"key": "143.58",
"doc_count": 1
},
{
"key": "143.64",
"doc_count": 1
},
{
"key": "144.78",
"doc_count": 1
},
{
"key": "145.15",
"doc_count": 1
},
{
"key": "145.9",
"doc_count": 1
},
{
"key": "146.23",
"doc_count": 1
},
{
"key": "146.35",
"doc_count": 1
},
{
"key": "147.82",
"doc_count": 1
},
{
"key": "148.23",
"doc_count": 1
},
{
"key": "151.62",
"doc_count": 1
},
{
"key": "153.15",
"doc_count": 1
},
{
"key": "154.01",
"doc_count": 1
},
{
"key": "159.81",
"doc_count": 1
},
{
"key": "164.11",
"doc_count": 1
},
{
"key": "171.29",
"doc_count": 1
},
{
"key": "172.29",
"doc_count": 1
},
{
"key": "173.55",
"doc_count": 1
},
{
"key": "174.1",
"doc_count": 1
},
{
"key": "174.65",
"doc_count": 1
},
{
"key": "179.46",
"doc_count": 1
},
{
"key": "180.82",
"doc_count": 1
},
{
"key": "184.39",
"doc_count": 1
},
{
"key": "185.19",
"doc_count": 1
},
{
"key": "191.44",
"doc_count": 1
},
{
"key": "196.47",
"doc_count": 1
},
{
"key": "197.9",
"doc_count": 1
},
{
"key": "200.63",
"doc_count": 1
},
{
"key": "23.72",
"doc_count": 1
},
{
"key": "239.31",
"doc_count": 1
},
{
"key": "24.69",
"doc_count": 1
},
{
"key": "241.81",
"doc_count": 1
},
{
"key": "251.89",
"doc_count": 1
},
{
"key": "26.06",
"doc_count": 1
},
{
"key": "30.23",
"doc_count": 1
},
{
"key": "300.26",
"doc_count": 1
},
{
"key": "38.66",
"doc_count": 1
},
{
"key": "38.67",
"doc_count": 1
},
{
"key": "38.88",
"doc_count": 1
},
{
"key": "38.91",
"doc_count": 1
},
{
"key": "39.6",
"doc_count": 1
},
{
"key": "41.45",
"doc_count": 1
},
{
"key": "42.57",
"doc_count": 1
},
{
"key": "44.41",
"doc_count": 1
},
{
"key": "45.2",
"doc_count": 1
},
{
"key": "47.35",
"doc_count": 1
},
{
"key": "47.49",
"doc_count": 1
},
{
"key": "47.98",
"doc_count": 1
},
{
"key": "48.3",
"doc_count": 1
},
{
"key": "49.12",
"doc_count": 1
},
{
"key": "49.37",
"doc_count": 1
},
{
"key": "52.39",
"doc_count": 1
},
{
"key": "53.46",
"doc_count": 1
},
{
"key": "54.19",
"doc_count": 1
},
{
"key": "56.16",
"doc_count": 1
},
{
"key": "56.29",
"doc_count": 1
},
{
"key": "57.71",
"doc_count": 1
},
{
"key": "59.76",
"doc_count": 1
},
{
"key": "60.46",
"doc_count": 1
},
{
"key": "63.15",
"doc_count": 1
},
{
"key": "66.09",
"doc_count": 1
},
{
"key": "66.3",
"doc_count": 1
},
{
"key": "68.74",
"doc_count": 1
},
{
"key": "70.86",
"doc_count": 1
},
{
"key": "72.99",
"doc_count": 1
},
{
"key": "75.22",
"doc_count": 1
},
{
"key": "77.81",
"doc_count": 1
},
{
"key": "78.57",
"doc_count": 1
},
{
"key": "83.58",
"doc_count": 1
},
{
"key": "84.66",
"doc_count": 1
},
{
"key": "85.02",
"doc_count": 1
},
{
"key": "87.09",
"doc_count": 1
},
{
"key": "88.98",
"doc_count": 1
},
{
"key": "90.31",
"doc_count": 1
},
{
"key": "91.38",
"doc_count": 1
},
{
"key": "93.5",
"doc_count": 1
},
{
"key": "95.72",
"doc_count": 1
},
{
"key": "98.66",
"doc_count": 1
},
{
"key": "99.5",
"doc_count": 1
}
]
},
"business_size": {
"doc_count_error_upper_bound": 0,
"sum_other_doc_count": 0,
"buckets": [
{
"key": "S",
"doc_count": 138
},
{
"key": "O",
"doc_count": 4
}
]
},
"median_price": {
"values": {
"50.0": 118.76499938964844
}
},
"wage_stats": {
"count": 142,
"min": 23.719999313354492,
"max": 300.260009765625,
"avg": 114.63978862762451,
"sum": 16278.84998512268,
"sum_of_squares": 2235300.344112769,
"variance": 2599.2705825175794,
"variance_population": 2599.2705825175794,
"variance_sampling": 2617.705125656002,
"std_deviation": 50.983042107328,
"std_deviation_population": 50.983042107328,
"std_deviation_sampling": 51.16351361718624,
"std_deviation_bounds": {
"upper": 216.60587284228052,
"lower": 12.673704412968519,
"upper_population": 216.60587284228052,
"lower_population": 12.673704412968519,
"upper_sampling": 216.966815861997,
"lower_sampling": 12.312761393252032
}
}
}
}