US Lawyers

Lawyers Database in United States

Data Structure

city [23,458]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ yf_slug (100%)
bigint(20) unsigned
+ city_order_id (100%)
city_order [104]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ yf_slug (100%)
bigint(20) unsigned
+ state_id (100%)
lawyer [1,086,885]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ yf_slug (100%)
varchar(255)
+ get_license_date (99.8%)
varchar(255)
+ tellphone (2%)
varchar(255)
+ website (0%)
bigint(20) unsigned
+ city_id (100%)
lawyer_x_practice_area [1,789,372]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ lawyer_id (100%)
bigint(20) unsigned
+ practice_area_id (100%)
practice_area [476]
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%)
varchar(255)
+ yf_slug (100%)

Description

This attorneys database contains the latest edition (the data of license, phone number, website and location) of attorneys in United States.  It's current the most comprehensive lawyers database you can find on the web. This is consists of great lawyers from different fields such as business, family, car accidents, civil rigts, elder law etc.

Data Profile

Size 503.47M
Tables 6
Last Commit 2017-02-17 04:13:59

Updates / Commits

Time Size Tables Columns Rows
2017-02-17 04:13:59 503.47M 6 29 2900346

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 23,458 .001 23.458
city_order 104 .001 0.104
lawyer 1,086,885 .001 1086.885
lawyer_x_practice_area 1,789,372 .001 1789.372
practice_area 476 .001 0.476
state 51 .001 0.051
Total Credits 2900.346 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.