FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
21 rows where Registration_Number = 526, State = "NY" and Zip = 10022
This data as json, CSV (advanced)
Suggested facets: Short_Form_Date, Short_Form_Last_Name, Short_Form_First_Name
State 1
- NY · 21 ✖
Registration_Number 1
- Innovation Norway · 21 ✖
Registrant_Name 1
City 1
- New York 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330 | 330 | 2013-02-07 | Raposo | Antonio | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 | |
664 | 664 | 2011-03-28 | Barnese | Hege Vibeke | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 | |
1721 | 1721 | 2003-09-05 | Hansen | Harald | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 | |
2485 | 2485 | 2007-12-31 | Gran | Beate Christin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 | |
3467 | 3467 | 1950-01-09 | 1948-05-13 | Tonnessen | Joan Tolnes | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
6963 | 6963 | 2003-02-15 | 1998-04-06 | Guarnieri | Marie N. | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
12098 | 12098 | 2011-03-31 | 2007-11-30 | Brunner | Tone | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
14326 | 14326 | 1960-04-29 | 1951-02-21 | Simonsen | Svein Erlend Winge | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
14422 | 14422 | 1960-04-30 | 1948-05-13 | Brandvik | Johan Matheus | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
14817 | 14817 | 1999-04-30 | 1999-12-21 | Von Krogh | Marianne | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
16986 | 16986 | 1948-05-24 | 1948-05-13 | Mork | Marit | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
18520 | 18520 | 2005-06-01 | 2003-09-05 | Nygardhs | Robert | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
21508 | 21508 | 2004-06-30 | 2003-09-05 | Hansen | Hege Vibeke | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
21695 | 21695 | 2011-06-30 | 2007-12-31 | Dahle | Kristin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
22026 | 22026 | 1949-07-01 | 1948-05-13 | Olsen | Knut | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
32434 | 32434 | 1959-10-08 | 1955-01-27 | Koefoed | Henning | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
34910 | 34910 | 1988-11-01 | 1985-01-31 | Bolann | Elin | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
39347 | 39347 | 1982-12-30 | 1960-09-14 | Prag | Per | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
39356 | 39356 | 1983-12-30 | 1937-01-01 | Sand | Levar | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
39361 | 39361 | 1984-12-30 | 1948-05-13 | Brekke | Kaare | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
39362 | 39362 | 1985-12-30 | 1937-01-01 | Conradi | Trond | Innovation Norway 526 | 1948-05-13 | Innovation Norway | WeWork | 575 Lexington Ave | New York | NY | 10022 |
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]) );