home

Menu
  • Search all tables
  • GraphQL API

fara

Table actions
  • GraphQL API for fara

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

Custom SQL query

Tables

FARA_All_ForeignPrincipals

Foreign_Principal_Termination_Date, Foreign_Principal, Foreign_Principal_Registration_Date, Country/Location_Represented, Registration_Number, Registrant_Date, Registrant_Name, Address_1, Address_2, City, State, Zip

16,939 rows

FARA_All_RegistrantDocs

Date_Stamped, Registrant_Name, Registration_Number, Document_Type, Short_Form_Name, Foreign_Principal_Name, Foreign_Principal_Country, URL

135,872 rows

FARA_All_Registrants

Registration_Number, Registration_Date, Termination_Date, Name, Business_Name, Address_1, Address_2, City, State, Zip

6,717 rows

FARA_All_ShortForms

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

42,460 rows

FARA_All_ForeignPrincipals_fts (hidden)

Foreign_Principal, Registrant_Name, FARA_All_ForeignPrincipals_fts, rank

16,939 rows

FARA_All_ForeignPrincipals_fts_config (hidden)

k, v

1 row

FARA_All_ForeignPrincipals_fts_data (hidden)

id, block

180 rows

FARA_All_ForeignPrincipals_fts_docsize (hidden)

id, sz

16,939 rows

FARA_All_ForeignPrincipals_fts_idx (hidden)

segid, term, pgno

169 rows

FARA_All_RegistrantDocs_fts (hidden)

Registrant_Name, Short_Form_Name, Foreign_Principal_Name, FARA_All_RegistrantDocs_fts, rank

135,872 rows

FARA_All_RegistrantDocs_fts_config (hidden)

k, v

1 row

FARA_All_RegistrantDocs_fts_data (hidden)

id, block

858 rows

FARA_All_RegistrantDocs_fts_docsize (hidden)

id, sz

135,872 rows

FARA_All_RegistrantDocs_fts_idx (hidden)

segid, term, pgno

717 rows

FARA_All_Registrants_fts (hidden)

Name, Address_1, Address_2, FARA_All_Registrants_fts, rank

6,717 rows

FARA_All_Registrants_fts_config (hidden)

k, v

1 row

FARA_All_Registrants_fts_data (hidden)

id, block

83 rows

FARA_All_Registrants_fts_docsize (hidden)

id, sz

6,717 rows

FARA_All_Registrants_fts_idx (hidden)

segid, term, pgno

74 rows

FARA_All_ShortForms_fts (hidden)

Short_Form_Last_Name, Short_Form_First_Name, Registrant_Name, FARA_All_ShortForms_fts, rank

42,460 rows

FARA_All_ShortForms_fts_config (hidden)

k, v

1 row

FARA_All_ShortForms_fts_data (hidden)

id, block

425 rows

FARA_All_ShortForms_fts_docsize (hidden)

id, sz

42,460 rows

FARA_All_ShortForms_fts_idx (hidden)

segid, term, pgno

474 rows

Download SQLite DB: fara.db 36.3 MB

Powered by Datasette · Queries took 46.504ms · Data source: The U.S. Department of Justice · About: https://github.com/simonw/fara-history