U.S. Healthcare Data

Population Health, Diseases, Drugs, Nutritions, Health-plans

@kaggle.maheshdadhich_us_healthcare_data

Drugs Package

@kaggle.maheshdadhich_us_healthcare_data.drugs_package

productid PRODUCTID	productndc PRODUCTNDC	ndcpackagecode NDCPACKAGECODE	packagedescription PACKAGEDESCRIPTION
0002-1200_4bd46cbe-cdc1-4329-a8e7-22816bd7fc33	0002-1200	0002-1200-30	1 VIAL, MULTI-DOSE in 1 CAN (0002-1200-30) > 30 mL in 1 VIAL, MULTI-DOSE
0002-1200_4bd46cbe-cdc1-4329-a8e7-22816bd7fc33	0002-1200	0002-1200-50	1 VIAL, MULTI-DOSE in 1 CAN (0002-1200-50) > 50 mL in 1 VIAL, MULTI-DOSE
0002-1407_14757f9d-f641-4836-acf3-229265588d1d	0002-1407	0002-1407-01	10 mL in 1 VIAL (0002-1407-01)
0002-1433_aaae85ae-9295-465f-b938-463b74b8d5bd	0002-1433	0002-1433-80	4 SYRINGE in 1 CARTON (0002-1433-80) > .5 mL in 1 SYRINGE (0002-1433-01)
0002-1434_aaae85ae-9295-465f-b938-463b74b8d5bd	0002-1434	0002-1434-80	4 SYRINGE in 1 CARTON (0002-1434-80) > .5 mL in 1 SYRINGE (0002-1434-01)
0002-1445_2ecde4c5-5128-4725-9cf5-64384857eb1c	0002-1445	0002-1445-09	3 SYRINGE in 1 CARTON (0002-1445-09) > 1 mL in 1 SYRINGE (0002-1445-01)
0002-1445_2ecde4c5-5128-4725-9cf5-64384857eb1c	0002-1445	0002-1445-11	1 SYRINGE in 1 CARTON (0002-1445-11) > 1 mL in 1 SYRINGE (0002-1445-01)
0002-1445_2ecde4c5-5128-4725-9cf5-64384857eb1c	0002-1445	0002-1445-27	2 SYRINGE in 1 CARTON (0002-1445-27) > 1 mL in 1 SYRINGE (0002-1445-01)
0002-1445_2ecde4c5-5128-4725-9cf5-64384857eb1c	0002-1445	0002-1445-61	1 SYRINGE in 1 CARTON (0002-1445-61) > 1 mL in 1 SYRINGE
0002-1975_23295988-5c83-40af-99e3-67ac0b5a9562	0002-1975	0002-1975-61	1 BOTTLE, WITH APPLICATOR in 1 CARTON (0002-1975-61) > 90 mL in 1 BOTTLE, WITH APPLICATOR


CREATE TABLE drugs_package (
  "productid" VARCHAR,
  "productndc" VARCHAR,
  "ndcpackagecode" VARCHAR,
  "packagedescription" VARCHAR
);