MarketBank - Retail Financial Services Demand & Potential

Category:
TypeProviders.AzureMarketPlace
Description: Consume Azure Marketplace data from MarketBank Retail Financial Services Demand & Potential. For more information, please goto https://datamarket.azure.com/dataset/13d66793-c703-4efb-9198-ca95802c0d13
Code:
type MarketBank = Microsoft.FSharp.Data.TypeProviders.ODataService< ServiceUri = @"https://api.datamarket.azure.com/RpmConsulting/MarketBank/" >

let MarketBank() =
let data = MarketBank.GetDataContext()
//To sign up for a Windows Azure Marketplace account, please go to https://datamarket.azure.com/account/info
data.Credentials<- NetworkCredential (Utils.ADM_USER_ID, Utils.ADM_ACCOUNT_ID)

query {
for b in data.MarketBank2010 do
where (b.StateAbbreviation = "WA")
sortBy (b.Id)
select b
}|> Seq.iter(fun i -> printfn "%A - %A" i.Id i.AnnuitiesPenetrationIndex)

// sample output
// "530019501001" - 113
// "530019501002" - 116
// "530019501003" - 78
// "530019501004" - 122
// "530019502001" - 132
// "530019502002" - 113
// "530019502003" - 77
// "530019503001" - 124
// ...


Execution Result:
"530019501001" - 113
"530019501002" - 116
"530019501003" - 78
"530019501004" - 122
"530019502001" - 132
"530019502002" - 113
"530019502003" - 77
"530019503001" - 124
"530019503002" - 88
"530019503003" - 77
"530019503004" - 82
"530019503005" - 60
"530019503006" - 66
"530019504001" - 70
"530019504002" - 73
"530019505001" - 89
"530019505002" - 66
"530039801001" - 103
"530039801002" - 91
"530039801003" - 120
"530039802001" - 122
"530039802002" - 121
"530039802003" - 117
"530039802004" - 121
"530039803001" - 65
"530039803002" - 90
"530039803003" - 77
"530039803004" - 91
"530039804001" - 97
"530039804002" - 81
"530039805001" - 87
"530039805002" - 78
"530039805003" - 95
"530039805004" - 112
"530039806001" - 83
"530039806002" - 117
"530039806003" - 102
"530039806004" - 119
"530050101001" - 0
"530050101002" - 195
"530050101003" - 142
"530050102011" - 167
"530050102012" - 123
"530050102013" - 129
"530050102021" - 102
"530050102022" - 141
"530050102023" - 147
"530050102024" - 86
"530050102025" - 76
"530050103001" - 120
"530050103002" - 127
"530050103003" - 143
"530050103004" - 94
"530050104001" - 87
"530050104002" - 76
"530050104003" - 76
"530050105001" - 92
"530050105002" - 108
"530050105003" - 87
"530050106001" - 91
"530050106002" - 71
"530050106003" - 65
"530050106004" - 115
"530050106005" - 207
"530050107001" - 83
"530050107002" - 98
"530050107003" - 101
"530050107004" - 108
"530050107005" - 123
"530050108011" - 151
"530050108012" - 148
"530050108013" - 125
"530050108014" - 141
"530050108015" - 137
"530050108031" - 137
"530050108032" - 71
"530050108033" - 132
"530050108041" - 164
"530050108042" - 139
"530050108043" - 128
"530050108044" - 64
"530050108045" - 92
"530050108046" - 171
"530050108047" - 88
"530050109011" - 104
"530050109012" - 169
"530050109013" - 132
"530050109014" - 73
"530050109015" - 66
"530050109016" - 35
"530050109021" - 57
"530050109022" - 72
"530050109023" - 57
"530050109024" - 130
"530050110011" - 130
"530050110012" - 83
"530050110013" - 144
"530050110014" - 157
"530050110015" - 48
"530050110016" - 55

Last edited Mar 1, 2012 at 7:05 PM by ttliu2000, version 7

Comments

No comments yet.