WasteDataFlow - Local Authority Waste Management

this_contains_subject_to_change_for_the_selected_autho_9a2a5b03 This File Contains Data (subject To Change) For The Selected Authorities And Periods Only If Returns Have Been Completed.	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	unnamed_9 Unnamed: 9	unnamed_10 Unnamed: 10	unnamed_11 Unnamed: 11	unnamed_12 Unnamed: 12	unnamed_13 Unnamed: 13	unnamed_14 Unnamed: 14	unnamed_15 Unnamed: 15	unnamed_16 Unnamed: 16	unnamed_17 Unnamed: 17	unnamed_18 Unnamed: 18	unnamed_19 Unnamed: 19	unnamed_20 Unnamed: 20	unnamed_21 Unnamed: 21	unnamed_22 Unnamed: 22	unnamed_23 Unnamed: 23	unnamed_24 Unnamed: 24	unnamed_25 Unnamed: 25	unnamed_26 Unnamed: 26	unnamed_27 Unnamed: 27	unnamed_28 Unnamed: 28	unnamed_29 Unnamed: 29	unnamed_30 Unnamed: 30	unnamed_31 Unnamed: 31	unnamed_32 Unnamed: 32	unnamed_33 Unnamed: 33	unnamed_34 Unnamed: 34
WasteProcessorId	WasteStreamId	WasteProcessorOutputId	SenderWasteProcessorOutputId	Authority	AuthorityId	Period	PeriodId	WasteStreamTypeId	WasteStreamType	FacilityTypeId	FacilityType	NationalFacilityId	FacilityName	FacilityAddress	FacilityPostCode	FacilityLicence	FacilityCode	OutputProcessTypeId	OutputProcessType	TotalTonnes	MaterialId	Material	TonnesByMaterial	TonnesFromHHSources	TonnesFromCommercialSources	TonnesFromIndustrialSources	TonnesFromNonHHSources	TonnesFromWfHSources	TonnesFromWnfHSources	UsageId	Usage	QuarterlyComments	MonthlyComments	MaterialGroup
3037990	3037009	0	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	16	Reprocessor - recycling (qu19)	3232	U R M ( U K ) Limited	49 Lidgate Crescent, Langthwaite Grange Ind, South Kirkby, West Yorkshire	WF9 3NR	61833 / FP3198ZN		0		518.42	6	Mixed glass	518.42							0				Glass
3037990	3037009	9766992	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	22	Final Destination	0						1	Dry recyclate	518.42	6	Mixed glass	518.42							0				Glass
3037991	3037021	0	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	16	Reprocessor - recycling (qu19)	7932	Other/Exempt	Tyre Rec, Unit 10, Brunnel Rd, Essex, SS7 4PS,		N/A		0		14.45	53	Car tyres	14.45							0				Tyres
3037991	3037021	9766993	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	22	Final Destination	0						1	Dry recyclate	14.45	53	Car tyres	14.45							0				Tyres
3037992	3037024	0	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	16	Reprocessor - recycling (qu19)	7932	Other/Exempt	Mid UK Recycling Ltd, Summit House, Quarrington, Sleaford, Lincolnshire NG34 8RT,		N/A		0		127.38	77	Carpets	127.38							0				Textiles
3037992	3037024	9766994	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	22	Final Destination	0						1	Dry recyclate	127.38	77	Carpets	127.38							0				Textiles
3037993	3037022	0	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	16	Reprocessor - recycling (qu19)	7932	Other/Exempt	Cylinder Care, Richmond House, Garforth, Leeds, LS25 1NB ,		N/A		0		4.98	63	Gas bottles	4.98							0				Metal
3037993	3037022	9766995	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	22	Final Destination	0						1	Dry recyclate	4.98	63	Gas bottles	4.98							0				Metal
3037994	3037012	0	0	Luton Borough Council	1	Apr 18 - Jun 18	289	1	Source segregated recyclate	16	Reprocessor - recycling (qu19)	7932	Other/Exempt	Living Fuels, Freedom Farm, Cowles Drove, Hockwold-cum-Wilton, Nr Thetford, Norfolk, IP26 4JQ,		N/A		0		0	0		0							0


CREATE TABLE q100_waste_collection_data_england_2018_19 (
  "this_contains_subject_to_change_for_the_selected_autho_9a2a5b03" 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,
  "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,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR
);