home / fara

Menu
  • Search all tables
  • GraphQL API

FARA_All_ShortForms

Table actions
  • GraphQL API for FARA_All_ShortForms
List of all short form registrants (active and terminated)

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

98 rows where City = "Jamaica"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Registration_Date, Address_2, Short_Form_Termination_Date (date), Registration_Date (date)

Registration_Number 2

  • Jamaica Progressive League, Inc. 97
  • Partido Institucional Democratico (PID) 1

Registrant_Name 2

  • Jamaica Progressive League, Inc. 97
  • Partido Institucional Democratico (PID) 1

State 1

  • NY 98

City 1

  • Jamaica · 98 ✖
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
4791 4791 1970-01-30 1959-11-12 Tully Irma Maud Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
5698 5698 1978-02-01 1974-10-17 Prestwidge Hilda D. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
6875 6875 1955-02-15 1955-04-15 Berry Olive Madge Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
7141 7141 1955-02-17 1945-03-09 Brown Ethelred Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
7142 7142 1955-02-17 1955-04-15 Cochrane Ephraim C. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
7143 7143 1955-02-17 1955-04-15 Richards Cranmer Martin Luther Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
7144 7144 1955-02-17 1955-04-15 Wainwright Wesley Augustus Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
7145 7145 1955-02-17 1949-04-27 Johnston Vincent Llewelyn Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
7146 7146 1955-02-17 1952-10-15 Taylor Fleada Benegma Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
9485 9485 1964-03-09 1962-01-03 Plummer Ephraim A. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
9486 9486 1965-03-09 1964-11-12 Wilson Headley Casabianca Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
9488 9488 1967-03-09 1967-01-11 Dunn Timothy Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
10530 10530 1948-03-23 1945-03-09 Bowen Thomas R. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
12848 12848 1966-04-07 1962-04-16 Davis Hyacinth Beatrice Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
12849 12849 1966-04-07 1962-04-16 Sewell Clifford C. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
12850 12850 1966-04-07 1965-09-17 Taylor Austin Richard Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
12851 12851 1966-04-07 1965-09-24 Small Ettie Craig Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
13286 13286 1952-04-14 1948-04-19 Gray Haskell Edson Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
18405 18405 1976-06-01 1974-10-17 McKenzie Roy P. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
18875 18875 1969-06-05 1966-07-27 Pitterson Fernando Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
18876 18876 1969-06-05 1959-11-12 Davis Fitzgerald Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
22559 22559 1963-07-05 1962-04-16 McLymont Dorcas Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
22560 22560 1963-07-05 1947-04-28 McLymont Leonard Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
27161 27161 1973-08-22 1971-02-14 Williams Cecile Angela Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
28721 28721 1959-09-01 1950-04-18 Munroe Gladys Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
28723 28723 1959-09-01 1959-11-12 Mason George A. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
28735 28735 1962-09-01 1953-03-30 Reid Frederick Leopold Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30375 30375 1955-09-25 1954-04-15 Collins Myrtle Alexandria Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30376 30376 1961-09-25 1960-08-08 Siddons Hyacinth Agatha Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30379 30379 1961-09-25 1957-09-09 Foster Suzanne Frances Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30380 30380 1961-09-25 1957-09-09 Gibson Alethia Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30616 30616 1952-09-28 1945-03-09 Trew Richard Samuel Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30617 30617 1952-09-28 1952-04-14 Raymore Hubert Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30618 30618 1952-09-28 1952-10-15 MacBeth Rhoda Louise Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30756 30756 1945-09-30 1945-03-09 Brown May Estelle Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30757 30757 1945-09-30 1945-03-09 Davis Alberta Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30758 30758 1945-09-30 1945-03-09 Kiffin Magdelene Claris Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30759 30759 1945-09-30 1945-03-09 Senior Charles M. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30760 30760 1945-09-30 1945-03-09 West Randolf Ollivienone Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30764 30764 1948-09-30 1945-03-09 DePass Lilla Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30765 30765 1948-09-30 1945-03-09 Lindsay Reginald R. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30766 30766 1948-09-30 1947-04-28 Gibson Alethia Lucille Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30767 30767 1948-09-30 1947-04-28 Johnson Albert Percival Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30768 30768 1948-09-30 1947-04-28 McLaughlin Inez Maud Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30769 30769 1949-09-30 1946-03-01 Miller Carrie Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
30770 30770 1949-09-30 1945-03-09 Edwards Richard Alescander Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31731 31731 1946-10-01 1946-03-01 Burton Leslie George Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31732 31732 1946-10-01 1946-03-01 Stewart Mable E. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31733 31733 1946-10-01 1945-03-12 Burns Ruby Ann Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31734 31734 1946-10-01 1946-03-25 Welsh Adeline Theresa Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31758 31758 1960-10-01 1960-08-08 Anglin Samuel Louis Disrali Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31759 31759 1960-10-01 1957-09-09 Ashbourne Johanna E. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31760 31760 1960-10-01 1959-10-08 Dyer Jacob Alexander Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31762 31762 1960-10-01 1959-11-12 Henry Beryl Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31806 31806 1975-10-01 1975-06-03 Dunkley Leslie R. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31808 31808 1975-10-01 1974-10-17 Dwyer Mickie H. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
31809 31809 1975-10-01 1974-10-17 Lee Cynthia C. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
32604 32604 1975-10-11 1971-02-14 Kenyon Vernon S. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
32605 32605 1975-10-11 1974-10-17 Taylor Ronald H. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33434 33434 1966-10-23 1966-06-24 Panton Eustace E. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33435 33435 1966-10-23 1966-07-27 O'Reilly Laselve Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33436 33436 1966-10-23 1966-07-27 Comacho Rudolf Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33524 33524 1971-10-24 1967-01-11 Neysmith Horace Granville Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33525 33525 1971-10-24 1971-02-14 Burke Frank Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33526 33526 1971-10-24 1971-02-14 Campbell Thomas Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33527 33527 1971-10-24 1971-02-14 Grant-Kelly Neville Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33528 33528 1971-10-24 1971-02-14 Scott Cecil E. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33529 33529 1971-10-24 1968-05-24 Baker Reginald Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33530 33530 1971-10-24 1967-07-11 Reid Frederick L. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33531 33531 1977-10-24 1971-02-14 Neysmith Lucille Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33568 33568 1970-10-25 1967-01-11 Williams Lilla DePass Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33569 33569 1970-10-25 1945-03-09 Johnson Daisy Brooks Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33570 33570 1970-10-25 1967-07-11 Johnson Daisy B. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33583 33583 1987-10-25 1985-02-26 Davis Marsaine Arthur Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33585 33585 1987-10-25 1968-05-24 Young John S. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33590 33590 1988-10-25 1945-03-09 Shepperd David Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33591 33591 1988-10-25 1948-04-19 Wright Hector Cadwallder Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33592 33592 1988-10-25 1952-06-15 Reid Louise Clarke Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33630 33630 1958-10-26 1958-10-17 Brown Estelle Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33631 33631 1958-10-26 1958-11-21 Richards Cranmer Martin Luther Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33667 33667 1957-10-27 1957-09-09 Thomas Eric Granville Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33797 33797 1951-10-29 1950-04-18 Clarke Frank Clinton Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33798 33798 1951-10-29 1948-04-19 Trowers Boswell Elisha Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
33799 33799 1951-10-29 1949-04-27 Henry Beryl Eugene Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
34174 34174 1978-10-31 1971-02-14 Cardoza Horace A. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
34274 34274 1989-10-31 1975-07-03 Johnston Vincent L. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
34857 34857 1978-11-01 1974-10-17 McTaggart Basch C. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
36187 36187 1982-11-22 1974-10-17 Rodney Karl B. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
36285 36285 1982-11-24 1978-06-12 Objio Sigfrido S. Partido Institucional Democratico (PID) 2915 1978-06-12 Partido Institucional Democratico (PID) 90-04 - 161st Street Suiyr 309 Jamaica NY 11432
36311 36311 1951-11-25 1948-04-19 Rose-Body Beatrice Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
36312 36312 1951-11-25 1947-04-28 Dyer Jacob Alexander Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
36510 36510 1972-11-29 1971-02-14 Abrahams Clarence Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
36511 36511 1972-11-29 1971-02-14 Williams Noel Ivanhoe Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
39865 39865 1970-12-31 1965-09-24 Bernard Lucille Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
39997 39997 1976-12-31 1974-10-17 Stewart Mabel Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
40146 40146 1980-12-31 1974-10-17 Collins Edna M. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
40147 40147 1980-12-31 1974-10-17 Pinnock Eric J. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432
40261 40261 1984-12-31 1950-04-18 Duncan Rupert V. Jamaica Progressive League, Inc. 296 1945-03-12 Jamaica Progressive League, Inc. 15905 Hillside Avenue 2nd Floor Jamaica NY 11432

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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])
);
Powered by Datasette · Queries took 507.524ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history