Can't copy csv file into Heroku database

[MarcyNash]

Running heroku pg:psql to bulk load a csv file to seed the concerts table fails. Had no trouble reading it into my local project.

When I try to read it into the deployed project on Heroku, I get the following error:

salty-shore-97321::DATABASE-> \copy concerts(concert_name,concert_date,concert_time,artist, venue,venue_address,cost) FROM 'csv/concerts1.csv' WITH (FORMAT csv, HEADER true) ERROR: extra data after last expected column CONTEXT: COPY concerts, line 2: "Maverick Concerts presents,"Sunday, July 16, 2017",4:00 PM,Parker String Quartet,120 Maverick Rd,Woo..." salty-shore-97321::DATABASE->

[payne-chris-r]

How many lines is the file? It can't process very large csv files. (I think it's 1k it 10k+)

[payne-chris-r]

Can you post the raw text from the file?

[MarcyNash]

This is a copy of the file I'm trying to use to seed the concerts table --

concert_name,concert_date,concert_time,artist,venue,venue_address,cost, created_at,updated_at
Maverick Concerts presents,"Sunday, July 16, 2017",4:00 PM,Parker String Quartet,120 Maverick Rd,Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Electric Earth Concerts presents,"Saturday, August 26, 2017",7:30 PM,Horszowski Trio,"120 Maverick Rd, Woodstock, Various NH locations",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, July 23, 2017",4:00 PM,Jasper String Quartet,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, July 30, 2017",4:00 PM,Trio con Brio Copenhagen,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, August 6, 2017",4:00 PM,Dover String Quartet,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, August 13, 2017",4:00 PM,Harlem Quartet,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, August 20, 2017",4:00 PM,Amernet String Quartet,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Saturday, August 26, 2017",6:00 PM,CHAMBER ORCHESTRA CONCERT,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, August 27, 2017",4:00 PM,Trio Solisti,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, September 3, 2017",4:00 PM,Horszowski Trio,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Maverick Concerts presents,"Sunday, September 10, 2017",4:00 PM,Shanghai Quartet,"120 Maverick Rd, Woodstock, Woodstock",Woodstock,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
First Baptist Church of Medford presents,"Friday, August 25, 2017",7:00 PM,Matisse Trio,"29 Oakland St., Medford",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Thursday, July 13, 2017",8:00 PM,Chamber Music,49 Main St,"Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Friday, July 14, 2017",8:00 PM,Chamber Music,49 Main St,"Putney, Vt",25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Saturday, July 15, 2017",8:00 PM,Chamber Music,49 Main St,"Putney, Vt",25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Thursday, July 20, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Friday, July 21, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Saturday, July 22, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Tuesday, July 25, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Wednesday, July 26, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Thursday, July 27, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Friday, July 28, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Saturday, July 29, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Tuesday, August 1, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Wednesday, August 2, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Thursday, August 3, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Friday, August 4, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Saturday, August 5, 2017",12:30 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",18,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Yellow Barn presents,"Saturday, August 5, 2017",8:00 PM,Chamber Music,"49 Main St, Putney, Vt","Putney, Vt",28,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Wednesday, August 2, 2017",7:30 PM,Lydian String Quartet,"Church of the Holy Spirit, Olreans",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Monday, August 21, 2017",7:30 PM,Ying Quartet,"Church of the Holy Spirit, Olreans",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Tuesday, August 1, 2017",7:30 PM,Brahms in the Café,"Cotuit Center for the Arts, Cotuit",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Tuesday, August 8, 2017",7:30 PM,The Teacher and the Student,"Cotuit Center for the Arts, Cotuit",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Tuesday, August 15, 2017",7:30 PM,Borromeo String Quartet,"Cotuit Center for the Arts, Cotuit",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (CT) presents,"Friday, July 14, 2017",7:30 PM,Chamber Music,Croocker Theater,Brunswick,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (CT) presents,"Friday, August 4, 2017",7:30 PM,Chamber Music,"Croocker Theater, Brunswick",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Wednesday, August 16, 2017",7:30 PM,Borromeo String Quartet,"Dennis Union Church, Dennis",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Ellingwood Chapel Concert Series (EC) presents,"Saturday, July 15, 2017",8:00 PM,Fin de Siècle,"Ellingwood Chapel, 195 Nahant Rd",Nahant,25,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Ellingwood Chapel Concert Series (EC) presents,"Saturday, August 19, 2017",8:00 PM,"Jose Lezcano, Guitar","Ellingwood Chapel, 195 Nahant Rd., Nahant",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Ellingwood Chapel Concert Series (EC) presents,"Saturday, September 9, 2017",8:00 PM,"Thomas Stumpf, piano","Ellingwood Chapel, 195 Nahant Rd., Nahant",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Electric Earth Concerts presents,"Sunday, September 10, 2017",4:00 PM,ACRONYM baroque ensemble,"Ellingwood Chapel, 195 Nahant Rd., Various NH locations",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Mohawk Trails Concerts presents,"Saturday, July 15, 2017",7:30 PM,"Matt Haimovitz, cello, and Estela Olevsky, piano",Federated Church,Charlemont,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Mohawk Trails Concerts presents,"Saturday, July 22, 2017",7:30 PM,"Christopher Hall, clarinet / comedian with","Federated Church, Charlemont",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Thursday, August 10, 2017",7:30 PM,Chamber Music,"First Congregational Church, Chatham",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Wednesday, August 23, 2017",7:30 PM,Ying Quartet,"First Congregational Church, Chatham",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Friday, August 4, 2017",7:30 PM,The Power of Wind,"First Congregational Church, Wellfleet",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Monday, August 7, 2017",7:30 PM,Emerson String Quartet,"First Congregational Church, Wellfleet",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Friday, August 18, 2017",7:30 PM,Rossini’s Petite Messe Solennelle,"First Congregational Church, Wellfleet",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Cape Cod Chamber Music Festival presents,"Friday, August 25, 2017",7:30 PM,Ying Quartet,"First Congregational Church, Wellfleet",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, July 19, 2017",7:00 PM,Opening Night,Hatch Shell Boston Esplanade,Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, July 26, 2017",7:00 PM,Mercury Orchestra,Hatch Shell Boston Esplanade,Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, July 26, 2017",7:00 PM,Mercury Orchestra,Hatch Shell Boston Esplanade,Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, August 2, 2017",7:00 PM,Beethoven – Symphony #9,"Hatch Shell Boston Esplanade, Boston",Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, August 9, 2017",7:00 PM,Anthems of the World,"Hatch Shell Boston Esplanade, Boston",Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, August 16, 2017",7:00 PM,Longwood Symphony Orchestra,"Hatch Shell Boston Esplanade, Boston",Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Landmarks Orchestra presents,"Wednesday, August 23, 2017",7:00 PM,Landmarks Dance Carnival,"Hatch Shell Boston Esplanade, Boston",Boston,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, July 14, 2017",8:00 PM,"Andris Nelsons, conductor",Koussevitzky Music Shed,Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, July 15, 2017",10:30 AM,"Andris Nelsons, conductor",Koussevitzky Music Shed,Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, July 15, 2017",8:00 PM,"Andris Nelsons, conductor",Koussevitzky Music Shed,Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Sunday, July 16, 2017",2:30 PM,"Andris Nelsons, conductor",Koussevitzky Music Shed,Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, July 21, 2017",8:00 PM,"Gustavo Gimeno, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, July 22, 2017",10:30 AM,"Ken-David Masur, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, July 22, 2017",8:00 PM,"Thomas Adès, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Sunday, July 23, 2017",2:30 PM,"Ken-David Masur, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, July 28, 2017",8:00 PM,"Charles Dutoit, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, July 29, 2017",10:30 AM,"Bramwell Tovey, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, July 29, 2017",8:00 PM,"Charles Dutoit, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Tuesday, August 1, 2017",8:00 PM,Tanglewood on Parade,"Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, August 4, 2017",8:00 PM,"Hans Graf, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 5, 2017",10:30 AM,"Christoph von Dohnányi, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 5, 2017",8:00 PM,"Hans Graf, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Sunday, August 6, 2017",2:30 PM,"Christoph von Dohnányi, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, August 11, 2017",10:30 AM,"Lahav Shani, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, August 11, 2017",8:00 PM,"Giancarlo Guerrero, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 12, 2017",2:30 PM,"Lahav Shani, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 12, 2017",8:00 PM,"Christoph von Dohnányi, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Friday, August 18, 2017",8:00 PM,"David Afkham, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 19, 2017",10:30 AM,"Andris Nelsons, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Sunday, August 20, 2017",2:30 PM,"Andris Nelsons, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 26, 2017",10:30 AM,"Andris Nelsons, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Saturday, August 26, 2017",8:00 PM,"Andris Nelsons, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (K) presents,"Sunday, August 27, 2017",2:30 PM,"Andris Nelsons, conductor","Koussevitzky Music Shed, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Electric Earth Concerts presents,"Sunday, August 20, 2017",4:00 PM,Borromeo String Quartet,"Koussevitzky Music Shed, Various NH locations","MIT, Cambridge",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Mercury Orchestra (K) presents,"Saturday, August 12, 2017",8:00 PM,Mercury Orchestra,"Kresge Auditorium, MIT, Cambridge",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Metropolitan Wind Symphony presents,"Thursday, July 13, 2017",7:30 PM,MetWinds Band Concerts in the Park,National Heritage Museum,"33 Marrett Road, Lexington, MA",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Metropolitan Wind Symphony presents,"Thursday, July 27, 2017",7:30 PM,MetWinds Band Concerts in the Park,National Heritage Museum,"33 Marrett Road, Lexington, MA",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Metropolitan Wind Symphony presents,"Thursday, July 20, 2017",7:30 PM,MetWinds Band Concerts in the Park,"National Heritage Museum, 33 Marrett Road, Lexington, MA, Lexington",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts presents,"Monday, July 24, 2017",7:30 PM,"Yinfei Wang 王寅飛, pianist","Orchard Cove Senior Community, One Del Pond Dr., Canton",,5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Aston Magna (SJP) presents,"Saturday, July 15, 2017",6:00 PM,Chamber Music,Saint James Place,"352 Main Street, Great Barrington",45,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Electric Earth Concerts presents,"Saturday, July 15, 2017",7:30 PM,Serenade,Saint James Place,"352 Main Street, Great Barrington",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Mercury Orchestra presents,"Saturday, July 15, 2017",8:00 PM,Mercury Orchestra,Sanders Theatre,"45 Quincy Street, Cambridge",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Monday, July 17, 2017",8:00 PM,Tanglewood Music Center Orchestra,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Wednesday, July 19, 2017",8:00 PM,Emerson String Quartet,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Thursday, July 20, 2017",8:00 PM,Emerson String Quartet,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Monday, July 24, 2017",8:00 PM,Tanglewood Music Center Orchestra,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Wednesday, July 26, 2017",8:00 PM,Chamber Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Thursday, July 27, 2017",8:00 PM,"Pierre-Laurent Aimard, piano","Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Sunday, July 30, 2017",2:30 PM,Young Artists Wind Ensemble,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Thursday, August 3, 2017",8:00 PM,Schubert’s Summer Journey,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Tuesday, August 8, 2017",8:00 PM,"Garrick Ohlsson, piano","Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Wednesday, August 9, 2017",8:00 PM,Handel and Haydn Society,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Thursday, August 10, 2017",8:00 PM,Festival of Contemporary Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Friday, August 11, 2017",2:30 PM,Festival of Contemporary Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Saturday, August 12, 2017",8:00 PM,Festival of Contemporary Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Sunday, August 13, 2017",10:00 AM,Festival of Contemporary Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Sunday, August 13, 2017",8:00 PM,Festival of Contemporary Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Monday, August 14, 2017",8:00 PM,Festival of Contemporary Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Wednesday, August 16, 2017",8:00 PM,Chamber Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Thursday, August 17, 2017",8:00 PM,Schubert’s Summer Journey,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Sunday, August 20, 2017",10:00 AM,Chamber Music,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Boston Symphony Tanglewood (SOH) presents,"Wednesday, August 23, 2017",8:00 PM,Schubert’s Summer Journey,"Seiji Ozawa Hall, Lenox",Lenox,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Aston Magna (W) presents,"Thursday, July 13, 2017",7:00 PM,Chamber Music,Slosberg Recital Hall,"415 South Street, Waltham",45,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Aston Magna (W) presents,"Saturday, July 22, 2017",6:00 PM,Music from the Court of Isabella D’Este,Slosberg Recital Hall,"415 South Street, Waltham",45,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Aston Magna (W) presents,"Thursday, July 20, 2017",7:00 PM,Music from the Court of Isabella D’Este,"Slosberg Recital Hall 415 South Street, Waltham",,45,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Monday, July 17, 2017",7:30 PM,Chamber Music,Studzinski Recital Hall,"Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Wednesday, July 19, 2017",7:30 PM,Chamber Music,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Friday, July 21, 2017",7:30 PM,Chamber Music,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Monday, July 24, 2017",7:30 PM,JUPITER STRING QUARTET,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Wednesday, July 26, 2017",7:30 PM,Chamber Music,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Friday, July 28, 2017",7:30 PM,Chamber Music,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Monday, July 31, 2017",7:30 PM,Borromeo String Quartet,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Bowdoin International Music Festival (SZ) presents,"Wednesday, August 2, 2017",7:30 PM,Chamber Music,"Studzinski Recital Hall, Bowdoin College, Brunswick","Bowdoin College, Brunswick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Sevenars Music Festival presents,"Sunday, July 16, 2017",4:00 PM,Chamber Music,The Academy,South Worthington,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Sevenars Music Festival presents,"Sunday, July 23, 2017",4:00 PM,Chamber Music,"The Academy,, South Worthington",,20,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Sevenars Music Festival presents,"Sunday, July 30, 2017",4:00 PM,Chamber Music,"The Academy,, South Worthington",,20,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Sevenars Music Festival presents,"Sunday, August 6, 2017",4:00 PM,Chamber Music,"The Academy,, South Worthington",,20,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Sevenars Music Festival presents,"Sunday, August 13, 2017",4:00 PM,"Rorianne Schrade, pianist","The Academy,, South Worthington",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Electric Earth Concerts presents,"Sunday, August 6, 2017",4:00 PM,Serenade,"The Academy,, Various NH locations",,0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Friday, July 14, 2017",8:00 PM,Chamber Music,Various Mansions,"Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Thursday, July 13, 2017",11:00 AM,"Clemens Teufel, piano","Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Thursday, July 13, 2017",7:00 PM,Chamber Music,"Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Monday, July 17, 2017",8:00 PM,Chamber Music,"Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Tuesday, July 18, 2017",8:00 PM,Chamber Music,"Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Wednesday, July 19, 2017",6:00 PM,"Three Pianos, Six Hands","Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Wednesday, July 19, 2017",6:00 PM,Bach Gamba Sonatas,"Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Newport Music Festival presents,"Wednesday, July 19, 2017",8:00 PM,Chamber Music,"Various Mansions, Newport","Newport, RI",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Thursday, July 27, 2017",7:30 PM,Carpe Diem String Quartet,Walnut Hill School,"12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Sunday, July 23, 2017",7:30 PM,"Hung-Kuan Chen 陳宏寬, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Tuesday, July 25, 2017",7:30 PM,"Larry Weng, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Friday, July 28, 2017",7:30 PM,"Artur Haftman, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Saturday, July 29, 2017",7:30 PM,Chamber Music,"Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Monday, July 31, 2017",7:30 PM,"Han Chen 陳涵 , pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Tuesday, August 1, 2017",7:30 PM,"Alexander Korsantia, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",0,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Wednesday, August 2, 2017",7:30 PM,Borromeo String Quartet,"Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Friday, August 4, 2017",7:30 PM,Chamber Music,"Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Sunday, August 6, 2017",7:30 PM,"Eric Lu 陸逸軒, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Thursday, August 10, 2017",7:30 PM,"Mana Tokuno, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""
Foundation for Chinese Performing Arts (WH) presents,"Thursday, August 10, 2017",7:30 PM,"Mana Tokuno, pianist","Walnut Hill School, 12 Highland Street, Natick","12 Highland Street, Natick",5,"""2017-07-18 16:43:38.187476""","""2017-07-18 16:43:38.187476"""

[MarcyNash]

I posted the file. I only has 149 rows.

Thanks, Marcy

On Fri, Jul 21, 2017 at 5:53 AM, Chris R. Payne notifications@github.com wrote:

Can you post the raw text from the file?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/ga-wdi-boston/capstone-project/issues/778#issuecomment-316959178, or mute the thread https://github.com/notifications/unsubscribe-auth/AIb6bdVslIWUXn1RVr_3pOk4EmZaCi45ks5sQHUwgaJpZM4Oe-f2 .

[cpearce31]

The problem appears to be with the address column. The addresses have commas in them and aren't in quotes, so they get parsed as multiple columns.

[cpearce31]

Looking again, I only notice that issue in the first row. You could use something like this to make sure CSV is properly formatted: https://csvlint.io/