Provider Data Service – Directions for Downloading Historical PSF Data 1
Provider Data Service
Directions for Downloading Historical PSF Data
Figure 1. Download the full Provider Specific File (PSF) or a filtered subset by URL
Full PSF
-
Filtered Subset
Returns full historical data by URL
as a CSV file
Large file (157MB) that can take 1
min+ to download
Beneficial if you are comfortable
with filtering down a large static file
using programs like Excel
-
Enter custom filters manually as
query strings in the URL of your
browser
Beneficial if you want a smaller file
targeted to your needs
Save the URL and re-use to return
updated data in the future
You can download filtered data as a
CSV file or up to 3 years of data as
an Excel file
Note: The current version includes only the Inpatient historical PSF data for all Part A institutions
and facilities. Outpatient historical PSF data will be available in a future release.
Provider Data Service – Directions for Downloading Historical PSF Data 2
Table of Contents
Download the Full PSF ........................................................................................................................................... 3
Download Full PSF URL ................................................................................................................................... 3
Download a Subset Using Custom URL Filters..................................................................................................... 3
1. Basic Rules ................................................................................................................................................. 3
2. Filter by Effective Date ............................................................................................................................... 3
Example: fromDate URL ............................................................................................................. 3
Example: toDate URL .................................................................................................................. 4
Example: fromDate and toDate URL ........................................................................................... 4
3. Filter by Oscar (Provider) Number .............................................................................................................. 4
Example: Oscar Number URL ..................................................................................................... 4
Example: Multiple Oscar Numbers URL ..................................................................................... 4
4. Filter by National Provider Identifier (NPI) ................................................................................................ 4
Example: NPI URL ...................................................................................................................... 4
Example: Multiple NPIs URL ...................................................................................................... 5
5. Filter by Facility Type (for User with Pricers) ............................................................................................. 5
Example: Skilled Nursing Facility (SNF) Pricer Type URL......................................................... 5
6. Filter by Intermediary Number (Medicare Administrative Contractors) ...................................................... 5
Example: Skilled Nursing Facility (SNF) Pricer Type URL......................................................... 5
7. Filter by State Abbreviation ........................................................................................................................ 6
Example: Single State Abbreviation URL .................................................................................... 6
Example: Multiple State Abbreviation URL ................................................................................ 6
8. Filter by Format .......................................................................................................................................... 6
Example: Excel Format URL ....................................................................................................... 6
9. Combining Filters ....................................................................................................................................... 6
You can combine parameters to apply multiple filters at once by using the “&” symbol.
Example: All records effective from January 1, 2015 for hospice providers: ............................... 6
How to Keep Leading Zeros with CSV Files in Excel ........................................................................................... 7
Appendix A ............................................................................................................................................................. 9
Intermediary Number Reference Sheet .............................................................................................................. 9
Appendix B ........................................................................................................................................................... 10
State Code Reference Sheet ............................................................................................................................. 10
Provider Data Service – Directions for Downloading Historical PSF Data 3
Download the Full PSF
Note that entering the following URL in your browser will export a large file (157 MB) of all historical
data for all Part A institutional providers, dating back to the 1980s.
Download Full PSF URL
pds.webpricer.cms.gov/fiss/inpatient/export
Download a Subset Using Custom URL Filters
You can also filter the data you download by manually entering in query string parameters as a URL. In
the future, a graphical user interface (GUI) will be developed to enable more user-friendly filtering.
Figure 2. Add filtering parameters to the base URL in your browser
1. Basic Rules
Use “?” to introduce the first parameter after base URL
Use “=” to set the value of a parameter
Use “&” to combine multiple parameters
2. Filter by Effective Date
The effectiveDate column indicates the date that a PSF with new rates became effective for a provider.
You can filter the bulk data file to a specific date range using the fromDate and toDate parameters. The
date format is YYYY-MM-DD.
Example: fromDate URL
pds.webpricer.cms.gov/fiss/inpatient/export?fromDate=2015-01-01
Provider Data Service – Directions for Downloading Historical PSF Data 4
Example: toDate URL
pds.webpricer.cms.gov/fiss/inpatient/export?toDate=2020-12-31
Example: fromDate and toDate URL
pds.webpricer.cms.gov/fiss/inpatient/export?fromDate=2015-01-01&toDate=2020-12-31
If fromDate is not specified, all records with effective dates up to and including the toDate will return. If
toDate is not specified, all records with effective dates on and after the fromDate will be returned. If both
fromDate and toDate are specified, all records with effective dates on or between the two dates will be
returned.
3. Filter by Oscar (Provider) Number
The oscarNumber column contains the unique number assigned to a provider. You can filter the bulk data
file by the Oscar number using the format XXXXXX. Up to 15 Oscar Numbers can be specified at a time
using the “&” symbol.
Example: Oscar Number URL
pds.webpricer.cms.gov/fiss/inpatient/export?oscarNumber=100001
Example: Multiple Oscar Numbers URL
pds.webpricer.cms.gov/fiss/inpatient/export?oscarNumber=100001&oscarNumber=100002
4. Filter by National Provider Identifier (NPI)
The nationalProviderIdentifier column contains the unique number assigned to a provider. You can filter
the bulk data file by the NPI using the format XXXXXXXXXX. Up to 15 NPIs can be specified at a time
using the “&” symbol.
Example: NPI URL
pds.webpricer.cms.gov/fiss/inpatient/export?npi=1234567890
Provider Data Service – Directions for Downloading Historical PSF Data 5
Example: Multiple NPIs URL
pds.webpricer.cms.gov/fiss/inpatient/export?npi=1234567890&npi=1234567891
5. Filter by Facility Type
CMS currently groups Part A institutional providers into seven facility types, each of which corresponds
to a different payment system. The Provider Specific File includes a Provider Type value for each
provider, which corresponds to its facility type. Only 1 facilityType can be specified per URL request.
Table 1. Seven Part A Facility Types
Facility Type
FacilityType
Parameter for URL
Provider Type
Inpatient (Acute Care)
INP 00, 01, 07, 08, 09, 10, 11, 13, 14, 15, 16,
17, 18, 21 or 22
Skilled Nursing Facility
SNF 38, 51, 52 or 53
Inpatient Psychiatric Facility
IPF 03 or 49
Home Health Agency
HHA 36
Hospice
HOS 35
Inpatient Rehabilitation Facility
IRF 04, 06 or 50 or the third position of
Provider Number is T or R
Long-Term Care Hospital
LTCH 02
Example: Skilled Nursing Facility (SNF) Facility Type URL
pds.webpricer.cms.gov/fiss/inpatient/export?facilityType=SNF
6. Filter by Intermediary Number (Medicare Administrative Contractors)
The intermediaryNumber column contains the unique number assigned to an Intermediary, or Medicare
Administrative Contractor, for each provider. You can filter the bulk data file by the Intermediary using
the format XXXXX. Only one Intermediary can be specified per URL request.
Example: Skilled Nursing Facility (SNF) Pricer Type URL
pds.webpricer.cms.gov/fiss/inpatient/export?intermediary=00010
For all Intermediary Numbers, see Appendix A: Intermediary Number Reference Sheet.
Provider Data Service – Directions for Downloading Historical PSF Data 6
7. Filter by State Abbreviation
You can filter the bulk data file by state using the format XX. Up to ten states can be specified at a time.
Note that the Provider Specific File includes a numeric State Code for each provider. Some states are
divided into multiple State Codes. Using the State Abbreviation filter in the URL will capture all State
Codes for a given state.
For all state codes, see Appendix B: State Code Reference Sheet.
Example: Single State Abbreviation URL
pds.webpricer.cms.gov/fiss/inpatient/export?state=VA
Example: Multiple State Abbreviation URL
pds.webpricer.cms.gov/fiss/inpatient/export?state=CO&state=IA
8. Filter by File Format
The Format filter allows for selection of either Excel or CSV. If the format is not specified it will default
to CSV. Note that the Excel format requires you to specify a date range of 3 years or less due to the large
file sizes generated. Depending on the filters used, an Excel file download may take up to 2 minutes.
Example: Excel Format URL
pds.webpricer.cms.gov/fiss/inpatient/export?format=excel
9. Combining Filters
You can combine parameters to apply multiple filters at once by using the “&” symbol.
Example: All records effective from January 1, 2015 for hospice providers:
pds.webpricer.cms.gov/fiss/inpatient/export?fromDate=2015-01-01&facilityType=HOS
Provider Data Service – Directions for Downloading Historical PSF Data 7
How to Keep Leading Zeros with CSV Files in Excel
When opening a CSV file, leading zeros are not formatted appropriately in Excel by default and will
cause Excel to drop leading zeros from some columns. There are steps that can be taken to prevent the
format change using Excel’s Text Import Wizard:
1. Save the CSV file to your computer.
2. Right click on the saved file and rename the file by adding .txt to the file extension.
3. Select “yes” when asked if you are sure you want to change the file name extension. (If on a Mac
system, click “Use .txt”).
4. Open Excel. Select File > Open and Browse.
5. Select the file with the .txt file extension. You may need to change the file type to “all files” to
locate. Open the file.
6. The Text Import Wizard will launch.
7. Click the "Delimited" radio button in the Text Import Wizard. Select Next.
8. Deselect the "Tab," and select "Comma" from the list. Click the "Next" button.
9. Select the “Text” radio button.
10. Select the first column in the wizard, scroll right to the last column, select shift, and click on the
last column. This action will select all columns to ensure your changes apply to all the data.
11. Click the "Finish" button. The file will now open in Excel with leading zeros intact.
Provider Data Service – Directions for Downloading Historical PSF Data 8
We value your feedback
We’d love to hear from you! Was this new service useful to you? What can we improve? No ask is too
small. Our goal is to enhance your experience as we modernize access to the Provider Specific File.
Please email Modernizing Medicare (ModernizingMedicare@cms.hhs.gov) with the subject line
“Provider Specific File Feedback” with your comments or suggestions.
Provider Data Service – Directions for Downloading Historical PSF Data 9
Appendix A
Intermediary Number Reference Sheet
Table 2. Intermediary Number Reference Sheet
VDC
Jurisdiction
MAC
Intermediary #
CDS
JJ - Georgia Cahaba 10201
CDS
JJ - Tennessee Cahaba 10301
CDS
JJ - Alabama Cahaba 10101
CDS
JN - Florida FCSO 09101
CDS
JN - Puerto Rico FCSO 09201
CDS
JL - Delaware Novitas-Solutions 12101
CDS
JL - DC/MD/NJ/PA Novitas-Solutions 12001
CDS
JL - Legacy (DC, DE, MD, NJ and PA) Novitas-Solutions 12901
CDS
JH - Colorado/New Mexico/Texas Novitas-Solutions 04011
CDS
JH - Arkansas/Louisiana/Mississippi Novitas-Solutions 07001
CDS
JH - Oklahoma Novitas-Solutions 04311
CDS
JH - Legacy (CO, NM, TX and OK) Novitas-Solutions 04911
CDS
JM - Virginia/W. Virginia Palmetto 11003
CDS
JM - North Carolina Palmetto 11501
CDS
JM - South Carolina Palmetto 11001
Perspecta
J15 - KY Cigna 15101
Perspecta
J15 - OH Cigna 15201
Perspecta
J15 - RHHI Cigna 15004
Perspecta
J6 - Illinois NGS 06101
Perspecta
J6 - MN NGS 06201
Perspecta
J6 - NGS RHHI NGS 06014
Perspecta
J6 - WI NGS 06001
Perspecta
JK - CT/NY NGS 13001
Perspecta
JK - Maine NGS 14011
Perspecta
JK - Mass NGS 14211
Perspecta
JK - NH/VT NGS 14013
Perspecta
JK - RI NGS 14411
Perspecta
JE - CA/ HI/ NV Noridian 01011
Perspecta
JE - FISS Alt Int - Am Samoa, N Mar Islands Noridian 01911
Perspecta
JF - 21 AK/ WA/ OR/ ID Noridian 02001
Perspecta
JF - AZ/ UT/ MT/ ND/ SD/ WY Noridian 03001
Perspecta
J5 - IA, KS, MO, NE WPS 05001
Perspecta
J5 - National (Legacy) (NTA) WPS 05901
Provider Data Service – Directions for Downloading Historical PSF Data 10
VDC Jurisdiction MAC Intermediary #
Perspecta
J8 - IN WPS 08101
Perspecta
J8 - MI WPS 08201
Perspecta
Skyward DEV Core (based on WPS J5) Skyward 05001
Appendix B
State Code Reference Sheet
Table 3. State Code Reference Sheet
State State Abbreviation for URL State Code
Alabama
AL 01
Alaska
AK 02
Arizona
AZ 00, 03
Arkansas
AR 04, 89
California
CA 05, 55, 75, 92, A0, A1, B2
Colorado
CO 06, 91
Connecticut
CT 07, 81
Delaware
DE 08
District of Columbia
DC 09
Florida
FL 10, 68, 69, A2
Georgia
GA 11, 85
Hawaii
HI 12
Idaho
ID 13, 54
Illinois
IL 14, 78
Indiana
IN 15
Iowa
IA 16, 76
Kansas
KS 17, 70
Kentucky
KY 18, B0
Louisiana
LA 19, 71, 95, A3
Maine
ME 20
Maryland
MD 21, 80
Massachusetts
MA 22, 82
Michigan
MI 23, A4
Minnesota
MN 24, 77
Mississippi
MS 25, A5
Missouri
MO 26, 79
Montana
MT 27
Provider Data Service – Directions for Downloading Historical PSF Data 11
State State Abbreviation for URL State Code
Nebraska
NE 28
Nevada
NV 29
New Hampshire
NH 30
New Jersey
NJ 31, 83
New Mexico
NM 32, 96
New York
NY 33, 57
North Carolina
NC 34, 86
North Dakota
ND 35
Ohio
OH 36, 72, A6
Oklahoma
OK 37, 90
Oregon
OR 38, 93
Pennsylvania
PA 39, 73, A7
Puerto Rico
PR 40, 84
Rhode Island
RI 41
South Carolina
SC 42, 87
South Dakota
SD 43
Tennessee
TN 44, 88, A8
Texas
TX 45, 67, 74, 97, A9
Utah
UT 46
Vermont
VT 47
Virgin Islands
VI 48
Virginia
VA 49
Washington
WA 50, 94
West Virginia
WV 51, 58, B1
Wisconsin
WI 52
Wyoming
WY 53
Canada
N/A 56
Mexico
N/A 59
American Samoa
AS 64
Guam
GU 65
Commonwealth of the Northern
Marianas Islands
MP 66
Foreign Countries (exceptions:
Canada and Mexico)
N/A 99
Last updated: June 1, 2021
