NHM Spend Data P04
Department for Digital, Culture, Media and Sport
@ukgov.nhm_over_500_p04
NHM Spend Data P04
@ukgov.nhm_over_500_p04.nhm_spend_data_p04
2011 July Return
- 40.33 KB
- 1564 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-07-07 00:00:00.000 | B/S - Tangible Fixed Assets - Exhibi | PEG Visitor Offer Strat Non Exh Proj | Schofield Lothian | CADPINVMIZR00000111 | 1787.5000 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Elec & Mech Contract Services | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000102 | 2170.7200 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Elec Works | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000096 | 506.2500 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Elec Works | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000106 | 548.9700 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Est RoutineMaint - Day to day Maint | Estates Buildings | Emcor Facility Services Ltd | CADPINVMIZR00000097 | 981.0000 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Estates Mechanical Works | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000099 | 5010.8400 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Estates Mechanical Works | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000100 | 2543.5200 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Estates Mechanical Works | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000103 | 1521.6400 | |
| DCMS | NHM | 2011-07-07 00:00:00.000 | Estates Mechanical Works | Estates Engineering | Emcor Facility Services Ltd | CADPINVMIZR00000104 | 1179.3800 |
CREATE TABLE nhm_spend_data_p04 (
"department_family" VARCHAR,
"entity" VARCHAR,
"date" VARCHAR,
"expense_type" VARCHAR,
"expense_area" VARCHAR,
"supplier" VARCHAR,
"transaction_number" VARCHAR,
"amount" VARCHAR,
"vat_registration_number" VARCHAR
);