Payments To The 3rd Sector
Leeds City Council
@ukgov.payments_to_the_3rd_sector1
Leeds City Council
@ukgov.payments_to_the_3rd_sector1
CREATE TABLE n_2012_13 (
"bodyname" VARCHAR,
"servicelabel" VARCHAR,
"servicecode" BIGINT,
"servicedivisionlabel" VARCHAR,
"servicedivisioncode" BIGINT,
"organisationalunit" VARCHAR,
"expenditurecategory" VARCHAR,
"cipfadetailed_expendituretype" VARCHAR,
"date" VARCHAR,
"netamount" DOUBLE,
"capitalandrevenue" VARCHAR,
"suppliername" VARCHAR
);
CREATE TABLE n_2013_14 (
"organisationname" VARCHAR,
"organisationcode" VARCHAR,
"effectivedate" TIMESTAMP,
"directorateservice" VARCHAR,
"suppliername" VARCHAR,
"paymentdate" TIMESTAMP,
"transactionnumber" BIGINT,
"netamount" DOUBLE,
"irrecoverablevat" BIGINT,
"purposeofspend" VARCHAR,
"councilprocurementcategoryname" VARCHAR
);
CREATE TABLE n_2014_15 (
"organisationname" VARCHAR,
"organisationcode" VARCHAR,
"effectivedate" TIMESTAMP,
"directorateservice" VARCHAR,
"suppliername" VARCHAR,
"paymentdate" TIMESTAMP,
"transactionnumber" BIGINT,
"netamount" DOUBLE,
"irrecoverablevat" BIGINT,
"purposeofspend" VARCHAR,
"councilprocurementcategoryname" VARCHAR
);
CREATE TABLE n_2015_16 (
"organisationname" VARCHAR,
"organisationcode" VARCHAR,
"effectivedate" TIMESTAMP,
"directorateservice" VARCHAR,
"suppliername" VARCHAR,
"paymentdate" VARCHAR,
"transactionnumber" BIGINT,
"netamount" DOUBLE,
"irrecoverablevat" DOUBLE,
"purposeofspend" VARCHAR,
"councilprocurementcategoryname" VARCHAR
);
CREATE TABLE n_2016_17 (
"organisation" VARCHAR,
"effective_date" TIMESTAMP,
"directorate" VARCHAR,
"supplier_name" VARCHAR,
"payment_date" VARCHAR,
"transaction_number" BIGINT,
"n__amount" VARCHAR,
"purpose_of_spend" VARCHAR,
"category_name" VARCHAR
);
CREATE TABLE n_2017_18 (
"organisation" VARCHAR,
"directorate" VARCHAR,
"pay_date" TIMESTAMP,
"amount_sum" DOUBLE,
"supplier_name" VARCHAR,
"type_of_expenditure" VARCHAR,
"category_name" VARCHAR
);
CREATE TABLE n_2018_19 (
"organisation" VARCHAR,
"directorate" VARCHAR,
"pay_date" VARCHAR,
"amount_sum" DOUBLE,
"supplier_name" VARCHAR,
"type_of_expenditure" VARCHAR,
"category_name" VARCHAR
);
Anyone who has the link will be able to view this.