ed_loans
2 rows where affiliation = "Democratic" and filed_date = "1/14/20 0:00"
This data as json, CSV (advanced)
Link | rowid ▼ | district | candidate | affiliation | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
10 | 10 | Bd. Ed. District 07 | Esser, Karla | Democratic | 2000.0 | 12/31/19 0:00 | 2000.0 | 1/14/20 0:00 | ||
46 | 46 | CU Regent District 02 | Harber, Aaron | Democratic | 17500.0 | 12/31/19 0:00 | 0.0 | 1/14/20 0:00 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ed_loans" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "loan_amount" REAL, "loan_date" TEXT, "payment_amount" REAL, "payment_date" TEXT, "loan_balance" REAL, "filed_date" TEXT );