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

31 rows where Registration_Number = 3819

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • IL 31

Registration_Number 1

  • Welsh Development Agency · 31 ✖

Registrant_Name 1

  • Welsh Development Agency 31

City 1

  • Chicago 31
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
6831 6831 1994-02-14 1990-11-15 Davies Brian Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11969 11969 2006-03-31 2004-04-09 Wallace Cari Anne Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11971 11971 2006-03-31 2002-04-29 Balcon Cecile Marie Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11972 11972 2006-03-31 2002-04-29 Brace Catrin Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11973 11973 2006-03-31 2002-04-29 Herring Sue Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11974 11974 2006-03-31 2002-04-29 Reynish Anne Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11993 11993 2006-03-31 2002-10-15 O'Keefe Anthony Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11994 11994 2006-03-31 2002-10-15 Banning Chris Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11995 11995 2006-03-31 2002-10-15 Carlyon Kathleen Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11996 11996 2006-03-31 2002-10-15 Hiscox Mel Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11997 11997 2006-03-31 2002-10-15 Rowell Charles Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11998 11998 2006-03-31 2005-10-21 Sethi Shayra Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
11999 11999 2006-03-31 2003-10-22 Dennis Cheryl Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
12521 12521 2004-04-01 2000-07-20 Mulder Vaughn Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
14853 14853 2001-04-30 2000-07-20 Zalud James A. Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
14875 14875 2002-04-30 2000-07-20 Lonergan Colette Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
14876 14876 2002-04-30 2000-07-20 Sheehan Christopher John Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
17085 17085 1994-05-25 1989-10-30 Still Paul Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
19688 19688 2000-06-16 1992-01-31 Simpson Robert Ivor Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
19689 19689 2000-06-16 1992-01-31 Singleton Claire T. Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
19690 19690 2000-06-16 1994-04-22 Evans David Morris Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
19693 19693 2000-06-16 1993-12-13 Rowlands Peter Robert Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
21115 21115 1989-06-30 1989-03-09 Francis Colin E. Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
21166 21166 1991-06-30 1990-10-18 Bogage Barry Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
28393 28393 2001-08-31 2000-07-20 Simcox J.A. Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
31304 31304 2002-09-30 2001-10-09 Wright Paul Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
32782 32782 2005-10-14 2005-10-21 Donegan Thomas S. Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
35626 35626 2005-11-11 2002-04-29 Sadler Mark Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
36757 36757 1993-11-30 1994-02-14 Sheehan Chriostopher John Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
36925 36925 2004-11-30 2000-07-20 James Carol Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606
41235 41235 2001-12-31 2000-07-20 Lohrer Jane Welsh Development Agency 3819 1986-04-24 Welsh Development Agency 191 North Wacker Drive Suite 1685 Chicago IL 60606

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 1422.148ms · 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