_dta: 1. by Jean Roth , jroth@nber.org , 30 May 2023 2. by Jean Roth , jroth@nber.org , 26 May 2023 3. NBER URL: www.nber.org/data/npi.html 4. Source Page: https://download.cms.gov/nppes/NPI_Files.html 5. Source File URL: 6. Source Text File: npidata_pfile_20050523-20230507.csv* 7. by Jean Roth , jroth@nber.org , 31 May 2023 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 Number-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 Contains data from /homes/nber/vecchioc/bulk/npi/data/2023/dea2npixw20235.dta Observations: 18,304 Variables: 9 31 May 2023 09:21 (_dta has notes) -------------------------------------------------------------------------------- Variable Storage Display Value 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 str9 %9s Drug Enforcement Administration (DEA) Registration Number othpidty byte %28.0g othpidty * Other Provider Identifier Type Code othpidst str2 %9s * Other Provider Identifier State othpidiss str78 %78s Other Provider Identifier Issuer deatype byte %44.0g deatype DEA Registrant Type 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 A - Deprecated (used by some older entities) 2 B - Hospital/Clinic 3 C - Practitioner 4 D - Teaching Institution 5 E - Manufacturer 6 F - Distributor 7 G - Researcher 8 H - Analytical Lab 10 J - Importer 11 K - Exporter 12 L - Reverse Distributor 13 M - Mid Level Practitioner 16 P - Narcotic Treatment Program 18 R - Narcotic Treatment Program 19 S - Narcotic Treatment Program 20 T - Narcotic Treatment Program 21 U - Narcotic Treatment Program 24 X - Suboxone/Subutex Prescribing Program entity: 1 Individual 2 Organization