Skip to content

Instantly share code, notes, and snippets.

@RobertApikyan

RobertApikyan/Residual Value Lookup Response

Created March 11, 2024 16:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RobertApikyan/d2033e542047a1102b13e1286e80dca3 to your computer and use it in GitHub Desktop.
Save RobertApikyan/d2033e542047a1102b13e1286e80dca3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Residual Value Lookup Response
[
{
"publish_date":"3/11/2024",
"data_freq":"D",
"state":"NT",
"country":"US",
"vin":"WDDGJ4HBF",
"uvc":"2015560230",
"groupnum":"4507",
"model_year":"2015",
"make":"Mercedes-Benz",
"model":"C Class",
"series":"C250",
"style":"2D Coupe",
"mileage_cat":"F",
"class_code":"F",
"class_code_long":"F",
"class_name":"Luxury Car",
"class_name_long":"Near Luxury Car",
"segment_category":"NLC",
"description_score":"",
"first_values_flag":false,
"risk_score":"",
"base_whole_xclean":9900,
"mileage_whole_xclean":0,
"regional_whole_xclean":0,
"non_history_adjusted_whole_xclean":9900,
"final_whole_xclean":9900,
"base_whole_clean":8600,
"mileage_whole_clean":0,
"regional_whole_clean":0,
"non_history_adjusted_whole_clean":8600,
"final_whole_clean":8600,
"base_whole_avg":6825,
"mileage_whole_avg":0,
"regional_whole_avg":0,
"non_history_adjusted_whole_avg":6825,
"final_whole_avg":6825,
"base_whole_rough":5125,
"mileage_whole_rough":0,
"regional_whole_rough":0,
"non_history_adjusted_whole_rough":5125,
"final_whole_rough":5125,
"base_retail_xclean":14650,
"mileage_retail_xclean":0,
"regional_retail_xclean":0,
"non_history_adjusted_retail_xclean":14650,
"final_retail_xclean":14650,
"base_retail_clean":13075,
"mileage_retail_clean":0,
"regional_retail_clean":0,
"non_history_adjusted_retail_clean":13075,
"final_retail_clean":13075,
"base_retail_avg":10550,
"mileage_retail_avg":0,
"regional_retail_avg":0,
"non_history_adjusted_retail_avg":10550,
"final_retail_avg":10550,
"base_retail_rough":8500,
"mileage_retail_rough":0,
"regional_retail_rough":0,
"non_history_adjusted_retail_rough":8500,
"final_retail_rough":8500,
"base_tradein_clean":8740,
"mileage_tradein_clean":0,
"regional_tradein_clean":0,
"non_history_adjusted_tradein_clean":8740,
"final_tradein_clean":8740,
"base_tradein_avg":6965,
"mileage_tradein_avg":0,
"regional_tradein_avg":0,
"non_history_adjusted_tradein_avg":6965,
"final_tradein_avg":6965,
"base_tradein_rough":4865,
"mileage_tradein_rough":0,
"regional_tradein_rough":0,
"non_history_adjusted_tradein_rough":4865,
"final_tradein_rough":4865,
"region2":0,
"region3":-25,
"region4":-25,
"region5":0,
"region6":0,
"msrp":39400,
"retail_equipped":45440,
"price_includes":"AT LTH SR",
"wheel_base":108.7,
"tire_size":"225/45R17",
"gvw":3428,
"seat_cap":"4",
"seats":"Sport",
"fuel_type":"Gas",
"fuel_cap":"17.4",
"fuel_delivery":"Direct injection",
"hwy_mpg":"31",
"city_mpg":"21",
"engine_description":"1.8L I-4 DI T/C I/C",
"cylinders":"4",
"engine_displacement":"1.8L",
"engine_turbocharged":"Turbocharg",
"base_hp":"201 @ 5500",
"taxable_hp":19.6,
"torque":"229 @ 4300",
"transmission":"A",
"drivetrain":"RWD",
"num_gears":"7",
"ext_doors":"2",
"moon_sunroof":"Sunroof, tilt-sliding",
"airbags":"Side Curtain",
"basic_warranty":"4-year/50,000-mile",
"add_deduct_list":[
{
"uoc":"N5",
"name":"Navigation System",
"xclean":400,
"clean":400,
"avg":400,
"rough":400,
"auto":"N",
"resid12":0,
"resid24":0,
"resid30":0,
"resid36":0,
"resid42":0,
"resid48":0,
"resid60":0,
"resid72":0
},
{
"uoc":"19",
"name":"w/o Leather",
"xclean":-525,
"clean":-525,
"avg":-525,
"rough":-525,
"auto":"N",
"resid12":0,
"resid24":0,
"resid30":0,
"resid36":0,
"resid42":0,
"resid48":0,
"resid60":0,
"resid72":0
}
],
"mileage_list":[
{
"model_year":"2015",
"range_begin":1,
"range_end":18000,
"xclean":5150,
"clean":5600,
"avg":6075,
"rough":6075,
"finadv":5375,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":18001,
"range_end":28000,
"xclean":4700,
"clean":5150,
"avg":5600,
"rough":6075,
"finadv":4925,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":28001,
"range_end":38000,
"xclean":4225,
"clean":4700,
"avg":5150,
"rough":5600,
"finadv":4450,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":38001,
"range_end":48000,
"xclean":3800,
"clean":4225,
"avg":4700,
"rough":5150,
"finadv":4025,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":48001,
"range_end":58000,
"xclean":3375,
"clean":3800,
"avg":4225,
"rough":4700,
"finadv":3600,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":58001,
"range_end":64000,
"xclean":2950,
"clean":3375,
"avg":3800,
"rough":4225,
"finadv":3175,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":64001,
"range_end":70000,
"xclean":2550,
"clean":2950,
"avg":3375,
"rough":3800,
"finadv":2750,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":70001,
"range_end":76000,
"xclean":2125,
"clean":2550,
"avg":2950,
"rough":3375,
"finadv":2325,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":76001,
"range_end":82000,
"xclean":1700,
"clean":2125,
"avg":2550,
"rough":2950,
"finadv":1900,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":82001,
"range_end":88000,
"xclean":1475,
"clean":1700,
"avg":2125,
"rough":2550,
"finadv":1600,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":88001,
"range_end":94000,
"xclean":1275,
"clean":1475,
"avg":1700,
"rough":2125,
"finadv":1375,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":94001,
"range_end":97000,
"xclean":1075,
"clean":1275,
"avg":1475,
"rough":1700,
"finadv":1175,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":97001,
"range_end":100000,
"xclean":850,
"clean":1075,
"avg":1275,
"rough":1475,
"finadv":950,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":100001,
"range_end":103000,
"xclean":650,
"clean":850,
"avg":1075,
"rough":1275,
"finadv":750,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":103001,
"range_end":106000,
"xclean":425,
"clean":650,
"avg":850,
"rough":1075,
"finadv":550,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":106001,
"range_end":109000,
"xclean":225,
"clean":425,
"avg":650,
"rough":850,
"finadv":325,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":109001,
"range_end":112000,
"xclean":0,
"clean":225,
"avg":425,
"rough":650,
"finadv":125,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":112001,
"range_end":115000,
"xclean":-225,
"clean":0,
"avg":225,
"rough":425,
"finadv":-125,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":115001,
"range_end":118000,
"xclean":-425,
"clean":-225,
"avg":0,
"rough":225,
"finadv":-325,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":118001,
"range_end":121000,
"xclean":-650,
"clean":-425,
"avg":-225,
"rough":0,
"finadv":-550,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":121001,
"range_end":124000,
"xclean":-850,
"clean":-650,
"avg":-425,
"rough":-225,
"finadv":-750,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":124001,
"range_end":127000,
"xclean":-1075,
"clean":-850,
"avg":-650,
"rough":-425,
"finadv":-950,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":127001,
"range_end":130000,
"xclean":-1275,
"clean":-1075,
"avg":-850,
"rough":-650,
"finadv":-1175,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":130001,
"range_end":133000,
"xclean":-1475,
"clean":-1275,
"avg":-1075,
"rough":-850,
"finadv":-1375,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":133001,
"range_end":136000,
"xclean":-1900,
"clean":-1475,
"avg":-1275,
"rough":-1075,
"finadv":-1700,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":136001,
"range_end":139000,
"xclean":-2325,
"clean":-1900,
"avg":-1475,
"rough":-1275,
"finadv":-2125,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":139001,
"range_end":145000,
"xclean":-2750,
"clean":-2325,
"avg":-1900,
"rough":-1475,
"finadv":-2550,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":145001,
"range_end":151000,
"xclean":-3175,
"clean":-2750,
"avg":-2325,
"rough":-1900,
"finadv":-2950,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":151001,
"range_end":157000,
"xclean":-3600,
"clean":-3175,
"avg":-2750,
"rough":-2325,
"finadv":-3375,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":157001,
"range_end":163000,
"xclean":-4025,
"clean":-3600,
"avg":-3175,
"rough":-2750,
"finadv":-3800,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":163001,
"range_end":169000,
"xclean":-4425,
"clean":-4025,
"avg":-3600,
"rough":-3175,
"finadv":-4225,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":169001,
"range_end":175000,
"xclean":-5150,
"clean":-4425,
"avg":-4025,
"rough":-3600,
"finadv":-4800,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":175001,
"range_end":181000,
"xclean":-5500,
"clean":-5150,
"avg":-4425,
"rough":-4025,
"finadv":-5325,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":181001,
"range_end":191000,
"xclean":-5775,
"clean":-5500,
"avg":-5150,
"rough":-4425,
"finadv":-5650,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":191001,
"range_end":201000,
"xclean":-6050,
"clean":-5775,
"avg":-5500,
"rough":-5150,
"finadv":-5925,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":201001,
"range_end":211000,
"xclean":-6350,
"clean":-6050,
"avg":-5775,
"rough":-5500,
"finadv":-6200,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":211001,
"range_end":221000,
"xclean":-6625,
"clean":-6350,
"avg":-6050,
"rough":-5775,
"finadv":-6475,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":221001,
"range_end":231000,
"xclean":-6900,
"clean":-6625,
"avg":-6350,
"rough":-6050,
"finadv":-6750,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":231001,
"range_end":241000,
"xclean":-6900,
"clean":-6900,
"avg":-6625,
"rough":-6350,
"finadv":-6900,
"mileage_cat":"F"
},
{
"model_year":"2015",
"range_begin":241001,
"range_end":999999,
"xclean":-6900,
"clean":-6900,
"avg":-6900,
"rough":-6625,
"finadv":-6900,
"mileage_cat":"F"
}
],
"model_number_list":[
"C250C"
],
"residuals":[
]
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment