U.S. flag

An official website of the United States government

Department of Labor Logo United States Department of Labor
Dot gov

The .gov means it's official.
Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you're on a federal government site.

Https

The site is secure.
The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted securely.

Accessing the Public Data API with Python

 

Multiple Series and Multiple Years

Use this code to retrieve data for more than one timeseries and more than one year.

Sample Python Script:

import requests
import json
import prettytable
headers = {'Content-type': 'application/json'} 
data = json.dumps({"seriesid": ['CUUR0000SA0','SUUR0000SA0'],"startyear":"2011", "endyear":"2014"}) 
p = requests.post('https://api.bls.gov/publicAPI/v2/timeseries/data/', data=data, headers=headers) 
json_data = json.loads(p.text) 
for series in json_data['Results']['series']:
    x=prettytable.PrettyTable(["series id","year","period","value","footnotes"])
    seriesId = series['seriesID']
    for item in series['data']:
        year = item['year']
        period = item['period']
        value = item['value']
        footnotes=""
        for footnote in item['footnotes']:
            if footnote:
                footnotes = footnotes + footnote['text'] + ','
        if 'M01' <= period <= 'M12':
            x.add_row([seriesId,year,period,value,footnotes[0:-1]])
    output = open("c:\\temp\\" + seriesId + ".txt","w")
    output.write (x.get_string())
    output.close()

 

 

Acknowledgments:

The BLS API Team thanks Mark McEnearney for contributing the above sample Python Script.

 

Last Modified Date: October 16, 2014