222,105 US Lawyers List Database (Email, Phone, Website, Zip code)

Database Description:

This attorneys database contains latest list (address, serving locality, phone number, fax, website URL, email and practice areas) of lawyers / attorneys and legal firms in United States.

Each lawyer or legal firm is identified by a state, a local city and a zip code. Each of them has a street address, a telephone number, a fax number, a website URL, an email, and is associated with a number of practice areas.

There are 135,220 unique email addresses, 86,508 unique telephone numbers, 42,492 unique fax numbers and 35,031 unique website URLs.

There are 86 different legal practice areas, 51 states and 6,918 localities that these lawyers are serving.

Database Meta:

• Size: 76.0 MB
• Last updated: Sep. 23rd, 2011
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 5

Buy Now & Download: $189.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• lawyer

  Records:222,105

  The table containing all the lawyers / attorneys records.

  Data fields

  1. id: int(11)
  2. title: varchar(255)
  3. address: varchar(255)
  4. state: varchar(255)
  5. state_id: int(11)
  6. locality: varchar(255)
  7. locality_id: int(11)
  8. zip_code: varchar(255)
  9. telephone: varchar(255)
  10. fax: varchar(255)
  11. website: varchar(255)
  12. email: varchar(255)
  13. specialty_areas: text

• lawyer2practice_area

  Records:491,901

  Lawyer to practice area relationship table. Each lawyer or legal firm relates to multiple practice areas.

  Data fields

  1. id: int(11)
  2. lawyer_id: int(11)
  3. practice_area_id: int(11)

• locality

  Records:6,918

  Local city / town table.

  Data fields

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

• practice_area

  Records:86

  Different legal practice areas lawyers specialize in.

  Data fields

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

• state

  Records:51

  51 states.

  Data fields

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

Buy Now & Download: $189.00 (USD)

Potential Applications / Usage:

• Legal help information site
• Lawyers directory / US attorney search by practice area and locality

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