This project is read-only.
Lawyers.com - Consumer Legal Articles

Category:
TypeProviders.AzureMarketPlace
Description: Consume Azure Marketplace data from Lawyers.com Consumer Legal Articles. For more information, please goto https://datamarket.azure.com/dataset/4306e828-ad35-4049-b9a9-4e4824cc37e8
Code:
[<Generate>]
type Lawyers = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/LexisNexis/ConsumerLegalArticles/" >

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

query {
for a in articles.Articles do
where (a.State = "Washington")
select a
}|> Seq.iter(fun i -> printfn "%A" i.Title)

// sample output
// "WA Witnesses at a Small Claims Trial"
// "WA Alternatives to Small Claims Court"
// "WA After Small Claims Court"
// "Estate Planning in Washington State (WA)"
// "Washington Expungement and Record Sealing"
// "Selling a House in Washington"
// "Washington Statutes of Limitations"
// "Criminal Process in Washington State (WA)"
// ...


Execution Result:
"WA Witnesses at a Small Claims Trial"
"WA Alternatives to Small Claims Court"
"WA After Small Claims Court"
"Estate Planning in Washington State (WA)"
"Washington Expungement and Record Sealing"
"Selling a House in Washington"
"Washington Statutes of Limitations"
"Criminal Process in Washington State (WA)"
"Personal Injury in the State of Washington (WA)"
"WA Collecting the Judgment"
"Divorce in Washington State (WA)"
"Washington Traffic Violations"
"Buying a House in Washington (WA)"
"WA Small Claims Trials"
"WA What Is Small Claims Court?"
"WA Filing a Small Claims Suit"
"Washington Small Claims"
"Employment Law in Washington State"
"Bankruptcy in Washington State"

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:
[<Generate>]

type MarketBank = Microsoft.FSharp.Data.TypeProviders.ODataService//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

BranchInfo - U.S. Bank Branch Locations, History & Performance Database

Category:
TypeProviders.AzureMarketPlace
Description: BranchInfo™ 2011 is a historical database of every bank branch location in the U.S. containing information matched by institution and site, across a five-year timeframe. For more information, please goto https://datamarket.azure.com/dataset/36c385f2-5903-4335-af09-294e3043839f
Code:
[<Generate>]

type BankInfo = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/RpmConsulting/BranchInfo">

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

query {
for b in bank.BranchInfo2011 do
where (b.BranchState = "WA")
where (b.BranchZip = "98052")
select b
}|> Seq.iter(fun i -> printfn "%A - %A" i.BranchName i.BranchDeposits)

// sample output
// "Washington Federal S & L Association " - 1000788M
// "Redmond Branch " - 1000788M
// "Overlake Safeway Branch " - 925095M
// "Overlake Park Branch " - 883017M
// "Redmond Branch " - 1000788M
// "North Redmond Branch " - 965031M
// "Bel-Red Branch " - 987997M
// ...


Execution Result:
"Washington Federal S & L Association    " - 1000788M
"Washington Federal S & L Association " - 1000788M
"Redmond Branch " - 1000788M
"Overlake Safeway Branch " - 925095M
"Overlake Park Branch " - 883017M
"Redmond Branch " - 1000788M
"North Redmond Branch " - 965031M
"Bel-Red Branch " - 987997M
"Bear Creek Branch " - 1000788M
"Redmond Branch " - 965031M
"Overlake Park Branch " - 925095M
"Redmond Branch " - 987102M
"Redmond Branch " - 987102M
"Redmond " - 965031M
"Redmond Branch " - 987102M
"Avondale Branch " - 754616M
"Redmond " - 883017M
"Redmond Branch " - 987102M
"Redmond Branch " - 546681M
"Redmond Branch " - 965031M

Data.Gov - 2006-2008 Crime in the United States (Data.gov)

Category:
TypeProviders.AzureMarketPlace
Description: Consume Azure Marketplace crime data from Data.gov. For more information, please goto https://datamarket.azure.com/dataset/c663117f-db6d-49e1-bc83-b05390bb3c70
Code:
[<Generate>]

type C = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/data.gov/Crimes">

let DataGov() =
let crime = new C.ServiceTypes.datagovCrimesContainer()
//To sign up for a Windows Azure Marketplace account, please go to https://datamarket.azure.com/account/info
crime.Credentials<- NetworkCredential (Utils.ADM_USER_ID, Utils.ADM_ACCOUNT_ID)

// compare different property crime rates for cities around microsoft
query {
for m in crime.CityCrime do
where (m.City = "Redmond" || m.City = "Kirkland" || m.City = "Bellevue" || m.City = "Seattle" )
where (m.State = "Washington")
where (m.Year = 2008)
sortBy (m.City)
} |> Seq.map ( fun c -> (c.City, (float c.Burglary + float c.PropertyCrime) / float c.Population * 100.0))
|> Seq.sortBy(fun d -> snd d )
|> Seq.toList
|> printfn "%A"

