NHM Spend Data P12
Department for Digital, Culture, Media and Sport
@ukgov.nhm_over_500_p12
NHM Spend Data P12
@ukgov.nhm_over_500_p12.nhm_spend_data_p12
2011 March Return
- 55.09 KB
- 2417 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-03-18 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000005805 | 477.0000 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000005805 | 1813.5000 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000005805 | 2872.8000 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000005805 | 3673.5000 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible F Assets - L&B - Fees | Estates Buildings | Dannatt Johnson Architects | CADPINVSM0000005806 | 8712.2600 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible Fixed Assets - Exhibi | PEG Visitor Offer Strat Non Exh Proj | Real Studios | CADPINVSM0000005800 | 4767.0000 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible Fixed Assets Fixtures | Collections Committee (Furniture) | SSI Schaefer Ltd | CADPINVSM0000005792 | 1092.9200 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | B/S - Tangible Fixed Assets Fixtures | Collections Committee (Furniture) | SSI Schaefer Ltd | CADPINVSM0000005793 | 7104.0500 | |
| DCMS | NHM | 2011-03-18 00:00:00.000 | Equipment < Ł5k | Estates Furniture | Emcor Facility Services Ltd | CADPINVSM0000005777 | 2163.3800 |
CREATE TABLE nhm_spend_data_p12 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"vat_registration_number" VARCHAR
);