U.S. Opiate Prescriptions/Overdoses

CREATE TABLE prescriber_info (
  "npi" BIGINT,
  "gender" VARCHAR,
  "state" VARCHAR,
  "credentials" VARCHAR,
  "specialty" VARCHAR,
  "abilify" BIGINT,
  "acetaminophen_codeine" BIGINT,
  "acyclovir" BIGINT,
  "advair_diskus" BIGINT,
  "aggrenox" BIGINT,
  "alendronate_sodium" BIGINT,
  "allopurinol" BIGINT,
  "alprazolam" BIGINT,
  "amiodarone_hcl" BIGINT,
  "amitriptyline_hcl" BIGINT,
  "amlodipine_besylate" BIGINT,
  "amlodipine_besylate_benazepril" BIGINT,
  "amoxicillin" BIGINT,
  "amox_tr_potassium_clavulanate" BIGINT,
  "amphetamine_salt_combo" BIGINT,
  "atenolol" BIGINT,
  "atorvastatin_calcium" BIGINT,
  "avodart" BIGINT,
  "azithromycin" BIGINT,
  "baclofen" BIGINT,
  "bd_ultra_fine_pen_needle" BIGINT,
  "benazepril_hcl" BIGINT,
  "benicar" BIGINT,
  "benicar_hct" BIGINT,
  "benztropine_mesylate" BIGINT,
  "bisoprolol_hydrochlorothiazide" BIGINT,
  "brimonidine_tartrate" BIGINT,
  "bumetanide" BIGINT,
  "bupropion_hcl_sr" BIGINT,
  "bupropion_xl" BIGINT,
  "buspirone_hcl" BIGINT,
  "bystolic" BIGINT,
  "carbamazepine" BIGINT,
  "carbidopa_levodopa" BIGINT,
  "carisoprodol" BIGINT,
  "cartia_xt" BIGINT,
  "carvedilol" BIGINT,
  "cefuroxime" BIGINT,
  "celebrex" BIGINT,
  "cephalexin" BIGINT,
  "chlorhexidine_gluconate" BIGINT,
  "chlorthalidone" BIGINT,
  "cilostazol" BIGINT,
  "ciprofloxacin_hcl" BIGINT,
  "citalopram_hbr" BIGINT,
  "clindamycin_hcl" BIGINT,
  "clobetasol_propionate" BIGINT,
  "clonazepam" BIGINT,
  "clonidine_hcl" BIGINT,
  "clopidogrel" BIGINT,
  "clotrimazole_betamethasone" BIGINT,
  "colcrys" BIGINT,
  "combivent_respimat" BIGINT,
  "crestor" BIGINT,
  "cyclobenzaprine_hcl" BIGINT,
  "dexilant" BIGINT,
  "diazepam" BIGINT,
  "diclofenac_sodium" BIGINT,
  "dicyclomine_hcl" BIGINT,
  "digox" BIGINT,
  "digoxin" BIGINT,
  "diltiazem_24hr_cd" BIGINT,
  "diltiazem_24hr_er" BIGINT,
  "diltiazem_er" BIGINT,
  "diltiazem_hcl" BIGINT,
  "diovan" BIGINT,
  "diphenoxylate_atropine" BIGINT,
  "divalproex_sodium" BIGINT,
  "divalproex_sodium_er" BIGINT,
  "donepezil_hcl" BIGINT,
  "dorzolamide_timolol" BIGINT,
  "doxazosin_mesylate" BIGINT,
  "doxepin_hcl" BIGINT,
  "doxycycline_hyclate" BIGINT,
  "duloxetine_hcl" BIGINT,
  "enalapril_maleate" BIGINT,
  "escitalopram_oxalate" BIGINT,
  "estradiol" BIGINT,
  "exelon" BIGINT,
  "famotidine" BIGINT,
  "felodipine_er" BIGINT,
  "fenofibrate" BIGINT,
  "fentanyl" BIGINT,
  "finasteride" BIGINT,
  "flovent_hfa" BIGINT,
  "fluconazole" BIGINT,
  "fluoxetine_hcl" BIGINT,
  "fluticasone_propionate" BIGINT,
  "furosemide" BIGINT,
  "gabapentin" BIGINT,
  "gemfibrozil" BIGINT,
  "glimepiride" BIGINT,
  "glipizide" BIGINT,
  "glipizide_er" BIGINT,
  "glipizide_xl" BIGINT
);