provider_data_loader.sql

# Nov 2013
# MG

use test;

drop table `t`;

create table `t` (
     `NPI` varchar(10) , 
     `Entity` varchar(10) ,
     `Replacement NPI` varchar(10),
     `Employer Identification Number (EIN)` varchar(10) , 
     `Provider Organization Name (Legal Business Name)` varchar(100) , 
     `Provider Last Name (Legal Name)` varchar(10) , 
     `Provider First Name` varchar(10) , 
     `Provider Middle Name` varchar(10) , 
     `Provider Name Prefix Text` varchar(10) , 
     `Provider Name Suffix Text` varchar(10) , 
     `Provider Credential Text` varchar(10) , 
     `Provider Other Organization Name` varchar(10) , 
     `Provider Other Organization Name Type Code` varchar(10) , 
     `Provider Other Last Name` varchar(10) , 
     `Provider Other First Name` varchar(10) , 
     `Provider Other Middle Name` varchar(10) , 
     `Provider Other Name Prefix Text` varchar(10) , 
     `Provider Other Name Suffix Text` varchar(10) , 
     `Provider Other Credential Text` varchar(10) , 
     `Provider Other Last Name Type Code` varchar(10) , 
     `Provider First Line Business Mailing Address` varchar(10) , 
     `Provider Second Line Business Mailing Address` varchar(10) , 
     `Provider Business Mailing Address City Name` varchar(10) , 
     `Provider Business Mailing Address State Name` varchar(10) , 
     `Provider Business Mailing Address Postal Code` varchar(10) , 
     `pbmacc (If outside U.S.)` varchar(10) , 
     `Provider Business Mailing Address Telephone Number` varchar(10) , 
     `Provider Business Mailing Address Fax Number` varchar(10) , 
     `Provider First Line Business Practice Location Address` varchar(10) , 
     `Provider Second Line Business Practice Location Address` varchar(10) , 
     `Provider Business Practice Location Address City Name` varchar(10) , 
     `Provider Business Practice Location Address State Name` varchar(10) , 
     `Provider Business Practice Location Address Postal Code` varchar(10) , 
     `pbmacc2 (If outside U.S.)` varchar(10) , 
     `Provider Business Practice Location Address Telephone Number` varchar(10) , 
     `Provider Business Practice Location Address Fax Number` varchar(10) , 
     `Provider Enumeration Date` varchar(10) , 
     `Last Update Date` varchar(10) , 
     `NPI Deactivation Reason Code` varchar(10) , 
     `NPI Deactivation Date` varchar(10) , 
     `NPI Reactivation Date` varchar(10) , 
     `Provider Gender Code` varchar(10) , 
     `Authorized Official Last Name` varchar(10) , 
     `Authorized Official First Name` varchar(10) , 
     `Authorized Official Middle Name` varchar(10) , 
     `Authorized Official Title or Position` varchar(10) , 
     `Authorized Official Telephone Number` varchar(10) , 
     `Healthcare Provider Taxonomy Code_1` varchar(10) , 
     `Provider License Number_1` varchar(10) , 
     `Provider License Number State Code_1` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_1` varchar(10) , 
     `Healthcare Provider Taxonomy Code_2` varchar(10) , 
     `Provider License Number_2` varchar(10) , 
     `Provider License Number State Code_2` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_2` varchar(10) , 
     `Healthcare Provider Taxonomy Code_3` varchar(10) , 
     `Provider License Number_3` varchar(10) , 
     `Provider License Number State Code_3` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_3` varchar(10) , 
     `Healthcare Provider Taxonomy Code_4` varchar(10) , 
     `Provider License Number_4` varchar(10) , 
     `Provider License Number State Code_4` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_4` varchar(10) , 
     `Healthcare Provider Taxonomy Code_5` varchar(10) , 
     `Provider License Number_5` varchar(10) , 
     `Provider License Number State Code_5` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_5` varchar(10) , 
     `Healthcare Provider Taxonomy Code_6` varchar(10) , 
     `Provider License Number_6` varchar(10) , 
     `Provider License Number State Code_6` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_6` varchar(10) , 
     `Healthcare Provider Taxonomy Code_7` varchar(10) , 
     `Provider License Number_7` varchar(10) , 
     `Provider License Number State Code_7` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_7` varchar(10) , 
     `Healthcare Provider Taxonomy Code_8` varchar(10) , 
     `Provider License Number_8` varchar(10) , 
     `Provider License Number State Code_8` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_8` varchar(10) , 
     `Healthcare Provider Taxonomy Code_9` varchar(10) , 
     `Provider License Number_9` varchar(10) , 
     `Provider License Number State Code_9` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_9` varchar(10) , 
     `Healthcare Provider Taxonomy Code_10` varchar(10) , 
     `Provider License Number_10` varchar(10) , 
     `Provider License Number State Code_10` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_10` varchar(10) , 
     `Healthcare Provider Taxonomy Code_11` varchar(10) , 
     `Provider License Number_11` varchar(10) , 
     `Provider License Number State Code_11` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_11` varchar(10) , 
     `Healthcare Provider Taxonomy Code_12` varchar(10) , 
     `Provider License Number_12` varchar(10) , 
     `Provider License Number State Code_12` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_12` varchar(10) , 
     `Healthcare Provider Taxonomy Code_13` varchar(10) , 
     `Provider License Number_13` varchar(10) , 
     `Provider License Number State Code_13` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_13` varchar(10) , 
     `Healthcare Provider Taxonomy Code_14` varchar(10) , 
     `Provider License Number_14` varchar(10) , 
     `Provider License Number State Code_14` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_14` varchar(10) , 
     `Healthcare Provider Taxonomy Code_15` varchar(10) , 
     `Provider License Number_15` varchar(10) , 
     `Provider License Number State Code_15` varchar(10) , 
     `Healthcare Provider Primary Taxonomy Switch_15` varchar(10) , 
     `Other Provider Identifier_1` varchar(10) , 
     `Other Provider Identifier Type Code_1` varchar(10) , 
     `Other Provider Identifier State_1` varchar(10) , 
     `Other Provider Identifier Issuer_1` varchar(10) , 
     `Other Provider Identifier_2` varchar(10) , 
     `Other Provider Identifier Type Code_2` varchar(10) , 
     `Other Provider Identifier State_2` varchar(10) , 
     `Other Provider Identifier Issuer_2` varchar(10) , 
     `Other Provider Identifier_3` varchar(10) , 
     `Other Provider Identifier Type Code_3` varchar(10) , 
     `Other Provider Identifier State_3` varchar(10) , 
     `Other Provider Identifier Issuer_3` varchar(10) , 
     `Other Provider Identifier_4` varchar(10) , 
     `Other Provider Identifier Type Code_4` varchar(10) , 
     `Other Provider Identifier State_4` varchar(10) , 
     `Other Provider Identifier Issuer_4` varchar(10) , 
     `Other Provider Identifier_5` varchar(10) , 
     `Other Provider Identifier Type Code_5` varchar(10) , 
     `Other Provider Identifier State_5` varchar(10) , 
     `Other Provider Identifier Issuer_5` varchar(10) , 
     `Other Provider Identifier_6` varchar(10) , 
     `Other Provider Identifier Type Code_6` varchar(10) , 
     `Other Provider Identifier State_6` varchar(10) , 
     `Other Provider Identifier Issuer_6` varchar(10) , 
     `Other Provider Identifier_7` varchar(10) , 
     `Other Provider Identifier Type Code_7` varchar(10) , 
     `Other Provider Identifier State_7` varchar(10) , 
     `Other Provider Identifier Issuer_7` varchar(10) , 
     `Other Provider Identifier_8` varchar(10) , 
     `Other Provider Identifier Type Code_8` varchar(10) , 
     `Other Provider Identifier State_8` varchar(10) , 
     `Other Provider Identifier Issuer_8` varchar(10) , 
     `Other Provider Identifier_9` varchar(10) , 
     `Other Provider Identifier Type Code_9` varchar(10) , 
     `Other Provider Identifier State_9` varchar(10) , 
     `Other Provider Identifier Issuer_9` varchar(10) , 
     `Other Provider Identifier_10` varchar(10) , 
     `Other Provider Identifier Type Code_10` varchar(10) , 
     `Other Provider Identifier State_10` varchar(10) , 
     `Other Provider Identifier Issuer_10` varchar(10) , 
     `Other Provider Identifier_11` varchar(10) , 
     `Other Provider Identifier Type Code_11` varchar(10) , 
     `Other Provider Identifier State_11` varchar(10) , 
     `Other Provider Identifier Issuer_11` varchar(10) , 
     `Other Provider Identifier_12` varchar(10) , 
     `Other Provider Identifier Type Code_12` varchar(10) , 
     `Other Provider Identifier State_12` varchar(10) , 
     `Other Provider Identifier Issuer_12` varchar(10) , 
     `Other Provider Identifier_13` varchar(10) , 
     `Other Provider Identifier Type Code_13` varchar(10) , 
     `Other Provider Identifier State_13` varchar(10) , 
     `Other Provider Identifier Issuer_13` varchar(10) , 
     `Other Provider Identifier_14` varchar(10) , 
     `Other Provider Identifier Type Code_14` varchar(10) , 
     `Other Provider Identifier State_14` varchar(10) , 
     `Other Provider Identifier Issuer_14` varchar(10) , 
     `Other Provider Identifier_15` varchar(10) , 
     `Other Provider Identifier Type Code_15` varchar(10) , 
     `Other Provider Identifier State_15` varchar(10) , 
     `Other Provider Identifier Issuer_15` varchar(10) , 
     `Other Provider Identifier_16` varchar(10) , 
     `Other Provider Identifier Type Code_16` varchar(10) , 
     `Other Provider Identifier State_16` varchar(10) , 
     `Other Provider Identifier Issuer_16` varchar(10) , 
     `Other Provider Identifier_17` varchar(10) , 
     `Other Provider Identifier Type Code_17` varchar(10) , 
     `Other Provider Identifier State_17` varchar(10) , 
     `Other Provider Identifier Issuer_17` varchar(10) , 
     `Other Provider Identifier_18` varchar(10) , 
     `Other Provider Identifier Type Code_18` varchar(10) , 
     `Other Provider Identifier State_18` varchar(10) , 
     `Other Provider Identifier Issuer_18` varchar(10) , 
     `Other Provider Identifier_19` varchar(10) , 
     `Other Provider Identifier Type Code_19` varchar(10) , 
     `Other Provider Identifier State_19` varchar(10) , 
     `Other Provider Identifier Issuer_19` varchar(10) , 
     `Other Provider Identifier_20` varchar(10) , 
     `Other Provider Identifier Type Code_20` varchar(10) , 
     `Other Provider Identifier State_20` varchar(10) , 
     `Other Provider Identifier Issuer_20` varchar(10) , 
     `Other Provider Identifier_21` varchar(10) , 
     `Other Provider Identifier Type Code_21` varchar(10) , 
     `Other Provider Identifier State_21` varchar(10) , 
     `Other Provider Identifier Issuer_21` varchar(10) , 
     `Other Provider Identifier_22` varchar(10) , 
     `Other Provider Identifier Type Code_22` varchar(10) , 
     `Other Provider Identifier State_22` varchar(10) , 
     `Other Provider Identifier Issuer_22` varchar(10) , 
     `Other Provider Identifier_23` varchar(10) , 
     `Other Provider Identifier Type Code_23` varchar(10) , 
     `Other Provider Identifier State_23` varchar(10) , 
     `Other Provider Identifier Issuer_23` varchar(10) , 
     `Other Provider Identifier_24` varchar(10) , 
     `Other Provider Identifier Type Code_24` varchar(10) , 
     `Other Provider Identifier State_24` varchar(10) , 
     `Other Provider Identifier Issuer_24` varchar(10) , 
     `Other Provider Identifier_25` varchar(10) , 
     `Other Provider Identifier Type Code_25` varchar(10) , 
     `Other Provider Identifier State_25` varchar(10) , 
     `Other Provider Identifier Issuer_25` varchar(10) , 
     `Other Provider Identifier_26` varchar(10) , 
     `Other Provider Identifier Type Code_26` varchar(10) , 
     `Other Provider Identifier State_26` varchar(10) , 
     `Other Provider Identifier Issuer_26` varchar(10) , 
     `Other Provider Identifier_27` varchar(10) , 
     `Other Provider Identifier Type Code_27` varchar(10) , 
     `Other Provider Identifier State_27` varchar(10) , 
     `Other Provider Identifier Issuer_27` varchar(10) , 
     `Other Provider Identifier_28` varchar(10) , 
     `Other Provider Identifier Type Code_28` varchar(10) , 
     `Other Provider Identifier State_28` varchar(10) , 
     `Other Provider Identifier Issuer_28` varchar(10) , 
     `Other Provider Identifier_29` varchar(10) , 
     `Other Provider Identifier Type Code_29` varchar(10) , 
     `Other Provider Identifier State_29` varchar(10) , 
     `Other Provider Identifier Issuer_29` varchar(10) , 
     `Other Provider Identifier_30` varchar(10) , 
     `Other Provider Identifier Type Code_30` varchar(10) , 
     `Other Provider Identifier State_30` varchar(10) , 
     `Other Provider Identifier Issuer_30` varchar(10) , 
     `Other Provider Identifier_31` varchar(10) , 
     `Other Provider Identifier Type Code_31` varchar(10) , 
     `Other Provider Identifier State_31` varchar(10) , 
     `Other Provider Identifier Issuer_31` varchar(10) , 
     `Other Provider Identifier_32` varchar(10) , 
     `Other Provider Identifier Type Code_32` varchar(10) , 
     `Other Provider Identifier State_32` varchar(10) , 
     `Other Provider Identifier Issuer_32` varchar(10) , 
     `Other Provider Identifier_33` varchar(10) , 
     `Other Provider Identifier Type Code_33` varchar(10) , 
     `Other Provider Identifier State_33` varchar(10) , 
     `Other Provider Identifier Issuer_33` varchar(10) , 
     `Other Provider Identifier_34` varchar(10) , 
     `Other Provider Identifier Type Code_34` varchar(10) , 
     `Other Provider Identifier State_34` varchar(10) , 
     `Other Provider Identifier Issuer_34` varchar(10) , 
     `Other Provider Identifier_35` varchar(10) , 
     `Other Provider Identifier Type Code_35` varchar(10) , 
     `Other Provider Identifier State_35` varchar(10) , 
     `Other Provider Identifier Issuer_35` varchar(10) , 
     `Other Provider Identifier_36` varchar(10) , 
     `Other Provider Identifier Type Code_36` varchar(10) , 
     `Other Provider Identifier State_36` varchar(10) , 
     `Other Provider Identifier Issuer_36` varchar(10) , 
     `Other Provider Identifier_37` varchar(10) , 
     `Other Provider Identifier Type Code_37` varchar(10) , 
     `Other Provider Identifier State_37` varchar(10) , 
     `Other Provider Identifier Issuer_37` varchar(10) , 
     `Other Provider Identifier_38` varchar(10) , 
     `Other Provider Identifier Type Code_38` varchar(10) , 
     `Other Provider Identifier State_38` varchar(10) , 
     `Other Provider Identifier Issuer_38` varchar(10) , 
     `Other Provider Identifier_39` varchar(10) , 
     `Other Provider Identifier Type Code_39` varchar(10) , 
     `Other Provider Identifier State_39` varchar(10) , 
     `Other Provider Identifier Issuer_39` varchar(10) , 
     `Other Provider Identifier_40` varchar(10) , 
     `Other Provider Identifier Type Code_40` varchar(10) , 
     `Other Provider Identifier State_40` varchar(10) , 
     `Other Provider Identifier Issuer_40` varchar(10) , 
     `Other Provider Identifier_41` varchar(10) , 
     `Other Provider Identifier Type Code_41` varchar(10) , 
     `Other Provider Identifier State_41` varchar(10) , 
     `Other Provider Identifier Issuer_41` varchar(10) , 
     `Other Provider Identifier_42` varchar(10) , 
     `Other Provider Identifier Type Code_42` varchar(10) , 
     `Other Provider Identifier State_42` varchar(10) , 
     `Other Provider Identifier Issuer_42` varchar(10) , 
     `Other Provider Identifier_43` varchar(10) , 
     `Other Provider Identifier Type Code_43` varchar(10) , 
     `Other Provider Identifier State_43` varchar(10) , 
     `Other Provider Identifier Issuer_43` varchar(10) , 
     `Other Provider Identifier_44` varchar(10) , 
     `Other Provider Identifier Type Code_44` varchar(10) , 
     `Other Provider Identifier State_44` varchar(10) , 
     `Other Provider Identifier Issuer_44` varchar(10) , 
     `Other Provider Identifier_45` varchar(10) , 
     `Other Provider Identifier Type Code_45` varchar(10) , 
     `Other Provider Identifier State_45` varchar(10) , 
     `Other Provider Identifier Issuer_45` varchar(10) , 
     `Other Provider Identifier_46` varchar(10) , 
     `Other Provider Identifier Type Code_46` varchar(10) , 
     `Other Provider Identifier State_46` varchar(10) , 
     `Other Provider Identifier Issuer_46` varchar(10) , 
     `Other Provider Identifier_47` varchar(10) , 
     `Other Provider Identifier Type Code_47` varchar(10) , 
     `Other Provider Identifier State_47` varchar(10) , 
     `Other Provider Identifier Issuer_47` varchar(10) , 
     `Other Provider Identifier_48` varchar(10) , 
     `Other Provider Identifier Type Code_48` varchar(10) , 
     `Other Provider Identifier State_48` varchar(10) , 
     `Other Provider Identifier Issuer_48` varchar(10) , 
     `Other Provider Identifier_49` varchar(10) , 
     `Other Provider Identifier Type Code_49` varchar(10) , 
     `Other Provider Identifier State_49` varchar(10) , 
     `Other Provider Identifier Issuer_49` varchar(10) , 
     `Other Provider Identifier_50` varchar(10) , 
     `Other Provider Identifier Type Code_50` varchar(10) , 
     `Other Provider Identifier State_50` varchar(10) , 
     `Other Provider Identifier Issuer_50` varchar(10) , 
     `Is Sole Proprietor` varchar(10) , 
     `Is Organization Subpart` varchar(10) , 
     `Parent Organization LBN` varchar(10) , 
     `Parent Organization TIN` varchar(10) , 
     `Authorized Official Name Prefix Text` varchar(10) , 
     `Authorized Official Name Suffix Text` varchar(10) , 
     `Authorized Official Credential Text` varchar(10) , 
     `Healthcare Provider Taxonomy Group_1` varchar(10) , 
     `Healthcare Provider Taxonomy Group_2` varchar(10) , 
     `Healthcare Provider Taxonomy Group_3` varchar(10) , 
     `Healthcare Provider Taxonomy Group_4` varchar(10) , 
     `Healthcare Provider Taxonomy Group_5` varchar(10) , 
     `Healthcare Provider Taxonomy Group_6` varchar(10) , 
     `Healthcare Provider Taxonomy Group_7` varchar(10) , 
     `Healthcare Provider Taxonomy Group_8` varchar(10) , 
     `Healthcare Provider Taxonomy Group_9` varchar(10) , 
     `Healthcare Provider Taxonomy Group_10` varchar(10) , 
     `Healthcare Provider Taxonomy Group_11` varchar(10) , 
     `Healthcare Provider Taxonomy Group_12` varchar(10) , 
     `Healthcare Provider Taxonomy Group_13` varchar(10) , 
     `Healthcare Provider Taxonomy Group_14` varchar(10) , 
     `Healthcare Provider Taxonomy Group_15` varchar(10)   
);

