API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 10th, 2016
85
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 179.06 KB | None | 0 0
raw download clone embed print report
  1. {
  2. "cells": [
  3. {
  4. "cell_type": "code",
  5. "execution_count": 4,
  6. "metadata": {
  7. "collapsed": false
  8. },
  9. "outputs": [
  10. {
  11. "data": {
  12. "text/plain": [
  13. "'\"npi\",\"entity_type_code\",\"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\",\"provider_business_mailing_address_country_code_if_outside_us\",\"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\",\"provider_business_practice_location_address_country_code_if_outside_us\",\"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\"'"
  14. ]
  15. },
  16. "execution_count": 4,
  17. "metadata": {},
  18. "output_type": "execute_result"
  19. }
  20. ],
  21. "source": [
  22. "headers = [\n",
  23. " \"NPI\", # \"NPI\",\n",
  24. " \"Entity Type Code\", # \"Entity Type Code\",\n",
  25. " \"Replacement NPI\", # \"Replacement NPI\",\n",
  26. " \"Employer Identification Number (EIN)\", # \"Employer Identification Number (EIN)\",\n",
  27. " \"Provider Organization Name (Legal Business Name)\", # \"Provider Organization Name (Legal Business Name)\",\n",
  28. " \"Provider Last Name (Legal Name)\", # \"Provider Last Name (Legal Name)\",\n",
  29. " \"Provider First Name\", # \"Provider First Name\",\n",
  30. " \"Provider Middle Name\", # \"Provider Middle Name\",\n",
  31. " \"Provider Name Prefix Text\", # \"Provider Name Prefix Text\",\n",
  32. " \"Provider Name Suffix Text\", # \"Provider Name Suffix Text\",\n",
  33. " \"Provider Credential Text\", # \"Provider Credential Text\",\n",
  34. " \"Provider Other Organization Name\", # \"Provider Other Organization Name\",\n",
  35. " \"Provider Other Organization Name Type Code\", # \"Provider Other Organization Name Type Code\",\n",
  36. " \"Provider Other Last Name\", # \"Provider Other Last Name\",\n",
  37. " \"Provider Other First Name\", # \"Provider Other First Name\",\n",
  38. " \"Provider Other Middle Name\", # \"Provider Other Middle Name\",\n",
  39. " \"Provider Other Name Prefix Text\", # \"Provider Other Name Prefix Text\",\n",
  40. " \"Provider Other Name Suffix Text\", # \"Provider Other Name Suffix Text\",\n",
  41. " \"Provider Other Credential Text\", # \"Provider Other Credential Text\",\n",
  42. " \"Provider Other Last Name Type Code\", # \"Provider Other Last Name Type Code\",\n",
  43. " \"Provider First Line Business Mailing Address\", # \"Provider First Line Business Mailing Address\",\n",
  44. " \"Provider Second Line Business Mailing Address\", # \"Provider Second Line Business Mailing Address\",\n",
  45. " \"Provider Business Mailing Address City Name\", # \"Provider Business Mailing Address City Name\",\n",
  46. " \"Provider Business Mailing Address State Name\", # \"Provider Business Mailing Address State Name\",\n",
  47. " \"Provider Business Mailing Address Postal Code\", # \"Provider Business Mailing Address Postal Code\",\n",
  48. " \"Provider Business Mailing Address Country Code (If outside U.S.)\", # \"Provider Business Mailing Address Country Code (If outside U.S.)\",\n",
  49. " \"Provider Business Mailing Address Telephone Number\", # \"Provider Business Mailing Address Telephone Number\",\n",
  50. " \"Provider Business Mailing Address Fax Number\", # \"Provider Business Mailing Address Fax Number\",\n",
  51. " \"Provider First Line Business Practice Location Address\", # \"Provider First Line Business Practice Location Address\",\n",
  52. " \"Provider Second Line Business Practice Location Address\", # \"Provider Second Line Business Practice Location Address\",\n",
  53. " \"Provider Business Practice Location Address City Name\", # \"Provider Business Practice Location Address City Name\",\n",
  54. " \"Provider Business Practice Location Address State Name\", # \"Provider Business Practice Location Address State Name\",\n",
  55. " \"Provider Business Practice Location Address Postal Code\", # \"Provider Business Practice Location Address Postal Code\",\n",
  56. " \"Provider Business Practice Location Address Country Code (If outside U.S.)\", # \"Provider Business Practice Location Address Country Code (If outside U.S.)\",\n",
  57. " \"Provider Business Practice Location Address Telephone Number\", # \"Provider Business Practice Location Address Telephone Number\",\n",
  58. " \"Provider Business Practice Location Address Fax Number\", # \"Provider Business Practice Location Address Fax Number\",\n",
  59. " \"Provider Enumeration Date\", # \"Provider Enumeration Date\",\n",
  60. " \"Last Update Date\", # \"Last Update Date\",\n",
  61. " \"NPI Deactivation Reason Code\", # \"NPI Deactivation Reason Code\",\n",
  62. " \"NPI Deactivation Date\", # \"NPI Deactivation Date\",\n",
  63. " \"NPI Reactivation Date\", # \"NPI Reactivation Date\",\n",
  64. " \"Provider Gender Code\", # \"Provider Gender Code\",\n",
  65. " \"Authorized Official Last Name\", # \"Authorized Official Last Name\",\n",
  66. " \"Authorized Official First Name\", # \"Authorized Official First Name\",\n",
  67. " \"Authorized Official Middle Name\", # \"Authorized Official Middle Name\",\n",
  68. " \"Authorized Official Title or Position\", # \"Authorized Official Title or Position\",\n",
  69. " \"Authorized Official Telephone Number\", # \"Authorized Official Telephone Number\",\n",
  70. " \"Healthcare Provider Taxonomy Code_1\", # \"Healthcare Provider Taxonomy Code_1\",\n",
  71. " \"Provider License Number_1\", # \"Provider License Number_1\",\n",
  72. " \"Provider License Number State Code_1\", # \"Provider License Number State Code_1\",\n",
  73. " \"Healthcare Provider Primary Taxonomy Switch_1\", # \"Healthcare Provider Primary Taxonomy Switch_1\",\n",
  74. " \"Healthcare Provider Taxonomy Code_2\", # \"Healthcare Provider Taxonomy Code_2\",\n",
  75. " \"Provider License Number_2\", # \"Provider License Number_2\",\n",
  76. " \"Provider License Number State Code_2\", # \"Provider License Number State Code_2\",\n",
  77. " \"Healthcare Provider Primary Taxonomy Switch_2\", # \"Healthcare Provider Primary Taxonomy Switch_2\",\n",
  78. " \"Healthcare Provider Taxonomy Code_3\", # \"Healthcare Provider Taxonomy Code_3\",\n",
  79. " \"Provider License Number_3\", # \"Provider License Number_3\",\n",
  80. " \"Provider License Number State Code_3\", # \"Provider License Number State Code_3\",\n",
  81. " \"Healthcare Provider Primary Taxonomy Switch_3\", # \"Healthcare Provider Primary Taxonomy Switch_3\",\n",
  82. " \"Healthcare Provider Taxonomy Code_4\", # \"Healthcare Provider Taxonomy Code_4\",\n",
  83. " \"Provider License Number_4\", # \"Provider License Number_4\",\n",
  84. " \"Provider License Number State Code_4\", # \"Provider License Number State Code_4\",\n",
  85. " \"Healthcare Provider Primary Taxonomy Switch_4\", # \"Healthcare Provider Primary Taxonomy Switch_4\",\n",
  86. " \"Healthcare Provider Taxonomy Code_5\", # \"Healthcare Provider Taxonomy Code_5\",\n",
  87. " \"Provider License Number_5\", # \"Provider License Number_5\",\n",
  88. " \"Provider License Number State Code_5\", # \"Provider License Number State Code_5\",\n",
  89. " \"Healthcare Provider Primary Taxonomy Switch_5\", # \"Healthcare Provider Primary Taxonomy Switch_5\",\n",
  90. " \"Healthcare Provider Taxonomy Code_6\", # \"Healthcare Provider Taxonomy Code_6\",\n",
  91. " \"Provider License Number_6\", # \"Provider License Number_6\",\n",
  92. " \"Provider License Number State Code_6\", # \"Provider License Number State Code_6\",\n",
  93. " \"Healthcare Provider Primary Taxonomy Switch_6\", # \"Healthcare Provider Primary Taxonomy Switch_6\",\n",
  94. " \"Healthcare Provider Taxonomy Code_7\", # \"Healthcare Provider Taxonomy Code_7\",\n",
  95. " \"Provider License Number_7\", # \"Provider License Number_7\",\n",
  96. " \"Provider License Number State Code_7\", # \"Provider License Number State Code_7\",\n",
  97. " \"Healthcare Provider Primary Taxonomy Switch_7\", # \"Healthcare Provider Primary Taxonomy Switch_7\",\n",
  98. " \"Healthcare Provider Taxonomy Code_8\", # \"Healthcare Provider Taxonomy Code_8\",\n",
  99. " \"Provider License Number_8\", # \"Provider License Number_8\",\n",
  100. " \"Provider License Number State Code_8\", # \"Provider License Number State Code_8\",\n",
  101. " \"Healthcare Provider Primary Taxonomy Switch_8\", # \"Healthcare Provider Primary Taxonomy Switch_8\",\n",
  102. " \"Healthcare Provider Taxonomy Code_9\", # \"Healthcare Provider Taxonomy Code_9\",\n",
  103. " \"Provider License Number_9\", # \"Provider License Number_9\",\n",
  104. " \"Provider License Number State Code_9\", # \"Provider License Number State Code_9\",\n",
  105. " \"Healthcare Provider Primary Taxonomy Switch_9\", # \"Healthcare Provider Primary Taxonomy Switch_9\",\n",
  106. " \"Healthcare Provider Taxonomy Code_10\", # \"Healthcare Provider Taxonomy Code_10\",\n",
  107. " \"Provider License Number_10\", # \"Provider License Number_10\",\n",
  108. " \"Provider License Number State Code_10\", # \"Provider License Number State Code_10\",\n",
  109. " \"Healthcare Provider Primary Taxonomy Switch_10\", # \"Healthcare Provider Primary Taxonomy Switch_10\",\n",
  110. " \"Healthcare Provider Taxonomy Code_11\", # \"Healthcare Provider Taxonomy Code_11\",\n",
  111. " \"Provider License Number_11\", # \"Provider License Number_11\",\n",
  112. " \"Provider License Number State Code_11\", # \"Provider License Number State Code_11\",\n",
  113. " \"Healthcare Provider Primary Taxonomy Switch_11\", # \"Healthcare Provider Primary Taxonomy Switch_11\",\n",
  114. " \"Healthcare Provider Taxonomy Code_12\", # \"Healthcare Provider Taxonomy Code_12\",\n",
  115. " \"Provider License Number_12\", # \"Provider License Number_12\",\n",
  116. " \"Provider License Number State Code_12\", # \"Provider License Number State Code_12\",\n",
  117. " \"Healthcare Provider Primary Taxonomy Switch_12\", # \"Healthcare Provider Primary Taxonomy Switch_12\",\n",
  118. " \"Healthcare Provider Taxonomy Code_13\", # \"Healthcare Provider Taxonomy Code_13\",\n",
  119. " \"Provider License Number_13\", # \"Provider License Number_13\",\n",
  120. " \"Provider License Number State Code_13\", # \"Provider License Number State Code_13\",\n",
  121. " \"Healthcare Provider Primary Taxonomy Switch_13\", # \"Healthcare Provider Primary Taxonomy Switch_13\",\n",
  122. " \"Healthcare Provider Taxonomy Code_14\", # \"Healthcare Provider Taxonomy Code_14\",\n",
  123. " \"Provider License Number_14\", # \"Provider License Number_14\",\n",
  124. " \"Provider License Number State Code_14\", # \"Provider License Number State Code_14\",\n",
  125. " \"Healthcare Provider Primary Taxonomy Switch_14\", # \"Healthcare Provider Primary Taxonomy Switch_14\",\n",
  126. " \"Healthcare Provider Taxonomy Code_15\", # \"Healthcare Provider Taxonomy Code_15\",\n",
  127. " \"Provider License Number_15\", # \"Provider License Number_15\",\n",
  128. " \"Provider License Number State Code_15\", # \"Provider License Number State Code_15\",\n",
  129. " \"Healthcare Provider Primary Taxonomy Switch_15\", # \"Healthcare Provider Primary Taxonomy Switch_15\",\n",
  130. " \"Other Provider Identifier_1\", # \"Other Provider Identifier_1\",\n",
  131. " \"Other Provider Identifier Type Code_1\", # \"Other Provider Identifier Type Code_1\",\n",
  132. " \"Other Provider Identifier State_1\", # \"Other Provider Identifier State_1\",\n",
  133. " \"Other Provider Identifier Issuer_1\", # \"Other Provider Identifier Issuer_1\",\n",
  134. " \"Other Provider Identifier_2\", # \"Other Provider Identifier_2\",\n",
  135. " \"Other Provider Identifier Type Code_2\", # \"Other Provider Identifier Type Code_2\",\n",
  136. " \"Other Provider Identifier State_2\", # \"Other Provider Identifier State_2\",\n",
  137. " \"Other Provider Identifier Issuer_2\", # \"Other Provider Identifier Issuer_2\",\n",
  138. " \"Other Provider Identifier_3\", # \"Other Provider Identifier_3\",\n",
  139. " \"Other Provider Identifier Type Code_3\", # \"Other Provider Identifier Type Code_3\",\n",
  140. " \"Other Provider Identifier State_3\", # \"Other Provider Identifier State_3\",\n",
  141. " \"Other Provider Identifier Issuer_3\", # \"Other Provider Identifier Issuer_3\",\n",
  142. " \"Other Provider Identifier_4\", # \"Other Provider Identifier_4\",\n",
  143. " \"Other Provider Identifier Type Code_4\", # \"Other Provider Identifier Type Code_4\",\n",
  144. " \"Other Provider Identifier State_4\", # \"Other Provider Identifier State_4\",\n",
  145. " \"Other Provider Identifier Issuer_4\", # \"Other Provider Identifier Issuer_4\",\n",
  146. " \"Other Provider Identifier_5\", # \"Other Provider Identifier_5\",\n",
  147. " \"Other Provider Identifier Type Code_5\", # \"Other Provider Identifier Type Code_5\",\n",
  148. " \"Other Provider Identifier State_5\", # \"Other Provider Identifier State_5\",\n",
  149. " \"Other Provider Identifier Issuer_5\", # \"Other Provider Identifier Issuer_5\",\n",
  150. " \"Other Provider Identifier_6\", # \"Other Provider Identifier_6\",\n",
  151. " \"Other Provider Identifier Type Code_6\", # \"Other Provider Identifier Type Code_6\",\n",
  152. " \"Other Provider Identifier State_6\", # \"Other Provider Identifier State_6\",\n",
  153. " \"Other Provider Identifier Issuer_6\", # \"Other Provider Identifier Issuer_6\",\n",
  154. " \"Other Provider Identifier_7\", # \"Other Provider Identifier_7\",\n",
  155. " \"Other Provider Identifier Type Code_7\", # \"Other Provider Identifier Type Code_7\",\n",
  156. " \"Other Provider Identifier State_7\", # \"Other Provider Identifier State_7\",\n",
  157. " \"Other Provider Identifier Issuer_7\", # \"Other Provider Identifier Issuer_7\",\n",
  158. " \"Other Provider Identifier_8\", # \"Other Provider Identifier_8\",\n",
  159. " \"Other Provider Identifier Type Code_8\", # \"Other Provider Identifier Type Code_8\",\n",
  160. " \"Other Provider Identifier State_8\", # \"Other Provider Identifier State_8\",\n",
  161. " \"Other Provider Identifier Issuer_8\", # \"Other Provider Identifier Issuer_8\",\n",
  162. " \"Other Provider Identifier_9\", # \"Other Provider Identifier_9\",\n",
  163. " \"Other Provider Identifier Type Code_9\", # \"Other Provider Identifier Type Code_9\",\n",
  164. " \"Other Provider Identifier State_9\", # \"Other Provider Identifier State_9\",\n",
  165. " \"Other Provider Identifier Issuer_9\", # \"Other Provider Identifier Issuer_9\",\n",
  166. " \"Other Provider Identifier_10\", # \"Other Provider Identifier_10\",\n",
  167. " \"Other Provider Identifier Type Code_10\", # \"Other Provider Identifier Type Code_10\",\n",
  168. " \"Other Provider Identifier State_10\", # \"Other Provider Identifier State_10\",\n",
  169. " \"Other Provider Identifier Issuer_10\", # \"Other Provider Identifier Issuer_10\",\n",
  170. " \"Other Provider Identifier_11\", # \"Other Provider Identifier_11\",\n",
  171. " \"Other Provider Identifier Type Code_11\", # \"Other Provider Identifier Type Code_11\",\n",
  172. " \"Other Provider Identifier State_11\", # \"Other Provider Identifier State_11\",\n",
  173. " \"Other Provider Identifier Issuer_11\", # \"Other Provider Identifier Issuer_11\",\n",
  174. " \"Other Provider Identifier_12\", # \"Other Provider Identifier_12\",\n",
  175. " \"Other Provider Identifier Type Code_12\", # \"Other Provider Identifier Type Code_12\",\n",
  176. " \"Other Provider Identifier State_12\", # \"Other Provider Identifier State_12\",\n",
  177. " \"Other Provider Identifier Issuer_12\", # \"Other Provider Identifier Issuer_12\",\n",
  178. " \"Other Provider Identifier_13\", # \"Other Provider Identifier_13\",\n",
  179. " \"Other Provider Identifier Type Code_13\", # \"Other Provider Identifier Type Code_13\",\n",
  180. " \"Other Provider Identifier State_13\", # \"Other Provider Identifier State_13\",\n",
  181. " \"Other Provider Identifier Issuer_13\", # \"Other Provider Identifier Issuer_13\",\n",
  182. " \"Other Provider Identifier_14\", # \"Other Provider Identifier_14\",\n",
  183. " \"Other Provider Identifier Type Code_14\", # \"Other Provider Identifier Type Code_14\",\n",
  184. " \"Other Provider Identifier State_14\", # \"Other Provider Identifier State_14\",\n",
  185. " \"Other Provider Identifier Issuer_14\", # \"Other Provider Identifier Issuer_14\",\n",
  186. " \"Other Provider Identifier_15\", # \"Other Provider Identifier_15\",\n",
  187. " \"Other Provider Identifier Type Code_15\", # \"Other Provider Identifier Type Code_15\",\n",
  188. " \"Other Provider Identifier State_15\", # \"Other Provider Identifier State_15\",\n",
  189. " \"Other Provider Identifier Issuer_15\", # \"Other Provider Identifier Issuer_15\",\n",
  190. " \"Other Provider Identifier_16\", # \"Other Provider Identifier_16\",\n",
  191. " \"Other Provider Identifier Type Code_16\", # \"Other Provider Identifier Type Code_16\",\n",
  192. " \"Other Provider Identifier State_16\", # \"Other Provider Identifier State_16\",\n",
  193. " \"Other Provider Identifier Issuer_16\", # \"Other Provider Identifier Issuer_16\",\n",
  194. " \"Other Provider Identifier_17\", # \"Other Provider Identifier_17\",\n",
  195. " \"Other Provider Identifier Type Code_17\", # \"Other Provider Identifier Type Code_17\",\n",
  196. " \"Other Provider Identifier State_17\", # \"Other Provider Identifier State_17\",\n",
  197. " \"Other Provider Identifier Issuer_17\", # \"Other Provider Identifier Issuer_17\",\n",
  198. " \"Other Provider Identifier_18\", # \"Other Provider Identifier_18\",\n",
  199. " \"Other Provider Identifier Type Code_18\", # \"Other Provider Identifier Type Code_18\",\n",
  200. " \"Other Provider Identifier State_18\", # \"Other Provider Identifier State_18\",\n",
  201. " \"Other Provider Identifier Issuer_18\", # \"Other Provider Identifier Issuer_18\",\n",
  202. " \"Other Provider Identifier_19\", # \"Other Provider Identifier_19\",\n",
  203. " \"Other Provider Identifier Type Code_19\", # \"Other Provider Identifier Type Code_19\",\n",
  204. " \"Other Provider Identifier State_19\", # \"Other Provider Identifier State_19\",\n",
  205. " \"Other Provider Identifier Issuer_19\", # \"Other Provider Identifier Issuer_19\",\n",
  206. " \"Other Provider Identifier_20\", # \"Other Provider Identifier_20\",\n",
  207. " \"Other Provider Identifier Type Code_20\", # \"Other Provider Identifier Type Code_20\",\n",
  208. " \"Other Provider Identifier State_20\", # \"Other Provider Identifier State_20\",\n",
  209. " \"Other Provider Identifier Issuer_20\", # \"Other Provider Identifier Issuer_20\",\n",
  210. " \"Other Provider Identifier_21\", # \"Other Provider Identifier_21\",\n",
  211. " \"Other Provider Identifier Type Code_21\", # \"Other Provider Identifier Type Code_21\",\n",
  212. " \"Other Provider Identifier State_21\", # \"Other Provider Identifier State_21\",\n",
  213. " \"Other Provider Identifier Issuer_21\", # \"Other Provider Identifier Issuer_21\",\n",
  214. " \"Other Provider Identifier_22\", # \"Other Provider Identifier_22\",\n",
  215. " \"Other Provider Identifier Type Code_22\", # \"Other Provider Identifier Type Code_22\",\n",
  216. " \"Other Provider Identifier State_22\", # \"Other Provider Identifier State_22\",\n",
  217. " \"Other Provider Identifier Issuer_22\", # \"Other Provider Identifier Issuer_22\",\n",
  218. " \"Other Provider Identifier_23\", # \"Other Provider Identifier_23\",\n",
  219. " \"Other Provider Identifier Type Code_23\", # \"Other Provider Identifier Type Code_23\",\n",
  220. " \"Other Provider Identifier State_23\", # \"Other Provider Identifier State_23\",\n",
  221. " \"Other Provider Identifier Issuer_23\", # \"Other Provider Identifier Issuer_23\",\n",
  222. " \"Other Provider Identifier_24\", # \"Other Provider Identifier_24\",\n",
  223. " \"Other Provider Identifier Type Code_24\", # \"Other Provider Identifier Type Code_24\",\n",
  224. " \"Other Provider Identifier State_24\", # \"Other Provider Identifier State_24\",\n",
  225. " \"Other Provider Identifier Issuer_24\", # \"Other Provider Identifier Issuer_24\",\n",
  226. " \"Other Provider Identifier_25\", # \"Other Provider Identifier_25\",\n",
  227. " \"Other Provider Identifier Type Code_25\", # \"Other Provider Identifier Type Code_25\",\n",
  228. " \"Other Provider Identifier State_25\", # \"Other Provider Identifier State_25\",\n",
  229. " \"Other Provider Identifier Issuer_25\", # \"Other Provider Identifier Issuer_25\",\n",
  230. " \"Other Provider Identifier_26\", # \"Other Provider Identifier_26\",\n",
  231. " \"Other Provider Identifier Type Code_26\", # \"Other Provider Identifier Type Code_26\",\n",
  232. " \"Other Provider Identifier State_26\", # \"Other Provider Identifier State_26\",\n",
  233. " \"Other Provider Identifier Issuer_26\", # \"Other Provider Identifier Issuer_26\",\n",
  234. " \"Other Provider Identifier_27\", # \"Other Provider Identifier_27\",\n",
  235. " \"Other Provider Identifier Type Code_27\", # \"Other Provider Identifier Type Code_27\",\n",
  236. " \"Other Provider Identifier State_27\", # \"Other Provider Identifier State_27\",\n",
  237. " \"Other Provider Identifier Issuer_27\", # \"Other Provider Identifier Issuer_27\",\n",
  238. " \"Other Provider Identifier_28\", # \"Other Provider Identifier_28\",\n",
  239. " \"Other Provider Identifier Type Code_28\", # \"Other Provider Identifier Type Code_28\",\n",
  240. " \"Other Provider Identifier State_28\", # \"Other Provider Identifier State_28\",\n",
  241. " \"Other Provider Identifier Issuer_28\", # \"Other Provider Identifier Issuer_28\",\n",
  242. " \"Other Provider Identifier_29\", # \"Other Provider Identifier_29\",\n",
  243. " \"Other Provider Identifier Type Code_29\", # \"Other Provider Identifier Type Code_29\",\n",
  244. " \"Other Provider Identifier State_29\", # \"Other Provider Identifier State_29\",\n",
  245. " \"Other Provider Identifier Issuer_29\", # \"Other Provider Identifier Issuer_29\",\n",
  246. " \"Other Provider Identifier_30\", # \"Other Provider Identifier_30\",\n",
  247. " \"Other Provider Identifier Type Code_30\", # \"Other Provider Identifier Type Code_30\",\n",
  248. " \"Other Provider Identifier State_30\", # \"Other Provider Identifier State_30\",\n",
  249. " \"Other Provider Identifier Issuer_30\", # \"Other Provider Identifier Issuer_30\",\n",
  250. " \"Other Provider Identifier_31\", # \"Other Provider Identifier_31\",\n",
  251. " \"Other Provider Identifier Type Code_31\", # \"Other Provider Identifier Type Code_31\",\n",
  252. " \"Other Provider Identifier State_31\", # \"Other Provider Identifier State_31\",\n",
  253. " \"Other Provider Identifier Issuer_31\", # \"Other Provider Identifier Issuer_31\",\n",
  254. " \"Other Provider Identifier_32\", # \"Other Provider Identifier_32\",\n",
  255. " \"Other Provider Identifier Type Code_32\", # \"Other Provider Identifier Type Code_32\",\n",
  256. " \"Other Provider Identifier State_32\", # \"Other Provider Identifier State_32\",\n",
  257. " \"Other Provider Identifier Issuer_32\", # \"Other Provider Identifier Issuer_32\",\n",
  258. " \"Other Provider Identifier_33\", # \"Other Provider Identifier_33\",\n",
  259. " \"Other Provider Identifier Type Code_33\", # \"Other Provider Identifier Type Code_33\",\n",
  260. " \"Other Provider Identifier State_33\", # \"Other Provider Identifier State_33\",\n",
  261. " \"Other Provider Identifier Issuer_33\", # \"Other Provider Identifier Issuer_33\",\n",
  262. " \"Other Provider Identifier_34\", # \"Other Provider Identifier_34\",\n",
  263. " \"Other Provider Identifier Type Code_34\", # \"Other Provider Identifier Type Code_34\",\n",
  264. " \"Other Provider Identifier State_34\", # \"Other Provider Identifier State_34\",\n",
  265. " \"Other Provider Identifier Issuer_34\", # \"Other Provider Identifier Issuer_34\",\n",
  266. " \"Other Provider Identifier_35\", # \"Other Provider Identifier_35\",\n",
  267. " \"Other Provider Identifier Type Code_35\", # \"Other Provider Identifier Type Code_35\",\n",
  268. " \"Other Provider Identifier State_35\", # \"Other Provider Identifier State_35\",\n",
  269. " \"Other Provider Identifier Issuer_35\", # \"Other Provider Identifier Issuer_35\",\n",
  270. " \"Other Provider Identifier_36\", # \"Other Provider Identifier_36\",\n",
  271. " \"Other Provider Identifier Type Code_36\", # \"Other Provider Identifier Type Code_36\",\n",
  272. " \"Other Provider Identifier State_36\", # \"Other Provider Identifier State_36\",\n",
  273. " \"Other Provider Identifier Issuer_36\", # \"Other Provider Identifier Issuer_36\",\n",
  274. " \"Other Provider Identifier_37\", # \"Other Provider Identifier_37\",\n",
  275. " \"Other Provider Identifier Type Code_37\", # \"Other Provider Identifier Type Code_37\",\n",
  276. " \"Other Provider Identifier State_37\", # \"Other Provider Identifier State_37\",\n",
  277. " \"Other Provider Identifier Issuer_37\", # \"Other Provider Identifier Issuer_37\",\n",
  278. " \"Other Provider Identifier_38\", # \"Other Provider Identifier_38\",\n",
  279. " \"Other Provider Identifier Type Code_38\", # \"Other Provider Identifier Type Code_38\",\n",
  280. " \"Other Provider Identifier State_38\", # \"Other Provider Identifier State_38\",\n",
  281. " \"Other Provider Identifier Issuer_38\", # \"Other Provider Identifier Issuer_38\",\n",
  282. " \"Other Provider Identifier_39\", # \"Other Provider Identifier_39\",\n",
  283. " \"Other Provider Identifier Type Code_39\", # \"Other Provider Identifier Type Code_39\",\n",
  284. " \"Other Provider Identifier State_39\", # \"Other Provider Identifier State_39\",\n",
  285. " \"Other Provider Identifier Issuer_39\", # \"Other Provider Identifier Issuer_39\",\n",
  286. " \"Other Provider Identifier_40\", # \"Other Provider Identifier_40\",\n",
  287. " \"Other Provider Identifier Type Code_40\", # \"Other Provider Identifier Type Code_40\",\n",
  288. " \"Other Provider Identifier State_40\", # \"Other Provider Identifier State_40\",\n",
  289. " \"Other Provider Identifier Issuer_40\", # \"Other Provider Identifier Issuer_40\",\n",
  290. " \"Other Provider Identifier_41\", # \"Other Provider Identifier_41\",\n",
  291. " \"Other Provider Identifier Type Code_41\", # \"Other Provider Identifier Type Code_41\",\n",
  292. " \"Other Provider Identifier State_41\", # \"Other Provider Identifier State_41\",\n",
  293. " \"Other Provider Identifier Issuer_41\", # \"Other Provider Identifier Issuer_41\",\n",
  294. " \"Other Provider Identifier_42\", # \"Other Provider Identifier_42\",\n",
  295. " \"Other Provider Identifier Type Code_42\", # \"Other Provider Identifier Type Code_42\",\n",
  296. " \"Other Provider Identifier State_42\", # \"Other Provider Identifier State_42\",\n",
  297. " \"Other Provider Identifier Issuer_42\", # \"Other Provider Identifier Issuer_42\",\n",
  298. " \"Other Provider Identifier_43\", # \"Other Provider Identifier_43\",\n",
  299. " \"Other Provider Identifier Type Code_43\", # \"Other Provider Identifier Type Code_43\",\n",
  300. " \"Other Provider Identifier State_43\", # \"Other Provider Identifier State_43\",\n",
  301. " \"Other Provider Identifier Issuer_43\", # \"Other Provider Identifier Issuer_43\",\n",
  302. " \"Other Provider Identifier_44\", # \"Other Provider Identifier_44\",\n",
  303. " \"Other Provider Identifier Type Code_44\", # \"Other Provider Identifier Type Code_44\",\n",
  304. " \"Other Provider Identifier State_44\", # \"Other Provider Identifier State_44\",\n",
  305. " \"Other Provider Identifier Issuer_44\", # \"Other Provider Identifier Issuer_44\",\n",
  306. " \"Other Provider Identifier_45\", # \"Other Provider Identifier_45\",\n",
  307. " \"Other Provider Identifier Type Code_45\", # \"Other Provider Identifier Type Code_45\",\n",
  308. " \"Other Provider Identifier State_45\", # \"Other Provider Identifier State_45\",\n",
  309. " \"Other Provider Identifier Issuer_45\", # \"Other Provider Identifier Issuer_45\",\n",
  310. " \"Other Provider Identifier_46\", # \"Other Provider Identifier_46\",\n",
  311. " \"Other Provider Identifier Type Code_46\", # \"Other Provider Identifier Type Code_46\",\n",
  312. " \"Other Provider Identifier State_46\", # \"Other Provider Identifier State_46\",\n",
  313. " \"Other Provider Identifier Issuer_46\", # \"Other Provider Identifier Issuer_46\",\n",
  314. " \"Other Provider Identifier_47\", # \"Other Provider Identifier_47\",\n",
  315. " \"Other Provider Identifier Type Code_47\", # \"Other Provider Identifier Type Code_47\",\n",
  316. " \"Other Provider Identifier State_47\", # \"Other Provider Identifier State_47\",\n",
  317. " \"Other Provider Identifier Issuer_47\", # \"Other Provider Identifier Issuer_47\",\n",
  318. " \"Other Provider Identifier_48\", # \"Other Provider Identifier_48\",\n",
  319. " \"Other Provider Identifier Type Code_48\", # \"Other Provider Identifier Type Code_48\",\n",
  320. " \"Other Provider Identifier State_48\", # \"Other Provider Identifier State_48\",\n",
  321. " \"Other Provider Identifier Issuer_48\", # \"Other Provider Identifier Issuer_48\",\n",
  322. " \"Other Provider Identifier_49\", # \"Other Provider Identifier_49\",\n",
  323. " \"Other Provider Identifier Type Code_49\", # \"Other Provider Identifier Type Code_49\",\n",
  324. " \"Other Provider Identifier State_49\", # \"Other Provider Identifier State_49\",\n",
  325. " \"Other Provider Identifier Issuer_49\", # \"Other Provider Identifier Issuer_49\",\n",
  326. " \"Other Provider Identifier_50\", # \"Other Provider Identifier_50\",\n",
  327. " \"Other Provider Identifier Type Code_50\", # \"Other Provider Identifier Type Code_50\",\n",
  328. " \"Other Provider Identifier State_50\", # \"Other Provider Identifier State_50\",\n",
  329. " \"Other Provider Identifier Issuer_50\", # \"Other Provider Identifier Issuer_50\",\n",
  330. " \"Is Sole Proprietor\", # \"Is Sole Proprietor\",\n",
  331. " \"Is Organization Subpart\", # \"Is Organization Subpart\",\n",
  332. " \"Parent Organization LBN\", # \"Parent Organization LBN\",\n",
  333. " \"Parent Organization TIN\", # \"Parent Organization TIN\",\n",
  334. " \"Authorized Official Name Prefix Text\", # \"Authorized Official Name Prefix Text\",\n",
  335. " \"Authorized Official Name Suffix Text\", # \"Authorized Official Name Suffix Text\",\n",
  336. " \"Authorized Official Credential Text\", # \"Authorized Official Credential Text\",\n",
  337. " \"Healthcare Provider Taxonomy Group_1\", # \"Healthcare Provider Taxonomy Group_1\",\n",
  338. " \"Healthcare Provider Taxonomy Group_2\", # \"Healthcare Provider Taxonomy Group_2\",\n",
  339. " \"Healthcare Provider Taxonomy Group_3\", # \"Healthcare Provider Taxonomy Group_3\",\n",
  340. " \"Healthcare Provider Taxonomy Group_4\", # \"Healthcare Provider Taxonomy Group_4\",\n",
  341. " \"Healthcare Provider Taxonomy Group_5\", # \"Healthcare Provider Taxonomy Group_5\",\n",
  342. " \"Healthcare Provider Taxonomy Group_6\", # \"Healthcare Provider Taxonomy Group_6\",\n",
  343. " \"Healthcare Provider Taxonomy Group_7\", # \"Healthcare Provider Taxonomy Group_7\",\n",
  344. " \"Healthcare Provider Taxonomy Group_8\", # \"Healthcare Provider Taxonomy Group_8\",\n",
  345. " \"Healthcare Provider Taxonomy Group_9\", # \"Healthcare Provider Taxonomy Group_9\",\n",
  346. " \"Healthcare Provider Taxonomy Group_10\", # \"Healthcare Provider Taxonomy Group_10\",\n",
  347. " \"Healthcare Provider Taxonomy Group_11\", # \"Healthcare Provider Taxonomy Group_11\",\n",
  348. " \"Healthcare Provider Taxonomy Group_12\", # \"Healthcare Provider Taxonomy Group_12\",\n",
  349. " \"Healthcare Provider Taxonomy Group_13\", # \"Healthcare Provider Taxonomy Group_13\",\n",
  350. " \"Healthcare Provider Taxonomy Group_14\", # \"Healthcare Provider Taxonomy Group_14\",\n",
  351. " \"Healthcare Provider Taxonomy Group_15\"\n",
  352. "]\n",
  353. "\n",
  354. "def cleanse(s):\n",
  355. " return s.lower().replace (\" \", \"_\").replace(\"(\",\"\").replace(\")\",\"\").replace(\".\",\"\").strip()\n",
  356. "\n",
  357. "headers = [cleanse(h) for h in headers]\n",
  358. "\n",
  359. "\"\\\"\" + \"\\\",\\\"\".join(headers) + \"\\\"\""
  360. ]
  361. },
  362. {
  363. "cell_type": "code",
  364. "execution_count": 1,
  365. "metadata": {
  366. "collapsed": false
  367. },
  368. "outputs": [],
  369. "source": [
  370. "headers = [\n",
  371. " \"NPI\", # \"NPI\",\n",
  372. " \"Entity Type Code\", # \"Entity Type Code\",\n",
  373. " \"Replacement NPI\", # \"Replacement NPI\",\n",
  374. " \"Employer Identification Number (EIN)\", # \"Employer Identification Number (EIN)\",\n",
  375. " \"Provider Organization Name (Legal Business Name)\", # \"Provider Organization Name (Legal Business Name)\",\n",
  376. " \"Provider Last Name (Legal Name)\", # \"Provider Last Name (Legal Name)\",\n",
  377. " \"Provider First Name\", # \"Provider First Name\",\n",
  378. " \"Provider Middle Name\", # \"Provider Middle Name\",\n",
  379. " \"Provider Name Prefix Text\", # \"Provider Name Prefix Text\",\n",
  380. " \"Provider Name Suffix Text\", # \"Provider Name Suffix Text\",\n",
  381. " \"Provider Credential Text\", # \"Provider Credential Text\",\n",
  382. " \"Provider Other Organization Name\", # \"Provider Other Organization Name\",\n",
  383. " \"Provider Other Organization Name Type Code\", # \"Provider Other Organization Name Type Code\",\n",
  384. " \"Provider Other Last Name\", # \"Provider Other Last Name\",\n",
  385. " \"Provider Other First Name\", # \"Provider Other First Name\",\n",
  386. " \"Provider Other Middle Name\", # \"Provider Other Middle Name\",\n",
  387. " \"Provider Other Name Prefix Text\", # \"Provider Other Name Prefix Text\",\n",
  388. " \"Provider Other Name Suffix Text\", # \"Provider Other Name Suffix Text\",\n",
  389. " \"Provider Other Credential Text\", # \"Provider Other Credential Text\",\n",
  390. " \"Provider Other Last Name Type Code\", # \"Provider Other Last Name Type Code\",\n",
  391. " \"Provider First Line Business Mailing Address\", # \"Provider First Line Business Mailing Address\",\n",
  392. " \"Provider Second Line Business Mailing Address\", # \"Provider Second Line Business Mailing Address\",\n",
  393. " \"Provider Business Mailing Address City Name\", # \"Provider Business Mailing Address City Name\",\n",
  394. " \"Provider Business Mailing Address State Name\", # \"Provider Business Mailing Address State Name\",\n",
  395. " \"Provider Business Mailing Address Postal Code\", # \"Provider Business Mailing Address Postal Code\",\n",
  396. " \"Provider Business Mailing Address Country Code (If outside U.S.)\", # \"Provider Business Mailing Address Country Code (If outside U.S.)\",\n",
  397. " \"Provider Business Mailing Address Telephone Number\", # \"Provider Business Mailing Address Telephone Number\",\n",
  398. " \"Provider Business Mailing Address Fax Number\", # \"Provider Business Mailing Address Fax Number\",\n",
  399. " \"Provider First Line Business Practice Location Address\", # \"Provider First Line Business Practice Location Address\",\n",
  400. " \"Provider Second Line Business Practice Location Address\", # \"Provider Second Line Business Practice Location Address\",\n",
  401. " \"Provider Business Practice Location Address City Name\", # \"Provider Business Practice Location Address City Name\",\n",
  402. " \"Provider Business Practice Location Address State Name\", # \"Provider Business Practice Location Address State Name\",\n",
  403. " \"Provider Business Practice Location Address Postal Code\", # \"Provider Business Practice Location Address Postal Code\",\n",
  404. " \"Provider Business Practice Location Address Country Code (If outside U.S.)\", # \"Provider Business Practice Location Address Country Code (If outside U.S.)\",\n",
  405. " \"Provider Business Practice Location Address Telephone Number\", # \"Provider Business Practice Location Address Telephone Number\",\n",
  406. " \"Provider Business Practice Location Address Fax Number\", # \"Provider Business Practice Location Address Fax Number\",\n",
  407. " \"Provider Enumeration Date\", # \"Provider Enumeration Date\",\n",
  408. " \"Last Update Date\", # \"Last Update Date\",\n",
  409. " \"NPI Deactivation Reason Code\", # \"NPI Deactivation Reason Code\",\n",
  410. " \"NPI Deactivation Date\", # \"NPI Deactivation Date\",\n",
  411. " \"NPI Reactivation Date\", # \"NPI Reactivation Date\",\n",
  412. " \"Provider Gender Code\", # \"Provider Gender Code\",\n",
  413. " \"Authorized Official Last Name\", # \"Authorized Official Last Name\",\n",
  414. " \"Authorized Official First Name\", # \"Authorized Official First Name\",\n",
  415. " \"Authorized Official Middle Name\", # \"Authorized Official Middle Name\",\n",
  416. " \"Authorized Official Title or Position\", # \"Authorized Official Title or Position\",\n",
  417. " \"Authorized Official Telephone Number\", # \"Authorized Official Telephone Number\",\n",
  418. " \"Healthcare Provider Taxonomy Code_1\", # \"Healthcare Provider Taxonomy Code_1\",\n",
  419. " \"Provider License Number_1\", # \"Provider License Number_1\",\n",
  420. " \"Provider License Number State Code_1\", # \"Provider License Number State Code_1\",\n",
  421. " \"Healthcare Provider Primary Taxonomy Switch_1\", # \"Healthcare Provider Primary Taxonomy Switch_1\",\n",
  422. " \"Healthcare Provider Taxonomy Code_2\", # \"Healthcare Provider Taxonomy Code_2\",\n",
  423. " \"Provider License Number_2\", # \"Provider License Number_2\",\n",
  424. " \"Provider License Number State Code_2\", # \"Provider License Number State Code_2\",\n",
  425. " \"Healthcare Provider Primary Taxonomy Switch_2\", # \"Healthcare Provider Primary Taxonomy Switch_2\",\n",
  426. " \"Healthcare Provider Taxonomy Code_3\", # \"Healthcare Provider Taxonomy Code_3\",\n",
  427. " \"Provider License Number_3\", # \"Provider License Number_3\",\n",
  428. " \"Provider License Number State Code_3\", # \"Provider License Number State Code_3\",\n",
  429. " \"Healthcare Provider Primary Taxonomy Switch_3\", # \"Healthcare Provider Primary Taxonomy Switch_3\",\n",
  430. " \"Healthcare Provider Taxonomy Code_4\", # \"Healthcare Provider Taxonomy Code_4\",\n",
  431. " \"Provider License Number_4\", # \"Provider License Number_4\",\n",
  432. " \"Provider License Number State Code_4\", # \"Provider License Number State Code_4\",\n",
  433. " \"Healthcare Provider Primary Taxonomy Switch_4\", # \"Healthcare Provider Primary Taxonomy Switch_4\",\n",
  434. " \"Healthcare Provider Taxonomy Code_5\", # \"Healthcare Provider Taxonomy Code_5\",\n",
  435. " \"Provider License Number_5\", # \"Provider License Number_5\",\n",
  436. " \"Provider License Number State Code_5\", # \"Provider License Number State Code_5\",\n",
  437. " \"Healthcare Provider Primary Taxonomy Switch_5\", # \"Healthcare Provider Primary Taxonomy Switch_5\",\n",
  438. " \"Healthcare Provider Taxonomy Code_6\", # \"Healthcare Provider Taxonomy Code_6\",\n",
  439. " \"Provider License Number_6\", # \"Provider License Number_6\",\n",
  440. " \"Provider License Number State Code_6\", # \"Provider License Number State Code_6\",\n",
  441. " \"Healthcare Provider Primary Taxonomy Switch_6\", # \"Healthcare Provider Primary Taxonomy Switch_6\",\n",
  442. " \"Healthcare Provider Taxonomy Code_7\", # \"Healthcare Provider Taxonomy Code_7\",\n",
  443. " \"Provider License Number_7\", # \"Provider License Number_7\",\n",
  444. " \"Provider License Number State Code_7\", # \"Provider License Number State Code_7\",\n",
  445. " \"Healthcare Provider Primary Taxonomy Switch_7\", # \"Healthcare Provider Primary Taxonomy Switch_7\",\n",
  446. " \"Healthcare Provider Taxonomy Code_8\", # \"Healthcare Provider Taxonomy Code_8\",\n",
  447. " \"Provider License Number_8\", # \"Provider License Number_8\",\n",
  448. " \"Provider License Number State Code_8\", # \"Provider License Number State Code_8\",\n",
  449. " \"Healthcare Provider Primary Taxonomy Switch_8\", # \"Healthcare Provider Primary Taxonomy Switch_8\",\n",
  450. " \"Healthcare Provider Taxonomy Code_9\", # \"Healthcare Provider Taxonomy Code_9\",\n",
  451. " \"Provider License Number_9\", # \"Provider License Number_9\",\n",
  452. " \"Provider License Number State Code_9\", # \"Provider License Number State Code_9\",\n",
  453. " \"Healthcare Provider Primary Taxonomy Switch_9\", # \"Healthcare Provider Primary Taxonomy Switch_9\",\n",
  454. " \"Healthcare Provider Taxonomy Code_10\", # \"Healthcare Provider Taxonomy Code_10\",\n",
  455. " \"Provider License Number_10\", # \"Provider License Number_10\",\n",
  456. " \"Provider License Number State Code_10\", # \"Provider License Number State Code_10\",\n",
  457. " \"Healthcare Provider Primary Taxonomy Switch_10\", # \"Healthcare Provider Primary Taxonomy Switch_10\",\n",
  458. " \"Healthcare Provider Taxonomy Code_11\", # \"Healthcare Provider Taxonomy Code_11\",\n",
  459. " \"Provider License Number_11\", # \"Provider License Number_11\",\n",
  460. " \"Provider License Number State Code_11\", # \"Provider License Number State Code_11\",\n",
  461. " \"Healthcare Provider Primary Taxonomy Switch_11\", # \"Healthcare Provider Primary Taxonomy Switch_11\",\n",
  462. " \"Healthcare Provider Taxonomy Code_12\", # \"Healthcare Provider Taxonomy Code_12\",\n",
  463. " \"Provider License Number_12\", # \"Provider License Number_12\",\n",
  464. " \"Provider License Number State Code_12\", # \"Provider License Number State Code_12\",\n",
  465. " \"Healthcare Provider Primary Taxonomy Switch_12\", # \"Healthcare Provider Primary Taxonomy Switch_12\",\n",
  466. " \"Healthcare Provider Taxonomy Code_13\", # \"Healthcare Provider Taxonomy Code_13\",\n",
  467. " \"Provider License Number_13\", # \"Provider License Number_13\",\n",
  468. " \"Provider License Number State Code_13\", # \"Provider License Number State Code_13\",\n",
  469. " \"Healthcare Provider Primary Taxonomy Switch_13\", # \"Healthcare Provider Primary Taxonomy Switch_13\",\n",
  470. " \"Healthcare Provider Taxonomy Code_14\", # \"Healthcare Provider Taxonomy Code_14\",\n",
  471. " \"Provider License Number_14\", # \"Provider License Number_14\",\n",
  472. " \"Provider License Number State Code_14\", # \"Provider License Number State Code_14\",\n",
  473. " \"Healthcare Provider Primary Taxonomy Switch_14\", # \"Healthcare Provider Primary Taxonomy Switch_14\",\n",
  474. " \"Healthcare Provider Taxonomy Code_15\", # \"Healthcare Provider Taxonomy Code_15\",\n",
  475. " \"Provider License Number_15\", # \"Provider License Number_15\",\n",
  476. " \"Provider License Number State Code_15\", # \"Provider License Number State Code_15\",\n",
  477. " \"Healthcare Provider Primary Taxonomy Switch_15\", # \"Healthcare Provider Primary Taxonomy Switch_15\",\n",
  478. " \"Other Provider Identifier_1\", # \"Other Provider Identifier_1\",\n",
  479. " \"Other Provider Identifier Type Code_1\", # \"Other Provider Identifier Type Code_1\",\n",
  480. " \"Other Provider Identifier State_1\", # \"Other Provider Identifier State_1\",\n",
  481. " \"Other Provider Identifier Issuer_1\", # \"Other Provider Identifier Issuer_1\",\n",
  482. " \"Other Provider Identifier_2\", # \"Other Provider Identifier_2\",\n",
  483. " \"Other Provider Identifier Type Code_2\", # \"Other Provider Identifier Type Code_2\",\n",
  484. " \"Other Provider Identifier State_2\", # \"Other Provider Identifier State_2\",\n",
  485. " \"Other Provider Identifier Issuer_2\", # \"Other Provider Identifier Issuer_2\",\n",
  486. " \"Other Provider Identifier_3\", # \"Other Provider Identifier_3\",\n",
  487. " \"Other Provider Identifier Type Code_3\", # \"Other Provider Identifier Type Code_3\",\n",
  488. " \"Other Provider Identifier State_3\", # \"Other Provider Identifier State_3\",\n",
  489. " \"Other Provider Identifier Issuer_3\", # \"Other Provider Identifier Issuer_3\",\n",
  490. " \"Other Provider Identifier_4\", # \"Other Provider Identifier_4\",\n",
  491. " \"Other Provider Identifier Type Code_4\", # \"Other Provider Identifier Type Code_4\",\n",
  492. " \"Other Provider Identifier State_4\", # \"Other Provider Identifier State_4\",\n",
  493. " \"Other Provider Identifier Issuer_4\", # \"Other Provider Identifier Issuer_4\",\n",
  494. " \"Other Provider Identifier_5\", # \"Other Provider Identifier_5\",\n",
  495. " \"Other Provider Identifier Type Code_5\", # \"Other Provider Identifier Type Code_5\",\n",
  496. " \"Other Provider Identifier State_5\", # \"Other Provider Identifier State_5\",\n",
  497. " \"Other Provider Identifier Issuer_5\", # \"Other Provider Identifier Issuer_5\",\n",
  498. " \"Other Provider Identifier_6\", # \"Other Provider Identifier_6\",\n",
  499. " \"Other Provider Identifier Type Code_6\", # \"Other Provider Identifier Type Code_6\",\n",
  500. " \"Other Provider Identifier State_6\", # \"Other Provider Identifier State_6\",\n",
  501. " \"Other Provider Identifier Issuer_6\", # \"Other Provider Identifier Issuer_6\",\n",
  502. " \"Other Provider Identifier_7\", # \"Other Provider Identifier_7\",\n",
  503. " \"Other Provider Identifier Type Code_7\", # \"Other Provider Identifier Type Code_7\",\n",
  504. " \"Other Provider Identifier State_7\", # \"Other Provider Identifier State_7\",\n",
  505. " \"Other Provider Identifier Issuer_7\", # \"Other Provider Identifier Issuer_7\",\n",
  506. " \"Other Provider Identifier_8\", # \"Other Provider Identifier_8\",\n",
  507. " \"Other Provider Identifier Type Code_8\", # \"Other Provider Identifier Type Code_8\",\n",
  508. " \"Other Provider Identifier State_8\", # \"Other Provider Identifier State_8\",\n",
  509. " \"Other Provider Identifier Issuer_8\", # \"Other Provider Identifier Issuer_8\",\n",
  510. " \"Other Provider Identifier_9\", # \"Other Provider Identifier_9\",\n",
  511. " \"Other Provider Identifier Type Code_9\", # \"Other Provider Identifier Type Code_9\",\n",
  512. " \"Other Provider Identifier State_9\", # \"Other Provider Identifier State_9\",\n",
  513. " \"Other Provider Identifier Issuer_9\", # \"Other Provider Identifier Issuer_9\",\n",
  514. " \"Other Provider Identifier_10\", # \"Other Provider Identifier_10\",\n",
  515. " \"Other Provider Identifier Type Code_10\", # \"Other Provider Identifier Type Code_10\",\n",
  516. " \"Other Provider Identifier State_10\", # \"Other Provider Identifier State_10\",\n",
  517. " \"Other Provider Identifier Issuer_10\", # \"Other Provider Identifier Issuer_10\",\n",
  518. " \"Other Provider Identifier_11\", # \"Other Provider Identifier_11\",\n",
  519. " \"Other Provider Identifier Type Code_11\", # \"Other Provider Identifier Type Code_11\",\n",
  520. " \"Other Provider Identifier State_11\", # \"Other Provider Identifier State_11\",\n",
  521. " \"Other Provider Identifier Issuer_11\", # \"Other Provider Identifier Issuer_11\",\n",
  522. " \"Other Provider Identifier_12\", # \"Other Provider Identifier_12\",\n",
  523. " \"Other Provider Identifier Type Code_12\", # \"Other Provider Identifier Type Code_12\",\n",
  524. " \"Other Provider Identifier State_12\", # \"Other Provider Identifier State_12\",\n",
  525. " \"Other Provider Identifier Issuer_12\", # \"Other Provider Identifier Issuer_12\",\n",
  526. " \"Other Provider Identifier_13\", # \"Other Provider Identifier_13\",\n",
  527. " \"Other Provider Identifier Type Code_13\", # \"Other Provider Identifier Type Code_13\",\n",
  528. " \"Other Provider Identifier State_13\", # \"Other Provider Identifier State_13\",\n",
  529. " \"Other Provider Identifier Issuer_13\", # \"Other Provider Identifier Issuer_13\",\n",
  530. " \"Other Provider Identifier_14\", # \"Other Provider Identifier_14\",\n",
  531. " \"Other Provider Identifier Type Code_14\", # \"Other Provider Identifier Type Code_14\",\n",
  532. " \"Other Provider Identifier State_14\", # \"Other Provider Identifier State_14\",\n",
  533. " \"Other Provider Identifier Issuer_14\", # \"Other Provider Identifier Issuer_14\",\n",
  534. " \"Other Provider Identifier_15\", # \"Other Provider Identifier_15\",\n",
  535. " \"Other Provider Identifier Type Code_15\", # \"Other Provider Identifier Type Code_15\",\n",
  536. " \"Other Provider Identifier State_15\", # \"Other Provider Identifier State_15\",\n",
  537. " \"Other Provider Identifier Issuer_15\", # \"Other Provider Identifier Issuer_15\",\n",
  538. " \"Other Provider Identifier_16\", # \"Other Provider Identifier_16\",\n",
  539. " \"Other Provider Identifier Type Code_16\", # \"Other Provider Identifier Type Code_16\",\n",
  540. " \"Other Provider Identifier State_16\", # \"Other Provider Identifier State_16\",\n",
  541. " \"Other Provider Identifier Issuer_16\", # \"Other Provider Identifier Issuer_16\",\n",
  542. " \"Other Provider Identifier_17\", # \"Other Provider Identifier_17\",\n",
  543. " \"Other Provider Identifier Type Code_17\", # \"Other Provider Identifier Type Code_17\",\n",
  544. " \"Other Provider Identifier State_17\", # \"Other Provider Identifier State_17\",\n",
  545. " \"Other Provider Identifier Issuer_17\", # \"Other Provider Identifier Issuer_17\",\n",
  546. " \"Other Provider Identifier_18\", # \"Other Provider Identifier_18\",\n",
  547. " \"Other Provider Identifier Type Code_18\", # \"Other Provider Identifier Type Code_18\",\n",
  548. " \"Other Provider Identifier State_18\", # \"Other Provider Identifier State_18\",\n",
  549. " \"Other Provider Identifier Issuer_18\", # \"Other Provider Identifier Issuer_18\",\n",
  550. " \"Other Provider Identifier_19\", # \"Other Provider Identifier_19\",\n",
  551. " \"Other Provider Identifier Type Code_19\", # \"Other Provider Identifier Type Code_19\",\n",
  552. " \"Other Provider Identifier State_19\", # \"Other Provider Identifier State_19\",\n",
  553. " \"Other Provider Identifier Issuer_19\", # \"Other Provider Identifier Issuer_19\",\n",
  554. " \"Other Provider Identifier_20\", # \"Other Provider Identifier_20\",\n",
  555. " \"Other Provider Identifier Type Code_20\", # \"Other Provider Identifier Type Code_20\",\n",
  556. " \"Other Provider Identifier State_20\", # \"Other Provider Identifier State_20\",\n",
  557. " \"Other Provider Identifier Issuer_20\", # \"Other Provider Identifier Issuer_20\",\n",
  558. " \"Other Provider Identifier_21\", # \"Other Provider Identifier_21\",\n",
  559. " \"Other Provider Identifier Type Code_21\", # \"Other Provider Identifier Type Code_21\",\n",
  560. " \"Other Provider Identifier State_21\", # \"Other Provider Identifier State_21\",\n",
  561. " \"Other Provider Identifier Issuer_21\", # \"Other Provider Identifier Issuer_21\",\n",
  562. " \"Other Provider Identifier_22\", # \"Other Provider Identifier_22\",\n",
  563. " \"Other Provider Identifier Type Code_22\", # \"Other Provider Identifier Type Code_22\",\n",
  564. " \"Other Provider Identifier State_22\", # \"Other Provider Identifier State_22\",\n",
  565. " \"Other Provider Identifier Issuer_22\", # \"Other Provider Identifier Issuer_22\",\n",
  566. " \"Other Provider Identifier_23\", # \"Other Provider Identifier_23\",\n",
  567. " \"Other Provider Identifier Type Code_23\", # \"Other Provider Identifier Type Code_23\",\n",
  568. " \"Other Provider Identifier State_23\", # \"Other Provider Identifier State_23\",\n",
  569. " \"Other Provider Identifier Issuer_23\", # \"Other Provider Identifier Issuer_23\",\n",
  570. " \"Other Provider Identifier_24\", # \"Other Provider Identifier_24\",\n",
  571. " \"Other Provider Identifier Type Code_24\", # \"Other Provider Identifier Type Code_24\",\n",
  572. " \"Other Provider Identifier State_24\", # \"Other Provider Identifier State_24\",\n",
  573. " \"Other Provider Identifier Issuer_24\", # \"Other Provider Identifier Issuer_24\",\n",
  574. " \"Other Provider Identifier_25\", # \"Other Provider Identifier_25\",\n",
  575. " \"Other Provider Identifier Type Code_25\", # \"Other Provider Identifier Type Code_25\",\n",
  576. " \"Other Provider Identifier State_25\", # \"Other Provider Identifier State_25\",\n",
  577. " \"Other Provider Identifier Issuer_25\", # \"Other Provider Identifier Issuer_25\",\n",
  578. " \"Other Provider Identifier_26\", # \"Other Provider Identifier_26\",\n",
  579. " \"Other Provider Identifier Type Code_26\", # \"Other Provider Identifier Type Code_26\",\n",
  580. " \"Other Provider Identifier State_26\", # \"Other Provider Identifier State_26\",\n",
  581. " \"Other Provider Identifier Issuer_26\", # \"Other Provider Identifier Issuer_26\",\n",
  582. " \"Other Provider Identifier_27\", # \"Other Provider Identifier_27\",\n",
  583. " \"Other Provider Identifier Type Code_27\", # \"Other Provider Identifier Type Code_27\",\n",
  584. " \"Other Provider Identifier State_27\", # \"Other Provider Identifier State_27\",\n",
  585. " \"Other Provider Identifier Issuer_27\", # \"Other Provider Identifier Issuer_27\",\n",
  586. " \"Other Provider Identifier_28\", # \"Other Provider Identifier_28\",\n",
  587. " \"Other Provider Identifier Type Code_28\", # \"Other Provider Identifier Type Code_28\",\n",
  588. " \"Other Provider Identifier State_28\", # \"Other Provider Identifier State_28\",\n",
  589. " \"Other Provider Identifier Issuer_28\", # \"Other Provider Identifier Issuer_28\",\n",
  590. " \"Other Provider Identifier_29\", # \"Other Provider Identifier_29\",\n",
  591. " \"Other Provider Identifier Type Code_29\", # \"Other Provider Identifier Type Code_29\",\n",
  592. " \"Other Provider Identifier State_29\", # \"Other Provider Identifier State_29\",\n",
  593. " \"Other Provider Identifier Issuer_29\", # \"Other Provider Identifier Issuer_29\",\n",
  594. " \"Other Provider Identifier_30\", # \"Other Provider Identifier_30\",\n",
  595. " \"Other Provider Identifier Type Code_30\", # \"Other Provider Identifier Type Code_30\",\n",
  596. " \"Other Provider Identifier State_30\", # \"Other Provider Identifier State_30\",\n",
  597. " \"Other Provider Identifier Issuer_30\", # \"Other Provider Identifier Issuer_30\",\n",
  598. " \"Other Provider Identifier_31\", # \"Other Provider Identifier_31\",\n",
  599. " \"Other Provider Identifier Type Code_31\", # \"Other Provider Identifier Type Code_31\",\n",
  600. " \"Other Provider Identifier State_31\", # \"Other Provider Identifier State_31\",\n",
  601. " \"Other Provider Identifier Issuer_31\", # \"Other Provider Identifier Issuer_31\",\n",
  602. " \"Other Provider Identifier_32\", # \"Other Provider Identifier_32\",\n",
  603. " \"Other Provider Identifier Type Code_32\", # \"Other Provider Identifier Type Code_32\",\n",
  604. " \"Other Provider Identifier State_32\", # \"Other Provider Identifier State_32\",\n",
  605. " \"Other Provider Identifier Issuer_32\", # \"Other Provider Identifier Issuer_32\",\n",
  606. " \"Other Provider Identifier_33\", # \"Other Provider Identifier_33\",\n",
  607. " \"Other Provider Identifier Type Code_33\", # \"Other Provider Identifier Type Code_33\",\n",
  608. " \"Other Provider Identifier State_33\", # \"Other Provider Identifier State_33\",\n",
  609. " \"Other Provider Identifier Issuer_33\", # \"Other Provider Identifier Issuer_33\",\n",
  610. " \"Other Provider Identifier_34\", # \"Other Provider Identifier_34\",\n",
  611. " \"Other Provider Identifier Type Code_34\", # \"Other Provider Identifier Type Code_34\",\n",
  612. " \"Other Provider Identifier State_34\", # \"Other Provider Identifier State_34\",\n",
  613. " \"Other Provider Identifier Issuer_34\", # \"Other Provider Identifier Issuer_34\",\n",
  614. " \"Other Provider Identifier_35\", # \"Other Provider Identifier_35\",\n",
  615. " \"Other Provider Identifier Type Code_35\", # \"Other Provider Identifier Type Code_35\",\n",
  616. " \"Other Provider Identifier State_35\", # \"Other Provider Identifier State_35\",\n",
  617. " \"Other Provider Identifier Issuer_35\", # \"Other Provider Identifier Issuer_35\",\n",
  618. " \"Other Provider Identifier_36\", # \"Other Provider Identifier_36\",\n",
  619. " \"Other Provider Identifier Type Code_36\", # \"Other Provider Identifier Type Code_36\",\n",
  620. " \"Other Provider Identifier State_36\", # \"Other Provider Identifier State_36\",\n",
  621. " \"Other Provider Identifier Issuer_36\", # \"Other Provider Identifier Issuer_36\",\n",
  622. " \"Other Provider Identifier_37\", # \"Other Provider Identifier_37\",\n",
  623. " \"Other Provider Identifier Type Code_37\", # \"Other Provider Identifier Type Code_37\",\n",
  624. " \"Other Provider Identifier State_37\", # \"Other Provider Identifier State_37\",\n",
  625. " \"Other Provider Identifier Issuer_37\", # \"Other Provider Identifier Issuer_37\",\n",
  626. " \"Other Provider Identifier_38\", # \"Other Provider Identifier_38\",\n",
  627. " \"Other Provider Identifier Type Code_38\", # \"Other Provider Identifier Type Code_38\",\n",
  628. " \"Other Provider Identifier State_38\", # \"Other Provider Identifier State_38\",\n",
  629. " \"Other Provider Identifier Issuer_38\", # \"Other Provider Identifier Issuer_38\",\n",
  630. " \"Other Provider Identifier_39\", # \"Other Provider Identifier_39\",\n",
  631. " \"Other Provider Identifier Type Code_39\", # \"Other Provider Identifier Type Code_39\",\n",
  632. " \"Other Provider Identifier State_39\", # \"Other Provider Identifier State_39\",\n",
  633. " \"Other Provider Identifier Issuer_39\", # \"Other Provider Identifier Issuer_39\",\n",
  634. " \"Other Provider Identifier_40\", # \"Other Provider Identifier_40\",\n",
  635. " \"Other Provider Identifier Type Code_40\", # \"Other Provider Identifier Type Code_40\",\n",
  636. " \"Other Provider Identifier State_40\", # \"Other Provider Identifier State_40\",\n",
  637. " \"Other Provider Identifier Issuer_40\", # \"Other Provider Identifier Issuer_40\",\n",
  638. " \"Other Provider Identifier_41\", # \"Other Provider Identifier_41\",\n",
  639. " \"Other Provider Identifier Type Code_41\", # \"Other Provider Identifier Type Code_41\",\n",
  640. " \"Other Provider Identifier State_41\", # \"Other Provider Identifier State_41\",\n",
  641. " \"Other Provider Identifier Issuer_41\", # \"Other Provider Identifier Issuer_41\",\n",
  642. " \"Other Provider Identifier_42\", # \"Other Provider Identifier_42\",\n",
  643. " \"Other Provider Identifier Type Code_42\", # \"Other Provider Identifier Type Code_42\",\n",
  644. " \"Other Provider Identifier State_42\", # \"Other Provider Identifier State_42\",\n",
  645. " \"Other Provider Identifier Issuer_42\", # \"Other Provider Identifier Issuer_42\",\n",
  646. " \"Other Provider Identifier_43\", # \"Other Provider Identifier_43\",\n",
  647. " \"Other Provider Identifier Type Code_43\", # \"Other Provider Identifier Type Code_43\",\n",
  648. " \"Other Provider Identifier State_43\", # \"Other Provider Identifier State_43\",\n",
  649. " \"Other Provider Identifier Issuer_43\", # \"Other Provider Identifier Issuer_43\",\n",
  650. " \"Other Provider Identifier_44\", # \"Other Provider Identifier_44\",\n",
  651. " \"Other Provider Identifier Type Code_44\", # \"Other Provider Identifier Type Code_44\",\n",
  652. " \"Other Provider Identifier State_44\", # \"Other Provider Identifier State_44\",\n",
  653. " \"Other Provider Identifier Issuer_44\", # \"Other Provider Identifier Issuer_44\",\n",
  654. " \"Other Provider Identifier_45\", # \"Other Provider Identifier_45\",\n",
  655. " \"Other Provider Identifier Type Code_45\", # \"Other Provider Identifier Type Code_45\",\n",
  656. " \"Other Provider Identifier State_45\", # \"Other Provider Identifier State_45\",\n",
  657. " \"Other Provider Identifier Issuer_45\", # \"Other Provider Identifier Issuer_45\",\n",
  658. " \"Other Provider Identifier_46\", # \"Other Provider Identifier_46\",\n",
  659. " \"Other Provider Identifier Type Code_46\", # \"Other Provider Identifier Type Code_46\",\n",
  660. " \"Other Provider Identifier State_46\", # \"Other Provider Identifier State_46\",\n",
  661. " \"Other Provider Identifier Issuer_46\", # \"Other Provider Identifier Issuer_46\",\n",
  662. " \"Other Provider Identifier_47\", # \"Other Provider Identifier_47\",\n",
  663. " \"Other Provider Identifier Type Code_47\", # \"Other Provider Identifier Type Code_47\",\n",
  664. " \"Other Provider Identifier State_47\", # \"Other Provider Identifier State_47\",\n",
  665. " \"Other Provider Identifier Issuer_47\", # \"Other Provider Identifier Issuer_47\",\n",
  666. " \"Other Provider Identifier_48\", # \"Other Provider Identifier_48\",\n",
  667. " \"Other Provider Identifier Type Code_48\", # \"Other Provider Identifier Type Code_48\",\n",
  668. " \"Other Provider Identifier State_48\", # \"Other Provider Identifier State_48\",\n",
  669. " \"Other Provider Identifier Issuer_48\", # \"Other Provider Identifier Issuer_48\",\n",
  670. " \"Other Provider Identifier_49\", # \"Other Provider Identifier_49\",\n",
  671. " \"Other Provider Identifier Type Code_49\", # \"Other Provider Identifier Type Code_49\",\n",
  672. " \"Other Provider Identifier State_49\", # \"Other Provider Identifier State_49\",\n",
  673. " \"Other Provider Identifier Issuer_49\", # \"Other Provider Identifier Issuer_49\",\n",
  674. " \"Other Provider Identifier_50\", # \"Other Provider Identifier_50\",\n",
  675. " \"Other Provider Identifier Type Code_50\", # \"Other Provider Identifier Type Code_50\",\n",
  676. " \"Other Provider Identifier State_50\", # \"Other Provider Identifier State_50\",\n",
  677. " \"Other Provider Identifier Issuer_50\", # \"Other Provider Identifier Issuer_50\",\n",
  678. " \"Is Sole Proprietor\", # \"Is Sole Proprietor\",\n",
  679. " \"Is Organization Subpart\", # \"Is Organization Subpart\",\n",
  680. " \"Parent Organization LBN\", # \"Parent Organization LBN\",\n",
  681. " \"Parent Organization TIN\", # \"Parent Organization TIN\",\n",
  682. " \"Authorized Official Name Prefix Text\", # \"Authorized Official Name Prefix Text\",\n",
  683. " \"Authorized Official Name Suffix Text\", # \"Authorized Official Name Suffix Text\",\n",
  684. " \"Authorized Official Credential Text\", # \"Authorized Official Credential Text\",\n",
  685. " \"Healthcare Provider Taxonomy Group_1\", # \"Healthcare Provider Taxonomy Group_1\",\n",
  686. " \"Healthcare Provider Taxonomy Group_2\", # \"Healthcare Provider Taxonomy Group_2\",\n",
  687. " \"Healthcare Provider Taxonomy Group_3\", # \"Healthcare Provider Taxonomy Group_3\",\n",
  688. " \"Healthcare Provider Taxonomy Group_4\", # \"Healthcare Provider Taxonomy Group_4\",\n",
  689. " \"Healthcare Provider Taxonomy Group_5\", # \"Healthcare Provider Taxonomy Group_5\",\n",
  690. " \"Healthcare Provider Taxonomy Group_6\", # \"Healthcare Provider Taxonomy Group_6\",\n",
  691. " \"Healthcare Provider Taxonomy Group_7\", # \"Healthcare Provider Taxonomy Group_7\",\n",
  692. " \"Healthcare Provider Taxonomy Group_8\", # \"Healthcare Provider Taxonomy Group_8\",\n",
  693. " \"Healthcare Provider Taxonomy Group_9\", # \"Healthcare Provider Taxonomy Group_9\",\n",
  694. " \"Healthcare Provider Taxonomy Group_10\", # \"Healthcare Provider Taxonomy Group_10\",\n",
  695. " \"Healthcare Provider Taxonomy Group_11\", # \"Healthcare Provider Taxonomy Group_11\",\n",
  696. " \"Healthcare Provider Taxonomy Group_12\", # \"Healthcare Provider Taxonomy Group_12\",\n",
  697. " \"Healthcare Provider Taxonomy Group_13\", # \"Healthcare Provider Taxonomy Group_13\",\n",
  698. " \"Healthcare Provider Taxonomy Group_14\", # \"Healthcare Provider Taxonomy Group_14\",\n",
  699. " \"Healthcare Provider Taxonomy Group_15\"\n",
  700. "]\n",
  701. "\n",
  702. "def cleanse(s):\n",
  703. " return s.lower().replace (\" \", \"_\").replace(\"(\",\"\").replace(\")\",\"\").replace(\".\",\"\").strip()\n",
  704. "\n",
  705. "headers = [cleanse(h) for h in headers]\n",
  706. "\n",
  707. "\n",
  708. "create_table = \"create table npi_providers (\" + headers[0] + \" varchar(255));\" \n",
  709. "# \";\".join([\" alter table npi_providers add \" + h + \" varchar(255)\" for h in headers])\n",
  710. "alter_table = [\"alter table npi_providers add \" + h + \" varchar(255)\" for h in headers]\n",
  711. "\n",
  712. "# import pymssql\n",
  713. "\n",
  714. "# server = \"agxsvot8op.database.windows.net\" # getenv(\"PYMSSQL_TEST_SERVER\")\n",
  715. "# user = \"staxio\" # getenv(\"PYMSSQL_TEST_USERNAME\")\n",
  716. "# password = \"Stax@2015!\" # getenv(\"PYMSSQL_TEST_PASSWORD\")\n",
  717. "# database = \"Main\"\n",
  718. "\n",
  719. "# conn = pymssql.connect(server, user, password, database)\n",
  720. "# cursor = conn.cursor()\n",
  721. "# cursor.execute(create_table)\n",
  722. "# for at in alter_table:\n",
  723. "# cursor.execute(at)\n",
  724. "\n",
  725. "# # cursor.executemany(\n",
  726. "# # \"INSERT INTO persons VALUES (%d, %s, %s)\",\n",
  727. "# # [(1, 'John Smith', 'John Doe'),\n",
  728. "# # (2, 'Jane Doe', 'Joe Dog'),\n",
  729. "# # (3, 'Mike T.', 'Sarah H.')])\n",
  730. "# # # you must call commit() to persist your data if you don't set autocommit to True\n",
  731. "# conn.commit()\n",
  732. "\n",
  733. "# # cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')\n",
  734. "# # row = cursor.fetchone()\n",
  735. "# # while row:\n",
  736. "# # print(\"ID=%d, Name=%s\" % (row[0], row[1]))\n",
  737. "# # row = cursor.fetchone()\n",
  738. "\n",
  739. "# conn.close()\n",
  740. "# print('done')"
  741. ]
  742. },
  743. {
  744. "cell_type": "code",
  745. "execution_count": 2,
  746. "metadata": {
  747. "collapsed": false
  748. },
  749. "outputs": [],
  750. "source": []
  751. },
  752. {
  753. "cell_type": "code",
  754. "execution_count": 8,
  755. "metadata": {
  756. "collapsed": false
  757. },
  758. "outputs": [],
  759. "source": [
  760. "# stmt = \"create table npi_providers (\" + \" varchar(150), \".join(headers) + \" varchar(150))\"\n",
  761. "\n",
  762. "\n",
  763. "create_table = \"create table npi_providers (\" + headers[0] + \" varchar(255));\" \n",
  764. "# \";\".join([\" alter table npi_providers add \" + h + \" varchar(255)\" for h in headers])\n",
  765. "\n",
  766. "\n",
  767. "alter_table = [\"alter table npi_providers add \" + h + \" varchar(255)\" for h in headers]"
  768. ]
  769. },
  770. {
  771. "cell_type": "code",
  772. "execution_count": 6,
  773. "metadata": {
  774. "collapsed": false
  775. },
  776. "outputs": [],
  777. "source": [
  778. "# len(stmt)\n",
  779. "# stmt\n",
  780. "\n",
  781. "# for h in headers:\n",
  782. "# # if len(h) > 128: # \"provid\" in h: # h[-6:] == \"ddress\":\n",
  783. "# # print(h)\n",
  784. "# print(len(h), h)"
  785. ]
  786. },
  787. {
  788. "cell_type": "code",
  789. "execution_count": 9,
  790. "metadata": {
  791. "collapsed": false
  792. },
  793. "outputs": [
  794. {
  795. "ename": "ImportError",
  796. "evalue": "No module named 'pymssql'",
  797. "output_type": "error",
  798. "traceback": [
  799. "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
  800. "\u001b[0;31mImportError\u001b[0m Traceback (most recent call last)",
  801. "\u001b[0;32m<ipython-input-9-f366ca5dc2c4>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0;32mimport\u001b[0m \u001b[0mpymssql\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m 2\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 3\u001b[0m \u001b[0mserver\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"agxsvot8op.database.windows.net\"\u001b[0m \u001b[0;31m# getenv(\"PYMSSQL_TEST_SERVER\")\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 4\u001b[0m \u001b[0muser\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"staxio\"\u001b[0m \u001b[0;31m# getenv(\"PYMSSQL_TEST_USERNAME\")\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m 5\u001b[0m \u001b[0mpassword\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"Stax@2015!\"\u001b[0m \u001b[0;31m# getenv(\"PYMSSQL_TEST_PASSWORD\")\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
  802. "\u001b[0;31mImportError\u001b[0m: No module named 'pymssql'"
  803. ]
  804. }
  805. ],
  806. "source": [
  807. "# import pymssql\n",
  808. "\n",
  809. "# server = \"agxsvot8op.database.windows.net\" # getenv(\"PYMSSQL_TEST_SERVER\")\n",
  810. "# user = \"staxio\" # getenv(\"PYMSSQL_TEST_USERNAME\")\n",
  811. "# password = \"Stax@2015!\" # getenv(\"PYMSSQL_TEST_PASSWORD\")\n",
  812. "# database = \"Main\"\n",
  813. "\n",
  814. "# conn = pymssql.connect(server, user, password, database)\n",
  815. "# cursor = conn.cursor()\n",
  816. "# cursor.execute(create_table)\n",
  817. "# for at in alter_table:\n",
  818. "# cursor.execute(at)\n",
  819. "\n",
  820. "# # cursor.executemany(\n",
  821. "# # \"INSERT INTO persons VALUES (%d, %s, %s)\",\n",
  822. "# # [(1, 'John Smith', 'John Doe'),\n",
  823. "# # (2, 'Jane Doe', 'Joe Dog'),\n",
  824. "# # (3, 'Mike T.', 'Sarah H.')])\n",
  825. "# # # you must call commit() to persist your data if you don't set autocommit to True\n",
  826. "# conn.commit()\n",
  827. "\n",
  828. "# # cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')\n",
  829. "# # row = cursor.fetchone()\n",
  830. "# # while row:\n",
  831. "# # print(\"ID=%d, Name=%s\" % (row[0], row[1]))\n",
  832. "# # row = cursor.fetchone()\n",
  833. "\n",
  834. "# conn.close()"
  835. ]
  836. },
  837. {
  838. "cell_type": "code",
  839. "execution_count": 16,
  840. "metadata": {
  841. "collapsed": false
  842. },
  843. "outputs": [
  844. {
  845. "name": "stdout",
  846. "output_type": "stream",
  847. "text": [
  848. "\"alter table npi_providers add npi varchar(255)\",\n",
  849. "\"alter table npi_providers add entity_type_code varchar(255)\",\n",
  850. "\"alter table npi_providers add replacement_npi varchar(255)\",\n",
  851. "\"alter table npi_providers add employer_identification_number_ein varchar(255)\",\n",
  852. "\"alter table npi_providers add provider_organization_name_legal_business_name varchar(255)\",\n",
  853. "\"alter table npi_providers add provider_last_name_legal_name varchar(255)\",\n",
  854. "\"alter table npi_providers add provider_first_name varchar(255)\",\n",
  855. "\"alter table npi_providers add provider_middle_name varchar(255)\",\n",
  856. "\"alter table npi_providers add provider_name_prefix_text varchar(255)\",\n",
  857. "\"alter table npi_providers add provider_name_suffix_text varchar(255)\",\n",
  858. "\"alter table npi_providers add provider_credential_text varchar(255)\",\n",
  859. "\"alter table npi_providers add provider_other_organization_name varchar(255)\",\n",
  860. "\"alter table npi_providers add provider_other_organization_name_type_code varchar(255)\",\n",
  861. "\"alter table npi_providers add provider_other_last_name varchar(255)\",\n",
  862. "\"alter table npi_providers add provider_other_first_name varchar(255)\",\n",
  863. "\"alter table npi_providers add provider_other_middle_name varchar(255)\",\n",
  864. "\"alter table npi_providers add provider_other_name_prefix_text varchar(255)\",\n",
  865. "\"alter table npi_providers add provider_other_name_suffix_text varchar(255)\",\n",
  866. "\"alter table npi_providers add provider_other_credential_text varchar(255)\",\n",
  867. "\"alter table npi_providers add provider_other_last_name_type_code varchar(255)\",\n",
  868. "\"alter table npi_providers add provider_first_line_business_mailing_address varchar(255)\",\n",
  869. "\"alter table npi_providers add provider_second_line_business_mailing_address varchar(255)\",\n",
  870. "\"alter table npi_providers add provider_business_mailing_address_city_name varchar(255)\",\n",
  871. "\"alter table npi_providers add provider_business_mailing_address_state_name varchar(255)\",\n",
  872. "\"alter table npi_providers add provider_business_mailing_address_postal_code varchar(255)\",\n",
  873. "\"alter table npi_providers add provider_business_mailing_address_country_code_if_outside_us varchar(255)\",\n",
  874. "\"alter table npi_providers add provider_business_mailing_address_telephone_number varchar(255)\",\n",
  875. "\"alter table npi_providers add provider_business_mailing_address_fax_number varchar(255)\",\n",
  876. "\"alter table npi_providers add provider_first_line_business_practice_location_address varchar(255)\",\n",
  877. "\"alter table npi_providers add provider_second_line_business_practice_location_address varchar(255)\",\n",
  878. "\"alter table npi_providers add provider_business_practice_location_address_city_name varchar(255)\",\n",
  879. "\"alter table npi_providers add provider_business_practice_location_address_state_name varchar(255)\",\n",
  880. "\"alter table npi_providers add provider_business_practice_location_address_postal_code varchar(255)\",\n",
  881. "\"alter table npi_providers add provider_business_practice_location_address_country_code_if_outside_us varchar(255)\",\n",
  882. "\"alter table npi_providers add provider_business_practice_location_address_telephone_number varchar(255)\",\n",
  883. "\"alter table npi_providers add provider_business_practice_location_address_fax_number varchar(255)\",\n",
  884. "\"alter table npi_providers add provider_enumeration_date varchar(255)\",\n",
  885. "\"alter table npi_providers add last_update_date varchar(255)\",\n",
  886. "\"alter table npi_providers add npi_deactivation_reason_code varchar(255)\",\n",
  887. "\"alter table npi_providers add npi_deactivation_date varchar(255)\",\n",
  888. "\"alter table npi_providers add npi_reactivation_date varchar(255)\",\n",
  889. "\"alter table npi_providers add provider_gender_code varchar(255)\",\n",
  890. "\"alter table npi_providers add authorized_official_last_name varchar(255)\",\n",
  891. "\"alter table npi_providers add authorized_official_first_name varchar(255)\",\n",
  892. "\"alter table npi_providers add authorized_official_middle_name varchar(255)\",\n",
  893. "\"alter table npi_providers add authorized_official_title_or_position varchar(255)\",\n",
  894. "\"alter table npi_providers add authorized_official_telephone_number varchar(255)\",\n",
  895. "\"alter table npi_providers add healthcare_provider_taxonomy_code_1 varchar(255)\",\n",
  896. "\"alter table npi_providers add provider_license_number_1 varchar(255)\",\n",
  897. "\"alter table npi_providers add provider_license_number_state_code_1 varchar(255)\",\n",
  898. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_1 varchar(255)\",\n",
  899. "\"alter table npi_providers add healthcare_provider_taxonomy_code_2 varchar(255)\",\n",
  900. "\"alter table npi_providers add provider_license_number_2 varchar(255)\",\n",
  901. "\"alter table npi_providers add provider_license_number_state_code_2 varchar(255)\",\n",
  902. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_2 varchar(255)\",\n",
  903. "\"alter table npi_providers add healthcare_provider_taxonomy_code_3 varchar(255)\",\n",
  904. "\"alter table npi_providers add provider_license_number_3 varchar(255)\",\n",
  905. "\"alter table npi_providers add provider_license_number_state_code_3 varchar(255)\",\n",
  906. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_3 varchar(255)\",\n",
  907. "\"alter table npi_providers add healthcare_provider_taxonomy_code_4 varchar(255)\",\n",
  908. "\"alter table npi_providers add provider_license_number_4 varchar(255)\",\n",
  909. "\"alter table npi_providers add provider_license_number_state_code_4 varchar(255)\",\n",
  910. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_4 varchar(255)\",\n",
  911. "\"alter table npi_providers add healthcare_provider_taxonomy_code_5 varchar(255)\",\n",
  912. "\"alter table npi_providers add provider_license_number_5 varchar(255)\",\n",
  913. "\"alter table npi_providers add provider_license_number_state_code_5 varchar(255)\",\n",
  914. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_5 varchar(255)\",\n",
  915. "\"alter table npi_providers add healthcare_provider_taxonomy_code_6 varchar(255)\",\n",
  916. "\"alter table npi_providers add provider_license_number_6 varchar(255)\",\n",
  917. "\"alter table npi_providers add provider_license_number_state_code_6 varchar(255)\",\n",
  918. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_6 varchar(255)\",\n",
  919. "\"alter table npi_providers add healthcare_provider_taxonomy_code_7 varchar(255)\",\n",
  920. "\"alter table npi_providers add provider_license_number_7 varchar(255)\",\n",
  921. "\"alter table npi_providers add provider_license_number_state_code_7 varchar(255)\",\n",
  922. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_7 varchar(255)\",\n",
  923. "\"alter table npi_providers add healthcare_provider_taxonomy_code_8 varchar(255)\",\n",
  924. "\"alter table npi_providers add provider_license_number_8 varchar(255)\",\n",
  925. "\"alter table npi_providers add provider_license_number_state_code_8 varchar(255)\",\n",
  926. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_8 varchar(255)\",\n",
  927. "\"alter table npi_providers add healthcare_provider_taxonomy_code_9 varchar(255)\",\n",
  928. "\"alter table npi_providers add provider_license_number_9 varchar(255)\",\n",
  929. "\"alter table npi_providers add provider_license_number_state_code_9 varchar(255)\",\n",
  930. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_9 varchar(255)\",\n",
  931. "\"alter table npi_providers add healthcare_provider_taxonomy_code_10 varchar(255)\",\n",
  932. "\"alter table npi_providers add provider_license_number_10 varchar(255)\",\n",
  933. "\"alter table npi_providers add provider_license_number_state_code_10 varchar(255)\",\n",
  934. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_10 varchar(255)\",\n",
  935. "\"alter table npi_providers add healthcare_provider_taxonomy_code_11 varchar(255)\",\n",
  936. "\"alter table npi_providers add provider_license_number_11 varchar(255)\",\n",
  937. "\"alter table npi_providers add provider_license_number_state_code_11 varchar(255)\",\n",
  938. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_11 varchar(255)\",\n",
  939. "\"alter table npi_providers add healthcare_provider_taxonomy_code_12 varchar(255)\",\n",
  940. "\"alter table npi_providers add provider_license_number_12 varchar(255)\",\n",
  941. "\"alter table npi_providers add provider_license_number_state_code_12 varchar(255)\",\n",
  942. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_12 varchar(255)\",\n",
  943. "\"alter table npi_providers add healthcare_provider_taxonomy_code_13 varchar(255)\",\n",
  944. "\"alter table npi_providers add provider_license_number_13 varchar(255)\",\n",
  945. "\"alter table npi_providers add provider_license_number_state_code_13 varchar(255)\",\n",
  946. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_13 varchar(255)\",\n",
  947. "\"alter table npi_providers add healthcare_provider_taxonomy_code_14 varchar(255)\",\n",
  948. "\"alter table npi_providers add provider_license_number_14 varchar(255)\",\n",
  949. "\"alter table npi_providers add provider_license_number_state_code_14 varchar(255)\",\n",
  950. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_14 varchar(255)\",\n",
  951. "\"alter table npi_providers add healthcare_provider_taxonomy_code_15 varchar(255)\",\n",
  952. "\"alter table npi_providers add provider_license_number_15 varchar(255)\",\n",
  953. "\"alter table npi_providers add provider_license_number_state_code_15 varchar(255)\",\n",
  954. "\"alter table npi_providers add healthcare_provider_primary_taxonomy_switch_15 varchar(255)\",\n",
  955. "\"alter table npi_providers add other_provider_identifier_1 varchar(255)\",\n",
  956. "\"alter table npi_providers add other_provider_identifier_type_code_1 varchar(255)\",\n",
  957. "\"alter table npi_providers add other_provider_identifier_state_1 varchar(255)\",\n",
  958. "\"alter table npi_providers add other_provider_identifier_issuer_1 varchar(255)\",\n",
  959. "\"alter table npi_providers add other_provider_identifier_2 varchar(255)\",\n",
  960. "\"alter table npi_providers add other_provider_identifier_type_code_2 varchar(255)\",\n",
  961. "\"alter table npi_providers add other_provider_identifier_state_2 varchar(255)\",\n",
  962. "\"alter table npi_providers add other_provider_identifier_issuer_2 varchar(255)\",\n",
  963. "\"alter table npi_providers add other_provider_identifier_3 varchar(255)\",\n",
  964. "\"alter table npi_providers add other_provider_identifier_type_code_3 varchar(255)\",\n",
  965. "\"alter table npi_providers add other_provider_identifier_state_3 varchar(255)\",\n",
  966. "\"alter table npi_providers add other_provider_identifier_issuer_3 varchar(255)\",\n",
  967. "\"alter table npi_providers add other_provider_identifier_4 varchar(255)\",\n",
  968. "\"alter table npi_providers add other_provider_identifier_type_code_4 varchar(255)\",\n",
  969. "\"alter table npi_providers add other_provider_identifier_state_4 varchar(255)\",\n",
  970. "\"alter table npi_providers add other_provider_identifier_issuer_4 varchar(255)\",\n",
  971. "\"alter table npi_providers add other_provider_identifier_5 varchar(255)\",\n",
  972. "\"alter table npi_providers add other_provider_identifier_type_code_5 varchar(255)\",\n",
  973. "\"alter table npi_providers add other_provider_identifier_state_5 varchar(255)\",\n",
  974. "\"alter table npi_providers add other_provider_identifier_issuer_5 varchar(255)\",\n",
  975. "\"alter table npi_providers add other_provider_identifier_6 varchar(255)\",\n",
  976. "\"alter table npi_providers add other_provider_identifier_type_code_6 varchar(255)\",\n",
  977. "\"alter table npi_providers add other_provider_identifier_state_6 varchar(255)\",\n",
  978. "\"alter table npi_providers add other_provider_identifier_issuer_6 varchar(255)\",\n",
  979. "\"alter table npi_providers add other_provider_identifier_7 varchar(255)\",\n",
  980. "\"alter table npi_providers add other_provider_identifier_type_code_7 varchar(255)\",\n",
  981. "\"alter table npi_providers add other_provider_identifier_state_7 varchar(255)\",\n",
  982. "\"alter table npi_providers add other_provider_identifier_issuer_7 varchar(255)\",\n",
  983. "\"alter table npi_providers add other_provider_identifier_8 varchar(255)\",\n",
  984. "\"alter table npi_providers add other_provider_identifier_type_code_8 varchar(255)\",\n",
  985. "\"alter table npi_providers add other_provider_identifier_state_8 varchar(255)\",\n",
  986. "\"alter table npi_providers add other_provider_identifier_issuer_8 varchar(255)\",\n",
  987. "\"alter table npi_providers add other_provider_identifier_9 varchar(255)\",\n",
  988. "\"alter table npi_providers add other_provider_identifier_type_code_9 varchar(255)\",\n",
  989. "\"alter table npi_providers add other_provider_identifier_state_9 varchar(255)\",\n",
  990. "\"alter table npi_providers add other_provider_identifier_issuer_9 varchar(255)\",\n",
  991. "\"alter table npi_providers add other_provider_identifier_10 varchar(255)\",\n",
  992. "\"alter table npi_providers add other_provider_identifier_type_code_10 varchar(255)\",\n",
  993. "\"alter table npi_providers add other_provider_identifier_state_10 varchar(255)\",\n",
  994. "\"alter table npi_providers add other_provider_identifier_issuer_10 varchar(255)\",\n",
  995. "\"alter table npi_providers add other_provider_identifier_11 varchar(255)\",\n",
  996. "\"alter table npi_providers add other_provider_identifier_type_code_11 varchar(255)\",\n",
  997. "\"alter table npi_providers add other_provider_identifier_state_11 varchar(255)\",\n",
  998. "\"alter table npi_providers add other_provider_identifier_issuer_11 varchar(255)\",\n",
  999. "\"alter table npi_providers add other_provider_identifier_12 varchar(255)\",\n",
  1000. "\"alter table npi_providers add other_provider_identifier_type_code_12 varchar(255)\",\n",
  1001. "\"alter table npi_providers add other_provider_identifier_state_12 varchar(255)\",\n",
  1002. "\"alter table npi_providers add other_provider_identifier_issuer_12 varchar(255)\",\n",
  1003. "\"alter table npi_providers add other_provider_identifier_13 varchar(255)\",\n",
  1004. "\"alter table npi_providers add other_provider_identifier_type_code_13 varchar(255)\",\n",
  1005. "\"alter table npi_providers add other_provider_identifier_state_13 varchar(255)\",\n",
  1006. "\"alter table npi_providers add other_provider_identifier_issuer_13 varchar(255)\",\n",
  1007. "\"alter table npi_providers add other_provider_identifier_14 varchar(255)\",\n",
  1008. "\"alter table npi_providers add other_provider_identifier_type_code_14 varchar(255)\",\n",
  1009. "\"alter table npi_providers add other_provider_identifier_state_14 varchar(255)\",\n",
  1010. "\"alter table npi_providers add other_provider_identifier_issuer_14 varchar(255)\",\n",
  1011. "\"alter table npi_providers add other_provider_identifier_15 varchar(255)\",\n",
  1012. "\"alter table npi_providers add other_provider_identifier_type_code_15 varchar(255)\",\n",
  1013. "\"alter table npi_providers add other_provider_identifier_state_15 varchar(255)\",\n",
  1014. "\"alter table npi_providers add other_provider_identifier_issuer_15 varchar(255)\",\n",
  1015. "\"alter table npi_providers add other_provider_identifier_16 varchar(255)\",\n",
  1016. "\"alter table npi_providers add other_provider_identifier_type_code_16 varchar(255)\",\n",
  1017. "\"alter table npi_providers add other_provider_identifier_state_16 varchar(255)\",\n",
  1018. "\"alter table npi_providers add other_provider_identifier_issuer_16 varchar(255)\",\n",
  1019. "\"alter table npi_providers add other_provider_identifier_17 varchar(255)\",\n",
  1020. "\"alter table npi_providers add other_provider_identifier_type_code_17 varchar(255)\",\n",
  1021. "\"alter table npi_providers add other_provider_identifier_state_17 varchar(255)\",\n",
  1022. "\"alter table npi_providers add other_provider_identifier_issuer_17 varchar(255)\",\n",
  1023. "\"alter table npi_providers add other_provider_identifier_18 varchar(255)\",\n",
  1024. "\"alter table npi_providers add other_provider_identifier_type_code_18 varchar(255)\",\n",
  1025. "\"alter table npi_providers add other_provider_identifier_state_18 varchar(255)\",\n",
  1026. "\"alter table npi_providers add other_provider_identifier_issuer_18 varchar(255)\",\n",
  1027. "\"alter table npi_providers add other_provider_identifier_19 varchar(255)\",\n",
  1028. "\"alter table npi_providers add other_provider_identifier_type_code_19 varchar(255)\",\n",
  1029. "\"alter table npi_providers add other_provider_identifier_state_19 varchar(255)\",\n",
  1030. "\"alter table npi_providers add other_provider_identifier_issuer_19 varchar(255)\",\n",
  1031. "\"alter table npi_providers add other_provider_identifier_20 varchar(255)\",\n",
  1032. "\"alter table npi_providers add other_provider_identifier_type_code_20 varchar(255)\",\n",
  1033. "\"alter table npi_providers add other_provider_identifier_state_20 varchar(255)\",\n",
  1034. "\"alter table npi_providers add other_provider_identifier_issuer_20 varchar(255)\",\n",
  1035. "\"alter table npi_providers add other_provider_identifier_21 varchar(255)\",\n",
  1036. "\"alter table npi_providers add other_provider_identifier_type_code_21 varchar(255)\",\n",
  1037. "\"alter table npi_providers add other_provider_identifier_state_21 varchar(255)\",\n",
  1038. "\"alter table npi_providers add other_provider_identifier_issuer_21 varchar(255)\",\n",
  1039. "\"alter table npi_providers add other_provider_identifier_22 varchar(255)\",\n",
  1040. "\"alter table npi_providers add other_provider_identifier_type_code_22 varchar(255)\",\n",
  1041. "\"alter table npi_providers add other_provider_identifier_state_22 varchar(255)\",\n",
  1042. "\"alter table npi_providers add other_provider_identifier_issuer_22 varchar(255)\",\n",
  1043. "\"alter table npi_providers add other_provider_identifier_23 varchar(255)\",\n",
  1044. "\"alter table npi_providers add other_provider_identifier_type_code_23 varchar(255)\",\n",
  1045. "\"alter table npi_providers add other_provider_identifier_state_23 varchar(255)\",\n",
  1046. "\"alter table npi_providers add other_provider_identifier_issuer_23 varchar(255)\",\n",
  1047. "\"alter table npi_providers add other_provider_identifier_24 varchar(255)\",\n",
  1048. "\"alter table npi_providers add other_provider_identifier_type_code_24 varchar(255)\",\n",
  1049. "\"alter table npi_providers add other_provider_identifier_state_24 varchar(255)\",\n",
  1050. "\"alter table npi_providers add other_provider_identifier_issuer_24 varchar(255)\",\n",
  1051. "\"alter table npi_providers add other_provider_identifier_25 varchar(255)\",\n",
  1052. "\"alter table npi_providers add other_provider_identifier_type_code_25 varchar(255)\",\n",
  1053. "\"alter table npi_providers add other_provider_identifier_state_25 varchar(255)\",\n",
  1054. "\"alter table npi_providers add other_provider_identifier_issuer_25 varchar(255)\",\n",
  1055. "\"alter table npi_providers add other_provider_identifier_26 varchar(255)\",\n",
  1056. "\"alter table npi_providers add other_provider_identifier_type_code_26 varchar(255)\",\n",
  1057. "\"alter table npi_providers add other_provider_identifier_state_26 varchar(255)\",\n",
  1058. "\"alter table npi_providers add other_provider_identifier_issuer_26 varchar(255)\",\n",
  1059. "\"alter table npi_providers add other_provider_identifier_27 varchar(255)\",\n",
  1060. "\"alter table npi_providers add other_provider_identifier_type_code_27 varchar(255)\",\n",
  1061. "\"alter table npi_providers add other_provider_identifier_state_27 varchar(255)\",\n",
  1062. "\"alter table npi_providers add other_provider_identifier_issuer_27 varchar(255)\",\n",
  1063. "\"alter table npi_providers add other_provider_identifier_28 varchar(255)\",\n",
  1064. "\"alter table npi_providers add other_provider_identifier_type_code_28 varchar(255)\",\n",
  1065. "\"alter table npi_providers add other_provider_identifier_state_28 varchar(255)\",\n",
  1066. "\"alter table npi_providers add other_provider_identifier_issuer_28 varchar(255)\",\n",
  1067. "\"alter table npi_providers add other_provider_identifier_29 varchar(255)\",\n",
  1068. "\"alter table npi_providers add other_provider_identifier_type_code_29 varchar(255)\",\n",
  1069. "\"alter table npi_providers add other_provider_identifier_state_29 varchar(255)\",\n",
  1070. "\"alter table npi_providers add other_provider_identifier_issuer_29 varchar(255)\",\n",
  1071. "\"alter table npi_providers add other_provider_identifier_30 varchar(255)\",\n",
  1072. "\"alter table npi_providers add other_provider_identifier_type_code_30 varchar(255)\",\n",
  1073. "\"alter table npi_providers add other_provider_identifier_state_30 varchar(255)\",\n",
  1074. "\"alter table npi_providers add other_provider_identifier_issuer_30 varchar(255)\",\n",
  1075. "\"alter table npi_providers add other_provider_identifier_31 varchar(255)\",\n",
  1076. "\"alter table npi_providers add other_provider_identifier_type_code_31 varchar(255)\",\n",
  1077. "\"alter table npi_providers add other_provider_identifier_state_31 varchar(255)\",\n",
  1078. "\"alter table npi_providers add other_provider_identifier_issuer_31 varchar(255)\",\n",
  1079. "\"alter table npi_providers add other_provider_identifier_32 varchar(255)\",\n",
  1080. "\"alter table npi_providers add other_provider_identifier_type_code_32 varchar(255)\",\n",
  1081. "\"alter table npi_providers add other_provider_identifier_state_32 varchar(255)\",\n",
  1082. "\"alter table npi_providers add other_provider_identifier_issuer_32 varchar(255)\",\n",
  1083. "\"alter table npi_providers add other_provider_identifier_33 varchar(255)\",\n",
  1084. "\"alter table npi_providers add other_provider_identifier_type_code_33 varchar(255)\",\n",
  1085. "\"alter table npi_providers add other_provider_identifier_state_33 varchar(255)\",\n",
  1086. "\"alter table npi_providers add other_provider_identifier_issuer_33 varchar(255)\",\n",
  1087. "\"alter table npi_providers add other_provider_identifier_34 varchar(255)\",\n",
  1088. "\"alter table npi_providers add other_provider_identifier_type_code_34 varchar(255)\",\n",
  1089. "\"alter table npi_providers add other_provider_identifier_state_34 varchar(255)\",\n",
  1090. "\"alter table npi_providers add other_provider_identifier_issuer_34 varchar(255)\",\n",
  1091. "\"alter table npi_providers add other_provider_identifier_35 varchar(255)\",\n",
  1092. "\"alter table npi_providers add other_provider_identifier_type_code_35 varchar(255)\",\n",
  1093. "\"alter table npi_providers add other_provider_identifier_state_35 varchar(255)\",\n",
  1094. "\"alter table npi_providers add other_provider_identifier_issuer_35 varchar(255)\",\n",
  1095. "\"alter table npi_providers add other_provider_identifier_36 varchar(255)\",\n",
  1096. "\"alter table npi_providers add other_provider_identifier_type_code_36 varchar(255)\",\n",
  1097. "\"alter table npi_providers add other_provider_identifier_state_36 varchar(255)\",\n",
  1098. "\"alter table npi_providers add other_provider_identifier_issuer_36 varchar(255)\",\n",
  1099. "\"alter table npi_providers add other_provider_identifier_37 varchar(255)\",\n",
  1100. "\"alter table npi_providers add other_provider_identifier_type_code_37 varchar(255)\",\n",
  1101. "\"alter table npi_providers add other_provider_identifier_state_37 varchar(255)\",\n",
  1102. "\"alter table npi_providers add other_provider_identifier_issuer_37 varchar(255)\",\n",
  1103. "\"alter table npi_providers add other_provider_identifier_38 varchar(255)\",\n",
  1104. "\"alter table npi_providers add other_provider_identifier_type_code_38 varchar(255)\",\n",
  1105. "\"alter table npi_providers add other_provider_identifier_state_38 varchar(255)\",\n",
  1106. "\"alter table npi_providers add other_provider_identifier_issuer_38 varchar(255)\",\n",
  1107. "\"alter table npi_providers add other_provider_identifier_39 varchar(255)\",\n",
  1108. "\"alter table npi_providers add other_provider_identifier_type_code_39 varchar(255)\",\n",
  1109. "\"alter table npi_providers add other_provider_identifier_state_39 varchar(255)\",\n",
  1110. "\"alter table npi_providers add other_provider_identifier_issuer_39 varchar(255)\",\n",
  1111. "\"alter table npi_providers add other_provider_identifier_40 varchar(255)\",\n",
  1112. "\"alter table npi_providers add other_provider_identifier_type_code_40 varchar(255)\",\n",
  1113. "\"alter table npi_providers add other_provider_identifier_state_40 varchar(255)\",\n",
  1114. "\"alter table npi_providers add other_provider_identifier_issuer_40 varchar(255)\",\n",
  1115. "\"alter table npi_providers add other_provider_identifier_41 varchar(255)\",\n",
  1116. "\"alter table npi_providers add other_provider_identifier_type_code_41 varchar(255)\",\n",
  1117. "\"alter table npi_providers add other_provider_identifier_state_41 varchar(255)\",\n",
  1118. "\"alter table npi_providers add other_provider_identifier_issuer_41 varchar(255)\",\n",
  1119. "\"alter table npi_providers add other_provider_identifier_42 varchar(255)\",\n",
  1120. "\"alter table npi_providers add other_provider_identifier_type_code_42 varchar(255)\",\n",
  1121. "\"alter table npi_providers add other_provider_identifier_state_42 varchar(255)\",\n",
  1122. "\"alter table npi_providers add other_provider_identifier_issuer_42 varchar(255)\",\n",
  1123. "\"alter table npi_providers add other_provider_identifier_43 varchar(255)\",\n",
  1124. "\"alter table npi_providers add other_provider_identifier_type_code_43 varchar(255)\",\n",
  1125. "\"alter table npi_providers add other_provider_identifier_state_43 varchar(255)\",\n",
  1126. "\"alter table npi_providers add other_provider_identifier_issuer_43 varchar(255)\",\n",
  1127. "\"alter table npi_providers add other_provider_identifier_44 varchar(255)\",\n",
  1128. "\"alter table npi_providers add other_provider_identifier_type_code_44 varchar(255)\",\n",
  1129. "\"alter table npi_providers add other_provider_identifier_state_44 varchar(255)\",\n",
  1130. "\"alter table npi_providers add other_provider_identifier_issuer_44 varchar(255)\",\n",
  1131. "\"alter table npi_providers add other_provider_identifier_45 varchar(255)\",\n",
  1132. "\"alter table npi_providers add other_provider_identifier_type_code_45 varchar(255)\",\n",
  1133. "\"alter table npi_providers add other_provider_identifier_state_45 varchar(255)\",\n",
  1134. "\"alter table npi_providers add other_provider_identifier_issuer_45 varchar(255)\",\n",
  1135. "\"alter table npi_providers add other_provider_identifier_46 varchar(255)\",\n",
  1136. "\"alter table npi_providers add other_provider_identifier_type_code_46 varchar(255)\",\n",
  1137. "\"alter table npi_providers add other_provider_identifier_state_46 varchar(255)\",\n",
  1138. "\"alter table npi_providers add other_provider_identifier_issuer_46 varchar(255)\",\n",
  1139. "\"alter table npi_providers add other_provider_identifier_47 varchar(255)\",\n",
  1140. "\"alter table npi_providers add other_provider_identifier_type_code_47 varchar(255)\",\n",
  1141. "\"alter table npi_providers add other_provider_identifier_state_47 varchar(255)\",\n",
  1142. "\"alter table npi_providers add other_provider_identifier_issuer_47 varchar(255)\",\n",
  1143. "\"alter table npi_providers add other_provider_identifier_48 varchar(255)\",\n",
  1144. "\"alter table npi_providers add other_provider_identifier_type_code_48 varchar(255)\",\n",
  1145. "\"alter table npi_providers add other_provider_identifier_state_48 varchar(255)\",\n",
  1146. "\"alter table npi_providers add other_provider_identifier_issuer_48 varchar(255)\",\n",
  1147. "\"alter table npi_providers add other_provider_identifier_49 varchar(255)\",\n",
  1148. "\"alter table npi_providers add other_provider_identifier_type_code_49 varchar(255)\",\n",
  1149. "\"alter table npi_providers add other_provider_identifier_state_49 varchar(255)\",\n",
  1150. "\"alter table npi_providers add other_provider_identifier_issuer_49 varchar(255)\",\n",
  1151. "\"alter table npi_providers add other_provider_identifier_50 varchar(255)\",\n",
  1152. "\"alter table npi_providers add other_provider_identifier_type_code_50 varchar(255)\",\n",
  1153. "\"alter table npi_providers add other_provider_identifier_state_50 varchar(255)\",\n",
  1154. "\"alter table npi_providers add other_provider_identifier_issuer_50 varchar(255)\",\n",
  1155. "\"alter table npi_providers add is_sole_proprietor varchar(255)\",\n",
  1156. "\"alter table npi_providers add is_organization_subpart varchar(255)\",\n",
  1157. "\"alter table npi_providers add parent_organization_lbn varchar(255)\",\n",
  1158. "\"alter table npi_providers add parent_organization_tin varchar(255)\",\n",
  1159. "\"alter table npi_providers add authorized_official_name_prefix_text varchar(255)\",\n",
  1160. "\"alter table npi_providers add authorized_official_name_suffix_text varchar(255)\",\n",
  1161. "\"alter table npi_providers add authorized_official_credential_text varchar(255)\",\n",
  1162. "\"alter table npi_providers add healthcare_provider_taxonomy_group_1 varchar(255)\",\n",
  1163. "\"alter table npi_providers add healthcare_provider_taxonomy_group_2 varchar(255)\",\n",
  1164. "\"alter table npi_providers add healthcare_provider_taxonomy_group_3 varchar(255)\",\n",
  1165. "\"alter table npi_providers add healthcare_provider_taxonomy_group_4 varchar(255)\",\n",
  1166. "\"alter table npi_providers add healthcare_provider_taxonomy_group_5 varchar(255)\",\n",
  1167. "\"alter table npi_providers add healthcare_provider_taxonomy_group_6 varchar(255)\",\n",
  1168. "\"alter table npi_providers add healthcare_provider_taxonomy_group_7 varchar(255)\",\n",
  1169. "\"alter table npi_providers add healthcare_provider_taxonomy_group_8 varchar(255)\",\n",
  1170. "\"alter table npi_providers add healthcare_provider_taxonomy_group_9 varchar(255)\",\n",
  1171. "\"alter table npi_providers add healthcare_provider_taxonomy_group_10 varchar(255)\",\n",
  1172. "\"alter table npi_providers add healthcare_provider_taxonomy_group_11 varchar(255)\",\n",
  1173. "\"alter table npi_providers add healthcare_provider_taxonomy_group_12 varchar(255)\",\n",
  1174. "\"alter table npi_providers add healthcare_provider_taxonomy_group_13 varchar(255)\",\n",
  1175. "\"alter table npi_providers add healthcare_provider_taxonomy_group_14 varchar(255)\",\n",
  1176. "\"alter table npi_providers add healthcare_provider_taxonomy_group_15 varchar(255)\",\n"
  1177. ]
  1178. }
  1179. ],
  1180. "source": [
  1181. "for at in alter_table:\n",
  1182. " print(\"\\\"\"+at+\"\\\",\")"
  1183. ]
  1184. },
  1185. {
  1186. "cell_type": "code",
  1187. "execution_count": 6,
  1188. "metadata": {
  1189. "collapsed": false
  1190. },
  1191. "outputs": [
  1192. {
  1193. "name": "stdout",
  1194. "output_type": "stream",
  1195. "text": [
  1196. "create table npi_providers (npi varchar(255));alter table npi_providers add entity_type_code varchar(255); alter table npi_providers add replacement_npi varchar(255); alter table npi_providers add employer_identification_number_ein varchar(255); alter table npi_providers add provider_organization_name_legal_business_name varchar(255); alter table npi_providers add provider_last_name_legal_name varchar(255); alter table npi_providers add provider_first_name varchar(255); alter table npi_providers add provider_middle_name varchar(255); alter table npi_providers add provider_name_prefix_text varchar(255); alter table npi_providers add provider_name_suffix_text varchar(255); alter table npi_providers add provider_credential_text varchar(255); alter table npi_providers add provider_other_organization_name varchar(255); alter table npi_providers add provider_other_organization_name_type_code varchar(255); alter table npi_providers add provider_other_last_name varchar(255); alter table npi_providers add provider_other_first_name varchar(255); alter table npi_providers add provider_other_middle_name varchar(255); alter table npi_providers add provider_other_name_prefix_text varchar(255); alter table npi_providers add provider_other_name_suffix_text varchar(255); alter table npi_providers add provider_other_credential_text varchar(255); alter table npi_providers add provider_other_last_name_type_code varchar(255); alter table npi_providers add provider_first_line_business_mailing_address varchar(255); alter table npi_providers add provider_second_line_business_mailing_address varchar(255); alter table npi_providers add provider_business_mailing_address_city_name varchar(255); alter table npi_providers add provider_business_mailing_address_state_name varchar(255); alter table npi_providers add provider_business_mailing_address_postal_code varchar(255); alter table npi_providers add provider_business_mailing_address_country_code_if_outside_us varchar(255); alter table npi_providers add provider_business_mailing_address_telephone_number varchar(255); alter table npi_providers add provider_business_mailing_address_fax_number varchar(255); alter table npi_providers add provider_first_line_business_practice_location_address varchar(255); alter table npi_providers add provider_second_line_business_practice_location_address varchar(255); alter table npi_providers add provider_business_practice_location_address_city_name varchar(255); alter table npi_providers add provider_business_practice_location_address_state_name varchar(255); alter table npi_providers add provider_business_practice_location_address_postal_code varchar(255); alter table npi_providers add provider_business_practice_location_address_country_code_if_outside_us varchar(255); alter table npi_providers add provider_business_practice_location_address_telephone_number varchar(255); alter table npi_providers add provider_business_practice_location_address_fax_number varchar(255); alter table npi_providers add provider_enumeration_date varchar(255); alter table npi_providers add last_update_date varchar(255); alter table npi_providers add npi_deactivation_reason_code varchar(255); alter table npi_providers add npi_deactivation_date varchar(255); alter table npi_providers add npi_reactivation_date varchar(255); alter table npi_providers add provider_gender_code varchar(255); alter table npi_providers add authorized_official_last_name varchar(255); alter table npi_providers add authorized_official_first_name varchar(255); alter table npi_providers add authorized_official_middle_name varchar(255); alter table npi_providers add authorized_official_title_or_position varchar(255); alter table npi_providers add authorized_official_telephone_number varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_1 varchar(255); alter table npi_providers add provider_license_number_1 varchar(255); alter table npi_providers add provider_license_number_state_code_1 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_1 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_2 varchar(255); alter table npi_providers add provider_license_number_2 varchar(255); alter table npi_providers add provider_license_number_state_code_2 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_2 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_3 varchar(255); alter table npi_providers add provider_license_number_3 varchar(255); alter table npi_providers add provider_license_number_state_code_3 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_3 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_4 varchar(255); alter table npi_providers add provider_license_number_4 varchar(255); alter table npi_providers add provider_license_number_state_code_4 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_4 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_5 varchar(255); alter table npi_providers add provider_license_number_5 varchar(255); alter table npi_providers add provider_license_number_state_code_5 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_5 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_6 varchar(255); alter table npi_providers add provider_license_number_6 varchar(255); alter table npi_providers add provider_license_number_state_code_6 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_6 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_7 varchar(255); alter table npi_providers add provider_license_number_7 varchar(255); alter table npi_providers add provider_license_number_state_code_7 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_7 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_8 varchar(255); alter table npi_providers add provider_license_number_8 varchar(255); alter table npi_providers add provider_license_number_state_code_8 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_8 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_9 varchar(255); alter table npi_providers add provider_license_number_9 varchar(255); alter table npi_providers add provider_license_number_state_code_9 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_9 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_10 varchar(255); alter table npi_providers add provider_license_number_10 varchar(255); alter table npi_providers add provider_license_number_state_code_10 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_10 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_11 varchar(255); alter table npi_providers add provider_license_number_11 varchar(255); alter table npi_providers add provider_license_number_state_code_11 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_11 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_12 varchar(255); alter table npi_providers add provider_license_number_12 varchar(255); alter table npi_providers add provider_license_number_state_code_12 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_12 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_13 varchar(255); alter table npi_providers add provider_license_number_13 varchar(255); alter table npi_providers add provider_license_number_state_code_13 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_13 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_14 varchar(255); alter table npi_providers add provider_license_number_14 varchar(255); alter table npi_providers add provider_license_number_state_code_14 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_14 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_15 varchar(255); alter table npi_providers add provider_license_number_15 varchar(255); alter table npi_providers add provider_license_number_state_code_15 varchar(255); alter table npi_providers add healthcare_provider_primary_taxonomy_switch_15 varchar(255); alter table npi_providers add other_provider_identifier_1 varchar(255); alter table npi_providers add other_provider_identifier_type_code_1 varchar(255); alter table npi_providers add other_provider_identifier_state_1 varchar(255); alter table npi_providers add other_provider_identifier_issuer_1 varchar(255); alter table npi_providers add other_provider_identifier_2 varchar(255); alter table npi_providers add other_provider_identifier_type_code_2 varchar(255); alter table npi_providers add other_provider_identifier_state_2 varchar(255); alter table npi_providers add other_provider_identifier_issuer_2 varchar(255); alter table npi_providers add other_provider_identifier_3 varchar(255); alter table npi_providers add other_provider_identifier_type_code_3 varchar(255); alter table npi_providers add other_provider_identifier_state_3 varchar(255); alter table npi_providers add other_provider_identifier_issuer_3 varchar(255); alter table npi_providers add other_provider_identifier_4 varchar(255); alter table npi_providers add other_provider_identifier_type_code_4 varchar(255); alter table npi_providers add other_provider_identifier_state_4 varchar(255); alter table npi_providers add other_provider_identifier_issuer_4 varchar(255); alter table npi_providers add other_provider_identifier_5 varchar(255); alter table npi_providers add other_provider_identifier_type_code_5 varchar(255); alter table npi_providers add other_provider_identifier_state_5 varchar(255); alter table npi_providers add other_provider_identifier_issuer_5 varchar(255); alter table npi_providers add other_provider_identifier_6 varchar(255); alter table npi_providers add other_provider_identifier_type_code_6 varchar(255); alter table npi_providers add other_provider_identifier_state_6 varchar(255); alter table npi_providers add other_provider_identifier_issuer_6 varchar(255); alter table npi_providers add other_provider_identifier_7 varchar(255); alter table npi_providers add other_provider_identifier_type_code_7 varchar(255); alter table npi_providers add other_provider_identifier_state_7 varchar(255); alter table npi_providers add other_provider_identifier_issuer_7 varchar(255); alter table npi_providers add other_provider_identifier_8 varchar(255); alter table npi_providers add other_provider_identifier_type_code_8 varchar(255); alter table npi_providers add other_provider_identifier_state_8 varchar(255); alter table npi_providers add other_provider_identifier_issuer_8 varchar(255); alter table npi_providers add other_provider_identifier_9 varchar(255); alter table npi_providers add other_provider_identifier_type_code_9 varchar(255); alter table npi_providers add other_provider_identifier_state_9 varchar(255); alter table npi_providers add other_provider_identifier_issuer_9 varchar(255); alter table npi_providers add other_provider_identifier_10 varchar(255); alter table npi_providers add other_provider_identifier_type_code_10 varchar(255); alter table npi_providers add other_provider_identifier_state_10 varchar(255); alter table npi_providers add other_provider_identifier_issuer_10 varchar(255); alter table npi_providers add other_provider_identifier_11 varchar(255); alter table npi_providers add other_provider_identifier_type_code_11 varchar(255); alter table npi_providers add other_provider_identifier_state_11 varchar(255); alter table npi_providers add other_provider_identifier_issuer_11 varchar(255); alter table npi_providers add other_provider_identifier_12 varchar(255); alter table npi_providers add other_provider_identifier_type_code_12 varchar(255); alter table npi_providers add other_provider_identifier_state_12 varchar(255); alter table npi_providers add other_provider_identifier_issuer_12 varchar(255); alter table npi_providers add other_provider_identifier_13 varchar(255); alter table npi_providers add other_provider_identifier_type_code_13 varchar(255); alter table npi_providers add other_provider_identifier_state_13 varchar(255); alter table npi_providers add other_provider_identifier_issuer_13 varchar(255); alter table npi_providers add other_provider_identifier_14 varchar(255); alter table npi_providers add other_provider_identifier_type_code_14 varchar(255); alter table npi_providers add other_provider_identifier_state_14 varchar(255); alter table npi_providers add other_provider_identifier_issuer_14 varchar(255); alter table npi_providers add other_provider_identifier_15 varchar(255); alter table npi_providers add other_provider_identifier_type_code_15 varchar(255); alter table npi_providers add other_provider_identifier_state_15 varchar(255); alter table npi_providers add other_provider_identifier_issuer_15 varchar(255); alter table npi_providers add other_provider_identifier_16 varchar(255); alter table npi_providers add other_provider_identifier_type_code_16 varchar(255); alter table npi_providers add other_provider_identifier_state_16 varchar(255); alter table npi_providers add other_provider_identifier_issuer_16 varchar(255); alter table npi_providers add other_provider_identifier_17 varchar(255); alter table npi_providers add other_provider_identifier_type_code_17 varchar(255); alter table npi_providers add other_provider_identifier_state_17 varchar(255); alter table npi_providers add other_provider_identifier_issuer_17 varchar(255); alter table npi_providers add other_provider_identifier_18 varchar(255); alter table npi_providers add other_provider_identifier_type_code_18 varchar(255); alter table npi_providers add other_provider_identifier_state_18 varchar(255); alter table npi_providers add other_provider_identifier_issuer_18 varchar(255); alter table npi_providers add other_provider_identifier_19 varchar(255); alter table npi_providers add other_provider_identifier_type_code_19 varchar(255); alter table npi_providers add other_provider_identifier_state_19 varchar(255); alter table npi_providers add other_provider_identifier_issuer_19 varchar(255); alter table npi_providers add other_provider_identifier_20 varchar(255); alter table npi_providers add other_provider_identifier_type_code_20 varchar(255); alter table npi_providers add other_provider_identifier_state_20 varchar(255); alter table npi_providers add other_provider_identifier_issuer_20 varchar(255); alter table npi_providers add other_provider_identifier_21 varchar(255); alter table npi_providers add other_provider_identifier_type_code_21 varchar(255); alter table npi_providers add other_provider_identifier_state_21 varchar(255); alter table npi_providers add other_provider_identifier_issuer_21 varchar(255); alter table npi_providers add other_provider_identifier_22 varchar(255); alter table npi_providers add other_provider_identifier_type_code_22 varchar(255); alter table npi_providers add other_provider_identifier_state_22 varchar(255); alter table npi_providers add other_provider_identifier_issuer_22 varchar(255); alter table npi_providers add other_provider_identifier_23 varchar(255); alter table npi_providers add other_provider_identifier_type_code_23 varchar(255); alter table npi_providers add other_provider_identifier_state_23 varchar(255); alter table npi_providers add other_provider_identifier_issuer_23 varchar(255); alter table npi_providers add other_provider_identifier_24 varchar(255); alter table npi_providers add other_provider_identifier_type_code_24 varchar(255); alter table npi_providers add other_provider_identifier_state_24 varchar(255); alter table npi_providers add other_provider_identifier_issuer_24 varchar(255); alter table npi_providers add other_provider_identifier_25 varchar(255); alter table npi_providers add other_provider_identifier_type_code_25 varchar(255); alter table npi_providers add other_provider_identifier_state_25 varchar(255); alter table npi_providers add other_provider_identifier_issuer_25 varchar(255); alter table npi_providers add other_provider_identifier_26 varchar(255); alter table npi_providers add other_provider_identifier_type_code_26 varchar(255); alter table npi_providers add other_provider_identifier_state_26 varchar(255); alter table npi_providers add other_provider_identifier_issuer_26 varchar(255); alter table npi_providers add other_provider_identifier_27 varchar(255); alter table npi_providers add other_provider_identifier_type_code_27 varchar(255); alter table npi_providers add other_provider_identifier_state_27 varchar(255); alter table npi_providers add other_provider_identifier_issuer_27 varchar(255); alter table npi_providers add other_provider_identifier_28 varchar(255); alter table npi_providers add other_provider_identifier_type_code_28 varchar(255); alter table npi_providers add other_provider_identifier_state_28 varchar(255); alter table npi_providers add other_provider_identifier_issuer_28 varchar(255); alter table npi_providers add other_provider_identifier_29 varchar(255); alter table npi_providers add other_provider_identifier_type_code_29 varchar(255); alter table npi_providers add other_provider_identifier_state_29 varchar(255); alter table npi_providers add other_provider_identifier_issuer_29 varchar(255); alter table npi_providers add other_provider_identifier_30 varchar(255); alter table npi_providers add other_provider_identifier_type_code_30 varchar(255); alter table npi_providers add other_provider_identifier_state_30 varchar(255); alter table npi_providers add other_provider_identifier_issuer_30 varchar(255); alter table npi_providers add other_provider_identifier_31 varchar(255); alter table npi_providers add other_provider_identifier_type_code_31 varchar(255); alter table npi_providers add other_provider_identifier_state_31 varchar(255); alter table npi_providers add other_provider_identifier_issuer_31 varchar(255); alter table npi_providers add other_provider_identifier_32 varchar(255); alter table npi_providers add other_provider_identifier_type_code_32 varchar(255); alter table npi_providers add other_provider_identifier_state_32 varchar(255); alter table npi_providers add other_provider_identifier_issuer_32 varchar(255); alter table npi_providers add other_provider_identifier_33 varchar(255); alter table npi_providers add other_provider_identifier_type_code_33 varchar(255); alter table npi_providers add other_provider_identifier_state_33 varchar(255); alter table npi_providers add other_provider_identifier_issuer_33 varchar(255); alter table npi_providers add other_provider_identifier_34 varchar(255); alter table npi_providers add other_provider_identifier_type_code_34 varchar(255); alter table npi_providers add other_provider_identifier_state_34 varchar(255); alter table npi_providers add other_provider_identifier_issuer_34 varchar(255); alter table npi_providers add other_provider_identifier_35 varchar(255); alter table npi_providers add other_provider_identifier_type_code_35 varchar(255); alter table npi_providers add other_provider_identifier_state_35 varchar(255); alter table npi_providers add other_provider_identifier_issuer_35 varchar(255); alter table npi_providers add other_provider_identifier_36 varchar(255); alter table npi_providers add other_provider_identifier_type_code_36 varchar(255); alter table npi_providers add other_provider_identifier_state_36 varchar(255); alter table npi_providers add other_provider_identifier_issuer_36 varchar(255); alter table npi_providers add other_provider_identifier_37 varchar(255); alter table npi_providers add other_provider_identifier_type_code_37 varchar(255); alter table npi_providers add other_provider_identifier_state_37 varchar(255); alter table npi_providers add other_provider_identifier_issuer_37 varchar(255); alter table npi_providers add other_provider_identifier_38 varchar(255); alter table npi_providers add other_provider_identifier_type_code_38 varchar(255); alter table npi_providers add other_provider_identifier_state_38 varchar(255); alter table npi_providers add other_provider_identifier_issuer_38 varchar(255); alter table npi_providers add other_provider_identifier_39 varchar(255); alter table npi_providers add other_provider_identifier_type_code_39 varchar(255); alter table npi_providers add other_provider_identifier_state_39 varchar(255); alter table npi_providers add other_provider_identifier_issuer_39 varchar(255); alter table npi_providers add other_provider_identifier_40 varchar(255); alter table npi_providers add other_provider_identifier_type_code_40 varchar(255); alter table npi_providers add other_provider_identifier_state_40 varchar(255); alter table npi_providers add other_provider_identifier_issuer_40 varchar(255); alter table npi_providers add other_provider_identifier_41 varchar(255); alter table npi_providers add other_provider_identifier_type_code_41 varchar(255); alter table npi_providers add other_provider_identifier_state_41 varchar(255); alter table npi_providers add other_provider_identifier_issuer_41 varchar(255); alter table npi_providers add other_provider_identifier_42 varchar(255); alter table npi_providers add other_provider_identifier_type_code_42 varchar(255); alter table npi_providers add other_provider_identifier_state_42 varchar(255); alter table npi_providers add other_provider_identifier_issuer_42 varchar(255); alter table npi_providers add other_provider_identifier_43 varchar(255); alter table npi_providers add other_provider_identifier_type_code_43 varchar(255); alter table npi_providers add other_provider_identifier_state_43 varchar(255); alter table npi_providers add other_provider_identifier_issuer_43 varchar(255); alter table npi_providers add other_provider_identifier_44 varchar(255); alter table npi_providers add other_provider_identifier_type_code_44 varchar(255); alter table npi_providers add other_provider_identifier_state_44 varchar(255); alter table npi_providers add other_provider_identifier_issuer_44 varchar(255); alter table npi_providers add other_provider_identifier_45 varchar(255); alter table npi_providers add other_provider_identifier_type_code_45 varchar(255); alter table npi_providers add other_provider_identifier_state_45 varchar(255); alter table npi_providers add other_provider_identifier_issuer_45 varchar(255); alter table npi_providers add other_provider_identifier_46 varchar(255); alter table npi_providers add other_provider_identifier_type_code_46 varchar(255); alter table npi_providers add other_provider_identifier_state_46 varchar(255); alter table npi_providers add other_provider_identifier_issuer_46 varchar(255); alter table npi_providers add other_provider_identifier_47 varchar(255); alter table npi_providers add other_provider_identifier_type_code_47 varchar(255); alter table npi_providers add other_provider_identifier_state_47 varchar(255); alter table npi_providers add other_provider_identifier_issuer_47 varchar(255); alter table npi_providers add other_provider_identifier_48 varchar(255); alter table npi_providers add other_provider_identifier_type_code_48 varchar(255); alter table npi_providers add other_provider_identifier_state_48 varchar(255); alter table npi_providers add other_provider_identifier_issuer_48 varchar(255); alter table npi_providers add other_provider_identifier_49 varchar(255); alter table npi_providers add other_provider_identifier_type_code_49 varchar(255); alter table npi_providers add other_provider_identifier_state_49 varchar(255); alter table npi_providers add other_provider_identifier_issuer_49 varchar(255); alter table npi_providers add other_provider_identifier_50 varchar(255); alter table npi_providers add other_provider_identifier_type_code_50 varchar(255); alter table npi_providers add other_provider_identifier_state_50 varchar(255); alter table npi_providers add other_provider_identifier_issuer_50 varchar(255); alter table npi_providers add is_sole_proprietor varchar(255); alter table npi_providers add is_organization_subpart varchar(255); alter table npi_providers add parent_organization_lbn varchar(255); alter table npi_providers add parent_organization_tin varchar(255); alter table npi_providers add authorized_official_name_prefix_text varchar(255); alter table npi_providers add authorized_official_name_suffix_text varchar(255); alter table npi_providers add authorized_official_credential_text varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_1 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_2 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_3 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_4 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_5 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_6 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_7 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_8 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_9 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_10 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_11 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_12 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_13 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_14 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_15 varchar(255)\n"
  1197. ]
  1198. }
  1199. ],
  1200. "source": [
  1201. "print(create_table + \"; \".join([at for at in alter_table[1:]]))"
  1202. ]
  1203. },
  1204. {
  1205. "cell_type": "code",
  1206. "execution_count": 7,
  1207. "metadata": {
  1208. "collapsed": false
  1209. },
  1210. "outputs": [
  1211. {
  1212. "data": {
  1213. "text/plain": [
  1214. "['npi',\n",
  1215. " 'entity_type_code',\n",
  1216. " 'replacement_npi',\n",
  1217. " 'employer_identification_number_ein',\n",
  1218. " 'provider_organization_name_legal_business_name',\n",
  1219. " 'provider_last_name_legal_name',\n",
  1220. " 'provider_first_name',\n",
  1221. " 'provider_middle_name',\n",
  1222. " 'provider_name_prefix_text',\n",
  1223. " 'provider_name_suffix_text',\n",
  1224. " 'provider_credential_text',\n",
  1225. " 'provider_other_organization_name',\n",
  1226. " 'provider_other_organization_name_type_code',\n",
  1227. " 'provider_other_last_name',\n",
  1228. " 'provider_other_first_name',\n",
  1229. " 'provider_other_middle_name',\n",
  1230. " 'provider_other_name_prefix_text',\n",
  1231. " 'provider_other_name_suffix_text',\n",
  1232. " 'provider_other_credential_text',\n",
  1233. " 'provider_other_last_name_type_code',\n",
  1234. " 'provider_first_line_business_mailing_address',\n",
  1235. " 'provider_second_line_business_mailing_address',\n",
  1236. " 'provider_business_mailing_address_city_name',\n",
  1237. " 'provider_business_mailing_address_state_name',\n",
  1238. " 'provider_business_mailing_address_postal_code',\n",
  1239. " 'provider_business_mailing_address_country_code_if_outside_us',\n",
  1240. " 'provider_business_mailing_address_telephone_number',\n",
  1241. " 'provider_business_mailing_address_fax_number',\n",
  1242. " 'provider_first_line_business_practice_location_address',\n",
  1243. " 'provider_second_line_business_practice_location_address',\n",
  1244. " 'provider_business_practice_location_address_city_name',\n",
  1245. " 'provider_business_practice_location_address_state_name',\n",
  1246. " 'provider_business_practice_location_address_postal_code',\n",
  1247. " 'provider_business_practice_location_address_country_code_if_outside_us',\n",
  1248. " 'provider_business_practice_location_address_telephone_number',\n",
  1249. " 'provider_business_practice_location_address_fax_number',\n",
  1250. " 'provider_enumeration_date',\n",
  1251. " 'last_update_date',\n",
  1252. " 'npi_deactivation_reason_code',\n",
  1253. " 'npi_deactivation_date',\n",
  1254. " 'npi_reactivation_date',\n",
  1255. " 'provider_gender_code',\n",
  1256. " 'authorized_official_last_name',\n",
  1257. " 'authorized_official_first_name',\n",
  1258. " 'authorized_official_middle_name',\n",
  1259. " 'authorized_official_title_or_position',\n",
  1260. " 'authorized_official_telephone_number',\n",
  1261. " 'healthcare_provider_taxonomy_code_1',\n",
  1262. " 'provider_license_number_1',\n",
  1263. " 'provider_license_number_state_code_1',\n",
  1264. " 'healthcare_provider_primary_taxonomy_switch_1',\n",
  1265. " 'healthcare_provider_taxonomy_code_2',\n",
  1266. " 'provider_license_number_2',\n",
  1267. " 'provider_license_number_state_code_2',\n",
  1268. " 'healthcare_provider_primary_taxonomy_switch_2',\n",
  1269. " 'healthcare_provider_taxonomy_code_3',\n",
  1270. " 'provider_license_number_3',\n",
  1271. " 'provider_license_number_state_code_3',\n",
  1272. " 'healthcare_provider_primary_taxonomy_switch_3',\n",
  1273. " 'healthcare_provider_taxonomy_code_4',\n",
  1274. " 'provider_license_number_4',\n",
  1275. " 'provider_license_number_state_code_4',\n",
  1276. " 'healthcare_provider_primary_taxonomy_switch_4',\n",
  1277. " 'healthcare_provider_taxonomy_code_5',\n",
  1278. " 'provider_license_number_5',\n",
  1279. " 'provider_license_number_state_code_5',\n",
  1280. " 'healthcare_provider_primary_taxonomy_switch_5',\n",
  1281. " 'healthcare_provider_taxonomy_code_6',\n",
  1282. " 'provider_license_number_6',\n",
  1283. " 'provider_license_number_state_code_6',\n",
  1284. " 'healthcare_provider_primary_taxonomy_switch_6',\n",
  1285. " 'healthcare_provider_taxonomy_code_7',\n",
  1286. " 'provider_license_number_7',\n",
  1287. " 'provider_license_number_state_code_7',\n",
  1288. " 'healthcare_provider_primary_taxonomy_switch_7',\n",
  1289. " 'healthcare_provider_taxonomy_code_8',\n",
  1290. " 'provider_license_number_8',\n",
  1291. " 'provider_license_number_state_code_8',\n",
  1292. " 'healthcare_provider_primary_taxonomy_switch_8',\n",
  1293. " 'healthcare_provider_taxonomy_code_9',\n",
  1294. " 'provider_license_number_9',\n",
  1295. " 'provider_license_number_state_code_9',\n",
  1296. " 'healthcare_provider_primary_taxonomy_switch_9',\n",
  1297. " 'healthcare_provider_taxonomy_code_10',\n",
  1298. " 'provider_license_number_10',\n",
  1299. " 'provider_license_number_state_code_10',\n",
  1300. " 'healthcare_provider_primary_taxonomy_switch_10',\n",
  1301. " 'healthcare_provider_taxonomy_code_11',\n",
  1302. " 'provider_license_number_11',\n",
  1303. " 'provider_license_number_state_code_11',\n",
  1304. " 'healthcare_provider_primary_taxonomy_switch_11',\n",
  1305. " 'healthcare_provider_taxonomy_code_12',\n",
  1306. " 'provider_license_number_12',\n",
  1307. " 'provider_license_number_state_code_12',\n",
  1308. " 'healthcare_provider_primary_taxonomy_switch_12',\n",
  1309. " 'healthcare_provider_taxonomy_code_13',\n",
  1310. " 'provider_license_number_13',\n",
  1311. " 'provider_license_number_state_code_13',\n",
  1312. " 'healthcare_provider_primary_taxonomy_switch_13',\n",
  1313. " 'healthcare_provider_taxonomy_code_14',\n",
  1314. " 'provider_license_number_14',\n",
  1315. " 'provider_license_number_state_code_14',\n",
  1316. " 'healthcare_provider_primary_taxonomy_switch_14',\n",
  1317. " 'healthcare_provider_taxonomy_code_15',\n",
  1318. " 'provider_license_number_15',\n",
  1319. " 'provider_license_number_state_code_15',\n",
  1320. " 'healthcare_provider_primary_taxonomy_switch_15',\n",
  1321. " 'other_provider_identifier_1',\n",
  1322. " 'other_provider_identifier_type_code_1',\n",
  1323. " 'other_provider_identifier_state_1',\n",
  1324. " 'other_provider_identifier_issuer_1',\n",
  1325. " 'other_provider_identifier_2',\n",
  1326. " 'other_provider_identifier_type_code_2',\n",
  1327. " 'other_provider_identifier_state_2',\n",
  1328. " 'other_provider_identifier_issuer_2',\n",
  1329. " 'other_provider_identifier_3',\n",
  1330. " 'other_provider_identifier_type_code_3',\n",
  1331. " 'other_provider_identifier_state_3',\n",
  1332. " 'other_provider_identifier_issuer_3',\n",
  1333. " 'other_provider_identifier_4',\n",
  1334. " 'other_provider_identifier_type_code_4',\n",
  1335. " 'other_provider_identifier_state_4',\n",
  1336. " 'other_provider_identifier_issuer_4',\n",
  1337. " 'other_provider_identifier_5',\n",
  1338. " 'other_provider_identifier_type_code_5',\n",
  1339. " 'other_provider_identifier_state_5',\n",
  1340. " 'other_provider_identifier_issuer_5',\n",
  1341. " 'other_provider_identifier_6',\n",
  1342. " 'other_provider_identifier_type_code_6',\n",
  1343. " 'other_provider_identifier_state_6',\n",
  1344. " 'other_provider_identifier_issuer_6',\n",
  1345. " 'other_provider_identifier_7',\n",
  1346. " 'other_provider_identifier_type_code_7',\n",
  1347. " 'other_provider_identifier_state_7',\n",
  1348. " 'other_provider_identifier_issuer_7',\n",
  1349. " 'other_provider_identifier_8',\n",
  1350. " 'other_provider_identifier_type_code_8',\n",
  1351. " 'other_provider_identifier_state_8',\n",
  1352. " 'other_provider_identifier_issuer_8',\n",
  1353. " 'other_provider_identifier_9',\n",
  1354. " 'other_provider_identifier_type_code_9',\n",
  1355. " 'other_provider_identifier_state_9',\n",
  1356. " 'other_provider_identifier_issuer_9',\n",
  1357. " 'other_provider_identifier_10',\n",
  1358. " 'other_provider_identifier_type_code_10',\n",
  1359. " 'other_provider_identifier_state_10',\n",
  1360. " 'other_provider_identifier_issuer_10',\n",
  1361. " 'other_provider_identifier_11',\n",
  1362. " 'other_provider_identifier_type_code_11',\n",
  1363. " 'other_provider_identifier_state_11',\n",
  1364. " 'other_provider_identifier_issuer_11',\n",
  1365. " 'other_provider_identifier_12',\n",
  1366. " 'other_provider_identifier_type_code_12',\n",
  1367. " 'other_provider_identifier_state_12',\n",
  1368. " 'other_provider_identifier_issuer_12',\n",
  1369. " 'other_provider_identifier_13',\n",
  1370. " 'other_provider_identifier_type_code_13',\n",
  1371. " 'other_provider_identifier_state_13',\n",
  1372. " 'other_provider_identifier_issuer_13',\n",
  1373. " 'other_provider_identifier_14',\n",
  1374. " 'other_provider_identifier_type_code_14',\n",
  1375. " 'other_provider_identifier_state_14',\n",
  1376. " 'other_provider_identifier_issuer_14',\n",
  1377. " 'other_provider_identifier_15',\n",
  1378. " 'other_provider_identifier_type_code_15',\n",
  1379. " 'other_provider_identifier_state_15',\n",
  1380. " 'other_provider_identifier_issuer_15',\n",
  1381. " 'other_provider_identifier_16',\n",
  1382. " 'other_provider_identifier_type_code_16',\n",
  1383. " 'other_provider_identifier_state_16',\n",
  1384. " 'other_provider_identifier_issuer_16',\n",
  1385. " 'other_provider_identifier_17',\n",
  1386. " 'other_provider_identifier_type_code_17',\n",
  1387. " 'other_provider_identifier_state_17',\n",
  1388. " 'other_provider_identifier_issuer_17',\n",
  1389. " 'other_provider_identifier_18',\n",
  1390. " 'other_provider_identifier_type_code_18',\n",
  1391. " 'other_provider_identifier_state_18',\n",
  1392. " 'other_provider_identifier_issuer_18',\n",
  1393. " 'other_provider_identifier_19',\n",
  1394. " 'other_provider_identifier_type_code_19',\n",
  1395. " 'other_provider_identifier_state_19',\n",
  1396. " 'other_provider_identifier_issuer_19',\n",
  1397. " 'other_provider_identifier_20',\n",
  1398. " 'other_provider_identifier_type_code_20',\n",
  1399. " 'other_provider_identifier_state_20',\n",
  1400. " 'other_provider_identifier_issuer_20',\n",
  1401. " 'other_provider_identifier_21',\n",
  1402. " 'other_provider_identifier_type_code_21',\n",
  1403. " 'other_provider_identifier_state_21',\n",
  1404. " 'other_provider_identifier_issuer_21',\n",
  1405. " 'other_provider_identifier_22',\n",
  1406. " 'other_provider_identifier_type_code_22',\n",
  1407. " 'other_provider_identifier_state_22',\n",
  1408. " 'other_provider_identifier_issuer_22',\n",
  1409. " 'other_provider_identifier_23',\n",
  1410. " 'other_provider_identifier_type_code_23',\n",
  1411. " 'other_provider_identifier_state_23',\n",
  1412. " 'other_provider_identifier_issuer_23',\n",
  1413. " 'other_provider_identifier_24',\n",
  1414. " 'other_provider_identifier_type_code_24',\n",
  1415. " 'other_provider_identifier_state_24',\n",
  1416. " 'other_provider_identifier_issuer_24',\n",
  1417. " 'other_provider_identifier_25',\n",
  1418. " 'other_provider_identifier_type_code_25',\n",
  1419. " 'other_provider_identifier_state_25',\n",
  1420. " 'other_provider_identifier_issuer_25',\n",
  1421. " 'other_provider_identifier_26',\n",
  1422. " 'other_provider_identifier_type_code_26',\n",
  1423. " 'other_provider_identifier_state_26',\n",
  1424. " 'other_provider_identifier_issuer_26',\n",
  1425. " 'other_provider_identifier_27',\n",
  1426. " 'other_provider_identifier_type_code_27',\n",
  1427. " 'other_provider_identifier_state_27',\n",
  1428. " 'other_provider_identifier_issuer_27',\n",
  1429. " 'other_provider_identifier_28',\n",
  1430. " 'other_provider_identifier_type_code_28',\n",
  1431. " 'other_provider_identifier_state_28',\n",
  1432. " 'other_provider_identifier_issuer_28',\n",
  1433. " 'other_provider_identifier_29',\n",
  1434. " 'other_provider_identifier_type_code_29',\n",
  1435. " 'other_provider_identifier_state_29',\n",
  1436. " 'other_provider_identifier_issuer_29',\n",
  1437. " 'other_provider_identifier_30',\n",
  1438. " 'other_provider_identifier_type_code_30',\n",
  1439. " 'other_provider_identifier_state_30',\n",
  1440. " 'other_provider_identifier_issuer_30',\n",
  1441. " 'other_provider_identifier_31',\n",
  1442. " 'other_provider_identifier_type_code_31',\n",
  1443. " 'other_provider_identifier_state_31',\n",
  1444. " 'other_provider_identifier_issuer_31',\n",
  1445. " 'other_provider_identifier_32',\n",
  1446. " 'other_provider_identifier_type_code_32',\n",
  1447. " 'other_provider_identifier_state_32',\n",
  1448. " 'other_provider_identifier_issuer_32',\n",
  1449. " 'other_provider_identifier_33',\n",
  1450. " 'other_provider_identifier_type_code_33',\n",
  1451. " 'other_provider_identifier_state_33',\n",
  1452. " 'other_provider_identifier_issuer_33',\n",
  1453. " 'other_provider_identifier_34',\n",
  1454. " 'other_provider_identifier_type_code_34',\n",
  1455. " 'other_provider_identifier_state_34',\n",
  1456. " 'other_provider_identifier_issuer_34',\n",
  1457. " 'other_provider_identifier_35',\n",
  1458. " 'other_provider_identifier_type_code_35',\n",
  1459. " 'other_provider_identifier_state_35',\n",
  1460. " 'other_provider_identifier_issuer_35',\n",
  1461. " 'other_provider_identifier_36',\n",
  1462. " 'other_provider_identifier_type_code_36',\n",
  1463. " 'other_provider_identifier_state_36',\n",
  1464. " 'other_provider_identifier_issuer_36',\n",
  1465. " 'other_provider_identifier_37',\n",
  1466. " 'other_provider_identifier_type_code_37',\n",
  1467. " 'other_provider_identifier_state_37',\n",
  1468. " 'other_provider_identifier_issuer_37',\n",
  1469. " 'other_provider_identifier_38',\n",
  1470. " 'other_provider_identifier_type_code_38',\n",
  1471. " 'other_provider_identifier_state_38',\n",
  1472. " 'other_provider_identifier_issuer_38',\n",
  1473. " 'other_provider_identifier_39',\n",
  1474. " 'other_provider_identifier_type_code_39',\n",
  1475. " 'other_provider_identifier_state_39',\n",
  1476. " 'other_provider_identifier_issuer_39',\n",
  1477. " 'other_provider_identifier_40',\n",
  1478. " 'other_provider_identifier_type_code_40',\n",
  1479. " 'other_provider_identifier_state_40',\n",
  1480. " 'other_provider_identifier_issuer_40',\n",
  1481. " 'other_provider_identifier_41',\n",
  1482. " 'other_provider_identifier_type_code_41',\n",
  1483. " 'other_provider_identifier_state_41',\n",
  1484. " 'other_provider_identifier_issuer_41',\n",
  1485. " 'other_provider_identifier_42',\n",
  1486. " 'other_provider_identifier_type_code_42',\n",
  1487. " 'other_provider_identifier_state_42',\n",
  1488. " 'other_provider_identifier_issuer_42',\n",
  1489. " 'other_provider_identifier_43',\n",
  1490. " 'other_provider_identifier_type_code_43',\n",
  1491. " 'other_provider_identifier_state_43',\n",
  1492. " 'other_provider_identifier_issuer_43',\n",
  1493. " 'other_provider_identifier_44',\n",
  1494. " 'other_provider_identifier_type_code_44',\n",
  1495. " 'other_provider_identifier_state_44',\n",
  1496. " 'other_provider_identifier_issuer_44',\n",
  1497. " 'other_provider_identifier_45',\n",
  1498. " 'other_provider_identifier_type_code_45',\n",
  1499. " 'other_provider_identifier_state_45',\n",
  1500. " 'other_provider_identifier_issuer_45',\n",
  1501. " 'other_provider_identifier_46',\n",
  1502. " 'other_provider_identifier_type_code_46',\n",
  1503. " 'other_provider_identifier_state_46',\n",
  1504. " 'other_provider_identifier_issuer_46',\n",
  1505. " 'other_provider_identifier_47',\n",
  1506. " 'other_provider_identifier_type_code_47',\n",
  1507. " 'other_provider_identifier_state_47',\n",
  1508. " 'other_provider_identifier_issuer_47',\n",
  1509. " 'other_provider_identifier_48',\n",
  1510. " 'other_provider_identifier_type_code_48',\n",
  1511. " 'other_provider_identifier_state_48',\n",
  1512. " 'other_provider_identifier_issuer_48',\n",
  1513. " 'other_provider_identifier_49',\n",
  1514. " 'other_provider_identifier_type_code_49',\n",
  1515. " 'other_provider_identifier_state_49',\n",
  1516. " 'other_provider_identifier_issuer_49',\n",
  1517. " 'other_provider_identifier_50',\n",
  1518. " 'other_provider_identifier_type_code_50',\n",
  1519. " 'other_provider_identifier_state_50',\n",
  1520. " 'other_provider_identifier_issuer_50',\n",
  1521. " 'is_sole_proprietor',\n",
  1522. " 'is_organization_subpart',\n",
  1523. " 'parent_organization_lbn',\n",
  1524. " 'parent_organization_tin',\n",
  1525. " 'authorized_official_name_prefix_text',\n",
  1526. " 'authorized_official_name_suffix_text',\n",
  1527. " 'authorized_official_credential_text',\n",
  1528. " 'healthcare_provider_taxonomy_group_1',\n",
  1529. " 'healthcare_provider_taxonomy_group_2',\n",
  1530. " 'healthcare_provider_taxonomy_group_3',\n",
  1531. " 'healthcare_provider_taxonomy_group_4',\n",
  1532. " 'healthcare_provider_taxonomy_group_5',\n",
  1533. " 'healthcare_provider_taxonomy_group_6',\n",
  1534. " 'healthcare_provider_taxonomy_group_7',\n",
  1535. " 'healthcare_provider_taxonomy_group_8',\n",
  1536. " 'healthcare_provider_taxonomy_group_9',\n",
  1537. " 'healthcare_provider_taxonomy_group_10',\n",
  1538. " 'healthcare_provider_taxonomy_group_11',\n",
  1539. " 'healthcare_provider_taxonomy_group_12',\n",
  1540. " 'healthcare_provider_taxonomy_group_13',\n",
  1541. " 'healthcare_provider_taxonomy_group_14',\n",
  1542. " 'healthcare_provider_taxonomy_group_15']"
  1543. ]
  1544. },
  1545. "execution_count": 7,
  1546. "metadata": {},
  1547. "output_type": "execute_result"
  1548. }
  1549. ],
  1550. "source": [
  1551. "headers"
  1552. ]
  1553. },
  1554. {
  1555. "cell_type": "code",
  1556. "execution_count": 8,
  1557. "metadata": {
  1558. "collapsed": false
  1559. },
  1560. "outputs": [
  1561. {
  1562. "data": {
  1563. "text/plain": [
  1564. "329"
  1565. ]
  1566. },
  1567. "execution_count": 8,
  1568. "metadata": {},
  1569. "output_type": "execute_result"
  1570. }
  1571. ],
  1572. "source": [
  1573. "len(headers)"
  1574. ]
  1575. },
  1576. {
  1577. "cell_type": "code",
  1578. "execution_count": 9,
  1579. "metadata": {
  1580. "collapsed": false
  1581. },
  1582. "outputs": [
  1583. {
  1584. "name": "stdout",
  1585. "output_type": "stream",
  1586. "text": [
  1587. "create table npi_providers (npi varchar(255));alter table npi_providers add entity_type_code text; alter table npi_providers add replacement_npi varchar(255); alter table npi_providers add employer_identification_number_ein text; alter table npi_providers add provider_organization_name_legal_business_name varchar(255); alter table npi_providers add provider_last_name_legal_name text; alter table npi_providers add provider_first_name varchar(255); alter table npi_providers add provider_middle_name text; alter table npi_providers add provider_name_prefix_text varchar(255); alter table npi_providers add provider_name_suffix_text text; alter table npi_providers add provider_credential_text varchar(255); alter table npi_providers add provider_other_organization_name text; alter table npi_providers add provider_other_organization_name_type_code varchar(255); alter table npi_providers add provider_other_last_name text; alter table npi_providers add provider_other_first_name varchar(255); alter table npi_providers add provider_other_middle_name text; alter table npi_providers add provider_other_name_prefix_text varchar(255); alter table npi_providers add provider_other_name_suffix_text text; alter table npi_providers add provider_other_credential_text varchar(255); alter table npi_providers add provider_other_last_name_type_code text; alter table npi_providers add provider_first_line_business_mailing_address varchar(255); alter table npi_providers add provider_second_line_business_mailing_address text; alter table npi_providers add provider_business_mailing_address_city_name varchar(255); alter table npi_providers add provider_business_mailing_address_state_name text; alter table npi_providers add provider_business_mailing_address_postal_code varchar(255); alter table npi_providers add provider_business_mailing_address_country_code_if_outside_us text; alter table npi_providers add provider_business_mailing_address_telephone_number varchar(255); alter table npi_providers add provider_business_mailing_address_fax_number text; alter table npi_providers add provider_first_line_business_practice_location_address varchar(255); alter table npi_providers add provider_second_line_business_practice_location_address text; alter table npi_providers add provider_business_practice_location_address_city_name varchar(255); alter table npi_providers add provider_business_practice_location_address_state_name text; alter table npi_providers add provider_business_practice_location_address_postal_code varchar(255); alter table npi_providers add provider_business_practice_location_address_country_code_if_outside_us text; alter table npi_providers add provider_business_practice_location_address_telephone_number varchar(255); alter table npi_providers add provider_business_practice_location_address_fax_number text; alter table npi_providers add provider_enumeration_date varchar(255); alter table npi_providers add last_update_date text; alter table npi_providers add npi_deactivation_reason_code varchar(255); alter table npi_providers add npi_deactivation_date text; alter table npi_providers add npi_reactivation_date varchar(255); alter table npi_providers add provider_gender_code text; alter table npi_providers add authorized_official_last_name varchar(255); alter table npi_providers add authorized_official_first_name text; alter table npi_providers add authorized_official_middle_name varchar(255); alter table npi_providers add authorized_official_title_or_position text; alter table npi_providers add authorized_official_telephone_number varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_1 text; alter table npi_providers add provider_license_number_1 varchar(255); alter table npi_providers add provider_license_number_state_code_1 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_1 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_2 text; alter table npi_providers add provider_license_number_2 varchar(255); alter table npi_providers add provider_license_number_state_code_2 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_2 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_3 text; alter table npi_providers add provider_license_number_3 varchar(255); alter table npi_providers add provider_license_number_state_code_3 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_3 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_4 text; alter table npi_providers add provider_license_number_4 varchar(255); alter table npi_providers add provider_license_number_state_code_4 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_4 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_5 text; alter table npi_providers add provider_license_number_5 varchar(255); alter table npi_providers add provider_license_number_state_code_5 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_5 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_6 text; alter table npi_providers add provider_license_number_6 varchar(255); alter table npi_providers add provider_license_number_state_code_6 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_6 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_7 text; alter table npi_providers add provider_license_number_7 varchar(255); alter table npi_providers add provider_license_number_state_code_7 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_7 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_8 text; alter table npi_providers add provider_license_number_8 varchar(255); alter table npi_providers add provider_license_number_state_code_8 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_8 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_9 text; alter table npi_providers add provider_license_number_9 varchar(255); alter table npi_providers add provider_license_number_state_code_9 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_9 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_10 text; alter table npi_providers add provider_license_number_10 varchar(255); alter table npi_providers add provider_license_number_state_code_10 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_10 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_11 text; alter table npi_providers add provider_license_number_11 varchar(255); alter table npi_providers add provider_license_number_state_code_11 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_11 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_12 text; alter table npi_providers add provider_license_number_12 varchar(255); alter table npi_providers add provider_license_number_state_code_12 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_12 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_13 text; alter table npi_providers add provider_license_number_13 varchar(255); alter table npi_providers add provider_license_number_state_code_13 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_13 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_14 text; alter table npi_providers add provider_license_number_14 varchar(255); alter table npi_providers add provider_license_number_state_code_14 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_14 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_code_15 text; alter table npi_providers add provider_license_number_15 varchar(255); alter table npi_providers add provider_license_number_state_code_15 text; alter table npi_providers add healthcare_provider_primary_taxonomy_switch_15 varchar(255); alter table npi_providers add other_provider_identifier_1 text; alter table npi_providers add other_provider_identifier_type_code_1 varchar(255); alter table npi_providers add other_provider_identifier_state_1 text; alter table npi_providers add other_provider_identifier_issuer_1 varchar(255); alter table npi_providers add other_provider_identifier_2 text; alter table npi_providers add other_provider_identifier_type_code_2 varchar(255); alter table npi_providers add other_provider_identifier_state_2 text; alter table npi_providers add other_provider_identifier_issuer_2 varchar(255); alter table npi_providers add other_provider_identifier_3 text; alter table npi_providers add other_provider_identifier_type_code_3 varchar(255); alter table npi_providers add other_provider_identifier_state_3 text; alter table npi_providers add other_provider_identifier_issuer_3 varchar(255); alter table npi_providers add other_provider_identifier_4 text; alter table npi_providers add other_provider_identifier_type_code_4 varchar(255); alter table npi_providers add other_provider_identifier_state_4 text; alter table npi_providers add other_provider_identifier_issuer_4 varchar(255); alter table npi_providers add other_provider_identifier_5 text; alter table npi_providers add other_provider_identifier_type_code_5 varchar(255); alter table npi_providers add other_provider_identifier_state_5 text; alter table npi_providers add other_provider_identifier_issuer_5 varchar(255); alter table npi_providers add other_provider_identifier_6 text; alter table npi_providers add other_provider_identifier_type_code_6 varchar(255); alter table npi_providers add other_provider_identifier_state_6 text; alter table npi_providers add other_provider_identifier_issuer_6 varchar(255); alter table npi_providers add other_provider_identifier_7 text; alter table npi_providers add other_provider_identifier_type_code_7 varchar(255); alter table npi_providers add other_provider_identifier_state_7 text; alter table npi_providers add other_provider_identifier_issuer_7 varchar(255); alter table npi_providers add other_provider_identifier_8 text; alter table npi_providers add other_provider_identifier_type_code_8 varchar(255); alter table npi_providers add other_provider_identifier_state_8 text; alter table npi_providers add other_provider_identifier_issuer_8 varchar(255); alter table npi_providers add other_provider_identifier_9 text; alter table npi_providers add other_provider_identifier_type_code_9 varchar(255); alter table npi_providers add other_provider_identifier_state_9 text; alter table npi_providers add other_provider_identifier_issuer_9 varchar(255); alter table npi_providers add other_provider_identifier_10 text; alter table npi_providers add other_provider_identifier_type_code_10 varchar(255); alter table npi_providers add other_provider_identifier_state_10 text; alter table npi_providers add other_provider_identifier_issuer_10 varchar(255); alter table npi_providers add other_provider_identifier_11 text; alter table npi_providers add other_provider_identifier_type_code_11 varchar(255); alter table npi_providers add other_provider_identifier_state_11 text; alter table npi_providers add other_provider_identifier_issuer_11 varchar(255); alter table npi_providers add other_provider_identifier_12 text; alter table npi_providers add other_provider_identifier_type_code_12 varchar(255); alter table npi_providers add other_provider_identifier_state_12 text; alter table npi_providers add other_provider_identifier_issuer_12 varchar(255); alter table npi_providers add other_provider_identifier_13 text; alter table npi_providers add other_provider_identifier_type_code_13 varchar(255); alter table npi_providers add other_provider_identifier_state_13 text; alter table npi_providers add other_provider_identifier_issuer_13 varchar(255); alter table npi_providers add other_provider_identifier_14 text; alter table npi_providers add other_provider_identifier_type_code_14 varchar(255); alter table npi_providers add other_provider_identifier_state_14 text; alter table npi_providers add other_provider_identifier_issuer_14 varchar(255); alter table npi_providers add other_provider_identifier_15 text; alter table npi_providers add other_provider_identifier_type_code_15 varchar(255); alter table npi_providers add other_provider_identifier_state_15 text; alter table npi_providers add other_provider_identifier_issuer_15 varchar(255); alter table npi_providers add other_provider_identifier_16 text; alter table npi_providers add other_provider_identifier_type_code_16 varchar(255); alter table npi_providers add other_provider_identifier_state_16 text; alter table npi_providers add other_provider_identifier_issuer_16 varchar(255); alter table npi_providers add other_provider_identifier_17 text; alter table npi_providers add other_provider_identifier_type_code_17 varchar(255); alter table npi_providers add other_provider_identifier_state_17 text; alter table npi_providers add other_provider_identifier_issuer_17 varchar(255); alter table npi_providers add other_provider_identifier_18 text; alter table npi_providers add other_provider_identifier_type_code_18 varchar(255); alter table npi_providers add other_provider_identifier_state_18 text; alter table npi_providers add other_provider_identifier_issuer_18 varchar(255); alter table npi_providers add other_provider_identifier_19 text; alter table npi_providers add other_provider_identifier_type_code_19 varchar(255); alter table npi_providers add other_provider_identifier_state_19 text; alter table npi_providers add other_provider_identifier_issuer_19 varchar(255); alter table npi_providers add other_provider_identifier_20 text; alter table npi_providers add other_provider_identifier_type_code_20 varchar(255); alter table npi_providers add other_provider_identifier_state_20 text; alter table npi_providers add other_provider_identifier_issuer_20 varchar(255); alter table npi_providers add other_provider_identifier_21 text; alter table npi_providers add other_provider_identifier_type_code_21 varchar(255); alter table npi_providers add other_provider_identifier_state_21 text; alter table npi_providers add other_provider_identifier_issuer_21 varchar(255); alter table npi_providers add other_provider_identifier_22 text; alter table npi_providers add other_provider_identifier_type_code_22 varchar(255); alter table npi_providers add other_provider_identifier_state_22 text; alter table npi_providers add other_provider_identifier_issuer_22 varchar(255); alter table npi_providers add other_provider_identifier_23 text; alter table npi_providers add other_provider_identifier_type_code_23 varchar(255); alter table npi_providers add other_provider_identifier_state_23 text; alter table npi_providers add other_provider_identifier_issuer_23 varchar(255); alter table npi_providers add other_provider_identifier_24 text; alter table npi_providers add other_provider_identifier_type_code_24 varchar(255); alter table npi_providers add other_provider_identifier_state_24 text; alter table npi_providers add other_provider_identifier_issuer_24 varchar(255); alter table npi_providers add other_provider_identifier_25 text; alter table npi_providers add other_provider_identifier_type_code_25 varchar(255); alter table npi_providers add other_provider_identifier_state_25 text; alter table npi_providers add other_provider_identifier_issuer_25 varchar(255); alter table npi_providers add other_provider_identifier_26 text; alter table npi_providers add other_provider_identifier_type_code_26 varchar(255); alter table npi_providers add other_provider_identifier_state_26 text; alter table npi_providers add other_provider_identifier_issuer_26 varchar(255); alter table npi_providers add other_provider_identifier_27 text; alter table npi_providers add other_provider_identifier_type_code_27 varchar(255); alter table npi_providers add other_provider_identifier_state_27 text; alter table npi_providers add other_provider_identifier_issuer_27 varchar(255); alter table npi_providers add other_provider_identifier_28 text; alter table npi_providers add other_provider_identifier_type_code_28 varchar(255); alter table npi_providers add other_provider_identifier_state_28 text; alter table npi_providers add other_provider_identifier_issuer_28 varchar(255); alter table npi_providers add other_provider_identifier_29 text; alter table npi_providers add other_provider_identifier_type_code_29 varchar(255); alter table npi_providers add other_provider_identifier_state_29 text; alter table npi_providers add other_provider_identifier_issuer_29 varchar(255); alter table npi_providers add other_provider_identifier_30 text; alter table npi_providers add other_provider_identifier_type_code_30 varchar(255); alter table npi_providers add other_provider_identifier_state_30 text; alter table npi_providers add other_provider_identifier_issuer_30 varchar(255); alter table npi_providers add other_provider_identifier_31 text; alter table npi_providers add other_provider_identifier_type_code_31 varchar(255); alter table npi_providers add other_provider_identifier_state_31 text; alter table npi_providers add other_provider_identifier_issuer_31 varchar(255); alter table npi_providers add other_provider_identifier_32 text; alter table npi_providers add other_provider_identifier_type_code_32 varchar(255); alter table npi_providers add other_provider_identifier_state_32 text; alter table npi_providers add other_provider_identifier_issuer_32 varchar(255); alter table npi_providers add other_provider_identifier_33 text; alter table npi_providers add other_provider_identifier_type_code_33 varchar(255); alter table npi_providers add other_provider_identifier_state_33 text; alter table npi_providers add other_provider_identifier_issuer_33 varchar(255); alter table npi_providers add other_provider_identifier_34 text; alter table npi_providers add other_provider_identifier_type_code_34 varchar(255); alter table npi_providers add other_provider_identifier_state_34 text; alter table npi_providers add other_provider_identifier_issuer_34 varchar(255); alter table npi_providers add other_provider_identifier_35 text; alter table npi_providers add other_provider_identifier_type_code_35 varchar(255); alter table npi_providers add other_provider_identifier_state_35 text; alter table npi_providers add other_provider_identifier_issuer_35 varchar(255); alter table npi_providers add other_provider_identifier_36 text; alter table npi_providers add other_provider_identifier_type_code_36 varchar(255); alter table npi_providers add other_provider_identifier_state_36 text; alter table npi_providers add other_provider_identifier_issuer_36 varchar(255); alter table npi_providers add other_provider_identifier_37 text; alter table npi_providers add other_provider_identifier_type_code_37 varchar(255); alter table npi_providers add other_provider_identifier_state_37 text; alter table npi_providers add other_provider_identifier_issuer_37 varchar(255); alter table npi_providers add other_provider_identifier_38 text; alter table npi_providers add other_provider_identifier_type_code_38 varchar(255); alter table npi_providers add other_provider_identifier_state_38 text; alter table npi_providers add other_provider_identifier_issuer_38 varchar(255); alter table npi_providers add other_provider_identifier_39 text; alter table npi_providers add other_provider_identifier_type_code_39 varchar(255); alter table npi_providers add other_provider_identifier_state_39 text; alter table npi_providers add other_provider_identifier_issuer_39 varchar(255); alter table npi_providers add other_provider_identifier_40 text; alter table npi_providers add other_provider_identifier_type_code_40 varchar(255); alter table npi_providers add other_provider_identifier_state_40 text; alter table npi_providers add other_provider_identifier_issuer_40 varchar(255); alter table npi_providers add other_provider_identifier_41 text; alter table npi_providers add other_provider_identifier_type_code_41 varchar(255); alter table npi_providers add other_provider_identifier_state_41 text; alter table npi_providers add other_provider_identifier_issuer_41 varchar(255); alter table npi_providers add other_provider_identifier_42 text; alter table npi_providers add other_provider_identifier_type_code_42 varchar(255); alter table npi_providers add other_provider_identifier_state_42 text; alter table npi_providers add other_provider_identifier_issuer_42 varchar(255); alter table npi_providers add other_provider_identifier_43 text; alter table npi_providers add other_provider_identifier_type_code_43 varchar(255); alter table npi_providers add other_provider_identifier_state_43 text; alter table npi_providers add other_provider_identifier_issuer_43 varchar(255); alter table npi_providers add other_provider_identifier_44 text; alter table npi_providers add other_provider_identifier_type_code_44 varchar(255); alter table npi_providers add other_provider_identifier_state_44 text; alter table npi_providers add other_provider_identifier_issuer_44 varchar(255); alter table npi_providers add other_provider_identifier_45 text; alter table npi_providers add other_provider_identifier_type_code_45 varchar(255); alter table npi_providers add other_provider_identifier_state_45 text; alter table npi_providers add other_provider_identifier_issuer_45 varchar(255); alter table npi_providers add other_provider_identifier_46 text; alter table npi_providers add other_provider_identifier_type_code_46 varchar(255); alter table npi_providers add other_provider_identifier_state_46 text; alter table npi_providers add other_provider_identifier_issuer_46 varchar(255); alter table npi_providers add other_provider_identifier_47 text; alter table npi_providers add other_provider_identifier_type_code_47 varchar(255); alter table npi_providers add other_provider_identifier_state_47 text; alter table npi_providers add other_provider_identifier_issuer_47 varchar(255); alter table npi_providers add other_provider_identifier_48 text; alter table npi_providers add other_provider_identifier_type_code_48 varchar(255); alter table npi_providers add other_provider_identifier_state_48 text; alter table npi_providers add other_provider_identifier_issuer_48 varchar(255); alter table npi_providers add other_provider_identifier_49 text; alter table npi_providers add other_provider_identifier_type_code_49 varchar(255); alter table npi_providers add other_provider_identifier_state_49 text; alter table npi_providers add other_provider_identifier_issuer_49 varchar(255); alter table npi_providers add other_provider_identifier_50 text; alter table npi_providers add other_provider_identifier_type_code_50 varchar(255); alter table npi_providers add other_provider_identifier_state_50 text; alter table npi_providers add other_provider_identifier_issuer_50 varchar(255); alter table npi_providers add is_sole_proprietor text; alter table npi_providers add is_organization_subpart varchar(255); alter table npi_providers add parent_organization_lbn text; alter table npi_providers add parent_organization_tin varchar(255); alter table npi_providers add authorized_official_name_prefix_text text; alter table npi_providers add authorized_official_name_suffix_text varchar(255); alter table npi_providers add authorized_official_credential_text text; alter table npi_providers add healthcare_provider_taxonomy_group_1 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_2 text; alter table npi_providers add healthcare_provider_taxonomy_group_3 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_4 text; alter table npi_providers add healthcare_provider_taxonomy_group_5 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_6 text; alter table npi_providers add healthcare_provider_taxonomy_group_7 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_8 text; alter table npi_providers add healthcare_provider_taxonomy_group_9 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_10 text; alter table npi_providers add healthcare_provider_taxonomy_group_11 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_12 text; alter table npi_providers add healthcare_provider_taxonomy_group_13 varchar(255); alter table npi_providers add healthcare_provider_taxonomy_group_14 text; alter table npi_providers add healthcare_provider_taxonomy_group_15 varchar(255)\n"
  1588. ]
  1589. }
  1590. ],
  1591. "source": [
  1592. "alter_table = []\n",
  1593. "varchar = True\n",
  1594. "for h in headers:\n",
  1595. " if varchar:\n",
  1596. " alter_table.append(\"alter table npi_providers add \" + h + \" varchar(255)\")\n",
  1597. " varchar = False\n",
  1598. " else:\n",
  1599. " alter_table.append(\"alter table npi_providers add \" + h + \" text\")\n",
  1600. " varchar = True\n",
  1601. "\n",
  1602. "\n",
  1603. "print(create_table + \"; \".join([at for at in alter_table[1:]]))"
  1604. ]
  1605. },
  1606. {
  1607. "cell_type": "code",
  1608. "execution_count": 13,
  1609. "metadata": {
  1610. "collapsed": false
  1611. },
  1612. "outputs": [],
  1613. "source": [
  1614. "with open(\"/Users/brydavis/Downloads/npi_headers.txt\", \"w\") as f:\n",
  1615. " line = \"\\\"\" + \"\\\",\\\"\".join(headers) + \"\\\"\\n\"\n",
  1616. " f.write(line)"
  1617. ]
  1618. },
  1619. {
  1620. "cell_type": "code",
  1621. "execution_count": null,
  1622. "metadata": {
  1623. "collapsed": true
  1624. },
  1625. "outputs": [],
  1626. "source": []
  1627. }
  1628. ],
  1629. "metadata": {
  1630. "kernelspec": {
  1631. "display_name": "Python [Root]",
  1632. "language": "python",
  1633. "name": "Python [Root]"
  1634. },
  1635. "language_info": {
  1636. "codemirror_mode": {
  1637. "name": "ipython",
  1638. "version": 3
  1639. },
  1640. "file_extension": ".py",
  1641. "mimetype": "text/x-python",
  1642. "name": "python",
  1643. "nbconvert_exporter": "python",
  1644. "pygments_lexer": "ipython3",
  1645. "version": "3.5.2"
  1646. }
  1647. },
  1648. "nbformat": 4,
  1649. "nbformat_minor": 0
  1650. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!