da_loans

1 row where candidate = "Padden, Amy" and filed_date = "10/15/19 0:00"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ district candidate affiliation loan_amount loan_date payment_amount payment_date loan_balance filed_date
8 8 DA 18 Arapahoe, Douglas, Lincoln, Elbert Padden, Amy Democratic 80000 7/27/19 0:00     80000 10/15/19 0:00

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "da_loans" (
"district" TEXT,
  "candidate" TEXT,
  "affiliation" TEXT,
  "loan_amount" INTEGER,
  "loan_date" TEXT,
  "payment_amount" INTEGER,
  "payment_date" TEXT,
  "loan_balance" INTEGER,
  "filed_date" TEXT
);