This is a fields-rich lawyers database with 14,493 best lawyers from 63 countries. Each record is comprised of title, last name, recognized since, headquarters and etc. All these lawyers are offered 1,216 practice areas of these countries. In the lawyers database, there are other 6 related tables of these lawyers, they are lawyer additional information with 4,539 records, lawyer admissions with 2,277 records, 15,812 lawyer affiliations with content in each, lawyer award list with 14,186 records, 13,242 lawyer education records with content in each and 2,415 lawyer firm detail with headquarters in each. The whole lawyers database consists of 19 tables.
| Name | n3zm_Lawyer_bestlawyers_com |
|---|---|
| Data | 79.72M (+ 0B) |
| Tables | 19 (+ 0) |
| Columns | 87 (+ 0) |
| Table Rows | 211,291 (+ 0) |
| Media | 28.92M (+ 0B) |
| Files | 988 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| country | 63 | title |
100%
|
| lawyer | 14,493 | title |
99.96%
|
| last_name |
99.99%
|
||
| description |
54.49%
|
||
| title_wb |
96.32%
|
||
| title_wb_slug |
96.32%
|
||
| recognized_since |
100%
|
||
| recognized_in |
100%
|
||
| law_school |
55.48%
|
||
| languages |
17.28%
|
||
| lawyer_page |
99.83%
|
||
| direct_dial |
16.41%
|
||
| e_mail |
21.42%
|
||
| headquarters |
99.5%
|
||
| lawyer_bio |
62.3%
|
||
| recognized_in_the_best_lawyers |
53.2%
|
||
| lawyer_additional_information | 4,539 | key |
100%
|
| value |
100%
|
||
| lawyer_admissions | 2,277 | key |
100%
|
| value |
100%
|
||
| lawyer_affiliations | 15,812 | content |
100%
|
| lawyer_award_list | 14,186 | key |
100%
|
| value |
99.99%
|
||
| lawyer_education | 13,242 | content |
100%
|
| lawyer_firm_detail | 2,415 | title |
100%
|
| headquarters |
86.05%
|
||
| lawyer_image | 14,492 | lawyer_id |
0%
|
| lawyer_x_lawyer_additional_information | 6,196 | lawyer_id |
100%
|
| lawyer_additional_information_id |
100%
|
||
| lawyer_x_lawyer_admissions | 5,069 | lawyer_id |
100%
|
| lawyer_admissions_id |
100%
|
||
| lawyer_x_lawyer_affiliations | 24,137 | lawyer_id |
100%
|
| lawyer_affiliations_id |
100%
|
||
| lawyer_x_lawyer_award_list | 24,311 | lawyer_id |
100%
|
| lawyer_award_list_id |
100%
|
||
| lawyer_x_lawyer_education | 16,412 | lawyer_id |
100%
|
| lawyer_education_id |
100%
|
||
| lawyer_x_lawyer_firm_detail | 14,502 | lawyer_id |
100%
|
| lawyer_firm_detail_id |
100%
|
||
| lawyer_x_lawyer_image | 14,503 | lawyer_id |
100%
|
| lawyer_image_id |
100%
|
||
| practice_area | 1,216 | title |
100%
|
| country_id |
100%
|
||
| country |
100%
|
||
| practice_area_x_lawyer | 23,426 | practice_area_id |
100%
|
| lawyer_id |
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
LAWYER_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 28.92M | 988 |
