home / fara

Menu
  • Search all tables
  • GraphQL API

fara

Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history

Custom SQL query returning 101 rows (hide)

 
1
select 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 from FARA_All_ShortForms where "Registrant_Name" = :p0 order by rowid limit 101

Query parameters

This data as json, CSV

rowidShort_Form_Termination_DateShort_Form_DateShort_Form_Last_NameShort_Form_First_NameRegistration_NumberRegistration_DateRegistrant_NameAddress_1Address_2CityStateZip
139   2023-01-17 Goldman Kevin 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
140   2023-01-17 London Joy 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
141   2023-01-17 Perlmutter Rachel 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
142   2023-01-17 Pittman Mary Gannon 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
143   2023-01-17 Prade Nasir Steven 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
144   2023-01-17 Ringler Todd D. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
145   2023-01-17 Teitelman Sarah 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
196   2023-01-25 Chitwood Matthew McKenzie 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
197   2023-01-25 Garsko Summer 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
273   2023-01-31 O'Keefe Eleanor 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
274   2023-01-31 Albrow Sophie 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
276   2023-01-31 Cusack Patricia 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
277   2023-01-31 Garvey Alex Edward 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
278   2023-01-31 Jones Timothy Carlton 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
279   2023-01-31 Killick Charles Robinson 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
280   2023-01-31 Lock Benjamin 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
281   2023-01-31 Lowe Matthew 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
333   2022-02-07 Workman Daniel 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
353   2023-02-10 Awesu Awanat Toyin 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
354   2023-02-10 Streit Matthew 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
355   2023-02-10 Thompson Jeremy Solomon 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
461   2021-02-26 Millard Rachel Louise 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
480   2023-03-02 Cazalet Eloise 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
481   2023-03-02 Lehr Deborah 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
484   2023-03-02 Resnick-Ault Jessica 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
485   2023-03-02 Rowland Daniel 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
486   2023-03-02 Walters Lindsay E. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
487   2023-03-02 Watts Joseph 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
532   2023-03-08 Ishaq Malalla Fairooz Noora Mohammed 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
534   2023-03-08 Petroccione Emily 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
535   2023-03-08 Roscoe Andrew Leslie 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
560   2020-03-11 Sullivan Jr. Jere J. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
581   2021-03-16 Bledsoe Paul W. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
758   2023-04-10 Dunn Paul 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
760   2023-04-10 Ostrower Matthew 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
761   2023-04-10 Sabrina Lam Ka Wai 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
762   2023-04-10 Tailor Sophia 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
763   2023-04-10 Wei Ching Adrianna Lau 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
764   2023-04-10 Wong Yue Kei 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
769   2023-04-11 Si Ho Chan Simon 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
770   2023-04-12 Cheung Wing Sze 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
875   2023-04-25 Reid Zoe 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
979   2023-05-06 Palmer Jodie 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
985   2023-05-08 Mitchell John 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
986   2023-05-08 Morimoto Andrew 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1026   2023-05-15 Rubel Steven 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1068   2023-05-20 Tyson Max 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1069   2023-05-20 Vazquez Edgar 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1080   2023-05-22 Johnson Tomos 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1081   2023-05-22 Laws George Benjamin 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1095   2023-05-24 DuToit Lili 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1096   2023-05-24 Forrest Sophie 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1097   2023-05-24 Gibbs Portia 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1098   2023-05-24 Konowe Adam 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1114   2023-05-26 Larese-Pollonin Sabrina 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1213   2022-06-09 Ames Joseph P. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1214   2022-06-09 Esguerra Lorenz 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1215   2022-06-09 Moses Jarrod 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1216   2022-06-09 Silverman Audra 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1218   2023-06-09 Dingwell Makena 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1236   2022-06-14 Vera Maria Pereyra 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1242   2022-06-15 Semaski Victoria 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1263   2023-06-20 Murray Debora Comenalli 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1264   2023-06-20 Oh Clare 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1367   2022-07-07 Hedquist Christopher 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1369   2022-07-07 Nandigama Saveri 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1550   2023-07-31 Farrah Rami 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1551   2023-07-31 Haskell Maxim 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1567   2021-08-05 Phillips Lauren Delaney 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1628   2021-08-17 O'Shea Jack 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1779   2022-09-14 Davidson-Musser Stella Bijou 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1780   2022-09-14 Edelman Richard 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1783   2022-09-14 Harris Lauren 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1916   2021-10-07 Lehner Tyler Joseph 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1953   2022-10-13 Hershey Isabella Rane 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1960   2022-10-14 Hakimi Nicole 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1977   2019-10-17 Neary Sean 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
1986   2022-10-19 Rittenberry Jordan 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2106   2022-11-03 Albin Daniela 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2107   2022-11-03 Brown Christina 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2108   2022-11-03 Rudorf Hanna 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2178   2022-11-17 Silva Luis Felipe Betancourt 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2322   2020-12-01 Loyd Weston Yates 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2401   2022-12-14 Wales Alexandra 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2447   2022-12-21 Willner Sean Thomas 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2895 2012-01-01 2010-07-20 Walsh Monica 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2898 2012-01-01 2011-07-22 Bennett Taylor R. 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
2993 2017-01-01 2013-03-15 Holland Michael 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
3104 2008-01-02 2008-04-22 Williamson Maria Conti 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3201 2008-01-04 2008-04-22 Field Steven 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3202 2008-01-04 2008-10-31 Chamberlin Emily 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3203 2008-01-04 2008-10-31 Lopez Jennifer 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3248 2008-01-05 2008-04-22 Caldwell Erin 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3249 2008-01-05 2008-04-22 Kozel Jennifer 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3250 2008-01-05 2008-04-22 Levy David 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3498 2008-01-09 2008-10-31 Brown Jeanette 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3826 2008-01-15 2008-04-22 Roy Tristan 3657 1985-03-12 Daniel J. Edelman, Inc. 250 Hudson Street   New York NY 10013
3829 2010-01-15 2004-11-10 Segal J. Peter 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
3839 2021-01-15 2020-02-20 Streit Matthew Alan 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
3840 2021-01-15 2020-02-20 Thompson Jeremy Solomon 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
3841 2021-01-15 2020-02-26 Mansfield Adalie Joy 3634 1984-11-15 Daniel J. Edelman, Inc. 111 North Canal Street Suite 1100 Chicago IL 60606
Powered by Datasette · Queries took 4.052ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history