About this Dataset

ACA Federal Upper Limits

Affordable Care Act Federal Upper Limits (FUL) based on the weighted average of the most recently reported monthly average manufacturer price (AMP) for pharmaceutically and therapeutically equivalent multiple source drug products that are available for purchase by retail community pharmacies on a nationwide basis.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-10T07:42:40.892839
Tags: amp, federal-upper-limits, ful

Tables

Table 1

@usgov.hhs_gov_aca_federal_upper_limits_dc839.table_1

22.11 MB
2,045,366 rows
14 columns

CREATE TABLE table_1 (
  "product_group" BIGINT,
  "ingredient" VARCHAR,
  "strength" VARCHAR,
  "dosage" VARCHAR,
  "route" VARCHAR,
  "mdr_unit_type" VARCHAR,
  "weighted_average_of_amps" DOUBLE,
  "aca_ful" DOUBLE,
  "package_size" DOUBLE,
  "ndc" VARCHAR,
  "a_rated" VARCHAR,
  "multiplier_greater_than_175_percent_of_weighted_avg_of_amps" VARCHAR,
  "year" BIGINT,
  "month" BIGINT
);