| Field | Records | Percent | Type | Comment |
|---|
| id | 69,539 | 100% | int(11) | Unique Identifier |
| biz_name | 69,539 | 100% | varchar(150) | Business Name |
| biz_info | 3 | 0% | text | Business Information and Description |
| e_address | 69,539 | 100% | varchar(100) | Physical Address |
| e_city | 69,539 | 100% | varchar(50) | Physical Address City |
| e_state | 69,539 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 69,539 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 64,012 | 92% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 69,539 | 100% | varchar(20) | Physical Address Country |
| loc_county | 69,496 | 100% | varchar(40) | Physical Address County |
| loc_area_code | 69,496 | 100% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 69,496 | 100% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 31,344 | 45% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 24,015 | 35% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 69,496 | 100% | varchar(6) | Location Time Zone |
| loc_DST | 69,539 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 69,496 | 100% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 487 | 1% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 69,496 | 100% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 487 | 1% | varchar(15) | Longitude (Precision Polygon Based) |
| biz_phone | 69,538 | 100% | varchar(20) | Business Phone Number |
| supp_aeds | 760 | 1% | int(11) | Supplies Automatic External Defibrillators |
| supp_urinal | 41,490 | 60% | int(11) | Supplies Commodes-Urinals |
| supp_cpmd | 5,653 | 8% | int(11) | Supplies Continuous Passive Motion Devices |
| sup_splint | 1,641 | 2% | int(11) | Supplies Dynamic Splints |
| supp_gluc | 54,583 | 78% | int(11) | Supplies Blood Glucose Supplies |
| supp_gsp | 4,109 | 6% | int(11) | Supplies Gastric Suction Pumps |
| supp_ehb | 12,224 | 18% | int(11) | Electric Hospital Beds |
| supp_mhb | 10,378 | 15% | int(11) | Manual Hospital Beds |
| supp_ihps | 2,038 | 3% | int(11) | Supplies Infrared Heating Pad Systems |
| supp_infuse | 4,477 | 6% | int(11) | Supplies Infusion Pumps |
| supp_insl | 3,403 | 5% | int(11) | Supplies Insulin Infusion |
| supp_impin | 1,732 | 2% | int(11) | Supplies Implanted Infusion |
| supp_pwt | 3,888 | 6% | int(11) | Supplies Pressure Wound Therapy |
| supp_elecsim | 2,447 | 4% | int(11) | Supplies Electrical Stimulators |
| supp_oststim | 1,450 | 2% | int(11) | Supplies Osteogenesis Stimulators |
| supp_pnucomp | 5,547 | 8% | int(11) | Supplies Pneumatic Compression Devices |
| supp_spgen | 1,150 | 2% | int(11) | Supplies Speech Generating Devices |
| supp_suppsur | 11,620 | 17% | int(11) | Supplies Support Surfaces |
| supp_trac | 8,632 | 12% | int(11) | Supplies Traction Equipment |
| supp_tens | 9,893 | 14% | int(11) | Supplies Transcutaneous Electrical Nerve Stimulators |
| supp_ultra | 3,683 | 5% | int(11) | Supplies Ultraviolet Light Devices |
| supp_hde | 379 | 1% | int(11) | Supplies Home Dialysis Equipment |
| supp_hemo | 630 | 1% | int(11) | Supplies Hemodialysis Equipment |
| supp_canes | 49,970 | 72% | int(11) | Supplies Canes Crutches |
| supp_lifts | 11,633 | 17% | int(11) | Supplies Patient Lifts |
| supp_scoot | 9,613 | 14% | int(11) | Supplies Scooters |
| supp_slm | 13,189 | 19% | int(11) | Supplies Seat Lift Mechanisms |
| supp_walker | 49,370 | 71% | int(11) | Supplies Walkers |
| supp_wheel | 14,849 | 21% | int(11) | Supplies Wheelchairs Manual |
| supp_whellp | 9,872 | 14% | int(11) | Supplies Wheelchairs Power |
| supp_wc | 3,177 | 5% | int(11) | Wheelchair Cushions |
| supp_orth1 | 4,058 | 6% | int(11) | Supplies Orthoses - Custom Fabricated |
| supp_orth2 | 7,962 | 11% | int(11) | Supplies Orthoses - Prefabricated |
| supp_orth3 | 26,862 | 39% | int(11) | Supplies Orthoses - Off-the-Shelf |
| supp_bpa | 5,808 | 8% | int(11) | Supplies Breast Prostheses & Accessories |
| supp_coch | 311 | 0% | int(11) | Supplies Cochlear Implants |
| supp_face | 326 | 0% | int(11) | Supplies Facial Prostheses |
| supp_neuro | 1,097 | 2% | int(11) | Supplies Neurostimulators |
| supp_osc | 440 | 1% | int(11) | Supplies Ocular Prostheses |
| supp_ost | 42,095 | 61% | int(11) | Supplies Ostomy Supplies |
| supp_soma | 708 | 1% | int(11) | Supplies Somatic Prostheses |
| supp_trach | 8,375 | 12% | int(11) | Supplies Tracheostomy Supplies |
| supp_uro | 36,044 | 52% | int(11) | Supplies Urological Supplies |
| supp_voice | 403 | 1% | int(11) | Supplies Voice Prosthetics |
| supp_glasses | 5,634 | 8% | int(11) | Supplies Prosthetic Lenses - Eyeglasses |
| supp_contacts | 5,439 | 8% | int(11) | Supplies Prosthetic Lenses - Contact Lenses |
| supp_catar | 1,476 | 2% | int(11) | Supplies Prosthetic Lenses - Cataract Lenses |
| supp_enteral | 35,712 | 51% | int(11) | Supplies Enteral Nutrients, Equipment, & Supplies |
| supp_nutr | 17,898 | 26% | int(11) | Supplies Parenteral Nutrients, Equipment, & Supplies |
| supp_limb | 3,280 | 5% | int(11) | Supplies Limb Prostheses |
| supp_eye | 440 | 1% | int(11) | Supplies Eye Prostheses |
| supp_cpap | 11,444 | 16% | int(11) | Supplies CPAP, RADs, & Related Supplies & Accessories |
| supp_hfcwo | 1,887 | 3% | int(11) | Supplies High Frequency Chest Wall Oscillation (HFCWO) Devices |
| supp_vent | 3,389 | 5% | int(11) | Supplies Invasive Mechanical Ventilation |
| supp_ippb | 3,616 | 5% | int(11) | Supplies Intermittent Positive Pressure Breathing (IPPB) Devices |
| supp_ipvd | 1,883 | 3% | int(11) | Supplies Intrapulmonary Percussive Ventilation Devices |
| supp_mech | 3,054 | 4% | int(11) | Supplies Mechanical In-Exsufflation Devices |
| supp_nebz | 42,394 | 61% | int(11) | Supplies Nebulizer Equipment & Supplies |
| supp_onyg | 9,639 | 14% | int(11) | Supplies Oxygen Equipment & Supplies |
| supp_resp | 8,026 | 12% | int(11) | Supplies Respiratory Suction Pumps |
| supp_ventacc | 3,810 | 5% | int(11) | Supplies Ventilators, Accessories, & Supplies |
| supp_srgdress | 42,111 | 61% | int(11) | Supplies Surgical Dressings |
| supp_diab1 | 22,751 | 33% | int(11) | Supplies Diabetic Shoes & Inserts: Prefabricated |
| supp_diab2 | 12,742 | 18% | int(11) | Supplies Diabetic Shoes & Inserts: Custom Fabricated |
