U.S. Consumer Price Index - 1913 to Current

Data

Published by: MetricMash
Categories: Business and Finance, Science & Statistics
Date added: 6/3/2011
Get support for this offering

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. The CPI can be used to measure inflation and adjust the real value of wages, salaries and pensions for regulating prices and for calculating the real rate of return on investments. MetricMash optimizes the historical and monthly publications from the U.S. Bureau of Labor Statistics (BLS) into a dimensional model to allow for effective integration into your analytical tool. The model consists of the following query-able fact categories – All Urban Consumers (CPI-U); Urban Wage Earners and Clerical Workers (CPI-CW); All Urban Consumers (Chained CPI); Average Price Data; and Department Store Inventory Price Index. Two lookup queries are also provided to allow slicing along related Series and Time attributes. This dataset is updated monthly.

Service root URL

https://api.datamarket.azure.com/MetricMash/USConsumerPriceIndex/v1/

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

AllUrbanConsumersPriceIndex

Input parameters:

Name Sample values Type Required
SeriesKey String
DateValue DateTime

Results:

Name Type
RowKey Int32
SeriesKey String
DateValue DateTime
Index Decimal
PriceChangeFromPriorMonthInPercent Decimal
PriceChange3MonthsAgoInPercent Decimal
PriceChange6MonthsAgoInPercent Decimal
PriceChange12MonthsAgoInPercent Decimal
PriceChange3YearsAgoInPercent Decimal
PriceChange5YearsAgoInPercent Decimal
PriceChange10YearsAgoInPercent Decimal

UrbanWageEarnersConsumerPriceIndex

Input parameters:

Name Sample values Type Required
SeriesKey String
DateValue DateTime

Results:

Name Type
RowKey Int32
SeriesKey String
DateValue DateTime
Index Decimal
PriceChangeFromPriorMonthInPercent Decimal
PriceChange3MonthsAgoInPercent Decimal
PriceChange6MonthsAgoInPercent Decimal
PriceChange12MonthsAgoInPercent Decimal
PriceChange3YearsAgoInPercent Decimal
PriceChange5YearsAgoInPercent Decimal
PriceChange10YearsAgoInPercent Decimal

AllUrbanChainedConsumerPriceIndex

Input parameters:

Name Sample values Type Required
SeriesKey String
DateValue DateTime

Results:

Name Type
RowKey Int32
SeriesKey String
DateValue DateTime
Index Decimal
PriceChangeFromPriorMonthInPercent Decimal
PriceChange3MonthsAgoInPercent Decimal
PriceChange6MonthsAgoInPercent Decimal
PriceChange12MonthsAgoInPercent Decimal
PriceChange3YearsAgoInPercent Decimal
PriceChange5YearsAgoInPercent Decimal
PriceChange10YearsAgoInPercent Decimal

AveragePriceData

Input parameters:

Name Sample values Type Required
SeriesKey String
DateValue DateTime

Results:

Name Type
RowKey Int32
SeriesKey String
DateValue DateTime
Price Decimal
PriceChangeFromPriorMonthInPercent Decimal
PriceChange3MonthsAgoInPercent Decimal
PriceChange6MonthsAgoInPercent Decimal
PriceChange12MonthsAgoInPercent Decimal
PriceChange3YearsAgoInPercent Decimal
PriceChange5YearsAgoInPercent Decimal
PriceChange10YearsAgoInPercent Decimal

DepartmentStoreInventoryPriceIndex

Input parameters:

Name Sample values Type Required
SeriesKey String
DateValue DateTime

Results:

Name Type
RowKey Int32
SeriesKey String
DateValue DateTime
Index Decimal
PriceChangeFromPriorMonthInPercent Decimal
PriceChange3MonthsAgoInPercent Decimal
PriceChange6MonthsAgoInPercent Decimal
PriceChange12MonthsAgoInPercent Decimal
PriceChange3YearsAgoInPercent Decimal
PriceChange5YearsAgoInPercent Decimal
PriceChange10YearsAgoInPercent Decimal

TimeReference

Input parameters:

Name Sample values Type Required
DateValue DateTime
Year String
Quarter String
MonthMMM String
MonthMM String
MonthMM2 String
IsLast3MonthFlag Boolean
IsLast6MonthFlag Boolean
IsLast12MonthFlag Boolean
IsLast3YearFlag Boolean
IsLast5YearFlag Boolean
IsLast10YearFlag Boolean
IsLatestFlag Boolean
IsRecessionFlag Boolean

Results:

Name Type
DateValue DateTime
Year String
Quarter String
MonthMMM String
MonthMM String
MonthMM2 String
IsLast3MonthFlag Boolean
IsLast6MonthFlag Boolean
IsLast12MonthFlag Boolean
IsLast3YearFlag Boolean
IsLast5YearFlag Boolean
IsLast10YearFlag Boolean
IsLatestFlag Boolean
IsRecessionFlag Boolean

SeriesReference

Input parameters:

Name Sample values Type Required
KeyName String
SeriesKey String
BasePeriodKey Int32
BasePeriod String
AreaCode String
AreaName String
AreaSortSequence String
AreaDisplayLevel Int32
ParentAreaCode String
ParentAreaName String
ItemCode String
ItemName String
ItemSortSequence String
ItemDisplayLevel Int32
ParentItemCode String
ParentItemName String
Seasonality String

Results:

Name Type
KeyName String
SeriesKey String
BasePeriodKey Int32
BasePeriod String
AreaCode String
AreaName String
AreaNameDisplay String
AreaNameDisplayLine String
AreaSortSequence String
AreaDisplayLevel Int32
ParentAreaCode String
ParentAreaName String
ItemCode String
ItemName String
ItemNameDisplay String
ItemNameDisplayLine String
ItemSortSequence String
ItemDisplayLevel Int32
ParentItemCode String
ParentItemName String
Seasonality String

