In [7]:

    

#Import modules
import requests
import json
import pandas as pd


    

In [8]:

    

#Set the key
key = None


    

In [42]:

    

#Endpoint and payload
baseURL = 'https://api.census.gov/data/2015/acs5'
payload = {'get':'NAME,B01001_001E',
           'for':'county:*',
           'in':'state:37',
           'key':key
          }


    

In [43]:

    

response = requests.get(baseURL,payload)


    

In [47]:

    

t = response.text
c = response.content
print(type(t), type(c))


    

    




(<type 'unicode'>, <type 'str'>)

In [48]:

    

print t


    

    




[["NAME","B01001_001E","state","county"],
["Alamance County, North Carolina","155258","37","001"],
["Alexander County, North Carolina","37158","37","003"],
["Alleghany County, North Carolina","10911","37","005"],
["Anson County, North Carolina","26135","37","007"],
["Ashe County, North Carolina","27114","37","009"],
["Avery County, North Carolina","17695","37","011"],
["Beaufort County, North Carolina","47561","37","013"],
["Bertie County, North Carolina","20518","37","015"],
["Bladen County, North Carolina","34720","37","017"],
["Brunswick County, North Carolina","115926","37","019"],
["Buncombe County, North Carolina","247336","37","021"],
["Burke County, North Carolina","89548","37","023"],
["Cabarrus County, North Carolina","188375","37","025"],
["Caldwell County, North Carolina","81758","37","027"],
["Camden County, North Carolina","10161","37","029"],
["Carteret County, North Carolina","68228","37","031"],
["Caswell County, North Carolina","23174","37","033"],
["Catawba County, North Carolina","154610","37","035"],
["Chatham County, North Carolina","67431","37","037"],
["Cherokee County, North Carolina","27092","37","039"],
["Chowan County, North Carolina","14656","37","041"],
["Clay County, North Carolina","10656","37","043"],
["Cleveland County, North Carolina","97178","37","045"],
["Columbus County, North Carolina","57230","37","047"],
["Craven County, North Carolina","104450","37","049"],
["Cumberland County, North Carolina","324603","37","051"],
["Currituck County, North Carolina","24492","37","053"],
["Dare County, North Carolina","34863","37","055"],
["Davidson County, North Carolina","163867","37","057"],
["Davie County, North Carolina","41447","37","059"],
["Duplin County, North Carolina","59453","37","061"],
["Durham County, North Carolina","288817","37","063"],
["Edgecombe County, North Carolina","55280","37","065"],
["Forsyth County, North Carolina","361684","37","067"],
["Franklin County, North Carolina","62296","37","069"],
["Gaston County, North Carolina","209807","37","071"],
["Gates County, North Carolina","11724","37","073"],
["Graham County, North Carolina","8700","37","075"],
["Granville County, North Carolina","58109","37","077"],
["Greene County, North Carolina","21328","37","079"],
["Guilford County, North Carolina","506763","37","081"],
["Halifax County, North Carolina","53407","37","083"],
["Harnett County, North Carolina","124320","37","085"],
["Haywood County, North Carolina","59170","37","087"],
["Henderson County, North Carolina","109719","37","089"],
["Hertford County, North Carolina","24368","37","091"],
["Hoke County, North Carolina","51075","37","093"],
["Hyde County, North Carolina","5693","37","095"],
["Iredell County, North Carolina","165066","37","097"],
["Jackson County, North Carolina","40812","37","099"],
["Johnston County, North Carolina","178396","37","101"],
["Jones County, North Carolina","10166","37","103"],
["Lee County, North Carolina","59418","37","105"],
["Lenoir County, North Carolina","58782","37","107"],
["Lincoln County, North Carolina","79578","37","109"],
["McDowell County, North Carolina","44961","37","111"],
["Macon County, North Carolina","33919","37","113"],
["Madison County, North Carolina","21027","37","115"],
["Martin County, North Carolina","23729","37","117"],
["Mecklenburg County, North Carolina","990288","37","119"],
["Mitchell County, North Carolina","15330","37","121"],
["Montgomery County, North Carolina","27601","37","123"],
["Moore County, North Carolina","91743","37","125"],
["Nash County, North Carolina","94722","37","127"],
["New Hanover County, North Carolina","213091","37","129"],
["Northampton County, North Carolina","21011","37","131"],
["Onslow County, North Carolina","183753","37","133"],
["Orange County, North Carolina","138644","37","135"],
["Pamlico County, North Carolina","12982","37","137"],
["Pasquotank County, North Carolina","40018","37","139"],
["Pender County, North Carolina","55166","37","141"],
["Perquimans County, North Carolina","13498","37","143"],
["Person County, North Carolina","39262","37","145"],
["Pitt County, North Carolina","173798","37","147"],
["Polk County, North Carolina","20327","37","149"],
["Randolph County, North Carolina","142370","37","151"],
["Richmond County, North Carolina","46046","37","153"],
["Robeson County, North Carolina","134871","37","155"],
["Rockingham County, North Carolina","92300","37","157"],
["Rowan County, North Carolina","138361","37","159"],
["Rutherford County, North Carolina","66865","37","161"],
["Sampson County, North Carolina","63873","37","163"],
["Scotland County, North Carolina","35932","37","165"],
["Stanly County, North Carolina","60586","37","167"],
["Stokes County, North Carolina","46661","37","169"],
["Surry County, North Carolina","73170","37","171"],
["Swain County, North Carolina","14163","37","173"],
["Transylvania County, North Carolina","32928","37","175"],
["Tyrrell County, North Carolina","4152","37","177"],
["Union County, North Carolina","213422","37","179"],
["Vance County, North Carolina","44829","37","181"],
["Wake County, North Carolina","976019","37","183"],
["Warren County, North Carolina","20468","37","185"],
["Washington County, North Carolina","12668","37","187"],
["Watauga County, North Carolina","52240","37","189"],
["Wayne County, North Carolina","124355","37","191"],
["Wilkes County, North Carolina","68946","37","193"],
["Wilson County, North Carolina","81581","37","195"],
["Yadkin County, North Carolina","37971","37","197"],
["Yancey County, North Carolina","17604","37","199"]]

In [ ]:

    

#Get list of variables
dfVars = pd.read_json('http://api.census.gov/data/2012/sbo')
dfVars.dataset.values[0]['description']


    

In [ ]:

    

endpointURL = 'api.census.gov/data/2012/sbo'