Database
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
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 set. The whole US lawyers' data set consists of 9 tables.
Data Samples (JSON, CSV, XML, Excel):
http://n3.datasn.io/data/api/v1/n3a2/lawyer_1/main/list/
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 |
|
city_order | 104 |
|
city | 23,458 |
|
county | 3,042 |
|
lawyer | 1,086,885 |
|
lawyer_image | 17,357 |
|
practice_area | 476 |
|
lawyer_x_practice_area | 1,789,372 |
|
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
Let us know and we'll see what we can do. Additional fees may apply.