About this Dataset

Loans Received By Hawaii State And County Candidates From November 8, 2006 Through December 31, 2024

Loans Received By Hawaii State and County Candidates From November 8, 2006 Through December 31, 2024
Organization: State of Hawaii
Last updated: 2024-12-20T17:27:51.744930
Tags: campaign-contributions, campaign-finance, campaign-spending, campaign-spending-commission, candidate, contributions, hawaii-candidates, political-contributions

Tables

Loans Received By Hawaii State And County Candidates From November 8, 2006 Through December 31, 2024

@usgov.state_of_hawaii_loans_received_by_hawaii_state_and_cou_f4e47aa1.loans_received_by_hawaii_state_and_county_candidates_f_1360f742

69.99 kB
910 rows
22 columns

CREATE TABLE loans_received_by_hawaii_state_and_county_candidates_f_1360f742 (
  "candidate_name" VARCHAR,
  "vendor_type" VARCHAR,
  "vendor_name" VARCHAR,
  "date" TIMESTAMP,
  "acquisition_amount" DOUBLE,
  "durable_asset_description" VARCHAR,
  "disposition_amount" DOUBLE,
  "method" VARCHAR,
  "to_whom" VARCHAR,
  "durable_asset_id" BIGINT,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "office" VARCHAR,
  "district" VARCHAR,
  "county" VARCHAR,
  "party" VARCHAR,
  "reg_no" VARCHAR,
  "election_period" VARCHAR,
  "mapping_location" VARCHAR
);