home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_Registrants

Table actions
  • GraphQL API for FARA_All_Registrants
List of all registrant data (active and terminated)

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

2,405 rows where City = "Washington"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date (date), Termination_Date (date)

Address_1 >30

  • 1575 I Street, N.W. 15
  • 1706 - 18th Street, N.W. 15
  • 1747 Pennsylvania Avenue, N.W. 15
  • 1001 Pennsylvania Avenue, N.W. 13
  • 1701 Pennsylvania Avenue, N.W. 13
  • 2550 M Street, N.W. 13
  • 1001 Connecticut Avenue, N.W. 12
  • 1025 Connecticut Avenue, N.W. 12
  • 1800 K Street, N.W. 12
  • 600 New Hampshire Avenue, N.W. 12
  • 815 Connecticut Avenue, N.W. 12
  • 1333 New Hampshire Avenue, NW 11
  • 818 Connecticut Avenue, N.W. 11
  • 1150 Connecticut Avenue, N.W. 10
  • 1629 K Street, N.W. 10
  • 1700 Pennsylvania Avenue, N.W. 10
  • 1730 Pennsylvania Avenue, N.W. 10
  • 655 - 15th Street, N.W. 10
  • 801 Pennsylvania Avenue, N.W. 10
  • 1000 Connecticut Avenue, N.W. 9
  • 1050 Connecticut Avenue, N.W. 9
  • 1100 Connecticut Avenue, N.W. 9
  • 1330 Connecticut Avenue, N.W. 9
  • 1776 K Street, N.W. 9
  • 499 South Capitol Street, S.W. 9
  • Embassy of Japan 9
  • 1629 K Street, NW 8
  • 1700 K Street, N.W. 8
  • 1919 Pennsylvania Avenue, N.W. 8
  • 910 - 17th Street, N.W. 8
  • …

State 2

  • DC 2,404
  • NY 1

City 1

  • Washington · 2,405 ✖
