This project is read-only.
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:
type Unemployment = Microsoft.FSharp.Data.TypeProviders.ODataService< ServiceUri = @"https://api.datamarket.azure.com/MetricMash/USConsumerPriceIndex/">

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

Last edited Mar 1, 2012 at 8:06 PM by ttliu2000, version 5

Comments

No comments yet.