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 dump .sql text file, CSV, MS Excel
• Tables: 4

Buy Now & Download: $139.00 (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: $139.00 (USD)

Potential Applications / Usage:

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

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• 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
• Single Table Format