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.
| 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) |
Data Samples
Database APIs
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%
|
| lawyer_id |
100%
|
||
| city | 1,800 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| eduction | 39,975 | title |
99.96%
|
| 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%
|
| eduction_id |
100%
|
||
| lawyer_x_practice_area | 416,576 | lawyer_id |
100%
|
| practice_area_id |
100%
|
||
| lawyer_x_professional_experience | 39,725 | lawyer_id |
100%
|
| 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.
