FARA_All_ShortForms

Table actions
List of all short form registrants (active and terminated)

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

15 rows where City = "San Francisco" and Registrant_Name = "Earthjustice"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Short_Form_Termination_Date, Short_Form_First_Name, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)

State 1

Registration_Number 1

Registrant_Name 1

  • Earthjustice · 15 ✖

City 1

  • San Francisco · 15 ✖
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
7264 7264 2020-02-19 2019-09-24 Coleman Daveon Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
9669 9669 2020-03-11 2019-09-20 Tauber Jill Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
14118 14118 2022-04-25 2019-09-24 Wagner Martin Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
14119 14119 2022-04-25 2021-09-24 Manupipatpong Methawee Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
16856 16856 2021-05-21 2019-09-24 Dillen Abigail Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
17205 17205 2020-05-26 2019-09-20 Arnoldy Ben Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
31680 31680 2019-09-30 2019-09-24 Fitzgerald Erin Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
31681 31681 2019-09-30 2019-09-24 Trotter Elizabeth Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
32645 32645 2021-10-11 2019-09-20 Pejan Ramin Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
33222 33222 2020-10-19 2019-09-20 Patriana Zarah Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
33223 33223 2020-10-19 2019-09-20 Sivaraman Bala Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
33224 33224 2020-10-19 2019-09-20 Zniber Siham Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
33225 33225 2020-10-19 2019-09-24 Brenner Sarah Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
33226 33226 2020-10-19 2019-09-25 Fitzsimmons Jill Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111
35673 35673 2020-11-12 2019-09-20 Brauer Gabe Earthjustice 6725 2019-09-20 Earthjustice 50 California Street Suite 500 San Francisco CA 94111

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])
);