Golf Courses (US)

Database of 19,168 Golf Courses across United States in 10,380 Cities

Data Structure

city [9,502]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ slug (100%)
bigint(20) unsigned
+ state_id (100%)
city2course [225,695]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
bigint(20) unsigned
+ city_id (100%)
bigint(20) unsigned
+ course_id (100%)
varchar(255)
+ distance (100%)
course [19,168]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
text
+ description (100%)
varchar(255)
+ locality (100%)
varchar(255)
+ address (100%)
varchar(255)
+ phone (100%)
varchar(255)
+ website (74.1%)
varchar(255)
+ type (100%)
varchar(255)
+ holes (100%)
varchar(255)
+ yards (88.7%)
varchar(255)
+ par (88.7%)
text
+ course_details (100%)
text
+ facility_details (100%)
state [52]
bigint(20) unsigned
+ id (100%)
timestamp
+ ts (100%)
varchar(255)
+ title (100%)
varchar(255)
+ abbreviation (100%)

Description

This is a fields-rich database of nearly 20,000 golf courses in the United States. Each golf course record consists of contact information such as phone number, address and website, in addition to course type, number of holes, yards, par and many more details such as grass and facility.

There are 7 types of golf courses included: Municipal (2,881 courses in total), Private (55), Private Equity (3,028), Private Non-Equity (2,012), Public (11,078), Public Access (75) and Semi-Private (39).

There are 11,248 unique golf website URLs and 15,910 unique phone numbers in this database. There are a total of 9,502 cities in US that have golf courses in or near them. Slightly over 20 courses are found in or near each of them on average.

Data Profile

Size 55.89M
Tables 4
Last Commit 2016-08-26 04:21:29

Updates / Commits

Time Size Tables Columns Rows
2016-08-26 04:21:29 55.89M 4 28 254417

Pricing

All prices are in Datactory Credits.

TableRowsPrice per Row (Credits)Subtotal (Credits)
city 9,502 .001 9.502
city2course 225,695 .001 225.695
course 19,168 .001 19.168
state 52 .001 0.052
Total Credits 254.417 Credits (1) (2)
(1). Plus cost by query time at 0.1 credits per second. A typical query takes about 0.001 seconds which would then charge you 0.0001 credits.
(2). This is the total amount of credits required for ALL rows in these tables. You are free to query for only a selected part of them, even a single row, and pay only for that.

How to Access

Click to see how to access this dataset.