FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
12 rows where Registrant_Name = "J.M. Mathes, Inc." and State = "NY"
This data as json, CSV (advanced)
Suggested facets: Short_Form_Termination_Date (date), Registration_Date (date)
State 1
- NY · 12 ✖
Registration_Number 1
Registrant_Name 1
- J.M. Mathes, Inc. · 12 ✖
City 1
- New York 12
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10342 | 10342 | 1952-03-20 | 1950-02-06 | Ingram | George Barber | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10343 | 10343 | 1952-03-20 | 1951-03-27 | Cox | John Warren | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10344 | 10344 | 1952-03-20 | 1951-03-27 | Smith | Richard Bull | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10345 | 10345 | 1952-03-20 | 1950-04-24 | Marshall | Leonard | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10346 | 10346 | 1952-03-20 | 1949-09-21 | Baird | Janet Hamilton | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10347 | 10347 | 1952-03-20 | 1949-09-21 | Deardorff | Robert Monroe | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10348 | 10348 | 1952-03-20 | 1949-09-21 | Gustafson | Philip H. | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10349 | 10349 | 1952-03-20 | 1949-09-21 | Hoffman | Rona | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10350 | 10350 | 1952-03-20 | 1949-09-21 | Okie | William T. | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10351 | 10351 | 1952-03-20 | 1949-09-27 | King | Wilfred Strickland | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10352 | 10352 | 1952-03-20 | 1949-09-27 | Monroe | Arthur F. | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY | ||
10353 | 10353 | 1952-03-20 | 1950-11-30 | de Bayeux | Dorothy Pegoix | J.M. Mathes, Inc. 590 | 1949-09-21 | J.M. Mathes, Inc. | 122 East 42nd Street | New York | NY |
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]) );