Trafford Council

@ukgov.trafford_council_parking_account

Table List

2 tables(33.02 KB)

Trafford-parking-account

@ukgov.trafford_council_parking_account.trafford_parking_account

28.94 KB
10 rows
32 columns

organisation_name Organisation Name	organisation_code Organisation Code	period Period	on_street_income_parking On Street Income:Parking	on_street_income_permit On Street Income:Permit	on_street_income_pcn On Street Income:PCN	on_street_income_other On Street Income:Other	on_street_income_total On Street Income:Total	on_street_costs_enforcement On Street Costs:Enforcement	on_street_costs_admin On Street Costs:Admin	on_street_costs_capital On Street Costs:Capital	on_street_costs_total On Street Costs:Total	on_street_surplus_deficit On Street Surplus/Deficit	on_street_surplus_deficit_spend_highway_maintenance On Street Surplus/Deficit Spend:Highway Maintenance	off_street_income_parking Off Street Income:Parking	off_street_income_pcn Off Street Income:PCN	off_street_income_other Off Street Income:Other	off_street_income_total Off Street Income:Total	off_street_costs_total Off Street Costs:Total	off_street_surplus_deficit Off Street Surplus/Deficit
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2014/15	180496	146889	827443	21741	1176569	476009	513177	820	990005	186562	186562	466394	NA	668	467063	196574	270489
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2015/16	264180	144656	798654	29784	1237273	451312	517711	820	969842	265679	265679	581200	NA	4944	586143	322504	263639
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2016/17	358028	156963	842298	38138	1395425	465925	417711	820	884456	510969	510971	646857	NA	1650	648507	226874	421633
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2017/18	525958	167651	895128	53801	1642537	481485	507735	15020	1004240	638297	638297	902297	NA	393	902690	143207	759483
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2018/19	542532	187329	1007700	44664	1782225	409512	470568	20606	900686	881539	881539	897961	NA	4500	902461	110741	791720
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2019/20	478949	206063	1084779	50549	1820340	459585	442705.74	17433.46	919724.2	900615.8	900615.8	640791.84	NA	16425	657216.84	283817	373399.84
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2020/21	228221	211393	636033	2592	1078239	456634	413667.26	19600.91	889902.17	188336.83	188336.83	167599.36	NA	24100	191699.36	250754.41	-59055.05
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2021/22	442374	240264	926757	43068	1652463	492228	444776.61	20596.85	957601.46	694861.54	694861.54	324326.48	NA	30000	354326.48	253231.2	101095.28
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2022/23	635744.68	252673.57	1056035.44	54426.67	1998880.36	606094.75	473484	26103.82	1105682.57	893197.79	893197.79	393910.73	NA	30000	423910.73	299127.7	124783.03
Trafford Council	https://opendatacommunities.org/id/metropolitan-district-council/trafford	2023/24	656225.51	262308.85	1249906.24	50014.13	2218454.73	746563.08	484412.54	35279.58	1266255.2	952199.53	952199.53	490681.17	NA	30264.8	520945.97	245358.64	275587.33


CREATE TABLE trafford_parking_account (
  "organisation_name" VARCHAR,
  "organisation_code" VARCHAR,
  "period" VARCHAR,
  "on_street_income_parking" DOUBLE,
  "on_street_income_permit" DOUBLE,
  "on_street_income_pcn" DOUBLE,
  "on_street_income_blue_badge" BIGINT,
  "on_street_income_other" DOUBLE,
  "on_street_income_total" DOUBLE,
  "on_street_costs_enforcement" DOUBLE,
  "on_street_costs_admin" DOUBLE,
  "on_street_costs_schemes" BIGINT,
  "on_street_costs_capital" DOUBLE,
  "on_street_costs_other" BIGINT,
  "on_street_costs_total" DOUBLE,
  "on_street_surplus_deficit" DOUBLE,
  "on_street_surplus_deficit_spend_off_street_parking" BIGINT,
  "on_street_surplus_deficit_spend_park_and_ride" BIGINT,
  "on_street_surplus_deficit_spend_supported_bus" BIGINT,
  "on_street_surplus_deficit_spend_concessionary_fares" BIGINT,
  "on_street_surplus_deficit_spend_community_transport" BIGINT,
  "on_street_surplus_deficit_spend_shopmobility" BIGINT,
  "on_street_surplus_deficit_spend_school_crossing" BIGINT,
  "on_street_surplus_deficit_spend_highway_maintenance" DOUBLE,
  "on_street_surplus_deficit_spend_transport_planning" BIGINT,
  "on_street_surplus_deficit_spend_other" BIGINT,
  "off_street_income_parking" DOUBLE,
  "off_street_income_pcn" VARCHAR,
  "off_street_income_other" DOUBLE,
  "off_street_income_total" DOUBLE,
  "off_street_costs_total" DOUBLE,
  "off_street_surplus_deficit" DOUBLE
);

Trafford Council - Parking Account

Table List

Trafford-parking-account

@ukgov.trafford_council_parking_account.trafford_parking_account

organisation_name

organisation_code

period

on_street_income_parking

on_street_income_permit

on_street_income_pcn

on_street_income_blue_badge

on_street_income_other

on_street_income_total

on_street_costs_enforcement

on_street_costs_admin

on_street_costs_schemes

on_street_costs_capital

on_street_costs_other

on_street_costs_total

on_street_surplus_deficit

on_street_surplus_deficit_spend_off_street_parking

on_street_surplus_deficit_spend_park_and_ride

on_street_surplus_deficit_spend_supported_bus

on_street_surplus_deficit_spend_concessionary_fares

on_street_surplus_deficit_spend_community_transport

on_street_surplus_deficit_spend_shopmobility

on_street_surplus_deficit_spend_school_crossing

on_street_surplus_deficit_spend_highway_maintenance

on_street_surplus_deficit_spend_transport_planning

on_street_surplus_deficit_spend_other

off_street_income_parking

off_street_income_pcn

off_street_income_other

off_street_income_total

off_street_costs_total

off_street_surplus_deficit

Share link