Winners For Partner Innovation
First Place – Anti-Mafia Analytics Platform
Winning Team from
$10,000 for Charity of Choice
Summary
We created the schema in Lucid Chart and designated primary keys, foreign keys, and attributes. Since there were no publicly available datasets on the Italian Mafia, we generated representative synthetic data. We performed research into Mafia family hierarchy, main crime activities and geography to make sure our data generated accurately. Using the Python language and associated Pandas library, we created CSV’s for Mafia Members, Police Members, Public Individuals, Financial Transactions, Crime Incidents, Raids and others.
The CSVs were loaded into TigerGraph. The schema was created and the CSV files were mapped to nodes and edges.
GSQL queries were run to reveal insights of our synthetic data.