da_loans
1 row where filed_date = "5/3/20 0:00" sorted by affiliation
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation ▼ | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | DA 11 Park et al | Turner, Kaitlin | Democratic | 1000 | 1/25/20 0:00 | 1000 | 5/3/20 0:00 |
Advanced export
JSON shape: default, array, newline-delimited
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 );