Car Dealers (US)

Auto Car Dealers of United States by Make, State, City, Phone, Address

Data Structure

city [5,628]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ state_abbreviation (100%)
bigint(20) unsigned
+ state_id (100%)
dealer [34,073]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address (100%)
char(5)
+ zip_code (100%)
varchar(255)
+ phone (100%)
varchar(20)
+ make_slug (100%)
bigint(20) unsigned
+ make_id (100%)
varchar(30)
+ city (100%)
bigint(20) unsigned
+ city_id (100%)
char(2)
+ state_abbreviation (100%)
bigint(20) unsigned
+ state_id (100%)
make [34]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ abbreviation (100%)
varchar(255)
+ title (100%)

Description

This is the complete list / database of US auto dealers with 34,073 dealer records and 24,590 unique phone numbers. Each and every car dealer is categorized by make, city and state. All of the auto dealers have a phone number, store address and zip code.

Data Profile

Size 23.06M
Tables 4
Last Commit 2016-12-07 00:28:26

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:28:26 23.06M 4 25 39786
2016-08-29 04:31:09 23.06M 4 25 39786
2016-08-26 02:54:41 16.86M 4 25 39786

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 5,628 .001 5.628
dealer 34,073 .001 34.073
make 34 .001 0.034
state 51 .001 0.051
Total Credits 39.786 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.