Name: Grants Paid To Organisations
Creator: UK Government
License: http://reference.data.gov.uk/id/open-government-licence

About this Dataset

Grants Paid To Organisations

Grants paid to businesses, town and parish councils, voluntary, community and social enterprise organisations.
Publisher name: South Lakeland District Council
Last updated: 2022-07-01T04:04:17Z

Tables

Grants Paid To Organisations

@ukgov.grants_paid_to_organisations.grants_paid_to_organisations

27.77 kB
273 rows
18 columns

CREATE TABLE grants_paid_to_organisations (
  "extractiondate" TIMESTAMP,
  "publisherlabel" VARCHAR,
  "publisheruri" VARCHAR,
  "beneficiaryname" VARCHAR,
  "organisationtype" VARCHAR,
  "companynumber" VARCHAR,
  "charitynumber" VARCHAR,
  "awarddate" VARCHAR,
  "paymentdate" VARCHAR,
  "grantduration" VARCHAR,
  "department" VARCHAR,
  "grantprogrammename" VARCHAR,
  "totalgrantawarded" DOUBLE,
  "totalcostofproject" DOUBLE,
  "grantpaid2014_15" VARCHAR,
  "purposeofgrant" VARCHAR,
  "geoareauri" VARCHAR,
  "geoarealabel" VARCHAR
);

Grants Paid To Organisations 2018/19

@ukgov.grants_paid_to_organisations.grants_paid_to_organisations_2018_19

29.46 kB
215 rows
19 columns

CREATE TABLE grants_paid_to_organisations_2018_19 (
  "extractiondate" TIMESTAMP,
  "publisherlabel" VARCHAR,
  "publisheruri" VARCHAR,
  "beneficiaryname" VARCHAR,
  "organisationtype" VARCHAR,
  "companynumber" VARCHAR,
  "charitynumber" VARCHAR,
  "awarddate" VARCHAR,
  "paymentdate" VARCHAR,
  "grantduration" VARCHAR,
  "department" VARCHAR,
  "grantprogrammename" VARCHAR,
  "totalgrantawarded" BIGINT,
  "totalcostofproject" DOUBLE,
  "grantpaid2018_19" VARCHAR,
  "purposeofgrant" VARCHAR,
  "geoareauri_emma_to_add" VARCHAR  -- GeoAreaURI (Emma To Add),
  "geoarealabel" VARCHAR,
  "notes" VARCHAR
);