NICAR 2023 Neo4j Workshop

0_import.cypher

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");

1_find_parcels.cypher

MATCH (p:Parcel) 
RETURN p LIMIT 10

2_find_parcel_bills.cypher

MATCH (p:Parcel)<-[:LEGISLATES]-(b:Bill)
RETURN * LIMIT 100

3_find_bill_sponsors.cypher

MATCH (p:Parcel)<-[:LEGISLATES]-(b:Bill)<-[:SPONSORED]-(l:Legislator)
RETURN * LIMIT 100

4_parcel_with_most_bills.cypher

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

5_find_yellowstone_bills.cypher

MATCH (p:Parcel {name: "Yellowstone National Park"})
MATCH (p)<-[:LEGISLATES]-(b:Bill)<-[:SPONSORED]-(l:Legislator)
RETURN *

6_legislator_most_sponsored.cypher

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

7_add_legislative_influence.cypher

MATCH (l1:Legislator)-[:SPONSORED]->(:Bill)<-[:COSPONSORED]-(l2:Legislator)
CREATE (l1)<-[:INFLUENCED_BY]->(l2)