This is a golf courses database of 18,139 records with title, address, phone number, score, vote, website, architect name and regulation length holes in each. All these golf courses are located in 6,564 regions with city, state and zip in each of the United States. In addition to these tables, there are 3 important one mostly related with these golf courses, 42,713 tee summary records with title, par, pating, slope, yardage and golf course id; tees back nine with 55,908 records and tees front nine with 55,908 records. The whole America golf courses database has 6 tables.
| Name | n3_lyz_pga.com/golf_courses |
|---|---|
| Data | 43.48M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 56 (+ 0) |
| Table Rows | 197,362 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| golf_course | 18,139 | title |
99.99%
|
| address |
99.97%
|
||
| phone |
99.7%
|
||
| score |
22.36%
|
||
| vote |
24.31%
|
||
| websit |
74.99%
|
||
| architect_name |
75.73%
|
||
| regulation_length_holes |
91.34%
|
||
| golf_course_x_region | 18,130 | golf_course_id |
100%
|
| region_id |
100%
|
||
| region | 6,564 | state |
99.98%
|
| city |
100%
|
||
| zip |
99.98%
|
||
| tee_summary | 42,713 | title |
100%
|
| par |
100%
|
||
| pating |
100%
|
||
| slope |
100%
|
||
| yardage |
100%
|
||
| golf_course_id |
100%
|
||
| tees_back_nine | 55,908 | title |
100%
|
| golf_course_id |
100%
|
||
| ten |
100%
|
||
| eleven |
89.97%
|
||
| twelve |
89.97%
|
||
| thirteen |
89.97%
|
||
| fourteen |
89.97%
|
||
| fifteen |
89.97%
|
||
| sixteen |
89.97%
|
||
| seventeen |
89.97%
|
||
| eighteen |
89.97%
|
||
| in |
100%
|
||
| tees_front_nine | 55,908 | title |
100%
|
| golf_course_id |
100%
|
||
| one |
100%
|
||
| two |
99.98%
|
||
| three |
99.98%
|
||
| four |
99.98%
|
||
| five |
99.98%
|
||
| six |
99.98%
|
||
| seven |
99.98%
|
||
| eight |
99.98%
|
||
| nine |
99.98%
|
||
| out |
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.