// sample output
// [("Redmond", 3.717874241); ("Bellevue", 4.063400812); ("Kirkland", 4.584304584);
// ("Seattle", 6.574905907)]


Execution Result:
[("Redmond", 3.717874241); ("Bellevue", 4.063400812); ("Kirkland", 4.584304584);
("Seattle", 6.574905907)]

ESRI - 2010 Key US Demographics by ZIP Code, Place and County (Trial)

Category:
TypeProviders.AzureMarketPlace
Description: 2010 Key US Demographics by ZIP Code, Place, and County Data is a select offering of the demographic data required to understand a market. For more information, please goto https://datamarket.azure.com/dataset/c7154924-7cab-47ac-97fb-7671376ff656
Code:
[<Generate>]

type D = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/Esri/KeyUSDemographicsTrial/">

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

query {
for c in pl.demog1 do
where (c.StateName = "Washington")
where (c.CountyName = "King County")
sortBy c.GeographyId
} |> Seq.filter (fun i -> match i.GeographyName.Trim().ToLower() with
| "redmond" -> true
| "bellevue" -> true
| "kirkland" -> true
| _ -> false)
|> Seq.iter (fun i -> printfn "%A - %A" i.GeographyId i.PerCapitaIncome2010.Value )

// sample output
// "98004" - 58631
// "98005" - 44672
// "98006" - 51553
// "98007" - 36689
// "98008" - 43038
// "98033" - 55849
// "98034" - 39577
// "98052" - 47359
// "98053" - 47164


Execution Result:
"98004" - 58631
"98005" - 44672
"98006" - 51553
"98007" - 36689
"98008" - 43038
"98033" - 55849
"98034" - 39577
"98052" - 47359
"98053" - 47164

LexisNexis - Legal Communities

Category:
TypeProviders.AzureMarketPlace
Description: Content from the LexisNexis Legal Communities including expert commentary on current legal issues as well as timely podcasts. For more information, please goto https://datamarket.azure.com/dataset/101eb297-c17f-4f22-a844-16ca2e52252d
Code:
[<Generate>]

type L = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/LexisNexis/LegalCommunities/">

let LexisNexis() =
let legal = new L.ServiceTypes.LexisNexisLegalCommunitiesContainer()
//To sign up for a Windows Azure Marketplace account, please go to https://datamarket.azure.com/account/info
legal.Credentials<- NetworkCredential (Utils.ADM_USER_ID, Utils.ADM_ACCOUNT_ID)

query {
for m in legal.CommunityContent do
where (m.DatePublished > System.DateTime(2011, 1, 1))
select m
} |> Seq.iter (fun i -> printfn "%A - %A" i.Author i.Title )

// sample output
// "Ted Connolly" - "What Do Credit Scores Tell Lenders About Us That We Don’t Know?"
// "Patrick McCraney" - "Distressed Investors May Feel a Chill in the Air"
// "Arina Shulga" - "Doing Business in Russia"
// "George Pressly" - "SEC Whistleblowers can Help Uncover "Soft Dollar" Practices"
// "Francis G.X. Pileggi" - "Key Delaware Corporate and Commercial Decisions in 2010 "
// "Thomas O. Gorman" - "SEC Enforcement Trends 2011"
// ...



