This is a yellow pages data set of Europe having 664,271 company records from 228 countries. Each record is comprised of post code, street name, countrycode, registered office, year established, headcount, description, type, country, city, company and url.
These companies are classified into 42,415 categories by 9 types (Service Provid, other, Multi-Category, Agent/ Representative, Distributor, Manufacturer/ Producer, Wholesaler, Retailer and Subcontractor). Apart from this, there are 962,564 company phone numbers and 143,415 key words of these companies.
The whole Europe yellow pages database totaly has 9 tables.
| Name | n3_lyz_europages |
|---|---|
| Data | 1.21G (+ 919.98M) |
| Tables | 9 (+ 1) |
| Columns | 51 (+ 10) |
| Table Rows | 6,522,791 (+ 1,249,558) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| letter | 27 | letter |
100%
|
| type | 9 | type |
100%
|
| total |
100%
|
||
| company | 664,271 | post_code |
99.17%
|
| street_name |
99.52%
|
||
| countrycode |
99.95%
|
||
| registered_office |
3.33%
|
||
| year_established |
12.54%
|
||
| headcount |
43.2%
|
||
| description |
57.08%
|
||
| type |
56.27%
|
||
| country |
99.95%
|
||
| city |
99.93%
|
||
| company |
100%
|
||
| url |
67.54%
|
||
| category_x_company | 3,590,187 | company_id |
100%
|
| category_id |
100%
|
||
| category | 42,415 | category |
100%
|
| country | 228 | total |
100%
|
| country |
99.56%
|
||
| country_code |
99.56%
|
||
| key_word | 143,415 | key_word |
100%
|
| company_x_key_word | 1,119,675 | key_word_id |
100%
|
| company_id |
100%
|
||
| company_phone | 962,564 | company_id |
100%
|
| phone |
100%
|
||
| type |
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.