# insert into t('NPI','Entity') values('83471', 'alkkfdj'), ('183471', '2alkkfdj');
# insert into t values('hgljh83471', 'alkkfdj'), ('183471', '2alkkfdj');

load data local  
  infile 'first1e4.csv'
  into table t  FIELDS TERMINATED by ','
  enclosed by '"'
  lines terminated by '\n'
  (
     `NPI` , 
     `Entity` ,
     `Replacement NPI`,
     `Employer Identification Number (EIN)` , 
     `Provider Organization Name (Legal Business Name)` , 
     `Provider Last Name (Legal Name)` , 
     `Provider First Name` , 
     `Provider Middle Name` , 
     `Provider Name Prefix Text` , 
     `Provider Name Suffix Text` , 
     `Provider Credential Text` , 
     `Provider Other Organization Name` , 
     `Provider Other Organization Name Type Code` , 
     `Provider Other Last Name` , 
     `Provider Other First Name` , 
     `Provider Other Middle Name` , 
     `Provider Other Name Prefix Text` , 
     `Provider Other Name Suffix Text` , 
     `Provider Other Credential Text` , 
     `Provider Other Last Name Type Code` , 
     `Provider First Line Business Mailing Address` , 
     `Provider Second Line Business Mailing Address` , 
     `Provider Business Mailing Address City Name` , 
     `Provider Business Mailing Address State Name` , 
     `Provider Business Mailing Address Postal Code` , 
     `pbmacc (If outside U.S.)` , 
     `Provider Business Mailing Address Telephone Number` , 
     `Provider Business Mailing Address Fax Number` , 
     `Provider First Line Business Practice Location Address` , 
     `Provider Second Line Business Practice Location Address` , 
     `Provider Business Practice Location Address City Name` , 
     `Provider Business Practice Location Address State Name` , 
     `Provider Business Practice Location Address Postal Code` , 
     `pbmacc2 (If outside U.S.)` , 
     `Provider Business Practice Location Address Telephone Number` , 
     `Provider Business Practice Location Address Fax Number` , 
     `Provider Enumeration Date` , 
     `Last Update Date` , 
     `NPI Deactivation Reason Code` , 
     `NPI Deactivation Date` , 
     `NPI Reactivation Date` , 
     `Provider Gender Code` , 
     `Authorized Official Last Name` , 
     `Authorized Official First Name` , 
     `Authorized Official Middle Name` , 
     `Authorized Official Title or Position` , 
     `Authorized Official Telephone Number` , 
     `Healthcare Provider Taxonomy Code_1` , 
     `Provider License Number_1` , 
     `Provider License Number State Code_1` , 
     `Healthcare Provider Primary Taxonomy Switch_1` , 
     `Healthcare Provider Taxonomy Code_2` , 
     `Provider License Number_2` , 
     `Provider License Number State Code_2` , 
     `Healthcare Provider Primary Taxonomy Switch_2` , 
     `Healthcare Provider Taxonomy Code_3` , 
     `Provider License Number_3` , 
     `Provider License Number State Code_3` , 
     `Healthcare Provider Primary Taxonomy Switch_3` , 
     `Healthcare Provider Taxonomy Code_4` , 
     `Provider License Number_4` , 
     `Provider License Number State Code_4` , 
     `Healthcare Provider Primary Taxonomy Switch_4` , 
     `Healthcare Provider Taxonomy Code_5` , 
     `Provider License Number_5` , 
     `Provider License Number State Code_5` , 
     `Healthcare Provider Primary Taxonomy Switch_5` , 
     `Healthcare Provider Taxonomy Code_6` , 
     `Provider License Number_6` , 
     `Provider License Number State Code_6` , 
     `Healthcare Provider Primary Taxonomy Switch_6` , 
     `Healthcare Provider Taxonomy Code_7` , 
     `Provider License Number_7` , 
     `Provider License Number State Code_7` , 
     `Healthcare Provider Primary Taxonomy Switch_7` , 
     `Healthcare Provider Taxonomy Code_8` , 
     `Provider License Number_8` , 
     `Provider License Number State Code_8` , 
     `Healthcare Provider Primary Taxonomy Switch_8` , 
     `Healthcare Provider Taxonomy Code_9` , 
     `Provider License Number_9` , 
     `Provider License Number State Code_9` , 
     `Healthcare Provider Primary Taxonomy Switch_9` , 
     `Healthcare Provider Taxonomy Code_10` , 
     `Provider License Number_10` , 
     `Provider License Number State Code_10` , 
     `Healthcare Provider Primary Taxonomy Switch_10` , 
     `Healthcare Provider Taxonomy Code_11` , 
     `Provider License Number_11` , 
     `Provider License Number State Code_11` , 
     `Healthcare Provider Primary Taxonomy Switch_11` , 
     `Healthcare Provider Taxonomy Code_12` , 
     `Provider License Number_12` , 
     `Provider License Number State Code_12` , 
     `Healthcare Provider Primary Taxonomy Switch_12` , 
     `Healthcare Provider Taxonomy Code_13` , 
     `Provider License Number_13` , 
     `Provider License Number State Code_13` , 
     `Healthcare Provider Primary Taxonomy Switch_13` , 
     `Healthcare Provider Taxonomy Code_14` , 
     `Provider License Number_14` , 
     `Provider License Number State Code_14` , 
     `Healthcare Provider Primary Taxonomy Switch_14` , 
     `Healthcare Provider Taxonomy Code_15` , 
     `Provider License Number_15` , 
     `Provider License Number State Code_15` , 
     `Healthcare Provider Primary Taxonomy Switch_15` , 
     `Other Provider Identifier_1` , 
     `Other Provider Identifier Type Code_1` , 
     `Other Provider Identifier State_1` , 
     `Other Provider Identifier Issuer_1` , 
     `Other Provider Identifier_2` , 
     `Other Provider Identifier Type Code_2` , 
     `Other Provider Identifier State_2` , 
     `Other Provider Identifier Issuer_2` , 
     `Other Provider Identifier_3` , 
     `Other Provider Identifier Type Code_3` , 
     `Other Provider Identifier State_3` , 
     `Other Provider Identifier Issuer_3` , 
     `Other Provider Identifier_4` , 
     `Other Provider Identifier Type Code_4` , 
     `Other Provider Identifier State_4` , 
     `Other Provider Identifier Issuer_4` , 
     `Other Provider Identifier_5` , 
     `Other Provider Identifier Type Code_5` , 
     `Other Provider Identifier State_5` , 
     `Other Provider Identifier Issuer_5` , 
     `Other Provider Identifier_6` , 
     `Other Provider Identifier Type Code_6` , 
     `Other Provider Identifier State_6` , 
     `Other Provider Identifier Issuer_6` , 
     `Other Provider Identifier_7` , 
     `Other Provider Identifier Type Code_7` , 
     `Other Provider Identifier State_7` , 
     `Other Provider Identifier Issuer_7` , 
     `Other Provider Identifier_8` , 
     `Other Provider Identifier Type Code_8` , 
     `Other Provider Identifier State_8` , 
     `Other Provider Identifier Issuer_8` , 
     `Other Provider Identifier_9` , 
     `Other Provider Identifier Type Code_9` , 
     `Other Provider Identifier State_9` , 
     `Other Provider Identifier Issuer_9` , 
     `Other Provider Identifier_10` , 
     `Other Provider Identifier Type Code_10` , 
     `Other Provider Identifier State_10` , 
     `Other Provider Identifier Issuer_10` , 
     `Other Provider Identifier_11` , 
     `Other Provider Identifier Type Code_11` , 
     `Other Provider Identifier State_11` , 
     `Other Provider Identifier Issuer_11` , 
     `Other Provider Identifier_12` , 
     `Other Provider Identifier Type Code_12` , 
     `Other Provider Identifier State_12` , 
     `Other Provider Identifier Issuer_12` , 
     `Other Provider Identifier_13` , 
     `Other Provider Identifier Type Code_13` , 
     `Other Provider Identifier State_13` , 
     `Other Provider Identifier Issuer_13` , 
     `Other Provider Identifier_14` , 
     `Other Provider Identifier Type Code_14` , 
     `Other Provider Identifier State_14` , 
     `Other Provider Identifier Issuer_14` , 
     `Other Provider Identifier_15` , 
     `Other Provider Identifier Type Code_15` , 
     `Other Provider Identifier State_15` , 
     `Other Provider Identifier Issuer_15` , 
     `Other Provider Identifier_16` , 
     `Other Provider Identifier Type Code_16` , 
     `Other Provider Identifier State_16` , 
     `Other Provider Identifier Issuer_16` , 
     `Other Provider Identifier_17` , 
     `Other Provider Identifier Type Code_17` , 
     `Other Provider Identifier State_17` , 
     `Other Provider Identifier Issuer_17` , 
     `Other Provider Identifier_18` , 
     `Other Provider Identifier Type Code_18` , 
     `Other Provider Identifier State_18` , 
     `Other Provider Identifier Issuer_18` , 
     `Other Provider Identifier_19` , 
     `Other Provider Identifier Type Code_19` , 
     `Other Provider Identifier State_19` , 
     `Other Provider Identifier Issuer_19` , 
     `Other Provider Identifier_20` , 
     `Other Provider Identifier Type Code_20` , 
     `Other Provider Identifier State_20` , 
     `Other Provider Identifier Issuer_20` , 
     `Other Provider Identifier_21` , 
     `Other Provider Identifier Type Code_21` , 
     `Other Provider Identifier State_21` , 
     `Other Provider Identifier Issuer_21` , 
     `Other Provider Identifier_22` , 
     `Other Provider Identifier Type Code_22` , 
     `Other Provider Identifier State_22` , 
     `Other Provider Identifier Issuer_22` , 
     `Other Provider Identifier_23` , 
     `Other Provider Identifier Type Code_23` , 
     `Other Provider Identifier State_23` , 
     `Other Provider Identifier Issuer_23` , 
     `Other Provider Identifier_24` , 
     `Other Provider Identifier Type Code_24` , 
     `Other Provider Identifier State_24` , 
     `Other Provider Identifier Issuer_24` , 
     `Other Provider Identifier_25` , 
     `Other Provider Identifier Type Code_25` , 
     `Other Provider Identifier State_25` , 
     `Other Provider Identifier Issuer_25` , 
     `Other Provider Identifier_26` , 
     `Other Provider Identifier Type Code_26` , 
     `Other Provider Identifier State_26` , 
     `Other Provider Identifier Issuer_26` , 
     `Other Provider Identifier_27` , 
     `Other Provider Identifier Type Code_27` , 
     `Other Provider Identifier State_27` , 
     `Other Provider Identifier Issuer_27` , 
     `Other Provider Identifier_28` , 
     `Other Provider Identifier Type Code_28` , 
     `Other Provider Identifier State_28` , 
     `Other Provider Identifier Issuer_28` , 
     `Other Provider Identifier_29` , 
     `Other Provider Identifier Type Code_29` , 
     `Other Provider Identifier State_29` , 
     `Other Provider Identifier Issuer_29` , 
     `Other Provider Identifier_30` , 
     `Other Provider Identifier Type Code_30` , 
     `Other Provider Identifier State_30` , 
     `Other Provider Identifier Issuer_30` , 
     `Other Provider Identifier_31` , 
     `Other Provider Identifier Type Code_31` , 
     `Other Provider Identifier State_31` , 
     `Other Provider Identifier Issuer_31` , 
     `Other Provider Identifier_32` , 
     `Other Provider Identifier Type Code_32` , 
     `Other Provider Identifier State_32` , 
     `Other Provider Identifier Issuer_32` , 
     `Other Provider Identifier_33` , 
     `Other Provider Identifier Type Code_33` , 
     `Other Provider Identifier State_33` , 
     `Other Provider Identifier Issuer_33` , 
     `Other Provider Identifier_34` , 
     `Other Provider Identifier Type Code_34` , 
     `Other Provider Identifier State_34` , 
     `Other Provider Identifier Issuer_34` , 
     `Other Provider Identifier_35` , 
     `Other Provider Identifier Type Code_35` , 
     `Other Provider Identifier State_35` , 
     `Other Provider Identifier Issuer_35` , 
     `Other Provider Identifier_36` , 
     `Other Provider Identifier Type Code_36` , 
     `Other Provider Identifier State_36` , 
     `Other Provider Identifier Issuer_36` , 
     `Other Provider Identifier_37` , 
     `Other Provider Identifier Type Code_37` , 
     `Other Provider Identifier State_37` , 
     `Other Provider Identifier Issuer_37` , 
     `Other Provider Identifier_38` , 
     `Other Provider Identifier Type Code_38` , 
     `Other Provider Identifier State_38` , 
     `Other Provider Identifier Issuer_38` , 
     `Other Provider Identifier_39` , 
     `Other Provider Identifier Type Code_39` , 
     `Other Provider Identifier State_39` , 
     `Other Provider Identifier Issuer_39` , 
     `Other Provider Identifier_40` , 
     `Other Provider Identifier Type Code_40` , 
     `Other Provider Identifier State_40` , 
     `Other Provider Identifier Issuer_40` , 
     `Other Provider Identifier_41` , 
     `Other Provider Identifier Type Code_41` , 
     `Other Provider Identifier State_41` , 
     `Other Provider Identifier Issuer_41` , 
     `Other Provider Identifier_42` , 
     `Other Provider Identifier Type Code_42` , 
     `Other Provider Identifier State_42` , 
     `Other Provider Identifier Issuer_42` , 
     `Other Provider Identifier_43` , 
     `Other Provider Identifier Type Code_43` , 
     `Other Provider Identifier State_43` , 
     `Other Provider Identifier Issuer_43` , 
     `Other Provider Identifier_44` , 
     `Other Provider Identifier Type Code_44` , 
     `Other Provider Identifier State_44` , 
     `Other Provider Identifier Issuer_44` , 
     `Other Provider Identifier_45` , 
     `Other Provider Identifier Type Code_45` , 
     `Other Provider Identifier State_45` , 
     `Other Provider Identifier Issuer_45` , 
     `Other Provider Identifier_46` , 
     `Other Provider Identifier Type Code_46` , 
     `Other Provider Identifier State_46` , 
     `Other Provider Identifier Issuer_46` , 
     `Other Provider Identifier_47` , 
     `Other Provider Identifier Type Code_47` , 
     `Other Provider Identifier State_47` , 
     `Other Provider Identifier Issuer_47` , 
     `Other Provider Identifier_48` , 
     `Other Provider Identifier Type Code_48` , 
     `Other Provider Identifier State_48` , 
     `Other Provider Identifier Issuer_48` , 
     `Other Provider Identifier_49` , 
     `Other Provider Identifier Type Code_49` , 
     `Other Provider Identifier State_49` , 
     `Other Provider Identifier Issuer_49` , 
     `Other Provider Identifier_50` , 
     `Other Provider Identifier Type Code_50` , 
     `Other Provider Identifier State_50` , 
     `Other Provider Identifier Issuer_50` , 
     `Is Sole Proprietor` , 
     `Is Organization Subpart` , 
     `Parent Organization LBN` , 
     `Parent Organization TIN` , 
     `Authorized Official Name Prefix Text` , 
     `Authorized Official Name Suffix Text` , 
     `Authorized Official Credential Text` , 
     `Healthcare Provider Taxonomy Group_1` , 
     `Healthcare Provider Taxonomy Group_2` , 
     `Healthcare Provider Taxonomy Group_3` , 
     `Healthcare Provider Taxonomy Group_4` , 
     `Healthcare Provider Taxonomy Group_5` , 
     `Healthcare Provider Taxonomy Group_6` , 
     `Healthcare Provider Taxonomy Group_7` , 
     `Healthcare Provider Taxonomy Group_8` , 
     `Healthcare Provider Taxonomy Group_9` , 
     `Healthcare Provider Taxonomy Group_10` , 
     `Healthcare Provider Taxonomy Group_11` , 
     `Healthcare Provider Taxonomy Group_12` , 
     `Healthcare Provider Taxonomy Group_13` , 
     `Healthcare Provider Taxonomy Group_14` , 
     `Healthcare Provider Taxonomy Group_15`
);

# Example
 select `NPI` from t LIMIT 10;