FARA_All_ShortForms
Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history
375 rows where Registrant_Name = "Ruder Finn, Inc."
This data as json, CSV (advanced)
Suggested facets: Registration_Date, Address_1, Zip, Short_Form_Termination_Date (date), Registration_Date (date)
Registration_Number 4
City 3
- New York 350
- Washington 22
- Chicago 3
Registrant_Name 1
- Ruder Finn, Inc. · 375 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
246 | 246 | 2022-01-30 | Caamano | Antonia | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
449 | 449 | 2023-02-24 | Lee | Edmund | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
450 | 450 | 2023-02-24 | Young | Isabelle | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
492 | 492 | 2022-03-03 | Ford | Chase Aaron | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
735 | 735 | 2022-04-06 | Enkhbaatar | Odsuren | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
836 | 836 | 2023-04-19 | Sinkovitz | Lily | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
845 | 845 | 2023-04-20 | Scarinzi | Chip | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
867 | 867 | 2023-04-24 | Johnson | Stephanie | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1273 | 1273 | 2020-06-22 | Bloomgarden | Kathy | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1275 | 1275 | 2020-06-22 | Rabe | Brianna | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1294 | 1294 | 2021-06-25 | Manella | Isabel | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1391 | 1391 | 2022-07-11 | Mautz | Hannah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1480 | 1480 | 2022-07-25 | Yacavone | Kyra | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1544 | 1544 | 2021-07-30 | Mason | Ryan | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
1545 | 1545 | 2021-07-30 | Munjal | Sonali | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2004 | 2004 | 2022-10-21 | Berry | Haven | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2092 | 2092 | 2020-11-02 | Ayromlou | Maryam | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2093 | 2093 | 2020-11-02 | Barrett | Jenny | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2094 | 2094 | 2020-11-02 | Dickter | Noah | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2095 | 2095 | 2020-11-02 | Francum | Peyton | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2097 | 2097 | 2020-11-02 | Kim | Robin | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2099 | 2099 | 2020-11-02 | Savarese | Jessica | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2101 | 2101 | 2020-11-02 | Yi | Guen | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2144 | 2144 | 2022-11-11 | Gusain | Tripti | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | ||
2635 | 2635 | 1986-01-01 | 1980-07-24 | Mintz | Gilda Yolles | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
2846 | 2846 | 2007-01-01 | 1979-07-16 | Lipton | Charles | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
2847 | 2847 | 2007-01-01 | 1962-08-09 | Ruder | William | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
2861 | 2861 | 2007-01-01 | 1966-12-30 | Warshaw | Saul Leon | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
3055 | 3055 | 1985-01-02 | 1981-02-23 | Bagar | Robert | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
3277 | 3277 | 1987-01-06 | 1986-09-21 | Bigelow | Astrid | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
3482 | 3482 | 1979-01-09 | 1977-09-22 | Ryan | Philip G. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
3790 | 3790 | 1987-01-15 | 1985-08-06 | Cid | Jorge Del | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
3801 | 3801 | 1992-01-15 | 1987-08-07 | Steinberg | Peter D. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
3944 | 3944 | 1968-01-17 | 1967-06-23 | Snyder | John I. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4076 | 4076 | 2022-01-18 | 2021-05-14 | Gould | Charles | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
4083 | 4083 | 1968-01-19 | 1963-04-26 | Rosen | Harold Bert | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4515 | 4515 | 1979-01-26 | 1978-02-07 | Gottesman | Hyam | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4678 | 4678 | 1976-01-28 | 1975-12-23 | Javits | Marion B. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4754 | 4754 | 1989-01-29 | 1997-04-21 | Rheem | Donald L. II | Ruder Finn, Inc. 4315 | 1989-11-09 | Ruder Finn, Inc. | 808 - 17th Street, N.W. | Suite 600 | Washington | DC | 20006 |
4814 | 4814 | 1983-01-30 | 1983-01-26 | Hannawalt | James F. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4928 | 4928 | 1970-01-31 | 1964-06-08 | Hunter | Harry F. , Jr. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4958 | 4958 | 1977-01-31 | 1973-10-31 | Schneck | Lucille Corrier | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
4995 | 4995 | 1984-01-31 | 1982-05-11 | Rothrock | Judith | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
5057 | 5057 | 1990-01-31 | 1987-08-10 | Paris | Peter Boston | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
5278 | 5278 | 2003-01-31 | 1979-04-25 | Peters | Sharon | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
5655 | 5655 | 1963-02-01 | 1962-04-27 | Warshaw | Saul Leon | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
5981 | 5981 | 2001-02-02 | 1999-10-28 | Crespo | Carrie | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6098 | 6098 | 2023-02-03 | 2022-09-21 | Harb | Krystel | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
6160 | 6160 | 1971-02-05 | 1968-10-31 | Rand | Larry Anthony | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6220 | 6220 | 1976-02-06 | 1973-05-22 | Lindo | Arthur S. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6373 | 6373 | 1982-02-08 | 1981-02-23 | Warren | Suzanne L. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6498 | 6498 | 1967-02-10 | 1966-12-30 | Goff | Daniel Neville | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6817 | 6817 | 1992-02-14 | 1990-10-30 | Postle | Bradley R. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
6917 | 6917 | 1974-02-15 | 1973-05-22 | Bach | Helga Rieg | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7062 | 7062 | 1987-02-16 | 1985-03-14 | Rosenblat | Arney | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7137 | 7137 | 2001-02-16 | 2000-04-27 | Baumgartner | Lisa | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7328 | 7328 | 1975-02-21 | 1974-05-30 | Simon | Edwin | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7329 | 7329 | 1979-02-21 | 1977-09-22 | Goldberg | Ann E. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7374 | 7374 | 1985-02-22 | 1983-10-12 | Gorant | Denise | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7504 | 7504 | 1978-02-24 | 1968-09-17 | O'Connor | Jean | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7710 | 7710 | 1991-02-26 | 1987-11-25 | DeMala | Pamela Sue | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7784 | 7784 | 1987-02-27 | 1985-08-21 | Pew | Gilda B. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7798 | 7798 | 1998-02-27 | 1996-05-03 | Thiney | Emmanuelle A. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7846 | 7846 | 1967-02-28 | 1966-12-30 | Ferris | Robert D. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7857 | 7857 | 1969-02-28 | 1967-06-23 | Champion | Eleanor M. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7859 | 7859 | 1969-02-28 | 1966-11-21 | Valverde | Geogia Lee | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7862 | 7862 | 1970-02-28 | 1964-02-10 | Reilly | Madeleine Halpin | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7880 | 7880 | 1976-02-28 | 1975-09-09 | Booth | Margaret | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7928 | 7928 | 1986-02-28 | 1963-11-08 | Landman | Amos | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7937 | 7937 | 1989-02-28 | 1987-01-05 | Marks | Roberta G. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7974 | 7974 | 1991-02-28 | 1990-04-27 | Stern | Ava | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
7977 | 7977 | 1991-02-28 | 1986-05-23 | Schechter | William | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
8496 | 8496 | 2000-02-29 | 1999-10-28 | Essen | Jennifer | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
8778 | 8778 | 1990-03-01 | 1989-11-09 | Bowman | Christopher J. | Ruder Finn, Inc. 4315 | 1989-11-09 | Ruder Finn, Inc. | 808 - 17th Street, N.W. | Suite 600 | Washington | DC | 20006 |
8946 | 8946 | 2023-03-01 | 2022-09-21 | Shulak | Delayna | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
9025 | 9025 | 1989-03-03 | 1986-05-28 | Reilly | James V. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9139 | 9139 | 2022-03-04 | 2020-12-21 | Caughman | Katie | Ruder Finn, Inc. 6840 | 2020-06-22 | Ruder Finn, Inc. | 425 East 53rd Street | New York | NY | 10022 | |
9182 | 9182 | 1997-03-05 | 1995-10-27 | Dukas | Richard | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9376 | 9376 | 1969-03-07 | 1966-02-10 | Unger | David | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9701 | 9701 | 1982-03-12 | 1981-02-23 | Blane | Susan Nierenberg | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9822 | 9822 | 1980-03-14 | 1971-11-23 | Bagar | Robert Anthony | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9923 | 9923 | 1975-03-15 | 1975-09-09 | Birnbaum | Jane | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9931 | 9931 | 1979-03-15 | 1978-02-16 | Halprin | Jerome | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
9983 | 9983 | 2001-03-15 | 2000-04-27 | Crownover | Shannon | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10044 | 10044 | 1970-03-16 | 1966-12-30 | Rubinow | Ronald William | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10667 | 10667 | 1986-03-24 | 1985-03-19 | Mouchly-Weiss | Harriet | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10839 | 10839 | 1965-03-27 | 1963-04-26 | Ansberry | Louise Steinman | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10840 | 10840 | 1965-03-27 | 1964-11-12 | Eckman | Ralph Roland | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10865 | 10865 | 1986-03-27 | 1975-09-09 | Feinsot | Louise | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10881 | 10881 | 1992-03-27 | 1992-04-28 | Merriam | Dena | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
10938 | 10938 | 1972-03-28 | 1971-11-08 | Brandt | John | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11113 | 11113 | 1971-03-30 | 1966-11-28 | Lucas | James Russel | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11178 | 11178 | 1996-03-30 | 1995-04-28 | Hirsch | Susan | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11423 | 11423 | 1971-03-31 | 1969-12-31 | Abel | Joan R. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11452 | 11452 | 1975-03-31 | 1969-11-06 | Penner | Etsuko S. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11810 | 11810 | 1999-03-31 | 1997-04-21 | Johnson | Krista K. | Ruder Finn, Inc. 4315 | 1989-11-09 | Ruder Finn, Inc. | 808 - 17th Street, N.W. | Suite 600 | Washington | DC | 20006 |
11839 | 11839 | 2000-03-31 | 1997-08-22 | Golden-Vazquez | Abigail | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
11844 | 11844 | 2000-03-31 | 1999-10-28 | Janashvili | Lev | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
12085 | 12085 | 2011-03-31 | 2000-04-27 | Kalson | David | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | New York | NY | 10022 | |
12396 | 12396 | 1969-04-01 | 1963-03-25 | Nash,Jr. | Leslie A. | Ruder Finn, Inc. 1481 | 1961-09-27 | Ruder Finn, Inc. | 301 East 57th Street | 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]) );