About this Dataset

Unpaid Expenditures For Hawaii Noncandidate Committees From January 1, 2008 Through December 31, 2024

Unpaid Expenditures For Hawaii Noncandidate Committees From January 1, 2008 Through December 31, 2024
Organization: State of Hawaii
Last updated: 2024-10-11T16:31:45.127227
Tags: campaign-contributions, campaign-finance, campaign-spending, campaign-spending-commission, candidate, contributions, hawaii-candidates, political-contributions

Tables

Unpaid Expenditures For Hawaii Noncandidate Committees From January 1, 2008 Through December 31, 2024

@usgov.state_of_hawaii_unpaid_expenditures_for_hawaii_noncand_de8207fb.unpaid_expenditures_for_hawaii_noncandidate_committees_647f312f

98.2 kB
2,043 rows
21 columns

CREATE TABLE unpaid_expenditures_for_hawaii_noncandidate_committees_647f312f (
  "noncandidate_committee_name" VARCHAR,
  "vendor_type" VARCHAR,
  "vendor_name" VARCHAR,
  "date" TIMESTAMP,
  "unpaid_expenditure_amount" DOUBLE,
  "expenditure_category" VARCHAR,
  "purpose_of_expenditure" VARCHAR,
  "independent_expenditure" VARCHAR,
  "candidate_name_s" VARCHAR  -- Candidate Name(s),
  "support_oppose" VARCHAR,
  "repay_amount" DOUBLE,
  "unpaid_expenditure_id" BIGINT,
  "forgiven" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "reg_no" VARCHAR,
  "election_period" VARCHAR,
  "mapping_location" VARCHAR
);