UKAEA Transactions
United Kingdom Atomic Energy Authority
@ukgov.uk_atomic_energy_authority_transactions
United Kingdom Atomic Energy Authority
@ukgov.uk_atomic_energy_authority_transactions
CREATE TABLE ukaea_transactions_jun_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" DOUBLE
);
CREATE TABLE ukaea_transactions_june_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_june_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_mar_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_mar_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_mar_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" DOUBLE
);
CREATE TABLE ukaea_transactions_march_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_may_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"n__net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_may_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_may_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_may_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"net_amount" DOUBLE,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR
);
CREATE TABLE ukaea_transactions_nov_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_nov_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" DOUBLE
);
CREATE TABLE ukaea_transactions_november_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_oct_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_oct_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" DOUBLE
);
CREATE TABLE ukaea_transactions_oct_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" DOUBLE
);
CREATE TABLE ukaea_transactions_october_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_sep_2020 (
"department" VARCHAR,
"entitiy" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_sep_2021 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"transaction_number" VARCHAR,
"supplier_name" VARCHAR,
"net_amount" DOUBLE
);
CREATE TABLE ukaea_transactions_sep_2022 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" DOUBLE,
"unnamed_8" VARCHAR
);
CREATE TABLE ukaea_transactions_september_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
Anyone who has the link will be able to view this.