home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for 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

25 rows where Registration_Number = 139

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_Last_Name, Short_Form_Termination_Date (date)

State 1

  • CA 25

Registration_Number 1

  • Comite Regional Sinarquista en Los Angeles · 25 ✖

Registrant_Name 1

  • Comite Regional Sinarquista en Los Angeles 25

City 1

  • Los Angeles 25
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
8599 8599 1946-03-01 1946-01-31 Jimenez Salvador A. Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9084 9084 1968-03-04 1944-01-31 Cabrera Martin Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9085 9085 1968-03-04 1946-01-31 Lara Manuel Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9086 9086 1968-03-04 1946-01-31 Rodriguez Ernesto Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9087 9087 1968-03-04 1955-02-15 Rivera Porfirio Ojeda Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9088 9088 1968-03-04 1946-03-12 Diaz Jose Sebastian Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9089 9089 1968-03-04 1946-03-13 Martinez Antonio Burciaga Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9090 9090 1968-03-04 1955-03-21 Ramirez Jose Alvarez Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9091 9091 1968-03-04 1946-03-27 Ortega Rodolfo M. Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9092 9092 1968-03-04 1946-04-01 Legaspi Miguel S. Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9093 9093 1968-03-04 1946-04-15 Rubio Eduardo Valverde Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9094 9094 1968-03-04 1946-06-06 Salce Miguel Perez Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9095 9095 1968-03-04 1946-06-06 Torres Ventura Aurencio Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9096 9096 1968-03-04 1946-06-14 Garcia Jose Hernandez Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9097 9097 1968-03-04 1946-06-14 Gomez Carlos Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9098 9098 1968-03-04 1946-06-14 Luevano Jose Guadalupe Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9099 9099 1968-03-04 1946-06-14 Velasco Refugio Luna Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9100 9100 1968-03-04 1946-06-28 Gomez Jose Maria Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9101 9101 1968-03-04 1946-06-28 Zamudio Eutimio Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9102 9102 1968-03-04 1956-08-20 Acevedo Jesus Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9103 9103 1968-03-04 1942-10-08 Alejo Jose R. Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9104 9104 1968-03-04 1942-10-08 Villasenor Pedro Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
9105 9105 1968-03-04 1942-10-08 de Luna Baltazar Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
15274 15274 1945-05-01 1942-10-08 Arroyo Jose Jesus Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  
15275 15275 1945-05-01 1942-10-08 Perez Benito Frausto Comite Regional Sinarquista en Los Angeles 139 1942-10-08 Comite Regional Sinarquista en Los Angeles 727 Camulos Street   Los Angeles CA  

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 · Queries took 714.966ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
  • Sort ascending
  • Sort descending
  • Facet by this
  • Hide this column
  • Show all columns
  • Show not-blank rows