VCDB — Vehicles for base vehicle 153868

All columns from aaia_vcdb.vehicle (capped at 500 rows), plus manual joins for make/model/year/submodel/region, and extra columns from every other parent declared as a PostgreSQL foreign key from vehicle (engine, transmission, etc.—when FK metadata exists). Dynamic columns are prefixed like vcdb_j0_tablename_colname.

Full aaia_vcdb FK listing · if engine/trans columns are missing, the DB may not define those FKs.

vehicleid basevehicleid submodelid regionid source publicationstageid publicationstagesource publicationstagedate vcdb_make vcdb_model vcdb_year vcdb_submodel vcdb_region_abbr vcdb_region_name vcdb_j0_publicationstage_publicationstagename vcdb_j1_publicationstage_publicationstagename Browse
275075 153868 2537 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 Adventure USA United States 4 4 Row
275076 153868 269 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 LE USA United States 4 4 Row
275077 153868 4983 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 Hybrid XSE USA United States 4 4 Row
275078 153868 3127 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 Hybrid XLE USA United States 4 4 Row
275079 153868 1399 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 Hybrid Limited USA United States 4 4 Row
275080 153868 3126 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 Hybrid LE USA United States 4 4 Row
275081 153868 3615 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 XLE Premium USA United States 4 4 Row
275082 153868 971 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 XLE USA United States 4 4 Row
275083 153868 4311 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 TRD Off-Road USA United States 4 4 Row
275084 153868 13 1 4 2020-07-20 14:26:00 Toyota RAV4 2021 Limited USA United States 4 4 Row
279384 153868 3126 2 4 2020-10-20 21:48:00 Toyota RAV4 2021 Hybrid LE CAN Canada 4 4 Row
279385 153868 1399 2 4 2020-10-20 21:48:00 Toyota RAV4 2021 Hybrid Limited CAN Canada 4 4 Row
279386 153868 3127 2 4 2020-10-20 21:48:00 Toyota RAV4 2021 Hybrid XLE CAN Canada 4 4 Row
279387 153868 4983 2 4 2020-10-20 21:48:00 Toyota RAV4 2021 Hybrid XSE CAN Canada 4 4 Row
279388 153868 269 2 4 2020-10-20 21:48:00 Toyota RAV4 2021 LE CAN Canada 4 4 Row
279389 153868 13 2 4 2020-10-20 22:01:00 Toyota RAV4 2021 Limited CAN Canada 4 4 Row
279390 153868 2911 2 4 2020-10-20 22:01:00 Toyota RAV4 2021 Trail CAN Canada 4 4 Row
279391 153868 4311 2 4 2020-10-20 22:01:00 Toyota RAV4 2021 TRD Off-Road CAN Canada 4 4 Row
279392 153868 971 2 4 2020-10-20 22:01:00 Toyota RAV4 2021 XLE CAN Canada 4 4 Row
279393 153868 3615 2 4 2020-10-20 22:01:00 Toyota RAV4 2021 XLE Premium CAN Canada 4 4 Row
279394 153868 3612 1 4 2020-10-20 22:01:00 Toyota RAV4 2021 Hybrid XLE Premium USA United States 4 4 Row
284409 153868 2537 3 4 2021-02-16 22:50:00 Toyota RAV4 2021 Adventure MEX Mexico 4 4 Row
284410 153868 269 3 4 2021-02-16 22:50:00 Toyota RAV4 2021 LE MEX Mexico 4 4 Row
284411 153868 13 3 4 2021-02-16 22:50:00 Toyota RAV4 2021 Limited MEX Mexico 4 4 Row
284412 153868 1399 3 4 2021-02-16 22:50:00 Toyota RAV4 2021 Hybrid Limited MEX Mexico 4 4 Row
284413 153868 971 3 4 2021-02-16 22:50:00 Toyota RAV4 2021 XLE MEX Mexico 4 4 Row