US Lawyers & Attorneys

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

Data Structure

lawyer [222,105]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ address (100%)
varchar(255)
+ state (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ locality (100%)
bigint(20) unsigned
+ locality_id (100%)
varchar(255)
+ zip_code (100%)
varchar(255)
+ telephone (100%)
varchar(255)
+ fax (73.2%)
varchar(255)
+ website (64.5%)
varchar(255)
+ email (67.2%)
text
+ specialty_areas (100%)
lawyer2practice_area [491,901]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ lawyer_id (100%)
bigint(20) unsigned
+ practice_area_id (100%)
locality [6,918]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ state_id (100%)
varchar(255)
+ title (100%)
practice_area [86]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
state [51]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)

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.

Data Profile

Size 142.84M
Tables 5
Last Commit 2016-12-07 00:27:08

Updates / Commits

Time Size Tables Columns Rows
2016-12-07 00:27:08 142.84M 5 28 721061
2016-08-31 03:09:51 142.84M 5 28 721061

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
lawyer 222,105 .001 222.105
lawyer2practice_area 491,901 .001 491.901
locality 6,918 .001 6.918
practice_area 86 .001 0.086
state 51 .001 0.051
Total Credits 721.061 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.