Copy for matching sample.txt
LOAD CSV WITH HEADERS FROM "file:/Final Neo4j Matching Sample.csv" AS line
FIELDTERMINATOR ','
MERGE(case:Cases {name:line.Case,link:line.Link})
MERGE(company:Company{name:line.CompanyNamesReconciled,number:line.CompanyNumber,type:line.CompanyType,status:line.CompanyStatus,incorporation:line.IncorporationDate,dissolution:line.DissolutionDate,companypreviousnames:line.CompanyPreviousNames,previousnamesnumber:line.NumberofPreviousNames,changeinregisteredaddress:line.ChangeInRegisteredAddress,previousaddressnumber:line.NumberofPreviousAddresses,executivenumber:line.TotalNumberofExecutives,industrycode1:line.IndustryCode1,description1:line.DescriptionofIndustryCode1,industrycode2:line.IndustryCode2,description2:line.DescriptionofIndustryCode2,industrycode3:line.IndustryCode3,description3:line.DescriptionofIndustryCode3,industrycode4:line.IndustryCode4,description4:line.DescriptionofIndustryCode4,industrycode5:line.IndustryCode5,description5:line.DescriptionofIndustryCode5,industrycode6:line.IndustryCode6,description6:line.DescriptionofIndustryCode6,industrycode7:line.IndustryCode7,description8:line.DescriptionofIndustryCode8,industrycode9:line.IndustryCode9,description9:line.DescriptionofIndustryCode9,industrycode10:line.IndustryCode10,description10:line.DescriptionofIndustryCode10,dateofreportingcash:line.DateofReportingCashatBank,latestcashatbank:line.LatestFinancialsCashatBank,previousdateofreportingcash:line.PreviousYearDateofReportingCashatBank,previouscashatbank:line.PreviousFinancialsCashatBank,dateofreportingcurrentassets:line.DateofReportingCurrentAssets,latestcurrentassets:line.LatestFinancialsCurrentAssets,previousdateofreportingcurrentassets:line.PreviousYearDateofReportingCurrentAssets,previouscurrentassets:line.PreviousFinancialsCurrentAssets,dateofreportingcurrentliabilities:line.DateofReportingCurrentLiabilities,latestcurrentliabilities:line.LatestFinancialsCurrentLiabilities,previousdateofreportingcurrentliabilities:line.PreviousYearDateofReportingCurrentLiabilities,previouscurrentliabilities:line.PreviousFinancialsCurrentLiabilities,dateofreportingfixedassets:line.DateofReportingFixedAssets,latestfixedassets:line.LatestFinancialsFixedAssets,previousdateofreportingfixedassets:line.PreviousYearDateofReportingFixedAssets,previousfixedassets:line.PreviousFinancialsFixedAssets})
MERGE(registeredaddress:CompanyAddress{address:line.RegisteredAddress,postalcodes:line.PostalCodes})
MERGE(case)-[:COMPANY]->(company)-[:COMPANYADDRESS]->(registeredaddress)
FOREACH (ignoreMe IN CASE WHEN line.ChangeInRegisteredAddress="Yes" AND toInteger(line.NumberofPreviousNames)=0 THEN [1] ELSE [] END|
FOREACH (ignoreMe IN CASE WHEN line.PrevAddress1 <> "NA" THEN [1] ELSE [] END|
MERGE (address1:Address{address:line.PrevAddress1,starttenure:line.StartofTenureAddress1,endtenure:line.EndofTenureAddress1})
This file has been truncated. show original
Final Neo4j Matching Sample.csv
RowID Case Link CompanyNamesReconciled CompanyNumber CompanyType CompanyStatus IncorporationDate DissolutionDate CompanyPreviousNames NumberofPreviousNames CompanyPreviousName1 StartDateofPreviousName1 EndDateofPreviousName1 CompanyPreviousName2 StartDateofPreviousName2 EndDateofPreviousName2 CompanyPreviousName3 StartDateofPreviousName3 EndDateofPreviousName3 CompanyPreviousName4 StartDateofPreviousName4 EndDateofPreviousName4 RegisteredAddress RegisteredStreetAddress Location PostalCodes ChangeInRegisteredAddress NumberofPreviousAddresses PrevAddress1 StartofTenureAddress1 EndofTenureAddress1 PrevAddress2 StartofTenureAddress2 EndofTenureAddress2 PrevAddress3 StartofTenureAddress3 EndofTenureAddress3 IndustryCode1 DescriptionofIndustryCode1 IndustryCode2 DescriptionofIndustryCode2 IndustryCode3 DescriptionofIndustryCode3 IndustryCode4 DescriptionofIndustryCode4 IndustryCode5 DescriptionofIndustryCode5 IndustryCode6 DescriptionofIndustryCode6 IndustryCode7 DescriptionofIndustryCode7 IndustryCode8 DescriptionofIndustryCode8 IndustryCode9 DescriptionofIndustryCode9 IndustryCode10 DescriptionofIndustryCode10 DateofReportingCashatBank LatestFinancialsCashatBank PreviousYearDateofReportingCashatBank PreviousFinancialsCashatBank DateofReportingCurrentAssets LatestFinancialsCurrentAssets PreviousYearDateofReportingCurrentAssets PreviousFinancialsCurrentAssets DateofReportingCurrentLiabilities LatestFinancialsCurrentLiabilities PreviousYearDateofReportingCurrentLiabilities PreviousFinancialsCurrentLiabilities DateofReportingFixedAssets LatestFinancialsFixedAssets PreviousYearDateofReportingFixedAssets PreviousFinancialsFixedAssets TotalNumberofExecutives IdentificationNumberofExecutive1 NameofExecutive1 DateofBirthofExecutive1 PositionofExecutive1 AddressofExecutive1 StartDateofExecutive1sTenure EndDateofExecutive1sTenure NationalityofExecutive1 Executive1sNationsFSIRanking AppointmentsofExecutive1 PEPandSanctionCheckMatches1 IdentificationNumberofExecutive2 NameofExecutive2 DateofBirthofExecutive2 AddressofExecutive2 PositionofExecutive2 StartDateofExecutive2sTenure EndDateofExecutive2sTenure NationalityofExecutive2 Executive2sNationsFSIRanking AppointmentsofExecutive2 PEPandSanctionCheckMatches2 IdentificationNumberofExecutive3 NameofExecutive3 DateofBirthofExecutive3 AddressofExecutive3 PositionofExecutive3 StartDateofExecutive3sTenure EndDateofExecutive3sTenure NationalityofExecutive3 Executive3sNationsFSIRanking AppointmentsofExecutive3 PEPandSanctionCheckMatches3 IdentificationNumberofExecutive4 NameofExecutive4 DateofBirthofExecutive4 AddressofExecutive4 PositionofExecutive4 StartDateofExecutive4sTenure EndDateofExecutive4sTenure NationalityofExecutive4 Executive4sNationsFSIRanking AppointmentsofExecutive4 PEPandSanctionCheckMatches4 IdentificationNumberofExecutive5 NameofExecutive5 DateofBirthofExecutive5 AddressofExecutive5 PositionofExecutive5 StartDateofExecutive5sTenure EndDateofExecutive5sTenure NationalityofExecutive5 Executive5sNationsFSIRanking AppointmentsofExecutive5 PEPandSanctionCheckMatches5 IdentificationNumberofExecutive6 NameofExecutive6 DateofBirthofExecutive6 AddressofExecutive6 PositionofExecutive6 StartDateofExecutive6sTenure EndDateofExecutive6sTenure NationalityofExecutive6 Executive6sNationsFSIRanking AppointmentsofExecutive6 PEPandSanctionCheckMatches6 IdentificationNumberofExecutive7 NameofExecutive7 DateofBirthofExecutive7 AddressofExecutive7 PositionofExecutive7 StartDateofExecutive7sTenure EndDateofExecutive7sTenure NationalityofExecutive7 Executive7sNationsFSIRanking AppointmentsofExecutive7 PEPandSanctionCheckMatches7 IdentificationNumberofExecutive8 NameofExecutive8 DateofBirthofExecutive8 AddressofExecutive8 PositionofExecutive8 StartDateofExecutive8sTenure EndDateofExecutive8sTenure NationalityofExecutive8 Executive8sNationsFSIRanking AppointmentsofExecutive8 PEPandSanctionCheckMatches8 IdentificationNumberofExecutive9 NameofExecutive9 DateofBirthofExecutive9 AddressofExecutive9 PositionofExecutive9 StartDateofExecutive9sTenure EndDateofExecutive9sTenure NationalityofExecutive9 Executive9sNationsFSIRanking AppointmentsofExecutive9 PEPandSanctionCheckMatches9 IdentificationNumberofExecutive10 NameofExecutive10 DateofBirthofExecutive10 AddressofExecutive10 PositionofExecutive10 StartDateofExecutive10sTenure EndDateofExecutive10sTenure NationalityofExecutive10 Executive10sNationsFSIRanking AppointmentsofExecutive10 PEPandSanctionCheckMatches10 IdentificationNumberofExecutive11 NameofExecutive11 DateofBirthofExecutive11 AddressofExecutive11 PositionofExecutive11 StartDateofExecutive11sTenure EndDateofExecutive11sTenure NationalityofExecutive11 Executive11sNationsFSIRanking AppointmentsofExecutive11 PEPandSanctionCheckMatches11 IdentificationNumberofExecutive12 NameofExecutive12 DateofBirthofExecutive12 AddressofExecutive12 PositionofExecutive12 StartDateofExecutive12sTenure EndDateofExecutive12sTenure NationalityofExecutive12 Executive12sNationsFSIRanking AppointmentsofExecutive12 PEPandSanctionCheckMatches12 IdentificationNumberofExecutive13 NameofExecutive13 DateofBirthofExecutive13 AddressofExecutive13 PositionofExecutive13 StartDateofExecutive13sTenure EndDateofExecutive13sTenure NationalityofExecutive13 Executive13sNationsFSIRanking AppointmentsofExecutive13 PEPandSanctionCheckMatches13 IdentificationNumberofExecutive14 NameofExecutive14 DateofBirthofExecutive14 AddressofExecutive14 PositionofExecutive14 StartDateofExecutive14sTenure EndDateofExecutive14sTenure NationalityofExecutive14 Executive14sNationsFSIRanking AppointmentsofExecutive14 PEPandSanctionCheckMatches14 IdentificationNumberofExecutive15 NameofExecutive15 DateofBirthofExecutive15 AddressofExecutive15 PositionofExecutive15 StartDateofExecutive15sTenure EndDateofExecutive15sTenure NationalityofExecutive15 Executive15sNationsFSIRanking AppointmentsofExecutive15 PEPandSanctionCheckMatches15 IdentificationNumberofExecutive16 NameofExecutive16 DateofBirthofExecutive16 AddressofExecutive16 PositionofExecutive16 StartDateofExecutive16sTenure EndDateofExecutive16sTenure NationalityofExecutive16 Executive16sNationsFSIRanking AppointmentsofExecutive16 PEPandSanctionCheckMatches16 IdentificationNumberofExecutive17 NameofExecutive17 DateofBirthofExecutive17 AddressofExecutive17 PositionofExecutive17 StartDateofExecutive17sTenure EndDateofExecutive17sTenure NationalityofExecutive17 Executive17sNationsFSIRanking AppointmentsofExecutive17 PEPandSanctionCheckMatches17 IdentificationNumberofExecutive18 NameofExecutive18 DateofBirthofExecutive18 AddressofExecutive18 PositionofExecutive18 StartDateofExecutive18sTenure EndDateofExecutive18sTenure NationalityofExecutive18 Executive18sNationsFSIRanking AppointmentsofExecutive18 PEPandSanctionCheckMatches18 IdentificationNumberofExecutive19 NameofExecutive19 DateofBirthofExecutive19 AddressofExecutive19 PositionofExecutive19 StartDateofExecutive19sTenure EndDateofExecutive19sTenure NationalityofExecutive19 Executive19sNationsFSIRanking AppointmentsofExecutive19 PEPandSanctionCheckMatches19 IdentificationNumberofExecutive20 NameOfExecutive 20 DateofBirthofExecutive20 AddressofExecutive20 PositionofExecutive20 StartDateofExecutive20sTenure EndDateofExecutive20sTenure NationalityofExecutive20 Executive20sNationsFSIRanking AppointmentsofExecutive20 PEPandSanctionCheckMatches20 IdentificationNumberofExecutive21 NameOfExecutive21 DateofBirthofExecutive21 AddressofExecutive21 PositionofExecutive21 StartDateofExecutive21sTenure EndDateofExecutive21sTenure NationalityofExecutive21 Executive21sNationsFSIRanking AppointmentsofExecutive21 PEPandSanctionCheckMatches21 NumberofBeneficialOwners UltimateBeneficialOwner1 PEPandSanctionCheckMatchforOwner1 UltimateBeneficialOwner2 PEPandSanctionCheckMatchforOwner2 UltimateBeneficialOwner3 PEPandSanctionCheckMatchforOwner3 UltimateBeneficialOwner4 PEPandSanctionCheckMatchforOwner4
1 Non-Corruption 1 No link 1 HOFFNAR LIMITED 10412818 Private Limited Company Dissolved 10/06/2016 4/02/2019 No 0 NA NA NA NA NA NA NA NA NA NA NA NA "Flat 2 Genesis House
37 Woodlands Road, Surbiton, KT6 6PR" "Flat 2 Genesis House
37 Woodlands Road" Surbiton KT6 6PR No 0 NA NA NA NA NA NA uk_sic_2007-7499 Non-trading company eu_nace_2-749 Other professional, scientific and technical activities n.e.c. isic_4-749 Other professional, scientific and technical activities n.e.c. NA NA NA NA NA NA NA NA NA NA NA NA NA NA 31/10/2017 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 1 251653874 OMAR SHAIKH Dec-80 director Puggaardsgade 4,4th, Puggaardsgade 4,4th, Copenhagen, Denmark, 1573 10/06/2016 NA UNITED KINGDOM 23 1 No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No 1 Mr Omar Omar Shaikh No NA No NA No NA No
2 Non-Corruption 2 No link 2 DANTECH FASTENERS LIMITED 3661851 Private Limited Company Active 11/05/1998 NA No 0 NA NA NA NA NA NA NA NA NA NA NA NA "Unit 6 Seven Stars Road
Seven Stars Business Centre, Oldbury, B69 4JR" "Unit 6 Seven Stars Road
Seven Stars Business Centre" Oldbury B69 4JR Yes 3 37 stanmore hill stanmore middlesex HA7 3DS 5/11/1998 6/09/2006 4 Crowberry Close Clayhanger Walsall West Midlands WS8 7RH 6/09/2006 7/02/2012 Gander Cottage Frog Lane Wheaton Aston Stafford ST19 9NW 7/02/2012 31/08/2016 uk_sic_2007-3299 Other manufacturing n.e.c. eu_nace_2-3299 Other manufacturing n.e.c. isic_4-3290 Other manufacturing n.e.c. NA NA NA NA NA NA NA NA NA NA NA NA NA NA 31/07/2017 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 4 192647553 HALLMARK SECRETARIES LIMITED NA secretary Unit 6, Seven Stars Road, Seven Stars Business Centre, Oldbury, England, B69 4JR 11/05/1998 11/05/1998 UNITED KINGDOM 23 2 No 192647578 HALLMARK REGISTRARS LIMITED Apr-57 Unit 6, Seven Stars Road, Seven Stars Business Centre, Oldbury, England, B69 4JR director 11/05/1998 11/05/1998 DENMARK 61 3 No 250416794 JUDITH MARIE NIELSEN NA 120 East Road, London, N1 6AA secretary 11/05/1998 NA NA NA 8509 No 250416795 ALLAN JUUL TVED NIELSEN NA 120 East Road, London, N1 6AA director 11/05/1998 NA NA NA 8338 No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No 1 Mr. Allan Juul Tved Nielsen No NA No NA No NA No
3 Non-Corruption 3 No link 3 JULIUS NIELSEN (UK) LIMITED 4408458 Private Limited Company Active 4/03/2002 NA Yes 2 JULIUS NIELSEN HOLDING (UK) LIMITED 24/09/2003 20/08/2007 IPF INTERNATIONAL PROPERTIES FINANCE LONDON LIMITED 4/03/2002 24/09/2003 NA NA NA NA NA NA "Abbey House 51 High Street
Saffron Walden, Essex, CB10 1AF" "Abbey House 51 High Street
Saffron Walden" Essex CB10 1AF Yes 4 2 babmaes street london SW1Y 6NT 3/04/2002 8/09/2003 5TH floor 86 jermyn street london SW1Y 6AW 8/09/2003 6/12/2004 3 Bentinck Mews London W1U 2AH 6/12/2004 6/04/2010 uk_sic_2007-7499 Non-trading company eu_nace_2-749 Other professional, scientific and technical activities n.e.c. isic_4-749 Other professional, scientific and technical activities n.e.c. NA NA NA NA NA NA NA NA NA NA NA NA NA NA 30/09/2017 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA 14 205712172 LONDON SECRETARIES LIMITED Jan-64 secretary Flat 5, 6 Peralta Court, Ir-Rampa Ta San Giljan, St Julians Stj 1062, Malta 4/05/2002 11/03/2004 DENMARK 61 1 No 205712185 MARYLEBONE MANAGEMENT SERVICES LIMITED NA 5th Floor, 86 Jermyn Street, London, SW1Y 6AW secretary 11/03/2004 2/07/2012 NA NA 357 No 205712202 TADCO SECRETARIAL SERVICES LIMITED NA 6th, Floor, 63 Curzon Street Mayfair, London, United Kingdom, W1J 8PD secretary 4/03/2002 4/05/2002 NA NA 29 No 205712228 WILLIAM ROBERT HAWES NA 6th Floor Tsl Business Centre, 94-96 Wigmore Street, London, W1U 3RF director 4/05/2002 7/02/2002 NA NA 251 No 205712248 THOMAS LANE Jan-45 124 Barrowgate Road, London, W4 4QP director 4/05/2002 11/03/2004 UNITED KINGDOM 23 423 No 205712262 SAMANTHA DALZIEL LEAK Oct-60 2 Circus Street, London, SE10 8SG director 11/03/2004 2/07/2011 UNITED KINGDOM 23 281 No 205712281 MARYLEBONE DIRECTORS LIMITED Jul-70 4 Royal Bank Court, Le Mont Millais, St Helier, Jersey, Channel Islands, Britain, JE2 4RA director 13/02/2006 2/07/2012 UNITED KINGDOM 23 35 No 205712304 DAVID JOHN MCMASTER Aug-58 23 Dornden Drive, Langton Green, Tunbridge Wells, Kent, TN3 0AA director 14/06/2005 19/12/2005 UNITED KINGDOM 23 62 No 205712318 MADS JULIUS NIELSEN May-57 PO Box 1075, Elizabeth House, 9 Castle Street, St Helier, Jersey, Channel Islands, JE4 2QP director 2/07/2012 NA UNITED KINGDOM 23 18 No 205712331 JACQUELINE ANNETTE OLLERENSHAW Apr-77 196 Bath Street, Glasgow, Scotland, G2 4HG director 2/07/2011 3/03/2011 UNITED KINGDOM 23 60 No 205712348 KENNETH RAE Jan-68 6th Floor, 63 Curzon Street, Mayfair, London, W1J 8PD director 17/06/2011 2/07/2012 UNITED KINGDOM 23 14 No 205712368 RED SHIELD MANAGEMENT LIMITED NA 6th, Floor, 63 Curzon Street Mayfair, London, United Kingdom, W1J 8PD director 14/06/2005 2/07/2012 NA NA 31 No 205712384 ROBERT PHILLIP SURCOUF NA 6th, Floor, 63 Curzon Street Mayfair, London, United Kingdom, W1J 8PD director 3/03/2011 17/06/2011 NA NA 31 No 205712405 TADCO DIRECTORS LIMITED NA 6th Floor Tsl Business Centre, 94-96 Wigmore Street, London, W1U 3RF director 4/03/2002 4/05/2002 NA NA 248 No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No NA NA NA NA NA NA NA NA NA NA No 1 Mr Mads Julius Nielsen No NA No NA No NA No
This file has been truncated. show original
