Home Data Automotive Automobiles Used Cars

336,150 Used Cars API: Price, Mileage, Vin, Overview, Image by Year, Make, Model

Name	n3_chennan_car_truecar_com_1
Data	868.86M (+ 0B)
Tables	8 (+ 0)
Columns	43 (+ 0)
Table Rows	2,786,905 (+ 0)
Media	26.90M (+ 0B)
Files	300 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

This is a pre-owned vehicles database of 336,150 used cars from 3,480 years by 609 models of 58 makes (such as Acura, BMW, Ferrari, Honda, Land Rover, Mercedes-Benz, Rolls-Royce, etc.). Each used car is identified by title, price, mileage, location, exterior, interior, vehicle identification number, description, stock number and image url. There are 120,989 overview of these vehicles. The whole used vehicles data set consists of 8 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_chennan/used_car_for_sale_2/ (By Table)

Media Files

used_car_image ^{Bytes: 26.90M / Files: 300}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
make	58	title	100%
model	609	title	100%
		make_id	100%
		make	100%
used_car	336,150	title	100%
		price	100%
		mileage	100%
		location	100%
		interior	76.85%
		exterior	97.01%
		vin	100%
		description	73.18%
		stock_number	77.5%
		image_url	77.53%
used_car_x_vehicle_overview	1,989,468	used_car_id	100%
used_car_x_vehicle_overview	1,989,468	vehicle_overview_id	100%
vehicle_overview	120,989	key	100%
vehicle_overview	120,989	value	100%
year	3,480	title	100%
		model	100%
		model_id	100%
year_x_used_car	336,151	year_id	100%
year_x_used_car	336,151	used_car_id	100%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

used_car_image

Size (Bytes)	Files
26.90M	300

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	868.86M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2023-01-01 (+ 95 d)	868.86M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2022-09-27 (+ 271 d)	868.86M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2021-12-30 (+ 115 d)	868.86M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2021-09-05 (+ 150 d)	868.86M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2021-04-08 (+ 68 d)	868.86M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2021-01-29 (+ 120 d)	868.86M (- 0.09G)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2020-10-01 (+ 38 d)	0.94G (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2020-08-23 (+ 141 d)	0.94G (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2020-04-04 (+ 196 d)	0.94G (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (+ 0B)	300 (+ 0)
2019-09-21 (+ 197 d)	0.94G (- 4.66M)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	26.90M (- 16.46G)	300 (- 186,430)
2019-03-07 (+ 43 d)	0.95G (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2019-01-23 (+ 44 d)	0.95G (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-12-09 (+ 29 d)	0.95G (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-11-09 (+ 27 d)	0.95G (+ 877.12M)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-10-13 (+ 29 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-09-13 (+ 34 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-08-09 (+ 27 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-07-12 (+ 31 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-06-10 (+ 31 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-05-10 (+ 28 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-04-11 (+ 38 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-03-03 (+ 35 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2018-01-27 (+ 29 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 0)	16.48G (+ 0B)	186,730 (+ 0)
2017-12-29 (+ 20 d)	93.03M (+ 0B)	8 (+ 0)	43 (+ 0)	2,786,905 (+ 1,593,839)	16.48G (+ 12.35G)	186,730 (+ 139,865)
2017-12-08	93.03M	8	43	1,193,066	4.13G	46,865

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.