Execution Result:
"Ted Connolly" - "What Do Credit Scores Tell Lenders About Us That We Don’t Know?"
"Patrick McCraney" - "Distressed Investors May Feel a Chill in the Air"
"Arina Shulga" - "Doing Business in Russia"
"George Pressly" - "SEC Whistleblowers can Help Uncover "Soft Dollar" Practices"
"Francis G.X. Pileggi" - "Key Delaware Corporate and Commercial Decisions in 2010 "
"Thomas O. Gorman" - "SEC Enforcement Trends 2011"
"Kevin M. LaCroix" - "A Closer Look at the 2010 Securities Lawsuit Filings "
"Thomas Fox" - "Private Equity and the FCPA"
"Jonathan Zavin" - "Architecture firm allowed to use projected future profits in calculating copyright/design infringement award: Looney Ricks Kiss Architects, Inc. v. Bryan"
"Norman Clark" - "I hope that I am wrong, but…"
"Jayne Navarre" - "Navigating The Social Web | A Very Large Marketplace"
"Jim Hassett" - "Six steps to better budgets (Part 1 of 2)"
"Thomas H. Clarke, Jr." - "California's OEHHA sets a Public Health Goal for Chrome-6 at 0.02 ppb"
"Stephen Sather" - "Supreme Court Grapples With the Meaning of the Means Test"
"Kevin M. LaCroix" - "FDIC's Bid to Intervene in Bank Investors' Suit Denied "
"Thomas O. Gorman" - "SEC Enforcement Trends 2011: Market Reform"
"Thomas Fox" - "Questions, Questions and More Questions: Foreign Courts and the FCPA"
"Doug Cornelius" - "Private Equity Portfolio Companies and Bribery Charges"
"Kevin M. LaCroix" - "Under Morrison, Section 10(b) Does Not Apply to Swap Transactions in U.S Referencing Non-U.S. Securities "
"Arina Shulga" - "SEC Inquires Into Secondary Trading Activities By Large Private Companies "
"David R. Schoenhaar" - "Gifting in 2011"
"Thomas O. Gorman" - "The N.Y. Attorney General’s Lawsuit Against E&Y: Substance vs. Form"
"Kevin M. LaCroix" - "Some Questions About the N.Y. AG's Lehman-Related Complaint Against E&Y "
"Randy J. Maniloff" - "For Insurers In Pennsylvania, Courts Continue to Sing The Praises Of Kvaerner And Gambone"
"Scott A. McKeown" - "CAFC Slates Patent Reexamination/Reissue Disputes for Early 2011 Resolution"
"Scott A. McKeown" - "Admissions & Patent Reexamination Requests"
"Stephen Sather" - "Judge Rules That Home is Where the Heart Is "
"Vetstein Law Group, P.C. " - "Massachusetts Real Estate Law Year In Review & Outlook For 2011"
"Norman Clark" - "Oops…ouch!"
"Sunstein Kann Murphy & Timbers LLP" - "Business Method Claims after Bilski: The Federal Circuit Weighs in on Abstractness"
"Jayne Navarre" - "Content and Community | What I’m doing with social media in 2011"
"Thomas O. Gorman" - "Dodd-Frank: Too Many Regulations Too Fast?"
"Jim Hassett" - "Six steps to better budgets (Part 2 of 2)"
"Doug Cornelius" - "The SEC, Funding, and Rulemaking"
"Thomas Fox" - "Franchising and the FCPA"
"Sunstein Kann Murphy & Timbers LLP" - "Jingle All the Way…To the Tune of $1.3 Billion: Oracle Wins Largest-Ever Copyright Infringement Award"
"Deirdre R. Wheatley-Liss" - "Transfer Taxes--Now on "Sale""
"Randy J. Maniloff" - "If You Build It, He Will Come (And Sue You)"
"Kevin M. LaCroix" - "The Top Ten D&O Stories of 2010"
"Thomas O. Gorman" - "Alcantel-Lucent Settles FCPA Cases"
"Randy J. Maniloff" - "If You Build It, He Will Come (And Sue You)"
"Bullivant Houser Bailey PC" - "Theft of Money is not "Loss of Use" Under a Commercial General Liability Policy"
"Thomas H. Clarke, Jr." - "California sets forth indicators of disproportionate impacts of climate change on environmental justice communities"
"E. Lynn Grayson" - "Vermont Law Top 10 Environmental Watch List 2011"
"Stephen Sather" - "Diocese of Milwaukee Seeks Chapter 11 Protection From Sexual Abuse Claims "
"Thomas O. Gorman" - "SEC Enforcement Trends 2011: Reogranization"
"Doug Cornelius" - "Facebook, Capital and Liquidity"
"Kevin M. LaCroix" - "News Updates for the New Year "
"Thomas Fox" - "More Than Just the FCPA and Bribery Act – The Local Battle Against Corruption"
"LexisNexis Patent Law Center Staff" - "President signs legislation to establish a pilot program in certain United States district courts to encourage enhancement of expertise in patent cases among district judges"
"Bullivant Houser Bailey PC" - "New Year's Resolution: Protect Your Confidential Shipping Data at U.S. Ports of Entry"
"Randy J. Maniloff" - "For Insurers In Pennsylvania, Courts Continue to Sing The Praises Of Kvaerner And Gambone"
"LexisNexis Environmental Law Community Staff" - "2010 Ends with a Flurry of Activity on Greenhouse Gas Regulatory & Litigation Fronts"
"Keller and Heckman LLP" - "Advertising and Food and Drug Law Report: Consent Orders Provoke Debate Over FTC and FDA Substantiation Standards"
"Cassandra Roberts" - "Permanency in Delaware: Rodgers is from Venus, Gelman from Mars"
"LexisNexis Workers' Comp Fraud Team" - "Workers' Comp Fraud Blotter - Recent Arrests, Charges, Convictions, and Investigations (1/6/2011)"
"Kevin M. LaCroix" - "Barclays' Subprime Related Securities Suit Dismissed "
"Francis G.X. Pileggi" - "Delaware Supreme Court Dismisses Claims Against PricewaterhouseCoopers "
"Francine McKenna" - "PricewaterhouseCoopers Prevails In Decision On AIG “In Pari Delicto” Case"
"Jayne Navarre" - "Facebook | Does the goldrush mentality on Wall Street have implications for law firm marketing?"
"Keller and Heckman LLP" - "Telecom Business Alert -- Vol. VIII Issue 1"
"LexisNexis Environmental Law Community Staff" - "EPA Issues First Ever Numeric Nutrient Water Quality Criteria and Standards for Florida Lakes and Rivers "
"J. Wylie Donald" - "Looking Forward and Looking Back - Some Climate Change Response Perspectives and Predictions"
"J. Wylie Donald" - "Looking Back to 2010 and Forward to 2011 and Beyond - Perspectives and Predictions on Climate Change"
"J. Michael McBride" - "Recent Case: Bank’s Have to Prove Legal Right to Foreclose, Before They Foreclose"
"Thomas O. Gorman" - "Portfolio Managers Sanctioned for Charging Unauthorized Fees"
"Doug Cornelius" - "Compliance and Foreclosures in Massachusetts"
"Doug Cornelius" - "Compliance and Foreclosures in Massachusetts"
"Gary Larkin" - "Some More Top Issues Lists for 2011"
"Francis G.X. Pileggi" - "Federal Court Refuses to Enforce Forum Selection Clause in Bylaws "
"Scott A. McKeown" - "Patent Reexamination Pilot Program Update"
"Vetstein Law Group, P.C. " - "Apocalypse Now? Will The Massachusetts Ibanez Case Unravel Widespread Irregularities In The Residential Securitized Mortgage Market?"
"Deirdre R. Wheatley-Liss" - "New Lease on Life: Organ Donation"
"Thomas O. Gorman" - "2 SEC Insider Trading Cases Filed"
"Randy J. Maniloff" - "Holy Mau: Florida Federal Court Rejects Continuous Trigger for Chinese Drywall Claims"
"Randy J. Maniloff" - "Endurance Coverage: “Top Ten Insurance Cases Of The Year” Reaches The Decade Mark"
"Vetstein Law Group, P.C. " - "Breaking News: Ibanez Foreclosure Ruling Upheld: An Indictment Of The Securitized Mortgage System"
"Brinks Hofer Gilson & Lione" - "Federal Circuit Rejects the Use of the 25 Percent "Rule of Thumb" in Calculating Reasonable Royalty for Patent Infringement"
"Martin A. Sullivan" - "Tax Triangulation"
"David Cay Johnston" - "Reasons, Rule and Riots: Our Societal Panic"
"Norman Clark" - "Getting serious about associate profitability"
"Thomas O. Gorman" - "Loss Causation and Class Certification"
"Martin A. Sullivan" - "Twelve Steps to Tax Reform"
"Kevin M. LaCroix" - "Subprime and Credit-Crisis Related Securities Cases: The Latest Status "
"Thomas Fox" - "Is Your FCPA Compliance Program a Good Business Model?"
"GreenbergTraurig" - "Income Standard in the Netherlands for Highly Skilled Migrants 2011"
"Martin A. Sullivan" - "Tax Reformers, Beware! Bipartisan Energy Policy"
"Keller and Heckman LLP" - "Employer Compliance Guidance for Whistleblower Provisions Under New Food Safety Modernization Act "
"LexisNexis Estate and Elder Law Center Staff" - "Registration Opens for the Medicare and Medicaid Electronic Health Records (EHR) Incentive Programs"
"David Brunori" - "The Pension Mess Must be Fixed"
"David Cay Johnston" - "On the Dole, Corporate Style"
"Christopher Bergin" - "Attack of the Killer Bs, and Other Snappy Acronyms"
"Christopher Bergin" - "The Myth of Revenue Neutrality"
"Martin A. Sullivan" - "The Fate of Tax Reform Depends on the Tea Party"
"Keller and Heckman LLP" - "Employer Compliance Guidance for Whistleblower Provisions Under New Food Safety Modernization Act "
"Thomas H. Clarke, Jr." - "Saccharin is no longer a hazardous waste (really)"
"Thomas H. Clarke, Jr." - "Decline of Western Aspen trees swells population of rodents that carry the deadly sin nombre virus"
"Stephen Sather" - "Supreme Court Rules That Debtor Must Have Loan or Lease Payment for Means Test Deduction "
"Gary Larkin" - "Triennial, Annual Favorites for Say on Pay Frequency Vote"
"Thomas Fox" - "Jonathan Marks’ 13 Step FCPA Compliance Action Plan"

