_dta: 1. planxw2018 data set up by Jean Roth , jroth@nber.org , 8 Dec 2017 2. NBER URL: http://www.nber.org/data/cms-health-insurance-marketplace-public-use-files.html 3. Source Page: http://download.cms.gov/marketplace-puf/2018/plan-id-crosswalk-puf.zip 4. Source File URL: https://www.cms.gov/CCIIO/Resources/Data-Resources/marketplace-puf.html state: 1. Two-character state abbreviation indicating the state where the plan is offered dentalplan: 1. Categorical indicator that plan is a stand- alone dental plan (SADP) planid_2017: 1. Fourteen-character alpha-numeric code that identifies the 2017 insurance plan in the 2. Health Insurance Oversight System (HIOS) 3. This field is only available for the 2017 and 2018 datasets. issuerid_2017: 1. Five-digit numeric code that identifies the issuer organization in HIOS for the 2017 2. plan 3. This field is only available for the 2017 and 2018 datasets. multistateplan_2017: 1. Categorical indicator of whether the 2017 plan is a multi-state plan 2. This field is only available for the 2017 and 2018 datasets. metallevel_2017: 1. Metal level, or coverage category, of the 2017 plan based on its actuarial value 2. Values of High and Low are only applicable for dental plans; values other than High 3. and Low are only applicable to medical plans. This field is only available for the 4. 2017 and 2018 datasets. childadultonly_2017: 1. The types of child enrollment options for the 2017 plan 2. A value of 0 means the 2017 plan allows adult-only and child-only enrollment; a 3. value of 1 means the 2017 plan allows only child- only enrollment; a value of 2 4. means the 2017 plan allows only adult-only enrollment. This field is only 5. available for the 2017 and 2018 datasets. fipscode: 1. Federal Information Processing Standards (FIPS) code assigned to the county within a state 2. that is included in the plan’s service area zipcode: 1. Five-digit zip code within the partial-county region included in the plan’s service area 2. A value of “00000” means the issuer did not split the county into zip codes when 3. submitting the Plan Crosswalk Template (i.e., the entire county is covered by the plan) crosswalklevel: 1. Categorical indicator of the crosswalk level 2. A value of 0 equals Crosswalking to the same Plan ID; a value of 1 equals Crosswalking 3. at the Plan ID level; a value of 2 equals Crosswalking at the Plan ID and county 4. coverage level; a value of 3 equals Crosswalking at the zip-code level for one or more 5. counties. For the 2015 dataset: a value of 4 equals Discontinue 2014 plan with no 6. cross walk (no re-enrollment option in 2015); a value of 5 equals 2014 Plan withdrawn 7. prior to certification For the 2016 dataset: a value of 4 equals Discontinue 2015 plan 8. with no cross walk (no re-enrollment option in 2016); a value of 5 equals 2015 Plan 9. withdrawn prior to certification For the 2017 dataset: a value of 4 equals Discontinue 10. 2016 plan with no cross walk (no re-enrollment option in 2017); a value of 5 equals 11. 2016 Plan withdrawn prior to certification For the 2018 dataset: a value of 4 equals 12. Discontinue 2017 plan with no cross walk (no re-enrollment option in 2018); a value of 13. 5 equals 2017 Plan withdrawn prior to certification reasonforcrosswalk: 1. Categorical indicator of the reason for the crosswalk 2. For the 2015 dataset: a value of 0 equals Renewing the same product/plan 3. combination using the same 2014 Plan ID; a value of 1 equals Renewing the same 4. product/plan combination using a different 2015 Plan ID; a value of 2 equals 5. Renewing product or renewal in a different plan within the product; a value of 3 6. equals Continuing product with no plan available in the particular service area 7. under that product and enrollment in a different product; a value of 4 equals 8. Continuing product with no plan available in the particular service area under 9. that product and no enrollment option; a value of 5 equals Discontinuing product 10. and no enrollment option; a value of 6 equals Discontinuing product and enrollment 11. into a different product; a value of 7 equals Continuing product; no silver plan 12. available in the particular service area under that product, enrollment in a 13. silver plan under a different product;.. For the 2016 dataset: a value of 0 equals 14. Renewing the same product/plan combination using the same 2015 Plan ID; a value of 15. 1 equals Renewing the same product/plan combination using a different 2016 Plan 16. ID; a value of 2 equals Renewing product or renewal in a different plan within the 17. product; a value of 3 equals Continuing product with no plan available in the 18. particular service area under that product and enrollment in a different product; 19. a value of 4 equals Continuing product with no plan available in the particular 20. service area under that product and no enrollment option; a value of 5 equals 21. Discontinuing product and no enrollment option; a value of 6 equals Discontinuing 22. product and enrollment into a different product; a value of 7 equals Continuing 23. product; no silver plan available in the particular service area under that 24. product, enrollment in a silver plan under a different product. For the 2017 25. dataset: a value of 0 equals Renewing the same product/plan combination using the 26. same 2016 Plan ID; a value of 1 equals Renewing the same product/plan combination 27. using a different 2017 Plan ID; a value of 2 equals Renewing product or renewal in 28. a different plan within the product; a value of 3 equals Continuing product with 29. no plan available in the particular service area under that product and enrollment 30. in a different product; a value of 4 equals Continuing product with no plan 31. available in the particular service area under that product and no enrollment 32. option; a value of 5 equals Discontinuing product and no enrollment option; a 33. value of 6 equals Discontinuing product and enrollment into a different product; a 34. value of 7 equals Continuing product; no silver plan available in the particular 35. service area under that product, enrollment in a silver plan under a different 36. product; a value of 8 equals Crosswalk to a different issuer; crosswalk determined 37. by CMS and not existing issuer. For the 2018 dataset: a value of 0 equals Renewing 38. the same product/plan combination using the same 2017 Plan ID; a value of 1 equals 39. Renewing the same product/plan combination using a different 2018 Plan ID; a value 40. of 2 equals Renewing product or renewal in a different plan within the product; a 41. value of 3 equals Continuing product with no plan available in the particular 42. service area under that product and enrollment in a different product; a value of 43. 4 equals Continuing product with no plan available in the particular service area 44. under that product and no enrollment option; a value of 5 equals Discontinuing 45. product and no enrollment option; a value of 6 equals Discontinuing product and 46. enrollment into a different product; a value of 7 equals Continuing product; no 47. silver plan available in the particular service area under that product, 48. enrollment in a silver plan under a different product; a value of 8 equals 49. Crosswalk to a different issuer; crosswalk determined by CMS and not existing 50. issuer; a value of 10 equals Discontinuing plan; plan discontinued in a bare 51. county. planid_2018: 1. Fourteen-character alpha-numeric code that identifies the 2018 insurance plan in the 2. Health Insurance Oversight System (HIOS) 3. This field is only available for the 2018 dataset. issuerid_2018: 1. Five-digit numeric code that identifies the issuer organization in HIOS for the 2018 2. plan 3. This field is only available for the 2018 dataset. multistateplan_2018: 1. Categorical indicator of whether the 2018 plan is a multi-state plan 2. This field is only available for the 2018 dataset. metallevel_2018: 1. Metal level, or coverage category, of the 2018 plan based on its actuarial value 2. Values of High and Low are only applicable for dental plans; values other than High 3. and Low are only applicable to medical plans. This field is only available for the 4. 2018 datasets. childadultonly_2018: 1. The types of child enrollment options for the 2018 plan 2. A value of 0 means the 2018 plan allows adult-only and child-only enrollment; a 3. value of 1 means the 2018 plan allows only child- only enrollment; a value of 2 4. means the 2018 plan allows only adult-only enrollment. This field is only 5. available for the 2018 dataset. ageoffplanid_2018: 1. Fourteen-character alpha-numeric code that identifies the plan available to 2. enrollees who will age-off (i.e., no longer meet the criteria for continued 3. eligibility) the 2017 plan prior to January 1, 2018 4. A value of “00000XX0000000” indicates that the issuer did not provide an 5. age-off plan ID. This field is only available for the 2018 dataset. issuerid_ageoff2018: 1. Five-digit numeric code that identifies the issuer organization in HIOS for the 2. 2018 plan identified in the AgeOffPlanID_2018 field 3. A value of “00000” indicates that the issuer did not provide an age-off plan 4. ID. This field is only available for the 2018 dataset. multistateplan_ageoff2018: 1. Categorical indicator of whether the 2018 age off plan is a multi-state 2. plan 3. A value of X indicates that the issuer did not provide an age-off plan ID. 4. This field is only available for the 2018 dataset. metallevel_ageoff2018: 1. Metal level of the 2018 age off plan based on its actuarial value 2. A value of X indicates that the issuer did not provide an age-off plan ID; 3. values of High and Low are only applicable for dental plans; values other than 4. High and Low are only applicable to medical plans. This field is only available 5. for the 2018 dataset. childadultonly_ageoff2018: 1. The types of child enrollment options for the 2018 age off plan 2. A value of 0 means the 2018 age off plan allows adult-only and child-only 3. enrollment; a value of 1 means the 2018 age off plan allows only child-only 4. enrollment; a value of 2 means the 2018 age off plan allows only adult-only 5. enrollment; a value of X indicates that the issuer did not provide an 6. age-off plan ID. This field is only available for the 2018 dataset. obs: 105,853 vars: 21 8 Dec 2017 13:57 size: 33,872,960 (_dta has notes) ---------------------------------------------------------------------------------------------------------------------------------------------------------- storage display value variable name type format label variable label ---------------------------------------------------------------------------------------------------------------------------------------------------------- state str2 %9s * State dentalplan str1 %9s * Dental Plan planid_2017 str14 %14s * 2017 Plan ID issuerid_2017 long %12.0g * 2017 Issuer ID multistateplan_2017 str1 %9s * 2017 Multistate Plan metallevel_2017 str12 %12s * 2017 Metal Level childadultonly_2017 byte %8.0g * 2017 Child Adult Only fipscode long %12.0g * FIPS Code zipcode str221 %221s * Zip Codes crosswalklevel byte %8.0g * Crosswalk Level reasonforcrosswalk byte %8.0g * Crosswalk Level planid_2018 str14 %14s * 2018 Plan ID issuerid_2018 long %12.0g * 2018 Issuer ID multistateplan_2018 str1 %9s * 2018 Multistate Plan metallevel_2018 str12 %12s * 2018 Metal Level childadultonly_2018 str1 %9s * 2018 Child Adult Only ageoffplanid_2018 str14 %14s * 2018 Age Off Plan ID issuerid_ageoff2018 long %12.0g * Issuer ID for 2018 Age Off Plan multistateplan_ageoff2018 str1 %9s * 2018 Age Off Multistate Plan metallevel_ageoff2018 str6 %9s * 2018 Age Off Metal Level childadultonly_ageoff2018 str1 %9s * 2018 Age Off Child Adult Only * indicated variables have notes ---------------------------------------------------------------------------------------------------------------------------------------------------------- Sorted by: