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

36 rows where Registration_Number = 1051

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

State 1

  • DC 36

Registration_Number 1

  • Galland, Kharasch, Calkins & Short, P.C. · 36 ✖

Registrant_Name 1

  • Galland, Kharasch, Calkins & Short, P.C. 36

City 1

  • Washington 36
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
2583 2583 1979-01-01 1957-07-09 Galland George Freeman Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
2592 2592 1981-01-01 1973-05-10 Calkins G. Nathan Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6374 6374 1983-02-08 1961-01-13 Kharasch Robert Nelson Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6375 6375 1983-02-08 1977-02-08 Johnson Thomas A. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6376 6376 1983-02-08 1977-02-08 Lewis Jean H. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6377 6377 1983-02-08 1981-02-20 Short David E. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6378 6378 1983-02-08 1979-02-22 Friedlander Charles Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6379 6379 1983-02-08 1979-02-22 Gluck Richard D. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6380 6380 1983-02-08 1979-02-22 Greenberg Edward D. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6381 6381 1983-02-08 1979-02-22 Mahon Kathleen Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6382 6382 1983-02-08 1974-02-25 Garfinkle Morris Richard Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6383 6383 1983-02-08 1973-05-10 Bernstein Arthur D. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6384 6384 1983-02-08 1973-05-10 Boikess Olga Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6385 6385 1983-02-08 1973-05-10 Karas William Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6386 6386 1983-02-08 1983-05-10 Avery Rosemary Boyd Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6387 6387 1983-02-08 1968-05-23 Short Laurence A. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6390 6390 1983-02-08 1957-07-09 Calkins Gary Nathan , Jr. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6391 6391 1983-02-08 1963-07-17 Scupi Amy Ross Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6392 6392 1983-02-08 1979-08-23 Farmer Donald A. , Jr. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6393 6393 1983-02-08 1980-08-26 Migdail Rhonda Gloria Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6394 6394 1983-02-08 1977-09-09 Andrews Dale Carter Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6395 6395 1983-02-08 1977-09-09 Street David Prince Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6396 6396 1983-02-08 1978-09-12 Matthews Suzette Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6397 6397 1983-02-08 1981-09-18 Denny Marc F. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6398 6398 1983-02-08 1981-09-18 Rubin Steven M. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6399 6399 1983-02-08 1981-09-18 Tsaknis Mayda Colon Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6400 6400 1983-02-08 1981-09-18 Weiss Alan Michael Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6401 6401 1983-02-08 1972-09-26 McGeorge Robert L. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6402 6402 1983-02-08 1979-10-24 Gilligan Thomas Scott Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
6403 6403 1983-02-08 1979-10-24 Kastner Kenneth Mark Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
8722 8722 1977-03-01 1975-07-18 Castelbuono Anthony C. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
8723 8723 1977-03-01 1975-08-15 Brown David S. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
15919 15919 1981-05-08 1979-10-24 Dryer David E. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
16509 16509 1981-05-16 1979-10-24 Ulmer Nicholas Courtland Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
39864 39864 1969-12-31 1963-01-30 Lippman William Joseph Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007
40010 40010 1976-12-31 1975-07-10 Clearwaters Keith I. Galland, Kharasch, Calkins & Short, P.C. 1051 1957-07-09 Galland, Kharasch, Calkins & Short, P.C. 1054 - 31st Street, N.W.   Washington DC 20007

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