Materialized view medicare.qc_admissions

Overview for medicare.qc_admissions

Aggregate data for admissions, beneficiaries and enrollments

Transformed from medicare.qc_adm_union

SQL/DDL Statement

CREATE materialized view  medicare.qc_admissions AS
SELECT
    year,
	state,
	zip,
	reason,
	MAX(state_iso) AS state_iso,
	COUNT(*) AS NumRecords,
	(#(hll_add_agg(bene)))::BIGINT AS NumDistinctBeneficaries,
	hll_add_agg(bene) AS bene_hll
FROM medicare.qc_adm_union

GROUP BY year,state,zip,reason;

COMMENT ON materialized view medicare.qc_admissions IS 'CREATED BY Dorieh: {"version": "0.4.5", "url": "file:///Users/misha/harvard/github/dorieh", "commit": null}. Created at 2026-07-13 11:20:49.408565';

---

Columns:

Column Name	Column Type	Datatype
bene_hll	computed	string
numdistinctbeneficaries	computed	BIGINT
numrecords	computed	BIGINT
reason		string
state		string
state_iso	computed	CHAR(5)
year		string
zip		string