FARA_All_RegistrantDocs

Table actions
List of URLs to all registrant docs (available in PDF format)

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

17 rows where Registrant_Name = "AB&C Philadelphia, LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Foreign_Principal_Name 2

Foreign_Principal_Country 2

Registrant_Name 1

  • AB&C Philadelphia, LLC · 17 ✖
Link rowid ▼ Date_Stamped Registrant_Name Registration_Number Document_Type Short_Form_Name Foreign_Principal_Name Foreign_Principal_Country URL
54393 54393 2011-05-24 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Exhibit AB   Netherlands Foreign Investment Agency NETHERLANDS https://efile.fara.gov/docs/6043-Exhibit-AB-20110524-1.pdf
54394 54394 2011-05-24 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Exhibit C       https://efile.fara.gov/docs/6043-Exhibit-C-20110524-1.pdf
54395 54395 2011-05-24 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Registration Statement       https://efile.fara.gov/docs/6043-Registration-Statement-20110524-1.pdf
54396 54396 2011-05-24 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Orr, John H.     https://efile.fara.gov/docs/6043-Short-Form-20110524-2.pdf
66272 66272 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Foster, Stephanie A.     https://efile.fara.gov/docs/6043-Short-Form-20130620-6.pdf
66273 66273 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Talbot, James B.     https://efile.fara.gov/docs/6043-Short-Form-20130620-4.pdf
66274 66274 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Yarrow, Steven     https://efile.fara.gov/docs/6043-Short-Form-20130620-8.pdf
66275 66275 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20130620-1.pdf
66276 66276 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20130620-2.pdf
66277 66277 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20130620-3.pdf
66278 66278 2013-06-20 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20130620-4.pdf
130567 130567 2013-12-12 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Brandsdorfer, Louis     https://efile.fara.gov/docs/6043-Short-Form-20131212-12.pdf
130568 130568 2013-12-12 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Gentieu, Valerie     https://efile.fara.gov/docs/6043-Short-Form-20131212-14.pdf
130569 130569 2013-12-12 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Short-Form Waters, D. Bruce     https://efile.fara.gov/docs/6043-Short-Form-20131212-10.pdf
130570 130570 2013-12-12 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20131212-5.pdf
131796 131796 2014-12-18 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20141218-6.pdf
131797 131797 2014-12-18 AB&C Philadelphia, LLC AB&C Philadelphia, LLC 6043 Supplemental Statement       https://efile.fara.gov/docs/6043-Supplemental-Statement-20141218-7.pdf

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);