Rite Aid Pharmacy – Consumer Claims & Discount Trends

Name: Rite Aid Pharmacy – Consumer Claims & Discount Trends
Creator: Rx Data, LLC
Published: 2025-05-22 18:17:35
License: 暂无描述

Snowflake2025-05-22 更新2025-05-23 收录

下载链接：

https://app.snowflake.com/marketplace/listing/GZTSZ45XA6W

下载链接

链接失效反馈

官方服务：

资源简介：

Drive Strategic Decisions with ***Rite Aid Pharmacy – Consumer Claims & Discount Trends.*** Tap into the power of over 6 million claim-level records from Rite Aid locations across the U.S. to unlock unparalleled insights into consumer behavior and medication access. This exclusive data product sheds light on real-world pharmacy transactions, capturing key metrics outside traditional insurance channels. Discover the Competitive Edge to: - Spot Market Trends: Identify shifting demand patterns across Rite Aid's vast network. - Optimize Pricing Strategies: Leverage granular NDC-linked pricing data to refine market positioning. - Target Regional Opportunities: Uncover geographic hot spots for enhanced outreach and expansion. Built for healthcare strategists, market researchers, and pharmaceutical leaders, this dataset empowers you to make data-driven decisions with confidence. Fully de-identified and HIPAA compliant. Unlock insights, drive your strategy and lead the market.

提供机构：

Rx Data, LLC

创建时间：

2025-05-14

原始信息汇总

Rite Aid Pharmacy – Consumer Claims & Discount Trends 数据集概述

数据集基本信息

提供商: Rx Data, LLC
访问权限: 免费
访问模式: Unlimited Access
数据更新频率: 每周
地理覆盖范围: 美国所有州
云区域可用性: 支持AWS多个区域（包括亚太、北美等44个区域）

数据集描述

数据内容: 包含超过600万条来自Rite Aid药房的索赔级别记录，涵盖消费者行为和药物定价趋势。
数据特点: 去标识化、符合HIPAA标准，捕捉传统保险渠道之外的关键指标。
适用场景: 医疗保健战略制定、市场研究、制药行业分析。

商业需求

市场分析: 支持战略市场研究、医疗保健分析和制药规划，分析Rite Aid客户群的需求和成本趋势。
位置规划: 识别跨数千个地点的区域药物获取模式。

数据字典（部分列表示例）

ID: Varchar
MEMBER_GENDER: Varchar
MEMBER_STATE: Varchar
MEMBER_AGE_GROUP: Varchar
MASTER_MEMBER_DATE_SUBMITTED: Date
MASTER_REPEAT_USAGE: Varchar
UNIQUE_MEMBER: Boolean
DATE_FILLED: Date
DATE_SUBMITTED: Date
WEEKDAY: Varchar
RXCLAIM_ACTUAL_STATUS: Varchar
PHARMACY_ID: Varchar
PHARMACY_NAME: Varchar
DRUG_NAME: Varchar
DRUG_NDC: Varchar
TOTAL_QUANTITY: Number
TOTAL_DAYS_SUPPLY: Number
TOTAL_DRUG_COST: Number
TOTAL_AWP_COST: Number

使用示例

sql SELECT MEMBER_AGE_GROUP, MEMBER_GENDER, SUM(TOTAL_RXS) AS TOTAL_RXS_SUM FROM PUBLIC.SAMPLE_RITE_AID_CLAIMS WHERE RXCLAIM_ACTUAL_STATUS = Paid AND REVERSED = FALSE AND MEMBER_GENDER IN (M, F) GROUP BY MEMBER_AGE_GROUP, MEMBER_GENDER ORDER BY TOTAL_RXS_SUM DESC;