Parking Account (Apr 15 - Sept 15)

@ukgov.manchester_parking_account.parking_account_apr_15_sept_15

689.5 kB
64,052 rows
10 columns

CREATE TABLE parking_account_apr_15_sept_15 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "contravention" BIGINT,
  "contravention_description" VARCHAR
);

Parking Account (April 2021)

@ukgov.manchester_parking_account.parking_account_april_2021

240.32 kB
22,634 rows
9 columns

CREATE TABLE parking_account_april_2021 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "restriction" VARCHAR,
  "outstanding" VARCHAR,
  "contravention_code" DOUBLE
);

Parking Account (April 2025)

@ukgov.manchester_parking_account.parking_account_april_2025

407.95 kB
53,829 rows
8 columns

CREATE TABLE parking_account_april_2025 (
  "issued_at" VARCHAR,
  "location" VARCHAR,
  "ticket_destination" VARCHAR,
  "cont" VARCHAR  -- Cont.,
  "status" VARCHAR,
  "paid" VARCHAR,
  "n__value" VARCHAR  -- Value,
  "n__os_bal" VARCHAR  -- OS Bal
);

Parking Account (August 2021)

@ukgov.manchester_parking_account.parking_account_august_2021

337.07 kB
34,824 rows
9 columns

CREATE TABLE parking_account_august_2021 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "offence" DOUBLE
);

Parking Account (August 2022)

@ukgov.manchester_parking_account.parking_account_august_2022

270.25 kB
31,577 rows
8 columns

CREATE TABLE parking_account_august_2022 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destinatio" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "offence" VARCHAR
);

Parking Account (August 2023)

@ukgov.manchester_parking_account.parking_account_august_2023

318.81 kB
38,943 rows
8 columns

CREATE TABLE parking_account_august_2023 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "contravention" VARCHAR
);

Parking Account (February 2020)

@ukgov.manchester_parking_account.parking_account_february_2020

299.53 kB
27,253 rows
10 columns

CREATE TABLE parking_account_february_2020 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "contravention" DOUBLE,
  "contravention_description" VARCHAR
);

Parking Account (February 2022)

@ukgov.manchester_parking_account.parking_account_february_2022

246.22 kB
27,952 rows
8 columns

CREATE TABLE parking_account_february_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "cont" VARCHAR  -- Cont.
);

Parking Account (February 2023)

@ukgov.manchester_parking_account.parking_account_february_2023

320.99 kB
45,868 rows
8 columns

CREATE TABLE parking_account_february_2023 (
  "issued_time_date" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "cont" VARCHAR
);

Parking Account (February 2025)

@ukgov.manchester_parking_account.parking_account_february_2025

339.78 kB
46,102 rows
12 columns

CREATE TABLE parking_account_february_2025 (
  "issued_at" VARCHAR,
  "location" VARCHAR,
  "campaign" VARCHAR,
  "cont" VARCHAR,
  "pcn_status" VARCHAR,
  "paid_status1" VARCHAR,
  "pcn_charge" VARCHAR,
  "payments" VARCHAR,
  "refunds" VARCHAR,
  "canxamount" VARCHAR,
  "writeoff" VARCHAR,
  "os_bal" VARCHAR
);

Parking Account (January 19)

@ukgov.manchester_parking_account.parking_account_january_19

354.99 kB
35,815 rows
10 columns

CREATE TABLE parking_account_january_19 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "contravention" BIGINT,
  "contravention_description" VARCHAR
);

Parking Account (January 2023)

@ukgov.manchester_parking_account.parking_account_january_2023

391.06 kB
53,362 rows
20 columns

CREATE TABLE parking_account_january_2023 (
  "n_01_01_2023_00_00" VARCHAR  -- 01/01/2023–00:00,
  "n__0_00" VARCHAR  -- £0.00,
  "portland_street_north_east_bound" VARCHAR  -- Portland Street (North-East Bound),
  "city_centre" VARCHAR,
  "postal_from_cctv_review_client" VARCHAR  -- Postal (from Cctv Review Client),
  "createnewpcnextended" VARCHAR,
  "bus_lane" VARCHAR,
  "n__0_00_1" VARCHAR  -- £0.00.1,
  "n_34" VARCHAR  -- 34,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19
);

Parking Account (July 2022)

@ukgov.manchester_parking_account.parking_account_july_2022

279.34 kB
33,055 rows
8 columns

CREATE TABLE parking_account_july_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "cont" VARCHAR  -- Cont.
);

Parking Account (June 2022)

@ukgov.manchester_parking_account.parking_account_june_2022

274.13 kB
32,590 rows
8 columns

CREATE TABLE parking_account_june_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "cont" VARCHAR  -- Cont.
);

Parking Account (March 2021)

@ukgov.manchester_parking_account.parking_account_march_2021

217.85 kB
19,950 rows
9 columns

CREATE TABLE parking_account_march_2021 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "restriction" VARCHAR,
  "outstanding" VARCHAR,
  "contravention" DOUBLE
);

Parking Account (March 2022)

@ukgov.manchester_parking_account.parking_account_march_2022

306.23 kB
31,434 rows
8 columns

CREATE TABLE parking_account_march_2022 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destinatio" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "offence" VARCHAR
);

Parking Account (March 2025)

@ukgov.manchester_parking_account.parking_account_march_2025

333.45 kB
44,848 rows
12 columns

CREATE TABLE parking_account_march_2025 (
  "issued_at" VARCHAR,
  "location" VARCHAR,
  "campaign" VARCHAR,
  "cont" VARCHAR,
  "pcn_status" VARCHAR,
  "paid_status1" VARCHAR,
  "pcn_charge" VARCHAR,
  "payments" VARCHAR,
  "refunds" VARCHAR,
  "canxamount" VARCHAR,
  "writeoff" VARCHAR,
  "os_bal" VARCHAR
);

Parking Account (May 19)

@ukgov.manchester_parking_account.parking_account_may_19

308.72 kB
28,666 rows
10 columns

CREATE TABLE parking_account_may_19 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "contravention" BIGINT,
  "contravention_description" VARCHAR
);

Parking Account (May 2022)

@ukgov.manchester_parking_account.parking_account_may_2022

283.69 kB
33,374 rows
8 columns

CREATE TABLE parking_account_may_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding_balance" VARCHAR,
  "contravention" VARCHAR
);

Parking Account (May 2025)

@ukgov.manchester_parking_account.parking_account_may_2025

407.58 kB
47,653 rows
8 columns

CREATE TABLE parking_account_may_2025 (
  "issued_at" VARCHAR,
  "location" VARCHAR,
  "ticket_destination" VARCHAR,
  "cont" VARCHAR  -- Cont.,
  "status" VARCHAR,
  "paid" VARCHAR,
  "n__value" VARCHAR  -- Value,
  "n__os_bal" VARCHAR  -- OS Bal
);

Parking Account (November 2022)

@ukgov.manchester_parking_account.parking_account_november_2022

313.67 kB
35,211 rows
9 columns

CREATE TABLE parking_account_november_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "ceo" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "offence" VARCHAR
);

Parking Account (October 2022)

@ukgov.manchester_parking_account.parking_account_october_2022

301.6 kB
35,926 rows
8 columns

CREATE TABLE parking_account_october_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "cont" VARCHAR  -- Cont.
);

Parking Account (September 2020)

@ukgov.manchester_parking_account.parking_account_september_2020

295.83 kB
28,390 rows
9 columns

CREATE TABLE parking_account_september_2020 (
  "issued" VARCHAR,
  "paid" VARCHAR,
  "status" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "outstanding" VARCHAR,
  "offence" DOUBLE
);

Parking Account (September 2022)

@ukgov.manchester_parking_account.parking_account_september_2022

275.5 kB
32,516 rows
8 columns

CREATE TABLE parking_account_september_2022 (
  "issued_at" VARCHAR,
  "paid" VARCHAR,
  "location" VARCHAR,
  "ward" VARCHAR,
  "ticket_destination" VARCHAR,
  "zone_name" VARCHAR,
  "os_bal" VARCHAR,
  "cont" VARCHAR  -- Cont.
);

Manchester Parking Account

About this Dataset