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,
  "base_msrp" VARCHAR,
  "base_invoice" VARCHAR,
  "colors_exterior" VARCHAR,
  "colors_interior" VARCHAR,
  "body_type" VARCHAR,
  "doors" BIGINT,
  "total_seating" DOUBLE,
  "length_in" DOUBLE,
  "width_in" DOUBLE,
  "height_in" DOUBLE,
  "wheelbase_in" DOUBLE,
  "front_track_in" DOUBLE,
  "rear_track_in" DOUBLE,
  "ground_clearance_in" DOUBLE,
  "angle_of_approach_degrees" DOUBLE,
  "angle_of_departure_degrees" DOUBLE,
  "turning_circle_ft" DOUBLE,
  "drag_coefficient_cd" DOUBLE,
  "epa_interior_volume_cu_ft" DOUBLE,
  "cargo_capacity_cu_ft" DOUBLE,
  "maximum_cargo_capacity_cu_ft" DOUBLE,
  "curb_weight_lbs" DOUBLE,
  "gross_weight_lbs" DOUBLE,
  "maximum_payload_lbs" DOUBLE,
  "maximum_towing_capacity_lbs" DOUBLE,
  "cylinders" VARCHAR,
  "engine_size_l" DOUBLE,
  "horsepower_hp" BIGINT,
  "horsepower_rpm" DOUBLE,
  "torque_ft_lbs" DOUBLE,
  "torque_rpm" DOUBLE,
  "valves" DOUBLE,
  "valve_timing" VARCHAR,
  "cam_type" VARCHAR,
  "drive_type" VARCHAR,
  "transmission" VARCHAR,
  "engine_type" VARCHAR,
  "fuel_type" VARCHAR,
  "fuel_tank_capacity_gal" DOUBLE,
  "epa_combined_mpg" DOUBLE,
  "epa_city_highway_mpg" VARCHAR,
  "range_in_miles_city_hwy" VARCHAR,
  "epa_combined_mpge" DOUBLE,
  "epa_city_highway_mpge" VARCHAR,
  "epa_electricity_range_mi" VARCHAR,
  "epa_kwh_100_mi" DOUBLE,
  "epa_time_to_charge_battery_at_240v_hr" DOUBLE,
  "battery_capacity_kwh" DOUBLE,
  "front_head_room_in" DOUBLE,
  "front_hip_room_in" DOUBLE,
  "front_leg_room_in" DOUBLE,
  "front_shoulder_room_in" DOUBLE,
  "rear_head_room_in" DOUBLE,
  "rear_hip_room_in" DOUBLE,
  "rear_leg_room_in" DOUBLE,
  "rear_shoulder_room_in" DOUBLE,
  "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_driving" VARCHAR,
  "expert_rating_comfort" VARCHAR,
  "expert_rating_interior" VARCHAR,
  "expert_rating_technology" VARCHAR,
  "expert_rating_storage" VARCHAR,
  "expert_rating_economy" VARCHAR,
  "expert_rating_value" VARCHAR,
  "expert_rating_wildcard" VARCHAR,
  "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
);