FARA_All_RegistrantDocs
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where Document_Type = "Short-Form" and Registrant_Name = "KING & SPALDING"
This data as json, CSV (advanced)
Registrant_Name 1
- KING & SPALDING · 21 ✖
Foreign_Principal_Name 1
- - 21
Foreign_Principal_Country 1
- - 21
Document_Type 1
- Short-Form · 21 ✖
Link | rowid ▼ | Date_Stamped | Registrant_Name | Registration_Number | Document_Type | Short_Form_Name | Foreign_Principal_Name | Foreign_Principal_Country | URL |
---|---|---|---|---|---|---|---|---|---|
26119 | 26119 | 1991-03-08 | KING & SPALDING | King & Spalding 4352 | Short-Form | JAMES H. LOKEY, JR. | Available-FARA-Public-Office | ||
26120 | 26120 | 1991-03-08 | KING & SPALDING | King & Spalding 4352 | Short-Form | PETER J. GENZ | Available-FARA-Public-Office | ||
26121 | 26121 | 1991-03-08 | KING & SPALDING | King & Spalding 4352 | Short-Form | W. DONALD KNIGHT, JR. | Available-FARA-Public-Office | ||
28350 | 28350 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | BRUCE W. BABER | Available-FARA-Public-Office | ||
28351 | 28351 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | CHARLES M. SHAFFER, JR. | Available-FARA-Public-Office | ||
28352 | 28352 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | GRIFFIN B. BELL | Available-FARA-Public-Office | ||
28353 | 28353 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | LOUIS N. JAMESON | Available-FARA-Public-Office | ||
28354 | 28354 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | THEODORE M. HESTER | Available-FARA-Public-Office | ||
28355 | 28355 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | WILLIAM C. TALMADGE | Available-FARA-Public-Office | ||
28356 | 28356 | 1990-03-16 | KING & SPALDING | King & Spalding 4352 | Short-Form | WILLIAM J. COPLE, III | Available-FARA-Public-Office | ||
37562 | 37562 | 1990-04-04 | KING & SPALDING | King & Spalding 4352 | Short-Form | CYNTHIA D. GILLESPIE | Available-FARA-Public-Office | ||
37563 | 37563 | 1990-04-04 | KING & SPALDING | King & Spalding 4352 | Short-Form | THOMAS J. YOUNG | Available-FARA-Public-Office | ||
62737 | 62737 | 1990-06-05 | KING & SPALDING | King & Spalding 4352 | Short-Form | ABBOTT B. LIPSKY, JR. | Available-FARA-Public-Office | ||
62738 | 62738 | 1990-06-05 | KING & SPALDING | King & Spalding 4352 | Short-Form | J. SEDWICK SOLLERS III | Available-FARA-Public-Office | ||
67350 | 67350 | 1990-06-25 | KING & SPALDING | King & Spalding 4352 | Short-Form | CHARLES H. TISDALE, JR. | Available-FARA-Public-Office | ||
67351 | 67351 | 1990-06-25 | KING & SPALDING | King & Spalding 4352 | Short-Form | MARY JANE NORVILLE | Available-FARA-Public-Office | ||
67352 | 67352 | 1990-06-25 | KING & SPALDING | King & Spalding 4352 | Short-Form | THEODORE M. HESTER | Available-FARA-Public-Office | ||
67353 | 67353 | 1990-06-25 | KING & SPALDING | King & Spalding 4352 | Short-Form | WILLIAM J. COPLE, III | Available-FARA-Public-Office | ||
77867 | 77867 | 1992-07-22 | KING & SPALDING | King & Spalding 4352 | Short-Form | THEODORE M. HESTER | Available-FARA-Public-Office | ||
77868 | 77868 | 1992-07-22 | KING & SPALDING | King & Spalding 4352 | Short-Form | WALTER W. DRIVER, JR. | Available-FARA-Public-Office | ||
83452 | 83452 | 1991-08-01 | KING & SPALDING | King & Spalding 4352 | Short-Form | WILLIAM F. NELSON | Available-FARA-Public-Office |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [FARA_All_RegistrantDocs] ( [Date_Stamped] TEXT, [Registrant_Name] TEXT, [Registration_Number] INTEGER, [Document_Type] TEXT, [Short_Form_Name] TEXT, [Foreign_Principal_Name] TEXT, [Foreign_Principal_Country] TEXT, [URL] TEXT, FOREIGN KEY([Registration_Number]) REFERENCES [FARA_All_Registrants]([Registration_Number]) );