Home Data Automotive Automobiles New Cars + SUVs + Automobiles

33,052 New Cars: Color, Drive, Dealer, Tel. by Make, Model, Year Database

Name	n3a2_edmunds_com
Data	32.89M (+ 0B)
Tables	7 (+ 0)
Columns	40 (+ 0)
Table Rows	71,142 (+ 0)
Media	613.76M (+ 0B)
Files	23,241 (+ 0)
Last Commit	2018-09-13 04:26:28 (+ 34 d)

This is a fields-rich database of 33,052 new cars by 44 makes and 998 models. Each record is comprised of title, exterior color, interior color, dealer, phone name and submodel. The whole new cars database consists of 7 tables.

Data Samples

No samples defined.

Database APIs

No APIs defined.

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
make	44	title	100%
model	998	title	100%
		make_id	100%
		make	100%
model_x_year	3,992	model_id	100%
model_x_year	3,992	year_id	100%
model_x_year_x_new_car	33,052	model_x_year_id	100%
model_x_year_x_new_car	33,052	new_car_id	100%
new_car	33,052	title	100%
		exterior_color	100%
		interior_color	100%
		drive	99.62%
		dealer	100%
		mi_away	100%
		telphone	94.43%
		sellers_comment	57.07%
		submodel	100%
		franchise_id	100%
		zip	100%
		msrp	100%
year	4	title	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

new_car_image

Size (Bytes)	Files
613.76M	23,241

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2018-09-13 (+ 34 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-08-09 (+ 27 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-07-12 (+ 31 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-06-10 (+ 31 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-05-10 (+ 28 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-04-11 (+ 38 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-03-03 (+ 35 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2018-01-27 (+ 29 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2017-12-29 (+ 20 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2017-12-08 (+ 9 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2017-11-28 (+ 19 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2017-11-09 (+ 10 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2017-10-29 (+ 19 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 0B)	23,241 (+ 0)
2017-10-09 (+ 31 d)	32.89M (+ 0B)	7 (+ 0)	40 (+ 0)	71,142 (+ 0)	613.76M (+ 14.84M)	23,241 (+ 579)
2017-09-08	32.89M	7	40	71,142	598.92M	22,662

Download Latest Commit

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

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.