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.2.3", "url": "https://github.com/NSAPH-Data-Platform/dorieh", "commit": "bf4644403297aaf478f6a42717508dde55da409a"}. Created at 2024-08-12 13:31:09.799867';

---

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