About this Dataset

Unpaid Expenditures For Hawaii State And County Candidates From November 8, 2006 Through December 31, 2024

Unpaid Expenditures For Hawaii State and County Candidates From November 8, 2006 Through December 31, 2024
Organization: State of Hawaii
Last updated: 2024-10-11T16:31:51.987052
Tags: campaign-contributions, campaign-finance, campaign-spending, campaign-spending-commission, candidate, contributions, hawaii-candidates, political-contributions

Tables

Unpaid Expenditures For Hawaii State And County Candidates From November 8, 2006 Through December 31, 2024

@usgov.state_of_hawaii_unpaid_expenditures_for_hawaii_state_a_792fc334.unpaid_expenditures_for_hawaii_state_and_county_candid_20c0e834

388.02 KB
8562 rows
23 columns


CREATE TABLE unpaid_expenditures_for_hawaii_state_and_county_candid_20c0e834 (
  "candidate_name" VARCHAR,
  "vendor_type" VARCHAR,
  "vendor_name" VARCHAR,
  "date" TIMESTAMP,
  "unpaid_expenditure_amount" DOUBLE,
  "authorized_use" VARCHAR,
  "expenditure_category" VARCHAR,
  "purpose_of_expenditure" VARCHAR,
  "repay_amount" DOUBLE,
  "unpaid_expenditure_id" BIGINT,
  "forgiven" VARCHAR,
  "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
);