Skip to content

Instantly share code, notes, and snippets.

View apogiatzis's full-sized avatar
:electron:
Stay awhile and listen.

APogiatzis apogiatzis

:electron:
Stay awhile and listen.
113 followers · 278 following
View GitHub Profile
@apogiatzis
apogiatzis / lab2-data.json
Created February 15, 2022 04:46
{"type":"node","id":"0","labels":["Person"],"properties":{"occupation":"Architect","obj_id":"f2556438-bfca-4bb9-904c-8b46f5f5dc85","nationality":"Eritrea","phone":"+44(0)161 4960764","ni_number":"ZZ 42 19 48 T","date_of_birth":"1998-08-15","last_name":"Reed","first_name":"Emma","email":"nevans@hotmail.co.uk"}}
{"type":"node","id":"1","labels":["Person"],"properties":{"occupation":"Insurance claims handler","obj_id":"6757d890-2419-4c53-a621-649d71ffa135","nationality":"Bolivia","phone":"+441632 960 157","ni_number":"ZZ 387784 T","date_of_birth":"1980-01-01","last_name":"Barker","first_name":"Diana","email":"nixonguy@hotmail.co.uk"}}
{"type":"node","id":"2","labels":["Person"],"properties":{"occupation":"Chief Financial Officer","obj_id":"0ca6a40e-4847-4828-872c-a2afb96cdba6","nationality":"Saint Helena","phone":"+44(0)8081570609","ni_number":"ZZ 513933 T","date_of_birth":"1970-12-16","last_name":"Nelson","first_name":"Benjamin","email":"vfinch@yahoo.com"}}
{"type":"node","id":"3","labels":["Person"],"propertie
@apogiatzis
apogiatzis / persons.csv
Last active February 15, 2022 07:40
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 9 columns, instead of 5. in line 7.
obj_id,first_name,last_name,date_of_birth,occupation,nationality,phone,email,ni_number
63e5d001-06c4-4c61-8e5c-adf6c71d3fae,Emma,Reed,1998-08-15,Architect,Eritrea,+44(0)161 4960764,nevans@hotmail.co.uk,ZZ 42 19 48 T
1f362952-2004-4ba5-a436-3094212b8013,Diana,Barker,1980-01-01,Insurance claims handler,Bolivia,+44(0)161 4960764,nixonguy@hotmail.co.uk,ZZ 387784 T
b325f325-349b-4cf0-88a4-4becfad61310,Benjamin,Nelson,1970-12-16,Chief Financial Officer,Saint Helena,+44(0)8081570609,vfinch@yahoo.com,ZZ 513933 T
bfef9b63-e83e-476a-81df-89b24b1d32cd,Patrick,Roberts,2000-06-26,"Chemist, analytical",Belgium,+44(0)121 496 0871,lynn41@hotmail.co.uk,ZZ839894T
7d0889e1-dc79-4212-ad01-6f93d5d67dc8,Louise,Green,1996-03-11,Investment analyst,Montserrat,0118 4960423,ryanosborne@outlook.com,ZZ711220T
23332453-381e-4542-9841-66e8ca2f4a8a,Jonathan,Sutton,1996-08-17,"Scientist, water quality",Falkland Islands (Malvinas),0191 4960339,cjackson@yahoo.co.uk,ZZ 515917 T
667a42a8-b4c3-4e83-a7e9-86950a084c4b,Kate,Yates,1982-12-15,Financia
@apogiatzis
apogiatzis / accounts.csv
Last active February 15, 2022 07:44
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 6 columns, instead of 4. in line 8.
obj_id,balance,currency,owners,bank,opened_at
5032bafa-4641-476d-b9f0-b4d94d181aa7,5182.1738748835505,GBP,63e5d001-06c4-4c61-8e5c-adf6c71d3fae,Barclays,2019-08-20 09:41:56
bdbccd63-c521-4c54-946f-ee3c14eda434,31215.637395712656,GBP,1f362952-2004-4ba5-a436-3094212b8013,HSBC,2013-07-15 10:27:05
0506bfa7-626b-43ce-b06a-d48e2b9b796a,1337.8565290857598,GBP,b325f325-349b-4cf0-88a4-4becfad61310,Lloyds Banking Group,1993-03-01 22:31:55
e0150719-ab46-4b5e-891e-ddf026e5a1a6,9145.970496204713,GBP,bfef9b63-e83e-476a-81df-89b24b1d32cd,HSBC,2018-07-28 01:28:29
c2eccf2d-6279-4edc-b586-ccc700b94316,26.434749463574057,GBP,7d0889e1-dc79-4212-ad01-6f93d5d67dc8,HSBC,2013-11-22 14:47:47
61d284c7-9f32-4c98-a4a5-bd86530a40fe,12055.0285816817,GBP,23332453-381e-4542-9841-66e8ca2f4a8a,Royal Bank of Scotland,2014-05-02 01:09:01
cc8c69fe-c672-4004-bf97-34ed59d77d7c,19268.41108098035,GBP,667a42a8-b4c3-4e83-a7e9-86950a084c4b,NatWest,2008-03-08 02:59:08
befbee72-df70-4f02-9fa2-1bdedc7963eb,386.7139309481009,GBP,42a24287-f541-49f0-8918-e81d
@apogiatzis
apogiatzis / transactions.csv
Last active February 15, 2022 07:44
obj_id amount currency sender recipient type timestamp
83de3990-9292-4e2f-b3f9-29298bfd30e7 8297.26919178327 GBP 5032bafa-4641-476d-b9f0-b4d94d181aa7 309170fe-77e1-4d35-95c1-1ae4d5f96712 TRANSFER 2020-02-07 13:42:42
b520abea-f139-4869-a044-70e2cb5d3be9 4741.819187246722 GBP e989b38f-41a0-4562-a7c5-c94b84b18074 dd06213c-d4a4-43ca-9f6f-2d7ccd540334 TRANSFER 2021-01-03 12:29:40
048424e8-aee5-442d-ac69-fd9af3792df5 1434.7613936628347 GBP 11849051-1fa8-4da6-8419-74c709a3434b f071b9a9-8eae-434e-84d7-f59baa2a24e7 TRANSFER 2021-12-02 23:04:16
7d9f4507-5c32-452a-8ebe-b5070492fdef 7343.383225824531 GBP 30f6ba08-ec1e-4ba2-8c77-81e6b1b7a62d d8f491bd-4f63-419d-8f58-89883951456b TRANSFER 2020-10-21 23:38:50
5bdcca63-17f3-4cd1-948f-8fd8750573b9 3969.6346440750895 GBP 11dbf645-5bf7-4479-9eb1-4d6a78ee0878 11dbf645-5bf7-4479-9eb1-4d6a78ee0878 TRANSFER 2021-12-05 09:40:18
9fe06993-ccbf-4456-9c8c-aad7f4529cc3 5778.174746535905 GBP d8f491bd-4f63-419d-8f58-89883951456b 30f6ba08-ec1e-4ba2-8c77-81e6b1b7a62d TRANSFER 2021-04-01 22:44
@apogiatzis
apogiatzis / deposits.csv
Last active February 15, 2022 07:44
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 7 columns, instead of 1. in line 7.
obj_id,amount,currency,sender,recipient,type,timestamp
c0017c27-ab73-4029-8330-5ac72a3826c2,2889.4697311261652,GBP,d45d49f6-c23f-4f41-b520-c1bbd7f463cc,dfa672ee-aef1-47bd-a7a8-e15651bc4f29,DEPOSIT,2020-08-14 09:29:07
78c32f40-3d02-43a6-b4de-0cc0f09e0f66,4942.411954937588,GBP,20b1da10-404d-437f-885c-1fe19f96ebf9,9f6187bd-97f1-4c9a-b127-97a51d6f687a,DEPOSIT,2017-12-21 04:50:03
d1d2d120-6a48-4235-a346-d6cc74f5ad15,26069.262308789504,GBP,a5d78208-ad07-4783-9d0b-9dc7ea9b2009,009a8cb9-3988-42cf-a7ec-d3aa90e94207,DEPOSIT,2022-01-26 00:51:01
cb822199-2d02-4921-ab7f-1fe6390f1c34,19793.024645699916,GBP,2b41bf16-2fa8-4ba5-9d63-5bbb5b43ea93,309170fe-77e1-4d35-95c1-1ae4d5f96712,DEPOSIT,2018-10-02 01:02:37
30907626-3e4e-44f1-a40c-d1db780d55b7,9801.845155065861,GBP,8a325c51-3b79-433d-90e2-d69ffac3609f,99fcdd05-65c3-442c-a343-da7ad7a61fad,DEPOSIT,2017-05-13 08:29:00
688eaf83-50b6-4926-8b2f-838864d998a8,8518.70601847095,GBP,b57a519e-58b4-4448-a415-4c10ea3bff76,30f7f188-fe96-439e-a218-d0d4c932af5e,DEPOSIT,2018-11-18 13:08:45
7
@apogiatzis
apogiatzis / cash_transfers.csv
Last active February 15, 2022 07:43
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 6 columns, instead of 3. in line 7.
obj_id,amount,owner,currency,recipient,timestamp
a171081d-b910-47c3-b400-f54c5d159b7c,3012.520326499339,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,80544cb9-b281-45c3-b4c3-985f1a8ac847,2014-09-20 23:15:35
87329ee1-ff6c-4989-8ad4-6558b9a92fc8,2397.429076329954,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,4f05b1f2-9aec-48e2-b1ce-0d1cee31a969,2014-09-21 00:15:35
475f483c-87a5-4290-bd08-ea31aee834eb,7471.771387165544,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,b57a519e-58b4-4448-a415-4c10ea3bff76,2014-09-21 01:15:35
60a366bb-56c8-4d20-8612-62462a3a7ca2,8404.497519509043,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,c7a90ae7-8a94-4ad1-b114-d52b411b0b2a,2014-09-21 02:15:35
b78d97db-8ed8-44f2-ad4a-f1084942ac06,3160.252473111225,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,23332453-381e-4542-9841-66e8ca2f4a8a,2014-09-21 03:15:35
7ff7eb2e-6c2b-45b0-bb39-39b747a5c1d9,6098.609201828923,bab6ff99-a25e-4d5c-8bb5-769dfd7799ae,GBP,5dee4ac7-7378-4147-bf72-f3e8df240b68,2014-09-21 04:15:35
b8bf566c-5af5-4023-a889-8177bb16ac59,7904.390599685095,ba
@apogiatzis
apogiatzis / illegal_cash.csv
Last active February 15, 2022 07:43
obj_id amount currency recipient timestamp
c3684828-fca3-47fe-b438-198a5e0a52db 141365.0 GBP bab6ff99-a25e-4d5c-8bb5-769dfd7799ae 2014-09-16 22:15:35
58499457-abe3-4291-9f52-3daec8a3f8c3 144375.0 GBP 63e5d001-06c4-4c61-8e5c-adf6c71d3fae 2015-09-16 11:59:12
@apogiatzis
apogiatzis / persons.csv
Created February 15, 2022 08:26
We can make this file beautiful and searchable if this error is corrected: It looks like row 8 should actually have 9 columns, instead of 5. in line 7.
obj_id,first_name,last_name,date_of_birth,occupation,nationality,phone,email,ni_number
4a7edb39-029f-40a1-8fef-7ddff72537ce,Emma,Reed,1998-08-15,Architect,Eritrea,+44(0)161 4960764,nevans@hotmail.co.uk,ZZ 42 19 48 T
682a5412-07dd-4215-be8d-aee30df50be4,Diana,Barker,1980-01-01,Insurance claims handler,Bolivia,+441632 960 157,nixonguy@hotmail.co.uk,ZZ 387784 T
5d73ead8-5cee-47ce-8692-403fe511e07d,Benjamin,Nelson,1970-12-16,Chief Financial Officer,Saint Helena,+44(0)8081570609,vfinch@yahoo.com,ZZ 513933 T
f61040ff-c30c-4d1c-acb3-5417b2bd95b2,Patrick,Roberts,2000-06-26,"Chemist, analytical",Belgium,+44(0)121 496 0871,lynn41@hotmail.co.uk,ZZ839894T
962f7070-cffb-4b45-8fcb-2af9b88063a3,Louise,Green,1996-03-11,Investment analyst,Montserrat,0118 4960423,ryanosborne@outlook.com,ZZ711220T
7babbe46-c714-44d0-9a52-192bf6e604db,Jonathan,Sutton,1996-08-17,"Scientist, water quality",Falkland Islands (Malvinas),0191 4960339,cjackson@yahoo.co.uk,ZZ 515917 T
905368ca-b852-4bae-837c-8faffb66579f,Kate,Yates,1982-12-15,Financial
@apogiatzis
apogiatzis / accounts.csv
Created February 15, 2022 08:26
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 6 columns, instead of 2. in line 8.
obj_id,balance,currency,owners,bank,opened_at
8f912e95-a127-469d-b416-5237eb4f8abb,5787.342044550753,GBP,4a7edb39-029f-40a1-8fef-7ddff72537ce,Co-operative Bank,2018-04-10 00:36:44
25b093b4-e6aa-40c7-8c03-5991f0843744,7967.470665633736,GBP,682a5412-07dd-4215-be8d-aee30df50be4,Lloyds Banking Group,2003-02-04 01:50:31
89f33950-6b0e-4310-a751-d169ff12415e,9128.136912370079,GBP,5d73ead8-5cee-47ce-8692-403fe511e07d,Co-operative Bank,2012-11-04 21:18:02
0651c053-69c5-4c89-a959-04004b1af6ef,4158.837239751703,GBP,f61040ff-c30c-4d1c-acb3-5417b2bd95b2,Lloyds Banking Group,2016-10-11 23:45:09
577a6f0c-0fbe-48be-9c71-a7dd7a264ba2,3889.477255052483,GBP,962f7070-cffb-4b45-8fcb-2af9b88063a3,Royal Bank of Scotland,2016-09-19 11:33:58
e3f538c2-bc5b-4def-92ae-0a9c94698213,19033.734115247018,GBP,7babbe46-c714-44d0-9a52-192bf6e604db,Lloyds Banking Group,2013-01-21 10:05:48
9ad13c27-52ad-4932-b96d-1f714620cc25,5658.602453620952,GBP,905368ca-b852-4bae-837c-8faffb66579f,HSBC,2018-09-23 22:01:57
7a28a2be-b72a-452f-a50d-735dc06cfde9,1
@apogiatzis
apogiatzis / transactions.csv
Created February 15, 2022 08:27
obj_id amount currency sender recipient type timestamp
86822a80-fd2e-481b-a572-064bb8bdde2b 33070.0771947208 GBP ab69ea89-888a-49c5-bc29-2152bf640139 8751ba4a-b53d-4cad-afaa-e6cae0e4a08d TRANSFER 2021-09-07 14:10:00
2fd4315f-807b-49b7-9b94-cd7c3a7147d0 3806.9101883916524 GBP 44943fd7-30ae-48df-8cc9-e0851c3b85a0 4ba25847-9f04-44d1-99ed-a6c506d7e64f TRANSFER 2018-04-17 07:48:59
3f00285e-eb48-41e5-99db-dbbc59987eef 1141.6629621084373 GBP 6900aaba-5635-4747-afd9-714f5b2c521d a161eac4-736d-4950-bdc4-0ead2e6c8638 TRANSFER 2021-01-14 18:25:58
d9684a41-1a2a-4015-a9c4-7e5d56540d09 622.9774963147655 GBP 6a4e60b8-76f5-4676-bb21-e942b3b72779 1bdd38e0-1ab8-49a5-b42d-360201a05ffc TRANSFER 2022-01-13 18:48:02
bdaa6b01-6fc6-4ec6-9db5-8b5d90c72d55 26489.162040911215 GBP be1049b6-c04d-4f36-bf65-2e05b0196562 4b944683-e879-4407-8e17-50d683344334 TRANSFER 2021-09-24 13:07:54
6696471a-4ea4-46c2-9677-7de571ebcfae 3646.2037853976017 GBP d7a1b0c5-5c2b-4ba8-984f-ad391ada3e88 6a4e60b8-76f5-4676-bb21-e942b3b72779 TRANSFER 2022-01-22 11: