NHM Spend Data P03
Department for Digital, Culture, Media and Sport
@ukgov.nhm_over_500_p03
NHM Spend Data P03
@ukgov.nhm_over_500_p03.nhm_spend_data_p03
2011 June Return
- 34.44 KB
- 1243 rows
- 9 columns
department_familyDepartment Family | entityEntity | dateDate | expense_typeExpense Type | expense_areaExpense Area | supplierSupplier | transaction_numberTransaction Number | amountAmount | vat_registration_numberVAT Registration Number |
|---|---|---|---|---|---|---|---|---|
| -------------------------------------------------- | -------------------------------------------------- | ----------------------- | -------------------------------------------------- | -------------------------------------------------- | -------------------------------------------------- | -------------------------------------------------- | --------------------- | -------------------------------------------------- |
| DCMS | NHM | 2011-06-07 00:00:00.000 | Agency Temporary Staff Costs | PEG Prod Special Effects | Hays Construction & Property | CADPINVSM0000006345 | 621.4400 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000006342 | 2720.2500 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000006342 | 5510.2500 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000006355 | 906.7500 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000006355 | 1836.7500 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | SVM Facilities Group Ltd | CADPINVSM0000006341 | 700.0000 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | Equipment < Ł5k | PEG Prod Special Effects | Digital View Ltd. | CADPINVSM0000006340 | 3292.0000 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | Estates Mechanical Works | Estates Engineering | Millipore (UK) Ltd | CADPINVSM0000006354 | 24.0000 | |
| DCMS | NHM | 2011-06-07 00:00:00.000 | Estates Mechanical Works | Estates Engineering | Millipore (UK) Ltd | CADPINVSM0000006354 | 394.4000 |
CREATE TABLE nhm_spend_data_p03 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"vat_registration_number" VARCHAR
);