school_board_loans
4 rows where candidate = "GEARHART, TYLER" and district = "ST. VRAIN VALLEY RE 1J"
This data as json, CSV (advanced)
Suggested facets: loan_amount, loan_balance, filed_date
Link | rowid ▼ | district | candidate | loan_amount | loan_date | payment_amount | payment_date | loan_balance | filed_date |
---|---|---|---|---|---|---|---|---|---|
54 | 54 | ST. VRAIN VALLEY RE 1J | GEARHART, TYLER | 2005.0 | 8/24/21 | 2005.0 | 9/7/21 | ||
55 | 55 | ST. VRAIN VALLEY RE 1J | GEARHART, TYLER | -2005.0 | 8/24/21 | -2005.0 | 10/18/21 | ||
56 | 56 | ST. VRAIN VALLEY RE 1J | GEARHART, TYLER | 88.51 | 8/24/21 | 0.0 | 10/18/21 | ||
57 | 57 | ST. VRAIN VALLEY RE 1J | GEARHART, TYLER | 88.51 | 8/24/21 | 88.51 | 10/18/21 | 0.0 | 10/18/21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "school_board_loans" ( "district" TEXT, "candidate" TEXT, "loan_amount" REAL, "loan_date" TEXT, "payment_amount" REAL, "payment_date" TEXT, "loan_balance" REAL, "filed_date" TEXT );