Registration_Number ▼ Registration_Date Termination_Date Name Business_Name Address_1 Address_2 City State Zip
23 1942-07-09 1946-07-09 Haan, Kilsoo Kenneth   101 D Street, N.E.   Washington DC  
26 1942-07-09 1942-07-09 Chang, Kee Young   1766 Hobart Street, N.W.   Washington DC  
27 1942-07-09 1950-07-09 LeRoy & Denslow   530 Washington Building   Washington DC xxxxx
44 1942-07-13 1943-04-01 Ploechl, Willibald Maria   1915 Kalorama Road, N.W.   Washington DC  
52 1942-07-16 1946-06-15 Glesinger, Egon   3816 - 49th Street, N.W.   Washington DC  
63 1942-07-27 1943-07-27 Chung, Woonsoo   1766 Hobart Street, N.W.   Washington DC  
102 1942-08-20 1949-08-20 Lu, David   National Press Building Room 1151 Washington DC  
125 1942-09-18 1943-03-18 Ekis, Ludvigs   4704 - 17th Street, N.E.   Washington DC 20005
132 1942-09-24 1943-10-24 LeRoy & Denslow   412-418 Colorado Building   Washington DC xxxxx
136 1942-10-07 1942-10-07 De Longfief, Henri Villieras   National Press Building   Washington DC  
137 1942-10-07 1942-10-07 Sweinhart, Henry L.   1374 National Press Building   Washington DC  
138 1942-10-10 1943-05-31 Austin, Clyde   1706 K Street, N.W.   Washington DC  
144 1942-10-19 1946-04-19 Shands, Richard E.   Shoreham Building   Washington DC  
153 1942-11-05 1942-11-05 Minor, Gatley & Drury   312 Colorado Building 1341 G Street, N.W. Washington DC  
155 1942-11-13 1948-11-15 Korean Commission   1766 Hobart Street, N.W.   Washington DC  
161 1942-12-07 1946-12-07 Korean-American Council   1700 I Street, N.W.   Washington DC  
168 1943-01-01 1944-12-31 Aladren, Jose M.   Hotel Lafayette   Washington DC  
189 1943-04-23 1945-12-31 United Korean Committee in America   1719 K Street, N.W.   Washington DC  
205 1943-08-27 1945-02-17 Riddick, Floyd M.   U.S. Chamber of Commerce   Washington DC 20005
226 1943-12-18 1945-06-18 Kolonia, Peter V.   1530 - 16th Street, N.W.   Washington DC  
230 1944-01-29 1944-01-29 De Lozada, Enrique S.   Bolivian Embassy Investment Building (1119) Washington DC  
233 1944-02-07 1944-03-03 Chinel, Fernando Iturralde   Invest. Bldg./Bolivian Embassy 15th & K Streets, Room 1119 Washington DC  
237 1944-02-29 1950-05-05 Ryan, Edwin   Catholic University of America Washington DC  
243 1944-03-31 1945-03-31 Grimes, Warren Whyte   640 Shoreham Building   Washington DC  
251 1944-05-04 1944-11-04 Korean Affairs Institute, Inc.   1029 Vermont Avenue, N.W.   Washington DC  
268 1944-06-24 1944-11-30 Nathan, Robert R.   1731 K Street, N.W.   Washington DC  
285 1944-12-07 1944-12-07 Frampton, Merle Elbert   2222 I Street, N.W.   Washington DC  
290 1945-02-16 1946-02-16 Law Office of George E. Tolman   607 Mills Building   Washington DC  
293 1945-02-26 1945-12-31 Aladren del Perojo, Jose Maria   Burlington Hotel Vermont Avenue, N.W. Washington DC  
298 1945-03-27 1945-03-27 Casares Sanchez, Manuel   1862 Ingleside Terrace, N.W.   Washington DC  
302 1945-04-18 1946-04-18 Fotitch, Constantin A.   3001 Albemarle Street, N.W.   Washington DC  
322 1945-09-21 1945-09-21 Arab Office   Wardman Park Hotel Suite 400E Washington DC  
325 1945-10-15 1946-10-15 Menefee, Selden C.   1121 Vermont Avenue, N.W.   Washington DC  
333 1945-12-20 1947-03-27 Burling, Edward B.   701 Union Trust Building   Washington DC  
334 1945-12-27 1949-06-27 Meana, Juan A.   3323 Dent Place, N.W.   Washington DC  
340 1946-01-25 1946-07-25 Gordon, John W.   1621 K Street, N.W.   Washington DC  
341 1946-01-28 1952-07-28 Cox, Oscar S.   1210 - 18th Street, N.W.   Washington DC  
345 1946-02-25 1960-02-25 Gass, Oscar   1029 Vermont Avenue, N.W.   Washington DC  
349 1946-03-27 1947-03-15 Choukanoff, Boyan Petkoff   Shoreham Hotel 2500 Calvert Street, N.W. Washington DC  
352 1946-04-22 1982-05-13 Robert R. Nathan Associates, Inc.   3 Thomas Circle   Washington DC 20530
355 1946-04-26 1946-10-04 Rauh, Joseph L. Jr.,   1820 Jefferson Place, NW   Washington DC 20005
356 1946-05-07 1950-11-20 Lynch, Mary Katherine   3031 Gates Road, N.W.   Washington DC  
357 1946-05-09 1946-07-15 Szabad, George Michael   21 Kennedy Street, N.W.   Washington DC  
372 1946-09-26 1973-01-31 Polish Press Agency, Washington, D.C. Polska Agencja Prasowa 928 National Press Building   Washington DC 20004
377 1946-10-14 1947-02-05 Pehle, John William   1707 I Street, N.W.   Washington DC  
380 1946-10-16 1946-10-16 Fiala, Frantisek (Father)   C/O Czechoslovak Embassy 2349 Massachusetts Avenue, NW Washington DC  
385 1946-10-22 1947-02-28 Meyer, Bernard Stern   39 Broadway Suite 1002 Washington DC  
394 1946-11-19 2003-06-30 Australian Broadcasting Corporation   529 14th Street, N.W. Suite 510 Washington DC 20045
397 1946-11-19 1947-08-16 John G. Laylin & Edward B. Burling   701 Union Trust Building   Washington DC  
415 1946-12-19 1946-12-19 Bourguiba, Habib   Arab Office Wardman Park Hotel Washington DC  
420 1947-01-09 1960-11-01 Cummings, Sellers, Reeves & Conner   1616 K Street, N.W.   Washington DC  
421 1947-01-10 1950-06-19 Culbertson, William S.   Stoneleigh Court 1025 Connecticut Avenue, N.W. Washington DC  
425 1947-01-10 1960-09-19 Casares Sanchez, Manuel   6107 Broad Branch Road   Washington DC  
435 1947-02-05 1948-02-05 Lever, Michael   1841 Columbia Road, N.W.   Washington DC  
439 1947-02-17 1967-03-07 Pehle, Riemer, Luxford & Naiden   1210 - 18th Street, N.W.   Washington DC 20036
442 1947-02-26 1947-08-26 John Lord O'Brian & John G. Laylin   701 Union Trust Building   Washington DC  
452 1947-04-10 1947-12-31 Aguado, Enoc   1620 - 16th Street, N.W.   Washington DC 20009
453 1947-04-10 1948-10-10 Sacasa, Fernando F.   1620 - 16th Street, N.W.   Washington DC  
467 1947-06-06 1948-04-01 Committee For Unity Of The Nile Valley   612 Albee Building   Washington DC  
468 1947-06-06 1947-06-06 Marcos, Ferdinand E.   3720 Northhampton Street, N.W.   Washington DC  
476 1947-07-07 1950-01-07 Dimitrov, Gueorgi Mihov   724 - 9th Street, N.W. Suite 624 Washington DC  
478 1947-07-14 1948-01-14 Strong, George Eugene   226 Woodward Building   Washington DC 20005
490 1947-09-24 1958-09-24 Alk, Isadore G.   1026 Woodward Building   Washington DC  
491 1947-10-03 1948-10-03 Bolton & Lucas   1028 Connecticut Avenue, N.W.   Washington DC  
496 1948-04-17 1949-07-15 Macek, Vladko   2552 University Place, N.W.   Washington DC  
497 1947-10-16 1948-01-31 Munson, Lyle Hugh   2132 Wyoming Avenue, N.W.   Washington DC  
500 1947-11-14 1958-11-14 Rips, Serge   1025 Woodward Building   Washington DC  
508 1948-01-19 2012-12-31 Cleary, Gottlieb, Steen & Hamilton, LLP   2000 Pennsylvania Avenue, NW   Washington DC 20006-1801
514 1948-02-25 1967-02-01 British Broadcasting Corporation   C.B.S. Building 2020 M Street, N.W. Washington DC 20036
517 1948-03-15 1948-03-15 Ginsburg & Leventhal   1147 Connecticut Avenue, N.W.   Washington DC  
521 1948-04-09 1949-03-31 Goodwin, William J.   528 Union Trust Building   Washington DC  
523 1948-04-16 1977-11-16 Covington & Burling   888 - 16th Street, N.W.   Washington DC 20006
524 1948-04-16 1949-02-03 Fahy, Charles   1625 K Street, N.W.   Washington DC  
525 1948-05-10 1948-06-15 Munson, Lyle Hugh   1426 - 35th Street, N.W.   Washington DC  
532 1948-07-07 1950-01-07 Fleming, John William   1026 Continental Building 1511 K Street, N.W. Washington DC  
534 1948-08-04 1963-08-04 Borkin, Joseph   802 Ring Building   Washington DC  
540 1948-09-16 1970-03-16 Ginsburg, Feldman & Bress   914 Ring Building   Washington DC  
555 1949-01-13 1949-07-13 Buzesti, Grigore Niculescu   3307 Woodley Road   Washington DC  
556 1949-01-24 1953-01-31 Oliver, Robert T.   1620 I Street, N.W.   Washington DC  
562 1949-02-11 1964-08-11 Clark, Charles Patrick   Dupont Circle Building 1346 Connecticut Avenue #1115 Washington DC  
566 1949-03-08 1949-03-08 Krupavicius, Mykolas   C/O Lithuanian Legation 2622 - 16th Street, N.W. Washington DC  
567 1949-03-08 1949-03-08 Sidzikauskas, Vaclovas   C/O Lithuanian Legation 2622 - 16th Street, N.W. Washington DC  
569 1949-05-09 1950-11-09 Garza, Lorenzo (Melon)   Chastleton Hotel 1701 - 16th Street, N.W. Washington DC  
571 1949-05-16 1949-06-24 Richardson, Frank D.   Suite 902-904 815 Fifteenth Street, NW Washington DC 20005
580 1949-07-11 1950-04-10 Goodwin, William J.   528 Union Trust Building   Washington DC  
581 1949-07-12 1950-01-12 D&F All Americas Investors, Inc. Virgin Islands Legislative & Welfare Committee 631 Pennsylvania Avenue, N.W.   Washington DC  
584 1949-07-15 1951-07-01 McInerny, Timothy A.   2020 R Street, N.W.   Washington DC  
585 1949-07-28 1951-08-28 Davies, Richberg, Tydings, Beebe & Landa   1000 Vermont Avenue, N.W.   Washington DC  
594 1949-10-28 1951-02-01 Lathrom & Jenkins   541 Washington Building   Washington DC  
597 1949-11-10 1991-05-15 Henley, Lillian   1706 - 18th Street, N.W.   Washington DC 20009
611 1950-02-03 1950-02-03 American Engineering Export Corporation   1737 H Street, N.W.   Washington DC  
613 1950-02-17 1953-02-17 Sessions, Gordon Morrison   777 - 14th Street, N.W.   Washington DC  
617 1950-03-07 1950-03-07 Gantt, Paul H.   4435 - 29th Street, N.W.   Washington DC  
621 1950-03-29 1973-05-04 Central News Agency of China, Washington Bureau   549 National Press Building   Washington DC 20004
626 1950-06-05 1950-10-01 Banda, Francisco C.   3716 Ingomar Street, N.W.   Washington DC  
632 1950-07-20 1950-10-10 Onishi, Charles Y.   3 Dupont Circle   Washington DC  
635 1950-07-26 1962-07-26 Sokitch, Miloye   2500 Q Street, N.W.   Washington DC  
637 1950-08-10 1962-08-10 Culbertson, Pendleton & Pendleton   1025 Connecticut Avenue, N.W.   Washington DC  
638 1950-08-16 1953-08-16 National Lecture Management, Inc.   714 Dupont Cirle Building Suite 928 Washington DC  
641 1950-09-20 1966-02-18 Kreisinger, Robert   1706 - 18th Street, N.W.   Washington DC 20009

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [FARA_All_Registrants] (
   [Registration_Number] INTEGER PRIMARY KEY,
   [Registration_Date] TEXT,
   [Termination_Date] TEXT,
   [Name] TEXT,
   [Business_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 40.681ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history