McDonalds Location Details Database v.1.0.3
14,224 McDonalds
License Database Purchase Options
 |
USAGE RIGHTS $30.00 |
PUBLICATION RIGHTS $60.00 |
MASTER RIGHTS $120.00 |
| Data Tracking Seeds |  |
|
 |
| Data Modification | |
|
|
| Importing | |
|
|
| Exporting | |
|
|
| Merge | |
|
|
| Web Usage | |
|
|
| Multiple PC's or Websites | |
|
|
| Mobile Development | |
|
|
| Updates Available | |
|
|
| All Data File Formats | |
|
|
| Custom File Formats | |
|
|
| Distribution | |
|
|
| Copyright Endorsement | |
|
|
| BUY NOW | BUY NOW | BUY NOW |
Our McDonalds Location Details Database contains location and contact information including available features and services such as Free WiFi, Playground, Credit Card Acceptance and more.
Table Schema Database Field Statistics
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 14,224 | 100% | int(11) | Unique Identifier |
| e_address | 14,224 | 100% | varchar(100) | Physical Address |
| e_city | 14,224 | 100% | varchar(50) | Physical Address City |
| e_state | 14,224 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 14,210 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 3,942 | 28% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 14,224 | 100% | varchar(20) | Physical Address Country |
| loc_county | 14,204 | 100% | varchar(40) | Physical Address County |
| loc_area_code | 14,204 | 100% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 14,204 | 100% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 6,563 | 46% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 4,794 | 34% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 14,204 | 100% | varchar(6) | Location Time Zone |
| loc_DST | 14,224 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 14,204 | 100% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 13,817 | 97% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 14,204 | 100% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 13,817 | 97% | varchar(15) | Longitude (Precision Polygon Based) |
| biz_phone | 14,215 | 100% | varchar(20) | Business Phone Number |
| f_playplace | 14,224 | 100% | enum('Y','N','U') | Play Place at McDonalds Location |
| f_drivethru | 14,224 | 100% | enum('Y','N','U') | Drive-Thru at McDonalds Location |
| f_cc | 14,224 | 100% | enum('Y','N','U') | McDonalds Accepts Credit Cards |
| f_arch | 14,224 | 100% | enum('Y','N','U') | Accepts Arch Card Program - http://www.aboutmcdonalds.com/mcd/our_company/mcd_faq/arch-credit_card.html |
| f_wifi | 14,224 | 100% | enum('Y','N','U') | Free WiFi at McDonalds Location |
| l_type | 14,224 | 100% | varchar(100) | McDonalds Location Type |
| biz_name | 14,224 | 100% | varchar(150) | Business Name |
| McDonalds Records Information | |||
|---|---|---|---|
| USA | Alaska | 30 | McDonalds |
| USA | Alabama | 255 | McDonalds |
| USA | Arkansas | 171 | McDonalds |
| USA | Arizona | 285 | McDonalds |
| USA | California | 1,339 | McDonalds |
| USA | Colorado | 226 | McDonalds |
| USA | Connecticut | 145 | McDonalds |
| USA | District Of Columbia | 37 | McDonalds |
| USA | Delaware | 37 | McDonalds |
| USA | Florida | 870 | McDonalds |
| USA | Georgia | 457 | McDonalds |
| USA | Hawaii | 73 | McDonalds |
| USA | Iowa | 151 | McDonalds |
| USA | Idaho | 60 | McDonalds |
| USA | Illinois | 677 | McDonalds |
| USA | Indiana | 367 | McDonalds |
| USA | Kansas | 152 | McDonalds |
| USA | Kentucky | 259 | McDonalds |
| USA | Louisiana | 253 | McDonalds |
| USA | Massachusetts | 259 | McDonalds |
| USA | Maryland | 309 | McDonalds |
| USA | Maine | 60 | McDonalds |
| USA | Michigan | 559 | McDonalds |
| USA | Minnesota | 220 | McDonalds |
| USA | Missouri | 321 | McDonalds |
| USA | Mississippi | 147 | McDonalds |
| USA | Montana | 48 | McDonalds |
| USA | North Carolina | 457 | McDonalds |
| USA | North Dakota | 24 | McDonalds |
| USA | Nebraska | 83 | McDonalds |
| USA | New Hampshire | 66 | McDonalds |
| USA | New Jersey | 266 | McDonalds |
| USA | New Mexico | 101 | McDonalds |
| USA | Nevada | 159 | McDonalds |
| USA | New York | 702 | McDonalds |
| USA | Ohio | 644 | McDonalds |
| USA | Oklahoma | 209 | McDonalds |
| USA | Oregon | 166 | McDonalds |
| USA | Pennsylvania | 533 | McDonalds |
| USA | Rhode Island | 32 | McDonalds |
| USA | South Carolina | 218 | McDonalds |
| USA | South Dakota | 30 | McDonalds |
| USA | Tennessee | 330 | McDonalds |
| USA | Texas | 1,165 | McDonalds |
| USA | Utah | 112 | McDonalds |
| USA | Virginia | 423 | McDonalds |
| USA | Vermont | 31 | McDonalds |
| USA | Washington | 273 | McDonalds |
| USA | Wisconsin | 301 | McDonalds |
| USA | West Virginia | 105 | McDonalds |
| USA | Wyoming | 27 | McDonalds |
This is NOT an email marketing list
