FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
10 rows where City = "Los Angeles", Registrant_Name = "KBS LA, Inc.", Registration_Number = 3792 and "Short_Form_Date" is on date 1986-04-03
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Short_Form_Date (date)
State 1
- CA 10
Registration_Number 1
- KBS LA, Inc. · 10 ✖
Registrant_Name 1
- KBS LA, Inc. · 10 ✖
City 1
- Los Angeles · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6536 | 6536 | 1989-02-10 | 1986-04-03 | Song | Jhang Gil | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
9468 | 9468 | 2001-03-08 | 1986-04-03 | Chung | Young Ho | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
9469 | 9469 | 2001-03-08 | 1986-04-03 | Lee | Kun Man | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
12027 | 12027 | 2008-03-31 | 1986-04-03 | Lee | Seung Sang | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
12783 | 12783 | 1991-04-05 | 1986-04-03 | Lee | Joo Hyuk | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
18463 | 18463 | 1986-06-01 | 1986-04-03 | Kil | Jong Sup | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
25581 | 25581 | 1990-08-01 | 1986-04-03 | Lee | Jung Soo | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
26536 | 26536 | 1987-08-13 | 1986-04-03 | Seong | Dae Seock | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
34914 | 34914 | 1988-11-01 | 1986-04-03 | Lee | Chung Soo | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 | |
35294 | 35294 | 1988-11-05 | 1986-04-03 | Cha | Jong Ho | KBS LA, Inc. 3792 | 1986-03-11 | KBS LA, Inc. | 625 South Kingsley Drive | Los Angeles | CA | 90005 |
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]) );