Trafford Council - Grants To Voluntary And Community Organisations

CREATE TABLE table_1 (
  "identifier" VARCHAR,
  "title" VARCHAR,
  "description" VARCHAR,
  "currency" VARCHAR,
  "amount_applied_for" VARCHAR,
  "amount_awarded" DOUBLE,
  "amount_disbursed" VARCHAR,
  "award_date" TIMESTAMP,
  "url" VARCHAR,
  "planned_dates_start_date" VARCHAR,
  "planned_dates_end_date" VARCHAR,
  "planned_dates_duration_months" BIGINT,
  "recipient_org_identifier" VARCHAR,
  "recipient_org_name" VARCHAR,
  "recipient_org_charity_number" DOUBLE,
  "recipient_org_company_number" VARCHAR,
  "recipient_org_street_address" VARCHAR,
  "recipient_org_city" VARCHAR,
  "recipient_org_county" VARCHAR,
  "recipient_org_country" VARCHAR,
  "recipient_org_postal_code" VARCHAR,
  "recipient_org_description" VARCHAR,
  "recipient_org_web_address" VARCHAR,
  "beneficiary_location_name" VARCHAR,
  "beneficiary_location_country_code" VARCHAR,
  "beneficiary_location_latitude" VARCHAR,
  "beneficiary_location_longitude" VARCHAR,
  "beneficiary_location_geographic_code" VARCHAR,
  "beneficiary_location_geographic_code_type" VARCHAR,
  "funding_org_identifier" VARCHAR,
  "funding_org_name" VARCHAR,
  "funding_org_department" VARCHAR,
  "grant_programme_code" VARCHAR,
  "grant_programme_title" VARCHAR,
  "grant_programme_url" VARCHAR,
  "from_an_open_call" VARCHAR,
  "related_activity" VARCHAR,
  "last_modified" TIMESTAMP,
  "data_source" VARCHAR
);

CREATE TABLE trafford_council_voluntary_sector_grants_metadata (
  "beneficiary_location_geographic_code" VARCHAR,
  "a_code_referring_to_a_geographical_area" VARCHAR,
  "n__drawn_from_an_established_gazetteer_for_example" VARCHAR,
  "n__the_code_for_a_local_authority_ward" VARCHAR,
  "n__or_parliamentary_constituency" VARCHAR
);