FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
50 rows where Address_1 = "1500 Broadway"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Address_2, Short_Form_Termination_Date (date), Short_Form_Date (date), Registration_Date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1005 | 1005 | 2016-05-12 | Ji | Tao | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
1610 | 1610 | 2011-08-14 | Serviss | Ben | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
2287 | 2287 | 2011-11-30 | Wang | Jun | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
2386 | 2386 | 2002-12-12 | Huang | Qing | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 | |
2535 | 2535 | 1966-01-01 | 1965-05-11 | Carrillo | Roberto Sandoval Y | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
2537 | 2537 | 1966-01-01 | 1960-08-05 | Esparza | Luis Navarro | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
3512 | 3512 | 1962-01-10 | 1946-12-17 | Vazquez | Juan , Jr. | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
3716 | 3716 | 2020-01-14 | 2016-05-12 | Zhang | Yuan | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
5451 | 5451 | 2011-01-31 | 2011-08-14 | Preimesberger | Mei | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
5497 | 5497 | 2015-01-31 | 2011-11-30 | Liu | Lian | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
5625 | 5625 | 1949-02-01 | 1946-12-17 | Chenoweth | Harry Escalante | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
5626 | 5626 | 1949-02-01 | 1946-12-17 | Vargas | Guillermo Hawley | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
5652 | 5652 | 1961-02-01 | 1959-07-29 | Basauri | Luis Madrazo | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
6718 | 6718 | 1976-02-13 | 1970-09-08 | D'Addona | Manuel Zopfy | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
8115 | 8115 | 2000-02-28 | 1990-09-11 | Chang | Lily Chun-Yen | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
8823 | 8823 | 2001-03-01 | 1990-09-11 | Tse | Karen C. | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
12855 | 12855 | 2012-04-06 | 2011-11-30 | Lariviere | David Robert | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
17620 | 17620 | 1973-05-31 | 1972-03-23 | Avila | Ricardo | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
17621 | 17621 | 1973-05-31 | 1972-03-23 | Canto | Rogerio | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
19502 | 19502 | 1970-06-15 | 1965-05-11 | Brillas | Guillermo Moreno | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
20124 | 20124 | 1964-06-24 | 1946-12-17 | Alatorre | Francisco | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
21341 | 21341 | 1999-06-30 | 1990-09-11 | Hui | Chen | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
21342 | 21342 | 1999-06-30 | 1990-09-11 | Xiaobei | Zhang | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
22035 | 22035 | 1956-07-01 | 1951-04-04 | Reynoso | Fernando | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
26396 | 26396 | 2003-08-10 | 1990-08-29 | Xiliang | Feng | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
28764 | 28764 | 1964-09-01 | 1946-12-17 | Moscosso | V.H. | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
28821 | 28821 | 1983-09-01 | 1982-02-02 | Augay | Peter | Augay Enterprises, Inc. 3328 | 1982-02-02 | Augay Enterprises, Inc. | 1500 Broadway | New York | NY | 10036 | |
28822 | 28822 | 1983-09-01 | 1982-02-02 | Heapps | William | Augay Enterprises, Inc. 3328 | 1982-02-02 | Augay Enterprises, Inc. | 1500 Broadway | New York | NY | 10036 | |
28823 | 28823 | 1983-09-01 | 1982-02-02 | Schrenk | Gerald | Augay Enterprises, Inc. 3328 | 1982-02-02 | Augay Enterprises, Inc. | 1500 Broadway | New York | NY | 10036 | |
29151 | 29151 | 1990-09-04 | 1983-04-19 | Kee | Young | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
30160 | 30160 | 2006-09-20 | 1990-09-11 | Hom | Jin-Get | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
30161 | 30161 | 2006-09-20 | 2002-12-12 | Li | Wen | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
30456 | 30456 | 2009-09-25 | 2006-11-30 | Qu | Yingpu | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
31770 | 31770 | 1957-10-01 | 1946-12-17 | Servin | G. | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
31793 | 31793 | 1964-10-01 | 1953-05-12 | Garza | Horacio Dominguez | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
32834 | 32834 | 1971-10-15 | 1971-02-04 | Vasconcelos | Jose I. | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
33217 | 33217 | 2011-10-19 | 1990-09-11 | Yinghuang | Zhu | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
33378 | 33378 | 1986-10-22 | 1962-03-16 | Scanlan | Francis Thomas | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
33385 | 33385 | 1986-10-22 | 1978-07-19 | Cerchione | Emita (Rodriguez) | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
34877 | 34877 | 1977-11-01 | 1973-08-14 | Guillen | Jose Ramon | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
36069 | 36069 | 2008-11-19 | 2007-12-21 | Massand | Rikki N. | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
36400 | 36400 | 2009-11-25 | 2002-12-12 | Zhou | Gengxin | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
37514 | 37514 | 2012-12-01 | 2011-08-14 | Xie | Zhihong | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
37807 | 37807 | 2014-12-05 | 2011-08-14 | Liu | Zuoyi | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
38275 | 38275 | 1973-12-14 | 1947-02-24 | Moreno | Felipe Nicolas Puente Y | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
38276 | 38276 | 1973-12-14 | 1947-02-26 | Lina | Laura Cecilia Bergquist | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
38280 | 38280 | 1973-12-14 | 1946-12-17 | Porragas | Santiago Pichardo | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
39359 | 39359 | 1983-12-30 | 1946-12-17 | Hernandez | Jose Guadalupe | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
39360 | 39360 | 1983-12-30 | 1946-12-17 | Lopez | Jose M. | Mexican Government Railway System 413 | 1946-12-17 | Mexican Government Railway System | 1500 Broadway | Suite 810 | New York | NY | 10017 |
41513 | 41513 | 2006-12-31 | 1990-09-11 | Wong | Lap-Jong | China Daily Distribution Corporation 3457 | 1983-04-19 | China Daily Distribution Corporation | 1500 Broadway | Suite 2800 | New York | NY | 10036 |
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]) );