Import CSV relationship error

Neo4j Graph Platform Cypher
1

Hi guys,

I am importing a CSV into neo4j and I am having a small issue with my Data model

I have the following data model after running this cypher query

Load csv with headers from 'file:///Congresional_Directory_Updated.csv' as line

With line
MERGE (c:Congressman{Address:line.Address})
ON CREATE SET
 c.Zip = line.`Zip+4`,
 c.BioguideID = line.BioguideID,
 c.Prefix = line.Prefix,
 c.Name = line.FullName

MERGE (city:City{Name:line.City})
MERGE (state:State{Code:line.State})
MERGE (district:District{District:line.`St/Dis`})
MERGE (party:Party{Name:line.Party})
MERGE (building:Building{Name:line.Building})

MERGE (c)-[:Lives_In]->(city)
MERGE (city)-[:Located_In]->(state)
MERGE (c)-[:Represents]->(party)
MERGE (c)-[:Works_In]->(building)

image
image.png940×289 14.7 KB

When I want to create a relationship between district and state after running the following Cypher query

Load csv with headers from 'file:///Congresional_Directory_Updated.csv' as line
With line 
MERGE (district:District{District:line.`St/Dis`})
MERGE (city:City{Name:line.City})
MERGE (district)-[:Located_In]->(city)

Unfortunately my data model turns to this

image
image.png776×317 18.8 KB

As you can see there are now multiple "Located_In" relationships that I didn't intend on having in my model. To be clear the desired "Located_In" relationships are between District and State as well as between City and State. I have circled them in the below image.

image
image.png776×317 20.6 KB

Any advice would be appreciated.

Many thanks,
Sam.