FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
118 rows where City = "Washington" and Registrant_Name = "Covington & Burling" sorted by Registration_Date
This data as json, CSV (advanced)
Registration_Number 3
Registration_Date (date) 3 ✖
- 2002-04-01 8
- 1993-05-26 7
- 1948-04-16 3
State 1
- DC 18
Registrant_Name 1
- Covington & Burling · 18 ✖
City 1
- Washington · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37265 | 37265 | 1964-12-01 | 1961-10-11 | Ball | Robert Markham | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
39793 | 39793 | 1965-12-31 | 1964-11-17 | Rohrbaugh | Stephen Bunker | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
39855 | 39855 | 1967-12-31 | 1966-05-13 | Bentzen | Michael Porter | Covington & Burling 523 | 1948-04-16 | Covington & Burling | 888 - 16th Street, N.W. | Washington | DC | 20006 | |
21204 | 21204 | 1994-06-30 | 1993-07-21 | Hamilton | Deanna J. | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
21207 | 21207 | 1994-06-30 | 1993-09-14 | Jacobsen | Mark Paul | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
38938 | 38938 | 1993-12-22 | 1993-07-15 | Yeo | Matthew S. | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
39263 | 39263 | 1994-12-28 | 1993-05-26 | Snipes | James Carpenter | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
39264 | 39264 | 1994-12-28 | 1993-06-02 | Kirby | John David | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
39265 | 39265 | 1994-12-28 | 1993-07-21 | Medish | Mark C. | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
39266 | 39266 | 1994-12-28 | 1993-08-11 | Hartwell | Olga | Covington & Burling 4807 | 1993-05-26 | Covington & Burling | Post Office Box 7566 | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20044 |
14887 | 14887 | 2003-04-30 | 2003-02-25 | Barker | Laura Anita | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14888 | 14888 | 2003-04-30 | 2003-02-25 | Becker | Barbara Jessie | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14889 | 14889 | 2003-04-30 | 2003-02-25 | DeArment | Roderick A. | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14890 | 14890 | 2003-04-30 | 2003-02-25 | Feldman | Mark E. | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14891 | 14891 | 2003-04-30 | 2002-04-01 | Eizenstat | Stuart E. | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14892 | 14892 | 2003-04-30 | 2002-04-01 | Marchick | David M. | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14893 | 14893 | 2003-04-30 | 2002-04-08 | Davis | Emily | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 | |
14894 | 14894 | 2003-04-30 | 2002-04-08 | Flanagan | Peter L. | Covington & Burling 5489 | 2002-04-01 | Covington & Burling | 1201 Pennsylvania Avenue, N.W. | Washington | DC | 20004-2401 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );