List of all registrant data (active and terminated)

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

2,362 rows where State = "DC" sorted by Address_2

View and edit SQL

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

State

  • DC · 2,362
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  
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  
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  
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  
259 1944-06-05 1945-06-05 Sakellariou, Alexander E.   1208 Crittenden Street, N.W.   Washingtonq 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  
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  
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  
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  
397 1946-11-19 1947-08-16 John G. Laylin & Edward B. Burling   701 Union Trust Building   Washington DC  
420 1947-01-09 1960-11-01 Cummings, Sellers, Reeves & Conner   1616 K Street, 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  
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
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  
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  
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  
641 1950-09-20 1966-02-18 Kreisinger, Robert   1706 - 18th Street, N.W.   Washington DC 20009
648 1950-11-08 1952-11-05 Egyptian Information Bureau   2300 Decatur Place, N.W.   Washington DC  
655 1951-01-12 1953-01-12 Clark, Clifford M.   1523 L Street, N.W.   Washington DC  
656 1951-01-16 1952-03-31 Resnikoff, Reuben   2112 Massachusetts Avenue, NW   Washington DC 20005
657 1951-01-25 1973-02-01 National Committee for Liberation of Slovakia   1065 National Press Building   Washington DC 20004
660 1951-02-20 1953-02-20 Barnes, James M.   1025 Connecticut Avenue   Washington DC  
685 1951-10-01 1951-10-31 Sperling, Mae Irene   2112 Massachusetts Avenue, NW   Washington DC  
691 1951-10-31 1952-10-30 Sherman, Alexander   1612 Wisconsin Avenue, N.W.   Washington DC  
693 1951-11-14 1952-11-14 Pope, Lillian Marcella   2112 Massachusetts Avenue, NW   Washington DC  
694 1951-11-14 1962-11-20 Einhorn, Nathan   2640 - 16th Street, N.W.   Washington DC  
696 1951-11-20 1961-11-25 Lamberton, Harry C.   1908 Q Street, N.W.   Washington DC  
699 1951-12-03 1953-07-15 Smith, Alan Dexter   2514 Massachusetts Avenue, NW   Washington DC  
708 1952-01-16 1952-07-16 Jerome Jacobson Associates   3 Thomas Circle, N.W.   Washington DC  
715 1952-02-20 1952-12-08 Brockman Jr., Earle Wingo   2112 Massachusetts Avenue, NW   Washington DC  
716 1952-02-20 1952-08-22 Brockman, Marjorie M.   2112 Massachusetts Avenue, NW   Washington DC  
718 1952-02-26 1957-02-26 Schaler, Butler & Associates   1028 Connecticut Avenue, N.W.   Washington DC  
726 1952-05-26 1952-05-26 Haitian Dessalines Western Hemisphere Trade Corporation   1420 New York Avenue, N.W.   Washington DC  
728 1952-05-28 1957-05-28 Arnold, Fortas & Porter   1200 - 18th Street, N.W.   Washington DC  
730 1952-06-18 1952-12-18 Krock-Erwin Associates, Inc.   1406 G Street, N.W.   Washington DC  
731 1952-06-23 1952-09-01 Mardo, Bill   2112 Massachusetts Avenue, NW   Washington DC  
744 1952-11-04 1952-11-04 Bolles, Edmund Blair   1909 I Street, N.W.   Washington DC  
748 1952-12-17 1961-02-09 Davies, Richberg, Tydings, Landa & Duff   1000 Vermont Avenue, N.W.   Washington DC  

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