_dta: 1. by Jean Roth , jroth@nber.org , 30 Dec 2017 2. by Jean Roth , jroth@nber.org , 14 Dec 2017 3. NBER URL: www.nber.org/data/npi.html 4. Source Page: http://download.cms.gov/nppes/NPI_Files.html 5. Source File URL: download.cms.gov/nppes/NPPES_Data_Dissemination_Dec_2017.zip 6. Source Text File: npidata_20050523-20171210.csv* 7. by Jean Roth , jroth@nber.org , 20 Mar 2018 seq: 1. The NPI public use file has a wide shape with 50 other provider variables. 2. The seq variable indicates which Other Provider Identifier variable, othpid[1-50] , the DEA-type identifier came from. othpidty: 1. 01, OTHER 2. 02, MEDICARE UPIN 3. 04, MEDICARE ID-TYPE UNSPECIFIED 4. 05, MEDICAID 5. 06, MEDICARE OSCAR/CERTIFICATION 6. 07, MEDICARE NSC 7. 08, MEDICARE PIN othpidst: 1. AK, ALASKA, S 2. AL, ALABAMA, S 3. AR, ARKANSAS, S 4. AS, AMERICAN SAMOA, T 5. AZ, ARIZONA, S 6. CA, CALIFORNIA, S 7. CO, COLORADO, S 8. CT, CONNECTICUT, S 9. DC, DISTRICT OF COLUMBIA, T 10. DE, DELAWARE, S 11. FL, FLORIDA, S 12. FM, MICRONESIA, FEDERATED STATES OF, T 13. GA, GEORGIA, S 14. GU, GUAM, T 15. HI, HAWAII, S 16. IA, IOWA, S 17. ID, IDAHO, S 18. IL, ILLINOIS, S 19. IN, INDIANA, S 20. KS, KANSAS, S 21. KY, KENTUCKY, S 22. LA, LOUISIANA, S 23. MA, MASSACHUSETTS, S 24. MD, MARYLAND, S 25. ME, MAINE, S 26. MH, MARSHALL ISLANDS, T 27. MI, MICHIGAN, S 28. MN, MINNESOTA, S 29. MO, MISSOURI, S 30. MP, MARIANA ISLANDS, NORTHERN, T 31. MS, MISSISSIPPI, S 32. MT, MONTANA, S 33. NC, NORTH CAROLINA, S 34. ND, NORTH DAKOTA, S 35. NE, NEBRASKA, S 36. NH, NEW HAMPSHIRE, S 37. NJ, NEW JERSEY, S 38. NM, NEW MEXICO, S 39. NV, NEVADA, S 40. NY, NEW YORK, S 41. OH, OHIO, S 42. OK, OKLAHOMA, S 43. OR, OREGON, S 44. PA, PENNSYLVANIA, S 45. PR, PUERTO RICO, T 46. PW, PALAU, T 47. RI, RHODE ISLAND, S 48. SC, SOUTH CAROLINA, S 49. SD, SOUTH DAKOTA, S 50. TN, TENNESSEE, S 51. TX, TEXAS, S 52. UT, UTAH, S 53. VA, VIRGINIA, S 54. VI, VIRGIN ISLANDS, T 55. VT, VERMONT, S 56. WA, WASHINGTON, S 57. WI, WISCONSIN, S 58. WV, WEST VIRGINIA, S 59. WY, WYOMING, S 60. ZZ, Foreign Country, T entity: 1. 1, Individual 2. 2, Organization obs: 72,033 vars: 9 20 Mar 2018 16:46 size: 9,796,488 (_dta has notes) ----------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------- npi str10 %10s National Provider Identifier (NPI) seq byte %9.0g * # of Other Provider Identifier in NPPES file dea str20 %20s Drug Enforcement Agency (DEA) Number othpidty byte %28.0g othpidty * Other Provider Identifier Type Code othpidst str2 %9s * Other Provider Identifier State othpidiss str80 %80s Other Provider Identifier Issuer deatype byte %115.0g deatype Type of DEA entity byte %12.0g entity * Entity Type Code: NPI is Individual or Organization pcredential str20 %20s Provider Credential Text * indicated variables have notes ----------------------------------------------------------------------------------------------------------- Sorted by: dea npi othpidty: 1 Other 2 Medicare UPIN 4 Medicare ID-Type Unspecified 5 Medicaid 6 Medicare OSCAR/Certification 7 Medicare NSC 8 Medicare PIN deatype: 1 Hospital/Clinic/Practitioner/Teaching Institution/Pharmacy 2 Hospital/Clinic/Practitioner/Teaching Institution/Pharmacy 3 Practioner 4 Teaching Institution 5 Manufacturer 6 Hospital/Clinic/Practitioner/Teaching Institution/Pharmacy 7 Hospital/Clinic/Practitioner/Teaching Institution/Pharmacy 8 Analytic Lab 10 Importer 11 Exporter 12 Reverse Distributor 13 Mid-Level Practitioner (NP/PA/OD/ET, etc.) 16 Manufacturer/Distributor/Researcher/Analytical Lab/Importer/Exporter/Reverse Distributor/Narco > tic Treatment Program 18 Manufacturer/Distributor/Researcher/Analytical Lab/Importer/Exporter/Reverse Distributor/Narco > tic Treatment Program 19 Narcotic Treatment Program 20 Narcotic Treatment Program 21 Narcotic Treatment Program 24 Suboxone/Subutex Prescribing Program entity: 1 Individual 2 Organization