Usage & Publication License: database price dollar sign119.00

US 1M Lawyers Data: Title, Rating, Telephone, Practice Area, Images

US 1,086,885 lawyers & 476 practice areas database: title, rating, telephone, practice area, images

database structure screenshot of US 1M Lawyers Data: Title, Rating, Telephone, Practice Area, Images

Description: In the lawyers database, there are 1,086,885 records from 23,458 cities over 3,042 counties of 51 states in America. Each lawyer has a title, rating, get license date, city and etc. There are 476 practice areas for these US lawyers in this data. The whole US lawyers' data set consists of 9 tables.

Data Samples (JSON, CSV, Excel):
http://n3.datasn.io/data/api/v1/n3a2/lawyer_1/main/list/

Related DBs:

Database Statistics

  • Size: 473.03 MB
  • Tables: 8
  • Records: 1,086,885
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Images Statistics

  • Images: 8.68K
  • Dimensions: 100x 150 on average
  • Image formats: JPEG
  • Images count: 17357
  • Reference field: image_name_field

Database Structure

Table Records Fields
state 51
  1. id
  2. ts
  3. title
city_order 104
  1. id
  2. ts
  3. title
city 23,458
  1. id
  2. ts
  3. title
county 3,042
  1. id
  2. ts
  3. title
lawyer 1,086,885
  1. id
  2. ts
  3. title
  4. rating
  5. get_license_date
  6. tellphone
  7. website
lawyer_image 17,357
  1. id
  2. ts
  3. source_content_type
  4. hash_file_content
  5. size
  6. path
  7. title
  8. access
practice_area 476
  1. id
  2. ts
  3. title
lawyer_x_practice_area 1,789,372
  1. id
  2. ts

Database Attachments

Images: This database is attached with 17357 images. See them under the Attachments tab.


Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

city

  • Abbeville
  • Abernant
  • Adamsville
  • Addison
  • Adger
  • Alabaster
  • Alberta
  • Albertville
  • Alexander City
  • Alexandria
  • Aliceville
  • Allgood
  • Alpine
  • Alton
  • Altoona
  • Andalusia
  • Anniston
  • Arab
  • Ardmore
  • Ariton
  • Arley
  • Ashford
  • Ashland
  • Ashville
  • Athens
  • Atmore
  • Attalla
  • Auburn
  • Auburn University
  • Axis
  • Banks
  • Bay Minette
  • Bayou La Batre
  • Bellamy
  • Belle Mina
  • Benton
  • Bessemer
  • Billingsley
  • Birmingham
  • Black
  • Blountsville
  • Blue Mountain
  • Bluff Park
  • Boaz
  • Boligee
  • Bon Air
  • Bon Secour
  • Booth
  • Boykin
  • Brantley
  • Bremen
  • Brent
  • Brewton
  • Bridgeport
  • Brierfield
  • Brooklyn
  • Brookside
  • Brookwood
  • Brownsboro
  • Brundidge
  • Burnwell
  • Butler
  • Bynum
  • Cahaba Heights
  • Calera
  • Calvert
  • Camden
  • Camp Hill
  • Capshaw
  • Carbon Hill
  • Cardiff
  • Carrollton
  • Castleberry
  • Catherine
  • Cecil
  • Cedar Bluff
  • Center Point
  • Centre
  • Centreville
  • Chancellor
  • Chapman
  • Chatom
  • Chelsea
  • Cherokee
  • Chickasaw
  • Childersburg
  • Choccolocco
  • Clanton
  • Clay
  • Clayton
  • Cleveland
  • Clinton
  • Coaling
  • Coden
  • Coffee Springs
  • Coker
  • Collinsville
  • Columbiana
  • Cook Springs
  • Coosa Pines

practice_area

  • Business
  • General Practice
  • Limited Liability Company (LLC)
  • Contracts & Agreements
  • Intellectual Property
  • Criminal Defense
  • DUI & DWI
  • Family
  • Personal Injury
  • Domestic Violence
  • Litigation
  • Divorce & Separation
  • Immigration
  • Car Accidents
  • Appeals
  • Civil Rights
  • Employment & Labor
  • Estate Planning
  • Probate
  • Administrative Law
  • Wills & Living Wills
  • Power Of Attorney
  • Trusts
  • Social Security
  • Bankruptcy & Debt
  • Lawsuits & Disputes
  • Child Custody
  • Child Support
  • Elder Law
  • Guardianship
  • Medicaid & Medicare
  • Adoption
  • Real Estate
  • Employee Benefits
  • Workers Compensation
  • Speeding & Traffic Ticket
  • Juvenile
  • Wrongful Death
  • Defective and Dangerous Products
  • Trucking Accident
  • Government
  • State, Local And Municipal Law
  • Trademark Application
  • Land Use & Zoning
  • Insurance
  • Consumer Protection
  • Corporate & Incorporation
  • Transportation
  • Construction & Development
  • Education
  • Commercial
  • Environmental and Natural Resources
  • Arbitration
  • Tax
  • Expungement
  • Trademark Infringement
  • Foreclosure
  • Debt Collection
  • Chapter 7 Bankruptcy
  • Uncontested Divorce
  • Chapter 13 Bankruptcy
  • Insurance Fraud
  • Mediation
  • Military Law
  • Ethics & Professional Responsibility
  • Landlord & Tenant
  • Credit Repair
  • Asylum
  • Admiralty & Maritime
  • Motorcycle Accident
  • Class Action
  • Medical Malpractice
  • Banking
  • Aviation
  • Federal Crime
  • Financial Markets and Services
  • International Law
  • Child Abuse
  • Health Care
  • Marriage & Prenuptials
  • Alimony
  • Mergers & Acquisitions
  • Energy & Utilities
  • Securities Offerings
  • White Collar Crime
  • Oil & Gas
  • Public Finance & Tax Exempt Finance
  • Equipment Finance and Leasing
  • Nursing Home Abuse and Neglect
  • Election Campaigns & Political Law
  • Antitrust & Trade Law
  • Health Insurance
  • Discrimination
  • Securities & Investment Fraud
  • Constitutional
  • Telecommunications
  • Life Sciences & Biotechnology
  • Mesothelioma & Asbestos
  • Sex Crime
  • Spinal Cord Injury

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: [email protected]UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. What prints, printer or milk?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.