Last active
April 12, 2023 15:33
-
-
Save johnymontana/e306c4685a96711ddd4dcfb2f224af3e to your computer and use it in GitHub Desktop.
NICAR 2023 Neo4j Workshop
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Parcel) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Subject) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Bill) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Committee) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Legislator) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Trip) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Organization) REQUIRE n.neo4jImportId IS UNIQUE; | |
CREATE CONSTRAINT IF NOT EXISTS FOR (n:Destination) REQUIRE n.neo4jImportId IS UNIQUE; | |
CALL apoc.import.json("https://cdn.neo4jlabs.com/data/landgraph/landgraph.json"); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (p:Parcel) | |
RETURN p LIMIT 10 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (p:Parcel)<-[:LEGISLATES]-(b:Bill) | |
RETURN * LIMIT 100 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (p:Parcel)<-[:LEGISLATES]-(b:Bill)<-[:SPONSORED]-(l:Legislator) | |
RETURN * LIMIT 100 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (p:Parcel)<-[:LEGISLATES]-(b:Bill) | |
WITH p, COUNT(b) AS num_bills | |
RETURN p.name, num_bills ORDER BY num_bills DESC LIMIT 100 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (p:Parcel {name: "Yellowstone National Park"}) | |
MATCH (p)<-[:LEGISLATES]-(b:Bill)<-[:SPONSORED]-(l:Legislator) | |
RETURN * |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (l:Legislator)-[:SPONSORED]->(b:Bill)-[:LEGISLATES]->(p:Parcel) | |
WITH l, COUNT(b) AS num_bills | |
RETURN l.name AS legislator, num_bills ORDER BY num_bills DESC LIMIT 10 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MATCH (l1:Legislator)-[:SPONSORED]->(:Bill)<-[:COSPONSORED]-(l2:Legislator) | |
CREATE (l1)<-[:INFLUENCED_BY]->(l2) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment