About this Dataset

Durable Assets For Hawaii Noncandidate Committees From January 1, 2008 Through December 31, 2024

Durable Assets For Hawaii Noncandidate Committees From January 1, 2008 Through December 31, 2024
Organization: State of Hawaii
Last updated: 2025-02-21T18:32:20.779177
Tags: campaign-contributions, campaign-finance, campaign-spending, campaign-spending-commission, candidate, contributions, hawaii-candidates, political-contributions

Tables

Durable Assets For Hawaii Noncandidate Committees From January 1, 2008 Through December 31, 2024

@usgov.state_of_hawaii_durable_assets_for_hawaii_noncandidate_c52898f1.durable_assets_for_hawaii_noncandidate_committees_from_ca258bb5

95.9 KB
2043 rows
21 columns


CREATE TABLE durable_assets_for_hawaii_noncandidate_committees_from_ca258bb5 (
  "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,
  "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
);