Skip to content

Instantly share code, notes, and snippets.

@rvanbruggen
Last active October 12, 2020 21:51
  • Star 3 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save rvanbruggen/0eeb3ea1e6189760d2a09e376cc519c1 to your computer and use it in GitHub Desktop.
FinCEN files in Neo4j+Zeppelin

Using Zeppelin with Neo4j to analyse the FinCEN Files

Last week, we got another great and widely publicised case of Graph Databases' usefullness throw our way. The ICIJ published their FinCEN Files research, and on top of allowing you to explore the data on their website they also published an anonymised subset of the data as a series of CSV/JSON files. My friends and colleagues Michael Hunger, Will Lyon and the rest of the team, helped with the process of making this subset available as a Neo4j database (see this github repo), and there's even a super easy FinCEN Files Neo4j Sandbox that you can spin up in no time for some investigation fun.

So of course I had to take this data for a spin myself - it seems really important to me that more eyeballs are looking at this, and more people exposing the sometimes very questionable behaviour of the world's largest financial institutions.

Introducing Zeppelin

I had heard of some great technology a while ago that would allow people to use their data in a very different way, by looking at these interactive webpages that would interact with a Neo4j database.

Zeppelin

Kind of like a GraphGist, but then running against your own dataset, and more interactive, with many more visualisation and reporting possibilities. It was called Apache Zeppelin, and it looked really interesting. I read a few articles about it (like this Blogpost), and soon was browsing the web for more info.

Soon was giving it a spin: I quickly installed Zeppelin following these instructions, and really found it quite a breeze to get going.

The Neo4j Interpreter

Next up was to connect the Zeppelin install to my Neo4j database. Zeppelin uses a specific terminology for these types of connectors - calling them "Interpreters". I am (of course) running the latest 4.1.1 release inside the Neo4j Desktop, and the Neo4j Interpreter that comes with Zeppelin (you can find the documentation for that interpreter on the Apache website was not working - apparently it was only supporting Neo4j 3.5.x.

So that's when I gave my friends a call. Turned out that the Neo4j Interpreter had been created by our long time Italian partner called Larus. One of their engineers, Andrea Santurbano was the author of the Interpreter - and after a few slack messages back and forth he was willing to upgrade the code to the latest Neo4j version. You can also ind Andrea on LinkedIn - he's such a nice guy and really helped me out.

So once Andrea had done the technical work to upgrade the Interpreter, there were only a handful of steps left to take:

  • I needed to update the interpreter on my default install:

    • Just download the ZIP file, and
    • then replace the contents of the in <ZEPPELIN_HOME>/neo4j directory with the contents of the ZIP file. This contains the jars with the support to Neo4j 4.x (as supported by the Java Driver 4.0.1)
  • Then I could start Zeppelin with a simple command: bin/zeppelin-daemon.sh start. (Note that this should not be in your G-drive folder :) ... - it does not like that)

  • Once that was done, I could browse to http://localhost:8080/, and then

  • start the Tutorial on Zeppelin.

It was very easy and quick to get going with.

Writing my FinCEN Files Notebook

Creating the actual Zeppelin notebook was not very difficult either. Once logged into the main Zeppelin management page, I just had to configure the interpreter by providing it with the URI for the server, and the authentication credentials. That way, the interpreter would know what to do everytime the notebook would have a paragraph starting with %neo4j: that would mean that the paragraph would need to route the following queries in that paragraph to the configured Neo4j server.

As you can see, I was able to very quickly add a few useful paragraphs to the notebook. I have uploaded the full notebook (a .json file that contains all info about the notebook) to github: please find it over here.

Final note: apart from using the %neo4j start to the paragraphs, I was also very quickly able to add context with to the notebook by including some Markdown text. Just start a paragraph with %md, and before you know it the notebook includes some images, links etc. It's super easy.

I could really see how this system, the Zeppelin Notebooks, could be even more powerful if you would start combining lots of different datasources (with other paragraph codes like %cassandra or %jdbc or ...) in the same notebook. Then you could really use this notebook paradigm to enrich and develop your insights into the data in an even more profound way.

I hope this was a useful example/exercise for you. As always, looking forward to some feedback - my contact details are below.

Cheers

Rik

About me

