Members Allowances
Lincolnshire County Council
@ukgov.members_allowances3
Lincolnshire County Council
@ukgov.members_allowances3
CREATE TABLE members_allowances (
"organisationlabel" VARCHAR,
"organisationuri" VARCHAR,
"publisheddate" TIMESTAMP,
"latestdata" VARCHAR,
"durationfrom" TIMESTAMP,
"durationto" TIMESTAMP,
"reportingperiodtype" VARCHAR,
"financialyear" VARCHAR,
"membertype" VARCHAR,
"membername" VARCHAR,
"politicalparty" VARCHAR,
"co_optedmembersallowance" VARCHAR,
"basicallowance" DOUBLE,
"specialresponsibility" DOUBLE,
"travelexpenses" DOUBLE,
"subsistencetaxable" DOUBLE,
"subsistencenontaxable" DOUBLE,
"fares" DOUBLE,
"childcareanddependantcarers" DOUBLE,
"total" DOUBLE,
"notes" VARCHAR
);
CREATE TABLE table_2 (
"dataset_id_dsid" BIGINT,
"dataset_name" VARCHAR,
"field" VARCHAR,
"type" VARCHAR,
"mandatory_or_optional_requirement_mor" VARCHAR,
"field_description" VARCHAR,
"schema" VARCHAR,
"lcc_mapping" VARCHAR,
"schema_comments" VARCHAR,
"schema_data_rules_comment" VARCHAR,
"formatreference" VARCHAR,
"example" VARCHAR
);
Anyone who has the link will be able to view this.