Header fails in the last step.

[pomerham]

Im not sure what Im missing. Everything is working but the last step of the header. Any suggestions?

import csv import requests from BeautifulSoup import BeautifulSoup

url = 'http://www.showmeboone.com/sheriff/JailResidents/JailResidents.asp' response = requests.get(url) html = response.content

soup = BeautifulSoup(html) table = soup.find('tbody', attrs={'class': 'stripe'})

list_of_rows = [] for row in table.findAll('tr')[1:]: list_of_cells = [] for cell in row.findAll('td'): text = cell.text.replace(' ' , '') list_of_cells.append(text) list_of_rows.append(list_of_cells)

outfile = open("./inmates.csv", "wb") writer = csv.writer(outfile) writer.writerow(["Last", "First", "Middle", "Gender", "Race", "Age", "City", "State"]) writer.writerows(list_of_rows) ~ ~

-============

Here is the output in text. Same results in excel.

Details,ADAM,OMER,SIRAJ,M,B,29,COLUMBIA,MO Details,ALEXANDER,BENJAMIN,FRANKLIN,M,B,22,COLUMBIA,MO Details,AMAN,JUSTIN,TYLER,M,B,36,COLUMBIA,MO Details,ANDREWS,JOSEPH,DAMON,M,W,39,COLUMBIA,MO Details,ARTEAGA,BRAYAN,OSIRIS-CACHO,M,H,25,JEFFERSON CITY,MO Details,AUSTIN,KAY,CEE,F,W,33,KANSAS CITY,MO Details,AVALOS-AVALOS,JOSE,,M,H,18,ST.ANN,MO Details,BARRETT,NICHOLE,RAYSHEA,F,B,31,COLUMBIA,MO Details,BENNETT,EMAS,CASSELL,M,B,38,KANSAS CITY,MO Details,BENNETT,VONTHILLA,MARIE,F,B,52,COLUMBIA,MO Details,BERARDI,DEBORAH,EVA,F,W,55,COLUMBIA,MO Details,BERETS,HARRISON,COLE,M,W,21,COLUMBIA,MO Details,BERGESCH,CHRISTOPHER,JAMES,M,W,25,FULTON,MO Details,BEUER,CHRISTOPHER,TODD,M,W,35,COLUMBIA,MO Details,BLAIR,RYAN,WADE,M,W,25,MEXICO,MO Details,BLAND,RANDY,LAMONT,M,B,22,SPRINGFIELD,MO Details,BODINE,EDITH,JOYCE,F,W,41,MOBERLY,MO Details,BOGART,COURTNEY,LEE,M,W,39,COLUMBIA,MO Details,BONAPARTE,NATHANIEL,LEROY,M,B,38,COLUMBIA,MO Details,BOWERS,ARRINGTON,LEE,M,B,50,COLUMBIA,MO Details,BRADLEY,JAMIE,MICHELLE,F,W,32,COLUMBIA,MO Details,BROOKINS,OSCAR,MENTER,M,B,28,COLUMBIA,MO Details,BROOKINS,QUANTRELL,TRAVEION,M,B,26,COLUMBIA,MO Details,BROWN,JARRELL,DORAN,M,B,19,KANSAS CITY,MO Details,BUCHANAN,CHARLES,MARLEON,M,B,25,COLUMBIA,MO Details,BURKS,JUSTIN,JAY,M,W,41,FULTON,MO Details,BURTON,RICK,DONNELL,M,B,53,ST LOUIS,MO Details,CANNELL,MAC,GARNETT,M,W,32,COLUMBIA,MO Details,CARRASQUILLO-MARTINEZ,ANGEL,LUIS,M,H,35,JACKSON,MO Details,CARTER,DARIAN,MAURICE,M,B,24,COLUMBIA,MO Details,CARTER,DEMARCO,RAYDELL,M,B,21,COLUMBIA,MO Details,CARTER,KORJANAE,FORSTEIN,F,B,23,COLUMBIA,MO Details,CEFERINO,APAEZ,ESTELA,M,H,29,COLUMBIA,MO Details,CHASE,JULIAN,FULLER,M,B,23,COLUMBIA,MO Details,CLARKSON,RODNEY,ALEXANDER,M,B,25,COLUMBIA,MO Details,CLAYTON,DEWAYNE,EDWARD,M,W,51,COLUMBIA,MO Details,COATES,JOSHUA,EDWARD,M,W,35,ROCHEPORT,MO Details,COLLINS,DENNIS,CARL,M,B,32,COLUMBIA,MO Details,CONTRERAS,JOEY,,M,W,29,MARSHALL,MO Details,CRUM,CHRISTOPHER,KHAN,M,B,37,COLUMBIA,MO Details,CRUSBY-DANIELS,RAYMONDRE,MACK,M,B,19,FULTON,MO Details,CUNNINGHAM,MYLONYO,TRAMIRE,M,B,24,COLUMBIA,MO Details,DALTON,NEIL,LANCE,M,W,29,COLUMBIA,MO Details,DAVIS,KAYLA,REBECCA,F,W,27,COLUMBIA,MO Details,DEACON,DUSTIN,ODALE,M,W,24,COLUMBIA,MO Details,DELVON,ANTONIO,KEVON,M,B,24,COLUMBIA,MO Details,DENNY,DEANDRE,LAVELLE,M,B,20,COLUMBIA,MO Details,DIAZ,MARIBEL,MARIE,F,H,18,COLUMBIA,MO Details,DORE,ROBERT,LEE,M,W,29,COLUMBIA,MO Details,DOWNS,WILLIAM,CHARLES,M,W,42,JEFFERSON CITY,MO