FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
180 rows where City = "Philadelphia" sorted by Zip
This data as json, CSV (advanced)
Registration_Number 12
- Al Paul Lefton Company, Inc. 20
- Dilworth, Paxson, Kalish, Kohn & Dilks 17
- Al Paul Lefton Company Inc. 16
- AB&C Philadelphia, LLC 7
- Gray & Rogers, Inc. 6
- Friedmann Radio Broadcasting & Advertising Company 3
- Tayoun, Joseph John 3
- ACM Worldwide, Ltd. 3
- Spiro & Associates, Inc. 2
- McLaughlin & Morgan, Inc. 1
- Rancourt, Karolyn T. 1
- Unique Solution Advisors 1
Registrant_Name 12
- Al Paul Lefton Company, Inc. 20
- Dilworth, Paxson, Kalish, Kohn & Dilks 17
- Al Paul Lefton Company Inc. 16
- AB&C Philadelphia, LLC 7
- Gray & Rogers, Inc. 6
- ACM Worldwide, Ltd. 3
- Friedmann Radio Broadcasting & Advertising Company 3
- Tayoun, Joseph John 3
- Spiro & Associates, Inc. 2
- McLaughlin & Morgan, Inc. 1
- Rancourt, Karolyn T. 1
- Unique Solution Advisors 1
State 1
- PA 80
City 1
- Philadelphia · 80 ✖
Link | rowid | Short_Form_Termination_Date | Short_Form_Date | Short_Form_Last_Name | Short_Form_First_Name | Registration_Number | Registration_Date | Registrant_Name | Address_1 | Address_2 | City | State | Zip ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21396 | 21396 | 2001-06-30 | 1994-05-06 | Waters | David Bruce | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
21397 | 21397 | 2001-06-30 | 1994-05-06 | Yarrow | Steven E. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
21400 | 21400 | 2001-06-30 | 2001-06-12 | Fong | Mary Ann | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
21401 | 21401 | 2001-06-30 | 1995-06-19 | Talbot | James E. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
21420 | 21420 | 2001-06-30 | 1998-12-21 | Ditton | Jill | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
23302 | 23302 | 2005-07-15 | 2004-03-25 | Kneisel | William J. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
23936 | 23936 | 1999-07-23 | 1997-01-16 | Michaud | Anne E. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
27592 | 27592 | 1996-08-28 | 1995-06-19 | LaBranche | Angelique | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
28379 | 28379 | 2001-08-31 | 1997-01-16 | Buckman | Judith G. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
28391 | 28391 | 2001-08-31 | 2001-06-12 | Rossi | Richard A. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
28392 | 28392 | 2001-08-31 | 2000-06-21 | Smith | J. Gregory | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
28547 | 28547 | 2010-08-31 | 2004-03-25 | Brandsdorfer | Louis | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28548 | 28548 | 2010-08-31 | 2004-03-25 | Ditton | Jill | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28549 | 28549 | 2010-08-31 | 2004-03-25 | Lefton | Al Paul Jr., | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28550 | 28550 | 2010-08-31 | 2004-03-25 | Orr | John H. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28551 | 28551 | 2010-08-31 | 2004-03-25 | Scanlon | Raymond D. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28552 | 28552 | 2010-08-31 | 2004-03-25 | Sharkey | Darlene M. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28553 | 28553 | 2010-08-31 | 2004-03-25 | Waters | D. Bruce | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28554 | 28554 | 2010-08-31 | 2004-03-25 | Yarrow | Steven E. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28556 | 28556 | 2010-08-31 | 2008-05-06 | Foster | Stephanie | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
28557 | 28557 | 2010-08-31 | 2009-05-07 | Talbot | James E. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
29246 | 29246 | 2008-09-05 | 2004-03-25 | Evans | John M. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
29357 | 29357 | 2001-09-07 | 1994-05-06 | Costomiris | D. Lynn | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
29887 | 29887 | 1999-09-15 | 1998-06-26 | Brightman | Ellen | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
31139 | 31139 | 1996-09-30 | 1994-05-06 | Kilkenny | Kathleen | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
32265 | 32265 | 1995-10-04 | 1994-05-06 | Perkins | Thomas F. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
32338 | 32338 | 2007-10-05 | 2005-10-28 | DzwIll | Eileen | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
33980 | 33980 | 1999-10-29 | 1998-06-26 | Sanders | Christine | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
34395 | 34395 | 1997-10-31 | 1995-06-19 | Pickford | Lorraine V. | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
35561 | 35561 | 1995-11-09 | 1994-05-06 | Magee | Marjorie Moll | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
35562 | 35562 | 2001-11-09 | 2000-01-10 | Ryan | M. Martha | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
36564 | 36564 | 1999-11-29 | 1998-12-21 | Haller | Wendy Ann | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
37487 | 37487 | 2006-12-01 | 2004-03-25 | Boyette | Michael | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
37490 | 37490 | 2009-12-01 | 2004-03-25 | Nunez | Nurisell | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
37615 | 37615 | 1994-12-02 | 1994-05-06 | Grasso | Amanda | Al Paul Lefton Company, Inc. 4912 | 1994-05-06 | Al Paul Lefton Company, Inc. | 100 Independence Mall, West | Rohm & Haas Building | Philadelphia | PA | 19106-2399 |
38431 | 38431 | 2009-12-15 | 2009-05-07 | Stokes | Patricia L. | Al Paul Lefton Company Inc. 5614 | 2004-03-25 | Al Paul Lefton Company Inc. | 100 Independence Mall West | Philadelphia | PA | 19106-2399 | |
16841 | 16841 | 2014-05-21 | 2013-12-12 | Brandsdorfer | Louis | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
17522 | 17522 | 2014-05-30 | 2013-06-20 | Yarrow | Steven | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
19740 | 19740 | 1977-06-17 | 1975-06-06 | Lawrence | Gordon G. | Spiro & Associates, Inc. 2545 | 1974-11-04 | Spiro & Associates, Inc. | Chestnut East Building | 841 Chestnut Street | Philadelphia | PA | 19107 |
19741 | 19741 | 1977-06-17 | 1974-11-04 | Sherman | Martin | Spiro & Associates, Inc. 2545 | 1974-11-04 | Spiro & Associates, Inc. | Chestnut East Building | 841 Chestnut Street | Philadelphia | PA | 19107 |
19946 | 19946 | 2014-06-20 | 2013-12-12 | Gentieu | Valerie | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25220 | 25220 | 2014-07-31 | 2011-05-24 | Orr | John H. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25233 | 25233 | 2014-07-31 | 2013-06-20 | Foster | Stephanie A. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25234 | 25234 | 2014-07-31 | 2013-06-20 | Talbot | James B. | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
25257 | 25257 | 2014-07-31 | 2013-12-12 | Waters | D. Bruce | AB&C Philadelphia, LLC 6043 | 2011-05-24 | AB&C Philadelphia, LLC | 125 South 9th Street | Suite 801 | Philadelphia | PA | 19107 |
33123 | 33123 | 1984-10-18 | 1982-04-21 | Delman | David | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33124 | 33124 | 1984-10-18 | 1982-04-21 | Feinstein | Laurence Robert | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33125 | 33125 | 1984-10-18 | 1982-04-21 | Ferrell | David L. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33126 | 33126 | 1984-10-18 | 1982-04-21 | Mugler | Kenneth S. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33127 | 33127 | 1984-10-18 | 1982-04-21 | Rector | Marion C. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
33128 | 33128 | 1984-10-18 | 1982-04-21 | Senker | Patricia A. | Gray & Rogers, Inc. 3358 | 1982-04-21 | Gray & Rogers, Inc. | 1234 Market Street | Philadelphia | PA | 19107 | |
37452 | 37452 | 1997-12-01 | 1997-03-14 | Arsenault | Robert L. | ACM Worldwide, Ltd. 5164 | 1997-03-14 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | |
37453 | 37453 | 1997-12-01 | 1997-03-14 | Cades | Stewart R. | ACM Worldwide, Ltd. 5164 | 1997-03-14 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | |
37454 | 37454 | 1997-12-01 | 1997-03-14 | Model | Allen J. | ACM Worldwide, Ltd. 5164 | 1997-03-14 | ACM Worldwide, Ltd. | 310 South Juniper Street | Philadelphia | PA | 19107 | |
23834 | 23834 | 1965-07-23 | 1964-07-24 | Dilks | Walter Howard , Jr. | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32130 | 32130 | 1966-10-02 | 1964-07-24 | Coleman | William T. , Jr. | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32131 | 32131 | 1966-10-02 | 1964-07-24 | Dilworth | Richardson | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32132 | 32132 | 1966-10-02 | 1964-07-24 | Fine | Aaron Mones | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32133 | 32133 | 1966-10-02 | 1964-07-24 | Frommer | John W. , Jr. | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32134 | 32134 | 1966-10-02 | 1964-07-24 | Hill | Louis Graveraet | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32135 | 32135 | 1966-10-02 | 1964-07-24 | Kalish | Harry Alexander | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32136 | 32136 | 1966-10-02 | 1964-07-24 | Kohn | Harold Lias | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32137 | 32137 | 1966-10-02 | 1964-07-24 | Korman | Dolores | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32138 | 32138 | 1966-10-02 | 1964-07-24 | Levy | Richard Langsdorf | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32139 | 32139 | 1966-10-02 | 1964-07-24 | Manoff | Marcus | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32140 | 32140 | 1966-10-02 | 1964-07-24 | Paxson | Henry Douglas | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32141 | 32141 | 1966-10-02 | 1964-07-24 | Sutton | Charles Leo | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32142 | 32142 | 1966-10-02 | 1964-07-24 | Sutton | James Anderson | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32143 | 32143 | 1966-10-02 | 1964-07-24 | Whitman | Jules I. (I. Wishnefsky) | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32144 | 32144 | 1966-10-02 | 1964-08-17 | Gordon | Richard J. | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
32145 | 32145 | 1966-10-02 | 1964-08-17 | Kalish | Jacob | Dilworth, Paxson, Kalish, Kohn & Dilks 1775 | 1964-07-24 | Dilworth, Paxson, Kalish, Kohn & Dilks | 2635 Fidelity-Philadelphia | Trust Building | Philadelphia | PA | 19109 |
3150 | 3150 | 1967-01-04 | 1960-01-07 | Friedmann | Rochelle | Friedmann Radio Broadcasting & Advertising Company 1304 | 1959-12-07 | Friedmann Radio Broadcasting & Advertising Company | 1105 Friendship Street | Philadelphia | PA | 19111 | |
3151 | 3151 | 1967-01-04 | 1964-09-21 | Berensmann | Hanns-Peter | Friedmann Radio Broadcasting & Advertising Company 1304 | 1959-12-07 | Friedmann Radio Broadcasting & Advertising Company | 1105 Friendship Street | Philadelphia | PA | 19111 | |
9897 | 9897 | 1964-03-15 | 1959-12-07 | Schmitt | Albert Richard | Friedmann Radio Broadcasting & Advertising Company 1304 | 1959-12-07 | Friedmann Radio Broadcasting & Advertising Company | 1105 Friendship Street | Philadelphia | PA | 19111 | |
2162 | 2162 | 2022-11-12 | Mach | George Edward James | Unique Solution Advisors 7191 | 2022-11-12 | Unique Solution Advisors | 2531 West Girard Avenue | Unit 3 | Philadelphia | PA | 19130 | |
40444 | 40444 | 1987-12-31 | 1981-12-03 | Jackson | Andrew | Tayoun, Joseph John 3315 | 1981-12-03 | Tayoun, Joseph John | 1229 South 11th Street | Philadelphia | PA | 19147 | |
40445 | 40445 | 1987-12-31 | 1981-12-03 | Miller | William | Tayoun, Joseph John 3315 | 1981-12-03 | Tayoun, Joseph John | 1229 South 11th Street | Philadelphia | PA | 19147 | |
40446 | 40446 | 1987-12-31 | 1981-12-03 | Tayoun | James Joseph | Tayoun, Joseph John 3315 | 1981-12-03 | Tayoun, Joseph John | 1229 South 11th Street | Philadelphia | PA | 19147 | |
16530 | 16530 | 2008-05-16 | 2003-05-02 | Rancourt | Karolyn T. | Rancourt, Karolyn T. 5559 | 2003-05-02 | Rancourt, Karolyn T. | 1648 South Orkney Street | Philadelphia | PA | 19148 | |
41004 | 41004 | 1996-12-31 | 1995-12-15 | McLaughlin | William J. | McLaughlin & Morgan, Inc. 5088 | 1995-12-15 | McLaughlin & Morgan, Inc. | 146 North Bread Street | Philadelphia | PA | 19149 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_ShortForms] ( [Short_Form_Termination_Date] TEXT, [Short_Form_Date] TEXT, [Short_Form_Last_Name] TEXT, [Short_Form_First_Name] TEXT, [Registration_Number] INTEGER, [Registration_Date] TEXT, [Registrant_Name] TEXT, [Address_1] TEXT, [Address_2] TEXT, [City] TEXT, [State] TEXT, [Zip] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );