Dataset: Manchester Parking Account

Parking Account (February 2023)

@ukgov.manchester_parking_account.parking_account_february_2023

313.47 KB
45868 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 (April 2025)

@ukgov.manchester_parking_account.parking_account_april_2025

398.38 KB
53829 rows
8 columns


CREATE TABLE parking_account_april_2025 (
  "issued_at" VARCHAR,
  "location" VARCHAR,
  "ticket_destination" VARCHAR,
  "cont" VARCHAR,
  "status" VARCHAR,
  "paid" VARCHAR,
  "n__value" VARCHAR,
  "n__os_bal" VARCHAR
);

Parking Account (March 2021)

@ukgov.manchester_parking_account.parking_account_march_2021

212.74 KB
19950 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 (November 2022)

@ukgov.manchester_parking_account.parking_account_november_2022

306.32 KB
35211 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 (January 19)

@ukgov.manchester_parking_account.parking_account_january_19

346.67 KB
35815 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

381.89 KB
53362 rows
20 columns


CREATE TABLE parking_account_january_2023 (
  "n_01_01_2023_00_00" VARCHAR,
  "n__0_00" VARCHAR,
  "portland_street_north_east_bound" VARCHAR,
  "city_centre" VARCHAR,
  "postal_from_cctv_review_client" VARCHAR,
  "createnewpcnextended" VARCHAR,
  "bus_lane" VARCHAR,
  "n__0_00_1" VARCHAR,
  "n_34" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR
);

Parking Account (October 2022)

@ukgov.manchester_parking_account.parking_account_october_2022

294.53 KB
35926 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
);

Parking Account (March 2022)

@ukgov.manchester_parking_account.parking_account_march_2022

299.06 KB
31434 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 (September 2022)

@ukgov.manchester_parking_account.parking_account_september_2022

269.04 KB
32516 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
);

Parking Account (March 2025)

@ukgov.manchester_parking_account.parking_account_march_2025

325.64 KB
44848 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 (June 2022)

@ukgov.manchester_parking_account.parking_account_june_2022

267.71 KB
32590 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
);

Parking Account (Apr 15 - Sept 15)

@ukgov.manchester_parking_account.parking_account_apr_15_sept_15

673.34 KB
64052 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 (May 2022)

@ukgov.manchester_parking_account.parking_account_may_2022

277.04 KB
33374 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 (July 2022)

@ukgov.manchester_parking_account.parking_account_july_2022

272.79 KB
33055 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
);

Parking Account (August 2023)

@ukgov.manchester_parking_account.parking_account_august_2023

311.34 KB
38943 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

292.51 KB
27253 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 (August 2021)

@ukgov.manchester_parking_account.parking_account_august_2021

329.17 KB
34824 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 (May 19)

@ukgov.manchester_parking_account.parking_account_may_19

301.49 KB
28666 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 (September 2020)

@ukgov.manchester_parking_account.parking_account_september_2020

288.89 KB
28390 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 (May 2025)

@ukgov.manchester_parking_account.parking_account_may_2025

398.03 KB
47653 rows
8 columns


CREATE TABLE parking_account_may_2025 (
  "issued_at" VARCHAR,
  "location" VARCHAR,
  "ticket_destination" VARCHAR,
  "cont" VARCHAR,
  "status" VARCHAR,
  "paid" VARCHAR,
  "n__value" VARCHAR,
  "n__os_bal" VARCHAR
);

Parking Account (February 2022)

@ukgov.manchester_parking_account.parking_account_february_2022

240.45 KB
27952 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
);

Parking Account (April 2021)

@ukgov.manchester_parking_account.parking_account_april_2021

234.68 KB
22634 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 (August 2022)

@ukgov.manchester_parking_account.parking_account_august_2022

263.92 KB
31577 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 (February 2025)

@ukgov.manchester_parking_account.parking_account_february_2025

331.82 KB
46102 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
);

Manchester Parking Account

About this Dataset