TfGM Spending Over £500

body_name Body Name	service_area Service Area	expense_type Expense Type	invoice_payment_date Invoice Payment Date	transaction_number Transaction Number	net_amount Net Amount	supplier_name Supplier Name
TfGM	Transport	Capital Costs - Research Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114253	6000	AECOM LTD
TfGM	Transport	Research Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114144	6481	AECOM LTD
TfGM	Transport	Insurance	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	1900056466	885.64	AMAS LTD CLIENTS ACCOUNT
TfGM	Transport	Paper and Printing Consumables	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114290	793.27	ANTALIS LTD
TfGM	Transport	Capital Costs - Engineering Support Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114387	590	APOLLO ENERGY LTD
TfGM	Transport	Capital Costs - Project Support Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114386	2722.75	APOLLO ENERGY LTD
TfGM	Transport	Capital Costs - Programme and Project Management Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114191	7901.1	ARCADIS LLP
TfGM	Transport	Design Support Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114360	59861.03	ARCADIS LLP
TfGM	Transport	Design Support Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114492	4903.17	ARCADIS LLP
TfGM	Transport	Financial and Commercial Support Services	Tue Oct 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	5100114554	2699.02	ARCADIS LLP


CREATE TABLE n_3rd_quarter_2017_18 (
  "body_name" VARCHAR,
  "service_area" VARCHAR,
  "expense_type" VARCHAR,
  "invoice_payment_date" TIMESTAMP,
  "transaction_number" BIGINT,
  "net_amount" DOUBLE,
  "supplier_name" VARCHAR
);