Chanjet - China Small & Medium Enterprises Management & Operation KPI Data

Category:
TypeProviders.AzureMarketPlace
Description: Chanjet provides SME operation and management KPI data based on its nationwide survey conducted among SMEs from multiple industries. For more information, please goto https://datamarket.azure.com/dataset/6bd3a6b3-2fe0-4609-ba11-959190000047
Code:
[<Generate>]

type SME = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/Chanjet/ChinaSmallAndMediumEnterprises/">

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

query {
for b in china.GeographyInfo do
where (b.EconomicZoneId.Value = 1)
select b
} |> Seq.iter (fun i -> printfn "%A - %A" i.ProvinceNameEnglish i.ProvinceNameChinese)

// sample output
// "Shanghai" - "上海"
// "Jiangsu" - "江苏"
// "Zhejiang" - "浙江"


Execution Result:
"Shanghai" - "上海"
"Jiangsu" - "江苏"
"Zhejiang" - "浙江"

MetricMash - U.S. Consumer Price Index (1913 to Current)

Category:
TypeProviders.AzureMarketPlace
Description: The MetricMash U.S. Consumer Price Index (CPI) dataset provides the changes in the prices paid by consumers for over 375 goods and services in major expenditure groups – such as food, housing, apparel, transportation, medical care and education cost. For more information, please goto https://datamarket.azure.com/dataset/26058d69-5cad-4a7c-9a14-a21a0c40de86
Code:
[<Generate>]

