This is a golf courses database with 861 records from 585 regions. Each record has information, description, awards, establish, location, classification, phone number, fax number, email address, website, etc. All these golf courses are categorized into 4 classifications (featured, pga tour, top courses and top architects) and further into 11 categories, such as pete dye, A.W. Tillinghast, Donald Ross, Robert Trent Jones, etc. Besides, it has other 2 improtant tables related with these golf courses, they are 4,273 golf course tee records with color, par, yards, rating, slope, etc. in each and golf course tee detail with 12,430 records.
The whole golf courses database has a total of 9 tables.
| Name | n3_lyz_course.bluegolf.com |
|---|---|
| Data | 6.77M (+ 0B) |
| Tables | 9 (+ 0) |
| Columns | 83 (+ 0) |
| Table Rows | 20,058 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 4 | title |
100%
|
| category_2 | 11 | title |
100%
|
| category_id |
100%
|
||
| description |
100%
|
||
| name |
100%
|
||
| website |
100%
|
||
| category_2_x_golf_course | 763 | category_2_id |
100%
|
| golf_course_id |
100%
|
||
| category_x_golf_course | 270 | category_id |
100%
|
| golf_course_id |
100%
|
||
| golf_course | 861 | golf_course |
100%
|
| information |
96.4%
|
||
| description |
92.33%
|
||
| awards |
6.5%
|
||
| establish |
74.1%
|
||
| location |
100%
|
||
| classification |
100%
|
||
| architect |
0%
|
||
| phone |
97.91%
|
||
| fax |
49.01%
|
||
|
19.63%
|
|||
| website |
97.56%
|
||
| head_pro |
49.25%
|
||
| director_of_golf |
12.31%
|
||
| golf_course_tee | 4,273 | color |
100%
|
| golf_course_id |
100%
|
||
| par |
96.16%
|
||
| yards |
95.41%
|
||
| rating |
96.16%
|
||
| slope |
96.16%
|
||
| golf_course_tee_detail | 12,430 | title |
100%
|
| golf_course_tee_id |
100%
|
||
| one |
99.17%
|
||
| two |
99.17%
|
||
| three |
99.17%
|
||
| four |
99.17%
|
||
| five |
99.17%
|
||
| six |
99.17%
|
||
| seven |
99.17%
|
||
| eight |
99.17%
|
||
| nine |
99.17%
|
||
| out |
66.11%
|
||
| ten |
99.17%
|
||
| eleven |
99.17%
|
||
| twelve |
99.17%
|
||
| thirteen |
99.17%
|
||
| fourteen |
99.17%
|
||
| fifteen |
99.17%
|
||
| sixteen |
99.17%
|
||
| seventeen |
99.17%
|
||
| eighteen |
99.17%
|
||
| in |
66.11%
|
||
| tot |
66.11%
|
||
| golf_course_x_region | 861 | golf_course_id |
100%
|
| region_id |
100%
|
||
| region | 585 | region |
100%
|
| sub_region |
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.
