Litter Fines Issued By 3GS

Leeds City Council

@ukgov.litter_fines_issued_by_3gs

Table List

2 tables(54.84 KB)

January - March 2021

2020

January - March 2021

@ukgov.litter_fines_issued_by_3gs.january_march_2021

6.92 KB
16 rows
9 columns

fpn_detail FPN Detail	unnamed_1 Unnamed: 1	unnamed_2 Unnamed: 2	unnamed_3 Unnamed: 3	unnamed_4 Unnamed: 4	unnamed_5 Unnamed: 5	unnamed_6 Unnamed: 6	unnamed_7 Unnamed: 7	unnamed_8 Unnamed: 8
Client	Status	Amount(Ł)	Issuer	Issue Datetime	Breach Reason	Breach Location	Paid At	Paid Amount(Ł)
Leeds City Council	Complete	80	143	04/01/2021 07:41	EP87 - Cigarette (Littering )	Bond Street	05/01/2021 09:45	80
Leeds City Council	Complete	100	181	04/01/2021 11:40	EP87 - Cigarette (Littering )	Commercial Street	04/02/2021 13:45	100
Leeds City Council	Pending Prosecution	100	143	04/01/2021 11:44	EP87 - Cigarette (Littering )	Albion Street near Boots
Leeds City Council	Cancelled	80	235	04/01/2021 12:22	EP87 - Cigarette (Littering )	Lands Lane
Leeds City Council	Complete	80	235	04/01/2021 12:25	EP87 - Cigarette (Littering )	Lands Lane	08/01/2021 12:06	80
Leeds City Council	Complete	80	143	04/01/2021 12:43	EP87 - Cigarette (Littering )	Merrion Way near Costa	14/01/2021 17:49	80
Leeds City Council	Complete	80	203	04/01/2021 12:59	EP87 - Cigarette (Littering )	Commercial Street	04/01/2021 17:46	80
Leeds City Council	Pending Prosecution	100	181	04/01/2021 13:05	EP87 - Cigarette (Littering )	Albion Street
Leeds City Council	Complete	80	181	04/01/2021 13:19	EP87 - Cigarette (Littering )	Bond Street	13/01/2021 11:44	80


CREATE TABLE january_march_2021 (
  "fpn_detail" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "unnamed_8" VARCHAR
);