METRICMASH LLC - MICROSOFT AZURE END-USER LICENSE AGREEMENT

MetricMash LLC's End-User License Agreement (hereinafter known as "EULA") is a legal agreement between You (either an individual or a single entity, and if a corporation, "You" shall include your employees, agents and contractors) and MetricMash LLC for the MetricMash LLC content (hereinafter known as the "Licensed Content") which you have selected via Microsoft's Windows Azure Marketplace DataMarket service ("Windows Azure Marketplace DataMarket"). By downloading or otherwise using or accessing the Licensed Content, You agree to be bound by the terms of this EULA and to utilize the Licensed Content only in accordance with this EULA. This EULA represents the entire agreement concerning the Licensed Content between You and MetricMash LLC, and it supersedes any prior proposal, representation, or understanding between the parties.

PROVISION OF SERVICES

The Licensed Content is being licensed to You, not sold, for the duration of the subscription which has been selected within Windows Azure Marketplace DataMarket (the "Term"). Nothing in the EULA constitutes a waiver of MetricMash LLC rights under U.S. or international copyright law or any other federal or state law.

GRANT OF LICENSE.

The Licensed Content is licensed to You solely for Your own personal use. You further agree that You shall comply with all applicable laws in connection with Your use of the Licensed Content.

LIMITATIONS

(a) The Licensed Content as it exists in its orignal published structure, shape and form by MetricMash LLC may not be sublicensed, redistributed, syndicated or used for any commercial purposes, or otherwise made available to any third parties.

(b) You may not use the Licensed Content in conjunction with any material or service which is obscene, pornographic, defamatory, or otherwise illegal.

TERMINATION

The EULA and your right to use the Service will automatically terminate if you fail to comply with any material provision of this EULA. MetricMash LLC may terminate the EULA at any time by delivering notice to You.

NO WARRANTIES

MetricMash LLC expressly disclaims any warranties with respect to the Licensed Content. The Licensed Content is provided "AS IS," "WITH ALL FAULTS," and "AS AVAILABLE" without any express or implied warranty of any kind, including but not limited to any warranties of merchantability or fitness for a particular purpose. MetricMash LLC does not warrant or assume responsibility for the accuracy or completeness of the Licensed Content, the accessibility of the Licensed Content within Windows Azure Marketplace DataMarket, or the frequency/timeliness of the Licensed Content as accessed via Windows Azure Marketplace DataMarket. MetricMash LLC does not warrant or assume any responsibility for the functionality or availability of Windows Azure Marketplace DataMarket.

LIMITATION OF LIABILITY

(a) The use of the Licensed Content is at Your sole risk. In no event shall MetricMash LLC be liable for any direct, indirect, special, incidental or consequential damages (including, without limitation, lost profits, business interruption, or lost information), or other damages based in contract, tort or otherwise, arising out of the use of, or inability to use, the Licensed Content, or any element thereof, even if MetricMash LLC has been made aware of the possibility of such damages. MetricMash LLC shall have no liability whatsoever with respect to Your use of Windows Azure Marketplace DataMarket or with respect to functionality, availability, or any other aspect of Windows Azure Marketplace DataMarket.

(b) In no event shall MetricMash LLC be liable for any failure or unavailability of the Licensed Content due to any act of God, fire, natural disaster, accident, act of government, shortage of materials or supplies, strikes or other organized labor action, significant failure of the Internet, terrorist activity, act of third parties, or any other case beyond the reasonable control of MetricMash.

INDEMNIFICATION BY YOU

If You use or distribute the Licensed Content in violation of this EULA, You agree to indemnify, hold harmless and defend MetricMash LLC from and against any and all claims, liability, loss, damage, cost and expense (including reasonable attorneys' fees and litigation costs), arising out of or relating to such unauthorized use or distribution of the Licensed Content.

SEVERABILITY

If any part of this License is held invalid or unenforceable, the remaining provisions of this EULA shall be unimpaired and remain in full force and effect.

GOVERNING LAW AND JURISDICTION, JURY TRIAL WAIVER

You expressly understand and agree to submit to the personal and exclusive jurisdiction of the courts of the country, state, province or territory determined solely by MetricMash LLC to resolve any legal matter arising from this EULA or related to your use of MetricMash LLC. THE PARTIES HERETO WAIVE TRIAL BY JURY WITH RESPECT TO ANY MATTERS ARISING UNDER OR RELATING TO THIS EULA and agree that the prevailing party or parties in any such litigation shall be entitled to recover from the other party all costs and expenses, including without limitation reasonable attorneys' and paralegals' fees incurred by such party in connection with such litigation.

CHANGES

MetricMash LLC reserves the right to change any part of this EULA, with or without notice, from time to time. You agree to regularly review this EULA, and your continued use of the Licensed Content after the effective date of such changes will constitute acceptance of and agreement to any such changes.

MetricMash, LLC 16192 Coastal Hwy Lewes, DE 19958 www.MetricMash.com

100

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$49.95

per month

Try Free

Trial Details
This selection includes a 1 month free trial. After the trial period expires, your credit card will be charged on a monthly basis for the subscription price (plus applicable tax) until your subscription is cancelled or terminated. If you cancel within the trial period, your credit card will not be charged.

1,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$99.95

per month

Buy
10,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$149.95

per month

Buy
100,000

Transactions/month
A transaction is one request that returns one page of results. Retrieving multiple pages will result in multiple transactions executed.

$299.95

per month

Buy

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.