Sample Of American Year Make Model Trim Specs

CREATE TABLE year_make_model_trim_full_specs_by_teoalida_sample (
  "id" BIGINT,
  "make" VARCHAR,
  "model" VARCHAR,
  "year" BIGINT,
  "trim" VARCHAR,
  "trim_description" VARCHAR  -- Trim (description),
  "base_msrp" VARCHAR,
  "base_invoice" VARCHAR,
  "colors_exterior" VARCHAR,
  "colors_interior" VARCHAR,
  "body_type" VARCHAR,
  "doors" BIGINT,
  "total_seating" DOUBLE,
  "length_in" DOUBLE  -- Length (in),
  "width_in" DOUBLE  -- Width (in),
  "height_in" DOUBLE  -- Height (in),
  "wheelbase_in" DOUBLE  -- Wheelbase (in),
  "front_track_in" DOUBLE  -- Front Track (in),
  "rear_track_in" DOUBLE  -- Rear Track (in),
  "ground_clearance_in" DOUBLE  -- Ground Clearance (in),
  "angle_of_approach_degrees" DOUBLE  -- Angle Of Approach (degrees),
  "angle_of_departure_degrees" DOUBLE  -- Angle Of Departure (degrees),
  "turning_circle_ft" DOUBLE  -- Turning Circle (ft),
  "drag_coefficient_cd" DOUBLE  -- Drag Coefficient (Cd),
  "epa_interior_volume_cu_ft" DOUBLE  -- EPA Interior Volume (cu Ft),
  "cargo_capacity_cu_ft" DOUBLE  -- Cargo Capacity (cu Ft),
  "maximum_cargo_capacity_cu_ft" DOUBLE  -- Maximum Cargo Capacity (cu Ft),
  "curb_weight_lbs" DOUBLE  -- Curb Weight (lbs),
  "gross_weight_lbs" DOUBLE  -- Gross Weight (lbs),
  "maximum_payload_lbs" DOUBLE  -- Maximum Payload (lbs),
  "maximum_towing_capacity_lbs" DOUBLE  -- Maximum Towing Capacity (lbs),
  "cylinders" VARCHAR,
  "engine_size_l" DOUBLE  -- Engine Size (l),
  "horsepower_hp" BIGINT  -- Horsepower (HP),
  "horsepower_rpm" DOUBLE  -- Horsepower (rpm),
  "torque_ft_lbs" DOUBLE  -- Torque (ft-lbs),
  "torque_rpm" DOUBLE  -- Torque (rpm),
  "valves" DOUBLE,
  "valve_timing" VARCHAR,
  "cam_type" VARCHAR,
  "drive_type" VARCHAR,
  "transmission" VARCHAR,
  "engine_type" VARCHAR,
  "fuel_type" VARCHAR,
  "fuel_tank_capacity_gal" DOUBLE  -- Fuel Tank Capacity (gal),
  "epa_combined_mpg" DOUBLE,
  "epa_city_highway_mpg" VARCHAR,
  "range_in_miles_city_hwy" VARCHAR  -- Range In Miles (city/hwy),
  "epa_combined_mpge" DOUBLE,
  "epa_city_highway_mpge" VARCHAR,
  "epa_electricity_range_mi" VARCHAR  -- EPA Electricity Range (mi),
  "epa_kwh_100_mi" DOUBLE,
  "epa_time_to_charge_battery_at_240v_hr" DOUBLE  -- EPA Time To Charge Battery (at 240V) (hr),
  "battery_capacity_kwh" DOUBLE  -- Battery Capacity (kWh),
  "front_head_room_in" DOUBLE  -- Front Head Room (in),
  "front_hip_room_in" DOUBLE  -- Front Hip Room (in),
  "front_leg_room_in" DOUBLE  -- Front Leg Room (in),
  "front_shoulder_room_in" DOUBLE  -- Front Shoulder Room (in),
  "rear_head_room_in" DOUBLE  -- Rear Head Room (in),
  "rear_hip_room_in" DOUBLE  -- Rear Hip Room (in),
  "rear_leg_room_in" DOUBLE  -- Rear Leg Room (in),
  "rear_shoulder_room_in" DOUBLE  -- Rear Shoulder Room (in),
  "basic" VARCHAR,
  "drivetrain" VARCHAR,
  "roadside" VARCHAR,
  "rust" VARCHAR,
  "source_json" VARCHAR,
  "source_url" VARCHAR,
  "image_url" VARCHAR,
  "nhtsa_overall_rating" VARCHAR,
  "scorecard_overall" VARCHAR,
  "scorecard_driving" VARCHAR,
  "scorecard_comfort" VARCHAR,
  "scorecard_interior" VARCHAR,
  "scorecard_utility" VARCHAR,
  "scorecard_technology" VARCHAR,
  "expert_rating_our_verdict" VARCHAR  -- Expert Rating - Our Verdict,
  "expert_rating_driving" VARCHAR  -- Expert Rating - Driving,
  "expert_rating_comfort" VARCHAR  -- Expert Rating - Comfort,
  "expert_rating_interior" VARCHAR  -- Expert Rating - Interior,
  "expert_rating_technology" VARCHAR  -- Expert Rating - Technology,
  "expert_rating_storage" VARCHAR  -- Expert Rating - Storage,
  "expert_rating_economy" VARCHAR  -- Expert Rating - Economy,
  "expert_rating_value" VARCHAR  -- Expert Rating - Value,
  "expert_rating_wildcard" VARCHAR  -- Expert Rating - Wildcard,
  "old_trim" VARCHAR,
  "old_description" VARCHAR,
  "images_url" VARCHAR,
  "suspension" VARCHAR,
  "front_seats" VARCHAR,
  "rear_seats" VARCHAR,
  "power_features" VARCHAR,
  "instrumentation" VARCHAR,
  "convenience" VARCHAR,
  "comfort" VARCHAR,
  "memorized_settings" VARCHAR,
  "in_car_entertainment" VARCHAR,
  "roof_and_glass" VARCHAR,
  "body" VARCHAR,
  "truck_features" VARCHAR
);