B2_Loans

✎ View and edit SQL

This data as json

0 records

CREATE TABLE "B2_Loans" (
"Filer_ID" TEXT,
  "Filer_NamL" TEXT,
  "Report_Num" TEXT,
  "Committee_Type" TEXT,
  "Rpt_Date" TEXT,
  "From_Date" TEXT,
  "Thru_Date" TEXT,
  "Elect_Date" TEXT,
  "tblCover_Office_Cd" TEXT,
  "tblCover_Offic_Dscr" TEXT,
  "Rec_Type" TEXT,
  "Form_Type" TEXT,
  "Tran_ID" TEXT,
  "Entity_Cd" TEXT,
  "Lndr_NamL" TEXT,
  "Lndr_NamF" TEXT,
  "Lndr_NamT" TEXT,
  "Lndr_NamS" TEXT,
  "Loan_Adr1" TEXT,
  "Loan_Adr2" TEXT,
  "Loan_City" TEXT,
  "Loan_ST" TEXT,
  "Loan_Zip4" TEXT,
  "Loan_Date1" TEXT,
  "Loan_Date2" TEXT,
  "Loan_Amt1" TEXT,
  "Loan_Amt2" TEXT,
  "Loan_Amt3" TEXT,
  "Loan_Amt4" TEXT,
  "Loan_Rate" TEXT,
  "Loan_EMP" TEXT,
  "Loan_OCC" TEXT,
  "Loan_Self" TEXT,
  "Cmte_ID" TEXT,
  "Tres_NamL" TEXT,
  "Tres_NamF" TEXT,
  "Tres_NamT" TEXT,
  "Tres_NamS" TEXT,
  "Tres_Adr1" TEXT,
  "Tres_Adr2" TEXT,
  "Tres_City" TEXT,
  "Tres_ST" TEXT,
  "Tres_ZIP4" TEXT,
  "B2Lender_Name-Inter_name" TEXT,
  "Intr_NamF" TEXT,
  "Intr_NamT" TEXT,
  "Intr_NamS" TEXT,
  "Intr_Adr1" TEXT,
  "Intr_Adr2" TEXT,
  "Intr_City" TEXT,
  "Intr_ST" TEXT,
  "Intr_ZIP4" TEXT,
  "Memo_Code" TEXT,
  "Memo_RefNo" TEXT,
  "BakRef_TID" TEXT,
  "XRef_SchNm" TEXT,
  "XRef_Match" TEXT,
  "Loan_Amt5" TEXT,
  "Loan_Amt6" TEXT,
  "Loan_Amt7" TEXT,
  "Loan_Amt8" TEXT
);