DATA FEEDS
Historical Vehicles Feed
DATA FEEDS
Historical Vehicles Feed – Data Dictionary
| Field | Format | Length | Source | Description | Sample | Available Since |
| id | string | 64 | MC Generated | This is a GUID and unique in the feed. In History feed VIN number is prefixed | 8f5f3b11-4e34 | Jan 15 |
| vin | string | 17 | MC Scraped | 17 char long VIN of the car | JTEBU14R760085015 | Jan 15 |
| heading | string | 256 | MC Scraped | The car heading as listed on the inventory page of the dealer website | Pre-Owned 2016 Chevrolet Spark 1LT | Jan 15 |
| more_info | string | 1024 | MC Scraped | The listing details page url | https://www.bayerchevy.com/inventory/used-2016-ford-expedition-xlt-suv-1fmju1ht5gef20569/ | Jan 15 |
| price | number | 12 | MC Scraped | The car price as listed on the website | 12988 | Jan 15 |
| msrp | number | 12 | MC Scraped | The car retail price as listed on the website | 11550 | Jan 15 |
| miles | number | 12 | MC Scraped | The car miles/odometer as listed on the website | 121861 | Jan 15 |
| stock_no | string | 32 | MC Scraped | Stock number of the car listed on the website | PV4710 | Jan 15 |
| year | number | 4 | VIN Decoder | Model Year of the car (VIN Decoded) | 2020 | Jan 15 |
| make | string | 32 | VIN Decoder | Make of the car (VIN Decoded) | Nissan | Jan 15 |
| model | string | 256 | VIN Decoder | Model of the car (VIN Decoded) | Sentra | Jan 15 |
| trim | string | 256 | VIN Decoder | Trim of the car (VIN Decoded) | SV | Jan 15 |
| vehicle_type | string | 64 | VIN Decoder | Vehicle type of the car (VIN Decoded) | Car | Jan 15 |
| body_type | string | 64 | VIN Decoder | Body type of the car (VIN Decoded) | Sedan | Jan 15 |
| body_subtype | string | 64 | VIN Decoder | Body subtype of the car (VIN Decoded) | Crew | Jan 15 |
| drivetrain | string | 64 | VIN Decoder | Drivetrain of the car (VIN Decoded) | 4WD | Jan 15 |
| fuel_type | string | 64 | VIN Decoder | Fuel type of the car (VIN Decoded) | Premium Unleaded | Jan 15 |
| engine | string | 64 | VIN Decoder | Engine of the car (VIN Decoded) | 3.8L V6 | Jan 15 |
| engine_block | string | 8 | VIN Decoder | Engine block of the car (VIN Decoded) | V | Jan 15 |
| engine_size | string | 16 | VIN Decoder | Engine size of the car (VIN Decoded) | 3.8 | Jan 15 |
| transmission | string | 32 | VIN Decoder | Transmission of the car (VIN Decoded) | Automatic | Jan 15 |
| doors | number | 5 | VIN Decoder | Doors of the car (VIN Decoded) | 5 | Jan 15 |
| cylinders | string | 5 | VIN Decoder | Cylinders of the car (VIN Decoded) | 8 | Jan 15 |
| city_mpg | number | 8 | VIN Decoder | City miles per gallon (VIN Decoded) | 13 | Jan 15 |
| highway_mpg | number | 8 | VIN Decoder | Highway miles per gallon (VIN Decoded) | 34 | Jan 15 |
| interior_color | string | 64 | MC Scraped | This field provides details on interior color and in some cases it provides color with some extra information like Jet Black, Perforated leather-appointed front outboard seat trim , Very Dark Atmosphere, Leather-appointed front outboard seat trim | Jet Black | Jan 15 |
| exterior_color | string | 64 | MC Scraped | This field provides details on exterior color and in some cases it provides color with some extra information like Supersonic Red/Midnight Black Metallic Roof [extra_cost_color] , Ext. / Int. Mosaic Black Metallic / Jet Black With Red Accents | Mosaic Black Metallic | Jan 15 |
| base_exterior_color | string | 64 | MC Calculated | Basic normalised color calculated from exterior color. E.g. Metallic black exterior is saved as Black in this field. Possible values in this field are Gray, Green, Gold, Blue, Brown, Purple, Red, Black, White, Pink, Orange, Yellow, Silver and Beige | Silver | Jan 18 |
| base_interior_color | string | 64 | MC Calculated | Basic normalised color calculated from interior color. E.g. Metallic black interior is saved as Black in this field Possible values in this field are Gray, Green, Gold, Blue, Brown, Purple, Red, Black, White, Pink, Orange, Yellow, Silver and Beige | Green | Jan 18 |
| is_certified | number | 5 | MC Scraped | Flag indicating whether its a certified car. The flag is set to 1 when we find the keyword “certified” somewhere in the listings heading or it’s description. We set this flag 0 otherwise. 1 indicates its a certified car 0 indicates its not a certified car | 1 | Jan 15 |
| is_transfer | number | 5 | MC Scraped | This field is populated only when the dealer location differs from the car location. The flag is set to 1 when we find the keyword “transfer” somewhere in the listings description. We set this flag 0 otherwise. 1 indicates transfer option is available on the car 0 indicates transfer option is not available on this car | 0 | April 18 |
| taxonomy_vin | string | 10 | MC Calculated | This is a squish VIN obtained from 17 character VIN by selecting first 8 letters appended with 10th and 11th character | 1N4AZ1CPKC | Jan 15 |
| model_code | string | 24 | MC Scraped | Model code of the car listed on the website | WKJS74 | April 18 |
| *scraped_at | timestamp | 32 | MC Calculated | This is the time when the listing was scraped for the first time. This value is retained even if the listing has an update in the subsequent scraping cycles. The time period between scraped_at and status_date is the duration for which the source website has not done any significant (+-10%) change in either price or miles. Please use the reference links given at the bottom of this table for more information. | 2023-06-06T18:24:23Z | Jan 15 |
| *status_date | timestamp | 32 | MC Calculated | The last seen at time. Please use the reference links given at the bottom of this table for more information. | 2023-06-12T14:36:20Z | Jan 15 |
| *first_scraped_at | timestamp | 32 | MC Calculated | This time is the oldest scraped_at date for the car with respect to the MarketCheck historical database. This is a Car or VIN Level attribute and hence will only be elevated to and made available with the most recent listing of the car. For a car which was introduced in MarketCheck database for the very first time and is still active, this field has a null value. | 2022-09-29T08:45:51Z | Jan 15 |
| dealer_id | number | 32 | MC Generated | MarketCheck Dealer id | 10020326 | Jan 15 |
| source | string | 256 | MC Scraped | Website domain | driveway.com | Jan 15 |
| seller_name | string | 512 | MC Scraped | Dealer Name | driveway | Jan 15 |
| street | string | 512 | MC Scraped | Dealer location fields | 2175 Nw Raleigh St | Jan 15 |
| city | string | 128 | MC Scraped | Portland | Jan 15 | |
| state | string | 128 | MC Scraped | OR | Jan 15 | |
| zip | string | 10 | MC Scraped | 97210 | Jan 15 | |
| latitude | decimal number | 8 | MC Calculated | 45.534234 | Jan 15 | |
| longitude | decimal number | 8 | MC Calculated | -122.696261 | Jan 15 | |
| country | string | 2 | MC Scraped | US | Jan 16 | |
| seller_phone | string | 256 | MC Scraped | Comma separated list of phone numbers of the dealer | 718-526-8140 | Jan 15 |
| seller_email | string | 256 | MC Scraped | Email of the dealer | rfelicetti@piazzaacura.com | Jan 15 |
| seller_type | string | 32 | MC Calculated | It takes any one of these values dealer / fsbo / auction, same as that of listing_type | dealer | Jan 15 |
| listing_type | string | 32 | MC Calculated | It takes any one of these values dealer / fsbo / auction, same as that of seller_type | dealer | Jan 15 |
| inventory_type | string | 16 | MC Calculated | It takes any one of these values used / new | used | Jan 15 |
| dealer_type | string | 32 | MC Calculated | It takes any one of these values franchise / independent | franchise | Aug 18 |
| car_seller_name | string | 512 | MC Scraped | Name of the dealer who has the Car available in his lot | Piazza Honda of Reading | Jan 16 |
| car_address | string | 512 | MC Scraped | Car location fields – these will be populated only when the dealer location differs from the car location. This may mean the dealer has a transfer option for the car. | Reading PA 19607 | Jan 16 |
| car_street | string | 512 | MC Scraped | 703 W Division | Jan 16 | |
| car_city | string | 128 | MC Scraped | Arlington | Jan 16 | |
| car_state | string | 128 | MC Scraped | TX | Jan 16 | |
| car_zip | string | 128 | MC Scraped | 76012 | Jan 16 | |
| car_latitude | decimal number | 11 | MC Calculated | 32.756604 | Jan 16 | |
| car_longitude | decimal number | 11 | MC Calculated | -97.135837 | Jan 16 | |
| seller_comments | string | variable length text | MC Scraped | Dealer comments as listed on details page | Awards: * 2012 IIHS Top Safety PickReviews: * If you covet a nicely detailed mid-size all-American convertible that can comfortably seat four adults with usable room in the trunk | Jan 15 |
| options | string | variable length text | MC Scraped | Pipe separated list of options found on details page | ABS Brakes|Adjustable Foot Pedals|Air Conditioning | Jan 15 |
| features | string | variable length text | MC Scraped | Pipe separated list of features found on details page | Air filtration|Front air conditioning|Front air conditioning zones | Jan 15 |
| photo_links | string | variable length text | MC Scraped | Pipe separated list of photo links found on details page of the car | https://pictures.dealer.com/p/piazzahondaread/0514/20567771cf27f57e48fbc060385d00d5x.jpg|https://pictures.dealer.com/p/piazzahondaread/0303/9085aba54389bc0657d11cc042f135acx.jpg | Jan 15 |
| photo_url | string | 1024 | MC Scraped | Main photo url found on details page of the car | https://pictures.dealer.com/p/piazzahondaread/0514/20567771cf27f57e48fbc060385d00d5x.jpg | Jan 15 |
| **dom | number | 5 | MC Calculated | The total days on market of the car. The DOM of a car is a sum of all days the car is reported online by all its online sources (i.e. the combined period between scraped_at and status_date) with the overlapping periods considered only ones. Please use the reference links given at the bottom of this table for more information. | 430 | Jan 15 |
| **dom_180 | number | 5 | MC Calculated | The sum of the days on market of the Car considering only the last 6 months. Please use the reference links given at the bottom of this table for more information. | 430 | Jan 18 |
| **dom_active | number | 5 | MC Calculated | The sum of the days on market of the Car considering only the last 30 days period. Please use the reference links given at the bottom of this table for more information. | 430 | Jan 18 |
| currency_indicator | string | 32 | MC Calculated | Currency unit. It is USD for US listings and CAD for Canadian listings | USD | March 18 |
| miles_indicator | string | 32 | MC Calculated | Mileage unit. It is MILES for US listings and KILOMETERS for Canadian listings | MILES | March 18 |
| carfax_1_owner | number | 5 | MC Scraped | Flag indicating whether the listings has a Carfax one owner flag. The flag is set to 1 when we find the keyword “carfax one owner” somewhere in the listings description. We set this flag 0 otherwise. 1 indicates the listings has a Carfax one owner flag 0 indicates the listings does not highligths a Carfax one owner flag | 1 | April 18 |
| carfax_clean_title | number | 5 | MC Scraped | Flag indicating whether the listings has a Carfax clean title flag. The flag is set to 1 when we find the keyword “carfax clean title” somewhere in the listings description. We set this flag 0 otherwise. 1 indicates the listings has a Carfax clean title flag 0 indicates the listings does not highligths a Carfax clean title flag | 1 | April 18 |
| loan_term | number | 5 | MC Scraped | Car finance term in months as listed on details page | 3 | May 18 |
| loan_apr | decimal number | 5 | MC Scraped | Car finance annual percentage rate value as listed on details page | 4.95 | May 18 |
| l_down_pay | number | 5 | MC Scraped | Car lease down payment value as listed on details page | 2500 | May 18 |
| l_emi | number | 5 | MC Scraped | Car lease monthly payment value as listed on details page | 1308 | May 18 |
| f_down_pay | decimal number | 8 | MC Scraped | Car finance down payment value as listed on details page | 1356 | May 18 |
| f_down_pay_per | number | 5 | MC Scraped | Car finance down payment value in percentage as listed on details page | 20 | May 18 |
| f_emi | number | 5 | MC Scraped | Car finance monthly payment value as listed on details page | 308 | May 18 |
| lease_term | number | 5 | MC Scraped | Car lease term value per month as listed on details page | May 18 | |
| in_transit | number | 1 | MC Scraped | Flag indicating whether it’s a in_transit car. The flag is set to 1 when we find the keyword “in_transit” (and all its close variants like “in-transit”, “in transit” etc) somewhere in the listings heading or it’s description. We set this flag 0 otherwise. 1 indicates its a in_transit car 0 indicates its not a in_transit car | 1 | January 22 |
| in_transit_at | timestamp | 32 | MC Calculated | This is a timestamp. It will indicate since when the particular VIN is in transit for that specific source | 2023-05-25T14:43:04Z | January 22 |
| in_transit_days | number | 5 | MC Calculated | This field contains the no. of days the listing/VIN is in transit on that source | 67 | January 22 |
| is_searchable | NA | 1 | MC Calculated | Flag will give the dealership listing where the vehicle is physically located identified by our differred attibution logic. 1 indicates car physically available at that current dealership 0 indicates car physically not available at that current dealership | 1 | May 18 |
| delivery_date | NA | 10 | MC Calculated | Snapshot date only available on Snowflake Platform. Using current date while appending daily active inventory data in the Snowflake table | Sept 21 |
* References that explain various date fields:
PPT – https://storage.googleapis.com/marketcheck-sample-feeds/dates_in_mc_feed.pptx
Medium Link – https://medium.com/marketcheck-apis/marketcheck-api-listing-dates-explained-ec67477ee800
** Reference that explains DOM fields and how those are calculated:
PPT – https://storage.googleapis.com/marketcheck-sample-feeds/Days_on_Market(DOM).pptx
** Reference that explains vehicle attribution logic:
Text File – https://storage.googleapis.com/marketcheck-sample-feeds/vehicle_attribution_logic.txt
** Reference that explains use of Cloud Translation for non-english websites (mostly canadian sites) having primary language as Spanish or French:
Reference Link – powered by Google Translate
** Non-availability of the field value is represented by an empty string or a “null” string.
AUTOMOTIVE DATA
Historical Vehicles Data Feed
We process every dealership listing in the US, Canada, and the UK daily, capturing data from auctions and private sellers as well. This allows us to cover 98% of all automotive retail market activity, with 20 million listings updated from over 70,000 dealerships each day. This gives us the most comprehensive view of historical automotive retail trends.
We collect detailed information, including VIN, price, mileage, days on market, dealer details, and vehicle images, ensuring each VIN is linked to the correct dealership while removing duplicates. Our data includes precise timestamps and specific build details like trim and features.
MarketCheck’s platform also offers normalized values, enabling easy comparison across brands and feature-based searches. Our flexible, use-case agnostic data is available via API, full data feeds, or custom widgets, ensuring seamless access however you need it.
CONTACT US
We want to hear from you
Whether it’s questions about how we can best serve your business or if you want to learn more, get in touch! Emails are usually answered the same day they’re sent.
