FARA_All_ShortForms

List of all short form registrants (active and terminated)

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

49 rows where State = "LA"

✎ View and edit SQL

This data as json, atom, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Registration_Date, Address_1, Address_2, Zip, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

Registration_Number

State

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
2406 2406 1967-01-01 1963-02-13 Waltzer Bruce Charles 1513 1513 1962-01-22 Smith, Scheuermann & Jones 1006 Baronne Building 305 Baronne Street New Orleans LA 70112
3977 3977 1968-01-22 1965-04-02 Jones Alvin Basile 1513 1513 1962-01-22 Smith, Scheuermann & Jones 1006 Baronne Building 305 Baronne Street New Orleans LA 70112
3979 3979 1968-01-22 1965-07-27 Clear Taylor Edward 1513 1513 1962-01-22 Smith, Scheuermann & Jones 1006 Baronne Building 305 Baronne Street New Orleans LA 70112
3980 3980 1968-01-22 1965-07-27 Scheuermann Arthel Joan 1513 1513 1962-01-22 Smith, Scheuermann & Jones 1006 Baronne Building 305 Baronne Street New Orleans LA 70112
7391 7391 1983-02-28 1974-01-28 Tapia Enrique Vizzuett 1881 1881 1965-04-13 Mexican Government Tourism Office, New Orleans 1515 One Shell Square   New Orleans LA 70139
8007 8007 1957-03-01 1956-01-30 Corbin Barbara Anne Denckla 907 907 1955-09-01 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
8008 8008 1957-03-01 1956-01-30 Fellom Mario Jules 907 907 1955-09-01 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
8009 8009 1957-03-01 1956-01-30 Frith Elizabeth Fitz-Randolph 907 907 1955-09-01 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
8010 8010 1957-03-01 1956-01-30 Price Mary Margaret Walzem 907 907 1955-09-01 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
8013 8013 1957-03-01 1955-09-01 Wilson Scott Farrington 907 907 1955-09-01 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
8041 8041 1966-03-01 1965-06-20 Peebles Jack Cornelius 1513 1513 1962-01-22 Smith, Scheuermann & Jones 1006 Baronne Building 305 Baronne Street New Orleans LA 70112
8435 8435 1959-03-04 1958-11-03 Wright Allen Eli 1167 1167 1958-09-04 Smithhart, Clyde Geral 405-6 Pioneer Building   Lake Charles LA  
13372 13372 1982-04-29 1981-03-24 Guerra Modesto A. 3215 3215 1981-03-24 Guerra & Associates, Inc. 704 Marigny Street   New Orleans LA 70117
16072 16072 1993-05-28 1993-05-28 Dunn Floyd , Jr. 4811 4811 1993-05-28 Dunn, Floyd 300 Brown Street   Mooringsport LA 71060
16344 16344 1964-05-31 1964-07-07 Yana Yoshio 1768 1768 1964-07-07 Japan Trade Center, New Orleans 330 International Trade Mart 2 Canal Street New Orleans LA 70130
17182 17182 1993-06-01 1991-10-21 Feingerts Bruce L. 4577 4577 1991-10-21 Feingerts & Kelly, PLC 650 Poydras Street Suite 2750 New Orleans LA 70130-6161
17183 17183 1993-06-01 1991-10-21 Kelly Dennis E. 4577 4577 1991-10-21 Feingerts & Kelly, PLC 650 Poydras Street Suite 2750 New Orleans LA 70130-6161
18386 18386 1969-06-18 1966-08-24 Miyamoto Hidetoshi 1768 1768 1964-07-07 Japan Trade Center, New Orleans 330 International Trade Mart 2 Canal Street New Orleans LA 70130
19292 19292 1962-06-30 1962-01-04 McGuire Katherine Daly 1504 1504 1961-12-29 Ronny Caire Advertising Agency, Inc. 704 Cigali Building   New Orleans LA  
19293 19293 1962-06-30 1962-01-24 Leslie James Lon 1504 1504 1961-12-29 Ronny Caire Advertising Agency, Inc. 704 Cigali Building   New Orleans LA  
19296 19296 1962-06-30 1962-04-02 Caire Robert James 1504 1504 1961-12-29 Ronny Caire Advertising Agency, Inc. 704 Cigali Building   New Orleans LA  
19297 19297 1962-06-30 1962-04-19 Caire Heda Whann Williams 1504 1504 1961-12-29 Ronny Caire Advertising Agency, Inc. 704 Cigali Building   New Orleans LA  
20552 20552 1971-07-01 1971-04-19 Velazquez Carlos Hampe 1881 1881 1965-04-13 Mexican Government Tourism Office, New Orleans 1515 One Shell Square   New Orleans LA 70139
22124 22124 1968-07-22 1966-08-24 Maruo Takeshi 1768 1768 1964-07-07 Japan Trade Center, New Orleans 330 International Trade Mart 2 Canal Street New Orleans LA 70130
24974 24974 1960-08-16 1960-07-14 Bolanos Vilma 1377 1377 1960-07-14 Comite de Ayuda Pro Liberacion de Nicaragua Post Office Box 2432   New Orleans LA  
24975 24975 1960-08-16 1960-07-14 Cabrera Henry 1377 1377 1960-07-14 Comite de Ayuda Pro Liberacion de Nicaragua Post Office Box 2432   New Orleans LA  
25633 25633 1998-08-27 1998-01-13 Mireskandari Amir 5207 5207 1997-09-08 Lugano Group, Inc. 201 St. Charles Avenue Suite 2544 New Orleans LA 70170-2500
25634 25634 1998-08-27 1997-09-08 Doley Harold E. , III 5207 5207 1997-09-08 Lugano Group, Inc. 201 St. Charles Avenue Suite 2544 New Orleans LA 70170-2500
25813 25813 2004-08-29 2004-05-13 Doley Harold E. III., 5608 5608 2004-02-27 Lugano Group Incorporated 650 Poydras Street Suite 1400 New Orleans LA 70130-6116
25814 25814 2004-08-29 2004-05-13 Mireskandari Amir 5608 5608 2004-02-27 Lugano Group Incorporated 650 Poydras Street Suite 1400 New Orleans LA 70130-6116
26149 26149 1982-08-31 1973-03-27 Tapia Elva Licea 1881 1881 1965-04-13 Mexican Government Tourism Office, New Orleans 1515 One Shell Square   New Orleans LA 70139
26315 26315 1993-08-31 1993-01-14 Feingerts Bruce L. 4752 4752 1993-01-14 Ukrainian Technical Assistance Foundation 650 Poydras Street Suite 2750 New Orleans LA 70130
26316 26316 1993-08-31 1993-01-14 Kelly Dennis E. 4752 4752 1993-01-14 Ukrainian Technical Assistance Foundation 650 Poydras Street Suite 2750 New Orleans LA 70130
26706 26706 2015-08-31 2014-08-04 Creaghan James P. 6238 6238 2014-08-04 AUX Initiatives, LLC 6298 Seven Oaks Avenue   Baton Rouge LA 70806
26708 26708 2015-08-31 2014-08-18 Kiley Gregory Thomas 6238 6238 2014-08-04 AUX Initiatives, LLC 6298 Seven Oaks Avenue   Baton Rouge LA 70806
26709 26709 2015-08-31 2014-08-18 Meltz Gary Charles 6238 6238 2014-08-04 AUX Initiatives, LLC 6298 Seven Oaks Avenue   Baton Rouge LA 70806
26710 26710 2015-08-31 2014-08-18 Reilly Patricia A. 6238 6238 2014-08-04 AUX Initiatives, LLC 6298 Seven Oaks Avenue   Baton Rouge LA 70806
26711 26711 2015-08-31 2014-08-18 Shows Clifford Ronald 6238 6238 2014-08-04 AUX Initiatives, LLC 6298 Seven Oaks Avenue   Baton Rouge LA 70806
27503 27503 1965-09-09 1964-07-07 Nozaki Seigo 1768 1768 1964-07-07 Japan Trade Center, New Orleans 330 International Trade Mart 2 Canal Street New Orleans LA 70130
28919 28919 1980-09-30 1979-04-02 Chang Byung S. 3010 3010 1979-04-02 Korea Trade Center, New Orleans ITM Building 2 Canal Street, Suite 1605 New Orleans LA 70130
31113 31113 1969-10-21 1966-07-14 Seitinger Dr. Heinz K. 1986 1986 1966-07-14 Austrian Trade Delegate in the U.S., Southern Office 1410 International Trade Mart   New Orleans LA 70130
31114 31114 1969-10-21 1966-07-14 Waldschuetz Gerhard 1986 1986 1966-07-14 Austrian Trade Delegate in the U.S., Southern Office 1410 International Trade Mart   New Orleans LA 70130
31562 31562 1993-10-28 1993-01-14 LeBlanc Michele M. 4752 4752 1993-01-14 Ukrainian Technical Assistance Foundation 650 Poydras Street Suite 2750 New Orleans LA 70130
31964 31964 1973-10-31 1972-01-25 Shimizu Makoto 2309 2309 1972-01-25 Japan Trade Center, New Orleans 1447 International Trade Mart Building New Orleans LA 70130
31973 31973 1976-10-31 1974-03-25 Yoshida Takeshi 2309 2309 1972-01-25 Japan Trade Center, New Orleans 1447 International Trade Mart Building New Orleans LA 70130
34214 34214 1958-11-30 1958-06-23 Chapman Isaac D. 1152 1152 1958-06-23 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
34215 34215 1958-11-30 1958-06-23 Frith Elizabeth Fitz-Randolph 1152 1152 1958-06-23 Scott Wilson & Associates St. Charles Hotel Suite 338 New Orleans LA  
34817 34817 1966-12-01 1965-04-13 Legorreta Eduardo Noriega 1881 1881 1965-04-13 Mexican Government Tourism Office, New Orleans 1515 One Shell Square   New Orleans LA 70139
37742 37742 1984-12-31 1984-11-07 Chung Kui Lae 3010 3010 1979-04-02 Korea Trade Center, New Orleans ITM Building 2 Canal Street, Suite 1605 New Orleans LA 70130

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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)
);
Powered by Datasette · Query took 334.748ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history