MATCH (o:Outbreak)-[:LINKED_TO]->(f:Firm)-[:RECALLED]->(r:Recall)
OPTIONAL MATCH (r)-[:DISTRIBUTED_TO]->(s:State)
WITH o, f, count(DISTINCT r) AS recalls, collect(DISTINCT s.code) AS shipped
MATCH (o)-[c:CASES_IN]->(cs:State)
RETURN o.pathogen AS pathogen, f.name AS firm, recalls, shipped, collect(cs.code + ':' + toString(c.count)) AS cases

MATCH (o:Outbreak)-[:CASES_IN]->(s:State), (o)-[:LINKED_TO]->(f:Firm)
WHERE NOT (f)-[:RECALLED]->(:Recall)-[:DISTRIBUTED_TO]->(s)
RETURN o.id AS outbreak, s.code AS state

MATCH (a:Firm)-[e:SUPPLIED]->(b:Firm) OPTIONAL MATCH (b)-[:RECALLED]->(r:Recall)
RETURN a.name AS from, b.name AS to, e.basis AS basis, collect(r.id) AS their_recalls

MATCH (r:Recall)-[:HAZARD]->(h:Hazard) RETURN h.name AS hazard, count(r) AS recalls,
sum(CASE WHEN r.classification = 'Class I' THEN 1 ELSE 0 END) AS class_I ORDER BY recalls DESC

MATCH (f:Firm)-[:RECALLED]->(r:Recall)-[:HAZARD]->(:Hazard {name: 'Listeria monocytogenes'})
WITH f, count(DISTINCT r.event_id) AS events, count(r) AS products WHERE events > 1
RETURN f.name AS firm, f.state AS state, events, products ORDER BY events DESC, products DESC LIMIT 5

MATCH (r:Recall {downstream: true}) RETURN count(r) AS downstream_recalls, count(DISTINCT r.event_id) AS events