Home Data Professional Services Lawyers / Attorneys

US 131,311 Lawyers API: Phone, Address, Lat, Lon, Education

Name	n3_chennan_lawyer_justia_com
Data	300.80M (+ 0B)
Tables	11 (+ 0)
Columns	57 (+ 0)
Table Rows	2,099,312 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

This lawyers database is rich in tables and fields. It has a total of 131,311 attorneys over 37,800 areas from 1,800 popular cities of 51 states in America. In table lawyer, there are title, phone number, latitude, street address, locality region, postal code, longitude, etc in each record. This America lawyers data also contians 39,975 education records, practice area with 55 records and professional experience with 14,857 records. The whole United States attorneys data set has 11 tables.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_chennan/lawyers_in_us_3/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
area	37,800	title	100%
		city_id	100%
		city	100%
area_x_lawyer	1,287,736	area_id	100%
area_x_lawyer	1,287,736	lawyer_id	100%
city	1,800	title	100%
		state_id	100%
		state	100%
eduction	39,975	title	99.96%
eduction	39,975	value	93.51%
lawyer	131,311	title	100%
		phone	95%
		latitude	99.99%
		street_address	99.7%
		locality	99.97%
		region	99.9%
		postal_code	99.71%
		longitude	99.71%
		languages	22.18%
lawyer_x_eduction	129,426	lawyer_id	100%
lawyer_x_eduction	129,426	eduction_id	100%
lawyer_x_practice_area	416,576	lawyer_id	100%
lawyer_x_practice_area	416,576	practice_area_id	100%
lawyer_x_professional_experience	39,725	lawyer_id	100%
lawyer_x_professional_experience	39,725	professional_experience_id	100%
practice_area	55	value	100%
professional_experience	14,857	value	99.99%
state	51	title	100%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

No media sets.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	300.80M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	300.80M (+ 118.86M)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	181.94M (+ 0B)	11 (+ 0)	57 (+ 0)	2,099,312 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03	181.94M	11	57	2,099,312	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.