{"paragraphs":[{"title":"Introduction","text":"%md\n# [ICIJ](http://www.icij.org) FinCEN Files in [Neo4j](http://www.neo4j.com)\n\n<img src=\"https://media.icij.org/uploads/2020/09/FinCEN_Files_ICIJ_1920px.jpg\" width=\"80%\" />\n\nBefore you go any further in exploring the data, take a look at these documents to give you more context\n* [the ICIJ Investigation](https://www.icij.org/investigations/fincen-files/)\n** an explanation of [what _Suspicious Activity Reports (SARs)_ actually are](https://www.icij.org/investigations/fincen-files/suspicious-activity-reports-explained/)\n* [Michael Hunger's work with the data](https://github.com/jexp/fincen)\n* [the raw data to download](https://www.icij.org/investigations/fincen-files/download-fincen-files-transaction-data/)\n\nand for background reading:\n* An explanation about [what correspiondence banks are](https://www.investopedia.com/terms/c/correspondent-bank.asp)\n* An illustration of the humongous costs / transaction [fees that correspondence banks charge their clients](https://expatfinance.net/international-bank-transfers-correspondent-bank-fees)\n","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":true,"language":"markdown","completionSupport":false},"colWidth":12,"editorMode":"ace/mode/markdown","fontSize":9,"editorHide":true,"title":true,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"HTML","data":"<div class=\"markdown-body\">\n<h1><a href=\"http://www.icij.org\">ICIJ</a> FinCEN Files in <a href=\"http://www.neo4j.com\">Neo4j</a></h1>\n<img src=\"https://media.icij.org/uploads/2020/09/FinCEN_Files_ICIJ_1920px.jpg\" width=\"80%\" />\n<p>Before you go any further in exploring the data, take a look at these documents to give you more context<br/>* <a href=\"https://www.icij.org/investigations/fincen-files/\">the ICIJ Investigation</a><br/>** an explanation of <a href=\"https://www.icij.org/investigations/fincen-files/suspicious-activity-reports-explained/\">what <em>Suspicious Activity Reports (SARs)</em> actually are</a><br/>* <a href=\"https://github.com/jexp/fincen\">Michael Hunger&rsquo;s work with the data</a><br/>* <a href=\"https://www.icij.org/investigations/fincen-files/download-fincen-files-transaction-data/\">the raw data to download</a></p>\n<p>and for background reading:<br/>* An explanation about <a href=\"https://www.investopedia.com/terms/c/correspondent-bank.asp\">what correspiondence banks are</a><br/>* An illustration of the humongous costs / transaction <a href=\"https://expatfinance.net/international-bank-transfers-correspondent-bank-fees\">fees that correspondence banks charge their clients</a></p>\n</div>"}]},"apps":[],"jobName":"paragraph_1601312946481_1820383465","id":"20200926-105551_1289980515","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"focus":true,"$$hashKey":"object:45027"},{"title":"How many entities in which countries","text":"%neo4j\nmatch (e:Entity)--(c:Country)\nreturn distinct c.name, count(e)\norder by count(e) desc limit 10;","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"c.name":"string","count(e)":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false},"multiBarChart":{"rotate":{"degree":"-90"},"xLabelStatus":"default"},"lineChart":{"rotate":{"degree":"-45"},"xLabelStatus":"default"},"stackedAreaChart":{"rotate":{"degree":"-45"},"xLabelStatus":"default"}},"commonSetting":{},"keys":[{"name":"c.name","index":0,"aggr":"sum"}],"groups":[],"values":[{"name":"count(e)","index":1,"aggr":"sum"}]},"helium":{}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"TABLE","data":"c.name\tcount(e)\n\"United States\"\t243\n\"Russia\"\t243\n\"Switzerland\"\t184\n\"United Kingdom\"\t147\n\"China\"\t137\n\"United Arab Emirates\"\t119\n\"Hong Kong\"\t112\n\"Latvia\"\t101\n\"Singapore\"\t86\n\"Cyprus\"\t81\n"}]},"apps":[],"jobName":"paragraph_1601312946485_-1256379917","id":"20200926-094520_1458928178","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45028"},{"title":"What are the biggest Filings","text":"%neo4j\nMATCH (f:Filing)\nRETURN f ORDER BY f.amount DESC LIMIT 10;","user":"anonymous","dateUpdated":"2020-09-28T20:05:54+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"multiBarChart","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"id":"string","label":"string","end_date":"string","beneficiary_lng":"string","begin_date":"string","beneficiary_lat":"string","begin_date_format":"string","end_date_format":"string","beneficiary_bank_id":"string","number":"string","filer_org_name":"string","originator_bank_country":"string","filer_org_name_id":"string","end":"string","sar_id":"string","amount":"string","beneficiary_iso":"string","originator_bank":"string","originator_iso":"string","origin_lat":"string","beneficiary_bank_country":"string","beneficiary_bank":"string","origin_lng":"string","originator_bank_id":"string","begin":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false},"multiBarChart":{"rotate":{"degree":"-45"},"xLabelStatus":"rotate"},"network":{"properties":{"Filing":{"selected":"label","keys":["end_date","beneficiary_lng","begin_date","beneficiary_lat","begin_date_format","beneficiary_bank_id","end_date_format","number","filer_org_name","originator_bank_country","filer_org_name_id","end","id","sar_id","amount","beneficiary_iso","originator_bank","originator_iso","origin_lat","beneficiary_bank","beneficiary_bank_country","origin_lng","originator_bank_id","begin","label"]}},"d3Graph":{"forceLayout":{"timeout":10000,"charge":-120,"linkDistance":80},"zoom":{"minScale":1.3}}}},"commonSetting":{},"keys":[{"name":"id","index":0,"aggr":"sum"},{"name":"filer_org_name","index":10,"aggr":"sum"}],"groups":[],"values":[{"name":"amount","index":15,"aggr":"sum"}]},"helium":{}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"NETWORK","data":"{\"nodes\":[{\"id\":1061,\"data\":{\"end_date\":\"Oct 20, 2015\",\"beneficiary_lng\":\"6.1667\",\"begin_date\":\"Oct 20, 2015\",\"beneficiary_lat\":\"49.75\",\"begin_date_format\":\"2015-10-20T00:00:00Z\",\"end_date_format\":\"2015-10-20T00:00:00Z\",\"beneficiary_bank_id\":\"kbl-european-private-bankers-sa-luxembourg-lux\",\"number\":1,\"filer_org_name\":\"The Bank of New York Mellon Corp.\",\"originator_bank_country\":\"Luxembourg\",\"filer_org_name_id\":\"the-bank-of-new-york-mellon-corp\",\"end\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":10,\"day\":20},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"226760\",\"sar_id\":\"3991\",\"amount\":500000000,\"beneficiary_iso\":\"LUX\",\"originator_bank\":\"Bank of China\",\"originator_iso\":\"LUX\",\"origin_lat\":\"49.75\",\"beneficiary_bank_country\":\"Luxembourg\",\"beneficiary_bank\":\"Kbl European Private Bankers S.A.\",\"origin_lng\":\"6.1667\",\"originator_bank_id\":\"bank-of-china\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":10,\"day\":20},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":4725,\"data\":{\"end_date\":\"Apr 6, 2016\",\"beneficiary_lng\":\"25\",\"begin_date\":\"Mar 29, 2016\",\"beneficiary_lat\":\"57\",\"begin_date_format\":\"2016-03-29T00:00:00Z\",\"beneficiary_bank_id\":\"rigensis-bank-as-latvia-lva\",\"end_date_format\":\"2016-04-06T00:00:00Z\",\"number\":8,\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"Netherlands\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2016,\"month\":4,\"day\":6},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"243670\",\"sar_id\":\"2704\",\"amount\":336194500,\"beneficiary_iso\":\"LVA\",\"originator_bank\":\"ING Netherland NV\",\"originator_iso\":\"NLD\",\"origin_lat\":\"52.5\",\"beneficiary_bank_country\":\"Latvia\",\"beneficiary_bank\":\"Rigensis Bank AS\",\"origin_lng\":\"5.75\",\"originator_bank_id\":\"ing-netherland-nv\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2016,\"month\":3,\"day\":29},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":2550,\"data\":{\"end_date\":\"Sep 4, 2014\",\"beneficiary_lng\":\"13.3333\",\"begin_date\":\"Jun 5, 2013\",\"beneficiary_lat\":\"47.3333\",\"begin_date_format\":\"2013-06-05T00:00:00Z\",\"beneficiary_bank_id\":\"raiffeisen-bank-international-ag-vienna-austria-aut\",\"end_date_format\":\"2014-09-04T00:00:00Z\",\"number\":174,\"filer_org_name\":\"Standard Chartered Plc\",\"originator_bank_country\":\"Netherlands\",\"filer_org_name_id\":\"standard-chartered-plc\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":9,\"day\":4},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"235039\",\"sar_id\":\"4208\",\"amount\":350082732,\"beneficiary_iso\":\"AUT\",\"originator_bank\":\"Amsterdam Trade Bank NV\",\"originator_iso\":\"NLD\",\"origin_lat\":\"52.5\",\"beneficiary_bank\":\"Raiffeisen Bank International Ag\",\"beneficiary_bank_country\":\"Austria\",\"origin_lng\":\"5.75\",\"originator_bank_id\":\"amsterdam-trade-bank-nv\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":6,\"day\":5},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":1671,\"data\":{\"end_date\":\"Dec 11, 2015\",\"beneficiary_lng\":\"114.1667\",\"begin_date\":\"Dec 11, 2015\",\"beneficiary_lat\":\"22.25\",\"begin_date_format\":\"2015-12-11T00:00:00Z\",\"beneficiary_bank_id\":\"ocbc-wing-hang-bank-hong-kong-hkg\",\"end_date_format\":\"2015-12-11T00:00:00Z\",\"number\":1,\"filer_org_name\":\"The Bank of New York Mellon Corp.\",\"originator_bank_country\":\"Belgium\",\"filer_org_name_id\":\"the-bank-of-new-york-mellon-corp\",\"end\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":12,\"day\":11},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"229506\",\"sar_id\":\"4251\",\"amount\":5.119999625E8,\"beneficiary_iso\":\"HKG\",\"originator_bank\":\"JPMorgan Chase Bank National\",\"originator_iso\":\"BEL\",\"origin_lat\":\"50.8333\",\"beneficiary_bank_country\":\"Hong Kong\",\"beneficiary_bank\":\"Ocbc Wing Hang Bank\",\"origin_lng\":\"4\",\"originator_bank_id\":\"jpmorgan-chase-bank-national\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":12,\"day\":11},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":3576,\"data\":{\"end_date\":\"Aug 8, 2011\",\"beneficiary_lng\":\"100\",\"begin_date\":\"Aug 8, 2011\",\"beneficiary_lat\":\"60\",\"begin_date_format\":\"2011-08-08T00:00:00Z\",\"beneficiary_bank_id\":\"rosbank-moscow-russia-rus\",\"end_date_format\":\"2011-08-08T00:00:00Z\",\"number\":1,\"filer_org_name\":\"The Bank of New York Mellon Corp.\",\"originator_bank_country\":\"Netherlands\",\"filer_org_name_id\":\"the-bank-of-new-york-mellon-corp\",\"end\":{\"dateTime\":{\"date\":{\"year\":2011,\"month\":8,\"day\":8},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"238294\",\"sar_id\":\"2748\",\"amount\":2721000000,\"beneficiary_iso\":\"RUS\",\"originator_bank\":\"Amsterdam Trade Bank NV\",\"originator_iso\":\"NLD\",\"origin_lat\":\"52.5\",\"beneficiary_bank_country\":\"Russia\",\"beneficiary_bank\":\"Rosbank\",\"origin_lng\":\"5.75\",\"originator_bank_id\":\"amsterdam-trade-bank-nv\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2011,\"month\":8,\"day\":8},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":1960,\"data\":{\"end_date\":\"Mar 19, 2014\",\"beneficiary_lng\":\"103.8\",\"begin_date\":\"Mar 7, 2014\",\"beneficiary_lat\":\"1.3667\",\"begin_date_format\":\"2014-03-07T00:00:00Z\",\"beneficiary_bank_id\":\"societe-generale-bank-and-trust-singapore-sa-sgbt-singapore-singapore-sgp\",\"end_date_format\":\"2014-03-19T00:00:00Z\",\"number\":4,\"filer_org_name\":\"Société Générale SA\",\"originator_bank_country\":\"Switzerland\",\"filer_org_name_id\":\"societe-generale-sa\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":3,\"day\":19},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"231948\",\"sar_id\":\"2778\",\"amount\":336828000,\"beneficiary_iso\":\"SGP\",\"originator_bank\":\"Societe Generale Private Banking\",\"originator_iso\":\"CHE\",\"origin_lat\":\"47\",\"beneficiary_bank_country\":\"Singapore\",\"beneficiary_bank\":\"Societe Generale Bank And Trust Singapore SA\",\"origin_lng\":\"8\",\"originator_bank_id\":\"societe-generale-private-banking\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":3,\"day\":7},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":2969,\"data\":{\"end_date\":\"Jan 4, 2013\",\"beneficiary_lng\":\"-2\",\"begin_date\":\"Jan 8, 2007\",\"beneficiary_lat\":\"54\",\"begin_date_format\":\"2007-01-08T00:00:00Z\",\"beneficiary_bank_id\":\"deutsche-bank-ag-london-branch-gbr\",\"end_date_format\":\"2013-01-04T00:00:00Z\",\"number\":90,\"filer_org_name\":\"JP Morgan Chase \\u0026 Co.\",\"originator_bank_country\":\"United Kingdom\",\"filer_org_name_id\":\"jp-morgan-chase-co\",\"end\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":1,\"day\":4},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"236396\",\"sar_id\":\"3190\",\"amount\":1.08274811202E9,\"beneficiary_iso\":\"GBR\",\"originator_bank\":\"JPMorgan Chase Bank\",\"originator_iso\":\"GBR\",\"origin_lat\":\"54\",\"beneficiary_bank_country\":\"United Kingdom\",\"beneficiary_bank\":\"Deutsche Bank AG -- London Branch\",\"origin_lng\":\"-2\",\"originator_bank_id\":\"jpmorgan-chase-bank\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2007,\"month\":1,\"day\":8},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":4265,\"data\":{\"end_date\":\"Aug 22, 2014\",\"beneficiary_lng\":\"30\",\"begin_date\":\"Oct 25, 2013\",\"beneficiary_lat\":\"-15\",\"begin_date_format\":\"2013-10-25T00:00:00Z\",\"beneficiary_bank_id\":\"stanbic-bank-zambia-zmb\",\"end_date_format\":\"2014-08-22T00:00:00Z\",\"number\":23,\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"United Kingdom\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":8,\"day\":22},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"240243\",\"sar_id\":\"3512\",\"amount\":4.6235102967E8,\"beneficiary_iso\":\"ZMB\",\"originator_bank\":\"Citibank, N.A.\",\"originator_iso\":\"GBR\",\"origin_lat\":\"54\",\"beneficiary_bank\":\"Stanbic Bank\",\"beneficiary_bank_country\":\"Zambia\",\"origin_lng\":\"-2\",\"originator_bank_id\":\"citibank-na\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":10,\"day\":25},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":2281,\"data\":{\"end_date\":\"Sep 30, 2014\",\"amount\":457984607,\"beneficiary_lng\":\"103.8\",\"beneficiary_iso\":\"SGP\",\"begin_date\":\"Sep 30, 2014\",\"originator_bank\":\"Deutsche Bank AG\",\"beneficiary_lat\":\"1.3667\",\"begin_date_format\":\"2014-09-30T00:00:00Z\",\"beneficiary_bank_id\":\"usb-ag-singapore-sgp\",\"end_date_format\":\"2014-09-30T00:00:00Z\",\"originator_iso\":\"HKG\",\"origin_lat\":\"22.25\",\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"Hong Kong\",\"beneficiary_bank\":\"Usb AG\",\"beneficiary_bank_country\":\"Singapore\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":9,\"day\":30},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"origin_lng\":\"114.1667\",\"originator_bank_id\":\"deutsche-bank-ag\",\"id\":\"233414\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":9,\"day\":30},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"sar_id\":\"3670\"},\"label\":\"Filing\"},{\"id\":3162,\"data\":{\"end_date\":\"Feb 24, 2016\",\"beneficiary_lng\":\"-97\",\"begin_date\":\"May 23, 2013\",\"beneficiary_lat\":\"38\",\"begin_date_format\":\"2013-05-23T00:00:00Z\",\"beneficiary_bank_id\":\"jp-morgan-us-usa\",\"end_date_format\":\"2016-02-24T00:00:00Z\",\"number\":18,\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"Switzerland\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2016,\"month\":2,\"day\":24},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"237303\",\"sar_id\":\"2713\",\"amount\":8.0265600676E8,\"beneficiary_iso\":\"USA\",\"originator_bank\":\"Gazprombank\",\"originator_iso\":\"CHE\",\"origin_lat\":\"47\",\"beneficiary_bank\":\"JPMorgan\",\"beneficiary_bank_country\":\"United States\",\"origin_lng\":\"8\",\"originator_bank_id\":\"gazprombank\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":5,\"day\":23},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"}],\"edges\":[],\"labels\":{\"Country\":\"#667D2C\",\"Entity\":\"#32AD8D\",\"Filing\":\"#F2758E\"},\"types\":[\"TRANSFERRED_TO\",\"FILED\",\"COUNTRY\",\"CONCERNS\",\"ORIGINATOR\",\"BENEFITS\",\"TRANSFERRED\"],\"directed\":true}"}]},"apps":[],"jobName":"paragraph_1601312946486_-849379026","id":"20200926-094610_1794156471","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45029"},{"title":"Filings with its participants - ordered by transaction size","text":"%neo4j\nMATCH (f:Filing)\nWITH f ORDER BY f.amount DESC LIMIT 10\nMATCH (f)-[r]-(e:Entity)\nRETURN *;\n","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"network","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"id":"string","label":"string","country":"string","louvain_cluster":"string","name":"string","location":"string","betweenness":"string","pagerank":"string","end_date":"string","beneficiary_lng":"string","begin_date":"string","beneficiary_lat":"string","begin_date_format":"string","beneficiary_bank_id":"string","end_date_format":"string","number":"string","filer_org_name":"string","originator_bank_country":"string","filer_org_name_id":"string","end":"string","sar_id":"string","amount":"string","beneficiary_iso":"string","originator_bank":"string","originator_iso":"string","origin_lat":"string","beneficiary_bank_country":"string","beneficiary_bank":"string","origin_lng":"string","originator_bank_id":"string","begin":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}},"helium":{}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"NETWORK","data":"{\"nodes\":[{\"id\":4864,\"data\":{\"country\":\"CHE\",\"louvain_cluster\":978,\"name\":\"Credit Suisse AG\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"betweenness\":0.0,\"id\":\"credit-suisse-ag-zurich-switzerland-che\",\"pagerank\":2.155709555745125},\"label\":\"Entity\"},{\"id\":4994,\"data\":{\"country\":\"BEL\",\"louvain_cluster\":233,\"name\":\"Euroclear Bank SA\",\"location\":{\"srid\":4326,\"x\":4.0,\"y\":50.8333},\"betweenness\":0.0,\"id\":\"euroclear-bank-sa-brussels-belgium-bel\",\"pagerank\":0.15283333340194077},\"label\":\"Entity\"},{\"id\":4866,\"data\":{\"country\":\"CHE\",\"louvain_cluster\":1287,\"name\":\"Societe Generale Private Banking\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"betweenness\":0.0,\"id\":\"societe-generale-private-banking-sgpb-suisse-switzerland-che\",\"pagerank\":0.34125000759959223},\"label\":\"Entity\"},{\"id\":4867,\"data\":{\"country\":\"SGP\",\"louvain_cluster\":1287,\"name\":\"Societe Generale Bank And Trust Singapore SA\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"societe-generale-bank-and-trust-singapore-sa-sgbt-singapore-singapore-sgp\",\"pagerank\":0.494250026345253},\"label\":\"Entity\"},{\"id\":4868,\"data\":{\"country\":\"MCO\",\"louvain_cluster\":107,\"name\":\"Societe Generale Bank And Trust Monaco\",\"location\":{\"srid\":4326,\"x\":7.4,\"y\":43.7333},\"betweenness\":0.0,\"id\":\"societe-generale-bank-and-trust-monaco-sgbt-monaco-monaco-mco\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":1671,\"data\":{\"end_date\":\"Dec 11, 2015\",\"beneficiary_lng\":\"114.1667\",\"begin_date\":\"Dec 11, 2015\",\"beneficiary_lat\":\"22.25\",\"begin_date_format\":\"2015-12-11T00:00:00Z\",\"beneficiary_bank_id\":\"ocbc-wing-hang-bank-hong-kong-hkg\",\"end_date_format\":\"2015-12-11T00:00:00Z\",\"number\":1,\"filer_org_name\":\"The Bank of New York Mellon Corp.\",\"originator_bank_country\":\"Belgium\",\"filer_org_name_id\":\"the-bank-of-new-york-mellon-corp\",\"end\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":12,\"day\":11},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"229506\",\"sar_id\":\"4251\",\"amount\":5.119999625E8,\"beneficiary_iso\":\"HKG\",\"originator_bank\":\"JPMorgan Chase Bank National\",\"originator_iso\":\"BEL\",\"origin_lat\":\"50.8333\",\"beneficiary_bank_country\":\"Hong Kong\",\"beneficiary_bank\":\"Ocbc Wing Hang Bank\",\"origin_lng\":\"4\",\"originator_bank_id\":\"jpmorgan-chase-bank-national\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":12,\"day\":11},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":5128,\"data\":{\"country\":\"PAN\",\"louvain_cluster\":367,\"name\":\"Andbanc\",\"location\":{\"srid\":4326,\"x\":-80.0,\"y\":9.0},\"betweenness\":0.0,\"id\":\"andbanc-panama-sa-panama-city-panama-pan\",\"pagerank\":0.2987500101327896},\"label\":\"Entity\"},{\"id\":6413,\"data\":{\"louvain_cluster\":1074,\"name\":\"JPMorgan\",\"location\":{\"srid\":4326,\"x\":-97.0,\"y\":38.0},\"betweenness\":0.0,\"id\":\"jp-morgan-us-usa\",\"pagerank\":0.16159090911969545},\"label\":\"Entity\"},{\"id\":5270,\"data\":{\"country\":\"CYP\",\"louvain_cluster\":509,\"name\":\"Bank of Cyprus Public Company Limited\",\"location\":{\"srid\":4326,\"x\":33.0,\"y\":35.0},\"betweenness\":0.0,\"id\":\"bank-of-cyprus-public-company-limited-cyprus-cyp\",\"pagerank\":0.1754999994300306},\"label\":\"Entity\"},{\"id\":4761,\"data\":{\"louvain_cluster\":0,\"name\":\"The Bank of New York Mellon Corp.\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"the-bank-of-new-york-mellon-corp\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":2969,\"data\":{\"end_date\":\"Jan 4, 2013\",\"beneficiary_lng\":\"-2\",\"begin_date\":\"Jan 8, 2007\",\"beneficiary_lat\":\"54\",\"begin_date_format\":\"2007-01-08T00:00:00Z\",\"beneficiary_bank_id\":\"deutsche-bank-ag-london-branch-gbr\",\"end_date_format\":\"2013-01-04T00:00:00Z\",\"number\":90,\"filer_org_name\":\"JP Morgan Chase \\u0026 Co.\",\"originator_bank_country\":\"United Kingdom\",\"filer_org_name_id\":\"jp-morgan-chase-co\",\"end\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":1,\"day\":4},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"236396\",\"sar_id\":\"3190\",\"amount\":1.08274811202E9,\"beneficiary_iso\":\"GBR\",\"originator_bank\":\"JPMorgan Chase Bank\",\"originator_iso\":\"GBR\",\"origin_lat\":\"54\",\"beneficiary_bank_country\":\"United Kingdom\",\"beneficiary_bank\":\"Deutsche Bank AG -- London Branch\",\"origin_lng\":\"-2\",\"originator_bank_id\":\"jpmorgan-chase-bank\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2007,\"month\":1,\"day\":8},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":4762,\"data\":{\"louvain_cluster\":1,\"name\":\"Société Générale SA\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"societe-generale-sa\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4763,\"data\":{\"louvain_cluster\":2,\"name\":\"Standard Chartered Plc\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"standard-chartered-plc\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":5660,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":899,\"name\":\"Deutsche Bank Ooo\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"deutsche-bank-ooo-russia-rus\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4764,\"data\":{\"louvain_cluster\":1588,\"name\":\"Deutsche Bank AG\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"deutsche-bank-ag\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":5148,\"data\":{\"country\":\"HKG\",\"louvain_cluster\":387,\"name\":\"Ocbc Wing Hang Bank Limited\",\"location\":{\"srid\":4326,\"x\":114.1667,\"y\":22.25},\"betweenness\":0.0,\"id\":\"ocbc-wing-hang-bank-limited-hong-kong-hkg\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4892,\"data\":{\"country\":\"AUT\",\"louvain_cluster\":168,\"name\":\"Raiffeisen Bank International AG\",\"location\":{\"srid\":4326,\"x\":13.3333,\"y\":47.3333},\"betweenness\":0.0,\"id\":\"raiffeisen-bank-international-ag-vienna-austria-aut\",\"pagerank\":0.5674613311886787},\"label\":\"Entity\"},{\"id\":4765,\"data\":{\"louvain_cluster\":4,\"name\":\"JP Morgan Chase \\u0026 Co.\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"jp-morgan-chase-co\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":5789,\"data\":{\"louvain_cluster\":519,\"name\":\"Deutsche Bank AG\",\"location\":{\"srid\":4326,\"x\":-2.0,\"y\":54.0},\"betweenness\":0.0,\"id\":\"deutsche-bank-ag-london-branch-gbr\",\"pagerank\":0.23925000354647638},\"label\":\"Entity\"},{\"id\":5149,\"data\":{\"country\":\"HKG\",\"louvain_cluster\":261,\"name\":\"Credit Suisse\",\"location\":{\"srid\":4326,\"x\":114.1667,\"y\":22.25},\"betweenness\":0.0,\"id\":\"credit-suisse-hong-kong-hkg\",\"pagerank\":0.3753125071525574},\"label\":\"Entity\"},{\"id\":5150,\"data\":{\"country\":\"SGP\",\"louvain_cluster\":102,\"name\":\"Indian Bank\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"indian-bank-singapore-sgp\",\"pagerank\":0.2987500101327896},\"label\":\"Entity\"},{\"id\":5151,\"data\":{\"country\":\"CYM\",\"louvain_cluster\":390,\"name\":\"DMS Bank \\u0026 Trust Ltd. \",\"location\":{\"srid\":4326,\"x\":-80.5,\"y\":19.5},\"betweenness\":0.0,\"id\":\"dms-bank-trust-ltd-cayman-islandsg-cym\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":6559,\"data\":{\"louvain_cluster\":264,\"name\":\"Stanbic Bank\",\"location\":{\"srid\":4326,\"x\":30.0,\"y\":-15.0},\"betweenness\":0.0,\"id\":\"stanbic-bank-zambia-zmb\",\"pagerank\":0.1579687503166497},\"label\":\"Entity\"},{\"id\":4897,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":136,\"name\":\"Ojsc Jscb International Financial Club\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"ojsc-jscb-international-financial-club-moscow-russia-rus\",\"pagerank\":0.27750000506639483},\"label\":\"Entity\"},{\"id\":4901,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":144,\"name\":\"Sberbank of Russia\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"sberbank-of-russia-moscow-russia-rus\",\"pagerank\":0.5047972723841667},\"label\":\"Entity\"},{\"id\":1061,\"data\":{\"end_date\":\"Oct 20, 2015\",\"beneficiary_lng\":\"6.1667\",\"begin_date\":\"Oct 20, 2015\",\"beneficiary_lat\":\"49.75\",\"begin_date_format\":\"2015-10-20T00:00:00Z\",\"end_date_format\":\"2015-10-20T00:00:00Z\",\"beneficiary_bank_id\":\"kbl-european-private-bankers-sa-luxembourg-lux\",\"number\":1,\"filer_org_name\":\"The Bank of New York Mellon Corp.\",\"originator_bank_country\":\"Luxembourg\",\"filer_org_name_id\":\"the-bank-of-new-york-mellon-corp\",\"end\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":10,\"day\":20},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"226760\",\"sar_id\":\"3991\",\"amount\":500000000,\"beneficiary_iso\":\"LUX\",\"originator_bank\":\"Bank of China\",\"originator_iso\":\"LUX\",\"origin_lat\":\"49.75\",\"beneficiary_bank_country\":\"Luxembourg\",\"beneficiary_bank\":\"Kbl European Private Bankers S.A.\",\"origin_lng\":\"6.1667\",\"originator_bank_id\":\"bank-of-china\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2015,\"month\":10,\"day\":20},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":6823,\"data\":{\"louvain_cluster\":264,\"name\":\"Citibank N.A.\",\"location\":{\"srid\":4326,\"x\":-97.0,\"y\":38.0},\"betweenness\":0.0,\"id\":\"citibank-na\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":5288,\"data\":{\"country\":\"CHN\",\"louvain_cluster\":527,\"name\":\"Shanghai Pudong Development Bank\",\"location\":{\"srid\":4326,\"x\":105.0,\"y\":35.0},\"betweenness\":0.0,\"id\":\"shanghai-pudong-development-bank-shanghai-china-chn\",\"pagerank\":0.35642858445644376},\"label\":\"Entity\"},{\"id\":1960,\"data\":{\"end_date\":\"Mar 19, 2014\",\"beneficiary_lng\":\"103.8\",\"begin_date\":\"Mar 7, 2014\",\"beneficiary_lat\":\"1.3667\",\"begin_date_format\":\"2014-03-07T00:00:00Z\",\"beneficiary_bank_id\":\"societe-generale-bank-and-trust-singapore-sa-sgbt-singapore-singapore-sgp\",\"end_date_format\":\"2014-03-19T00:00:00Z\",\"number\":4,\"filer_org_name\":\"Société Générale SA\",\"originator_bank_country\":\"Switzerland\",\"filer_org_name_id\":\"societe-generale-sa\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":3,\"day\":19},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"231948\",\"sar_id\":\"2778\",\"amount\":336828000,\"beneficiary_iso\":\"SGP\",\"originator_bank\":\"Societe Generale Private Banking\",\"originator_iso\":\"CHE\",\"origin_lat\":\"47\",\"beneficiary_bank_country\":\"Singapore\",\"beneficiary_bank\":\"Societe Generale Bank And Trust Singapore SA\",\"origin_lng\":\"8\",\"originator_bank_id\":\"societe-generale-private-banking\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":3,\"day\":7},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":6696,\"data\":{\"louvain_cluster\":1287,\"name\":\"Societe Generale Private Banking\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"betweenness\":0.0,\"id\":\"societe-generale-private-banking\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4777,\"data\":{\"country\":\"SGP\",\"louvain_cluster\":1145,\"name\":\"United Overseas Bank Limited\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"united-overseas-bank-limited-singapore-sgp\",\"pagerank\":1.1673702776432036},\"label\":\"Entity\"},{\"id\":5289,\"data\":{\"country\":\"CHN\",\"louvain_cluster\":1185,\"name\":\"First Sino Bank\",\"location\":{\"srid\":4326,\"x\":105.0,\"y\":35.0},\"betweenness\":0.0,\"id\":\"first-sino-bank-shanghai-china-chn\",\"pagerank\":0.3200000025331974},\"label\":\"Entity\"},{\"id\":4265,\"data\":{\"end_date\":\"Aug 22, 2014\",\"beneficiary_lng\":\"30\",\"begin_date\":\"Oct 25, 2013\",\"beneficiary_lat\":\"-15\",\"begin_date_format\":\"2013-10-25T00:00:00Z\",\"beneficiary_bank_id\":\"stanbic-bank-zambia-zmb\",\"end_date_format\":\"2014-08-22T00:00:00Z\",\"number\":23,\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"United Kingdom\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":8,\"day\":22},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"240243\",\"sar_id\":\"3512\",\"amount\":4.6235102967E8,\"beneficiary_iso\":\"ZMB\",\"originator_bank\":\"Citibank, N.A.\",\"originator_iso\":\"GBR\",\"origin_lat\":\"54\",\"beneficiary_bank\":\"Stanbic Bank\",\"beneficiary_bank_country\":\"Zambia\",\"origin_lng\":\"-2\",\"originator_bank_id\":\"citibank-na\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":10,\"day\":25},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":5290,\"data\":{\"country\":\"HKG\",\"louvain_cluster\":529,\"name\":\"Taiwan Cooperative Bank\",\"location\":{\"srid\":4326,\"x\":114.1667,\"y\":22.25},\"betweenness\":0.0,\"id\":\"taiwan-cooperative-bank-hong-kong-hkg\",\"pagerank\":0.27750000506639483},\"label\":\"Entity\"},{\"id\":4778,\"data\":{\"country\":\"CHN\",\"louvain_cluster\":1517,\"name\":\"Bank of Communications\",\"location\":{\"srid\":4326,\"x\":105.0,\"y\":35.0},\"betweenness\":0.0,\"id\":\"bank-of-communications-shanghai-china-chn\",\"pagerank\":0.4730276077985764},\"label\":\"Entity\"},{\"id\":5291,\"data\":{\"country\":\"MAC\",\"louvain_cluster\":286,\"name\":\"Banco Nacional Ultramarino\",\"location\":{\"srid\":4326,\"x\":113.55,\"y\":22.1667},\"betweenness\":0.0,\"id\":\"banco-nacional-ultramarino-macau-mac\",\"pagerank\":0.21375000253319743},\"label\":\"Entity\"},{\"id\":4908,\"data\":{\"country\":\"CHN\",\"louvain_cluster\":1517,\"name\":\"Ping An Bank Co Ltd\",\"location\":{\"srid\":4326,\"x\":105.0,\"y\":35.0},\"betweenness\":0.0,\"id\":\"ping-an-bank-co-ltd-shenzhen-china-chn\",\"pagerank\":0.5155552044510842},\"label\":\"Entity\"},{\"id\":5166,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":405,\"name\":\"Sberbank of Russia\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"sberbank-of-russia-russia-rus\",\"pagerank\":0.486026431620121},\"label\":\"Entity\"},{\"id\":6193,\"data\":{\"louvain_cluster\":1588,\"name\":\"Usb AG\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"usb-ag-singapore-sgp\",\"pagerank\":0.1527127658715472},\"label\":\"Entity\"},{\"id\":5041,\"data\":{\"country\":\"TUR\",\"louvain_cluster\":280,\"name\":\"Denizbank AS\",\"location\":{\"srid\":4326,\"x\":35.0,\"y\":39.0},\"betweenness\":0.0,\"id\":\"denizbank-as-turkey-tur\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":6706,\"data\":{\"louvain_cluster\":1074,\"name\":\"Gazprombank\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"gazprombank\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":5427,\"data\":{\"country\":\"CHE\",\"louvain_cluster\":666,\"name\":\"Gazprombank Switzerland Ltd\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"betweenness\":0.0,\"id\":\"gazprombank-switzerland-ltd-switzerland-che\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":6073,\"data\":{\"louvain_cluster\":261,\"name\":\"Ocbc Wing Hang Bank\",\"location\":{\"srid\":4326,\"x\":114.1667,\"y\":22.25},\"betweenness\":0.0,\"id\":\"ocbc-wing-hang-bank-hong-kong-hkg\",\"pagerank\":0.19250000063329936},\"label\":\"Entity\"},{\"id\":4925,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":164,\"name\":\"UniCredit Bank, Cjsc\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"unicredit-bank-cjsc-moscow-russia-rus\",\"pagerank\":0.4637410581111908},\"label\":\"Entity\"},{\"id\":4927,\"data\":{\"country\":\"SGP\",\"louvain_cluster\":264,\"name\":\"DBS Bank Ltd\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"dbs-bank-ltd-singapore-sgp\",\"pagerank\":2.0414265586690536},\"label\":\"Entity\"},{\"id\":6847,\"data\":{\"louvain_cluster\":159,\"name\":\"Bank of China\",\"location\":{\"srid\":4326,\"x\":105.0,\"y\":35.0},\"betweenness\":0.0,\"id\":\"bank-of-china\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4806,\"data\":{\"country\":\"CHE\",\"louvain_cluster\":1156,\"name\":\"Credit Suisse\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"betweenness\":5.0,\"id\":\"credit-suisse-zurich-switzerland-che\",\"pagerank\":0.3248493656516075},\"label\":\"Entity\"},{\"id\":6732,\"data\":{\"louvain_cluster\":519,\"name\":\"JPMorgan Chase Bank\",\"location\":{\"srid\":4326,\"x\":-2.0,\"y\":54.0},\"betweenness\":0.0,\"id\":\"jpmorgan-chase-bank\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4943,\"data\":{\"country\":\"CZE\",\"louvain_cluster\":286,\"name\":\"PPF Banka A.S. \",\"location\":{\"srid\":4326,\"x\":15.5,\"y\":49.75},\"betweenness\":0.0,\"id\":\"ppf-banka-as-prague-czech-republic-cze\",\"pagerank\":0.3036830447614193},\"label\":\"Entity\"},{\"id\":4817,\"data\":{\"country\":\"SGP\",\"louvain_cluster\":56,\"name\":\"Credit Suisse\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"credit-suisse-singapore-sgp\",\"pagerank\":0.8251832872629166},\"label\":\"Entity\"},{\"id\":4947,\"data\":{\"country\":\"LUX\",\"louvain_cluster\":159,\"name\":\"Kbl European Private Bankers S.A. \",\"location\":{\"srid\":4326,\"x\":6.1667,\"y\":49.75},\"betweenness\":4.0,\"id\":\"kbl-european-private-bankers-sa-luxembourg-lux\",\"pagerank\":0.24046429172158243},\"label\":\"Entity\"},{\"id\":6612,\"data\":{\"louvain_cluster\":1869,\"name\":\"Rigensis Bank AS\",\"location\":{\"srid\":4326,\"x\":25.0,\"y\":57.0},\"betweenness\":0.0,\"id\":\"rigensis-bank-as-latvia-lva\",\"pagerank\":0.2350000012665987},\"label\":\"Entity\"},{\"id\":3162,\"data\":{\"end_date\":\"Feb 24, 2016\",\"beneficiary_lng\":\"-97\",\"begin_date\":\"May 23, 2013\",\"beneficiary_lat\":\"38\",\"begin_date_format\":\"2013-05-23T00:00:00Z\",\"beneficiary_bank_id\":\"jp-morgan-us-usa\",\"end_date_format\":\"2016-02-24T00:00:00Z\",\"number\":18,\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"Switzerland\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2016,\"month\":2,\"day\":24},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"237303\",\"sar_id\":\"2713\",\"amount\":8.0265600676E8,\"beneficiary_iso\":\"USA\",\"originator_bank\":\"Gazprombank\",\"originator_iso\":\"CHE\",\"origin_lat\":\"47\",\"beneficiary_bank\":\"JPMorgan\",\"beneficiary_bank_country\":\"United States\",\"origin_lng\":\"8\",\"originator_bank_id\":\"gazprombank\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":5,\"day\":23},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":7004,\"data\":{\"louvain_cluster\":168,\"name\":\"Amsterdam Trade Bank NV\",\"location\":{\"srid\":4326,\"x\":5.75,\"y\":52.5},\"betweenness\":0.0,\"id\":\"amsterdam-trade-bank-nv\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4960,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":168,\"name\":\"Rosbank\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"rosbank-moscow-russia-rus\",\"pagerank\":2.477209949493408},\"label\":\"Entity\"},{\"id\":5473,\"data\":{\"country\":\"GBR\",\"louvain_cluster\":712,\"name\":\"Deutsche Bank AG\",\"location\":{\"srid\":4326,\"x\":-2.0,\"y\":54.0},\"betweenness\":0.0,\"id\":\"deutsche-bank-ag-united-kingdom-gbr\",\"pagerank\":0.27750000506639483},\"label\":\"Entity\"},{\"id\":7521,\"data\":{\"louvain_cluster\":1869,\"name\":\"ING Netherland NV\",\"location\":{\"srid\":4326,\"x\":5.75,\"y\":52.5},\"betweenness\":0.0,\"id\":\"ing-netherland-nv\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":5093,\"data\":{\"country\":\"NLD\",\"louvain_cluster\":1004,\"name\":\"ING Netherland NV\",\"location\":{\"srid\":4326,\"x\":5.75,\"y\":52.5},\"betweenness\":0.0,\"id\":\"ing-netherland-nv-netherlands-nld\",\"pagerank\":0.2957142896950245},\"label\":\"Entity\"},{\"id\":4969,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":208,\"name\":\"VTB Bank\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"vtb-bank-open-joint-stock-bank-moscow-russia-rus\",\"pagerank\":0.3342305935919285},\"label\":\"Entity\"},{\"id\":2281,\"data\":{\"end_date\":\"Sep 30, 2014\",\"amount\":457984607,\"beneficiary_lng\":\"103.8\",\"beneficiary_iso\":\"SGP\",\"begin_date\":\"Sep 30, 2014\",\"originator_bank\":\"Deutsche Bank AG\",\"beneficiary_lat\":\"1.3667\",\"begin_date_format\":\"2014-09-30T00:00:00Z\",\"beneficiary_bank_id\":\"usb-ag-singapore-sgp\",\"end_date_format\":\"2014-09-30T00:00:00Z\",\"originator_iso\":\"HKG\",\"origin_lat\":\"22.25\",\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"Hong Kong\",\"beneficiary_bank\":\"Usb AG\",\"beneficiary_bank_country\":\"Singapore\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":9,\"day\":30},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"origin_lng\":\"114.1667\",\"originator_bank_id\":\"deutsche-bank-ag\",\"id\":\"233414\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":9,\"day\":30},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"sar_id\":\"3670\"},\"label\":\"Filing\"},{\"id\":5363,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":602,\"name\":\"Gazprombank\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"gazprombank-russia-rus\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":4725,\"data\":{\"end_date\":\"Apr 6, 2016\",\"beneficiary_lng\":\"25\",\"begin_date\":\"Mar 29, 2016\",\"beneficiary_lat\":\"57\",\"begin_date_format\":\"2016-03-29T00:00:00Z\",\"beneficiary_bank_id\":\"rigensis-bank-as-latvia-lva\",\"end_date_format\":\"2016-04-06T00:00:00Z\",\"number\":8,\"filer_org_name\":\"Deutsche Bank AG\",\"originator_bank_country\":\"Netherlands\",\"filer_org_name_id\":\"deutsche-bank-ag\",\"end\":{\"dateTime\":{\"date\":{\"year\":2016,\"month\":4,\"day\":6},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"243670\",\"sar_id\":\"2704\",\"amount\":336194500,\"beneficiary_iso\":\"LVA\",\"originator_bank\":\"ING Netherland NV\",\"originator_iso\":\"NLD\",\"origin_lat\":\"52.5\",\"beneficiary_bank_country\":\"Latvia\",\"beneficiary_bank\":\"Rigensis Bank AS\",\"origin_lng\":\"5.75\",\"originator_bank_id\":\"ing-netherland-nv\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2016,\"month\":3,\"day\":29},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":2550,\"data\":{\"end_date\":\"Sep 4, 2014\",\"beneficiary_lng\":\"13.3333\",\"begin_date\":\"Jun 5, 2013\",\"beneficiary_lat\":\"47.3333\",\"begin_date_format\":\"2013-06-05T00:00:00Z\",\"beneficiary_bank_id\":\"raiffeisen-bank-international-ag-vienna-austria-aut\",\"end_date_format\":\"2014-09-04T00:00:00Z\",\"number\":174,\"filer_org_name\":\"Standard Chartered Plc\",\"originator_bank_country\":\"Netherlands\",\"filer_org_name_id\":\"standard-chartered-plc\",\"end\":{\"dateTime\":{\"date\":{\"year\":2014,\"month\":9,\"day\":4},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"235039\",\"sar_id\":\"4208\",\"amount\":350082732,\"beneficiary_iso\":\"AUT\",\"originator_bank\":\"Amsterdam Trade Bank NV\",\"originator_iso\":\"NLD\",\"origin_lat\":\"52.5\",\"beneficiary_bank\":\"Raiffeisen Bank International Ag\",\"beneficiary_bank_country\":\"Austria\",\"origin_lng\":\"5.75\",\"originator_bank_id\":\"amsterdam-trade-bank-nv\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2013,\"month\":6,\"day\":5},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":3576,\"data\":{\"end_date\":\"Aug 8, 2011\",\"beneficiary_lng\":\"100\",\"begin_date\":\"Aug 8, 2011\",\"beneficiary_lat\":\"60\",\"begin_date_format\":\"2011-08-08T00:00:00Z\",\"beneficiary_bank_id\":\"rosbank-moscow-russia-rus\",\"end_date_format\":\"2011-08-08T00:00:00Z\",\"number\":1,\"filer_org_name\":\"The Bank of New York Mellon Corp.\",\"originator_bank_country\":\"Netherlands\",\"filer_org_name_id\":\"the-bank-of-new-york-mellon-corp\",\"end\":{\"dateTime\":{\"date\":{\"year\":2011,\"month\":8,\"day\":8},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}},\"id\":\"238294\",\"sar_id\":\"2748\",\"amount\":2721000000,\"beneficiary_iso\":\"RUS\",\"originator_bank\":\"Amsterdam Trade Bank NV\",\"originator_iso\":\"NLD\",\"origin_lat\":\"52.5\",\"beneficiary_bank_country\":\"Russia\",\"beneficiary_bank\":\"Rosbank\",\"origin_lng\":\"5.75\",\"originator_bank_id\":\"amsterdam-trade-bank-nv\",\"begin\":{\"dateTime\":{\"date\":{\"year\":2011,\"month\":8,\"day\":8},\"time\":{\"hour\":0,\"minute\":0,\"second\":0,\"nano\":0}},\"offset\":{\"totalSeconds\":0},\"zone\":{\"totalSeconds\":0}}},\"label\":\"Filing\"},{\"id\":7035,\"data\":{\"louvain_cluster\":261,\"name\":\"JPMorgan Chase Bank National\",\"location\":{\"srid\":4326,\"x\":4.0,\"y\":50.8333},\"betweenness\":0.0,\"id\":\"jpmorgan-chase-bank-national\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"}],\"edges\":[{\"source\":2281,\"target\":6193,\"id\":32389,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":1061,\"target\":4947,\"id\":10503,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4761,\"target\":3576,\"id\":25737,\"data\":{},\"label\":\"FILED\"},{\"source\":4761,\"target\":1671,\"id\":8201,\"data\":{},\"label\":\"FILED\"},{\"source\":3576,\"target\":4969,\"id\":25738,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1671,\"target\":4777,\"id\":8202,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4761,\"target\":1061,\"id\":10378,\"data\":{},\"label\":\"FILED\"},{\"source\":1671,\"target\":7035,\"id\":36875,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1061,\"target\":4908,\"id\":10379,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4764,\"target\":4265,\"id\":40209,\"data\":{},\"label\":\"FILED\"},{\"source\":4725,\"target\":6612,\"id\":34833,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":1671,\"target\":4806,\"id\":8210,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4265,\"target\":6823,\"id\":40210,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":2550,\"target\":4892,\"id\":32658,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":3576,\"target\":4901,\"id\":25875,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3576,\"target\":4960,\"id\":33684,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":1061,\"target\":5288,\"id\":10392,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1671,\"target\":4817,\"id\":8218,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3576,\"target\":4925,\"id\":26011,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1061,\"target\":6847,\"id\":35996,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":3162,\"target\":5166,\"id\":24349,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4762,\"target\":1960,\"id\":2590,\"data\":{},\"label\":\"FILED\"},{\"source\":4764,\"target\":4725,\"id\":6558,\"data\":{},\"label\":\"FILED\"},{\"source\":1960,\"target\":4866,\"id\":2591,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4725,\"target\":5093,\"id\":6559,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3576,\"target\":4960,\"id\":26147,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3162,\"target\":5660,\"id\":24355,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1671,\"target\":6073,\"id\":31779,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":1671,\"target\":5149,\"id\":8227,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1061,\"target\":5289,\"id\":10405,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3162,\"target\":5363,\"id\":24362,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1671,\"target\":4927,\"id\":8235,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1960,\"target\":4867,\"id\":2604,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3162,\"target\":5473,\"id\":24368,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":2550,\"target\":7004,\"id\":38065,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1061,\"target\":5290,\"id\":10418,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1671,\"target\":5150,\"id\":8244,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":2969,\"target\":5789,\"id\":33077,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":1960,\"target\":4868,\"id\":2613,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3162,\"target\":5270,\"id\":24374,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1960,\"target\":6696,\"id\":37307,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1671,\"target\":5151,\"id\":8253,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1061,\"target\":5291,\"id\":10431,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1061,\"target\":4947,\"id\":31169,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":4763,\"target\":2550,\"id\":5698,\"data\":{},\"label\":\"FILED\"},{\"source\":2550,\"target\":5041,\"id\":5699,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1960,\"target\":4867,\"id\":32068,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":1671,\"target\":5148,\"id\":8261,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4265,\"target\":6559,\"id\":34373,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":4764,\"target\":3162,\"id\":15942,\"data\":{},\"label\":\"FILED\"},{\"source\":4764,\"target\":2281,\"id\":37702,\"data\":{},\"label\":\"FILED\"},{\"source\":3162,\"target\":5427,\"id\":15943,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":2281,\"target\":4764,\"id\":37704,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1061,\"target\":4778,\"id\":10443,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3576,\"target\":4864,\"id\":25807,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4765,\"target\":2969,\"id\":38614,\"data\":{},\"label\":\"FILED\"},{\"source\":3576,\"target\":4897,\"id\":25943,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":2969,\"target\":6732,\"id\":38615,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1061,\"target\":4817,\"id\":10455,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":4725,\"target\":7521,\"id\":40791,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":3576,\"target\":4994,\"id\":26079,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":1061,\"target\":4927,\"id\":10467,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3576,\"target\":7004,\"id\":39406,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1061,\"target\":4943,\"id\":10479,\"data\":{},\"label\":\"CONCERNS\"},{\"source\":3162,\"target\":6413,\"id\":33270,\"data\":{},\"label\":\"BENEFITS\"},{\"source\":3162,\"target\":6706,\"id\":38907,\"data\":{},\"label\":\"ORIGINATOR\"},{\"source\":1061,\"target\":5128,\"id\":10491,\"data\":{},\"label\":\"CONCERNS\"}],\"labels\":{\"Country\":\"#667D2C\",\"Entity\":\"#32AD8D\",\"Filing\":\"#F2758E\"},\"types\":[\"TRANSFERRED_TO\",\"FILED\",\"COUNTRY\",\"CONCERNS\",\"ORIGINATOR\",\"BENEFITS\",\"TRANSFERRED\"],\"directed\":true}"}]},"apps":[],"jobName":"paragraph_1601312946486_-59473813","id":"20200926-094648_1736072078","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45030"},{"title":"Fillings with participents - ordered by transaction size","text":"%neo4j\nMATCH (e:Entity)--(f:Filing)\nWITH e, round(sum(f.amount)) as total\nWITH e, total ORDER BY total DESC LIMIT 10\nOPTIONAL MATCH (e)-[:COUNTRY]-(c:Country)\nRETURN e.name, c.name, total;\n","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"table","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"e.name":"string","c.name":"string","total":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"TABLE","data":"e.name\tc.name\ttotal\n\"The Bank of New York Mellon Corp.\"\tNULL\t2.363867824E10\n\"Credit Suisse AG\"\t\"Switzerland\"\t1.1240126583E10\n\"Rosbank\"\t\"Russia\"\t1.0752855482E10\n\"Deutsche Bank AG\"\t\"Hong Kong\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"Czech Republic\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"Germany\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"United Kingdom\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"United States\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"India\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"Netherlands\"\t7.852493064E9\n\"Deutsche Bank AG\"\t\"Singapore\"\t7.852493064E9\n\"Sberbank of Russia\"\t\"Russia\"\t5.084848206E9\n\"Ojsc Jscb International Financial Club\"\t\"Russia\"\t3.982189867E9\n\"DBS Bank Ltd\"\t\"Singapore\"\t3.789793886E9\n\"ING Netherland NV\"\t\"Netherlands\"\t3.724418207E9\n\"VTB Bank\"\t\"Russia\"\t3.504216988E9\n\"UniCredit Bank, Cjsc\"\t\"Russia\"\t3.442192714E9\n"}]},"apps":[],"jobName":"paragraph_1601312946487_358995509","id":"20200926-094740_1272420367","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45031"},{"title":"Entities with highest total transaction volume - as a graph","text":"%neo4j\nMATCH (e:Entity)--(f:Filing)\nWITH e, round(sum(f.amount)) as total\nWITH e, total ORDER BY total DESC LIMIT 10\nOPTIONAL MATCH (e)-[r:COUNTRY]-(c:Country)\nRETURN e, r, c;","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"table","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"id":"string","label":"string","country":"string","louvain_cluster":"string","name":"string","location":"string","betweenness":"string","pagerank":"string","code":"string","tld":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"NETWORK","data":"{\"nodes\":[{\"id\":4864,\"data\":{\"country\":\"CHE\",\"louvain_cluster\":978,\"name\":\"Credit Suisse AG\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"betweenness\":0.0,\"id\":\"credit-suisse-ag-zurich-switzerland-che\",\"pagerank\":2.155709555745125},\"label\":\"Entity\"},{\"id\":4960,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":168,\"name\":\"Rosbank\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"rosbank-moscow-russia-rus\",\"pagerank\":2.477209949493408},\"label\":\"Entity\"},{\"id\":4897,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":136,\"name\":\"Ojsc Jscb International Financial Club\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"ojsc-jscb-international-financial-club-moscow-russia-rus\",\"pagerank\":0.27750000506639483},\"label\":\"Entity\"},{\"id\":99,\"data\":{\"name\":\"Hong Kong\",\"location\":{\"srid\":4326,\"x\":114.1667,\"y\":22.25},\"code\":\"HKG\",\"tld\":\"HK\"},\"label\":\"Country\"},{\"id\":4901,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":144,\"name\":\"Sberbank of Russia\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"sberbank-of-russia-moscow-russia-rus\",\"pagerank\":0.5047972723841667},\"label\":\"Entity\"},{\"id\":5093,\"data\":{\"country\":\"NLD\",\"louvain_cluster\":1004,\"name\":\"ING Netherland NV\",\"location\":{\"srid\":4326,\"x\":5.75,\"y\":52.5},\"betweenness\":0.0,\"id\":\"ing-netherland-nv-netherlands-nld\",\"pagerank\":0.2957142896950245},\"label\":\"Entity\"},{\"id\":102,\"data\":{\"name\":\"India\",\"location\":{\"srid\":4326,\"x\":77.0,\"y\":20.0},\"code\":\"IND\",\"tld\":\"IN\"},\"label\":\"Country\"},{\"id\":4969,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":208,\"name\":\"VTB Bank\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"vtb-bank-open-joint-stock-bank-moscow-russia-rus\",\"pagerank\":0.3342305935919285},\"label\":\"Entity\"},{\"id\":202,\"data\":{\"name\":\"Singapore\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"code\":\"SGP\",\"tld\":\"SG\"},\"label\":\"Country\"},{\"id\":239,\"data\":{\"name\":\"United Kingdom\",\"location\":{\"srid\":4326,\"x\":-2.0,\"y\":54.0},\"code\":\"GBR\",\"tld\":\"GB\"},\"label\":\"Country\"},{\"id\":80,\"data\":{\"name\":\"Germany\",\"location\":{\"srid\":4326,\"x\":9.0,\"y\":51.0},\"code\":\"DEU\",\"tld\":\"DE\"},\"label\":\"Country\"},{\"id\":240,\"data\":{\"name\":\"United States\",\"location\":{\"srid\":4326,\"x\":-97.0,\"y\":38.0},\"code\":\"USA\",\"tld\":\"US\"},\"label\":\"Country\"},{\"id\":183,\"data\":{\"name\":\"Russia\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"code\":\"RUS\",\"tld\":\"RU\"},\"label\":\"Country\"},{\"id\":4761,\"data\":{\"louvain_cluster\":0,\"name\":\"The Bank of New York Mellon Corp.\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"the-bank-of-new-york-mellon-corp\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":57,\"data\":{\"name\":\"Czech Republic\",\"location\":{\"srid\":4326,\"x\":15.5,\"y\":49.75},\"code\":\"CZE\",\"tld\":\"CZ\"},\"label\":\"Country\"},{\"id\":220,\"data\":{\"name\":\"Switzerland\",\"location\":{\"srid\":4326,\"x\":8.0,\"y\":47.0},\"code\":\"CHE\",\"tld\":\"CH\"},\"label\":\"Country\"},{\"id\":4764,\"data\":{\"louvain_cluster\":1588,\"name\":\"Deutsche Bank AG\",\"location\":{\"srid\":4326,\"x\":-73.987862,\"y\":40.777571},\"betweenness\":0.0,\"id\":\"deutsche-bank-ag\",\"pagerank\":0.15000000000000002},\"label\":\"Entity\"},{\"id\":156,\"data\":{\"name\":\"Netherlands\",\"location\":{\"srid\":4326,\"x\":5.75,\"y\":52.5},\"code\":\"NLD\",\"tld\":\"NL\"},\"label\":\"Country\"},{\"id\":4925,\"data\":{\"country\":\"RUS\",\"louvain_cluster\":164,\"name\":\"UniCredit Bank, Cjsc\",\"location\":{\"srid\":4326,\"x\":100.0,\"y\":60.0},\"betweenness\":0.0,\"id\":\"unicredit-bank-cjsc-moscow-russia-rus\",\"pagerank\":0.4637410581111908},\"label\":\"Entity\"},{\"id\":4927,\"data\":{\"country\":\"SGP\",\"louvain_cluster\":264,\"name\":\"DBS Bank Ltd\",\"location\":{\"srid\":4326,\"x\":103.8,\"y\":1.3667},\"betweenness\":0.0,\"id\":\"dbs-bank-ltd-singapore-sgp\",\"pagerank\":2.0414265586690536},\"label\":\"Entity\"}],\"edges\":[{\"source\":4864,\"target\":220,\"id\":2560,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":5093,\"target\":156,\"id\":6465,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":99,\"id\":37703,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":102,\"id\":36456,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":202,\"id\":37706,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":156,\"id\":38797,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4960,\"target\":183,\"id\":4079,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4927,\"target\":202,\"id\":3504,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":57,\"id\":36689,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4969,\"target\":183,\"id\":4435,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":80,\"id\":35573,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":239,\"id\":35190,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4764,\"target\":240,\"id\":35322,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4925,\"target\":183,\"id\":3484,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4901,\"target\":183,\"id\":3133,\"data\":{},\"label\":\"COUNTRY\"},{\"source\":4897,\"target\":183,\"id\":3070,\"data\":{},\"label\":\"COUNTRY\"}],\"labels\":{\"Country\":\"#667D2C\",\"Entity\":\"#32AD8D\",\"Filing\":\"#F2758E\"},\"types\":[\"TRANSFERRED_TO\",\"FILED\",\"COUNTRY\",\"CONCERNS\",\"ORIGINATOR\",\"BENEFITS\",\"TRANSFERRED\"],\"directed\":true}"}]},"apps":[],"jobName":"paragraph_1601312946488_-1281111250","id":"20200926-095216_742035044","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45032"},{"title":"Money flows between banks - total worth of transactions","text":"%neo4j\nMATCH (source:Entity)<-[:ORIGINATOR]-(f:Filing)-[:BENEFITS]->(target:Entity)\nWITH source, target, round(sum(f.amount)) as total ORDER BY total DESC LIMIT 10\nRETURN source.name, target.name, total;","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"table","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"source.name":"string","target.name":"string","total":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"TABLE","data":"source.name\ttarget.name\ttotal\n\"Amsterdam Trade Bank NV\"\t\"Rosbank\"\t2.747023352E9\n\"Rigensis Bank AS\"\t\"ING Netherland NV\"\t1.201172347E9\n\"ING Netherland NV\"\t\"Rigensis Bank AS\"\t1.199219653E9\n\"JPMorgan Chase Bank\"\t\"Deutsche Bank AG\"\t1.082748112E9\n\"AS Expobank\"\t\"Credit Suisse AG\"\t8.88040731E8\n\"Caledonian Bank Ltd\"\t\"Hong Kong And Shanghai Banking Corp.\"\t8.28938267E8\n\"Gazprombank\"\t\"JPMorgan\"\t8.02656007E8\n\"AS Expobank\"\t\"Bank Soyuz\"\t7.698349E8\n\"Deutsche Bank AG\"\t\"Usb AG\"\t6.81317607E8\n\"Societe Generale Private Banking\"\t\"Societe Generale Bank And Trust Singapore SA\"\t6.36828E8\n"}]},"apps":[],"jobName":"paragraph_1601312946488_2117939598","id":"20200926-095309_697037896","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45033"},{"title":"Money flows between banks - number of transactions","text":"%neo4j\nMATCH (source:Entity)<-[:ORIGINATOR]-(f:Filing)-[:BENEFITS]->(target:Entity)\nRETURN source.name, target.name, count(*) as NumberOfFilings, round(sum(f.amount)) as total$\nORDER BY NumberOfFilings DESC\nLIMIT 10;","user":"anonymous","dateUpdated":"2020-09-28T19:09:06+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"title":true,"results":{"0":{"graph":{"mode":"table","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"source.name":"string","target.name":"string","NumberOfFilings":"string","total$":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"TABLE","data":"source.name\ttarget.name\tNumberOfFilings\ttotal$\n\"LTB Bank\"\t\"Credit Suisse AG\"\t73\t2.70167064E8\n\"AS Expobank\"\t\"Credit Suisse AG\"\t72\t8.88040731E8\n\"Trust Merchant Bank Sarl\"\t\"Habib Bank A G Zurich\"\t51\t676071.0\n\"Emirates Bank International Limited\"\t\"Credit Europe Bank N.V. \"\t44\t3889103.0\n\"Barclays Bank Plc Ho UK\"\t\"Commonwealth Bank of Australia\"\t43\t332293.0\n\"LTB Bank Riga \"\t\"Credit Suisse AG\"\t38\t3.0970342E7\n\"Rigensis Bank AS\"\t\"ING Netherland NV\"\t38\t1.201172347E9\n\"JSC Norvik Banka\"\t\"Sberbank\"\t36\t89909.0\n\" Natwest Offshore\"\t\"Commonwealth Bank of Australia\"\t27\t60368.0\n\"Baltinvestbank\"\t\"Eesti Krediidipank\"\t26\t6681531.0\n"}]},"apps":[],"jobName":"paragraph_1601312946489_2078762168","id":"20200926-095431_385674804","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45034"},{"title":"About me","text":"%md\n* On Twitter: [https://twitter.com/rvanbruggen](@rvanbruggen)\n* On LinkedIn: [https://www.linkedin.com/in/rikvanbruggen/](see my profile)\n* My blog: [Bruggen](http://blog.bruggen.com)\n* Our podcast: [Graphistania](http://www.graphistania.com) page on my Blog, on [Soundcloud](https://soundcloud.com/graphistania/sets/graphistania-podcast), [rss](http://feeds.soundcloud.com/users/soundcloud:users:141739624/sounds.rss), [Spotify](https://gate.sc/?url=https%3A%2F%2Fopen.spotify.com%2Fshow%2F4bR3RTo6ArDQB09gBHIHrV%3Fsi%3DP5Hk8LwkSwCHuGciMNc-sw&token=45c521-1-1601110915592), [Apple Music](https://podcasts.apple.com/be/podcast/graphistania-podcast-for-neo4j-graph-database-community/id975377379?mt=2)","user":"anonymous","dateUpdated":"2020-09-28T20:06:16+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":true,"language":"markdown","completionSupport":false},"colWidth":12,"editorMode":"ace/mode/markdown","fontSize":9,"editorHide":true,"title":true,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"HTML","data":"<div class=\"markdown-body\">\n<ul>\n <li>On Twitter: <a href=\"@rvanbruggen\">https://twitter.com/rvanbruggen</a></li>\n <li>On LinkedIn: [https://www.linkedin.com/in/rikvanbruggen/](see my profile)</li>\n <li>My blog: <a href=\"http://blog.bruggen.com\">Bruggen</a></li>\n <li>Our podcast: <a href=\"http://www.graphistania.com\">Graphistania</a> page on my Blog, on <a href=\"https://soundcloud.com/graphistania/sets/graphistania-podcast\">Soundcloud</a>, <a href=\"http://feeds.soundcloud.com/users/soundcloud:users:141739624/sounds.rss\">rss</a>, <a href=\"https://gate.sc/?url=https%3A%2F%2Fopen.spotify.com%2Fshow%2F4bR3RTo6ArDQB09gBHIHrV%3Fsi%3DP5Hk8LwkSwCHuGciMNc-sw&token=45c521-1-1601110915592\">Spotify</a>, <a href=\"https://podcasts.apple.com/be/podcast/graphistania-podcast-for-neo4j-graph-database-community/id975377379?mt=2\">Apple Music</a></li>\n</ul>\n</div>"}]},"apps":[],"jobName":"paragraph_1601312946489_-538692129","id":"20200926-095443_697798156","dateCreated":"2020-09-28T19:09:06+0200","status":"READY","errorMessage":"","progressUpdateIntervalMs":500,"$$hashKey":"object:45035"}],"name":"FinCEN Notebook - analysis","id":"2FJSH6UES","noteParams":{},"noteForms":{},"angularObjects":{"md:shared_process":[],"neo4j:shared_process":[]},"config":{"isZeppelinNotebookCronEnable":false,"looknfeel":"default","personalizedMode":"false"},"info":{}}
{"paragraphs":[{"text":"%md\n# Importing the FinCEN `.json` files into a blank Neo4j database\n\nPlease ensure that you have a blank database running, and that you will not accidentally overwrite any data that is already in that database!\n\nThe import process requires you to install the [APOC](https://neo4j.com/developer/neo4j-apoc/) plugin on your neo4j server. This is a very simple job using the [Neo4j Desktop](https://neo4j.com/developer/neo4j-desktop/).","user":"anonymous","dateUpdated":"2020-09-29T15:11:04+0200","config":{"tableHide":false,"editorSetting":{"editOnDblClick":true,"language":"markdown","completionSupport":false},"colWidth":12,"editorMode":"ace/mode/markdown","fontSize":9,"editorHide":true,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"HTML","data":"<div class=\"markdown-body\">\n<h1>Importing the FinCEN <code>.json</code> files into a blank Neo4j database</h1>\n<p>Please ensure that you have a blank database running, and that you will not accidentally overwrite any data that is already in that database!</p>\n<p>The import process requires you to install the <a href=\"https://neo4j.com/developer/neo4j-apoc/\">APOC</a> plugin on your neo4j server. This is a very simple job using the <a href=\"https://neo4j.com/developer/neo4j-desktop/\">Neo4j Desktop</a>.</p>\n</div>"}]},"apps":[],"jobName":"paragraph_1601384822771_-1555192059","id":"20200929-141710_1794568640","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:04+0200","dateFinished":"2020-09-29T15:11:04+0200","status":"FINISHED","progressUpdateIntervalMs":500,"focus":true,"$$hashKey":"object:43341"},{"text":"%neo4j\ncreate constraint on (c:Country) assert c.code is unique;","user":"anonymous","dateUpdated":"2020-09-29T15:11:04+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822775_621355729","id":"20200929-142227_981964382","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:04+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43342"},{"text":"%neo4j\ncreate constraint on (e:Entity) assert e.id is unique;","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822775_-67359503","id":"20200929-145040_1721720452","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43343"},{"text":"%neo4j\ncreate constraint on (f:Filing) assert f.id is unique;","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822775_1110128202","id":"20200929-145051_1160166179","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43344"},{"text":"%neo4j\ncreate index on :Filing(icij_sar_id);","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822775_1272377751","id":"20200929-145101_13135185","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43345"},{"text":"%neo4j\ncreate index on :Entity(name);","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822775_-88547807","id":"20200929-145112_119222795","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43346"},{"text":"%neo4j\ncreate index on :Filing(begin);","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_826432765","id":"20200929-145128_1481527459","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43347"},{"text":"%neo4j\ncreate index on :Filing(end);","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_148964111","id":"20200929-145136_1232515768","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43348"},{"text":"%neo4j\ncreate index on :Filing(amount);","user":"anonymous","dateUpdated":"2020-09-29T15:11:05+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_-1933559759","id":"20200929-145146_457170487","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:05+0200","dateFinished":"2020-09-29T15:11:05+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43349"},{"text":"%neo4j\ncreate index on :Country(name);","user":"anonymous","dateUpdated":"2020-09-29T15:11:06+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_1052761807","id":"20200929-145157_471188134","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:06+0200","dateFinished":"2020-09-29T15:11:06+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43350"},{"text":"%neo4j\ncall apoc.load.json(\"https://raw.githubusercontent.com/jexp/fincen/main/countries.json\") yield value\nmerge (c:Country {code:value.iso3}) set c.name = value.name, c.tld = value.iso2, c.location = point({latitude:toFloat(value.lat), longitude:toFloat(value.lng)})\nwith * where not value.exist_transaction is null set c:ExistTransactions;","user":"anonymous","dateUpdated":"2020-09-29T15:11:06+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_343793586","id":"20200929-145207_1527332335","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:06+0200","dateFinished":"2020-09-29T15:11:06+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43351"},{"text":"%neo4j\ncall apoc.load.json(\"https://raw.githubusercontent.com/jexp/fincen/main/sar-data.json\") yield value\nmerge (s:Filing {id:value.id}) set s += value;","user":"anonymous","dateUpdated":"2020-09-29T15:11:06+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_1997717860","id":"20200929-145216_927880121","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:06+0200","dateFinished":"2020-09-29T15:11:07+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43352"},{"text":"%neo4j\ncall apoc.load.json(\"https://raw.githubusercontent.com/jexp/fincen/main/sar-details.json\") yield value\nmatch (f:Filing {icij_sar_id:value.icij_sar_id})\nmerge (filer:Entity {id:value.filer_org_name_id}) on create set filer.name = value.filer_org_name, \nfiler.location = point({latitude:toFloat(value.filer_org_lat),longitude:toFloat(value.filer_org_lng)})\nmerge (other:Entity {id:value.entity_b_id}) on create set other.name = value.entity_b, \nother.location = point({latitude:toFloat(value.entity_b_lat),longitude:toFloat(value.entity_b_lng)}),\nother.country = value.entity_b_iso_code\nmerge (c:Country {code:value.entity_b_iso_code})\nmerge (f)<-[:FILED]-(filer)\nmerge (f)-[:CONCERNS]->(other)\nmerge (other)-[:COUNTRY]->(c);","user":"anonymous","dateUpdated":"2020-09-29T15:11:08+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_-1771700864","id":"20200929-145224_1779499361","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:08+0200","dateFinished":"2020-09-29T15:11:09+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43353"},{"text":"%neo4j\nmatch (f:Filing)\nset f.end=datetime(f.end_date_format)\nset f.begin=datetime(f.begin_date_format)","user":"anonymous","dateUpdated":"2020-09-29T15:11:09+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601384822776_-522917414","id":"20200929-145249_6909536","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:09+0200","dateFinished":"2020-09-29T15:11:10+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43354"},{"text":"%neo4j\nmerge (ben:Entity {id:f.beneficiary_bank_id})\non create set ben.name = f.beneficiary_bank, ben.location = point({latitude:toFloat(f.beneficiary_lat), longitude:toFloat(f.beneficiary_lng)})\nmerge (cben:Country {code:f.beneficiary_iso})\nmerge (ben)-[:COUNTRY]->(cben)\nmerge (f)-[:BENEFITS]->(ben)\nmerge (filer:Entity {id:f.filer_org_name_id})\non create set filer.name = f.filer_org_name, filer.location = point({latitude:toFloat(f.filer_org_lat), longitude:toFloat(f.filer_org_lng)})\nmerge (f)<-[:FILED]-(filer)\nmerge (org:Entity {id:f.originator_bank_id})\non create set org.name = f.originator_bank, org.location = point({latitude:toFloat(f.origin_lat), longitude:toFloat(f.origin_lng)})\nmerge (corg:Country {code:f.originator_iso})\nmerge (org)-[:COUNTRY]->(corg)\nmerge (f)-[:ORIGINATOR]->(org)\n;","user":"anonymous","dateUpdated":"2020-09-29T15:11:10+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"results":{},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"ERROR","msg":[{"type":"TEXT","data":"Variable `f` not defined (line 1, column 23 (offset: 22))\n\"merge (ben:Entity {id:f.beneficiary_bank_id})\"\n ^"}]},"apps":[],"jobName":"paragraph_1601384822777_980855655","id":"20200929-145302_413346179","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:10+0200","dateFinished":"2020-09-29T15:11:10+0200","status":"ERROR","progressUpdateIntervalMs":500,"$$hashKey":"object:43355"},{"text":"%neo4j\nmatch (n) \nreturn labels(n), count(n)","user":"anonymous","dateUpdated":"2020-09-29T15:11:16+0200","config":{"editorSetting":{"editOnDblClick":false},"colWidth":12,"editorMode":"ace/mode/undefined","fontSize":9,"editorHide":false,"results":{"0":{"graph":{"mode":"table","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"labels(n)":"string","count(n)":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}}}},"enabled":true},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"TABLE","data":"labels(n)\tcount(n)\n[\"Country\"]\t254\n[\"Filing\"]\t4507\n[\"Entity\"]\t977\n"}]},"apps":[],"jobName":"paragraph_1601384822774_1531113788","id":"20200929-144908_285721855","dateCreated":"2020-09-29T15:07:02+0200","dateStarted":"2020-09-29T15:11:16+0200","dateFinished":"2020-09-29T15:11:16+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:43356"}],"name":"FinCEN Notebook - data import from JSON","id":"2FN5298WX","noteParams":{},"noteForms":{},"angularObjects":{"md:shared_process":[],"neo4j:shared_process":[]},"config":{"isZeppelinNotebookCronEnable":false,"looknfeel":"default","personalizedMode":"false"},"info":{}}
{"paragraphs":[{"text":"%md\n# Importing the FinCEN `.csv` files into a blank Neo4j database\n\nPlease ensure that you have a blank database running, and that you will not accidentally overwrite any data that is already in that database!\n\nThe import process requires you to install the [APOC](https://neo4j.com/developer/neo4j-apoc/) plugin on your neo4j server. This is a very simple job using the [Neo4j Desktop](https://neo4j.com/developer/neo4j-desktop/).","user":"anonymous","dateUpdated":"2020-09-29T15:14:32+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":true,"language":"markdown","completionSupport":false},"editorMode":"ace/mode/markdown","editorHide":true,"tableHide":false},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"HTML","data":"<div class=\"markdown-body\">\n<h1>Importing the FinCEN <code>.csv</code> files into a blank Neo4j database</h1>\n<p>Please ensure that you have a blank database running, and that you will not accidentally overwrite any data that is already in that database!</p>\n<p>The import process requires you to install the <a href=\"https://neo4j.com/developer/neo4j-apoc/\">APOC</a> plugin on your neo4j server. This is a very simple job using the <a href=\"https://neo4j.com/developer/neo4j-desktop/\">Neo4j Desktop</a>.</p>\n</div>"}]},"apps":[],"jobName":"paragraph_1601381830604_820010438","id":"20200929-141710_1794568640","dateCreated":"2020-09-29T14:17:10+0200","dateStarted":"2020-09-29T15:14:32+0200","dateFinished":"2020-09-29T15:14:32+0200","status":"FINISHED","progressUpdateIntervalMs":500,"focus":true,"$$hashKey":"object:41723"},{"text":"%neo4j\ncreate constraint on (c:Country) assert c.code is unique;","user":"anonymous","dateUpdated":"2020-09-29T15:14:32+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false,"language":"markdown","completionSupport":false},"editorMode":"ace/mode/undefined","editorHide":false},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601381898770_514404281","id":"20200929-141818_997888401","dateCreated":"2020-09-29T14:18:18+0200","dateStarted":"2020-09-29T15:14:32+0200","dateFinished":"2020-09-29T15:14:32+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41724"},{"text":"%neo4j\ncreate constraint on (e:Entity) assert e.id is unique;","user":"anonymous","dateUpdated":"2020-09-29T15:14:32+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383460041_-1957461310","id":"20200929-144420_359465044","dateCreated":"2020-09-29T14:44:20+0200","dateStarted":"2020-09-29T15:14:32+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41725"},{"text":"%neo4j\ncreate constraint on (f:Filing) assert f.id is unique;","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383472974_-485915910","id":"20200929-144432_1226765214","dateCreated":"2020-09-29T14:44:32+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41726"},{"text":"%neo4j\ncreate index on :Filing(icij_sar_id);","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383481558_1932674510","id":"20200929-144441_351884852","dateCreated":"2020-09-29T14:44:41+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41727"},{"text":"%neo4j\ncreate index on :Entity(name);","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383490620_-904324583","id":"20200929-144450_1051357080","dateCreated":"2020-09-29T14:44:50+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41728"},{"text":"%neo4j\ncreate index on :Filing(begin);","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383507470_345652377","id":"20200929-144507_1482347832","dateCreated":"2020-09-29T14:45:07+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41729"},{"text":"%neo4j\ncreate index on :Filing(end);","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383517220_-1057982345","id":"20200929-144517_437913213","dateCreated":"2020-09-29T14:45:17+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41730"},{"text":"%neo4j\ncreate index on :Filing(amount);","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383525436_-1252145344","id":"20200929-144525_316131386","dateCreated":"2020-09-29T14:45:25+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41731"},{"text":"%neo4j\ncreate index on :Country(name);","user":"anonymous","dateUpdated":"2020-09-29T15:14:33+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383532772_-258882926","id":"20200929-144532_2038355384","dateCreated":"2020-09-29T14:45:32+0200","dateStarted":"2020-09-29T15:14:33+0200","dateFinished":"2020-09-29T15:14:33+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41732"},{"text":"%neo4j\nload csv with headers from \"https://raw.githubusercontent.com/jexp/fincen/main/download_transactions_map.csv\" as value\nmerge (s:Filing {id:value.id}) set s += value;","user":"anonymous","dateUpdated":"2020-09-29T15:14:34+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383545969_743244492","id":"20200929-144545_758357485","dateCreated":"2020-09-29T14:45:45+0200","dateStarted":"2020-09-29T15:14:34+0200","dateFinished":"2020-09-29T15:14:35+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41733"},{"text":"%neo4j\nload csv with headers from \"https://raw.githubusercontent.com/jexp/fincen/main/download_bank_connections.csv\" as value\nmatch (f:Filing {icij_sar_id:value.icij_sar_id})\nmerge (filer:Entity {id:value.filer_org_name_id}) on create set filer.name = value.filer_org_name, \nfiler.location = point({latitude:toFloat(value.filer_org_lat),longitude:toFloat(value.filer_org_lng)})\nmerge (other:Entity {id:value.entity_b_id}) on create set other.name = value.entity_b, \nother.location = point({latitude:toFloat(value.entity_b_lat),longitude:toFloat(value.entity_b_lng)}),\nother.country = value.entity_b_iso_code\nmerge (c:Country {code:value.entity_b_iso_code}) on create set c.name = value.entity_b_country\nmerge (f)<-[:FILED]-(filer)\nmerge (f)-[:CONCERNS]->(other)\nmerge (other)-[:COUNTRY]->(c);","user":"anonymous","dateUpdated":"2020-09-29T15:14:35+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383555773_342957744","id":"20200929-144555_1668005362","dateCreated":"2020-09-29T14:45:55+0200","dateStarted":"2020-09-29T15:14:35+0200","dateFinished":"2020-09-29T15:14:36+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41734"},{"text":"%neo4j\nmatch (f:Filing)\nset f.transactions = toInteger(f.number_transactions)\nset f.amount = toFloat(f.amount_transactions)\nset f.end=date(apoc.temporal.toZonedTemporal(f.end_date,\"MMM dd, yyyy\"))\nset f.begin=date(apoc.temporal.toZonedTemporal(f.begin_date,\"MMM dd, yyyy\"))\n\nmerge (ben:Entity {id:f.beneficiary_bank_id})\non create set ben.name = f.beneficiary_bank, ben.location = point({latitude:toFloat(f.beneficiary_lat), longitude:toFloat(f.beneficiary_lng)})\nmerge (cben:Country {code:f.beneficiary_iso})\nmerge (ben)-[:COUNTRY]->(cben)\nmerge (f)-[:BENEFITS]->(ben)\n\nmerge (filer:Entity {id:f.filer_org_name_id})\non create set filer.name = f.filer_org_name, filer.location = point({latitude:toFloat(f.filer_org_lat), longitude:toFloat(f.filer_org_lng)})\nmerge (f)<-[:FILED]-(filer)\n\nmerge (org:Entity {id:f.originator_bank_id})\non create set org.name = f.originator_bank, org.location = point({latitude:toFloat(f.origin_lat), longitude:toFloat(f.origin_lng)})\nmerge (corg:Country {code:f.originator_iso})\nmerge (org)-[:COUNTRY]->(corg)\nmerge (f)-[:ORIGINATOR]->(org)\n;","user":"anonymous","dateUpdated":"2020-09-29T15:14:36+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[]},"apps":[],"jobName":"paragraph_1601383565926_-707320097","id":"20200929-144605_808433343","dateCreated":"2020-09-29T14:46:05+0200","dateStarted":"2020-09-29T15:14:36+0200","dateFinished":"2020-09-29T15:14:37+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41735"},{"text":"%neo4j\nmatch (n) \nreturn labels(n), count(n)","user":"anonymous","dateUpdated":"2020-09-29T15:14:37+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{"0":{"graph":{"mode":"table","height":300,"optionOpen":false,"setting":{"table":{"tableGridState":{},"tableColumnTypeState":{"names":{"labels(n)":"string","count(n)":"string"},"updated":false},"tableOptionSpecHash":"[{\"name\":\"useFilter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable filter for columns\"},{\"name\":\"showPagination\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable pagination for better navigation\"},{\"name\":\"showAggregationFooter\",\"valueType\":\"boolean\",\"defaultValue\":false,\"widget\":\"checkbox\",\"description\":\"Enable a footer for displaying aggregated values\"}]","tableOptionValue":{"useFilter":false,"showPagination":false,"showAggregationFooter":false},"updated":false,"initialized":false}},"commonSetting":{}}}},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined","editorHide":false},"settings":{"params":{},"forms":{}},"results":{"code":"SUCCESS","msg":[{"type":"TABLE","data":"labels(n)\tcount(n)\n[\"Filing\"]\t4507\n[\"Entity\"]\t2763\n[\"Country\"]\t131\n"}]},"apps":[],"jobName":"paragraph_1601383748486_1735907994","id":"20200929-144908_285721855","dateCreated":"2020-09-29T14:49:08+0200","dateStarted":"2020-09-29T15:14:37+0200","dateFinished":"2020-09-29T15:14:37+0200","status":"FINISHED","progressUpdateIntervalMs":500,"$$hashKey":"object:41736"},{"text":"%neo4j\n","user":"anonymous","dateUpdated":"2020-09-29T15:14:37+0200","config":{"colWidth":12,"fontSize":9,"enabled":true,"results":{},"editorSetting":{"editOnDblClick":false},"editorMode":"ace/mode/undefined"},"settings":{"params":{},"forms":{}},"apps":[],"jobName":"paragraph_1601385277525_-2030427750","id":"20200929-151437_1483923985","dateCreated":"2020-09-29T15:14:37+0200","status":"READY","progressUpdateIntervalMs":500,"$$hashKey":"object:41737"}],"name":"FinCEN Notebook - data import from CSV","id":"2FNA549N6","noteParams":{},"noteForms":{},"angularObjects":{"md:shared_process":[],"neo4j:shared_process":[]},"config":{"isZeppelinNotebookCronEnable":false,"looknfeel":"default","personalizedMode":"false"},"info":{}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment