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

Database 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.

Database Meta:

• Size: 6.4 MB
• Last updated: Apr. 5th, 2011
• Formats Included: MySQL 5 SQL dump text file, CSV, MS Excel
• Tables: 4

Buy Now & Download: $89.95 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• city

  Records:5,628

  All the major cities / counties that these auto dealers are near.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. state_abbreviation: varchar(255)

• dealer

  Records:34,073

  Table containing all the car dealers and their contact information, categorized by state, city and make.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. address: varchar(255)
  4. zip_code: char(5)
  5. phone: varchar(255)
  6. make_slug: varchar(20)
  7. city: varchar(30)
  8. state_abbreviation: char(2)

• make

  Records:34

  Auto makes table.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. slug: varchar(255)

• state

  Records:51

  All US states.

  Data fields

  1. id: int(11)
  2. abbreviation: varchar(255)
  3. title: varchar(255)

Buy Now & Download: $89.95 (USD)

Prospective Applications / Implementations:

• Auto car dealers search engine / directory
• New & used auto dealership directory
• Online portal or community of potential customers / auto fans
• ...Order a custom build

Other Available Formats:

After purchase, please contact us for any of the specific data formats listed below and we will send it right away.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database (Extra $175)
• Single Table Format (Extra $100)