About this Dataset

Campaign Spending OE Ledger CC Dataset

Campaign Spending OE Ledger CC Dataset as of December 31, 2024
Organization: State of Hawaii
Last updated: 2024-04-10T22:35:52.921380
Tags: campaign-spending-commission

Tables

Campaign Spending OE Ledger CC Dataset W/ Map

@usgov.state_of_hawaii_campaign_spending_oe_ledger_cc_dataset.campaign_spending_oe_ledger_cc_dataset_w_map

1.63 MB
34,334 rows
37 columns

CREATE TABLE campaign_spending_oe_ledger_cc_dataset_w_map (
  "schedule" VARCHAR,
  "candidate_name" VARCHAR,
  "name_id" BIGINT,
  "type" VARCHAR,
  "name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "date" TIMESTAMP,
  "amount" DOUBLE,
  "aggregated_amount" DOUBLE,
  "authorized_use" VARCHAR,
  "non_monetary" VARCHAR  -- Non-Monetary?,
  "category" VARCHAR,
  "purpose" VARCHAR,
  "office" VARCHAR,
  "district" VARCHAR,
  "county" VARCHAR,
  "party" VARCHAR,
  "reg_no" VARCHAR,
  "election_period" VARCHAR,
  "reporting_period" VARCHAR,
  "inoutstate" VARCHAR,
  "range" VARCHAR,
  "loan_source" VARCHAR,
  "repay_amount" VARCHAR,
  "id" DOUBLE,
  "forgiven" VARCHAR,
  "disposition_amount" DOUBLE,
  "to_whom" VARCHAR,
  "candidate_disclosure_form_url" VARCHAR,
  "new_georeferenced_column" VARCHAR,
  "year" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);

Campaign Spending OE Ledger CC Dataset W/ Map 2

@usgov.state_of_hawaii_campaign_spending_oe_ledger_cc_dataset.campaign_spending_oe_ledger_cc_dataset_w_map_2

1.63 MB
34,334 rows
37 columns

CREATE TABLE campaign_spending_oe_ledger_cc_dataset_w_map_2 (
  "schedule" VARCHAR,
  "candidate_name" VARCHAR,
  "name_id" BIGINT,
  "type" VARCHAR,
  "name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "date" TIMESTAMP,
  "amount" DOUBLE,
  "aggregated_amount" DOUBLE,
  "authorized_use" VARCHAR,
  "non_monetary" VARCHAR  -- Non-Monetary?,
  "category" VARCHAR,
  "purpose" VARCHAR,
  "office" VARCHAR,
  "district" VARCHAR,
  "county" VARCHAR,
  "party" VARCHAR,
  "reg_no" VARCHAR,
  "election_period" VARCHAR,
  "reporting_period" VARCHAR,
  "inoutstate" VARCHAR,
  "range" VARCHAR,
  "loan_source" VARCHAR,
  "repay_amount" VARCHAR,
  "id" DOUBLE,
  "forgiven" VARCHAR,
  "disposition_amount" DOUBLE,
  "to_whom" VARCHAR,
  "candidate_disclosure_form_url" VARCHAR,
  "new_georeferenced_column" VARCHAR,
  "year" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);