Lifetime updates. Come back once in a while to stay updated of new versions of this database.

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:

MySQL Database: 222,105 US Lawyers List Database (Email, Phone, Website, Zip code) for Sale

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)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

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

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.