License Database Purchase Options
USAGE RIGHTS $150.00 |
PUBLICATION RIGHTS $300.00 |
MASTER RIGHTS $600.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 |
Retirement Communities are a planned community for residents who have retired from an active working life. This business database contains listing records and lists for Assisted Living Facilities and Elder Care Homes of all types throughout the U.S.
Note that this is multi table database as there is a supplemental table that contains Features and Services that are tied to the new biz_features field. This field contains a comma separated list if id's that correspond to applicable records from this auxiliary table.
This content database also includes an additional file for images associated with the listings. This file has thousands of images for the retirement homes and communities listed in the database.
The l_image field references the main logo image for the facility, however there is a directory structure in place that contains additional facility, amenity, and other photographs that are useful for gallery image implementation.
Table Schema Database Field Statistics
Field | Records | Percent | Type | Comment |
---|---|---|---|---|
id | 34,838 | 100% | int(11) | Unique Identifier |
biz_name | 34,838 | 100% | varchar(150) | Business Name |
biz_info | 4,935 | 14% | text | Short Business Description |
biz_details | 6,637 | 19% | text | Long Business Description |
biz_features | 4,622 | 13% | varchar(255) | Features and Services |
cat_primary | 34,838 | 100% | varchar(75) | Business Primary Category |
cat_sub | 34,838 | 100% | varchar(75) | Business Secondary/Sub Category |
e_address | 34,722 | 100% | varchar(100) | Physical Address |
e_city | 34,837 | 100% | varchar(50) | Physical Address City |
e_state | 34,838 | 100% | varchar(20) | Physical Address State / Province |
e_postal | 34,838 | 100% | varchar(7) | Physical Address Postal Code |
e_zip_full | 14,044 | 40% | varchar(10) | Zip +4 for US Physical Addresses |
e_country | 34,838 | 100% | varchar(20) | Physical Address Country |
loc_county | 34,829 | 100% | varchar(40) | Physical Address County |
loc_area_code | 34,829 | 100% | varchar(3) | Physical Address Area Code |
loc_FIPS | 34,829 | 100% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
loc_MSA | 14,898 | 43% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
loc_PMSA | 9,709 | 28% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
loc_TZ | 34,829 | 100% | varchar(6) | Location Time Zone |
loc_DST | 34,838 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
loc_LAT_centroid | 34,829 | 100% | varchar(15) | Latitude (Centroid Based) |
loc_LAT_poly | 34,110 | 98% | varchar(15) | Latitude (Precision Polygon Based) |
loc_LONG_centroid | 34,829 | 100% | varchar(15) | Longitude (Centroid Based) |
loc_LONG_poly | 34,110 | 98% | varchar(15) | Longitude (Precision Polygon Based) |
biz_phone | 34,822 | 100% | varchar(20) | Business Phone Number |
biz_phone_ext | 0 | 0% | varchar(8) | Business Phone Number Extension |
biz_fax | 1,150 | 3% | varchar(20) | Business Fax Number |
biz_email | 517 | 1% | varchar(75) | Business Contact Email Address |
web_url | 9,042 | 26% | varchar(175) | Website URL |
web_meta_title | 505 | 1% | varchar(255) | Website Meta Title |
web_meta_desc | 380 | 1% | varchar(255) | Website Meta Description |
web_meta_keys | 203 | 1% | varchar(255) | Website Meta Keywords |
l_image | 6,674 | 19% | varchar(255) | Business Logo Image |
Retirement Homes Records Information | |||
---|---|---|---|
USA | Alaska | 64 | Retirement Homes |
USA | Alabama | 607 | Retirement Homes |
USA | Arkansas | 446 | Retirement Homes |
USA | Arizona | 714 | Retirement Homes |
USA | California | 2,463 | Retirement Homes |
USA | Colorado | 692 | Retirement Homes |
USA | Connecticut | 549 | Retirement Homes |
USA | District Of Columbia | 38 | Retirement Homes |
USA | Delaware | 84 | Retirement Homes |
USA | Florida | 1,560 | Retirement Homes |
USA | Georgia | 1,006 | Retirement Homes |
USA | Hawaii | 70 | Retirement Homes |
USA | Iowa | 827 | Retirement Homes |
USA | Idaho | 339 | Retirement Homes |
USA | Illinois | 1,412 | Retirement Homes |
USA | Indiana | 891 | Retirement Homes |
USA | Kansas | 763 | Retirement Homes |
USA | Kentucky | 537 | Retirement Homes |
USA | Louisiana | 523 | Retirement Homes |
USA | Massachusetts | 807 | Retirement Homes |
USA | Maryland | 630 | Retirement Homes |
USA | Maine | 235 | Retirement Homes |
USA | Michigan | 1,234 | Retirement Homes |
USA | Minnesota | 1,005 | Retirement Homes |
USA | Missouri | 1,036 | Retirement Homes |
USA | Mississippi | 372 | Retirement Homes |
USA | Montana | 273 | Retirement Homes |
USA | North Carolina | 1,135 | Retirement Homes |
USA | North Dakota | 160 | Retirement Homes |
USA | Nebraska | 517 | Retirement Homes |
USA | New Hampshire | 166 | Retirement Homes |
USA | New Jersey | 776 | Retirement Homes |
USA | New Mexico | 219 | Retirement Homes |
USA | Nevada | 220 | Retirement Homes |
USA | New York | 1,216 | Retirement Homes |
USA | Ohio | 1,556 | Retirement Homes |
USA | Oklahoma | 648 | Retirement Homes |
USA | Oregon | 695 | Retirement Homes |
USA | Pennsylvania | 1,191 | Retirement Homes |
USA | Rhode Island | 156 | Retirement Homes |
USA | South Carolina | 550 | Retirement Homes |
USA | South Dakota | 273 | Retirement Homes |
USA | Tennessee | 782 | Retirement Homes |
USA | Texas | 2,014 | Retirement Homes |
USA | Utah | 282 | Retirement Homes |
USA | Virginia | 718 | Retirement Homes |
USA | Vermont | 110 | Retirement Homes |
USA | Washington | 873 | Retirement Homes |
USA | Wisconsin | 1,118 | Retirement Homes |
USA | West Virginia | 199 | Retirement Homes |
USA | Wyoming | 80 | Retirement Homes |