steehold.com
format: sql
year: 2023
rows: 105196
SAMPLE
(68943, 'UG71273832', NULL, 'Ben Koryang Baatom', 'Male', NULL, 'Uganda', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Member of Parliament elected in 2021', 'None', 'None', 'https://www.parliament.go.ug/page/about-parliament', 'No Document', 'PEP', 0, 'WP8614920866', '2022-04-01 23:08:14', '2022-04-01 23:08:14', 'tVrFOCuIIv19LCldp3CI'), (68944, 'BW40589573', NULL, 'Lobatse Beslag', 'Male', NULL, 'Botswana', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Kgosi for Ghanzi West Region; Member of the 3th Ntlo Ya Dikgosi 2014-2019 (Ghanzi West Region)', 'None', 'None', 'https://www.worthpoint.com/worthopedia/members-3rd-ntlo-ya-dikgosi-2014-2019-1994402157', 'No Document', 'Royal', 0, 'WP8614932331', '2022-04-01 23:08:14', '2022-04-01 23:08:14', 'tVrFOCuIIv19LCldp3CI'), (68945, 'EC12134237', NULL, 'Ramiro Vladimir Narváez Garzón', 'Male', NULL, 'Ecuador', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Member of the National Assembly elected in 2021', 'None', 'None', 'https://2017-2021.observatoriolegislativo.ec/asamblea-nacional/asambleistas/', 'No document', 'PEP', 0, 'WP8615298164', '2022-04-01 23:08:14', '2022-04-01 23:08:14', 'tVrFOCuIIv19LCldp3CI'), (68946, 'CZ45527119', NULL, 'Jakub Michalek', 'Male', '1989-06-02', 'Czechia', 'Jan Mracek ', 'Thomas Mrackova', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Member of the Chamber of Deputies elected in 2021', 'None', 'None', 'https://www.psp.cz/en/sqw/hp.sqw?k=192', 'No Document', 'PEP', 0, 'WP8615529240', '2022-04-01 23:08:14', '2022-04-01 23:08:14', 'tVrFOCuIIv19LCldp3CI'), (68947, 'KE11648468', NULL, 'Alex Mutambo Nganga', 'Male', NULL, 'Kenya', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Member of County Assembly for Kitui County in Kenya from 2013 to 2017', 'None', 'None', 'Not Applicable', 'No Document', 'PEP', 0, 'WP8615581472', '2022-04-01 23:08:14', '2022-04-01 23:08:14', 'tVrFOCuIIv19LCldp3CI'), (68948, 'NA45733120', NULL, 'Pijoo Nganate', 'Male', NULL, 'Namibia', 'Helmi Maruru', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Governor of Omaheke Region appointed in 2020', 'None', 'None', 'https://murd.gov.na/public-staff-experience', 'No Document', 'PEP', 0, 'WP8615808169', '2022-04-01 23:08:14', '2022-04-01 23:08:14', 'tVrFOCuIIv19LCldp3CI'), (68949, 'VE44867695', NULL, 'Susana Virginia Barreiros Rodríguez', 'Female', '1981-11-07', 'Venezuela', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Unknown', 'Canadian Sanctioned Individual', 'The judge who led the case and sentencing of the Venezuela opposition leader Leopoldo López. as such engaged in activities that seriously undermine democracy, respect for human rights and the rule of law and thus Complicit for actions that undermined democracy after at least 125 people were killed in the 2017 Venezuelan protests', 'The judge sentenced the Venezuela opposition leader Leopoldo López. as such engaged in activities that seriously undermine democracy', 'https://www.international.gc.ca/world-monde/international_relations-relations_internationales/sanctions/consolidated-consolide.aspx?lang=eng', 'https://www.international.gc.ca/world-monde/assets/pdfs/international_relations-relations_internationales/sanctions/sema-lmes.pdf', 'PEP, Corruption, Human Rights, Adverse Media', 0, 'WP8615941002', '2022-04-01 23:08:14', '2023-06-15 04:44:55', 'tVrFOCuIIv19LCldp3CI'), (1958, 'WPO21407732', 'SE95202289', NULL, 'Samhall Aktiebolag, a.k.a Samhall', NULL, NULL, 'Sweden', 'Box 27705\n115 91 Stockholm', NULL, NULL, NULL, NULL, 'Unknown', 'State-Owned', 'This entity is owned by the government', 'State-Owned Enterprise', NULL, 'None', 'None', 'https://www.government.se/government-agencies/#2154', 'No Document', 0, '2022-04-01 23:00:23', '2023-05-15 19:07:59', 'tVrFOCuIIv19LCldp3CI'), (1959, 'WPO21414765', 'GB85064569', NULL, 'ADVANCED ELECTRONICS DEVELOPMENT, LTD', NULL, NULL, 'United Kingdom', '3 Mandeville Place, London, United Kingdom', NULL, NULL, NULL, NULL, 'Unknown', 'Sanction', 'ADVANCED ELECTRONICS DEVELOPMENT, LTD, 3 Mandeville Place, London, United Kingdom [IRAQ2]. ', 'OFAC Sanctioned Entity', NULL, 'Transactions Prohibited For Persons Owned or Controlled by U.S. Financial Institutions', 'Sanctioned by OFAC', 'https://home.treasury.gov/policy-issues/financial-sanctions/specially-designated-nationals-and-blocked-persons-list-sdn-human-readable-lists', 'https://www.treasury.gov/ofac/downloads/sdnlist.pdf', 0, '2022-04-01 23:00:23', '2023-05-15 19:07:59', 'tVrFOCuIIv19LCldp3CI'), (1960, 'WPO21424581', 'SA34388711', NULL, 'NURIN COMPANY, a.k.a AL-OSAMA TRADING CO. LTD., AL-\'USAMA TRADING COMPANY, ASYAF GROUP, ASYAF INTERNATIONAL HOLDING GROUP, ASYAF INTERNATIONAL HOLDING GROUP FOR TRADING & INVESTMENT, ASYAF INTERNATIONAL HOLDING GROUP FOR TRADING AND INVESTMENT, DAN ISDICO', NULL, NULL, 'Saudi Arabia', 'P.O. Box 8800, Jeddah 21492, Saudi Arabia; 504 & 7102, Ibrahim Shakir Building, Hail Street Rowais, Near Caravan Center, Jeddah 21492, Saudi Arabia; Pr. Amir Sultan Street, Khalidiya Business Center, 3rd Floor, Khalidiya, Jeddah, Saudi Arabia; Riyadh 14213, Saudi Arabia; Dammam, Saudi Arabia; Al Kharaj, Saudi Arabia; Qasim, Saudi Arabia; Khartoum, Sudan ', NULL, NULL, NULL, NULL, 'AL-AGHA Abu Ubaydah Khayri Hafiz, HAMAS', 'Sanction', '\"NURIN COMPANY\" (a.k.a. AL-OSAMA TRADING CO. LTD.; a.k.a. AL-\'USAMA TRADING COMPANY; a.k.a. ASYAF GROUP; a.k.a. ASYAF INTERNATIONAL HOLDING GROUP; a.k.a. ASYAF INTERNATIONAL HOLDING GROUP FOR TRADING & INVESTMENT; a.k.a. ASYAF INTERNATIONAL HOLDING GROUP FOR TRADING AND INVESTMENT; a.k.a. DAN ISDICO; a.k.a. M/S OSAMA KHAIRY HAFEZ TRADING EST.;a.k.a. OSAMA TRADING COMPANY LTD; a.k.a. \"AL-\'USAMAH COMPANY\"; a.k.a. \"ASAMA COMMERCIAL COMPANY\"; a.k.a. \"ASAMA COMPANY\"), P.O. Box 8800, Jeddah 21492, Saudi Arabia; 504 & 7102, Ibrahim Shakir Building, Hail Street Rowais, Near Caravan Center, Jeddah 21492, Saudi Arabia; Pr. Amir Sultan Street, Khalidiya Business Center, 3rd Floor, Khalidiya, Jeddah, Saudi Arabia; Riyadh 14213, Saudi Arabia; Dammam, Saudi Arabia; Al Kharaj, Saudi Arabia; Qasim, Saudi Arabia; Khartoum, Sudan [SDGT] (Linked To: AL-AGHA, Abu Ubaydah Khayri Hafiz; Linked To: HAMAS)', 'OFAC Sanctioned Entity', NULL, 'Transactions Prohibited For Persons Owned or Controlled by U.S. Financial Institutions', 'Sanctioned by OFAC', 'https://home.treasury.gov/policy-issues/financial-sanctions/specially-designated-nationals-and-blocked-persons-list-sdn-human-readable-lists', 'https://www.treasury.gov/ofac/downloads/sdnlist.pdf', 0, '2022-04-01 23:00:23', '2023-05-15 19:07:59', 'tVrFOCuIIv19LCldp3CI'), (1961, 'WPO21429286', 'VN99745678', NULL, 'GETINSA INGENIERIA VIETNAM COMPANY LTD.', NULL, NULL, 'Vietnam', 'NV37 TRUNG VAN NEW URBAN AREA TRUNG VAN WARD SOUTH TU LIEM DIST. HANOI', NULL, NULL, NULL, NULL, 'Unknown', 'Fraud', 'Placed on the World Bank debarred parties list', 'World Bank Sanctioned Entity', NULL, 'Sanctioned by the World Bank from 29-Nov-2021 to 28-Nov-2027', 'World Bank Debarred Entity', 'https://www.worldbank.org/en/projects-operations/procurement/debarred-firms', 'https://thedocs.worldbank.org/en/doc/387181466627871302-0290022021/original/WorldBankNotesonDebarredFirmsandIndividuals.pdf', 0, '2022-04-01 23:00:23', '2023-05-15 19:07:59', 'tVrFOCuIIv19LCldp3CI'),