FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
13 rows where City = "Washington" and Registrant_Name = "Tew Cardenas, LLP" sorted by rowid descending
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date, Short_Form_Date, Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- DC 13
Registration_Number 1
Registrant_Name 1
- Tew Cardenas, LLP · 13 ✖
City 1
- Washington · 13 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25083 | 25083 | 2006-07-31 | 2006-02-14 | Amado | Ana Lissa | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
24574 | 24574 | 2004-07-30 | 2003-06-10 | Gould | Jay Eric | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
23133 | 23133 | 2006-07-14 | 2004-03-29 | Hays | Dennis K. | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
21583 | 21583 | 2006-06-30 | 2005-11-23 | Cerda | Victor X. | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
19711 | 19711 | 2006-06-16 | 2006-01-20 | Shigetomi | Kent C. | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
17200 | 17200 | 2006-05-26 | 2004-03-29 | Rappoport | Sloan | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
16451 | 16451 | 2008-05-15 | 2006-10-31 | Idler | Jose Enrique | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
15470 | 15470 | 2006-05-01 | 2005-03-23 | Durkin | Andrea Gash | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
8186 | 8186 | 2005-02-28 | 2003-07-23 | Navarro | Ana | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
5424 | 5424 | 2009-01-31 | 2005-11-23 | Noriega | Roger | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
5419 | 5419 | 2009-01-31 | 2003-06-10 | Cardenas | Alberto R. | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
5417 | 5417 | 2009-01-31 | 2008-02-11 | Brennan | Patrick Theodore | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
3139 | 3139 | 2006-01-03 | 2005-03-23 | Gonzalez | Emilio T. | Tew Cardenas, LLP 5562 | 2003-06-10 | Tew Cardenas, LLP | One Metro Center | 700 12th Street, N.W., Suite 1150 | Washington | DC | 20005 |
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]) );