type CPI = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/MetricMash/USConsumerPriceIndex/">

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

query {
for b in us.AllUrbanChainedConsumerPriceIndex do
where (b.DateValue < new System.DateTime(2010, 1, 1) )
where (b.DateValue > new System.DateTime(2008, 12, 30) )
select b
} |> Seq.iter (fun i -> printfn "%A - %A" i.DateValue i.Index)

// sample output
// 1/1/2009 12:00:00 AM - 122.09500M
// 1/1/2009 12:00:00 AM - 149.17700M
// 1/1/2009 12:00:00 AM - 117.95400M
// 1/1/2009 12:00:00 AM - 86.86600M
// 1/1/2009 12:00:00 AM - 107.73100M
// 1/1/2009 12:00:00 AM - 80.52600M
// 1/1/2009 12:00:00 AM - 110.22400M
// ...


Execution Result:
1/1/2009 12:00:00 AM - 122.09500M
1/1/2009 12:00:00 AM - 149.17700M
1/1/2009 12:00:00 AM - 117.95400M
1/1/2009 12:00:00 AM - 86.86600M
1/1/2009 12:00:00 AM - 107.73100M
1/1/2009 12:00:00 AM - 80.52600M
1/1/2009 12:00:00 AM - 110.22400M
1/1/2009 12:00:00 AM - 173.11600M
1/1/2009 12:00:00 AM - 74.08000M
1/1/2009 12:00:00 AM - 128.66300M
1/1/2009 12:00:00 AM - 128.81700M
1/1/2009 12:00:00 AM - 125.97000M
1/1/2009 12:00:00 AM - 127.11200M
1/1/2009 12:00:00 AM - 128.99200M
1/1/2009 12:00:00 AM - 128.89100M
1/1/2009 12:00:00 AM - 130.93000M
1/1/2009 12:00:00 AM - 160.63900M
1/1/2009 12:00:00 AM - 96.11000M
1/1/2009 12:00:00 AM - 143.76000M
1/1/2009 12:00:00 AM - 126.88300M
1/1/2009 12:00:00 AM - 149.95200M
1/1/2009 12:00:00 AM - 121.81600M
1/1/2009 12:00:00 AM - 105.61200M
1/1/2009 12:00:00 AM - 133.85300M
1/1/2009 12:00:00 AM - 110.96100M
1/1/2009 12:00:00 AM - 110.65300M
1/1/2009 12:00:00 AM - 132.47200M
1/1/2009 12:00:00 AM - 115.23600M
2/1/2009 12:00:00 AM - 122.59800M
2/1/2009 12:00:00 AM - 152.24900M
2/1/2009 12:00:00 AM - 118.34800M
2/1/2009 12:00:00 AM - 89.60300M
2/1/2009 12:00:00 AM - 108.72100M
2/1/2009 12:00:00 AM - 80.49100M
2/1/2009 12:00:00 AM - 110.17900M
2/1/2009 12:00:00 AM - 173.01200M
2/1/2009 12:00:00 AM - 74.07200M
2/1/2009 12:00:00 AM - 128.37400M
2/1/2009 12:00:00 AM - 128.49200M
2/1/2009 12:00:00 AM - 125.18300M
2/1/2009 12:00:00 AM - 127.33300M
2/1/2009 12:00:00 AM - 129.32900M
2/1/2009 12:00:00 AM - 128.91600M
2/1/2009 12:00:00 AM - 131.21800M
2/1/2009 12:00:00 AM - 158.71700M
2/1/2009 12:00:00 AM - 96.42300M
2/1/2009 12:00:00 AM - 144.68300M
2/1/2009 12:00:00 AM - 127.86600M
2/1/2009 12:00:00 AM - 150.84900M
2/1/2009 12:00:00 AM - 123.28200M
2/1/2009 12:00:00 AM - 105.96000M
2/1/2009 12:00:00 AM - 134.01200M
2/1/2009 12:00:00 AM - 113.13500M
2/1/2009 12:00:00 AM - 113.10500M
2/1/2009 12:00:00 AM - 132.82600M
2/1/2009 12:00:00 AM - 113.78800M
3/1/2009 12:00:00 AM - 122.80300M
3/1/2009 12:00:00 AM - 150.79500M
3/1/2009 12:00:00 AM - 118.80700M
3/1/2009 12:00:00 AM - 92.16100M
3/1/2009 12:00:00 AM - 109.13100M
3/1/2009 12:00:00 AM - 80.40600M
3/1/2009 12:00:00 AM - 110.07500M
3/1/2009 12:00:00 AM - 173.10200M
3/1/2009 12:00:00 AM - 73.94600M
3/1/2009 12:00:00 AM - 128.00100M
3/1/2009 12:00:00 AM - 128.09400M
3/1/2009 12:00:00 AM - 124.40300M
3/1/2009 12:00:00 AM - 127.28800M
3/1/2009 12:00:00 AM - 132.61400M
3/1/2009 12:00:00 AM - 128.89600M
3/1/2009 12:00:00 AM - 131.57100M
3/1/2009 12:00:00 AM - 155.87300M
3/1/2009 12:00:00 AM - 96.75300M
3/1/2009 12:00:00 AM - 144.89900M
3/1/2009 12:00:00 AM - 127.96900M
3/1/2009 12:00:00 AM - 151.10800M
3/1/2009 12:00:00 AM - 123.91500M
3/1/2009 12:00:00 AM - 106.09300M
3/1/2009 12:00:00 AM - 134.06400M
3/1/2009 12:00:00 AM - 113.25900M
3/1/2009 12:00:00 AM - 113.25000M
3/1/2009 12:00:00 AM - 133.00600M
3/1/2009 12:00:00 AM - 113.65200M
4/1/2009 12:00:00 AM - 123.05300M
4/1/2009 12:00:00 AM - 152.38800M
4/1/2009 12:00:00 AM - 119.04000M
4/1/2009 12:00:00 AM - 92.63600M
4/1/2009 12:00:00 AM - 109.89600M
4/1/2009 12:00:00 AM - 80.44900M
4/1/2009 12:00:00 AM - 110.13700M
4/1/2009 12:00:00 AM - 173.17500M
4/1/2009 12:00:00 AM - 73.99300M
4/1/2009 12:00:00 AM - 127.68100M
4/1/2009 12:00:00 AM - 127.77100M
4/1/2009 12:00:00 AM - 123.67400M
4/1/2009 12:00:00 AM - 127.00200M
4/1/2009 12:00:00 AM - 135.61400M
4/1/2009 12:00:00 AM - 128.64300M
4/1/2009 12:00:00 AM - 131.72800M

