I'm working with government data on Bills filed. These Bills have metadata (e.g., Name, Author, etc.) that I'm parking at the Node with relationships to Entities (i.e., Nodes) when it makes sense like author. I also have a list of 'Actions' recorded for each Bill (e.g., Filed, Voted on, Signed, etc.). The list of actions can be quite extensive (100+) per Bill. There are 1000+ Bills so I'm seeking suggestions advise on how to model 'Action' elements. I have sequence which each Action was taken so my three ideas are:
- Load all Actions as Nodes with a pointer back to the Bill. This would park each will with 100+ similiar [:action_for] relationships. However the Actions would not have a relationship to each other.
- Load all the Action Nodes linking to the previous Action of the Bill. This seems very natural for the Graph but I'm very new to this so the loading from CSV cypher code is beyond me at this point and how to query it is also.
- Least 'graphy' would be to load all Actions directly on the Node. I'm not sure how to capture a list in properties so it just feels wrong.
Any suggestions or advise would be greatly appreciated.
Thanks!
-Dan