FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
22 rows where Short_Form_Termination_Date = "2022-07-31"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_First_Name, Address_1, Zip, Short_Form_Date (date)
Registration_Number 9
- Ice Miller LLP 5
- Counterpoint Strategies LTD 5
- Cornerstone Government Affairs 4
- New Heights Communications LLC 3
- IDA Ireland 1
- Tourism Authority of Thailand, Los Angeles 1
- Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 1
- Ice Miller Strategies LLC 1
- Ethos Foundation (DBA - Bharati Foundation) 1
Registrant_Name 9
- Counterpoint Strategies LTD 5
- Ice Miller LLP 5
- Cornerstone Government Affairs 4
- New Heights Communications LLC 3
- Ethos Foundation (DBA - Bharati Foundation) 1
- IDA Ireland 1
- Ice Miller Strategies LLC 1
- Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 1
- Tourism Authority of Thailand, Los Angeles 1
City 6
- Washington 8
- New York 6
- Indianapolis 5
- Arlington 1
- Frisco 1
- Los Angeles 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25403 | 25403 | 2022-07-31 | 2022-03-08 | Chanen | Jill Schachner | Ice Miller LLP 7092 | 2022-03-08 | Ice Miller LLP | One American Square | Suite 2900 | Indianapolis | IN | 46282 |
25404 | 25404 | 2022-07-31 | 2022-03-08 | Christensen | Guillermo S. | Ice Miller LLP 7092 | 2022-03-08 | Ice Miller LLP | One American Square | Suite 2900 | Indianapolis | IN | 46282 |
25405 | 25405 | 2022-07-31 | 2022-03-08 | Day | Timothy M. | Ice Miller LLP 7092 | 2022-03-08 | Ice Miller LLP | One American Square | Suite 2900 | Indianapolis | IN | 46282 |
25406 | 25406 | 2022-07-31 | 2022-03-08 | Loadholt | Jarrod | Ice Miller LLP 7092 | 2022-03-08 | Ice Miller LLP | One American Square | Suite 2900 | Indianapolis | IN | 46282 |
25407 | 25407 | 2022-07-31 | 2022-03-08 | Stackhouse | Dale | Ice Miller LLP 7092 | 2022-03-08 | Ice Miller LLP | One American Square | Suite 2900 | Indianapolis | IN | 46282 |
25408 | 25408 | 2022-07-31 | 2022-05-05 | Foster | Daniel Richard | Counterpoint Strategies LTD 7113 | 2022-05-05 | Counterpoint Strategies LTD | C/O Buchbinder Tunick & Company LLP | One Penn Plaza, Suite 3200 | New York | NY | 10119 |
25409 | 25409 | 2022-07-31 | 2022-05-05 | Glaze | Chris Michael | Counterpoint Strategies LTD 7113 | 2022-05-05 | Counterpoint Strategies LTD | C/O Buchbinder Tunick & Company LLP | One Penn Plaza, Suite 3200 | New York | NY | 10119 |
25410 | 25410 | 2022-07-31 | 2022-05-05 | Hammond | Robert Crouse | Counterpoint Strategies LTD 7113 | 2022-05-05 | Counterpoint Strategies LTD | C/O Buchbinder Tunick & Company LLP | One Penn Plaza, Suite 3200 | New York | NY | 10119 |
25411 | 25411 | 2022-07-31 | 2022-05-05 | Hayes | Justin Braden | Counterpoint Strategies LTD 7113 | 2022-05-05 | Counterpoint Strategies LTD | C/O Buchbinder Tunick & Company LLP | One Penn Plaza, Suite 3200 | New York | NY | 10119 |
25412 | 25412 | 2022-07-31 | 2022-05-05 | McCarthy | James Andrew | Counterpoint Strategies LTD 7113 | 2022-05-05 | Counterpoint Strategies LTD | C/O Buchbinder Tunick & Company LLP | One Penn Plaza, Suite 3200 | New York | NY | 10119 |
25413 | 25413 | 2022-07-31 | 2007-06-01 | Hayes | Paraic | IDA Ireland 1770 | 1964-07-10 | IDA Ireland | 345 Park Avenue | 17th Floor | New York | NY | 10154 |
25414 | 25414 | 2022-07-31 | 2020-06-04 | McCord | Morgan | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 |
25415 | 25415 | 2022-07-31 | 2013-07-26 | Sukthavorn | Proud | Tourism Authority of Thailand, Los Angeles 2178 | 1969-12-19 | Tourism Authority of Thailand, Los Angeles | 611 North Larchmont Boulevard | 1st Floor | Los Angeles | CA | 90004 |
25416 | 25416 | 2022-07-31 | 2022-07-30 | Reddy | Sreekanth | Ethos Foundation (DBA - Bharati Foundation) 7149 | 2022-07-30 | Ethos Foundation (DBA - Bharati Foundation) | 13759 Boyle LN | Frisco | TX | 75035 | |
25417 | 25417 | 2022-07-31 | 2017-08-10 | Barton | Joseph | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 |
25418 | 25418 | 2022-07-31 | 2022-08-22 | Zhao | Jianying | Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) 6113 | 2012-07-06 | Representative Office in the USA, China Council for the Promotion of International Trade (CCPIT) | 2001 Jefferson Davis Highway | Suite 608 | Arlington | VA | 22202 |
25419 | 25419 | 2022-07-31 | 2017-08-31 | Kaufman | Campbell | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 |
25420 | 25420 | 2022-07-31 | 2021-09-01 | Christensen | Guillermo S. | Ice Miller Strategies LLC 7005 | 2021-09-01 | Ice Miller Strategies LLC | 200 Massachusetts Avenue, NW | Suite 400 | Washington | DC | 20001 |
25421 | 25421 | 2022-07-31 | 2021-11-04 | Moor | Ian | New Heights Communications LLC 7035 | 2021-11-04 | New Heights Communications LLC | 6632 32nd Street, NW | Washington | DC | 20015 | |
25422 | 25422 | 2022-07-31 | 2021-11-04 | Setzer | Christy | New Heights Communications LLC 7035 | 2021-11-04 | New Heights Communications LLC | 6632 32nd Street, NW | Washington | DC | 20015 | |
25423 | 25423 | 2022-07-31 | 2021-11-04 | Stanley | Alexis | New Heights Communications LLC 7035 | 2021-11-04 | New Heights Communications LLC | 6632 32nd Street, NW | Washington | DC | 20015 | |
25424 | 25424 | 2022-07-31 | 2020-11-11 | Hubert | Martin | Cornerstone Government Affairs 6401 | 2017-01-20 | Cornerstone Government Affairs | 800 Maine Avenue, SW | Floor 7 | Washington | DC | 20024 |
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]) );