da_loans
6 rows where loan_balance = 0
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, loan_amount, loan_date, payment_amount
filed_date 4 ✖
Link | rowid ▼ | district | candidate | affiliation | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|---|
3 | 3 | DA 8 Larimer | Mclaughlin, Gordon | Democratic | 6000 | 10/15/20 0:00 | 0 | 11/2/20 0:00 | ||
5 | 5 | DA 8 Larimer | Mclaughlin, Gordon | Democratic | 6000 | 10/15/20 0:00 | 6000 | 11/9/20 0:00 | 0 | 12/3/20 0:00 |
6 | 6 | DA 17 Adams | Mason, Brian | Democratic | 5000 | 2/27/19 0:00 | 0 | 4/15/19 0:00 | ||
7 | 7 | DA 17 Adams | Mason, Brian | Democratic | 5000 | 2/27/19 0:00 | 5000 | 11/2/19 0:00 | 0 | 1/15/20 0:00 |
9 | 9 | DA 11 Park et al | Stanley, Linda | Republican | 5000 | 9/22/20 0:00 | 0 | 11/2/20 0:00 | ||
11 | 11 | DA 11 Park et al | Stanley, Linda | Republican | 5000 | 9/22/20 0:00 | 5000 | 11/16/20 0:00 | 0 | 12/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 );