Medical Equipment Suppliers

@kaggle.amitgold_medical_equipment_suppliers

Table List

1 table(7.96 MB)

Medical Equipment Suppliers

@kaggle.amitgold_medical_equipment_suppliers.medical_equipment_suppliers

7.96 MB
63112 rows
17 columns

provider_id Provider Id	acceptsassignement Acceptsassignement	participationbegindate Participationbegindate	businessname Businessname	practicename Practicename	practiceaddress1 Practiceaddress1	practiceaddress2 Practiceaddress2	practicecity Practicecity	practicestate Practicestate	practicezip9code Practicezip9code	telephonenumber Telephonenumber	specialitieslist Specialitieslist	providertypelist Providertypelist	supplieslist Supplieslist	latitude Latitude	longitude Longitude
20561045	true	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	HARTIG DRUG CO CORP	HARTIG DRUG STORE 5	11002 BARTELL BLVD	nan	GALENA	IL	610368215	8157772700	Pharmacy	nan	Enteral Nutrients\|Walkers\|Tracheotomy Supplies\|Oral Antiemetic Drugs\|Canes and/or Crutches\|Orthoses: Off-The-Shelf\|Epoetin\|Urological Supplies\|Surgical Dressings\|Insulin Infusion Pumps and/or Supplies\|Oral Anticancer Drugs\|Blood Glucose Monitors/Supplies (Non-Mail Order)\|Nebulizer Equipment and/or S…	42.44484	-90.45593
20489003		Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	WAL-MART STORES EAST LP	WALMART PHARMACY 10-0674	1112 NASHVILLE PIKE	nan	GALLATIN	TN	370667116	6154521110	Optician\|Pharmacy	nan	Enteral Nutrients\|Oral Antiemetic Drugs\|Blood Glucose Monitors/Supplies (Non-Mail Order)\|Blood Glucose Monitors/Supplies (Mail Order)\|Epoetin\|Surgical Dressings\|Infusion Drugs\|Prosthetic Lenses: Conventional Eyeglasses\|Oral Anticancer Drugs\|Immunosuppressive Drugs\|Ostomy Supplies\|Nebulizer Drugs	36.37498	-86.47526
20447711		Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	OHIO CVS STORES LLC	CVS PHARMACY #03306	1949 WEST MARKET STREET	nan	AKRON	OH	443136910	3308675410	Pharmacy	nan	Blood Glucose Monitors/Supplies (Mail Order)\|Parenteral Nutrients\|Surgical Dressings\|Commodes, Urinals, Bedpans\|Parenteral Equipment and/or Supplies\|Ostomy Supplies\|Nebulizer Drugs\|Walkers\|Oral Antiemetic Drugs\|Blood Glucose Monitors/Supplies (Non-Mail Order)\|Enteral Equipment and/or Supplies\|Nebuli…	41.11353	-81.5782
20541431		Wed Mar 31 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	LUXOTTICA OF AMERICA INC	LENSCRAFERS #00855	2526 S THIRD ST	nan	JACKSONVILLE	FL	322506024	9042472374	Optician	nan	Prosthetic Lenses: Conventional Eyeglasses	30.26696	-81.38857
20469089	true	Thu Dec 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	SPECIALTY INFUSIONS INC	PRIME INFUSIONS	1624 BROADWAY	nan	BROOKLYN	NY	112071026	7184434000	Pharmacy	nan	External Infusion Pumps and/or Supplies\|Osteogenesis Stimulators\|Ultraviolet Light Devices and/or Supplies\|Wheelchair Seating/Cushions\|Infusion Drugs\|Commodes, Urinals, Bedpans\|Contracture Treatment Devices: Dynamic Splint\|Insulin Infusion Pumps and/or Supplies\|Parenteral Equipment and/or Supplies\|E…	40.68483	-73.91404
20395109	true	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WALGREEN CO	WALGREENS #21331	2001 W PATAPSCO AVE	nan	BALTIMORE	MD	212303329	4106462059	Pharmacy	nan	Epoetin\|Oral Antiemetic Drugs\|Blood Glucose Monitors/Supplies (Non-Mail Order)\|Immunosuppressive Drugs\|Nebulizer Drugs\|Oral Anticancer Drugs\|Infusion Drugs	39.25011	-76.64251
20408885	true	Fri Jan 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	OPTION CARE ENTERPRISES INC	OPTION CARE	49 FREEWAY DR	SUITE A	CRANSTON	RI	29207935	4014311300	MSC With Respiratory Therapist\|Pharmacy\|Certified Other	OXYGEN & EQUIPMENT	Hospital Beds (Manual)\|Enteral Equipment and/or Supplies\|Continuous Positive Airway Pressure (CPAP) Devices\|Wheelchairs (Standard Manual Related Accessories)\|Nebulizer Equipment and/or Supplies\|Ventilators Accessories and/or Supplies\|Immunosuppressive Drugs\|Commodes, Urinals, Bedpans\|Parenteral Nutr…	41.75103	-71.44957
20325797	true	Sun Jan 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	KANSAS CVS PHARMACY LLC	CVS PHARMACY #00676	2300 IOWA ST	nan	LAWRENCE	KS	660463938	7858321112	Pharmacy	nan	Nebulizer Equipment and/or Supplies\|Immunosuppressive Drugs\|Blood Glucose Monitors/Supplies (Mail Order)\|Parenteral Nutrients\|Heat & Cold Applications\|Surgical Dressings\|Walkers\|Oral Anticancer Drugs\|Blood Glucose Monitors/Supplies (Non-Mail Order)\|Enteral Equipment and/or Supplies\|Canes and/or Crut…	38.94331	-95.26038
20557649		Wed Jul 09 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	MB PHARMACY LLC	MB PHARMACY LLC	11457 QUEENS BLVD	nan	FOREST HILLS	NY	113756554	7182681900	Pharmacy	nan	Walkers\|Oral Anticancer Drugs\|Canes and/or Crutches\|Wheelchairs (Standard Manual)\|(TENS) Transcutaneous Electrical Nerve Stimulators and/or Supplies\|Epoetin\|Surgical Dressings\|Infusion Drugs\|Commodes, Urinals, Bedpans\|Heat & Cold Applications\|Insulin Infusion Pumps and/or Supplies\|Blood Glucose Moni…	40.71697	-73.83451
20654861		Thu Jan 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	OFFERLE APOTHECARY INC.	M-D CHOICE MEDICAL SUPPLY	2413 HOBSON RD	nan	FORT WAYNE	IN	468052917	2604246743	Medical Supply Company Other	nan	Walkers\|Orthoses: Prefabricated (Non-Custom Fabricated)\|Canes and/or Crutches\|Orthoses: Off-The-Shelf\|Surgical Dressings\|Commodes, Urinals, Bedpans\|Breast Prostheses and/or Accessories\|Urological Supplies\|Ostomy Supplies	41.09829	-85.09882


CREATE TABLE medical_equipment_suppliers (
  "provider_id" BIGINT,
  "acceptsassignement" BOOLEAN,
  "participationbegindate" TIMESTAMP,
  "businessname" VARCHAR,
  "practicename" VARCHAR,
  "practiceaddress1" VARCHAR,
  "practiceaddress2" VARCHAR,
  "practicecity" VARCHAR,
  "practicestate" VARCHAR,
  "practicezip9code" BIGINT,
  "telephonenumber" BIGINT,
  "specialitieslist" VARCHAR,
  "providertypelist" VARCHAR,
  "supplieslist" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "is_contracted_for_cba" BOOLEAN
);