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 transactions_dec_2018 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" TIMESTAMP,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" BIGINT,
"n__net_amount" VARCHAR
);
CREATE TABLE transactions_feb_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 transactions_jan_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" TIMESTAMP,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" BIGINT,
"n__net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" TIMESTAMP,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" BIGINT,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_apr_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_apr_2021 (
"department" VARCHAR,
"organisation" VARCHAR,
"pay_date" VARCHAR,
"expense_area" VARCHAR,
"product_family" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_apr_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_aug_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"unnamed_3" VARCHAR,
"product_family" VARCHAR,
"expense_area" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_aug_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_aug_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,
"unnamed_9" DOUBLE
);
CREATE TABLE ukaea_transactions_august_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_dec_2020 (
"dpartment" 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_dec_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_december_2019 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"expense_area" VARCHAR,
"product_family" VARCHAR,
"supplier_name" VARCHAR,
"transaction_number" VARCHAR,
"net_amount" VARCHAR
);
CREATE TABLE ukaea_transactions_feb_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_feb_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_february_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_jan_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_jan_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_january_2020 (
"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_jul_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_jul_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_july_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_july_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_jun_2021 (
"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.