EDR - Environmental Hazard Rank

Category:
TypeProviders.AzureMarketPlace
Description: The EDR Environmental Hazard Ranking System depicts the relative environmental health of any U.S. ZIP code based on an advanced analysis of its environmental issues. For more information, please goto https://datamarket.azure.com/dataset/d8161344-f755-4a86-83e6-db9a89f06efd
Code:
[<Generate>]

type EHR = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/EDR/EnvironmentalHazardRank">

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

query {
for h in e.EnvironmentalHazardRankingByUSPostalZipCode do
where (h.State = "WA")
sortByDescending (h.EnviromentalHazardIndex)
select h
} |> Seq.iter (fun i -> printfn "%A - %A" i.ZipCode i.EnviromentalHazardIndex)

// sample output
// "98001" - 55120853.90000M
// "98002" - 53938430.83000M
// "98003" - 31725567.94000M
// "98004" - 51774234.93000M
// "98005" - 38690824.03000M
// "98006" - 16916724.70000M
// "98007" - 16998583.21000M
// "98008" - 10245452.63000M
// ...



Execution Result:
 - 11721000146.66000M
"99352" - 280787612.47000M
"98421" - 263478646.41000M
"98108" - 233915721.22000M
"98032" - 197053184.29000M
"98134" - 189212233.25000M
"98901" - 135385347.52000M
"98201" - 121655015.63000M
"99362" - 114542434.74000M
"98632" - 104758249.30000M
"98055" - 100782289.68000M
"98902" - 98742662.93000M
"98225" - 98708231.89000M
"98221" - 98302749.09000M
"98501" - 96130703.62000M
"98584" - 95392219.88000M
"98402" - 94616216.34000M
"98532" - 89771215.45000M
"98926" - 89724222.82000M
"98223" - 77021434.69000M
"98204" - 76743679.56000M
"98661" - 75826283.43000M
"98837" - 72752923.33000M
"98520" - 72639562.87000M
"98106" - 72354617.27000M
"98312" - 72134498.85000M
"99301" - 71669878.21000M
"98290" - 71421617.41000M
"98531" - 70422350.18000M
"98362" - 68982141.99000M
"98409" - 67745642.15000M
"98109" - 65669655.02000M
"98944" - 63750668.68000M
"98371" - 62801007.51000M
"98119" - 62635274.91000M
"98226" - 62201784.04000M
"98273" - 60357630.60000M
"98110" - 59883436.40000M
"98072" - 59183777.60000M
"98188" - 58990777.60000M
"98168" - 58521899.60000M
"98801" - 56606321.41000M
"98660" - 55944312.39000M
"98499" - 55449750.59000M
"98001" - 55120853.90000M
"99207" - 55089879.86000M
"98366" - 54255616.87000M
"98002" - 53938430.83000M
"98903" - 53459263.74000M
"98272" - 53336669.97000M
"98107" - 53316785.65000M
"98550" - 52844434.41000M
"98671" - 52794212.80000M
"98230" - 52644830.12000M
"99216" - 52368007.02000M
"98103" - 51828863.74000M
"98004" - 51774234.93000M
"99336" - 51293658.77000M
"98148" - 50419253.69000M
"98642" - 49477447.60000M
"98033" - 48754147.25000M
"99166" - 48152779.01000M
"98036" - 47884707.35000M
"98052" - 47825158.89000M
"98424" - 47625836.47000M
"98248" - 46702138.95000M
"98368" - 45762046.24000M
"98277" - 44957009.70000M
"98031" - 43253856.28000M
"98666" - 42967590.25000M
"99212" - 42655121.16000M
"98038" - 41921831.82000M
"98121" - 41782754.70000M
"98118" - 41614406.01000M
"98233" - 41542490.42000M
"98027" - 41299184.74000M
"98270" - 41289540.04000M
"98122" - 40897227.64000M
"98662" - 40765623.56000M
"99344" - 39979632.27000M
"98422" - 39782621.52000M
"98105" - 39195387.10000M
"98005" - 38690824.03000M
"98502" - 38626778.71000M
"98022" - 37778961.71000M
"98115" - 37608330.11000M
"98144" - 37466319.20000M
"99114" - 37097474.56000M
"98294" - 36631385.75000M
"99206" - 36578118.66000M
"98284" - 36462867.89000M
"98126" - 36274330.56000M
"98155" - 35731370.03000M
"98433" - 35701032.28000M
"98278" - 35623812.66000M
"98936" - 35556461.15000M
"99202" - 35450981.70000M
"98314" - 35200308.38000M
"98133" - 34950682.92000M
"99021" - 34942778.62000M

