About this Dataset

Fundraiser Notices Filed By Hawaii Noncandidate Committees

Fundraiser Notices Filed By Hawaii Noncandidate Committees
Organization: State of Hawaii
Last updated: 2024-04-10T22:37:22.347706
Tags: campaign, campaign-spending, campaign-spending-commission, candidate, fundraiser, fundraisers, noncandidate

Tables

Fundraiser Notices Filed By Hawaii Noncandidate Committees

@usgov.state_of_hawaii_fundraiser_notices_filed_by_hawaii_non_974826e8.fundraiser_notices_filed_by_hawaii_noncandidate_committees

24.24 kB
84 rows
21 columns

CREATE TABLE fundraiser_notices_filed_by_hawaii_noncandidate_committees (
  "noncandidate_committee_name" VARCHAR,
  "person_in_charge" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "fundraiser_date" TIMESTAMP,
  "hour_time" VARCHAR  -- Hour (Time),
  "place_of_fundraiser" VARCHAR,
  "fundraiser_address_1" VARCHAR,
  "fundraiser_address_2" VARCHAR,
  "fundraiser_city" VARCHAR,
  "fundraiser_state" VARCHAR,
  "fundraiser_zip_code" VARCHAR,
  "price_or_suggested_contribution_range" VARCHAR  -- Price Or Suggested Contribution (Range),
  "price_or_suggested_contribution_max_range_if_applicable" DOUBLE  -- Price Or Suggested Contribution (Max Range, If Applicable),
  "reg_no" VARCHAR,
  "election_period" VARCHAR,
  "mapping_location" VARCHAR,
  "fundraiser_date_text" TIMESTAMP  -- Fundraiser Date (text)
);