FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
78 rows where Foreign_Principal_Name = "All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry""
This data as json, CSV (advanced)
Suggested facets: Date_Stamped (date)
Registrant_Name
Document_Type
Foreign_Principal_Name
- All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" · 78 ✖
Foreign_Principal_Country
- UKRAINE 78
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
3249 | 3249 | 2021-01-04 | Yorktown Solutions, LLC | 6491 6491 | Exhibit AB | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Exhibit-AB-20200104-18.pdf | |
3401 | 3401 | 2020-01-05 | Yorktown Solutions, LLC | 6491 6491 | Exhibit AB | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Exhibit-AB-20200105-14.pdf | |
4949 | 4949 | 2021-01-13 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210113-173.pdf | |
5647 | 5647 | 2021-01-18 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210118-178.pdf | |
5813 | 5813 | 2021-01-19 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210119-179.pdf | |
5960 | 5960 | 2021-01-20 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210120-180.pdf | |
6133 | 6133 | 2021-01-21 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210121-181.pdf | |
6720 | 6720 | 2020-01-24 | 6491 | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200124-70.pdf | |
12550 | 12550 | 2021-02-01 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210201-186.pdf | |
13201 | 13201 | 2021-02-04 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210204-188.pdf | |
13439 | 13439 | 2021-02-05 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210205-190.pdf | |
14016 | 14016 | 2021-02-08 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210208-191.pdf | |
14160 | 14160 | 2021-02-09 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210209-193.pdf | |
14328 | 14328 | 2021-02-10 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210210-194.pdf | |
14503 | 14503 | 2021-02-11 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210211-195.pdf | |
14851 | 14851 | 2020-02-13 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200213-65.pdf | |
14852 | 14852 | 2020-02-13 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200213-66.pdf | |
15373 | 15373 | 2021-02-16 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210216-196.pdf | |
15742 | 15742 | 2020-02-18 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200218-60.pdf | |
15758 | 15758 | 2021-02-18 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210218-198.pdf | |
15928 | 15928 | 2021-02-19 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210219-199.pdf | |
15929 | 15929 | 2021-02-19 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210219-200.pdf | |
16464 | 16464 | 2021-02-22 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210222-201.pdf | |
16692 | 16692 | 2021-02-23 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210223-202.pdf | |
16884 | 16884 | 2020-02-24 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200224-68.pdf | |
16916 | 16916 | 2021-02-24 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210224-204.pdf | |
17352 | 17352 | 2020-02-26 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200226-59.pdf | |
17353 | 17353 | 2020-02-26 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200226-62.pdf | |
17695 | 17695 | 2021-02-27 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210227-205.pdf | |
22367 | 22367 | 2021-03-01 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20210301-206.pdf | |
22647 | 22647 | 2019-03-02 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20190302-124.pdf | |
24341 | 24341 | 2020-03-10 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200310-71.pdf | |
25967 | 25967 | 2020-03-18 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200318-74.pdf | |
27336 | 27336 | 2020-03-25 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200325-75.pdf | |
43353 | 43353 | 2020-05-03 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200503-85.pdf | |
43807 | 43807 | 2020-05-06 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200506-87.pdf | |
45477 | 45477 | 2020-05-14 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200514-89.pdf | |
46333 | 46333 | 2020-05-18 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200518-90.pdf | |
46501 | 46501 | 2020-05-19 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200519-91.pdf | |
55095 | 55095 | 2020-06-04 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200604-93.pdf | |
56489 | 56489 | 2020-06-11 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200611-94.pdf | |
56685 | 56685 | 2020-06-12 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200612-95.pdf | |
57163 | 57163 | 2020-06-15 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200615-98.pdf | |
57316 | 57316 | 2020-06-16 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200616-99.pdf | |
57491 | 57491 | 2020-06-17 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200617-100.pdf | |
66853 | 66853 | 2020-07-16 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200716-105.pdf | |
66854 | 66854 | 2020-07-16 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200716-106.pdf | |
67844 | 67844 | 2020-07-21 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200721-107.pdf | |
68436 | 68436 | 2020-07-24 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200724-108.pdf | |
74815 | 74815 | 2020-08-05 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200805-109.pdf | |
75007 | 75007 | 2020-08-06 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200806-110.pdf | |
75864 | 75864 | 2020-08-10 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200810-111.pdf | |
76043 | 76043 | 2020-08-11 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200811-112.pdf | |
77496 | 77496 | 2020-08-20 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200820-114.pdf | |
78393 | 78393 | 2020-08-26 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200826-116.pdf | |
78601 | 78601 | 2020-08-27 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200827-117.pdf | |
79873 | 79873 | 2020-08-31 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200831-118.pdf | |
83685 | 83685 | 2020-09-03 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200903-120.pdf | |
83686 | 83686 | 2020-09-03 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200903-122.pdf | |
83687 | 83687 | 2020-09-03 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200903-123.pdf | |
86346 | 86346 | 2020-09-17 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200917-142.pdf | |
86347 | 86347 | 2020-09-17 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200917-145.pdf | |
86578 | 86578 | 2020-09-18 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200918-144.pdf | |
88765 | 88765 | 2020-09-28 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20200928-149.pdf | |
95400 | 95400 | 2020-10-12 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201012-150.pdf | |
95588 | 95588 | 2020-10-13 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201013-151.pdf | |
95710 | 95710 | 2020-10-14 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201014-152.pdf | |
95711 | 95711 | 2020-10-14 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201014-153.pdf | |
95712 | 95712 | 2020-10-14 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201014-154.pdf | |
96858 | 96858 | 2020-10-20 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201020-155.pdf | |
96859 | 96859 | 2020-10-20 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201020-156.pdf | |
96860 | 96860 | 2020-10-20 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201020-157.pdf | |
97441 | 97441 | 2020-10-23 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201023-158.pdf | |
104992 | 104992 | 2020-11-12 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201112-162.pdf | |
105405 | 105405 | 2020-11-14 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201114-165.pdf | |
113713 | 113713 | 2020-12-01 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201201-166.pdf | |
115951 | 115951 | 2020-12-14 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201214-170.pdf | |
118091 | 118091 | 2020-12-24 | Yorktown Solutions, LLC | 6491 6491 | Informational Materials | All-Ukrainian Industry Association "Federation of Employers of the Oil and Gas Industry" | UKRAINE | https://efile.fara.gov/docs/6491-Informational-Materials-20201224-176.pdf |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY(Registration_Number) REFERENCES FARA_All_Registrants(Registration_Number) );