Defra Government Procurement Card Spend - Transactions Over £500
Department for Environment, Food and Rural Affairs
@ukgov.defra_gpc_spend_over_500_pounds
Department for Environment, Food and Rural Affairs
@ukgov.defra_gpc_spend_over_500_pounds
CREATE TABLE defra_government_procurement_card_spend_transactions_over_500 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_august_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_october_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_august_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_december_2017_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_november_2017_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_february_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_may_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_march_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_october_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_may_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_december_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_april_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_august_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_february_2019_revised (
"jncc_25_02_2019_themanagementcentr_3835_2_accommodatio_f3842f27" VARCHAR,
"n__dinner_at_bangor_university_dinner_for_9_jncc_staff" VARCHAR,
"n__5_officials" VARCHAR,
"n__8_committee_members" VARCHAR,
"n__and_2_guests_accommodation_x_11_jncc_staff" VARCHAR,
"n__4_committee_members" VARCHAR,
"n__2_audit_risk_accounting_committee_members_and_1_guest" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_june_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_august_2017_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_november_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_april_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_june_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_march_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_april_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_february_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_july_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_september_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE september_2017_return_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_november_2016 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_november_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"ta" VARCHAR,
"notes" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_march_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_september_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_june_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_may_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_december_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_july_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_september_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_may_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_january_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_october_2020_revised_2 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_january_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_march_2020_revised (
"jncc_09_03_2020_amznmktplace_957_23_wireless_headset" VARCHAR,
"surface_pro_keyboard" VARCHAR,
"isopropyl_alcohol_cleaning_spray" VARCHAR,
"server_kvm_adaptors" VARCHAR,
"hard_drive_enclosures_neoprene_sleeves_x6" VARCHAR,
"replacement_iphone_headphone_adaptor" VARCHAR,
"wireless_headsets_keyboards_iphone_headset_adaptors_la_18f5958d" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_april_2019_revised (
"jncc_26_04_2019_park_avenue_hotel_belfast_4_555_50_one_ca3b5745" VARCHAR,
"n__dinner_at_park4_avenue_hotel_for_10_jncc_staff" VARCHAR,
"n__9_official_attendees" VARCHAR,
"n__11_committee_members_accommodation_x_9_jncc_staff_8_57571042" VARCHAR,
"n__1_x_1_night" VARCHAR,
"n__4_committee_members_x_2_nights" VARCHAR,
"n__x_1_night_x_2_official_attendees" VARCHAR,
"n__meeting_refreshments_x_2_days_for_10_jncc_staff" VARCHAR,
"n__11_committee_members" VARCHAR,
"n__10_guests" VARCHAR,
"n__9_official_attendees_d685ce" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_july_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_february_2020_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_october_2017_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_january_2017 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_july_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_december_2016 (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" DOUBLE,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_january_2019_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
CREATE TABLE defra_gpc_spend_over_500_june_2018_revised (
"entity" VARCHAR,
"gl_date" TIMESTAMP,
"merchant_name" VARCHAR,
"amount" VARCHAR,
"description" VARCHAR
);
Anyone who has the link will be able to view this.