In the lawyers database, there are 1,086,885 records from 23,458 cities over 3,042 counties of 51 states in America. Each lawyer has title, rating, get license date, city and etc. There are 476 practice areas for these US lawyers in this data. The whole US lawyers data set consists of 9 tables.
| Name | n3a2_avvo_com |
|---|---|
| Data | 473.03M (+ 0B) |
| Tables | 9 (+ 0) |
| Columns | 45 (+ 0) |
| Table Rows | 2,903,388 (+ 0) |
| Media | 68.37M (+ 0B) |
| Files | 17,357 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 23,458 | title |
100%
|
| city_order_id |
100%
|
||
| city_order | 104 | title |
100%
|
| state_id |
100%
|
||
| county | 3,042 | title |
100%
|
| state_id |
100%
|
||
| lawyer | 1,086,885 | title |
100%
|
| rating |
83.63%
|
||
| get_license_date |
99.83%
|
||
| tellphone |
1.98%
|
||
| website |
0%
|
||
| city_id |
100%
|
||
| lawyer_x_practice_area | 1,789,372 | lawyer_id |
100%
|
| practice_area_id |
100%
|
||
| practice_area | 476 | title |
100%
|
| 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
LAWYER_IMAGE
| Size (Bytes) | Files |
|---|---|
| 68.37M | 17,357 |
