UKAEA Transactions
United Kingdom Atomic Energy Authority
@ukgov.uk_atomic_energy_authority_transactions
United Kingdom Atomic Energy Authority
@ukgov.uk_atomic_energy_authority_transactions
Financial transactions of the UK Atomic Energy Authority. Published monthly.
Publisher name: United Kingdom Atomic Energy Authority
Last updated: 2022-12-24T03:10:04Z
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 -- Net Amount
);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 -- Net Amount
);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 -- Net Amount
);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 -- Net Amount
);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 -- Unnamed: 8
);CREATE TABLE ukaea_transactions_aug_2020 (
"department" VARCHAR,
"entity" VARCHAR,
"pay_date" VARCHAR,
"unnamed_3" VARCHAR -- Unnamed: 3,
"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: 8,
"unnamed_9" DOUBLE -- Unnamed: 9
);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 -- Net Amount
);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.