Healthcare Adverse Events (FAERS)

MATCH (n)
RETURN count(n) AS total_nodes;

CALL db.labels() YIELD label
RETURN label
ORDER BY label;

MATCH ()-[r]->()
RETURN count(r) AS total_relationships;

MATCH ()-[r]->()
RETURN DISTINCT type(r) AS relationship_type
ORDER BY relationship_type;

MATCH (c:Case)
WHERE c.gender IS NOT NULL
RETURN DISTINCT c.gender AS gender
ORDER BY gender;

MATCH (r:Reaction)
WHERE r.description IS NOT NULL
RETURN count(DISTINCT r.description) AS distinct_reactions;

MATCH (o:Outcome)
WHERE o.outcome IS NOT NULL
RETURN DISTINCT o.outcome AS outcome_description
ORDER BY outcome_description;

MATCH (c:Case)-[:HAS_REACTION]->(r:Reaction)
WHERE r.description IS NOT NULL
RETURN r.description AS reaction, count(*) AS frequency
ORDER BY frequency DESC
LIMIT 20;

MATCH (d:Drug)<-[:IS_PRIMARY_SUSPECT|IS_SECONDARY_SUSPECT]-(c:Case)
MATCH (c)-[:RESULTED_IN]->(o:Outcome)
WHERE o.outcome IN $severe
RETURN d.name AS drug_name, count(DISTINCT c) AS severe_cases
ORDER BY severe_cases DESC
LIMIT 10;

MATCH (m:Manufacturer)-[:REGISTERED]->(c:Case)-[:HAS_REACTION]->(r:Reaction)
MATCH (d:Drug)<-[:IS_PRIMARY_SUSPECT|IS_SECONDARY_SUSPECT|IS_CONCOMITANT|IS_INTERACTING]-(c)
RETURN m.manufacturerName AS manufacturer, count(DISTINCT d) AS drugs_with_side_effects
ORDER BY drugs_with_side_effects DESC
LIMIT 10;

MATCH (m:Manufacturer {manufacturerName: 'PFIZER'})-[:REGISTERED]->(c:Case)-[:HAS_REACTION]->(r:Reaction)
MATCH (d:Drug)<-[:IS_PRIMARY_SUSPECT|IS_SECONDARY_SUSPECT|IS_CONCOMITANT|IS_INTERACTING]-(c)
WHERE r.description IS NOT NULL
RETURN d.name AS drug_name,
       collect(DISTINCT r.description)[0..20] AS side_effects,
       count(DISTINCT c) AS case_count
ORDER BY case_count DESC
LIMIT 5;