Wiltshire Council Open Data

Data

Published by: Wiltshire Council
Categories: Government
Date added: 5/2/2012
Get support for this offering

Wiltshire Council publishes a number of data services that provide up to date data on its spending, procurement and the salaries of senior management.

Service root URL

https://api.datamarket.azure.com/wiltscouncil/WiltshireCouncilOpenData/v1/

This service supports both fixed and flexible query. Some queries may include required input parameters. (learn more about query types)

CreditCardSpending

Input parameters:

Name Sample values Type Required
Body String
BodyName String
CardDescription String
CardholderReference String
CycleRef DateTime
ForeignCurrency String
ForeignCurrencyAmount Double
HomeCurrency String
MerchantCity String
MerchantName String
Name String
PostingDate DateTime
TransactionAmount Double
TransactionDate DateTime
UniqueID Int32

Results:

Name Type
Body String
BodyName String
CardDescription String
CardholderReference String
CycleRef DateTime
ForeignCurrency String
ForeignCurrencyAmount Double
HomeCurrency String
MerchantCity String
MerchantName String
Name String
PostingDate DateTime
TransactionAmount Double
TransactionDate DateTime
UniqueID Int32

PaymentsOverFiveHundredPounds

Input parameters:

Name Sample values Type Required
Amount Double
BVACOP String
CostCentre Int32
Date DateTime
ExpenseArea String
ExpenseCode String
ExpenseType String
ExtendedDescription String
InvoiceID String
PostCode String
PROCLASS String
RevenueOrCapital String
SupplierID Int32
SupplierName String
TransactionID String
UniqueID Int32
VATRegNum String

Results:

Name Type
Amount Double
BVACOP String
CostCentre Int32
Date DateTime
ExpenseArea String
ExpenseCode String
ExpenseType String
ExtendedDescription String
InvoiceID String
PostCode String
PROCLASS String
RevenueOrCapital String
SupplierID Int32
SupplierName String
TransactionID String
UniqueID Int32
VATRegNum String

SalariesAndExpenses

Input parameters:

Name Sample values Type Required
CapitalBudget Double
Date DateTime
Employees Int32
Expenses Double
FiveKBand String
FTECeiling Double
FTEFloor Double
FTEMin Double
GrossBudget Double
JobDescription String
JobTitle String
Name String
RevenueBudget Double
SAPNumber Int32
ServiceArea String
TotalBudget Double
UniqueID Int32

Results:

Name Type
CapitalBudget Double
Date DateTime
Employees Int32
Expenses Double
FiveKBand String
FTECeiling Double
FTEFloor Double
FTEMin Double
GrossBudget Double
JobDescription String
JobTitle String
Name String
RevenueBudget Double
SAPNumber Int32
ServiceArea String
TotalBudget Double
UniqueID Int32
This data is published and can be used under the terms of the Open Government License. Please see http://data.gov.uk/terms-conditions.

Not available in your market

Resources

  • Microsoft PowerPivot For Excel 2010

    Learn how to use Microsoft PowerPivot for Excel 2010, with this and other DataMarket data, to create compelling self-service BI solutions.

  • Tableau Software

    Learn how to visualize this and other DataMarket datasets in Tableau. Tableau’s rapid fire business intelligence solution provides best-in-class data visualization and web dashboards anyone can use.

  • Learn How To Use This Data In Visual Studio

    Learn how to seamlessly consume DataMarket data in Visual Studio with strongly-typed data access and full IntelliSense support to ease development.