_dta: 1. rate2016 set up by Jean Roth , jroth@nber.org , 6 Oct 2016 2. Source Page: http://download.cms.gov/marketplace-puf/2016/rate-puf.zip 3. Source File URL: https://www.cms.gov/CCIIO/Resources/Data-Resources/marketplace-puf.html businessyear: 1. Year for which plan provides coverage to enrollees statecode: 1. Two-character state abbreviation indicating the state where the plan is offered issuerid: 1. Five-digit numeric code that identifies the issuer organization in the Health Insurance 2. Oversight System (HIOS) sourcename: 1. Categorical identifier of source of data import versionnum: 1. Integer value for version of data import importdate: 1. Date of data import issuerid2: 1. Five-digit numeric code that identifies the issuer organization in HIOS 2. Issuer ID is repeated because of tool data import requirements federaltin: 1. Tax ID Number of issuer rateeffectivedate: 1. Date that the foundation insurance plan base rate started being used to determine 2. the federally facilitated exchange rate for a specific insurance plan rateexpirationdate: 1. Date that the foundation insurance plan base rate stopped being used to determine 2. the federally facilitated exchange rate for a specific insurance plan planid: 1. Fourteen-character alpha-numeric code that identifies an insurance plan within HIOS ratingareaid: 1. Identifier for the geographic rating area within a state 2. Each rating area identifier maps to a geographic region within the state (e.g., one or 3. more counties, three-digit zip codes, or metropolitan statistical areas) tobacco: 1. Categorical indicator of whether a subscriber's tobacco use is used to determine rate 2. eligibility for the insurance plan age: 1. Categorical indicator of whether a subscriber's age is used to determine rate eligibility for the 2. insurance plan individualrate: 1. Dollar value for the insurance premium cost applicable to a non-tobacco user for the 2. insurance plan in a rating area, or to a general subscriber if there is no tobacco 3. preference individualtobaccorate: 1. Dollar value for the insurance premium cost applicable to a tobacco user for 2. the insurance plan in a rating area 3. This field is only applicable if Tobacco field equals Tobacco User/Non-Tobacco 4. User couple: 1. Dollar value for the insurance premium cost applicable to the primary enrollee plus a 2. secondary subscriber for the insurance plan in a rating area 3. This field is only applicable if Age field equals Family Option primarysubscriberandonedependent: 1. Dollar value for the insurance premium cost applicable to the 2. primary enrollee plus one dependent for the insurance plan in a 3. rating area 4. This field is only applicable if Age field equals Family Option primarysubscriberandtwodependent: 1. Dollar value for the insurance premium cost applicable to the 2. primary enrollee plus two dependents for the insurance plan in a 3. rating area 4. This field is only applicable if Age field equals Family Option primarysubscriberandthreeormored: 1. Dollar value for the insurance premium cost applicable to the 2. primary enrollee plus three or more dependents for the insurance 3. plan in a rating area 4. This field is only applicable if Age field equals Family Option coupleandonedependent: 1. Dollar value for the insurance premium cost applicable to the primary enrollee 2. plus a secondary subscriber and one dependent for the insurance plan in a 3. rating area 4. This field is only applicable if Age field equals Family Option coupleandtwodependents: 1. Dollar value for the insurance premium cost applicable to the primary enrollee 2. plus a secondary subscriber and two dependents for the insurance plan in a 3. rating area 4. This field is only applicable if Age field equals Family Option coupleandthreeormoredependents: 1. Dollar value for the insurance premium cost applicable to the primary 2. enrollee plus a secondary subscriber and three or more dependents for 3. the insurance plan in a rating area 4. This field is only applicable if Age field equals Family Option rownumber: 1. Template row number associated with this data record 2. Unavailable for some templates 1. Overview of the Rate PUF Oversight (CCIIO) is releasing 3. the Marketplace PUF in order to improve transparency and increase access to the Marketplace 4. data. The Marketplace PUF includes data on Qualified Health Plans (QHPs) and Stand-alone 5. Dental Plans (SADPs) offered in states with Federally-facilitated Marketplaces (FFM), which 6. include states with State Partnership Marketplaces (SPM), Federally-facilitated Small 7. Business Health Options Programs (FF-SHOP) and State-based Marketplaces (SBM) that rely on 8. the federal information technology platform for QHP eligibility and enrollment 9. functionality. The Marketplace PUF also includes data on Multi State Plans (MSPs). The 10. Marketplace PUF does not include data from SBMs that do not rely on the federal platform 11. for QHP eligibility and enrollment functionality. The Rate PUF (Rate-PUF) is one of the 12. seven files that make up the Marketplace PUF. The Rate-PUF contains plan-level data on 13. individual rates based on an eligible subscriber's age, tobacco use, and geographic 14. location. These data either originate from the Rate Table template (i.e., template field), 15. an Excel based form used by issuers to describe their plans in the QHP/SADP application 16. process, or were generated by CCIIO for use in data processing (i.e., system-generated). 17. This data dictionary describes the variables contained in the Rate-PUF. Each record relates 18. to one issuer's rates based on plan, geographic rating area, and subscriber eligibility 19. requirements. The Rate- PUF is available for plan year 2014, plan year 2015, and plan year 20. 2016. 2. Variable Attributes 21. Integer value for template row number associated with this data record 22. Unavailable for some templates obs: 4,171,845 vars: 24 6 Oct 2016 19:58 size: 738,416,565 (_dta has notes) ----------------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ----------------------------------------------------------------------------------------------------------------- businessyear int %8.0g * Business Year statecode str2 %9s * State Code issuerid long %12.0g * Issuer ID sourcename str5 %9s * Source Name versionnum byte %8.0g * Version Number importdate str19 %19s * Import Date issuerid2 long %12.0g * Issuer ID (repeated) federaltin str10 %10s * Tax Identification Number rateeffectivedate str10 %10s * Rate Effective Date rateexpirationdate str10 %10s * Rate Expiration Date planid str14 %14s * Plan ID ratingareaid str14 %14s * Rating Area ID tobacco str29 %29s * Tobacco age str13 %13s * Age individualrate float %9.0g * Individual Rate individualtobaccorate float %9.0g * Individual Tobacco Rate couple float %9.0g * Couple primarysubscriberandonedependent float %9.0g * Primary Subscriber and One Dependent primarysubscriberandtwodependent float %9.0g * Primary Subscriber and Two Dependents primarysubscriberandthreeormored float %9.0g * Primary Subscriber and Three or More coupleandonedependent float %9.0g * Couple and One Dependent coupleandtwodependents float %9.0g * Couple and Two Dependents coupleandthreeormoredependents float %9.0g * Couple and Three or More Dependents rownumber long %8.0g * Row Number * indicated variables have notes ----------------------------------------------------------------------------------------------------------------- Sorted by: