FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
33 rows where "Short_Form_Termination_Date" is on date 2018-07-31 sorted by Registration_Date
This data as json, CSV (advanced)
Suggested facets: Address_1, Short_Form_Date (date)
Registration_Number 13
- Lloyd's of London Market Representatives 9
- KOTRA 7
- Beckerman 5
- Daniel J. Edelman, Inc. 2
- Zeno Group, Inc. 2
- Italian Government Tourist Board, New York 1
- Japan National Tourism Organization 1
- Italian Government Travel Office, Chicago 1
- KARV Communications, Inc. 1
- S.G.R. LLC Government Relations and Lobbying 1
- DLM Group, LLC 1
- Filangiere Society for Justice and Good Government 1
- Churchill Ripley, LLC 1
Registrant_Name 13
- Lloyd's of London Market Representatives 9
- KOTRA 7
- Beckerman 5
- Daniel J. Edelman, Inc. 2
- Zeno Group, Inc. 2
- Churchill Ripley, LLC 1
- DLM Group, LLC 1
- Filangiere Society for Justice and Good Government 1
- Italian Government Tourist Board, New York 1
- Italian Government Travel Office, Chicago 1
- Japan National Tourism Organization 1
- KARV Communications, Inc. 1
- S.G.R. LLC Government Relations and Lobbying 1
City 8
- New York 10
- London 9
- Chicago 5
- Hackensack 5
- Burke 1
- Los Angeles 1
- New York 1
- Washington 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25335 | 25335 | 2018-07-31 | 2017-10-17 | Persampieri | Salvatore | Italian Government Tourist Board, New York 568 | 1949-04-21 | Italian Government Tourist Board, New York | 686 Park Avenue | 3rd Floor | New York | NY | 10065 |
25312 | 25312 | 2018-07-31 | 2016-02-04 | Yoneda | Hiromi | Japan National Tourism Organization 769 | 1953-05-26 | Japan National Tourism Organization | 250 Park Avenue Suite. 1900 | New York | NY | 10177 | |
25320 | 25320 | 2018-07-31 | 2016-05-27 | Chae | Hee Kwang | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25336 | 25336 | 2018-07-31 | 2014-11-25 | Cha | Sungwook | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25337 | 25337 | 2018-07-31 | 2014-11-25 | Kim | Hanseung | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25338 | 25338 | 2018-07-31 | 2014-11-25 | Kim | Sooyeon | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25339 | 25339 | 2018-07-31 | 2015-11-30 | Kwon | Ohsuk | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25340 | 25340 | 2018-07-31 | 2015-11-30 | Yu | Byoungwoo | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25341 | 25341 | 2018-07-31 | 2016-11-30 | Ahn | Yooseok | KOTRA 1619 | 1963-04-17 | KOTRA | 460 Park Avenue | 14th Floor | New York | NY | 10022 |
25334 | 25334 | 2018-07-31 | 2017-10-17 | Chillemi | Mina Amendola | Italian Government Travel Office, Chicago 1892 | 1968-06-07 | Italian Government Travel Office, Chicago | 401 North Michigan Avenue | Suite 1720 | Chicago | IL | 60611 |
25317 | 25317 | 2018-07-31 | 2018-04-27 | Hickson | Kelsey | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25318 | 25318 | 2018-07-31 | 2018-04-27 | Kirschenbaum | Elizabeth Kubo | Daniel J. Edelman, Inc. 3634 | 1984-11-15 | Daniel J. Edelman, Inc. | 111 North Canal Street | Suite 1100 | Chicago | IL | 60606 |
25313 | 25313 | 2018-07-31 | 2013-02-26 | Miesowitz | Sabrina Ariel | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25314 | 25314 | 2018-07-31 | 2005-02-28 | Parry | John | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25315 | 25315 | 2018-07-31 | 2018-03-02 | Carter | Misty | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25316 | 25316 | 2018-07-31 | 2018-03-02 | Claydon | Simon | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25323 | 25323 | 2018-07-31 | 1994-06-01 | Evans | Alastair MacKenzie | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25327 | 25327 | 2018-07-31 | 2000-08-17 | Gunset | Joseph P. | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25328 | 25328 | 2018-07-31 | 2002-08-19 | Walmsley | James Stuart Mainprize | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25330 | 25330 | 2018-07-31 | 2016-08-30 | Grant | Tirnothy | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25331 | 25331 | 2018-07-31 | 2017-08-30 | Weaver | Hilary | Lloyd's of London Market Representatives 4883 | 1994-01-06 | Lloyd's of London Market Representatives | One Lime Street | London | |||
25324 | 25324 | 2018-07-31 | 2008-08-14 | Schranz | Gerald | Beckerman 5877 | 2008-08-14 | Beckerman | One University Plaza | Suite 507 | Hackensack | NJ | 07601 |
25325 | 25325 | 2018-07-31 | 2008-08-14 | Taccini | Angelene | Beckerman 5877 | 2008-08-14 | Beckerman | One University Plaza | Suite 507 | Hackensack | NJ | 07601 |
25326 | 25326 | 2018-07-31 | 2008-08-14 | Zakheim | Keith | Beckerman 5877 | 2008-08-14 | Beckerman | One University Plaza | Suite 507 | Hackensack | NJ | 07601 |
25333 | 25333 | 2018-07-31 | 2011-10-06 | Maxted | Tomi Mikael | Beckerman 5877 | 2008-08-14 | Beckerman | One University Plaza | Suite 507 | Hackensack | NJ | 07601 |
25342 | 25342 | 2018-07-31 | 2017-12-12 | Paul | Jordan | Beckerman 5877 | 2008-08-14 | Beckerman | One University Plaza | Suite 507 | Hackensack | NJ | 07601 |
25329 | 25329 | 2018-07-31 | 2017-08-28 | Jacobson | Seth | KARV Communications, Inc. 6162 | 2013-04-08 | KARV Communications, Inc. | 122 East 42nd Street | Suite 2005 | New York | NY | 10168 |
25332 | 25332 | 2018-07-31 | 2016-09-20 | Amundaray | Carla | S.G.R. LLC Government Relations and Lobbying 6379 | 2016-09-20 | S.G.R. LLC Government Relations and Lobbying | 1775 Eye Street, NW | Suite 410 | Washington | DC | 20006 |
25319 | 25319 | 2018-07-31 | 2017-05-10 | Lubin | Marcus | DLM Group, LLC 6428 | 2017-05-10 | DLM Group, LLC | 9616 Burke View Avenue | Burke | VA | 22015 | |
25310 | 25310 | 2018-07-31 | 2018-01-24 | Auriana | Lawrence | Filangiere Society for Justice and Good Government 6513 | 2018-01-24 | Filangiere Society for Justice and Good Government | 17 Battery Place | 11th Floor | New York | NY | 10004 |
25311 | 25311 | 2018-07-31 | 2018-02-02 | Ripley Lewis | Anna Churchill | Churchill Ripley, LLC 6519 | 2018-02-02 | Churchill Ripley, LLC | 2011 Federal Avenue | Los Angeles | CA | 90025 | |
25321 | 25321 | 2018-07-31 | 2019-05-29 | Cruz | Shileen | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 | |
25322 | 25322 | 2018-07-31 | 2019-05-29 | Klopfer | Courtney | Zeno Group, Inc. 6652 | 2019-03-18 | Zeno Group, Inc. | 130 East Randolph Street | Chicago | IL | 60601 |
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]) );