MetricMash - U.S. Unemployment Data

Category:
TypeProviders.AzureMarketPlace
Description: The MetricMash U.S. Unemployment dataset provides users the very latest government published metrics going back to 1948. For more information, please goto https://datamarket.azure.com/dataset/662d2b6a-119d-447e-a2b9-84d7a7f83590
Code:
[<Generate>]

type Unemployment = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/MetricMash/USUnemploymentData/">

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

query {
for c in Unemply.UnemploymentRates do
where (c.Year = "2009")
select c
} |> Seq.iter (fun i -> printfn "%A - %A" (i.MonthMMM + ", " + i.Year) i.Value)

// sample output
// "Jan, 2009" - 8.200M
// "Jan, 2009" - 9.000M
// "Jan, 2009" - 14.100M
// "Jan, 2009" - 7.800M
// "Jan, 2009" - 8.500M
// "Jan, 2009" - 6.900M
// "Jan, 2009" - 7.100M
// ...


Execution Result:
"Jan, 2009" - 8.200M
"Jan, 2009" - 9.000M
"Jan, 2009" - 14.100M
"Jan, 2009" - 7.800M
"Jan, 2009" - 8.500M
"Jan, 2009" - 6.900M
"Jan, 2009" - 7.100M
"Jan, 2009" - 7.600M
"Jan, 2009" - 6.400M
"Jan, 2009" - 12.700M
"Jan, 2009" - 15.600M
"Jan, 2009" - 10.200M
"Jan, 2009" - 9.900M
"Jan, 2009" - 20.800M
"Jan, 2009" - 24.200M
"Jan, 2009" - 17.500M
"Jan, 2009" - 18.600M
"Jan, 2009" - 21.700M
"Jan, 2009" - 15.400M
"Jan, 2009" - 36.300M
"Jan, 2009" - 44.000M
"Jan, 2009" - 29.500M
"Jan, 2009" - 7.200M
"Jan, 2009" - 7.800M
"Jan, 2009" - 6.400M
"Jan, 2009" - 6.500M
"Jan, 2009" - 7.000M
"Jan, 2009" - 5.900M
"Jan, 2009" - 11.600M
"Jan, 2009" - 14.300M
"Jan, 2009" - 9.300M
"Jan, 2009" - 12.400M
"Jan, 2009" - 14.100M
"Jan, 2009" - 10.500M
"Jan, 2009" - 6.600M
"Jan, 2009" - 7.100M
"Jan, 2009" - 5.900M
"Jan, 2009" - 6.900M
"Jan, 2009" - 7.600M
"Jan, 2009" - 6.100M
"Jan, 2009" - 21.900M
"Jan, 2009" - 20.300M
"Jan, 2009" - 8.200M
"Jan, 2009" - 6.700M
"Jan, 2009" - 6.000M
"Jan, 2009" - 5.200M
"Jan, 2009" - 26.800M
"Jan, 2009" - 23.000M
"Jan, 2009" - 9.200M
"Jan, 2009" - 6.800M
"Jan, 2009" - 6.800M
"Jan, 2009" - 4.800M
"Jan, 2009" - 16.800M
"Jan, 2009" - 17.600M
"Jan, 2009" - 7.000M
"Jan, 2009" - 6.500M
"Jan, 2009" - 5.000M
"Jan, 2009" - 1.800M
"Jan, 2009" - 0.500M
"Jan, 2009" - 4.800M
"Jan, 2009" - 0.600M
"Jan, 2009" - 5.300M
"Jan, 2009" - 5.500M
"Jan, 2009" - 17.100M
"Jan, 2009" - 12.700M
"Jan, 2009" - 15.000M
"Jan, 2009" - 5.000M
"Jan, 2009" - 12.300M
"Jan, 2009" - 8.100M
"Jan, 2009" - 3.900M
"Jan, 2009" - 6.500M
"Jan, 2009" - 8.200M
"Jan, 2009" - 8.700M
"Jan, 2009" - 7.600M
"Jan, 2009" - 34.400M
"Jan, 2009" - 8.200M
"Jan, 2009" - 7.100M
"Jan, 2009" - 5.900M
"Jan, 2009" - 7.300M
"Jan, 2009" - 5.000M
"Jan, 2009" - 14.600M
"Jan, 2009" - 4.800M
"Jan, 2009" - 4.000M
"Feb, 2009" - 8.700M
"Feb, 2009" - 9.500M
"Feb, 2009" - 15.000M
"Feb, 2009" - 8.200M
"Feb, 2009" - 9.100M
"Feb, 2009" - 7.300M
"Feb, 2009" - 7.500M
"Feb, 2009" - 8.200M
"Feb, 2009" - 6.600M
"Feb, 2009" - 13.600M
"Feb, 2009" - 16.300M
"Feb, 2009" - 11.100M
"Feb, 2009" - 11.100M
"Feb, 2009" - 21.900M
"Feb, 2009" - 25.200M
"Feb, 2009" - 18.600M
"Feb, 2009" - 19.500M

Microsoft - Utility Rate Service

Category:
TypeProviders.AzureMarketPlace
Description: The Microsoft Utility Rate Service is a database of electric utilities and rates indexed by location within the United States, gathered from Partner Utilities and/or from publically available information. For more information, please goto https://datamarket.azure.com/dataset/b848b1ed-3f61-40a9-8e43-597e0d352394
Code:
[<Generate>]

type Util = Microsoft.FSharp.Data.TypeProviders.ODataService//api.datamarket.azure.com/Microsoft/UtilityRateService/">

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

query {
for c in rate.UtilityByPostalCodes do
where (c.PostalCode = "98052")
select c
} |> Seq.iter (fun i -> printfn "%A - %A" i.Name i.RateSource)

// sample output
// "Average Price by State (Residential)" - "AreaAverages"
// "Contoso" - "ThirdParty"



Execution Result:
"Average Price by State (Residential)" - "AreaAverages"
"Contoso" - "ThirdParty"

Last edited Sep 13, 2011 at 12:53 AM by ttliu2000, version 2

Comments

No comments yet.