Spend Over £25,000 In UK Sport

department_family Department Family	entity Entity	date Date	expense_type Expense Type	expense_area Expense Area	supplier Supplier	transaction_number Transaction Number	n__amount Amount
Department for Culture, Media & Sport	UK Sport	Mon Nov 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Grant	WC Events Programme	Yorkshire 2019 ltd	9786	300000
Department for Culture, Media & Sport	UK Sport	Mon Oct 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Research	Communications	Munro Market Research Ltd	27666	45842.67
Department for Culture, Media & Sport	UK Sport	Wed Nov 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Grant	Summer - Paralympic	Badminton England	19310001	49478
Department for Culture, Media & Sport	UK Sport	Wed Nov 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Grant	Summer - Olympic	Badminton England	19310002	34739
Department for Culture, Media & Sport	UK Sport	Wed Nov 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Grant	Summer - Olympic	British Basketball Federation	19310003	102186


CREATE TABLE transparency_november_2018 (
  "department_family" VARCHAR,
  "entity" VARCHAR,
  "date" TIMESTAMP,
  "expense_type" VARCHAR,
  "expense_area" VARCHAR,
  "supplier" VARCHAR,
  "transaction_number" BIGINT,
  "n__amount" DOUBLE,
  "vat_registration_number" VARCHAR
);