fernandopetry
7/31/2019 - 9:26 PM

tabela_ref.json

{
  "warning_count": 0,
  "error_count": 0,
  "message_list": [],
  "token_expiration_minutes": 0,
  "used_vehicles": {
    "used_vehicle_list": [
      {
        "publish_date": "7/31/2019",
        "data_freq": "D",
        "state": "NT",
        "country": "US",
        "vin": "1D7HU1827",
        "uvc": "2007240591",
        "groupnum": "7431",
        "model_year": "2007",
        "make": "Dodge",
        "model": "Ram 1500",
        "series": "Laramie",
        "style": "Quad Cab 4WD",
        "mileage_cat": "G",
        "class_code": "K",
        "class_name": "Pickup",
        "description_score": "",
        "first_values_flag": false,
        "risk_score": "",
        "base_whole_xclean": 0,
        "mileage_whole_xclean": 0,
        "add_deduct_whole_xclean": 0,
        "regional_whole_xclean": 0,
        "adjusted_whole_xclean": 0,
        "base_whole_clean": 10100,
        "mileage_whole_clean": 0,
        "add_deduct_whole_clean": 400,
        "regional_whole_clean": 0,
        "adjusted_whole_clean": 10500,
        "base_whole_avg": 7200,
        "mileage_whole_avg": 0,
        "add_deduct_whole_avg": 400,
        "regional_whole_avg": 0,
        "adjusted_whole_avg": 7600,
        "base_whole_rough": 4900,
        "mileage_whole_rough": 0,
        "add_deduct_whole_rough": 400,
        "regional_whole_rough": 0,
        "adjusted_whole_rough": 5300,
        "base_retail_xclean": 0,
        "mileage_retail_xclean": 0,
        "add_deduct_retail_xclean": 0,
        "regional_retail_xclean": 0,
        "adjusted_retail_xclean": 0,
        "base_retail_clean": 13650,
        "mileage_retail_clean": 0,
        "add_deduct_retail_clean": 400,
        "regional_retail_clean": 0,
        "adjusted_retail_clean": 14050,
        "base_retail_avg": 10275,
        "mileage_retail_avg": 0,
        "add_deduct_retail_avg": 400,
        "regional_retail_avg": 0,
        "adjusted_retail_avg": 10675,
        "base_retail_rough": 7675,
        "mileage_retail_rough": 0,
        "add_deduct_retail_rough": 400,
        "regional_retail_rough": 0,
        "adjusted_retail_rough": 8075,
        "base_tradein_clean": 10270,
        "mileage_tradein_clean": 0,
        "add_deduct_tradein_clean": 400,
        "regional_tradein_clean": 0,
        "adjusted_tradein_clean": 10670,
        "base_tradein_avg": 7370,
        "mileage_tradein_avg": 0,
        "add_deduct_tradein_avg": 400,
        "regional_tradein_avg": 0,
        "adjusted_tradein_avg": 7770,
        "base_tradein_rough": 4655,
        "mileage_tradein_rough": 0,
        "add_deduct_tradein_rough": 400,
        "regional_tradein_rough": 0,
        "adjusted_tradein_rough": 5055,
        "base_finadv": 10025,
        "mileage_finadv": 0,
        "add_deduct_finadv": 400,
        "regional_finadv": 0,
        "adjusted_finadv": 10425,
        "region2": 0,
        "region3": 0,
        "region4": 0,
        "region5": 0,
        "region6": 0,
        "msrp": 37790,
        "retail_equipped": 42895,
        "price_includes": "AT AC 8CY",
        "wheel_base": 160.5,
        "tire_size": "265/70R17",
        "gvw": 6800,
        "payload_cap": "1,500",
        "seat_cap": "6",
        "fuel_type": "Gas",
        "fuel_cap": "26.0",
        "fuel_delivery": "MPI",
        "hwy_mpg": "17",
        "city_mpg": "13",
        "engine_description": "5.7L V8 SFI Hemi Mlt-Disp",
        "cylinders": "8",
        "engine_displacement": "5.7L",
        "base_hp": "340 @ 5400",
        "taxable_hp": 49.2,
        "torque": "390 @ 4000",
        "oil_cap": "7.0",
        "transmission": "A",
        "drivetrain": "4WD",
        "num_gears": "5",
        "ext_doors": "4",
        "basic_warranty": "3-year/36,000-mile, Limited",
        "add_deduct_list": [
          {
            "uoc": "CH",
            "name": "Chrome Package",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "EP",
            "name": "Entertainment System",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "N5",
            "name": "Navigation System",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "RB",
            "name": "Power Running Boards",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "WP",
            "name": "20-Inch Wheel Package",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "12",
            "name": "Power Sunroof",
            "xclean": 250,
            "clean": 250,
            "avg": 250,
            "rough": 250,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "VH",
            "name": "5.7L HEMI V8",
            "xclean": 400,
            "clean": 400,
            "avg": 400,
            "rough": 400,
            "auto": "Y",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          }
        ],
        "mileage_list": [
          {
            "model_year": "2007",
            "range_begin": 1,
            "range_end": 42000,
            "xclean": 0,
            "clean": 2350,
            "avg": 2650,
            "rough": 2225,
            "finadv": 2200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 42001,
            "range_end": 54000,
            "xclean": 0,
            "clean": 2125,
            "avg": 2425,
            "rough": 2125,
            "finadv": 1975,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 54001,
            "range_end": 66000,
            "xclean": 0,
            "clean": 1875,
            "avg": 2175,
            "rough": 2000,
            "finadv": 1725,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 66001,
            "range_end": 78000,
            "xclean": 0,
            "clean": 1625,
            "avg": 1925,
            "rough": 1850,
            "finadv": 1450,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 78001,
            "range_end": 90000,
            "xclean": 0,
            "clean": 1325,
            "avg": 1650,
            "rough": 1675,
            "finadv": 1150,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 90001,
            "range_end": 102000,
            "xclean": 0,
            "clean": 1025,
            "avg": 1350,
            "rough": 1475,
            "finadv": 850,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 102001,
            "range_end": 114000,
            "xclean": 0,
            "clean": 700,
            "avg": 1025,
            "rough": 1250,
            "finadv": 525,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 114001,
            "range_end": 126000,
            "xclean": 0,
            "clean": 350,
            "avg": 700,
            "rough": 975,
            "finadv": 175,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 126001,
            "range_end": 138000,
            "xclean": 0,
            "clean": 0,
            "avg": 350,
            "rough": 675,
            "finadv": -200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 138001,
            "range_end": 150000,
            "xclean": 0,
            "clean": -375,
            "avg": 0,
            "rough": 350,
            "finadv": -550,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 150001,
            "range_end": 162000,
            "xclean": 0,
            "clean": -750,
            "avg": -375,
            "rough": 0,
            "finadv": -925,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 162001,
            "range_end": 174000,
            "xclean": 0,
            "clean": -1100,
            "avg": -750,
            "rough": -375,
            "finadv": -1300,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 174001,
            "range_end": 186000,
            "xclean": 0,
            "clean": -1475,
            "avg": -1100,
            "rough": -750,
            "finadv": -1650,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 186001,
            "range_end": 198000,
            "xclean": 0,
            "clean": -1825,
            "avg": -1475,
            "rough": -1100,
            "finadv": -2000,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 198001,
            "range_end": 210000,
            "xclean": 0,
            "clean": -2175,
            "avg": -1825,
            "rough": -1450,
            "finadv": -2350,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 210001,
            "range_end": 222000,
            "xclean": 0,
            "clean": -2525,
            "avg": -2175,
            "rough": -1825,
            "finadv": -2700,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 222001,
            "range_end": 234000,
            "xclean": 0,
            "clean": -2875,
            "avg": -2525,
            "rough": -2175,
            "finadv": -3050,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 234001,
            "range_end": 246000,
            "xclean": 0,
            "clean": -3225,
            "avg": -2875,
            "rough": -2525,
            "finadv": -3400,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 246001,
            "range_end": 258000,
            "xclean": 0,
            "clean": -3575,
            "avg": -3225,
            "rough": -2875,
            "finadv": -3750,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 258001,
            "range_end": 270000,
            "xclean": 0,
            "clean": -3925,
            "avg": -3550,
            "rough": -3200,
            "finadv": -4100,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 270001,
            "range_end": 999999,
            "xclean": 0,
            "clean": -4250,
            "avg": -3900,
            "rough": -3550,
            "finadv": -4425,
            "mileage_cat": "G"
          }
        ],
        "model_number_list": [
          "DR6P41",
          "DR6P42"
        ]
      },
      {
        "publish_date": "7/31/2019",
        "data_freq": "D",
        "state": "NT",
        "country": "US",
        "vin": "1D7HU1827",
        "uvc": "2007240572",
        "groupnum": "7435",
        "model_year": "2007",
        "make": "Dodge",
        "model": "Ram 1500",
        "series": "SLT",
        "style": "Quad Cab 4WD",
        "mileage_cat": "G",
        "class_code": "K",
        "class_name": "Pickup",
        "description_score": "",
        "first_values_flag": false,
        "risk_score": "",
        "base_whole_xclean": 0,
        "mileage_whole_xclean": 0,
        "add_deduct_whole_xclean": 0,
        "regional_whole_xclean": 0,
        "adjusted_whole_xclean": 0,
        "base_whole_clean": 9200,
        "mileage_whole_clean": 0,
        "add_deduct_whole_clean": 400,
        "regional_whole_clean": 0,
        "adjusted_whole_clean": 9600,
        "base_whole_avg": 6300,
        "mileage_whole_avg": 0,
        "add_deduct_whole_avg": 400,
        "regional_whole_avg": 0,
        "adjusted_whole_avg": 6700,
        "base_whole_rough": 4000,
        "mileage_whole_rough": 0,
        "add_deduct_whole_rough": 400,
        "regional_whole_rough": 0,
        "adjusted_whole_rough": 4400,
        "base_retail_xclean": 0,
        "mileage_retail_xclean": 0,
        "add_deduct_retail_xclean": 0,
        "regional_retail_xclean": 0,
        "adjusted_retail_xclean": 0,
        "base_retail_clean": 12700,
        "mileage_retail_clean": 0,
        "add_deduct_retail_clean": 400,
        "regional_retail_clean": 0,
        "adjusted_retail_clean": 13100,
        "base_retail_avg": 9325,
        "mileage_retail_avg": 0,
        "add_deduct_retail_avg": 400,
        "regional_retail_avg": 0,
        "adjusted_retail_avg": 9725,
        "base_retail_rough": 6725,
        "mileage_retail_rough": 0,
        "add_deduct_retail_rough": 400,
        "regional_retail_rough": 0,
        "adjusted_retail_rough": 7125,
        "base_tradein_clean": 9370,
        "mileage_tradein_clean": 0,
        "add_deduct_tradein_clean": 400,
        "regional_tradein_clean": 0,
        "adjusted_tradein_clean": 9770,
        "base_tradein_avg": 6470,
        "mileage_tradein_avg": 0,
        "add_deduct_tradein_avg": 400,
        "regional_tradein_avg": 0,
        "adjusted_tradein_avg": 6870,
        "base_tradein_rough": 3840,
        "mileage_tradein_rough": 0,
        "add_deduct_tradein_rough": 400,
        "regional_tradein_rough": 0,
        "adjusted_tradein_rough": 4240,
        "base_finadv": 9125,
        "mileage_finadv": 0,
        "add_deduct_finadv": 400,
        "regional_finadv": 0,
        "adjusted_finadv": 9525,
        "region2": 0,
        "region3": 0,
        "region4": 0,
        "region5": 0,
        "region6": 0,
        "msrp": 31605,
        "retail_equipped": 37480,
        "price_includes": "AT AC 8CY",
        "wheel_base": 160.5,
        "tire_size": "245/70R17",
        "gvw": 6800,
        "payload_cap": "1,500",
        "seat_cap": "6",
        "fuel_type": "Gas",
        "fuel_cap": "26.0",
        "fuel_delivery": "MPI",
        "hwy_mpg": "17",
        "city_mpg": "13",
        "engine_description": "5.7L V8 SFI Hemi Mlt-Disp",
        "cylinders": "8",
        "engine_displacement": "5.7L",
        "base_hp": "235 @ 4400",
        "taxable_hp": 49.2,
        "torque": "300 @ 3500",
        "oil_cap": "6.0",
        "transmission": "A",
        "drivetrain": "4WD",
        "num_gears": "6",
        "ext_doors": "4",
        "basic_warranty": "3-year/36,000-mile, Limited",
        "add_deduct_list": [
          {
            "uoc": "CH",
            "name": "Chrome Package",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "EP",
            "name": "Entertainment System",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "HR",
            "name": "Big Horn",
            "xclean": 125,
            "clean": 125,
            "avg": 125,
            "rough": 125,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "N5",
            "name": "Navigation System",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "RB",
            "name": "Power Running Boards",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "20",
            "name": "Leather",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "WP",
            "name": "20-Inch Wheel Package",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "12",
            "name": "Power Sunroof",
            "xclean": 250,
            "clean": 250,
            "avg": 250,
            "rough": 250,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "LO",
            "name": "Lone Star",
            "xclean": 300,
            "clean": 300,
            "avg": 300,
            "rough": 300,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "VH",
            "name": "5.7L HEMI V8",
            "xclean": 400,
            "clean": 400,
            "avg": 400,
            "rough": 400,
            "auto": "Y",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "05",
            "name": "w/o AT - Exc Diesel",
            "xclean": -850,
            "clean": -850,
            "avg": -850,
            "rough": -850,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          }
        ],
        "mileage_list": [
          {
            "model_year": "2007",
            "range_begin": 1,
            "range_end": 42000,
            "xclean": 0,
            "clean": 2350,
            "avg": 2650,
            "rough": 2225,
            "finadv": 2200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 42001,
            "range_end": 54000,
            "xclean": 0,
            "clean": 2125,
            "avg": 2425,
            "rough": 2125,
            "finadv": 1975,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 54001,
            "range_end": 66000,
            "xclean": 0,
            "clean": 1875,
            "avg": 2175,
            "rough": 2000,
            "finadv": 1725,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 66001,
            "range_end": 78000,
            "xclean": 0,
            "clean": 1625,
            "avg": 1925,
            "rough": 1850,
            "finadv": 1450,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 78001,
            "range_end": 90000,
            "xclean": 0,
            "clean": 1325,
            "avg": 1650,
            "rough": 1675,
            "finadv": 1150,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 90001,
            "range_end": 102000,
            "xclean": 0,
            "clean": 1025,
            "avg": 1350,
            "rough": 1475,
            "finadv": 850,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 102001,
            "range_end": 114000,
            "xclean": 0,
            "clean": 700,
            "avg": 1025,
            "rough": 1250,
            "finadv": 525,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 114001,
            "range_end": 126000,
            "xclean": 0,
            "clean": 350,
            "avg": 700,
            "rough": 975,
            "finadv": 175,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 126001,
            "range_end": 138000,
            "xclean": 0,
            "clean": 0,
            "avg": 350,
            "rough": 675,
            "finadv": -200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 138001,
            "range_end": 150000,
            "xclean": 0,
            "clean": -375,
            "avg": 0,
            "rough": 350,
            "finadv": -550,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 150001,
            "range_end": 162000,
            "xclean": 0,
            "clean": -750,
            "avg": -375,
            "rough": 0,
            "finadv": -925,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 162001,
            "range_end": 174000,
            "xclean": 0,
            "clean": -1100,
            "avg": -750,
            "rough": -375,
            "finadv": -1300,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 174001,
            "range_end": 186000,
            "xclean": 0,
            "clean": -1475,
            "avg": -1100,
            "rough": -750,
            "finadv": -1650,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 186001,
            "range_end": 198000,
            "xclean": 0,
            "clean": -1825,
            "avg": -1475,
            "rough": -1100,
            "finadv": -2000,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 198001,
            "range_end": 210000,
            "xclean": 0,
            "clean": -2175,
            "avg": -1825,
            "rough": -1450,
            "finadv": -2350,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 210001,
            "range_end": 222000,
            "xclean": 0,
            "clean": -2525,
            "avg": -2175,
            "rough": -1825,
            "finadv": -2700,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 222001,
            "range_end": 234000,
            "xclean": 0,
            "clean": -2875,
            "avg": -2525,
            "rough": -2175,
            "finadv": -3050,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 234001,
            "range_end": 246000,
            "xclean": 0,
            "clean": -3225,
            "avg": -2875,
            "rough": -2525,
            "finadv": -3400,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 246001,
            "range_end": 258000,
            "xclean": 0,
            "clean": -3575,
            "avg": -3225,
            "rough": -2875,
            "finadv": -3750,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 258001,
            "range_end": 270000,
            "xclean": 0,
            "clean": -3925,
            "avg": -3550,
            "rough": -3200,
            "finadv": -4100,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 270001,
            "range_end": 999999,
            "xclean": 0,
            "clean": -4250,
            "avg": -3900,
            "rough": -3550,
            "finadv": -4425,
            "mileage_cat": "G"
          }
        ],
        "model_number_list": [
          "DR6H41",
          "DR6H42"
        ]
      },
      {
        "publish_date": "7/31/2019",
        "data_freq": "D",
        "state": "NT",
        "country": "US",
        "vin": "1D7HU1827",
        "uvc": "2007240699",
        "groupnum": "7439",
        "model_year": "2007",
        "make": "Dodge",
        "model": "Ram 1500",
        "series": "Sport",
        "style": "Quad Cab 4WD",
        "mileage_cat": "G",
        "class_code": "K",
        "class_name": "Pickup",
        "description_score": "",
        "first_values_flag": false,
        "risk_score": "",
        "base_whole_xclean": 0,
        "mileage_whole_xclean": 0,
        "add_deduct_whole_xclean": 0,
        "regional_whole_xclean": 0,
        "adjusted_whole_xclean": 0,
        "base_whole_clean": 10300,
        "mileage_whole_clean": 0,
        "add_deduct_whole_clean": 0,
        "regional_whole_clean": 0,
        "adjusted_whole_clean": 10300,
        "base_whole_avg": 7400,
        "mileage_whole_avg": 0,
        "add_deduct_whole_avg": 0,
        "regional_whole_avg": 0,
        "adjusted_whole_avg": 7400,
        "base_whole_rough": 5100,
        "mileage_whole_rough": 0,
        "add_deduct_whole_rough": 0,
        "regional_whole_rough": 0,
        "adjusted_whole_rough": 5100,
        "base_retail_xclean": 0,
        "mileage_retail_xclean": 0,
        "add_deduct_retail_xclean": 0,
        "regional_retail_xclean": 0,
        "adjusted_retail_xclean": 0,
        "base_retail_clean": 13900,
        "mileage_retail_clean": 0,
        "add_deduct_retail_clean": 0,
        "regional_retail_clean": 0,
        "adjusted_retail_clean": 13900,
        "base_retail_avg": 10500,
        "mileage_retail_avg": 0,
        "add_deduct_retail_avg": 0,
        "regional_retail_avg": 0,
        "adjusted_retail_avg": 10500,
        "base_retail_rough": 7900,
        "mileage_retail_rough": 0,
        "add_deduct_retail_rough": 0,
        "regional_retail_rough": 0,
        "adjusted_retail_rough": 7900,
        "base_tradein_clean": 10470,
        "mileage_tradein_clean": 0,
        "add_deduct_tradein_clean": 0,
        "regional_tradein_clean": 0,
        "adjusted_tradein_clean": 10470,
        "base_tradein_avg": 7570,
        "mileage_tradein_avg": 0,
        "add_deduct_tradein_avg": 0,
        "regional_tradein_avg": 0,
        "adjusted_tradein_avg": 7570,
        "base_tradein_rough": 4845,
        "mileage_tradein_rough": 0,
        "add_deduct_tradein_rough": 0,
        "regional_tradein_rough": 0,
        "adjusted_tradein_rough": 4845,
        "base_finadv": 10225,
        "mileage_finadv": 0,
        "add_deduct_finadv": 0,
        "regional_finadv": 0,
        "adjusted_finadv": 10225,
        "region2": 0,
        "region3": 0,
        "region4": 0,
        "region5": 0,
        "region6": 0,
        "msrp": 36715,
        "retail_equipped": 40550,
        "price_includes": "AT AC 8CY",
        "wheel_base": 140.5,
        "tire_size": "275/60R20",
        "gvw": 6800,
        "payload_cap": "1,500",
        "seat_cap": "6",
        "fuel_type": "Gas",
        "fuel_cap": "26.0",
        "fuel_delivery": "MPI",
        "hwy_mpg": "17",
        "city_mpg": "13",
        "engine_description": "5.7L V8 SFI Hemi Mlt-Disp",
        "cylinders": "8",
        "engine_displacement": "5.7L",
        "base_hp": "340 @ 5400",
        "taxable_hp": 49.2,
        "torque": "390 @ 4000",
        "oil_cap": "7.0",
        "transmission": "A",
        "drivetrain": "4WD",
        "num_gears": "5",
        "ext_doors": "4",
        "basic_warranty": "3-year/36,000-mile, Limited",
        "add_deduct_list": [
          {
            "uoc": "CH",
            "name": "Chrome Package",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "EP",
            "name": "Entertainment System",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "N5",
            "name": "Navigation System",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "20",
            "name": "Leather",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "12",
            "name": "Power Sunroof",
            "xclean": 250,
            "clean": 250,
            "avg": 250,
            "rough": 250,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          }
        ],
        "mileage_list": [
          {
            "model_year": "2007",
            "range_begin": 1,
            "range_end": 42000,
            "xclean": 0,
            "clean": 2350,
            "avg": 2650,
            "rough": 2225,
            "finadv": 2200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 42001,
            "range_end": 54000,
            "xclean": 0,
            "clean": 2125,
            "avg": 2425,
            "rough": 2125,
            "finadv": 1975,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 54001,
            "range_end": 66000,
            "xclean": 0,
            "clean": 1875,
            "avg": 2175,
            "rough": 2000,
            "finadv": 1725,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 66001,
            "range_end": 78000,
            "xclean": 0,
            "clean": 1625,
            "avg": 1925,
            "rough": 1850,
            "finadv": 1450,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 78001,
            "range_end": 90000,
            "xclean": 0,
            "clean": 1325,
            "avg": 1650,
            "rough": 1675,
            "finadv": 1150,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 90001,
            "range_end": 102000,
            "xclean": 0,
            "clean": 1025,
            "avg": 1350,
            "rough": 1475,
            "finadv": 850,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 102001,
            "range_end": 114000,
            "xclean": 0,
            "clean": 700,
            "avg": 1025,
            "rough": 1250,
            "finadv": 525,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 114001,
            "range_end": 126000,
            "xclean": 0,
            "clean": 350,
            "avg": 700,
            "rough": 975,
            "finadv": 175,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 126001,
            "range_end": 138000,
            "xclean": 0,
            "clean": 0,
            "avg": 350,
            "rough": 675,
            "finadv": -200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 138001,
            "range_end": 150000,
            "xclean": 0,
            "clean": -375,
            "avg": 0,
            "rough": 350,
            "finadv": -550,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 150001,
            "range_end": 162000,
            "xclean": 0,
            "clean": -750,
            "avg": -375,
            "rough": 0,
            "finadv": -925,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 162001,
            "range_end": 174000,
            "xclean": 0,
            "clean": -1100,
            "avg": -750,
            "rough": -375,
            "finadv": -1300,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 174001,
            "range_end": 186000,
            "xclean": 0,
            "clean": -1475,
            "avg": -1100,
            "rough": -750,
            "finadv": -1650,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 186001,
            "range_end": 198000,
            "xclean": 0,
            "clean": -1825,
            "avg": -1475,
            "rough": -1100,
            "finadv": -2000,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 198001,
            "range_end": 210000,
            "xclean": 0,
            "clean": -2175,
            "avg": -1825,
            "rough": -1450,
            "finadv": -2350,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 210001,
            "range_end": 222000,
            "xclean": 0,
            "clean": -2525,
            "avg": -2175,
            "rough": -1825,
            "finadv": -2700,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 222001,
            "range_end": 234000,
            "xclean": 0,
            "clean": -2875,
            "avg": -2525,
            "rough": -2175,
            "finadv": -3050,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 234001,
            "range_end": 246000,
            "xclean": 0,
            "clean": -3225,
            "avg": -2875,
            "rough": -2525,
            "finadv": -3400,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 246001,
            "range_end": 258000,
            "xclean": 0,
            "clean": -3575,
            "avg": -3225,
            "rough": -2875,
            "finadv": -3750,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 258001,
            "range_end": 270000,
            "xclean": 0,
            "clean": -3925,
            "avg": -3550,
            "rough": -3200,
            "finadv": -4100,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 270001,
            "range_end": 999999,
            "xclean": 0,
            "clean": -4250,
            "avg": -3900,
            "rough": -3550,
            "finadv": -4425,
            "mileage_cat": "G"
          }
        ],
        "model_number_list": [
          "DR6H41"
        ]
      },
      {
        "publish_date": "7/31/2019",
        "data_freq": "D",
        "state": "NT",
        "country": "US",
        "vin": "1D7HU1827",
        "uvc": "2007240448",
        "groupnum": "7443",
        "model_year": "2007",
        "make": "Dodge",
        "model": "Ram 1500",
        "series": "ST",
        "style": "Quad Cab 4WD",
        "mileage_cat": "G",
        "class_code": "K",
        "class_name": "Pickup",
        "description_score": "",
        "first_values_flag": false,
        "risk_score": "",
        "base_whole_xclean": 0,
        "mileage_whole_xclean": 0,
        "add_deduct_whole_xclean": 0,
        "regional_whole_xclean": 0,
        "adjusted_whole_xclean": 0,
        "base_whole_clean": 9000,
        "mileage_whole_clean": 0,
        "add_deduct_whole_clean": 400,
        "regional_whole_clean": 0,
        "adjusted_whole_clean": 9400,
        "base_whole_avg": 6100,
        "mileage_whole_avg": 0,
        "add_deduct_whole_avg": 400,
        "regional_whole_avg": 0,
        "adjusted_whole_avg": 6500,
        "base_whole_rough": 3800,
        "mileage_whole_rough": 0,
        "add_deduct_whole_rough": 400,
        "regional_whole_rough": 0,
        "adjusted_whole_rough": 4200,
        "base_retail_xclean": 0,
        "mileage_retail_xclean": 0,
        "add_deduct_retail_xclean": 0,
        "regional_retail_xclean": 0,
        "adjusted_retail_xclean": 0,
        "base_retail_clean": 12475,
        "mileage_retail_clean": 0,
        "add_deduct_retail_clean": 400,
        "regional_retail_clean": 0,
        "adjusted_retail_clean": 12875,
        "base_retail_avg": 9125,
        "mileage_retail_avg": 0,
        "add_deduct_retail_avg": 400,
        "regional_retail_avg": 0,
        "adjusted_retail_avg": 9525,
        "base_retail_rough": 6500,
        "mileage_retail_rough": 0,
        "add_deduct_retail_rough": 400,
        "regional_retail_rough": 0,
        "adjusted_retail_rough": 6900,
        "base_tradein_clean": 9170,
        "mileage_tradein_clean": 0,
        "add_deduct_tradein_clean": 400,
        "regional_tradein_clean": 0,
        "adjusted_tradein_clean": 9570,
        "base_tradein_avg": 6270,
        "mileage_tradein_avg": 0,
        "add_deduct_tradein_avg": 400,
        "regional_tradein_avg": 0,
        "adjusted_tradein_avg": 6670,
        "base_tradein_rough": 3645,
        "mileage_tradein_rough": 0,
        "add_deduct_tradein_rough": 400,
        "regional_tradein_rough": 0,
        "adjusted_tradein_rough": 4045,
        "base_finadv": 8925,
        "mileage_finadv": 0,
        "add_deduct_finadv": 400,
        "regional_finadv": 0,
        "adjusted_finadv": 9325,
        "region2": 0,
        "region3": 0,
        "region4": 0,
        "region5": 0,
        "region6": 0,
        "msrp": 29810,
        "retail_equipped": 34845,
        "price_includes": "AT AC 8CY",
        "wheel_base": 160.5,
        "tire_size": "245/70R17",
        "gvw": 6800,
        "payload_cap": "1,500",
        "seat_cap": "6",
        "fuel_type": "Gas",
        "fuel_cap": "26.0",
        "fuel_delivery": "MPI",
        "hwy_mpg": "17",
        "city_mpg": "13",
        "engine_description": "5.7L V8 SFI Hemi Mlt-Disp",
        "cylinders": "8",
        "engine_displacement": "5.7L",
        "base_hp": "235 @ 4400",
        "taxable_hp": 49.2,
        "torque": "300 @ 3500",
        "oil_cap": "6.0",
        "transmission": "A",
        "drivetrain": "4WD",
        "num_gears": "6",
        "ext_doors": "4",
        "basic_warranty": "3-year/36,000-mile, Limited",
        "add_deduct_list": [
          {
            "uoc": "84",
            "name": "Chrome Wheels",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "CH",
            "name": "Chrome Package",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "RB",
            "name": "Power Running Boards",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "20",
            "name": "Leather",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "WP",
            "name": "20-Inch Wheel Package",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "SK",
            "name": "SXT App Package",
            "xclean": 250,
            "clean": 250,
            "avg": 250,
            "rough": 250,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "09",
            "name": "Power Windows",
            "xclean": 300,
            "clean": 300,
            "avg": 300,
            "rough": 300,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "VH",
            "name": "5.7L HEMI V8",
            "xclean": 400,
            "clean": 400,
            "avg": 400,
            "rough": 400,
            "auto": "Y",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "WK",
            "name": "Work Truck Group",
            "xclean": -100,
            "clean": -100,
            "avg": -100,
            "rough": -100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "05",
            "name": "w/o AT - Exc Diesel",
            "xclean": -850,
            "clean": -850,
            "avg": -850,
            "rough": -850,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          }
        ],
        "mileage_list": [
          {
            "model_year": "2007",
            "range_begin": 1,
            "range_end": 42000,
            "xclean": 0,
            "clean": 2350,
            "avg": 2650,
            "rough": 2225,
            "finadv": 2200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 42001,
            "range_end": 54000,
            "xclean": 0,
            "clean": 2125,
            "avg": 2425,
            "rough": 2125,
            "finadv": 1975,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 54001,
            "range_end": 66000,
            "xclean": 0,
            "clean": 1875,
            "avg": 2175,
            "rough": 2000,
            "finadv": 1725,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 66001,
            "range_end": 78000,
            "xclean": 0,
            "clean": 1625,
            "avg": 1925,
            "rough": 1850,
            "finadv": 1450,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 78001,
            "range_end": 90000,
            "xclean": 0,
            "clean": 1325,
            "avg": 1650,
            "rough": 1675,
            "finadv": 1150,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 90001,
            "range_end": 102000,
            "xclean": 0,
            "clean": 1025,
            "avg": 1350,
            "rough": 1475,
            "finadv": 850,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 102001,
            "range_end": 114000,
            "xclean": 0,
            "clean": 700,
            "avg": 1025,
            "rough": 1250,
            "finadv": 525,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 114001,
            "range_end": 126000,
            "xclean": 0,
            "clean": 350,
            "avg": 700,
            "rough": 975,
            "finadv": 175,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 126001,
            "range_end": 138000,
            "xclean": 0,
            "clean": 0,
            "avg": 350,
            "rough": 675,
            "finadv": -200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 138001,
            "range_end": 150000,
            "xclean": 0,
            "clean": -375,
            "avg": 0,
            "rough": 350,
            "finadv": -550,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 150001,
            "range_end": 162000,
            "xclean": 0,
            "clean": -750,
            "avg": -375,
            "rough": 0,
            "finadv": -925,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 162001,
            "range_end": 174000,
            "xclean": 0,
            "clean": -1100,
            "avg": -750,
            "rough": -375,
            "finadv": -1300,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 174001,
            "range_end": 186000,
            "xclean": 0,
            "clean": -1475,
            "avg": -1100,
            "rough": -750,
            "finadv": -1650,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 186001,
            "range_end": 198000,
            "xclean": 0,
            "clean": -1825,
            "avg": -1475,
            "rough": -1100,
            "finadv": -2000,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 198001,
            "range_end": 210000,
            "xclean": 0,
            "clean": -2175,
            "avg": -1825,
            "rough": -1450,
            "finadv": -2350,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 210001,
            "range_end": 222000,
            "xclean": 0,
            "clean": -2525,
            "avg": -2175,
            "rough": -1825,
            "finadv": -2700,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 222001,
            "range_end": 234000,
            "xclean": 0,
            "clean": -2875,
            "avg": -2525,
            "rough": -2175,
            "finadv": -3050,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 234001,
            "range_end": 246000,
            "xclean": 0,
            "clean": -3225,
            "avg": -2875,
            "rough": -2525,
            "finadv": -3400,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 246001,
            "range_end": 258000,
            "xclean": 0,
            "clean": -3575,
            "avg": -3225,
            "rough": -2875,
            "finadv": -3750,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 258001,
            "range_end": 270000,
            "xclean": 0,
            "clean": -3925,
            "avg": -3550,
            "rough": -3200,
            "finadv": -4100,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 270001,
            "range_end": 999999,
            "xclean": 0,
            "clean": -4250,
            "avg": -3900,
            "rough": -3550,
            "finadv": -4425,
            "mileage_cat": "G"
          }
        ],
        "model_number_list": [
          "DR6L41",
          "DR6L42"
        ]
      },
      {
        "publish_date": "7/31/2019",
        "data_freq": "D",
        "state": "NT",
        "country": "US",
        "vin": "1D7HU1827",
        "uvc": "2007240698",
        "groupnum": "7446",
        "model_year": "2007",
        "make": "Dodge",
        "model": "Ram 1500",
        "series": "TRX4",
        "style": "Quad Cab 4WD",
        "mileage_cat": "G",
        "class_code": "K",
        "class_name": "Pickup",
        "description_score": "",
        "first_values_flag": false,
        "risk_score": "",
        "base_whole_xclean": 0,
        "mileage_whole_xclean": 0,
        "add_deduct_whole_xclean": 0,
        "regional_whole_xclean": 0,
        "adjusted_whole_xclean": 0,
        "base_whole_clean": 10200,
        "mileage_whole_clean": 0,
        "add_deduct_whole_clean": 400,
        "regional_whole_clean": 0,
        "adjusted_whole_clean": 10600,
        "base_whole_avg": 7300,
        "mileage_whole_avg": 0,
        "add_deduct_whole_avg": 400,
        "regional_whole_avg": 0,
        "adjusted_whole_avg": 7700,
        "base_whole_rough": 5000,
        "mileage_whole_rough": 0,
        "add_deduct_whole_rough": 400,
        "regional_whole_rough": 0,
        "adjusted_whole_rough": 5400,
        "base_retail_xclean": 0,
        "mileage_retail_xclean": 0,
        "add_deduct_retail_xclean": 0,
        "regional_retail_xclean": 0,
        "adjusted_retail_xclean": 0,
        "base_retail_clean": 13750,
        "mileage_retail_clean": 0,
        "add_deduct_retail_clean": 400,
        "regional_retail_clean": 0,
        "adjusted_retail_clean": 14150,
        "base_retail_avg": 10400,
        "mileage_retail_avg": 0,
        "add_deduct_retail_avg": 400,
        "regional_retail_avg": 0,
        "adjusted_retail_avg": 10800,
        "base_retail_rough": 7800,
        "mileage_retail_rough": 0,
        "add_deduct_retail_rough": 400,
        "regional_retail_rough": 0,
        "adjusted_retail_rough": 8200,
        "base_tradein_clean": 10370,
        "mileage_tradein_clean": 0,
        "add_deduct_tradein_clean": 400,
        "regional_tradein_clean": 0,
        "adjusted_tradein_clean": 10770,
        "base_tradein_avg": 7470,
        "mileage_tradein_avg": 0,
        "add_deduct_tradein_avg": 400,
        "regional_tradein_avg": 0,
        "adjusted_tradein_avg": 7870,
        "base_tradein_rough": 4750,
        "mileage_tradein_rough": 0,
        "add_deduct_tradein_rough": 400,
        "regional_tradein_rough": 0,
        "adjusted_tradein_rough": 5150,
        "base_finadv": 10125,
        "mileage_finadv": 0,
        "add_deduct_finadv": 400,
        "regional_finadv": 0,
        "adjusted_finadv": 10525,
        "region2": 0,
        "region3": 0,
        "region4": 0,
        "region5": 0,
        "region6": 0,
        "msrp": 32855,
        "retail_equipped": 38550,
        "price_includes": "AT AC 8CY",
        "wheel_base": 140.5,
        "tire_size": "265/70R17",
        "gvw": 6700,
        "payload_cap": "1,500",
        "seat_cap": "6",
        "fuel_type": "Gas",
        "fuel_cap": "26.0",
        "fuel_delivery": "MPI",
        "hwy_mpg": "19",
        "city_mpg": "14",
        "engine_description": "5.7L V8 SFI Hemi Mlt-Disp",
        "cylinders": "8",
        "engine_displacement": "5.7L",
        "base_hp": "235 @ 4400",
        "taxable_hp": 49.2,
        "torque": "300 @ 3500",
        "oil_cap": "6.0",
        "transmission": "A",
        "drivetrain": "4WD",
        "num_gears": "6",
        "ext_doors": "4",
        "basic_warranty": "3-year/36,000-mile, Limited",
        "add_deduct_list": [
          {
            "uoc": "CH",
            "name": "Chrome Package",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "EP",
            "name": "Entertainment System",
            "xclean": 100,
            "clean": 100,
            "avg": 100,
            "rough": 100,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "N5",
            "name": "Navigation System",
            "xclean": 150,
            "clean": 150,
            "avg": 150,
            "rough": 150,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "20",
            "name": "Leather",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "WP",
            "name": "20-Inch Wheel Package",
            "xclean": 225,
            "clean": 225,
            "avg": 225,
            "rough": 225,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "12",
            "name": "Power Sunroof",
            "xclean": 250,
            "clean": 250,
            "avg": 250,
            "rough": 250,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "VH",
            "name": "5.7L HEMI V8",
            "xclean": 400,
            "clean": 400,
            "avg": 400,
            "rough": 400,
            "auto": "Y",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          },
          {
            "uoc": "05",
            "name": "w/o AT - Exc Diesel",
            "xclean": -850,
            "clean": -850,
            "avg": -850,
            "rough": -850,
            "auto": "N",
            "resid12": 0,
            "resid24": 0,
            "resid30": 0,
            "resid36": 0,
            "resid42": 0,
            "resid48": 0,
            "resid60": 0,
            "resid72": 0
          }
        ],
        "mileage_list": [
          {
            "model_year": "2007",
            "range_begin": 1,
            "range_end": 42000,
            "xclean": 0,
            "clean": 2350,
            "avg": 2650,
            "rough": 2225,
            "finadv": 2200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 42001,
            "range_end": 54000,
            "xclean": 0,
            "clean": 2125,
            "avg": 2425,
            "rough": 2125,
            "finadv": 1975,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 54001,
            "range_end": 66000,
            "xclean": 0,
            "clean": 1875,
            "avg": 2175,
            "rough": 2000,
            "finadv": 1725,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 66001,
            "range_end": 78000,
            "xclean": 0,
            "clean": 1625,
            "avg": 1925,
            "rough": 1850,
            "finadv": 1450,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 78001,
            "range_end": 90000,
            "xclean": 0,
            "clean": 1325,
            "avg": 1650,
            "rough": 1675,
            "finadv": 1150,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 90001,
            "range_end": 102000,
            "xclean": 0,
            "clean": 1025,
            "avg": 1350,
            "rough": 1475,
            "finadv": 850,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 102001,
            "range_end": 114000,
            "xclean": 0,
            "clean": 700,
            "avg": 1025,
            "rough": 1250,
            "finadv": 525,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 114001,
            "range_end": 126000,
            "xclean": 0,
            "clean": 350,
            "avg": 700,
            "rough": 975,
            "finadv": 175,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 126001,
            "range_end": 138000,
            "xclean": 0,
            "clean": 0,
            "avg": 350,
            "rough": 675,
            "finadv": -200,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 138001,
            "range_end": 150000,
            "xclean": 0,
            "clean": -375,
            "avg": 0,
            "rough": 350,
            "finadv": -550,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 150001,
            "range_end": 162000,
            "xclean": 0,
            "clean": -750,
            "avg": -375,
            "rough": 0,
            "finadv": -925,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 162001,
            "range_end": 174000,
            "xclean": 0,
            "clean": -1100,
            "avg": -750,
            "rough": -375,
            "finadv": -1300,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 174001,
            "range_end": 186000,
            "xclean": 0,
            "clean": -1475,
            "avg": -1100,
            "rough": -750,
            "finadv": -1650,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 186001,
            "range_end": 198000,
            "xclean": 0,
            "clean": -1825,
            "avg": -1475,
            "rough": -1100,
            "finadv": -2000,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 198001,
            "range_end": 210000,
            "xclean": 0,
            "clean": -2175,
            "avg": -1825,
            "rough": -1450,
            "finadv": -2350,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 210001,
            "range_end": 222000,
            "xclean": 0,
            "clean": -2525,
            "avg": -2175,
            "rough": -1825,
            "finadv": -2700,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 222001,
            "range_end": 234000,
            "xclean": 0,
            "clean": -2875,
            "avg": -2525,
            "rough": -2175,
            "finadv": -3050,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 234001,
            "range_end": 246000,
            "xclean": 0,
            "clean": -3225,
            "avg": -2875,
            "rough": -2525,
            "finadv": -3400,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 246001,
            "range_end": 258000,
            "xclean": 0,
            "clean": -3575,
            "avg": -3225,
            "rough": -2875,
            "finadv": -3750,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 258001,
            "range_end": 270000,
            "xclean": 0,
            "clean": -3925,
            "avg": -3550,
            "rough": -3200,
            "finadv": -4100,
            "mileage_cat": "G"
          },
          {
            "model_year": "2007",
            "range_begin": 270001,
            "range_end": 999999,
            "xclean": 0,
            "clean": -4250,
            "avg": -3900,
            "rough": -3550,
            "finadv": -4425,
            "mileage_cat": "G"
          }
        ],
        "model_number_list": [
          "DR6H41"
        ]
      }
    ],
    "template": 1,
    "version": 1,
    "data_included": true,
    "data_available": true
  }
}