This golf courses database contains 16,862 records in 8,341 cities of the United States. Each record is comprised of course, city, description, state, address, zip, county, email, website, phone, fax, classification, year built, annual round, annual round remark, season, manager, club pro, superintendant, guest policy, designer, pro shop hour, dress code, fees weekend, fees weekday, tee time reservation, online reservation, earliest tee time, hole, green, fairway, water hazard, bunker, metal spike, greens aerated, overseeding and five somes.
In table golf course review, there are 16,862 records with tee, par, length, slope, usga rating and golf course id in each.
The whole United States golf courses dataset has 4 tables in total.
| Name | n3_lyz_golfnationwide.com |
|---|---|
| Data | 28M (+ 1.05M) |
| Tables | 4 (+ 1) |
| Columns | 91 (+ 40) |
| Table Rows | 92,513 (+ 50) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 8,341 | city |
100%
|
| golf_course | 16,862 | golf_course |
100%
|
| city |
100%
|
||
| description |
1.01%
|
||
| state |
100%
|
||
| address |
99.73%
|
||
| zip |
99.72%
|
||
| county |
99.44%
|
||
|
26.29%
|
|||
| website |
22.53%
|
||
| phone |
99.72%
|
||
| fax |
74.03%
|
||
| classification |
99.72%
|
||
| year_built |
95.05%
|
||
| annual_round |
99.73%
|
||
| annual_round_remark |
61.91%
|
||
| season |
99.72%
|
||
| manager |
99.72%
|
||
| club_pro |
99.72%
|
||
| superintendant |
99.72%
|
||
| guest_policy |
99.72%
|
||
| designer |
99.72%
|
||
| pro_shop_hour |
99.72%
|
||
| dress_code |
99.72%
|
||
| fees_weekend |
99.73%
|
||
| fees_weekday |
99.73%
|
||
| tee_time_reservation |
99.72%
|
||
| online_reservation |
99.72%
|
||
| earliest_tee_time |
75.09%
|
||
| hole |
99.73%
|
||
| green |
99.73%
|
||
| fairway |
99.72%
|
||
| water_hazard |
99.63%
|
||
| bunker |
99.01%
|
||
| metal_spike |
99.64%
|
||
| greens_aerated |
99%
|
||
| overseeding |
98.78%
|
||
| five_somes |
99.62%
|
||
| golf_course_review | 67,260 | tee |
100%
|
| par |
60.54%
|
||
| length |
60.62%
|
||
| slope |
60.62%
|
||
| usga_rating |
60.62%
|
||
| golf_course_id |
100%
|
||
| golf_courseb | 50 | golf_course |
100%
|
| city |
100%
|
||
| description |
0%
|
||
| state |
100%
|
||
| address |
100%
|
||
| zip |
100%
|
||
| county |
100%
|
||
|
16%
|
|||
| website |
14%
|
||
| phone |
100%
|
||
| fax |
48%
|
||
| classification |
100%
|
||
| year_built |
94%
|
||
| annual_round |
100%
|
||
| annual_round_remark |
60%
|
||
| season |
100%
|
||
| manager |
100%
|
||
| club_pro |
100%
|
||
| superintendant |
100%
|
||
| guest_policy |
100%
|
||
| designer |
100%
|
||
| pro_shop_hour |
100%
|
||
| dress_code |
100%
|
||
| fees_weekend |
100%
|
||
| fees_weekday |
100%
|
||
| tee_time_reservation |
100%
|
||
| online_reservation |
100%
|
||
| earliest_tee_time |
56%
|
||
| hole |
100%
|
||
| green |
100%
|
||
| fairway |
100%
|
||
| water_hazard |
100%
|
||
| bunker |
100%
|
||
| metal_spike |
100%
|
||
| greens_aerated |
100%
|
||
| overseeding |
100%
|
||
| five_somes |
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.
