This is a comprehensive global golf courses database having 21,179 records of 10.3K cities from 17 regions. Each record is comprised of address, description, holes, par, length, policies, rental service, practice instruction, ratings count, recommended count, overall rating, facilities condition rating, value money rating, pace of play rating, staff friendliness rating, course conditions rating, course layout rating, course difficulty rating, recommended percentage, secondary ratings, slope, rating, year built, season, architect, greens and fairways.
Apart from this, there are 82,365 golf course tee records with tee, slope, golf course, par, length and rating in each, and there are 88,552 files of these golf course pictures in the 3.06G media set.
The whole world golf courses database contains 8 tables.
| Name | n3_lyz_golfnow.com/course_directory |
|---|---|
| Data | 74.44M (- 42.78M) |
| Tables | 8 (- 11) |
| Columns | 64 (- 60) |
| Table Rows | 228,457 (- 317,827) |
| Media | 3.06G (+ 2.50G) |
| Files | 88,552 (+ 70,602) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| golf_course | 21,179 | golf_course |
100%
|
| address |
100%
|
||
| description |
99.75%
|
||
| holes |
82.95%
|
||
| par |
79.88%
|
||
| length |
78.76%
|
||
| policies |
93.72%
|
||
| rental_service |
92.65%
|
||
| practice_instruction |
93.87%
|
||
| ratings_count |
98.81%
|
||
| recommended_count |
98.81%
|
||
| overall_rating |
98.81%
|
||
| facilities_condition_rating |
98.81%
|
||
| value_money_rating |
98.81%
|
||
| pace_of_play_rating |
98.81%
|
||
| staff_friendliness_rating |
98.81%
|
||
| course_conditions_rating |
98.81%
|
||
| course_layout_rating |
98.81%
|
||
| course_difficulty_rating |
98.81%
|
||
| recommended_percentage |
98.81%
|
||
| secondary_ratings |
98.81%
|
||
| slope |
56.97%
|
||
| rating |
57.59%
|
||
| year_built |
94.28%
|
||
| season |
82.49%
|
||
| architect |
62.98%
|
||
| greens |
37.96%
|
||
| fairways |
31.15%
|
||
| golf_course_tee | 82,365 | tee |
100%
|
| slope |
99.58%
|
||
| golf_course_id |
100%
|
||
| par |
100%
|
||
| length |
100%
|
||
| rating |
99.61%
|
||
| img_slug | 93,140 | golf_course_id |
100%
|
| region | 17 | region |
100%
|
| total_golf_course |
100%
|
||
| region_2 | 212 | region |
100%
|
| region_1 |
100%
|
||
| region_3 | 10,365 | region |
100%
|
| region_1 |
100%
|
||
| region_2 |
100%
|
||
| region_3_x_golf_course | 21,179 | golf_course_id |
100%
|
| region_3_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
GOLF_COURSE_PICTURE
| Size (Bytes) | Files |
|---|---|
| 3.06G | 88,552 |
